Search Results po_vendors




Here's a detailed description of the PO_VENDORS table in Oracle E-Business Suite (EBS):

Table Name: PO_VENDORS
Module: Purchasing
Purpose: Stores vendor/supplier master information

Key Columns:
1. VENDOR_ID (Primary Key)
- Unique identifier for each vendor
- System-generated sequential number
- Used in joins with other purchasing tables

2. SEGMENT1
- Vendor number/code
- Used for external identification
- Often displayed in vendor lists and reports

3. VENDOR_NAME
- Full legal name of the vendor/supplier
- Used for reporting and vendor identification

4. VENDOR_TYPE_LOOKUP_CODE
- Classifies vendor type (e.g., Internal, External)
- Helps in vendor categorization

5. PAYMENT_TERMS_ID
- References payment terms for the vendor
- Linked to AP_TERMS table

6. CURRENCY_CODE
- Default currency for transactions with vendor

7. ENABLED_FLAG
- Indicates if vendor is active/inactive in system
- 'Y' - Active, 'N' - Inactive

8. VENDOR_NAME_ALT
- Alternate vendor name

9. TAX_REGISTRATION_NUMBER
- Vendor's tax identification number

Important Related Tables:
- PO_VENDOR_SITES
- AP_SUPPLIERS
- PO_VENDOR_CONTACTS

Typical Use Cases:
- Vendor master maintenance
- Procurement processing
- Supplier selection
- Payment processing