ExpenseReportsExpenseExpenseItemization
Breaks down a single expense into multiple sub-items (for example, hotel bill itemization), improving transparency and accuracy.
Columns
| Name | Type | Description |
| ExpenseReportsExpenseReportId [KEY] | Long | Unique identifier for an expense report within the system, used for referencing and tracking specific reports. |
| ExpenseExpenseId [KEY] | Long | Unique identifier for an expense entry within the report, used to distinguish individual expenses. |
| AssignmentId | Long | Identifies the individual associated with a specific expense entry, helping to track ownership and responsibility. |
| AuditAdjustmentReason | String | Reason provided by the auditor for adjusting a reimbursable amount, necessary for tracking audit decisions. |
| AuditAdjustmentReasonCode | String | Code representing the auditor's reason for adjusting the reimbursable amount, offering a standardized way of documenting audit actions. |
| AwtGroupId | Long | Unique identifier for an alternate tax withholding group, allowing the system to manage different withholding groups. |
| BilledAmount | Decimal | Amount billed to a corporate card account, used to track spending and corporate card transactions. |
| BilledCurrencyCode | String | Currency code representing the billed amount, ensuring the correct currency is used for billing and accounting. |
| CardId | Long | Unique identifier for a specific corporate card used in transactions, important for linking expenses to the correct card. |
| CheckoutDate | Date | Date when an individual departs from a location associated with accommodations expenses, used for tracking the duration of business trips. |
| CreatedBy | String | Username of the individual who created the record, aiding in accountability and tracking who initiated the transaction. |
| CreationDate | Datetime | Date and time the record was created, providing a timestamp for when the expense or transaction was entered into the system. |
| CreditCardTrxnId | Long | Transaction ID associated with a specific corporate card transaction, allowing the system to match receipts and payments. |
| DailyAmount | Decimal | The amount of the daily expense receipt in the receipt's currency, providing insight into daily spending. |
| DailyDistance | Decimal | Distance traveled in a day for business, used for calculating mileage and transportation expenses. |
| DailyLimit | String | Daily spending limit for a trip, helping to enforce company policies on allowable daily expenses. |
| DepartureLocationId | Long | Unique identifier for the departure location in an expense, used to track travel routes and origins. |
| Description | String | A textual description of an expense item, providing context or explanation for the associated costs. |
| DestinationFrom | String | The starting or departure location for the trip, important for route planning and tracking travel expenses. |
| DestinationTo | String | The ending or arrival location for the trip, used in conjunction with 'DestinationFrom' to track the full travel route. |
| DistanceUnitCode | String | Code that specifies the unit of measurement for travel distance, typically KILOMETER or MILE, ensuring consistency in reporting. |
| EndDate | String | The last day of an expense that spans multiple days, used to track the full duration of multi-day travel or business activities. |
| EndOdometer | Decimal | Odometer reading at the end of a trip, used for mileage reimbursements and travel data accuracy. |
| ExchangeRate | Decimal | Rate at which one currency can be exchanged for another at a specific point in time, ensuring proper conversion for international expenses. |
| ExpenseCategoryCode | String | Code used to classify an expense item, with possible values such as BUSINESS or PERSONAL, helping to categorize spending. |
| ExpenseCreationMethodCode | String | Code indicating the method used to create an expense, with possible values like MOBILE iOS DEVICE or MOBILE ANDROID DEVICE, to track creation sources. |
| ExpenseId [KEY] | Long | Unique identifier for a specific expense item, allowing for precise tracking and reporting of each expense. |
| ExpenseReportId | Long | Unique identifier for a specific expense report, linking multiple expenses together for approval and reimbursement processes. |
| ExpenseSource | String | Code representing the source of an expense, such as CASH or CORP_CARD, to identify how the expense was paid. |
| ExpenseTemplateId | Long | Unique identifier for a specific expense template, used to standardize and automate the creation of common expense reports. |
| ExpenseTypeId | Long | Unique identifier for an expense type, used to categorize expenses for reporting and policy enforcement. |
| FlightClassLimit | String | Expense limit for a specific flight class, used to control spending on different flight categories. |
| FlightDuration | Decimal | Duration of a flight in hours, relevant for calculating per diem or other time-based travel expenses. |
| FlightNumber | String | Unique identifier for a specific airline flight, used to track travel itineraries and flight-related expenses. |
| FuelType | String | Types of fuel eligible for reimbursement, defining what fuel charges are acceptable for reimbursement. |
| ImgReceiptRequiredFlag | Bool | Flag indicating whether an expense requires an image of the receipt, used for ensuring compliance with documentation standards. |
| ItemizationParentExpenseId | Long | Identifier for the parent expense of an itemized expense. Values include NULL (not itemized), -1 (parent line with itemization), and greater than 0 (itemized child line). |
| ItemizationReceiptBusinessTotalAmount | Decimal | Total amount to be reimbursed for business expenses on an itemized receipt. |
| ItemizationReceiptPersonalTotalAmount | Decimal | Amount on the receipt allocated to personal expenses, not reimbursable by the employer. |
| ItineraryReservationId | Long | Unique identifier for a travel reservation, used to link expenses to specific bookings or itineraries. |
| Justification | String | Text providing the reason for incurring an expense, necessary for compliance and approval processes. |
| JustificationRequiredFlag | Bool | Flag indicating whether an expense requires justification, ensuring that all expenses have a valid reason for being incurred. |
| LastUpdateDate | Datetime | Date and time when the record was last updated, providing a timestamp for modifications or corrections. |
| LastUpdatedBy | String | Username of the individual who last updated the record, helping to track changes and maintain accountability. |
| LicensePlateNumber | String | Number of the vehicle's license plate, used for tracking mileage or vehicle-related expenses. |
| Location | String | The location where the expense was incurred, helping to categorize expenses based on geographic location. |
| LocationId | Long | Unique identifier for a specific expense location, used to link the expense to a designated site or area. |
| LongTermTripFlag | Bool | Flag indicating whether a trip is considered long-term, relevant for per diem and other long-term travel policies. |
| LongTermTripStartDate | Date | Date when a long-term trip started, used to track the duration and apply specific policies for extended travel. |
| MerchantDocumentNumber | String | Document number provided by the merchant on the receipt, used for verifying and matching receipts. |
| MerchantName | String | Name of the merchant where the expense was incurred, important for verifying transactions and reconciling purchases. |
| MerchantReference | String | Purchase identification provided by the merchant, used for transaction tracking and verification. |
| MerchantTaxRegNumber | String | Tax registration number assigned to a merchant by a tax authority, important for compliance and tax reporting. |
| MerchantTaxpayerId | String | Unique identifier for a merchant's taxpayer registration, ensuring proper tax tracking and reporting. |
| MileagePolicyId | Long | Unique identifier for the mileage policy applied to an expense, used for ensuring compliance with company policies. |
| NumberOfAttendees | Decimal | Number of people who attended an event for which expenses were incurred, useful for business entertainment expense tracking. |
| NumberOfDays | Int | Number of days for which the expense was incurred, helping to track and approve multi-day expenses. |
| NumberPeople | Int | Number of passengers in a vehicle, relevant for calculating vehicle-related expenses or reimbursements. |
| OrgId | Long | Unique identifier for the business unit associated with the expense, used to categorize and allocate expenses by department. |
| PassengerAmount | Decimal | Total reimbursement amount for carrying passengers in a vehicle, used to calculate travel and transportation expenses. |
| PassengerName | String | Name of a passenger in a vehicle or on a flight, used for tracking and verifying travel-related expenses. |
| PassengerRateType | String | Type of rate used for passenger-related mileage reimbursement, relevant for calculating transport costs. |
| PaymentDueFromCode | String | Code that indicates the liability owner for a transaction, ensuring proper payment responsibility. |
| PersonId | Long | Unique identifier for the person associated with an expense, helping to track individual expenses and payments. |
| PersonalReceiptAmount | Decimal | Amount of a receipt marked as personal, not eligible for reimbursement by the company. |
| PolicyShortpayFlag | Bool | Flag indicating whether an expense has been short-paid due to policy violations, ensuring compliance with company reimbursement policies. |
| PolicyViolatedFlag | Bool | Flag indicating whether an expense violates company policies, used for enforcement and auditing purposes. |
| PolicyWarningFlag | Bool | Flag indicating whether a policy warning has been applied to an expense, helping to monitor compliance. |
| PolicyWarningReasonCode | String | Code representing the reason for a warning issued by an auditor, ensuring transparency in the audit process. |
| PreparerId | Long | Unique identifier for the person who created the expense report, important for accountability and tracking. |
| RatePerPassenger | Decimal | Rate per passenger for mileage reimbursement, helping to calculate transport expenses fairly. |
| ReceiptAmount | Decimal | Total amount of the receipt in the currency of the receipt, used for tracking and verifying expense amounts. |
| ReceiptCurrencyCode | String | Currency code for the receipt's currency, ensuring the correct exchange rate and amount are used. |
| ReceiptDate | Date | Date when a receipt was generated, helping to verify the timing of an expense. |
| ReceiptMissingDecRequiredFlag | Bool | Flag indicating whether a declaration is required for missing receipts, used for maintaining proper documentation. |
| ReceiptMissingFlag | Bool | Flag indicating whether receipts are missing for an expense, ensuring compliance with receipt submission requirements. |
| ReceiptRequiredFlag | Bool | Flag indicating whether a receipt is required for the expense, ensuring proper documentation for reimbursement. |
| ReceiptVerifiedFlag | Bool | Flag indicating whether an auditor has verified the receipt for an expense, ensuring proper validation. |
| ReimbursableAmount | Decimal | Amount eligible for reimbursement in the specified currency, ensuring accurate calculations of what can be reimbursed. |
| ReimbursementCurrencyCode | String | Currency code for the amount to be reimbursed, ensuring consistency in currency conversion and reporting. |
| SequenceNumber | Decimal | Number indicating the sequence of expenses within a report, helping to maintain the correct order for review. |
| StartDate | Date | Date when the expense occurred or the first day of a multi-day expense, used for tracking the time frame of the expense. |
| TaxClassificationCode | String | Code representing the tax classification applied to an expense, ensuring accurate tax reporting and compliance. |
| TicketClassCode | String | Code representing the class of a flight or ticket, used to track expenses by class for reporting or policy enforcement. |
| TicketNumber | String | Unique identifier for a specific airline ticket, important for verifying travel and related expenses. |
| TravelMethodCode | String | Code indicating the method of travel used during a trip, helping to categorize transportation-related expenses. |
| TravelType | String | Code representing the type of flight, with possible values DOMESTIC or INTERNATIONAL, used to track travel expenses. |
| TripDistance | Decimal | Total distance traveled during a trip, important for calculating mileage and transport reimbursements. |
| UOMDays | Decimal | Number of days for per diem expenses, based on the unit of measure, used to calculate daily allowances. |
| ValidationErrorFlag | Bool | Flag indicating whether a validation error occurred, helping auditors and users track data integrity issues. |
| ValidationErrorMessages | String | Messages that describe errors encountered during validation, useful for debugging and improving data quality. |
| ValidationWarningMessages | String | Messages that describe warnings encountered during validation, important for user awareness of potential issues. |
| VehicleCategoryCode | String | Code that categorizes the type of vehicle used for the trip, with possible values COMPANY, PRIVATE, or RENTAL. |
| VehicleType | String | Type of vehicle used for transportation, with possible values CAR, MOTORCYCLE, or VAN, helping to categorize travel-related expenses. |
| ZoneCode | String | Code representing the geographical zone of the trip, used for calculating distance-based reimbursements. |
| ZoneTypeCode | String | Code that defines the lookup type for geographical zones, used to apply mileage rates for different regions. |
| ExpenseType | String | Type of expense, used to categorize and define which expenses are eligible for reimbursement. |
| BusinessUnit | String | Identifies the business unit associated with the expense record, used for internal reporting and allocation. |
| Finder | String | Search term or filter used to locate specific records in the system, making it easier to find and manage expense entries. |
| SysEffectiveDate | String | The effective date of the system configuration, used to apply the correct settings or rules for the current period. |
| CUReferenceNumber | Int | Reference number linking child aggregates to parent tables, used for ensuring correct data hierarchy and reporting. |
| EffectiveDate | Date | Date used to filter resources that are effective as of a specific point in time, essential for time-sensitive data operations. |