ExpenseAirfarePoliciesexpenseAirfarePolicyLines
Provides detailed line items for airfare policy rules, including maximum limits, exceptions, and additional fare conditions.
Columns
| Name | Type | Description |
| ExpenseAirfarePoliciesAirfarePolicyId [KEY] | Long | The unique identifier for the airfare policy in the ExpenseAirfarePolicies table, used to link related entries in the expense management system. |
| PolicyLineId [KEY] | Long | The unique identifier for the policy line in the ExpenseAirfarePolicies table, specifying individual rules or configurations within an airfare policy. |
| ObjectVersionNumber | Int | The version number of the object, used for concurrency control to manage changes and ensure data consistency in the ExpenseAirfarePolicies table. |
| AirfarePolicyId | Long | The identifier for the specific airfare policy linked to the expense, used to track which policy governs a particular set of airfare rules. |
| TypeOfRateCode | String | The code that defines the type of rate applied to the airfare, helping to classify rates such as standard or discounted for different policy types. |
| FlightClassCode | String | The code that specifies the class of flight, indicating whether it’s economy, business, or first class, to be used in conjunction with travel policies. |
| FlightClassCodeDomestic | String | The code for the class of flight for domestic travel, used to differentiate between domestic and international travel policy rules. |
| FlightClassCodeInternat | String | The code for the class of flight for international travel, specifically identifying travel policies for flights crossing international borders. |
| StartDate | Date | The start date for the application of this airfare policy line, indicating when the policy or rule becomes effective. |
| EndDate | Date | The end date for the application of this airfare policy line, marking when the policy or rule will no longer be applicable. |
| RoleId | Long | The unique identifier for the role associated with this airfare policy line, used to specify the position or responsibility tied to the policy. |
| RoleName | String | The name of the role linked to the airfare policy line, helping to identify which employees or departments are subject to the policy. |
| FlightDurationThreshold | Decimal | The threshold value for flight duration, used to determine applicable policies based on how long a flight lasts (for example, domestic vs international). |
| InvalidCode | String | The code indicating whether the airfare policy line is invalid, typically used for deactivated or obsolete policies. |
| CreationDate | Datetime | The date and time when the airfare policy line was created, providing an audit trail for policy changes. |
| CreatedBy | String | The user or system that created the airfare policy line, providing accountability for policy creation. |
| LastUpdateDate | Datetime | The most recent date and time the airfare policy line was updated, reflecting changes to the policy or its terms. |
| LastUpdatedBy | String | The user or system that last updated the airfare policy line, enabling tracking of modifications for auditing purposes. |
| LastUpdateLogin | String | The login identifier of the user or system responsible for the last update to the airfare policy line, assisting in identifying changes. |
| Invalid | String | Indicates whether the airfare policy line is marked as invalid, which could signal deactivation or removal from active use. |
| Status | String | The current status of the airfare policy line, such as active, pending, or expired, indicating whether it is in use or not. |
| StatusCode | String | The code representing the specific status of the airfare policy line, providing a standardized way to categorize the policy's current state. |
| Finder | String | A unique identifier used in the Finder function to search and retrieve specific airfare policy lines in the system based on set criteria. |