Table: expense_data

Columns
  Column Name Data Type Default
Value
References
Table
Foreign Key
Name
1. PK expense_data_key decimal(15)      
2.   expense_report_key decimal(15)   expense_report fk_expense_data1
3.   expense_type_key decimal(15)   expense_type fk_expense_data5
4.   currency_key decimal(15)   currency fk_expense_data2
5.   payment_method_key decimal(15)   payment_method fk_expense_data4
6.   expense_date datetime      
7.   expense_project_allocation_key decimal(15)   expense_project_allocation fk_expense_data6
8.   comments varchar(2000)      
9.   amount decimal(18,3)      
10.   summary varchar(2000)      
11.   sequence int      
12.   receipt_included char(1)      
13.   no_receipt_reason varchar(128)      
14.   vendor_key decimal(15)   vendor fk_expense_data3
15.   vendor_name varchar(255)      
16.   project_type_key decimal(15)   project_type fk_expense_data7
17.   exchange_rate decimal(18,6)      
18.   expense_currency varchar(25)      
19.   expense_amount decimal(18,3)      
20.   expense_vat_amount decimal(18,3) ((0.000))    
21.   vat_amount decimal(18,3) ((0.000))    
22.   vat_location_key decimal(15)   vat_location fk_expense_data8
23.   imported_expense_data_key decimal(15)   imported_expense_data fk_expense_data9
24.   parent_key decimal(15)      
25.   last_update datetime (getdate())    
Foreign Keys
Column References Foreign Key Name
Table Column
currency_key currency currency_key fk_expense_data2
expense_project_allocation_key expense_project_allocation expense_project_allocation_key fk_expense_data6
expense_report_key expense_report expense_report_key fk_expense_data1
expense_type_key expense_type expense_type_key fk_expense_data5
imported_expense_data_key imported_expense_data imported_expense_data_key fk_expense_data9
payment_method_key payment_method payment_method_key fk_expense_data4
project_type_key project_type project_type_key fk_expense_data7
vat_location_key vat_location location_key fk_expense_data8
vendor_key vendor vendor_key fk_expense_data3
Referenced from
Table Column Foreign Key Name
air_detail expense_data_key fk_air_detail1
business_meeting_detail expense_data_key fk_business_meeting_detail1
cash_return_detail expense_data_key fk_cash_return_detail1
cell_phone_detail expense_data_key fk_cell_phone_detail1
company_car_detail expense_data_key fk_company_car_detail1
entertainment_detail expense_data_key fk_entertainment_detail1
expense_data_allocation expense_data_key fk_expense_data_allocation1
lodging_allowable_detail expense_data_key fk_lodging_allowable_detail1
lodging_detail expense_data_key fk_lodging_detail1
lodging_per_diem_detail expense_data_key fk_lodging_per_diem_detail1
mie_allowable_detail expense_data_key fk_mie_allowable_detail1
mie_per_diem_detail expense_data_key fk_mie_per_diem_detail1
mileage_detail expense_data_key fk_mileage_detail1
Check Constraints
Name Definition
cc_expense_data_expense_date ([expense_date]>='1900-01-01' AND [expense_date]<='2099-12-31')
Indices
Index Name Unique Column Name Asc Or Desc
pk_expense_data true expense_data_key Asc
idx_expense_data1 false imported_expense_data_key Asc
idx_expense_data2 false expense_report_key Asc
Dependent Views
View Name
journal_view