Get Vendors
Use this service to get active vendors from Spectrum.
Connection Information
URL = https://<SPECTRUM-SERVER>:8482/vendors/Company_Code
Authentication: Basic Authentication, Enhanced Authentication
Supported methods: GET
Underlying File Maintenance
- Accounts Payable > Vendor File Maintenance
- Accounts Payable > Vendor Locations
Assumptions and Dependencies
- Only active vendors are returned.
Parameter Fields
| Element Name | Description | Req | Type | Max | Format | Validation |
|---|---|---|---|---|---|---|
| Authorization_ID | Authorization ID to access the server | YES | Text | 20 | Data Exchange Installation Screen | |
| GUID | Unique reference number created by programming | Text | 36 | |||
| pCompany_Code | Company Code | YES | Text | 3 | Valid Company in Spectrum | Defaults from the Authorization ID if not populated |
| pType | Vendor Type | Text | 6 | |||
| pCity | Vendor City | Text | 25 | |||
| pState | Vendor State | Text | 2 | |||
| pName | Vendor Name | Text | 30 | |||
| pCostCenter | Cost Centers | Text | 3 | Specific cost center or 'ALL' |
Return Fields
| Element Name | Description | Req | Type | Max | Format | Validation |
|---|---|---|---|---|---|---|
| Company_Code | Company Code | Text | 3 | Valid Spectrum Company | ||
| Vendor_Code | Vendor Code | Text | 10 | Vendor File Maintenance | ||
| Name | Vendor Name | Text | 30 | Vendor File Maintenance or Vendor Location Maintenance | ||
| Address_1 | Address 1 | Text | 30 | Vendor File Maintenance or Vendor Location Maintenance | ||
| Address_2 | Address 2 | Text | 30 | Vendor File Maintenance or Vendor Location Maintenance | ||
| City | City | Text | 30 | Vendor File Maintenance or Vendor Location Maintenance | ||
| State | State / Province | Text | 2 | Vendor File Maintenance or Vendor Location Maintenance | ||
| Zip_Code | Postal Code | Text | 10 | Vendor File Maintenance or Vendor Location Maintenance | ||
| First_Name | Primary Contact First Name | Text | 20 | Contact Master | ||
| Last_Name | Primary Contact Last Name | Text | 30 | Contact Master | ||
| Phone_Number | Primary Contact Phone | Text | 14 | Primary phone defined for Contact Master | ||
| Primary Contact Email | Text | 80 | Email defined for Contact Master | |||
| Account_Reference | Account Reference | Text | 25 | Vendor File Maintenance | ||
| Payment_Terms Text 1 | Payment Due Terms | Text | 1 | When A = Invoice Date. When B = Prox Terms | ||
|
Payment_Term_Days Numeric 12 | Payment Number of Days | Numeric | 12 | |||
| Discount_Terms | Discount Terms | Text | 1 | When A = Invoice Date. When B = Prox Terms | ||
| Discount_Term_Days | Discount Number of Days | Numeric | 12 | |||
| Discount_Percent | Discount Percent | Numeric | 3.2 | |||
| Purchase_Location_Name | Purchase Location | Text | 30 | Locations | ||
| Purchase_Address_1 | Text | 30 | Locations | |||
| Purchase_Address_2 | Text | 30 | Locations | |||
| Purchase_City | Text | 30 | Locations | |||
| Purchase_State | Text | 2 | Locations | |||
| Purchase_Zip | Numeric | 10 | Locations | |||
| Payment_Location_Name | Payment Location | Text | 30 | Locations | ||
| Payment_Address_1 | Text | 30 | Locations | |||
| Payment_Address_2 | Text | 30 | Locations | |||
| Purchase_City | Text | 30 | Locations | |||
| Purchase_State | Text | 2 | Locations | |||
| Purchase_Zip | Numeric | 10 | Locations |
