SOLine

PX.Objects.SO

View API Entity: SalesOrder/entity/Default/24.200.001/SalesOrder

189 of 189 fields

	Field Name	Type	Display Name	Foreign Key
	`LineNbr`	`int`	Line Nbr.	-
Description:The line number of the document.
	`OrderNbr` API	`nvarchar(15)`	Order Nbr.	SOOrder
Description:The reference number of the sales order in which this line item is listed. The field is included in the following foreign keys:
	`OrderType` API Default Navigation	`char(2)`	Order Type	SOOrderType
Description:The type of the sales order in which this line item is listed. The field is included in the following foreign keys:
	`AlternateID`	`nvarchar(50)`	Alternate ID	-
Description:The alternate ID for the item, such as the barcode or the inventory ID used by the customer.
	`AutoCreateIssueLine`	`bit`	Auto Create Issue	-
Description:A Boolean value that indicates whether the line of the Issue type will be created automatically for each order line of the Receipt type if the order is of the RR type.
	`AutomaticDiscountsDisabled`	`bit`	Automatic Discounts Disabled	-
Description:A Boolean value that indicates whether the system does not need to calculate discounts, because they are already calculated.
	`AvalaraCustomerUsageType`	`char(1)`	Tax Exemption Type	-
Description:The entity usage type of the customer location if sales to this location are tax-exempt. By default, the system inserts the entity usage type. This field is available only if the External Tax Calculation Integration feature is enabled on the Enable/Disable Features (CS100000) form. This field is not available for transfer orders.
	`AvgCost`Nonexistent in DB	`decimal`	Average Cost	-
Description:Average cost of the Inventory Item of the line.
	`BaseBilledQty`	`decimal(25, 6)`		-
Description:The quantity of stock and non-stock items that were billed, expressed in the base unit of measure.
	`BaseClosedQty`	`decimal`		-
Description:The closed quantity of the item, expressed in the base unit of measure.
	`BaseOpenQty`	`decimal(25, 6)`	Base Open Qty.	-
Description:The quantity of the item to be shipped, expressed in the base unit of measure.
	`BaseOrderQty`	`decimal(25, 6)`	Base Order Qty.	-
Description:The quantity of the item sold, expressed in the base unit of measure. This quantity is used for calculating discounts if the Base UOM field is .
	`BaseQtyOnOrders`	`decimal(25, 6)`		-
Description:The quantity of the item sold, expressed in the base unit of measure in a blanket sales order line, distributed among child orders that are generated for this line.
	`BaseShippedQty`	`decimal(25, 6)`		-
Description:The quantity of the stock item being prepared for shipment and already shipped for this order, expressed in the base unit of measure.
	`BaseUnbilledQty`	`decimal(25, 6)`		-
Description:The quantity of stock and non-stock items that were not yet billed, expressed in the base unit of measure.
	`Behavior`	`char(2)`		-
Description:The behavior which is defined by the OrderType of the sales order in which this line item is listed.
	`BilledAmt`	`decimal(19, 4)`		-
Description:The sum of amounts of the payments or prepayments that have been applied to the AR invoice generated for the line of the order.
	`BilledQty`	`decimal(25, 6)`	Billed Quantity	-
Description:The quantity of stock and non-stock items that were billed.
	`BlanketLineNbr`	`int`		BlanketSOLine
Description:The blanket line number of the blanket sales order from which the child order has been generated. The field is included in the following foreign keys:
	`BlanketNbr`Default Navigation	`nvarchar(15)`	Blanket SO Ref. Nbr.	SOBlanketOrderLink
Description:The reference number of the blanket sales order from which the child order has been generated. The field is included in the following foreign keys:
	`BlanketOpenQty`	`decimal`	Blanket Open Qty.	-
Description:The quantity of a stock or non-stock item in a blanket sales order line that has not been transferred to child orders. This value is calculated as the difference between the line quantity and the quantity on child orders. This field is available only for blanket sales orders.
	`BlanketSplitLineNbr`	`int`		BlanketSOLineSplit
