Table: budget

Previous: billing_type

Unanet Data Model

Next: budget_detail

Columns

		Column Name	Data Type	Default Value	References Table	Foreign Key Name
1.	PK	budget_key	decimal(15)
2.		budget_name_key	decimal(15)		budget_name	fk_budget1
3.		legal_entity_key	decimal(15)		customer	fk_budget2
4.		fiscal_year_key	decimal(15)		fiscal_year	fk_budget3
5.		type	char(1)	('I')

Foreign Keys

Column	References		Foreign Key Name
	Table	Column
budget_name_key	budget_name	budget_name_key	fk_budget1
legal_entity_key	customer	customer_key	fk_budget2
fiscal_year_key	fiscal_year	fiscal_year_key	fk_budget3

Referenced from

Table	Column	Foreign Key Name
budget_organization	budget_key	fk_budget_organization1
cost_pool_group_calc	budget_key	fk_cost_pool_group_calc7

Check Constraints

Name	Definition
cc_budget_type	([type]='B' OR [type]='I')

Indices

Index Name	Unique	Column Name	Asc Or Desc
pk_budget	true	budget_key	Asc
idx_budget1	true	budget_name_key	Asc
		legal_entity_key
		fiscal_year_key
		type
idx_budget2	false	legal_entity_key	Asc
idx_budget3	false	fiscal_year_key	Asc