ITPub博客

首页 > Linux操作系统 > Linux操作系统 > Supplier

Supplier

原创 Linux操作系统 作者:chenshm329 时间:2011-02-24 10:19:06 0 删除 编辑

Basic Tables in R12

R12

Description

HZ_PARTIES

This happens to be the master table now instead of PO_VENDORS.
You will notice that the PARTY_NUMBER below is the Registry id in the R12 supplier screen.
Also, this party_id will be referenced in the remainder set of tables.

HZ_PARTY_USG_ASSIGNMENTS

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

HZ_ORGANIZATION_PROFILES

his 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.
Effectively this also means that our good old AP_TAX_CODES_ALL is no longer the master table for Taxes.
Now we have a new tax rate table, i.e. ZX_RATES_B.
ZX_ACCOUNTS is another table that has been introduced to capture accounting setup related to Tax Codes.

PO_VENDORS

PO_VENDORS is a view in R12, that joins AP_SUPPLIERS & HZ_PARTIES.
Similarly, PO_VENDOR_SITES and PO_VENDOR_SITES_ALL are also views based upon AP_SUPPLIER_SITES_ALL.

 

 

来自 “ ITPUB博客 ” ,链接:http://blog.itpub.net/17087603/viewspace-687831/,如需转载,请注明出处,否则将追究法律责任。

请登录后发表评论 登录
全部评论

注册时间:2009-08-09

  • 博文量
    182
  • 访问量
    129662