Description:The blanket split line number of the blanket sales order from which the child order has been generated. The field is included in the FK.BlanketSplit foreign key. The field is a part of the identifier of the blanket sales order split line BlanketSOLineSplit.BlanketSOLineSplit.lineNbr.
	`BlanketType`	`char(2)`		-
Description:The order type of the blanket sales order from which the child order has been generated. The field is included in the following foreign keys:
	`BranchID`Default Navigation	`int`	Branch	Branch
Description:The identifier of the branch. The field is included in the FK.Branch foreign key. The value of this field corresponds to the value of the Branch.branchID field.
	`CalculateDiscountsOnImport`Nonexistent in DB	`bit`	Calculate automatic discounts on import	-
Description:A Boolean value that indicates whether the line discounts will be calculated automaticly.
	`CancelDate`	`datetime2`	Cancel By	-
Description:The expiration date of the order in which this line item is listed.
	`Cancelled`	`bit`		-
Description:A Boolean value that indicates whether the order was cancelled.
	`ChildLineCntr`	`int`		-
Description:The identifier of the detail line of the parent order.
	`ClosedQty`	`decimal`		-
Description:The closed quantity of the item, calculated as the subtraction of the quantity of the item to be shipped from the quantity of the item sold.
	`Commissionable`	`bit`	Commissionable	-
Description:A Boolean value that indicates whether the line is subjected to a sales commission. This field is available only if the Commissions feature is enabled on the Enable/Disable Features (CS100000) form. This field is not available for orders of the TR type.
	`CommnAmt`	`decimal(19, 4)`		-
Description:The default commission amount of the salesperson.
	`CommnPct`	`decimal(9, 6)`		-
Description:The default commission percentage of the salesperson.
	`Completed`	`bit`	Completed	-
Description:A Boolean value that indicates whether the line is completed.
	`CompleteQtyMax`	`decimal(9, 6)`	Overship Threshold (%)	-
Description:No description available
	`CompleteQtyMin`	`decimal(9, 6)`	Undership Threshold (%)	-
Description:No description available
	`CostCenterID`	`int`		INLotSerialStatusByCostCenter
Description:No description available
	`CostCodeID`Default Navigation	`int`	Cost Code	PMCostCode
Description:The cost code with which this document is associated to track project costs and revenue. The field is included in the FK.CostCode foreign key. The field is the identifier of the cost code PMCostCode.PMCostCode.costCodeID. This field is available only if the Cost Codes feature is enabled on the Enable/Disable Features (CS100000) form in addition to the integration of the Projects submodule with Sales Orders.
	`CreatedByID`Default Navigation	`uniqueidentifier`	Created By	Users
Description:No description available
	`CreatedByScreenID`	`char(8)`		-
Description:No description available
	`CreatedDateTime`	`datetime`		-
Description:No description available
	`CuryBilledAmt`	`decimal(19, 4)`		-
Description:The sum of amounts of the payments or prepayments that have been applied to the AR invoice generated for the line of the order (in the currency of the document).
	`CuryCommnAmt`	`decimal(19, 4)`		-
Description:The default commission amount of the salesperson (in the currency of the document).
	`CuryDiscAmt`	`decimal(19, 4)`	Discount Amount	-
Description:The amount of the line-level discount of the line (in the currency of the document).
	`CuryDiscPrice`	`decimal`	Disc. Unit Price	-
Description:The unit price, which has been recalculated after the application of discounts (in the currency of the document).
	`CuryExtCost`	`decimal(19, 6)`	Extended Cost	-
Description:No description available
	`CuryExtPrice`	`decimal(19, 6)`	Ext. Price	-
Description:The extended price of the item line (in the currency of the document).
	`CuryInfoID`	`bigint`		CurrencyInfo
