ExpenseMileagePolicies
ExpenseMileagePolicies
Columns
| Name | Type | Description |
| AdditionalRatesListCode | String | AdditionalRatesListCode of ExpenseMileagePolicies |
| ApplyThresholdByCode | String | ApplyThresholdByCode of ExpenseMileagePolicies |
| ApplyThresholdBy | String | ApplyThresholdBy of ExpenseMileagePolicies |
| CalculationPassRateByDistFlag | Bool | CalculationPassRateByDistFlag of ExpenseMileagePolicies |
| CapturePassNamesFlag | Bool | CapturePassNamesFlag of ExpenseMileagePolicies |
| CommuteDistanceRequiredFlag | Bool | CommuteDistanceRequiredFlag of ExpenseMileagePolicies |
| CountryCode | String | CountryCode of ExpenseMileagePolicies |
| Country | String | Country of ExpenseMileagePolicies |
| CreatedBy | String | CreatedBy of ExpenseMileagePolicies |
| CreationDate | Datetime | CreationDate of ExpenseMileagePolicies |
| CurrencyCode | String | CurrencyCode of ExpenseMileagePolicies |
| Currency | String | Currency of ExpenseMileagePolicies |
| CurrencyOptionCode | String | CurrencyOptionCode of ExpenseMileagePolicies |
| CurrencyOption | String | CurrencyOption of ExpenseMileagePolicies |
| Description | String | Description of ExpenseMileagePolicies |
| DisplayAllUnitsFlag | Bool | DisplayAllUnitsFlag of ExpenseMileagePolicies |
| DistanceThresholdFlag | Bool | DistanceThresholdFlag of ExpenseMileagePolicies |
| EligibilityDistance | Double | EligibilityDistance of ExpenseMileagePolicies |
| EnabledAdditnlRatesFlag | Bool | EnabledAdditnlRatesFlag of ExpenseMileagePolicies |
| EnabledDeductCommuteFlag | Bool | EnabledDeductCommuteFlag of ExpenseMileagePolicies |
| EnabledEligibilityFlag | Bool | EnabledEligibilityFlag of ExpenseMileagePolicies |
| EnabledFuelTypeFlag | Bool | EnabledFuelTypeFlag of ExpenseMileagePolicies |
| EnabledGenderFlag | Bool | EnabledGenderFlag of ExpenseMileagePolicies |
| EnabledLocationFlag | Bool | EnabledLocationFlag of ExpenseMileagePolicies |
| EnabledMaximumPassFlag | Bool | EnabledMaximumPassFlag of ExpenseMileagePolicies |
| EnabledPassengerFlag | Bool | EnabledPassengerFlag of ExpenseMileagePolicies |
| EnabledRoleFlag | Bool | EnabledRoleFlag of ExpenseMileagePolicies |
| EnabledStandardDeductionFlag | Bool | EnabledStandardDeductionFlag of ExpenseMileagePolicies |
| EnabledVehCategoryFlag | Bool | EnabledVehCategoryFlag of ExpenseMileagePolicies |
| EnabledVehTypeFlag | Bool | EnabledVehTypeFlag of ExpenseMileagePolicies |
| FuelTypeListCode | String | FuelTypeListCode of ExpenseMileagePolicies |
| LastUpdateDate | Datetime | LastUpdateDate of ExpenseMileagePolicies |
| LastUpdateLogin | String | LastUpdateLogin of ExpenseMileagePolicies |
| LastUpdatedBy | String | LastUpdatedBy of ExpenseMileagePolicies |
| LocationTypeCode | String | LocationTypeCode of ExpenseMileagePolicies |
| LocationType | String | LocationType of ExpenseMileagePolicies |
| MaximumPassengers | Int | MaximumPassengers of ExpenseMileagePolicies |
| MileageDeduction | Double | MileageDeduction of ExpenseMileagePolicies |
| MileagePolicyId [KEY] | Long | MileagePolicyId of ExpenseMileagePolicies |
| PassengerRuleCode | String | PassengerRuleCode of ExpenseMileagePolicies |
| PassengerRule | String | PassengerRule of ExpenseMileagePolicies |
| PolicyName | String | PolicyName of ExpenseMileagePolicies |
| PolicyRoleCode | String | PolicyRoleCode of ExpenseMileagePolicies |
| PolicyRole | String | PolicyRole of ExpenseMileagePolicies |
| StatusCode | String | StatusCode of ExpenseMileagePolicies |
| Status | String | Status of ExpenseMileagePolicies |
| StandardDeductionCode | String | StandardDeductionCode of ExpenseMileagePolicies |
| UnitOfMeasureCode | String | UnitOfMeasureCode of ExpenseMileagePolicies |
| UnitOfMeasure | String | UnitOfMeasure of ExpenseMileagePolicies |
| VehicleCategoryListCode | String | VehicleCategoryListCode of ExpenseMileagePolicies |
| VehicleTypeListCode | String | VehicleTypeListCode of ExpenseMileagePolicies |
| ZoneTypeCode | String | ZoneTypeCode of ExpenseMileagePolicies |
| ZoneType | String | ZoneType of ExpenseMileagePolicies |
Pseudo-Columns
SELECT ステートメントのWHERE 句では、疑似カラムフィールドを使用して、データソースから返されるタプルを詳細に制御することができます。
| Name | Type | Description |
| Finder | String | finder |