| Previous: mileage_detail | Unanet Data Model | Next: mileage_rate_set |
| Column Name | Data Type | Default Value |
References Table |
Foreign Key Name |
||
| 1. | PK | mileage_rate_key | decimal(15) | |||
| 2. | mileage_rate_set_key | decimal(15) | mileage_rate_set | fk_mileage_rate1 | ||
| 3. | begin_date | datetime | ||||
| 4. | rate | decimal(15,4) | ||||
| Column | References | Foreign Key Name | |
| Table | Column | ||
| mileage_rate_set_key | mileage_rate_set | mileage_rate_set_key | fk_mileage_rate1 |
| Name | Definition |
| cc_mileage_rate_begin_date | ([begin_date]>='1900-01-01' AND [begin_date]<='2099-12-31') |
| Index Name | Unique | Column Name | Asc Or Desc |
| pk_mileage_rate | true | mileage_rate_key | Asc |