Expenses

The expenses view object represents detailed information about expense items for individual expense reports you enter.

Data store key : FscmTopModelAM.FinExtractAM.ExmBiccExtractAM.ExpenseExtractPVO

Primary Keys : ExpenseId

Initial Extract Date : ExpenseCreationDate

Incremental Extract Date : ExpenseLastUpdateDate

Attributes

This table provides the list of exposed attributes and their descriptions.

Name	Description
ExpenseAllocationReason	The reason for updating allocations for this report line.
ExpenseAllocationSplitCode	Indicates how this expense line is split. A null value indicates that the line is not split.
ExpenseAssignmentId	The assignment identifier of the individual on the corporate card.
ExpenseAttributeCategory	The context name for the Expenses descriptive flexfield.
ExpenseAttributeChar1	A character segment for the Expenses descriptive flexfield.
ExpenseAttributeChar10	A character segment for the Expenses descriptive flexfield.
ExpenseAttributeChar11	A character segment for the Expenses descriptive flexfield.
ExpenseAttributeChar12	A character segment for the Expenses descriptive flexfield.
ExpenseAttributeChar13	A character segment for the Expenses descriptive flexfield.
ExpenseAttributeChar14	A character segment for the Expenses descriptive flexfield.
ExpenseAttributeChar15	A character segment for the Expenses descriptive flexfield.
ExpenseAttributeChar2	A character segment for the Expenses descriptive flexfield.
ExpenseAttributeChar3	A character segment for the Expenses descriptive flexfield.
ExpenseAttributeChar4	A character segment for the Expenses descriptive flexfield.
ExpenseAttributeChar5	A character segment for the Expenses descriptive flexfield.
ExpenseAttributeChar6	A character segment for the Expenses descriptive flexfield.
ExpenseAttributeChar7	A character segment for the Expenses descriptive flexfield.
ExpenseAttributeChar8	A character segment for the Expenses descriptive flexfield.
ExpenseAttributeChar9	A character segment for the Expenses descriptive flexfield.
ExpenseAttributeDate1	A date segment for the Expenses descriptive flexfield.
ExpenseAttributeDate2	A date segment for the Expenses descriptive flexfield.
ExpenseAttributeDate3	A date segment for the Expenses descriptive flexfield.
ExpenseAttributeDate4	A date segment for the Expenses descriptive flexfield.
ExpenseAttributeDate5	A date segment for the Expenses descriptive flexfield.
ExpenseAttributeDatetime1	A date and time segment for the Expenses descriptive flexfield.
ExpenseAttributeDatetime2	A date and time segment for the Expenses descriptive flexfield.
ExpenseAttributeNumber1	A number segment for the Expenses descriptive flexfield.
ExpenseAttributeNumber2	A number segment for the Expenses descriptive flexfield.
ExpenseAttributeNumber3	A number segment for the Expenses descriptive flexfield.
ExpenseAttributeNumber4	A number segment for the Expenses descriptive flexfield.
ExpenseAttributeNumber5	A number segment for the Expenses descriptive flexfield.
ExpenseAuditAdjustmentReason	The reason for adjusting the reimbursable amount to the individual during audit.
ExpenseAuditAdjustmentReasonCode	The reason code for adjusting the reimbursable amount to the individual during audit.
ExpenseAvgMileageRate	The average mileage rate including additional applicable rates such as passenger rates and rates for hauling a trailer.
ExpenseAwtGroupId	The identifier for alternate tax withholding group.
ExpenseCardId	The unique identifier of a specific corporate card.
ExpenseCategoryCode	The classification of an expense item such as business or personal.
ExpenseCcPrepaidInvoiceId	The identifier of the payment request generated to reimburse the individual.
ExpenseCcPrepaidRequestId	The request identifier of the job that processes a corporate card transaction for reimbursement to corporate card issuer. Applicable only when payment liability is company pay.
ExpenseCheckoutDate	The date when a person departs a place associated with an accommodation expense category.
ExpenseCountryOfSupply	The country where the supplier of the expense resides.
ExpenseCreatedBy	The user who created the expense row.
ExpenseCreationDate	The date and time when the expense was created.
ExpenseCreationMethodCode	The method of expense item creation, such as mobile iOS device or mobile Android device.
ExpenseCreditCardTrxnId	The unique identifier of a specific corporate card transaction.
ExpenseDailyDistance	The distance traveled in a day for business.
ExpenseDepartureLocationId	The unique identifier of the departure location.
ExpenseDescription	The description of an item included in the expense.
ExpenseDestinationFrom	The starting or departure location of the trip.
ExpenseDestinationTo	The ending or arrival location of the trip.
ExpenseDistanceUnitCode	The unit of the distance traveled, such as kilometer and mile.
ExpenseEmpDefaultCostCenter	The default cost center assigned to an individual.
ExpenseEndDate	The last day of an expense that spans multiple days.
ExpenseExchangeRate	The rate that represents the amount one currency can be exchanged for another at a specific point in time.
ExpenseFlightNumber	The airline flight number for an expense.
ExpenseFuelType	The types of fuel for which fuel charge reimbursement is permitted.
ExpenseFuncCurrencyAmount	The amount to be reimbursed to the individual in functional currency for expenses incurred.
ExpenseId	The unique identifier of a specific expense item.
ExpenseImgReceiptRequiredFlag	Indicates whether the expense requires an imaged receipt.
ExpenseInactiveEmpProcessId	The request identifier of the job that processes the expenses of inactive employees. Applicable only if the expense is processed after the employee is terminated.
ExpenseItemizationParentExpenseId	The unique identifier of the parent expense of an itemized expense item. Possible values are NULL indicating that the expense is not itemized, -1 indicating that the expense is a parent line with itemization, and greater than 0 indicating that the expense is an itemized child line and the value is the parent line's identifier.
ExpenseJustification	The reason why the expense was incurred.
ExpenseJustificationRequiredFlag	Indicates whether the expense requires justification.
ExpenseLastUpdateDate	The date and time when the expense row was last updated.
ExpenseLastUpdateLogin	The session login associated with the user who last updated the expense row.
ExpenseLastUpdatedBy	The user who last updated the expense row.
ExpenseLicensePlateNumber	The license plate number of the vehicle.
ExpenseLocation	The location where the expense was incurred.
ExpenseLocationId	The unique identifier of a specific location.
ExpenseMerchantDocumentNumber	The receipt number on the receipt issued by the merchant.
ExpenseMerchantName	The name of the merchant where the expense was incurred.
ExpenseMerchantReference	The purchase identification of a transaction provided by the merchant at the point of sale.
ExpenseMerchantTaxRegNumber	The 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 will be identified.
ExpenseMerchantTaxpayerId	The tax payer identifier of the merchant.
ExpenseMileageRateAdjustedFlag	Indicates whether the mileage rate was adjusted after expense report approval.
ExpenseNumberOfAttendees	The number of people that attended the event for which an expense was incurred. For example, the number of people that attended a business dinner or an entertainment event.
ExpenseNumberPeople	The number of passengers in the vehicle.
ExpenseObjectVersionNumber	Used to implement optimistic locking. This number is incremented every time that the row is updated. The number is compared at the start and end of a transaction to detect whether another session has updated the row since it was queried.
ExpenseOrgId	The identifier of the business unit associated to the row.
ExpenseOrigExchangeRate	The exchange rate of the expense before it was changed.
ExpenseOrigExpenseTypeId	The expense type of the expense before it was changed.
ExpenseOrigReceiptAmount	The original amount of the receipt for this expense.
ExpenseOrigReimbursableAmount	The original amount to be reimbursed to the individual for this expense.
ExpensePassengerAmount	The total reimbursement for carrying passengers in the vehicle.
ExpensePassengerRateType	The passenger rate type used for mileage reimbursement for this expense.
ExpensePersonId	The identifier of the individual on the corporate card.
ExpensePersonalReceiptAmount	The amount of the expense that is marked as personal.
ExpensePolicyShortpayFlag	Indicates whether the expense is short paid due to policy noncompliance.
ExpensePolicyViolatedFlag	Indicates whether the expense violated company policies.
ExpensePreparerId	The identifier of the person who created the expense.
ExpenseRangeHigh	The higher limit of the distance threshold range used in mileage rate calculation.
ExpenseRangeLow	The lower limit of the distance threshold range used in mileage rate calculation.
ExpenseRatePerPassenger	The applicable mileage rate per passenger for this expense.
ExpenseReceiptAmount	The amount of the receipt in the receipt currency.
ExpenseReceiptCurrencyCode	The receipt currency of an expense item.
ExpenseReceiptMissingDecReqFlag	Indicates whether an expense item with missing receipts is required to submit missing receipts declaration.
ExpenseReceiptMissingFlag	Indicates whether the receipts are missing for this expense.
ExpenseReceiptRequiredFlag	Indicates whether this expense requires a receipt.
ExpenseReceiptVerifiedFlag	Indicates whether the auditor verified the receipt for this expense.
ExpenseReimbursableAmount	The amount to be reimbursed to the individual in reimbursable currency for this expense.
ExpenseReimbursementCurrencyCode	The currency of the amount to be reimbursed to the individual for expenses incurred.
ExpenseReportId	The unique identifier of a specific expense report.
ExpenseSequenceNum	The sequence in which expenses items are entered into an expense report.
ExpenseSource	The source of an expense item, such as cash or corporate card.
ExpenseStartDate	The date when the expense occurred or the first day of an expense that spans multiple days.
ExpenseTaxClassificationCode	The tax code applicable to the expense item.
ExpenseTemplateId	The unique identifier of a specific expense template.
ExpenseTicketClassCode	The cabin class of a flight or ship, for example business or economy.
ExpenseTicketNumber	The airline ticket number for an expense.
ExpenseTravelType	Indicates whether a flight is domestic or international.
ExpenseTripDistance	The total distance traveled during a business trip for which mileage reimbursement is requested.
ExpenseTrxnAvailableDate	The date when a corporate card transaction is available for inclusion in an expense report.
ExpenseTypeCategoryCode	The grouping of expense types and additional data fields that are relevant for a particular grouping of expenses. An example is airfare. This grouping allows expense types to include information such as class of fare, merchant, ticket number, location from, and location to.
ExpenseTypeId	The unique identifier for a specific expense type.
ExpenseUomDays	The number of per diem expense days calculated based on the unit of measure.
ExpenseVehicleCategoryCode	The grouping of vehicle types such as, company, private, or rental.
ExpenseVehicleType	The types of vehicles for which mileage reimbursement is permitted such as, car, motorcycle, and van.