What are the tables associated with Invoice?
Answer Posted / 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 |
Post New Answer View All Answers
What is meant RD020
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.
difference between primary ledger and secondary ledger in r12
How will account an advance of Rs.10000/- which is a permanent prepayment, can I make payment for this?
what is the difference between bonus reserve and bonus expense
We have both consumption tax and With Holding Tax on each invoice, will there be any conflict involved?
Write Test Scripts for a telecummunication project on the basis of priority with some examples with regard to AP,GL,FA.
Do you track and record relationships between customers e.g. franchises, subsidiaries etc.?
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.
I am traying to access oracle functiona/ technical interview questions asked by the consultancy "infosys", but i cant find anything when i go the to the links, i need the oracle erp techno functiona questions pls, Thanks, in advance Tovia
1)What cannot be consolidated in GCS? 2) When you setup calendar in GL is it possible to change it?
Can I do a payment of 50 bills on a post date. If yes, then how?
What are the types of setups in apps inventory module
What kind of necessary ap information you gather from the client?
What is the db number of a particular customer TCA?