JC_Master_Subcontractor_Contact_MSTR (JC001520)

azurecurveProductsWennSoft Products (131)3rd PartyJC_Master_Subcontractor_Contact_MSTR (JC001520)

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

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

Display Name: JC_Master_Subcontractor_Contact_MSTR
Physical Name: JC001520
Technical Name: JC_Master_Subcontractor_Contact_MSTR

Seq NoPhysical NameDisplay NameDexterity Data TypeSQL Data TypeSQL DB LengthKeyable Length
1VENDORID SearchVendor IDSTR_15_Vendor_IDString1615
Key to the PM Vendor Master File (PM00200).

Click to show/hide

SELECT
       ['JC_Master_Subcontractor_Contact_MSTR'].VENDORID AS 'JC_Master_Subcontractor_Contact_MSTR-Vendor ID'
       ,['PM Vendor Master File'].VENDORID AS 'PM Vendor Master File-Vendor ID'
FROM
       JC001520 AS ['JC_Master_Subcontractor_Contact_MSTR']
INNER JOIN
       PM00200 AS ['PM Vendor Master File']
              ON
                     ['JC_Master_Subcontractor_Contact_MSTR'].VENDORID = ['PM Vendor Master File'].VENDORID
2CONTACT SearchContactSTR60String6260
3User_Define_1 SearchUser Define 1STR30String3230
4User_Define_2 SearchUser Define 2STR30String3230
5User_Define_3 SearchUser Define 3STR30String3230
6User_Define_4 SearchUser Define 4STR30String3230
7User_Define_5 SearchUser Define 5STR30String3230
8User_Define_6 SearchUser Define 6STR30String3230
9USERDEF1 SearchUser Defined 1STR20String2220
10USERDEF2 SearchUser Defined 2STR20String2220
11USRDEF03 SearchUser Defined 3STR20String2220
12USRDEF04 SearchUser Defined 4STR20String2220
13USRDEF05 SearchUser Defined 5STR20String2220
14User_Defined_CB_1 SearchUser Defined CB 1CBBoolean20
15User_Defined_CB_2 SearchUser Defined CB 2CBBoolean20
16User_Defined_CB_3 SearchUser Defined CB 3CBBoolean20
17User_Defined_CB_4 SearchUser Defined CB 4CBBoolean20
18USRDAT01 SearchUser Defined Date 1DTDate48
19USRDAT02 SearchUser Defined Date 2DTDate48
20User_Defined_Date_3 SearchWS User Defined Date 3DATEDate46
21User_Defined_Date_4 SearchWS User Defined Date 4DATEDate46
22User_Defined_Dollar_1 SearchUser Defined Dollar 1DLR14_RBS0_STR$Currency1014
23User_Defined_Dollar_2 SearchUser Defined Dollar 2DLR14_RBS0_STR$Currency1014
24User_Defined_Dollar_3 SearchUser Defined Dollar 3DLR14_RBS0_STR$Currency1014
25User_Defined_Dollar_4 SearchUser Defined Dollar 4DLR14_RBS0_STR$Currency1014
26User_Def_Integer_1 SearchUser Defined Integer 1LI6_S2Long Integer46
27User_Def_Integer_2 SearchUser Defined Integer 2LI6_S2Long Integer46
28User_Defined_Integer_3 SearchUser Defined Integer 3LI6_S2Long Integer46
29User_Defined_Integer_4 SearchUser Defined Integer 4LI6_S2Long Integer46
30WSReserved_CB1 SearchWSReserved CB1CBBoolean20
31WSReserved_CB2 SearchWSReserved CB2CBBoolean20
32WSReserved_CB3 SearchWSReserved CB3CBBoolean20
33WSReserved_CB4 SearchWSReserved CB4CBBoolean20
34WSReserved_CB5 SearchWSReserved CB5CBBoolean20
35WSReserved_CB6 SearchWSReserved CB6CBBoolean20
36WSReserved_CB7 SearchWSReserved CB7CBBoolean20
37WSReserved_CB8 SearchWSReserved CB8CBBoolean20
38WSReserved_CB9 SearchWSReserved CB9CBBoolean20
39WSReserved_CB10 SearchWSReserved CB10CBBoolean20
40WSReserved_Integer1 SearchWSReserved Integer1INT4Integer24
41WSReserved_Integer2 SearchWSReserved Integer2INT4Integer24
42WSReserved_Integer3 SearchWSReserved Integer3INT4Integer24
43WSReserved_Integer4 SearchWSReserved Integer4INT4Integer24
44WSReserved_Integer5 SearchWSReserved Integer5INT4Integer24
45WSReserved_STR1 SearchWSReserved STR1STR10String1210
46WSReserved_STR2 SearchWSReserved STR2STR10String1210
azurecurveProductsWennSoft Products (131)3rd PartyJC_Master_Subcontractor_Contact_MSTR (JC001520)

Leave a Reply

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