BlanketSOLine

PX.Objects.SO.DAC.Projections

85 of 85 fields

	Field Name	Type	Display Name	Foreign Key
	`LineNbr`	`int`		-
Description:No description available
	`OrderNbr`	`nvarchar(15)`		BlanketSOOrder
Description:No description available
	`OrderType`	`char(2)`		SOOrderType
Description:No description available
	`AutomaticDiscountsDisabled`	`bit`		-
Description:No description available
	`BaseBilledQty`	`decimal(25, 6)`		-
Description:No description available
	`BaseClosedQty`	`decimal`		-
Description:No description available
	`BaseOpenQty`	`decimal(25, 6)`		-
Description:No description available
	`BaseOrderQty`	`decimal(25, 6)`		-
Description:No description available
	`BaseQtyOnOrders`	`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
	`BlanketOpenQty`	`decimal`		-
Description:No description available
	`BranchID`	`int`		Branch
Description:No description available
	`ChildLineCntr`	`int`		-
Description:No description available
	`ClosedQty`	`decimal`		-
Description:No description available
	`Completed`	`bit`		-
Description:No description available
	`CostCodeID`	`int`		PMCostCode
Description:No description available
	`CuryBilledAmt`	`decimal(19, 4)`		-
Description:No description available
	`CuryDiscAmt`	`decimal(19, 4)`		-
Description:No description available
	`CuryExtPrice`	`decimal(19, 6)`		-
Description:No description available
	`CuryInfoID`	`bigint`		CurrencyInfo
Description:No description available
	`CuryLineAmt`	`decimal(19, 4)`		-
Description:No description available
	`CuryOpenAmt`	`decimal(19, 4)`		-
Description:No description available
	`CuryUnbilledAmt`	`decimal(19, 4)`		-
Description:No description available
	`CuryUnitPrice`	`decimal(19, 6)`		-
Description:No description available
	`CustomerID`	`int`		Customer
Description:No description available
	`CustomerLocationID`	`int`		Location
Description:No description available
	`CustomerOrderNbr`	`nvarchar(40)`		-
Description:No description available
	`DiscAmt`	`decimal(19, 4)`		-
Description:No description available
	`DiscountID`	`nvarchar(10)`		ARDiscount
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
	`FOBPoint`	`nvarchar(15)`		FOBPoint
Description:No description available
	`GroupDiscountRate`	`decimal(21, 18)`		-
Description:No description available
	`InventoryID`	`int`		InventoryItem
Description:No description available
	`IsFree`	`bit`		-
Description:No description available
	`IsStockItem`	`bit`		-
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
	`LineAmt`	`decimal(19, 4)`		-
Description:No description available
	`LineSign`	`smallint`		-
Description:No description available
	`LineType`	`char(2)`		-
Description:No description available
	`ManualDisc`	`bit`		-
Description:No description available
	`NoteID`	`uniqueidentifier`		-
Description:No description available
	`OpenAmt`	`decimal(19, 4)`		-
Description:No description available
	`OpenChildLineCntr`	`int`		-
Description:No description available
	`OpenLine`	`bit`		-
Description:No description available
	`OpenQty`	`decimal(25, 6)`		-
Description:No description available
	`Operation`	`char(1)`		SOOrderTypeOperation
Description:No description available
	`OrderQty`	`decimal(25, 6)`		-
Description:No description available
	`OrigCuryOpenAmt`	`decimal`		-
Description:No description available
	`POCreate`	`bit`		-
Description:No description available
	`POCreated`	`bit`		-
Description:No description available
	`POSource`	`char(1)`		-
Description:No description available
	`ProjectID`	`int`		PMProject
Description:No description available
	`QtyOnOrders`	`decimal(25, 6)`		-
Description:No description available
	`RequestDate`	`datetime2`		-
Description:No description available
	`SalesAcctID`	`int`		Account
Description:The account associated with the sale of the line item.
	`SalesPersonID`	`int`		SalesPerson
Description:No description available
	`SalesSubID`	`int`		Sub
Description:The subaccount associated with the sale of the line item.
	`SchedOrderDate`	`datetime2`		-
Description:No description available
	`SchedShipDate`	`datetime2`		-
Description:No description available
	`ShipComplete`	`char(1)`		-
Description:No description available
	`ShippedQty`	`decimal(25, 6)`		-
Description:No description available
	`ShipTermsID`	`nvarchar(10)`		ShipTerms
Description:No description available
	`ShipVia`	`nvarchar(15)`		Carrier
Description:No description available
	`ShipZoneID`	`nvarchar(15)`		ShippingZone
Description:No description available
	`SiteID`	`int`		BlanketSOOrderSite
Description:No description available
	`SkipLineDiscounts`	`bit`		-
Description:Indicates (if selected) that the automatic line discounts are not applied to this line.
	`SubItemID`	`int`		INSubItem
Description:No description available
	`TaskID`	`int`		PMTask
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
	`UnitPrice`	`decimal(19, 6)`		-
Description:No description available
	`UOM`Default Navigation	`nvarchar(6)`	UOM	-
Description:No description available
	`VendorID`	`int`		Vendor
Description:No description available