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
|
Showing posts with label Find the All Table and Flow of Information of the Receivables (AR) of Oracle apps EBS R12. Show all posts
Showing posts with label Find the All Table and Flow of Information of the Receivables (AR) of Oracle apps EBS R12. Show all posts
Thursday, 7 September 2017
Find the All Table and Flow of Information of the Receivables (AR) of Oracle apps EBS R12
Subscribe to:
Posts (Atom)
How to Call a Seeded Oracle Form from a Custom Form (Step-by-Step Guide)
How to Call a Seeded Oracle Form from a Custom Form (Step-by-Step Guide) Introduction In Oracle E-Business Suite, it is a common requirem...
-
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...
-
----- Script for the BOM Routing Department Query in Oracle apps EBS R12 ---- SELECT (SELECT hou.NAME F...