GL10110 - Open Year Summary Master
Contains period-level summary balances for all accounts in open (current) fiscal years. Updated each time transactions are posted.
SQL Query Builder
19 Columns
| Column | Description | Type | Length | |
|---|---|---|---|---|
| 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 | ||
| YEAR1 | smallint 0 | |||
| PERIODID | smallint 0 | |||
| Ledger_ID | smallint 0 | |||
| PERDBLNC | numeric(19,5) 0.00 | |||
| ACTNUMBR_1 | char(5) '' | |||
| ACTNUMBR_2 | char(5) '' | |||
| ACTNUMBR_3 | char(5) '' | |||
| ACTNUMBR_4 | char(5) '' | |||
| ACTNUMBR_5 | char(5) '' | |||
| ACTNUMBR_6 | char '' | |||
| ACCATNUM | smallint 0 | |||
| ACTNUMBR_7 | char '' | |||
| CRDTAMNT | numeric(19,5) 0.00 | |||
| DEBITAMT | numeric(19,5) 0.00 | |||
| ACTNUMBR_8 | char '' | |||
| ACTNUMBR_9 | char '' | |||
| DEX_ROW_ID | int auto number (1,1) | |||
| ACTNUMBR_10 | char '' |
Reporting Tips
- - Prefer the GL11110 view which shows debits, credits, and net changes per period with account descriptions
- - Period columns (PERDBLNC) store cumulative balances
Related Tables
Tables that share columns with GL10110. Click "Join" to add to your query.