account receivable(ar)important tables in oracle apps
--ACCOUNT RECIEVABLES TABLES
--TRANSACTIONS(INVOICES)
Select * from RA_CUSTOMER_TRX_ALL
Select * from RA_CUSTOMER_TRX_LINES_ALL
Select * from RA_CUST_TRX_LINE_GL_DIST_ALL
Select * from RA_CUST_TRX_LINE_SALESREPS_ALL
--CASH RECIEPTS
Select * from AR_CASH_RECEIPTS_ALL
--INVOICE TYPES
Select * from RA_CUST_TRX_TYPES_ALL
--SOURCE
Select * from RA_BATCH_SOURCES_ALL
--SALES REPS
Select * from RA_SALESREPS_ALL
--PAYMENT TERMS
Select * from RA_TERMS_TL
Select * from RA_TERMS_LINES
--RECEIPT PAYMENT METHOD
Select * from AR_RECEIPT_METHODS
No comments:
Post a Comment