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 |