Interview Questions Answers.ORG
Interviewer And Interviewee Guide
Interviews
Quizzes
Home
Quizzes
Interviews Accounts Interviews:Account ExecutiveAccount ManagementAccountingAccounting ManagerAccounts PayableAccounts Receivable ClerkAdvertising Account ExecutiveAssistant AccountsAuditBankingBookkeeping ClerkClerk Accounts PayableCost AccountingExecutive AccountsJunior AccountantKey Account ManagersPayroll AssistantPayroll SpecialistSecretary AccountantSenior Accountant
Copyright © 2018. All Rights Reserved
Clerk Accounts Payable Interview Question:
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:
Copyright 2007-2024 by Interview Questions Answers .ORG All Rights Reserved.
https://InterviewQuestionsAnswers.ORG.
https://InterviewQuestionsAnswers.ORG.