Loading

Monday, February 22, 2010

Tables holding info about Suppliers in R12

As mentioned in my previous post, Supplier information is moved to R12 and below are some of the important tables involved 

HZ_PARTIES

This is the master table for Suppliers instead of PO_VENDORS. As usual PARTY_ID will be referenced in the other related tables. 

HZ_PARTY_USG_ASSIGNMENTS

This table stores the Party Usages, for example, in this case it captures the fact that the given party_id is of type SUPPLIER 

HZ_ORGANIZATION_PROFILES

This table captures additional Supplier information, for example, credit scoring details of Supplier or the Number of Employees working in Supplier Organization. 

IBY_EXTERNAL_PAYEES_ALL

This table captures Payment related details of the Supplier.
For example:-
    1. How should the supplier's remittance advice must be sent?
    2. What is the default Payment method Code for this supplier?
    3. Who bears the bank charges when lets say SWIFT payment is made?
This information can be setup at either the Supplier level or at Supplier Site level.
 

AP_SUPPLIERS

Alongside HZ_PARTIES, this is another master table that replaces the PO_VENDORS table of 11i.
Instead of expanding the design of HZ_PARTIES, oracle decided to hold the supplier specific attributes in AP_SUPPLIERS
 

POS_SUPPLIER_MAPPINGS

This table holds the mapping between the AP_SUPPLIERS.VENDOR_ID and HZ_PARTIES.PARTY_ID.
This is useful in cases whereby two vendors  effectively belong  the same HZ_Party Record.
 

ZX_PARTY_TAX_PROFILE

The taxation related details like Tax Codes, and Tax Accounts etc have been moved from AP into ZX.

ZX is the name of a new Application "E-Business Tax". Efectively this application is the Tax repository/Taxation Engine for eBusiness Suite starting from R12. 

ZX_RATES_B

This table holds all the TAX_RATES. In simple words it is the replacement for the 11i table AP_TAX_CODES_ALL. 

ZX_ACCOUNTS

This table also falls under the module ‘E-BUSINEES Tax’ and it holds the details about the Accounting setups for the each TAX_RATE.

0 Responses to “Tables holding info about Suppliers in R12”

Post a Comment

Disclaimer

The ideas, thoughts and concepts expressed here are my own. They, in no way reflect those of my employer or any other organization/client that I am associated. The articles presented doesn't imply to any particular organization or client and are meant only for knowledge Sharing purpose. The articles can't be reproduced or copied without the Owner's knowledge or permission.