AM
AMRPDetail
PX.Objects.AM44 of 44 fields
| Field Name | Type | Display Name | Foreign Key | |
|---|---|---|---|---|
RecordID | int | Record ID | - | |
Description:No description available | ||||
ActionDate | datetime2 | Action Date | - | |
Description:No description available | ||||
ActionLeadTime | int | Action Lead Time | - | |
Description:No description available | ||||
BaseQty | decimal(25, 6) | Base Qty | - | |
Description:No description available | ||||
BaseUOM | nvarchar(6) | Base UOM | INUnit | |
Description:No description available | ||||
BOMID | nvarchar(15) | BOM ID | - | |
Description:No description available | ||||
BOMLevel | int | BOM Level | - | |
Description:No description available | ||||
BOMRevisionID | nvarchar(10) | BOM Revision | AMBomItem | |
Description:No description available | ||||
BranchID | int | Branch | Branch | |
Description:No description available | ||||
CreatedByID | uniqueidentifier | Created By | Users | |
Description:No description available | ||||
CreatedByScreenID | char(8) | - | ||
Description:No description available | ||||
CreatedDateTime | datetime | Inventory Planning Date | - | |
Description:No description available | ||||
DetailFPRecordID | int | Detail FP ID | AMRPDetailFP | |
Description:No description available | ||||
InventoryID | int | Inventory ID | InventoryItem | |
Description:No description available | ||||
IsSub | bit | Is Sub | - | |
Description:No description available | ||||
ItemClassID | int | Item Class | INItemClass | |
Description:No description available | ||||
KitRevisionID | nvarchar(10) | Kit Revision | - | |
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 | ||||
ParentInventoryID | int | Parent Inventory ID | InventoryItem | |
Description:No description available | ||||
ParentRefNbr | nvarchar(30) | Related Parent Document | - | |
Description:No description available | ||||
ParentRefNoteID | uniqueidentifier | Related Parent Document ID | - | |
Description:No description available | ||||
ParentSubItemID | int | Parent Subitem | INSubItem | |
Description:No description available | ||||
PlannedRefNbr | nvarchar(30) | Generated Supply Document | - | |
Description:No description available | ||||
PreferredVendorID | int | Preferred Vendor ID | Vendor | |
Description:No description available | ||||
Processed | bit | Processed | - | |
Description:No description available | ||||
ProductInventoryID | int | Product Inventory ID | InventoryItem | |
Description:No description available | ||||
ProductManagerID | int | Product Manager ID | Contact | |
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 | ||||
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 | ||||
ReplenishmentSource | char(1) | Source | - | |
Description:No description available | ||||
SDFlag | char(1) | SD Flag | - | |
Description:No description available | ||||
SelectedNonexistent in DB | bit | Selected | - | |
Description:No description available | ||||
SiteID | int | Warehouse | INSite | |
Description:No description available | ||||
SubItemID | int | Subitem | INSubItem | |
Description:No description available | ||||
TransferSiteID | int | Transfer Warehouse | INSite | |
Description:No description available | ||||
tstamp | timestamp | - | ||
Description:No description available | ||||
Type | char(2) | Type | - | |
Description:No description available | ||||