Search Results ap_suppliers




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

Table Name: AP_SUPPLIERS
Module: Accounts Payable (AP)
Purpose: Stores vendor/supplier master information

Key Columns:
1. VENDOR_ID (Primary Key)
- Unique identifier for each supplier
- Auto-generated sequence number
- Used across multiple Oracle modules

2. VENDOR_NAME
- Official name of the supplier/vendor
- Used for reporting and vendor identification

3. VENDOR_NUMBER
- Unique alphanumeric code assigned to supplier
- Often used for external reporting

4. TAX_REGISTRATION_NUMBER
- Tax ID or VAT registration number
- Used for tax reporting purposes

5. PAYMENT_TERMS_ID
- References payment terms for the supplier
- Determines payment timing and conditions

6. CURRENCY_CODE
- Default currency for transactions with vendor
- Linked to GL_CURRENCIES table

7. VENDOR_TYPE_LOOKUP_CODE
- Categorizes vendor (Internal/External)
- Used for vendor classification

8. INACTIVE_DATE
- Date when vendor becomes inactive
- Helps manage vendor master data

9. CREATION_DATE
- Timestamp of vendor record creation
- System-maintained field

10. LAST_UPDATE_DATE
- Timestamp of last modification
- Tracks vendor information changes

Important Relationships:
- Connects with PO_VENDORS
- Linked to AP_SUPPLIER_SITES
- Referenced in AP_INVOICES

Typical Usage:
- Vendor master data management
- Supplier selection in procurement
- Payment processing
- Reporting and analysis