AP_HISTORY_CHECKS_ALL

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.

Details

• Schema: FUSION

• Object owner: AP

• Object type: TABLE

• Tablespace: APPS_TS_TX_DATA

Primary Key

Name	Columns
AP_HISTORY_CHECKS_ALL_PK	CHECK_ID

Columns

Name	Datatype	Length	Precision	Not-null	Comments
CHECK_ID	NUMBER		18	Yes	Payment record identifier that is used to make payment.
CHECK_NUMBER	NUMBER		18	Yes	Check number printed on physical check.
CHECK_DATE	DATE			Yes	Date when the payment is made and is mentioned on the payment document.
AMOUNT	NUMBER			Yes	Amount for which payment is made.
CURRENCY_CODE	VARCHAR2	15		Yes	Currency in which payment is made.
VOID_FLAG	VARCHAR2	1			Void payment identifier (Y or N)
PURGE_NAME	VARCHAR2	15			Name given to identify purge event.
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		18	Yes	Indicates the identifier of the business unit associated to the row.
CE_BANK_ACCT_USE_ID	NUMBER		18		Identifier of internal bank account used.
PAYMENT_ID	NUMBER		18		Oracle Payments payment identifier
OBJECT_VERSION_NUMBER	NUMBER		9	Yes	Used to implement optimistic locking. This number is incremented every time that the row is updated. The number is compared at the start and end of a transaction to detect whether another session has updated the row since it was queried.
CREATION_DATE	TIMESTAMP			Yes	Who column: indicates the date and time of the creation of the row.
CREATED_BY	VARCHAR2	64		Yes	Who column: indicates the user who created the row.
LAST_UPDATED_BY	VARCHAR2	64		Yes	Who column: indicates the user who last updated the row.
LAST_UPDATE_DATE	TIMESTAMP			Yes	Who column: indicates the date and time of the last update of the row.
LAST_UPDATE_LOGIN	VARCHAR2	32			Who column: indicates the session login associated to the user who last updated the row.

Foreign Keys

Table	Foreign Table	Foreign Key Column
AP_HISTORY_CHECKS_ALL	iby_payments_all	PAYMENT_ID
AP_HISTORY_CHECKS_ALL	ce_bank_acct_uses_all	CE_BANK_ACCT_USE_ID
ap_history_inv_payments_all	ap_history_checks_all	CHECK_ID

Indexes

Index	Uniqueness	Tablespace	Columns
AP_HISTORY_CHECKS_ALL_U1	Unique	Default	CHECK_ID