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 TypeSQL DB LengthKeyable Length
1BACHNUMB SearchBatch NumberSTR15_LBAUString1615
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 SourceSTR15String1615
3JRNENTRY SearchJournal EntryLI8_U0Long Integer48
4RCTRXSEQ SearchRecurring TRX SequenceDLR19_$S2Currency1019
5SOURCDOC SearchSource DocumentSTR10_Source_DocumentString1210
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 SearchReferenceSTR30String3230
7TRXDATE SearchTRX DateDT_DateDate46
8RVRSNGDT SearchReversing DateDT_DateDate46
9RCRNGTRX SearchRecurring TRXYNBoolean20
10BALFRCLC SearchBalance For CalculationGBInteger20
11PSTGSTUS SearchPosting StatusINTInteger20
12LASTUSER SearchLast UserUser_IDString1615
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_DateDate46
14USWHPSTD SearchUser Who PostedUser_IDString1615
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 TypeGBInteger20
16SQNCLINE SearchSequence LineDLR19_$S2Currency1019
17GLHDRMSG SearchGL HDR MessagesML_GL_HDR_MessagesLong Integer40
18GLHDRMS2 SearchGL HDR Messages2ML_GL_HDR_Messages_2Long Integer40
19TRXSORCE SearchTRX SourceSTR13String1413
20RVTRXSRC SearchReversing TRX SourceSTR13String1413
21SERIES SearchSeriesDDL_SeriesInteger20
22ORTRXTYP SearchOriginating TRX TypeINTInteger20
23ORPSTDDT SearchOriginating Posted DateDT_DateDate46
24ORCTRNUM SearchOriginating Control NumberSTR20String2220
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 SourceSTR13String1413
26OrigDTASeries SearchOriginating DTA SeriesINTInteger20
27ORMSTRID SearchOriginating Master IDSTR30String3230
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 NumberSTR20String2220
29ORMSTRNM SearchOriginating Master NameSTR64String6664
30ORDOCNUM SearchOriginating Document NumberSTR20String2220
31DTATRXType SearchDTA TRX TypeINTInteger20
32DTA_Index SearchDTA IndexDLR14Currency1014
33CURNCYID SearchCurrency IDSTR15_Currency_IDString1615
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 IndexINT3Integer23
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_IDString1615
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_IDString1615
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)1014
38EXCHDATE SearchExchange DateDT_DateDate46
39TIME1 SearchTimeTM6Time46
40RTCLCMTD SearchRate Calculation MethodGBInteger20
41NOTEINDX SearchNote IndexDLR14Currency1014
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 Integer40
43PERIODID SearchPeriod IDINT3Integer23
44OPENYEAR SearchOpen YearINT4_S0Integer24
45CLOSEDYR SearchClosed YearINT4_S0Integer24
46HISTRX SearchHistory TRXBooleanBoolean20
47REVPRDID SearchReversing Period IDINT3Integer23
48REVYEAR SearchReversing YearINT4_S0Integer24
49REVCLYR SearchReversing Closed YearINT4_S0Integer24
50REVHIST SearchReversing History TRXBooleanBoolean20
51ERRSTATE SearchError StateLong IntLong Integer48
52ICTRX SearchIC TRXCB_IC_TRXBoolean20

Click to show/hide Intercompany flag


0	Not intercompany.
1	Intercompany
53ORCOMID SearchOriginating Company IDSTR5_IC_IDString65
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 Integer48
55ICDISTS SearchICDistsBooleanBoolean20

Click to show/hide Intercompany distirubtions


0	Not intercompany.
1	Intercompany distributions present.
56PRNTSTUS SearchPrinting StatusINTInteger20
57DENXRATE SearchDenomination Exchange RateDLR14_Exchange_RateCurrency (Variable)1014
58MCTRXSTT SearchMC Transaction StateINT1Integer21
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 DateDTDate48
60Tax_Date SearchTax DateDTDate48
61VOIDED SearchVoidedCBBoolean20
62Original_JE SearchOriginal JELI8_U0Long Integer48
63Original_JE_Year SearchOriginal JE YearINTInteger20
64Original_JE_Seq_Num SearchOriginal JE Seq NumDLR19_$S2Currency1019
65Correcting_Trx_Type SearchCorrecting Trx TypeINTInteger20
66Ledger_ID SearchLedger IDINT2Integer22
67Adjustment_Transaction SearchAdjustment TransactionCB Adjustment TrxBoolean20
68DEX_ROW_TS Searchdatetimedatetime33
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 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.

Leave a Reply

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