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 TypeLength
1USERID SearchUser IDSTR15_User_IDString15
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_NameString64
3BCHSOURC SearchBatch SourceSTR15String15
4BACHNUMB SearchBatch NumberSTR15_LBAUString15
5PRRPTFAR SearchPrint Report Flag ArrayCBBoolean0
6PRRPTFAR_1 SearchPrint Report Flag Array[1]CBBoolean0
7PRRPTFAR_2 SearchPrint Report Flag Array[2]CBBoolean0
8PRRPTFAR_3 SearchPrint Report Flag Array[3]CBBoolean0
9PRRPTFAR_4 SearchPrint Report Flag Array[4]CBBoolean0
10PRRPTFAR_5 SearchPrint Report Flag Array[5]CBBoolean0
11PRRPTFAR_6 SearchPrint Report Flag Array[6]CBBoolean0
12PRTSCRAR SearchPrint To Screen ArrayCBBoolean0
13PRTSCRAR_1 SearchPrint To Screen Array[1]CBBoolean0
14PRTSCRAR_2 SearchPrint To Screen Array[2]CBBoolean0
15PRTSCRAR_3 SearchPrint To Screen Array[3]CBBoolean0
16PRTSCRAR_4 SearchPrint To Screen Array[4]CBBoolean0
17PRTSCRAR_5 SearchPrint To Screen Array[5]CBBoolean0
18PRTSCRAR_6 SearchPrint To Screen Array[6]CBBoolean0
19PRTPRARR SearchPrint To Printer ArrayCBBoolean0
20PRTPRARR_1 SearchPrint To Printer Array[1]CBBoolean0
21PRTPRARR_2 SearchPrint To Printer Array[2]CBBoolean0
22PRTPRARR_3 SearchPrint To Printer Array[3]CBBoolean0
23PRTPRARR_4 SearchPrint To Printer Array[4]CBBoolean0
24PRTPRARR_5 SearchPrint To Printer Array[5]CBBoolean0
25PRTPRARR_6 SearchPrint To Printer Array[6]CBBoolean0
26EXPTFTAR SearchExport File Type ArrayINTInteger0
27EXPTFTAR_1 SearchExport File Type Array[1]INTInteger0
28EXPTFTAR_2 SearchExport File Type Array[2]INTInteger0
29EXPTFTAR_3 SearchExport File Type Array[3]INTInteger0
30EXPTFTAR_4 SearchExport File Type Array[4]INTInteger0
31EXPTFTAR_5 SearchExport File Type Array[5]INTInteger0
32EXPTFTAR_6 SearchExport File Type Array[6]INTInteger0
33FEXPNMAR SearchFile Export Name ArraySTR255String255
34FEXPNMAR_1 SearchFile Export Name Array[1]STR255String255
35FEXPNMAR_2 SearchFile Export Name Array[2]STR255String255
36FEXPNMAR_3 SearchFile Export Name Array[3]STR255String255
37FEXPNMAR_4 SearchFile Export Name Array[4]STR255String255
38FEXPNMAR_5 SearchFile Export Name Array[5]STR255String255
39FEXPNMAR_6 SearchFile Export Name Array[6]STR255String255
40DEX_ROW_ID Searchintint10

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 *