Transaction Work (GL10000)

Easily find this page again using the shortlink: https://gpt.azrcrv.co.uk/GL10000

Product: Microsoft Dynamics GP (0)
Series: Financial

Display Name: Transaction Work
Physical Name: GL10000
Technical Name: GL_TRX_HDR_WORK

Group Display Name: Transaction Work
Group Technical Name: Transaction Work

Seq NoPhysical NameDisplay NameDexterity Data TypeSQL Data TypeLength
1BACHNUMB SearchBatch NumberSTR15_LBAUString15
Partial key to the PA Report Posting Definitions Master (SY00500).

Click to show/hide

SELECT
       ['Transaction Work'].BACHNUMB AS 'Transaction Work-Batch Number'
       ,['PA Report Posting Definitions Master'].BACHNUMB AS 'PA Report Posting Definitions Master-Batch Number'
FROM
       GL10000 AS ['Transaction Work']
INNER JOIN
       SY00500 AS ['PA Report Posting Definitions Master']
              ON
                     ['Transaction Work'].BACHNUMB = ['PA Report Posting Definitions Master'].BACHNUMB
              AND
                     ['Transaction Work'].BCHSOURC = ['PA Report Posting Definitions Master'].BCHSOURC
2BCHSOURC SearchBatch SourceSTR15String15
3JRNENTRY SearchJournal EntryLI8_U0Long Integer8
4RCTRXSEQ SearchRecurring TRX SequenceDLR19_$S2Currency19
5SOURCDOC SearchSource DocumentSTR10_Source_DocumentString10
Key to the Source Document Master (SY00900).

Click to show/hide

SELECT
       ['Transaction Work'].SOURCDOC AS 'Transaction Work-Source Document'
       ,['Source Document Master'].SOURCDOC AS 'Source Document Master-Source Document'
FROM
       GL10000 AS ['Transaction Work']
INNER JOIN
       SY00900 AS ['Source Document Master']
              ON
                     ['Transaction Work'].SOURCDOC = ['Source Document Master'].SOURCDOC
6REFRENCE SearchReferenceSTR30String30
7TRXDATE SearchTRX DateDT_DateDate6
8RVRSNGDT SearchReversing DateDT_DateDate6
9RCRNGTRX SearchRecurring TRXYNBoolean0
10BALFRCLC SearchBalance For CalculationGBInteger0
11PSTGSTUS SearchPosting StatusINTInteger0
12LASTUSER SearchLast UserUser_IDString15
The key to the Users Master (SY01400).

Click to show/hide

SELECT
       ['Transaction Work'].LASTUSER AS 'Transaction Work-Last User'
       ,['Users Master'].USERID AS 'Users Master-User ID'
FROM
       GL10000 AS ['Transaction Work']
INNER JOIN
       DYNAMICS..SY01400 AS ['Users Master']
              ON
                     ['Transaction Work'].LASTUSER = ['Users Master'].USERID
13LSTDTEDT SearchLast Date EditedDT_DateDate6
14USWHPSTD SearchUser Who PostedUser_IDString15
Key to the Users Master (SY01400).

Click to show/hide

SELECT
       ['Transaction Work'].USWHPSTD AS 'Transaction Work-User Who Posted'
       ,['Users Master'].USERID AS 'Users Master-User ID'
FROM
       GL10000 AS ['Transaction Work']
INNER JOIN
       DYNAMICS..SY01400 AS ['Users Master']
              ON
                     ['Transaction Work'].USWHPSTD = ['Users Master'].USERID
15TRXTYPE SearchTransaction TypeGBInteger0
16SQNCLINE SearchSequence LineDLR19_$S2Currency19
17GLHDRMSG SearchGL HDR MessagesML_GL_HDR_MessagesLong Integer0
18GLHDRMS2 SearchGL HDR Messages2ML_GL_HDR_Messages_2Long Integer0
19TRXSORCE SearchTRX SourceSTR13String13
20RVTRXSRC SearchReversing TRX SourceSTR13String13
21SERIES SearchSeriesDDL_SeriesInteger0
22ORTRXTYP SearchOriginating TRX TypeINTInteger0
23ORPSTDDT SearchOriginating Posted DateDT_DateDate6
24ORCTRNUM SearchOriginating Control NumberSTR20String20
For transactions originating in the Purchasing series, this is the key to the PM Key Master File (PM00400).

