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_HISTORY_CHECKS_ALL

Object Details

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

AP_HISTORY_CHECKS_ALL contains summary information on
invoice payments your Oracle Payables application
purges based on purge criteria you enter when you submit a purge.
Your Oracle Payables application inserts summary payment information
when you confirm a
purge process. Your Oracle Payables application stores the
invoice information in AP_HISTORY_INVOICES_ALL and stores
the relationships in AP_HISTORY_INVOICE_PAYMENTS_ALL.

Storage Details

Tablespace:	APPS_TS_ARCHIVE
PCT Free:	10
PCT Used:

Indexes

Index	Type	Uniqueness	Tablespace	Column
AP_HISTORY_CHECKS_U1	NORMAL	UNIQUE	APPS_TS_ARCHIVE	CHECK_ID

Columns

Name	Datatype	Length	Mandatory	Comments
CHECK_ID	NUMBER	(15)	Yes	Payment identifier
BANK_ACCOUNT_ID	NUMBER	(15)		No longer used
CHECK_NUMBER	NUMBER	(15)	Yes	Payment number
CHECK_DATE	DATE		Yes	Payment date
AMOUNT	NUMBER		Yes	Payment amount
CURRENCY_CODE	VARCHAR2	(15)	Yes	Currency code
VOID_FLAG	VARCHAR2	(1)		Void payment identifier (Y or N)
PURGE_NAME	VARCHAR2	(15)		Purge name
DOC_SEQUENCE_ID	NUMBER			Sequential numbering (voucher number) document sequence identifier for payment
DOC_SEQUENCE_VALUE	NUMBER			Voucher number (Sequential Numbering) for payment
ORG_ID	NUMBER	(15)		Organization identifier
CE_BANK_ACCT_USE_ID	NUMBER	(15)		Bank account identifier
PAYMENT_ID	NUMBER	(15)		Oracle Payments payment identifier

Query Text

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


SELECT CHECK_ID
,      BANK_ACCOUNT_ID
,      CHECK_NUMBER
,      CHECK_DATE
,      AMOUNT
,      CURRENCY_CODE
,      VOID_FLAG
,      PURGE_NAME
,      DOC_SEQUENCE_ID
,      DOC_SEQUENCE_VALUE
,      ORG_ID
,      CE_BANK_ACCT_USE_ID
,      PAYMENT_ID
FROM AP.AP_HISTORY_CHECKS_ALL;

Dependencies

[top of page]

AP.AP_HISTORY_CHECKS_ALL does not reference any database object

AP.AP_HISTORY_CHECKS_ALL is referenced by following:

APPS: AP_HISTORY_CHECKS; AP_HISTORY_CHECKS_ALL