DBA Data[Home] [Help] [Dependency Information]

VIEW: APPS.AR_RECEIVABLE_APPS_ALL_MRC_V

Object Details
Object Name: AR_RECEIVABLE_APPS_ALL_MRC_V
Object Type: VIEW
Owner: APPS
FND Design Data: ViewAR.AR_RECEIVABLE_APPS_ALL_MRC_V
Subobject Name:
Status: VALID

View Type

A multiple reporting currency view

[View Source]

Columns
Name Datatype Length Mandatory Comments
RECEIVABLE_APPLICATION_ID NUMBER (15) Yes Identifies the receivable application
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).
SET_OF_BOOKS_ID NUMBER (15) Yes Set of Books identifier
DISPLAY VARCHAR2 (1) Yes Y or N flag to indicate whether this is the latest 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
CASH_RECEIPT_ID NUMBER (15)
Identifies the payment being applied
GL_POSTED_DATE DATE

Date this record was transferred 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 Portion of receipt allocated to transaction in receipt currency. Only populated for APP and UNAPP rows that are part of a cross-currency application.
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
ACCTD_UNEARNED_DISCOUNT_TAKEN NUMBER

Unearned discount equivalent in the functional currency obtained using the invoice exchange rate
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.
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)
APPLY_DATE DATE
Yes Date the application was applied
APPLICATION_TYPE VARCHAR2 (20) Yes Lookup code for the type of application
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).
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
ON_ACCOUNT_CUSTOMER NUMBER (15)
No longer used
RECEIVABLES_TRX_ID NUMBER (15)
Identifier of receivable activity.
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
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
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
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
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
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_CASH_RECEIPT_ID VARCHAR2 (2000)
MRC only: Concatenated string of reporting set of books ID, payment identifier being applied 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_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_STATUS VARCHAR2 (2000)
MRC only: Concatenated string of reporting set of books ID, lookup type for the status of the application 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_ID NUMBER (15)
APPLICATION_REF_NUM VARCHAR2 (150)
APPLICATION_REF_REASON VARCHAR2 (30)
APPLICATION_REF_TYPE VARCHAR2 (30)
CHARGEBACK_CUSTOMER_TRX_ID NUMBER (15)
CUSTOMER_REFERENCE VARCHAR2 (100)
PAYMENT_SET_ID NUMBER (15)
SECONDARY_APPLICATION_REF_ID NUMBER (15)
CUSTOMER_REASON VARCHAR2 (30)
APPLIED_REC_APP_ID NUMBER (15)
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
Query Text

Cut, paste (and edit) the following text to query this object:


SELECT RECEIVABLE_APPLICATION_ID
,      AMOUNT_APPLIED
,      AMOUNT_APPLIED_FROM
,      SET_OF_BOOKS_ID
,      DISPLAY
,      STATUS
,      PAYMENT_SCHEDULE_ID
,      CASH_RECEIPT_ID
,      GL_POSTED_DATE
,      POSTING_CONTROL_ID
,      ACCTD_AMOUNT_APPLIED_FROM
,      ACCTD_AMOUNT_APPLIED_TO
,      ACCTD_EARNED_DISCOUNT_TAKEN
,      ACCTD_UNEARNED_DISCOUNT_TAKEN
,      LAST_UPDATED_BY
,      LAST_UPDATE_DATE
,      CREATED_BY
,      CREATION_DATE
,      TRANS_TO_RECEIPT_RATE
,      GL_DATE
,      CODE_COMBINATION_ID
,      APPLY_DATE
,      APPLICATION_TYPE
,      LAST_UPDATE_LOGIN
,      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
,      ON_ACCOUNT_CUSTOMER
,      RECEIVABLES_TRX_ID
,      EARNED_DISCOUNT_TAKEN
,      UNEARNED_DISCOUNT_TAKEN
,      DAYS_LATE
,      APPLICATION_RULE
,      COMMENTS
,      ATTRIBUTE_CATEGORY
,      ATTRIBUTE1
,      ATTRIBUTE2
,      ATTRIBUTE3
,      ATTRIBUTE4
,      ATTRIBUTE5
,      ATTRIBUTE6
,      ATTRIBUTE7
,      ATTRIBUTE8
,      ATTRIBUTE9
,      ATTRIBUTE10
,      POSTABLE
,      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
,      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
,      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
,      MRC_AMOUNT_APPLIED
,      MRC_AMOUNT_APPLIED_FROM
,      MRC_CASH_RECEIPT_ID
,      MRC_DISPLAY
,      MRC_PAYMENT_SCHEDULE_ID
,      MRC_STATUS
,      EDISC_TAX_ACCT_RULE
,      UNEDISC_TAX_ACCT_RULE
,      LINK_TO_TRX_HIST_ID
,      LINK_TO_CUSTOMER_TRX_ID
,      APPLICATION_REF_ID
,      APPLICATION_REF_NUM
,      APPLICATION_REF_REASON
,      APPLICATION_REF_TYPE
,      CHARGEBACK_CUSTOMER_TRX_ID
,      CUSTOMER_REFERENCE
,      PAYMENT_SET_ID
,      SECONDARY_APPLICATION_REF_ID
,      CUSTOMER_REASON
,      APPLIED_REC_APP_ID
,      SECONDARY_APPLICATION_REF_TYPE
,      SECONDARY_APPLICATION_REF_NUM
FROM APPS.AR_RECEIVABLE_APPS_ALL_MRC_V;

Dependencies

[top of page]

APPS.AR_RECEIVABLE_APPS_ALL_MRC_V references the following:

SchemaAPPS
SynonymAR_MC_RECEIVABLE_APPS
SynonymAR_RECEIVABLE_APPLICATIONS_ALL
APPS.AR_RECEIVABLE_APPS_ALL_MRC_V is referenced by following:

SchemaAPPS
ViewAR_AEL_SL_INV_MRC_V
ViewAR_AEL_SL_REC_MRC_V