Oracle eBusiness Suite Technical Reference

Release 11i - Copyright (c) 2001 - 2005 Oracle

This Technical Reference Manual (TRM) in any form, software or printed matter, contains proprietary information of Oracle ; it is provided under an Oracle agreement containing restrictions on use and disclosure and is also protected by copyright, patent, and other intellectual property law. Restrictions applicable to this TRM include, but are not limited to: (a) exercising either the same degree of care to safeguard the confidentiality of this TRM as you exercise to safeguard the confidentiality of your own most important Confidential Information or a reasonable degree of care, whichever is greater; (b) maintaining agreements with your employees and agents that protect the Confidential Information of third parties such as Oracle and instructing such employees and agents of these requirements for this TRM; (c) restricting disclosure of this TRM to those of your employees who have a 'need to know' consistent with the purposes for which this TRM was disclosed to you; (d) maintaining this TRM at all times on your premises; (e) not removing or destroying any proprietary or confidential legends or markings placed upon this TRM in whatever form, software or printed matter; and (f) not reproducing or transmitting this TRM in any form or by any means, electronic or mechanical, for any purpose, without the express written permission of Oracle. You should not use this TRM in any form, software or printed matter, to create software that performs the same or similar functions as any Oracle products.

The information in this TRM is subject to change without notice. If you find any problems in the TRM in any form, software or printed matter, please report them to us in writing. Oracle does not warrant that this TRM is error free. This TRM is provided to customer 'as is' with no warranty of any kind. This TRM does not constitute Documentation as that term is defined in Oracle's agreements. Reverse engineering of the Programs (software and documentation) associated with this TRM are prohibited. The Programs associated with this TRM are not intended for use in any nuclear, aviation, mass transit, medical, or other inherently dangerous applications. It shall be licensee's responsibility to take all appropriate fail safe, backup, redundancy and other measures to ensure the safe use of such applications if the Programs are used for such purposes, and Oracle disclaims liability for any damages caused by such use of the Programs. Program Documentation is licensed for use solely to support the deployment of the Programs and not for any other any other purpose. Restricted Rights Legend

This TRM and the Programs associated with this TRM delivered subject to the DOD FAR Supplement are 'commercial computer software' and use, duplication and disclosure of the TRM and the Programs associated with this TRM shall be subject to the licensing restrictions set forth in the applicable Oracle license agreement. Otherwise, this TRM and the Programs associated with this TRM delivered subject to the Federal Acquisition Regulations are 'restricted computer software' and use, duplication and disclosure of the TRM and the Programs associated with this TRM shall be subject to the restrictions in FAR 52.227-14, Rights in Data General, including Alternate III (June 1987). Oracle, 500 Oracle Parkway, Redwood City, CA 94065.

Oracle is a registered trademark. AIM Advantage™, Big Business. Small Business. All Business.™, CDM Advantage™, .comference™, ConText®, Des40®, Easy*Query™, Easy*SQL®, Education Objects™, EMM Advantage™, Enabling the Information Age®, ExpertDetectSM, Express®, FastForwardSM, GEMMS®, Gist™, Hyper*SQL™, instantOracle™, "Internet Business Intelligence - Insight for Everyone"™, iSQL*Plus™, JInitiator™, NLS*Workbench®, Object Marketplace™, ODP Pulse™, ODP Techwire™, OLA™, On Oracle™, Oracle®, Oracle Book®, Oracle Bookbatch®, Oracle BookBuilder®, OracleBRONZE®, Oracle Business OnLine®, OracleDevConnectSM, Oracle® Discoverer™, Oracle® Expert™, Oracle Financials®, OracleGOLDSM, OracleIncidentSM, OracleJSP™, OracleLifeCycleSM, Oracle Media Objects®, OracleMERCURYSM, OracleMetaLinkSM, OraclemetalsSM, OracleMobile™, Oracle Names®, Oracle NetSolutions®, Oracle® One™, Oracle Open Gateways®, Oracle OpenWorld®, OraclePLATINUMSM, Oracle Power Objects®, Oracle Press®, Oracle Procedural Gateway®, Oracle Quality®, Oracle Secure Network Services®, OracleSILVERSM, Oracle® SQL/Services™, Oracle® SQL*TutorSM, OracleSTERLINGSM, Oracle Store®, Oracle Transparent Gateway®, OracleWare®, Oracle8i™, Oracle9i™, PC Express®, Personal Express®, PJM Advantage™, PL/SQL™, Pro*Ada®, Pro*C™, Pro*C/C++™, Pro*COBOL®, Pro*FORTRAN®, Pro*Pascal®, Pro*PL/1®, Pro*REXX®, Profit™, ProREXX™, Report Card™, Secure Access 2.0™, Secure Network Services®, Security Without Compromise™, SellingPoint®, SQL*Plus®, Tutor™ are trademarks or registered trademarks of Oracle. Other names may be trademarks of their respective owners. The absence of a product or service name, slogan, or logo from this list does not constitute a waiver of Oracle's trademark or other intellectual property rights concerning that name, slogan, or logo.

eTRM - SQLAP Tables and Views

TABLE - AP.AP_1096_DATA_ALL

TABLE - AP.AP_1099_TAPE_DATA_ALL

TABLE - AP.AP_ACCOUNTING_EVENTS_ALL

TABLE - AP.AP_AE_HEADERS_ALL

TABLE - AP.AP_AE_LINES_ALL

TABLE - AP.AP_AGING_PERIODS

TABLE - AP.AP_AGING_PERIOD_LINES

TABLE - AP.AP_ALLOCATION_RULES

TABLE - AP.AP_ALLOCATION_RULE_LINES

TABLE - AP.AP_APINV_APPROVERS

TABLE - AP.AP_AUD_AUDITORS

TABLE - AP.AP_AUD_AUDIT_REASONS

TABLE - AP.AP_AUD_AUTO_AUDITS

TABLE - AP.AP_AUD_QUEUES

TABLE - AP.AP_AUD_RULE_ASSIGNMENTS_ALL

TABLE - AP.AP_AUD_RULE_SETS

TABLE - AP.AP_AUD_WORKLOADS

TABLE - AP.AP_AWT_BUCKETS_ALL

TABLE - AP.AP_AWT_GROUPS

TABLE - AP.AP_AWT_GROUP_TAXES_ALL

TABLE - AP.AP_AWT_TAX_RATES_ALL

