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
Foreign Keys
Column References Foreign Key Name
Table Column
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_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_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