AR_RECEIVABLE_APPLICATIONS_ALL
The AR_RECEIVABLE_APPLICATIONS_ALL table stores all accounting entries for both your cash and credit memo applications. The APPLICATION_TYPE column stores either CASH or CM (for credit memo applications). Each row in this table includes the amount applied, status, and accounting flexfield information. Possible application statuses include: APP for applied, UNAPP for unapplied, ACC for on-account, UNID for unidentified, ACTIVITY for receivable activity, and OTHER ACC for other receipt application. Receivables looks at application status to determine which flexfield account to use. Receivables uses CODE_COMBINATION_ID foreign key column to associate payment with the unidentified flexfield account. The CODE_COMBINATION_ID column stores valid Accounting Flexfield segment value combinations credited in General Ledger when this application is posted. Cash applications represent cash receipt applications. The sum of AMOUNT_APPLIED column for cash applications should always equal the amount of the cash receipt. A negative value in AMOUNT_APPLIED column becomes a debit when application is posted to General Ledger. When a cash receipt is initially created, Receivables creates a row in this table for cash receipt amount with status of UNAPP. For each subsequent application, Receivables creates two rows: one row with status of APP for amount applied to invoice, and one row with status UNAPP for the negative of the applied amount. If you reverse a cash application, Receivables creates two new rows: one row with status APP for the inverse amount of the original application (negative of the original application amount), and one row with status UNAPP for positive amount of application that is reversed. Credit memo applications do not have rows with status UNAPP, and use only rows with status of APP. The CASH_RECEIPT_ID column stores ID of the receipt you entered. Receivables concurrently creates a record for this receipt in AR_CASH_RECEIPTS_ALL table. This column is null for credit memo application. The CUSTOMER_TRX_ID and PAYMENT_SCHEDULE_ID columns also identify transaction you are applying. The APPLIED_CUSTOMER_TRX_ID and APPLIED_PAYMENT_SCHEDULE_ID columns identify invoice or credit memo that receives the application. If you apply a credit memo against the invoice, Receivables creates a record in this table. The CUSTOMER_TRX_ID and PAYMENT_SCHEDULE_ID columns for this record identify the credit memo you are applying. The APPLIED_CUSTOMER_TRX_ID and APPLIED_PAYMENT_SCHEDULE_ID columns for this record belong to invoice being applied. If you combine an on-account credit and a receipt, Receivables creates a record in this table. The CASH_RECEIPT_ID and PAYMENT_SCHEDULE_ID columns for this record identify the receipt. The APPLIED_CUSTOMER_TRX_ID and APPLIED_PAYMENT_SCHEDULE_ID columns for this record identify the on-account credit you combine with the receipt. The CONFIRMED_FLAG column is a denormalization from the AR_CASH_RECEIPTS_ALL table. If the cash receipt is not confirmed, applications of that receipt are not reflected in the payment schedule of the transaction the receipt is applied against.
Details
-
Schema: FUSION
-
Object owner: AR
-
Object type: TABLE
-
Tablespace: APPS_TS_TX_DATA
Primary Key
| Name | Columns |
|---|---|
|
AR_RECEIVABLE_APPLICATIONS_PK |
RECEIVABLE_APPLICATION_ID |
Columns
| Name | Datatype | Length | Precision | Not-null | Comments | Flexfield-mapping |
|---|---|---|---|---|---|---|
| RECEIVABLE_APPLICATION_ID | NUMBER | 18 | Yes | Identifies the receivable application | ||
| EXCEPTION_REASON_CODE | VARCHAR2 | 30 | Reason a receipt was applied manually. | |||
| 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. | |||
| 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. | |||
| AMOUNT_APPLIED | NUMBER | Yes | For same currency applications, the total amount of the application in the currency of the receipt and transaction. For cross currency applications, the total amount of the application in the currency of the transaction. | |||
| AMOUNT_APPLIED_FROM | NUMBER | The amount applied to the transaction in the receipt currency. This field is used only for cross currency applications (will be null for same currency applications). | ||||
| TRANS_TO_RECEIPT_RATE | NUMBER | The exchange rate used to convert the amount applied in the transaction currency to the amount applied in the receipt currency. This field is used only for cross currency receipt applications. | ||||
| GL_DATE | DATE | Yes | Date that this application will post to the General Ledger | |||
| CODE_COMBINATION_ID | NUMBER | 18 | Yes | General Ledger code combination (account) | ||
| SET_OF_BOOKS_ID | NUMBER | 18 | Yes | General Ledger Set of Books used (only one supported per organization) | ||
| DISPLAY | VARCHAR2 | 1 | Yes | Y or N flag to indicate whether this is the latest application | ||
| APPLY_DATE | DATE | Yes | Date the application was applied | |||
| APPLICATION_TYPE | VARCHAR2 | 20 | Yes | Lookup code for the type of application | ||
| STATUS | VARCHAR2 | 30 | Yes | Lookup type for the status of the application | ||
| PAYMENT_SCHEDULE_ID | NUMBER | 18 | Yes | Identifies the payment schedule of the payment or credit memo that is being applied | ||
| LAST_UPDATE_LOGIN | VARCHAR2 | 32 | Who column: indicates the session login associated to the user who last updated the row. | |||
| CASH_RECEIPT_ID | NUMBER | 18 | Identifies the payment being applied | |||
| APPLIED_CUSTOMER_TRX_ID | NUMBER | 18 | Identifies the debit item or credit memo to which a payment or credit memo is applied | |||
| APPLIED_CUSTOMER_TRX_LINE_ID | NUMBER | 18 | The line number of the debit item or credit memo to which a payment or credit memo is applied | |||
| APPLIED_PAYMENT_SCHEDULE_ID | NUMBER | 18 | Identifies the payment schedule of the debit item or credit memo that a payment or credit memo was applied to | |||
| CUSTOMER_TRX_ID | NUMBER | 18 | Identifies the debit item or credit memo being applied | |||
| LINE_APPLIED | NUMBER | Line amount applied | ||||
| TAX_APPLIED | NUMBER | Tax amount applied | ||||
| FREIGHT_APPLIED | NUMBER | Freight amount applied | ||||
| RECEIVABLES_CHARGES_APPLIED | NUMBER | Receivables charges amount applied | ||||
| EARNED_DISCOUNT_TAKEN | NUMBER | Amount of earned discount taken towards the application | ||||
| UNEARNED_DISCOUNT_TAKEN | NUMBER | Amount of unearned discount taken towards the application | ||||
| DAYS_LATE | NUMBER | 18 | Difference between apply date and due date of transaction | |||
| APPLICATION_RULE | VARCHAR2 | 30 | Yes | Code used internally to identify which SQL statements in which modules created this record | ||
| GL_POSTED_DATE | DATE | Date the application was posted to General Ledger | ||||
| COMMENTS | VARCHAR2 | 240 | User comments. | |||
| ATTRIBUTE_CATEGORY | VARCHAR2 | 30 | Descriptive Flexfield: structure definition of the user descriptive flexfield. | Receipt Applications (AR_RECEIVABLE_APPLICATIONS) | ||
| ATTRIBUTE1 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | Receipt Applications (AR_RECEIVABLE_APPLICATIONS) | ||
| ATTRIBUTE2 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | Receipt Applications (AR_RECEIVABLE_APPLICATIONS) | ||
| ATTRIBUTE3 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | Receipt Applications (AR_RECEIVABLE_APPLICATIONS) | ||
| ATTRIBUTE4 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | Receipt Applications (AR_RECEIVABLE_APPLICATIONS) | ||
| ATTRIBUTE5 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | Receipt Applications (AR_RECEIVABLE_APPLICATIONS) | ||
| ATTRIBUTE6 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | Receipt Applications (AR_RECEIVABLE_APPLICATIONS) | ||
| ATTRIBUTE7 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | Receipt Applications (AR_RECEIVABLE_APPLICATIONS) | ||
| ATTRIBUTE8 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | Receipt Applications (AR_RECEIVABLE_APPLICATIONS) | ||
| ATTRIBUTE9 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | Receipt Applications (AR_RECEIVABLE_APPLICATIONS) | ||
| ATTRIBUTE10 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | Receipt Applications (AR_RECEIVABLE_APPLICATIONS) | ||
| POSTABLE | VARCHAR2 | 1 | Y or N indicates whether the item is postable to the General Ledger | |||
| POSTING_CONTROL_ID | NUMBER | 18 | Yes | Receivables posting batch identifier, -1, -2, and -4 for posted in previous releases and -3 for not posted | ||
| ACCTD_AMOUNT_APPLIED_FROM | NUMBER | Yes | Receipt portion in functional currency, converted using the receipt rate | |||
| ACCTD_AMOUNT_APPLIED_TO | NUMBER | Amount allocated to the transaction in functional currency, converted using the transaction rate | ||||
| ACCTD_EARNED_DISCOUNT_TAKEN | NUMBER | Earned discount equivalent in the functional currency obtained using the invoice exchange rate | ||||
| ATTRIBUTE11 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | Receipt Applications (AR_RECEIVABLE_APPLICATIONS) | ||
| ATTRIBUTE12 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | Receipt Applications (AR_RECEIVABLE_APPLICATIONS) | ||
| ATTRIBUTE13 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | Receipt Applications (AR_RECEIVABLE_APPLICATIONS) | ||
| ATTRIBUTE14 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | Receipt Applications (AR_RECEIVABLE_APPLICATIONS) | ||
| ATTRIBUTE15 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | Receipt Applications (AR_RECEIVABLE_APPLICATIONS) | ||
| CONFIRMED_FLAG | VARCHAR2 | 1 | Null or Yes flag that indicates when a cash receipt is confirmed, No indicates if the cash receipt is not confirmed. Always use NVL (CONFIRMED_FLAG is Y) when checking this column. | |||
| PROGRAM_APPLICATION_ID | NUMBER | 18 | Concurrent Program who column - application id of the program that last updated this row (foreign key to FND_APPLICATION.APPLICATION_ID). | |||
| PROGRAM_ID | NUMBER | 18 | Concurrent Program who column - program id of the program that last updated this row (foreign key to FND_CONCURRENT_PROGRAM.CONCURRENT_PROGRAM_ID). | |||
| PROGRAM_UPDATE_DATE | DATE | Concurrent Program who column - date when a program last updated this row). | ||||
| REQUEST_ID | NUMBER | 18 | Enterprise Service Scheduler: indicates the request ID of the job that created or last updated the row. | |||
| USSGL_TRANSACTION_CODE | VARCHAR2 | 30 | Code defined by public sector accounting | Government Applications (AR_RECEIVABLE_APPLICATIONS_GOV) | ||
| USSGL_TRANSACTION_CODE_CONTEXT | VARCHAR2 | 30 | Context value for the USSGL Transaction Code Flexfield | Government Applications (AR_RECEIVABLE_APPLICATIONS_GOV) | ||
| EARNED_DISCOUNT_CCID | NUMBER | 18 | General Ledger code combination for the earned discount | |||
| UNEARNED_DISCOUNT_CCID | NUMBER | 18 | General Ledger code combination for the unearned discount | |||
| ACCTD_UNEARNED_DISCOUNT_TAKEN | NUMBER | Unearned discount equivalent in the functional currency obtained using the invoice exchange rate | ||||
| REVERSAL_GL_DATE | DATE | This column is filled in for the records that have been reversed and for the reversing record as well. | ||||
| CASH_RECEIPT_HISTORY_ID | NUMBER | 18 | Foreign key to the AR_CASH_RECEIPT_HISTORY table identifying the row that was current when the receivable application was created | |||
| ORG_ID | NUMBER | 18 | Yes | Indicates the identifier of the business unit associated to the row. | ||
| TAX_CODE | VARCHAR2 | 50 | Tax code for on-account transactions | |||
| 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. | |||
| GLOBAL_ATTRIBUTE_CATEGORY | VARCHAR2 | 30 | Global Descriptive Flexfield: structure definition of the global descriptive flexfield. | |||
| CONS_INV_ID | NUMBER | 18 | Consolidated invoice ID against which this adjustment appears | |||
| CONS_INV_ID_TO | NUMBER | 18 | Consolidated billing invoice ID which contains the application to the new site (if application of cash or credit memo is applied to a site that is different from the site that was originally assigned to the cash or credit memo transaction) | |||
| RULE_SET_ID | NUMBER | Application rule set identifier. | ||||
| LINE_EDISCOUNTED | NUMBER | Amount of earned discount taken from the remaining line amount for the item | ||||
| TAX_EDISCOUNTED | NUMBER | Amount of earned discount taken from the remaining tax amount for the item | ||||
| FREIGHT_EDISCOUNTED | NUMBER | Amount of earned discount taken from the remaining freight amount for the item | ||||
| CHARGES_EDISCOUNTED | NUMBER | Amount of earned discount taken from the remaining receivables charges amount for the item | ||||
| LINE_UEDISCOUNTED | NUMBER | Amount of unearned discount taken from the remaining line amount for the item | ||||
| TAX_UEDISCOUNTED | NUMBER | Amount of unearned discount taken from the remaining tax amount for the item | ||||
| FREIGHT_UEDISCOUNTED | NUMBER | Amount of unearned discount taken from the remaining freight amount for the item | ||||
| CHARGES_UEDISCOUNTED | NUMBER | Amount of unearned discount taken from the remaining receivables charges for the item | ||||
| RECEIVABLES_TRX_ID | NUMBER | 18 | Identifier of receivable activity. | |||
| ON_ACCOUNT_CUSTOMER | NUMBER | 18 | Not currently used. | |||
| EDISC_TAX_ACCT_RULE | VARCHAR2 | 3 | Indicates the rule used to create the accounting for tax on earned discounts. | |||
| UNEDISC_TAX_ACCT_RULE | VARCHAR2 | 3 | Indicates the rule used to create the accounting for tax on unearned discounts. | |||
| LINK_TO_TRX_HIST_ID | NUMBER | 18 | This column is used to reference the transaction history record, which is associated with the movement of deferred tax due to maturity date event, or its subsequent reversal event. | |||
| LINK_TO_CUSTOMER_TRX_ID | NUMBER | 18 | This column is used to reference the transaction that is associated with the short term debt application. | |||
| APPLICATION_REF_TYPE | VARCHAR2 | 30 | Identifies the application reference type and determines the context for the APPLICATION_REF_ID and APPLICATION_REF_NUM columns | |||
| APPLICATION_REF_ID | NUMBER | 18 | Application reference identifier whose context is determined by the APPLICATION_REF_TYPE column's value | |||
| APPLICATION_REF_NUM | VARCHAR2 | 30 | User-visible application reference number whose context is determined by the APPLICATION_REF_TYPE column's value | |||
| CHARGEBACK_CUSTOMER_TRX_ID | NUMBER | 18 | Not currently used. | |||
| SECONDARY_APPLICATION_REF_ID | NUMBER | 18 | Secondary application reference identifier of another transaction or application, such as a claim, that is associated with this receipt application | |||
| PAYMENT_SET_ID | NUMBER | 18 | Identifies the prepayment application's payment set ID | |||
| APPLICATION_REF_REASON | VARCHAR2 | 30 | Application reason code whose context is determined by the APPLICATION_REF_TYPE column's value | |||
| CUSTOMER_REFERENCE | VARCHAR2 | 100 | Reference supplied by customer | |||
| CUSTOMER_REASON | VARCHAR2 | 30 | Customer reason for deductions and chargebacks associated with an application. | |||
| APPLIED_REC_APP_ID | NUMBER | 18 | Identifies the Receivable Application record to which the payment has been applied. | |||
| SECONDARY_APPLICATION_REF_TYPE | VARCHAR2 | 30 | Identifies the application reference type and determines the context for the SECONDARY_APPLICATION_REF_ID and SECONDARY_APPLICATION_REF_NUM columns | |||
| SECONDARY_APPLICATION_REF_NUM | VARCHAR2 | 30 | User-visible application reference number whose context is determined by the SECONDARY_APPLICATION_REF_TYPE column's value | |||
| EVENT_ID | NUMBER | 18 | Subledger accounting event identifier. | |||
| UPGRADE_METHOD | VARCHAR2 | 30 | Upgrade flag to indicate the origin of the application | |||
| 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. | ||
| 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. | ||||
| BUDGETARY_CONTROL_FLAG | VARCHAR2 | 1 | Option that indicates whether budgeting is enabled on the ledger associated with the standard receipt, and if its details should be interfaced to Budgetary Control. Valid values are Y and N. | |||
| SUBLEDGER_BC_COMPLETE_FLAG | VARCHAR2 | 1 | Option that indicates whether to interface standard receipt accounting information from General Ledger to Budgetary Control. This value is passed by Budgetary Control to General Ledger through the accounting information from Receivables. | |||
| DATA_SET_ID | NUMBER | 18 | Unique identifier of the batch that groups receipt data for interface to Budgetary Control. | |||
| FUNDS_STATUS_CODE | VARCHAR2 | 30 | Status of the funds update on the receipt application. Valid values are mapped to the lookup ORA_XCC_FUNDS_STATUS. |
Foreign Keys
| Table | Foreign Table | Foreign Key Column |
|---|---|---|
| AR_RECEIVABLE_APPLICATIONS_ALL | ar_cash_receipts_all | CASH_RECEIPT_ID |
| AR_RECEIVABLE_APPLICATIONS_ALL | gl_code_combinations | CODE_COMBINATION_ID |
| AR_RECEIVABLE_APPLICATIONS_ALL | ar_receivables_trx_all | RECEIVABLES_TRX_ID, ORG_ID |
| AR_RECEIVABLE_APPLICATIONS_ALL | ra_customer_trx_all | CUSTOMER_TRX_ID |
| AR_RECEIVABLE_APPLICATIONS_ALL | ar_payment_schedules_all | PAYMENT_SCHEDULE_ID |
| AR_RECEIVABLE_APPLICATIONS_ALL | ra_customer_trx_all | APPLIED_CUSTOMER_TRX_ID |
| AR_RECEIVABLE_APPLICATIONS_ALL | ar_payment_schedules_all | APPLIED_PAYMENT_SCHEDULE_ID |
| AR_RECEIVABLE_APPLICATIONS_ALL | ra_customer_trx_lines_all | APPLIED_CUSTOMER_TRX_LINE_ID |
| AR_RECEIVABLE_APPLICATIONS_ALL | ar_cash_receipt_history_all | CASH_RECEIPT_HISTORY_ID |
| ar_adjustments_all | ar_receivable_applications_all | ASSOCIATED_APPLICATION_ID |
| iex_prd_appl_xref | ar_receivable_applications_all | RECEIVABLE_APPLICATION_ID |
| ar_statement_line_clusters | ar_receivable_applications_all | RECEIVABLE_APPLICATION_ID |
| ar_payment_schedules_all | ar_receivable_applications_all | CASH_APPLIED_ID_LAST |
| ar_interim_cash_rcpt_lines_all | ar_receivable_applications_all | APPLIED_REC_APP_ID |
Indexes
| Index | Uniqueness | Tablespace | Columns |
|---|---|---|---|
| AR_RECEIVABLE_APPLICATIONS_N1 | Non Unique | Default | CASH_RECEIPT_ID, STATUS |
| AR_RECEIVABLE_APPLICATIONS_N10 | Non Unique | Default | GL_POSTED_DATE |
| AR_RECEIVABLE_APPLICATIONS_N11 | Non Unique | Default | POSTING_CONTROL_ID, GL_DATE |
| AR_RECEIVABLE_APPLICATIONS_N12 | Non Unique | Default | CONS_INV_ID |
| AR_RECEIVABLE_APPLICATIONS_N13 | Non Unique | Default | LINK_TO_CUSTOMER_TRX_ID |
| AR_RECEIVABLE_APPLICATIONS_N14 | Non Unique | Default | PAYMENT_SET_ID |
| AR_RECEIVABLE_APPLICATIONS_N15 | Non Unique | Default | REQUEST_ID |
| AR_RECEIVABLE_APPLICATIONS_N16 | Non Unique | Default | EVENT_ID |
| AR_RECEIVABLE_APPLICATIONS_N2 | Non Unique | Default | CUSTOMER_TRX_ID |
| AR_RECEIVABLE_APPLICATIONS_N3 | Non Unique | Default | PAYMENT_SCHEDULE_ID, GL_DATE |
| AR_RECEIVABLE_APPLICATIONS_N5 | Non Unique | Default | APPLY_DATE |
| AR_RECEIVABLE_APPLICATIONS_N6 | Non Unique | Default | GL_DATE, SET_OF_BOOKS_ID |
| AR_RECEIVABLE_APPLICATIONS_N7 | Non Unique | Default | CREATION_DATE |
| AR_RECEIVABLE_APPLICATIONS_N8 | Non Unique | Default | APPLIED_PAYMENT_SCHEDULE_ID, GL_DATE |
| AR_RECEIVABLE_APPLICATIONS_N9 | Non Unique | Default | APPLIED_CUSTOMER_TRX_ID |
| AR_RECEIVABLE_APPLICATIONS_U1 | Unique | Default | RECEIVABLE_APPLICATION_ID |