TABLE - AP.AP_AWT_TEMP_DISTRIBUTIONS_ALL

TABLE - AP.AP_BANK_ACCOUNTS_ALL

TABLE - AP.AP_BANK_ACCOUNT_USES_ALL

TABLE - AP.AP_BANK_BRANCHES

TABLE - AP.AP_BANK_CHARGES

TABLE - AP.AP_BANK_CHARGE_LINES

TABLE - AP.AP_BATCHES_ALL

TABLE - AP.AP_CARDS_ALL

TABLE - AP.AP_CARD_CODES_ALL

TABLE - AP.AP_CARD_CODE_SETS_ALL

TABLE - AP.AP_CARD_CURRENCIES

TABLE - AP.AP_CARD_DETAILS

TABLE - AP.AP_CARD_EMP_CANDIDATES

TABLE - AP.AP_CARD_GL_ACCTS_ALL

TABLE - AP.AP_CARD_GL_SETS_ALL

TABLE - AP.AP_CARD_PARAMETERS

TABLE - AP.AP_CARD_PROFILES_ALL

TABLE - AP.AP_CARD_PROFILE_LIMITS_ALL

TABLE - AP.AP_CARD_PROGRAMS_ALL

TABLE - AP.AP_CARD_REQUESTS_ALL

TABLE - AP.AP_CARD_SUPPLIERS_ALL

TABLE - AP.AP_CC_ACCEPTORS

TABLE - AP.AP_CC_TRX_DETAILS

TABLE - AP.AP_CHECKRUN_CONC_PROCESSES_ALL

TABLE - AP.AP_CHECKRUN_CONFIRMATIONS_ALL

TABLE - AP.AP_CHECKS_ALL

TABLE - AP.AP_CHECK_FORMATS

TABLE - AP.AP_CHECK_INTEGERS

TABLE - AP.AP_CHECK_STOCKS_ALL

TABLE - AP.AP_CHRG_ALLOCATIONS_ALL

TABLE - AP.AP_CHRG_ALLOCATIONS_ALL_EFC

TABLE - AP.AP_CREDIT_CARD_TRXNS_ALL

TABLE - AP.AP_CURRENCY_GROUP

TABLE - AP.AP_DBI_LOG

TABLE - AP.AP_DISTRIBUTION_SETS_ALL

TABLE - AP.AP_DISTRIBUTION_SET_LINES_ALL

TABLE - AP.AP_DOC_SEQUENCE_AUDIT

TABLE - AP.AP_DUPLICATE_VENDORS_ALL

TABLE - AP.AP_ENCUMBRANCE_LINES_ALL

TABLE - AP.AP_ENCUMBRANCE_LINES_ALL_EFC

TABLE - AP.AP_EXPENSE_FEED_DISTS_ALL

TABLE - AP.AP_EXPENSE_FEED_LINES_ALL

TABLE - AP.AP_EXPENSE_PARAMS_ALL

TABLE - AP.AP_EXPENSE_REPORTS_ALL

TABLE - AP.AP_EXPENSE_REPORT_HEADERS_ALL

TABLE - AP.AP_EXPENSE_REPORT_LINES_ALL

TABLE - AP.AP_EXPENSE_REPORT_PARAMS_ALL

TABLE - AP.AP_EXP_LOCATIONS

TABLE - AP.AP_EXP_REPORT_DISTS_ALL

TABLE - AP.AP_FLEX_SEGMENT_MAPPINGS_ALL

TABLE - AP.AP_HISTORY_CHECKS_ALL

TABLE - AP.AP_HISTORY_INVOICES_ALL

TABLE - AP.AP_HISTORY_INV_PAYMENTS_ALL

TABLE - AP.AP_HOLDS_ALL

TABLE - AP.AP_HOLD_CODES

TABLE - AP.AP_IDENT_PARTY_SITE_GT

TABLE - AP.AP_INCOME_TAX_REGIONS

TABLE - AP.AP_INCOME_TAX_TYPES

TABLE - AP.AP_INTEREST_PERIODS

TABLE - AP.AP_INTERFACE_CONTROLS

TABLE - AP.AP_INTERFACE_REJECTIONS

TABLE - AP.AP_INVOICES_ALL

TABLE - AP.AP_INVOICES_INTERFACE

TABLE - AP.AP_INVOICES_UPG_CONTROL

TABLE - AP.AP_INVOICE_DISTRIBUTIONS_ALL

TABLE - APPS.AP_INVOICE_DISTRIBUTIONS_GT

TABLE - AP.AP_INVOICE_KEY_IND_ALL

TABLE - AP.AP_INVOICE_LINES_ALL

TABLE - AP.AP_INVOICE_LINES_INTERFACE

TABLE - AP.AP_INVOICE_PAYMENTS_ALL

TABLE - AP.AP_INVOICE_PREPAYS_ALL

TABLE - AP.AP_INVOICE_RELATIONSHIPS

TABLE - AP.AP_INV_APRVL_HIST_ALL

TABLE - AP.AP_INV_DISTS_UPDATE

TABLE - AP.AP_INV_SELECTION_CRITERIA_ALL

TABLE - AP.AP_LE_GROUP

TABLE - AP.AP_LIABILITY_BALANCE

TABLE - AP.AP_LINES_UPG_SYNC_DATA

TABLE - AP.AP_LINE_APRVL_HIST_ALL

TABLE - AP.AP_MAP_CODES

TABLE - AP.AP_MAP_TYPES_B

TABLE - AP.AP_MAP_TYPES_TL

TABLE - AP.AP_MATCHED_RECT_ADJ_ALL

TABLE - AP.AP_MC_CHECKS

TABLE - AP.AP_MC_INVOICES

TABLE - AP.AP_MC_INVOICE_DISTS

TABLE - AP.AP_MC_INVOICE_PAYMENTS

TABLE - AP.AP_MC_PAYMENT_HISTORY

TABLE - AP.AP_NEGOTIATION_HIST

TABLE - AP.AP_NOTES

TABLE - AP.AP_NO_MATCH_TRXNS

TABLE - AP.AP_ORG_ATTRIBUTES_GT

TABLE - AP.AP_ORG_COUNTRY_GT

TABLE - AP.AP_OTHER_PERIODS

TABLE - AP.AP_OTHER_PERIOD_TYPES

TABLE - AP.AP_OU_GROUP

TABLE - AP.AP_PARTY_CONTACT_SITES_GT

