AR_RECEIVABLE_APPLICATIONS_ALL.STATUS in Oracle APPS

• The AR_RECEIVABLE_APPLICATIONS_ALL table stores all accounting entries for both Cash and Credit Memo Applications. 

• The APPLICATION_TYPE column stores either CASH or CM (for credit memo applications). 

• Each row in this table includes the amount applied, status, and accounting flexfield information. 

• Status Column have below values: 
• APP for applied
• UNAPP for unapplied
• ACC for on-account
• UNID for unidentified
• ACTIVITY for receivable activity, and 
• OTHER ACC for other receipt application.