What are the tables associated with Invoice?




Answers were Sorted based on User's Feedback



What are the tables associated with Invoice?..

Answer / ritesh gakher

Invoice Base Tables are:

AP_INVOICES_ALL
AP_INVOICE_DISTRIBUTIONS_ALL

Is This Answer Correct ?    34 Yes 9 No

What are the tables associated with Invoice?..

Answer / ramkumar

AP_INVOICES_ALL
AP_INVOICE_DISTRIBUTIONS_ALL
AP_PAYMENT_SCHEDULES_ALL

Is This Answer Correct ?    27 Yes 10 No

What are the tables associated with Invoice?..

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




What are the tables associated with Invoice?..

Answer / srikanth

Also AR_PAYMENT_SCHEDULES_ALL which reflects the status of
each invoice.

Is This Answer Correct ?    14 Yes 2 No

What are the tables associated with Invoice?..

Answer / narendar chintam

1) RA_CUSTOMER_TRX_ALL
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.
2) RA_CUSTOMER_TRX_LINES_ALL
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.
3) RA_CUST_TRX_LINE_GL_DIST_ALL
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.
4) AR_PAYMENT_SCHEDULES_ALL
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,
5) AR_RECEIVABLE_APPLICATIONS_ALL
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).


Narendar Chintam
Oracle Functional consultant

Is This Answer Correct ?    7 Yes 0 No

What are the tables associated with Invoice?..

Answer / moksh

Don't consider the table aliases

the tables are:-
ap_invoices_all ai,
ap_batches_all ab,
ap_lookup_codes alc1,
ap_lookup_codes alc2,
ap_lookup_codes alc4,
ap_other_period_types aopt,
ap_recurring_payments_all arp,
ap_terms AT,
ap_system_parameters asp,
fnd_currencies fc,
fnd_document_sequences fds,
fnd_doc_sequence_categories fdsc,
gl_sets_of_books gsob,
gl_daily_conversion_types gdct,
hr_organization_units hou,
po_vendors pv,
po_vendor_sites_all pvs,
ap_awt_groups awt,
pa_projects_all pap,
pa_tasks pat,
zx_fc_business_categories_v zbc,
fnd_territories_tl fnd,
ap_distribution_sets dset,
po_headers ph,
iby_payment_methods_vl iby1,
iby_payment_reasons_vl iby2,
fnd_lookups iby3,
iby_delivery_channels_vl iby4,
fnd_lookups iby5,
iby_ext_bank_accounts ibybnk,
hz_parties hp

Is This Answer Correct ?    10 Yes 5 No

What are the tables associated with Invoice?..

Answer / venkatboilla

AP_INVOICES_ALL
AP_INVOICE_DISTRIBUTIONS_ALL
AP_PAYMENT_SCHEDULES_ALL
AP_INVOICE_PAYMENTS

Is This Answer Correct ?    11 Yes 9 No

What are the tables associated with Invoice?..

Answer / anji26

AP_INVOICES_ALL
AP_INVOICES_LINES _ALL
AP_INVOICE_DISTRIBUTIONS_ALL

Is This Answer Correct ?    0 Yes 0 No

Post New Answer



More Oracle Apps Financial Interview Questions

What is meant by third party payments?

0 Answers  


how to find out one organization using multi-org or single org?

5 Answers   Accenture, Cognizant,


What is the basic setup of payable?

1 Answers   Deloitte,


Can I Change the Value set once i attache to MY COA and can i post the journal entries with assiging the valuesets ti the COA

3 Answers  


What is write off Accruals? what is the use of this?

1 Answers   Genesis,






Hi All, My name is Prashant ..I want to know good institutes in Bangalore which provide training on Oracle Apps Financials..AP,AR,GL,CM,...Mail me at prashant09itagi@gmail.com

9 Answers   ABM, Wipro,


In GL Journal entry can understand which level i.e. batch wise or individually.

3 Answers   Satyam,


Can i know the best institute for oracle apps finance functional training in ameerpet?

2 Answers   Genesis,


What is 2 way , 3 way and 4 way matching?

12 Answers   Shell, HCL, TCS, IBM, Chartered Accountant, MNC,


What are all the standard interfaces in the GL,AP,AR,PO,OM and INV?

5 Answers   TCS, Oracle, Infinite Computer Solutions,


SLA usage ans how to define setups?

0 Answers   IBM, CNO,


What is meant my PO?

4 Answers  






Categories
  • Oracle Apps Technical Interview Questions Oracle Apps Technical (503)
  • Oracle Apps Financial Interview Questions Oracle Apps Financial (774)
  • Oracle Apps Manufacturing Interview Questions Oracle Apps Manufacturing (53)
  • Oracle Apps HRMS Interview Questions Oracle Apps HRMS (82)
  • Oracle Apps CRM Interview Questions Oracle Apps CRM (9)
  • Oracle Apps SCM Interview Questions Oracle Apps SCM (138)
  • Oracle Install Base Interview Questions Oracle Install Base (62)
  • Oracle Service Contracts Interview Questions Oracle Service Contracts (101)
  • Oracle Apps AllOther Interview Questions Oracle Apps AllOther (13)