TABLE - AP.AP_PAYCARD_TRX_FEE_HEADER_ALL

TABLE - AP.AP_PAYCARD_TRX_FEE_LINES

TABLE - AP.AP_PAYMENT_DISTRIBUTIONS_ALL

TABLE - AP.AP_PAYMENT_HISTORY_ALL

TABLE - AP.AP_PAYMENT_HIST_DISTS

TABLE - AP.AP_PAYMENT_KEY_IND_ALL

TABLE - AP.AP_PAYMENT_PROGRAMS

TABLE - AP.AP_PAYMENT_REP_ITF

TABLE - AP.AP_PAYMENT_SCHEDULES_ALL

TABLE - AP.AP_PAYMENT_TEMPLATES

TABLE - AP.AP_PAY_GROUP

TABLE - AP.AP_PBATCH_SETS_ALL

TABLE - AP.AP_PBATCH_SET_LINES_ALL

TABLE - AP.AP_PERIOD_CLOSE_EXCPS_GT

TABLE - AP.AP_POL_CAT_OPTIONS_ALL

TABLE - AP.AP_POL_CONTEXT

TABLE - AP.AP_POL_EXRATE_OPTIONS_ALL

TABLE - AP.AP_POL_EXRATE_TOLERANCES

TABLE - AP.AP_POL_HEADERS

TABLE - AP.AP_POL_ITEMIZATIONS

TABLE - AP.AP_POL_LINES

TABLE - AP.AP_POL_LINES_HISTORY

TABLE - AP.AP_POL_LOCATIONS_B

TABLE - AP.AP_POL_LOCATIONS_TL

TABLE - AP.AP_POL_SCHEDULE_OPTIONS

TABLE - AP.AP_POL_SCHEDULE_PERIODS

TABLE - AP.AP_POL_VIOLATIONS_ALL

TABLE - AP.AP_PPA_INVOICES_GT

TABLE - AP.AP_PPA_INVOICE_DISTS_GT

TABLE - AP.AP_PPA_INVOICE_LINES_GT

TABLE - AP.AP_PREPAY_APP_DISTS

TABLE - AP.AP_PREPAY_HISTORY_ALL

TABLE - AP.AP_PRODUCT_REGISTRATIONS

TABLE - AP.AP_PRODUCT_SETUP

TABLE - AP.AP_PURGE_INVOICE_LIST

TABLE - AP.AP_R115_UPGRADE

TABLE - AP.AP_RECON_DISTRIBUTIONS_ALL

TABLE - AP.AP_RECON_ERROR_CHK_GROUP_LINES

TABLE - AP.AP_RECURRING_PAYMENTS_ALL

TABLE - AP.AP_REPORTING_ENTITIES_ALL

TABLE - AP.AP_REPORTING_ENTITY_LINES_ALL

TABLE - AP.AP_SELECTED_INVOICES_ALL

TABLE - AP.AP_SELECTED_INVOICE_CHECKS_ALL

TABLE - AP.AP_SELF_ASSESSED_TAX_DIST_ALL

TABLE - AP.AP_SUPPLIERS

TABLE - AP.AP_SUPPLIERS_INT

TABLE - AP.AP_SUPPLIER_BALANCE_ITF

TABLE - AP.AP_SUPPLIER_CONTACTS

TABLE - AP.AP_SUPPLIER_INT_REJECTIONS

TABLE - AP.AP_SUPPLIER_SITES_ALL

TABLE - AP.AP_SUPPLIER_SITES_INT

TABLE - AP.AP_SUP_SITE_CONTACT_INT

TABLE - AP.AP_SYSTEM_PARAMETERS_ALL

TABLE - AP.AP_TAX_CODES_ALL

TABLE - AP.AP_TAX_DERIVATIONS

TABLE - AP.AP_TAX_RECVRY_RATES_ALL

TABLE - AP.AP_TAX_RECVRY_RULES_ALL

TABLE - AP.AP_TB_BALANCES_TMP

TABLE - AP.AP_TEMP_APPROVAL_ALL

TABLE - AP.AP_TERMS_LINES

TABLE - AP.AP_TERMS_TL

TABLE - AP.AP_TOLERANCES_ALL

TABLE - AP.AP_TOLERANCE_TEMPLATES

TABLE - AP.AP_TRANSMISSIONS_SETUP

TABLE - AP.AP_TRIAL_BAL

TABLE - AP.AP_TRIAL_BALANCE

TABLE - AP.AP_TRIAL_BALANCE_LEDGERS

TABLE - AP.AP_UNSELECTED_INVOICES_ALL

TABLE - AP.AP_USER_EXCHANGE_RATES

TABLE - AP.AP_VENDOR_AUDIT_TMP

TABLE - AP.AP_VENDOR_KEY_IND_ALL

TABLE - AP.AP_WEB_ACCFLEX_SEGMENTS

TABLE - AP.AP_WEB_AMEX_PARAMS

TABLE - AP.AP_WEB_DISC_LINES_GT

TABLE - AP.AP_WEB_EMPLOYEE_INFO_ALL

TABLE - AP.AP_WEB_PREFERENCES

TABLE - AP.AP_WEB_PROXY_ASSIGNMENTS

TABLE - AP.AP_WEB_SIGNING_LIMITS_ALL

TABLE - AP.AP_WEB_VAT_SETUP_ALL

TABLE - AP.AP_WHT_ITF

TABLE - AP.FINANCIALS_PURGES_ALL

TABLE - AP.FINANCIALS_SYSTEM_PARAMS_ALL

TABLE - AP.OIE_ADDON_MILEAGE_RATES

TABLE - AP.OIE_ALLOCATION_PREFS

TABLE - AP.OIE_ATTENDEES_ALL

TABLE - AP.OIE_CURRENT_PAGE_SETTING

TABLE - AP.OIE_DATA_CAPTURE_FIELDS

TABLE - AP.OIE_DATA_CAPTURE_OPTIONS

TABLE - AP.OIE_DATA_CAPTURE_RULES

TABLE - AP.OIE_DISTRIBUTION_SETS_ALL

TABLE - AP.OIE_PDM_DAILY_BREAKUPS

TABLE - AP.OIE_PDM_DESTINATIONS

TABLE - AP.OIE_POL_RATES_INTERFACE

TABLE - AP.OIE_SET_DISTRIBUTIONS

VIEW - APPS.APBV_AP_HOLDS

VIEW - APPS.APBV_AP_INVOICES

