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_INVOICE_PAYMENTS_ALL

Object Details

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

This table holds all invoice payments made to the suppliers. This table corresponds to the �Payments� tab of the Invoice Workbench.
In this table, there is one row maintained for the each invoice amount paid in the payment. For manual payments and Quick payments, this table corresponds to the Select Invoices window in the Payment workbench. Oracle Payables application updates this table while processing payment batch (PPR), enter a manual payment, or process a Quick payment.
When payment is voided, Oracle Payables application inserts an additional payment line that is the negative of the original payment line.
The values for POSTED_FLAG may be 'Y' for accounted payments or 'N' for unaccounted payments. Values for ACCRUAL_POSTED_FLAG may be 'Y' for accounted payments or 'N' for unaccounted payments under accrual basis accounting. The values for CASH_POSTED_FLAG may be 'Y' for accounted payments or 'N' for unaccounted payments under cash basis accounting.

Storage Details

Tablespace:	APPS_TS_TX_DATA
PCT Free:	10
PCT Used:

Indexes

Index	Type	Uniqueness	Tablespace	Column
AP_INVOICE_PAYMENTS_U1	NORMAL	UNIQUE	APPS_TS_TX_IDX	INVOICE_PAYMENT_ID
AP_INVOICE_PAYMENTS_N1	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	INVOICE_ID PAYMENT_NUM
AP_INVOICE_PAYMENTS_N2	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	CHECK_ID
AP_INVOICE_PAYMENTS_N3	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	POSTED_FLAG ORG_ID
AP_INVOICE_PAYMENTS_N4	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	ACCOUNTING_DATE
AP_INVOICE_PAYMENTS_N5	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	ACCRUAL_POSTED_FLAG
AP_INVOICE_PAYMENTS_N6	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	CASH_POSTED_FLAG
AP_INVOICE_PAYMENTS_N7	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	ASSETS_ADDITION_FLAG
AP_INVOICE_PAYMENTS_N8	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	ACCOUNTING_EVENT_ID
AP_INVOICE_PAYMENTS_N9	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	REVERSAL_INV_PMT_ID

Columns

