GL00100 - Account Master
Stores the chart of accounts including account names, types, and posting settings. Every GL account in the system has a record here.
SQL Query Builder
43 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) '' | ||||
| ACTALIAS | char(21) '' | ||||
| ACTNUMBR_6 | char '' | ||||
| ACTNUMBR_7 | char '' | ||||
| MNACSGMT | char(67) '' | ||||
| ACTNUMBR_8 | char '' | ||||
| ACCTTYPE | smallint 0 | ||||
Account Type values (4) 1 = Posting Account2 = Unit Account3 = Posting Allocation Account4 = Unit Allocation Account | |||||
| ACTNUMBR_9 | char '' | ||||
| ACTDESCR | char(51) '' | ||||
| ACTNUMBR_10 | char '' | ||||
| PSTNGTYP | smallint 0 | ||||
Posting Type values (2) 0 = Balance Sheet1 = Profit and Loss | |||||
| ACCATNUM | smallint 0 | ||||
| ACTIVE | tinyint 0 | ||||
| TPCLBLNC | smallint 0 | ||||
Typical Balance values (2) 0 = Debit1 = Credit | |||||
| DECPLACS | smallint 0 | ||||
| FXDORVAR | smallint 0 | ||||
Fixed or Variable Allocation values (2) 1 = Fixed Allocation2 = Variable Allocation | |||||
| BALFRCLC | smallint 0 | ||||
| DSPLKUPS | binary(4) 0 | ||||
| CNVRMTHD | smallint 0 | ||||
| HSTRCLRT | numeric(19,7) 0.00 | ||||
| NOTEINDX | numeric(19,5) 0.00 | ||||
| CREATDDT | datetime '1/1/1900' | ||||
| MODIFDT | datetime '1/1/1900' | ||||
| USERDEF1 | char(21) '' | ||||
| USERDEF2 | char(21) '' | ||||
| PostSlsIn | smallint 0 | ||||
| PostIvIn | smallint 0 | ||||
| PostPurchIn | smallint 0 | ||||
| PostPRIn | smallint 0 | ||||
| ADJINFL | tinyint 0 | ||||
| INFLAREV | int 0 | ||||
| INFLAEQU | int 0 | ||||
| ACCTENTR | tinyint 0 | ||||
| USRDEFS1 | char(31) '' | ||||
| USRDEFS2 | char(31) '' | ||||
| Clear_Balance | tinyint 0 | ||||
| DEX_ROW_TS | datetime (getutcdate()) | ||||
| DEX_ROW_ID | int auto number (1,1) | ||||
Reporting Tips
- - Use ACTINDX to link to this table from transaction tables
- - ACCTTYPE distinguishes posting vs unit vs allocation accounts
- - Check INACTIVE field to filter out disabled accounts
Related Tables
Tables that share columns with GL00100. Click "Join" to add to your query.