Interested to Buy Any Domain ? << Click Here >> for more details...
What are the tables associated with Invoice?
- 8 Answers
- 60123 Views
- HCL, IBM, TCS, I also Faced
- E-Mail Answers
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 working on PPR process to print checks. Currently the checks are printing for each supplier, supplier site and payment method group. My requirement is the invoice level one DFF is available (like A and B are the input values). Please let me know how include this DFF at invoice grouping level.
Hi guys, any person available ap,ar material pls send me this mail.id sreenathapps09@gmail.com
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.
Can Adjustments be imported?
I am created credit memo in at but while trying to complete it showing error message-hz_party_location
What is meant RD020
Hi I'm new in ERP - Oracle Application i appriciate if any one help me in this issue i need SQL to get badeget balance Acutal Balance Encumbrance Balance fund Avalable thanx ahmed
1)What cannot be consolidated in GCS? 2) When you setup calendar in GL is it possible to change it?
Do you track and record relationships between customers e.g. franchises, subsidiaries etc.?
Difference between header level tax calculation and line level tax calculation
could you please post some work around that any body have done in the financial modules.
What are the types of setups in apps inventory module
Recurring Problem Posting i have Journals for sep 2018 that i approved but they are not available to post even though the period is open in Oracle R12 Issues
What do you mean by controlling buyers workload?
How to support projects life cycles details?