Name	Datatype	Length	Mandatory	Comments
ACCOUNTING_EVENT_ID	NUMBER	(15)		This is the Accounting Event Identifier for the Payment. This is maintained in the Sub Ledger Accounting application.
ACCOUNTING_DATE	DATE		Yes	This is the Accounting Date of Payment.
ACCRUAL_POSTED_FLAG	VARCHAR2	(1)		Flag that indicates if the payment has been accounted in accrual ledger (Y or N)
AMOUNT	NUMBER		Yes	This is the payment amount of the invoice.
CASH_POSTED_FLAG	VARCHAR2	(1)		Flag that indicates if the payment has been accounted in cash ledger (Y or N)
CHECK_ID	NUMBER	(15)	Yes	The payment identifier is a unique sequential number to identify a payment. Foreign key to the AP_CHECKS_ALL.
INVOICE_ID	NUMBER	(15)	Yes	The invoice identifier is a unique sequential number to identify a invoice. Foreign key to the AP_INVOICES_ALL.
INVOICE_PAYMENT_ID	NUMBER	(15)	Yes	This is the unique identifier to identify the payment on the invoice. Generated using database sequence.
LAST_UPDATED_BY	NUMBER	(15)	Yes	Standard who column - unique internal identifier user who last updated this row. Foreign key to the USER_ID column of the FND_USER table.
LAST_UPDATE_DATE	DATE		Yes	Standard Who column - date when a user last updated this row.
PAYMENT_NUM	NUMBER	(15)	Yes	This is the payment number for the payment.
PERIOD_NAME	VARCHAR2	(15)	Yes	This is the Period name in which the invoice payment is processed.
POSTED_FLAG	VARCHAR2	(1)	Yes	Flag that indicates if the payment has been accounted (Y or N)
SET_OF_BOOKS_ID	NUMBER	(15)	Yes	Ledger unique identifier
ACCTS_PAY_CODE_COMBINATION_ID	NUMBER	(15)		Accounting Flexfield identifier for accounts payable liability account
ASSET_CODE_COMBINATION_ID	NUMBER	(15)		This is the identifier for cash account Accounting Flexfield.
CREATED_BY	NUMBER	(15)		Standard who column - unique internal identifier of user who created this row. Foreign key to the USER_ID column of the FND_USER table.
CREATION_DATE	DATE			Standard who column - date when this row was created.
LAST_UPDATE_LOGIN	NUMBER	(15)		Standard who column - operating system login of user who last updated this row. Foreign key to the LOGIN_ID column of the FND_LOGINS table.
BANK_ACCOUNT_NUM	VARCHAR2	(30)		This is the Bank account number used for payment.
BANK_ACCOUNT_TYPE	VARCHAR2	(25)		This is the Bank Account Type code. This is maintained in cash management.
BANK_NUM	VARCHAR2	(25)		This is the bank number of the bank account used for payment.
DISCOUNT_LOST	NUMBER			This is the amount of discount lost on payment of invoice.
DISCOUNT_TAKEN	NUMBER			This is the amount of discount taken on payments of the invoice.
EXCHANGE_DATE	DATE			This is the date on which the exchange rate is effective. Applicable for foreign currency payments.
EXCHANGE_RATE	NUMBER			Exchange rate for a foreign currency payment
EXCHANGE_RATE_TYPE	VARCHAR2	(30)		This is the exchange rate type like Spot, Corporate etc used for for foreign currency payments.
GAIN_CODE_COMBINATION_ID	NUMBER	(15)		Accounting Flexfield identifier for account to which realized exchange rate gains are posted. Foreign key to the GL_CODE_COMBINATIONS table.
INVOICE_BASE_AMOUNT	NUMBER			Payment amount in functional currency at invoice's exchange rate, only used for foreign currency invoice payments
LOSS_CODE_COMBINATION_ID	NUMBER	(15)		Accounting Flexfield identifier for account to which realized exchange rate losses are posted. Foreign key to the GL_CODE_COMBINATIONS table.
PAYMENT_BASE_AMOUNT	NUMBER			Payment amount at payment's exchange rate, only used for foreign currency invoice payments
ATTRIBUTE1	VARCHAR2	(150)		Descriptive flexfield segment
ATTRIBUTE10	VARCHAR2	(150)		Descriptive flexfield segment
ATTRIBUTE11	VARCHAR2	(150)		Descriptive flexfield segment
ATTRIBUTE12	VARCHAR2	(150)		Descriptive flexfield segment
ATTRIBUTE13	VARCHAR2	(150)		Descriptive flexfield segment
ATTRIBUTE14	VARCHAR2	(150)		Descriptive flexfield segment
ATTRIBUTE15	VARCHAR2	(150)		Descriptive flexfield segment
ATTRIBUTE2	VARCHAR2	(150)		Descriptive flexfield segment
ATTRIBUTE3	VARCHAR2	(150)		Descriptive flexfield segment
ATTRIBUTE4	VARCHAR2	(150)		Descriptive flexfield segment
ATTRIBUTE5	VARCHAR2	(150)		Descriptive flexfield segment
ATTRIBUTE6	VARCHAR2	(150)		Descriptive flexfield segment
ATTRIBUTE7	VARCHAR2	(150)		Descriptive flexfield segment
ATTRIBUTE8	VARCHAR2	(150)		Descriptive flexfield segment
ATTRIBUTE9	VARCHAR2	(150)		Descriptive flexfield segment
ATTRIBUTE_CATEGORY	VARCHAR2	(150)		Descriptive flexfield structure definition column.
CASH_JE_BATCH_ID	NUMBER	(15)		No longer used
FUTURE_PAY_CODE_COMBINATION_ID	NUMBER	(15)		No longer used
FUTURE_PAY_POSTED_FLAG	VARCHAR2	(1)		No longer used
JE_BATCH_ID	NUMBER	(15)		No longer used
ELECTRONIC_TRANSFER_ID	NUMBER	(15)		No longer used
ASSETS_ADDITION_FLAG	VARCHAR2	(1)		Flag that indicates if discounts on invoice payment have been transferred into Oracle Assets (U, Y or N)
INVOICE_PAYMENT_TYPE	VARCHAR2	(25)		This is the Creation method of a payment, used by Positive Pay feature. Possible values are Single or Batch.
OTHER_INVOICE_ID	NUMBER	(15)		No longer used
ORG_ID	NUMBER	(15)		This is the unique internal identifier of the operating unit in which the payment is created.
GLOBAL_ATTRIBUTE_CATEGORY	VARCHAR2	(150)		Reserved for country-specific functionality
GLOBAL_ATTRIBUTE1	VARCHAR2	(150)		Reserved for country-specific functionality
GLOBAL_ATTRIBUTE2	VARCHAR2	(150)		Reserved for country-specific functionality
GLOBAL_ATTRIBUTE3	VARCHAR2	(150)		Reserved for country-specific functionality
GLOBAL_ATTRIBUTE4	VARCHAR2	(150)		Reserved for country-specific functionality
GLOBAL_ATTRIBUTE5	VARCHAR2	(150)		Reserved for country-specific functionality
GLOBAL_ATTRIBUTE6	VARCHAR2	(150)		Reserved for country-specific functionality
GLOBAL_ATTRIBUTE7	VARCHAR2	(150)		Reserved for country-specific functionality
GLOBAL_ATTRIBUTE8	VARCHAR2	(150)		Reserved for country-specific functionality
GLOBAL_ATTRIBUTE9	VARCHAR2	(150)		Reserved for country-specific functionality
GLOBAL_ATTRIBUTE10	VARCHAR2	(150)		Reserved for country-specific functionality
GLOBAL_ATTRIBUTE11	VARCHAR2	(150)		Reserved for country-specific functionality
GLOBAL_ATTRIBUTE12	VARCHAR2	(150)		Reserved for country-specific functionality
GLOBAL_ATTRIBUTE13	VARCHAR2	(150)		Reserved for country-specific functionality
GLOBAL_ATTRIBUTE14	VARCHAR2	(150)		Reserved for country-specific functionality
GLOBAL_ATTRIBUTE15	VARCHAR2	(150)		Reserved for country-specific functionality
GLOBAL_ATTRIBUTE16	VARCHAR2	(150)		Reserved for country-specific functionality
GLOBAL_ATTRIBUTE17	VARCHAR2	(150)		Reserved for country-specific functionality
GLOBAL_ATTRIBUTE18	VARCHAR2	(150)		Reserved for country-specific functionality
GLOBAL_ATTRIBUTE19	VARCHAR2	(150)		Reserved for country-specific functionality
GLOBAL_ATTRIBUTE20	VARCHAR2	(150)		Reserved for country-specific functionality
EXTERNAL_BANK_ACCOUNT_ID	NUMBER	(15)		This is the External Bank Account identifier. Foreign key to the IBY_EXT_BANK_ACCOUNTS table.
MRC_EXCHANGE_DATE	VARCHAR2	(2000)		No Longer Used.
MRC_EXCHANGE_RATE	VARCHAR2	(2000)		No Longer Used.
MRC_EXCHANGE_RATE_TYPE	VARCHAR2	(2000)		No Longer Used.
MRC_GAIN_CODE_COMBINATION_ID	VARCHAR2	(2000)		No Longer Used.
MRC_INVOICE_BASE_AMOUNT	VARCHAR2	(2000)		No Longer Used.
MRC_LOSS_CODE_COMBINATION_ID	VARCHAR2	(2000)		No Longer Used.
MRC_PAYMENT_BASE_AMOUNT	VARCHAR2	(2000)		No Longer Used.
REVERSAL_FLAG	VARCHAR2	(1)		This Flag indicates whether current invoice payment is a reversal of another invoice payment.
REVERSAL_INV_PMT_ID	NUMBER	(15)		Identifier for invoice payment reversed through current invoice payment
IBAN_NUMBER	VARCHAR2	(40)		International bank account number. Used internationally to uniquely identify the account of a customer at a financial institution. During bank entry, the system validates the value to ensure that it is a valid IBAN.
INVOICING_PARTY_ID	NUMBER	(15)		Original party id for third party payment. This is the invoicing supplier party.
INVOICING_PARTY_SITE_ID	NUMBER	(15)		Original party site id for third party payment. This is the invoicing supplier party site.
INVOICING_VENDOR_SITE_ID	NUMBER	(15)		Original vendor site id for third party payment.
REMIT_TO_SUPPLIER_NAME	VARCHAR2	(240)		Name of the supplier to whom invoice amount will be remitted.
REMIT_TO_SUPPLIER_ID	NUMBER	(15)		Unique supplier identifier to whom invoice amount will be remitted.
REMIT_TO_SUPPLIER_SITE	VARCHAR2	(240)		Name of the supplier site to whom invoice amount will be remitted.
REMIT_TO_SUPPLIER_SITE_ID	NUMBER	(15)		Unique supplier site identifier to whom invoice amount will be remitted.

