ExpenseMileagePoliciesexpenseMileagePolicyLines
ExpenseMileagePoliciesexpenseMileagePolicyLines
Columns
| Name | Type | Description |
| ExpenseMileagePoliciesMileagePolicyId [KEY] | Long | ExpenseMileagePoliciesMileagePolicyId of ExpenseMileagePoliciesexpenseMileagePolicyLines |
| AdditionalRateCode | String | AdditionalRateCode of ExpenseMileagePoliciesexpenseMileagePolicyLines |
| AdditionalRate | String | AdditionalRate of ExpenseMileagePoliciesexpenseMileagePolicyLines |
| CalculationMethodCode | String | CalculationMethodCode of ExpenseMileagePoliciesexpenseMileagePolicyLines |
| CalculationMethod | String | CalculationMethod of ExpenseMileagePoliciesexpenseMileagePolicyLines |
| CreatedBy | String | CreatedBy of ExpenseMileagePoliciesexpenseMileagePolicyLines |
| CreationDate | Datetime | CreationDate of ExpenseMileagePoliciesexpenseMileagePolicyLines |
| CurrencyCode | String | CurrencyCode of ExpenseMileagePoliciesexpenseMileagePolicyLines |
| Currency | String | Currency of ExpenseMileagePoliciesexpenseMileagePolicyLines |
| DistanceThreshold | Double | DistanceThreshold of ExpenseMileagePoliciesexpenseMileagePolicyLines |
| EndDate | Date | EndDate of ExpenseMileagePoliciesexpenseMileagePolicyLines |
| FuelTypeCode | String | FuelTypeCode of ExpenseMileagePoliciesexpenseMileagePolicyLines |
| FuelType | String | FuelType of ExpenseMileagePoliciesexpenseMileagePolicyLines |
| GeographyId | Long | GeographyId of ExpenseMileagePoliciesexpenseMileagePolicyLines |
| GeolocName | String | GeolocName of ExpenseMileagePoliciesexpenseMileagePolicyLines |
| InvalidCode | String | InvalidCode of ExpenseMileagePoliciesexpenseMileagePolicyLines |
| InvalidDescription | String | InvalidDescription of ExpenseMileagePoliciesexpenseMileagePolicyLines |
| LastUpdateDate | Datetime | LastUpdateDate of ExpenseMileagePoliciesexpenseMileagePolicyLines |
| LastUpdateLogin | String | LastUpdateLogin of ExpenseMileagePoliciesexpenseMileagePolicyLines |
| LastUpdatedBy | String | LastUpdatedBy of ExpenseMileagePoliciesexpenseMileagePolicyLines |
| MileagePolicyId | Long | MileagePolicyId of ExpenseMileagePoliciesexpenseMileagePolicyLines |
| PassengerThreshold | Int | PassengerThreshold of ExpenseMileagePoliciesexpenseMileagePolicyLines |
| PolicyLineId [KEY] | Long | PolicyLineId of ExpenseMileagePoliciesexpenseMileagePolicyLines |
| Rate | Double | Rate of ExpenseMileagePoliciesexpenseMileagePolicyLines |
| RawCity | String | RawCity of ExpenseMileagePoliciesexpenseMileagePolicyLines |
| RawCountry | String | RawCountry of ExpenseMileagePoliciesexpenseMileagePolicyLines |
| RawCounty | String | RawCounty of ExpenseMileagePoliciesexpenseMileagePolicyLines |
| RawState | String | RawState of ExpenseMileagePoliciesexpenseMileagePolicyLines |
| RoleId | Long | RoleId of ExpenseMileagePoliciesexpenseMileagePolicyLines |
| RoleName | String | RoleName of ExpenseMileagePoliciesexpenseMileagePolicyLines |
| StartDate | Date | StartDate of ExpenseMileagePoliciesexpenseMileagePolicyLines |
| StatusCode | String | StatusCode of ExpenseMileagePoliciesexpenseMileagePolicyLines |
| Status | String | Status of ExpenseMileagePoliciesexpenseMileagePolicyLines |
| VehicleCategoryCode | String | VehicleCategoryCode of ExpenseMileagePoliciesexpenseMileagePolicyLines |
| VehicleCategory | String | VehicleCategory of ExpenseMileagePoliciesexpenseMileagePolicyLines |
| VehicleTypeCode | String | VehicleTypeCode of ExpenseMileagePoliciesexpenseMileagePolicyLines |
| VehicleType | String | VehicleType of ExpenseMileagePoliciesexpenseMileagePolicyLines |
| ZoneCode | String | ZoneCode of ExpenseMileagePoliciesexpenseMileagePolicyLines |
| Zone | String | Zone of ExpenseMileagePoliciesexpenseMileagePolicyLines |
Pseudo-Columns
SELECT ステートメントのWHERE 句では、疑似カラムフィールドを使用して、データソースから返されるタプルを詳細に制御することができます。
| Name | Type | Description |
| Finder | String | finder |