AM
AMEstimateMatl
Maintenance table for the materials on an estimate operation on the Estimate Operations (AM304000) form (corresponding to the EstimateOperMaint graph). Parent: AMEstimateItem, AMEstimateOper
View API Entity: EstimateMaterialDetail
/entity/MANUFACTURING/25.100.001/EstimateMaterialDetail| Field Name | Type | Display Name | Foreign Key | |
|---|---|---|---|---|
BackFlush API | bit | Backflush Materials | - | |
Description:Determine whether user need to release material manually or not | ||||
BaseOrderQtyNonexistent in DB | decimal? | Base Order Qty. | - | |
Description:No description available | ||||
BaseQtyReq | decimal | Base Qty Req | - | |
Description:No description available | ||||
BaseTotalQtyRequired | decimal | Base Total Required | - | |
Description:No description available | ||||
BatchSize API | decimal | Batch Size | - | |
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 | ||||
EstimateID | nvarchar(15) | Estimate ID | AMEstimateOper | |
Description:No description available | ||||
InventoryCD API | nvarchar | Inventory ID | InventoryItem | |
Description:No description available | ||||
InventoryID | int | Inventory ID | InventoryItem | |
Description:No description available | ||||
IsNonInventory API | bit | Non-Inventory | - | |
Description:No description available | ||||
ItemClassID API | int | Item Class | INItemClass | |
Description:No description available | ||||
ItemDesc API | nvarchar(256) | Description | - | |
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. 2 | - | |
Description:No description available | ||||
LocationID | int | Location | INLocation | |
Description:No description available | ||||
MaterialOperCost API | decimal | Total Cost | - | |
Description:No description available | ||||
MaterialType API | int | Material Type | - | |
Description:No description available | ||||
NoteID | uniqueidentifier | - | ||
Description:No description available | ||||
OperationID | int | Operation ID | AMEstimateOper | |
Description:No description available | ||||
PhantomRouting API | int | Phantom Routing | - | |
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 | ||||
RevisionID | nvarchar(10) | Revision | AMEstimateItem | |
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 | ||||
SubItemID API | int | Subitem | INSubItem | |
Description:No description available | ||||
SubcontractSource API | int | Subcontract Source | - | |
Description:No description available | ||||
TotalQtyRequired API | decimal | Total Required | - | |
Description:No description available | ||||
UOM API | nvarchar(6) | UOM | INUnit | |
Description:No description available | ||||
UnitCost API | decimal | Unit Cost | - | |
Description:No description available | ||||
tstamp | timestamp | - | ||
Description:No description available | ||||