Table: journal_time

Columns
		Column Name	Data Type	Default Value	References Table	Foreign Key Name
1.	PK	journal_key	decimal(15)
2.		journal_trans_date	datetime
3.		time_data_key	decimal(15)		person_time_data	fk_journal_time1
4.		organization_key	decimal(15)		customer	fk_journal_time6
5.		general_ledger_key	decimal(15)		general_ledger	fk_journal_time7
6.		account_key	decimal(15)		account	fk_journal_time2
7.		post_history_key	decimal(15)		post_history	fk_journal_time4
8.		invoice_key	decimal(15)		invoice	fk_journal_time5
9.		project_key	decimal(15)		project	fk_journal_time3
10.		category	tinyint
11.		amount	decimal(18,2)
12.		extract_date	datetime

Foreign Keys
Column	References		Foreign Key Name
Column	Table	Column	Foreign Key Name
account_key	account	account_key	fk_journal_time2
organization_key	customer	customer_key	fk_journal_time6
general_ledger_key	general_ledger	general_ledger_key	fk_journal_time7
invoice_key	invoice	invoice_key	fk_journal_time5
time_data_key	person_time_data	time_data_key	fk_journal_time1
post_history_key	post_history	post_history_key	fk_journal_time4
project_key	project	project_key	fk_journal_time3

Check Constraints
Name	Definition
cc_journal_time_category	([category]>=(1) AND [category]<=(99))
cc_journal_time_source	([post_history_key] IS NOT NULL AND [invoice_key] IS NULL OR [post_history_key] IS NULL AND [invoice_key] IS NOT NULL)
cc_jt_journal_trans_date	([journal_trans_date]>='1900-01-01' AND [journal_trans_date]<='2099-12-31')

Indices
Index Name	Unique	Column Name	Asc Or Desc
pk_journal_time	true	journal_key	Asc
idx_journal_time1	false	project_key	Asc
idx_journal_time2	false	invoice_key	Asc
idx_journal_time3	false	time_data_key	Asc
idx_journal_time4	false	organization_key	Asc
idx_journal_time5	false	general_ledger_key	Asc
idx_journal_time6	false	account_key	Asc
idx_journal_time7	false	post_history_key	Asc

Dependent Views
View Name
journal_view
vendor_payment_1099_view