pref_bom_user (BMPF0114)

Easily find this page again using the shortlink: https://gpt.azrcrv.co.uk/BMPF0114

Product: Manufacturing (346)
Series:

Display Name: pref_bom_user
Physical Name: BMPF0114
Technical Name: pref_bom_user

Group Display Name: Manufacturing BOM
Group Technical Name: Manufacturing BOM

Seq NoPhysical NameDisplay NameDexterity Data TypeSQL Data TypeLength
1CMPANYID SearchCompany IDIntegerINT54
Key to the Company Master (SY01500).

Click to show/hide

SELECT
       ['pref_bom_user'].CMPANYID AS 'pref_bom_user-Company ID'
       ,['Company Master'].CMPANYID AS 'Company Master-Company ID'
FROM
       BMPF0114 AS ['pref_bom_user']
INNER JOIN
       DYNAMICS..SY01500 AS ['Company Master']
              ON
                     ['pref_bom_user'].CMPANYID = ['Company Master'].CMPANYID
2USERID SearchUser IDStringSTR15_User_ID15
Key to the Users Master (SY01400).

Click to show/hide

SELECT
       ['pref_bom_user'].USERID AS 'pref_bom_user-User ID'
       ,['Users Master'].USERID AS 'Users Master-User ID'
FROM
       BMPF0114 AS ['pref_bom_user']
INNER JOIN
       DYNAMICS..SY01400 AS ['Users Master']
              ON
                     ['pref_bom_user'].USERID = ['Users Master'].USERID
