AM

AMRPDetail

PX.Objects.AMScreenAM400000Release 2025.2

Root Inventory Planning table for Inventory Planning display (planning recommendations)

View API Entity: MRPDisplay/entity/MANUFACTURING/25.100.001/MRPDisplay
Related:INSubItemInventoryItemAMBomItemUsersAMRPDetailFPVendor
Select a row for its description 44 of 44 fields
Field NameTypeDisplay NameForeign Key
ActionDate API
datetimeAction Date-
Description:No description available
ActionLeadTime API
intAction Lead Time-
Description:No description available
BOMID API
nvarchar(15)BOM IDAMBomItem
Description:BOM ID - ID of Bill of materials record
BOMLevel
intBOM Level-
Description:No description available
BOMRevisionID API Default Navigation
nvarchar(10)BOM RevisionAMBomItem
Description:Bill of material Revision ID
BaseQty API
decimalBase Qty-
Description:No description available
BaseUOM API Default Navigation
nvarchar(6)Base UOMINUnit
Description:No description available
BranchID API Default Navigation
intBranch-
Description:No description available
CreatedByIDDefault Navigation
uniqueidentifierCreated ByUsers
Description:No description available
CreatedByScreenID
char(8)-
Description:No description available
CreatedDateTime API
datetimeInventory Planning Date-
Description:No description available
DetailFPRecordID
intDetail FP IDAMRPDetailFP
Description:No description available
InventoryID API Default Navigation
intInventory IDInventoryItem
Description:No description available
IsSub
bitIs Sub-
Description:No description available
ItemClassID API Default Navigation
intItem ClassINItemClass
Description:No description available
KitRevisionIDDefault Navigation
nvarchar(10)Kit RevisionINKitSpecHdr
Description:Kit Revision ID
LastModifiedByIDDefault Navigation
uniqueidentifierLast Modified ByUsers
Description:No description available
LastModifiedByScreenID
char(8)-
Description:No description available
LastModifiedDateTime
datetime-
Description:No description available
ParentInventoryID API Default Navigation
intParent Inventory IDInventoryItem
Description:No description available
ParentRefNbr API
nvarchar(30)Related Parent Document-
Description:No description available
ParentRefNoteID
uniqueidentifierRelated Parent Document ID-
Description:No description available
ParentSubItemID API Default Navigation
intParent SubitemINSubItem
Description:No description available
PlannedRefNbr
nvarchar(30)Generated Supply Document-
Description:PlannedRefNbr - retains the record ID for all suggested supply plans generated by inventory planning
PreferredVendorID API Default Navigation
intPreferred Vendor IDVendor
Description:No description available
Processed
bitProcessed-
Description:No description available
ProductInventoryID API Default Navigation
intProduct Inventory IDInventoryItem
Description:No description available
ProductManagerID API Default Navigation
intProduct Manager IDEPEmployee
Description:No description available
ProductRefNbr API
nvarchar(30)Related Product Document-
Description:No description available
ProductRefNoteID
uniqueidentifierRelated Product Document ID-
Description:No description available
ProductSubItemID API Default Navigation
intProduct SubitemINSubItem
Description:No description available
PromiseDate API
datetimePromise Date-
Description:No description available
RecordID API
intRecord ID-
Description:No description available
RefNbr API
nvarchar(30)Related Document-
Description:No description available
RefNoteID
uniqueidentifierRelated Document ID-
Description:No description available
RefType API
char(2)Reference Type-
Description:Plan type related to the RefOrdertype and RefOrderNbr
ReplenishmentSource API
char(1)Source-
Description:Replenishment source
SDFlag API
nchar(1)SD Flag-
Description:No description available
Selected API Nonexistent in DB
bool?Selected-
Description:No description available
SiteID API Default Navigation
intWarehouseINSite
Description:No description available
SubItemID API Default Navigation
intSubitemINSubItem
Description:No description available
TransferSiteID API Default Navigation
intTransfer Warehouse-
Description:Transfer Warehouse ID
Type API
char(2)Type-
Description:Planning Type
tstamp
timestamp-
Description:No description available