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)

Report generated by pgAdmin3 LTS by BigSQL