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

VIEW: APPS.AR_CASH_RECEIPTS_ALL_MRC_V

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

View Type

A multiple reporting currency view

[View Source]

Columns
Name Datatype Length Mandatory Comments
CASH_RECEIPT_ID NUMBER (15) Yes Identifier of the cash receipt
SET_OF_BOOKS_ID NUMBER (15) Yes Set of Books identifier
EXCHANGE_RATE_TYPE VARCHAR2 (30)
Conversion type used to convert foreign currency transactions
EXCHANGE_RATE NUMBER

Currency conversion rate used to convert the transactional currency amount to reporting currency amount
EXCHANGE_DATE DATE

Currency conversion date used to convert the transactional currency amount to reporting currency amount
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.
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).
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 NUMBER
Yes Amount of the payment entry, denormalized from the history record to allow querying on amount
CURRENCY_CODE VARCHAR2 (15) Yes Currency code of the payment batch associated with this payment entry
RECEIVABLES_TRX_ID NUMBER (15)
Identifier of the transaction associated with this payment entry
PAY_FROM_CUSTOMER NUMBER (15)
Identifier of the customer associated with this payment entry
STATUS VARCHAR2 (30)
Identifies whether the status of this payment entry is applied, unapplied, unidentified, insufficient funds, reverse payment or stop payment
TYPE VARCHAR2 (20)
Identifies the category of the payment entry - either CASH or MISC; when coding, please use = 'MISC' or != 'MISC' (instead of = 'CASH') because of internal customization
RECEIPT_NUMBER VARCHAR2 (30)
Cash receipt number
RECEIPT_DATE DATE
Yes Date of the payment entry
MISC_PAYMENT_SOURCE VARCHAR2 (30)
Identifies the source of the miscellaneous receipt
COMMENTS VARCHAR2 (2000)
Comments about this receipt record
DISTRIBUTION_SET_ID NUMBER (15)
Identifier of the distribution set associated with this payment entry
REVERSAL_DATE DATE

Date payment entry reversed
REVERSAL_CATEGORY VARCHAR2 (20)
Identifies the reason why the payment entry was reversed
REVERSAL_REASON_CODE VARCHAR2 (30)
Indicates reason for reversing receipt, defined by user
REVERSAL_COMMENTS VARCHAR2 (240)
Comments regarding reversal
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
REMITTANCE_BANK_ACCOUNT_ID NUMBER (15)
Identifies the user's bank account for depositing the receipt
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)
This is null or Y when the cash receipt is confirmed. It is N if the cash receipt is not confirmed. Always use null value (confirmed_flag,'Y') when checking this column.
CUSTOMER_BANK_ACCOUNT_ID NUMBER (15)
Identifies the customer's bank account from where the receipt was paid
CUSTOMER_SITE_USE_ID NUMBER (15)
Identifies the customer's location
DEPOSIT_DATE DATE

This will be a user column, and will have no significance within the system
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).
RECEIPT_METHOD_ID NUMBER (15) Yes Identifies the payment method of the receipt
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).
SELECTED_FOR_FACTORING_FLAG VARCHAR2 (1)
Indicates if the receipt amount is discounted
SELECTED_REMITTANCE_BATCH_ID NUMBER (15)
Identifies the batch created by the receipt remitting process
FACTOR_DISCOUNT_AMOUNT NUMBER

The amount determined to factor the receipt
USSGL_TRANSACTION_CODE VARCHAR2 (30)
Code defined by public sector accounting
USSGL_TRANSACTION_CODE_CONTEXT VARCHAR2 (30)
Descriptive Flexfield structure defining column for public sector accounting
DOC_SEQUENCE_VALUE NUMBER (15)
Value assigned to document receipt
DOC_SEQUENCE_ID NUMBER (15)
Identifies database sequence used to assign document number to receipt
VAT_TAX_ID NUMBER (15)
This column refers to the VAT tax that this miscellaneous receipt is subject
REFERENCE_TYPE VARCHAR2 (30)
Indicates if this Miscellaneous Receipts is a PAYMENT, RECEIPT, or REMITTANCE
REFERENCE_ID NUMBER (15)
Foreign key to the AR_BATCHES, AR_CASH_RECEIPTS, or AP_CHECKS tables
CUSTOMER_RECEIPT_REFERENCE VARCHAR2 (30)
This column is used to store a customer reference value that the customer supplies at confirmation time
OVERRIDE_REMIT_ACCOUNT_FLAG VARCHAR2 (1)
This flag is Y when the remittance bank account is overridable by the remittance selection process and N when it is not. When it is null, it should be treated as Y.
ORG_ID NUMBER (15)
Organization identifier
ANTICIPATED_CLEARING_DATE DATE

Date the receipt is expected to clear the bank
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
ISSUER_NAME VARCHAR2 (50)
Issuer name of Notes Receivable (Asia Pacific requirement)
ISSUE_DATE DATE

