AM
AMProdMatl
Maintenance table for the materials on a production order operation on the Production Order Details (AM209000) form (corresponding to the ProdDetail graph). Parent: AMProdItem, AMProdOper
View API Entity: OrderMaterialDetail
/entity/MANUFACTURING/25.100.001/OrderMaterialDetail| Field Name | Type | Display Name | Foreign Key | |
|---|---|---|---|---|
BFlush API | 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 API | decimal | Batch Size | - | |
Description:No description available | ||||
CompBOMID API | nvarchar(15) | Comp BOM ID | AMBomItemActive | |
Description:No description available | ||||
CompBOMRevisionID API | 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 API | nvarchar(256) | Description | - | |
Description:No description available | ||||
ExpireDate | datetime | Expiration Date | - | |
Description:No description available | ||||
InventoryID API | 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 | ||||
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 API | 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 API | int | Location | INLocation | |
Description:Material location | ||||
LotSerialNbr | nvarchar(100) | Lot/Serial Nbr. | INLotSerialStatusByCostCenter | |
Description:No description available | ||||
MaterialType API | 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 API | 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 API | char(15) | Phantom BOM ID | - | |
Description:No description available | ||||
PhtmBOMLineRef API | int | Phantom BOM Ref Line Nbr | - | |
Description:No description available | ||||
PhtmBOMOperationID API | int | Phantom Operation ID | - | |
Description:No description available | ||||
PhtmBOMRevisionID | nvarchar(10) | Phantom BOM Revision | - | |
Description:No description available | ||||
PhtmLevel API | int | Phantom Level | - | |
Description:No description available | ||||
PhtmMatlBOMID | char(15) | Phantom Matl BOM ID | - | |
Description:No description available | ||||
PhtmMatlLineRef API | int | Phantom Matl Line Nbr | - | |
Description:No description available | ||||
PhtmMatlOperationID API | int | Phantom Matl Operation ID | - | |
Description:No description available | ||||
PhtmMatlRevisionID | nvarchar(10) | Phantom Matl Revision | - | |
Description:No description available | ||||
decimal? | Planned Cost | - | ||
Description:No description available | ||||
ProdCreate API | 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 API | decimal | Qty Actual | - | |
Description:No description available | ||||
decimal? | Qty Remaining | - | ||
Description:No description available | ||||
QtyReq API | decimal | Qty Required | - | |
Description:No description available | ||||
QtyReqWithScrapNonexistent in DB | decimal? | Qty Required with Scrap | - | |
Description:Qty Required with Scrap Factor worked in | ||||
QtyRoundUp API | bit | Qty Round Up | - | |
Description:No description available | ||||
ScrapFactor API | decimal | Scrap Factor | - | |
Description:No description available | ||||
SiteID API | int | Warehouse | INSite | |
Description:No description available | ||||
SortOrder API | int | Line Order | - | |
Description:No description available | ||||
SplitLineCntr | int | - | ||
Description:No description available | ||||
StatusID API | char(1) | Material Status | - | |
Description:No description available | ||||
SubItemID API | int | Subitem | INSubItem | |
Description:No description available | ||||
SubcontractSource API | 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 API | decimal | Total Actual Cost | - | |
Description:No description available | ||||
TotalQtyRequired API | 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 API | nvarchar(6) | UOM | INUnit | |
Description:No description available | ||||
UnassignedQty | decimal | - | ||
Description:No description available | ||||
UnitCost API | 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 API | bit | Warehouse Override | - | |
Description:No description available | ||||
tstamp | timestamp | - | ||
Description:No description available | ||||