What are the tables associated with Invoice?
Answer Posted / rajesh
RA_CUSTOMER_TRX_ALL -- It stores invoice,debit memo
,commitment,bills receivable and credit memo header Info
.Each row in this table includes information such as
customer,transaction type and printing instructions.
RA_CUSTOMER_TRX_ALL -- It stores information about
invoice,debit memo ,credit memo,bills receivabl and
commitment lines ( LINE ,FREIGHT ,TAX ).
RA_CUST_TRX_LINE_SALESREPS_ALL --- It stores sales credit
assignments for invoice lines.If receivables base your
invoice distributions on sales credits then a mapping
exists between the sales credit assignments in this table
with the RA_CUST_TRX_LINE_GL_DIST_ALL .
RA_CUST_TRX_LINE_GL_DIST_ALL --- It stores the accounting
records for revenue,unearned revenue and unbilled
receivables for each invoice or credit memo line. ORACLE
RECEIVABLES create one row for each invoice or credit memo
line. Each row in this table includes the General Ledger
account and the amount of the accounting entry.
Is This Answer Correct ? | 15 Yes | 3 No |
Post New Answer View All Answers
What is the use of operating unit, while configure multiorg?
How do u bridge the gaps in functional understanding of AP,GL,FA. explain with some live examples.
Invoice Approval Process?
What is gap analysis, what are the pre-requisities?
Can I do a payment of 50 bills on a post date. If yes, then how?
I am created credit memo in at but while trying to complete it showing error message-hz_party_location
I have created an invoice and made the payment in Accounts payable. Now the payment status is Negotiable and accounting status is processed. I reconciled the transaction in Cash Mgmt, The status changed from negotiable to Reconciled in CM. I checked the payment status for the invoice in payment window(AP), the payment status changed to RECONCILED UNACCOUNTED i.e correct but the accounting status is remain processed which is not the correct. I hope the transaction will be correct if the accounting status would have changed to PERTIAL . Please suggest any solution for the above query.
Re: what are the Issue that we face in Gl,PO and AP while Supporting
How to support projects life cycles details?
What is gap analysis, how do you defined. What are the pre-requisities?
Explain Customer Creation and Maintenance Process. Provide samples of customer master records with Payment Terms.
what is the meaning of purchase default and what are the types
explain your project plan with exam pal? i am preparing inter view .............
explain with examples what r the roles & Responsiblities of a functional consultant who reviews the Test Scripts, Test Cases and Test Execution Results of AP, FA and GL.
Provide an overview of AR cash receipt processing.