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
In Subinventories Form, how to enable the Locator Control. A message displayed when changing the drop down list "FRM-40200: Field is protected against update.
What is Reporting of financial data in a project.
On what different real time issues you worked while doing P2P cycle implementation?
How to Reconciliation AP to CM ? How to Reconciliation AR to CM ?
What is meant RD020
What do you mean by Category Set ? and what is its Relevance ?
What are the inventory report to check inventory status.
What is the procedure for requition import?
Invoice Approval Process?
What do you mean by controlling buyers workload?
What kind of necessary ap information you gather from the client?
What is the db number of a particular customer TCA?
Can I do a payment of 50 bills on a post date. If yes, then how?
encumbrence set ups?
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.