Account Payables « Oracle Apps Functional

2Apr/150

Account Payables Tables

These are the account payables tables and their functions

AP_1096_DATA_ALL	Summary payment information for 1099 type suppliers
AP_1099_TAPE_DATA_ALL	Supplier payment amounts by MISC type for 1099 reports on magnetic media
AP_ACCOUNTING_EVENTS_ALL	Accounting events table
AP_AE_HEADERS_ALL	Accounting entry headers table
AP_AGING_PERIODS	Aging period definitions
AP_AGING_PERIOD_LINES	Individual aging period information
AP_ALLOCATION_RULES	AP_ALLOCATION_RULES contains records establishing how charge lines (Freight and Miscellaneous) should be allocated to Item lines. Each record in this table indicates the type of allocation rule that will be generated. The available rule ty
AP_ALLOCATION_RULE_LINES	AP_ALLOCATION_RULE_LINES contains the records that establish which percentage and/or amount of a charge line is to be allocated to a specific item line. Allocation rule lines are created as children of an allocation rule, which is stored
AP_AUD_AUDIT_REASONS	This table stores the reasons why an expense report is audited.
AP_AUD_QUEUES	This table stores a list of expense reports for auditing along with their assignments to auditors.
AP_APINV_APPROVERS	This table connects approvers to their invoice components, either theinvoice header or the invoice line. The records are created during the InvoiceApproval Workflow process.
AP_AUD_AUDITORS	This table stores the auditor information
AP_AUD_AUDIT_REASONS_ARC	OIE Archive Table for Audit Reasons
AP_AUD_AUTO_AUDITS	This table stores an audit list.
AP_AUD_RULE_ASSIGNMENTS_ALL	This table stores the rule set assignments for organizations.
AP_AUD_RULE_SETS	This table stores the audit rule set information.
AP_AUD_WORKLOADS	This table stores auditor workloads assigned to auditors for various periods.
AP_AWT_TEMP_DISTRIBUTIONS_ALL	Withholding tax temporary distributions
AP_AWT_BUCKETS_ALL	Summary amount of tax withheld to date for a particular supplier site
AP_BANK_CHARGES	Bank charges definition information
AP_AWT_GROUP_TAXES_ALL	Withholding group taxes
AP_AWT_GROUPS	Withholding tax groups
AP_AWT_TAX_RATES_ALL	Withholding tax rates
AP_BANK_CHARGE_LINES	Ranges for bank charges and tolerance limits
AP_BATCHES_ALL	Summary invoice batch information
AP_BANK_TRANSMISSIONS	This table corresponds to the Transmission Window.
AP_CARD_DETAILS	New Card Details
AP_CARDS_ALL	Information about credit cards issued to employees
AP_CARD_CODES_ALL	Information for credit card codes that you define
AP_CARD_GL_SETS_ALL	Descriptive information about credit card GL account sets
AP_CARD_PARAMETERS	Card Expense Type Mappings
AP_CARD_CODE_SETS_ALL	Descriptive information about credit card code sets assigned to and used by card programs
AP_CARD_PROFILES_ALL	Information about the profiles assigned to credit cards distributed to your employees
AP_CARD_PROFILE_LIMITS_ALL	Reserved for a future feature
AP_CARD_PROGRAMS_ALL	Information about credit card programs you have defined
AP_CARD_EMP_CANDIDATES	New Card Employee Candidates
AP_CARD_CURRENCIES	The AP_CARD_CURRENCIES table is used to convert numeric currency values to the ISO currency code for Oracle Internet Expenses credit card transactions
AP_CARD_GL_ACCTS_ALL	Information about the GL accounts and descriptions for credit card GL account sets
AP_CARD_SUPPLIERS_ALL	This table contains all of the information relating to the supplier, supplier site, and credit card.
AP_CHECKRUN_CONC_PROCESSES_ALL	Temporary table for tracking payment batch concurrent programs
AP_CARD_REQUESTS_ALL	Reserved for a future feature
AP_CC_ACCEPTORS	This table stores information about credit card acceptors who provide detail-level transaction information.
AP_CHECK_INTEGERS	No Longer Used
AP_CC_TRX_DETAILS	This table stores detail-level credit card transaction information.
AP_CC_TRX_DETAILS_ARC	Archive table for CC Trx Details
AP_CHECK_TRANSMISSIONS	Temporary table containing payment information used for posting to the general ledger
AP_CHECKRUN_CONFIRMATIONS_ALL	Temporary table for payment batch confirmations
AP_CHECKS_ALL	Supplier payment data
AP_CHECK_FORMATS	No Longer Used
AP_CHECK_STOCKS_ALL	No Longer Used
AP_CHRG_ALLOCATIONS_ALL	No longer used
AP_CREDIT_CARD_TRXNS_ARC	OIE Archive Table for Credit Card Transactions
AP_CURRENCY_GROUP	Payment currencies for the Payment Process Request Template or the Payment Process Request.
AP_DOC_SEQUENCE_AUDIT	Voucher numbers assigned to invoices and payments
AP_CREDIT_CARD_TRXNS_ALL	Detailed information about the credit card transactions of your employees
AP_DBI_LOG	Log table to track the operations on Payables transaction tables relevant to the Daily Business Intelligence product.
AP_DISTRIBUTION_SET_LINES_ALL	Individual Distribution Set line definitions
AP_DISTRIBUTION_SETS_ALL	Invoice Distribution Set definitions
AP_DUPLICATE_VENDORS_ALL	Supplier information used by Supplier Merge
AP_ENCUMBRANCE_LINES_ALL	Encumbrance lines table
AP_EXPENSE_PARAMS_ALL	This table stores the Internet Expenses parameters for organizations.
AP_EXPENSE_REPORT_HEADERS_ARC	OIE Archive Table for Expense Report Headers
AP_EXPENSE_REPORT_LINES_ARC	OIE Archive Table for Expense Report Lines
AP_EXPENSE_FEED_DISTS_ALL	Accounting information for credit card transactions
AP_EXPENSE_FEED_LINES_ALL	Detailed information about credit card transactions imported from the credit card issuer
AP_EXP_LOCATIONS	Physical Address
AP_EXPENSE_REPORTS_ALL	Descriptive information about expense report templates
AP_EXPENSE_REPORT_HEADERS_ALL	Header information about employee expense reports
AP_EXPENSE_REPORT_LINES_ALL	Expense item information for employee expense reports
AP_EXPENSE_REPORT_PARAMS_ALL	Expense type information for expense report templates
AP_EXP_REPORT_DISTS_ALL	Expense distributions
AP_EXP_REPORT_DISTS_ARC	OIE Archive Table for Expense Report Distributions
AP_HISTORY_INVOICES_ALL	Summary information about purged invoices
AP_HISTORY_INV_PAYMENTS_ALL	Relationships between purged invoices and invoice payments
AP_FLEX_SEGMENT_MAPPINGS_ALL	Accounting Flexfield segment sequences used for Expense Distribution Detail Report
AP_HISTORY_CHECKS_ALL	Summary information about purged invoice payments
AP_INCOME_TAX_TYPES	1099 supplier types
AP_HOLDS_ALL	Invoice hold information
AP_HOLD_CODES	Invoice hold and release codes
AP_INTEREST_PERIODS	Interest rates and period information used to create Interest invoices
AP_INCOME_TAX_REGIONS	Income tax region information for supplier tax reporting purposes
AP_INTERFACE_CONTROLS	Temporary table for importing invoices from the open interface tables
AP_INTERFACE_REJECTIONS	Information about data that could not be loaded by Payables Open Interface Import
AP_INVOICES_INTERFACE	Information used to create an invoice using Payables Open Interface Import
AP_INVOICES_UPG_CONTROL	AP_INVOICES_UPG_CONTRO is used to maintain the record of pre-upgrade programs submitted and their progress.
AP_INVOICE_KEY_IND_ALL	Compiled invoice information for Key Indicators Report
AP_INVOICE_DISTRIBUTIONS_ALL	Invoice distribution line information
AP_INVOICE_LINES_ALL	AP_INVOICE_LINES_ALL contains records for invoice lines entered manually, generated automatically or imported from the Open Interface.
AP_INVOICE_LINES_INTERFACE	Information used to create one or more invoice distributions
AP_INVOICE_PAYMENTS_ALL	Invoice payment records
AP_INVOICES_ALL	Detailed invoice records
AP_INVOICE_PREPAYS_ALL	Invoice prepayment records
AP_INVOICE_RELATIONSHIPS	Relationships between invoices and interest invoices automatically created for overdue invoices
AP_INVOICE_TRANSMISSIONS	Temporary table for the invoice information used for posting to the general ledger
AP_INV_APRVL_HIST_ALL	AP_INV_APRVL_HIST_ALL contains the approval and rejection history of each invoice that passes through the Invoice Approval Workflow process. The process inserts a record for each approver assigned to review an invoice.
AP_LIABILITY_BALANCE	Denormalized information about liability accounting entry lines associated with invoices and payments that have been transferred to GL
AP_LINES_UPG_SYNC_DATA	AP_LINES_UPG_SYNC_DATA is used to record the invoice information that are captured through the triggers on the invoice transaction tables.
AP_LINE_APRVL_HIST_ALL	AP_LINE_APRVL_HIST_ALL contains the approval and rejection history of each invoice line that passes through the Invoice Approval Workflow's approval phase process. The process inserts a record for each approver assigned to review an invoice
AP_INV_SELECTION_CRITERIA_ALL	Payment batch invoice selection criteria
AP_LE_GROUP	Legal entities for the Payment Process Request Template or the Payment Process Request.
AP_MAP_CODES	QuickCode Map
AP_MAP_TYPES_B	Mapping Rules
AP_MC_INVOICES	Detailed invoice records in MRC defined reporting currency
AP_MC_CHECKS	Supplier payment data in MRC defined reporting currency
AP_MC_INVOICE_DISTS	Invoice distribution line information in MRC defined reporting currency
AP_MC_INVOICE_PAYMENTS	Invoice payment records in MRC defined reporting currency
AP_MAP_TYPES_TL	Translations for AP_MAP_TYPES_B
AP_MATCHED_RECT_ADJ_ALL	Tracks receipts that have been modified after invoices have been matched to them
AP_MC_PAYMENT_HISTORY	Payment history records in MRC defined reporting currency
AP_NEGOTIATION_HIST	Tracks the information changed during negotiation
AP_NOTES	This table stores information about notes
AP_NOTES_ARC	Archive table for AP Notes
AP_NO_MATCH_TRXNS	The AP_NO_MATCH_TRXNS table tracks the matching status of transactions
AP_OTHER_PERIOD_TYPES	Recurring invoice, key indicator, and withholding tax period type definitions
AP_PAYCARD_TRX_FEE_HEADER	Table AP_PAYCARD_TRX_FEE_HEADER stores header level information of the Transactions fees defined for a Payment Card in Oracle Payables. This tablecorresponds to the header region of the 'Transaction Fees' window. There will be one row in th
AP_PAYCARD_TRX_FEE_LINES	Table AP_PAYCARD_TRX_FEE_LINES stores line level information of the Transaction fees defined for a Payment Card in Oracle Payables. This table corresponds to the lines region of the "Transaction Fees" window. For a unique combination of
AP_PAYCARD_TRX_FEE_HEADER_ALL	Table AP_PAYCARD_TRX_FEE_HEADER stores header level information of the Transactions fees defined for a Payment Card in Oracle Payables. This table corresponds to the header region of the 'Transaction Fees' window.There will be one row in th
AP_OTHER_PERIODS	Recurring invoice, key indicator, payment terms, and withholding tax time period definitions
AP_PAYMENT_HISTORY_ALL	Maturity and reconciliation history for payments
AP_OU_GROUP	Operating units for the Payment Process Request Template or the Payment Process Request.
AP_PAYMENT_HIST_DISTS	The APHD table is populated during the pre-processing of the accounting extract that occurs when the Payables user launches the accounting process. Payment distributions are associated with payment accounting events referenced in each row
AP_PAYMENT_DISTRIBUTIONS_ALL	Payment distribution information
AP_PAYMENT_KEY_IND_ALL	Compiled payment information for Key Indicators Report
AP_PAYMENT_REP_ITF	Payables Interface table for RX payment reports
AP_PAYMENT_PROGRAMS	Payment programs used for defining payment formats
AP_POL_CAT_OPTIONS_ALL	This table stores category-specific rules.
AP_PAYMENT_SCHEDULES_ALL	Scheduled payment information on invoices
AP_PAYMENT_TEMPLATES	User Defined Payment Process Request Templates
AP_PAY_GROUP	Pay groups for the Payment Process Request Template or the Payment Process Request.
AP_PBATCH_SETS_ALL	Payment batch sets
AP_PBATCH_SET_LINES_ALL	Payment batch set lines
AP_POL_CONTEXT	This table stores user-specific organization context.
AP_POL_EXRATE_OPTIONS_ALL	This table stores exchange rate tolerances for policy compliance validation.
AP_POL_EXRATE_TOLERANCES	This table stores exchange rate tolerances for policy compliance validation.
AP_POL_LOCATIONS_TL	This table stores policy schedule location information.
AP_POL_HEADERS	This table stores the policy schedule header information.
AP_POL_ITEMIZATIONS	This table stores itemization information for expense types.
AP_POL_LINES	This table stores the policy schedule line information.
AP_POL_VIOLATIONS_ALL	This table is used to store policy violation information for expensereports.
AP_POL_LINES_HISTORY	This table stores the life cycle of a policy schedule line.
AP_POL_LOCATIONS_B	This table stores policy schedule location information.
AP_POL_VIOLATIONS_ARC	OIE Archive Table for Policy Violations
AP_POL_SCHEDULE_OPTIONS	This table stores policy schedule-specific rules.
AP_POL_SCHEDULE_PERIODS	This table stores policy schedule period information.
AP_PREPAY_APP_DISTS	This table details the distribution of prepayment application invoice distributions to the recipient invoice distribution. Records in this table will be created during the data extraction pre-processing from AP to SLA. The records in th
AP_PREPAY_HISTORY_ALL	AP_PREPAY_HISTORY_ALL countains the history of a prepayment which includes its related prepayment applications, prepayment unapplications and prepayment application adjustments. A row is created in APPH when the Prepayment Applied, Prepay
AP_PRODUCT_SETUP	AP_PRODUCT_SETUP contains the options and defaults you define for operating your Oracle Payables application system across all operating units. This table contains information such as your default payment terms and payment method. Your Orac
AP_R115_UPGRADE	Release 11i upgrade values for FUTURE DATED and MANUAL FUTURE DATED payment methods
AP_RECON_CHECK_RESULTS	Temporary storage of payment subtotals used for bank account reconciliation comparison
AP_RECON_DETAILS	Temporary storage of header and detail bank reconciliation information
AP_RECON_DISTRIBUTIONS_ALL	Reconciliation distributions records
AP_PURGE_INVOICE_LIST	Temporary storage of invoice IDs for invoice purge candidates
AP_RECON_ERROR_CHK_GROUPS	Bank reconciliation error checking structures used by AutoClear
AP_RECON_ERROR_CHK_GROUP_LINES	Associated reconciliation table records used by AutoClear
AP_RECON_RECORD_CODES	Bank reconciliation record descriptions used by AutoClear
AP_RECON_SUMMARIES	Temporary storage of bank-supplied reconciliation categorized sub-totals
AP_RECON_TRANSACTION_CODES	Bank detail reconciliation transaction codes
AP_RECON_LOCKS	Temporary table for monitoring AutoClear processes
AP_REPORTING_ENTITY_LINES_ALL	Balancing segment information associated with a tax reporting entity
AP_RECON_RECORD_SPECS	Bank reconciliation flat file structures used by AutoClear
AP_RECURRING_PAYMENTS_ALL	Recurring invoice parameters
AP_REPORTING_ENTITIES_ALL	Tax identification information for a tax reporting entity
AP_SELECTED_INVOICES_ALL	Temporary storage of invoices selected for payment in a payment batch
AP_SELECTED_INVOICE_CHECKS_ALL	No Longer Used
AP_SELF_ASSESSED_TAX_DIST_ALL	ap_self_assessed_tax_dist contains self assessed tax distributions
AP_SUPPLIER_BALANCE_ITF	Stores records for the AP Supplier Open Balance Letter report
AP_SUPPLIER_INT_REJECTIONS	Contains suppliers, sites, contacts rejections information.
AP_SUPPLIERS	AP_SUPPLIERS stores information about your supplier level attributes.
AP_SUPPLIER_SITES_INT	AP_SUPPLIER_SITES_INT_ALL holds Supplier Site information which is loadedby the user for import. The columns in the table map to corresponding columnsin PO_VENDOR_SITES_ALL table. The Oracle Payables application uses this information to
AP_SUP_SITE_CONTACT_INT	AP_SUP_SITE_CONTACT_INT holds Supplier contact data. The columns in the table map to corresponding columns in PO_VENDOR_CONTACTS table. The Oracle Payables application uses this information to create a new Supplier Contact record when th
AP_SUPPLIERS_INT	AP_SUPPLIERS_INT holds Supplier information which is loaded by the user for import. The columns in the table map to corresponding columns in the PO_VENDORS table. The Oracle Payables application uses this information to create a new Supp
AP_SUPPLIER_SITES_ALL	AP_SUPPLIER_SITES_ALL stores information about your supplier site level attributes.
AP_SYSTEM_PARAMETERS_ALL	Payables system defaults and parameters
AP_TAX_DERIVATIONS	No longer used.
AP_TAX_RECVRY_RATES_ALL	No longer used
AP_TB_BALANCES_TMP	AP_TB_BALANCES_TMP stores balance amounts for each liability account within a ledger as of the balance date. This table is used during trial balance upgrade to populate the account balances based on XLA_UPGRADE_DATES.start_date
AP_TEMP_APPROVAL_ALL	No longer used
AP_TAX_CODES_ALL	Tax code information
AP_TERMS_LINES	Detail information about payment terms
AP_TOLERANCES_ALL	Matching and invoice variance testing tolerance levels
AP_TAX_RECVRY_RULES_ALL	No longer used
AP_TRANSMISSIONS_SETUP	No Longer Used
AP_TERMS_TL	Payment term definitions
AP_TOLERANCE_TEMPLATES	Matching and invoice variance testing tolerance levels
AP_TRIAL_BAL	No longer used
AP_TRIAL_BALANCE	Denormalized information about posted invoices for your accrual set of books
AP_UNSELECTED_INVOICES_ALL	This table holds invoices that could not be paid by a payment batch.
AP_USER_EXCHANGE_RATES	User type exchange rate when submitting the payment process request for multiple currencies and even multiple functional currencies.
AP_VENDOR_AUDIT_TMP	Temporary table for duplicate supplier candidates during Supplier Merge
AP_VENDOR_KEY_IND_ALL	Compiled supplier information for the Key Indicators Report
AP_WEB_ACCFLEX_SEGMENTS	Accounting flexfield setup.
AP_WEB_AMEX_PARAMS	Download parameters for American Express
AP_WEB_EMPLOYEE_INFO_ALL	This table is used to store employee information.
AP_WEB_PREFERENCES	Stores the user preferences for Oracle Internet Expenses.
AP_WEB_SIGNING_LIMITS_ALL	Tracks signing limit authority for Self-Service Expenses-entered expense reports
AP_WEB_VAT_SETUP_ALL	This table is used to store VAT-related setup for a specific organization. The VAT-related setup data affects the display of merchant fields on the Expense Line Details page.
AP_WHT_ITF	Information for the submission of the AP Withholding Tax extract program
FINANCIALS_PURGES	Invoice purge selection criteria and purged invoice statistical data
AP_WEB_PROXY_ASSIGNMENTS	Stores reporting access rights relationships.
FINANCIALS_PURGES_ALL	Invoice purge selection criteria and purged invoice statistical data
OIE_ADDON_MILEAGE_RATES	This table stores additional information for a mileage expense type.
OIE_ADDON_MILEAGE_RATES_ARC	OIE Archive Table for Add on Mileag Rates
OIE_ALLOCATION_PREFS	User Allocation Preferences
OIE_ATTENDEES_ALL	Holds the attendee and recipient data for the current expense type.
FINANCIALS_SYSTEM_PARAMS_ALL	Oracle Financials system parameters and defaults
OIE_ATTENDEES_ARC	OIE Archive Table for Attendee Information
OIE_ATTENDEE_GROUPS	Table to hold the Attendee Groups that are created by the users
OIE_ATTENDEE_GROUP_DETAILS	OIE Attendee Group Details
OIE_CURRENT_PAGE_SETTING	This table stores the current setting of a region (hide-show, table..) on a page for each user.
OIE_DATA_CAPTURE_FIELDS	Stores the field behavior for the data capture rules.
OIE_DATA_CAPTURE_OPTIONS	Stores the attendee types enabled for the data capture rules.
OIE_DATA_CAPTURE_RULES	Stores the expense type data capture rules.
OIE_DUP_DETECT_RULES	OIE Duplicate Detection Rules
OIE_DISTRIBUTION_SETS_ALL	Distribution Set Header Table
OIE_DUP_DETECT_RS_DETAIL	OIE Duplicate Detection Rule Set Details
OIE_DUP_DETECT_RS_SUMMARY	OIE Duplicate Detection Rule Set Summary
OIE_DUP_RULE_ASSIGNMENTS_ALL	OIE Duplicate Detection Rule Assignments
OIE_PDM_DAILY_BREAKUPS	This table holds per diem data for a rate period.
OIE_PDM_DAILY_BREAKUPS_ARC	OIE Archive Table for PerDiem Daily Breakups
OIE_PDM_DESTINATIONS_ARC	OIE Archive Table for PerDiem Destinations
OIE_POL_RATES_INTERFACE	This table serves as an interface / staging table for uploaded CONUS and OCONUS rates which can be used to generate policy schedules.
OIE_SET_DISTRIBUTIONS	Set Distribution Table.
OIE_PDM_DESTINATIONS	This table holds per diem destination information.

Filed under: Account Payables No Comments

27May/120

Accounts Payables Close Process

The process to close an accounting period has changed in release 11i. The close process is reviewed here in order to compare it with the close process in prior releases.

Filed under: Account Payables Continue reading

Oracle Apps Functional All About Oracle Apps functional & Technical FAQs, Tutorials

Account Payables Tables

Accounts Payables Close Process

Recent Posts

Recent Comments

Archives

Categories