GL10111 - Historical Year Summary Master
Contains period-level summary balances for closed fiscal years.
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 | |||
| ACTNUMBR_1 | char(5) '' | |||
| ACTNUMBR_2 | char(5) '' | |||
| ACTNUMBR_3 | char(5) '' | |||
| ACTNUMBR_4 | char(5) '' | |||
| ACTNUMBR_5 | char(5) '' | |||
| ACCATNUM | smallint 0 | |||
| ACTNUMBR_6 | char '' | |||
| ACTNUMBR_7 | char '' | |||
| PERDBLNC | numeric(19,5) 0.00 | |||
| ACTNUMBR_8 | char '' | |||
| CRDTAMNT | numeric(19,5) 0.00 | |||
| DEBITAMT | numeric(19,5) 0.00 | |||
| ACTNUMBR_9 | char '' | |||
| ACTNUMBR_10 | char '' | |||
| DEX_ROW_ID | int auto number (1,1) |
Reporting Tips
- - Prefer the GL11111 view for reporting - it includes calculated net changes and account descriptions
Related Tables
Tables that share columns with GL10111. Click "Join" to add to your query.