Oracle EBS AR Module Table Names and Description :-
RA_CUST_TRX_TYPES_ALL :- Transaction type for invoices, commitments and credit memos
RA_CUSTOMER_TRX_ALL :- Header-level information about invoices, debit memos, chargebacks, commitments and credit memos
RA_CUSTOMER_TRX_LINES_ALL :- Invoice, debit memo, chargeback, credit memo and commitment lines
RA_CUST_TRX_LINE_GL_DIST_ALL :- Accounting records for revenue, unearned revenue and unbilled receivables
RA_CUST_TRX_LINE_SALESREPS_ALL :- Sales credit assignments for transactions
AR_ADJUSTMENTS_ALL :- Pending and approved invoice adjustments
RA_BATCHES_ALL
AR_CASH_RECEIPTS_ALL :- Detailed receipt information
AR_CASH_RECEIPT_HISTORY_ALL :- History of actions and status changes in the life cycle of a receipt
AR_PAYMENT_SCHEDULES_ALL :- All transactions except adjustments and miscellaneous cash receipts
AR_RECEIVABLE_APPLICATIONS_ALL :- Accounting information for cash and credit memo applications
AR_TRANSACTION_HISTORY_ALL :- Life cycle of a transaction
HZ_CUST_ACCOUNTS :- Stores information about customer accounts.
HZ_CUSTOMER_PROFILES :- Credit information for customer accounts and customer account sites
HZ_CUST_ACCT_SITES_ALL :- Stores all customer account sites across all operating units
HZ_CUST_ACCT_RELATE_ALL :- Relationships between customer accounts
HZ_CUST_CONTACT_POINTS :- This table is no longer used
HZ_CUST_PROF_CLASS_AMTS :- Customer profile class amount limits for each currency
HZ_CUST_SITE_USES_ALL :- Stores business purposes assigned to customer account sites.
HZ_LOCATIONS :- Physical addresses
HZ_ORG_CONTACTS :- People as contacts for parties
HZ_ORG_CONTACT_ROLES :- Roles played by organization contacts
HZ_PARTIES :- Information about parties such as organizations, people, and groups
HZ_PARTY_SITES :- Links party to physical locations
HZ_PARTY_SITE_USES :- The way that a party uses a particular site or address
HZ_RELATIONSHIPS :- Relationships between entities
HZ_RELATIONSHIP_TYPES :- Relationship types
No comments:
Post a Comment