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

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


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


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

Report generated by pgAdmin3 LTS by BigSQL