AM
AMRPPlan
Table grouping all actual and plan orders together to support detail inquiry
View API Entity: MRPDetailInquiryResult
/entity/MANUFACTURING/25.100.001/MRPDetailInquiryResult| Field Name | Type | Display Name | Foreign Key | |
|---|---|---|---|---|
ActionDate | datetime | Action Date | - | |
Description:No description available | ||||
BaseQty API | decimal | Qty | - | |
Description:No description available | ||||
BranchID | int | Branch | - | |
Description:No description available | ||||
ConsolidationID | nvarchar(30) | Consolidation ID | - | |
Description:Consolidation ID - displays the consolidated planning record ID | ||||
InventoryID | int | Inventory ID | InventoryItem | |
Description:No description available | ||||
IsPlan | bit | Plan | - | |
Description:Does the MRP entry contribute to planned qty (when true) vs actual qty (when false) | ||||
ParentInventoryID API | int | Parent Inventory ID | - | |
Description:No description available | ||||
ParentSubItemID API | int | Parent Subitem | INSubItem | |
Description:No description available | ||||
ProductInventoryID API | int | Product Inventory ID | - | |
Description:No description available | ||||
ProductRefNbr | nvarchar(30) | Related Product Document | - | |
Description:Product ref nbr - displays the top level document for generated supply and demands | ||||
ProductRefNoteID | uniqueidentifier | Related Product Document ID | - | |
Description:Related Product Document Transaction Note ID | ||||
ProductSubItemID API | int | Product Subitem | INSubItem | |
Description:No description available | ||||
PromiseDate API | datetime | Promise Date | - | |
Description:No description available | ||||
decimal? | Projected On-Hand Qty | - | ||
Description:Projected On-Hand Qty | ||||
RecordID API | int | - | ||
Description:No description available | ||||
RefNbr API | nvarchar(30) | Related Document | - | |
Description:No description available | ||||
RefNoteID | uniqueidentifier | Related Document ID | - | |
Description:No description available | ||||
RefType API | char(2) | Reference Type | - | |
Description:Plan type related to the RefOrdertype and RefOrderNbr | ||||
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 API | char(2) | Type | - | |
Description:Planning Type | ||||
UOM | nvarchar(6) | UOM | INUnit | |
Description:No description available | ||||