eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

DBA Data [Home] [Help] [Dependency Information]

TABLE: AP.AP_EXPENSE_REPORT_HEADERS_ALL

Object Details

Object Name:	AP_EXPENSE_REPORT_HEADERS_ALL
Object Type:	TABLE
Owner:	AP
FND Design Data:	SQLAP.AP_EXPENSE_REPORT_HEADERS_ALL
Subobject Name:
Status:	VALID

AP_EXPENSE_REPORT_HEADERS_ALL stores header information about the expense reports entered in Oracle Payables and Oracle Self-Service Expenses.

There is one row for each expense report you enter. Your Oracle Payables application uses this information to create invoice header information when you transfer expense reports to invoice tables. Transfer expense reports to invoice tables using the Expense Report Import program.

Your Oracle Payables application places the invoice ID in the VOUCHNO column when you transfer an expense report. To import invoices from an external source, Oracle recommends that you use the new Payables Open Interface tables.

This table corresponds to the header region of the Expense Reports window.

Storage Details

Tablespace:	APPS_TS_INTERFACE
PCT Free:	10
PCT Used:

Indexes

Index	Type	Uniqueness	Tablespace	Column
AP_EXPENSE_REPORT_HEADERS_U1	NORMAL	UNIQUE	APPS_TS_INTERFACE	REPORT_HEADER_ID
AP_EXPENSE_REPORT_HEADERS_N1	NORMAL	NONUNIQUE	APPS_TS_INTERFACE	VOUCHNO
AP_EXPENSE_REPORT_HEADERS_N11	NORMAL	NONUNIQUE	APPS_TS_INTERFACE	REPORT_SUBMITTED_DATE
AP_EXPENSE_REPORT_HEADERS_N12	NORMAL	NONUNIQUE	APPS_TS_INTERFACE	RECEIPTS_RECEIVED_DATE
AP_EXPENSE_REPORT_HEADERS_N13	NORMAL	NONUNIQUE	APPS_TS_INTERFACE	RECEIPTS_STATUS
AP_EXPENSE_REPORT_HEADERS_N14	NORMAL	NONUNIQUE	APPS_TS_INTERFACE	HOLDING_REPORT_HEADER_ID
AP_EXPENSE_REPORT_HEADERS_N15	NORMAL	NONUNIQUE	APPS_TS_INTERFACE	REQUEST_ID
AP_EXPENSE_REPORT_HEADERS_N2	NORMAL	NONUNIQUE	APPS_TS_INTERFACE	EMPLOYEE_ID
AP_EXPENSE_REPORT_HEADERS_N3	NORMAL	NONUNIQUE	APPS_TS_INTERFACE	REFERENCE_1 REFERENCE_2
AP_EXPENSE_REPORT_HEADERS_N4	NORMAL	NONUNIQUE	APPS_TS_INTERFACE	INVOICE_NUM
AP_EXPENSE_REPORT_HEADERS_N5	NORMAL	NONUNIQUE	APPS_TS_INTERFACE	PAID_ON_BEHALF_EMPLOYEE_ID
AP_EXPENSE_REPORT_HEADERS_N6	NORMAL	NONUNIQUE	APPS_TS_INTERFACE	SHORTPAY_PARENT_ID
AP_EXPENSE_REPORT_HEADERS_N7	NORMAL	NONUNIQUE	APPS_TS_INTERFACE	BOTHPAY_PARENT_ID
AP_EXPENSE_REPORT_HEADERS_N8	NORMAL	NONUNIQUE	APPS_TS_INTERFACE	LAST_AUDITED_BY
AP_EXPENSE_REPORT_HEADERS_N9	NORMAL	NONUNIQUE	APPS_TS_INTERFACE	EXPENSE_STATUS_CODE

Columns

