Easily find this page again using the shortlink: https://gpt.azrcrv.co.uk/BM010300
Product: Manufacturing (346)
Series:
Display Name: Bill Of Materials Log File Group Display Name: Manufacturing BOM
Physical Name: BM010300
Technical Name: BOM_Log
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 | ITEMNMBR | Item Number | String | STR30_Item_Number | 30 | |
Key to the Item Master (IV00101).
Click to show/hideSELECT
['Bill Of Materials Log File'].ITEMNMBR AS 'Bill Of Materials Log File-Item Number'
,['Item Master'].ITEMNMBR AS 'Item Master-Item Number'
FROM
BM010300 AS ['Bill Of Materials Log File']
INNER JOIN
IV00101 AS ['Item Master']
ON
['Bill Of Materials Log File'].ITEMNMBR = ['Item Master'].ITEMNMBR | ||||||
3 | CHANGENUMBER_I | Change Number | Integer | INT5 | 4 | |
4 | DESCRIPTIN50 | IC_Description | String | STR50 | 50 | |
5 | UNIT_I | Unit | String | STR10_U | 10 | |
6 | ADDCHG_I | Add Chg | String | STR15 | 15 | |
7 | DATE1 | Date | Date | DT6 | 6 | |
8 | TIME1 | Time | Time | TM6 | 6 | |
9 | QUANTITY_I | Quantity | Currency | DLR12_RBN_UT2 | 12 | |
10 | OPTPERCENT_I | OPT Percent | Long Integer | INTXXX.X% | 4 | |
11 | SCRAPPERCENT_I | Scrap Percent | Long Integer | INTXXX.X% | 4 | |
12 | ALTERNATE_I | Alternate | Boolean | CB | 0 | |
13 | ALTERNATEPARTFOR_I | Alternate Part For | String | STR30_Item_Number | 30 | |
14 | LEADTIMEOFFSET_I | Lead Time Offset | Currency | DLR_10_3 | 18 | |
15 | BOMUSERDEF1_I | BOM User Def1 | String | STR30 | 30 | |
16 | BOMUSERDEF2_I | BOM User Def2 | String | STR_30 | 30 | |
17 | BOMSINGLELOT_I | BOM_Single_Lot | Boolean | CB | 0 | |
18 | BOMENGAPPROVAL_I | BOM_Eng_Approval | Boolean | CB | 0 | |
19 | WCID_I | WC ID | String | STR10_Location_Code | 10 |