ExpensesExpenseItemization
Allows for subdividing a single expense item into multiple cost components (for example, a multi-day hotel stay), improving clarity.
Columns
| Name | Type | Description |
| ExpensesExpenseId [KEY] | Long | Unique identifier for the expense record, used to track and manage individual expenses within the system. |
| AssignmentId | Long | Unique identifier for the individual who owns the expense, linking the expense to a specific employee or contractor. |
| AuditAdjustmentReason | String | Explanation provided by the auditor for adjusting the reimbursable amount, ensuring transparency in the adjustment process. |
| AuditAdjustmentReasonCode | String | Code that specifies the auditor's reason for adjusting the reimbursable amount, used for categorization and reporting. |
| AwtGroupId | Long | Identifier for an alternate tax withholding group, used to categorize and apply different tax withholding rules to expenses. |
| BilledAmount | Decimal | Amount billed to the corporate card account, representing the cost charged by the service provider for the expense. |
| BilledCurrencyCode | String | Currency code indicating the currency used for the billed amount, ensuring proper conversion and reconciliation. |
| CardId | Long | Unique identifier for a specific corporate card, used to track expenses associated with that card. |
| CheckoutDate | Date | Date when the individual departs or checks out from a location related to an accommodation, used to track lodging expenses. |
| CreatedBy | String | Username of the individual who created the expense record, helping to trace the origin of the data. |
| CreationDate | Datetime | Timestamp indicating when the expense record was created, important for tracking the creation process. |
| CreditCardTrxnId | Long | Unique identifier for the specific credit card transaction, used to link an expense to its corresponding card payment. |
| DailyAmount | Decimal | Amount listed on the daily receipt for the expense, expressed in the receipt's currency. |
| DailyDistance | Decimal | Distance traveled during a day for business purposes, typically used for mileage reimbursement. |
| DailyLimit | String | Daily expense limit for a trip, often used to control and monitor business-related spending. |
| DepartureLocationId | Long | Unique identifier for the departure location of a trip, used to track the origin of the travel expenses. |
| Description | String | Description of the expense item, providing additional context to explain the nature of the expenditure. |
| DestinationFrom | String | Starting location of the trip, such as the city or airport from which the individual is traveling. |
| DestinationTo | String | Ending location of the trip, marking the arrival point for business travel. |
| DistanceUnitCode | String | Code indicating the unit of measurement for travel distance, with possible values being KILOMETER or MILE. |
| EndDate | String | Final day of the expense period for expenses spanning multiple days, providing a clear endpoint for tracking. |
| EndOdometer | Decimal | Odometer reading at the conclusion of a trip, used for calculating mileage reimbursement. |
| ExchangeRate | Decimal | Currency exchange rate applied when converting one currency to another, used for expenses incurred in foreign currencies. |
| ExpenseCategoryCode | String | Code that categorizes the expense item, helping to classify the expense for accounting and reporting purposes. |
| ExpenseCreationMethodCode | String | Code indicating how the expense was created, such as through a mobile iOS or Android device. |
| ExpenseId [KEY] | Long | Unique identifier for the specific expense item, enabling detailed tracking and reporting for each expense. |
| ExpenseReportId | Long | Unique identifier for the expense report that the expense item belongs to, linking the item to a broader financial report. |
| ExpenseSource | String | Code indicating the source of the expense, such as CASH or CORPORATE_CARD, used to identify the method of payment. |
| ExpenseTemplateId | Long | Unique identifier for the expense template, helping to standardize the creation of expense items across various categories. |
| ExpenseTypeId | Long | Unique identifier for the expense type, used to classify the nature of the expense for better reporting and analysis. |
| FlightClassLimit | String | The expense limit set for a specific flight class, such as business or economy class, to control the cost of travel. |
| FlightDuration | Decimal | Duration of the airline flight in hours, providing a measure of the travel time for the business trip. |
| FlightNumber | String | Flight number associated with an airline trip, used for tracking and managing travel details. |
| FuelType | String | Type of fuel for which a fuel charge is reimbursed, typically used for vehicle-related travel expenses. |
| ImgReceiptRequiredFlag | Bool | Flag indicating whether a receipt image is required for expense submission, ensuring compliance with submission policies. |
| ItemizationParentExpenseId | Long | Unique identifier for the parent expense in itemized expense entries, used to track hierarchical relationships between expenses. |
| ItemizationReceiptBusinessTotalAmount | Decimal | The total business amount on an itemized receipt, representing the portion eligible for reimbursement. |
| ItemizationReceiptPersonalTotalAmount | Decimal | Amount of the receipt that pertains to personal expenses and is not reimbursed. |
| ItineraryReservationId | Long | Unique identifier for a travel reservation, used to link the expense to the travel booking. |
| Justification | String | Reason for incurring the expense, providing clarity and context to ensure the expense meets company policies. |
| JustificationRequiredFlag | Bool | Flag indicating whether a justification is required for the expense item, ensuring compliance with policy. |
| LastUpdateDate | Datetime | Timestamp of the most recent update made to the expense record, helping to track changes over time. |
| LastUpdatedBy | String | Username of the individual who last modified the record, providing accountability for updates. |
| LicensePlateNumber | String | License plate number of the vehicle used for business travel, used for mileage and transportation-related expense tracking. |
| Location | String | Location where the expense was incurred, helping to classify and validate the expense for reimbursement. |
| LocationId | Long | Unique identifier for the location associated with the expense, used for tracking expenses by location. |
| LongTermTripFlag | Bool | Flag indicating whether the trip is considered long-term, which may require different handling for expense reporting. |
| LongTermTripStartDate | Date | Date when the long-term business trip began, used for tracking extended travel durations. |
| MerchantDocumentNumber | String | Receipt number or document issued by the merchant, used for identifying and verifying the purchase transaction. |
| MerchantName | String | Name of the merchant or service provider where the expense was incurred, helping to track the vendor associated with the purchase. |
| MerchantReference | String | Transaction reference provided by the merchant, used to identify the specific purchase for reconciliation. |
| MerchantTaxRegNumber | String | Unique identification number assigned to the merchant by tax authorities, used for regulatory compliance and tax reporting. |
| MerchantTaxpayerId | String | Tax Indentification Number (TIN) assigned to the merchant, ensuring proper tax reporting and legal compliance. |
| MileagePolicyId | Long | Unique identifier for the mileage policy applied to the expense, used to ensure proper reimbursement rates and rules are followed. |
| NumberOfAttendees | Decimal | The number of individuals who attended an event for which expenses were incurred, useful for business meals or entertainment expenses. |
| NumberOfDays | Int | The number of days the expense was incurred, used to track daily expenses like lodging, meals, or transportation. |
| NumberPeople | Int | Number of passengers in a vehicle during business travel, typically used for mileage and travel reimbursement. |
| OrgId | Long | Unique identifier for the organization or business unit associated with the expense, used for organizational reporting. |
| PassengerAmount | Decimal | Total amount reimbursed for carrying passengers in the vehicle during business travel, used to calculate mileage reimbursement. |
| PassengerName | String | Name of the individual who is a passenger during the business trip. |
| PassengerRateType | String | Rate type used for reimbursing the passenger during a business trip, typically based on company reimbursement policies. |
| PaymentDueFromCode | String | Code identifying the party responsible for paying the expense, helping to clarify liability for the transaction. |
| PersonId | Long | Unique identifier for the individual who owns the expense, used to link the expense to the employee or contractor. |
| PersonalReceiptAmount | Decimal | Amount of the receipt that is marked as a personal expense and is not eligible for reimbursement. |
| PolicyShortpayFlag | Bool | Flag indicating whether the expense was short-paid due to policy noncompliance, signaling the need for corrective action. |
| PolicyViolatedFlag | Bool | Flag indicating whether the expense violates company policies, helping to trigger further review or action. |
| PolicyWarningFlag | Bool | Flag indicating whether the expense has been flagged with a warning for potential policy violations. |
| PolicyWarningReasonCode | String | Code that specifies the reason for the warning, helping to categorize and handle policy-related issues. |
| PreparerId | Long | Unique identifier for the person who prepared the expense report, used to track who is responsible for submitting the report. |
| RatePerPassenger | Decimal | Mileage reimbursement rate per passenger, used to calculate the total reimbursement for carpooling or group travel. |
| ReceiptAmount | Decimal | Total amount on the receipt in the currency of the expense, used to ensure accuracy during reimbursement processing. |
| ReceiptCurrencyCode | String | Currency code indicating the currency in which the expense receipt was issued, ensuring accurate exchange and reporting. |
| ReceiptDate | Date | Date when the receipt was issued, used to match the expense with the corresponding receipt date for validation. |
| ReceiptMissingDecRequiredFlag | Bool | Flag indicating whether a missing receipt requires a declaration to explain the absence, ensuring accountability. |
| ReceiptMissingFlag | Bool | Flag indicating whether receipts are missing for an expense, prompting follow-up to ensure complete documentation. |
| ReceiptRequiredFlag | Bool | Flag indicating whether a receipt is required for the expense, used for ensuring compliance with company policy. |
| ReceiptVerifiedFlag | Bool | Flag indicating whether the receipt has been verified by an auditor or reviewer as part of the approval process. |
| ReimbursableAmount | Decimal | Amount to be reimbursed to the individual for an expense, ensuring that only valid and eligible amounts are reimbursed. |
| ReimbursementCurrencyCode | String | Currency code for the reimbursement amount, used to track and manage the currency for reimbursement payments. |
| SequenceNumber | Decimal | Number that identifies the order in which the expense items are entered in the report, helping to maintain a structured sequence. |
| StartDate | Date | Start date of the expense period or the first day of a trip, used to track the beginning of a multi-day expense. |
| TaxClassificationCode | String | Code indicating the tax classification that applies to the expense, used for proper tax treatment and reporting. |
| TicketClassCode | String | Code indicating the class of ticket for a flight or ship, helping to categorize travel expenses based on ticket class. |
| TicketNumber | String | Unique number assigned to an airline ticket, used to verify the purchase and track travel details. |
| TravelMethodCode | String | Code indicating the method of travel used during the trip, such as flight, train, or car rental, affecting travel reimbursements. |
| TravelType | String | Type of travel, either DOMESTIC or INTERNATIONAL, helping to categorize expenses based on the geographical scope of the trip. |
| TripDistance | Decimal | Total distance traveled during a business trip, typically used to calculate mileage reimbursement for the trip. |
| UOMDays | Decimal | Calculation of the number of per diem expense days based on the unit of measure, used for meal or lodging expenses. |
| ValidationErrorFlag | Bool | Flag indicating whether a validation error exists, requiring further action to resolve before expense approval. |
| ValidationErrorMessages | String | Messages detailing the validation errors, used to inform users about issues with expense data that need correction. |
| ValidationWarningMessages | String | Messages detailing any validation warnings, alerting users to potential issues that need attention before approval. |
| VehicleCategoryCode | String | Code indicating the type of vehicle, such as COMPANY, PRIVATE, or RENTAL, used for mileage reimbursement and travel expenses. |
| VehicleType | String | Type of vehicle used for business travel, such as CAR, MOTORCYCLE, or VAN, affecting mileage reimbursement and travel policies. |
| ZoneCode | String | Code that indicates the geographical area where the trip occurred, used for calculating mileage and travel reimbursements. |
| ZoneTypeCode | String | Code that defines the zone type for which mileage rates are applied, ensuring accurate calculations based on location. |
| ExpenseType | String | Expense type defined for categorizing the nature of the expense, helping to organize and report different types of expenditures. |
| Finder | String | Search term or identifier used to locate and filter specific records in the system, streamlining data retrieval. |
| Request | String | Request identifier associated with the expense, used for tracking its approval or review process. |
| SysEffectiveDate | String | System-defined effective date, marking when the record becomes valid and applicable for processing. |
| CUReferenceNumber | Int | Reference number used to link child aggregates to parent tables, ensuring consistency and relational integrity. |
| EffectiveDate | Date | Date parameter used to retrieve resources effective as of a specified date, ensuring accurate and time-sensitive data retrieval. |