SalesOrderLine

SalesOrderLines. Represents a line item in a sales order.

type SalesOrderLine {
  orderType: String!
  orderNbr: String!
  orderDate: DateTime
  lineNbr: Int!
  sortOrder: Int
  branchId: Int!
  behavior: String!
  operation: String!
  inventoryId: Int
  itemClassId: Int
  itemStatus: String
  siteId: Int
  lotSerialNbr: String
  expireDate: DateTime @deprecated
  expirationDate: DateTime
  uom: String
  orderQty: Decimal! @deprecated
  quantity: Decimal!
  shippedQty: Decimal! @deprecated
  qtyOnShipments: Decimal!
  curyUnitPrice: Decimal! @deprecated
  unitPriceInBaseCurrency: Decimal!
  unitPrice: Decimal!
  unitCost: Decimal
  curyUnitCost: Decimal!
  taxCategoryId: String
  subaccountId: Int
  alternateId: String
  tranDesc: String @deprecated
  lineDescription: String
  manualDisc: Boolean @deprecated
  manualDiscount: Boolean
  discPct: Decimal! @deprecated
  discountPercent: Decimal!
  discAmt: Decimal! @deprecated
  discountAmount: Decimal!
  taskId: Int
  reasonCode: String
  salesPersonId: Int
  commissionable: Boolean!
  invtMult: Short!
  shipComplete: String
  completeQtyMin: Decimal! @deprecated
  undershipThreshold: Decimal!
  completeQtyMax: Decimal! @deprecated
  overshipThreshold: Decimal!
  openQty: Decimal!
  curyLineAmt: Decimal
  lineAmt: Decimal
  completed: Boolean
  curyUnbilledAmt: Decimal
  shipDate: DateTime @deprecated
  shipOn: DateTime
  requestDate: DateTime @deprecated
  requestOn: DateTime
  discountId: String @deprecated
  discountCode: String
  invoiceNbr: String
  isFree: Boolean @deprecated
  freeItem: Boolean
  poCreate: Boolean! @deprecated
  markForPO: Boolean!
  poSource: String
  isRUTROTDeductible: Boolean!
  noteId: UUID @deprecated
  note: String
  externalLink: String
  discUnitPrice: Decimal
  extPrice: Decimal
  unbilledAmount: Decimal!
  attachments: [Attachment!]
  baseUnitName: String
  quantityInBaseUnit: Decimal
  deletedDatabaseRecord: Boolean!
  lastModifiedDateTime: DateTime!
  companyId: Int!
  id: String!
  createdInDataMartDateTime: DateTime!
  updatedInDataMartDateTime: DateTime!
}

Fields

SalesOrderLine.orderType ● String! non-null scalar

orderType > (PK) The type of the document, which is one of the predefined order types or a custom order type.

SalesOrderLine.orderNbr ● String! non-null scalar

orderNbr > (PK) The reference number of the document.

SalesOrderLine.orderDate ● DateTime scalar

orderDate > The date of the document.

SalesOrderLine.lineNbr ● Int! non-null scalar

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

SalesOrderLine.sortOrder ● Int scalar

sortOrder > The sort order of the document line. The system regenerates this number automatically when lines are reordered.

SalesOrderLine.branchId ● Int! non-null scalar

branchId > The unique identifier of the branch.

SalesOrderLine.behavior ● String! non-null scalar

behavior > The automation behaviour used for the template. An automation behaviour is a set of automation steps. Values can be Sales order, Invoice, Quote, Credit note, or RMA order.

SalesOrderLine.operation ● String! non-null scalar

operation > The operation to be performed in the workspace to fulfil the order. This information is collected from the system and not visible on the sales order line.

SalesOrderLine.inventoryId ● Int scalar

inventoryId > The unique identifier of the Inventory item.

SalesOrderLine.itemClassId ● Int scalar

itemClassId > Id of the Item Class assigned to the Inventory item.

SalesOrderLine.itemStatus ● String scalar

itemStatus > Status of the Inventory item. [Active, No sales, No purchases, No request, Inactive, Marked for deletion].

SalesOrderLine.siteId ● Int scalar

siteId > The unique identifier of the Warehouse.

SalesOrderLine.lotSerialNbr ● String scalar

lotSerialNbr > The lot or serial number of the item for returns.

SalesOrderLine.expirationDate ● DateTime scalar

expirationDate > The expiration date for the item with the specified lot number.

SalesOrderLine.uom ● String scalar

uom > The unit of measure (UoM) used for the item with this item Id.

SalesOrderLine.quantity ● Decimal! non-null scalar

quantity > The quantity of the item sold, measured in the UoM.

SalesOrderLine.qtyOnShipments ● Decimal! non-null scalar

qtyOnShipments > A read-only column that displays the quantity of the stock item being prepared for shipment and already shipped for this order.

SalesOrderLine.unitPriceInBaseCurrency ● Decimal! non-null scalar

unitPriceInBaseCurrency > The unit price in base currency of the document.

SalesOrderLine.unitPrice ● Decimal! non-null scalar

unitPrice > The price of the unit on the sales order.

SalesOrderLine.unitCost ● Decimal scalar

unitCost > The cost of the unit on the sales order.

SalesOrderLine.curyUnitCost ● Decimal! non-null scalar

curyUnitCost > The cost of the unit in currency.

SalesOrderLine.taxCategoryId ● String scalar

taxCategoryId > The VAT category of the goods mentioned in the salesOrderLine.

SalesOrderLine.subaccountId ● Int scalar

