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

TABLE: AR.AR_CASH_RECOS_ALL

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


This table stores Recommendation details generated for the document number references provided (BETA)


Storage Details
Tablespace: TablespaceAPPS_TS_TX_DATA
PCT Free: 10
PCT Used:
Indexes
Index Type Uniqueness Tablespace Column
AR_CASH_RECOS_ALL_UK1 NORMAL NONUNIQUE TablespaceAPPS_TS_TX_IDX ColumnREQUEST_ID
AR_CASH_RECOS_N1 NORMAL NONUNIQUE TablespaceAPPS_TS_TX_IDX ColumnREQUEST_ID
ColumnMATCH_REASON_CODE
Columns
Name Datatype Length Mandatory Comments
RECOMMENDATION_ID NUMBER (15) Yes Recommendation Identifier
REMIT_REFERENCE_ID NUMBER (15)
Remittance Reference Identifier
PAY_FROM_CUSTOMER NUMBER (15)
Identifier of the customer who sent this payment
RESOLVED_MATCHING_NUMBER VARCHAR2 (30)
Invoice number that corresponds to matching number
RESOLVED_MATCHING_DATE DATE

Transaction date that corresponds to transaction number that is stored in matching number column
RESOLVED_MATCHING_CLASS VARCHAR2 (30)
Transaction class of the matching number
RESOLVED_MATCH_CURRENCY VARCHAR2 (30)
Currency code of transaction
RESOLVED_TRX_AMOUNT NUMBER (9)
Resolved Transaction Amount
RESOLVED_TRX_AMOUNT_REM NUMBER (9)
Balance on the matching transaction number
MATCH_RESOLVED_USING VARCHAR2 (30)
Match Resolved Category
MATCH_SCORE_VALUE NUMBER (9)
Match Score Value
MATCH_REASON_CODE VARCHAR2 (30)
Match Reason Code
RECOMMENDATION_STATUS VARCHAR2 (30)
Recommendation Status
RECOMMENDATION_REASON VARCHAR2 (100)
Recommendation Reason
ORG_ID NUMBER
Yes Organization identifier
CREATED_BY NUMBER (15) Yes Standard who column
CREATION_DATE DATE
Yes Standard who column
LAST_UPDATED_BY NUMBER (15) Yes Standard who column
LAST_UPDATE_DATE DATE
Yes Standard Who column
LAST_UPDATE_LOGIN NUMBER (15)
Standard who column
PROGRAM_APPLICATION_ID NUMBER (15)
Program Application Identifier
PROGRAM_ID NUMBER (15)
Program Identifier
PROGRAM_UPDATE_DATE DATE

Program Update date
REQUEST_ID NUMBER (15)
Request Identifier
AUTOMATCH_ID NUMBER (15)
Automatch Rule Identifier
PRIORITY NUMBER (3)
Rule Priority inside the Rule Set
AUTOAPPLY_STATUS VARCHAR2 (20)
Autoapply Status
CUSTOMER_SITE_USE_ID NUMBER (15)
Customer Site Use Identifier
RECOMMENDATION_SOURCE VARCHAR2 (30)
Recommendation Source
RECOMMENDATION_TYPE VARCHAR2 (30)
Recommendation Type
CONS_INV_ID NUMBER (15)
Reserved for Future Use
Query Text

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


SELECT RECOMMENDATION_ID
,      REMIT_REFERENCE_ID
,      PAY_FROM_CUSTOMER
,      RESOLVED_MATCHING_NUMBER
,      RESOLVED_MATCHING_DATE
,      RESOLVED_MATCHING_CLASS
,      RESOLVED_MATCH_CURRENCY
,      RESOLVED_TRX_AMOUNT
,      RESOLVED_TRX_AMOUNT_REM
,      MATCH_RESOLVED_USING
,      MATCH_SCORE_VALUE
,      MATCH_REASON_CODE
,      RECOMMENDATION_STATUS
,      RECOMMENDATION_REASON
,      ORG_ID
,      CREATED_BY
,      CREATION_DATE
,      LAST_UPDATED_BY
,      LAST_UPDATE_DATE
,      LAST_UPDATE_LOGIN
,      PROGRAM_APPLICATION_ID
,      PROGRAM_ID
,      PROGRAM_UPDATE_DATE
,      REQUEST_ID
,      AUTOMATCH_ID
,      PRIORITY
,      AUTOAPPLY_STATUS
,      CUSTOMER_SITE_USE_ID
,      RECOMMENDATION_SOURCE
,      RECOMMENDATION_TYPE
,      CONS_INV_ID
FROM AR.AR_CASH_RECOS_ALL;

Dependencies

[top of page]

AR.AR_CASH_RECOS_ALL does not reference any database object

AR.AR_CASH_RECOS_ALL is referenced by following:

SchemaAR
ViewAR_CASH_RECOS_ALL#