Date this Note Receivable was issued (Asia Pacific requirement)
ISSUER_BANK_BRANCH_ID NUMBER (15)
Bank / Branch issuing the Note Receivable (Asia Pacific requirement)
CUSTOMER_BANK_BRANCH_ID NUMBER (15)
Unique identifier for customer bank branch ID
MRC_EXCHANGE_RATE_TYPE VARCHAR2 (2000)
Multiple Reporting Currencies only: Concatenated string of reporting set of books ID, currency conversion rate type pairs
MRC_EXCHANGE_RATE VARCHAR2 (2000)
Multiple Reporting Currencies only: Concatenated string of reporting set of books ID, currency conversion rate pairs
MRC_EXCHANGE_DATE VARCHAR2 (2000)
Multiple Reporting Currencies only: Concatenated string of reporting set of books ID, currency conversion date pairs
PAYMENT_SERVER_ORDER_NUM VARCHAR2 (80)
Identifies credit card payment authorized by Oracle Payment Server
APPROVAL_CODE VARCHAR2 (80)
Payment approval code from credit card issuer
ADDRESS_VERIFICATION_CODE VARCHAR2 (80)
Credit card address verification code from Oracle Payment Server
TAX_RATE NUMBER

The new tax rate entered when you override the rate for an ad hoc tax code
ACTUAL_VALUE_DATE DATE

The date cash is withdrawn or deposited in a bank account
POSTMARK_DATE DATE

The postmark date of the Receipt. Updated for record type 6. Used for discount calculation
APPLICATION_NOTES VARCHAR2 (2000)
Reference number that could not be matched to a transaction number during AutoLockbox validation.
UNIQUE_REFERENCE VARCHAR2 (32)
Unique Identifier for Credit Card Receipts Please re-create the multi-org view AR_CASH_RECEIPTS to include the new column UNIQUE_REFERENCE.
PROMISE_SOURCE VARCHAR2 (30)
Source that generated this promise to pay
REC_VERSION_NUMBER NUMBER (15)
Indicates receipt version number for audit purposes
REMIT_BANK_ACCT_USE_ID NUMBER (15)
The unique identifier of the remittance bank account use id to which the automatic receipt will be deposited
Query Text

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


SELECT CASH_RECEIPT_ID
,      SET_OF_BOOKS_ID
,      EXCHANGE_RATE_TYPE
,      EXCHANGE_RATE
,      EXCHANGE_DATE
,      LAST_UPDATED_BY
,      LAST_UPDATE_DATE
,      LAST_UPDATE_LOGIN
,      CREATED_BY
,      CREATION_DATE
,      AMOUNT
,      CURRENCY_CODE
,      RECEIVABLES_TRX_ID
,      PAY_FROM_CUSTOMER
,      STATUS
,      TYPE
,      RECEIPT_NUMBER
,      RECEIPT_DATE
,      MISC_PAYMENT_SOURCE
,      COMMENTS
,      DISTRIBUTION_SET_ID
,      REVERSAL_DATE
,      REVERSAL_CATEGORY
,      REVERSAL_REASON_CODE
,      REVERSAL_COMMENTS
,      ATTRIBUTE_CATEGORY
,      ATTRIBUTE1
,      ATTRIBUTE2
,      ATTRIBUTE3
,      ATTRIBUTE4
,      ATTRIBUTE5
,      ATTRIBUTE6
,      ATTRIBUTE7
,      ATTRIBUTE8
,      ATTRIBUTE9
,      ATTRIBUTE10
,      REMITTANCE_BANK_ACCOUNT_ID
,      ATTRIBUTE11
,      ATTRIBUTE12
,      ATTRIBUTE13
,      ATTRIBUTE14
,      ATTRIBUTE15
,      CONFIRMED_FLAG
,      CUSTOMER_BANK_ACCOUNT_ID
,      CUSTOMER_SITE_USE_ID
,      DEPOSIT_DATE
,      PROGRAM_APPLICATION_ID
,      PROGRAM_ID
,      PROGRAM_UPDATE_DATE
,      RECEIPT_METHOD_ID
,      REQUEST_ID
,      SELECTED_FOR_FACTORING_FLAG
,      SELECTED_REMITTANCE_BATCH_ID
,      FACTOR_DISCOUNT_AMOUNT
,      USSGL_TRANSACTION_CODE
,      USSGL_TRANSACTION_CODE_CONTEXT
,      DOC_SEQUENCE_VALUE
,      DOC_SEQUENCE_ID
,      VAT_TAX_ID
,      REFERENCE_TYPE
,      REFERENCE_ID
,      CUSTOMER_RECEIPT_REFERENCE
,      OVERRIDE_REMIT_ACCOUNT_FLAG
,      ORG_ID
,      ANTICIPATED_CLEARING_DATE
,      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
,      ISSUER_NAME
,      ISSUE_DATE
,      ISSUER_BANK_BRANCH_ID
,      CUSTOMER_BANK_BRANCH_ID
,      MRC_EXCHANGE_RATE_TYPE
,      MRC_EXCHANGE_RATE
,      MRC_EXCHANGE_DATE
,      PAYMENT_SERVER_ORDER_NUM
,      APPROVAL_CODE
,      ADDRESS_VERIFICATION_CODE
,      TAX_RATE
,      ACTUAL_VALUE_DATE
,      POSTMARK_DATE
,      APPLICATION_NOTES
,      UNIQUE_REFERENCE
,      PROMISE_SOURCE
,      REC_VERSION_NUMBER
,      REMIT_BANK_ACCT_USE_ID
FROM APPS.AR_CASH_RECEIPTS_ALL_MRC_V;

Dependencies

[top of page]

APPS.AR_CASH_RECEIPTS_ALL_MRC_V references the following:

SchemaAPPS
SynonymAR_CASH_RECEIPTS_ALL
SynonymAR_MC_CASH_RECEIPTS
APPS.AR_CASH_RECEIPTS_ALL_MRC_V is referenced by following:

SchemaAPPS
ViewAR_AEL_SL_REC_MRC_V