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
1)What cannot be consolidated in GCS? 2) When you setup calendar in GL is it possible to change it?
Write Test Scripts for a telecummunication project on the basis of priority with some examples with regard to AP,GL,FA.
What is the use of gl set of books name, while configure multiorg?
What is the use of operating unit, while configure multiorg?
Payables Applications Technical Reference Manual
Charge Back Setups ?
Difference between header level tax calculation and line level tax calculation
payment types and payment methods.
What is multi org? What is difference between 11i and 12i multi org structure?
What is Reporting of financial data in a project.
What is gap analysis, what are the pre-requisities?
How to do the analysis of discounts lost and fixing the root cause?
please explain with examples the below mentioned "Creating the end to end business scenarios and executing the scenarios to perform the regression testing".
We are running Oracle EBS 11i and yesterday whilst doing my month-end I forgot to select "calculate finance charge" on form ARXSUPST AR Print Statement run. I am struggling to get to My Oracle and was hoping someone out there might have experienced or heard of a similar problem. What are my options to rectify this situation... I look forward to you inputs..... Thank you Regards Salie
What is the use of mo: security profile, while configure multiorg?