Query Text

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


SELECT ACCOUNTING_EVENT_ID
,      ACCOUNTING_DATE
,      ACCRUAL_POSTED_FLAG
,      AMOUNT
,      CASH_POSTED_FLAG
,      CHECK_ID
,      INVOICE_ID
,      INVOICE_PAYMENT_ID
,      LAST_UPDATED_BY
,      LAST_UPDATE_DATE
,      PAYMENT_NUM
,      PERIOD_NAME
,      POSTED_FLAG
,      SET_OF_BOOKS_ID
,      ACCTS_PAY_CODE_COMBINATION_ID
,      ASSET_CODE_COMBINATION_ID
,      CREATED_BY
,      CREATION_DATE
,      LAST_UPDATE_LOGIN
,      BANK_ACCOUNT_NUM
,      BANK_ACCOUNT_TYPE
,      BANK_NUM
,      DISCOUNT_LOST
,      DISCOUNT_TAKEN
,      EXCHANGE_DATE
,      EXCHANGE_RATE
,      EXCHANGE_RATE_TYPE
,      GAIN_CODE_COMBINATION_ID
,      INVOICE_BASE_AMOUNT
,      LOSS_CODE_COMBINATION_ID
,      PAYMENT_BASE_AMOUNT
,      ATTRIBUTE1
,      ATTRIBUTE10
,      ATTRIBUTE11
,      ATTRIBUTE12
,      ATTRIBUTE13
,      ATTRIBUTE14
,      ATTRIBUTE15
,      ATTRIBUTE2
,      ATTRIBUTE3
,      ATTRIBUTE4
,      ATTRIBUTE5
,      ATTRIBUTE6
,      ATTRIBUTE7
,      ATTRIBUTE8
,      ATTRIBUTE9
,      ATTRIBUTE_CATEGORY
,      CASH_JE_BATCH_ID
,      FUTURE_PAY_CODE_COMBINATION_ID
,      FUTURE_PAY_POSTED_FLAG
,      JE_BATCH_ID
,      ELECTRONIC_TRANSFER_ID
,      ASSETS_ADDITION_FLAG
,      INVOICE_PAYMENT_TYPE
,      OTHER_INVOICE_ID
,      ORG_ID
,      GLOBAL_ATTRIBUTE_CATEGORY
,      GLOBAL_ATTRIBUTE1
,      GLOBAL_ATTRIBUTE2
,      GLOBAL_ATTRIBUTE3
,      GLOBAL_ATTRIBUTE4
,      GLOBAL_ATTRIBUTE5
,      GLOBAL_ATTRIBUTE6
,      GLOBAL_ATTRIBUTE7
,      GLOBAL_ATTRIBUTE8
,      GLOBAL_ATTRIBUTE9
,      GLOBAL_ATTRIBUTE10
,      GLOBAL_ATTRIBUTE11
,      GLOBAL_ATTRIBUTE12
,      GLOBAL_ATTRIBUTE13
,      GLOBAL_ATTRIBUTE14
,      GLOBAL_ATTRIBUTE15
,      GLOBAL_ATTRIBUTE16
,      GLOBAL_ATTRIBUTE17
,      GLOBAL_ATTRIBUTE18
,      GLOBAL_ATTRIBUTE19
,      GLOBAL_ATTRIBUTE20
,      EXTERNAL_BANK_ACCOUNT_ID
,      MRC_EXCHANGE_DATE
,      MRC_EXCHANGE_RATE
,      MRC_EXCHANGE_RATE_TYPE
,      MRC_GAIN_CODE_COMBINATION_ID
,      MRC_INVOICE_BASE_AMOUNT
,      MRC_LOSS_CODE_COMBINATION_ID
,      MRC_PAYMENT_BASE_AMOUNT
,      REVERSAL_FLAG
,      REVERSAL_INV_PMT_ID
,      IBAN_NUMBER
,      INVOICING_PARTY_ID
,      INVOICING_PARTY_SITE_ID
,      INVOICING_VENDOR_SITE_ID
,      REMIT_TO_SUPPLIER_NAME
,      REMIT_TO_SUPPLIER_ID
,      REMIT_TO_SUPPLIER_SITE
,      REMIT_TO_SUPPLIER_SITE_ID
FROM AP.AP_INVOICE_PAYMENTS_ALL;

Dependencies

[top of page]

AP.AP_INVOICE_PAYMENTS_ALL does not reference any database object

AP.AP_INVOICE_PAYMENTS_ALL is referenced by following:

APPS: AP_INVOICE_PAYMENTS; AP_INVOICE_PAYMENTS_ALL; AP_SSE_NOTIFY_EMPLOYEE