SO
SupplyPOLine
PX.Objects.SO40 of 40 fields
| Field Name | Type | Display Name | Foreign Key | |
|---|---|---|---|---|
LineNbr | int | PO Line Nbr. | - | |
Description:No description available | ||||
OrderNbr | nvarchar(15) | PO Nbr. | POOrder | |
Description:No description available | ||||
OrderType | char(2) | PO Type | - | |
Description:No description available | ||||
BaseDemandQtyNonexistent in DB | decimal | - | ||
Description:No description available | ||||
BaseOpenQty | decimal(25, 6) | - | ||
Description:No description available | ||||
BaseOrderQty | decimal(25, 6) | - | ||
Description:No description available | ||||
BaseReceivedQty | decimal(25, 6) | - | ||
Description:No description available | ||||
Cancelled | bit | - | ||
Description:No description available | ||||
Closed | bit | - | ||
Description:No description available | ||||
Completed | bit | - | ||
Description:No description available | ||||
CostCenterID | int | - | ||
Description:No description available | ||||
CostCodeID | int | PMCostCode | ||
Description:No description available | ||||
CuryID | nvarchar(5) | Currency | - | |
Description:No description available | ||||
CuryUnitCost | decimal(19, 6) | Unit Cost | - | |
Description:No description available | ||||
Hold | bit | - | ||
Description:No description available | ||||
InventoryID | int | Inventory ID | - | |
Description:No description available | ||||
IsSpecialOrder | 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) | Line Type | - | |
Description:No description available | ||||
LinkedSOLinesNonexistent in DB | unspecified | - | ||
Description:No description available | ||||
OpenQty | decimal(25, 6) | Open Qty. | - | |
Description:No description available | ||||
OrderDate | datetime2 | Order Date | - | |
Description:No description available | ||||
OrderQty | decimal(25, 6) | Order Qty. | - | |
Description:No description available | ||||
PlanID | bigint | PlanID | INItemPlan | |
Description:No description available | ||||
ProjectID | int | PMProject | ||
Description:No description available | ||||
PromisedDate | datetime2 | Promised | - | |
Description:No description available | ||||
ReceivedQty | decimal(25, 6) | - | ||
Description:No description available | ||||
SelectedNonexistent in DB | bit | Selected | - | |
Description:No description available | ||||
SelectedSOLinesNonexistent in DB | unspecified | - | ||
Description:No description available | ||||
SiteID | int | INSite | ||
Description:No description available | ||||
SODeleted | bit | - | ||
Description:No description available | ||||
SubItemID | int | Subitem | - | |
Description:No description available | ||||
TaskID | int | PMTask | ||
Description:No description available | ||||
TranDesc | nvarchar(256) | Line Description | - | |
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 | ||||
VendorRefNbr | nvarchar(40) | Vendor Ref. | - | |
Description:No description available | ||||