Skip to main content

APPaymentLine

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