Description:The identifier of the currency and exchange rate information. The field is included in the FK.CurrencyInfo foreign key. The value of this field corresponds to the value of the CurrencyInfo.curyInfoID field.
	`CuryLineAmt`	`decimal(19, 4)`	Amount	-
Description:The amount of the line, which the system calculates as the extended price minus the line-level discount (in the currency of the document).
	`CuryMarginAmt`	`decimal(19, 4)`	Est. Margin Amount	-
Description:The line's estimated margin amount (in the currency of the document). The value is not available for the transfer order. The value is empty for the line with zero extended cost and for the line marked for drop-ship or blanket for drop-ship.
	`CuryNetSales`	`decimal(19, 4)`		-
Description:The line amount without the tax and with the applied group and document discounts (in the currency of the document). The value has the negative sign for the receipt lines.
	`CuryOpenAmt`	`decimal(19, 4)`	Open Amount	-
Description:No description available
	`CuryTaxableAmt`	`decimal(19, 4)`		-
Description:The line amount that is subject to tax (in the currency of the document).
	`CuryUnbilledAmt`	`decimal(19, 4)`	Unbilled Amount	-
Description:The unbilled amount for a stock item with the Goods for Inventory line type or a non-stock item with the Non-Inventory Goods line type (in the currency of the document).
	`CuryUnitCost`	`decimal(19, 6)`	Unit Cost	-
Description:No description available
	`CuryUnitPrice`	`decimal(19, 6)`	Unit Price	-
Description:The unit price of the item (in the currency of the document).
	`CuryUnitPriceDR`	`decimal(19, 6)`	Unit Price for DR	-
Description:No description available
	`CustomerID` API	`int`		Customer
Description:The identifier of the customer of the original sales order. The field is included in the FK.Customer foreign key. The field is a part of the identifier of the reason code AR.Customer.Customer.bAccountID.
	`CustomerLocationID`Default Navigation	`int`	Ship-To Location	Location
Description:No description available
	`CustomerOrderNbr`	`nvarchar(40)`	Customer Order Nbr.	-
Description:The customer order number that the system inserts into the Customer Order Nbr. field for a generated child order. This field is available only for blanket sales orders.
	`DefaultOperation`Default Navigation	`char(1)`		SOOrderTypeOperation
Description:No description available
	`DefScheduleID`	`int`		DRSchedule
Description:The identifier of the deferred revenue or deferred expense schedule of the sales order. The field is included in the FK.DefaultShedule foreign key. The field is a part of the identifier of the deferred revenue or deferred expense schedule DRSchedule.DRSchedule.scheduleID.
	`DisableAutomaticTaxCalculation` API	`bit`	Disable Automatic Tax Calculation	-
Description:A Boolean value that indicates whether the system does not need to calculate taxes, because they are already calculated.
	`DiscAmt`	`decimal(19, 4)`		-
Description:The amount of the line-level discount of the line. If the Manual Discount field value is , it indicates that the amount of the discount is specified by the line discount that has been applied manually, or has been entered manually or calculated based on the discount percent of the line.
	`DiscountID`Default Navigation	`nvarchar(10)`	Discount Code	ARDiscount
Description:The code of the discount of the line. The field is included in the following foreign keys: This field is available only if the Customer Discounts feature is enabled on the Enable/Disable Features (CS100000) form.
	`DiscountsAppliedToLine`	`varbinary(MAX)`		-
Description:Array of line numbers of discounts applied to the line.
	`DiscountSequenceID`	`nvarchar(10)`	Discount Sequence	DiscountSequence
Description:The identifier of the discount sequence of the line. The field is included in the FK.DiscountSequence foreign key. The field is a part of the identifier of the Discount Sequence AR.DiscountSequence.DiscountSequence.discountSequenceID. This field is available only if the Customer Discounts feature is enabled on the Enable/Disable Features (CS100000) form.
	`DiscPct`	`decimal(9, 6)`	Discount Percent	-
