[Home] [Help]
[Dependency Information]
[Home] [Help]
[Dependency Information]
| Object Name: | AR_RECEIVABLE_APPLICATIONS_ALL |
|---|---|
| Object Type: | TABLE |
| Owner: | AR |
| FND Design Data: |  AR.AR_RECEIVABLE_APPLICATIONS_ALL
|
| Subobject Name: | |
| Status: | VALID |
The AR_RECEIVABLE_APPLICATIONS_ALL table stores records for cash and credit memo applications. The APPLICATION_TYPE column stores CASH for receipt applications and CM for credit memo applications. Each row in this table includes the amount applied, status, and account code combination information.
Receivables looks at the application status to determine which account code combination to use. The CODE_COMBINATION_ID column stores account code combination that are posted to Subledger Accounting.
The accounting code combinations stored in this table is meta data for creating accounting entries in Subledger Accounting. Receivables provides the code combinations stored in this table to Subledger Accounting as a source for accounting attributes for deriving the accounting code combinations. Subledger Accounting generates the final accounting entries that are posted to General Ledger. The accounting code combination used in the final accounting entries can be same as that stored in AR_RECEIVABLE_APPLICATIONS_ALL table or can be different depending on the rules setup in Subledger Accounting. The XLA_AE_HEADERS and XLA_AE_LINES tables in Subledger Accounting stores the accounting entries posted to General Ledger. The EVENT_ID column serves as link between AR_RECEIVABLE_APPLICATIONS_ALL and the XLA_AE_HEADERS tables.
Cash applications represent cash receipt applications. The sum of the AMOUNT_APPLIED column for cash applications should always equal the amount of the cash receipt. A negative value in the AMOUNT_APPLIED column becomes a debit when this application is posted to General Ledger.
When a cash receipt is initially created, Receivables creates a row in this table for the cash receipt amount with a status of UNAPP. For each subsequent application, Receivables creates two rows: one row with a status of APP for the amount that is applied to the invoice, and one row with status of UNAPP for the negative of the amount that is applied.
If a cash application is reversed, Receivables creates two new rows: one row with status of APP for the original application's inverse amount (the negative of the original application amount), and one row with a status of UNAPP for the positive amount of the application that is reversed.
Credit memo applications do not have rows with a status of UNAPP, and use only rows with a status of APP.
The CASH_RECEIPT_ID column stores the ID of the receipt that is entered. Receivables concurrently creates a record for this receipt in the AR_CASH_RECEIPTS_ALL table. This column is null for a credit memo application. The CUSTOMER_TRX_ID and PAYMENT_SCHEDULE_ID columns also identify the transaction that is actually applied.
The APPLIED_CUSTOMER_TRX_ID and APPLIED_PAYMENT_SCHEDULE_ID columns identify the invoice or credit memo that receives the application.
Receivables creates a record in this table when a credit memo is applied against an invoice. The CUSTOMER_TRX_ID and PAYMENT_SCHEDULE_ID columns for this record identify the credit memo that is applied. The APPLIED_CUSTOMER_TRX_ID and APPLIED_PAYMENT_SCHEDULE_ID columns for this record belong to the invoice that is receiving the application.
Receivables creates a record in this table when an on-account credit and a receipt is combined. 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 that is combined with the receipt.
The CONFIRMED_FLAG column is a denormalization from the AR_CASH_RECEIPTS_ALL table. If the cash receipt is not confirmed, the applications of that receipt are not reflected in the payment schedule of the transaction t
| Tablespace: |  APPS_TS_TX_DATA |
|---|---|
| PCT Free: | 10 |
| PCT Used: |
| Index | Type | Uniqueness | Tablespace | Column |
|---|---|---|---|---|
| AR_RECEIVABLE_APPLICATIONS_U1 | NORMAL | UNIQUE |
APPS_TS_TX_IDX
|
 RECEIVABLE_APPLICATION_ID
