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