Table: fin_document_detail

Columns
  Column Name Data Type Default
Value
References
Table
Foreign Key
Name
1. PK fin_document_detail_key decimal(15)      
2.   fin_document_key decimal(15)   fin_document fk_fin_document_detail1
3.   account_key decimal(15)   account fk_fin_document_detail2
4.   organization_key decimal(15)   customer fk_fin_document_detail3
5.   reference varchar(25)      
6.   description varchar(128)      
7.   transaction_date datetime      
8.   person_key decimal(15)   person fk_fin_document_detail4
9.   general_ledger_key decimal(15)   general_ledger fk_fin_document_detail5
10.   debit_amount decimal(18,2) ((0))    
11.   credit_amount decimal(18,2) ((0))    
12.   customer_key decimal(15)   customer fk_fin_document_detail6
Foreign Keys
Column References Foreign Key Name
Table Column
account_key account account_key fk_fin_document_detail2
organization_key customer customer_key fk_fin_document_detail3
customer_key customer customer_key fk_fin_document_detail6
fin_document_key fin_document fin_document_key fk_fin_document_detail1
general_ledger_key general_ledger general_ledger_key fk_fin_document_detail5
person_key person person_key fk_fin_document_detail4
Referenced from
Table Column Foreign Key Name
fin_document_detail_project fin_document_detail_key fk_fin_doc_detail_project5
Check Constraints
Name Definition
cc_fdd_amount (NOT ([debit_amount]<>(0) AND [credit_amount]<>(0)))
cc_fdd_transaction_date ([transaction_date]>='1900-01-01' AND [transaction_date]<='2099-12-31')
Indices
Index Name Unique Column Name Asc Or Desc
pk_fin_document_detail true fin_document_detail_key Asc
idx_fin_document_detail1 false fin_document_key Asc
idx_fin_document_detail2 false account_key Asc
idx_fin_document_detail3 false organization_key Asc
idx_fin_document_detail4 false person_key Asc
idx_fin_document_detail5 false general_ledger_key Asc
idx_fin_document_detail6 false customer_key Asc
Dependent Views
View Name
customer_payment_activity
customer_payment_export_view
journal_view
vendor_payment_1099_view
vendor_payment_activity
vendor_payment_export_view