Click to show/hide

SELECT
       ['Transaction Work'].ORCTRNUM AS 'Transaction Work-Originating Control Number'
       ,['PM Key Master File'].CNTRLNUM AS 'PM Key Master File-Control Number'
FROM
       GL10000 AS ['Transaction Work']
INNER JOIN
       PM00400 AS ['PM Key Master File']
              ON
                     ['Transaction Work'].ORCTRNUM = ['PM Key Master File'].CNTRLNUM
25ORTRXSRC SearchOriginating TRX SourceSTR13String13
26OrigDTASeries SearchOriginating DTA SeriesINTInteger0
27ORMSTRID SearchOriginating Master IDSTR30String30
For transactions originating in the Purchasing series, this is the key to the PM Vendor Master File (PM00200).

Click to show/hide

SELECT
       ['Transaction Work'].ORMSTRID AS 'Transaction Work-Originating Master ID'
       ,['PM Vendor Master File'].VENDORID AS 'PM Vendor Master File-Vendor ID'
FROM
       GL10000 AS ['Transaction Work']
INNER JOIN
       PM00200 AS ['PM Vendor Master File']
              ON
                     ['Transaction Work'].ORMSTRID = ['PM Vendor Master File'].VENDORID
28DTAControlNum SearchDTA Control NumberSTR20String20
29ORMSTRNM SearchOriginating Master NameSTR64String64
30ORDOCNUM SearchOriginating Document NumberSTR20String20
31DTATRXType SearchDTA TRX TypeINTInteger0
32DTA_Index SearchDTA IndexDLR14Currency14
33CURNCYID SearchCurrency IDSTR15_Currency_IDString15
Key to the Currency Setup (MC40200).

Click to show/hide

SELECT
       ['Transaction Work'].CURNCYID AS 'Transaction Work-Currency ID'
       ,['Currency Setup'].CURNCYID AS 'Currency Setup-Currency ID'
FROM
       GL10000 AS ['Transaction Work']
INNER JOIN
       DYNAMICS..MC40200 AS ['Currency Setup']
              ON
                     ['Transaction Work'].CURNCYID = ['Currency Setup'].CURNCYID
34CURRNIDX SearchCurrency IndexINT3Integer3
Key to the Currency Setup (MC40200).

Click to show/hide

SELECT
       ['Transaction Work'].CURRNIDX AS 'Transaction Work-Currency Index'
       ,['Currency Setup'].CURRNIDX AS 'Currency Setup-Currency Index'
FROM
       GL10000 AS ['Transaction Work']
INNER JOIN
       DYNAMICS..MC40200 AS ['Currency Setup']
              ON
                     ['Transaction Work'].CURRNIDX = ['Currency Setup'].CURRNIDX
35RATETPID SearchRate Type IDSTR15_Rate_Type_IDString15
Key to the Multicurrency Rate Type Setup (MC40100).

Click to show/hide

SELECT
       ['Transaction Work'].RATETPID AS 'Transaction Work-Rate Type ID'
       ,['Multicurrency Rate Type Setup'].RATETPID AS 'Multicurrency Rate Type Setup-Rate Type ID'
FROM
       GL10000 AS ['Transaction Work']
INNER JOIN
       MC40100 AS ['Multicurrency Rate Type Setup']
              ON
                     ['Transaction Work'].RATETPID = ['Multicurrency Rate Type Setup'].RATETPID
36EXGTBLID SearchExchange Table IDSTR15_Exchange_Table_IDString15
Key to the Multicurrency Exchange Rate Maintenance (MC00100).

Click to show/hide

SELECT
       ['Transaction Work'].EXGTBLID AS 'Transaction Work-Exchange Table ID'
       ,['Multicurrency Exchange Rate Maintenance'].EXGTBLID AS 'Multicurrency Exchange Rate Maintenance-Exchange Table ID'
FROM
       GL10000 AS ['Transaction Work']
INNER JOIN
       DYNAMICS..MC00100 AS ['Multicurrency Exchange Rate Maintenance']
              ON
                     ['Transaction Work'].EXGTBLID = ['Multicurrency Exchange Rate Maintenance'].EXGTBLID