3BOMSCROLLDEF1_I_1 SearchBOM Scroll Def 1[1]BooleanCB0
4BOMSCROLLDEF1_I SearchBOM Scroll Def 1CBBoolean0
5BOMSCROLLDEF2_I SearchBOM Scroll Def 2CBBoolean0
6BOMSCROLLDEF1_I_2 SearchBOM Scroll Def 1[2]BooleanCB0
7BOMSCROLLLABEL_I SearchBOM Scroll LabelSTR20String20
8BOMSCROLLDEF1_I_3 SearchBOM Scroll Def 1[3]BooleanCB0
9BOMSCROLLDEF1_I_4 SearchBOM Scroll Def 1[4]BooleanCB0
10BOMSCROLLDEF1_I_5 SearchBOM Scroll Def 1[5]BooleanCB0
11BOMSCROLLDEF1_I_6 SearchBOM Scroll Def 1[6]BooleanCB0
12BOMSCROLLDEF1_I_7 SearchBOM Scroll Def 1[7]BooleanCB0
13BOMSCROLLDEF1_I_8 SearchBOM Scroll Def 1[8]BooleanCB0
14BOMSCROLLDEF1_I_9 SearchBOM Scroll Def 1[9]BooleanCB0
15BOMSCROLLDEF1_I_10 SearchBOM Scroll Def 1[10]BooleanCB0
16BOMSCROLLDEF1_I_11 SearchBOM Scroll Def 1[11]BooleanCB0
17BOMSCROLLDEF1_I_12 SearchBOM Scroll Def 1[12]BooleanCB0
18BOMSCROLLDEF1_I_13 SearchBOM Scroll Def 1[13]BooleanCB0
19BOMSCROLLDEF1_I_14 SearchBOM Scroll Def 1[14]BooleanCB0
20BOMSCROLLDEF1_I_15 SearchBOM Scroll Def 1[15]BooleanCB0
21BOMSCROLLDEF1_I_16 SearchBOM Scroll Def 1[16]BooleanCB0
22BOMSCROLLDEF1_I_17 SearchBOM Scroll Def 1[17]BooleanCB0
23BOMSCROLLDEF1_I_18 SearchBOM Scroll Def 1[18]BooleanCB0
24BOMSCROLLDEF1_I_19 SearchBOM Scroll Def 1[19]BooleanCB0
25BOMSCROLLDEF2_I_1 SearchBOM Scroll Def 2[1]BooleanCB0
26BOMSCROLLDEF2_I_2 SearchBOM Scroll Def 2[2]BooleanCB0
27BOMSCROLLDEF2_I_3 SearchBOM Scroll Def 2[3]BooleanCB0
28BOMSCROLLDEF2_I_4 SearchBOM Scroll Def 2[4]BooleanCB0
29BOMSCROLLDEF2_I_5 SearchBOM Scroll Def 2[5]BooleanCB0
30BOMSCROLLDEF2_I_6 SearchBOM Scroll Def 2[6]BooleanCB0
31BOMSCROLLDEF2_I_7 SearchBOM Scroll Def 2[7]BooleanCB0
32BOMSCROLLDEF2_I_8 SearchBOM Scroll Def 2[8]BooleanCB0
33BOMSCROLLDEF2_I_9 SearchBOM Scroll Def 2[9]BooleanCB0
34BOMSCROLLDEF2_I_10 SearchBOM Scroll Def 2[10]BooleanCB0
35BOMSCROLLDEF2_I_11 SearchBOM Scroll Def 2[11]BooleanCB0
36BOMSCROLLDEF2_I_12 SearchBOM Scroll Def 2[12]BooleanCB0
37BOMSCROLLDEF2_I_13 SearchBOM Scroll Def 2[13]BooleanCB0
38BOMSCROLLDEF2_I_14 SearchBOM Scroll Def 2[14]BooleanCB0
39BOMSCROLLDEF2_I_15 SearchBOM Scroll Def 2[15]BooleanCB0
40BOMSCROLLDEF2_I_16 SearchBOM Scroll Def 2[16]BooleanCB0
41BOMSCROLLDEF2_I_17 SearchBOM Scroll Def 2[17]BooleanCB0
42BOMSCROLLDEF2_I_18 SearchBOM Scroll Def 2[18]BooleanCB0
43BOMSCROLLDEF2_I_19 SearchBOM Scroll Def 2[19]BooleanCB0
44BOMSCROLLLABEL_I_1 SearchBOM Scroll Label[1]StringSTR2020
45BOMSCROLLLABEL_I_2 SearchBOM Scroll Label[2]StringSTR2020
46BOMSCROLLLABEL_I_3 SearchBOM Scroll Label[3]StringSTR2020
47BOMSCROLLLABEL_I_4 SearchBOM Scroll Label[4]StringSTR2020
48BOMSCROLLLABEL_I_5 SearchBOM Scroll Label[5]StringSTR2020
49BOMSCROLLLABEL_I_6 SearchBOM Scroll Label[6]StringSTR2020
50BOMSCROLLLABEL_I_7 SearchBOM Scroll Label[7]StringSTR2020
51BOMSCROLLLABEL_I_8 SearchBOM Scroll Label[8]StringSTR2020
52BOMSCROLLLABEL_I_9 SearchBOM Scroll Label[9]StringSTR2020
53BOMSCROLLLABEL_I_10 SearchBOM Scroll Label[10]StringSTR2020
54BOMSCROLLLABEL_I_11 SearchBOM Scroll Label[11]StringSTR2020
55BOMSCROLLLABEL_I_12 SearchBOM Scroll Label[12]StringSTR2020
56BOMSCROLLLABEL_I_13 SearchBOM Scroll Label[13]StringSTR2020
57BOMSCROLLLABEL_I_14 SearchBOM Scroll Label[14]StringSTR2020
58BOMSCROLLLABEL_I_15 SearchBOM Scroll Label[15]StringSTR2020
59BOMSCROLLLABEL_I_16 SearchBOM Scroll Label[16]StringSTR2020
60BOMSCROLLLABEL_I_17 SearchBOM Scroll Label[17]StringSTR2020
61GRAPH_BOM_VS SearchGraphical BOM VSIntegerGB0

Leave a Reply

Your email address will not be published. Required fields are marked *