What are the tables associated with Invoice?
Answers were Sorted based on User's Feedback
Answer / ritesh gakher
Invoice Base Tables are:
|Is This Answer Correct ?||34 Yes||9 No|
Answer / ramkumar
|Is This Answer Correct ?||26 Yes||10 No|
Answer / 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|
Answer / srikanth
Also AR_PAYMENT_SCHEDULES_ALL which reflects the status of
|Is This Answer Correct ?||14 Yes||2 No|
This table stores invoice, debit memo, commitment, and credit memo header information. Each row includes general invoice information such as customer, transaction type, and printing instructions. You need one row for each invoice, debit memo, commitment, and credit memo you create in Oracle Receivables.
This table stores information about invoice, debit memo, credit memo, and commitment lines. For example, an invoice can have one line for Product A and another line for Product B. You need one row for each line. Invoice, debit memo, credit memo, and commitment lines are distinguished by the transaction type of the corresponding RA_CUSTOMER_TRX_ALL record.
This table stores the accounting records for revenue, unearned revenue and unbilled receivables for each invoice or credit memo line. Each row includes the GL account and the amount of the accounting entry. The AMOUNT column in this table is required even though it is null allowed. You need one row for each accounting distribution. You must have at least one (but you can have multiple) accounting distributions for each invoice or credit memo line. Oracle Receivables uses this information to post the proper amounts to your general ledger. If your invoice or credit memo has a transaction type where Post to GL is set to No, Oracle Receivables assigns Null to GL_DATE. If your AutoAccounting is unable to complete your general ledger default accounts using the AutoAccounting rules you define, incomplete general ledger accounts are stored in CONCATENATED_SEGMENTS.
This table stores all transactions except adjustments and miscellaneous cash receipts. Oracle Receivables updates this table when activity occurs against an invoice, debit memo, chargeback, credit memo, on account credit, or receipt. Oracle Receivables groups different transactions bythe column CLASS. These classes include invoice (INV), debit memos(DM), guarantees (GUAR), credit memos (CM), deposits (DEP),chargebacks (CB), and receipts (PMT). Transaction classes determine which columns in this table Oracle Receivables updates when a transaction occurs, and whether a transaction relates to either the RA_CUSTOMER_TRX_ALL table or the AR_CASH_RECEIPTS_ALLtable. AR_PAYMENT_SCHEDULES_ALL joins to the RA_CUSTOMER_TRX_ALL table for non–payment transaction entries such as the creation of credit memos, debit memos, invoices, chargebacks, or deposits. AR_PAYMENT_SCHEDULES_ALL uses the foreign key CUSTOMER_TRX_ID to join to the RA_CUSTOMER_TRX_ALL table for these transactions. AR_PAYMENT_SCHEDULES_ALL joins to the AR_CASH_RECEIPTS_ALL table for invoice–related payment transactions using the foreign key CASH_RECEIPT_ID. When a receiptis applied,
This table stores all accounting entries for your cash and credit memo applications. Each row includes the amount applied, status, and accounting flexfield information. Possible statuses of your applications include APP, UNAPP, ACC, and UNID. You use this information to determine the applications of your payments or credit memos. CONFIRMED_FLAG is a denormalization from AR_CASH_RECEIPTS_ALL.If the cash receipt is not confirmed, the applications of that receipt are not reflected in the payment schedule of the transaction it is applied against. There are two kinds of applications: CASH and CM (for credit memo applications).
Oracle Functional consultant
|Is This Answer Correct ?||7 Yes||0 No|
Answer / moksh
Don't consider the table aliases
the tables are:-
|Is This Answer Correct ?||10 Yes||5 No|
Answer / venkatboilla
|Is This Answer Correct ?||11 Yes||9 No|
How many reporting Set of Books can be attached to one primary Set of Books
Hi, I actually finished my oracle financials R12 course recently and am planning to attend an interview next week...so can any one help me with some of the important interview questions? I am actually keeping 2 yrs fake exp....
whenever i run the programe transfered to GL from payables that programe is shown with warning error and not transferred entries to GL
What are the various Journal Entries generated through fixed assets
What is the use of defining security hierarchy?
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.
what is the steps to customization ?
what r issues faced in gl
How will call a Key Flexfield Routine in Oracle Apps Forms and what are the arguments to be passed to that routines ? (He was asking me the Package name and Procedure)
If purchasing the goods from supplier, (Client or Vendor) want to pay directly by cash then what is the scenario in Accounts Payable, b'coz there is an only three types of payment are available i.e. 1. Electronic, 2. wire, and 3. cheque, in this case what we need, and is the journal entry will get and how it effect in GL Accounts ? to do
What is the CTA Account& What is the use of this?
Why are expenses items typically accrued at period end, and why are inventory items always accrued on receipt?