37XCHGRATE SearchExchange RateDLR14_Exchange_RateCurrency (Variable)14
38EXCHDATE SearchExchange DateDT_DateDate6
39TIME1 SearchTimeTM6Time6
40RTCLCMTD SearchRate Calculation MethodGBInteger0
41NOTEINDX SearchNote IndexDLR14Currency14
Key to the Record Notes Master (SY03900).

Click to show/hide

SELECT
       ['Transaction Work'].NOTEINDX AS 'Transaction Work-Note Index'
       ,['Record Notes Master'].NOTEINDX AS 'Record Notes Master-Note Index'
FROM
       GL10000 AS ['Transaction Work']
INNER JOIN
       SY03900 AS ['Record Notes Master']
              ON
                     ['Transaction Work'].NOTEINDX = ['Record Notes Master'].NOTEINDX
42GLHDRVAL SearchGL Header ValidML_GL_Header_ValidLong Integer0
43PERIODID SearchPeriod IDINT3Integer3
44OPENYEAR SearchOpen YearINT4_S0Integer4
45CLOSEDYR SearchClosed YearINT4_S0Integer4
46HISTRX SearchHistory TRXBooleanBoolean0
47REVPRDID SearchReversing Period IDINT3Integer3
48REVYEAR SearchReversing YearINT4_S0Integer4
49REVCLYR SearchReversing Closed YearINT4_S0Integer4
50REVHIST SearchReversing History TRXBooleanBoolean0
51ERRSTATE SearchError StateLong IntLong Integer8
52ICTRX SearchIC TRXCB_IC_TRXBoolean0

Click to show/hide Intercompany flag


0	Not intercompany.
1	Intercompany
53ORCOMID SearchOriginating Company IDSTR5_IC_IDString5
Key to the Company Master (SY01500).

Click to show/hide

SELECT
       ['Transaction Work'].ORCOMID AS 'Transaction Work-Originating Company ID'
       ,['Company Master'].CMPANYID AS 'Company Master-Company ID'
FROM
       GL10000 AS ['Transaction Work']
INNER JOIN
       DYNAMICS..SY01500 AS ['Company Master']
              ON
                     ['Transaction Work'].ORCOMID = ['Company Master'].CMPANYID
54ORIGINJE SearchOriginating Journal EntryLI8_U0Long Integer8
55ICDISTS SearchICDistsBooleanBoolean0

Click to show/hide Intercompany distirubtions


0	Not intercompany.
1	Intercompany distributions present.
56PRNTSTUS SearchPrinting StatusINTInteger0
57DENXRATE SearchDenomination Exchange RateDLR14_Exchange_RateCurrency (Variable)14
58MCTRXSTT SearchMC Transaction StateINT1Integer1
MC Transaction State of the transaction. State the transaction was created in. For non multi-currency transactions, this field will be blank.

Click to show/hide MC Transaction States

0	Euro currency is not created or no denomination currencies are enabled.
		1	Originating is not a denomination; Functional is not a denomination
		2	Originating is not a denomination; Functional is the Euro currency.
		3	Originating is not a denomination; Functional is a denomination.
		4	Originating is a denomination; Functional is not a denomination.
		5	Originating is a denomination; Functional is a denomination.
		6	Originating is a denomination; Functional is the Euro currency.
		7	Originating is the Euro currency; Functional is a denomination.
		8	Originating is the Euro currency; Functional is not a denomination.
59DOCDATE SearchDocument DateDTDate8
60Tax_Date SearchTax DateDTDate8
61VOIDED SearchVoidedCBBoolean0
62Original_JE SearchOriginal JELI8_U0Long Integer8
63Original_JE_Year SearchOriginal JE YearINTInteger0
64Original_JE_Seq_Num SearchOriginal JE Seq NumDLR19_$S2Currency19
65Correcting_Trx_Type SearchCorrecting Trx TypeINTInteger0
66Ledger_ID SearchLedger IDINT2Integer2
67Adjustment_Transaction SearchAdjustment TransactionCB Adjustment TrxBoolean0
68DEX_ROW_TS Searchdatetimedatetime3
DEX_ROW_TS records the time the record was last changed; often used with integration tools to identify which records have changed and need to be synchronised.
69DEX_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.

Leave a Reply

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