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: TableSQLAP.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: TablespaceAPPS_TS_TX_DATA
PCT Free: 10
PCT Used:
Indexes
Index Type Uniqueness Tablespace Column
AP_INVOICE_PAYMENTS_U1 NORMAL UNIQUE TablespaceAPPS_TS_TX_IDX ColumnINVOICE_PAYMENT_ID
AP_INVOICE_PAYMENTS_N1 NORMAL NONUNIQUE TablespaceAPPS_TS_TX_IDX ColumnINVOICE_ID
ColumnPAYMENT_NUM
AP_INVOICE_PAYMENTS_N2 NORMAL NONUNIQUE TablespaceAPPS_TS_TX_IDX ColumnCHECK_ID
AP_INVOICE_PAYMENTS_N3 NORMAL NONUNIQUE TablespaceAPPS_TS_TX_IDX ColumnPOSTED_FLAG
ColumnORG_ID
AP_INVOICE_PAYMENTS_N4 NORMAL NONUNIQUE TablespaceAPPS_TS_TX_IDX ColumnACCOUNTING_DATE
AP_INVOICE_PAYMENTS_N5 NORMAL NONUNIQUE TablespaceAPPS_TS_TX_IDX ColumnACCRUAL_POSTED_FLAG
AP_INVOICE_PAYMENTS_N6 NORMAL NONUNIQUE TablespaceAPPS_TS_TX_IDX ColumnCASH_POSTED_FLAG
AP_INVOICE_PAYMENTS_N7 NORMAL NONUNIQUE TablespaceAPPS_TS_TX_IDX ColumnASSETS_ADDITION_FLAG
AP_INVOICE_PAYMENTS_N8 NORMAL NONUNIQUE TablespaceAPPS_TS_TX_IDX ColumnACCOUNTING_EVENT_ID
AP_INVOICE_PAYMENTS_N9 NORMAL NONUNIQUE TablespaceAPPS_TS_TX_IDX ColumnREVERSAL_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:

SchemaAPPS
SynonymAP_INVOICE_PAYMENTS
SynonymAP_INVOICE_PAYMENTS_ALL
TriggerAP_SSE_NOTIFY_EMPLOYEE