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