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: TableSQLAP.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: TablespaceAPPS_TS_INTERFACE
PCT Free: 10
PCT Used:
Indexes
Index Type Uniqueness Tablespace Column
AP_EXPENSE_REPORT_HEADERS_U1 NORMAL UNIQUE TablespaceAPPS_TS_INTERFACE ColumnREPORT_HEADER_ID
AP_EXPENSE_REPORT_HEADERS_N1 NORMAL NONUNIQUE TablespaceAPPS_TS_INTERFACE ColumnVOUCHNO
AP_EXPENSE_REPORT_HEADERS_N11 NORMAL NONUNIQUE TablespaceAPPS_TS_INTERFACE ColumnREPORT_SUBMITTED_DATE
AP_EXPENSE_REPORT_HEADERS_N12 NORMAL NONUNIQUE TablespaceAPPS_TS_INTERFACE ColumnRECEIPTS_RECEIVED_DATE
AP_EXPENSE_REPORT_HEADERS_N13 NORMAL NONUNIQUE TablespaceAPPS_TS_INTERFACE ColumnRECEIPTS_STATUS
AP_EXPENSE_REPORT_HEADERS_N14 NORMAL NONUNIQUE TablespaceAPPS_TS_INTERFACE ColumnHOLDING_REPORT_HEADER_ID
AP_EXPENSE_REPORT_HEADERS_N15 NORMAL NONUNIQUE TablespaceAPPS_TS_INTERFACE ColumnREQUEST_ID
AP_EXPENSE_REPORT_HEADERS_N2 NORMAL NONUNIQUE TablespaceAPPS_TS_INTERFACE ColumnEMPLOYEE_ID
AP_EXPENSE_REPORT_HEADERS_N3 NORMAL NONUNIQUE TablespaceAPPS_TS_INTERFACE ColumnREFERENCE_1
ColumnREFERENCE_2
AP_EXPENSE_REPORT_HEADERS_N4 NORMAL NONUNIQUE TablespaceAPPS_TS_INTERFACE ColumnINVOICE_NUM
AP_EXPENSE_REPORT_HEADERS_N5 NORMAL NONUNIQUE TablespaceAPPS_TS_INTERFACE ColumnPAID_ON_BEHALF_EMPLOYEE_ID
AP_EXPENSE_REPORT_HEADERS_N6 NORMAL NONUNIQUE TablespaceAPPS_TS_INTERFACE ColumnSHORTPAY_PARENT_ID
AP_EXPENSE_REPORT_HEADERS_N7 NORMAL NONUNIQUE TablespaceAPPS_TS_INTERFACE ColumnBOTHPAY_PARENT_ID
AP_EXPENSE_REPORT_HEADERS_N8 NORMAL NONUNIQUE TablespaceAPPS_TS_INTERFACE ColumnLAST_AUDITED_BY
AP_EXPENSE_REPORT_HEADERS_N9 NORMAL NONUNIQUE TablespaceAPPS_TS_INTERFACE ColumnEXPENSE_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.
IMAGE_RECEIPTS_STATUS VARCHAR2 (30)
Image Receipts Status
IMAGE_RECEIPTS_RECEIVED_DATE DATE

Image Receipts Received Date
MISSING_IMG_JUST VARCHAR2 (240)
Missing Image Justification
APPROVAL_TYPE VARCHAR2 (10)
Approval Type
OVERDUE_REQUEST_ID NUMBER

Overdue receipts process request id
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
,      IMAGE_RECEIPTS_STATUS
,      IMAGE_RECEIPTS_RECEIVED_DATE
,      MISSING_IMG_JUST
,      APPROVAL_TYPE
,      OVERDUE_REQUEST_ID
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:

SchemaAP
ViewAP_EXPENSE_REPORT_HEADERS_ALL#