AP_INVOICE_PAYMENTS_ALL
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.
Details
-
Schema: FUSION
-
Object owner: AP
-
Object type: TABLE
-
Tablespace: APPS_TS_TX_DATA
Primary Key
| Name | Columns |
|---|---|
|
AP_INVOICE_PAYMENTS_PK |
INVOICE_PAYMENT_ID |
Columns
| Name | Datatype | Length | Precision | Not-null | Comments |
|---|---|---|---|---|---|
| ACCOUNTING_DATE | DATE | Yes | Date when the payment is to be accounted. | ||
| AMOUNT | NUMBER | Yes | Payment amount that is paid. | ||
| CHECK_ID | NUMBER | 18 | Yes | Payment identifier. | |
| INVOICE_ID | NUMBER | 18 | Yes | Unique invoice identifier that identifies the invoice to which the payment belongs. | |
| INVOICE_PAYMENT_ID | NUMBER | 18 | Yes | Unique identifier of the payment. | |
| 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. | ||
| PAYMENT_NUM | NUMBER | 18 | Yes | Number identifying a payment. | |
| PERIOD_NAME | VARCHAR2 | 15 | Yes | Period name associated with the payment. | |
| POSTED_FLAG | VARCHAR2 | 1 | Yes | Flag that indicates if the payment has been accounted (Y or N) | |
| SET_OF_BOOKS_ID | NUMBER | 18 | Yes | Ledger identifier of the payment. | |
| ACCTS_PAY_CODE_COMBINATION_ID | NUMBER | 18 | Accounting Flexfield identifier for accounts payable liability account | ||
| ASSET_CODE_COMBINATION_ID | NUMBER | 18 | Accounting Flexfield identifier for cash account | ||
| CREATED_BY | VARCHAR2 | 64 | Yes | Who column: indicates the user who created the row. | |
| CREATION_DATE | TIMESTAMP | Yes | Who column: indicates the date and time of the creation of the row. | ||
| LAST_UPDATE_LOGIN | VARCHAR2 | 32 | Who column: indicates the session login associated to the user who last updated the row. | ||
| BANK_ACCOUNT_NUM | VARCHAR2 | 30 | Bank account number for payment. | ||
| BANK_ACCOUNT_TYPE | VARCHAR2 | 25 | Bank account type through which payment is made. For example, savings or checking account. | ||
| BANK_NUM | VARCHAR2 | 25 | Unique identification number of the bank from where the payment is being made. | ||
| DISCOUNT_LOST | NUMBER | Discount amount lost when the invoice payment is not made in time to avail discount. | |||
| DISCOUNT_TAKEN | NUMBER | Discount amount on payment. | |||
| GAIN_CODE_COMBINATION_ID | NUMBER | 18 | 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 | 18 | 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 of the user descriptive flexfield. | ||
| ATTRIBUTE10 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | ||
| ATTRIBUTE11 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | ||
| ATTRIBUTE12 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | ||
| ATTRIBUTE13 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | ||
| ATTRIBUTE14 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | ||
| ATTRIBUTE15 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | ||
| ATTRIBUTE2 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | ||
| ATTRIBUTE3 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | ||
| ATTRIBUTE4 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | ||
| ATTRIBUTE5 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | ||
| ATTRIBUTE6 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | ||
| ATTRIBUTE7 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | ||
| ATTRIBUTE8 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | ||
| ATTRIBUTE9 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | ||
| ATTRIBUTE_CATEGORY | VARCHAR2 | 150 | Descriptive Flexfield: structure definition of the user descriptive flexfield. | ||
| 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) | ||
| ORG_ID | NUMBER | 18 | Yes | Indicates the identifier of the business unit associated to the row. | |
| GLOBAL_ATTRIBUTE_CATEGORY | VARCHAR2 | 150 | Global Descriptive Flexfield: structure definition of the global descriptive flexfield. | ||
| GLOBAL_ATTRIBUTE1 | VARCHAR2 | 150 | Global Descriptive Flexfield: segment of the global descriptive flexfield. | ||
| GLOBAL_ATTRIBUTE2 | VARCHAR2 | 150 | Global Descriptive Flexfield: segment of the global descriptive flexfield. | ||
| GLOBAL_ATTRIBUTE3 | VARCHAR2 | 150 | Global Descriptive Flexfield: segment of the global descriptive flexfield. | ||
| GLOBAL_ATTRIBUTE4 | VARCHAR2 | 150 | Global Descriptive Flexfield: segment of the global descriptive flexfield. | ||
| GLOBAL_ATTRIBUTE5 | VARCHAR2 | 150 | Global Descriptive Flexfield: segment of the global descriptive flexfield. | ||
| GLOBAL_ATTRIBUTE6 | VARCHAR2 | 150 | Global Descriptive Flexfield: segment of the global descriptive flexfield. | ||
| GLOBAL_ATTRIBUTE7 | VARCHAR2 | 150 | Global Descriptive Flexfield: segment of the global descriptive flexfield. | ||
| GLOBAL_ATTRIBUTE8 | VARCHAR2 | 150 | Global Descriptive Flexfield: segment of the global descriptive flexfield. | ||
| GLOBAL_ATTRIBUTE9 | VARCHAR2 | 150 | Global Descriptive Flexfield: segment of the global descriptive flexfield. | ||
| GLOBAL_ATTRIBUTE10 | VARCHAR2 | 150 | Global Descriptive Flexfield: segment of the global descriptive flexfield. | ||
| GLOBAL_ATTRIBUTE11 | VARCHAR2 | 150 | Global Descriptive Flexfield: segment of the global descriptive flexfield. | ||
| GLOBAL_ATTRIBUTE12 | VARCHAR2 | 150 | Global Descriptive Flexfield: segment of the global descriptive flexfield. | ||
| GLOBAL_ATTRIBUTE13 | VARCHAR2 | 150 | Global Descriptive Flexfield: segment of the global descriptive flexfield. | ||
| GLOBAL_ATTRIBUTE14 | VARCHAR2 | 150 | Global Descriptive Flexfield: segment of the global descriptive flexfield. | ||
| GLOBAL_ATTRIBUTE15 | VARCHAR2 | 150 | Global Descriptive Flexfield: segment of the global descriptive flexfield. | ||
| GLOBAL_ATTRIBUTE16 | VARCHAR2 | 150 | Global Descriptive Flexfield: segment of the global descriptive flexfield. | ||
| GLOBAL_ATTRIBUTE17 | VARCHAR2 | 150 | Global Descriptive Flexfield: segment of the global descriptive flexfield. | ||
| GLOBAL_ATTRIBUTE18 | VARCHAR2 | 150 | Global Descriptive Flexfield: segment of the global descriptive flexfield. | ||
| GLOBAL_ATTRIBUTE19 | VARCHAR2 | 150 | Global Descriptive Flexfield: segment of the global descriptive flexfield. | ||
| GLOBAL_ATTRIBUTE20 | VARCHAR2 | 150 | Global Descriptive Flexfield: segment of the global descriptive flexfield. | ||
| EXTERNAL_BANK_ACCOUNT_ID | NUMBER | 18 | 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_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 identifier 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 | ||
| MRC_FUTURE_PAY_POSTED_FLAG | VARCHAR2 | 2000 | Multiple Reporting Currencies only: | ||
| ACCOUNTING_EVENT_ID | NUMBER | 18 | Identifier for payment accounting event. | ||
| REVERSAL_FLAG | VARCHAR2 | 1 | Flag that indicates whether current invoice payment is a reversal of another invoice payment | ||
| REVERSAL_INV_PMT_ID | NUMBER | 18 | 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 | 18 | Original party id for third party payment | ||
| INVOICING_PARTY_SITE_ID | NUMBER | 18 | Original party id site for third party payment | ||
| INVOICING_VENDOR_SITE_ID | NUMBER | 18 | Original vendor site id for third party payment | ||
| EXCHANGE_RATE_TYPE | VARCHAR2 | 30 | Source of currency conversion rate, such as user defined, spot, or corporate for the payment. | ||
| EXCHANGE_RATE | NUMBER | Ratio at which the principal unit of one currency is converted into another currency for payment. | |||
| EXCHANGE_DATE | DATE | Date when a conversion rate is used to convert an amount into another currency for payment. | |||
| 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. | |
| INVOICE_CURRENCY_CODE | VARCHAR2 | 15 | The currency in which a supplier invoice is received. | ||
| PAYMENT_CURRENCY_CODE | VARCHAR2 | 15 | The currency that the payment is made in. | ||
| X_CURR_RATE | NUMBER | The conversion rate used to convert the invoice currency to payment currency. | |||
| AMOUNT_INV_CURR | NUMBER | The amount to be paid in invoice currency. | |||
| DISCOUNT_TAKEN_INV_CURR | NUMBER | The amount of discount taken in invoice currency. | |||
| DISCOUNT_LOST_INV_CURR | NUMBER | The amount of discount lost in invoice currency. | |||
| INV_ORG_ID | NUMBER | 18 | Invoicing Business Unit | ||
| REMIT_TO_SUPPLIER_NAME | VARCHAR2 | 240 | Third party supplier | ||
| REMIT_TO_SUPPLIER_ID | NUMBER | 18 | Third party supplier identifier | ||
| REMIT_TO_ADDRESS_NAME | VARCHAR2 | 240 | Remit-to address where payment should be sent | ||
| REMIT_TO_ADDRESS_ID | NUMBER | 18 | Remit-to address identifier where payment should be sent | ||
| ANNUAL_PERCENTAGE_RATE | NUMBER | Active discount percent rate for the dynamic discount calculation. | |||
| DAYS_ACCELERATED | NUMBER | Number of days used for the dynamic discount calculation. | |||
| APR_ASSIGNMENT_ID | NUMBER | 18 | Unique identifier of the annual percentage rate associated with the supplier. | ||
| GLOBAL_ATTRIBUTE_NUMBER1 | NUMBER | Global Descriptive Flexfield: segment of the global descriptive flexfield. | |||
| GLOBAL_ATTRIBUTE_NUMBER2 | NUMBER | Global Descriptive Flexfield: segment of the global descriptive flexfield. | |||
| GLOBAL_ATTRIBUTE_NUMBER3 | NUMBER | Global Descriptive Flexfield: segment of the global descriptive flexfield. | |||
| GLOBAL_ATTRIBUTE_NUMBER4 | NUMBER | Global Descriptive Flexfield: segment of the global descriptive flexfield. | |||
| GLOBAL_ATTRIBUTE_NUMBER5 | NUMBER | Global Descriptive Flexfield: segment of the global descriptive flexfield. | |||
| GLOBAL_ATTRIBUTE_DATE1 | DATE | Global Descriptive Flexfield: segment of the global descriptive flexfield. | |||
| GLOBAL_ATTRIBUTE_DATE2 | DATE | Global Descriptive Flexfield: segment of the global descriptive flexfield. | |||
| GLOBAL_ATTRIBUTE_DATE3 | DATE | Global Descriptive Flexfield: segment of the global descriptive flexfield. | |||
| GLOBAL_ATTRIBUTE_DATE4 | DATE | Global Descriptive Flexfield: segment of the global descriptive flexfield. | |||
| GLOBAL_ATTRIBUTE_DATE5 | DATE | Global Descriptive Flexfield: segment of the global descriptive flexfield. | |||
| ASSIGNMENT_TYPE_CODE | VARCHAR2 | 30 | Type of assignment. Possible values are ASSIGNED, STANDING_OFFER, and UNSUBSCRIBED. ASSIGNED represents the supplier assigned to the campaign, STANDING_OFFER represents that the supplier has accepted the standing offer, and UNSUBSCRIBED represents that the supplier has unsubscribed from the campaign. | ||
| CAMPAIGN_NAME | VARCHAR2 | 60 | Name of the discount offer made to the supplier. |
Foreign Keys
| Table | Foreign Table | Foreign Key Column |
|---|---|---|
| AP_INVOICE_PAYMENTS_ALL | ap_invoices_all | INVOICE_ID |
| AP_INVOICE_PAYMENTS_ALL | gl_code_combinations | ACCTS_PAY_CODE_COMBINATION_ID |
| AP_INVOICE_PAYMENTS_ALL | gl_code_combinations | ASSET_CODE_COMBINATION_ID |
| AP_INVOICE_PAYMENTS_ALL | gl_code_combinations | GAIN_CODE_COMBINATION_ID |
| AP_INVOICE_PAYMENTS_ALL | gl_code_combinations | LOSS_CODE_COMBINATION_ID |
| AP_INVOICE_PAYMENTS_ALL | poz_suppliers | REMIT_TO_SUPPLIER_ID |
| AP_INVOICE_PAYMENTS_ALL | hz_party_sites | REMIT_TO_ADDRESS_ID |
| AP_INVOICE_PAYMENTS_ALL | ap_checks_all | CHECK_ID |
| AP_INVOICE_PAYMENTS_ALL | gl_ledgers | SET_OF_BOOKS_ID |
| AP_INVOICE_PAYMENTS_ALL | gl_daily_conversion_types | EXCHANGE_RATE_TYPE |
| AP_INVOICE_PAYMENTS_ALL | ap_payment_schedules_all | INVOICE_ID, PAYMENT_NUM |
| AP_INVOICE_PAYMENTS_ALL | hz_parties | INVOICING_PARTY_ID |
| AP_INVOICE_PAYMENTS_ALL | hz_party_sites | INVOICING_PARTY_SITE_ID |
| ap_payment_hist_dists | ap_invoice_payments_all | INVOICE_PAYMENT_ID |
| fa_mass_additions | ap_invoice_payments_all | INVOICE_PAYMENT_ID |
| ap_invoice_distributions_all | ap_invoice_payments_all | AWT_INVOICE_PAYMENT_ID |
| ap_awt_temp_distributions_all | ap_invoice_payments_all | INVOICE_PAYMENT_ID |
Indexes
| Index | Uniqueness | Tablespace | Columns |
|---|---|---|---|
| AP_INVOICE_PAYMENTS_N1 | Non Unique | Default | INVOICE_ID, PAYMENT_NUM |
| AP_INVOICE_PAYMENTS_N2 | Non Unique | Default | CHECK_ID |
| AP_INVOICE_PAYMENTS_N3 | Non Unique | Default | POSTED_FLAG, ORG_ID, SET_OF_BOOKS_ID, ASSETS_ADDITION_FLAG, ACCOUNTING_DATE |
| AP_INVOICE_PAYMENTS_N4 | Non Unique | Default | ACCOUNTING_DATE |
| AP_INVOICE_PAYMENTS_N7 | Non Unique | Default | ASSETS_ADDITION_FLAG |
| AP_INVOICE_PAYMENTS_N8 | Non Unique | Default | ACCOUNTING_EVENT_ID |
| AP_INVOICE_PAYMENTS_N9 | Non Unique | Default | REVERSAL_INV_PMT_ID |
| AP_INVOICE_PAYMENTS_U1 | Unique | Default | INVOICE_PAYMENT_ID |