[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 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:
{{"bul:1"}}APP - Applied
{{"bul:1"}}UNAPP - Unapplied
{{"bul:1"}}ACC - On-Account
{{"bul:1"}}UNID - Unidentified
{{"bul:1"}}ACTIVITY - Receivable Activity
{{"bul:1"}}OTHER ACC - Other Receipt Application
{{"bodytext"}}Receivables looks at the application status to determine which flexfield account to use. Receivables uses the CODE_COMBINATION_ID foreign key column to associate this payment with the Unidentified flexfield account. The CODE_COMBINATION_ID column stores valid Accounting Flexfield segment value combinations that are credited in General Ledger when this application is posted.
.
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 you reverse a cash application, 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 you 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 you are actually applying.
.
The APPLIED_CUSTOMER_TRX_ID and APPLIED_PAYMENT_SCHEDULE_ID columns identify the 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 that you are applying. The APPLIED_CUSTOMER_TRX_ID and APPLIED_PAYMENT_SCHEDULE_ID columns for this record belong to the invoice that is receiving the application.
.
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 that you are combining 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 that the receipt is applied against.
.
For more details, see Technical Perspective: Transactions (Oracle Receivables User Guide).
| 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
ORG_ID
STATUS
APPLICATION_TYPE
CONFIRMED_FLAG
|
| 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
|
| Name | Datatype | Length | Mandatory | Comments |
|---|---|---|---|---|
| RECEIVABLE_APPLICATION_ID | NUMBER | (15) | Yes | Identifies the receivable application |
| LAST_UPDATED_BY | NUMBER | (15) | Yes | Standard who column - user who last updated this row (foreign key to FND_USER.USER_ID). |
| 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 (foreign key to FND_USER.USER_ID). |
| 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 | Date that this application will post to the General Ledger | |
| CODE_COMBINATION_ID | NUMBER | (15) | Yes | General Ledger code combination (account) |
| SET_OF_BOOKS_ID | NUMBER | (15) | 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 | (15) | Yes | Identifies the payment schedule of the payment or credit memo that is being applied |
| LAST_UPDATE_LOGIN | NUMBER | (15) | Standard who column - operating system login of user who last updated this row (foreign key to FND_LOGINS.LOGIN_ID). | |
| CASH_RECEIPT_ID | NUMBER | (15) | Identifies the payment being applied | |
| APPLIED_CUSTOMER_TRX_ID | NUMBER | (15) | Identifies the debit item or credit memo to which a payment or credit memo is applied | |
| APPLIED_CUSTOMER_TRX_LINE_ID | NUMBER | (15) | The line number of the debit item or credit memo to which a payment or credit memo is applied | |
| APPLIED_PAYMENT_SCHEDULE_ID | NUMBER | (15) | Identifies the payment schedule of the debit item or credit memo that a payment or credit memo was applied to | |
| CUSTOMER_TRX_ID | NUMBER | (15) | 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 | (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) | User's comments | |
| ATTRIBUTE_CATEGORY | VARCHAR2 | (30) | 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 | |
| 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 |
| 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 | |
| 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 id of the program that last updated this row (foreign key to FND_APPLICATION.APPLICATION_ID). | |
| PROGRAM_ID | NUMBER | (15) | 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 | (15) | Concurrent Program who column - concurrent request id of the program that last updated this row (foreign key to FND_CONCURRENT_REQUESTS.REQUEST_ID). | |
| 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 | This column is filled in 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) | Organization identifier | |
| TAX_CODE | VARCHAR2 | (50) | Tax code for on-account transactions | |
| 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) | Consolidated invoice ID against which this adjustment appears | |
| 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 | The application rule set ID | ||
| 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 | (15) | Identifier of receivable activity. | |
| ON_ACCOUNT_CUSTOMER | NUMBER | (15) | No longer used | |
| MRC_AMOUNT_APPLIED | VARCHAR2 | (2000) | MRC only: Concatenated string of reporting set of books ID, total amount of the application pairs | |
| MRC_AMOUNT_APPLIED_FROM | VARCHAR2 | (2000) | MRC only: Concatenated string of reporting set of books ID, total amount of the application in the currency of the receipt pairs | |
| MRC_DISPLAY | VARCHAR2 | (2000) | MRC only: Concatenated string of reporting set of books ID, Y/N flag to indicate the latest application pairs | |
| MRC_STATUS | VARCHAR2 | (2000) | MRC only: Concatenated string of reporting set of books ID, lookup type for the status of the application pairs | |
| MRC_PAYMENT_SCHEDULE_ID | VARCHAR2 | (2000) | MRC only: Concatenated string of reporting set of books ID, payment schedule identifier or credit memo being applied pairs | |
| MRC_CASH_RECEIPT_ID | VARCHAR2 | (2000) | MRC only: Concatenated string of reporting set of books ID, payment identifier being applied pairs | |
| MRC_GL_POSTED_DATE | VARCHAR2 | (2000) | MRC only: Concatenated string of reporting set of books ID, receivable posting batch identifier pairs | |
| MRC_POSTING_CONTROL_ID | VARCHAR2 | (2000) | MRC only: Concatenated string of reporting set of books ID, receivable posting batch identifier pairs | |
| MRC_ACCTD_AMOUNT_APPLIED_FROM | VARCHAR2 | (2000) | MRC only: Concatenated string of reporting set of books ID, amount of the source converted pairs | |
| MRC_ACCTD_AMOUNT_APPLIED_TO | VARCHAR2 | (2000) | MRC only: Concatenated string of reporting set of books ID, amount applied to item converted pairs | |
| MRC_ACCTD_EARNED_DISC_TAKEN | VARCHAR2 | (2000) | MRC only: Concatenated string of reporting set of books ID, earned discount equivalent in the reporting currency(s) pairs | |
| MRC_ACCTD_UNEARNED_DISC_TAKEN | VARCHAR2 | (2000) | MRC only: Concatenated string of reporting set of books ID unearned discount equivalent in the reporting currency(s) pairs | |
| 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 | (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 | (150) | User-visible application reference number whose context is determined by the APPLICATION_REF_TYPE column's value | |
| CHARGEBACK_CUSTOMER_TRX_ID | NUMBER | (15) | OBSOLETED | |
| 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) | 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 | |
| APPLIED_REC_APP_ID | NUMBER | (15) | 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 | (150) | User-visible application reference number whose context is determined by the SECONDARY_APPLICATION_REF_TYPE column's value | |
| EVENT_ID | NUMBER | (15) | SLA event_id | |
| UPGRADE_METHOD | VARCHAR2 | (30) | Upgrade flag to indicate the origin of the application | |
| AX_ACCOUNTED_FLAG | VARCHAR2 | (1) | ||
| INCLUDE_IN_ACCUMULATION | VARCHAR2 | (1) | Flag to include in acucmulation or not | |
| ON_ACCT_CUST_ID | NUMBER | (15) | On account customer id | |
| ON_ACCT_CUST_SITE_USE_ID | NUMBER | (15) | On account customer site use id | |
| ON_ACCT_PO_NUM | VARCHAR2 | (50) | On account PO number |
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
, INCLUDE_IN_ACCUMULATION
, ON_ACCT_CUST_ID
, ON_ACCT_CUST_SITE_USE_ID
, ON_ACCT_PO_NUM
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:
AR
AR_RECEIVABLE_APPLICATIONS_AL#
|
|
|
|