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

TABLE: AP.AP_HISTORY_INVOICES_ALL

Object Details
Object Name: AP_HISTORY_INVOICES_ALL
Object Type: TABLE
Owner: AP
FND Design Data: TableSQLAP.AP_HISTORY_INVOICES_ALL
Subobject Name:
Status: VALID


AP_HISTORY_INVOICES_ALL stores summary information of the
invoices your Oracle Payables application purges based
on purge criteria you enter when you submit a purge.
Your Oracle Payables application inserts summary
invoice information in this table when you confirm a
purge process. Your Oracle Payables application stores
related payment information in AP_HISTORY_CHECKS and
stores the relationships in
AP_HISTORY_INV_PAYMENTS.


Storage Details
Tablespace: TablespaceAPPS_TS_ARCHIVE
PCT Free: 10
PCT Used:
Indexes
Index Type Uniqueness Tablespace Column
AP_HISTORY_INVOICES_U2 NORMAL UNIQUE TablespaceAPPS_TS_ARCHIVE ColumnVENDOR_ID
ColumnINVOICE_NUM
ColumnORG_ID
Columns
Name Datatype Length Mandatory Comments
INVOICE_ID NUMBER (15) Yes Invoice identifier
VENDOR_ID NUMBER (15) Yes Supplier identifier
VENDOR_SITE_CODE VARCHAR2 (15)
Supplier site code
INVOICE_NUM VARCHAR2 (50) Yes Invoice number
INVOICE_DATE DATE

Invoice date
INVOICE_AMOUNT NUMBER
Yes Invoice amount
BATCH_NAME VARCHAR2 (50)
Invoice batch name
PURGE_NAME VARCHAR2 (15)
Purge name
DOC_SEQUENCE_ID NUMBER

Sequential Numbering (voucher number) document sequence identifier
DOC_SEQUENCE_VALUE NUMBER

Voucher number (Sequential Numbering) for invoice
ORG_ID NUMBER (15)
Organization identifier
Query Text

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


SELECT INVOICE_ID
,      VENDOR_ID
,      VENDOR_SITE_CODE
,      INVOICE_NUM
,      INVOICE_DATE
,      INVOICE_AMOUNT
,      BATCH_NAME
,      PURGE_NAME
,      DOC_SEQUENCE_ID
,      DOC_SEQUENCE_VALUE
,      ORG_ID
FROM AP.AP_HISTORY_INVOICES_ALL;

Dependencies

[top of page]

AP.AP_HISTORY_INVOICES_ALL does not reference any database object

AP.AP_HISTORY_INVOICES_ALL is referenced by following:

SchemaAP
ViewAP_HISTORY_INVOICES_ALL#