Find the All Table and Flow of Information of the Receivables (AR)
of Oracle apps EBS R12
|
|
Oracle Apps Receivables (AR) Tables
|
|
Transactions
|
|
RA_CUSTOMER_TRX_ALL
|
Transaction Header table
|
RA_CUSTOMER_TRX_LINES_ALL
|
Transaction Lines table
along with Tax lines.
|
RA_CUST_TRX_LINE_GL_DIST_ALL
|
Distribution for
Transaction Lines
|
RA_CUST_TRX_LINE_SALESREPS_ALL
|
Salesrep information for
Transaction Lines
|
Transaction Interface
Tables
|
|
RA_INTERFACE_LINES_ALL
|
Transaction Lines
interface
|
RA_INTERFACE_SALESCREDITS_ALL
|
Transaction Sales credit information
|
RA_INTERFACE_DISTRIBUTIONS_ALL
|
Transaction Distribution
information
|
RA_INTERFACE_ERRORS_ALL
|
Transaction errors table
|
AR_PAYMENTS_INTERFACE_ALL
|
Interface table to import
receipts
|
AR_INTERIM_CASH_RECEIPTS_ALL
|
Lockbox transfers the
receipts that pass validation to the interim tables
|
AR_INTERIM_CASH_RCPT_LINES_ALL
|
Lockbox transfers the
receipts that pass validation to the interim tables
|
Receipts tables
|
|
AR_CASH_RECEIPTS_ALL
|
Cash Receipt Header
tables
|
AR_RECEIVABLE_APPLICATIONS_ALL
|
stores Receipt
Application details
|
AR_PAYMENT_SCHEDULES_ALL
|
This table is updated
when an activity occurs against an invoice, debit memo, chargeback, credit
memo, on-account credit, bills receivable
|
AR_CASH_RECEIPT_HISTORY_ALL
|
This table stores all of
the activity that is contained for the life cycle of a receipt.
|
• Each row represents one
step.
|
|
• The status field for
that row tells you which step the receipt has reached.
|
|
• Possible statuses are
Approved, Confirmed, Remitted, Cleared, and Reversed.
|
|
Customer Tables
|
|
HZ_PARTIES
|
A party is an entity that
can enter into a business relationship.
|
HZ_CUST_ACCOUNTS
|
This table stores
information about customer/financial relationships established between a
Party and the deploying company.
|
HZ_PARTY_SITES
|
This table links a party
(HZ_PARTIES) and a location (HZ_LOCATIONS) and stores location-Specific party
information such as a person’s mail stops at their work address.
|
HZ_CUST_ACCT_SITES_ALL
|
This table stores
information about customer/financial account sites information.
|
HZ_CUST_SITE_USES_ALL
|
This table stores
information about the business purposes assigned to a customer account site
|
HZ_LOCATIONS
|
A location is a point in
geographical space described by an address and/or geographical Indicators
such as latitude or longitude.
|
Setup tables
|
|
RA_CUST_TRX_TYPES_ALL
|
This table stores
information about each transaction type for all classes of transactions, for
example, invoices, commitments, and credit memos.
|
AR_RECEIPT_CLASSES
|
This table stores the
different receipt classes that you define.
|
AR_RECEIPT_METHODS
|
This table stores
information about Payment Methods, receipt attributes that you define and
assign to Receipt Classes to account for receipts and their applications
|
Thursday, 7 September 2017
Find the All Table and Flow of Information of the Receivables (AR) of Oracle apps EBS R12
Subscribe to:
Post Comments (Atom)
How to change Employee Number Generation from Manual to Automatic in Oracle HRMS (When attempting to apply for a job in iRecruitment)
When attempting to apply for a job in iRecruitment, the following error occurs: ERROR: You must enter an Application Number. Solution: How t...
-
Find Customer Bill To and Ship to Address Script in Oracle Apps EBS R12 SELECT HP.PARTY_NAME CUSTOMER_NAME, DECODE (HCSUA.SITE_...
-
How To Enable or Disable Forms Personalization Option in Oracle Apps EBS System To start Forms Personalization navigate to Help -> D...
-
----- How to find the .rdf file or Oracle Report Location or Path in Server using EXECUTION_FILE_NAME or Report Short Name in Oracle Apps E...
No comments:
Post a Comment