Easily find this page again using the shortlink: https://gpt.azrcrv.co.uk/WS40002
Product: WennSoft Products (131)
Series: System
Display Name: WS_Product_Registration_SETP Group Display Name: WS Security
Physical Name: WS40002
Technical Name: WS_Product_Registration_SETP
Group Technical Name: WS Security
Seq No | Physical Name | Display Name | Dexterity Data Type | SQL Data Type | Length | |
---|---|---|---|---|---|---|
1 | Record ![]() | Record | INT | Integer | 0 | |
2 | CMPNYNAM ![]() | Company Name | STR64_Company_Name | String | 64 | |
3 | Registered_Phone_Number ![]() | Registered Phone Number | STR14_Phone | String | 14 | |
4 | Registration_Key1 ![]() | Registration Key1 | STR35_LBU | String | 35 | |
5 | Registration_Key2 ![]() | Registration Key2 | STR35_LBU | String | 35 | |
6 | Registration_Key3 ![]() | Registration Key3 | STR35_LBU | String | 35 | |
7 | Registration_Key4 ![]() | Registration Key4 | STR35_LBU | String | 35 | |
8 | Registration_Key5 ![]() | Registration Key5 | STR35_LBU | String | 35 | |
9 | Registration_Key6 ![]() | Registration Key6 | STR35_LBU | String | 35 | |
10 | Registration_Key7 ![]() | Registration Key7 | STR35_LBU | String | 35 | |
11 | Registration_Key8 ![]() | Registration Key8 | STR35_LBU | String | 35 | |
12 | Registration_Key9 ![]() | Registration Key9 | STR35_LBU | String | 35 | |
13 | Registration_Key10 ![]() | Registration Key10 | STR35_LBU | String | 35 | |
14 | Support_Plan_Expiration ![]() | Support Plan Experation | DT_6 | Date | 6 | |
15 | WS_Welcome1 ![]() | WS Welcome1 | STR30 | String | 30 | |
16 | WS_Welcome2 ![]() | WS Welcome2 | STR30 | String | 30 | |
17 | WS_Welcome3 ![]() | WS Welcome3 | STR30 | String | 30 | |
18 | WS_Welcome4 ![]() | WS Welcome4 | STR30 | String | 30 | |
19 | MODIFDT ![]() | Modified Date | DT | Date | 8 | |
20 | Modified_Time ![]() | Modified Time | TM6 | Time | 6 | |
21 | MDFUSRID ![]() | Modified User ID | STR15 | String | 15 | |
Key to the Users Master (SY01400).
Click to show/hideSELECT
['WS_Product_Registration_SETP'].MDFUSRID AS 'WS_Product_Registration_SETP-Modified User ID'
,['Users Master'].USERID AS 'Users Master-User ID'
FROM
WS40002 AS ['WS_Product_Registration_SETP']
INNER JOIN
DYNAMICS..SY01400 AS ['Users Master']
ON
['WS_Product_Registration_SETP'].MDFUSRID = ['Users Master'].USERID | ||||||
22 | User_Define_1 ![]() | User Define 1 | STR30 | String | 30 | |
23 | User_Define_2 ![]() | User Define 2 | STR30 | String | 30 | |
24 | USERDEF1 ![]() | User Defined 1 | STR20 | String | 20 | |
25 | USERDEF2 ![]() | User Defined 2 | STR20 | String | 20 | |
26 | User_Def_Integer_1 ![]() | User Defined Integer 1 | LI6_S2 | Long Integer | 6 | |
27 | User_Def_Integer_2 ![]() | User Defined Integer 2 | LI6_S2 | Long Integer | 6 | |
28 | User_Defined_Integer_3 ![]() | User Defined Integer 3 | LI6_S2 | Long Integer | 6 | |
29 | User_Defined_Integer_4 ![]() | User Defined Integer 4 | LI6_S2 | Long Integer | 6 | |
30 | User_Defined_Dollar_1 ![]() | User Defined Dollar 1 | DLR14_RBS0_STR$ | Currency | 14 | |
31 | User_Defined_Dollar_2 ![]() | User Defined Dollar 2 | DLR14_RBS0_STR$ | Currency | 14 | |
32 | User_Defined_Dollar_3 ![]() | User Defined Dollar 3 | DLR14_RBS0_STR$ | Currency | 14 | |
33 | User_Defined_Dollar_4 ![]() | User Defined Dollar 4 | DLR14_RBS0_STR$ | Currency | 14 | |
34 | USRDAT01 ![]() | User Defined Date 1 | DT | Date | 8 | |
35 | USRDAT02 ![]() | User Defined Date 2 | DT | Date | 8 | |
36 | User_Defined_Date_3 ![]() | WS User Defined Date 3 | DATE | Date | 6 | |
37 | User_Defined_Date_4 ![]() | WS User Defined Date 4 | DATE | Date | 6 | |
38 | User_Defined_CB_1 ![]() | User Defined CB 1 | CB | Boolean | 0 | |
39 | User_Defined_CB_2 ![]() | User Defined CB 2 | CB | Boolean | 0 | |
40 | User_Defined_CB_3 ![]() | User Defined CB 3 | CB | Boolean | 0 | |
41 | User_Defined_CB_4 ![]() | User Defined CB 4 | CB | Boolean | 0 | |
42 | WSReserved_CB1 ![]() | WSReserved CB1 | CB | Boolean | 0 | |
43 | WSReserved_CB2 ![]() | WSReserved CB2 | CB | Boolean | 0 | |
44 | WSReserved_CB3 ![]() | WSReserved CB3 | CB | Boolean | 0 | |
45 | WSReserved_CB4 ![]() | WSReserved CB4 | CB | Boolean | 0 | |
46 | WSReserved_CB5 ![]() | WSReserved CB5 | CB | Boolean | 0 | |
47 | WSReserved_STR1 ![]() | WSReserved STR1 | STR10 | String | 10 | |
48 | WSReserved_STR2 ![]() | WSReserved STR2 | STR10 | String | 10 |