Skip to main content

APInvoiceLine

APInvoiceLines. Note: if an Invoice 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 APInvoiceLine {
  refNbr: String!
  lineNbr: Int!
  tranType: String!
  poNbr: String
  poLineNbr: Int
  receiptNbr: String
  receiptLineNbr: Int
  inventoryId: Int
  tranDesc: String
  uom: String
  quantity: Decimal
  unitCost: Decimal
  curyUnitCost: Decimal
  lineAmt: Decimal
  curyLineAmt: Decimal
  discPct: Decimal
  discAmt: Decimal
  curyDiscAmt: Decimal
  discountUnitCostInCurrency: Decimal
  discountUnitCost: Decimal
  accountId: Int
  subaccountId: Int
  taxCategoryId: String
  deferredCode: String
  projectId: Int
  taskId: Int
  branchId: Int!
  note: String
  deletedDatabaseRecord: Boolean!
  companyId: Int!
  id: String!
  createdInDataMartDateTime: DateTime!
  updatedInDataMartDateTime: DateTime!
}

Fields

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

`APInvoiceLine.lineNbr` ● `Int!` non-null scalar

`APInvoiceLine.tranType` ● `String!` non-null scalar

`APInvoiceLine.poNbr` ● `String` scalar

`APInvoiceLine.poLineNbr` ● `Int` scalar

`APInvoiceLine.receiptNbr` ● `String` scalar

`APInvoiceLine.receiptLineNbr` ● `Int` scalar

`APInvoiceLine.inventoryId` ● `Int` scalar

`APInvoiceLine.tranDesc` ● `String` scalar

`APInvoiceLine.uom` ● `String` scalar

`APInvoiceLine.quantity` ● `Decimal` scalar

`APInvoiceLine.unitCost` ● `Decimal` scalar

`APInvoiceLine.curyUnitCost` ● `Decimal` scalar

`APInvoiceLine.lineAmt` ● `Decimal` scalar

`APInvoiceLine.curyLineAmt` ● `Decimal` scalar

`APInvoiceLine.discPct` ● `Decimal` scalar

`APInvoiceLine.discAmt` ● `Decimal` scalar

`APInvoiceLine.curyDiscAmt` ● `Decimal` scalar

`APInvoiceLine.discountUnitCostInCurrency` ● `Decimal` scalar

`APInvoiceLine.discountUnitCost` ● `Decimal` scalar

`APInvoiceLine.accountId` ● `Int` scalar

`APInvoiceLine.subaccountId` ● `Int` scalar

`APInvoiceLine.taxCategoryId` ● `String` scalar

`APInvoiceLine.deferredCode` ● `String` scalar

`APInvoiceLine.projectId` ● `Int` scalar

`APInvoiceLine.taskId` ● `Int` scalar

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

`APInvoiceLine.note` ● `String` scalar

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

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

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

companyId > The unique identifier of the company (PK)

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

id > The unique identifier of the document

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

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

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

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

Returned By

apInvoiceLines query

Fields
Returned By