SOLine2

PX.Objects.SO

57 of 57 fields

	Field Name	Type	Display Name	Foreign Key
	`LineNbr`	`int`		-
Description:No description available
	`OrderNbr`	`nvarchar(15)`		SOOrder
Description:No description available
	`OrderType`	`char(2)`		SOOrderType
Description:No description available
	`ActualUnitPrice`	`decimal`		-
Description:No description available
	`BaseBilledQty`	`decimal(25, 6)`		-
Description:No description available
	`BaseOpenQty`	`decimal(25, 6)`	Base Open Qty.	-
Description:No description available
	`BaseOrderQty`	`decimal(25, 6)`		-
Description:No description available
	`BaseShippedQty`	`decimal(25, 6)`		-
Description:No description available
	`BaseUnbilledQty`	`decimal(25, 6)`		-
Description:No description available
	`Behavior`	`char(2)`		-
Description:No description available
	`BilledAmt`	`decimal(19, 4)`		-
Description:No description available
	`BilledQty`	`decimal(25, 6)`		-
Description:No description available
	`Completed`	`bit`		-
Description:No description available
	`CompleteQtyMax`	`decimal(9, 6)`		-
Description:No description available
	`CompleteQtyMin`	`decimal(9, 6)`		-
Description:No description available
	`CuryBilledAmt`	`decimal(19, 4)`		-
Description:No description available
	`CuryDiscAmt`	`decimal(19, 4)`	Discount Amount	-
Description:No description available
	`CuryExtPrice`	`decimal(19, 6)`	Ext. Price	-
Description:No description available
	`CuryInfoID`	`bigint`		CurrencyInfo
Description:No description available
	`CuryOpenAmt`	`decimal(19, 4)`	Open Amount	-
Description:No description available
	`CuryUnbilledAmt`	`decimal(19, 4)`		-
Description:No description available
	`CuryUnitPrice`	`decimal(19, 6)`		-
Description:No description available
	`DisableAutomaticTaxCalculation`	`bit`		-
Description:No description available
	`DiscAmt`	`decimal(19, 4)`		-
Description:No description available
	`DiscPct`	`decimal(9, 6)`		-
Description:No description available
	`DocumentDiscountRate`	`decimal(21, 18)`		-
Description:No description available
	`ExtPrice`	`decimal(19, 6)`		-
Description:No description available
	`GroupDiscountRate`	`decimal(21, 18)`		-
Description:No description available
	`InventoryID`	`int`		InventoryItem
Description:No description available
	`LastModifiedByID`Default Navigation	`uniqueidentifier`	Last Modified By	-
Description:No description available
	`LastModifiedByScreenID`	`char(8)`		-
Description:No description available
	`LastModifiedDateTime`	`datetime`		-
Description:No description available
	`LineSign`	`smallint`		-
Description:No description available
	`LineType`	`char(2)`		-
Description:No description available
	`OpenAmt`	`decimal(19, 4)`		-
Description:No description available
	`OpenQty`	`decimal(25, 6)`		-
Description:No description available
	`Operation`	`char(1)`	Operation	SOOrderTypeOperation
Description:No description available
	`OrderQty`	`decimal(25, 6)`		-
Description:No description available
	`OriginalBaseShippedQty`	`decimal`		-
Description:No description available
	`PlanType`	`char(2)`		-
Description:No description available
	`POSource`	`char(1)`		-
Description:No description available
	`SalesAcctID`	`int`		Account
Description:No description available
	`SalesSubID`	`int`		Sub
Description:No description available
	`ShipComplete`	`char(1)`		-
Description:No description available
	`ShipDate`	`datetime2`		-
Description:No description available
	`ShippedQty`	`decimal(25, 6)`		-
Description:No description available
	`SiteID`	`int`		INSite
Description:No description available
	`SortOrder`	`int`		-
Description:No description available
	`SubItemID`	`int`		INSubItem
Description:No description available
	`TaxCategoryID`	`nvarchar(15)`		TaxCategory
Description:No description available
	`TaxZoneID`	`nvarchar(10)`		TaxZone
Description:No description available
	`TranDesc`	`nvarchar(256)`		-
Description:No description available
	`tstamp`	`timestamp`		-
Description:No description available
	`UnbilledAmt`	`decimal(19, 4)`		-
Description:No description available
	`UnbilledQty`	`decimal(25, 6)`		-
Description:No description available
	`UnitCost`	`decimal(19, 6)`		-
Description:No description available
	`UOM`Default Navigation	`nvarchar(6)`	UOM	-
Description:No description available