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 | SQL DB Length | Keyable Length |
---|---|---|---|---|---|---|
1 | Divisions ![]() | Divisions | STR15_LBAU | String | 16 | 15 |
2 | Wennsoft_Account_Index_1 ![]() | Wennsoft Account Index[1] | LI_14 | Long Integer | 4 | 14 |
3 | Wennsoft_Account_Index_2 ![]() | Wennsoft Account Index[2] | LI_14 | Long Integer | 4 | 14 |
4 | Wennsoft_Account_Index_3 ![]() | Wennsoft Account Index[3] | LI_14 | Long Integer | 4 | 14 |
5 | Wennsoft_Account_Index_4 ![]() | Wennsoft Account Index[4] | LI_14 | Long Integer | 4 | 14 |
6 | Wennsoft_Account_Index_5 ![]() | Wennsoft Account Index[5] | LI_14 | Long Integer | 4 | 14 |
7 | Wennsoft_Account_Index_6 ![]() | Wennsoft Account Index[6] | LI_14 | Long Integer | 4 | 14 |
8 | Wennsoft_Account_Index_7 ![]() | Wennsoft Account Index[7] | LI_14 | Long Integer | 4 | 14 |
9 | Wennsoft_Account_Index_8 ![]() | Wennsoft Account Index[8] | LI_14 | Long Integer | 4 | 14 |
10 | Wennsoft_Account_Index_9 ![]() | Wennsoft Account Index[9] | LI_14 | Long Integer | 4 | 14 |
11 | Wennsoft_Account_Index_10 ![]() | Wennsoft Account Index[10] | LI_14 | Long Integer | 4 | 14 |
12 | Wennsoft_Account_Index_11 ![]() | Wennsoft Account Index[11] | LI_14 | Long Integer | 4 | 14 |
13 | Wennsoft_Account_Index_12 ![]() | Wennsoft Account Index[12] | LI_14 | Long Integer | 4 | 14 |
14 | Wennsoft_Account_Index_13 ![]() | Wennsoft Account Index[13] | LI_14 | Long Integer | 4 | 14 |
15 | Wennsoft_Account_Index_14 ![]() | Wennsoft Account Index[14] | LI_14 | Long Integer | 4 | 14 |
16 | Wennsoft_Account_Index_15 ![]() | Wennsoft Account Index[15] | LI_14 | Long Integer | 4 | 14 |
17 | Wennsoft_Account_Index_16 ![]() | Wennsoft Account Index[16] | LI_14 | Long Integer | 4 | 14 |
18 | Wennsoft_Account_Index_17 ![]() | Wennsoft Account Index[17] | LI_14 | Long Integer | 4 | 14 |
19 | Wennsoft_Account_Index_18 ![]() | Wennsoft Account Index[18] | LI_14 | Long Integer | 4 | 14 |
20 | Wennsoft_Account_Index_19 ![]() | Wennsoft Account Index[19] | LI_14 | Long Integer | 4 | 14 |
21 | Wennsoft_Account_Index_20 ![]() | Wennsoft Account Index[20] | LI_14 | Long Integer | 4 | 14 |
22 | Wennsoft_Account_Index_21 ![]() | Wennsoft Account Index[21] | LI_14 | Long Integer | 4 | 14 |
23 | Wennsoft_Account_Index_22 ![]() | Wennsoft Account Index[22] | LI_14 | Long Integer | 4 | 14 |
24 | Wennsoft_Account_Index_23 ![]() | Wennsoft Account Index[23] | LI_14 | Long Integer | 4 | 14 |
25 | Wennsoft_Account_Index_24 ![]() | Wennsoft Account Index[24] | LI_14 | Long Integer | 4 | 14 |
26 | Wennsoft_Account_Index_25 ![]() | Wennsoft Account Index[25] | LI_14 | Long Integer | 4 | 14 |
27 | Wennsoft_Account_Index_26 ![]() | Wennsoft Account Index[26] | LI_14 | Long Integer | 4 | 14 |
28 | Wennsoft_Account_Index_27 ![]() | Wennsoft Account Index[27] | LI_14 | Long Integer | 4 | 14 |
29 | Wennsoft_Account_Index_28 ![]() | Wennsoft Account Index[28] | LI_14 | Long Integer | 4 | 14 |
30 | Wennsoft_Account_Index_29 ![]() | Wennsoft Account Index[29] | LI_14 | Long Integer | 4 | 14 |
31 | Wennsoft_Account_Index_30 ![]() | Wennsoft Account Index[30] | LI_14 | Long Integer | 4 | 14 |
32 | Wennsoft_Account_Index_31 ![]() | Wennsoft Account Index[31] | LI_14 | Long Integer | 4 | 14 |
33 | Wennsoft_Account_Index_32 ![]() | Wennsoft Account Index[32] | LI_14 | Long Integer | 4 | 14 |
34 | Wennsoft_Account_Index_33 ![]() | Wennsoft Account Index[33] | LI_14 | Long Integer | 4 | 14 |
35 | Wennsoft_Account_Index_34 ![]() | Wennsoft Account Index[34] | LI_14 | Long Integer | 4 | 14 |
36 | Wennsoft_Account_Index_35 ![]() | Wennsoft Account Index[35] | LI_14 | Long Integer | 4 | 14 |
37 | Wennsoft_Account_Index_36 ![]() | Wennsoft Account Index[36] | LI_14 | Long Integer | 4 | 14 |
38 | Wennsoft_Account_Index_37 ![]() | Wennsoft Account Index[37] | LI_14 | Long Integer | 4 | 14 |
39 | Wennsoft_Account_Index_38 ![]() | Wennsoft Account Index[38] | LI_14 | Long Integer | 4 | 14 |
40 | Wennsoft_Account_Index_39 ![]() | Wennsoft Account Index[39] | LI_14 | Long Integer | 4 | 14 |
41 | Wennsoft_Account_Index_40 ![]() | Wennsoft Account Index[40] | LI_14 | Long Integer | 4 | 14 |
42 | Wennsoft_Account_Index_41 ![]() | Wennsoft Account Index[41] | LI_14 | Long Integer | 4 | 14 |
43 | Wennsoft_Account_Index_42 ![]() | Wennsoft Account Index[42] | LI_14 | Long Integer | 4 | 14 |
44 | Wennsoft_Account_Index_43 ![]() | Wennsoft Account Index[43] | LI_14 | Long Integer | 4 | 14 |
45 | Wennsoft_Account_Index_44 ![]() | Wennsoft Account Index[44] | LI_14 | Long Integer | 4 | 14 |
46 | Wennsoft_Account_Index_45 ![]() | Wennsoft Account Index[45] | LI_14 | Long Integer | 4 | 14 |
47 | Wennsoft_Account_Index_46 ![]() | Wennsoft Account Index[46] | LI_14 | Long Integer | 4 | 14 |
48 | Wennsoft_Account_Index_47 ![]() | Wennsoft Account Index[47] | LI_14 | Long Integer | 4 | 14 |
49 | Wennsoft_Account_Index_48 ![]() | Wennsoft Account Index[48] | LI_14 | Long Integer | 4 | 14 |
50 | Wennsoft_Account_Index_49 ![]() | Wennsoft Account Index[49] | LI_14 | Long Integer | 4 | 14 |
51 | Wennsoft_Account_Index_50 ![]() | Wennsoft Account Index[50] | LI_14 | Long Integer | 4 | 14 |
52 | Wennsoft_Account_Index_51 ![]() | Wennsoft Account Index[51] | LI_14 | Long Integer | 4 | 14 |
53 | Wennsoft_Account_Index_52 ![]() | Wennsoft Account Index[52] | LI_14 | Long Integer | 4 | 14 |
54 | SOURCDOC ![]() | Source Document | STR10_Source_Document | String | 12 | 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 | 32 | 30 |
56 | All_Converted ![]() | All Converted | CB | Boolean | 2 | 0 |
57 | Wennsoft_Affiliate ![]() | Wennsoft Affiliate | STR15_LBAU | String | 16 | 15 |
58 | Wennsoft_Region ![]() | Wennsoft Region | STR15_LBAU | String | 16 | 15 |
59 | Wennsoft_Branch ![]() | Wennsoft Branch | STR15_LBAU | String | 16 | 15 |
60 | MODIFDT ![]() | Modified Date | DT | Date | 4 | 8 |
61 | Modified_Time ![]() | Modified Time | TM6 | Time | 4 | 6 |
62 | MDFUSRID ![]() | Modified User ID | STR15 | String | 16 | 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 | 2 |
64 | Time_Zone ![]() | Time Zone | STR3 | String | 4 | 3 |
65 | WS_Checkbox1 ![]() | WS Checkbox1 | CB | Boolean | 2 | 0 |
66 | WS_Checkbox_2 ![]() | WS Checkbox 2 | CB | Boolean | 2 | 0 |
67 | WS_Checkbox_3 ![]() | WS Checkbox 3 | CB | Boolean | 2 | 0 |
68 | WS_Checkbox_4 ![]() | WS Checkbox 4 | CB | Boolean | 2 | 0 |
69 | WS_Checkbox_5 ![]() | WS Checkbox 5 | CB | Boolean | 2 | 0 |
70 | WS_Checkbox_6 ![]() | WS Checkbox 6 | CB | Boolean | 2 | 0 |
71 | WS_Checkbox_7 ![]() | WS Checkbox 7 | CB | Boolean | 2 | 0 |
72 | WS_Checkbox_8 ![]() | WS Checkbox 8 | CB | Boolean | 2 | 0 |
73 | WS_Checkbox_9 ![]() | WS Checkbox 9 | CB | Boolean | 2 | 0 |
74 | WS_Checkbox_10 ![]() | WS Checkbox 10 | CB | Boolean | 2 | 0 |
75 | WS_Checkbox_11 ![]() | WS Checkbox 11 | CB | Boolean | 2 | 0 |
76 | WS_Checkbox_12 ![]() | WS Checkbox 12 | CB | Boolean | 2 | 0 |
77 | WS_Checkbox_13 ![]() | WS Checkbox 13 | CB | Boolean | 2 | 0 |
78 | WS_Checkbox_14 ![]() | WS Checkbox 14 | CB | Boolean | 2 | 0 |
79 | WS_Checkbox_15 ![]() | WS Checkbox 15 | CB | Boolean | 2 | 0 |
80 | WS_Checkbox_16 ![]() | WS Checkbox 16 | CB | Boolean | 2 | 0 |
81 | WS_Checkbox_17 ![]() | WS Checkbox 17 | CB | Boolean | 2 | 0 |
82 | WS_Checkbox_18 ![]() | WS Checkbox 18 | CB | Boolean | 2 | 0 |
83 | WS_Checkbox_19 ![]() | WS Checkbox 19 | CB | Boolean | 2 | 0 |
84 | WS_Checkbox_20 ![]() | WS Checkbox 20 | CB | Boolean | 2 | 0 |