Oracle Purchasing (PO) key Vendor tables (5)

admin
Categories: ERP Tables

PO_VENDORS stores information about your suppliers. You need one
row for each supplier you define.

Each row includes the supplier name as well as purchasing, receiving, payment, accounting, tax, classification, and general information.

Oracle Purchasing uses this information to determine active suppliers. VENDOR_ID is the unique system–generated receipt header number invisible to the user.
SEGMENT1 is the system–generated or manually assigned number you
use to identify the supplier in forms and reports.

Oracle Purchasing generates SEGMENT1 using the
PO_UNIQUE_IDENTIFIER_CONTROL table if you choose to let
Oracle Purchasing generate supplier numbers for you. This table is one
of three tables that store supplier information. PO_VENDORS
corresponds to the Suppliers window.

PO_VENDOR_SITES_ALL stores information about your supplier
sites. You need a row for each supplier site you define. Each row
includes the site address, supplier reference, purchasing, payment,
bank, and general information. Oracle Purchasing uses this
information to store supplier address information.
This table is one of three tables that store supplier information.
PO_VENDOR_SITES_ALL corresponds to the Sites region of the
Suppliers window.

Try MockupTiger to build Wireframes for your next software prototypes or initial Mockups when you are just iterating over ideas.


MockupTiger Wireframes builds instant wireframes for your Dashboards or Oracle Forms

Comments are closed.