| id |
integer |
Yes |
Yes |
nextval('gl_groups_id_seq'::regclass) |
Unique identifier |
| gl_group |
character varying(3) |
No |
No |
|
Group code |
| name |
character varying(60) |
No |
No |
|
Group name as assigned by user |
| alias |
character varying(60) |
No |
No |
|
Group name to print on reports |
| acct_type |
character varying(1) |
No |
No |
|
Account type; A = Asset L = Liability and Equity R = Revenue X = Expense |
| total_heading |
character varying(60) |
No |
No |
|
Text to display beside Total on Reports |
| total |
smallint |
No |
No |
|
Total Flag; 0 = No total 1 = Total with reset 2 = Total with no reset |
| line_advance |
character varying(1) |
No |
No |
|
Line advance setting for reports; 0 = No additional lines 1 - 5 = Number of additional lines to advance P = Page advance |
| _dbversion |
integer |
No |
No |
|
Program version that last modified this record |
| _created |
timestamp without time zone |
No |
No |
|
UTC Date and time record was created |
| _created_by |
character varying(3) |
No |
No |
|
User initials that created this record |
| _modified |
timestamp without time zone |
No |
No |
|
UTC Date and time record was last modified |
| _modified_by |
character varying(3) |
No |
No |
|
User initials that modified this record |