VIEW - APPS.APBV_AP_INVOICE_DISTRIBUTIONS

VIEW - APPS.APBV_AP_PAYMENTS

VIEW - APPS.APBV_AP_PAYMENT_TERMS

VIEW - APPS.APBV_CARDS

VIEW - APPS.APBV_CREDIT_CARD_TRXNS

VIEW - APPS.APBV_EXPENSE_REPORT_HEADERS

VIEW - APPS.APBV_EXPENSE_REPORT_LINES

VIEW - APPS.APBV_EXPENSE_REPORT_PARAMS

VIEW - APPS.APBV_EXP_REPORT_DISTS

VIEW - APPS.APBV_POL_VIOLATIONS

VIEW - APPS.APFV_AP_HOLDS

VIEW - APPS.APFV_AP_INVOICES

VIEW - APPS.APFV_AP_INVOICE_DISTRIBUTIONS

VIEW - APPS.APFV_AP_INVOICE_PAYMENTS

VIEW - APPS.APFV_AP_PAYMENTS

VIEW - APPS.APFV_AP_PAYMENT_TERMS

VIEW - APPS.APFV_EXPENSE_REPORTS

VIEW - APPS.APFV_PAYMENT_SCHEDULES

VIEW - APPS.AP_ALLOCATED_LINES_V

VIEW - APPS.AP_ALLOCATION_RULES_V

VIEW - APPS.AP_APPLICABLE_LINES_V

VIEW - APPS.AP_APPLY_PREPAYS_FR_PREPAY_V

VIEW - APPS.AP_APPLY_PREPAYS_V

VIEW - APPS.AP_AUD_EXPENSE_HEADERS_SEC_V

VIEW - APPS.AP_AUD_QUEUE_SUMMARIES_V

VIEW - APPS.AP_AWT_BUCKETS_V

VIEW - APPS.AP_AWT_TEMP_DISTRIBUTIONS_V

VIEW - APPS.AP_BANK_CHARGE_BEAERER_SRS_V

VIEW - APPS.AP_BATCHES_V

VIEW - APPS.AP_CARDS_V

VIEW - APPS.AP_CARD_EXPENSE_TYPE_V

VIEW - APPS.AP_CARD_NOTIFICATIONS_V

VIEW - APPS.AP_CARD_SUPPLIERS_V

VIEW - APPS.AP_CHARGES_V

VIEW - APPS.AP_CHARGE_ALLOCATIONS_V

VIEW - APPS.AP_CHECKS_V

VIEW - APPS.AP_DISTRIBUTION_SETS_DSN_V

VIEW - APPS.AP_DISTRIBUTION_SET_LINES_V

VIEW - APPS.AP_DIST_PREPAY_APPLICATION_V

VIEW - APPS.AP_DOCUMENTS_PAYABLE

VIEW - APPS.AP_DOCUMENT_LINES_V

VIEW - APPS.AP_DUPLICATE_VENDORS_V

VIEW - APPS.AP_ENCUMBRANCE_LINES_V

VIEW - APPS.AP_ENC_GL_INV_V

VIEW - APPS.AP_EXPENSE_FEED_DISTS_OPEN_V

VIEW - APPS.AP_EXPENSE_FEED_DISTS_V

VIEW - APPS.AP_EXPENSE_FEED_LINES_V

VIEW - APPS.AP_EXPENSE_REPORT_HEADERS_V

VIEW - APPS.AP_EXPENSE_REPORT_HISTORY_V

VIEW - APPS.AP_EXPENSE_REPORT_LINES_V

VIEW - APPS.AP_EXPENSE_REPORT_STATUS_V

VIEW - APPS.AP_EXPENSE_REPORT_VIOLATIONS_V

VIEW - APPS.AP_EXPENSE_TYPES_V

VIEW - APPS.AP_EXTRACT_INVOICE_DTLS_BC_V

VIEW - APPS.AP_FND_DOCUMENT_SEQUENCES_QF_V

VIEW - APPS.AP_HOLDS_HOLD_NAME_V

VIEW - APPS.AP_HOLDS_OVERVIEW_V

VIEW - APPS.AP_HOLDS_RELEASE_NAME_V

VIEW - APPS.AP_HOLDS_V

VIEW - APPS.AP_HOLD_CODES_HOLD_NAME_V

VIEW - APPS.AP_HOLD_CODES_V

VIEW - APPS.AP_INTERFACE_REJECTIONS_V

VIEW - APPS.AP_INVOICES_DERIVED_V

VIEW - APPS.AP_INVOICES_INTERFACE_V

VIEW - APPS.AP_INVOICES_READY_TO_PAY_V

VIEW - APPS.AP_INVOICES_UNION_PREPAYS_V

VIEW - APPS.AP_INVOICES_V

VIEW - APPS.AP_INVOICES_WWW_V

VIEW - APPS.AP_INVOICE_DISTRIBUTIONS_V

VIEW - APPS.AP_INVOICE_DISTS_INQUIRY_V

VIEW - APPS.AP_INVOICE_EXTRACT_DETAILS_V

VIEW - APPS.AP_INVOICE_EXTRACT_DETAILS_VL

VIEW - APPS.AP_INVOICE_EXTRACT_HEADER_V

VIEW - APPS.AP_INVOICE_IMPORT_REJECTION_V

VIEW - APPS.AP_INVOICE_IMPORT_SOURCES_V

VIEW - APPS.AP_INVOICE_LINES_INTERFACE_V

VIEW - APPS.AP_INVOICE_LINES_V

VIEW - APPS.AP_INVOICE_PAYMENTS_V

VIEW - APPS.AP_INVOICE_PAYMENT_HISTORY_V

VIEW - APPS.AP_INVOICE_PREPAYS_V

VIEW - APPS.AP_JE_CATEGORIES_V

VIEW - APPS.AP_LC_INVOICE_TYPES_DB_V

VIEW - APPS.AP_LC_INVOICE_TYPES_V

VIEW - APPS.AP_LC_QUICK_RELEASES_V

VIEW - APPS.AP_LOOKUP_CODES

VIEW - APPS.AP_LOOKUP_TYPES

VIEW - APPS.AP_MAP_TYPES_VL

VIEW - APPS.AP_MATCH_CORRECTION_DISTS_V

VIEW - APPS.AP_OIE_ADJUSTMENT_REASONS_V

VIEW - APPS.AP_OIE_AUDIT_REASONS_V

