Table Data dictionary report - gl_history_subgroups

Generated: 2018-10-17 2:51:19 PM
Server: PostgreSQL 9.3 (localhost:5432)
Database: datadict_donotremove
Schema: public
Notes:

Table for General Ledger subgroups as they were when the Year End Close was performed for the Fiscal Year ending as stated in year_end.

Columns

Name Data type Not Null? Primary key? Default Comment
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

Constraints

Name Type Definition Comment
gl_history_subgroups_pkey Primary key (id)

Report generated by pgAdmin3 LTS by BigSQL