Table: journal_funding_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.   funding_cap_adjustment_key decimal(15)   funding_cap_adjustment fk_journal_funding_cap_adj1
4.   organization_key decimal(15)   customer fk_journal_funding_cap_adj6
5.   general_ledger_key decimal(15)   general_ledger fk_journal_funding_cap_adj7
6.   account_key decimal(15)   account fk_journal_funding_cap_adj2
7.   post_history_key decimal(15)   post_history fk_journal_funding_cap_adj4
8.   invoice_key decimal(15)   invoice fk_journal_funding_cap_adj5
9.   project_key decimal(15)   project fk_journal_funding_cap_adj3
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_funding_cap_adj2
organization_key customer customer_key fk_journal_funding_cap_adj6
funding_cap_adjustment_key funding_cap_adjustment funding_cap_adjustment_key fk_journal_funding_cap_adj1
general_ledger_key general_ledger general_ledger_key fk_journal_funding_cap_adj7
invoice_key invoice invoice_key fk_journal_funding_cap_adj5
post_history_key post_history post_history_key fk_journal_funding_cap_adj4
project_key project project_key fk_journal_funding_cap_adj3
Check Constraints
Name Definition
cc_jfuca_category ([category]>=(1) AND [category]<=(99))
cc_jfuca_journal_trans_date ([journal_trans_date]>='1900-01-01' AND [journal_trans_date]<='2099-12-31')
cc_jfuca_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_funding_cap_adj true journal_key Asc
idx_journal_funding_cap_adj1 false project_key Asc
idx_journal_funding_cap_adj2 false invoice_key Asc
idx_journal_funding_cap_adj3 false organization_key Asc
idx_journal_funding_cap_adj4 false general_ledger_key Asc
idx_journal_funding_cap_adj5 false funding_cap_adjustment_key Asc
idx_journal_funding_cap_adj6 false account_key Asc
idx_journal_funding_cap_adj7 false post_history_key Asc
Dependent Views
View Name
journal_view