AP Tables (237)

AP - Payables — documented tables from Oracle EBS ETRM 12.2.2. Click any name for its documentation, columns and AI summary.

Table	Columns	Description
`AP_1096_DATA_ALL`	7	Summary payment information for 1099 type suppliers
`AP_1099_TAPE_DATA_ALL`	19	Supplier payment amounts by MISC type for 1099 reports on magnetic media
`AP_ACCOUNTING_EVENTS_ALL`	19	Accounting events table
`AP_AE_HEADERS_ALL`	24	Accounting entry headers table
`AP_AE_LINES_ALL`	56	Accounting entry lines table
`AP_AGING_PERIODS`	28	Aging period definitions
`AP_AGING_PERIOD_LINES`	32	Individual aging period information
`AP_ALLOCATION_RULES`	14	AP_ALLOCATION_RULES contains records establishing how charge lines (Freight and Miscellaneous) should be allocated to Item lines. Each reco
`AP_ALLOCATION_RULE_LINES`	14	AP_ALLOCATION_RULE_LINES contains the records that establish which percentage and/or amount of a charge line is to be allocated to a specifi
`AP_APINV_APPROVERS`	43	This table connects approvers to their invoice components, either theinvoice header or the invoice line. The records are created during the
`AP_AUD_AUDITORS`	8	This table stores the auditor information
`AP_AUD_AUDIT_REASONS`	8	This table stores the reasons why an expense report is audited.
`AP_AUD_AUDIT_REASONS_ARC`	10	OIE Archive Table for Audit Reasons
`AP_AUD_AUTO_AUDITS`	10	This table stores an audit list.
`AP_AUD_QUEUES`	8	This table stores a list of expense reports for auditing along with their assignments to auditors.
`AP_AUD_RULE_ASSIGNMENTS_ALL`	10	This table stores the rule set assignments for organizations.
`AP_AUD_RULE_SETS`	76	This table stores the audit rule set information.
`AP_AUD_WORKLOADS`	10	This table stores auditor workloads assigned to auditors for various periods.
`AP_AWT_BUCKETS_ALL`	15	Summary amount of tax withheld to date for a particular supplier site
`AP_AWT_GROUPS`	9	Withholding tax groups
`AP_AWT_GROUP_TAXES_ALL`	9	Withholding group taxes
`AP_AWT_TAX_RATES_ALL`	58	Withholding tax rates
`AP_AWT_TEMP_DISTRIBUTIONS_ALL`	37	Withholding tax temporary distributions
`AP_BANK_ACCOUNTS_ALL`	105
`AP_BANK_ACCOUNT_USES_ALL`	36
`AP_BANK_BRANCHES`	88
`AP_BANK_CHARGES`	16	Bank charges definition information
`AP_BANK_CHARGE_LINES`	13	Ranges for bank charges and tolerance limits
`AP_BATCHES_ALL`	40	Summary invoice batch information
`AP_CARDS_ALL`	59	Information about credit cards issued to employees
`AP_CARD_CODES_ALL`	29	Information for credit card codes that you define
`AP_CARD_CODE_SETS_ALL`	25	Descriptive information about credit card code sets assigned to and used by card programs
`AP_CARD_CURRENCIES`	8	The AP_CARD_CURRENCIES table is used to convert numeric currency values to the ISO currency code for Oracle Internet Expenses credit card tr
`AP_CARD_DETAILS`	14	New Card Details
`AP_CARD_EMP_CANDIDATES`	7	New Card Employee Candidates
`AP_CARD_GL_ACCTS_ALL`	25	Information about the GL accounts and descriptions for credit card GL account sets
`AP_CARD_GL_SETS_ALL`	25	Descriptive information about credit card GL account sets
`AP_CARD_PARAMETERS`	7	Card Expense Type Mappings
`AP_CARD_PROFILES_ALL`	37	Information about the profiles assigned to credit cards distributed to your employees
`AP_CARD_PROFILE_LIMITS_ALL`	30	Reserved for a future feature
`AP_CARD_PROGRAMS_ALL`	60	Information about credit card programs you have defined
`AP_CARD_REQUESTS_ALL`	54	Reserved for a future feature
`AP_CARD_SUPPLIERS_ALL`	9	This table contains all of the information relating to the supplier, supplier site, and credit card.
`AP_CC_ACCEPTORS`	22	This table stores information about credit card acceptors who provide detail-level transaction information.
`AP_CC_TRX_DETAILS`	25	This table stores detail-level credit card transaction information.
`AP_CC_TRX_DETAILS_ARC`	27	Archive table for CC Trx Details
`AP_CHECKRUN_CONC_PROCESSES_ALL`	4	Temporary table for tracking payment batch concurrent programs
`AP_CHECKRUN_CONFIRMATIONS_ALL`	11	Temporary table for payment batch confirmations
`AP_CHECKS_ALL`	156	Supplier payment data
`AP_CHECK_FORMATS`	78	No Longer Used
`AP_CHECK_INTEGERS`	1	No Longer Used
`AP_CHECK_STOCKS_ALL`	42	No Longer Used
`AP_CHRG_ALLOCATIONS_ALL`	15	No longer used
`AP_CHRG_ALLOCATIONS_ALL_EFC`	3
`AP_CREDIT_CARD_TRXNS_ALL`	154	Detailed information about the credit card transactions of your employees
`AP_CREDIT_CARD_TRXNS_ARC`	156	OIE Archive Table for Credit Card Transactions
`AP_CURRENCY_GROUP`	9	Payment currencies for the Payment Process Request Template or the Payment Process Request.
`AP_DBI_LOG`	12	Log table to track the operations on Payables transaction tables relevant to the Daily Business Intelligence product.
`AP_DISTRIBUTION_SETS_ALL`	27	Invoice Distribution Set definitions
`AP_DISTRIBUTION_SET_LINES_ALL`	36	Individual Distribution Set line definitions
`AP_DOC_SEQUENCE_AUDIT`	5	Voucher numbers assigned to invoices and payments
`AP_DUPLICATE_VENDORS_ALL`	20	Supplier information used by Supplier Merge
`AP_ENCUMBRANCE_LINES_ALL`	35	Encumbrance lines table
`AP_ENCUMBRANCE_LINES_ALL_EFC`	4
`AP_ERRORS_GT`	8
`AP_EXPENSE_FEED_DISTS_ALL`	40	Accounting information for credit card transactions
`AP_EXPENSE_FEED_LINES_ALL`	98	Detailed information about credit card transactions imported from the credit card issuer
`AP_EXPENSE_PARAMS_ALL`	15	This table stores the Internet Expenses parameters for organizations.
`AP_EXPENSE_REPORTS_ALL`	13	Descriptive information about expense report templates
`AP_EXPENSE_REPORT_HEADERS_ALL`	116	Header information about employee expense reports
`AP_EXPENSE_REPORT_HEADERS_ARC`	118	OIE Archive Table for Expense Report Headers
`AP_EXPENSE_REPORT_LINES_ALL`	163	Expense item information for employee expense reports
`AP_EXPENSE_REPORT_LINES_ARC`	165	OIE Archive Table for Expense Report Lines
`AP_EXPENSE_REPORT_PARAMS_ALL`	37	Expense type information for expense report templates
`AP_EXP_LOCATIONS`	18	Physical Address
`AP_EXP_REPORT_DISTS_ALL`	52	Expense distributions
`AP_EXP_REPORT_DISTS_ARC`	54	OIE Archive Table for Expense Report Distributions
`AP_EXP_REPORT_HEADERS_GT`	1
`AP_FLEX_SEGMENT_MAPPINGS_ALL`	16	Accounting Flexfield segment sequences used for Expense Distribution Detail Report
`AP_HISTORY_CHECKS_ALL`	13	Summary information about purged invoice payments
`AP_HISTORY_INVOICES_ALL`	11	Summary information about purged invoices
`AP_HISTORY_INV_PAYMENTS_ALL`	4	Relationships between purged invoices and invoice payments
`AP_HOLDS_ALL`	37	Invoice hold information
`AP_HOLD_CODES`	18	Invoice hold and release codes
`AP_IDENT_PARTY_SITE_GT`	2
`AP_INCOME_TAX_REGIONS`	28	Income tax region information for supplier tax reporting purposes
`AP_INCOME_TAX_TYPES`	9	1099 supplier types
`AP_INTEREST_PERIODS`	9	Interest rates and period information used to create Interest invoices
`AP_INTERFACE_CONTROLS`	3	Temporary table for importing invoices from the open interface tables
`AP_INTERFACE_REJECTIONS`	29	Information about data that could not be loaded by Payables Open Interface Import
`AP_INVOICES_ALL`	191	Detailed invoice records
`AP_INVOICES_INTERFACE`	155	Information used to create an invoice using Payables Open Interface Import
`AP_INVOICES_UPG_CONTROL`	14	AP_INVOICES_UPG_CONTRO is used to maintain the record of pre-upgrade programs submitted and their progress.
`AP_INVOICE_DISTRIBUTIONS_ALL`	244	Invoice distribution line information
`AP_INVOICE_DISTRIBUTIONS_GT`	20
`AP_INVOICE_KEY_IND_ALL`	40	Compiled invoice information for Key Indicators Report
`AP_INVOICE_LINES_ALL`	202	AP_INVOICE_LINES_ALL contains records for invoice lines entered manually, generated automatically or imported from the Open Interface.
`AP_INVOICE_LINES_INTERFACE`	185	Information used to create one or more invoice distributions
`AP_INVOICE_PAYMENTS_ALL`	95	Invoice payment records
`AP_INVOICE_PREPAYS_ALL`	10	Invoice prepayment records
`AP_INVOICE_RELATIONSHIPS`	9	Relationships between invoices and interest invoices automatically created for overdue invoices
`AP_INV_APRVL_HIST_ALL`	21	AP_INV_APRVL_HIST_ALL contains the approval and rejection history of each invoice that passes through the Invoice Approval Workflow process.
`AP_INV_DISTS_UPDATE`	244
`AP_INV_SELECTION_CRITERIA_ALL`	93	Payment batch invoice selection criteria
`AP_LE_GROUP`	9	Legal entities for the Payment Process Request Template or the Payment Process Request.
`AP_LIABILITY_BALANCE`	24	Denormalized information about liability accounting entry lines associated with invoices and payments that have been transferred to GL
`AP_LINES_UPG_SYNC_DATA`	11	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`	28	AP_LINE_APRVL_HIST_ALL contains the approval and rejection history of each invoice line that passes through the Invoice Approval Workflow's
`AP_LOCATIONS_GT`	15
`AP_MAP_CODES`	8	QuickCode Map
`AP_MAP_TYPES_B`	11	Mapping Rules
`AP_MAP_TYPES_TL`	10	Translations for AP_MAP_TYPES_B
`AP_MATCHED_RECT_ADJ_ALL`	14	Tracks receipts that have been modified after invoices have been matched to them
`AP_MC_CHECKS`	16	Supplier payment data in MRC defined reporting currency
`AP_MC_INVOICES`	6	Detailed invoice records in MRC defined reporting currency
`AP_MC_INVOICE_DISTS`	22	Invoice distribution line information in MRC defined reporting currency
`AP_MC_INVOICE_PAYMENTS`	9	Invoice payment records in MRC defined reporting currency
`AP_MC_PAYMENT_HISTORY`	11	Payment history records in MRC defined reporting currency
`AP_NEGOTIATION_HIST`	11	Tracks the information changed during negotiation
`AP_NOTES`	13	This table stores information about notes
`AP_NOTES_ARC`	15	Archive table for AP Notes
`AP_NO_MATCH_TRXNS`	7	The AP_NO_MATCH_TRXNS table tracks the matching status of transactions
`AP_OPEN_ITEMS_REVAL_GT`	29
`AP_ORG_ATTRIBUTES_GT`	5
`AP_ORG_COUNTRY_GT`	3
`AP_OTHER_PERIODS`	34	Recurring invoice, key indicator, payment terms, and withholding tax time period definitions
`AP_OTHER_PERIOD_TYPES`	26	Recurring invoice, key indicator, and withholding tax period type definitions
`AP_OU_GROUP`	9	Operating units for the Payment Process Request Template or the Payment Process Request.
`AP_PARTY_CONTACT_SITES_GT`	22
`AP_PAYCARD_TRX_FEE_HEADER`	26	Table AP_PAYCARD_TRX_FEE_HEADER stores header level information of the Transactions fees defined for a Payment Card in Oracle Payables. This
`AP_PAYCARD_TRX_FEE_HEADER_ALL`	26	Table AP_PAYCARD_TRX_FEE_HEADER stores header level information of the Transactions fees defined for a Payment Card in Oracle Payables. This
`AP_PAYCARD_TRX_FEE_LINES`	25	Table AP_PAYCARD_TRX_FEE_LINES stores line level information of the Transaction fees defined for a Payment Card in Oracle Payables. This ta
`AP_PAYMENT_DISTRIBUTIONS_ALL`	18	Payment distribution information
`AP_PAYMENT_HISTORY_ALL`	48	Maturity and reconciliation history for payments
`AP_PAYMENT_HIST_DISTS`	36	The APHD table is populated during the pre-processing of the accounting extract that occurs when the Payables user launches the accounting p
`AP_PAYMENT_KEY_IND_ALL`	34	Compiled payment information for Key Indicators Report
`AP_PAYMENT_PROGRAMS`	11	Payment programs used for defining payment formats
`AP_PAYMENT_REP_ITF`	66	Payables Interface table for RX payment reports
`AP_PAYMENT_SCHEDULES_ALL`	76	Scheduled payment information on invoices
`AP_PAYMENT_TEMPLATES`	59	User Defined Payment Process Request Templates
`AP_PAY_GROUP`	9	Pay groups for the Payment Process Request Template or the Payment Process Request.
`AP_PBATCH_SETS_ALL`	9	Payment batch sets
`AP_PBATCH_SET_LINES_ALL`	50	Payment batch set lines
`AP_PERIOD_CLOSE_EXCPS_GT`	39
`AP_POL_CAT_OPTIONS_ALL`	20	This table stores category-specific rules.
`AP_POL_CONTEXT`	7	This table stores user-specific organization context.
`AP_POL_EXRATE_OPTIONS_ALL`	12	This table stores exchange rate tolerances for policy compliance validation.
`AP_POL_EXRATE_TOLERANCES`	9	This table stores exchange rate tolerances for policy compliance validation.
`AP_POL_HEADERS`	60	This table stores the policy schedule header information.
`AP_POL_ITEMIZATIONS`	7	This table stores itemization information for expense types.
`AP_POL_LINES`	50	This table stores the policy schedule line information.
`AP_POL_LINES_HISTORY`	40	This table stores the life cycle of a policy schedule line.
`AP_POL_LOCATIONS_B`	15	This table stores policy schedule location information.
`AP_POL_LOCATIONS_TL`	10	This table stores policy schedule location information.
`AP_POL_SCHEDULE_OPTIONS`	18	This table stores policy schedule-specific rules.
`AP_POL_SCHEDULE_PERIODS`	20	This table stores policy schedule period information.
`AP_POL_VIOLATIONS_ALL`	17	This table is used to store policy violation information for expensereports.
`AP_POL_VIOLATIONS_ARC`	19	OIE Archive Table for Policy Violations
`AP_PPA_INVOICES_GT`	133
`AP_PPA_INVOICE_DISTS_GT1`	110
`AP_PPA_INVOICE_LINES_GT`	160
`AP_PREPAY_APP_DISTS`	42	This table details the distribution of prepayment application invoice distributions to the recipient invoice distribution. Records in this
`AP_PREPAY_HISTORY_ALL`	24	AP_PREPAY_HISTORY_ALL countains the history of a prepayment which includes its related prepayment applications, prepayment unapplications an
`AP_PRODUCT_REGISTRATIONS`	12
`AP_PRODUCT_SETUP`	21	AP_PRODUCT_SETUP contains the options and defaults you define for operating your Oracle Payables application system across all operating uni
`AP_PURGE_INVOICE_LIST`	3	Temporary storage of invoice IDs for invoice purge candidates
`AP_R115_UPGRADE`	2	Release 11i upgrade values for FUTURE DATED and MANUAL FUTURE DATED payment methods
`AP_RECON_DISTRIBUTIONS_ALL`	22	Reconciliation distributions records
`AP_RECON_ERROR_CHK_GROUP_LINES`	8	Associated reconciliation table records used by AutoClear
`AP_RECURRING_PAYMENTS_ALL`	127	Recurring invoice parameters
`AP_REPORTING_ENTITIES_ALL`	37	Tax identification information for a tax reporting entity
`AP_REPORTING_ENTITY_LINES_ALL`	9	Balancing segment information associated with a tax reporting entity
`AP_SELECTED_INVOICES_ALL`	115	Temporary storage of invoices selected for payment in a payment batch
`AP_SELECTED_INVOICE_CHECKS_ALL`	46	No Longer Used
`AP_SELF_ASSESSED_TAX_DIST_ALL`	164	ap_self_assessed_tax_dist contains self assessed tax distributions
`AP_SUPPLIERS`	180	AP_SUPPLIERS stores information about your supplier level attributes.
`AP_SUPPLIERS_INT`	165	AP_SUPPLIERS_INT holds Supplier information which is loaded by the user for import. The columns in the table map to corresponding columns
`AP_SUPPLIER_BALANCE_ITF`	30	Stores records for the AP Supplier Open Balance Letter report
`AP_SUPPLIER_CONTACTS`	52
`AP_SUPPLIER_INT_REJECTIONS`	8	Contains suppliers, sites, contacts rejections information.
`AP_SUPPLIER_SITES_ALL`	164	AP_SUPPLIER_SITES_ALL stores information about your supplier site level attributes.
`AP_SUPPLIER_SITES_INT`	185	AP_SUPPLIER_SITES_INT_ALL holds Supplier Site information which is loadedby the user for import. The columns in the table map to correspond
`AP_SUP_PARTY_SITES_GT`	25
`AP_SUP_SITE_CONTACT_INT`	54	AP_SUP_SITE_CONTACT_INT holds Supplier contact data. The columns in the table map to corresponding columns in PO_VENDOR_CONTACTS table. Th
`AP_SYSTEM_PARAMETERS_ALL`	183	Payables system defaults and parameters
`AP_TAX_ALLOC_AMOUNT_GT`	28
`AP_TAX_CODES_ALL`	66	Tax code information
`AP_TAX_DERIVATIONS`	10	No longer used.
`AP_TAX_RECVRY_RATES_ALL`	55	No longer used
`AP_TAX_RECVRY_RULES_ALL`	46	No longer used
`AP_TB_BALANCES_TMP`	4	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
`AP_TEMP_APPROVAL_ALL`	4	No longer used
`AP_TERMS_LINES`	48	Detail information about payment terms
`AP_TERMS_TL`	32	Payment term definitions
`AP_TOLERANCES_ALL`	16	Matching and invoice variance testing tolerance levels
`AP_TOLERANCE_TEMPLATES`	19	Matching and invoice variance testing tolerance levels
`AP_TRANSMISSIONS_SETUP`	56	No Longer Used
`AP_TRIAL_BAL`	8	No longer used
`AP_TRIAL_BALANCE`	5	Denormalized information about posted invoices for your accrual set of books
`AP_TRIAL_BALANCE_LEDGERS`	7
`AP_UNSELECTED_INVOICES_ALL`	10	This table holds invoices that could not be paid by a payment batch.
`AP_USER_EXCHANGE_RATES`	9	User type exchange rate when submitting the payment process request for multiple currencies and even multiple functional currencies.
`AP_VENDOR_AUDIT_TMP`	3	Temporary table for duplicate supplier candidates during Supplier Merge
`AP_VENDOR_KEY_IND_ALL`	23	Compiled supplier information for the Key Indicators Report
`AP_WEB_ACCFLEX_SEGMENTS`	10	Accounting flexfield setup.
`AP_WEB_AMEX_PARAMS`	15	Download parameters for American Express
`AP_WEB_DISC_LINES_GT`	34
`AP_WEB_EMPLOYEE_INFO_ALL`	11	This table is used to store employee information.
`AP_WEB_PREFERENCES`	20	Stores the user preferences for Oracle Internet Expenses.
`AP_WEB_PROXY_ASSIGNMENTS`	14	Stores reporting access rights relationships.
`AP_WEB_SIGNING_LIMITS_ALL`	10	Tracks signing limit authority for Self-Service Expenses-entered expense reports
`AP_WEB_VAT_SETUP_ALL`	14	This table is used to store VAT-related setup for a specific organization. The VAT-related setup data affects the display of merchant field
`AP_WHT_ITF`	82	Information for the submission of the AP Withholding Tax extract program
`FINANCIALS_PURGES_ALL`	84	Invoice purge selection criteria and purged invoice statistical data
`FINANCIALS_SYSTEM_PARAMS_ALL`	81	Oracle Financials system parameters and defaults
`OIE_ADDON_MILEAGE_RATES`	10	This table stores additional information for a mileage expense type.
`OIE_ADDON_MILEAGE_RATES_ARC`	12	OIE Archive Table for Add on Mileag Rates
`OIE_ALLOCATION_PREFS`	9	User Allocation Preferences
`OIE_ATTENDEES_ALL`	32	Holds the attendee and recipient data for the current expense type.
`OIE_ATTENDEES_ARC`	34	OIE Archive Table for Attendee Information
`OIE_ATTENDEE_GROUPS`	9	Table to hold the Attendee Groups that are created by the users
`OIE_ATTENDEE_GROUP_DETAILS`	32	OIE Attendee Group Details
`OIE_CURRENT_PAGE_SETTING`	13	This table stores the current setting of a region (hide-show, table..) on a page for each user.
`OIE_DATA_CAPTURE_FIELDS`	9	Stores the field behavior for the data capture rules.
`OIE_DATA_CAPTURE_OPTIONS`	9	Stores the attendee types enabled for the data capture rules.
`OIE_DATA_CAPTURE_RULES`	10	Stores the expense type data capture rules.
`OIE_DISTRIBUTION_SETS_ALL`	10	Distribution Set Header Table
`OIE_DUP_DETECT_RS_DETAIL`	8	OIE Duplicate Detection Rule Set Details
`OIE_DUP_DETECT_RS_SUMMARY`	8	OIE Duplicate Detection Rule Set Summary
`OIE_DUP_DETECT_RULES`	27	OIE Duplicate Detection Rules
`OIE_DUP_RULE_ASSIGNMENTS_ALL`	11	OIE Duplicate Detection Rule Assignments
`OIE_PDM_DAILY_BREAKUPS`	28	This table holds per diem data for a rate period.
`OIE_PDM_DAILY_BREAKUPS_ARC`	30	OIE Archive Table for PerDiem Daily Breakups
`OIE_PDM_DESTINATIONS`	10	This table holds per diem destination information.
`OIE_PDM_DESTINATIONS_ARC`	12	OIE Archive Table for PerDiem Destinations
`OIE_POL_RATES_INTERFACE`	19	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`	42	Set Distribution Table.