[Home] [Help]
[Dependency Information]
[Home] [Help]
[Dependency Information]
| Object Name: | AR_CASH_RECEIPT_HIST_MRC_V |
|---|---|
| Object Type: | VIEW |
| Owner: | APPS |
| FND Design Data: |  AR.AR_CASH_RECEIPT_HIST_MRC_V
|
| Subobject Name: | |
| Status: | VALID |
A multiple reporting currency view
| Name | Datatype | Length | Mandatory | Comments |
|---|---|---|---|---|
| CASH_RECEIPT_HISTORY_ID | NUMBER | (15) | Yes | Cash receipt history identifier |
| SET_OF_BOOKS_ID | NUMBER | (15) | Yes | Set of Books identifier |
| CASH_RECEIPT_ID | NUMBER | (15) | Yes | MRC only: Concatenated string of reporting set of books ID, cash receipt identifier pairs |
| FIRST_POSTED_RECORD_FLAG | VARCHAR2 | (1) | Yes | This is Y if this is the first row that is posted for this cash receipts; N otherwise. |
| POSTING_CONTROL_ID | NUMBER | (15) | Yes | Receivables posting batch identifier, -1, -2, and -4 for posted in previous releases and -3 for not posted |
| REVERSAL_POSTING_CONTROL_ID | NUMBER | (15) | Receivables posting batch identifier; -1 means it was posted by the old posting program (ARXGLP); -2 means it's posted from RA; -3 means it's not posted; this should be null if reversal_gl_date is null. | |
| GL_POSTED_DATE | DATE | Date this record was transferred to the General Ledger | ||
| REVERSAL_GL_POSTED_DATE | DATE | Date this record was transferred to the General Ledger | ||
| ACCTD_AMOUNT | NUMBER | Yes | Receipt amount in functional currency | |
| ACCTD_FACTOR_DISCOUNT_AMOUNT | NUMBER | FACTOR_DISCOUNT_AMOUNT in functional currency | ||
| EXCHANGE_DATE | DATE | Currency conversion date used to convert the transactional currency amount to reporting currency amount | ||
| EXCHANGE_RATE | NUMBER | Currency conversion rate used to convert the transactional currency amount to reporting currency amount | ||
| EXCHANGE_RATE_TYPE | VARCHAR2 | (30) | Currency conversion type used to convert the transactional currency amount to reporting currency amount | |
| CREATED_FROM | VARCHAR2 | (30) | Yes | Populated by code that points to form or program that created this row |
| STATUS | VARCHAR2 | (30) | Yes | One of the following: APPROVED, CONFIRMED, REMITTED, CLEARED, REVERSED |
| TRX_DATE | DATE | Yes | The transaction date when this history row occurs as entered by the user | |
| AMOUNT | NUMBER | Yes | The amount for this step of the life cycle of the receipt. Most of the amounts will be similar to the original amount of the cash receipt but the cleared amount might be different from the remitted due to any charges the bank took. | |
| POSTABLE_FLAG | VARCHAR2 | (1) | Yes | This is Y if the row is postable and N otherwise. It is N for the approved row and N for the REVERSED row. It is Y for all the other statuses. |
| FACTOR_FLAG | VARCHAR2 | (1) | Yes | This is Y if the status is REMITTED and the cash receipt was factored as specified by the user on the remittance step. |
| GL_DATE | DATE | Yes | The General Ledger Date that is used when debiting the ACCOUNT_CODE_COMBINATION_ID | |
| CURRENT_RECORD_FLAG | VARCHAR2 | (1) | This is Y if this row is the latest step for this cash receipt; it is null otherwise. | |
| BATCH_ID | NUMBER | (15) | This is a foreign key to the AR_BATCHES table that points to the batch that was used to create this row for this cash receipt. | |
| ACCOUNT_CODE_COMBINATION_ID | NUMBER | (15) | This is the account that is either debited or credited (on the GL_DATE and REVERSAL_GL_DATE respectively). | |
| REVERSAL_GL_DATE | DATE | This is the General Ledger Date that is used to credit the ACCOUNT_CODE_COMBINATION_ID. It also signifies that this row has been reversed. It could mean that the receipt went on to the next step or reverted one step. | ||
| REVERSAL_CASH_RECEIPT_HIST_ID | NUMBER | (15) | This is a unique key that sequences the reversal of this row and is sourced from the same sequence as CASH_RECEIPT_HISTORY_ID. | |
| FACTOR_DISCOUNT_AMOUNT | NUMBER | This is the amount of the bank charge and/or factor discount taken by the bank at clearance and/or factoring time. | ||
| BANK_CHARGE_ACCOUNT_CCID | NUMBER | (15) | This is the account that is debited and/or credited for the FACTOR_DISCOUNT_AMOUNT. | |
| 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. | |
| LAST_UPDATE_DATE | DATE | Yes | Standard Who column - date when a user last updated this row. | |
| 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). | |
| LAST_UPDATED_BY | NUMBER | (15) | Standard who column - user who last updated this row (foreign key to FND_USER.USER_ID). | |
| PRV_STAT_CASH_RECEIPT_HIST_ID | NUMBER | (15) | This column has the CASH_RECEIPT_HISTORY_ID of the record that precedes the current record in status. Normally, it is the ID of the reversed record. For rate adjustments, it has the same value as that of the record it reversed/adjusted. | |
| REVERSAL_CREATED_FROM | VARCHAR2 | (30) | Populated by code that points to form or program that reversed this row | |
| 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 | |
| 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 | |
| ATTRIBUTE_CATEGORY | VARCHAR2 | (30) | Descriptive flexfield structure definition column. | |
| NOTE_STATUS | VARCHAR2 | (30) | The state of the Note Receivable | |
| ORG_ID | NUMBER | (15) | Organization identifier |
Cut, paste (and edit) the following text to query this object:
SELECT CASH_RECEIPT_HISTORY_ID
, SET_OF_BOOKS_ID
, CASH_RECEIPT_ID
, FIRST_POSTED_RECORD_FLAG
, POSTING_CONTROL_ID
, REVERSAL_POSTING_CONTROL_ID
, GL_POSTED_DATE
, REVERSAL_GL_POSTED_DATE
, ACCTD_AMOUNT
, ACCTD_FACTOR_DISCOUNT_AMOUNT
, EXCHANGE_DATE
, EXCHANGE_RATE
, EXCHANGE_RATE_TYPE
, CREATED_FROM
, STATUS
, TRX_DATE
, AMOUNT
, POSTABLE_FLAG
, FACTOR_FLAG
, GL_DATE
, CURRENT_RECORD_FLAG
, BATCH_ID
, ACCOUNT_CODE_COMBINATION_ID
, REVERSAL_GL_DATE
, REVERSAL_CASH_RECEIPT_HIST_ID
, FACTOR_DISCOUNT_AMOUNT
, BANK_CHARGE_ACCOUNT_CCID
, LAST_UPDATE_LOGIN
, CREATED_BY
, CREATION_DATE
, LAST_UPDATE_DATE
, PROGRAM_APPLICATION_ID
, PROGRAM_ID
, PROGRAM_UPDATE_DATE
, REQUEST_ID
, LAST_UPDATED_BY
, PRV_STAT_CASH_RECEIPT_HIST_ID
, REVERSAL_CREATED_FROM
, ATTRIBUTE1
, ATTRIBUTE2
, ATTRIBUTE3
, ATTRIBUTE4
, ATTRIBUTE5
, ATTRIBUTE6
, ATTRIBUTE7
, ATTRIBUTE8
, ATTRIBUTE9
, ATTRIBUTE10
, ATTRIBUTE11
, ATTRIBUTE12
, ATTRIBUTE13
, ATTRIBUTE14
, ATTRIBUTE15
, ATTRIBUTE_CATEGORY
, NOTE_STATUS
, ORG_ID
FROM APPS.AR_CASH_RECEIPT_HIST_MRC_V;
APPS
AR_CASH_RECEIPT_HISTORY_ALL
AR_MC_CASH_RECEIPT_HIST
APPS.AR_CASH_RECEIPT_HIST_MRC_V is not referenced by any database object
|
|
|
|