Skip to main content

APPayment

APPayments. Note: if a Payment is deleted on ERP side this will not be reflected in DataMart for the time being. Support for deletion detection is in development.

type APPayment {
  documentType: String!
  refNbr: String!
  status: String!
  hold: Boolean!
  applicationPeriod: String!
  applicationDate: DateTime!
  paymentRef: String
  paymentMethod: String
  released: Boolean!
  cashAccountId: Int
  lastModifiedDateTime: DateTime!
  currencyId: String!
  description: String
  supplierId: Int!
  locationId: Int!
  paymentAmount: Decimal!
  financeCharges: Decimal!
  unappliedBalance: Decimal!
  appliedAmount: Decimal!
  deletedDatabaseRecord: Boolean!
  companyId: Int!
  id: String!
  createdInDataMartDateTime: DateTime!
  updatedInDataMartDateTime: DateTime!
}

Fields

`APPayment.documentType` ● `String!` non-null scalar

DocumentType > (PK) The type of the document

`APPayment.refNbr` ● `String!` non-null scalar

ReferenceNumber > (PK) The reference number of the document

`APPayment.status` ● `String!` non-null scalar

Status > The status of the document

`APPayment.hold` ● `Boolean!` non-null scalar

Hold > Indicates if the document is on hold

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

ApplicationPeriod > The financial period of the application

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

ApplicationDate > The date of the application

`APPayment.paymentRef` ● `String` scalar

PaymentRef > The external reference number of the payment

`APPayment.paymentMethod` ● `String` scalar

PaymentMethod > The method of payment

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

Released > Indicates if the document is released

`APPayment.cashAccountId` ● `Int` scalar

CashAccountID > The ID of the cash account

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

LastModifiedDateTime > The last modified date and time of the document

`APPayment.currencyId` ● `String!` non-null scalar

CurrencyId > The ID of the currency

`APPayment.description` ● `String` scalar

Description > The description of the document

`APPayment.supplierId` ● `Int!` non-null scalar

SupplierId > The ID of the supplier

`APPayment.locationId` ● `Int!` non-null scalar

LocationId > The ID of the location

`APPayment.paymentAmount` ● `Decimal!` non-null scalar

PaymentAmount > The amount of the payment

`APPayment.financeCharges` ● `Decimal!` non-null scalar

FinanceCharges > The finance charges of the payment

`APPayment.unappliedBalance` ● `Decimal!` non-null scalar

UnappliedBalance > The unapplied balance of the payment

`APPayment.appliedAmount` ● `Decimal!` non-null scalar

AppliedAmount > The applied amount of the payment

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

deletedDatabaseRecord > Indicates whether this record has been marked as deleted in the database

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

companyId > (PK) The unique identifier of the company

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

id > The unique identifier of the document in DataMart

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

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

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

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

Returned By

apPayments query

Fields
Returned By