Description:The percent of the line-level discount. If the Manual Discount field value is , it indicates that the percent of the discount is specified by the line discount that has been applied manually, or has been entered manually or calculated based on the discount amount of the line.
	`DiscPctDR`	`decimal(9, 6)`	Discount Percent for DR	-
Description:No description available
	`DiscPrice`	`decimal`		-
Description:The unit price that has been recalculated after the application of discounts.
	`DocumentDiscountRate`	`decimal(21, 18)`		-
Description:The rate of all discounts of the document type applied to the line.
	`DRTermEndDate`	`datetime2`	Term End Date	-
Description:The date when the process of deferred revenue recognition should finish for the selected item. This field is available only if the Deferred Revenue Management feature is enabled on the Enable/Disable Features (CS100000) form.
	`DRTermStartDate`	`datetime2`	Term Start Date	-
Description:The date when the process of deferred revenue recognition should start for the selected item. This field is available only if the Deferred Revenue Management feature is enabled on the Enable/Disable Features (CS100000) form.
	`ExpireDate`	`datetime2`	Expiration Date	-
Description:The expiration date for the item with the specified lot number. This field is available only for only orders of the RR type.
	`ExtCost`	`decimal(19, 6)`		-
Description:The extended cost, which the system calculates as the unit cost multiplied by the quantity.
	`ExtPrice`	`decimal(19, 6)`		-
Description:The extended price, which the system calculates as the unit price multiplied by the quantity.
	`ExtVolume`	`decimal(25, 6)`	Ext. Volume	-
Description:The extended volume, which the system calculates as the unit volume multiplied by the quantity.
	`ExtWeight`	`decimal(25, 6)`	Ext. Weight	-
Description:The extended weight, which the system calculates as the unit weight multiplied by the quantity.
	`FOBPoint`Default Navigation	`nvarchar(15)`	FOB	FOBPoint
Description:The point at which the ownership of the goods passes to the customer. This field is available only for blanket sales orders. This field cannot be empty.
	`FreezeManualDisc`Nonexistent in DB	`bit`		-
Description:A Boolean value that indicates whether the system will not recalculate the discount of the line type.
	`GroupDiscountRate`	`decimal(21, 18)`		-
Description:The rate of all discounts of the group type applied to the line.
	`IntercompanyPOLineNbr`	`int`		-
Description:The number of the Intercompany purchase order line to which the sales order line is linked. This field is available only if the Inter-Branch Transactions feature is enabled on the Enable/Disable Features (CS100000) form.
	`InventoryID`Default Navigation	`int`	Inventory ID	InventoryItem
Description:The inventory ID of the Inventory Item to be sold or returned. The field is included in the following foreign keys:
	`InventorySource`	`char(1)`	Inventory Source	-
Description:The source of material for a transaction line.
	`InvoiceDate`	`datetime2`	Original Sale Date	-
Description:Date of the Invoice line to which the return SO line is applied.
	`InvoiceLineNbr`	`int`	Invoice Line Nbr.	ARTran
Description:Number of the Invoice line to which the return SO line is applied. The field is included in the FK.InvoiceLine foreign key. The field is a part of the identifier of the Invoice Line ARTran.ARTran.lineNbr.
	`InvoiceNbr`	`nvarchar(15)`	Invoice Nbr.	SOInvoice
Description:Number of the Invoice to which the return SO line is applied. The field is included in the following foreign keys:
	`InvoiceType`	`char(3)`	Invoice Type	-
Description:Type of the Invoice to which the return SO line is applied. The field is included in the following foreign keys:
	`InvoiceUOM`	`nvarchar(6)`		-
Description:The unit of measure (UOM) of the original line of the invoice.
	`InvtMult`	`smallint`	Inventory Multiplier	-
Description:The Inventory Multiplier of the operation of the line.
	`IsBeingCopied`Nonexistent in DB	`bit`		-
Description:No description available
	`IsCostUpdatedOnPO`	`bit`	Update Cost On PO	-
Description:No description available
	`IsCut`Nonexistent in DBObsolete	`bit`		-
