- RA_CUSTOMER_TRX_ALL :stores invoice header information.
- RA_CUSTOMER_TRX_LINES_ALL stores information about invoice, debit memo, credit memo, bills receivable, and commitment lines.
- The AR_PAYMENT_SCHEDULES_ALL table stores all transactions except adjustments and miscellaneous cash receipts.
- RA_CUST_TRX_LINE_GL_DIST_ALL stores accounting distribution records for all transaction lines except bills receivable.
- RA_CUSTOMERS – Customer information
- RA_CUST_TRX_TYPES_ALL – Customer Transaction Type
- AR_PAYMENT_SCHEDULES_ALL
- AR_CASH_RECEIPTS_ALL stores one record for each receipt entry
- AR_CASH_RECEIPT_HISTORY_ALL stores all of the activity that is contained for the life cycle of a receipt.
- AR_RECEIVABLE_APPLICATIONS_ALL stores all accounting entries for cash and credit memo applications.
- AR_DISTRIBUTIONS_ALL stores the accounting distributions for cash receipts, miscellaneous receipts, adjustments,credit memo applications, cash receipt applications, and bills receivable transactions.
Oracle Technical Experience and Test Cases Shared from different resource and through self leanings.
July 31, 2010
AR TABLES
Subscribe to:
Post Comments (Atom)
COALESCE-SQL
Coalesce- return the null values from the expression. It works similar to a case statement where if expression 1 is false then goes to expr...
-
In HRMS we do use date with timestamp for EIT ans SIT segments. To change the format od the date we can use fnd_date . canonical_to_date ...
-
Creating LOVs 1. Start a new module by clicking on File - New - Form. 2. Change Module’s name to TEST_LOV. 3. Set up DEPT and EMP...
-
This is easily done with the following command: select to_char(to_date('56789','J'),'JSP') from dual / TO_CHAR...
No comments:
Post a Comment
Thanks for your comments submitted.,will review and Post soon! by admin.