ExpensesExpenseItemization
The expense itemizations resource is a child resource used to manage details about the itemized lines of an expense incurred by an employee.
Columns
Name | Type | Description |
ExpensesExpenseId [KEY] | Long | ExpensesExpenseId of ExpensesExpenseItemization |
AssignmentId | Long | Value that uniquely identifies the individual on the corporate card. |
AuditAdjustmentReason | String | Auditor's reason for adjusting the reimbursable amount to the individual. |
AuditAdjustmentReasonCode | String | Code that indicates the auditor's reason for adjusting the reimbursable amount to the individual. |
AwtGroupId | Long | Value that uniquely identifies an alternate tax withholding group. |
BilledAmount | Decimal | Amount billed to the corporate card account. |
BilledCurrencyCode | String | Code that indicates the amount billed to the corporate card account. |
CardId | Long | Value that uniquely identifies a specific corporate card. |
CheckoutDate | Date | Date when a person departs a place associated with an accommodations expense category. |
CreatedBy | String | CreatedBy of ExpensesExpenseItemization |
CreationDate | Datetime | CreationDate of ExpensesExpenseItemization |
CreditCardTrxnId | Long | Value that uniquely identifies a specific corporate card transaction. |
DailyAmount | Decimal | Amount of the daily expense receipt in the receipt currency. |
DailyDistance | Decimal | Distance traveled in a day for business. |
DailyLimit | String | DailyLimit of ExpensesExpenseItemization |
DepartureLocationId | Long | Value that uniquely identifies the departure location. |
Description | String | Description of an expense item. |
DestinationFrom | String | Starting or departure location of the trip. |
DestinationTo | String | Ending or arrival location of the trip. |
DistanceUnitCode | String | Code that indicates the travel distance unit. Possible values are KILOMETER and MILE. |
EndDate | String | Last day of an expense that spans multiple days. |
EndOdometer | Decimal | Odometer reading at the end of a trip. |
ExchangeRate | Decimal | Rate that represents the amount one currency can be exchanged for another at a specific point in time. |
ExpenseCategoryCode | String | Code that indicates the classification of an expense item. Possible values are BUSINESS and PERSONAL. |
ExpenseCreationMethodCode | String | Code that indicates the method of expense item creation. Possible values are MOBILE iOS DEVICE and MOBILE ANDROID DEVICE. |
ExpenseId [KEY] | Long | Value that uniquely identifies a specific expense item. |
ExpenseReportId | Long | Value that uniquely identifies a specific expense report. |
ExpenseSource | String | Source of an expense item. Possible values are CASH and CORPORATE CARD. |
ExpenseTemplateId | Long | Value that uniquely identifies a specific expense template. |
ExpenseTypeId | Long | Value that uniquely identifies a specific expense type. |
FlightClassLimit | String | Expense limit for a flight class. |
FlightDuration | Decimal | Duration of an airline flight in hours. |
FlightNumber | String | Number of an airline flight. |
FuelType | String | Types of fuel for which a fuel charge is reimbursed. |
ImgReceiptRequiredFlag | Bool | Indicates whether an expense requires an imaged receipt. |
ItemizationParentExpenseId | Long | Value that uniquely identifies the parent expense of an itemized expense item. Possible values are NULL, which indicates that the expense is not itemized, -1 which indicates that the expense is a parent line with itemization, and greater than 0, which indicates that the expense is an itemized child line and the value is the parent line's identifier. |
ItemizationReceiptBusinessTotalAmount | Decimal | Expense receipt amount to be reimbursed by the employer. |
ItemizationReceiptPersonalTotalAmount | Decimal | Amount on the receipt that was incurred by the employee for personal use. |
ItineraryReservationId | Long | Value that uniquely identifies a travel reservation. |
Justification | String | Reason an expense was incurred. |
JustificationRequiredFlag | Bool | Indicates whether an expense requires justification. |
LastUpdateDate | Datetime | LastUpdateDate of ExpensesExpenseItemization |
LastUpdatedBy | String | LastUpdatedBy of ExpensesExpenseItemization |
LicensePlateNumber | String | Number of the vehicle license plate. |
Location | String | Location where the expense was incurred. |
LocationId | Long | Value that uniquely identifies a specific expense location. |
LongTermTripFlag | Bool | Indicates whether a trip is long-term. |
LongTermTripStartDate | Date | Date when a long-term trip started. |
MerchantDocumentNumber | String | Number on the receipt issued by the merchant. |
MerchantName | String | Name of the merchant where the expense was incurred. |
MerchantReference | String | Purchase identification of a transaction provided by the merchant at the point of sale. |
MerchantTaxRegNumber | String | Unique sequence of letters or numbers assigned to a party or party site by a tax authority when it is registered and by which the party or party site registration is identified. |
MerchantTaxpayerId | String | Value that uniquely identifies a merchant tax payer. |
MileagePolicyId | Long | Value that uniquely identifies a mileage policy. |
NumberOfAttendees | Decimal | Number of people that attended an event for which expenses were incurred. For example, the number of people who attended a business dinner or an entertainment event. |
NumberOfDays | Int | Number of days the expense is incurred. |
NumberPeople | Int | Number of passengers in the vehicle. |
OrgId | Long | Value that uniquely identifies the business unit associated with the row. |
PassengerAmount | Decimal | Total reimbursement for carrying passengers in the vehicle. |
PassengerName | String | Name of airline flight passenger. |
PassengerRateType | String | Passenger rate type used for mileage reimbursement for an expense. |
PaymentDueFromCode | String | Code that indicates the liability owner of the transaction. |
PersonId | Long | Value that uniquely identifies the individual on the corporate card. |
PersonalReceiptAmount | Decimal | Amount of the receipt that is marked as a personal expense. |
PolicyShortpayFlag | Bool | Indicates whether the expense is short-paid due to policy noncompliance. |
PolicyViolatedFlag | Bool | Indicates whether the expense violates company policies. |
PolicyWarningFlag | Bool | Indicates whether the expense is marked with a warning. |
PolicyWarningReasonCode | String | Code that indicates the reason for a warning that an expense auditor applies to an expense item. A list of accepted values are defined in the lookup type ORA_EXM_WARNING_REASON. |
PreparerId | Long | Value that uniquely identifies the person who created the expense report. |
RatePerPassenger | Decimal | Mileage rate per passenger for an expense. |
ReceiptAmount | Decimal | Amount of the receipt in the receipt currency. |
ReceiptCurrencyCode | String | Code that indicates the receipt currency of an expense item. |
ReceiptDate | Date | Date when a receipt is generated. |
ReceiptMissingDecRequiredFlag | Bool | Indicates whether an expense item with missing receipts requires submission of a missing receipts declaration. |
ReceiptMissingFlag | Bool | Indicates whether receipts are missing for an expense. |
ReceiptRequiredFlag | Bool | Indicates whether an expense requires a receipt. |
ReceiptVerifiedFlag | Bool | Indicates whether an auditor verifies the receipt for an expense. |
ReimbursableAmount | Decimal | Amount to be reimbursed to the individual in reimbursable currency for an expense. |
ReimbursementCurrencyCode | String | Code that indicates the currency of the amount to be reimbursed to the individual for expenses incurred. |
SequenceNumber | Decimal | Number associated with a sequence in which expense items are entered in an expense report. |
StartDate | Date | Date when the expense occurred or the first day of an expense that spans multiple days. |
TaxClassificationCode | String | Code that indicates a tax classification that applies to an expense item. |
TicketClassCode | String | Code that indicates the ticket class of a ship cabin or a flight. Possible values are BUSINESS and ECONOMY. |
TicketNumber | String | Number of the airline ticket. |
TravelMethodCode | String | Code that indicates the method of travel used during a trip. |
TravelType | String | Type of flight. Possible values are DOMESTIC and INTERNATIONAL. |
TripDistance | Decimal | Total distance traveled during a business trip for which mileage reimbursement is requested. |
UOMDays | Decimal | Calculation for the number of per diem expense days based on the unit of measure. |
ValidationErrorFlag | Bool | Indicates whether a validation error exists. |
ValidationErrorMessages | String | Error messages populated during validation. |
ValidationWarningMessages | String | Warning messages populated during validation. |
VehicleCategoryCode | String | Code that indicates the vehicle type category. Possible values are COMPANY, PRIVATE, and RENTAL. |
VehicleType | String | Type of vehicle for which mileage reimbursement is permitted. Possible values are CAR, MOTORCYCLE, and VAN. |
ZoneCode | String | Code that indicates the geographical area of the trip. |
ZoneTypeCode | String | Code that indicates the lookup type that defines the zones for which mileage rates are defined. |
ExpenseType | String | Potential expense defined during setup and against which an expense item is incurred. |
Finder | String | Finder of ExpensesExpenseItemization |
Request | String | Request of ExpensesExpenseItemization |
SysEffectiveDate | String | SysEffectiveDate of ExpensesExpenseItemization |