Oracle E-Business Suite · Schema
Oracle EBS Supplier
Schema representing a supplier/vendor record in Oracle E-Business Suite Purchasing and Payables modules. Maps to AP_SUPPLIERS, AP_SUPPLIER_SITES_ALL, AP_SUPPLIER_CONTACTS, and the Trading Community Architecture (TCA) party model (HZ_PARTIES).
Business ApplicationsE-Business SuiteEnterpriseERPOracle
Properties
| Name | Type | Description |
|---|---|---|
| vendorId | integer | Vendor identifier (AP_SUPPLIERS.VENDOR_ID) |
| vendorName | string | Vendor name |
| segment1 | string | Vendor number |
| vendorType | stringnull | Vendor type lookup code (e.g., CONTRACTOR, EMPLOYEE, VENDOR) |
| partyId | integer | TCA party identifier (HZ_PARTIES.PARTY_ID) |
| taxPayerId | stringnull | Tax payer identification number (EIN/SSN/TIN) |
| taxRegistrationNumber | stringnull | Tax registration number (VAT number) |
| standardIndustryClass | stringnull | Standard Industry Classification (SIC) code |
| dunsBNumber | stringnull | DUNS number |
| oneTimeFlag | string | One-time vendor flag |
| customerNum | stringnull | Our customer number at the vendor |
| minorityGroupLookupCode | stringnull | Minority group classification |
| smallBusinessFlag | string | Small business flag |
| womenOwnedFlag | string | Women-owned business flag |
| paymentCurrencyCode | stringnull | Default payment currency code (ISO 4217) |
| invoiceCurrencyCode | stringnull | Default invoice currency code (ISO 4217) |
| paymentMethodCode | stringnull | Default payment method lookup code |
| payGroupLookupCode | stringnull | Pay group lookup code |
| termsId | integernull | Default payment terms identifier (AP_TERMS.TERM_ID) |
| termsName | stringnull | Default payment terms name |
| alwaysTakePrepaymentDiscFlag | string | |
| payDateBasisLookupCode | stringnull | Pay date basis (DISCOUNT, DUE) |
| invoiceAmountLimit | numbernull | Invoice amount limit |
| holdAllPaymentsFlag | string | Whether all payments are on hold |
| holdUnmatchedInvoicesFlag | string | Whether unmatched invoices are on hold |
| matchOption | stringnull | Invoice match option |
| enabled | boolean | Whether the vendor is currently active/enabled |
| startDateActive | string | Date the vendor becomes active |
| endDateActive | stringnull | Date the vendor becomes inactive |
| sites | array | Vendor site records |
| contacts | array | Vendor contact records |
| bankAccounts | array | Vendor bank account assignments |
| createdBy | integer | User who created the record |
| creationDate | string | Record creation date |
| lastUpdatedBy | integer | User who last updated the record |
| lastUpdateDate | string | Record last update date |