GL00105 - Account Index Master
Contains concatenated account numbers and is the primary lookup table for ACTINDX references throughout all GP modules.
SQL Query Builder
13 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 | ||
| ACTNUMBR_1 | char(5) '' | |||
| ACTNUMBR_2 | char(5) '' | |||
| ACTNUMBR_3 | char(5) '' | |||
| ACTNUMBR_4 | char(5) '' | |||
| ACTNUMBR_5 | char(5) '' | |||
| ACTNUMBR_6 | char '' | |||
| ACTNUMST | char(129) '' | |||
| ACTNUMBR_7 | char '' | |||
| DEX_ROW_ID | int auto number (1,1) | |||
| ACTNUMBR_8 | char '' | |||
| ACTNUMBR_9 | char '' | |||
| ACTNUMBR_10 | char '' |
Reporting Tips
- - This is the most-joined GL table - nearly every transaction table uses ACTINDX to reference accounts
- - Contains the full concatenated account string (ACTNUMST) that users see in GP windows
Related Tables
Tables that share columns with GL00105. Click "Join" to add to your query.