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

AP_INVOICE_PAYMENTS_ALL contains records
of invoice payments that you made to suppliers. There
is one row for each payment you make for each
invoice. There is one payment and one invoice for
each payment in this table. Your Oracle Payables
application updates this table when you confirm an
automatic payment batch, enter a manual payment, or
process a Quick payment. When you void a payment, your
Oracle Payables application inserts an additional payment
line that is the negative of the original payment line.
.
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; values for CASH_POSTED_FLAG
may be 'Y' for accounted payments or 'N' for unaccounted
payments under cash basis accounting.
.
For manual payments and Quick payments, this table
corresponds to the Select Invoices window in the Payment workbench.

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 SET_OF_BOOKS_ID ASSETS_ADDITION_FLAG ACCOUNTING_DATE
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)		Accounting Event Identifier
ACCOUNTING_DATE	DATE		Yes	Accounting date
ACCRUAL_POSTED_FLAG	VARCHAR2	(1)		Flag that indicates if the payment has been accounted in accrual set of books (Y or N)
AMOUNT	NUMBER		Yes	Payment amount
CASH_POSTED_FLAG	VARCHAR2	(1)		Flag that indicates if the payment has been accounted in cash set of books (Y or N)
CHECK_ID	NUMBER	(15)	Yes	Payment identifier
INVOICE_ID	NUMBER	(15)	Yes	Invoice identifier
INVOICE_PAYMENT_ID	NUMBER	(15)	Yes	Invoice payment identifier
LAST_UPDATED_BY	NUMBER	(15)	Yes	Standard who column - user who last updated 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.
PAYMENT_NUM	NUMBER	(15)	Yes	Payment number
PERIOD_NAME	VARCHAR2	(15)	Yes	Period name
POSTED_FLAG	VARCHAR2	(1)	Yes	Flag that indicates if the payment has been accounted (Y or N)
SET_OF_BOOKS_ID	NUMBER	(15)	Yes	Set of books identifier
ACCTS_PAY_CODE_COMBINATION_ID	NUMBER	(15)		Accounting Flexfield identifier for accounts payable liability account
ASSET_CODE_COMBINATION_ID	NUMBER	(15)		Accounting Flexfield identifier for cash account
CREATED_BY	NUMBER	(15)		Standard who column - user who created this row (foreign key to FND_USER.USER_ID).
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 FND_LOGINS.LOGIN_ID).
BANK_ACCOUNT_NUM	VARCHAR2	(30)		Bank account number
BANK_ACCOUNT_TYPE	VARCHAR2	(25)		Bank account type code
BANK_NUM	VARCHAR2	(25)		Bank number
DISCOUNT_LOST	NUMBER			Amount of discount lost
DISCOUNT_TAKEN	NUMBER			Amount of discount taken
EXCHANGE_DATE	DATE			Date for which exchange rate is obtained from daily rates table
EXCHANGE_RATE	NUMBER			Exchange rate for a foreign currency payment
EXCHANGE_RATE_TYPE	VARCHAR2	(30)		Exchange rate type for a foreign currency payment
GAIN_CODE_COMBINATION_ID	NUMBER	(15)		Accounting Flexfield identifier for account to which realized exchange rate gains are posted
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
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)		Creation method of a payment, used by Positive Pay feature (Single or Batch)
OTHER_INVOICE_ID	NUMBER	(15)		No longer used
ORG_ID	NUMBER	(15)		Organization identifier
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)		External Bank Account identifier
MRC_EXCHANGE_DATE	VARCHAR2	(2000)		Multiple Reporting Currencies only: Concatenated string of reporting set of books id and currency conversion date pairs
MRC_EXCHANGE_RATE	VARCHAR2	(2000)		Multiple Reporting Currencies only: Concatenated string of reporting set of books id and currency conversion rate pairs
MRC_EXCHANGE_RATE_TYPE	VARCHAR2	(2000)		Multiple Reporting Currencies only: Concatenated string of reporting set of books id and currency conversion rate type pairs
MRC_GAIN_CODE_COMBINATION_ID	VARCHAR2	(2000)		Multiple Reporting Currencies only: Concatenated string of reporting set of books ID and accounting flexfield identifier for account to which realized gains are posted pairs
MRC_INVOICE_BASE_AMOUNT	VARCHAR2	(2000)		Multiple Reporting Currencies only: Concatenated string of reporting set of books id and invoice payment amount in primary currency pairs, only applicable for foreign currency invoices
MRC_LOSS_CODE_COMBINATION_ID	VARCHAR2	(2000)		Multiple Reporting Currencies only: Concatenated string of reporting set of books id and accounting flexfield indentifier for account to which realized losses are posted pairs
MRC_PAYMENT_BASE_AMOUNT	VARCHAR2	(2000)		Multiple Reporting Currencies only: Concatenated string of reporting set of books id, and payment amount in primary currency pairs, only applicable for foreign currency invoices
REVERSAL_FLAG	VARCHAR2	(1)		Flag that 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
INVOICING_PARTY_SITE_ID	NUMBER	(15)		Original party id site for third party payment
INVOICING_VENDOR_SITE_ID	NUMBER	(15)		Original vendor site id for third party payment
REMIT_TO_SUPPLIER_NAME	VARCHAR2	(240)		Name of the third party payee
REMIT_TO_SUPPLIER_ID	NUMBER	(15)		ID of the third party payee
REMIT_TO_SUPPLIER_SITE	VARCHAR2	(240)		Site code of the third party payee
REMIT_TO_SUPPLIER_SITE_ID	NUMBER	(15)		Site id of the third party payee

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:

AP: AP_INVOICE_PAYMENTS_ALL#