AM
AMRPDetailFP
PX.Objects.AM45 of 45 fields
| Field Name | Type | Display Name | Foreign Key | |
|---|---|---|---|---|
RecordID | int | Record ID | - | |
Description:No description available | ||||
BAccountID | int | BAccount | ||
Description:No description available | ||||
BOMID | nvarchar(15) | BOM ID | - | |
Description:No description available | ||||
BOMRevisionID | nvarchar(10) | BOM Revision | AMBomItem | |
Description:No description available | ||||
BranchID | int | Branch | Branch | |
Description:No description available | ||||
ConsolidatedRecordID | int | Consolidated Record | - | |
Description:No description available | ||||
ConsolidatedSafetyQty | decimal(25, 6) | Consolidated Safety Qty. | - | |
Description:No description available | ||||
DemandPlanID | bigint | INItemPlan | ||
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:No description available | ||||
LateDemandNonexistent in DBObsolete | bit | 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(25, 6) | Consumed Fcst Qty | - | |
Description:No description available | ||||
OriginalQty | decimal(25, 6) | 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 | uniqueidentifier | Parent Schedule ID | - | |
Description:No description available | ||||
ParentSubItemID | int | Parent Subitem | - | |
Description:No description available | ||||
PlanDate | datetime2 | 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(25, 6) | Stock Qty | - | |
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:No description available | ||||
RequiredDate | datetime2 | Required Date | - | |
Description:No description available | ||||
SDFlag | char(1) | SD Flag | - | |
Description:No description available | ||||
SiteID | int | Warehouse | INSite | |
Description:No description available | ||||
SiteSequenceNonexistent in DB | int | Warehouse Sequence | - | |
Description:No description available | ||||
SubItemID | int | Subitem | - | |
Description:No description available | ||||
SuppliedQty | decimal(25, 6) | Supplied Qty | - | |
Description:No description available | ||||
SupplyPlanID | bigint | INItemPlan | ||
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 | ||||
VendorID | int | Vendor | ||
Description:No description available | ||||
VendorLocationID | int | Location | ||
Description:No description available | ||||