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_3 | Print To Printer Array[3] | Boolean | CB | 0 | |
| 22 | PRTPRARR | Print To Printer Array | CB | Boolean | 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 | File Export Name Array | STR255 | String | 255 | |
| 38 | FEXPNMAR_5 | File Export Name Array[5] | String | STR255 | 255 | |
| 39 | FEXPNMAR_6 | File Export Name Array[6] | String | STR255 | 255 | |