AR TABLES
AR TABLES
General Ledger Accounting Cycle
1. Open period
2. Create/reverse journal entries
3. Post
4. Review
5. Revalue
6. Translate
7. Consolidate
8. Review/correct balances
9. Run accounting reports
10. Close accounting period
- 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.
General Ledger Accounting Cycle
1. Open period
2. Create/reverse journal entries
3. Post
4. Review
5. Revalue
6. Translate
7. Consolidate
8. Review/correct balances
9. Run accounting reports
10. Close accounting period