Table: lodging_detail

Previous: lodging_allowable_detail Unanet Data Model Next: lodging_per_diem_detail
Columns
  Column Name Data Type Default
Value		 References
Table		 Foreign Key
Name
1. PK expense_data_key decimal(15)   expense_data fk_lodging_detail1
2.   hotel varchar(100)      
3.   location varchar(100)      
4.   check_in_date datetime      
5.   nights_charged int      
6.   room_rate decimal(15,3)      
7.   tax decimal(15,3)      
8.   misc_charge decimal(15,3)      
9.   misc_desc varchar(100)      
Foreign Keys
Column References Foreign Key Name
Table Column
expense_data_key expense_data expense_data_key fk_lodging_detail1
Check Constraints
Name Definition
cc_ld_check_in_date ([check_in_date]>='1900-01-01' AND [check_in_date]<='2099-12-31')
Indices
Index Name Unique Column Name Asc Or Desc
pk_lodging_detail true expense_data_key Asc