Skip to main content

SupplierPaymentLine

SupplierPaymentLines. Represents a line item in a supplier payment. Note: if a Payment Line is deleted on ERP side this will not be reflected in DataMart for the time being. Support for deletion detection is in development.

type SupplierPaymentLine {
  branchId: Int!
  paymentRefNbr: String!
  paymentDocType: String!
  invoiceRefNbr: String!
  invoiceDocType: String!
  adjNbr: Int!
  rgolAmt: Decimal
  currency: String!
  cashDiscountBalance: Decimal!
  balance: Decimal!
  amountPaid: Decimal
  batchNumber: String
  applicationPeriod: String!
  date: DateTime!
  withholdingTax: Decimal!
  dueDate: DateTime
  cashDiscountDate: DateTime
  cashDiscountTaken: Decimal
  supplierRef: String
  deletedDatabaseRecord: Boolean!
  companyId: Int!
  id: String!
  createdInDataMartDateTime: DateTime!
  updatedInDataMartDateTime: DateTime!
}

Fields

`SupplierPaymentLine.branchId` ● `Int!` non-null scalar

branchId > The branch ID.

`SupplierPaymentLine.paymentRefNbr` ● `String!` non-null scalar

paymentRefNbr > (PK) The reference number of the payment.

`SupplierPaymentLine.paymentDocType` ● `String!` non-null scalar

paymentDocType > (PK) The type of the payment document.

`SupplierPaymentLine.invoiceRefNbr` ● `String!` non-null scalar

invoiceRefNbr > (PK) The reference number of the invoice.

`SupplierPaymentLine.invoiceDocType` ● `String!` non-null scalar

invoiceDocType > (PK) The type of the invoice document.

`SupplierPaymentLine.adjNbr` ● `Int!` non-null scalar

adjNbr > (PK) The adjustment number.

`SupplierPaymentLine.rgolAmt` ● `Decimal` scalar

rgolAmt > The realized gain or loss amount.

`SupplierPaymentLine.currency` ● `String!` non-null scalar

currency > The currency ID.

`SupplierPaymentLine.cashDiscountBalance` ● `Decimal!` non-null scalar

cashDiscountBalance > The balance of the cash discount.

`SupplierPaymentLine.balance` ● `Decimal!` non-null scalar

balance > The balance amount.

`SupplierPaymentLine.amountPaid` ● `Decimal` scalar

amountPaid > The amount paid.

`SupplierPaymentLine.batchNumber` ● `String` scalar

batchNumber > The batch number.

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

applicationPeriod > The application period.

`SupplierPaymentLine.date` ● `DateTime!` non-null scalar

date > The date of the record.

`SupplierPaymentLine.withholdingTax` ● `Decimal!` non-null scalar

withholdingTax > The withholding tax amount.

`SupplierPaymentLine.dueDate` ● `DateTime` scalar

dueDate > The due date.

`SupplierPaymentLine.cashDiscountDate` ● `DateTime` scalar

cashDiscountDate > The cash discount date.

`SupplierPaymentLine.cashDiscountTaken` ● `Decimal` scalar

cashDiscountTaken > The cash discount taken.

`SupplierPaymentLine.supplierRef` ● `String` scalar

supplierRef > The supplier reference number.

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

deletedDatabaseRecord > Indicates if the corresponding record in the database has been deleted.

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

companyId > (PK) The unique identifier of the company.

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

id > The unique identifier of the document in DataMart.

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

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

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

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

Returned By

supplierPaymentLines query

Fields
Returned By