Sunday, July 22, 2018

(AR) Account Receivable Important tables in Oracle APPS

  • TRANSACTIONS(AR 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

  • AR CASH RECEIPTS
Select * from   AR_CASH_RECEIPTS_ALL

  • AR INVOICE TYPES
Select * from   RA_CUST_TRX_TYPES_ALL

  • AR BATCH SOURCE
Select * from   RA_BATCH_SOURCES_ALL

  • AR SALES REPS
Select * from   RA_SALESREPS_ALL

  • AR PAYMENT TERMS
Select * from   RA_TERMS_TL

Select * from   RA_TERMS_LINES

  • AR RECEIPT PAYMENT METHOD
Select * from   AR_RECEIPT_METHODS

No comments:

Post a Comment

SupplierAddressImportTemplate.xlsm South Africa Suburb Field mapping in POZ_SUPPLIER_ADDRESSES_INT

Suburb mpping in Supplier Address Import Template will be mapped to Address Element Attribute2 (HZ_LOCATIONS. ADDR_ELEMENT_ATTRIBUTE2)