Skip to main content

APInvoice

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

type APInvoice {
  documentType: String!
  referenceNumber: String!
  docDate: DateTime!
  origInvoiceDate: DateTime
  status: String!
  appStatus: Int
  hold: Boolean!
  financialPeriod: String!
  description: String
  supplierId: Int!
  locationId: Int!
  currencyId: String!
  exchangeRate: Decimal
  dueDate: DateTime
  vatTotal: Decimal!
  vatTotalInCurrency: Decimal!
  vatTaxableTotal: Decimal!
  vatTaxableTotalInCurrency: Decimal!
  vatExemptTotal: Decimal!
  vatExemptTotalInCurrency: Decimal!
  withHoldingTax: Decimal!
  withHoldingTaxInCurrency: Decimal!
  cashDiscountInCurrency: Decimal!
  cashDiscount: Decimal!
  balance: Decimal!
  balanceInCurrency: Decimal!
  amount: Decimal!
  amountInCurrency: Decimal!
  detailTotal: Decimal!
  detailTotalInCurrency: Decimal!
  note: String
  closedFinancialPeriod: String
  accountId: Int!
  subaccountId: Int!
  paymentMessage: String
  paymentRefNo: String
  paymentMethodId: String
  termsId: String
  cashDiscountDate: DateTime
  batchNumber: String
  payDate: DateTime
  supplierReference: String
  branchId: Int!
  paySelected: Boolean
  voucherId: String
  createdDateTime: DateTime!
  lastModifiedDateTime: DateTime!
  deletedDatabaseRecord: Boolean!
  companyId: Int!
  id: String!
  createdInDataMartDateTime: DateTime!
  updatedInDataMartDateTime: DateTime!
}

Fields

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

documentType (PK)

`APInvoice.referenceNumber` ● `String!` non-null scalar

referenceNumber (PK)

`APInvoice.docDate` ● `DateTime!` non-null scalar

docDate

`APInvoice.origInvoiceDate` ● `DateTime` scalar

origInvoiceDate

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

status

`APInvoice.appStatus` ● `Int` scalar

appStatus

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

hold

`APInvoice.financialPeriod` ● `String!` non-null scalar

financialPeriod

`APInvoice.description` ● `String` scalar

description

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

supplierId

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

locationId

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

currencyId

`APInvoice.exchangeRate` ● `Decimal` scalar

exchangeRate

`APInvoice.dueDate` ● `DateTime` scalar

dueDate

`APInvoice.vatTotal` ● `Decimal!` non-null scalar

vatTotal

`APInvoice.vatTotalInCurrency` ● `Decimal!` non-null scalar

vatTotalInCurrency

`APInvoice.vatTaxableTotal` ● `Decimal!` non-null scalar

vatTaxableTotal

`APInvoice.vatTaxableTotalInCurrency` ● `Decimal!` non-null scalar

vatTaxableTotalInCurrency

`APInvoice.vatExemptTotal` ● `Decimal!` non-null scalar

vatExemptTotal

`APInvoice.vatExemptTotalInCurrency` ● `Decimal!` non-null scalar

vatExemptTotalInCurrency

`APInvoice.withHoldingTax` ● `Decimal!` non-null scalar

withHoldingTax

`APInvoice.withHoldingTaxInCurrency` ● `Decimal!` non-null scalar

withHoldingTaxInCurrency

`APInvoice.cashDiscountInCurrency` ● `Decimal!` non-null scalar

cashDiscountInCurrency

`APInvoice.cashDiscount` ● `Decimal!` non-null scalar

cashDiscount

`APInvoice.balance` ● `Decimal!` non-null scalar

balance

`APInvoice.balanceInCurrency` ● `Decimal!` non-null scalar

balanceInCurrency

`APInvoice.amount` ● `Decimal!` non-null scalar

amount

`APInvoice.amountInCurrency` ● `Decimal!` non-null scalar

amountInCurrency

`APInvoice.detailTotal` ● `Decimal!` non-null scalar

detailTotal

`APInvoice.detailTotalInCurrency` ● `Decimal!` non-null scalar

detailTotalInCurrency

`APInvoice.note` ● `String` scalar

note

`APInvoice.closedFinancialPeriod` ● `String` scalar

closedFinancialPeriod

`APInvoice.accountId` ● `Int!` non-null scalar

accountId

`APInvoice.subaccountId` ● `Int!` non-null scalar

subaccountId

`APInvoice.paymentMessage` ● `String` scalar

paymentMessage

`APInvoice.paymentRefNo` ● `String` scalar

paymentRefNo

`APInvoice.paymentMethodId` ● `String` scalar

paymentMethodId

`APInvoice.termsId` ● `String` scalar

termsId

`APInvoice.cashDiscountDate` ● `DateTime` scalar

cashDiscountDate

`APInvoice.batchNumber` ● `String` scalar

batchNumber

`APInvoice.payDate` ● `DateTime` scalar

payDate

`APInvoice.supplierReference` ● `String` scalar

supplierReference

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

branchId

`APInvoice.paySelected` ● `Boolean` scalar

paySelected

`APInvoice.voucherId` ● `String` scalar

voucherId

`APInvoice.createdDateTime` ● `DateTime!` non-null scalar

createdDateTime

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

lastModifiedDateTime

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

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

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

companyId > The unique identifier of the company (PK)

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

id > The unique identifier of the document

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

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

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

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

Returned By

apInvoices query

Fields
Returned By