Description:No description available
	`IsFree`	`bit`	Free Item	-
Description:A Boolean value that indicates whether the inventory item specified in the row is a free item. If the field value is then the system updates the Unit Price, Discount Percent, Discount Amount, and Ext. Price amounts with 0 and set Manual Discount field to .
	`IsKit`Nonexistent in DB	`bit`	Is a Kit	-
Description:A Boolean value that indicates whether the item is a kit.
	`IsLegacyDropShip`	`bit`		-
Description:A Boolean value that indicates whether the line is a drop-ship which was created by the previous realization version.
	`IsOrchestratedLine`	`bit`	Orchestrated	-
Description:No description available
	`IsPOLinkAllowed`Nonexistent in DB	`bit`		-
Description:A Boolean value that indicates whether the Mark for PO field is and the Operation field is equal to the SOOperation.issue value of the line.
	`IsPromotionalPrice`	`bit`	Promotional Price	-
Description:No description available
	`IsSpecialOrder`	`bit`	Special Order	-
Description:No description available
	`IsStockItem`	`bit`	Is stock	-
Description:A Boolean value that indicates whether the Inventory Item of the line is a stock item.
	`ItemHasResidual`Nonexistent in DB	`bit`		-
Description:No description available
	`ItemRequiresTerms`Nonexistent in DB	`bit`		-
Description:When set to "true", indicates that the DRTermStartDate and DRTermEndDate fields are enabled for the line. The value of this field is set by the SOOrderEntry graph based on the settings of the item selected for the line. In other contexts it is not populated. See the attribute on the SOOrderEntry.SOLine_ItemRequiresTerms_CacheAttached handler for details.
	`LastModifiedByID`Default Navigation	`uniqueidentifier`	Last Modified By	Users
Description:No description available
	`LastModifiedByScreenID`	`char(8)`		-
Description:No description available
	`LastModifiedDateTime`	`datetime`		-
Description:No description available
	`LineAmt`	`decimal(19, 4)`		-
Description:The amount of the line, which the system calculates as the extended price minus the line-level discount.
	`LineQtyAvail`Nonexistent in DB	`decimal`		-
Description:The Quantity Available of the item of the line.
	`LineQtyHardAvail`Nonexistent in DB	`decimal`		-
Description:The Quantity Hard Available of the item of the line.
	`LineSign`	`smallint`		-
Description:No description available
	`LineType`	`char(2)`	Line Type	-
Description:No description available
	`LocationID` API Default Navigation	`int`	Location	INLocation
Description:The identifier of the location of the original sales order. The field is included in the following foreign keys:
	`LotSerialNbr`Default Navigation	`nvarchar(100)`	Lot/Serial Nbr.	INLotSerialStatus
Description:The lot or serial number of the item for returns. The field is included in the FK.LotSerialStatus foreign key. The field is a part of the identifier of the Location inventory item status by Lot Serial numbers SOLine.SOLine.locationID. This field is available only if the Lot and Serial Tracking feature is enabled on the Enable/Disable Features (CS100000) form.
	`ManualDisc`	`bit`	Manual Discount	-
Description:A Boolean value that indicates whether the discount has been applied manually.
	`ManualPrice`	`bit`	Manual Price	-
Description:A Boolean value that indicates whether the unit price in this line has been corrected or specified manually. If the field value is then the system updates the unit price in the document line with the current price (if one is specified). If the field value is then customer ID is changed in the sales order or return order, the system does not update unit prices in the line.
	`MarginAmt`	`decimal(19, 4)`		-
Description:The line's estimated margin amount. The value is not available for the transfer order. The value is empty for the line with zero extended cost and for the line marked for drop-ship or blanket for drop-ship.
	`MarginPct`	`decimal(19, 2)`	Est. Margin (%)	-
Description:The line's estimated margin percent. The value is not available for the transfer order. The value is empty for the line with zero extended cost and for the line marked for drop-ship or blanket for drop-ship.
	`NetSales`	`decimal(19, 4)`		-
