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 |