Skip to main content

SupplierPayment

SupplierPayment. Note: if a Payment is deleted on ERP side this will not be reflected in DataMart for the time being. Support for deletion detection is in development.

type SupplierPayment {
  documentType: String!
  refNbr: String!
  status: String!
  hold: Boolean!
  applicationPeriod: String!
  applicationDate: DateTime!
  paymentRef: String
  paymentMethod: String
  released: Boolean!
  cashAccountId: Int
  lastModifiedDateTime: DateTime!
  currencyId: String!
  description: String
  supplierId: Int!
  locationId: Int!
  paymentAmount: Decimal!
  financeCharges: Decimal!
  unappliedBalance: Decimal!
  appliedAmount: Decimal!
  deletedDatabaseRecord: Boolean!
  companyId: Int!
  id: String!
  createdInDataMartDateTime: DateTime!
  updatedInDataMartDateTime: DateTime!
}

Fields

`SupplierPayment.documentType` ● `String!` non-null scalar

DocumentType > (PK) The type of the document

`SupplierPayment.refNbr` ● `String!` non-null scalar

ReferenceNumber > (PK) The reference number of the document

`SupplierPayment.status` ● `String!` non-null scalar

Status > The status of the document

`SupplierPayment.hold` ● `Boolean!` non-null scalar

Hold > Indicates if the document is on hold

`SupplierPayment.applicationPeriod` ● `String!` non-null scalar

ApplicationPeriod > The financial period of the application

`SupplierPayment.applicationDate` ● `DateTime!` non-null scalar

ApplicationDate > The date of the application

`SupplierPayment.paymentRef` ● `String` scalar

PaymentRef > The external reference number of the payment

`SupplierPayment.paymentMethod` ● `String` scalar

PaymentMethod > The method of payment

`SupplierPayment.released` ● `Boolean!` non-null scalar

Released > Indicates if the document is released

`SupplierPayment.cashAccountId` ● `Int` scalar

CashAccountID > The ID of the cash account

`SupplierPayment.lastModifiedDateTime` ● `DateTime!` non-null scalar

LastModifiedDateTime > The last modified date and time of the document

`SupplierPayment.currencyId` ● `String!` non-null scalar

CurrencyId > The ID of the currency

`SupplierPayment.description` ● `String` scalar

Description > The description of the document

`SupplierPayment.supplierId` ● `Int!` non-null scalar

SupplierId > The ID of the supplier

`SupplierPayment.locationId` ● `Int!` non-null scalar

LocationId > The ID of the location

`SupplierPayment.paymentAmount` ● `Decimal!` non-null scalar

PaymentAmount > The amount of the payment

`SupplierPayment.financeCharges` ● `Decimal!` non-null scalar

FinanceCharges > The finance charges of the payment

`SupplierPayment.unappliedBalance` ● `Decimal!` non-null scalar

UnappliedBalance > The unapplied balance of the payment

`SupplierPayment.appliedAmount` ● `Decimal!` non-null scalar

AppliedAmount > The applied amount of the payment

`SupplierPayment.deletedDatabaseRecord` ● `Boolean!` non-null scalar

deletedDatabaseRecord > Indicates whether this record has been marked as deleted in the database

`SupplierPayment.companyId` ● `Int!` non-null scalar

companyId > (PK) The unique identifier of the company

`SupplierPayment.id` ● `String!` non-null scalar

id > The unique identifier of the document in DataMart

`SupplierPayment.createdInDataMartDateTime` ● `DateTime!` non-null scalar

createdInDataMartDateTime > The UTC DateTime when this document has been added to DataMart

`SupplierPayment.updatedInDataMartDateTime` ● `DateTime!` non-null scalar

updatedInDataMartDateTime > The UTC DateTime when this document has been updated in DataMart

Returned By

supplierPayments query

Fields
Returned By