[Home] [Help] [Dependency Information]
Object Name: | AR_CASH_RECEIPTS_MRC_V |
---|---|
Object Type: | VIEW |
Owner: | APPS |
FND Design Data: | AR.AR_CASH_RECEIPTS_MRC_V |
Subobject Name: | |
Status: | VALID |
A multiple reporting currency view
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
CASH_RECEIPT_ID | NUMBER | (15) | Yes | |
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 | ||
CURRENCY_CODE | VARCHAR2 | (15) | Yes | |
RECEIVABLES_TRX_ID | NUMBER | (15) | ||
PAY_FROM_CUSTOMER | NUMBER | (15) | ||
STATUS | VARCHAR2 | (30) | ||
TYPE | VARCHAR2 | (20) | ||
RECEIPT_NUMBER | VARCHAR2 | (30) | ||
RECEIPT_DATE | DATE | Yes | ||
MISC_PAYMENT_SOURCE | VARCHAR2 | (30) | ||
COMMENTS | VARCHAR2 | (2000) | ||
DISTRIBUTION_SET_ID | NUMBER | (15) | ||
REVERSAL_DATE | DATE | |||
REVERSAL_CATEGORY | VARCHAR2 | (20) | ||
REVERSAL_REASON_CODE | VARCHAR2 | (30) | ||
REVERSAL_COMMENTS | VARCHAR2 | (240) | ||
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) | ||
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) | ||
CUSTOMER_BANK_ACCOUNT_ID | NUMBER | (15) | ||
CUSTOMER_SITE_USE_ID | NUMBER | (15) | ||
DEPOSIT_DATE | DATE | |||
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 | |
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) | ||
SELECTED_REMITTANCE_BATCH_ID | NUMBER | (15) | ||
FACTOR_DISCOUNT_AMOUNT | NUMBER | |||
USSGL_TRANSACTION_CODE | VARCHAR2 | (30) | ||
USSGL_TRANSACTION_CODE_CONTEXT | VARCHAR2 | (30) | ||
DOC_SEQUENCE_VALUE | NUMBER | (15) | ||
DOC_SEQUENCE_ID | NUMBER | (15) | ||
VAT_TAX_ID | NUMBER | (15) | ||
REFERENCE_TYPE | VARCHAR2 | (30) | ||
REFERENCE_ID | NUMBER | (15) | ||
CUSTOMER_RECEIPT_REFERENCE | VARCHAR2 | (30) | ||
OVERRIDE_REMIT_ACCOUNT_FLAG | VARCHAR2 | (1) | ||
ORG_ID | NUMBER | (15) | Organization identifier | |
ANTICIPATED_CLEARING_DATE | DATE | Anticipated clearing date of receipt | ||
GLOBAL_ATTRIBUTE1 | VARCHAR2 | (150) | Reserved For Globalization Functionality | |
GLOBAL_ATTRIBUTE2 | VARCHAR2 | (150) | Reserved For Globalization Functionality | |
GLOBAL_ATTRIBUTE3 | VARCHAR2 | (150) | Reserved For Globalization Functionality | |
GLOBAL_ATTRIBUTE4 | VARCHAR2 | (150) | Reserved For Globalization Functionality | |
GLOBAL_ATTRIBUTE5 | VARCHAR2 | (150) | Reserved For Globalization Functionality | |
GLOBAL_ATTRIBUTE6 | VARCHAR2 | (150) | Reserved For Globalization Functionality | |
GLOBAL_ATTRIBUTE7 | VARCHAR2 | (150) | Reserved For Globalization Functionality | |
GLOBAL_ATTRIBUTE8 | VARCHAR2 | (150) | Reserved For Globalization Functionality | |
GLOBAL_ATTRIBUTE9 | VARCHAR2 | (150) | Reserved For Globalization Functionality | |
GLOBAL_ATTRIBUTE10 | VARCHAR2 | (150) | Reserved For Globalization Functionality | |
GLOBAL_ATTRIBUTE11 | VARCHAR2 | (150) | Reserved For Globalization Functionality | |
GLOBAL_ATTRIBUTE12 | VARCHAR2 | (150) | Reserved For Globalization Functionality | |
GLOBAL_ATTRIBUTE13 | VARCHAR2 | (150) | Reserved For Globalization Functionality | |
GLOBAL_ATTRIBUTE14 | VARCHAR2 | (150) | Reserved For Globalization Functionality | |
GLOBAL_ATTRIBUTE15 | VARCHAR2 | (150) | Reserved For Globalization Functionality | |
GLOBAL_ATTRIBUTE16 | VARCHAR2 | (150) | Reserved For Globalization Functionality | |
GLOBAL_ATTRIBUTE17 | VARCHAR2 | (150) | Reserved For Globalization Functionality | |
GLOBAL_ATTRIBUTE18 | VARCHAR2 | (150) | Reserved For Globalization Functionality | |
GLOBAL_ATTRIBUTE19 | VARCHAR2 | (150) | Reserved For Globalization Functionality | |
GLOBAL_ATTRIBUTE20 | VARCHAR2 | (150) | Reserved For Globalization Functionality | |
GLOBAL_ATTRIBUTE_CATEGORY | VARCHAR2 | (30) | Reserved For Globalization Functionality | |
ISSUER_NAME | VARCHAR2 | (50) | Original issuer of the Notes Receivable | |
ISSUE_DATE | DATE | Date on which the Notes Receivable was originally issued. | ||
ISSUER_BANK_BRANCH_ID | NUMBER | (15) | Bank and branch which originally issued the notes receivable. | |
CUSTOMER_BANK_BRANCH_ID | NUMBER | (15) | ||
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 | Stores tax rate when user has overridden ad hoc tax. | ||
ACTUAL_VALUE_DATE | DATE | Bank Statement Value Date | ||
POSTMARK_DATE | DATE | The postmark date of the Receipt. Updated for record type 6. Used for discount calculation |
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
, PAYMENT_SERVER_ORDER_NUM
, APPROVAL_CODE
, ADDRESS_VERIFICATION_CODE
, TAX_RATE
, ACTUAL_VALUE_DATE
, POSTMARK_DATE
FROM APPS.AR_CASH_RECEIPTS_MRC_V;
APPS.AR_CASH_RECEIPTS_MRC_V is not referenced by any database object
|
|
|