Technical Information related to Suppliers

Before we move on forward with bank details lets look at technical information related to suppliers. The best way to find out the underlying tables/view is to use about this page link
in all OA pages. Here are the steps to get supplier related table information. From suppliers page click on About this page link. Click on expand all to see all the view objects used by the supplier page. For example SupplierVO and SitesVO.

Representation of suppliers in the Trading Community Architecture (TCA) is new in R12.
The PO_VENDORS table is replaced by AP_SUPPLIERS table. When you create a supplier in AP a record is populated in HZ_PARTIES table. The party_number column is the registry_id in the create supplier form. The HZ_PARTY_USG_ASSIGNMENTS table stores party_usage_code which lets us know if the record is supplier or customer. POS_SUPPLIER_MAPPINGS table holds the mapping details between AP_SUPPLIERS.VENDOR_ID and HZ_PARTIES.PARTY_ID.

Information of the PARTY_ID, TCA_SYNC_VENDOR_NAME and TCA_SYNC_VAT_REG_NUM are also populated in AP_SUPPLIERS table. Also when you create site for a supplier, information is stoder in AP_SUPPLIER_SITES_ALL.