Tell me difference between interface tables and base tables?
Submitted by: AdministratorThe difference between the interface and base tables is as below
Interface table: is the table where the data gets validated before data get posted to the base tables. There are many interfaces which are seeded with Oracle. You can consider as the entry point of the data, and the interface checks the sanity of data.
Base tables: As told earlier once the data is validated will get updated in the base tables, and is considered as the data which is in the base table is accurate and used in many ways. (Reporting..etc..)
The base tables in AP are as follows:
1) ap_invoices_all
2) ap_invoice_payments_all
3) ap_invoice_distibutions_All
4) ap_payment_schdules
5) ap_payment_dustributions_all
6) ap_checks_all
7) ap_accounting_events_all
8) ap_bank_accounts_all
9) ap_bank_accounts_uses_all
Submitted by:
Interface table: is the table where the data gets validated before data get posted to the base tables. There are many interfaces which are seeded with Oracle. You can consider as the entry point of the data, and the interface checks the sanity of data.
Base tables: As told earlier once the data is validated will get updated in the base tables, and is considered as the data which is in the base table is accurate and used in many ways. (Reporting..etc..)
The base tables in AP are as follows:
1) ap_invoices_all
2) ap_invoice_payments_all
3) ap_invoice_distibutions_All
4) ap_payment_schdules
5) ap_payment_dustributions_all
6) ap_checks_all
7) ap_accounting_events_all
8) ap_bank_accounts_all
9) ap_bank_accounts_uses_all
Submitted by:
Read Online Clerk Accounts Payable Job Interview Questions And Answers
Top Clerk Accounts Payable Questions
☺ | Explain Standard Purchase Order? |
☺ | Explain when payment request form required? |
☺ | Explain me how many invoices on average do you handle on a daily/weekly/monthly basis? |
☺ | Tell me how to make sense of interviewer questions? |
☺ | Tell me what are your strengths as an accounting professional? |
Top Accounts Categories
☺ | Accounting Interview Questions. |
☺ | Accounts Payable Interview Questions. |
☺ | Senior Accountant Interview Questions. |
☺ | Junior Accountant Interview Questions. |
☺ | Audit Interview Questions. |