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
I am currently working in reputed Org as a Oracle apps end user (AR). Learned R12 functional course, but no real time exp as in support or implementation project.Please guide. thank you.
What is the meaning holding tax?
what is the steps to customization ?
Define the activities of the Configuration Manager (AP,GL,FA) in the team. Give examples
What is multi org? What is difference between 11i and 12i multi org structure?
On what different real time issues you worked while doing P2P cycle implementation?
How do you adjust receivables?
what is the meaning of purchase default and what are the types
How to refund for a customer who returns goods and wants a refund for $600 in R12 In above scenarios customer does not want Credit Memo or On- Account Credit, he wants refund check . and as we know we do not issue check from AR. How can we issue Check from AP and how offsetting is done for the same in R12
Write Test Scripts for a telecummunication project on the basis of priority with some examples with regard to AP,GL,FA.
explain your project plan with exam pal? i am preparing inter view .............
What is difference between primary and secondary ledger
Can I do a payment of 50 bills on a post date. If yes, then how?
What is Difference between Auto Copy Journal and recurring journal?
1)What cannot be consolidated in GCS? 2) When you setup calendar in GL is it possible to change it?