Skip to main content

CustomerPaymentLine

CustomerPaymentLines. Represents a line item showing how a customer payment is applied to a specific invoice.

type CustomerPaymentLine {
  paymentDocType: String!
  paymentRefNbr: String!
  adjustmentNbr: Int!
  invoiceDocType: String!
  invoiceRefNbr: String!
  amountPaid: Decimal
  cashDiscountTaken: Decimal
  balanceWriteOff: Decimal!
  date: DateTime!
  dueDate: DateTime
  cashDiscountDate: DateTime
  balance: Decimal
  cashDiscountBalance: Decimal
  description: String
  branchId: Int!
  applicationDate: DateTime!
  released: Boolean!
  voided: Boolean!
  amountApplied: Decimal
  amountAppliedInCurrency: Decimal
  postPeriodId: String!
  customerOrder: String
  lastModifiedDateTime: DateTime!
  deletedDatabaseRecord: Boolean!
  companyId: Int!
  id: String!
  createdInDataMartDateTime: DateTime!
  updatedInDataMartDateTime: DateTime!
}

Fields

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

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

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

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

`CustomerPaymentLine.adjustmentNbr` ● `Int!` non-null scalar

adjustmentNbr > (PK) The adjustment number.

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

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

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

invoiceRefNbr > (PK) The reference number of the adjusted document.

`CustomerPaymentLine.amountPaid` ● `Decimal` scalar

amountPaid > The amount paid on this line.

`CustomerPaymentLine.cashDiscountTaken` ● `Decimal` scalar

cashDiscountTaken > The cash discount taken on this line.

`CustomerPaymentLine.balanceWriteOff` ● `Decimal!` non-null scalar

balanceWriteOff > The balance write-off amount on this line.

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

date > The date of the adjusted document.

`CustomerPaymentLine.dueDate` ● `DateTime` scalar

dueDate > The due date from ARRegister.

`CustomerPaymentLine.cashDiscountDate` ● `DateTime` scalar

cashDiscountDate > The cash discount date from ARInvoice.

`CustomerPaymentLine.balance` ● `Decimal` scalar

balance > The calculated balance amount.

`CustomerPaymentLine.cashDiscountBalance` ● `Decimal` scalar

cashDiscountBalance > The calculated cash discount balance.

`CustomerPaymentLine.description` ● `String` scalar

description > The description from ARRegister.

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

branchId > The unique identifier of the branch associated with the adjusted document.

`CustomerPaymentLine.applicationDate` ● `DateTime!` non-null scalar

applicationDate > The date when the payment was applied to the invoice.

`CustomerPaymentLine.released` ● `Boolean!` non-null scalar

released > Indicates whether the payment application has been released.

`CustomerPaymentLine.voided` ● `Boolean!` non-null scalar

voided > Indicates whether the payment application has been voided.

`CustomerPaymentLine.amountApplied` ● `Decimal` scalar

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

`CustomerPaymentLine.amountAppliedInCurrency` ● `Decimal` scalar

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

`CustomerPaymentLine.postPeriodId` ● `String!` non-null scalar

postPeriodId > The adjusted financial period identifier.

`CustomerPaymentLine.customerOrder` ● `String` scalar

customerOrder > A reference to a document of the customer.

`CustomerPaymentLine.lastModifiedDateTime` ● `DateTime!` non-null scalar

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

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

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

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

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

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

id > The unique identifier of the document in DataMart.

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

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

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

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

Returned By

customerPaymentLines query

Fields
Returned By