ExpenseReportsExpense
Maintains line-level expense items within a report, capturing essential details like expense type, amount, and project allocations.
Columns
| Name | Type | Description |
| ExpenseReportsExpenseReportId [KEY] | Long | Unique identifier for the expense report within the system. This helps track and manage individual expense reports across the platform. |
| AgencyName | String | Name of the agency or service provider offering transportation or accommodation services, such as car rental or airfare. |
| AssignmentId | Long | Unique identifier assigned to an individual or employee, used to associate expenses with the correct user or owner. |
| AuditAdjustmentReason | String | Explanation provided by the auditor for any changes made to the reimbursable amount, helping to ensure transparency and clarity in adjustments. |
| AuditAdjustmentReasonCode | String | Code that categorizes the reason behind an adjustment made by the auditor to an individual's reimbursable expenses. |
| AwtGroupId | Long | Identifier for an alternate tax withholding group, which can be used for managing tax-related deductions for groups of employees. |
| BilledAmount | Decimal | The amount billed to the corporate card account, representing the cost charged to the account by the service provider. |
| BilledCurrencyCode | String | Currency code indicating the currency used for the amount billed to the corporate card account. |
| CardId | Long | Unique identifier for a specific corporate card, used to track transactions and account details for a particular cardholder. |
| CheckoutDate | Date | Date when an individual departs or checks out from a location related to an accommodation expense, such as a hotel or rental property. |
| CreatedBy | String | The user who created the record, providing accountability and helping to track the origin of each entry in the system. |
| CreationDate | Datetime | Timestamp indicating the exact date and time when the record was created, ensuring the correct chronological order of data. |
| CreditCardTrxnId | Long | Unique identifier for a specific transaction made using a corporate credit card, used for reference and reconciliation. |
| DailyAmount | Decimal | The amount of the daily expense receipt, typically used to track daily costs such as meals or incidental expenses. |
| DailyDistance | Decimal | Distance traveled by an individual in one day for business-related activities, typically used for calculating mileage reimbursement. |
| DailyLimit | String | The daily expense limit set for a specific trip, which helps control the spending based on company policies. |
| DepartureLocationId | Long | Unique identifier for the departure location, helping to track and associate expenses with specific geographical locations. |
| Description | String | A brief description of the expense item, providing context for the expenditure, such as the purpose or nature of the expense. |
| DestinationFrom | String | Starting location of a trip, such as the city or airport from which an individual is departing for business purposes. |
| DestinationTo | String | Ending or arrival location of the trip, indicating the destination for the business-related travel. |
| DistanceUnitCode | String | Code that specifies the unit of measurement for travel distance. Common values are KILOMETER and MILE, indicating the unit used for travel reimbursement. |
| EndDate | String | The final day of an expense item that spans multiple days, marking the end of the applicable time period for the expense. |
| EndDateTimestamp | Datetime | Timestamp indicating the exact end date and time for an expense item that spans multiple days, helping with accurate time tracking. |
| EndOdometer | Decimal | The odometer reading at the conclusion of a trip, used to calculate mileage and verify travel-related reimbursements. |
| ExchangeRate | Decimal | Rate at which one currency can be exchanged for another at a specific point in time, often used to convert foreign expenses. |
| ExpenseCategoryCode | String | Code that identifies the classification of an expense item, such as BUSINESS for work-related expenses or PERSONAL for non-business expenditures. |
| ExpenseCreationMethodCode | String | Code indicating the method by which an expense item was created, such as via mobile iOS or Android apps for expense reporting. |
| ExpenseId [KEY] | Long | Unique identifier for a specific expense item, enabling easy tracking and reference within the expense management system. |
| ExpenseReference | Int | Reference number used to identify and track specific expenses, often used to link expenses to broader reports or categories. |
| ExpenseReportId | Long | Unique identifier for a specific expense report, helping to associate all individual expenses with the corresponding report. |
| ExpenseSource | String | Code identifying the source of the expense, such as CASH for out-of-pocket expenses or CORP_CARD for corporate card transactions. |
| ExpenseTemplateId | Long | Unique identifier for a specific expense template, helping to define the structure and rules for expense entries. |
| ExpenseTypeCategoryCode | String | Code that classifies an expense item by its type, such as AIRFARE for flight costs or CAR_RENTAL for transportation expenses. |
| ExpenseTypeId | Long | Unique identifier for a specific expense type, helping to categorize expenses into types like lodging, meals, or travel. |
| FlightClassLimit | String | Expense limit associated with a specific flight class, such as business or economy class, used to control travel-related spending. |
| FlightDuration | Decimal | The duration of an airline flight in hours, used to assess the time spent traveling for business purposes. |
| FlightNumber | String | Flight number associated with an airline trip, used to identify specific flights for business travel reporting. |
| FuelType | String | Types of fuel covered for reimbursement under mileage policies, typically associated with the type of vehicle used. |
| ImageReceiptRequiredFlag | Bool | Indicates whether a scanned or photographed image of the receipt is required for submitting an expense. |
| ItemizationParentExpenseId | Long | Unique identifier for the parent expense of an itemized expense, enabling the tracking of grouped or broken-down expense items. |
| ItemizationReceiptBusinessTotalAmount | Decimal | Total business-related amount on a receipt to be reimbursed to the employee, after any personal expenses are deducted. |
| ItemizationReceiptPersonalTotalAmount | Decimal | Personal amount on a receipt, representing expenses that are not eligible for reimbursement. |
| ItineraryReservationId | Long | Unique identifier for a travel reservation, used to associate expenses with the details of the booked itinerary. |
| Justification | String | Reason provided for incurring an expense, explaining why the expense was necessary for business purposes. |
| JustificationRequiredFlag | Bool | Indicates whether a justification is required for an expense item, often used to ensure policy compliance. |
| LastUpdateDate | Datetime | Timestamp indicating when the record was last updated, providing the most recent version of the expense data. |
| LastUpdateLogin | String | Login session associated with the user who last updated the record, helping to track who made changes to the entry. |
| LastUpdatedBy | String | User who last updated the row, offering accountability and traceability for changes made to the expense record. |
| LicensePlateNumber | String | License plate number of a vehicle used during business travel, typically used for mileage tracking or vehicle-related expenses. |
| Location | String | Location where an expense was incurred, providing context for expenses such as meals, lodging, or transportation. |
| LocationId | Long | Unique identifier for a specific expense location, helping to track where expenses are associated geographically. |
| LongTermTripFlag | Bool | Indicates whether the trip is categorized as long-term, helping to apply specific rules for extended travel durations. |
| LongTermTripStartDate | Date | The date when a long-term business trip started, used for tracking the duration and associated expenses. |
| MerchantDocumentNumber | String | Document number from the merchant or service provider, used for identifying and reconciling receipts or purchase invoices. |
| MerchantName | String | Name of the merchant or service provider where an expense was incurred, aiding in vendor management and reporting. |
| MerchantReference | String | Purchase or transaction identification number provided by the merchant, often used for tracking and reconciliation of transactions. |
| MerchantTaxRegNumber | String | Unique identifier assigned to a merchant by the tax authority, used for regulatory compliance and transaction reporting. |
| MerchantTaxpayerId | String | Tax Indentification Number (TIN) assigned to a merchant, used for taxation and compliance purposes. |
| MileagePolicyId | Long | Unique identifier for a mileage policy, which defines rules for reimbursing mileage expenses for employees or contractors. |
| NumberOfAttendees | Decimal | The number of people who attended an event for which expenses were incurred, typically used for business meals or entertainment. |
| NumberOfDays | Int | The number of days for which an expense is being reported, often used for accommodations, meals, or travel-related expenses. |
| NumberPeople | Int | The number of people or passengers in a vehicle during business-related travel, impacting mileage and reimbursement calculations. |
| OrgId | Long | Unique identifier for the business unit associated with the expense, ensuring accurate tracking of expenses by department or team. |
| PassengerAmount | Decimal | Total amount reimbursed for carrying passengers in a vehicle, typically used for mileage reimbursement in carpool scenarios. |
| PassengerName | String | Name of the individual who is a passenger in the vehicle during a business trip. |
| PassengerRateType | String | Rate type for passenger reimbursement during a trip, used to calculate the reimbursement amount for carpooling. |
| PaymentDueFromCode | String | Code identifying the party responsible for paying a specific transaction, such as an employee or department. |
| PersonId | Long | Unique identifier for the individual who owns the expense, typically used to associate expenses with employees or contractors. |
| PersonalReceiptAmount | Decimal | Amount of an expense receipt that is considered personal and not reimbursable by the company. |
| PolicyShortpayFlag | Bool | Indicates whether an expense was short-paid due to noncompliance with company policies or limits. |
| PolicyViolatedFlag | Bool | Indicates whether an expense violates any company policy, triggering additional review or corrective actions. |
| PolicyWarningFlag | Bool | Indicates whether an expense item has been flagged with a warning for policy issues, requiring further review. |
| PolicyWarningReasonCode | String | Code explaining the reason for a policy warning applied to an expense item, based on company-defined criteria. |
| PreparerId | Long | Unique identifier for the person who prepared and submitted the expense report. |
| RatePerPassenger | Decimal | Mileage reimbursement rate per passenger for a vehicle used during a business trip, impacting total reimbursements. |
| ReceiptAmount | Decimal | Total amount shown on a receipt, used to verify that the expense matches the claimed amount. |
| ReceiptCurrencyCode | String | Currency code indicating the currency of the receipt, used for conversions or reconciliation of foreign expenses. |
| ReceiptDate | Date | Date when a receipt is issued, typically used for matching the expense date with supporting documentation. |
| ReceiptMissingDecRequiredFlag | Bool | Indicates whether a declaration is required for missing receipts, used for verifying missing documentation. |
| ReceiptMissingFlag | Bool | Indicates whether a receipt is missing for an expense item, prompting further investigation or clarification. |
| ReceiptRequiredFlag | Bool | Indicates whether a receipt is mandatory for the expense item, ensuring compliance with company reimbursement policies. |
| ReceiptVerifiedFlag | Bool | Indicates whether the receipt for an expense item has been verified by an auditor or approver. |
| ReimbursableAmount | Decimal | Amount eligible for reimbursement for a specific expense, after deducting any personal portions or policy violations. |
| ReimbursementCurrencyCode | String | Currency code representing the reimbursement amount for an expense, ensuring proper conversion and payment. |
| SequenceNumber | Decimal | Sequence number used to organize and enter expense items within a report, maintaining a structured order of expenses. |
| StartDate | Date | The start date of an expense item, typically marking the first day of a trip or business-related activity. |
| StartDateTimestamp | Datetime | Timestamp indicating the exact start date and time of an expense item, offering precise time tracking. |
| StartOdometer | Decimal | Odometer reading at the beginning of a trip, used for mileage calculation and verification of business travel. |
| TaxClassificationCode | String | Code indicating the tax classification applied to an expense, used for tax reporting and compliance. |
| TicketClassCode | String | Code specifying the ticket class of travel, such as business or economy, impacting travel reimbursements. |
| TicketNumber | String | Unique identifier for an airline ticket, used for referencing and verifying travel expenses. |
| TravelMethodCode | String | Code that identifies the method of travel used for a business trip, such as flight, car rental, or train. |
| TravelType | String | Type of travel for the expense item, typically either DOMESTIC or INTERNATIONAL. |
| 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 measurement for travel expenses. |
| ValidationErrorFlag | Bool | Indicates whether there was a validation error for the expense, triggering corrective actions or manual review. |
| ValidationErrorMessages | String | Error messages generated during validation, providing details on issues that need resolution before approval. |
| ValidationWarningMessages | String | Warning messages generated during validation, providing alerts on potential issues that may require attention. |
| VehicleCategoryCode | String | Code identifying the vehicle category, such as COMPANY, PRIVATE, or RENTAL, for mileage reimbursement calculations. |
| VehicleType | String | Type of vehicle used for business travel, such as CAR, MOTORCYCLE, or VAN, impacting mileage and transportation reimbursements. |
| ZoneCode | String | Geographical zone code that indicates the area of travel, used for calculating mileage rates based on location. |
| ZoneTypeCode | String | Code indicating the type of zone for which mileage rates are applied, used in travel and transportation reimbursements. |
| BusinessUnit | String | Business unit to which the incurred expense is attributed, helping to allocate costs to the correct organizational unit. |
| PersonName | String | Name of the person incurring the expense, typically the employee or contractor submitting the expense report. |
| ExpenseTemplate | String | Expense template used for categorizing and organizing the types of expenses incurred for reporting purposes. |
| ExpenseType | String | Type of expense associated with a specific business activity, such as meals, travel, or entertainment. |
| ReceiptCurrency | String | Currency in which the expense receipt was issued, used for reconciliation and accurate expense reporting. |
| ReimbursementCurrency | String | Currency used for reimbursing an employee or contractor for their expenses, which may differ from the receipt currency. |
| DistanceUnit | String | Unit of measurement used for travel distances, with possible values of KILOMETER or MILE. |
| TicketClass | String | Class of ticket purchased for business travel, with possible values including BUSINESS and ECONOMY. |
| ExpenseSourceName | String | Source of the expense item, such as Cash or Corporate Card, providing context on how the expense was incurred. |
| ReferenceNumber | String | Unique reference number for an expense item or object version, used to identify and track the version of the transaction. |
| Request | Long | Unique identifier associated with a specific credit card upload process, used for tracking uploaded expense data. |
| AttachmentExists | String | Indicates whether there is an attachment associated with the expense, providing context for document verification. |
| ExpenseReportStatus | String | Current status of an expense report, helping users track its progress through the approval and reimbursement process. |
| AuthTrxnNumber | String | Authorization number for a credit card transaction, helping to verify and validate card charges associated with the expense. |
| TravelTypeName | String | Name of the type of flight or travel, either Domestic or International, based on the TravelType attribute. |
| VehicleCategory | String | Category of vehicle used for business travel, such as COMPANY, PRIVATE, or RENTAL. |
| VehicleTypeName | String | Name of the specific vehicle type used, such as sedan, van, or SUV, for business-related travel. |
| FuelTypeName | String | Name of the fuel type used during travel, such as gasoline or diesel, for mileage reimbursement calculations. |
| TaxClassification | String | Description of the tax classification applied to an expense, guiding proper tax treatment and reporting. |
| CountryCode | String | Country code where the expense was incurred, ensuring accurate location-based expense tracking and reporting. |
| AutoSubmitDate | Datetime | Date when the expense is automatically submitted, typically used for time-sensitive expense reporting processes. |
| ReceiptTime | Datetime | Time when the receipt transaction occurred, used to differentiate transactions that happen on the same date. |
| TipAmount | Decimal | Amount of tip given in the transaction, helping to manage receipts with additional charges beyond the standard amount. |
| VisitedFlag | Bool | Indicates whether the user has confirmed or visited a particular expense item, used for validation purposes. |
| ValidationStatus | String | Status of the validation for an expense, such as errors, warnings, or confirmed as valid. |
| PrepaidFlag | Bool | Indicates whether the expense was prepaid, ensuring accurate accounting for pre-paid versus post-paid expenses. |
| ExpenseDff | String | Column for storing additional fields used only during insert operations. For update and delete, refer to the appropriate child table. |
| ExpenseAttendee | String | Column for managing attendees during insert operations. For update and delete, refer to the child table's operations. |
| ExpenseDistribution | String | Used for managing expense distribution in insert operations. For updates or deletes, refer to the corresponding child table. |
| expenseErrors | String | Column used for capturing errors during insert operations. For update and delete, refer to the relevant child table. |
| duplicateExpenses | String | Column for handling duplicate expense checks during insert operations. For updates or deletes, refer to the child table. |
| ExpenseItemization | String | Column used for itemizing expenses during insert operations. For updates or deletes, use operations in the related child table. |
| matchedExpenses | String | Column for matching expenses during insert operations. For updates or deletes, refer to the child table's operations. |
| Finder | String | Unique identifier or search term used for finding records within the system. |
| SysEffectiveDate | String | System-defined effective date used to track when a record becomes valid in the system. |
| CUReferenceNumber | Int | Reference number used to link child aggregates with their parent tables, helping maintain relational integrity. |
| EffectiveDate | Date | Date used to fetch resources that are effective as of a specified start date, assisting with historical data retrieval. |