Table: expense_data_allocation

Columns
  Column Name Data Type Default
Value
References
Table
Foreign Key
Name
1. PK expense_data_allocation_key decimal(15)      
2.   expense_data_key decimal(15)   expense_data fk_expense_data_allocation1
3.   project_key decimal(15)   project fk_expense_data_allocation2
4.   task_key decimal(15)   task fk_expense_data_allocation3
5.   allocation decimal(6,3)      
6.   amount decimal(18,3)      
7.   bill_amount decimal(18,3)      
8.   expense_currency varchar(25)      
9.   sequence int      
10.   vat_amount decimal(18,3) ((0.000))    
11.   vat_location_key decimal(15)   vat_location fk_expense_data_allocation4
12.   cost_struct_odc_key decimal(15)   cost_struct_odc fk_expense_data_allocation5
13.   project_type_key decimal(15)   project_type fk_expense_data_allocation6
14.   billable char(1)      
15.   post_history_key decimal(15)   post_history fk_expense_data_allocation7
16.   invoice_key decimal(15)   invoice fk_expense_data_allocation8
17.   markup decimal(5,2) ((0))    
18.   cost_account_key decimal(15)   account fk_expense_data_allocation9
19.   cost_post_history_key decimal(15)   post_history fk_expense_data_allocation10
20.   vendor_invoice_key decimal(15)   vendor_invoice fk_expense_data_allocation11
Foreign Keys
Column References Foreign Key Name
Table Column
cost_account_key account account_key fk_expense_data_allocation9
cost_struct_odc_key cost_struct_odc cost_struct_odc_key fk_expense_data_allocation5
expense_data_key expense_data expense_data_key fk_expense_data_allocation1
invoice_key invoice invoice_key fk_expense_data_allocation8
post_history_key post_history post_history_key fk_expense_data_allocation7
cost_post_history_key post_history post_history_key fk_expense_data_allocation10
project_key project project_key fk_expense_data_allocation2
project_type_key project_type project_type_key fk_expense_data_allocation6
task_key task task_key fk_expense_data_allocation3
vat_location_key vat_location location_key fk_expense_data_allocation4
vendor_invoice_key vendor_invoice fin_document_key fk_expense_data_allocation11
Referenced from
Table Column Foreign Key Name
cost_plus_post_detail expense_data_allocation_key fk_cost_plus_post_detail3
invcd_expense expense_data_allocation_key fk_invcd_expense2
journal_expense expense_data_allocation_key fk_journal_expense1
Check Constraints
Name Definition
cc_eda_billable (([billable]='N' OR [billable]='Y') AND [billable] IS NOT NULL)
cc_eda_project_type_key ([project_type_key] IS NOT NULL)
Indices
Index Name Unique Column Name Asc Or Desc
pk_expense_data_allocation true expense_data_allocation_key Asc
idx_expense_data_alloc1 false expense_data_key Asc
idx_expense_data_alloc2 false project_key Asc
idx_expense_data_alloc3 false invoice_key Asc
Dependent Views
View Name
journal_view
vendor_payment_1099_view