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
  released: Boolean!
  voided: Boolean!
  postPeriodId: String
  amountApplied: Decimal
  amountAppliedInCurrency: Decimal
  cashDiscountApplied: Decimal
  cashDiscountAppliedInCurrency: Decimal
  withholdingTaxApplied: Decimal
  withholdingTaxAppliedInCurrency: Decimal
  voidAdjNbr: Int
  supplierRef: String
  lastModifiedDateTime: DateTime!
  deletedDatabaseRecord: Boolean!
  supplierId: Int!
  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.released ● Boolean! non-null scalar​

released > Indicates whether the payment application has been released.

APPaymentLine.voided ● Boolean! non-null scalar​

voided > Indicates whether the payment application has been voided.

APPaymentLine.postPeriodId ● String scalar​

postPeriodId > The financial period the application is posted to (same value as applicationPeriod).

APPaymentLine.amountApplied ● Decimal scalar​

amountApplied > The amount applied to the invoice in the base currency.

APPaymentLine.amountAppliedInCurrency ● Decimal scalar​

amountAppliedInCurrency > The amount applied to the invoice in the document currency.

APPaymentLine.cashDiscountApplied ● Decimal scalar​

cashDiscountApplied > The cash discount applied to the invoice in the base currency.

APPaymentLine.cashDiscountAppliedInCurrency ● Decimal scalar​

cashDiscountAppliedInCurrency > The cash discount applied to the invoice in the document currency.

APPaymentLine.withholdingTaxApplied ● Decimal scalar​

withholdingTaxApplied > The withholding tax applied to the invoice in the base currency.

APPaymentLine.withholdingTaxAppliedInCurrency ● Decimal scalar​

withholdingTaxAppliedInCurrency > The withholding tax applied to the invoice in the document currency.

APPaymentLine.voidAdjNbr ● Int scalar​

voidAdjNbr > The adjustment number of the voiding application, when this application has been voided.

APPaymentLine.supplierRef ● String scalar​

supplierRef > The supplier reference number.

APPaymentLine.lastModifiedDateTime ● DateTime! non-null scalar​

lastModifiedDateTime > The last modified date and time of the supplier payment line.

APPaymentLine.deletedDatabaseRecord ● Boolean! non-null scalar​

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

APPaymentLine.supplierId ● Int! non-null scalar​

supplierId > The unique identifier of the supplier on the parent supplier payment.

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