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 do you mean by Category Set ? and what is its Relevance ?
What is the use of gl set of books name, while configure multiorg?
How to Reconciliation AP to CM ? How to Reconciliation AR to CM ?
What is the procedure for requition import?
Do you track and record relationships between customers e.g. franchises, subsidiaries etc.?
What is automation of accounts payable activities (evaluated receipt settlement)?
Explain about Localization (IND & US ) in Oracle Apps ?
While assigning the security by book in oracle assets..i am unable ot get the asset org in security profile form.This asset org was already defined in org description window.
There is employee X and employee Y (who is supervisor of X); when Y submits expenses how will the system ensures that this should not go to X even if he has the approval authority.
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.
How do u bridge the gaps in functional understanding of AP,GL,FA. explain with some live examples.
I am created credit memo in at but while trying to complete it showing error message-hz_party_location
How will account an advance of Rs.10000/- which is a permanent prepayment, can I make payment for this?
Please post the setups required to approve the payable invoice in AP.
what is the difference between bonus reserve and bonus expense