IN
INItemPlanOrig
An alias for Original Inventory Plan (INItemPlan) which can be used for building complex BQL queries.
| Field Name | Type | Display Name | Foreign Key | |
|---|---|---|---|---|
ActiveNonexistent in DB | bool? | Active | - | |
Description:No description available | ||||
BAccountID | int | BAccount | ||
Description:No description available | ||||
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 | ||||
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: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. | ||||
IsTempLotSerialNonexistent in DB | bool? | - | ||
Description:No description available | ||||
IsTemporaryNonexistent in DB | bool? | - | ||
Description:The flag indicates if the record is not for persistence | ||||
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 | ||||
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 | ||||
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 | ||||
ProjectID | int | - | ||
Description:No description available | ||||
RefEntityType | varchar(255) | - | ||
Description:No description available | ||||
RefNoteID | uniqueidentifier | - | ||
Description:No description available | ||||
Reverse | bit | Reverse | - | |
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 | ||||
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 | ||||