Previous: fiscal_week | Unanet Data Model | Next: fiscal_year_org_close |
Column Name | Data Type | Default Value |
References Table |
Foreign Key Name |
||
1. | PK | fiscal_year_key | decimal(15) | |||
2. | name | varchar(128) | ||||
3. | begin_date | datetime | ||||
4. | end_date | datetime | ||||
5. | rate_update_date | datetime |
Table | Column | Foreign Key Name |
budget | fiscal_year_key | fk_budget3 |
cost_struct_pool_rate | fiscal_year_key | fk_cost_struct_pool_rate2 |
fiscal_month | fiscal_year_key | fk_fiscal_month1 |
fiscal_quarter | fiscal_year_key | fk_fiscal_quarter1 |
fiscal_week | fiscal_year_key | fk_fiscal_week1 |
fiscal_year_org_close | fiscal_year_key | fk_fiscal_year_org_close1 |
Name | Definition |
cc_fiscal_year_begin_date | ([begin_date]>='1900-01-01' AND [begin_date]<='2099-12-31') |
cc_fiscal_year_end_date | ([end_date]>='1900-01-01' AND [end_date]<='2099-12-31') |
Index Name | Unique | Column Name | Asc Or Desc |
pk_fiscal_year | true | fiscal_year_key | Asc |
idx_fiscal_year1 | true | name | Asc |