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) |