AM
AMPlanMaterial
AMProdMatl with additional reference fields
| 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 | ||||
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 | - | |
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 | ||||
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 | ||||
ParentInventoryID | int | - | ||
Description:No description available | ||||
ParentSubItemID | int | - | ||
Description:No description available | ||||
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 | ||||
PlanDate | datetime | - | ||
Description:The date the material is needed | ||||
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 | ||||
ProductInventoryID | int | - | ||
Description:No description available | ||||
ProductSubItemID | int | - | ||
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 | ||||
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 | ||||
tstamp | timestamp | - | ||
Description:No description available | ||||