Easily find this page again using the shortlink: https://gpt.azrcrv.co.uk/SV000787
Product: WennSoft Products (131)
Series: 3rd Party
Display Name: SV_Invoice_Setup_MSTR
Physical Name: SV000787
Technical Name: SV_Invoice_Setup_MSTR
Seq No | Physical Name | Display Name | Dexterity Data Type | SQL Data Type | Length | |
---|---|---|---|---|---|---|
1 | Divisions | Divisions | STR15_LBAU | String | 15 | |
2 | Wennsoft_Account_Index_1 | Wennsoft Account Index[1] | LI_14 | Long Integer | 14 | |
3 | Wennsoft_Account_Index_2 | Wennsoft Account Index[2] | LI_14 | Long Integer | 14 | |
4 | Wennsoft_Account_Index_3 | Wennsoft Account Index[3] | LI_14 | Long Integer | 14 | |
5 | Wennsoft_Account_Index_4 | Wennsoft Account Index[4] | LI_14 | Long Integer | 14 | |
6 | Wennsoft_Account_Index_5 | Wennsoft Account Index[5] | LI_14 | Long Integer | 14 | |
7 | Wennsoft_Account_Index_6 | Wennsoft Account Index[6] | LI_14 | Long Integer | 14 | |
8 | Wennsoft_Account_Index_7 | Wennsoft Account Index[7] | LI_14 | Long Integer | 14 | |
9 | Wennsoft_Account_Index_8 | Wennsoft Account Index[8] | LI_14 | Long Integer | 14 | |
10 | Wennsoft_Account_Index_9 | Wennsoft Account Index[9] | LI_14 | Long Integer | 14 | |
11 | Wennsoft_Account_Index_10 | Wennsoft Account Index[10] | LI_14 | Long Integer | 14 | |
12 | Wennsoft_Account_Index_11 | Wennsoft Account Index[11] | LI_14 | Long Integer | 14 | |
13 | Wennsoft_Account_Index_12 | Wennsoft Account Index[12] | LI_14 | Long Integer | 14 | |
14 | Wennsoft_Account_Index_13 | Wennsoft Account Index[13] | LI_14 | Long Integer | 14 | |
15 | Wennsoft_Account_Index_14 | Wennsoft Account Index[14] | LI_14 | Long Integer | 14 | |
16 | Wennsoft_Account_Index_15 | Wennsoft Account Index[15] | LI_14 | Long Integer | 14 | |
17 | Wennsoft_Account_Index_16 | Wennsoft Account Index[16] | LI_14 | Long Integer | 14 | |
18 | Wennsoft_Account_Index_17 | Wennsoft Account Index[17] | LI_14 | Long Integer | 14 | |
19 | Wennsoft_Account_Index_18 | Wennsoft Account Index[18] | LI_14 | Long Integer | 14 | |
20 | Wennsoft_Account_Index_19 | Wennsoft Account Index[19] | LI_14 | Long Integer | 14 | |
21 | Wennsoft_Account_Index_20 | Wennsoft Account Index[20] | LI_14 | Long Integer | 14 | |
22 | Wennsoft_Account_Index_21 | Wennsoft Account Index[21] | LI_14 | Long Integer | 14 | |
23 | Wennsoft_Account_Index_22 | Wennsoft Account Index[22] | LI_14 | Long Integer | 14 | |
24 | Wennsoft_Account_Index_23 | Wennsoft Account Index[23] | LI_14 | Long Integer | 14 | |
25 | Wennsoft_Account_Index_24 | Wennsoft Account Index[24] | LI_14 | Long Integer | 14 | |
26 | Wennsoft_Account_Index_25 | Wennsoft Account Index[25] | LI_14 | Long Integer | 14 | |
27 | Wennsoft_Account_Index_26 | Wennsoft Account Index[26] | LI_14 | Long Integer | 14 | |
28 | Wennsoft_Account_Index_27 | Wennsoft Account Index[27] | LI_14 | Long Integer | 14 | |
29 | Wennsoft_Account_Index_28 | Wennsoft Account Index[28] | LI_14 | Long Integer | 14 | |
30 | Wennsoft_Account_Index_29 | Wennsoft Account Index[29] | LI_14 | Long Integer | 14 | |
31 | Wennsoft_Account_Index_30 | Wennsoft Account Index[30] | LI_14 | Long Integer | 14 | |
32 | Wennsoft_Account_Index_31 | Wennsoft Account Index[31] | LI_14 | Long Integer | 14 | |
33 | Wennsoft_Account_Index_32 | Wennsoft Account Index[32] | LI_14 | Long Integer | 14 | |
34 | Wennsoft_Account_Index_33 | Wennsoft Account Index[33] | LI_14 | Long Integer | 14 | |
35 | Wennsoft_Account_Index_34 | Wennsoft Account Index[34] | LI_14 | Long Integer | 14 | |
36 | Wennsoft_Account_Index_35 | Wennsoft Account Index[35] | LI_14 | Long Integer | 14 | |
37 | Wennsoft_Account_Index_36 | Wennsoft Account Index[36] | LI_14 | Long Integer | 14 | |
38 | Wennsoft_Account_Index_37 | Wennsoft Account Index[37] | LI_14 | Long Integer | 14 | |
39 | Wennsoft_Account_Index_38 | Wennsoft Account Index[38] | LI_14 | Long Integer | 14 | |
40 | Wennsoft_Account_Index_39 | Wennsoft Account Index[39] | LI_14 | Long Integer | 14 | |
41 | Wennsoft_Account_Index_40 | Wennsoft Account Index[40] | LI_14 | Long Integer | 14 | |
42 | Wennsoft_Account_Index_41 | Wennsoft Account Index[41] | LI_14 | Long Integer | 14 | |
43 | Wennsoft_Account_Index_42 | Wennsoft Account Index[42] | LI_14 | Long Integer | 14 | |
44 | Wennsoft_Account_Index_43 | Wennsoft Account Index[43] | LI_14 | Long Integer | 14 | |
45 | Wennsoft_Account_Index_44 | Wennsoft Account Index[44] | LI_14 | Long Integer | 14 | |
46 | Wennsoft_Account_Index_45 | Wennsoft Account Index[45] | LI_14 | Long Integer | 14 | |
47 | Wennsoft_Account_Index_46 | Wennsoft Account Index[46] | LI_14 | Long Integer | 14 | |
48 | Wennsoft_Account_Index_47 | Wennsoft Account Index[47] | LI_14 | Long Integer | 14 | |
49 | Wennsoft_Account_Index_48 | Wennsoft Account Index[48] | LI_14 | Long Integer | 14 | |
50 | Wennsoft_Account_Index_49 | Wennsoft Account Index[49] | LI_14 | Long Integer | 14 | |
51 | Wennsoft_Account_Index_50 | Wennsoft Account Index[50] | LI_14 | Long Integer | 14 | |
52 | Wennsoft_Account_Index_51 | Wennsoft Account Index[51] | LI_14 | Long Integer | 14 | |
53 | Wennsoft_Account_Index_52 | Wennsoft Account Index[52] | LI_14 | Long Integer | 14 | |
54 | SOURCDOC | Source Document | STR10_Source_Document | String | 10 | |
Key to the Source Document Master (SY00900).
Click to show/hideSELECT
['SV_Invoice_Setup_MSTR'].SOURCDOC AS 'SV_Invoice_Setup_MSTR-Source Document'
,['Source Document Master'].SOURCDOC AS 'Source Document Master-Source Document'
FROM
SV000787 AS ['SV_Invoice_Setup_MSTR']
INNER JOIN
SY00900 AS ['Source Document Master']
ON
['SV_Invoice_Setup_MSTR'].SOURCDOC = ['Source Document Master'].SOURCDOC | ||||||
55 | SDOCDSCR | Source Document Description | STR30 | String | 30 | |
56 | All_Converted | All Converted | CB | Boolean | 0 | |
57 | Wennsoft_Affiliate | Wennsoft Affiliate | STR15_LBAU | String | 15 | |
58 | Wennsoft_Region | Wennsoft Region | STR15_LBAU | String | 15 | |
59 | Wennsoft_Branch | Wennsoft Branch | STR15_LBAU | String | 15 | |
60 | MODIFDT | Modified Date | DT | Date | 8 | |
61 | Modified_Time | Modified Time | TM6 | Time | 6 | |
62 | MDFUSRID | Modified User ID | STR15 | String | 15 | |
Key to the Users Master (SY01400).
Click to show/hideSELECT
['SV_Invoice_Setup_MSTR'].MDFUSRID AS 'SV_Invoice_Setup_MSTR-Modified User ID'
,['Users Master'].USERID AS 'Users Master-User ID'
FROM
SV000787 AS ['SV_Invoice_Setup_MSTR']
INNER JOIN
DYNAMICS..SY01400 AS ['Users Master']
ON
['SV_Invoice_Setup_MSTR'].MDFUSRID = ['Users Master'].USERID | ||||||
63 | SV_Language_ID | SV Language ID | INT2 | Integer | 2 | |
64 | Time_Zone | Time Zone | STR3 | String | 3 | |
65 | WS_Checkbox1 | WS Checkbox1 | CB | Boolean | 0 | |
66 | WS_Checkbox_2 | WS Checkbox 2 | CB | Boolean | 0 | |
67 | WS_Checkbox_3 | WS Checkbox 3 | CB | Boolean | 0 | |
68 | WS_Checkbox_4 | WS Checkbox 4 | CB | Boolean | 0 | |
69 | WS_Checkbox_5 | WS Checkbox 5 | CB | Boolean | 0 | |
70 | WS_Checkbox_6 | WS Checkbox 6 | CB | Boolean | 0 | |
71 | WS_Checkbox_7 | WS Checkbox 7 | CB | Boolean | 0 | |
72 | WS_Checkbox_8 | WS Checkbox 8 | CB | Boolean | 0 | |
73 | WS_Checkbox_9 | WS Checkbox 9 | CB | Boolean | 0 | |
74 | WS_Checkbox_10 | WS Checkbox 10 | CB | Boolean | 0 | |
75 | WS_Checkbox_11 | WS Checkbox 11 | CB | Boolean | 0 | |
76 | WS_Checkbox_12 | WS Checkbox 12 | CB | Boolean | 0 | |
77 | WS_Checkbox_13 | WS Checkbox 13 | CB | Boolean | 0 | |
78 | WS_Checkbox_14 | WS Checkbox 14 | CB | Boolean | 0 | |
79 | WS_Checkbox_15 | WS Checkbox 15 | CB | Boolean | 0 | |
80 | WS_Checkbox_16 | WS Checkbox 16 | CB | Boolean | 0 | |
81 | WS_Checkbox_17 | WS Checkbox 17 | CB | Boolean | 0 | |
82 | WS_Checkbox_18 | WS Checkbox 18 | CB | Boolean | 0 | |
83 | WS_Checkbox_19 | WS Checkbox 19 | CB | Boolean | 0 | |
84 | WS_Checkbox_20 | WS Checkbox 20 | CB | Boolean | 0 |