Table Data dictionary report - gl_periods

Generated: 9/23/2016 2:38:49 PM
Server: PostgreSQL 9.3 (localhost:5432)
Database: datadict
Schema: public

Columns

Name Data type Not Null? Primary key? Default Comment
year character(1) Yes Yes Period year T = This yesr L = Last year N = Next year
period smallint Yes Yes Period number 1-12 or 1-13 for each of this, next and last year.
end_date date No No Period end date
start_date date No No Period start date
year_end date No No Year end date for each of this, last and next year periods
locked boolean Yes No false TRUE = Period is locked FALSE = Period is not locked

Constraints

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

Report generated by pgAdmin III