VIEW - APPS.AP_OIE_AUDIT_TYPES_V

VIEW - APPS.AP_OIE_AUD_RETURN_REASONS_V

VIEW - APPS.AP_OIE_AUTO_AUDIT_REASONS_V

VIEW - APPS.AP_OIE_CC_TRX_CATEGORIES_V

VIEW - APPS.AP_OIE_CC_VALIDATION_ERROR_V

VIEW - APPS.AP_OIE_EXPENSE_CATEGORY_V

VIEW - APPS.AP_OIE_FUEL_TYPE_V

VIEW - APPS.AP_OIE_POL_VIOLATION_TYPES_V

VIEW - APPS.AP_OIE_TICKET_CLASS_V

VIEW - APPS.AP_OIE_TRAVEL_TYPES_V

VIEW - APPS.AP_OIE_VEHICLE_CATEGORY_V

VIEW - APPS.AP_OIE_VEHICLE_TYPE_V

VIEW - APPS.AP_OTHER_PERIODS_PN_V

VIEW - APPS.AP_OTHER_PERIODS_V

VIEW - APPS.AP_OTHER_PERIOD_TYPES_PT_V

VIEW - APPS.AP_PAYMENT_EXTRACT_DETAILS_V

VIEW - APPS.AP_PAYMENT_EXTRACT_DETAILS_VL

VIEW - APPS.AP_PAYMENT_EXTRACT_HEADER_V

VIEW - APPS.AP_PAYMENT_SCHEDULES_V

VIEW - APPS.AP_PA_HEADER_REF_V

VIEW - APPS.AP_PBATCH_SETS_V

VIEW - APPS.AP_PBATCH_SET_LINES_V

VIEW - APPS.AP_POL_LOCATIONS_V

VIEW - APPS.AP_POL_LOCATIONS_VL

VIEW - APPS.AP_POL_VIOLATIONS_V

VIEW - APPS.AP_PO_CORRECTIONS_V

VIEW - APPS.AP_PO_DETAILS_V

VIEW - APPS.AP_PO_DISTRIBUTIONS_AP2_V

VIEW - APPS.AP_PO_HEADERS_EXTRACT_V

VIEW - APPS.AP_PO_LINES_EXTRACT_V

VIEW - APPS.AP_PO_SHIPMENTS_V

VIEW - APPS.AP_PO_VENDORS_EXTRACT_V

VIEW - APPS.AP_PO_VENDOR_SITES_EXTRACT_V

VIEW - APPS.AP_PREPAYAPP_EXTRACT_DETAILS_V

VIEW - APPS.AP_PREPAYAPP_EXTRACT_DTLS_BC_V

VIEW - APPS.AP_PREPAY_DEF_TAX_EXTRACT_V

VIEW - APPS.AP_RECEIPT_CORRECTIONS_V

VIEW - APPS.AP_RECEIPT_STATUS_V

VIEW - APPS.AP_RECURRING_PAYMENTS_V

VIEW - APPS.AP_SEC_V

VIEW - APPS.AP_SHIPPING_NETWORK_LOCATIONS

VIEW - APPS.AP_SHIP_BILL_TO_LOCATIONS_V

VIEW - APPS.AP_SLA_INVOICES_TRANSACTION_V

VIEW - APPS.AP_SLA_PAYMENTS_TRANSACTION_V

VIEW - APPS.AP_SOB_INFO_V

VIEW - APPS.AP_SRS_ACCTG_CURR_V

VIEW - APPS.AP_SRS_PAYEE_V

VIEW - APPS.AP_SRS_REGION_NAMES_V

VIEW - APPS.AP_SRS_SOB_NAME_V

VIEW - APPS.AP_SYSTEM_PARAMETERS_EXTRACT_V

VIEW - APPS.AP_TERMS_BAT_PAY_TERMS_V

VIEW - APPS.AP_TERMS_V

VIEW - APPS.AP_TERMS_VAL_V

VIEW - APPS.AP_TERMS_VL

VIEW - APPS.AP_TOLERANCES

VIEW - APPS.AP_TRANSMISSION_CODES_V

VIEW - APPS.AP_UNAPPLY_PREPAYS_FR_PREPAY_V

VIEW - APPS.AP_UNAPPLY_PREPAYS_V

VIEW - APPS.AP_USERS_V

VIEW - APPS.AP_VENDORS_V

VIEW - APPS.AP_VENDOR_DISP_V

VIEW - APPS.AP_VENDOR_SITES_V

VIEW - APPS.AP_VIEW_PREPAYS_FR_PREPAY_V

VIEW - APPS.AP_VIEW_PREPAYS_V

VIEW - APPS.AP_WEB_APPROVER_LOV_V

VIEW - APPS.AP_WEB_DFLEX_LOV_V

VIEW - APPS.AP_WEB_EXP_TYPE_ITEM_V

VIEW - APPS.AP_WEB_PA_PROJECTS_TASKS_V

VIEW - APPS.AP_WEB_PA_PROJECTS_V

VIEW - APPS.AP_WEB_PEOPLE_LOV_V

VIEW - APPS.AP_WEB_SIGNING_LIMITS_V

VIEW - APPS.AP_WFAPPROVAL_HISTORY_V

VIEW - APPS.AP_XML_INVOICE2_LEVEL_V

VIEW - APPS.FINANCIALS_PURGES_V

VIEW - APPS.FND_DOCUMENT_SEQUENCES_AP_V

VIEW - APPS.FND_DOC_SEQ_CATEGORIES_AP_V

VIEW - APPS.FND_ID_SEGMENT_NAME_AP_V

VIEW - APPS.OIE_ATTENDEES

VIEW - APPS.OIE_MGR_RPT_V

VIEW - APPS.OIE_SRS_CARD_NUMBER_V

VIEW - APPS.PA_EXPENDITURE_TYPES_AP_V

VIEW - APPS.PA_PROJECTS_AP_V

VIEW - APPS.PA_PROJECT_TASKS_AP_V

VIEW - APPS.PA_TASKS_AP_V

VIEW - APPS.PO_AP_RECEIPT_MATCH_V

VIEW - APPS.PO_VENDORS

VIEW - APPS.PO_VENDORS_ACTIVE_AP_V

VIEW - APPS.PO_VENDORS_ALL_V

VIEW - APPS.PO_VENDORS_AP_V

VIEW - APPS.PO_VENDOR_CONTACTS

VIEW - APPS.PO_VENDOR_SITES

