AM
AMBomMatl
PX.Objects.AM41 of 41 fields
| Field Name | Type | Display Name | Foreign Key | |
|---|---|---|---|---|
BOMID | nvarchar(15) | BOM ID | - | |
Description:No description available | ||||
LineID | int | Line Nbr. | - | |
Description:No description available | ||||
OperationID | int | Operation ID | AMBomOper | |
Description:No description available | ||||
RevisionID | nvarchar(10) | Revision | AMBomItem | |
Description:No description available | ||||
BaseQty | decimal(25, 6) | Base Qty | - | |
Description:No description available | ||||
BatchSize | decimal(25, 6) | Batch Size | - | |
Description:No description available | ||||
BFlush | bit | Backflush Materials | - | |
Description:No description available | ||||
BubbleNbr | nvarchar(10) | Bubble Nbr | - | |
Description:No description available | ||||
CompBOMID | nvarchar(15) | Comp BOM ID | AMBomItem | |
Description:No description available | ||||
CompBOMRevisionID | nvarchar(10) | Comp BOM Revision | AMBomItem | |
Description:No description available | ||||
CompEffDateObsolete | datetime2 | Obsolete Comp BOM Eff Date | - | |
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 | ||||
Descr | nvarchar(256) | Description | - | |
Description:No description available | ||||
EffDate | datetime2 | Effective Date | - | |
Description:No description available | ||||
ExpDate | datetime2 | Expiration Date | - | |
Description:No description available | ||||
InventoryID | int | Inventory ID | InventoryItem | |
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 | ||||
LineCntrRef | int | - | ||
Description:No description available | ||||
LineNbrNonexistent in DB | int | Line Nbr. 2 | - | |
Description:No description available | ||||
LocationID | int | Location | INLocation | |
Description:No description available | ||||
MaterialType | int | Material Type | - | |
Description:No description available | ||||
NoteID | uniqueidentifier | - | ||
Description:No description available | ||||
OriginalTreeNodeIDNonexistent in DB | nvarchar(MAX) | Original Tree Node | - | |
Description:No description available | ||||
PhantomRouting | int | Phantom Routing | - | |
Description:No description available | ||||
PlanCostNonexistent in DB | decimal | Planned Cost | - | |
Description:No description available | ||||
QtyReq | decimal(25, 6) | Qty Required | - | |
Description:No description available | ||||
RowStatus | int | Change Status | - | |
Description:No description available | ||||
ScrapFactor | decimal(19, 6) | Scrap Factor | - | |
Description:No description available | ||||
SelectedNonexistent in DB | bit | Selected | - | |
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 | ||||
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 | ||||