Journal Destinations Temp (SY04000)

azurecurveProductsMicrosoft Dynamics GP (0)SystemJournal Destinations Temp (SY04000)

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
Physical Name: SY04000
Technical Name: SY_Journal_Destination_TEMP

Group Display Name: Journal Destination TEMP
Group Technical Name: Journal Destination TEMP

Seq NoPhysical NameDisplay NameDexterity Data TypeSQL Data TypeSQL DB LengthKeyable Length
1USERID SearchUser IDSTR15_User_IDString1615
Key to the Users Master (SY01400).

Click to show/hide

SELECT
       ['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
2CMPNYNAM SearchCompany NameSTR64_Company_NameString6664
3BCHSOURC SearchBatch SourceSTR15String1615
4BACHNUMB SearchBatch NumberSTR15_LBAUString1615
5PRRPTFAR SearchPrint Report Flag ArrayCBBoolean20
6PRRPTFAR_1 SearchPrint Report Flag Array[1]CBBoolean20
7PRRPTFAR_2 SearchPrint Report Flag Array[2]CBBoolean20
8PRRPTFAR_3 SearchPrint Report Flag Array[3]CBBoolean20
9PRRPTFAR_4 SearchPrint Report Flag Array[4]CBBoolean20
10PRRPTFAR_5 SearchPrint Report Flag Array[5]CBBoolean20
11PRRPTFAR_6 SearchPrint Report Flag Array[6]CBBoolean20
12PRTSCRAR SearchPrint To Screen ArrayCBBoolean20
13PRTSCRAR_1 SearchPrint To Screen Array[1]CBBoolean20
14PRTSCRAR_2 SearchPrint To Screen Array[2]CBBoolean20
15PRTSCRAR_3 SearchPrint To Screen Array[3]CBBoolean20
16PRTSCRAR_4 SearchPrint To Screen Array[4]CBBoolean20
17PRTSCRAR_5 SearchPrint To Screen Array[5]CBBoolean20
18PRTSCRAR_6 SearchPrint To Screen Array[6]CBBoolean20
19PRTPRARR SearchPrint To Printer ArrayCBBoolean20
20PRTPRARR_1 SearchPrint To Printer Array[1]CBBoolean20
21PRTPRARR_2 SearchPrint To Printer Array[2]CBBoolean20
22PRTPRARR_3 SearchPrint To Printer Array[3]CBBoolean20
23PRTPRARR_4 SearchPrint To Printer Array[4]CBBoolean20
24PRTPRARR_5 SearchPrint To Printer Array[5]CBBoolean20
25PRTPRARR_6 SearchPrint To Printer Array[6]CBBoolean20
26EXPTFTAR SearchExport File Type ArrayINTInteger20
27EXPTFTAR_1 SearchExport File Type Array[1]INTInteger20
28EXPTFTAR_2 SearchExport File Type Array[2]INTInteger20
29EXPTFTAR_3 SearchExport File Type Array[3]INTInteger20
30EXPTFTAR_4 SearchExport File Type Array[4]INTInteger20
31EXPTFTAR_5 SearchExport File Type Array[5]INTInteger20
32EXPTFTAR_6 SearchExport File Type Array[6]INTInteger20
33FEXPNMAR SearchFile Export Name ArraySTR255String256255
34FEXPNMAR_1 SearchFile Export Name Array[1]STR255String256255
35FEXPNMAR_2 SearchFile Export Name Array[2]STR255String256255
36FEXPNMAR_3 SearchFile Export Name Array[3]STR255String256255
37FEXPNMAR_4 SearchFile Export Name Array[4]STR255String256255
38FEXPNMAR_5 SearchFile Export Name Array[5]STR255String256255
39FEXPNMAR_6 SearchFile Export Name Array[6]STR255String256255
40DEX_ROW_ID Searchintint1010

DEX_ROW_ID is an auto-numbered IDENTITY column used internally by Dexterity for lock management; it should not be used by developers to identify any particular piece of information.

Microsoft MVP Mariano Gomez has a good write up on the DEX_ROW_ID column.

azurecurveProductsMicrosoft Dynamics GP (0)SystemJournal Destinations Temp (SY04000)

Leave a Reply

Your email address will not be published. Required fields are marked *