AR_CASH_RECEIPT_HISTORY_ALL
The AR_CASH_RECEIPT_HISTORY_ALL table contains one row for each step in the life cycle of a receipt. The STATUS column indicates the status for each step: APPROVED for receipts approved for automatic creation and CONFIRMED for receipts confirmed by customer to be included in automatic receipt creation. Approved and confirmed statuses are valid only for automatically created receipts. Valid statuses for both manually and automatically created receipts include: REMITTED for receipts that were remitted, CLEARED for receipts that were cleared and REVERSED for receipts that were reversed. Receivables posts each row in this table to the General Ledger. Each row debits the account that is represented by the ACCOUNT_CODE_COMBINATION_ID column on the date specified in the GL_DATE column and credits the account on the date specified in the REVERSAL_GL_DATE column, if a date is present in this column. Optionally, each row will also debit (on the date specified in the GL_DATE column) and credit (on the date specified in the REVERSAL_GL_DATE column) the account that is represented by the BANK_CHARGE_ACCOUNT_CCID column for the amount in the FACTOR_DISCOUNT_AMOUNT column, which is the difference between the remitted amount and the cleared amount. The CURRENT_RECORD_FLAG column points to the current row, which is the current status of the cash receipt. The POSTABLE_FLAG column determines if a row can be posted to General Ledger. The primary key for this table is CASH_RECEIPT_HISTORY_ID.
Details
-
Schema: FUSION
-
Object owner: AR
-
Object type: TABLE
-
Tablespace: APPS_TS_TX_DATA
Primary Key
| Name | Columns |
|---|---|
|
AR_CASH_RECEIPT_HISTORY_PK |
CASH_RECEIPT_HISTORY_ID |
Columns
| Name | Datatype | Length | Precision | Not-null | Comments |
|---|---|---|---|---|---|
| CASH_RECEIPT_HISTORY_ID | NUMBER | 18 | Yes | Cash receipt history identifier | |
| CASH_RECEIPT_ID | NUMBER | 18 | Yes | Not currently used. | |
| 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. | ||
| 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. | |
| 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 | 18 | 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 | 18 | 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 | 18 | 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 | 18 | This is the account that is debited and/or credited for the FACTOR_DISCOUNT_AMOUNT. | ||
| POSTING_CONTROL_ID | NUMBER | 18 | Yes | Receivables posting batch identifier; -1 means it was posted by the old posting program (ARXGLP); -2 means it's posted from old rel8 RA; -3 means it's not posted; -4 means it's posted by rel9 RAPOST | |
| REVERSAL_POSTING_CONTROL_ID | NUMBER | 18 | 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 given when you submit record for General Ledger posting | |||
| REVERSAL_GL_POSTED_DATE | DATE | Date given when you submit reversal for General Ledger posting | |||
| LAST_UPDATE_LOGIN | VARCHAR2 | 32 | Who column: indicates the session login associated to the user who last updated the row. | ||
| ACCTD_AMOUNT | NUMBER | Yes | This is AMOUNT in the functional currency. | ||
| ACCTD_FACTOR_DISCOUNT_AMOUNT | NUMBER | This is FACTOR_DISCOUNT_AMOUNT in the functional currency. | |||
| CREATED_BY | VARCHAR2 | 64 | Yes | Who column: indicates the user who created the row. | |
| CREATION_DATE | TIMESTAMP | Yes | Who column: indicates the date and time of the creation of the row. | ||
| EXCHANGE_DATE | DATE | Date for which rate selected | |||
| EXCHANGE_RATE | NUMBER | Exchange rate used to convert foreign currency amounts into functional currency | |||
| EXCHANGE_RATE_TYPE | VARCHAR2 | 30 | Used to define multiple currency exchange rates for the same date | ||
| LAST_UPDATE_DATE | TIMESTAMP | Yes | Who column: indicates the date and time of the last update of the row. | ||
| PROGRAM_APPLICATION_ID | NUMBER | 18 | Concurrent Program who column - application id of the program that last updated this row (foreign key to FND_APPLICATION.APPLICATION_ID). | ||
| PROGRAM_ID | NUMBER | 18 | 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 | 18 | Enterprise Service Scheduler: indicates the request ID of the job that created or last updated the row. | ||
| LAST_UPDATED_BY | VARCHAR2 | 64 | Yes | Who column: indicates the user who last updated the row. | |
| PRV_STAT_CASH_RECEIPT_HIST_ID | NUMBER | 18 | 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. | ||
| CREATED_FROM | VARCHAR2 | 30 | Yes | Populated by code that points to form or program that created this row | |
| REVERSAL_CREATED_FROM | VARCHAR2 | 30 | Populated by code that points to form or program that reversed this row | ||
| ATTRIBUTE1 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | ||
| ATTRIBUTE2 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | ||
| ATTRIBUTE3 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | ||
| ATTRIBUTE4 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | ||
| ATTRIBUTE5 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | ||
| ATTRIBUTE6 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | ||
| ATTRIBUTE7 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | ||
| ATTRIBUTE8 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | ||
| ATTRIBUTE9 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | ||
| ATTRIBUTE10 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | ||
| ATTRIBUTE11 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | ||
| ATTRIBUTE12 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | ||
| ATTRIBUTE13 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | ||
| ATTRIBUTE14 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | ||
| ATTRIBUTE15 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | ||
| ATTRIBUTE_CATEGORY | VARCHAR2 | 30 | Descriptive Flexfield: structure definition of the user descriptive flexfield. | ||
| NOTE_STATUS | VARCHAR2 | 30 | The state of the Note Receivable | ||
| ORG_ID | NUMBER | 18 | Yes | Indicates the identifier of the business unit associated to the row. | |
| MRC_POSTING_CONTROL_ID | VARCHAR2 | 2000 | Not currently used. | ||
| MRC_GL_POSTED_DATE | VARCHAR2 | 2000 | Not currently used. | ||
| MRC_REVERSAL_GL_POSTED_DATE | VARCHAR2 | 2000 | Not currently used. | ||
| MRC_ACCTD_AMOUNT | VARCHAR2 | 2000 | Not currently used. | ||
| MRC_ACCTD_FACTOR_DISC_AMOUNT | VARCHAR2 | 2000 | Not currently used. | ||
| MRC_EXCHANGE_DATE | VARCHAR2 | 2000 | Not currently used. | ||
| MRC_EXCHANGE_RATE | VARCHAR2 | 2000 | Not currently used. | ||
| MRC_EXCHANGE_RATE_TYPE | VARCHAR2 | 2000 | Not currently used. | ||
| EVENT_ID | NUMBER | 18 | Subledger accounting event identifier. | ||
| OBJECT_VERSION_NUMBER | NUMBER | 9 | Yes | Used to implement optimistic locking. This number is incremented every time that the row is updated. The number is compared at the start and end of a transaction to detect whether another session has updated the row since it was queried. | |
| BUDGETARY_CONTROL_FLAG | VARCHAR2 | 1 | Option that indicates whether budgeting is enabled on the ledger associated with the standard receipt, and if its details should be interfaced to Budgetary Control. Valid values are Y and N. | ||
| SUBLEDGER_BC_COMPLETE_FLAG | VARCHAR2 | 1 | Option that indicates whether to interface standard receipt accounting information from General Ledger to Budgetary Control. This value is passed by Budgetary Control to General Ledger through the accounting information from Receivables. |
Foreign Keys
| Table | Foreign Table | Foreign Key Column |
|---|---|---|
| AR_CASH_RECEIPT_HISTORY_ALL | ar_cash_receipts_all | CASH_RECEIPT_ID |
| AR_CASH_RECEIPT_HISTORY_ALL | gl_daily_conversion_types | EXCHANGE_RATE_TYPE |
| AR_CASH_RECEIPT_HISTORY_ALL | xla_events | EVENT_ID, PROGRAM_APPLICATION_ID |
| AR_CASH_RECEIPT_HISTORY_ALL | ar_cash_receipt_history_all | REVERSAL_CASH_RECEIPT_HIST_ID |
| AR_CASH_RECEIPT_HISTORY_ALL | ar_batches_all | BATCH_ID |
| AR_CASH_RECEIPT_HISTORY_ALL | gl_code_combinations | ACCOUNT_CODE_COMBINATION_ID |
| AR_CASH_RECEIPT_HISTORY_ALL | gl_code_combinations | BANK_CHARGE_ACCOUNT_CCID |
| AR_CASH_RECEIPT_HISTORY_ALL | ar_cash_receipt_history_all | PRV_STAT_CASH_RECEIPT_HIST_ID |
| ar_trx_summary_hist | ar_cash_receipt_history_all | PREVIOUS_HISTORY_ID |
| ar_detailed_distributions_all | ar_cash_receipt_history_all | CASH_RECEIPT_HISTORY_ID |
| ar_misc_cash_distributions_all | ar_cash_receipt_history_all | CASH_RECEIPT_HISTORY_ID |
| ar_cash_receipt_history_all | ar_cash_receipt_history_all | REVERSAL_CASH_RECEIPT_HIST_ID |
| ar_cash_receipt_history_all | ar_cash_receipt_history_all | PRV_STAT_CASH_RECEIPT_HIST_ID |
| ar_receivable_applications_all | ar_cash_receipt_history_all | CASH_RECEIPT_HISTORY_ID |
Indexes
| Index | Uniqueness | Tablespace | Columns | Status |
|---|---|---|---|---|
| AR_CASH_RECEIPT_HISTORY_N1 | Non Unique | Default | CASH_RECEIPT_ID, CURRENT_RECORD_FLAG, FIRST_POSTED_RECORD_FLAG | |
| AR_CASH_RECEIPT_HISTORY_N10 | Non Unique | Default | EVENT_ID | |
| AR_CASH_RECEIPT_HISTORY_N11 | Non Unique | Default | CURRENT_RECORD_FLAG | Obsolete |
| AR_CASH_RECEIPT_HISTORY_N2 | Non Unique | Default | GL_DATE, FIRST_POSTED_RECORD_FLAG | |
| AR_CASH_RECEIPT_HISTORY_N3 | Non Unique | Default | BATCH_ID | |
| AR_CASH_RECEIPT_HISTORY_N4 | Non Unique | Default | POSTING_CONTROL_ID, GL_DATE | |
| AR_CASH_RECEIPT_HISTORY_N6 | Non Unique | Default | CURRENT_RECORD_FLAG, STATUS | |
| AR_CASH_RECEIPT_HISTORY_N8 | Non Unique | Default | REQUEST_ID | |
| AR_CASH_RECEIPT_HISTORY_N9 | Non Unique | Default | TRX_DATE | |
| AR_CASH_RECEIPT_HISTORY_U1 | Unique | Default | CASH_RECEIPT_HISTORY_ID | |
| AR_CASH_RECEIPT_HISTORY_U2 | Unique | Default | REVERSAL_CASH_RECEIPT_HIST_ID |