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
payment types and payment methods.
How to do the analysis of discounts lost and fixing the root cause?
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
How to Reconciliation AP to CM ? How to Reconciliation AR to CM ?
What is the use of hr: user type, while configure multiorg?
Difference between header level tax calculation and line level tax calculation
Explain Customization process?
What kind of necessary ap information you gather from the client?
What is the db number of a particular customer TCA?
Explain Customer Creation and Maintenance Process. Provide samples of customer master records with Payment Terms.
What is the use of mo: security profile, while configure multiorg?
Anyone provide the oracle fin/scm definetions
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.
Define the activities of the Configuration Manager (AP,GL,FA) in the team. Give examples
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.