AM
AMRPPlan
PX.Objects.AM24 of 24 fields
| Field Name | Type | Display Name | Foreign Key | |
|---|---|---|---|---|
RecordID | int | - | ||
Description:No description available | ||||
ActionDate | datetime2 | Action Date | - | |
Description:No description available | ||||
BaseQty | decimal(25, 6) | Qty | - | |
Description:No description available | ||||
BranchID | int | Branch | Branch | |
Description:No description available | ||||
ConsolidationID | nvarchar(30) | Consolidation ID | - | |
Description:No description available | ||||
InventoryID | int | Inventory ID | InventoryItem | |
Description:No description available | ||||
IsPlan | bit | Plan | - | |
Description:No description available | ||||
ParentInventoryID | int | Parent Inventory ID | InventoryItem | |
Description:No description available | ||||
ParentSubItemID | int | Parent Subitem | INSubItem | |
Description:No description available | ||||
ProductInventoryID | int | Product Inventory ID | InventoryItem | |
Description:No description available | ||||
ProductRefNbr | nvarchar(30) | Related Product Document | - | |
Description:No description available | ||||
ProductRefNoteID | uniqueidentifier | Related Product Document ID | - | |
Description:No description available | ||||
ProductSubItemID | int | Product Subitem | INSubItem | |
Description:No description available | ||||
PromiseDate | datetime2 | Promise Date | - | |
Description:No description available | ||||
QtyOnHandNonexistent in DB | decimal | Projected On-Hand Qty | - | |
Description:No description available | ||||
RefNbr | nvarchar(30) | Related Document | - | |
Description:No description available | ||||
RefNoteID | uniqueidentifier | Related Document ID | - | |
Description:No description available | ||||
RefType | char(2) | Reference Type | - | |
Description:No description available | ||||
SDflag | char(1) | SD Flag | - | |
Description:No description available | ||||
SiteID | int | Warehouse | INSite | |
Description:No description available | ||||
SubItemID | int | Subitem | INSubItem | |
Description:No description available | ||||
Tstamp | timestamp | - | ||
Description:No description available | ||||
Type | char(2) | Type | - | |
Description:No description available | ||||
UOM | nvarchar(6) | UOM | INUnit | |
Description:No description available | ||||