AM
AMProdMatlInventory
Projection to select all AMProdMatl fields with some InventoryItem and AMProdOper fields which otherwise when joined would cause sub query to InventoryItem after the main join query (based on some attributes on Inventory Item)
| Field Name | Type | Display Name | Foreign Key | |
|---|---|---|---|---|
BFlush | bit | Backflush Materials | - | |
Description:Determine whether user need to release material manually or not | ||||
BaseOperTotalQtyNonexistent in DB | decimal? | Base Order Qty. | - | |
Description:Operation AMProdOper.BaseTotalQty to drive total material required qty. | ||||
BaseQtyActual | decimal | Base Qty Actual | - | |
Description:No description available | ||||
BaseQtyRemainingNonexistent in DB | decimal? | Base Qty Remaining | - | |
Description:No description available | ||||
BaseTotalQtyRequired | decimal | Base Total Required | - | |
Description:No description available | ||||
BatchSize | decimal | Batch Size | - | |
Description:No description available | ||||
CompBOMID | nvarchar(15) | Comp BOM ID | AMBomItemActive | |
Description:No description available | ||||
CompBOMRevisionID | nvarchar(10) | Comp BOM Revision | AMBomItem | |
Description:No description available | ||||
CostCenterID | int | - | ||
Description:Cost center id selected project, task and warehouse | ||||
CreatedByID | uniqueidentifier | Created By | Users | |
Description:No description available | ||||
CreatedByScreenID | char(8) | - | ||
Description:No description available | ||||
CreatedDateTime | datetime | - | ||
Description:No description available | ||||
Descr | nvarchar(256) | Description | - | |
Description:No description available | ||||
ExpireDate | datetime | Expiration Date | - | |
Description:No description available | ||||
InventoryCD | nvarchar | Inventory CD | InventoryItem | |
Description:No description available | ||||
InventoryID | int | Inventory ID | InventoryItem | |
Description:No description available | ||||
InventorySource | char(1) | Inventory Source | - | |
Description:The source of material for a transaction line. | ||||
InvtMult | smallint | - | ||
Description:No description available | ||||
IsByproductNonexistent in DB | bool? | By-product | - | |
Description:No description available | ||||
IsFixedMaterialNonexistent in DB | bool? | Fixed Material | - | |
Description:No description available | ||||
IsStockItem | bit | Is Stock Item | - | |
Description:No description available | ||||
ItemClassID | int | Item Class | INItemClass | |
Description:No description available | ||||
ItemDescr | nvarchar(256) | Item Description | - | |
Description:The description of the Inventory Item. | ||||
ItemStatus | char(2) | Item Status | - | |
Description:No description available | ||||
LastModifiedByID | uniqueidentifier | Last Modified By | Users | |
Description:No description available | ||||
LastModifiedByScreenID | char(8) | - | ||
Description:No description available | ||||
LastModifiedDateTime | datetime | - | ||
Description:No description available | ||||
LineID | int | Line Nbr. | - | |
Description:No description available | ||||
LineNbrNonexistent in DB | int? | Line Nbr | - | |
Description:No description available | ||||
LineQtyAvailNonexistent in DB | decimal? | - | ||
Description:No description available | ||||
LineQtyHardAvailNonexistent in DB | decimal? | - | ||
Description:No description available | ||||
LocationID | int | Location | INLocation | |
Description:Material location | ||||
LotSerialNbr | nvarchar(100) | Lot/Serial Nbr. | INLotSerialStatusByCostCenter | |
Description:No description available | ||||
MaterialType | int | Material Type | - | |
Description:No description available | ||||
NoteID | uniqueidentifier | - | ||
Description:No description available | ||||
OperationCD | nvarchar(10) | Operation ID | - | |
Description:No description available | ||||
OperationID | int | Operation ID | AMProdOper | |
Description:No description available | ||||
OrderType | char(2) | Order Type | AMOrderType | |
Description:No description available | ||||
POCreate | bit | Mark for PO | - | |
Description:No description available | ||||
POLinkEnableNonexistent in DB | bool? | - | ||
Description:State of the PO Link action on Production Material grid | ||||
PhantomRouting | int | Phantom Routing | - | |
Description:No description available | ||||
PhtmBOMID | char(15) | Phantom BOM ID | - | |
Description:No description available | ||||
PhtmBOMLineRef | int | Phantom BOM Ref Line Nbr | - | |
Description:No description available | ||||
PhtmBOMOperationID | int | Phantom Operation ID | - | |
Description:No description available | ||||
PhtmBOMRevisionID | nvarchar(10) | Phantom BOM Revision | - | |
Description:No description available | ||||
PhtmLevel | int | Phantom Level | - | |
Description:No description available | ||||
PhtmMatlBOMID | char(15) | Phantom Matl BOM ID | - | |
Description:No description available | ||||
PhtmMatlLineRef | int | Phantom Matl Line Nbr | - | |
Description:No description available | ||||
PhtmMatlOperationID | int | Phantom Matl Operation ID | - | |
Description:No description available | ||||
PhtmMatlRevisionID | nvarchar(10) | Phantom Matl Revision | - | |
Description:No description available | ||||
PlanCostNonexistent in DB | decimal? | Planned Cost | - | |
Description:No description available | ||||
ProdCreate | bit | Mark for Production | - | |
Description:No description available | ||||
ProdLinkEnableNonexistent in DB | bool? | - | ||
Description:State to enable/disable Link Production Order in the grid | ||||
ProdOrdID | nvarchar(19) | Production Nbr. | AMProdItem | |
Description:No description available | ||||
ProjectID | int | Project | - | |
Description:Project/Task is not implemented for Manufacturing. Requirement for the class that implements ILSPrimary/ILSMaster | ||||
QtyActual | decimal | Qty Actual | - | |
Description:No description available | ||||
QtyRemainingNonexistent in DB | decimal? | Qty Remaining | - | |
Description:No description available | ||||
QtyReq | decimal | Qty Required | - | |
Description:No description available | ||||
QtyReqWithScrapNonexistent in DB | decimal? | Qty Required with Scrap | - | |
Description:Qty Required with Scrap Factor worked in | ||||
QtyRoundUp | bit | Qty Round Up | - | |
Description:No description available | ||||
ScrapFactor | decimal | Scrap Factor | - | |
Description:No description available | ||||
SiteID | int | Warehouse | INSite | |
Description:No description available | ||||
SortOrder | int | Line Order | - | |
Description:No description available | ||||
SplitLineCntr | int | - | ||
Description:No description available | ||||
StatusID | char(1) | Material Status | - | |
Description:No description available | ||||
StkItem | bit | Stock Item | - | |
Description:No description available | ||||
SubItemID | int | Subitem | INSubItem | |
Description:No description available | ||||
SubcontractSource | int | Subcontract Source | - | |
Description:No description available | ||||
TaskID | int | Task | - | |
Description:Project/Task is not implemented for Manufacturing. Requirement for the class that implements ILSPrimary/ILSMaster | ||||
TotActCost | decimal | Total Actual Cost | - | |
Description:No description available | ||||
TotalQtyRequired | decimal | Total Required | - | |
Description:No description available | ||||
TranDate | datetime | Tran Date | - | |
Description:No description available | ||||
TranType | char(3) | Tran. Type | - | |
Description:No description available | ||||
UOM | nvarchar(6) | UOM | INUnit | |
Description:No description available | ||||
UnassignedQty | decimal | - | ||
Description:No description available | ||||
UnitCost | decimal | Unit Cost | - | |
Description:No description available | ||||
UpdateProjectNonexistent in DB | bool? | - | ||
Description:Optionally copied Update Project value from AMProdItem.UpdateProject | ||||
VendorID | int | Vendor | BAccountR | |
Description:No description available | ||||
WarehouseOverride | bit | Warehouse Override | - | |
Description:No description available | ||||
WcID | nvarchar(20) | Work Center | AMWC | |
Description:No description available | ||||
tstamp | timestamp | - | ||
Description:No description available | ||||