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
  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​

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.released ● Boolean! non-null scalar​

released > Indicates whether the payment application has been released.

SupplierPaymentLine.voided ● Boolean! non-null scalar​

voided > Indicates whether the payment application has been voided.

SupplierPaymentLine.postPeriodId ● String scalar​

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

SupplierPaymentLine.amountApplied ● Decimal scalar​

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

SupplierPaymentLine.amountAppliedInCurrency ● Decimal scalar​

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

SupplierPaymentLine.cashDiscountApplied ● Decimal scalar​

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

SupplierPaymentLine.cashDiscountAppliedInCurrency ● Decimal scalar​

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

SupplierPaymentLine.withholdingTaxApplied ● Decimal scalar​

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

SupplierPaymentLine.withholdingTaxAppliedInCurrency ● Decimal scalar​

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

SupplierPaymentLine.voidAdjNbr ● Int scalar​

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

SupplierPaymentLine.supplierRef ● String scalar​

supplierRef > The supplier reference number.

SupplierPaymentLine.lastModifiedDateTime ● DateTime! non-null scalar​

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

SupplierPaymentLine.deletedDatabaseRecord ● Boolean! non-null scalar​

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

SupplierPaymentLine.supplierId ● Int! non-null scalar​

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

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