Skip to main content

SupplierDocumentLine

SupplierDocumentLines. Represents a line item in a supplier document. 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 SupplierDocumentLine {
  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​

SupplierDocumentLine.refNbr ● String! non-null scalar​

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

SupplierDocumentLine.lineNbr ● Int! non-null scalar​

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

SupplierDocumentLine.tranType ● String! non-null scalar​

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

SupplierDocumentLine.poNbr ● String scalar​

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

SupplierDocumentLine.poLineNbr ● Int scalar​

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

SupplierDocumentLine.receiptNbr ● String scalar​

receiptNbr > The receipt number associated with the invoice line.

SupplierDocumentLine.receiptLineNbr ● Int scalar​

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

SupplierDocumentLine.inventoryId ● Int scalar​

inventoryId > The inventory ID associated with the invoice line.

SupplierDocumentLine.tranDesc ● String scalar​

tranDesc > The transaction description of the invoice line.

SupplierDocumentLine.uom ● String scalar​

uom > The unit of measure for the invoice line.

SupplierDocumentLine.quantity ● Decimal scalar​

quantity > The quantity of items in the invoice line.

SupplierDocumentLine.unitCost ● Decimal scalar​

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

SupplierDocumentLine.curyUnitCost ● Decimal scalar​

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

SupplierDocumentLine.lineAmt ● Decimal scalar​

lineAmt > The total amount of the invoice line.

SupplierDocumentLine.curyLineAmt ● Decimal scalar​

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

SupplierDocumentLine.discPct ● Decimal scalar​

discPct > The discount percentage applied to the invoice line.

SupplierDocumentLine.discAmt ● Decimal scalar​

discAmt > The discount amount applied to the invoice line.

SupplierDocumentLine.curyDiscAmt ● Decimal scalar​

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

SupplierDocumentLine.discountUnitCostInCurrency ● Decimal scalar​

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

SupplierDocumentLine.discountUnitCost ● Decimal scalar​

discountUnitCost > The discounted unit cost of the invoice line.

SupplierDocumentLine.accountId ● Int scalar​

accountId > The account ID associated with the invoice line.

SupplierDocumentLine.subaccountId ● Int scalar​

subaccountId > The subaccount ID associated with the invoice line.

SupplierDocumentLine.taxCategoryId ● String scalar​

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

SupplierDocumentLine.deferredCode ● String scalar​

deferredCode > The deferred code associated with the invoice line.

SupplierDocumentLine.projectId ● Int scalar​

projectId > The project ID associated with the invoice line.

SupplierDocumentLine.taskId ● Int scalar​

taskId > The task ID associated with the invoice line.

SupplierDocumentLine.branchId ● Int! non-null scalar​

branchId > The branch ID associated with the invoice line.

SupplierDocumentLine.note ● String scalar​

note > The note associated with the invoice line.

SupplierDocumentLine.deletedDatabaseRecord ● Boolean! non-null scalar​

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

SupplierDocumentLine.companyId ● Int! non-null scalar​

companyId > (PK) The unique identifier of the company.

SupplierDocumentLine.id ● String! non-null scalar​

id > The unique identifier of the document in DataMart.

SupplierDocumentLine.createdInDataMartDateTime ● DateTime! non-null scalar​

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

SupplierDocumentLine.updatedInDataMartDateTime ● DateTime! non-null scalar​

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

Returned By​

supplierDocumentLines query