Easily find this page again using the shortlink: https://gpt.azrcrv.co.uk/SY04000
Product: Microsoft Dynamics GP (0)
Series: System
Display Name: Journal Destinations Temp Group Display Name: Journal Destination TEMP
Physical Name: SY04000
Technical Name: SY_Journal_Destination_TEMP
Group Technical Name: Journal Destination TEMP
Seq No | Physical Name | Display Name | Dexterity Data Type | SQL Data Type | Length | |
---|---|---|---|---|---|---|
1 | USERID | User ID | String | STR15_User_ID | 15 | |
Key to the Users Master (SY01400).
Click to show/hideSELECT
['Journal Destinations Temp'].USERID AS 'Journal Destinations Temp-User ID'
,['Users Master'].USERID AS 'Users Master-User ID'
FROM
SY04000 AS ['Journal Destinations Temp']
INNER JOIN
DYNAMICS..SY01400 AS ['Users Master']
ON
['Journal Destinations Temp'].USERID = ['Users Master'].USERID | ||||||
2 | CMPNYNAM | Company Name | String | STR64_Company_Name | 64 | |
3 | BCHSOURC | Batch Source | String | STR15 | 15 | |
4 | BACHNUMB | Batch Number | String | STR15_LBAU | 15 | |
5 | PRRPTFAR | Print Report Flag Array | CB | Boolean | 0 | |
6 | PRRPTFAR_1 | Print Report Flag Array[1] | Boolean | CB | 0 | |
7 | PRRPTFAR_2 | Print Report Flag Array[2] | Boolean | CB | 0 | |
8 | PRRPTFAR_3 | Print Report Flag Array[3] | Boolean | CB | 0 | |
9 | PRRPTFAR_4 | Print Report Flag Array[4] | Boolean | CB | 0 | |
10 | PRRPTFAR_5 | Print Report Flag Array[5] | Boolean | CB | 0 | |
11 | PRRPTFAR_6 | Print Report Flag Array[6] | Boolean | CB | 0 | |
12 | PRTSCRAR_1 | Print To Screen Array[1] | Boolean | CB | 0 | |
13 | PRTSCRAR_2 | Print To Screen Array[2] | Boolean | CB | 0 | |
14 | PRTSCRAR | Print To Screen Array | CB | Boolean | 0 | |
15 | PRTSCRAR_3 | Print To Screen Array[3] | Boolean | CB | 0 | |
16 | PRTSCRAR_4 | Print To Screen Array[4] | Boolean | CB | 0 | |
17 | PRTSCRAR_5 | Print To Screen Array[5] | Boolean | CB | 0 | |
18 | PRTSCRAR_6 | Print To Screen Array[6] | Boolean | CB | 0 | |
19 | PRTPRARR_1 | Print To Printer Array[1] | Boolean | CB | 0 | |
20 | PRTPRARR_2 | Print To Printer Array[2] | Boolean | CB | 0 | |
21 | PRTPRARR | Print To Printer Array | CB | Boolean | 0 | |
22 | PRTPRARR_3 | Print To Printer Array[3] | Boolean | CB | 0 | |
23 | PRTPRARR_4 | Print To Printer Array[4] | Boolean | CB | 0 | |
24 | PRTPRARR_5 | Print To Printer Array[5] | Boolean | CB | 0 | |
25 | PRTPRARR_6 | Print To Printer Array[6] | Boolean | CB | 0 | |
26 | EXPTFTAR_1 | Export File Type Array[1] | Integer | INT | 0 | |
27 | EXPTFTAR_2 | Export File Type Array[2] | Integer | INT | 0 | |
28 | EXPTFTAR_3 | Export File Type Array[3] | Integer | INT | 0 | |
29 | EXPTFTAR_4 | Export File Type Array[4] | Integer | INT | 0 | |
30 | EXPTFTAR | Export File Type Array | INT | Integer | 0 | |
31 | EXPTFTAR_5 | Export File Type Array[5] | Integer | INT | 0 | |
32 | EXPTFTAR_6 | Export File Type Array[6] | Integer | INT | 0 | |
33 | FEXPNMAR_1 | File Export Name Array[1] | String | STR255 | 255 | |
34 | FEXPNMAR_2 | File Export Name Array[2] | String | STR255 | 255 | |
35 | FEXPNMAR_3 | File Export Name Array[3] | String | STR255 | 255 | |
36 | FEXPNMAR_4 | File Export Name Array[4] | String | STR255 | 255 | |
37 | FEXPNMAR_5 | File Export Name Array[5] | String | STR255 | 255 | |
38 | FEXPNMAR | File Export Name Array | STR255 | String | 255 | |
39 | FEXPNMAR_6 | File Export Name Array[6] | String | STR255 | 255 |