Printable Expense Report Template Attributes

The following tables contain attribute names and their corresponding predefined attributes that you can use to modify the Printable Expense Report template.

Use these view object tables with the figure in the topic titled Modifying the Printable Expense Report Template: Procedures that is a related link in this topic.

PrintableReportVO - Expense Report Header Region

The following table contains attribute names and their corresponding predefined attributes, which are located in the Expense Report header region on the Printable Expense Report template.

Attribute Name	Predefined Attribute	Description
Assignment ID	AssignmentId	Assignment identifier of the individual on the corporate card.
Audit Code	AuditCode	Audit type for the expense report based on receipt requirements, such as original receipt-based audit and imaged receipt-based audit.
Both Pay Identifier	BothPayFlag	Indicates whether the expense report contains corporate card transactions with Both Pay payment liability.
Business Group ID	BusinessGroupId	Identifier of an enterprise. Used for multi-tenancy partitioning.
Cash Expense Payment Date	CashExpensePaidDate	Date when cash expense was reimbursed to the individual.
Created By	CreatedBy	Who column: indicates the user who created the row.
Creation Date	CreationDate	Who column: indicates the date and time of the creation of the row.
Current Approver ID	CurrentApproverId	Identifier of the current approver of the expense report.
Display Name	DisplayName	Derived denormalized name formatted for UI display. Formatting depends on the legislation code. Expect first name as first component in this format.
Displayed Field	DisplayedField	Expense report status.
Employee Number	EmployeeNumber	Number that identifies an employee within a company.
Entertainment Expense Identifier	EntertainmentExpenseFlag	Indicates whether this report contains any entertainment expenses.
Exchange Rate Type	ExchangeRateType	Conversion rate type used for calculating the reimbursable amount.
Expense Dates	ExpenseDates	Expense report date range.
Expense Report Date	ExpenseReportDate	Month, day, and year in which an expense report is saved or submitted.
Expense Report ID	ExpenseReportId	Identifier of the expense report.
Expense Report Number	ExpenseReportNum	Number that references an expense report and follows the numbering policies of the company.
Expense Report Processing ID	ExpRepProcessingId	Identifier of the expense report details, such as report status change history.
Expense Report Request ID	ExportRequestId	Identifier of a specific instance of the expense reimbursement process that processed this report.
Expense Report Total	ExpenseReportTotal	Total amount of the expense report in reimbursement currency. Amount in approver preferred currency is also shown if approver has a different preferred currency.
Expense Status Code	ExpenseStatusCode	Expense report approval status, such as Approved, Pending Manager Approval, or Paid.
Expense Status Date	ExpenseStatusDate	Date when expense report acquired the current status.
First Name	FirstName	Person's first name.
Formatted Report Submit Date	FormattedReportSubmitDate	Formatted date representing the date the expense report was submitted.
Formatted Total	FormattedTotal	Formatted report total amount based on reimbursement currency code.
Full Name	FullName	System constructed version of name. Used in more formal display purposes
Home Address	HomeAddress	Person's home address.
Imaged Receipt Status Code	ImagedReceiptStatusCode	Represents the imaged receipt status for the expense report.
Last Name	LastName	Person's last name.
Last Update Date	LastUpdateDate	Date the expense report was last updated.
Last Update Login	LastUpdateLogin	Login ID of the last person who accessed the expense report.
Last Updated By	LastUpdatedBy	Login ID of the last person who updated the expense report.
List Name	ListName	Constructed version of a person's name, intended for use in an alphabetically-ordered list. The value may naturally differ depending on the Legislation Code. Expect the last name as the first component in this format in most cases.
Middle Name	MiddleNames	Person's middle name.
Mileage Expense Identifier	MileageExpenseFlag	Indicates whether this report contains any mileage expense items.
Missing Images Reason	MissingImagesReason	Reason imaged receipts are not submitted with the expense report.
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.
Order Name ID	OrderName ID	System-constructed version of name used for sorting. A value is always stored in this location.
Organization ID	OrgId	Identifier of the business unit associated with the row.
Override Approver ID	OverrideApproverId	Identifier of the person chosen as the initial approver by the individual.
Parent Expense Report ID	ParentExpenseReportId	Identifier of the parent expense report.
Payment Method Code	PaymentMethodCode	Method of payment for this expense report, such as check, cash, or credit.
Person ID	PersonId	Identifier of the person whose expenses are included in this expense report.
Preparer ID	PreparerId	Identifier of the person who created the expense report.
Purpose	Purpose	Purpose of the expense report as entered by the user.
Receipt Filing Number	ReceiptFilingNumber	Receipt filing number that is manually entered by the expense auditor.
Receipt Status Code	ReceiptsStatusCode	Receipt status of an expense report, such as Missing, Required, or Received.
Receipts Receive Date	ReceiptsReceiveDate	Date when receipts for the expense report are received
Regular Expense Identifier	RegularExpenseFlag	Indicates whether this report contains any regular expenses, such as those that are not mileage, not entertainment, or not per diem.
Reimbursement Currency Code	ReimbursementCurrencyCode	Currency of the amount to be reimbursed to the individual for the expenses incurred.
Report Submit Date	ReportSubmitDate	Month, day, and year in which an expense report is submitted.
Single Reimbursement Code	SingleReimbCurrencyCode	The expense report reimbursement currency shown in the expense item table when all expense items have the same currency.

