Table: imported_expense_data

Columns
		Column Name	Data Type	Default Value	References Table	Foreign Key Name
1.	PK	imported_expense_data_key	decimal(15)
2.		import_date	datetime
3.		import_source	decimal(15)
4.		wizard_type	decimal(2)
5.		expense_date	datetime
6.		expense_amount	decimal(18,3)
7.		expense_vat_amount	decimal(18,3)
8.		expense_currency_code	varchar(25)
9.		amount	decimal(18,3)
10.		vat_amount	decimal(18,3)
11.		amount_currency_code	varchar(25)
12.		exchange_rate	decimal(18,6)
13.		vendor_name	varchar(255)
14.		payment_method_key	decimal(15)		payment_method	fk_imported_expense_data1
15.		receipt_included	char(1)
16.		comments	varchar(2000)
17.		no_receipt_reason	varchar(128)
18.		vat_location_name	varchar(50)

Foreign Keys
Column	References		Foreign Key Name
Column	Table	Column	Foreign Key Name
payment_method_key	payment_method	payment_method_key	fk_imported_expense_data1

Referenced from
Table	Column	Foreign Key Name
expense_data	imported_expense_data_key	fk_expense_data9
imported_air_detail	imported_expense_data_key	fk_imported_air_detail1
imported_credit_card_expense	imported_expense_data_key	fk_imported_credit_card_exp1
imported_lodging_detail	imported_expense_data_key	fk_imported_lodging_detail1

Check Constraints
Name	Definition
cc_ied_expense_date	([expense_date]>='1900-01-01' AND [expense_date]<='2099-12-31')
cc_ied_wizard_type	([wizard_type]=(3) OR [wizard_type]=(1))

Indices
Index Name	Unique	Column Name	Asc Or Desc
pk_imported_expense_data	true	imported_expense_data_key	Asc
idx_imported_expense_data1	false	import_date	Asc