Table: fin_document

Columns
		Column Name	Data Type	Default Value	References Table	Foreign Key Name
1.	PK	fin_document_key	decimal(15)
2.		legal_entity_key	decimal(15)		customer	fk_fin_document1
3.		document_type	tinyint
4.		document_number	varchar(15)
5.		document_date	datetime
6.		post_date	datetime
7.		last_updated_by	decimal(15)		person	fk_fin_document2
8.		created_by	decimal(15)		person	fk_fin_document3
9.		submitted_by	decimal(15)		person	fk_fin_document4
10.		posted_by	decimal(15)		person	fk_fin_document5
11.		last_updated_timestamp	datetime
12.		created_timestamp	datetime
13.		submitted_timestamp	datetime
14.		posted_timestamp	datetime
15.		reference	varchar(25)
16.		description	varchar(128)
17.		comments	varchar(2000)
18.		voiding_fin_document_key	decimal(15)		fin_document	fk_fin_document6
19.		voided_fin_document_key	decimal(15)		fin_document	fk_fin_document7
20.		status	varchar(25)

Foreign Keys
Column	References		Foreign Key Name
Column	Table	Column	Foreign Key Name
legal_entity_key	customer	customer_key	fk_fin_document1
voiding_fin_document_key	fin_document	fin_document_key	fk_fin_document6
voided_fin_document_key	fin_document	fin_document_key	fk_fin_document7
last_updated_by	person	person_key	fk_fin_document2
created_by	person	person_key	fk_fin_document3
submitted_by	person	person_key	fk_fin_document4
posted_by	person	person_key	fk_fin_document5

Referenced from
Table	Column	Foreign Key Name
customer_payment	fin_document_key	fk_customer_payment1
deposit	fin_document_key	fk_deposit1
deposit_included	included_fin_document_key	fk_deposit_included2
fin_document	voided_fin_document_key	fk_fin_document7
fin_document	voiding_fin_document_key	fk_fin_document6
fin_document_approval	fin_document_key	fk_fd_approval1
fin_document_attachment	fin_document_key	fk_fin_document_attachment1
fin_document_detail	fin_document_key	fk_fin_document_detail1
fin_document_recurring	created_by_fin_document_key	fk_fin_document_recurring2
fin_document_recurring	fin_document_key	fk_fin_document_recurring1
journal_entry	fin_document_key	fk_journal_entry1
vendor_invoice	fin_document_key	fk_vendor_invoice1
vendor_payment	fin_document_key	fk_vendor_payment9
vendor_payment_included	included_fin_document_key	fk_vendor_payment_included2

Check Constraints
Name	Definition
cc_fd_created_timestamp	([created_timestamp]>='1900-01-01' AND [created_timestamp]<='2099-12-31')
cc_fd_document_date	([document_date]>='1900-01-01' AND [document_date]<='2099-12-31')
cc_fd_document_type	([document_type]>=(0) AND [document_type]<=(99))
cc_fd_last_updated_timestamp	([last_updated_timestamp]>='1900-01-01' AND [last_updated_timestamp]<='2099-12-31')
cc_fd_post_date	([post_date]>='1900-01-01' AND [post_date]<='2099-12-31')
cc_fd_posted_timestamp	([posted_timestamp]>='1900-01-01' AND [posted_timestamp]<='2099-12-31')
cc_fd_status	([status]='APPROVED' OR [status]='DISAPPROVED' OR [status]='APPROVING' OR [status]='SUBMITTED' OR [status]='POSTED' OR [status]='INUSE')
cc_fd_submitted_timestamp	([submitted_timestamp]>='1900-01-01' AND [submitted_timestamp]<='2099-12-31')

Indices
Index Name	Unique	Column Name	Asc Or Desc
pk_fin_document	true	fin_document_key	Asc
idx_fin_document1	true	document_number	Asc
		document_type
idx_fin_document2	false	legal_entity_key	Asc
idx_fin_document3	false	last_updated_by	Asc
idx_fin_document4	false	created_by	Asc
idx_fin_document5	false	submitted_by	Asc
idx_fin_document6	false	posted_by	Asc
idx_fin_document7	false	voiding_fin_document_key	Asc
idx_fin_document8	false	voided_fin_document_key	Asc

Dependent Views
View Name
customer_invoice_activity
customer_payment_activity
vendor_invoice_activity
vendor_payment_1099_view
vendor_payment_activity