SO
SalesAllocation
PX.Objects.SO45 of 45 fields
| Field Name | Type | Display Name | Foreign Key | |
|---|---|---|---|---|
LineNbr | int | SO Line Nbr. | - | |
Description:No description available | ||||
OrderNbr | nvarchar(15) | Order Nbr. | SOOrder | |
Description:No description available | ||||
OrderType | char(2) | Order Type | SOOrderType | |
Description:No description available | ||||
BaseLineQty | decimal(25, 6) | Base Qty. | - | |
Description:No description available | ||||
BaseUOM | nvarchar(6) | Base UOM | - | |
Description:No description available | ||||
BufferedQtyNonexistent in DB | decimal | - | ||
Description:No description available | ||||
BufferedTimeNonexistent in DB | datetime | - | ||
Description:No description available | ||||
CancelDate | datetime2 | Cancel By | - | |
Description:No description available | ||||
CostCenterID | int | INSiteStatusByCostCenterShort | ||
Description:No description available | ||||
CuryID | nvarchar(5) | Currency | Currency | |
Description:No description available | ||||
CuryInfoIDNonexistent in DB | bigint | - | ||
Description:No description available | ||||
CuryLineAmt | decimal(19, 4) | Line Amount | - | |
Description:No description available | ||||
CuryOrderTotal | decimal(19, 4) | Order Total | - | |
Description:No description available | ||||
CustomerClassID | nvarchar(10) | Customer Class | CustomerClass | |
Description:No description available | ||||
CustomerID | int | Customer | - | |
Description:No description available | ||||
CustomerName | nvarchar(255) | Customer Name | - | |
Description:No description available | ||||
InventoryCD | nvarchar(30) | - | ||
Description:No description available | ||||
InventoryID | int | Inventory ID | - | |
Description:No description available | ||||
IsExtraAllocationNonexistent in DB | bit | - | ||
Description:No description available | ||||
LineAmt | decimal(19, 4) | - | ||
Description:No description available | ||||
LineQty | decimal(25, 6) | Line Qty. | - | |
Description:No description available | ||||
LineSiteID | int | Warehouse | - | |
Description:No description available | ||||
LotSerialQtyAllocated | decimal | - | ||
Description:No description available | ||||
NoteID | uniqueidentifier | - | ||
Description:No description available | ||||
OrderCreatedOn | datetime | - | ||
Description:No description available | ||||
OrderDate | datetime2 | Order Date | - | |
Description:No description available | ||||
OrderDesc | nvarchar(256) | Order Description | - | |
Description:No description available | ||||
OrderHold | bit | - | ||
Description:No description available | ||||
OrderPriority | smallint | Order Priority | - | |
Description:No description available | ||||
OrderStatus | char(1) | Order Status | - | |
Description:No description available | ||||
OrderTotal | decimal(19, 4) | - | ||
Description:No description available | ||||
QtyAllocated | decimal | Qty. Allocated | - | |
Description:No description available | ||||
QtyHardAvailNonexistent in DB | decimal | Available for Shipping | - | |
Description:No description available | ||||
QtyToAllocateNonexistent in DB | decimal | Qty. to Allocate | - | |
Description:No description available | ||||
QtyToDeallocateNonexistent in DB | decimal | Qty. to Deallocate | - | |
Description:No description available | ||||
QtyUnallocated | decimal | Qty. Unallocated | - | |
Description:No description available | ||||
RequestDate | datetime2 | Line Requested On | - | |
Description:No description available | ||||
SalesPersonID | int | Salesperson ID | - | |
Description:No description available | ||||
SelectedNonexistent in DB | bit | Selected | - | |
Description:No description available | ||||
ShipComplete | char(1) | Line Shipping Rule | - | |
Description:No description available | ||||
ShipDate | datetime2 | Line Ship On | - | |
Description:No description available | ||||
SplitSiteID | int | Alloc. Warehouse | - | |
Description:No description available | ||||
SubItemID | int | INSubItem | ||
Description:No description available | ||||
TranDesc | nvarchar(256) | Description | - | |
Description:No description available | ||||
UOM | nvarchar(6) | UOM | - | |
Description:No description available | ||||