AM
MRPEngineFirstPass.LoadINItemPlanProjection
PX.Objects.AM77 of 77 fields
| Field Name | Type | Display Name | Foreign Key | |
|---|---|---|---|---|
PlanID | bigint | INItemPlan | ||
Description:No description available | ||||
ActiveNonexistent in DB | bit | Active | - | |
Description:No description available | ||||
AMIncludeSupplyPlan | bit | - | ||
Description:No description available | ||||
AMLowLevel | int | Low Level | - | |
Description:No description available | ||||
AMMRPFlag | bit | Location MRP Enabled | - | |
Description:No description available | ||||
AMMRPFlagSite | bit | Inventory On Hand | - | |
Description:No description available | ||||
AMMRPPO | bit | Site MRP Include Purchase Orders | - | |
Description:No description available | ||||
AMMRPProd | bit | Site MRP Include Production Orders | - | |
Description:No description available | ||||
AMMRPShip | bit | Site MRP Include Shipments | - | |
Description:No description available | ||||
AMMRPSO | bit | Site MRP Include Sales Orders | - | |
Description:No description available | ||||
BAccountID | int | BAccount | ||
Description:No description available | ||||
BranchID | int | Branch | ||
Description:No description available | ||||
CostCenterID | int | INLotSerialStatusByCostCenter | ||
Description:No description available | ||||
CreatedByID | uniqueidentifier | Created By | Users | |
Description:No description available | ||||
CreatedByScreenID | varchar(8) | - | ||
Description:No description available | ||||
CreatedDateTime | datetime | - | ||
Description:No description available | ||||
DemandPlanID | bigint | - | ||
Description:No description available | ||||
DestinationSiteID | int | SO Order To Warehouse | - | |
Description:No description available | ||||
EntityType | varchar(MAX) | Note EntityType | - | |
Description:No description available | ||||
ExcludeFromMRP | bit | Exclude from MRP | - | |
Description:No description available | ||||
ExcludePlanLevel | int | - | ||
Description:No description available | ||||
FixedSource | char(1) | Fixed Source | - | |
Description:No description available | ||||
Hold | bit | On Hold | - | |
Description:No description available | ||||
IgnoreOrigPlan | bit | - | ||
Description:No description available | ||||
INDocType | char(3) | SO Order Inventory Transaction Type | - | |
Description:No description available | ||||
InventoryID | int | Inventory ID | InventoryItem | |
Description:No description available | ||||
IsSkippedWhenBackOrderedNonexistent in DB | bit | - | ||
Description:No description available | ||||
IsSupply | bit | Is Supply | - | |
Description:No description available | ||||
IsTempLotSerialNonexistent in DB | bit | - | ||
Description:No description available | ||||
IsTemporaryNonexistent in DB | bit | - | ||
Description:No description available | ||||
ItemClassID | int | Item Class | INItemClass | |
Description:No description available | ||||
KitInventoryID | int | Inventory ID | InventoryItem | |
Description:No description available | ||||
LastModifiedByID | uniqueidentifier | Last Modified By | Users | |
Description:No description available | ||||
LastModifiedByScreenID | varchar(8) | - | ||
Description:No description available | ||||
LastModifiedDateTime | datetime | - | ||
Description:No description available | ||||
LocationID | int | Location | INLocation | |
Description:No description available | ||||
LotSerialNbr | nvarchar(100) | Lot/Serial Nbr. | - | |
Description:No description available | ||||
Operation | char(1) | - | ||
Description:No description available | ||||
OrigNoteID | uniqueidentifier | - | ||
Description:No description available | ||||
OrigPlanID | bigint | - | ||
Description:No description available | ||||
OrigPlanLevel | int | - | ||
Description:No description available | ||||
OrigPlanType | char(2) | Orig. Plan Type | INPlanType | |
Description:No description available | ||||
OrigUOM | nvarchar(6) | - | ||
Description:No description available | ||||
ParentExcludeFromMRP | bit | Parent Item Exclude from MRP | - | |
Description:No description available | ||||
PlanDate | datetime2 | Planned On | - | |
Description:No description available | ||||
PlanQty | decimal | Planned Qty. | - | |
Description:No description available | ||||
PlanType | char(2) | Plan Type | INPlanType | |
Description:No description available | ||||
POOrderNbr | nvarchar(15) | - | ||
Description:No description available | ||||
POOrderType | char(2) | - | ||
Description:No description available | ||||
ProdItemCompleted | bit | Completed | - | |
Description:No description available | ||||
ProdItemInventoryID | int | Production Inventory ID | - | |
Description:No description available | ||||
ProdItemOrderType | varchar(MAX) | - | ||
Description:No description available | ||||
ProdItemProdOrdID | varchar(MAX) | - | ||
Description:No description available | ||||
ProdItemSubItemID | int | - | ||
Description:No description available | ||||
ProdMatlOperationCD | varchar(MAX) | - | ||
Description:No description available | ||||
ProdMatlOrderType | varchar(MAX) | - | ||
Description:No description available | ||||
ProdMatlProdOrdID | varchar(MAX) | - | ||
Description:No description available | ||||
ProjectID | int | - | ||
Description:No description available | ||||
RefEntityType | varchar(255) | - | ||
Description:No description available | ||||
RefNoteID | uniqueidentifier | - | ||
Description:No description available | ||||
RequestDate | datetime2 | - | ||
Description:No description available | ||||
Reverse | bit | Reverse | - | |
Description:No description available | ||||
SelectedNonexistent in DB | bit | Selected | - | |
Description:No description available | ||||
SiteID | int | Warehouse | INSite | |
Description:No description available | ||||
SOOrderNbr | nvarchar(15) | - | ||
Description:No description available | ||||
SOOrderType | char(2) | - | ||
Description:No description available | ||||
SOShipmentNbr | nvarchar(15) | - | ||
Description:No description available | ||||
SourceSiteID | int | Warehouse | INSite | |
Description:No description available | ||||
StatusID | char(1) | Production Order Status | - | |
Description:No description available | ||||
StkItem | bit | - | ||
Description:No description available | ||||
SubItemID | int | Subitem | INSubItem | |
Description:No description available | ||||
SupplyPlanID | bigint | INItemPlan | ||
Description:No description available | ||||
TaskID | int | - | ||
Description:No description available | ||||
tstamp | timestamp | - | ||
Description:No description available | ||||
UOM | nvarchar(6) | - | ||
Description:No description available | ||||
VendorID | int | Vendor | ||
Description:No description available | ||||
VendorLocationID | int | Location | ||
Description:No description available | ||||