AM
AMRPDetailFP
Inventory Planning first pass detail records rebuilt during Inventory Planning regen process
| Field Name | Type | Display Name | Foreign Key | |
|---|---|---|---|---|
BAccountID | int | BAccount | ||
Description:No description available | ||||
BOMID | nvarchar(15) | BOM ID | AMBomItem | |
Description:No description available | ||||
BOMRevisionID | nvarchar(10) | BOM Revision | AMBomItem | |
Description:No description available | ||||
BranchID | int | Branch | - | |
Description:No description available | ||||
ConsolidatedRecordID | int | Consolidated Record | - | |
Description:No description available | ||||
ConsolidatedSafetyQty | decimal | Consolidated Safety Qty. | - | |
Description:No description available | ||||
DemandPlanID | bigint | INItemPlanDemand | ||
Description:No description available | ||||
InventoryID | int | Inventory ID | InventoryItem | |
Description:No description available | ||||
ItemClassID | int | Item Class | INItemClass | |
Description:No description available | ||||
KitRevisionID | nvarchar(10) | Kit Revision | - | |
Description:Kit Revision ID | ||||
LateDemandNonexistent in DBObsolete | bool? | Late Demand | - | |
Description:No description available | ||||
LowLevel | int | Low Level | - | |
Description:No description available | ||||
OnHoldStatus | int | On hold status | - | |
Description:No description available | ||||
OrderQtyConsumed | decimal | Consumed Fcst Qty | - | |
Description:Contains forecast and MPS qty consumed numbers when the types are dependent | ||||
OriginalQty | decimal | Original Stock Qty | - | |
Description:No description available | ||||
ParentInventoryID | int | Parent Inventory ID | InventoryItem | |
Description:No description available | ||||
ParentRefNbr | nvarchar(30) | Parent Reference Nbr. | - | |
Description:No description available | ||||
ParentRefNoteID | uniqueidentifier | Related Parent Document ID | - | |
Description:No description available | ||||
ParentSchdNoteIDNonexistent in DB | Guid? | Parent Schedule ID | - | |
Description:Reference to the parent AMSchdItem.NoteID. | ||||
ParentSubItemID | int | Parent Subitem | - | |
Description:No description available | ||||
PlanDate | datetime | Plan Date | - | |
Description:No description available | ||||
PlanID | bigint | INItemPlan | ||
Description:No description available | ||||
PlanType | char(2) | Plan Type | - | |
Description:No description available | ||||
Processed | bit | Processed | - | |
Description:No description available | ||||
ProductInventoryID | int | Product Inventory ID | InventoryItem | |
Description:No description available | ||||
ProductRefNbr | nvarchar(30) | Product Reference Nbr. | - | |
Description:No description available | ||||
ProductRefNoteID | uniqueidentifier | Related Product Document ID | - | |
Description:No description available | ||||
ProductSubItemID | int | Product Subitem | - | |
Description:No description available | ||||
Qty | decimal | Stock Qty | - | |
Description:No description available | ||||
RecordID | int | Record ID | - | |
Description:No description available | ||||
RefNbr | nvarchar(30) | Ref Nbr | - | |
Description:No description available | ||||
RefNoteID | uniqueidentifier | Related Document ID | - | |
Description:No description available | ||||
RefType | char(2) | Ref Type | - | |
Description:Reference type | ||||
RequiredDate | datetime | Required Date | - | |
Description:No description available | ||||
SDFlag | nchar(1) | SD Flag | - | |
Description:No description available | ||||
SiteID | int | Warehouse | INSite | |
Description:No description available | ||||
SiteSequenceNonexistent in DB | int? | Warehouse Sequence | - | |
Description:Declares the order of processing for the same InventoryID. | ||||
SubItemID | int | Subitem | - | |
Description:No description available | ||||
SuppliedQty | decimal | Supplied Qty | - | |
Description:No description available | ||||
SupplyPlanID | bigint | INItemPlanSupply | ||
Description:No description available | ||||
TransferSiteID | int | Transfer Warehouse | - | |
Description:No description available | ||||
Type | char(2) | Type | - | |
Description:Planning Type | ||||
VendorID | int | Vendor | ||
Description:No description available | ||||
VendorLocationID | int | Location | ||
Description:No description available | ||||
tstamp | timestamp | - | ||
Description:No description available | ||||