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


TABLE: AR.AR_CASH_RECEIPT_HISTORY_ALL

Object Details
Object Name: AR_CASH_RECEIPT_HISTORY_ALL
Object Type: TABLE
Owner: AR
FND Design Data: TableAR.AR_CASH_RECEIPT_HISTORY_ALL
Subobject Name:
Status: VALID


The AR_CASH_RECEIPT_HISTORY_ALL table contains each step in a receipt's life cycle. Each row in this table represents one step. The STATUS column indicates which step the receipt has reached:
{{"bul:1"}}APPROVED - This status is valid only for an automatically created receipt and indicates that the receipt was approved for automatic creation.
{{"bul:1"}}CONFIRMED - This status is valid only for an automatically created receipt and indicates that the receipt was confirmed by the customer.
{{"bul:1"}}REMITTED - This status is valid for both automatically and manually created receipts and indicates that the receipt was remitted.
{{"bul:1"}}CLEARED - This status is valid for both automatically and manually created receipts and indicates that the receipt was cleared.
{{"bul:1"}}REVERSED - This status is valid for both automatically and manually created receipts and indicates that the receipt was reversed.
{{"bodytext"}}Oracle Receivables posts each row in this table to 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 you 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.


Storage Details
Tablespace: TablespaceAPPS_TS_TX_DATA
PCT Free: 10
PCT Used:
Indexes
Index Type Uniqueness Tablespace Column
AR_CASH_RECEIPT_HISTORY_U1 NORMAL UNIQUE TablespaceAPPS_TS_TX_IDX ColumnCASH_RECEIPT_HISTORY_ID
AR_CASH_RECEIPT_HISTORY_U2 NORMAL UNIQUE TablespaceAPPS_TS_TX_IDX ColumnREVERSAL_CASH_RECEIPT_HIST_ID
AR_CASH_RECEIPT_HISTORY_N1 NORMAL NONUNIQUE TablespaceAPPS_TS_TX_IDX ColumnCASH_RECEIPT_ID
ColumnCURRENT_RECORD_FLAG
ColumnFIRST_POSTED_RECORD_FLAG
AR_CASH_RECEIPT_HISTORY_N10 NORMAL NONUNIQUE TablespaceAPPS_TS_TX_IDX ColumnEVENT_ID
AR_CASH_RECEIPT_HISTORY_N2 NORMAL NONUNIQUE TablespaceAPPS_TS_TX_IDX ColumnGL_DATE
ColumnFIRST_POSTED_RECORD_FLAG
AR_CASH_RECEIPT_HISTORY_N3 NORMAL NONUNIQUE TablespaceAPPS_TS_TX_IDX ColumnBATCH_ID
ColumnFIRST_POSTED_RECORD_FLAG
AR_CASH_RECEIPT_HISTORY_N4 NORMAL NONUNIQUE TablespaceAPPS_TS_TX_IDX ColumnPOSTING_CONTROL_ID
ColumnGL_DATE
AR_CASH_RECEIPT_HISTORY_N6 NORMAL NONUNIQUE TablespaceAPPS_TS_TX_IDX ColumnCURRENT_RECORD_FLAG
ColumnSTATUS
AR_CASH_RECEIPT_HISTORY_N8 NORMAL NONUNIQUE TablespaceAPPS_TS_TX_IDX ColumnREQUEST_ID
AR_CASH_RECEIPT_HISTORY_N9 NORMAL NONUNIQUE TablespaceAPPS_TS_TX_IDX ColumnTRX_DATE
Columns
Name Datatype Length Mandatory Comments
CASH_RECEIPT_HISTORY_ID NUMBER (15) Yes Cash receipt history identifier
CASH_RECEIPT_ID NUMBER (15) Yes MRC only: Concatenated string of reporting set of books ID, cash receipt identifier pairs
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 (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.
POSTING_CONTROL_ID NUMBER (15) 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 (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 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 NUMBER (15)
Standard who column - operating system login of user who last updated this row (foreign key to FND_LOGINS.LOGIN_ID).
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 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.
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 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) Yes 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.
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
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
MRC_POSTING_CONTROL_ID VARCHAR2 (2000)
MRC only: Concatenated string of reporting set of books ID, receivable posting batch identifier pairs
MRC_GL_POSTED_DATE VARCHAR2 (2000)
MRC only: Concatenated string of reporting set of books ID, posted date for reporting book(s) pairs
MRC_REVERSAL_GL_POSTED_DATE VARCHAR2 (2000)
Concatenated string of reporting set of books ID, posted date for the reversal for reporting book(s) pairs
MRC_ACCTD_AMOUNT VARCHAR2 (2000)
MRC only: Concatenated string of reporting set of books ID, amount in reporting currency(s) pairs
MRC_ACCTD_FACTOR_DISC_AMOUNT VARCHAR2 (2000)
MRC only: Concatenated string of reporting set of books ID, FACTOR_DISCOUNT_AMOUNT in reporting currency(s) pairs
MRC_EXCHANGE_DATE VARCHAR2 (2000)
MRC only: Concatenated string of reporting set of books ID, exchange date pairs
MRC_EXCHANGE_RATE VARCHAR2 (2000)
MRC only: Concatenated string of reporting set of books ID, exchange rate pairs
MRC_EXCHANGE_RATE_TYPE VARCHAR2 (2000)
MRC only: Concatenated string of reporting set of books ID, exchange rate type pairs
EVENT_ID NUMBER (15)
SLA event_id
Query Text

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


SELECT CASH_RECEIPT_HISTORY_ID
,      CASH_RECEIPT_ID
,      STATUS
,      TRX_DATE
,      AMOUNT
,      FIRST_POSTED_RECORD_FLAG
,      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
,      POSTING_CONTROL_ID
,      REVERSAL_POSTING_CONTROL_ID
,      GL_POSTED_DATE
,      REVERSAL_GL_POSTED_DATE
,      LAST_UPDATE_LOGIN
,      ACCTD_AMOUNT
,      ACCTD_FACTOR_DISCOUNT_AMOUNT
,      CREATED_BY
,      CREATION_DATE
,      EXCHANGE_DATE
,      EXCHANGE_RATE
,      EXCHANGE_RATE_TYPE
,      LAST_UPDATE_DATE
,      PROGRAM_APPLICATION_ID
,      PROGRAM_ID
,      PROGRAM_UPDATE_DATE
,      REQUEST_ID
,      LAST_UPDATED_BY
,      PRV_STAT_CASH_RECEIPT_HIST_ID
,      CREATED_FROM
,      REVERSAL_CREATED_FROM
,      ATTRIBUTE1
,      ATTRIBUTE2
,      ATTRIBUTE3
,      ATTRIBUTE4
,      ATTRIBUTE5
,      ATTRIBUTE6
,      ATTRIBUTE7
,      ATTRIBUTE8
,      ATTRIBUTE9
,      ATTRIBUTE10
,      ATTRIBUTE11
,      ATTRIBUTE12
,      ATTRIBUTE13
,      ATTRIBUTE14
,      ATTRIBUTE15
,      ATTRIBUTE_CATEGORY
,      NOTE_STATUS
,      ORG_ID
,      MRC_POSTING_CONTROL_ID
,      MRC_GL_POSTED_DATE
,      MRC_REVERSAL_GL_POSTED_DATE
,      MRC_ACCTD_AMOUNT
,      MRC_ACCTD_FACTOR_DISC_AMOUNT
,      MRC_EXCHANGE_DATE
,      MRC_EXCHANGE_RATE
,      MRC_EXCHANGE_RATE_TYPE
,      EVENT_ID
FROM AR.AR_CASH_RECEIPT_HISTORY_ALL;

Dependencies

[top of page]

AR.AR_CASH_RECEIPT_HISTORY_ALL does not reference any database object

AR.AR_CASH_RECEIPT_HISTORY_ALL is referenced by following:

SchemaAR
ViewAR_CASH_RECEIPT_HISTORY_ALL#