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

TABLE: AR.AR_AUTOCLEAR_INTERIM

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


This table stores the necessary details required for clearing a receipt


Storage Details
Tablespace: TablespaceAPPS_TS_TX_DATA
PCT Free: 10
PCT Used:
Columns
Name Datatype Length Mandatory Comments
CASH_RECEIPT_ID NUMBER (15)
Cash Receipt Identifier
TRX_DATE DATE

The transaction date when the history row occurs as entered by the user
GL_DATE DATE

The General Ledger Date that is used when debiting the ACCOUNT_CODE_COMBINATION_ID
MODULE_NAME VARCHAR2 (30)
Module Name (AR_AUTOMATIC_CLEARING)
MODULE_VERSION VARCHAR2 (10)
Module Version
CASH_RECEIPT_HISTORY_ID NUMBER (15)
Cash Receipt History Identifier
EXCHANGE_DATE DATE

Date for which rate selected
EXCHANGE_RATE_TYPE VARCHAR2 (30)
Used to define multiple currency exchange rates for the same date
EXCHANGE_RATE NUMBER

Exchange rate used to convert foreign currency amounts into functional currency
CURRENCY_CODE VARCHAR2 (15)
Currency code of the payment batch associated with this payment entry
AMOUNT NUMBER

The remitted amount
FACTOR_DISCOUNT_AMOUNT NUMBER

The amount determined to factor the receipt
CRH_AMOUNT NUMBER

Amount from Cash receipt History table.
CRH_FACTOR_DISCOUNT_AMOUNT NUMBER

Factor Discount Amount from Cash Receipt History table. This is the amount of the bank charge and/or factor discount taken by the bank at clearance and/or factoring time
CR_CURRENCY_CODE VARCHAR2 (15)
Currency Code
EXCHANGE_RATE_OLD NUMBER

Exchange rate at the time of remittance
CURRENT_WORKER NUMBER (15)
Worker number that processes the current receipt
REQUEST_ID NUMBER (15)
Concurrent Program who column - concurrent request id of the program that last updated this row
TYPE VARCHAR2 (15)
Type of receipt selected for Clearance . (Remitted/Risk/Factored)
Query Text

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


SELECT CASH_RECEIPT_ID
,      TRX_DATE
,      GL_DATE
,      MODULE_NAME
,      MODULE_VERSION
,      CASH_RECEIPT_HISTORY_ID
,      EXCHANGE_DATE
,      EXCHANGE_RATE_TYPE
,      EXCHANGE_RATE
,      CURRENCY_CODE
,      AMOUNT
,      FACTOR_DISCOUNT_AMOUNT
,      CRH_AMOUNT
,      CRH_FACTOR_DISCOUNT_AMOUNT
,      CR_CURRENCY_CODE
,      EXCHANGE_RATE_OLD
,      CURRENT_WORKER
,      REQUEST_ID
,      TYPE
FROM AR.AR_AUTOCLEAR_INTERIM;

Dependencies

[top of page]

AR.AR_AUTOCLEAR_INTERIM does not reference any database object

AR.AR_AUTOCLEAR_INTERIM is referenced by following:

SchemaAR
ViewAR_AUTOCLEAR_INTERIM#