[Home] [Help]
[Dependency Information]
[Home] [Help]
[Dependency Information]
| Object Name: | APBV_EXPENSE_REPORT_HEADERS |
|---|---|
| Object Type: | VIEW |
| Owner: | APPS |
| FND Design Data: |  SQLAP.APBV_EXPENSE_REPORT_HEADERS
|
| Subobject Name: | |
| Status: | VALID |
A Business Intelligence System view
Based on AP_EXPENSE_REPORT_HEADERS_ALL, this view contains expense report data.
| 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 | |
| _DF | CHAR | (41) | ||
| DEFAULT_CURRENCY_CODE | VARCHAR2 | (15) | Yes | |
| DEFAULT_EXCHANGE_RATE_TYPE | VARCHAR2 | (30) | ||
| DEFAULT_EXCHANGE_RATE | NUMBER | |||
| DEFAULT_EXCHANGE_DATE | DATE | |||
| VOUCHER_NUM | VARCHAR2 | (50) | ||
| USSGL_TRANSACTION_CODE | VARCHAR2 | (30) | ||
| USSGL_TRX_CODE_CONTEXT | VARCHAR2 | (30) | ||
| DOC_CATEGORY_CODE | VARCHAR2 | (30) | ||
| AWT_GROUP_ID | NUMBER | (15) | ||
| ORG_ID | NUMBER | (15) | ||
| WORKFLOW_APPROVED_FLAG | VARCHAR2 | (1) | ||
| FLEX_CONCATENATED | VARCHAR2 | (240) | ||
| OVERRIDE_APPROVER_ID | NUMBER | (9) | ||
| PAYMENT_CROSS_RATE_TYPE | VARCHAR2 | (30) | ||
| PAYMENT_CROSS_RATE_DATE | DATE | |||
| PAYMENT_CROSS_RATE | NUMBER | |||
| PAYMENT_CURRENCY_CODE | VARCHAR2 | (15) | ||
| CORE_WF_STATUS_FLAG | VARCHAR2 | (1) | ||
| PREPAY_APPLY_FLAG | VARCHAR2 | (4) | ||
| PREPAY_NUM | VARCHAR2 | (50) | ||
| PREPAY_DIST_NUM | NUMBER | (15) | ||
| PREPAY_APPLY_AMOUNT | NUMBER | |||
| PREPAY_GL_DATE | DATE | |||
| BOTHPAY_PARENT_ID | NUMBER | (15) | ||
| SHORTPAY_PARENT_ID | NUMBER | (15) | ||
| PAID_ON_BEHALF_EMPLOYEE_ID | NUMBER | (15) | ||
| OVERRIDE_APPROVER_NAME | VARCHAR2 | (240) | ||
| AMT_DUE_CCARD_COMPANY | NUMBER | |||
| AMT_DUE_EMPLOYEE | NUMBER | |||
| DEFAULT_RECEIPT_CURRENCY_CODE | VARCHAR2 | (15) | ||
| MULTIPLE_CURRENCIES_FLAG | VARCHAR2 | (1) | ||
| EXPENSE_STATUS_CODE | VARCHAR2 | (4000) | ||
| EXPENSE_LAST_STATUS_DATE | DATE | |||
| EXPENSE_CURRENT_APPROVER_ID | NUMBER | (15) | ||
| REPORT_FILING_NUMBER | VARCHAR2 | (240) | ||
| RECEIPTS_RECEIVED_DATE | DATE | |||
| AUDIT_CODE | VARCHAR2 | (30) | ||
| REPORT_SUBMITTED_DATE | DATE | |||
| LAST_AUDITED_BY | NUMBER | (15) | ||
| RETURN_REASON_CODE | VARCHAR2 | (30) | ||
| RETURN_INSTRUCTION | VARCHAR2 | (4000) | ||
| RECEIPTS_STATUS | VARCHAR2 | (30) | ||
| HOLDING_REPORT_HEADER_ID | NUMBER | (15) | ||
| REQUEST_ID | NUMBER | (15) |
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
, _DF
, DEFAULT_CURRENCY_CODE
, DEFAULT_EXCHANGE_RATE_TYPE
, DEFAULT_EXCHANGE_RATE
, DEFAULT_EXCHANGE_DATE
, VOUCHER_NUM
, USSGL_TRANSACTION_CODE
, USSGL_TRX_CODE_CONTEXT
, DOC_CATEGORY_CODE
, AWT_GROUP_ID
, ORG_ID
, WORKFLOW_APPROVED_FLAG
, FLEX_CONCATENATED
, 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
FROM APPS.APBV_EXPENSE_REPORT_HEADERS;
APPS
AP_EXPENSE_REPORT_HEADERS_ALL
AP_WEB_OA_ACTIVE_PKG
- show dependent code
APPS.APBV_EXPENSE_REPORT_HEADERS is not referenced by any database object
|
|
|
|