Name	Datatype	Length	Mandatory	Comments
REPORT_HEADER_ID	NUMBER		Yes	Expense report header identifier
EMPLOYEE_ID	NUMBER	(10)		Employee identifier
WEEK_END_DATE	DATE		Yes	Period ending date of expense report, used as invoice_date and GL_date for expense reports
CREATION_DATE	DATE		Yes	Standard who column - date when this row was created.
CREATED_BY	NUMBER		Yes	Standard who column - user who created this row (foreign key to FND_USER.USER_ID).
LAST_UPDATE_DATE	DATE		Yes	Standard Who column - date when a user last updated this row.
LAST_UPDATED_BY	NUMBER		Yes	Standard who column - user who last updated this row (foreign key to FND_USER.USER_ID).
VOUCHNO	NUMBER		Yes	Invoice ID (populated when you transfer an expense report)
TOTAL	NUMBER		Yes	Total amount of expense report
VENDOR_ID	NUMBER	(15)		Supplier identifier
VENDOR_SITE_ID	NUMBER	(15)		Supplier site identifier
EXPENSE_CHECK_ADDRESS_FLAG	VARCHAR2	(30)		Flag that indicates if expense report will be sent to employee's home (H) or office (O) address
REFERENCE_1	VARCHAR2	(30)		Reference field for use by Oracle Projects or other external source invoice loading program.
REFERENCE_2	VARCHAR2	(30)		Reference field for use by Oracle Projects or other external source invoice loading program
INVOICE_NUM	VARCHAR2	(50)		The expense report number, which is usually a combination of a customizable report prefix and the report header identifier.
EXPENSE_REPORT_ID	NUMBER			The expense report template identifier.
ACCTS_PAY_CODE_COMBINATION_ID	NUMBER	(15)		Accounting Flexfield identifier for accounts payable liability account
SET_OF_BOOKS_ID	NUMBER	(15)		Set of books identifier
SOURCE	VARCHAR2	(25)		Source of expense report, used by Expense Report Import
PURGEABLE_FLAG	VARCHAR2	(1)		Flag that indicates if expense report will be purged after it is transferred with Expense Report Import (Y or N)
ACCOUNTING_DATE	DATE			Accounting date for records with source other than XpenseXpress
MAXIMUM_AMOUNT_TO_APPLY	NUMBER			Maximum amount of employee advance to be applied to an expense report
ADVANCE_INVOICE_TO_APPLY	NUMBER	(15)		Specific employee advance to apply to an expense report
APPLY_ADVANCES_DEFAULT	VARCHAR2	(4)		Flag that indicates if advances will be applied against expense reports (Y or N)
EMPLOYEE_CCID	NUMBER			Accounting Flexfield identifier for expense account associated with an employee
DESCRIPTION	VARCHAR2	(240)		Description of expense report
REJECT_CODE	VARCHAR2	(30)		Rejection code used by Expense Report Import for exception reporting
HOLD_LOOKUP_CODE	VARCHAR2	(25)		Name of hold placed on expense report
ATTRIBUTE_CATEGORY	VARCHAR2	(150)		Descriptive flexfield structure definition column.
ATTRIBUTE1	VARCHAR2	(150)		Descriptive flexfield segment
ATTRIBUTE2	VARCHAR2	(150)		Descriptive flexfield segment
ATTRIBUTE3	VARCHAR2	(150)		Descriptive flexfield segment
ATTRIBUTE4	VARCHAR2	(150)		Descriptive flexfield segment
ATTRIBUTE5	VARCHAR2	(150)		Descriptive flexfield segment
ATTRIBUTE6	VARCHAR2	(150)		Descriptive flexfield segment
ATTRIBUTE7	VARCHAR2	(150)		Descriptive flexfield segment
ATTRIBUTE8	VARCHAR2	(150)		Descriptive flexfield segment
ATTRIBUTE9	VARCHAR2	(150)		Descriptive flexfield segment
ATTRIBUTE10	VARCHAR2	(150)		Descriptive flexfield segment
ATTRIBUTE11	VARCHAR2	(150)		Descriptive flexfield segment
ATTRIBUTE12	VARCHAR2	(150)		Descriptive flexfield segment
ATTRIBUTE13	VARCHAR2	(150)		Descriptive flexfield segment
ATTRIBUTE14	VARCHAR2	(150)		Descriptive flexfield segment
ATTRIBUTE15	VARCHAR2	(150)		Descriptive flexfield segment
DEFAULT_CURRENCY_CODE	VARCHAR2	(15)	Yes	Currency code
DEFAULT_EXCHANGE_RATE_TYPE	VARCHAR2	(30)		Exchange rate type for foreign currency
DEFAULT_EXCHANGE_RATE	NUMBER			Exchange rate for foreign currency
DEFAULT_EXCHANGE_DATE	DATE			Date exchange rate is effective, usually the accounting date of a transaction
LAST_UPDATE_LOGIN	NUMBER	(15)		Standard who column - operating system login of user who last updated this row (foreign key to FND_LOGINS.LOGIN_ID).
VOUCHER_NUM	VARCHAR2	(50)		Not currently in use.
USSGL_TRANSACTION_CODE	VARCHAR2	(30)		Default transaction code for creating US Standard General Ledger journal entries
USSGL_TRX_CODE_CONTEXT	VARCHAR2	(30)		USSGL Transaction Code Descriptive Flexfield context column
DOC_CATEGORY_CODE	VARCHAR2	(30)		Sequential numbering (voucher number) document category
AWT_GROUP_ID	NUMBER	(15)		Withholding Tax group identifier
ORG_ID	NUMBER	(15)		Organization identifier
WORKFLOW_APPROVED_FLAG	VARCHAR2	(1)		Workflow approved flag.
FLEX_CONCATENATED	VARCHAR2	(240)		Indicates the cost center of the expense report entered in Self-Service Expenses.
GLOBAL_ATTRIBUTE_CATEGORY	VARCHAR2	(150)		Reserved for country-specific functionality
GLOBAL_ATTRIBUTE1	VARCHAR2	(150)		Reserved for country-specific functionality
GLOBAL_ATTRIBUTE2	VARCHAR2	(150)		Reserved for country-specific functionality
GLOBAL_ATTRIBUTE3	VARCHAR2	(150)		Reserved for country-specific functionality
GLOBAL_ATTRIBUTE4	VARCHAR2	(150)		Reserved for country-specific functionality
GLOBAL_ATTRIBUTE5	VARCHAR2	(150)		Reserved for country-specific functionality
GLOBAL_ATTRIBUTE6	VARCHAR2	(150)		Reserved for country-specific functionality
GLOBAL_ATTRIBUTE7	VARCHAR2	(150)		Reserved for country-specific functionality
GLOBAL_ATTRIBUTE8	VARCHAR2	(150)		Reserved for country-specific functionality
GLOBAL_ATTRIBUTE9	VARCHAR2	(150)		Reserved for country-specific functionality
GLOBAL_ATTRIBUTE10	VARCHAR2	(150)		Reserved for country-specific functionality
GLOBAL_ATTRIBUTE11	VARCHAR2	(150)		Reserved for country-specific functionality
GLOBAL_ATTRIBUTE12	VARCHAR2	(150)		Reserved for country-specific functionality
GLOBAL_ATTRIBUTE13	VARCHAR2	(150)		Reserved for country-specific functionality
GLOBAL_ATTRIBUTE14	VARCHAR2	(150)		Reserved for country-specific functionality
GLOBAL_ATTRIBUTE15	VARCHAR2	(150)		Reserved for country-specific functionality
GLOBAL_ATTRIBUTE16	VARCHAR2	(150)		Reserved for country-specific functionality
GLOBAL_ATTRIBUTE17	VARCHAR2	(150)		Reserved for country-specific functionality
GLOBAL_ATTRIBUTE18	VARCHAR2	(150)		Reserved for country-specific functionality
GLOBAL_ATTRIBUTE19	VARCHAR2	(150)		Reserved for country-specific functionality
GLOBAL_ATTRIBUTE20	VARCHAR2	(150)		Reserved for country-specific functionality
OVERRIDE_APPROVER_ID	NUMBER	(9)		Overriding approver employee identifier
PAYMENT_CROSS_RATE_TYPE	VARCHAR2	(30)		Cross currency payment rate type
PAYMENT_CROSS_RATE_DATE	DATE			Cross currency payment rate date
PAYMENT_CROSS_RATE	NUMBER			Exchange rate between invoice and payment; in Release 11 the value is always 1 unless they are fixed-rate currencies
PAYMENT_CURRENCY_CODE	VARCHAR2	(15)		Cross currency payment code
CORE_WF_STATUS_FLAG	VARCHAR2	(1)		Reserved for future use
PREPAY_APPLY_FLAG	VARCHAR2	(4)		This column will store the value for the checkbox in the expense reports window. It will indicate whether the expense report should apply prepayments or not.
PREPAY_NUM	VARCHAR2	(50)		This column will store the invoice number of an existing, fully paid prepayment. This column will specify the prepayment which contains the distribution that will be applied to the imported invoice.
PREPAY_DIST_NUM	NUMBER	(15)		This column will store the distribution of an existing prepayment. This distribution will be applied to the imported invoice. The invoice will be rejected if prepay_num is specified and prepayment has more than one distribution. If prepayment has only one distribution, then import program will apply this distribution by default.
PREPAY_APPLY_AMOUNT	NUMBER			This column will store the amount of prepayment that the user wishes to apply to the invoice. This amount has to be postive. If prepay_apply_amount is negative, invoice will be rejected.
PREPAY_GL_DATE	DATE			This column will store the GL_DATE that will be used for prepayment distributions, on the invoice, after application. If the user does not specify this date, then Prepay_GL_DATE for prepayment distributions will default from GL_DATE of the invoice.
BOTHPAY_PARENT_ID	NUMBER	(15)		When System Profile option "SS Expenses:CC Payment Due From" is BOTH pay, an expense report that contains both Out-of-pocket expenses and Credit card charges get split into one with only out-of-pocket expenses and another one with only credit card charges after the report goes through manager and AP approval processes. When the report does get split in Both Pay scenario, the new expense report?s bothpay_parent_id gets populated with the original expense report?s report_header_id
SHORTPAY_PARENT_ID	NUMBER	(15)		When an expense report gets shortpaid and is split into different expense reports, the new ones that get spawned off have their shortpay_parent_id columns populated with the original report's report_header_id
PAID_ON_BEHALF_EMPLOYEE_ID	NUMBER	(15)		When an expense report gets split in Both Pay scenario, the new expense report's paid_on_behalf_employee_id gets populated with the original expense report's employee_id.
OVERRIDE_APPROVER_NAME	VARCHAR2	(240)		Temporary storage for override approver name when user enteres it manually and wants to save the expesne report
AMT_DUE_CCARD_COMPANY	NUMBER			Amount that is due to credit card company
AMT_DUE_EMPLOYEE	NUMBER			Amount that is due to employee
DEFAULT_RECEIPT_CURRENCY_CODE	VARCHAR2	(15)		This contains the default selected receipt currency code for Expense Report Lines
MULTIPLE_CURRENCIES_FLAG	VARCHAR2	(1)		This flag indicates whether or not the Currency poplist should be displayed for Expense Report Lines
EXPENSE_STATUS_CODE	VARCHAR2	(30)		Status code of expense report
EXPENSE_LAST_STATUS_DATE	DATE			Last date that the status was changed
EXPENSE_CURRENT_APPROVER_ID	NUMBER	(15)		Current Approver ID of expense report
REPORT_FILING_NUMBER	VARCHAR2	(240)		Auditor-defined expense report filing number.
RECEIPTS_RECEIVED_DATE	DATE			Date when AP department received receipt package.
AUDIT_CODE	VARCHAR2	(30)		Identifies the auditing method.
REPORT_SUBMITTED_DATE	DATE			Date report was submitted
LAST_AUDITED_BY	NUMBER	(15)		Identifier of the user who last audited this expense report
RETURN_REASON_CODE	VARCHAR2	(30)		Explains the reason the auditor is returning the expense report to the preparer
RETURN_INSTRUCTION	VARCHAR2	(4000)		Allows the auditor to add additional instructions to expense reports that are being returned to the preparer
RECEIPTS_STATUS	VARCHAR2	(30)		Receipt package status
HOLDING_REPORT_HEADER_ID	NUMBER	(15)		Report header ID of the expense report that is causing a hold on this expense report.
REQUEST_ID	NUMBER	(15)		Concurrent request identifier
ADVANCES_JUSTIFICATION	VARCHAR2	(240)		Stores the justification, if advances are not applied.

