SO
BlanketSOLineSplit
PX.Objects.SO.DAC.Projections49 of 49 fields
| Field Name | Type | Display Name | Foreign Key | |
|---|---|---|---|---|
LineNbr | int | BlanketSOLine | ||
Description:No description available | ||||
OrderNbr | nvarchar(15) | SOOrder | ||
Description:No description available | ||||
OrderType | char(2) | SOOrderType | ||
Description:No description available | ||||
SplitLineNbr | int | SOLineSplit | ||
Description:No description available | ||||
BaseClosedQty | decimal(25, 6) | - | ||
Description:No description available | ||||
BaseQty | decimal(25, 6) | - | ||
Description:No description available | ||||
BaseQtyOnOrders | decimal(25, 6) | - | ||
Description:No description available | ||||
BaseReceivedQty | decimal(25, 6) | - | ||
Description:No description available | ||||
BaseShippedQty | decimal(25, 6) | - | ||
Description:No description available | ||||
BaseUnreceivedQtyNonexistent in DB | decimal | - | ||
Description:No description available | ||||
BlanketOpenQty | decimal | - | ||
Description:No description available | ||||
ChildLineCntr | int | - | ||
Description:No description available | ||||
ClosedQty | decimal(25, 6) | - | ||
Description:No description available | ||||
Completed | bit | - | ||
Description:No description available | ||||
CustomerOrderNbr | nvarchar(40) | - | ||
Description:No description available | ||||
EffectiveChildLineCntr | int | - | ||
Description:No description available | ||||
InventoryID | int | InventoryItem | ||
Description:No description available | ||||
IsAllocated | bit | - | ||
Description:No description available | ||||
LastModifiedByID | uniqueidentifier | Last Modified By | - | |
Description:No description available | ||||
LastModifiedByScreenID | char(8) | - | ||
Description:No description available | ||||
LastModifiedDateTime | datetime | - | ||
Description:No description available | ||||
LineType | char(2) | - | ||
Description:No description available | ||||
LocationID | int | INLocation | ||
Description:No description available | ||||
LotSerialNbr | nvarchar(100) | INLotSerialStatus | ||
Description:No description available | ||||
OpenChildLineCntr | int | - | ||
Description:No description available | ||||
PlanID | bigint | INItemPlan | ||
Description:No description available | ||||
POCancelled | bit | - | ||
Description:No description available | ||||
POCompleted | bit | - | ||
Description:No description available | ||||
POCreate | bit | - | ||
Description:No description available | ||||
POLineNbr | int | POLine | ||
Description:No description available | ||||
PONbr | nvarchar(15) | POOrder | ||
Description:No description available | ||||
POReceiptNbr | nvarchar(15) | POReceipt | ||
Description:No description available | ||||
POReceiptType | char(2) | - | ||
Description:No description available | ||||
POSource | char(1) | - | ||
Description:No description available | ||||
POType | char(2) | - | ||
Description:No description available | ||||
Qty | decimal(25, 6) | - | ||
Description:No description available | ||||
QtyOnOrders | decimal(25, 6) | - | ||
Description:No description available | ||||
ReceivedQty | decimal(25, 6) | - | ||
Description:No description available | ||||
RefNoteID | uniqueidentifier | - | ||
Description:No description available | ||||
SchedOrderDate | datetime2 | - | ||
Description:No description available | ||||
SchedShipDate | datetime2 | - | ||
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 | ||||
SubItemID | int | INLocationStatus | ||
Description:No description available | ||||
ToSiteID | int | INSite | ||
Description:No description available | ||||
tstamp | timestamp | - | ||
Description:No description available | ||||
UOM | nvarchar(6) | UOM | - | |
Description:No description available | ||||
VendorID | int | Vendor | ||
Description:No description available | ||||