SOLine4

PX.Objects.SO

46 of 46 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
	`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
	`BlanketLineNbr`	`int`		BlanketSOLine
Description:No description available
	`BlanketNbr`	`nvarchar(15)`		SOBlanketOrderLink
Description:No description available
	`BlanketSplitLineNbr`	`int`		BlanketSOLineSplit
Description:No description available
	`BlanketType`	`char(2)`		-
Description:No description available
	`BranchID`	`int`		Branch
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
	`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
	`DiscPct`	`decimal(9, 6)`		-
Description:No description available
	`DocumentDiscountRate`	`decimal(21, 18)`		-
Description:No description available
	`GroupDiscountRate`	`decimal(21, 18)`		-
Description:No description available
	`InventoryID`	`int`		InventoryItem
Description:No description available
	`LineAmt`	`decimal(19, 4)`		-
Description:No description available
	`LineSign`	`smallint`		-
Description:No description available
	`OpenAmt`	`decimal(19, 4)`		-
Description:No description available
	`OpenLine`	`bit`		-
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
	`POCreate`	`bit`		-
Description:No description available
	`POSource`	`char(1)`		-
Description:No description available
	`ProjectID`	`int`		PMProject
Description:No description available
	`SalesAcctID`	`int`		Account
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
	`TaskID`	`int`		PMTask
Description:No description available
	`TaxCategoryID`	`nvarchar(15)`		TaxCategory
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
	`UnitPrice`	`decimal(19, 6)`		-
Description:No description available
	`UOM`Default Navigation	`nvarchar(6)`	UOM	-
Description:No description available