VIEW - APPS.PO_VENDOR_SITES_ALL

VIEW - APPS.PO_VENDOR_SITES_ALL_V

VIEW - APPS.PO_VENDOR_SITES_AP_V

VIEW - APPS.PO_VENDOR_SITES_PAY_AP_V

Table: AP_1096_DATA_ALL

Foreign Keys from this table:

Comments

AP_1096_DATA_ALL contains summary payment information for
1099 type suppliers. The Internal Revenue Service
requires that you report this summary information for
any qualifying payments to 1099 suppliers. Your Oracle Payables
application updates this table when you submit the 1099 Forms
Report. Your Oracle Payables application uses the
summary payment information for the 1096 Report.
.
This table contains one record per tax entity ID. It has no
primary key.

Columns

[top of page]

AP.AP_1096_DATA_ALL does not reference any database object

AP.AP_1096_DATA_ALL is referenced by following:

APPS

SYNONYM - AP_1096_DATA

SYNONYM - AP_1096_DATA_ALL

[top of page]

Table: AP_1099_TAPE_DATA_ALL

Foreign Keys from this table:

Comments

AP_1099_TAPE_DATA_ALL is a temporary table that holds 1099 supplier
payment totals used for creating K records during the 1099 Electronic Media
process. The APXTRCMT report creates a row in the
table for each unique region code for a supplier after the report
calculates the total 1099 payments (MISC1, MISC2, etc.) for
the supplier's region codes.
.
The report then determines if the totals for a region code for
a supplier exceed the reporting limit for the region. If the
totals do not exceed the limit, the report updates the region code
to null for the vendor ID in this table and sums the 1099 totals for rows
with remaining region codes to produce the summary K records for
each region.

Indexes

Columns

[top of page]

AP.AP_1099_TAPE_DATA_ALL does not reference any database object

AP.AP_1099_TAPE_DATA_ALL is referenced by following:

APPS

SYNONYM - AP_1099_TAPE_DATA

SYNONYM - AP_1099_TAPE_DATA_ALL

[top of page]

Table: AP_ACCOUNTING_EVENTS_ALL

Primary Key: AP_ACCOUNTING_EVENTS_PK

1. ACCOUNTING_EVENT_ID

Foreign Keys to this table:

Comments

***** Warning: Oracle Internal Use Only *****

Oracle Corporation does not support access to Oracle applications data using this object, except from standard Oracle Applications programs.

Indexes

Columns

[top of page]

AP.AP_ACCOUNTING_EVENTS_ALL does not reference any database object

AP.AP_ACCOUNTING_EVENTS_ALL is referenced by following:

APPS

SYNONYM - AP_ACCOUNTING_EVENTS

SYNONYM - AP_ACCOUNTING_EVENTS_ALL

[top of page]

Table: AP_AE_HEADERS_ALL

Primary Key: AP_AE_HEADERS_PK

1. AE_HEADER_ID

Foreign Keys from this table:

Foreign Keys to this table:

Comments

An accounting entry header is an entity grouping all
accounting entry lines created for a given accounting
event and a particular set of books. An accounting
entry header can either be transferred over to GL or
not at all. That is, either
all its accounting entry lines are transferred or none at
all. The transferred to GL status is marked in the
GL_TRANSFER_FLAG. Possible values for GL_TRANSFER_FLAG
are Y, N, or E. Y indicates that the accounting entry header has
been transferred to GL. N indicates that the accounting entry
header has not been transferred to GL due to 2 possible
reasons: either the transfer process has not run or it has
run but the accounting entry had an accounting error on it. E
indicates that an error was encountered during the transfer to GL process.

Indexes

Columns

[top of page]

AP.AP_AE_HEADERS_ALL does not reference any database object

AP.AP_AE_HEADERS_ALL is referenced by following:

APPS

SYNONYM - AP_AE_HEADERS

SYNONYM - AP_AE_HEADERS_ALL

[top of page]

Table: AP_AE_LINES_ALL

Primary Key: AP_AE_LINES_PK

1. AE_LINE_ID

Foreign Keys from this table:

Comments

An accounting entry line is an entity containing
a proper accounting entry with debits or credits
both in transaction currency as well as functional
currency along with an account and other reference
information pointing to the transaction data that
originated the accounting entry line. An accounting
entry line is grouped with other accounting entry
lines for a specific accounting entry header. Any
such group of accounting entry lines should result
in balanced entries in the functional currency.

Indexes

Columns

[top of page]

AP.AP_AE_LINES_ALL does not reference any database object

AP.AP_AE_LINES_ALL is referenced by following:

APPS

SYNONYM - AP_AE_LINES

SYNONYM - AP_AE_LINES_ALL

[top of page]

Table: AP_AGING_PERIODS

Primary Key: AP_AGING_PERIODS_PK

1. AGING_PERIOD_ID

Foreign Keys to this table:

Comments

AP_AGING_PERIODS contains aging periods that you define
for use in the Invoice Aging Report. You need one row
for each period you use in this report.
.
In this table, PERIOD_NAME contains the name you give
to the aging period; it is not a reference to
AP_OTHER_PERIODS or GL_PERIODS.
.
This table corresponds to the Aging Periods window.

Indexes

Columns

[top of page]

AP.AP_AGING_PERIODS does not reference any database object

AP.AP_AGING_PERIODS is referenced by following:

APPS

SYNONYM - AP_AGING_PERIODS

[top of page]

Table: AP_AGING_PERIOD_LINES

Primary Key: AP_AGING_PERIOD_LINES_PK

1. AGING_PERIOD_LINE_ID

Foreign Keys from this table:

Comments

AP_AGING_PERIOD_LINES contains information on
individual aging periods. The Invoice Aging Report
returns data for these specific aging period lines
defined in this table. Each row in this table
corresponds with a date range to which the Invoice
Aging Report assigns invoices.
.
This table corresponds to the Aging Periods window.

Indexes

Columns

[top of page]

AP.AP_AGING_PERIOD_LINES does not reference any database object

AP.AP_AGING_PERIOD_LINES is referenced by following:

APPS

SYNONYM - AP_AGING_PERIOD_LINES

[top of page]

Table: AP_ALLOCATION_RULES

