Table: mileage_detail

Previous: mie_per_diem_detail

Unanet Data Model

Next: mileage_rate

Columns

		Column Name	Data Type	Default Value	References Table	Foreign Key Name
1.	PK	expense_data_key	decimal(15)		expense_data	fk_mileage_detail1
2.		from_location	varchar(100)
3.		to_location	varchar(100)
4.		miles	decimal(15,2)
5.		rate	decimal(15,4)
6.		round_trip	char(1)

Foreign Keys

Column	References		Foreign Key Name
	Table	Column
expense_data_key	expense_data	expense_data_key	fk_mileage_detail1

Indices

Index Name	Unique	Column Name	Asc Or Desc
pk_mileage_detail	true	expense_data_key	Asc