Easily find this page again using the shortlink: https://gpt.azrcrv.co.uk/BM010115
Product: Manufacturing (346)
Series:
Display Name: Bill Of Material Line File Group Display Name: Manufacturing BOM
Physical Name: BM010115
Technical Name: BOM_Line
Group Technical Name: Manufacturing BOM
| Seq No | Physical Name | Display Name | Dexterity Data Type | SQL Data Type | Length | |
|---|---|---|---|---|---|---|
| 1 | PPN_I  | PPN | String | STR30_UC | 30 | |
| 2 | CPN_I | CPN | String | STR30_Item_Number | 30 | |
| 3 | BOMCAT_I | BOM Cat | Integer | DDL_BOM_Cat | 0 | |
| 4 | BOMNAME_I | BOM Name | String | STR15_LBU | 15 | |
| 5 | BOMTYPE_I | BOM Type | Integer | DDL_BOM_Type | 0 | |
| 6 | BOMSEQ_I | BOM Seq | Long Integer | LINT_10 | 10 | |
| 7 | POSITION_NUMBER | Position Number | Integer | INT4_RB_U0 | 4 | |
| 8 | SUBCAT_I | Sub Cat | Integer | DDL_BOM_Cat | 0 | |
| 9 | SUBNAME_I | Sub Name | String | STR15_LBU | 15 | |
| 10 | SUB_REV_LEVEL_SEQ_I | Sub Revision Level Sequence | Long Integer | LINT_10 | 10 | |
| 11 | QUANTITY_I | Quantity | Currency | DLR12_RBN_UT2 | 12 | |
| 12 | OPTPERCENT_I | OPT Percent | Long Integer | INTXXX.X% | 4 | |
| 13 | SCRAPPERCENT_I | Scrap Percent | Long Integer | INTXXX.X% | 4 | |
| 14 | FLOORSTOCK_I | Floor Stock | Boolean | CB | 0 | |
| 15 | EFFECTIVEINDATE_I | Effective In Date | Date | DT | 8 | |
| 16 | EFFECTIVEOUTDATE_I | Effective Out Date | Date | DT | 8 | |
| 17 | ALTERNATE_I | Alternate | Boolean | CB | 0 | |
| 18 | ALTERNATEPARTFOR_I | Alternate Part For | String | STR30_Item_Number | 30 | |
| 19 | ALT_FOR_BOM_SEQ_I | Alt For BOM Seq | Long Integer | LINT_10 | 10 | |
| 20 | LEADTIMEOFFSET_I | Lead Time Offset | Currency | DLR_10_3 | 18 | |
| 21 | LEADTIMEOFFSETINC_I | Lead Time Offset Inc | Integer | DDL_Increment | 0 | |
| 22 | BOMUSERDEF1_I | BOM User Def1 | String | STR30 | 30 | |
| 23 | BOMUSERDEF2_I | BOM User Def2 | String | STR_30 | 30 | |
| 24 | BOMSINGLELOT_I | BOM_Single_Lot | Boolean | CB | 0 | |
| 25 | BOMENGAPPROVAL_I | BOM_Eng_Approval | Boolean | CB | 0 | |
| 26 | WCID_I | WC ID | String | STR10_Location_Code | 10 | |
| 27 | LOCNCODE | Location Code | String | STR10_Location_Code | 10 | |
Key to the Site Setup (IV40700).
Click to show/hideSELECT
['Bill Of Material Line File'].LOCNCODE AS 'Bill Of Material Line File-Location Code'
,['Site Setup'].LOCNCODE AS 'Site Setup-Location Code'
FROM
BM010115 AS ['Bill Of Material Line File']
INNER JOIN
IV40700 AS ['Site Setup']
ON
['Bill Of Material Line File'].LOCNCODE = ['Site Setup'].LOCNCODE | ||||||
| 28 | BACKFLUSHITEM_I | Backflush Item | Boolean | CB_Backflush Item | 0 | |
| 29 | CHANGEDATE_I | Change Date | Date | DT | 8 | |
| 30 | USERID | User ID | String | STR15_User_ID | 15 | |
Key to the Users Master (SY01400).
Click to show/hideSELECT
['Bill Of Material Line File'].USERID AS 'Bill Of Material Line File-User ID'
,['Users Master'].USERID AS 'Users Master-User ID'
FROM
BM010115 AS ['Bill Of Material Line File']
INNER JOIN
DYNAMICS..SY01400 AS ['Users Master']
ON
['Bill Of Material Line File'].USERID = ['Users Master'].USERID | ||||||
| 31 | OPTIONED_ITEM_I | Optioned Item | Boolean | CB | 0 | |
| 32 | ACTUAL_CONSUMED_CHECK_I | Actual Consumed Check | Boolean | CB | 0 | |
| 33 | FIXED_QTY_I | Fixed Quantity | Currency | DLR17_QTY_RBS0_UTR | 17 | |
| 34 | UOFM | U Of M | String | U_Of_M | 8 | |
| 35 | U_Of_M_2 | U Of M 2 | String | U_Of_M | 8 | |
| 36 | QTYBSUOM | QTY In Base U Of M | Currency | DLR17_QTY_RBS0_STR | 17 | |
| 37 | OFFSET_FROM_I | Offset From | Integer | DDL_Offset_From | 0 | |
| 38 | MFGNOTEINDEX_I | MFG Note Index | Currency | DLR14 | 14 | |
| 39 | MFGNOTEINDEX2_I | MFG Note Index2 | Currency | DLR14 | 14 | |