Table: imported_lodging_detail

Previous: imported_expense_data

Unanet Data Model

Next: invc_sect_fmt

Columns

		Column Name	Data Type	Default Value	References Table	Foreign Key Name
1.	PK	imported_expense_data_key	decimal(15)		imported_expense_data	fk_imported_lodging_detail1
2.		hotel	varchar(100)
3.		location	varchar(100)
4.		check_in_date	datetime
5.		nights_charged	int
6.		daily_room_rate	decimal(15,3)
7.		daily_room_tax	decimal(15,3)
8.		misc_charge	decimal(15,3)
9.		misc_desc	varchar(100)

Foreign Keys

Column	References		Foreign Key Name
	Table	Column
imported_expense_data_key	imported_expense_data	imported_expense_data_key	fk_imported_lodging_detail1

Check Constraints

Name	Definition
cc_ild_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_imported_lodging_detail	true	imported_expense_data_key	Asc