Table: fiscal_year

Previous: fiscal_week Unanet Data Model Next: fiscal_year_org_close
Columns
  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      
Referenced from
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
Check Constraints
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')
Indices
Index Name Unique Column Name Asc Or Desc
pk_fiscal_year true fiscal_year_key Asc
idx_fiscal_year1 true name Asc