Comments

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 types are Percentage Based, Amount Based, and Fully Prorated. Such rule types simply determine the type of data that will be provided by the user vs. generated by the system.
In a Fully Prorated Rule, the user does not select Item lines to allocate the charge across. Instead, the system will prorate across all Item lines during execution of the allocation rule.
In Percentage Based, the user selects the Item lines and the percentage of the charge to be allocated to each line selected.
The system then calculates the corresponding amount. In Amount Based, the user selects the Item lines and the amount of the charge to be allocated to each line selected.
The Item lines selected during Percentage Based or Amount Based rule type creation, along with the percentage or amount to be allocated, is stored in the AP_ALLOCATION_RULE_LINES table.
Allocation rules contain a status that determines whether the allocation rule has been executed and thus, it will no longer be used by the invoice that created it, or if it is pending execution and thus, still updateable.

Indexes

Columns

[top of page]

AP.AP_ALLOCATION_RULES does not reference any database object

AP.AP_ALLOCATION_RULES is referenced by following:

APPS

SYNONYM - AP_ALLOCATION_RULES

[top of page]

Table: AP_ALLOCATION_RULE_LINES

Comments

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 in the AP_ALLOCATION_RULES table. Consequently such allocation rule lines will be considered executed whenever the status of the allocation rule becomes executed.

Indexes

Columns

[top of page]

AP.AP_ALLOCATION_RULE_LINES does not reference any database object

AP.AP_ALLOCATION_RULE_LINES is referenced by following:

APPS

SYNONYM - AP_ALLOCATION_RULE_LINES

[top of page]

Table: AP_APINV_APPROVERS

Comments

This table connects approvers to their invoice components, either the
invoice header or the invoice line. The records are created during the Invoice
Approval Workflow process.

Columns

[top of page]

AP.AP_APINV_APPROVERS does not reference any database object

AP.AP_APINV_APPROVERS is referenced by following:

APPS

SYNONYM - AP_APINV_APPROVERS

[top of page]

Table: AP_AUD_AUDITORS

Primary Key: AP_AUD_AUDITORS_PK

1. AUDITOR_ID

Foreign Keys from this table:

Foreign Keys to this table:

Comments

AP_AUD_AUDITORS is a Audit-specific table that stores information about auditors.
The data in this table controls which users are valid auditors.
The table is shipped preseeded with a fallback auditor. The fallback auditor is used when no other auditor is available and has auditor_id -1.
The primary key for this table is AUDITOR_ID.

Indexes

Columns

[top of page]

AP.AP_AUD_AUDITORS does not reference any database object

AP.AP_AUD_AUDITORS is referenced by following:

APPS

SYNONYM - AP_AUD_AUDITORS

[top of page]

Table: AP_AUD_AUDIT_REASONS

Primary Key: AP_AUD_AUDIT_REASONS_PK

1. AUDIT_REASON_ID

Foreign Keys from this table:

Comments

AP_AUD_AUDIT_REASONS is an audit-specific table that contains the reasons why an expense report is audited. The primary key for this table is AUDIT_REASON_ID.

Indexes

Columns

[top of page]

AP.AP_AUD_AUDIT_REASONS does not reference any database object

AP.AP_AUD_AUDIT_REASONS is referenced by following:

APPS

SYNONYM - AP_AUD_AUDIT_REASONS

[top of page]

Table: AP_AUD_AUTO_AUDITS

Primary Key: AP_AUD_AUTO_AUDITS_PK

1. AUTO_AUDIT_ID

Comments

AP_AUD_AUTO_AUDITS is an audit-specific table that contains the list of employees whose expense reports are always audited. The primary key for this table is AUTO_AUDIT_ID.

Indexes

Columns

[top of page]

AP.AP_AUD_AUTO_AUDITS does not reference any database object

AP.AP_AUD_AUTO_AUDITS is referenced by following:

APPS

SYNONYM - AP_AUD_AUTO_AUDITS

[top of page]

Table: AP_AUD_QUEUES

Primary Key: AP_AUD_QUEUES_PK

1. EXPENSE_REPORT_ID

Foreign Keys from this table:

Comments

AP_AUD_QUEUES is a Audit-specific table that contains list of expense reports for auditing along with their assignments to auditors.
The primary key for this table is AUDITOR_QUEUE_ID.

Indexes

Columns

[top of page]

AP.AP_AUD_QUEUES does not reference any database object

AP.AP_AUD_QUEUES is referenced by following:

APPS

SYNONYM - AP_AUD_QUEUES

[top of page]

Table: AP_AUD_RULE_ASSIGNMENTS_ALL

Primary Key: AP_AUD_RULE_ASSIGNMENTS_PK

1. RULE_ASSIGNMENT_ID

Foreign Keys from this table:

Comments

AP_AUD_RULE_ASSIGNMENTS_ALL is an audit-specific table that contains rule set assignments for organizations. The data in this table is used to determine which audit rule to use, when deciding whether an expense report should be audited and whether to place the employee on the audit list.
The primary key for this table is RULE_ASSIGNMENT_ID.

Indexes

Columns

[top of page]

AP.AP_AUD_RULE_ASSIGNMENTS_ALL does not reference any database object

AP.AP_AUD_RULE_ASSIGNMENTS_ALL is referenced by following:

APPS

SYNONYM - AP_AUD_RULE_ASSIGNMENTS

SYNONYM - AP_AUD_RULE_ASSIGNMENTS_ALL

[top of page]

Table: AP_AUD_RULE_SETS

Primary Key: AP_AUD_RULE_SETS_PK

1. RULE_SET_ID

Foreign Keys from this table:

Foreign Keys to this table:

Comments

AP_AUD_RULE_SETS is an audit-specific table that contains audit rules.
The data in this table controls which expense reports are audited and when an employee is placed on the audit list. The primary key for this table is RULE_SET_ID.

Indexes

Columns

[top of page]

AP.AP_AUD_RULE_SETS does not reference any database object

AP.AP_AUD_RULE_SETS is referenced by following:

APPS

SYNONYM - AP_AUD_RULE_SETS

[top of page]

Table: AP_AUD_WORKLOADS

Primary Key: AP_AUD_WORKDLOADS_PK

1. AUDITOR_WORKLOAD_ID

Foreign Keys from this table:

Comments

AP_AUD_WORKLOADS is a Audit-specific table that stores auditor workload assignments for periods. A period is defined by a startdate and and enddate.
The data in this table is used to determine what workload to use for an auditor when deciding which auditor should audit a particular expense report.
The primary key for this table is AUDITOR_WORKLOAD_ID.

Indexes

Columns

[top of page]

