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_PAYMENT_HISTORY_ALL

Object Details

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

AP_PAYMENT_HISTORY_ALL stores the
clearing/unclearing history for payments. It
also stores the maturity history for future dated
payments. The table contains a row for each
future dated payment, once the future dated
payment matures, i.e. becomes negotiable. Any
time a payment is cleared or uncleared, a row
is inserted into this table for the payment. The
values for TRANSACTION_TYPE can be PAYMENT
MATURITY, PAYMENT CLEARING, or PAYMENT
UNCLEARING. Each row in this table also has the
accounting status for the maturity, clearing or
unclearing event.

Storage Details

Tablespace:	APPS_TS_TX_DATA
PCT Free:	10
PCT Used:

Indexes

Index	Type	Uniqueness	Tablespace	Column
AP_PAYMENT_HISTORY_U1	NORMAL	UNIQUE	APPS_TS_TX_IDX	PAYMENT_HISTORY_ID
AP_PAYMENT_HISTORY_U2	NORMAL	UNIQUE	APPS_TS_TX_IDX	REV_PMT_HIST_ID
AP_PAYMENT_HISTORY_N1	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	CHECK_ID
AP_PAYMENT_HISTORY_N2	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	ACCOUNTING_EVENT_ID
AP_PAYMENT_HISTORY_N3	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	POSTED_FLAG
AP_PAYMENT_HISTORY_N4	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	ACCOUNTING_DATE

Columns

Name	Datatype	Length	Mandatory	Comments
PAYMENT_HISTORY_ID	NUMBER	(15)	Yes	Payment history identifier
CHECK_ID	NUMBER	(15)	Yes	Payment identifier
ACCOUNTING_DATE	DATE		Yes	Accounting date for accounting entries for this transaction
TRANSACTION_TYPE	VARCHAR2	(30)	Yes	Transaction type - value can be PAYMENT MATURITY, PAYMENT CLEARING, or PAYMENT UNCLEARING
POSTED_FLAG	VARCHAR2	(1)	Yes	Flag to indicate whether the maturity, clearing or unclearing transaction has been accounted (Y or N)
MATCHED_FLAG	VARCHAR2	(1)		Flag to indicate whether the payment is matched to a bank statement line (Y or N). If yes, then the payment will be reconciled, else it will be cleared
ACCOUNTING_EVENT_ID	NUMBER	(15)		Accounting event identifier
ORG_ID	NUMBER	(15)		Organization identifier
CREATION_DATE	DATE		Yes	Standard who column - date when this row was created.
CREATED_BY	NUMBER	(15)	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	(15)	Yes	Standard who column - user who last updated this row (foreign key to FND_USER.USER_ID).
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).
PROGRAM_UPDATE_DATE	DATE			Concurrent Program who column - date when a program last updated this row).
PROGRAM_APPLICATION_ID	NUMBER	(15)		Concurrent Program who column - application id of the program that last updated this row (foreign key to FND_APPLICATION.APPLICATION_ID).
PROGRAM_ID	NUMBER	(15)		Concurrent Program who column - program id of the program that last updated this row (foreign key to FND_CONCURRENT_PROGRAM.CONCURRENT_PROGRAM_ID).
REQUEST_ID	NUMBER	(15)		Concurrent Program who column - concurrent request id of the program that last updated this row (foreign key to FND_CONCURRENT_REQUESTS.REQUEST_ID).
REV_PMT_HIST_ID	NUMBER	(15)		Payment history identifier of the reversed payment history transaction
TRX_BANK_AMOUNT	NUMBER			Amount to clear including charges and errors in the bank account currency
ERRORS_BANK_AMOUNT	NUMBER			Reconciliation error amount in the bank account currency
CHARGES_BANK_AMOUNT	NUMBER			Bank charges amount in the bank account currency
TRX_PMT_AMOUNT	NUMBER		Yes	Amount to clear including charges and errors in the payment currency
ERRORS_PMT_AMOUNT	NUMBER			Reconciliation error amount in the payment currency
CHARGES_PMT_AMOUNT	NUMBER			Bank charges amount in the payment currency
TRX_BASE_AMOUNT	NUMBER			Amount to clear including charges and errors in the base currency
ERRORS_BASE_AMOUNT	NUMBER			Reconciliation error amount in the base currency
CHARGES_BASE_AMOUNT	NUMBER			Bank charges amount in the base currency
BANK_CURRENCY_CODE	VARCHAR2	(15)		Bank account currency code
BANK_TO_BASE_XRATE_TYPE	VARCHAR2	(30)		Exchange rate type for bank account currency to base currency exchange rate
BANK_TO_BASE_XRATE_DATE	DATE			Date currency conversion rate is effective for bank account currency to base currency
BANK_TO_BASE_XRATE	NUMBER			Exchange rate from bank account currency to base currency
PMT_CURRENCY_CODE	VARCHAR2	(15)	Yes	Payment currency code
PMT_TO_BASE_XRATE_TYPE	VARCHAR2	(30)		Exchange rate type for payment currency to base currency exchange rate
PMT_TO_BASE_XRATE_DATE	DATE			Date currency conversion rate is effective for payment currency to base currency
PMT_TO_BASE_XRATE	NUMBER			Exchange rate from payment currency to base currency
MRC_PMT_TO_BASE_XRATE_TYPE	VARCHAR2	(2000)		Multiple Reporting Currencies only: Concatenated string of reporting set of books id and currency conversion rate type for payment currency to base currency conversion rate pairs
MRC_PMT_TO_BASE_XRATE_DATE	VARCHAR2	(2000)		Multiple Reporting Currencies only: Concatenated string of reporting set of books id and date currency conversion rate is effective for payment currency to base currency pairs
MRC_PMT_TO_BASE_XRATE	VARCHAR2	(2000)		Multiple Reporting Currencies only: Concatenated string of reporting set of books id and currency conversion rate from payment currency to base currency pairs
MRC_BANK_TO_BASE_XRATE_TYPE	VARCHAR2	(2000)		Multiple Reporting Currencies only: Concatenated string of reporting set of books id and currency conversion rate type for bank account currency to base currency conversion rate pairs
MRC_BANK_TO_BASE_XRATE_DATE	VARCHAR2	(2000)		Multiple reporting currencies only: Concatenated string of reporting set of books id and currency conversion rate date from bank account currency to base currency conversion date pairs
MRC_BANK_TO_BASE_XRATE	VARCHAR2	(2000)		Multiple Reporting Currencies only: Concatenated string of reporting set of books id and currency conversion rate from bank account currency to base currency pairs
MRC_TRX_BASE_AMOUNT	VARCHAR2	(2000)		Multiple Reporting Currencies only: Concatenated string of reporting set of books id and amount to clear including charges and errors pairs
MRC_ERRORS_BASE_AMOUNT	VARCHAR2	(2000)		Multiple Reporting Currencies only: Concatenated string of reporting set of books id and reconciliation error amount in the base currency pairs
MRC_CHARGES_BASE_AMOUNT	VARCHAR2	(2000)		Multiple Reporting Currencies only: Concatenated string of reporting set of books id and bank charges in the base currency pairs
RELATED_EVENT_ID	NUMBER	(15)		Originating transaction event id
HISTORICAL_FLAG	VARCHAR2	(1)		Flag to indicate whether the payment transaction is a result of upgraded data
INVOICE_ADJUSTMENT_EVENT_ID	NUMBER	(15)		Related adjusted invoice that resulted in a cascade event
GAIN_LOSS_INDICATOR	VARCHAR2	(1)		Indicates whether the payment related transaction resulted in gain or loss (G or L)

