AM
BomWhereUsedDetail
Where used inquiry detail
View API Entity: ItemWhereUsedRow
/entity/MANUFACTURING/25.100.001/ItemWhereUsedRow| Field Name | Type | Display Name | Foreign Key | |
|---|---|---|---|---|
BFlush | bit | Backflush Materials | - | |
Description:A Boolean value that indicates whether the the user needs to release the material manually. | ||||
BOMID API | nvarchar(15) | BOM ID | AMBomOper | |
Description:The identifier of the bill of material. | ||||
BOMSiteIDNonexistent in DB | int? | BOM Warehouse | INSite | |
Description:No description available | ||||
BOMStatusNonexistent in DB | string | Revision Status | - | |
Description:No description available | ||||
BaseQty | decimal | Base Qty | - | |
Description:The base quantity. | ||||
BatchSize API | decimal | Batch Size | - | |
Description:The additional parameter that you can use to flexibly set up the required material quantity. The system uses this value to calculate the final quantity of the material. | ||||
BubbleNbr | nvarchar(10) | Bubble Nbr | - | |
Description:The number of the material on the engineering drawing that relates to the BOM. | ||||
CompBOMID | nvarchar(15) | Comp BOM ID | AMBomItemActive | |
Description:The subassembly's bill of materials used for production. | ||||
CompBOMRevisionID | nvarchar(10) | Comp BOM Revision | AMBomItem | |
Description:The revision of the BOM that is specified in CompBOMID. | ||||
CompEffDateObsolete | datetime | 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:The description of the inventory item. | ||||
string | Description | - | ||
Description:No description available | ||||
EffDate | datetime | Effective Date | - | |
Description:The date when the system starts using the material for the item production. | ||||
EffEndDateNonexistent in DB | DateTime? | Revision End Date | - | |
Description:No description available | ||||
EffStartDateNonexistent in DB | DateTime? | Revision Start Date | - | |
Description:No description available | ||||
ExpDate | datetime | Expiration Date | - | |
Description:The date when the system stops using the material for the item production. | ||||
InventoryID API | int | Inventory ID | InventoryItem | |
Description:The identifier of the item used as a material. | ||||
IsStockItem API | bit | Is stock | - | |
Description:A Boolean value that indicates whether the material is a stock item. | ||||
int? | Item Class | INItemClass | ||
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 | ||||
int? | Level | - | ||
Description:No description available | ||||
LineCntrRef | int | - | ||
Description:AMBomRef line counter | ||||
LineID | int | Line Nbr. | - | |
Description:The line ID, which is an autoincremental number. | ||||
LineNbrNonexistent in DB | int? | Line Nbr. 2 | - | |
Description:The line number. | ||||
LocationID | int | Location | INLocation | |
Description:The warehouse location from which the material is issued. | ||||
MaterialType | int | Material Type | - | |
Description:The type of the material. | ||||
NoteID | uniqueidentifier | - | ||
Description:No description available | ||||
OperationID | int | Operation ID | AMBomOper | |
Description:The numeric identifier of the operation. | ||||
OriginalTreeNodeIDNonexistent in DB | string | Original Tree Node | - | |
Description:The original tree node. | ||||
string | Parent Desc. | - | ||
Description:No description available | ||||
ParentInventoryID API | int | Parent Inventory ID | - | |
Description:No description available | ||||
int? | Parent Item Class | INItemClass | ||
Description:No description available | ||||
ParentSubItemID API | int | Parent Subitem | INSubItem | |
Description:No description available | ||||
PhantomRouting | int | Phantom Routing | - | |
Description:The way of adding operations of the material that is a phantom subassembly to production orders based on the BOM. | ||||
PlanCostNonexistent in DB | decimal? | Planned Cost | - | |
Description:The planned cost of the inventory item. | ||||
QtyReq | decimal | Qty Required | - | |
Description:The material quantity needed to produce the item. | ||||
decimal? | Qty Required | - | ||
Description:No description available | ||||
RevisionID API | nvarchar(10) | Revision | AMBomItem | |
Description:The identifier of the BOM revision, which is the modification of the bill of material. | ||||
RowStatus | int | Change Status | - | |
Description:The change status. | ||||
ScrapFactor | decimal | Scrap Factor | - | |
Description:The scrap or shrinkage factor for the material. | ||||
SelectedNonexistent in DB | bool? | Selected | - | |
Description:No description available | ||||
int? | Sequence | - | ||
Description:Keep track of the records being inserted into the rows for display/sort order | ||||
SiteID API | int | Warehouse | INSite | |
Description:The warehouse from which the material is issued. | ||||
SortOrder | int | Line Order | - | |
Description:The sorting order. | ||||
string | - | |||
Description:No description available | ||||
SubItemID API | int | Subitem | INSubItem | |
Description:The subitem of the inventory item. | ||||
SubcontractSource | int | Subcontract Source | - | |
Description:The source of the material. | ||||
UOM API | nvarchar(6) | UOM | INUnit | |
Description:The unit of measure for the quantity specified in QtyReq. | ||||
UnitCost | decimal | Unit Cost | - | |
Description:The unit cost for the material. | ||||
tstamp | timestamp | - | ||
Description:No description available | ||||