ExpenseSummaryVO - Expense Summary Region

The following table contains attribute names and their corresponding predefined attributes, which are located in the Expense Summary region on the Printable Expense Report template.

Attribute Name	Predefined Attribute	Description
Amount	Amount	Amount that is due from employer or employee.
Card ID	CardId	Identifier of the corporate card transaction.
Card Number	CardNumber	Token or encrypted card number.
Currency Code	CurrencyCode	Currency of the amount to be reimbursed to the individual for the expenses incurred.
Estimated Total	EstimatedTotal	Estimated expense report total.
Expense Report ID	ExpenseReportId	Identifier of the expense report.
Formatted Amount	FormattedAmount	Formatted amount based on the currency code.
Payment Due From	Payment DueFrom	Party responsible for payment.
Summary Type	SummaryType	Indicator of payment responsibility.
Total	Total	Total amount of the expense report in reimbursement currency.

PrintableExpenseVO - Expense Items Region

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.
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.
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.
Employee Name	EmployeeName	Employee's name defined in Oracle Human Capital Management.
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.
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.
Location ID	LocationId	Identifier of a specific location.
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.
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.
Receipt Required Identifier	ReceiptRequiredFlag	Indicates whether this expense requires a receipt.
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.

PrintableExpenseDistVO - Distributions Region

The following table contains attribute names and their corresponding predefined attributes, which are located in the Distributions region on the Printable Expense Report template.

Attribute Name	Predefined Attribute	Description
Code Combination ID	CodeCombinationId	Identifier of the accounting code combination to which that expense is charged.
Cost Center	CostCenter	Cost center to which the expense is charged.
Created By	CreatedBy	Who column: indicates the user who created the row.
Creation Date	CreationDate	Who column: indicates the date and time of the creation of the row.
Expense Distribution ID	ExpenseDistId	Identifier of the expense distribution of a specific expense item.
Expense ID	ExpenseId	Identifier of the expense for this distribution.
Expense Report ID	ExpenseReportId	Identifier of the expense report, which includes the expense corresponding to this distribution.
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 Updated By Login	LastUpdateLogin	Who column: indicates the session login associated with the user who last updated the row.
Object Version Number	Object Version Number	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.
Project Billable Identifier	PJC_BILLABLE_FLAG	Indicates whether a project-related item is available to be billed to customers.
Project Capitalization Identifier	PJC_CAPITALIZABLE_FLAG	Indicates whether a project-related item is eligible for capitalization.
Project Context Category	PJC_CONTEXT_CATEGORY	Segment used to identify the descriptive flexfield application context for project-related standardized cost collection.
Project Contract ID	PJC_CONTRACT_ID	Identifier of contract. Used when Oracle Contract Billing or Oracle Grants Accounting is installed.
Project Contract Line ID	PJC_CONTRACT_LINE_ID	Tracks contract line information. Used when Oracle Contract Billing or Oracle Grants Accounting is installed.
Project Expenditure Item Date	PJC_EXPENDITURE_ITEM_DATE	Date on which a project-related transaction is incurred.
Project Expenditure Type ID	PJC_EXPENDITURE_TYPE_ID	Expenditure type used to build the transaction descriptive flexfield for project-related transaction distributions.
Project Funding Allocation ID	PJC_FUNDING_ALLOCATION_ID	Specifies the name of the project funding override. Used when Oracle Contract Billing or Oracle Grants Accounting is installed.
Project Organization ID	PJC_ORGANIZATION_ID	Identifier of expenditure organization used to build the transaction descriptive flexfield for project-related transaction distributions.
Project ID	PJC_PROJECT_ID	Identifier of the project used to build the transaction descriptive flexfield for project-related transaction distributions.
Reserved Project Fields	PJC_RESERVED_ATTRIBUTE1-10	Reserved for project-related functionality.
Project Task ID	PJC_TASK_ID	Identifier of the task used to build the transaction descriptive flexfield for project-related transaction distributions.
Reserved User Defined Project Fields	PJC_USER_DEF_ATTRIBUTE1-10	Reserved for user-defined project information.
Project Work Type ID	PJC_WORK_TYPE_ID	Identifier of project-related classification for worked performed.
Prepare Modified Identifier	PreparerModifiedFlag	Indicates whether the expense preparer modified the account or project distribution.
Project Name	ProjectName	Project name to which an expense item is assigned.
Project Number	ProjectNumber	Project number to which an expense item is assigned.
Reimbursable Amount	ReimbursableAmount	Amount to be reimbursed to the individual against this expense distribution.
Key Flexfield Segment 1-30	Segment1-30	Key flexfield: segment of the key flexfield.
Sequence Number	SequenceNum	Sequence in which the distributions are created.
Task Name	TaskName	Task name to which an expense item is assigned.
Task Number	TaskNumber	Task number to which an expense item is assigned.

