AM
AMEstimateMatl
PX.Objects.AM38 of 38 fields
| Field Name | Type | Display Name | Foreign Key | |
|---|---|---|---|---|
EstimateID | nvarchar(15) | Estimate ID | - | |
Description:No description available | ||||
LineID | int | Line Nbr. | - | |
Description:No description available | ||||
OperationID | int | Operation ID | AMEstimateOper | |
Description:No description available | ||||
RevisionID | nvarchar(10) | Revision | AMEstimateItem | |
Description:No description available | ||||
BackFlush | bit | Backflush Materials | - | |
Description:No description available | ||||
BaseOrderQtyNonexistent in DB | decimal | Base Order Qty. | - | |
Description:No description available | ||||
BaseQtyReq | decimal(25, 6) | Base Qty Req | - | |
Description:No description available | ||||
BaseTotalQtyRequired | decimal(25, 6) | Base Total Required | - | |
Description:No description available | ||||
BatchSize | decimal(25, 6) | 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 | ||||
InventoryCD | nvarchar(30) | Inventory ID | InventoryItem | |
Description:No description available | ||||
InventoryID | int | Inventory ID | InventoryItem | |
Description:No description available | ||||
IsNonInventory | bit | Non-Inventory | - | |
Description:No description available | ||||
ItemClassID | int | Item Class | INItemClass | |
Description:No description available | ||||
ItemDesc | 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 | ||||
LineNbrNonexistent in DB | int | Line Nbr. 2 | - | |
Description:No description available | ||||
LocationID | int | Location | INLocation | |
Description:No description available | ||||
MaterialOperCost | decimal(19, 6) | Total Cost | - | |
Description:No description available | ||||
MaterialType | int | Material Type | - | |
Description:No description available | ||||
NoteID | uniqueidentifier | - | ||
Description:No description available | ||||
PhantomRouting | int | Phantom Routing | - | |
Description:No description available | ||||
QtyReq | decimal(25, 6) | Qty Required | - | |
Description:No description available | ||||
QtyReqWithScrapNonexistent in DB | decimal | Qty Required with Scrap | - | |
Description:No description available | ||||
QtyRoundUp | bit | Qty Round Up | - | |
Description:No description available | ||||
ScrapFactor | decimal(19, 6) | Scrap Factor | - | |
Description:No description available | ||||
SiteID | int | Warehouse | INSite | |
Description:No description available | ||||
SortOrder | int | Line Order | - | |
Description:No description available | ||||
SubcontractSource | int | Subcontract Source | - | |
Description:No description available | ||||
SubItemID | int | Subitem | INSubItem | |
Description:No description available | ||||
TotalQtyRequired | decimal(25, 6) | Total Required | - | |
Description:No description available | ||||
tstamp | timestamp | - | ||
Description:No description available | ||||
UnitCost | decimal(19, 6) | Unit Cost | - | |
Description:No description available | ||||
UOM | nvarchar(6) | UOM | INUnit | |
Description:No description available | ||||