Description:The line amount without the tax and with the applied group and document discounts. The value has the negative sign for the receipt lines.
	`NoteID` API	`uniqueidentifier`		-
Description:No description available
	`OpenAmt`	`decimal(19, 4)`		-
Description:The amount of the stock items not yet shipped according to the line.
	`OpenChildLineCntr`	`int`		-
Description:The identifier of the unshipped detail line of the parent order.
	`OpenLine`	`bit`	Open Line	-
Description:No description available
	`OpenQty`	`decimal(25, 6)`	Open Qty.	-
Description:No description available
	`Operation`Default Navigation	`char(1)`	Operation	SOOrderTypeOperation
Description:No description available
	`OrchestrationOriginalLineNbr`	`int`		-
Description:No description available
	`OrchestrationOriginalSiteID`	`int`		-
Description:No description available
	`OrchestrationPlanID`Default Navigation	`nvarchar(15)`	Orchestration Plan	SOOrchestrationPlan
Description:No description available
	`OrderDate`	`datetime2`		-
Description:The date of the sales order in which this line item is listed.
	`OrderQty`	`decimal(25, 6)`	Quantity	-
Description:No description available
	`OrigIsSpecialOrder`Nonexistent in DB	`bit`		-
Description:No description available
	`OrigLineNbr`	`int`		SOLine
Description:The part of the identifier of the original line. The value of this field corresponds to the value of the SOLine.lineNbr field. The field is included in the FK.OriginalOrderLine foreign key.
	`OrigOrderNbr`Default Navigation	`nvarchar(15)`	Orig. Order Nbr.	SOOrder
Description:The identifier of the reference number of the original sales order. The field is included in the following foreign keys:
	`OrigOrderType`	`char(2)`	Orig. Order Type	SOOrderType
Description:The identifier of the type of the original order. The field is included in the following foreign keys:
	`OrigPlanType`Default NavigationObsolete	`char(2)`		INPlanType
Description:No description available
	`OrigShipmentType`	`char(1)`		-
Description:The Shipment Type of the original line of the Accounts Receivable invoice or memo.
	`PlanType`Nonexistent in DB	`nchar(2)`		-
Description:The Order Plan Type of the operation of the line.
	`POCreate`	`bit`	Mark for PO	-
Description:A Boolean value that indicates whether the order line was marked for purchasing (if it has not been shipped completely) and the line will be available for adding to a purchase order.
	`POCreated`	`bit`		-
Description:A Boolean value that indicates whether the line was added to a purchase order.
	`POCreateDate`	`datetime2`	PO Creation Date	-
Description:The planned date for creation of a purchase order. By default, the system inserts the current business date to this field. This field is available only for blanket sales orders.
	`POLineNbr`Nonexistent in DB	`int`	Drop-Ship PO Line Nbr.	-
Description:The number of the drop-ship purchase order line to which the sales order line is linked.
	`POLinkActive`Nonexistent in DB	`bit`	PO Linked	-
Description:A Boolean value that indicates whether the line has an active link to a line of the drop-ship purchase order.
	`POOrderNbr`Default NavigationNonexistent in DB	`nvarchar(15)`	Drop-Ship PO Nbr.	POOrder
Description:The number of the drop-ship purchase order to which the sales order line is linked.
	`POOrderStatus`Nonexistent in DB	`nchar(2)`	Drop-Ship PO Status	-
Description:The status of the drop-ship purchase order to which the sales order line is linked. The field can have one of the values listed in PO.POOrderStatus.
	`POOrderType`Nonexistent in DB	`nchar(2)`		-
Description:The type of the drop-ship purchase order to which the sales order line is linked. The field can have one of the values listed in PO.POOrderType.
	`POSiteID`Default Navigation	`int`	Purchase Warehouse	INSite
