AR_CASH_RECOS_ALL

This table stores the header information of the recommendations on a receipt reference

Details

• Schema: FUSION

• Object owner: AR

• Object type: TABLE

• Tablespace: FUSION_TS_TX_DATA

Primary Key

Name	Columns
AR_CASH_RECOS_PK	RECOMMENDATION_ID

Columns

Name	Datatype	Length	Precision	Not-null	Comments
RECOMMENDATION_ID	NUMBER		18	Yes	Recommendation Identifier
RECOMMENDATION_SOURCE	VARCHAR2	30		Yes	Source from which the recommendation is generated, such as AutoMatch or Application Exception Rule.
REMIT_REFERENCE_ID	NUMBER		18	Yes	Cash remittance reference identifier used as a foreign key to AR_CASH_REMIT_REFS_ALL.REMIT_REFERENCE_ID.
CUSTOMER_ID	NUMBER		18		Customer Identifier
RESOLVED_MATCHING_NUMBER	VARCHAR2	30			Resolved Document Number
MATCH_RESOLVED_USING	VARCHAR2	30			Receipt Match By used to do the match
MATCH_SCORE_VALUE	NUMBER				Match Score
MATCH_REASON_CODE	VARCHAR2	30			Match Reason
RECOMMENDATION_STATUS	VARCHAR2	30			Recommendation Status
ORG_ID	NUMBER		18	Yes	Indicates the identifier of the business unit associated to the row.
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.
LAST_UPDATED_BY	VARCHAR2	64		Yes	Who column: indicates the user who last updated the row.
LAST_UPDATE_DATE	TIMESTAMP			Yes	Who column: indicates the date and time of the last update of the row.
LAST_UPDATE_LOGIN	VARCHAR2	32			Who column: indicates the session login associated to the user who last updated the row.
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.
PROGRAM_APPLICATION_ID	NUMBER		18		Who column: indicates application that last updated this row. Foreign key to FND_APPLICATION.APPLICATION_ID.
PROGRAM_ID	NUMBER		18		Who column: indicates program that last updated this row. Foreign key to FND_CONCURRENT_PROGRAM.CONCURRENT_PROGRAM_ID.
PROGRAM_UPDATE_DATE	DATE				Concurrent program Who column.
REQUEST_ID	NUMBER		18		Enterprise Service Scheduler: indicates the request ID of the job that created or last updated the row.
AUTOAPPLY_STATUS	VARCHAR2	30			AutoApply Status
RECOMMENDATION_TYPE	VARCHAR2	30			Recommendation Type
CUSTOMER_SITE_USE_ID	NUMBER		18		Customer Site Use Identifier
AUTOMATCH_RULE_ID	NUMBER		18		Automatch Rule Identifier by which this recommendation is created
TRANSACTION_WEIGHT	NUMBER				Transaction weight for the AutoMatch rule used for the match.
TRANSACTION_SCORE	NUMBER				Score for the transaction string to the remittance string
CUSTOMER_WEIGHT	NUMBER				Customer weight for the AutoMatch rule used for the match.
CUSTOMER_SCORE	NUMBER				Score on customer number to the remittance customer number
AMOUNT_WEIGHT	NUMBER				Amount weight for the AutoMatch rule used for the match.
AMOUNT_SCORE	NUMBER				Score on transaction balance to the reference amount
EXACT_AMOUNT_WEIGHT	NUMBER				Amount weight when the balance amount matches the remittance amount.
EXACT_AMOUNT_FACTOR	NUMBER				Weight on the exact amount weight for the recommendation
NET_TAX_WEIGHT	NUMBER				Amount weight when the payment is net of tax.
NET_TAX_FACTOR	NUMBER				Weight on the net of tax weight for the recommendation
NET_FREIGHT_WEIGHT	NUMBER				Amount weight when the payment is net of freight.
NET_FREIGHT_FACTOR	NUMBER				Weight on the net of freight weight for the recommendation
NET_TAX_FREIGHT_WEIGHT	NUMBER				Amount weight when the payment is net of tax and freight.
NET_TAX_FREIGHT_FACTOR	NUMBER				Weight on the net of tax and freight weight for the recommendation
NET_UNDISC_WEIGHT	NUMBER				Amount weight when the payment is net of unearned discount.
NET_UNDISC_FACTOR	NUMBER				Weight on the net of unearned discount weight for the recommendation
TAX_REMAINING	NUMBER				Remaining tax for the recommendation
FREIGHT_REMAINING	NUMBER				Freight remaining in the recommendation
UNDISC_REMAINING	NUMBER				Unearned discount remaining in the recommendation
AMOUNT_APPLIED	NUMBER				Total amount applied in the recommendation
MASTER_REQ_ID	NUMBER		18		Request Identifier for the master automatch/autoapply program

Foreign Keys

Table	Foreign Table	Foreign Key Column
AR_CASH_RECOS_ALL	ar_cash_remit_refs_all	REMIT_REFERENCE_ID
AR_CASH_RECOS_ALL	hz_cust_accounts	CUSTOMER_ID
AR_CASH_RECOS_ALL	hz_cust_site_uses_all	CUSTOMER_SITE_USE_ID
AR_CASH_RECOS_ALL	ar_automatch_rules	AUTOMATCH_RULE_ID
ar_cash_reco_lines_all	ar_cash_recos_all	RECOMMENDATION_ID

Indexes

Index	Uniqueness	Tablespace	Columns
AR_CASH_RECOS_N1	Non Unique	FUSION_TS_TX_DATA	REMIT_REFERENCE_ID
AR_CASH_RECOS_N2	Non Unique	FUSION_TS_TX_DATA	MASTER_REQ_ID, MATCH_REASON_CODE, RECOMMENDATION_TYPE
AR_CASH_RECOS_U1	Unique	FUSION_TS_TX_DATA	RECOMMENDATION_ID