Query Text

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


SELECT PAYMENT_HISTORY_ID
,      CHECK_ID
,      ACCOUNTING_DATE
,      TRANSACTION_TYPE
,      POSTED_FLAG
,      MATCHED_FLAG
,      ACCOUNTING_EVENT_ID
,      ORG_ID
,      CREATION_DATE
,      CREATED_BY
,      LAST_UPDATE_DATE
,      LAST_UPDATED_BY
,      LAST_UPDATE_LOGIN
,      PROGRAM_UPDATE_DATE
,      PROGRAM_APPLICATION_ID
,      PROGRAM_ID
,      REQUEST_ID
,      REV_PMT_HIST_ID
,      TRX_BANK_AMOUNT
,      ERRORS_BANK_AMOUNT
,      CHARGES_BANK_AMOUNT
,      TRX_PMT_AMOUNT
,      ERRORS_PMT_AMOUNT
,      CHARGES_PMT_AMOUNT
,      TRX_BASE_AMOUNT
,      ERRORS_BASE_AMOUNT
,      CHARGES_BASE_AMOUNT
,      BANK_CURRENCY_CODE
,      BANK_TO_BASE_XRATE_TYPE
,      BANK_TO_BASE_XRATE_DATE
,      BANK_TO_BASE_XRATE
,      PMT_CURRENCY_CODE
,      PMT_TO_BASE_XRATE_TYPE
,      PMT_TO_BASE_XRATE_DATE
,      PMT_TO_BASE_XRATE
,      MRC_PMT_TO_BASE_XRATE_TYPE
,      MRC_PMT_TO_BASE_XRATE_DATE
,      MRC_PMT_TO_BASE_XRATE
,      MRC_BANK_TO_BASE_XRATE_TYPE
,      MRC_BANK_TO_BASE_XRATE_DATE
,      MRC_BANK_TO_BASE_XRATE
,      MRC_TRX_BASE_AMOUNT
,      MRC_ERRORS_BASE_AMOUNT
,      MRC_CHARGES_BASE_AMOUNT
,      RELATED_EVENT_ID
,      HISTORICAL_FLAG
,      INVOICE_ADJUSTMENT_EVENT_ID
,      GAIN_LOSS_INDICATOR
FROM AP.AP_PAYMENT_HISTORY_ALL;

Dependencies

[top of page]

AP.AP_PAYMENT_HISTORY_ALL does not reference any database object

AP.AP_PAYMENT_HISTORY_ALL is referenced by following:

APPS: AP_PAYMENT_HISTORY; AP_PAYMENT_HISTORY_ALL