Table Data dictionary report - gl_periods

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

Table of General Ledger Periods for Last Year, This Year and Next Year

Columns

Name Data type Not Null? Primary key? Default Comment
year character(1) Yes Yes Period fiscal year identifier; L = Last year T = This year N = Next year
period smallint Yes Yes Period number 1 - 13 for each for year
end_date date No No Period end date
start_date date No No Period start date
year_end date No No Fiscal Year End date for this period
locked boolean Yes No false Period locked flag; FALSE = Period is not locked TRUE = Period is locked

Constraints

Name Type Definition Comment
gl_periods_pkey Primary key (year, period)

Report generated by pgAdmin3 LTS by BigSQL