Clerk Accounts Payable Question:
Tell me difference between interface tables and base tables?
Answer:
The 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
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