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.
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
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.
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.
Do you think this Article is useful?
Subscribe to:
Post Comments (Atom)
0 Responses to “Tables holding info about Suppliers in R12”
Post a Comment