|
| AR_RECEIVABLE_APPLICATIONS_N1 | NORMAL | NONUNIQUE |
APPS_TS_TX_IDX
|
CASH_RECEIPT_ID
STATUS
|
| AR_RECEIVABLE_APPLICATIONS_N10 | NORMAL | NONUNIQUE |
APPS_TS_TX_IDX
|
GL_POSTED_DATE
|
| AR_RECEIVABLE_APPLICATIONS_N11 | NORMAL | NONUNIQUE |
APPS_TS_TX_IDX
|
POSTING_CONTROL_ID
GL_DATE
|
| AR_RECEIVABLE_APPLICATIONS_N12 | NORMAL | NONUNIQUE |
APPS_TS_TX_IDX
|
CONS_INV_ID
|
| AR_RECEIVABLE_APPLICATIONS_N13 | NORMAL | NONUNIQUE |
APPS_TS_TX_IDX
|
LINK_TO_CUSTOMER_TRX_ID
|
| AR_RECEIVABLE_APPLICATIONS_N14 | NORMAL | NONUNIQUE |
APPS_TS_TX_IDX
|
PAYMENT_SET_ID
|
| AR_RECEIVABLE_APPLICATIONS_N15 | NORMAL | NONUNIQUE |
APPS_TS_TX_IDX
|
REQUEST_ID
|
| AR_RECEIVABLE_APPLICATIONS_N16 | NORMAL | NONUNIQUE |
APPS_TS_TX_IDX
|
EVENT_ID
|
| AR_RECEIVABLE_APPLICATIONS_N2 | NORMAL | NONUNIQUE |
APPS_TS_TX_IDX
|
CUSTOMER_TRX_ID
|
| AR_RECEIVABLE_APPLICATIONS_N3 | NORMAL | NONUNIQUE |
APPS_TS_TX_IDX
|
PAYMENT_SCHEDULE_ID
GL_DATE
|
| AR_RECEIVABLE_APPLICATIONS_N5 | NORMAL | NONUNIQUE |
APPS_TS_TX_IDX
|
APPLY_DATE
|
| AR_RECEIVABLE_APPLICATIONS_N6 | NORMAL | NONUNIQUE |
APPS_TS_TX_IDX
|
GL_DATE
SET_OF_BOOKS_ID
|
| AR_RECEIVABLE_APPLICATIONS_N7 | NORMAL | NONUNIQUE |
APPS_TS_TX_IDX
|
CREATION_DATE
|
| AR_RECEIVABLE_APPLICATIONS_N8 | NORMAL | NONUNIQUE |
APPS_TS_TX_IDX
|
APPLIED_PAYMENT_SCHEDULE_ID
GL_DATE
|
| AR_RECEIVABLE_APPLICATIONS_N9 | NORMAL | NONUNIQUE |
APPS_TS_TX_IDX
|
APPLIED_CUSTOMER_TRX_ID
|
| RECEIVABLE_APPLICATION_ID | NUMBER | (15) | Yes | Internal identifier of the receivable application record and primary key for this table. |
| LAST_UPDATED_BY | NUMBER | (15) | Yes | Standard who column. User who last updated this row. |
| LAST_UPDATE_DATE | DATE | Yes | Standard Who column. Date when a user last updated this row. | |
| CREATED_BY | NUMBER | (15) | Yes | Standard who column. User who created this row. |
| CREATION_DATE | DATE | Yes | Standard who column. Date when this row was created. | |
| 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 | The General Ledger accounting date for the accounting entry for this application. | |
| CODE_COMBINATION_ID | NUMBER | (15) | Yes | General Ledger account code combination that will be debited or credited for this application row. |
| SET_OF_BOOKS_ID | NUMBER | (15) | Yes | Internal identifier of the ledger to which accounting entry for this application will be posted. |
| 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 | Indicates whether the application is a receipt application or credit memo application. Value �CASH� indicates receipt application and �CM� indicates credit memo application. |
| STATUS | VARCHAR2 | (30) | Yes | Lookup type for the status of the application. Possible application statuses include:APP - AppliedUNAPP - UnappliedACC - On-AccountUNID - Unidentified ACTIVITY - Receivable ActivityOTHER ACC - Other Receipt Application |
| PAYMENT_SCHEDULE_ID | NUMBER | (15) | Yes | Internal identifier of the payment schedule of the credit memo that is being applied. |
| LAST_UPDATE_LOGIN | NUMBER | (15) | Standard who column. Operating system login of user who last updated this row. | |
| CASH_RECEIPT_ID | NUMBER | (15) | Internal identifier of the cash receipt being applied. | |
| APPLIED_CUSTOMER_TRX_ID | NUMBER | (15) | Internal identifier the debit item or credit memo to which the receipt or credit memo is applied | |
| APPLIED_CUSTOMER_TRX_LINE_ID | NUMBER | (15) | The line number of the debit item or credit memo to which the receipt or credit memo is applied | |
| APPLIED_PAYMENT_SCHEDULE_ID | NUMBER | (15) | Identifies the payment schedule of the debit item or credit memo to which the receipt or credit memo is applied. | |
| CUSTOMER_TRX_ID | NUMBER | (15) | Internal identifier of the credit memo that is 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 | (15) | 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) | Comments entered by the user | |
| ATTRIBUTE_CATEGORY | VARCHAR2 | (30) | Descriptive flexfield context. | |
| 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 | |
| POSTABLE | VARCHAR2 | (1) | Y or N indicates whether the item is postable to the General Ledger | |
| POSTING_CONTROL_ID | NUMBER | (15) | Yes | Receivables posting batch identifier, -1, -2, and -4 for posted in previous releases and -3 for not posted. Stores the identifier of the concurrent request for posted records. |
| ACCTD_AMOUNT_APPLIED_FROM | NUMBER | Yes | Amount applied in functional currency. Converted using the exchange rate provided for the receipt. | |
| ACCTD_AMOUNT_APPLIED_TO | NUMBER | Amount applied to the transaction in functional currency. Converted using the exchange rate provided for the transaction. | ||
| ACCTD_EARNED_DISCOUNT_TAKEN | NUMBER | Earned discount amount in the functional currency converted using the transaction exchange rate. | ||
| 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 | |
| CONFIRMED_FLAG | VARCHAR2 | (1) | Null or Y when the cash receipt is confirmed, N if the cash receipt is not confirmed. Always use nvl (CONFIRMED_FLAG is Y) when checking this column. | |
| PROGRAM_APPLICATION_ID | NUMBER | (15) | Concurrent program who column. Application identifier of the program that last updated this row. | |
| PROGRAM_ID | NUMBER | (15) | Concurrent program who column. Identifier of the program that last updated this row. | |
| PROGRAM_UPDATE_DATE | DATE | Concurrent program who column. Date when a program last updated this row. | ||
| REQUEST_ID | NUMBER | (15) | Concurrent program who column. Identifier of the concurrent request that last updated this row. | |
| USSGL_TRANSACTION_CODE | VARCHAR2 | (30) | Code defined by public sector accounting | |
| USSGL_TRANSACTION_CODE_CONTEXT | VARCHAR2 | (30) | Context value for the USSGL Transaction Code Flexfield | |
| EARNED_DISCOUNT_CCID | NUMBER | (15) | General Ledger code combination for the earned discount | |
| UNEARNED_DISCOUNT_CCID | NUMBER | (15) | 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 | General Ledger account date for the records that have been reversed and for the reversing record as well. | ||
| CASH_RECEIPT_HISTORY_ID | NUMBER | (15) | Foreign key to the AR_CASH_RECEIPT_HISTORY table identifying the row that was current when the receivable application was created | |
| ORG_ID | NUMBER | (15) | Operating unit identifier | |
| TAX_CODE | VARCHAR2 | (50) | No longer in use. | |
| 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 | |
| GLOBAL_ATTRIBUTE_CATEGORY | VARCHAR2 | (30) | Reserved for country-specific functionality | |
| CONS_INV_ID | NUMBER | (15) | Internal identifier of the balance forward bill to which the receipt is applied. | |
| CONS_INV_ID_TO | NUMBER | (15) | 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 | Identifier of the application rule set used to apply this record. | ||
| LINE_EDISCOUNTED | NUMBER | Amount of earned discount attributable to line amount of the transaction. | ||
| TAX_EDISCOUNTED | NUMBER | Amount of earned discount attributable to tax amount of the transaction. | ||
| FREIGHT_EDISCOUNTED | NUMBER | Amount of earned discount attributable to freight amount of the transaction. | ||
| CHARGES_EDISCOUNTED | NUMBER | Amount of earned discount attributable to charged amount of the transaction. | ||
| LINE_UEDISCOUNTED | NUMBER | Amount of unearned discount attributable to line amount of the transaction. | ||
| TAX_UEDISCOUNTED | NUMBER | Amount of unearned discount attributable to tax amount of the transaction. | ||
| FREIGHT_UEDISCOUNTED | NUMBER | Amount of unearned discount attributable to freight amount of the transaction. | ||
| CHARGES_UEDISCOUNTED | NUMBER | Amount of unearned discount attributable to charged amount of the transaction. | ||
| RECEIVABLES_TRX_ID | NUMBER | (15) | Internal identifier of receivable transaction. | |
| ON_ACCOUNT_CUSTOMER | NUMBER | (15) | No longer in use. | |
| MRC_AMOUNT_APPLIED | VARCHAR2 | (2000) | No longer in use. Multiple Reporting Currencies columns are obsolete in R12. Accounting information for reporting currency is stored in Subledger Accounting tables in R12. | |
| MRC_AMOUNT_APPLIED_FROM | VARCHAR2 | (2000) | No longer in use. Multiple Reporting Currencies columns are obsolete in R12. Accounting information for reporting currency is stored in Subledger Accounting tables in R12. | |
| MRC_DISPLAY | VARCHAR2 | (2000) | No longer in use. Multiple Reporting Currencies columns are obsolete in R12. Accounting information for reporting currency is stored in Subledger Accounting tables in R12. | |
| MRC_STATUS | VARCHAR2 | (2000) | No longer in use. Multiple Reporting Currencies columns are obsolete in R12. Accounting information for reporting currency is stored in Subledger Accounting tables in R12. | |
| MRC_PAYMENT_SCHEDULE_ID | VARCHAR2 | (2000) | No longer in use. Multiple Reporting Currencies columns are obsolete in R12. Accounting information for reporting currency is stored in Subledger Accounting tables in R12. | |
| MRC_CASH_RECEIPT_ID | VARCHAR2 | (2000) | No longer in use. Multiple Reporting Currencies columns are obsolete in R12. Accounting information for reporting currency is stored in Subledger Accounting tables in R12. | |
| MRC_GL_POSTED_DATE | VARCHAR2 | (2000) | No longer in use. Multiple Reporting Currencies columns are obsolete in R12. Accounting information for reporting currency is stored in Subledger Accounting tables in R12. | |
| MRC_POSTING_CONTROL_ID | VARCHAR2 | (2000) | No longer in use. Multiple Reporting Currencies columns are obsolete in R12. Accounting information for reporting currency is stored in Subledger Accounting tables in R12. | |
| MRC_ACCTD_AMOUNT_APPLIED_FROM | VARCHAR2 | (2000) | No longer in use. Multiple Reporting Currencies columns are obsolete in R12. Accounting information for reporting currency is stored in Subledger Accounting tables in R12. | |
| MRC_ACCTD_AMOUNT_APPLIED_TO | VARCHAR2 | (2000) | No longer in use. Multiple Reporting Currencies columns are obsolete in R12. Accounting information for reporting currency is stored in Subledger Accounting tables in R12. | |
| MRC_ACCTD_EARNED_DISC_TAKEN | VARCHAR2 | (2000) | No longer in use. Multiple Reporting Currencies columns are obsolete in R12. Accounting information for reporting currency is stored in Subledger Accounting tables in R12. | |
| MRC_ACCTD_UNEARNED_DISC_TAKEN | VARCHAR2 | (2000) | No longer in use. Multiple Reporting Currencies columns are obsolete in R12. Accounting information for reporting currency is stored in Subledger Accounting tables in R12. | |
| EDISC_TAX_ACCT_RULE | VARCHAR2 | (3) | Used internally to setup receivable activity for earned discount. | |
| UNEDISC_TAX_ACCT_RULE | VARCHAR2 | (3) | Used internally to setup receivable activity for unearned discount. | |
| LINK_TO_TRX_HIST_ID | NUMBER | (15) | 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 | (15) | 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 | (15) | 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 | (15) | No longer in use | |
| SECONDARY_APPLICATION_REF_ID | NUMBER | (15) | Secondary application reference identifier of another transaction or application, such as a claim, that is associated with this receipt application | |
| PAYMENT_SET_ID | NUMBER | (15) | Internal identifier of 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 | |
| APPLIED_REC_APP_ID | NUMBER | (15) | For receipt-to-receipt application, stores the internal identifier of the receipt which is receiving the application. | |
| 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 | (15) | Identifier of the event created in Subledger Accounting for this record. | |
| UPGRADE_METHOD | VARCHAR2 | (30) | Upgrade flag to indicate the origin of the application | |
| AX_ACCOUNTED_FLAG | VARCHAR2 | (1) | ||
| Name | Datatype | Length | Mandatory | Comments |
|---|
Cut, paste (and edit) the following text to query this object:
SELECT RECEIVABLE_APPLICATION_ID
, LAST_UPDATED_BY
, LAST_UPDATE_DATE
, CREATED_BY
, CREATION_DATE
, AMOUNT_APPLIED
, AMOUNT_APPLIED_FROM
, TRANS_TO_RECEIPT_RATE
, GL_DATE
, CODE_COMBINATION_ID
, SET_OF_BOOKS_ID
, DISPLAY
, APPLY_DATE
, APPLICATION_TYPE
, STATUS
, PAYMENT_SCHEDULE_ID
, LAST_UPDATE_LOGIN
, CASH_RECEIPT_ID
, APPLIED_CUSTOMER_TRX_ID
, APPLIED_CUSTOMER_TRX_LINE_ID
, APPLIED_PAYMENT_SCHEDULE_ID
, CUSTOMER_TRX_ID
, LINE_APPLIED
, TAX_APPLIED
, FREIGHT_APPLIED
, RECEIVABLES_CHARGES_APPLIED
, EARNED_DISCOUNT_TAKEN
, UNEARNED_DISCOUNT_TAKEN
, DAYS_LATE
, APPLICATION_RULE
, GL_POSTED_DATE
, COMMENTS
, ATTRIBUTE_CATEGORY
, ATTRIBUTE1
, ATTRIBUTE2
, ATTRIBUTE3
, ATTRIBUTE4
, ATTRIBUTE5
, ATTRIBUTE6
, ATTRIBUTE7
, ATTRIBUTE8
, ATTRIBUTE9
, ATTRIBUTE10
, POSTABLE
, POSTING_CONTROL_ID
, ACCTD_AMOUNT_APPLIED_FROM
, ACCTD_AMOUNT_APPLIED_TO
, ACCTD_EARNED_DISCOUNT_TAKEN
, ATTRIBUTE11
, ATTRIBUTE12
, ATTRIBUTE13
, ATTRIBUTE14
, ATTRIBUTE15
, CONFIRMED_FLAG
, PROGRAM_APPLICATION_ID
, PROGRAM_ID
, PROGRAM_UPDATE_DATE
, REQUEST_ID
, USSGL_TRANSACTION_CODE
, USSGL_TRANSACTION_CODE_CONTEXT
, EARNED_DISCOUNT_CCID
, UNEARNED_DISCOUNT_CCID
, ACCTD_UNEARNED_DISCOUNT_TAKEN
, REVERSAL_GL_DATE
, CASH_RECEIPT_HISTORY_ID
, ORG_ID
, TAX_CODE
, 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
, GLOBAL_ATTRIBUTE_CATEGORY
, CONS_INV_ID
, CONS_INV_ID_TO
, RULE_SET_ID
, LINE_EDISCOUNTED
, TAX_EDISCOUNTED
, FREIGHT_EDISCOUNTED
, CHARGES_EDISCOUNTED
, LINE_UEDISCOUNTED
, TAX_UEDISCOUNTED
, FREIGHT_UEDISCOUNTED
, CHARGES_UEDISCOUNTED
, RECEIVABLES_TRX_ID
, ON_ACCOUNT_CUSTOMER
, MRC_AMOUNT_APPLIED
, MRC_AMOUNT_APPLIED_FROM
, MRC_DISPLAY
, MRC_STATUS
, MRC_PAYMENT_SCHEDULE_ID
, MRC_CASH_RECEIPT_ID
, MRC_GL_POSTED_DATE
, MRC_POSTING_CONTROL_ID
, MRC_ACCTD_AMOUNT_APPLIED_FROM
, MRC_ACCTD_AMOUNT_APPLIED_TO
, MRC_ACCTD_EARNED_DISC_TAKEN
, MRC_ACCTD_UNEARNED_DISC_TAKEN
, EDISC_TAX_ACCT_RULE
, UNEDISC_TAX_ACCT_RULE
, LINK_TO_TRX_HIST_ID
, LINK_TO_CUSTOMER_TRX_ID
, APPLICATION_REF_TYPE
, APPLICATION_REF_ID
, APPLICATION_REF_NUM
, CHARGEBACK_CUSTOMER_TRX_ID
, SECONDARY_APPLICATION_REF_ID
, PAYMENT_SET_ID
, APPLICATION_REF_REASON
, CUSTOMER_REFERENCE
, CUSTOMER_REASON
, APPLIED_REC_APP_ID
, SECONDARY_APPLICATION_REF_TYPE
, SECONDARY_APPLICATION_REF_NUM
, EVENT_ID
, UPGRADE_METHOD
, AX_ACCOUNTED_FLAG
FROM AR.AR_RECEIVABLE_APPLICATIONS_ALL;
AR.AR_RECEIVABLE_APPLICATIONS_ALL does not reference any database object
AR.AR_RECEIVABLE_APPLICATIONS_ALL is referenced by following:
APPS
AR_RECEIVABLE_APPLICATIONS
AR_RECEIVABLE_APPLICATIONS_ALL
AR_RECEIVABLE_APPLICATIONS_BRI
JAI_ARRA_ARIUD_TRG
JL_BR_AR_ASS_APPLN_ID_POPL
JL_BR_AR_OCC_DOCS_WRT_N_ABTMT1
|
|
|
|