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 | Actual Base Qty. | - | |
Description:No description available | ||||
BaseQtyRemainingNonexistent in DB | decimal? | Remaining Base Qty. | - | |
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 Material Line Nbr. | - | |
Description:No description available | ||||
PhtmMatlOperationID | int | Phantom Material 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 | Actual Qty. | - | |
Description:No description available | ||||
QtyRemainingNonexistent in DB | decimal? | Remaining Qty. | - | |
Description:No description available | ||||
QtyReq | decimal | Required Qty. | - | |
Description:No description available | ||||
QtyReqWithScrapNonexistent in DB | decimal? | Required Qty. with Scrap | - | |
Description:Qty Required with Scrap Factor worked in | ||||
QtyRoundUp | bit | Round Qty. 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 | ||||