Skip to main content

APPaymentLine

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 APPaymentLine {
  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

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

branchId > The branch ID.

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

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

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

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

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

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

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

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

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

adjNbr > (PK) The adjustment number.

`APPaymentLine.rgolAmt` ● `Decimal` scalar

rgolAmt > The realized gain or loss amount.

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

currency > The currency ID.

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

cashDiscountBalance > The balance of the cash discount.

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

balance > The balance amount.

`APPaymentLine.amountPaid` ● `Decimal` scalar

amountPaid > The amount paid.

`APPaymentLine.batchNumber` ● `String` scalar

batchNumber > The batch number.

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

applicationPeriod > The application period.

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

date > The date of the record.

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

withholdingTax > The withholding tax amount.

`APPaymentLine.dueDate` ● `DateTime` scalar

dueDate > The due date.

`APPaymentLine.cashDiscountDate` ● `DateTime` scalar

cashDiscountDate > The cash discount date.

`APPaymentLine.cashDiscountTaken` ● `Decimal` scalar

cashDiscountTaken > The cash discount taken.

`APPaymentLine.supplierRef` ● `String` scalar

supplierRef > The supplier reference number.

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

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

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

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

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

id > The unique identifier of the document in DataMart.

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

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

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

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

Returned By

apPaymentLines query

Fields
Returned By