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 |
Name | Type | Definition | Comment |
---|---|---|---|
gl_periods_pkey | Primary key | (year, period) |