AM
LoadINItemPlanProjection
Projection for query to LoadINItemPlan
| Field Name | Type | Display Name | Foreign Key | |
|---|---|---|---|---|
AMIncludeSupplyPlan | bit | - | ||
Description:No description available | ||||
AMLowLevel | int | Low Level | - | |
Description:InventoryItemExt.AMLowLevel Non UI field - keeps items lowest bom level value used in calculations | ||||
AMMRPFlag | bit | Location MRP Enabled | - | |
Description:INLocationExt.AMMRPFlag | ||||
AMMRPFlagSite | bit | Inventory On Hand | - | |
Description:INSiteExt.AMMRPFlag MRP Include Inventory On Hand (Main flag for warehouse with MRP) | ||||
AMMRPPO | bit | Site MRP Include Purchase Orders | - | |
Description:INSiteExt.AMMRPPO MRP Include Purchase Orders | ||||
AMMRPProd | bit | Site MRP Include Production Orders | - | |
Description:INSiteExt.AMMRPProd MRP Include Production Orders | ||||
AMMRPSO | bit | Site MRP Include Sales Orders | - | |
Description:INSiteExt.AMMRPSO MRP Include Sales Orders | ||||
AMMRPShip | bit | Site MRP Include Shipments | - | |
Description:INSiteExt.AMMRPShip MRP Include Shipments | ||||
ActiveNonexistent in DB | bool? | Active | - | |
Description:No description available | ||||
BAccountID | int | BAccount | ||
Description:No description available | ||||
BranchID | int | - | ||
Description:INSite.BranchID | ||||
CostCenterID | int | INLotSerialStatusByCostCenter | ||
Description:No description available | ||||
CreatedByID | uniqueidentifier | Created By | Users | |
Description:No description available | ||||
CreatedByScreenID | char(8) | - | ||
Description:No description available | ||||
CreatedDateTime | datetime | - | ||
Description:No description available | ||||
DemandPlanID | bigint | INItemPlanDemand | ||
Description:No description available | ||||
DestinationSiteID | int | SO Order To Warehouse | - | |
Description:SimpleOrder.destinationSiteID = SOOrder.destinationSiteID | ||||
EntityType | nvarchar | Note EntityType | - | |
Description:Note.EntityType | ||||
ExcludeFromMRP | bit | Exclude from MRP | - | |
Description:AMProdItem.ExcludeFromMRP | ||||
ExcludePlanLevel | int | - | ||
Description:No description available | ||||
FixedSource | char(1) | Fixed Source | - | |
Description:No description available | ||||
Hold | bit | On Hold | - | |
Description:No description available | ||||
INDocType | char(3) | SO Order Inventory Transaction Type | - | |
Description:SimpleOrder.iNDocType = SOOrderType.iNDocType | ||||
IgnoreOrigPlan | bit | - | ||
Description:The field is used for breaking inheritance between plans. It may be needed, e.g., when Lot/Serial Number of the base plan differs from the derivative one. | ||||
InventoryID | int | Inventory ID | InventoryItem | |
Description:No description available | ||||
IsSkippedWhenBackOrderedNonexistent in DB | bool? | - | ||
Description:The flag indicates if the record has to be skipped when backordered. | ||||
IsSupply | bit | Is Supply | - | |
Description:INPlanType.AsSupply | ||||
IsTempLotSerialNonexistent in DB | bool? | - | ||
Description:No description available | ||||
IsTemporaryNonexistent in DB | bool? | - | ||
Description:The flag indicates if the record is not for persistence | ||||
ItemClassID | int | Item Class | - | |
Description:InventoryItem.ItemClassID | ||||
KitInventoryID | int | Inventory ID | InventoryItem | |
Description:An identifier of a non-stock kit item that is associated with this component plan. | ||||
LastModifiedByID | uniqueidentifier | Last Modified By | Users | |
Description:No description available | ||||
LastModifiedByScreenID | char(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. | INLotSerialStatusByCostCenter | |
Description:No description available | ||||
Operation | char(1) | - | ||
Description:No description available | ||||
OrigNoteID | uniqueidentifier | - | ||
Description:No description available | ||||
OrigPlanID | bigint | INItemPlanOrig | ||
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 | ||||
POOrderNbr | nvarchar(15) | - | ||
Description:No description available | ||||
POOrderType | char(2) | - | ||
Description:No description available | ||||
ParentExcludeFromMRP | bit | Parent Item Exclude from MRP | - | |
Description:AMMrpProdMatl.excludeFromMRP = AMProdItem.excludeFromMRP | ||||
PlanDate | datetime | Planned On | - | |
Description:No description available | ||||
PlanID | bigint | - | ||
Description:No description available | ||||
PlanQty | decimal | Planned Qty. | - | |
Description:No description available | ||||
PlanType | char(2) | Plan Type | INPlanType | |
Description:No description available | ||||
ProdItemCompleted | bit | Completed | - | |
Description:AMProdItem.Completed | ||||
ProdItemInventoryID | int | Production Inventory ID | - | |
Description:AMMrpProdMatl.ProdItemInventoryID = AMProdItem.inventoryID | ||||
ProdItemOrderType | nvarchar | - | ||
Description:No description available | ||||
ProdItemProdOrdID | nvarchar | - | ||
Description:No description available | ||||
ProdItemSubItemID | int | - | ||
Description:AMMrpProdMatl.prodItemsubItemID = AMProdItem.subItemID | ||||
ProdMatlOperationCD | nvarchar | - | ||
Description:No description available | ||||
ProdMatlOrderType | nvarchar | - | ||
Description:No description available | ||||
ProdMatlProdOrdID | nvarchar | - | ||
Description:No description available | ||||
ProjectID | int | - | ||
Description:No description available | ||||
RefEntityType | varchar(255) | - | ||
Description:No description available | ||||
RefNoteID | uniqueidentifier | - | ||
Description:No description available | ||||
RequestDate | datetime | - | ||
Description:SOLine.RequestDate | ||||
Reverse | bit | Reverse | - | |
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 | ||||
SelectedNonexistent in DB | bool? | Selected | - | |
Description:No description available | ||||
SiteID | int | Warehouse | INSite | |
Description:No description available | ||||
SourceSiteID | int | Warehouse | INSite | |
Description:No description available | ||||
StatusID | char(1) | Production Order Status | - | |
Description:AMProdItem.StatusID | ||||
StkItem | bit | - | ||
Description:When set to "true", indicates that this item is a Stock Item. | ||||
SubItemID | int | Subitem | INSubItem | |
Description:No description available | ||||
SupplyPlanID | bigint | INItemPlanSupply | ||
Description:No description available | ||||
TaskID | int | - | ||
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 | ||||
tstamp | timestamp | - | ||
Description:No description available | ||||