SO
SOLineSplit
PX.Objects.SO88 of 88 fields
| Field Name | Type | Display Name | Foreign Key | |
|---|---|---|---|---|
LineNbr | int | SOLine | ||
Description:No description available | ||||
OrderNbr | nvarchar(15) | SOOrder | ||
Description:No description available | ||||
OrderType | char(2) | SOOrderType | ||
Description:No description available | ||||
SplitLineNbr | int | Allocation ID | SOLineSplit | |
Description:No description available | ||||
AllocatedPlanTypeNonexistent in DB | nvarchar | - | ||
Description:No description available | ||||
AMProdCreate | bit | Mark for Production | - | |
Description:No description available | ||||
AssignedNbrNonexistent in DB | nvarchar(30) | - | ||
Description:No description available | ||||
BackOrderPlanTypeNonexistent in DB | nvarchar | - | ||
Description:No description available | ||||
BaseClosedQty | decimal(25, 6) | - | ||
Description:For regular splits is 0. For Blanket order splits gets or sets quantity of items in base units that were transferred to child orders. | ||||
BaseOpenQtyNonexistent in DB | decimal | - | ||
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 | ||||
Behavior | char(2) | - | ||
Description:No description available | ||||
BlanketOpenQty | decimal | Blanket Open Qty. | - | |
Description:No description available | ||||
BookedPlanTypeNonexistent in DB | nvarchar | - | ||
Description:No description available | ||||
ChildLineCntr | int | - | ||
Description:No description available | ||||
ClosedQty | decimal(25, 6) | - | ||
Description:For regular splits is 0. For Blanket order splits gets or sets quantity of items in UOM that were transferred to child orders. | ||||
Completed | bit | Completed | - | |
Description:No description available | ||||
CostCenterID | int | - | ||
Description:No description available | ||||
CreatedByID | uniqueidentifier | Created By | Users | |
Description:No description available | ||||
CreatedByScreenID | char(8) | - | ||
Description:No description available | ||||
CreatedDateTime | datetime | - | ||
Description:No description available | ||||
CustomerOrderNbr | nvarchar(40) | Customer Order Nbr. | - | |
Description:No description available | ||||
EffectiveChildLineCntr | int | - | ||
Description:No description available | ||||
ExpireDate | datetime2 | Expiration Date | - | |
Description:No description available | ||||
FixedSource | nchar(1) | - | ||
Description:No description available | ||||
InventoryID | int | Inventory ID | InventoryItem | |
Description:No description available | ||||
InvtMult | smallint | - | ||
Description:No description available | ||||
IsAllocated | bit | Allocated | - | |
Description:No description available | ||||
IsMergeableNonexistent in DB | bit | - | ||
Description:No description available | ||||
IsOrchestratedLine | bit | Orchestrated | - | |
Description:No description available | ||||
IsStockItem | bit | - | ||
Description:No description available | ||||
LastModifiedByID | uniqueidentifier | Last Modified By | Users | |
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 | Location | INLocation | |
Description:No description available | ||||
LotSerClassIDNonexistent in DB | nvarchar(10) | - | ||
Description:No description available | ||||
LotSerialNbr | nvarchar(100) | Lot/Serial Nbr. | INLotSerialStatus | |
Description:No description available | ||||
OpenChildLineCntr | int | - | ||
Description:No description available | ||||
OpenQtyNonexistent in DB | decimal | - | ||
Description:No description available | ||||
Operation | char(1) | SOOrderTypeOperation | ||
Description:No description available | ||||
OrderDate | datetime2 | - | ||
Description:No description available | ||||
OrigPlanType | char(2) | INPlanType | ||
Description:No description available | ||||
ParentSplitLineNbr | int | Parent Allocation ID | - | |
Description:No description available | ||||
PlanID | bigint | INItemPlan | ||
Description:No description available | ||||
PlanTypeNonexistent in DB | nchar(2) | - | ||
Description:No description available | ||||
POCancelled | bit | - | ||
Description:No description available | ||||
POCompleted | bit | - | ||
Description:No description available | ||||
POCreate | bit | Mark for PO | - | |
Description:No description available | ||||
POCreateDate | datetime2 | PO Creation Date | - | |
Description:No description available | ||||
POLineNbr | int | PO Line Nbr. | POLine | |
Description:No description available | ||||
PONbr | nvarchar(15) | PO Nbr. | POOrder | |
Description:No description available | ||||
POReceiptNbr | nvarchar(15) | PO Receipt Nbr. | POReceipt | |
Description:No description available | ||||
POReceiptType | char(2) | PO Receipt Type | - | |
Description:No description available | ||||
POSiteID | int | INSite | ||
Description:No description available | ||||
POSource | char(1) | - | ||
Description:No description available | ||||
POType | char(2) | PO Type | - | |
Description:No description available | ||||
ProjectIDNonexistent in DB | int | - | ||
Description:No description available | ||||
Qty | decimal(25, 6) | Quantity | - | |
Description:No description available | ||||
QtyOnOrders | decimal(25, 6) | Qty. On Orders | - | |
Description:No description available | ||||
ReceivedQty | decimal(25, 6) | Qty. Received | - | |
Description:No description available | ||||
RefNoteID | uniqueidentifier | Related Document | - | |
Description:No description available | ||||
RequireAllocationNonexistent in DB | bit | - | ||
Description:No description available | ||||
RequireLocationNonexistent in DB | bit | - | ||
Description:No description available | ||||
RequireShippingNonexistent in DB | bit | - | ||
Description:No description available | ||||
SchedOrderDate | datetime2 | Sched. Order Date | - | |
Description:No description available | ||||
SchedShipDate | datetime2 | Sched. Shipment Date | - | |
Description:No description available | ||||
ShipComplete | char(1) | - | ||
Description:No description available | ||||
ShipDate | datetime2 | Ship On | - | |
Description:No description available | ||||
ShipmentNbr | nvarchar(15) | Shipment Nbr. | SOShipment | |
Description:No description available | ||||
ShippedQty | decimal(25, 6) | Qty. On Shipments | - | |
Description:No description available | ||||
SiteID | int | Alloc. Warehouse | INSite | |
Description:No description available | ||||
SOLineNbr | int | SOLine | ||
Description:No description available | ||||
SOOrderNbr | nvarchar(15) | SOOrder | ||
Description:No description available | ||||
SOOrderType | char(2) | SOOrderType | ||
Description:No description available | ||||
SOSplitLineNbr | int | - | ||
Description:No description available | ||||
SubItemID | int | Subitem | INLocationStatus | |
Description:No description available | ||||
TaskIDNonexistent in DB | int | - | ||
Description:No description available | ||||
ToSiteID | int | Orig. Warehouse | INSite | |
Description:No description available | ||||
TranTypeNonexistent in DB | nchar(3) | - | ||
Description:No description available | ||||
tstamp | timestamp | - | ||
Description:No description available | ||||
UnreceivedQtyNonexistent in DB | decimal | - | ||
Description:No description available | ||||
UOM | nvarchar(6) | UOM | INUnit | |
Description:No description available | ||||
VendorID | int | Vendor | ||
Description:No description available | ||||