| id |
integer |
Yes |
Yes |
nextval('gl_history_subgroups_id_seq'::regclass) |
Unique identifier |
| subgroup |
character varying(6) |
No |
No |
|
General Ledger subgroup code |
| name |
character varying(60) |
No |
No |
|
Subgroup name or description |
| gl_group |
character varying(3) |
No |
No |
|
General Ledger group that this subgroup is a member of - links to gl_history_groups.gl_group |
| suppress_flag |
boolean |
No |
No |
|
Suppress flag to use for reporting; FALSE = Do not supporess TRUE = Suppress on reports |
| _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 |
| year_end |
date |
No |
No |
|
Fiscal Year End for this history record |