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​

refNbr > (PK) The reference number of the invoice line.

APInvoiceLine.lineNbr ● Int! non-null scalar​

lineNbr > (PK) The line number of the invoice.

APInvoiceLine.tranType ● String! non-null scalar​

tranType > (PK) The transaction type of the invoice line.

APInvoiceLine.poNbr ● String scalar​

poNbr > The purchase order number associated with the invoice line.

APInvoiceLine.poLineNbr ● Int scalar​

poLineNbr > The line number of the purchase order associated with the invoice line.

APInvoiceLine.receiptNbr ● String scalar​

receiptNbr > The receipt number associated with the invoice line.

APInvoiceLine.receiptLineNbr ● Int scalar​

receiptLineNbr > The line number of the receipt associated with the invoice line.

APInvoiceLine.inventoryId ● Int scalar​

inventoryId > The inventory ID associated with the invoice line.

APInvoiceLine.tranDesc ● String scalar​

tranDesc > The transaction description of the invoice line.

APInvoiceLine.uom ● String scalar​

uom > The unit of measure for the invoice line.

APInvoiceLine.quantity ● Decimal scalar​

quantity > The quantity of items in the invoice line.

APInvoiceLine.unitCost ● Decimal scalar​

unitCost > The unit cost of the items in the invoice line.

APInvoiceLine.curyUnitCost ● Decimal scalar​

curyUnitCost > The unit cost in the currency of the invoice line.

APInvoiceLine.lineAmt ● Decimal scalar​

lineAmt > The total amount of the invoice line.

APInvoiceLine.curyLineAmt ● Decimal scalar​

curyLineAmt > The total amount in the currency of the invoice line.

APInvoiceLine.discPct ● Decimal scalar​

discPct > The discount percentage applied to the invoice line.

APInvoiceLine.discAmt ● Decimal scalar​

discAmt > The discount amount applied to the invoice line.

APInvoiceLine.curyDiscAmt ● Decimal scalar​

curyDiscAmt > The discount amount in the currency of the invoice line.

APInvoiceLine.discountUnitCostInCurrency ● Decimal scalar​

discountUnitCostInCurrency > The discounted unit cost in the currency of the invoice line.

APInvoiceLine.discountUnitCost ● Decimal scalar​

discountUnitCost > The discounted unit cost of the invoice line.

APInvoiceLine.accountId ● Int scalar​

accountId > The account ID associated with the invoice line.

APInvoiceLine.subaccountId ● Int scalar​

subaccountId > The subaccount ID associated with the invoice line.

APInvoiceLine.taxCategoryId ● String scalar​

taxCategoryId > The tax category ID associated with the invoice line.

APInvoiceLine.deferredCode ● String scalar​

deferredCode > The deferred code associated with the invoice line.

APInvoiceLine.projectId ● Int scalar​

projectId > The project ID associated with the invoice line.

APInvoiceLine.taskId ● Int scalar​

taskId > The task ID associated with the invoice line.

APInvoiceLine.branchId ● Int! non-null scalar​

branchId > The branch ID associated with the invoice line.

APInvoiceLine.note ● String scalar​

note > The note associated with the invoice line.

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 > (PK) The unique identifier of the company

APInvoiceLine.id ● String! non-null scalar​

id > The unique identifier of the document in DataMart

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