Description:The identifier of the destination warehouse for the items to be purchased. The field is included in the FK.POSite foreign key. The value of this field corresponds to the value of the INSite.siteID field.
	`POSource`	`char(1)`	PO Source	-
Description:No description available
	`PriceType`	`char(1)`	Price Type	-
Description:The type of the item price of the line. The field can have one of the values listed in PriceTypes.
	`ProjectID`	`int`		PMProject
Description:The identifier of the project. The field is included in the following foreign keys:
	`QtyOnOrders`	`decimal(25, 6)`	Qty. On Orders	-
Description:The quantity of a stock or non-stock item in a blanket sales order line distributed among child orders that are generated for this line.
	`ReasonCode`Default Navigation	`nvarchar(20)`	Reason Code	ReasonCode
Description:No description available
	`RequestDate`	`datetime2`	Requested On	-
Description:The date when the customer wants to receive the goods. The default value is specified in the Requested On field of the order.
	`RequireAllocation`Nonexistent in DB	`bit`		-
Description:The Require Stock Allocation of the order type of the line.
	`RequireLocation`Nonexistent in DB	`bit`		-
Description:The Require Location of the order type of the line.
	`RequireReasonCode`Nonexistent in DB	`bit`		-
Description:The Require Reason Code of the operation of the line.
	`RequireShipping`Nonexistent in DB	`bit`		-
Description:The Process Shipments of the order type of the line.
	`SalesAcctID`Default Navigation	`int`	Account	Account
Description:The account associated with the sale of the line item. The field is included in the FK.SalesAccount foreign key. The field is the identifier of the Sales Account GL.Account.Account.accountID.
	`SalesPersonID`Default Navigation	`int`	Salesperson ID	SalesPerson
Description:The salesperson associated with the sale of the line item. The field is included in the FK.SalesPerson foreign key. The field is a part of the identifier of the salesperson AR.SalesPerson.SalesPerson.salesPersonID. This field is available only if the Commissions feature is enabled on the Enable/Disable Features (CS100000) form. This field is not available for orders of the TR type.
	`SalesSubID`Default Navigation	`int`	Subaccount	Sub
Description:The subaccount associated with the sale of the line item. The field is included in the FK.SalesSubaccount foreign key. The field is the identifier of the Sales subaccount GL.Sub.Sub.subID.
	`SchedOrderDate`	`datetime2`	Sched. Order Date	-
Description:The date on which a child order should be generated for the line of the blanket sales order. By default, the system inserts the current business date to this field. The value in this field can be empty. The value cannot be earlier than the date of the blanket sales order and later than the expiration date of the blanket sales order. This field is available only for blanket sales orders.
	`SchedShipDate`	`datetime2`	Sched. Shipment Date	-
Description:The planned date of the shipment for a child order generated from this line. The date in this field cannot be earlier than the date of the blanket sales order and the Sched. Order Date. The value in this field cannot be later than the expiration date of the blanket sales order. This field is available only for blanket sales orders.
	`ShipComplete`	`char(1)`	Shipping Rule	-
Description:The way the line item should be shipped. The field can have one of the values listed in SOShipComplete.
	`ShipDate`	`datetime2`	Ship On	-
Description:No description available
	`ShippedQty`	`decimal(25, 6)`	Qty. On Shipments	-
Description:The quantity of the stock item being prepared for shipment and already shipped for this order.
	`ShipTermsID`Default Navigation	`nvarchar(10)`	Shipping Terms	ShipTerms
Description:The shipping terms used for the customer. This field is available only for blanket sales orders. This field cannot be empty.
	`ShipVia` API Default Navigation	`nvarchar(15)`	Ship Via	Carrier
Description:The ship via code that represents the carrier and its service to be used for shipping the ordered goods. This field is available only for blanket sales orders. This field cannot be empty.
	`ShipZoneID`Default Navigation	`nvarchar(15)`	Shipping Zone	ShippingZone
