WS_Option_SETP (WS40000)

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

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

Display Name: WS_Option_SETP
Physical Name: WS40000
Technical Name: WS_Option_SETP

Group Display Name: TimeTrack
Group Technical Name: TimeTrack

Seq NoPhysical NameDisplay NameDexterity Data TypeSQL Data TypeSQL DB LengthKeyable Length
1Record_Sequence SearchRecord SequenceINT5_RZ_U0Integer25
2WS_Transaction_Type SearchWS Transaction TypeSTR10_LBAUString1210
3DYOFWEEK SearchDay of WeekSTR20String2220
4Export_File_Format SearchExport File FormatDDLInteger20
5WS_Checkbox1 SearchWS Checkbox1CBBoolean20
6WS_Checkbox_2 SearchWS Checkbox 2CBBoolean20
7WS_Checkbox_3 SearchWS Checkbox 3CBBoolean20
8WS_Checkbox_4 SearchWS Checkbox 4CBBoolean20
9WS_Checkbox_5 SearchWS Checkbox 5CBBoolean20
10WS_Checkbox_6 SearchWS Checkbox 6CBBoolean20
11WS_Checkbox_7 SearchWS Checkbox 7CBBoolean20
12WS_Checkbox_8 SearchWS Checkbox 8CBBoolean20
13WS_Checkbox_9 SearchWS Checkbox 9CBBoolean20
14WS_Checkbox_10 SearchWS Checkbox 10CBBoolean20
15WS_Checkbox_11 SearchWS Checkbox 11CBBoolean20
16WS_Checkbox_12 SearchWS Checkbox 12CBBoolean20
17WS_Checkbox_13 SearchWS Checkbox 13CBBoolean20
18WS_Checkbox_14 SearchWS Checkbox 14CBBoolean20
19WS_Checkbox_15 SearchWS Checkbox 15CBBoolean20
20WS_Checkbox_16 SearchWS Checkbox 16CBBoolean20
21WS_Checkbox_17 SearchWS Checkbox 17CBBoolean20
22WS_Checkbox_18 SearchWS Checkbox 18CBBoolean20
23WS_Checkbox_19 SearchWS Checkbox 19CBBoolean20
24WS_Checkbox_20 SearchWS Checkbox 20CBBoolean20
25WS_Checkbox_21 SearchWS Checkbox 21CBBoolean20
26WS_Checkbox_22 SearchWS Checkbox 22CBBoolean20
27WS_Checkbox_23 SearchWS Checkbox 23CBBoolean20
28WS_Checkbox_24 SearchWS Checkbox 24CBBoolean20
29WS_Checkbox_25 SearchWS Checkbox 25CBBoolean20
30WS_Checkbox_26 SearchWS Checkbox 26CBBoolean20
31WS_Checkbox_27 SearchWS Checkbox 27CBBoolean20
32WS_Checkbox_28 SearchWS Checkbox 28CBBoolean20
33WS_Checkbox_29 SearchWS Checkbox 29CBBoolean20
34WS_Checkbox_30 SearchWS Checkbox 30CBBoolean20
35WS_Checkbox_31 SearchWS Checkbox 31CBBoolean20
36WS_Checkbox_32 SearchWS Checkbox 32CBBoolean20
37WS_Checkbox_33 SearchWS Checkbox 33CBBoolean20
38WS_Checkbox_34 SearchWS Checkbox 34CBBoolean20
39WS_Checkbox_35 SearchWS Checkbox 35CBBoolean20
40WS_Checkbox_36 SearchWS Checkbox 36CBBoolean20
41WS_Checkbox_37 SearchWS Checkbox 37CBBoolean20
42WS_Checkbox_38 SearchWS Checkbox 38CBBoolean20
43WS_Checkbox_39 SearchWS Checkbox 39CBBoolean20
44WS_Checkbox_40 SearchWS Checkbox 40CBBoolean20
45WS_Checkbox_41 SearchWS Checkbox 41CBBoolean20
46WS_Checkbox_42 SearchWS Checkbox 42CBBoolean20
47WS_Checkbox_43 SearchWS Checkbox 43CBBoolean20
48WS_Checkbox_44 SearchWS Checkbox 44CBBoolean20
49WS_Checkbox_45 SearchWS Checkbox 45CBBoolean20
50WS_String_1 SearchWS String 1STR20String2220
51WS_String_2 SearchWS String 2STR20String2220
52WSReserved_CB1 SearchWSReserved CB1CBBoolean20
53WSReserved_CB2 SearchWSReserved CB2CBBoolean20
54WSReserved_CB3 SearchWSReserved CB3CBBoolean20
55WSReserved_CB4 SearchWSReserved CB4CBBoolean20
56WSReserved_CB5 SearchWSReserved CB5CBBoolean20
57WSReserved_CB6 SearchWSReserved CB6CBBoolean20
58WSReserved_CB7 SearchWSReserved CB7CBBoolean20
59WSReserved_CB8 SearchWSReserved CB8CBBoolean20
60WSReserved_CB9 SearchWSReserved CB9CBBoolean20
61WSReserved_CB10 SearchWSReserved CB10CBBoolean20
62WSReserved_STR1 SearchWSReserved STR1STR10String1210
63WSReserved_STR2 SearchWSReserved STR2STR10String1210
64WSReserved_Integer1 SearchWSReserved Integer1INT4Integer24
65WSReserved_Integer2 SearchWSReserved Integer2INT4Integer24
66WSReserved_Integer3 SearchWSReserved Integer3INT4Integer24
67WSReserved_Integer4 SearchWSReserved Integer4INT4Integer24
68WSReserved_Integer5 SearchWSReserved Integer5INT4Integer24
69WSReserved_DDL1 SearchWSReserved DDL1DDLInteger20
70MODIFDT SearchModified DateDTDate48
71Modified_Time SearchModified TimeTM6Time46
72MDFUSRID SearchModified User IDSTR15String1615
Key to the Users Master (SY01400).

Click to show/hide

SELECT
       ['WS_Option_SETP'].MDFUSRID AS 'WS_Option_SETP-Modified User ID'
       ,['Users Master'].USERID AS 'Users Master-User ID'
FROM
       WS40000 AS ['WS_Option_SETP']
INNER JOIN
       DYNAMICS..SY01400 AS ['Users Master']
              ON
                     ['WS_Option_SETP'].MDFUSRID = ['Users Master'].USERID
73SV_Language_ID SearchSV Language IDINT2Integer22
74Wennsoft_Affiliate SearchWennsoft AffiliateSTR15_LBAUString1615
75Wennsoft_Region SearchWennsoft RegionSTR15_LBAUString1615
76Wennsoft_Branch SearchWennsoft BranchSTR15_LBAUString1615

Leave a Reply

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