JC_Setup_Options_SETP (JC41101)

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

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

Display Name: JC_Setup_Options_SETP
Physical Name: JC41101
Technical Name: JC_Setup_Options_SETP

Group Display Name: Job Cost
Group Technical Name: Job Cost

Seq NoPhysical NameDisplay NameDexterity Data TypeSQL Data TypeSQL DB LengthKeyable Length
1Record_Sequence SearchRecord SequenceINT5_RZ_U0Integer25
2WS_Checkbox1 SearchWS Checkbox1CBBoolean20
3WS_Checkbox_2 SearchWS Checkbox 2CBBoolean20
4WS_Checkbox_3 SearchWS Checkbox 3CBBoolean20
5WS_Checkbox_4 SearchWS Checkbox 4CBBoolean20
6WS_Checkbox_5 SearchWS Checkbox 5CBBoolean20
7WS_Checkbox_6 SearchWS Checkbox 6CBBoolean20
8WS_Checkbox_7 SearchWS Checkbox 7CBBoolean20
9WS_Checkbox_8 SearchWS Checkbox 8CBBoolean20
10WS_Checkbox_9 SearchWS Checkbox 9CBBoolean20
11WS_Checkbox_10 SearchWS Checkbox 10CBBoolean20
12WS_Checkbox_11 SearchWS Checkbox 11CBBoolean20
13WS_Checkbox_12 SearchWS Checkbox 12CBBoolean20
14WS_Checkbox_13 SearchWS Checkbox 13CBBoolean20
15WS_Checkbox_14 SearchWS Checkbox 14CBBoolean20
16WS_Checkbox_15 SearchWS Checkbox 15CBBoolean20
17WS_Checkbox_16 SearchWS Checkbox 16CBBoolean20
18WS_Checkbox_17 SearchWS Checkbox 17CBBoolean20
19WS_Checkbox_18 SearchWS Checkbox 18CBBoolean20
20WS_Checkbox_19 SearchWS Checkbox 19CBBoolean20
21WS_Checkbox_20 SearchWS Checkbox 20CBBoolean20
22WS_Group_1 SearchWS Group 1GBInteger20
23WS_Group_2 SearchWS Group 2GBInteger20
24WS_Group_3 SearchWS Group 3GBInteger20
25WS_Group_4 SearchWS Group 4GBInteger20
26WS_Group_5 SearchWS Group 5GBInteger20
27WS_String_1 SearchWS String 1STR20String2220
28WS_String_2 SearchWS String 2STR20String2220
29WS_String_3 SearchWS String 3STR20String2220
30WS_String_4 SearchWS String 4STR20String2220
31WS_String_5 SearchWS String 5STR20String2220
32USERID SearchUser IDSTR15_User_IDString1615
Key to the Users Master (SY01400).

Click to show/hide

SELECT
       ['JC_Setup_Options_SETP'].USERID AS 'JC_Setup_Options_SETP-User ID'
       ,['Users Master'].USERID AS 'Users Master-User ID'
FROM
       JC41101 AS ['JC_Setup_Options_SETP']
INNER JOIN
       DYNAMICS..SY01400 AS ['Users Master']
              ON
                     ['JC_Setup_Options_SETP'].USERID = ['Users Master'].USERID
33MDFUSRID SearchModified User IDSTR15String1615
Key to the Users Master (SY01400).

Click to show/hide

SELECT
       ['JC_Setup_Options_SETP'].MDFUSRID AS 'JC_Setup_Options_SETP-Modified User ID'
       ,['Users Master'].USERID AS 'Users Master-User ID'
FROM
       JC41101 AS ['JC_Setup_Options_SETP']
INNER JOIN
       DYNAMICS..SY01400 AS ['Users Master']
              ON
                     ['JC_Setup_Options_SETP'].MDFUSRID = ['Users Master'].USERID
34MODIFDT SearchModified DateDTDate48
35Modified_Time SearchModified TimeTM6Time46
36WSReserved_CB1 SearchWSReserved CB1CBBoolean20
37WSReserved_CB2 SearchWSReserved CB2CBBoolean20
38WSReserved_CB3 SearchWSReserved CB3CBBoolean20
39WSReserved_CB4 SearchWSReserved CB4CBBoolean20
40WSReserved_CB5 SearchWSReserved CB5CBBoolean20
41WSReserved_CB6 SearchWSReserved CB6CBBoolean20
42WSReserved_CB7 SearchWSReserved CB7CBBoolean20
43WSReserved_CB8 SearchWSReserved CB8CBBoolean20
44WSReserved_CB9 SearchWSReserved CB9CBBoolean20
45WSReserved_CB10 SearchWSReserved CB10CBBoolean20
46WSReserved_STR1 SearchWSReserved STR1STR10String1210
47WSReserved_STR2 SearchWSReserved STR2STR10String1210
48Wennsoft_Affiliate SearchWennsoft AffiliateSTR15_LBAUString1615
49Wennsoft_Region SearchWennsoft RegionSTR15_LBAUString1615
50Wennsoft_Branch SearchWennsoft BranchSTR15_LBAUString1615
51Time_Zone SearchTime ZoneSTR3String43

Leave a Reply

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