[Home] [Help]
[Dependency Information]
[Home] [Help]
[Dependency Information]
| Object Name: | AP_RECURRING_PAYMENTS_ALL |
|---|---|
| Object Type: | TABLE |
| Owner: | AP |
| FND Design Data: |  SQLAP.AP_RECURRING_PAYMENTS_ALL
|
| Subobject Name: | |
| Status: | VALID |
AP_RECURRING_PAYMENTS_ALL contains information about
recurring invoices you define. You need one row for
each set of recurring invoices you arrange with a
supplier. Your Oracle Payables application uses this
information to help you create recurring invoices without
duplicating data entry.
Values for PAID_FLAG1 and PAID_FLAG2 may be 'Y' for Yes
or 'N' for No.
This table corresponds to the Recurring Invoices window.
| Tablespace: |  APPS_TS_TX_DATA |
|---|---|
| PCT Free: | 10 |
| PCT Used: |
| Index | Type | Uniqueness | Tablespace | Column |
|---|---|---|---|---|
| AP_RECURRING_PAYMENTS_U1 | NORMAL | UNIQUE |
APPS_TS_TX_IDX
|
 RECURRING_PAYMENT_ID
|
| AP_RECURRING_PAYMENTS_U2 | NORMAL | UNIQUE |
APPS_TS_TX_IDX
|
VENDOR_ID
RECURRING_PAY_NUM
ORG_ID
|
| AP_RECURRING_PAYMENTS_N1 | NORMAL | NONUNIQUE |
APPS_TS_TX_IDX
|
RECURRING_PAY_NUM
|
| AP_RECURRING_PAYMENTS_N2 | NORMAL | NONUNIQUE |
APPS_TS_TX_IDX
|
VENDOR_SITE_ID
|
| AP_RECURRING_PAYMENTS_N3 | NORMAL | NONUNIQUE |
APPS_TS_TX_IDX
|
BATCH_ID
|
| AP_RECURRING_PAYMENTS_N4 | NORMAL | NONUNIQUE |
APPS_TS_TX_IDX
|
CONTROL_AMOUNT
|
| AP_RECURRING_PAYMENTS_N5 | NORMAL | NONUNIQUE |
APPS_TS_TX_IDX
|
CREATION_DATE
|
| Name | Datatype | Length | Mandatory | Comments |
|---|---|---|---|---|
| RECURRING_PAYMENT_ID | NUMBER | (15) | Yes | Unique internal Identifier for this record. Generated using a database sequence. |
| 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 - unique internal identifier user who last updated this row. Foreign key to the USER_ID column of the FND_USER table. |
| CREATION_DATE | DATE | Yes | Standard who column - date when this row was created. | |
| CREATED_BY | NUMBER | (15) | Yes | Standard who column - unique internal identifier of user who created this row. Foreign key to the USER_ID column of the FND_USER table. |
| VENDOR_ID | NUMBER | (15) | Yes | The unique internal identifier of the supplier to which the recurring invoice belongs. Foreign key to the AP_SUPPLIERS table. |
| RECURRING_PAY_NUM | VARCHAR2 | (25) | Yes | This is the Recurring invoice template number and is unique for a supplier. This number concatenated with period name of the recurring invoice period will be used as invoice number while creating invoices for this template. |
| VENDOR_SITE_ID | NUMBER | (15) | Yes | The unique internal identifier for the payment site of the supplier. Foreign key to the AP_SUPPLIER_SITES_ALL table. |
| REC_PAY_PERIOD_TYPE | VARCHAR2 | (15) | Yes | This corresponds to the special calendar name associated with recurring invoice, represents the frequency of the recurring invoice. |
| NUM_OF_PERIODS | NUMBER | (15) | Yes | Total number of payments to be made over life of recurring invoice |
| FIRST_PERIOD | VARCHAR2 | (15) | Yes | First period for which a recurring invoice will be created |
| FIRST_PERIOD_NUM | NUMBER | (15) | Yes | Number of first period |
| AUTHORIZED_TOTAL | NUMBER | Yes | Amount authorized for creation of invoices. | |
| CONTROL_AMOUNT | NUMBER | Yes | Total amount available for creation of invoices. | |
| DISTRIBUTION_SET_ID | NUMBER | (15) | Distribution set identifier to be used in the generation of distributions for a Invoice line. Foreign key to the DISTRIBUTION_SET_ID of AP_DISTRIBUTION_SETS_ALL table. | |
| TERMS_ID | NUMBER | (15) | Yes | Payment terms identifier. Foreign key to the TERMS_ID of the AP_TERMS_TL table. |
| SET_OF_BOOKS_ID | NUMBER | (15) | Yes | Ledger Unique Identifier |
| AMOUNT_APPLICABLE_TO_DISCOUNT | NUMBER | Yes | Amount of invoice applicable to a discount | |
| PAYMENT_METHOD_LOOKUP_CODE | VARCHAR2 | (25) | No longer used | |
| REM_PERIODS | NUMBER | (15) | Number of remaining periods | |
| ACCOUNTING_DATE | DATE | Accounting date | ||
| RELEASED_AMOUNT | NUMBER | Total amount of invoices created with a recurring invoice | ||
| BATCH_ID | NUMBER | (15) | Batch identifier | |
| ACCTS_PAY_CODE_COMBINATION_ID | NUMBER | (15) | Accounting Flexfield identifier for accounts payable liability account | |
| INVOICE_CURRENCY_CODE | VARCHAR2 | (15) | Yes | Currency code of the invoice. Foreign key to the FND_CURRENCIES table. |
| PAYMENT_CURRENCY_CODE | VARCHAR2 | (15) | Yes | Currency code of payment. If the Invoice Currency is not a fixed-rate currency, then the Payment Currency will be the same as the INVOICE_CURRENCY_CODE. For fixed-rate currency such as euro or another EMU currency it can be different to INVOICE_CURRENCY_CODE |
| INVOICE_BASE_RATE | NUMBER | (10) | No longer used | |
| PAY_GROUP_LOOKUP_CODE | VARCHAR2 | (25) | Name of the Paygroup associated with recurring invoice defintion used to pay a category of suppliers or invoices in the same payment batch. Possible values for this column are derived from FND_LOOKUP_VALUES for lookup_type 'PAY GROUP' | |
| TAX_AMOUNT | NUMBER | Amount of tax | ||
| PAYMENT_INVOICE_CROSS_RATE | NUMBER | (10) | No longer used | |
| EXCHANGE_RATE | NUMBER | Exchange rate between invoice currency and functional currency for a foreign currency recurring invoice | ||
| NEXT_PERIOD | VARCHAR2 | (15) | Name of next recurring invoice period | |
| NEXT_PAYMENT | NUMBER | Amount of next recurring invoice | ||
| INCREMENT_PERCENT | NUMBER | (10) | Percent change by which recurring invoices will increase or decrease per period | |
| NUM_OF_PERIODS_REM | NUMBER | (15) | Number of recurring invoice periods remaining | |
| SPECIAL_PAYMENT_AMOUNT1 | NUMBER | Amount of first special payment | ||
| SPECIAL_PERIOD_NAME1 | VARCHAR2 | (30) | Name of period in which first special payment made | |
| SPECIAL_PAYMENT_AMOUNT2 | NUMBER | Amount of second special payment | ||
| SPECIAL_PERIOD_NAME2 | VARCHAR2 | (30) | Name of period in which second special payment made | |
| DESCRIPTION | VARCHAR2 | (240) | Description | |
| PAID_FLAG1 | VARCHAR2 | (1) | Flag that indicates if first special payment has been paid (Y or N) | |
| PAID_FLAG2 | VARCHAR2 | (1) | Flag that indicates if second special payment has been made | |
| HOLD_LOOKUP_CODE | VARCHAR2 | (25) | Name of hold or release code | |
| HOLD_REASON | VARCHAR2 | (240) | Description of hold | |
| APPROVED_BY | NUMBER | (15) | Name of person who submitted Payables Invoice Validation for validated recurring invoice. | |
| EXPIRY_DATE | DATE | Date after which invoices cannot be created using recurring invoice definition | ||
| ATTRIBUTE_CATEGORY | VARCHAR2 | (150) | Descriptive flexfield structure definition column. | |
| ATTRIBUTE1 | 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 | |
| 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 | |
| EXCHANGE_RATE_TYPE | VARCHAR2 | (30) | Exchange rate type for foreign currency recurring invoice. Payables uses following five types of exchange rates:� User� Spot� Corporate� User-Defined� EMU Fixed | |
| PAYMENT_CROSS_RATE | NUMBER | Yes | Exchange rate between invoice and payment. The value is always 1 unless they are associated fixed-rate currencies such as euro or another EMU currency | |
| EXCHANGE_DATE | DATE | Date exchange rate is effective, usually accounting date of a transaction | ||
| 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. | |
| TAX_NAME | VARCHAR2 | (15) | No Longer Used | |
| EXCLUSIVE_PAYMENT_FLAG | VARCHAR2 | (1) | This flag indicates to pay this invoice using separate payment document.This columns corresponds to 'Pay alone' checkbox of Payment Tab. | |
| AWT_GROUP_ID | NUMBER | (15) | Withholding Tax group identifier at Invoice Validation time. This column correspods to 'Invoice Withholding Tax Group' | |
| ORG_ID | NUMBER | (15) | Unique internal identifier of the Operating Unit. | |
| PO_HEADER_ID | NUMBER | (15) | Purchase order header identifier. Used for PO matching. Validated against PO_HEADERS_ALL.PO_HEADER_ID | |
| PO_LINE_ID | NUMBER | (15) | Purchase order line identifier. Used for PO matching. Validated against PO_LINES_ALL.PO_LINE_ID | |
| LINE_LOCATION_ID | NUMBER | (15) | Purchase order line location identifier. Used for PO matching. Validated against PO_LINE_LOCATIONS_ALL.LINE_LOCATION_ID | |
| 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 | VARCHAR2 | (15) | Unique internal identifier for the supplier bank account associated with Invoice. Foreign key to the IBY_EXT_BANK_ACCOUNTS table | |
| APPROVAL_REQUIRED_FLAG | VARCHAR2 | (1) | Indicates whether invoice is subject to the Invoice Approval Workflow process (Y or N) | |
| USSGL_TRANSACTION_CODE | VARCHAR2 | (30) | Transaction Code for creating US Standard General Ledger journal entries (Oracle Public Sector Payables)/ | |
| FIRST_AMOUNT | NUMBER | Amount of first invoice created b the template, excluding any special payment such as a deposit | ||
| LEGAL_ENTITY_ID | NUMBER | (15) | Legal entity identifier | |
| TAXATION_COUNTRY | VARCHAR2 | (30) | The country in which the transaction is deemed to have taken place for taxation purposes. E-Business Tax will set the context of other tax drivers such as Product Fiscal Classification based on the value of this field. | |
| TAX_CONTROL_AMOUNT | NUMBER | Optional, user-enterable value to ensure that the calculated tax will be the same as on the physical document. | ||
| PRIMARY_INTENDED_USE | VARCHAR2 | (30) | Tax Driver: The purpose for which a product may be used. The actual use will be stored at the distribution level. | |
| PRODUCT_FISC_CLASSIFICATION | VARCHAR2 | (240) | Tax Driver: Product Fiscal Classification identifies the taxable nature of an Inventory item for tax determination or tax reporting purposes. | |
| USER_DEFINED_FISC_CLASS | VARCHAR2 | (240) | Tax Driver: User Defined Fiscal Classification used to to classify any tax requirement that you cannot define using the seeded fiscal classification types. This column corresponds to 'Fiscal Classification' of Invoice Workbench | |
| TRX_BUSINESS_CATEGORY | VARCHAR2 | (240) | Tax Driver: Transaction category assigned. Transaction business category used to identify and classify your business transactions for tax calculation purpose. | |
| REQUESTER_ID | NUMBER | (15) | Requester of goods or services on invoice. Used by Invoice Workflow Approval process to generate list of approvers. Valid values from active HR employees. Validated against PER_ALL_PEOPLE_F.PERSON_ID | |
| ITEM_DESCRIPTION | VARCHAR2 | (240) | Item description | |
| MANUFACTURER | VARCHAR2 | (30) | Name of manufacturer | |
| MODEL_NUMBER | VARCHAR2 | (40) | Model information | |
| PO_RELEASE_ID | NUMBER | Purchase order release identifier. Used for PO matching. Validated against PO_RELEASES_ALL.PO_RELEASE_ID | ||
| REMITTANCE_MESSAGE1 | VARCHAR2 | (150) | Remittance message for use in payment processing. | |
| REMITTANCE_MESSAGE2 | VARCHAR2 | (150) | Remittance message for use in payment processing | |
| REMITTANCE_MESSAGE3 | VARCHAR2 | (150) | Remittance message for use in payment processing | |
| PAYMENT_REASON_CODE | VARCHAR2 | (30) | Payment reason code | |
| PAYMENT_METHOD_CODE | VARCHAR2 | (30) | Name of the payment method used to pay the supplier site. Foreign key from the table IBY_PAYMENT_METHODS_B | |
| BANK_CHARGE_BEARER | VARCHAR2 | (30) | Bearer of bank charge cost. Bank charge bearers are defined as the lookup IBY_BANK_CHARGE_BEARER | |
| SETTLEMENT_PRIORITY | VARCHAR2 | (30) | The priority with which the financial institution or payment system should settle payment for this document. The available values for this column come from the FND lookup IBY_SETTLEMENT_PRIORITY | |
| PAYMENT_REASON_COMMENTS | VARCHAR2 | (30) | Free text field available for entering a reason for the payment | |
| DELIVERY_CHANNEL_CODE | VARCHAR2 | (30) | Delivery channel code | |
| PAY_AWT_GROUP_ID | NUMBER | (15) | Withholding Tax group identifier at Payment time. This column corresponds to 'Payment Withholding Tax Group' | |
| REMIT_TO_SUPPLIER_NAME | VARCHAR2 | (240) | Name of the supplier to whom invoice amount can be remitted | |
| REMIT_TO_SUPPLIER_ID | NUMBER | (15) | Unique supplier identifier to whom invoice amount can be remitted | |
| REMIT_TO_SUPPLIER_SITE | VARCHAR2 | (240) | Name of the supplier site to whom invoice amount can be remitted | |
| REMIT_TO_SUPPLIER_SITE_ID | NUMBER | (15) | Unique supplier site identifier to whom invoice amount can be remitted | |
| RELATIONSHIP_ID | NUMBER | (15) | Unique identifier to third party relationships of a supplier with another supplier. This column will be populated if the payment is made to the third party. |
Cut, paste (and edit) the following text to query this object:
SELECT RECURRING_PAYMENT_ID
, LAST_UPDATE_DATE
, LAST_UPDATED_BY
, CREATION_DATE
, CREATED_BY
, VENDOR_ID
, RECURRING_PAY_NUM
, VENDOR_SITE_ID
, REC_PAY_PERIOD_TYPE
, NUM_OF_PERIODS
, FIRST_PERIOD
, FIRST_PERIOD_NUM
, AUTHORIZED_TOTAL
, CONTROL_AMOUNT
, DISTRIBUTION_SET_ID
, TERMS_ID
, SET_OF_BOOKS_ID
, AMOUNT_APPLICABLE_TO_DISCOUNT
, PAYMENT_METHOD_LOOKUP_CODE
, REM_PERIODS
, ACCOUNTING_DATE
, RELEASED_AMOUNT
, BATCH_ID
, ACCTS_PAY_CODE_COMBINATION_ID
, INVOICE_CURRENCY_CODE
, PAYMENT_CURRENCY_CODE
, INVOICE_BASE_RATE
, PAY_GROUP_LOOKUP_CODE
, TAX_AMOUNT
, PAYMENT_INVOICE_CROSS_RATE
, EXCHANGE_RATE
, NEXT_PERIOD
, NEXT_PAYMENT
, INCREMENT_PERCENT
, NUM_OF_PERIODS_REM
, SPECIAL_PAYMENT_AMOUNT1
, SPECIAL_PERIOD_NAME1
, SPECIAL_PAYMENT_AMOUNT2
, SPECIAL_PERIOD_NAME2
, DESCRIPTION
, PAID_FLAG1
, PAID_FLAG2
, HOLD_LOOKUP_CODE
, HOLD_REASON
, APPROVED_BY
, EXPIRY_DATE
, ATTRIBUTE_CATEGORY
, ATTRIBUTE1
, ATTRIBUTE2
, ATTRIBUTE3
, ATTRIBUTE4
, ATTRIBUTE5
, ATTRIBUTE6
, ATTRIBUTE7
, ATTRIBUTE8
, ATTRIBUTE9
, ATTRIBUTE10
, ATTRIBUTE11
, ATTRIBUTE12
, ATTRIBUTE13
, ATTRIBUTE14
, ATTRIBUTE15
, EXCHANGE_RATE_TYPE
, PAYMENT_CROSS_RATE
, EXCHANGE_DATE
, LAST_UPDATE_LOGIN
, TAX_NAME
, EXCLUSIVE_PAYMENT_FLAG
, AWT_GROUP_ID
, ORG_ID
, PO_HEADER_ID
, PO_LINE_ID
, LINE_LOCATION_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
, APPROVAL_REQUIRED_FLAG
, USSGL_TRANSACTION_CODE
, FIRST_AMOUNT
, LEGAL_ENTITY_ID
, TAXATION_COUNTRY
, TAX_CONTROL_AMOUNT
, PRIMARY_INTENDED_USE
, PRODUCT_FISC_CLASSIFICATION
, USER_DEFINED_FISC_CLASS
, TRX_BUSINESS_CATEGORY
, REQUESTER_ID
, ITEM_DESCRIPTION
, MANUFACTURER
, MODEL_NUMBER
, PO_RELEASE_ID
, REMITTANCE_MESSAGE1
, REMITTANCE_MESSAGE2
, REMITTANCE_MESSAGE3
, PAYMENT_REASON_CODE
, PAYMENT_METHOD_CODE
, BANK_CHARGE_BEARER
, SETTLEMENT_PRIORITY
, PAYMENT_REASON_COMMENTS
, DELIVERY_CHANNEL_CODE
, PAY_AWT_GROUP_ID
, REMIT_TO_SUPPLIER_NAME
, REMIT_TO_SUPPLIER_ID
, REMIT_TO_SUPPLIER_SITE
, REMIT_TO_SUPPLIER_SITE_ID
, RELATIONSHIP_ID
FROM AP.AP_RECURRING_PAYMENTS_ALL;
AP.AP_RECURRING_PAYMENTS_ALL does not reference any database object
AP.AP_RECURRING_PAYMENTS_ALL is referenced by following:
APPS
AP_RECURRING_PAYMENTS
AP_RECURRING_PAYMENTS_ALL
|
|
|
|