GL20000 - Open Year Posted Transactions
Stores all posted GL journal entry detail for open (current) fiscal years. This is the primary GL transaction detail table.
SQL Query Builder
66 Columns
| Column | Description | Type | Length | ||
|---|---|---|---|---|---|
| OPENYEAR | smallint 0 | ||||
| JRNENTRY | int 0 | ||||
| RCTRXSEQ | numeric(19,5) 0.00 | ||||
| SOURCDOC | char(11) '' | ||||
| REFRENCE | char(31) '' | ||||
| DSCRIPTN | char(31) '' | ||||
| TRXDATE | datetime '1/1/1900' | ||||
| TRXSORCE | char(13) '' | ||||
| ACTINDX | Links to GL00105 to get the full concatenated account number and description. This is the primary key for account lookups across all modules. | int 0 | |||
| POLLDTRX | tinyint 0 | ||||
| LASTUSER | char(15) '' | ||||
| LSTDTEDT | datetime '1/1/1900' | ||||
| USWHPSTD | char(15) '' | ||||
| ORGNTSRC | char(15) '' | ||||
| ORGNATYP | smallint 0 | ||||
| QKOFSET | smallint 0 | ||||
| SERIES | smallint 0 | ||||
Module Series values (8) 1 = All2 = Financial3 = Sales4 = Purchasing5 = Inventory6 = Payroll7 = Project10 = 3rd Party | |||||
| ORTRXTYP | smallint 0 | ||||
| ORCTRNUM | char(21) '' | ||||
| ORMSTRID | char(31) '' | ||||
| ORMSTRNM | char(65) '' | ||||
| ORDOCNUM | char(21) '' | ||||
| ORPSTDDT | datetime '1/1/1900' | ||||
| ORTRXSRC | char(13) 0 | ||||
| OrigDTASeries | smallint 0 | ||||
| OrigSeqNum | int 0 | ||||
| SEQNUMBR | int 0 | ||||
| DTA_GL_Status | smallint 0 | ||||
| DTA_Index | numeric(19,5) 0.00 | ||||
| CURNCYID | Functional currency code (e.g., USD, CAD, GBP). Use to filter or group multicurrency transactions. | char(15) '' | |||
| CURRNIDX | smallint 0 | ||||
| RATETPID | char(15) '' | ||||
| EXGTBLID | char(15) '' | ||||
| XCHGRATE | numeric(19,7) 0.00 | ||||
| EXCHDATE | datetime '1/1/1900' | ||||
| TIME1 | datetime '1/1/1900' | ||||
| RTCLCMTD | smallint 0 | ||||
| NOTEINDX | numeric(19,5) 0.00 | ||||
| ICTRX | tinyint 0 | ||||
| ORCOMID | char(5) '' | ||||
| ORIGINJE | int 0 | ||||
| PERIODID | smallint 0 | ||||
| CRDTAMNT | numeric(19,5) 0.00 | ||||
| DEBITAMT | numeric(19,5) 0.00 | ||||
| ORCRDAMT | numeric(19,5) 0.00 | ||||
| ORDBTAMT | numeric(19,5) 0.00 | ||||
| DOCDATE | datetime '1/1/1900' | ||||
| PSTGNMBR | int 0 | ||||
| PPSGNMBR | int 0 | ||||
| DENXRATE | numeric(19,7) 0.00 | ||||
| MCTRXSTT | smallint 0 | ||||
| CorrespondingUnit | char(5) '' | ||||
| VOIDED | tinyint 0 | ||||
| Back_Out_JE | int 0 | ||||
| Back_Out_JE_Year | smallint 0 | ||||
| Correcting_JE | int 0 | ||||
| Correcting_JE_Year | smallint 0 | ||||
| Original_JE | int 0 | ||||
| Original_JE_Seq_Num | numeric(19,5) 0.00 | ||||
| Original_JE_Year | smallint 0 | ||||
| Ledger_ID | smallint 0 | ||||
| Adjustment_Transaction | tinyint 0 | ||||
| APRVLUSERID | char '' | ||||
| DEX_ROW_TS | datetime (getutcdate()) | ||||
| DEX_ROW_ID | int auto number (1,1) | ||||
| APPRVLDT | datetime '1/1/1900' | ||||
Reporting Tips
- - JRNENTRY + RCTRXSEQ typically forms a unique identifier
- - Include CURNCYID in uniqueness checks for multicurrency environments
- - Use SERIES to filter by originating module
Related Tables
Tables that share columns with GL20000. Click "Join" to add to your query.