ExpenseAirfarePoliciesexpenseAirfarePolicyLines
ExpenseAirfarePoliciesexpenseAirfarePolicyLines
Columns
| Name | Type | Description |
| ExpenseAirfarePoliciesAirfarePolicyId [KEY] | Long | The unique identifier of the expense airfare policy record. |
| PolicyLineId [KEY] | Long | The unique identifier of the airfare policy rate line. |
| ObjectVersionNumber | Int | Number used to implement optimistic locking for an expense airfare policy line. The number increments every time the row is updated. The value of the object version number at the start and end of a transaction are compared to detect whether another session has updated the row since it was queried. |
| AirfarePolicyId | Long | The unique identifier of the airfare policy for which rates are defined. |
| TypeOfRateCode | String | Indicates if this line is a base airline line or a catch all line. |
| FlightClassCode | String | Airline ticket class such as economy class or business class. |
| FlightClassCodeDomestic | String | Airline ticket class such as economy class or business class, for domestic flights. |
| FlightClassCodeInternat | String | Airline ticket class such as economy class or business class, for international flights. |
| StartDate | Date | Date at the beginning of the valid date range for airfare expense rate. |
| EndDate | Date | Date at the end of the valid date range for airfare expense rate. |
| RoleId | Long | The unique identifier of the role for which the airfare policy rate is applicable. |
| RoleName | String | Role name for which the airfare policy rate is applicable, such as Director or Engineer. |
| FlightDurationThreshold | Double | Expense manager can specify a flight duration threshold such that, above the threshold or below the threshold, a different flight class can be used. For example, airfare policy can be defined such that if flight duration is more than seven hours, employee can fly business class. |
| InvalidCode | String | Code that indicates the reason why the airfare expense policy rate line failed validation. Values are from the lookup EXM_POLICY_INVALID_CODE. |
| CreationDate | Datetime | Date and time when the row was created. |
| CreatedBy | String | User who created the row. |
| LastUpdateDate | Datetime | Date and time when the row was last updated. |
| LastUpdatedBy | String | User who last updated the row. |
| LastUpdateLogin | String | Session login of user who last updated the row. |
| Invalid | String | The reason why the airfare expense policy rate line failed validation. |
| Status | String | Status of the rate line, such as Valid, Active, or Invalid. |
| StatusCode | String | Indicates the status of the rate line. Values are from the lookup EXM_POLICY_STATUS. |
Pseudo-Columns
SELECT ステートメントのWHERE 句では、疑似カラムフィールドを使用して、データソースから返されるタプルを詳細に制御することができます。
| Name | Type | Description |
| Finder | String | finder |