EmployeeExpenseAttendeeVO - Employee Attendees Region

The following table contains attribute names and their corresponding predefined attributes, which are located in the Employee Attendees region on the Printable Expense Report template.

Attribute Name	Predefined Attribute	Description
Amount	Amount	Amount spent on the expense attendee.
Attendee Party ID	AttendeePartyId	Attendee party identifier.
Attendee Type	AttendeeType	Attendee or recipient type of the expense attendee.
Created By	CreatedBy	Who column: indicates the user who created the row.
Creation Date	CreationDate	Who column: indicates the date and time of the creation of the row.
Employee Identifier	EmployeeFlag	Indicates whether an expense attendee is an employee.
Employer Address	EmployerAddress	Employer address of the expense attendee.
Employer Name	EmployerName	Employer name of the employee or nonemployee attendee.
Employer Party ID	ExployerPartyId	Employer party identifier.
Expense Attendee ID	ExpenseAttendeeId	Expense attendee identifier.
Expense ID	ExpenseId	Related expense item identifier.
Formatted Amount	FormattedAmount	Formatted receipt amount.
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 Updated By Login	LastUpdateLogin	Who column: indicates the session login associated with the user who last updated the row.
Name	Name	Name of the employee or nonemployee expense attendee.
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.
Tax Identifier	TaxIdentifier	Tax identifier of the employee or nonemployee expense attendee.
Title	Title	Title of the employee or nonemployee expense attendee.

NonemployeeExpenseAttendeeVO - Nonemployee Attendees Region

The following table contains attribute names and their corresponding predefined attributes, which are located in the Nonemployee Attendees region on the Printable Expense Report template.

Attribute Name	Predefined Attribute	Description
Amount	Amount	Amount spent on the expense attendee.
Attendee Party ID	AttendeePartyId	Attendee party identifier.
Attendee Type	AttendeeType	Attendee or recipient type of the expense attendee.
Created By	CreatedBy	Who column: indicates the user who created the row.
Creation Date	CreationDate	Who column: indicates the date and time of the creation of the row.
Employee Identifier	EmployeeFlag	Indicates whether expense attendee is an employee.
Employer Address	EmployerAddress	Employer address of the expense attendee.
Employer Name	EmployerName	Employer name of the employee or nonemployee attendee.
Employer Party ID	EmployerPartyId	Employer party identifier.
Expense Attendee ID	ExpenseAttendeeId	Expense attendee identifier.
Expense ID	ExpenseId	Related expense item identifier.
Formatted Amount	FormattedAmount	Formatted receipt amount.
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 Updated By Login	LastUpdateLogin	Who column: indicates the session login associated with the user who last updated the row.
Name	Name	Name of the employee or nonemployee expense attendee.
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.
Tax Identifier	TaxIdentifier	Tax identifier of the employee or non-employee expense attendee.
Title	Title	Title of the employee or nonemployee expense attendee.

AttachmentVO - Attachment Region

The following table contains attribute names and their corresponding predefined attributes, which are located in the Attachment region on the Printable Expense Report template.

Attribute Name	Predefined Attribute	Description
Document	DOCUMENT	Actual document for the associated document type.
Title	TITLE	Title that the user gave the attachment.