Get Customers
Use this service to import Get Customers information.
WSDL: GetCustomers.jws
Method: GetCustomers
Use these tables for reference when using this service.
Parameter Field Descriptions
Note: The Authorization_ID and GUID elements are not shown on the Spectrum Excel Office Add-in templates for data entry points.
| Element Name | Description | Req? | Type | Max | Field Information |
|---|---|---|---|---|---|
| Authorization_ID | Authorization ID to access the server | YES | Text | 20 | Data Exchange Installation Screen |
| GUID | Unique reference number created by programming | Text | 36 | ** See GUID definition | |
| pCompany_Code | Company Code | YES | Text | 3 | Valid Company in Spectrum. Defaults from Authorization ID if not populated. |
| pStatus | Customer Status | Text | 3 | Leave blank for 'Active' only, or 'I' to include both Active and Inactive customers, or 'ALL' to include all customers |
Return Field Descriptions
| Element Name | Description | Type | Max | Field Information |
|---|---|---|---|---|
| Company_Code | Company Code | Text | 3 | Valid Spectrum Company |
| Customer_Code | Customer Code | Text | 10 | Customer File Maintenance |
| Name | Customer Name | Text | 30 | Customer File Maintenance |
| Address_1 | Address 1 | Text | 30 | Customer File Maintenance |
| Address_2 | Address 2 | Text | 30 | Customer File Maintenance |
| City | City | Text | 25 | Customer File Maintenance |
| State | State / Province | Text | 2 | Customer File Maintenance |
| Zip_Code | Postal Code | Text | 10 | Customer File 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 Telephone | Text | 14 | Primary phone defined for Contact Master |
| Email1 | Primary Contact Email | Text | 80 | Email1 defined for Contact Master |
| Price_Level_Material | Standard Material Price Level | Num | 1 | Customer File Maintenance (1-5 or blank) |
| Taxable_Flag | Standard Tax Status | Text | 11 | Customer File Maintenance ('Taxable' or 'Non-Taxable' or 'No Default') |
| Status | Customer Status | Text | 8 | Customer File Maintenance ('Active' or 'Inactive' or 'Not Used') |
