Table Data dictionary report - gl_history_periods

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

Notes:

Table for General Ledger Fiscal Periods 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_periods_id_seq'::regclass)	Unique identifier
period	smallint	No	No		Period number 1 - 13
end_date	date	No	No		Period end date
year_end	date	No	No		Fiscal Year End date for this period
start_date	date	No	No		Period start date

Constraints

Name	Type	Definition	Comment
gl_history_periods_pkey	Primary key	(id)