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 |