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 TypeLength
1Record_Sequence SearchRecord SequenceINT5_RZ_U0Integer5
2WS_Checkbox1 SearchWS Checkbox1CBBoolean0
3WS_Checkbox_2 SearchWS Checkbox 2CBBoolean0
4WS_Checkbox_3 SearchWS Checkbox 3CBBoolean0
5WS_Checkbox_4 SearchWS Checkbox 4CBBoolean0
6WS_Checkbox_5 SearchWS Checkbox 5CBBoolean0
7WS_Checkbox_6 SearchWS Checkbox 6CBBoolean0
8WS_Checkbox_7 SearchWS Checkbox 7CBBoolean0
9WS_Checkbox_8 SearchWS Checkbox 8CBBoolean0
10WS_Checkbox_9 SearchWS Checkbox 9CBBoolean0
11WS_Checkbox_10 SearchWS Checkbox 10CBBoolean0
12WS_Checkbox_11 SearchWS Checkbox 11CBBoolean0
13WS_Checkbox_12 SearchWS Checkbox 12CBBoolean0
14WS_Checkbox_13 SearchWS Checkbox 13CBBoolean0
15WS_Checkbox_14 SearchWS Checkbox 14CBBoolean0
16WS_Checkbox_15 SearchWS Checkbox 15CBBoolean0
17WS_Checkbox_16 SearchWS Checkbox 16CBBoolean0
18WS_Checkbox_17 SearchWS Checkbox 17CBBoolean0
19WS_Checkbox_18 SearchWS Checkbox 18CBBoolean0
20WS_Checkbox_19 SearchWS Checkbox 19CBBoolean0
21WS_Checkbox_20 SearchWS Checkbox 20CBBoolean0
22WS_Group_1 SearchWS Group 1GBInteger0
23WS_Group_2 SearchWS Group 2GBInteger0
24WS_Group_3 SearchWS Group 3GBInteger0
25WS_Group_4 SearchWS Group 4GBInteger0
26WS_Group_5 SearchWS Group 5GBInteger0
27WS_String_1 SearchWS String 1STR20String20
28WS_String_2 SearchWS String 2STR20String20
29WS_String_3 SearchWS String 3STR20String20
30WS_String_4 SearchWS String 4STR20String20
31WS_String_5 SearchWS String 5STR20String20
32USERID SearchUser IDSTR15_User_IDString15
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 IDSTR15String15
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 DateDTDate8
35Modified_Time SearchModified TimeTM6Time6
36WSReserved_CB1 SearchWSReserved CB1CBBoolean0
37WSReserved_CB2 SearchWSReserved CB2CBBoolean0
38WSReserved_CB3 SearchWSReserved CB3CBBoolean0
39WSReserved_CB4 SearchWSReserved CB4CBBoolean0
40WSReserved_CB5 SearchWSReserved CB5CBBoolean0
41WSReserved_CB6 SearchWSReserved CB6CBBoolean0
42WSReserved_CB7 SearchWSReserved CB7CBBoolean0
43WSReserved_CB8 SearchWSReserved CB8CBBoolean0
44WSReserved_CB9 SearchWSReserved CB9CBBoolean0
45WSReserved_CB10 SearchWSReserved CB10CBBoolean0
46WSReserved_STR1 SearchWSReserved STR1STR10String10
47WSReserved_STR2 SearchWSReserved STR2STR10String10
48Wennsoft_Affiliate SearchWennsoft AffiliateSTR15_LBAUString15
49Wennsoft_Region SearchWennsoft RegionSTR15_LBAUString15
50Wennsoft_Branch SearchWennsoft BranchSTR15_LBAUString15
51Time_Zone SearchTime ZoneSTR3String3

Leave a Reply

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