Table: fixed_price

Previous: fiscal_year_org_close

Unanet Data Model

Next: fixed_price_invc_sect_fmt

Columns

		Column Name	Data Type	Default Value	References Table	Foreign Key Name
1.	PK	fixed_price_key	decimal(15)
2.		project_key	decimal(15)		project	fk_fixed_price1
3.		task_key	decimal(15)		task	fk_fixed_price2
4.		invoice_key	decimal(15)		invoice	fk_fixed_price3
5.		post_history_key	decimal(15)		post_history	fk_fixed_price4
6.		billable_post_history_key	decimal(15)		post_history	fk_fixed_price5
7.		bill_date	datetime
8.		use_wbs_end_date	char(1)
9.		description	varchar(128)
10.		amount	decimal(18,2)
11.		rev_rec_method	decimal(1)

Foreign Keys

Column	References		Foreign Key Name
	Table	Column
invoice_key	invoice	invoice_key	fk_fixed_price3
post_history_key	post_history	post_history_key	fk_fixed_price4
billable_post_history_key	post_history	post_history_key	fk_fixed_price5
project_key	project	project_key	fk_fixed_price1
task_key	task	task_key	fk_fixed_price2

Referenced from

Table	Column	Foreign Key Name
fp_revenue_schedule	fixed_price_key	fk_fp_revenue_schedule1
invcd_fixed_price	fixed_price_key	fk_invcd_fixed_price2
journal_fixed_price	fixed_price_key	fk_journal_fixed_price1

Check Constraints

Name	Definition
cc_fp_bill_date	([bill_date]>='1900-01-01' AND [bill_date]<='2099-12-31')
cc_fp_bill_post_history_key	([billable_post_history_key] IS NULL OR [post_history_key] IS NOT NULL)
cc_fp_rev_rec_method	([rev_rec_method]=(3) OR [rev_rec_method]=(2) OR [rev_rec_method]=(1))
cc_fp_use_wbs_end_date	([use_wbs_end_date]='N' OR [use_wbs_end_date]='Y')

Indices

Index Name	Unique	Column Name	Asc Or Desc
pk_fixed_price	true	fixed_price_key	Asc
idx_fixed_price1	false	project_key	Asc
idx_fixed_price2	false	invoice_key	Asc
idx_fixed_price3	false	task_key	Asc
idx_fixed_price4	false	post_history_key	Asc
idx_fixed_price5	false	billable_post_history_key	Asc

Dependent Views

View Name
journal_view