Query Text

Cut, paste (and edit) the following text to query this object:


SELECT REPORT_HEADER_ID
,      EMPLOYEE_ID
,      WEEK_END_DATE
,      CREATION_DATE
,      CREATED_BY
,      LAST_UPDATE_DATE
,      LAST_UPDATED_BY
,      VOUCHNO
,      TOTAL
,      VENDOR_ID
,      VENDOR_SITE_ID
,      EXPENSE_CHECK_ADDRESS_FLAG
,      REFERENCE_1
,      REFERENCE_2
,      INVOICE_NUM
,      EXPENSE_REPORT_ID
,      ACCTS_PAY_CODE_COMBINATION_ID
,      SET_OF_BOOKS_ID
,      SOURCE
,      PURGEABLE_FLAG
,      ACCOUNTING_DATE
,      MAXIMUM_AMOUNT_TO_APPLY
,      ADVANCE_INVOICE_TO_APPLY
,      APPLY_ADVANCES_DEFAULT
,      EMPLOYEE_CCID
,      DESCRIPTION
,      REJECT_CODE
,      HOLD_LOOKUP_CODE
,      ATTRIBUTE_CATEGORY
,      ATTRIBUTE1
,      ATTRIBUTE2
,      ATTRIBUTE3
,      ATTRIBUTE4
,      ATTRIBUTE5
,      ATTRIBUTE6
,      ATTRIBUTE7
,      ATTRIBUTE8
,      ATTRIBUTE9
,      ATTRIBUTE10
,      ATTRIBUTE11
,      ATTRIBUTE12
,      ATTRIBUTE13
,      ATTRIBUTE14
,      ATTRIBUTE15
,      DEFAULT_CURRENCY_CODE
,      DEFAULT_EXCHANGE_RATE_TYPE
,      DEFAULT_EXCHANGE_RATE
,      DEFAULT_EXCHANGE_DATE
,      LAST_UPDATE_LOGIN
,      VOUCHER_NUM
,      USSGL_TRANSACTION_CODE
,      USSGL_TRX_CODE_CONTEXT
,      DOC_CATEGORY_CODE
,      AWT_GROUP_ID
,      ORG_ID
,      WORKFLOW_APPROVED_FLAG
,      FLEX_CONCATENATED
,      GLOBAL_ATTRIBUTE_CATEGORY
,      GLOBAL_ATTRIBUTE1
,      GLOBAL_ATTRIBUTE2
,      GLOBAL_ATTRIBUTE3
,      GLOBAL_ATTRIBUTE4
,      GLOBAL_ATTRIBUTE5
,      GLOBAL_ATTRIBUTE6
,      GLOBAL_ATTRIBUTE7
,      GLOBAL_ATTRIBUTE8
,      GLOBAL_ATTRIBUTE9
,      GLOBAL_ATTRIBUTE10
,      GLOBAL_ATTRIBUTE11
,      GLOBAL_ATTRIBUTE12
,      GLOBAL_ATTRIBUTE13
,      GLOBAL_ATTRIBUTE14
,      GLOBAL_ATTRIBUTE15
,      GLOBAL_ATTRIBUTE16
,      GLOBAL_ATTRIBUTE17
,      GLOBAL_ATTRIBUTE18
,      GLOBAL_ATTRIBUTE19
,      GLOBAL_ATTRIBUTE20
,      OVERRIDE_APPROVER_ID
,      PAYMENT_CROSS_RATE_TYPE
,      PAYMENT_CROSS_RATE_DATE
,      PAYMENT_CROSS_RATE
,      PAYMENT_CURRENCY_CODE
,      CORE_WF_STATUS_FLAG
,      PREPAY_APPLY_FLAG
,      PREPAY_NUM
,      PREPAY_DIST_NUM
,      PREPAY_APPLY_AMOUNT
,      PREPAY_GL_DATE
,      BOTHPAY_PARENT_ID
,      SHORTPAY_PARENT_ID
,      PAID_ON_BEHALF_EMPLOYEE_ID
,      OVERRIDE_APPROVER_NAME
,      AMT_DUE_CCARD_COMPANY
,      AMT_DUE_EMPLOYEE
,      DEFAULT_RECEIPT_CURRENCY_CODE
,      MULTIPLE_CURRENCIES_FLAG
,      EXPENSE_STATUS_CODE
,      EXPENSE_LAST_STATUS_DATE
,      EXPENSE_CURRENT_APPROVER_ID
,      REPORT_FILING_NUMBER
,      RECEIPTS_RECEIVED_DATE
,      AUDIT_CODE
,      REPORT_SUBMITTED_DATE
,      LAST_AUDITED_BY
,      RETURN_REASON_CODE
,      RETURN_INSTRUCTION
,      RECEIPTS_STATUS
,      HOLDING_REPORT_HEADER_ID
,      REQUEST_ID
,      ADVANCES_JUSTIFICATION
FROM AP.AP_EXPENSE_REPORT_HEADERS_ALL;

Dependencies

[top of page]

AP.AP_EXPENSE_REPORT_HEADERS_ALL does not reference any database object

AP.AP_EXPENSE_REPORT_HEADERS_ALL is referenced by following:

APPS: AP_EXPENSE_REPORT_HEADERS; AP_EXPENSE_REPORT_HEADERS_ALL