AP.AP_AUD_WORKLOADS does not reference any database object

AP.AP_AUD_WORKLOADS is referenced by following:

APPS

SYNONYM - AP_AUD_WORKLOADS

[top of page]

Table: AP_AWT_BUCKETS_ALL

Primary Key: AP_AWT_BUCKETS_PK

1. PERIOD_NAME
2. TAX_NAME
3. VENDOR_ID

Foreign Keys from this table:

Comments

AP_AWT_BUCKETS_ALL contains the
denormalized amount of tax withheld to date
for a particular supplier site and a specific
withholding tax code within each period. The
periods are determined by the period type
assigned to the withholding tax code. There
will not be a row in this table if there is no withholding tax for this supplier site.

Columns

[top of page]

AP.AP_AWT_BUCKETS_ALL does not reference any database object

AP.AP_AWT_BUCKETS_ALL is referenced by following:

APPS

SYNONYM - AP_AWT_BUCKETS

SYNONYM - AP_AWT_BUCKETS_ALL

[top of page]

Table: AP_AWT_GROUPS

Primary Key: AP_AWT_GROUPS_PK

1. GROUP_ID

Foreign Keys to this table:

Comments

AP_AWT_GROUPS contains withholding tax
groups. Each withholding tax group contains
one or more withholding tax codes. This table
corresponds to the Withholding Tax Groups window.

Indexes

Columns

[top of page]

AP.AP_AWT_GROUPS does not reference any database object

AP.AP_AWT_GROUPS is referenced by following:

APPS

SYNONYM - AP_AWT_GROUPS

[top of page]

Table: AP_AWT_GROUP_TAXES_ALL

Primary Key: AP_AWT_GROUP_TAXES_PK

1. GROUP_ID
2. TAX_NAME

Foreign Keys from this table:

Comments

AP_AWT_GROUP_TAXES_ALL is the intersection
table that belongs to a specific withholding tax
group and refers to a specific withholding tax code. Its
primary key is GROUP_ID and TAX_NAME. The same
withholding tax code cannot belong to the same withholding tax group more than once.

Columns

[top of page]

AP.AP_AWT_GROUP_TAXES_ALL does not reference any database object

AP.AP_AWT_GROUP_TAXES_ALL is referenced by following:

APPS

SYNONYM - AP_AWT_GROUP_TAXES

SYNONYM - AP_AWT_GROUP_TAXES_ALL

[top of page]

Table: AP_AWT_TAX_RATES_ALL

Primary Key: AP_AWT_TAX_RATES_PK

1. TAX_RATE_ID

Foreign Keys from this table:

Foreign Keys to this table:

Comments

AP_AWT_TAX_RATES_ALL contains tax
rates for Withholding tax type tax codes. Oracle
Payables predefines the Standard and Penalty
tax rate types for withholding taxes. In addition,
Certificate rate types are assigned to a specific
supplier site and Exception rate types are assigned
to a specific invoice. START_AMOUNT and
END_AMOUNT columns are only used if the
parent withholding tax uses amount ranges.

Indexes

Columns

[top of page]

AP.AP_AWT_TAX_RATES_ALL does not reference any database object

AP.AP_AWT_TAX_RATES_ALL is referenced by following:

APPS

SYNONYM - AP_AWT_TAX_RATES

SYNONYM - AP_AWT_TAX_RATES_ALL

[top of page]

Table: AP_AWT_TEMP_DISTRIBUTIONS_ALL

Foreign Keys from this table:

Comments

AP_AWT_TEMP_DISTRIBUTIONS_ALL contains temporary
withholding tax type invoice distributions for projected withholding
tax or unconfirmed payment batches.

Indexes

Columns

[top of page]

AP.AP_AWT_TEMP_DISTRIBUTIONS_ALL does not reference any database object

AP.AP_AWT_TEMP_DISTRIBUTIONS_ALL is referenced by following:

APPS

SYNONYM - AP_AWT_TEMP_DISTRIBUTIONS

SYNONYM - AP_AWT_TEMP_DISTRIBUTIONS_ALL

[top of page]

Table: AP_BANK_ACCOUNTS_ALL

Primary Key: AP_BANK_ACCOUNTS_PK

1. BANK_ACCOUNT_ID

Primary Key: AP_BANK_ACCOUNTS_UK1

1. BANK_ACCOUNT_NAME

Foreign Keys from this table:

Foreign Keys to this table:

Comments

AP_BANK_ACCOUNTS_ALL contains information about your bank accounts. You need one row for each bank account you define. Each bank account must be affiliated with one bank branch. When you initiate an automatic payment batch, enter a manual check, or create a Quick payment,
you can select a bank account that you define in this table.
This table corresponds to the Bank Accounts window.

Indexes

Columns

[top of page]

AP.AP_BANK_ACCOUNTS_ALL does not reference any database object

AP.AP_BANK_ACCOUNTS_ALL is referenced by following:

APPS

SYNONYM - AP_BANK_ACCOUNTS

SYNONYM - AP_BANK_ACCOUNTS_ALL

[top of page]

Table: AP_BANK_ACCOUNT_USES_ALL

Primary Key: AP_BANK_ACCOUNT_USES_PK

1. BANK_ACCOUNT_USES_ID

Foreign Keys from this table:

Comments

AP_BANK_ACCOUNT_USES_ALL stores information for the internal and external bank accounts you
define in Oracle Payables and Oracle Receivables applications.

Indexes

Columns

[top of page]

AP.AP_BANK_ACCOUNT_USES_ALL does not reference any database object

AP.AP_BANK_ACCOUNT_USES_ALL is referenced by following:

APPS

SYNONYM - AP_BANK_ACCOUNT_USES

SYNONYM - AP_BANK_ACCOUNT_USES_ALL

[top of page]

Table: AP_BANK_BRANCHES

Primary Key: AP_BANK_BRANCHES_PK

1. BANK_BRANCH_ID

Primary Key: AP_BANK_BRANCHES_UK1

1. BANK_NUM

Primary Key: AP_BANK_BRANCHES_UK2

1. BANK_NAME
2. BANK_BRANCH_NAME

Foreign Keys from this table:

Foreign Keys to this table:

Comments

AP_BANK_BRANCHES contains information about the bank branches you define when you set up your banks. You need one row for each bank branch you use. One bank branch may have multiple bank accounts.
This table corresponds to the Bank Branch region of the Banks window.

Indexes

Columns