Table Data dictionary report - gl_history_divisions

Generated: 2018-10-17 8:18:42 AM
Server: PostgreSQL 9.3 (localhost:5432)
Database: datadict_donotremove
Schema: public

Notes:

Table for General Ledger divisions as they were when the Year End Close was performed for the Fiscal Year ending as stated in year_end. Only one record will exist for non divisionalized companies. One extra record, '000', will exist for divisionalized companies for the consolidated division.

Columns

Name	Data type	Not Null?	Primary key?	Default	Comment
id	integer	Yes	Yes	nextval('gl_history_divisions_id_seq'::regclass)	Unique identifier
division	character varying(3)	No	No		Division code; 000 = non divisionlized company or consolidated division for multi division company
name	character varying(60)	No	No		Division name
_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_divisions_pkey	Primary key	(id)