Show 

Table: journal_fee_cap_adjustment

Columns
  Column Name Data Type Default
Value
References
Table
Foreign Key
Name
1. PK journal_key decimal(15)      
2.   journal_trans_date datetime      
3.   fee_cap_adjustment_key decimal(15)   fee_cap_adjustment fk_journal_fee_cap_adjust1
4.   organization_key decimal(15)   customer fk_journal_fee_cap_adjust6
5.   general_ledger_key decimal(15)   general_ledger fk_journal_fee_cap_adjust7
6.   account_key decimal(15)   account fk_journal_fee_cap_adjust2
7.   post_history_key decimal(15)   post_history fk_journal_fee_cap_adjust4
8.   invoice_key decimal(15)   invoice fk_journal_fee_cap_adjust5
9.   project_key decimal(15)   project fk_journal_fee_cap_adjust3
10.   category tinyint      
11.   amount decimal(18,2)      
12.   extract_date datetime      
Foreign Keys
Column References Foreign Key Name
Table Column
account_key account account_key fk_journal_fee_cap_adjust2
organization_key customer customer_key fk_journal_fee_cap_adjust6
fee_cap_adjustment_key fee_cap_adjustment fee_cap_adjustment_key fk_journal_fee_cap_adjust1
general_ledger_key general_ledger general_ledger_key fk_journal_fee_cap_adjust7
invoice_key invoice invoice_key fk_journal_fee_cap_adjust5
post_history_key post_history post_history_key fk_journal_fee_cap_adjust4
project_key project project_key fk_journal_fee_cap_adjust3
Check Constraints
Name Definition
cc_jfca_category ([category]>=(1) AND [category]<=(99))
cc_jfca_journal_trans_date ([journal_trans_date]>='1900-01-01' AND [journal_trans_date]<='2099-12-31')
cc_jfca_source ([post_history_key] IS NOT NULL AND [invoice_key] IS NULL OR [post_history_key] IS NULL AND [invoice_key] IS NOT NULL)
Indices
Index Name Unique Column Name Asc Or Desc
pk_journal_fee_cap_adjustment true journal_key Asc
idx_journal_fee_cap_adjust1 false project_key Asc
idx_journal_fee_cap_adjust2 false invoice_key Asc
idx_journal_fee_cap_adjust3 false organization_key Asc
idx_journal_fee_cap_adjust4 false general_ledger_key Asc
idx_journal_fee_cap_adjust5 false fee_cap_adjustment_key Asc
idx_journal_fee_cap_adjust6 false account_key Asc
idx_journal_fee_cap_adjust7 false post_history_key Asc
Dependent Views
View Name
journal_view