SV_IV_Item_MSTR (SV00406)

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

Product: WennSoft Products (131)
Series: 3rd Party

Display Name: SV_IV_Item_MSTR
Physical Name: SV00406
Technical Name: SV_IV_Item_MSTR

Group Display Name: SERVICE
Group Technical Name: SERVICE

Seq NoPhysical NameDisplay NameDexterity Data TypeSQL Data TypeSQL DB LengthKeyable Length
1ITEMNMBR SearchItem NumberSTR30_Item_NumberString3230
Key to the Item Master (IV00101).

Click to show/hide

SELECT
       ['SV_IV_Item_MSTR'].ITEMNMBR AS 'SV_IV_Item_MSTR-Item Number'
       ,['Item Master'].ITEMNMBR AS 'Item Master-Item Number'
FROM
       SV00406 AS ['SV_IV_Item_MSTR']
INNER JOIN
       IV00101 AS ['Item Master']
              ON
                     ['SV_IV_Item_MSTR'].ITEMNMBR = ['Item Master'].ITEMNMBR
2Equipment_Type SearchEquipment TypeSTR30String3230
3Wennsoft_Model_Number SearchWennsoft Model NumberSTR20String2220
4USERDEF1 SearchUser Defined 1STR20String2220
5USERDEF2 SearchUser Defined 2STR20String2220
6USRDEF03 SearchUser Defined 3STR20String2220
7USRDEF04 SearchUser Defined 4STR20String2220
8USRDEF05 SearchUser Defined 5STR20String2220
9User_Defined_CB_1 SearchUser Defined CB 1CBBoolean20
10UDCB1 SearchUser Defined CB 11CBBoolean20
11User_Defined_CB_2 SearchUser Defined CB 2CBBoolean20
12UDCB2 SearchUser Defined CB 21CBBoolean20
13User_Defined_CB_3 SearchUser Defined CB 3CBBoolean20
14User_Defined_CB_4 SearchUser Defined CB 4CBBoolean20
15USRDAT01 SearchUser Defined Date 1DTDate48
16USRDAT02 SearchUser Defined Date 2DTDate48
17User_Defined_Date_3 SearchWS User Defined Date 3DATEDate46
18User_Defined_Date_4 SearchWS User Defined Date 4DATEDate46
19User_Defined_Dollar_1 SearchUser Defined Dollar 1DLR14_RBS0_STR$Currency1014
20UserDD1 SearchUser Defined Dollar 11DLR14_RBS0_STR$Currency1014
21User_Defined_Dollar_2 SearchUser Defined Dollar 2DLR14_RBS0_STR$Currency1014
22UserDD2 SearchUser Defined Dollar 21DLR14_RBS0_STR$Currency1014
23User_Defined_Dollar_3 SearchUser Defined Dollar 3DLR14_RBS0_STR$Currency1014
24User_Defined_Dollar_4 SearchUser Defined Dollar 4DLR14_RBS0_STR$Currency1014
25User_Defined_EInfo1 SearchUser Defined EInfo1STR255String256255
26User_Defined_EInfo2 SearchUser Defined EInfo2STR255String256255
27User_Def_Integer_1 SearchUser Defined Integer 1LI6_S2Long Integer46
28UDI1 SearchUser Defined Integer 11LI6_S2Long Integer46
29User_Def_Integer_2 SearchUser Defined Integer 2LI6_S2Long Integer46
30UDI2 SearchUser Defined Integer 21LI6_S2Long Integer46
31User_Defined_Integer_3 SearchUser Defined Integer 3LI6_S2Long Integer46
32User_Defined_Integer_4 SearchUser Defined Integer 4LI6_S2Long Integer46
33User_Defined_Time_1 SearchUser Defined Time 1TM6Time46

Leave a Reply

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