subaccountId > The unique identifier of the subaccount.

SalesOrderLine.alternateId ● String scalar

alternateId > The alternate Id for the item, such as the item Id used by the customer.

SalesOrderLine.lineDescription ● String scalar

lineDescription > Line description > The description of the unit.

SalesOrderLine.manualDiscount ● Boolean scalar

manualDiscount > Indicates whether the discount has been applied manually.

SalesOrderLine.discountPercent ● Decimal! non-null scalar

discountPercent > The percent of the line-level discount that has been applied manually or automatically to this line item (if the item is not a free item).

SalesOrderLine.discountAmount ● Decimal! non-null scalar

discountAmount > The amount of the line-level discount that has been applied manually or automatically to this line item (if the item is not a free item).

SalesOrderLine.taskId ● Int scalar

taskId > The particular task of the project with which this document is associated.

SalesOrderLine.reasonCode ● String scalar

reasonCode > The reason code to be used for creation or cancellation of the order, if applicable.

SalesOrderLine.salesPersonId ● Int scalar

salesPersonId > The salesperson associated with the sale of the line item.

SalesOrderLine.commissionable ● Boolean! non-null scalar

commissionable > Indicates whether this line is subject to sales commission.

SalesOrderLine.invtMult ● Short! non-null scalar

invtMult > The multiplier for the quantity.

SalesOrderLine.shipComplete ● String scalar

shipComplete > Shipping rule > An option that controls whether incomplete and partial shipments for the order are allowed. [Values: Ship complete, Back order allowed, Cancel remainder].

SalesOrderLine.undershipThreshold ● Decimal! non-null scalar

undershipThreshold > Undership threshold (%) > The minimal percentage of goods shipped (with respect to the ordered quantity) to consider the order shipped completely.

SalesOrderLine.overshipThreshold ● Decimal! non-null scalar

overshipThreshold > Overship threshold (%) > The maximum percentage of goods shipped (with respect to the ordered quantity) allowed by the customer.

SalesOrderLine.openQty ● Decimal! non-null scalar

openQty > The quantity of the item to be shipped; that is, the total quantity minus the quantity shipped according to closed shipment documents.

SalesOrderLine.curyLineAmt ● Decimal scalar

curyLineAmt > Extended price in currency which is the unit price multiplied by the quantity.

SalesOrderLine.lineAmt ● Decimal scalar

lineAmt > Extended Price which is the unit price multiplied by the quantity.

SalesOrderLine.completed ● Boolean scalar

completed > Indicates whether this line is marked as completed.

SalesOrderLine.curyUnbilledAmt ● Decimal scalar

curyUnbilledAmt > Amount in currency not yet invoiced > The amount of cancelled shipments and cancelled remainders.

SalesOrderLine.shipOn ● DateTime scalar

shipOn > The date when the item is to be shipped.

SalesOrderLine.requestOn ● DateTime scalar

requestOn > The date when the customer wants to receive the goods. Defaults to the current business date.

SalesOrderLine.discountCode ● String scalar

discountCode > The code of the discount that has been applied to this line.

SalesOrderLine.invoiceNbr ● String scalar

invoiceNbr > The invoice number of the invoice generated for this order.

SalesOrderLine.freeItem ● Boolean scalar

freeItem > Indicates whether the stock item specified in the row is a free item.

SalesOrderLine.markForPO ● Boolean! non-null scalar

markForPO > Indicates whether the order line is marked for purchasing (if it has not been shipped completely).

SalesOrderLine.poSource ● String scalar

poSource > Purchase order source > The purchase order source to be used to fulfill this line, which can be one of the following options: Purchase to order, Drop-shipment.

SalesOrderLine.isRUTROTDeductible ● Boolean! non-null scalar

isRUTROTDeductible > Indicates whether the line or item is included in the RUTROT calculations.

SalesOrderLine.note ● String scalar

note > The user-defined note text connected to the order.

SalesOrderLine.externalLink ● String scalar

externalLink > A user-defined external reference. Only editable while the sales order status is Open; becomes read-only after association with a Shipment or Invoice.

SalesOrderLine.discUnitPrice ● Decimal scalar

discUnitPrice > The unit price, which has been recalculated after the application of discounts.

SalesOrderLine.extPrice ● Decimal scalar

extPrice > The extended price in currency.

SalesOrderLine.unbilledAmount ● Decimal! non-null scalar

unbilledAmount > Amount not yet invoiced > The amount of cancelled shipments and cancelled remainders.

SalesOrderLine.attachments ● [Attachment!] list object

attachments > The data containing information about the document attachments.

SalesOrderLine.baseUnitName ● String scalar

baseUnitName > The unit of measure (UoM) used for the item with this item Id.

SalesOrderLine.quantityInBaseUnit ● Decimal scalar

quantityInBaseUnit > The quantity of the item sold, measured in the UoM.

SalesOrderLine.deletedDatabaseRecord ● Boolean! non-null scalar

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

SalesOrderLine.lastModifiedDateTime ● DateTime! non-null scalar

lastModifiedDateTime > The last modified date and time of the document line.

SalesOrderLine.companyId ● Int! non-null scalar

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

SalesOrderLine.id ● String! non-null scalar

id > The unique identifier of the document in DataMart.

SalesOrderLine.createdInDataMartDateTime ● DateTime! non-null scalar

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

SalesOrderLine.updatedInDataMartDateTime ● DateTime! non-null scalar

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

Show deprecated

Returned By

salesOrderLinesV2 query