The following table contains attribute names and their corresponding predefined attributes, which are located in the Expense Items region on the Printable Expense Report template.
Attribute Name Predefined Attribute Description
Assignment ID AssignmentId Identifier of the assignment for the person
on the expense report.
Billed Amount BilledAmount Amount billed to the corporate card
account.
Billed Currency Code BilledCurrencyCode Corporate card transaction billed currency
code.
Attribute Name Predefined Attribute Description
Billed Date BilledDate Date of the statement on which the
transaction appears.
Billed Decimal Placement BilledDecimal Number of decimal places used to display
the billed amount.
Business Amount BusinessAmount Expense business amount.
Card ID CardId Identifier of a specific corporate card.
Card Member Name CardmemberName Card member name.
Card Number CardNumber Token or encrypted card number.
Card Program ID CardProgramId Identifier of the corporate card program.
Card Program Name CardProgramName Corporate card program name.
Card Reference ID CardReferenceId Identifier of the corporate card in Oracle
Fusion Payments.
Card Status Code CardStatusCode Status of a corporate card, such as Active,
Inactive, or Unassigned.
Category Code CategoryCode Expense type category code.
Code Combination ID CodeCombinationId Identifier of the accounting code
combination to which that expense is charged.
Company Account ID CompanyAccountId Identifier assigned by the card issuer to
the deploying company or its business unit.
Company Number CompanyNumber Corporate account number assigned by
the card issuer to the deploying company or its business unit.
Cost Center CostCenter Cost center to which an expense item is
assigned.
Created By CreatedBy DisplaySequence Who column: indicates the user who
created the row.
Attribute Name Predefined Attribute Description
Creation Date CreationDate Who column: indicates the date and time
of the creation of the row.
Credit Card Transaction ID CreditCardTrxnId Identifier of a specific corporate card transaction.
Currency Conversion Rate CurrencyConversionRate A rate that represents the amount one currency can be exchanged for another at a specific point in time. Oracle Applications can access daily, periodic, and historical rates. These rates are used for foreign currency conversion, revaluation, and translation.
Default Project Expenditure Type DefaultProjExpendType Project expenditure that is assigned to an expense type that has not been set up at the project level.
Description Description Description of an expense item.
Default Corporate Card Expense Type ID DfltCcExpTypeId Card expense type used if no mapping rule has been specified.
Expense Type Category DisplayedField Expense type category.
Expense Source DisplayedField1 Source of the transaction, either Cash or
Corporate Card.
Display Policy Violation Identifier DisplayPolicyViolationFlag Indicates whether an expense item has a policy violation.
Display Policy Violation Identifier DisplayViolationFlag Indicates whether employees are warned when they submit expenses that exceed defined entertainment expense policy rate limit.
Display Receipt Violation Identifier DispRcptViolationFlag Indicates whether a receipt missing policy warning is displayed to the user.
Dispute Date DisputeDate Date when the individual placed this
transaction or dispute.
Employee Default Cost Center EmpDefaultCostCenter Employee's default cost center defined in Oracle Human Capital Management.
Attribute Name Predefined Attribute Description
Enable Corporate Card Mapping Identifier EnableCcMappingFlag Indicates whether the lookup codes from the charge file are associated with the company's expense types.
Project Enabled Identifier EnableProjectsFlag Indicates whether the expense item is
enabled for projects.
End Date EndDate Distribution end date.
Exchange Rate ExchangeRate Rate that represents the amount one
currency can be exchanged for another at a specific point in time.
Attendee ExpenseAttendee Attendee identified at the distribution
level.
Expense Category Code ExpenseCategoryCode Expense category.
Expense ID ExpenseId Identifier of a specific expense item..
Expense Report ID ExpenseReportId Identifier of a specific expense report.
Expense Source ExpenseSource Source of the transaction, either Cash or
Corporate Card.
Expense Template ID ExpenseTemplateId Identifier of a specific expense template.
Expense Template Name ExpenseTemplateName Name of the expense report template.
Expense Type Category Code ExpenseTypeCategoryCode 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.
Expense Type ID ExpenseTypeId Identifier for a specific expense type.
Expense Type Name ExpenseTypeName Name of the expense type.
Formatted Amount FormattedAmount Formatted reimbursable amount.
Formatted Start Date FormattedStartDate Formatted expense start date.
Attribute Name Predefined Attribute Description
Functional Currency Amount
FuncCurrencyAmount Amount to be reimbursed to the individual in functional currency for expenses incurred.
Attendees Includes Employees HasEmployeeAttendees Indicator that the expense includes employee attendees.
Attendees Includes Nonemployees. HasNonEmployeeAttendees Indicator that the expense includes nonemployee attendees.
Imaged Receipt Required Identifier ImgReceiptRequiredFlag Indicates whether this expense requires an imaged receipt.
Include Personal Expense Identifier InclPersonalExpenseFlag Indicates whether the expense item includes a personal amount.
Itemization Parent Expense ID ItemizationParentExpenseId 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.
Expense Item Sequence ItemSequence Sequence in which expenses items are
entered into an expense report.
Justification Justification Reason an expense was incurred.
Justification Required Identifier JustificationRequiredFlag Indicates whether the expense requires justification.
Last Update Date LastUpdateDate Who column: indicates the date and time
of the last update of the row.
Last Updated By LastUpdatedBy Who column: indicates the user who last
updated the row.
Last Update Login LastUpdateLogin Who column: indicates the session login
associated with the user who last updated the row.
Location Location Expense location.
Attribute Name Predefined Attribute Description
Masked Card Number MaskedCardNumber Token or masked card number.
Merchant Document Number MerchantDocumentNumber Receipt number on the receipt issued by the merchant.
Merchant Name MerchantName Name of the merchant where the expense
was incurred.
Merchant Reference MerchantReference Purchase identification of a transaction
provided by the merchant at the point of sale.
Merchant Taxpayer ID MerchantTaxpayerId Tax payer identifier of the merchant.
Expense Template Name Name Expense template name.
Number of Days NumberOfDays Number of days that the expense spans.
Number of People NumberPeople 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.
Object Version Number ObjectVersionNumber 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.
Organization ID OrgId Identifier of the business unit associated
with the row.
Original Reimbursable Amount OrigReimbursableAmount Original amount to be reimbursed to the individual for this expense.
Parent Expense Type ID ParentExpenseTypeId 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.
Passenger Amount PassengerAmount Passenger amount of the mileage
expense.
Attribute Name Predefined Attribute Description
Payment Due From Code PaymentDueFromCode Party responsible for payment.
Payment Identifier PaymentFlag Payment identifier from credit card
transactions table.
Personal Amount PersonalAmount Amount of the expense that is marked as
personal.
Person ID PersonId Identifier of the individual.
Policy Short Pay Identifier PolicyShortpayFlag Indicates whether the expense is short paid due to policy noncompliance.
Policy Violated Identifier PolicyViolatedFlag Indicates whether the expense violated company policies.
Posted Amount PostedAmount Transaction amount that was posted to
the statement or account.
Posted Currency Code PostedCurrencyCode Currency code associated with a posted
corporate card transaction.
Posted Date PostedDate Date the transaction was posted to the
statement.
Posted Decimal Placement PostedDecimal Number of decimal places used to display
the posted amount.
Preparer ID PreparerId Identifier of the person who created the
expense.
Project ID ProjectId Project identifier of the expense item.
Receipt Amount ReceiptAmount Amount of the receipt in the receipt
currency.
Receipt Currency Code ReceiptCurrencyCode Receipt currency of an expense item.
Receipt Missing Identifier ReceiptMissingFlag Indicates whether the receipts are missing for this expense.
Attribute Name Predefined Attribute Description
Receipt Verified Identifier ReceiptVerifiedFlag Indicates whether the auditor verified the receipt for this expense.
Reference Number ReferenceNumber Corporate card reference number.
Reimbursable Amount ReimbursableAmount Expense item reimbursable amount.
Reimbursement Currency Code ReimbursementCurrencyCode Expense item reimbursable currency.
Request ID RequestId Request identifier in Enterprise Service
Scheduler of the process that created or last updated the row.
Sequence Number SequenceNum Sequence in which expenses items are
entered into an expense report.
Source Type SourceType Source of an expense item, such as cash
or corporate card.
Start Date StartDate Expense item start date.
Transaction Amount TransactionAmount Amount charged by the merchant in the
currency of the transaction.
Transaction Date TransactionDate Transaction date of item for detailed
transaction.
Transaction Status TransactionStatus Corporate card transaction status.
Transaction Type TransactionType Corporate card transaction type.
Trip Distance TripDistance Estimated total travel distance for
a business trip for which mileage reimbursement will be requested.
Vehicle Category Code VehicleCategoryCode Category of vehicle driven, such as
Company or Private.