Description:The identification of the shipping zone of the customer to be used to calculate the freight. This field is available only for blanket sales orders. This field cannot be empty.
	`SiteID`Default Navigation	`int`	Warehouse	INSite
Description:No description available
	`SkipDisc`Nonexistent in DB	`bit`		-
Description:No description available
	`SkipLineDiscounts`	`bit`	Ignore Automatic Line Discounts	-
Description:Indicates (if selected) that the automatic line discounts are not applied to this line.
	`SortOrder`	`int`	Line Order	-
Description:The order number of the document line. The system regenerates this number automatically when lines are reordered.
	`SubItemID`Default Navigation	`int`	Subitem	INSubItem
Description:No description available
	`SubstitutionRequired`	`bit`	Substitution Required	-
Description:A Boolean value that indicates whether the current item has to be replaced with the related item that is specified on the Non-Stock Items (IN202000) or Stock Items (IN202500) form. Shipment for the original item cannot be created if this field is .
	`TaskID`Default Navigation	`int`	Project Task	PMTask
Description:No description available
	`TaxableAmt`	`decimal(19, 4)`		-
Description:The line amount that is subject to tax.
	`TaxCategoryID`Default Navigation	`nvarchar(15)`	Tax Category	TaxCategory
Description:No description available
	`TaxZoneID`Default Navigation	`nvarchar(10)`	Tax Zone	TaxZone
Description:The tax zone associated with the customer location. If no tax zone is specified for this customer location, the system inserts into this field the tax zone assigned to the selling branch. This field is available only for blanket sales orders.
	`TranDesc`	`nvarchar(256)`	Line Description	-
Description:No description available
	`TranType`Nonexistent in DB	`nchar(3)`		-
Description:The Inventory Transaction Type of the operation of the line.
	`tstamp`	`timestamp`		-
Description:No description available
	`UnassignedQty`	`decimal(25, 6)`		-
Description:Contains the difference between the line quantity and the quantity on child split lines, for Inventory Items with lot or serial number.
	`UnbilledAmt`	`decimal(19, 4)`		-
Description:The unbilled amount for a stock item with the Goods for Inventory line type or a non-stock item with the Non-Inventory Goods line type. Calculated as the quantity in the sales order minus the quantity in the invoice or invoices generated for this order, multiplied by the discounted unit price in the order. The unbilled amount for a non-stock item with the Misc. Charge line type is calculated as the line amount minus the line discount (if applicable), and minus the line amount in the invoice or invoices generated for this order. This field is not available for transfer orders.
	`UnbilledQty`	`decimal(25, 6)`	Unbilled Quantity	-
Description:The quantity of stock and non-stock items that were not yet billed.
	`UnitCost`	`decimal(19, 6)`		-
Description:The unit cost at which the item being returned was issued from inventory when it was sold. For the return lines added with a link to an original invoice, this is the cost specified in the inventory issue transaction that was generated on release of the original invoice. For the return lines not linked to an invoice, the unit cost specified in this column depends on the items valuation method and the settings of the warehouse specified in the line. This field is available for orders of the CM, RC, RR, RM or CR type.
	`UnitPrice`	`decimal(19, 6)`	Unit Price	-
Description:The unit price of the item.
	`UnitVolume`	`decimal(19, 6)`		-
Description:The unit volume of the item.
	`UnitWeigth`	`decimal(19, 6)`	Unit Weight	-
Description:The unit weight of the item.
	`UnshippedQty`Nonexistent in DB	`decimal`	Unshipped Qty.	-
Description:The quantity of the blanket sales order line that have not been shipped yet in child orders. This field is available only for blanket sales orders.
	`UOM`Default Navigation	`nvarchar(6)`	UOM	INUnit
Description:The unit of measure (UOM) used for the item with this inventory ID.
	`VendorID`Default Navigation	`int`	Vendor	Vendor
Description:No description available
	`VerifyOrderQty`	`decimal`		-
Description:This will store the initial Order Qty of the SO to the verification process while updating the SOLine/SOLineSplits