Skip to main content

SupplierPaymentLine

SupplierPaymentLines. 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