[Home] [Help] [Dependency Information]
Object Name: | AR_RECEIVABLE_APPS_ALL_MRC_V |
---|---|
Object Type: | VIEW |
Owner: | APPS |
FND Design Data: | AR.AR_RECEIVABLE_APPS_ALL_MRC_V |
Subobject Name: | |
Status: | VALID |
A multiple reporting currency view
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 | (30) | ||
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 | (30) | User-visible application reference number whose context is determined by the SECONDARY_APPLICATION_REF_TYPE column's value |
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;
|
|
|