Show 

Table: request_expense_data

Columns
  Column Name Data Type Default
Value
References
Table
Foreign Key
Name
1. PK request_expense_data_key decimal(15)      
2.   request_expense_report_key decimal(15)   request_expense_report fk_request_expense_data1
3.   expense_type_name varchar(100)      
4.   currency varchar(100)      
5.   payment_method varchar(100)      
6.   expense_date datetime      
7.   request_allocation_key decimal(15)   request_allocation fk_request_expense_data2
8.   vendor varchar(255)      
9.   amount decimal(15,3)      
10.   summary varchar(2000)      
11.   comments varchar(2000)      
12.   account_number varchar(2000)      
13.   receipt_included char(1)      
14.   no_receipt_reason varchar(128)      
15.   project_type varchar(25)      
16.   billable char(1)      
17.   exchange_rate decimal(18,6)      
18.   expense_currency varchar(25)      
19.   expense_amount decimal(18,3)      
20.   parent_key decimal(15)      
Foreign Keys
Column References Foreign Key Name
Table Column
request_allocation_key request_allocation request_allocation_key fk_request_expense_data2
request_expense_report_key request_expense_report request_expense_report_key fk_request_expense_data1
Check Constraints
Name Definition
cc_red_expense_date ([expense_date]>='1900-01-01' AND [expense_date]<='2099-12-31')
Indices
Index Name Unique Column Name Asc Or Desc
pk_request_expense_data true request_expense_data_key Asc