Skip to content

CustomerInquiry

CustomerInquiry.asmx

 

This web service provides three methods to access the Elliott Customer database:

·        SearchCustomer: Get a list of customers matching certain customer search criteria.

·        GetCustomerInfo: Get the attributes, notes, links, eContact, and open item information for a specific customer.

·        GetARCodes: Retrieve all records in the Salesman, Customer Type, State, Ship Via, Terms, and Tax Codes files.

 

SearchCustomer

This method uses the relational engine to execute the SQL command and retrieve customer data based on the provided customer number. Data can be filtered on a variety of fields and a user can choose the detail level that is returned.

 

Usage:

SearchCustomerResult = A.SearchCustomer(UserName, UserPassword, DetailLevel, CustomerNo, CustomerName, Address1, City, State, PostalCode, Country, PhoneNo, Contact, CustomerType, CreditLimit, HoldFlag, Collector, Terroritories, ShiaVia, TermsCode, DiscountPct, SalesmanNo, SalesPTD, SalesYTD, SalesLastYear, AccountBalance, LastSalesDate, AgeAmtPeriod1andUp, AgeAmtPeriod2andUp, AgeAmtPeriod3andUp, AgeAmtPeriod4, Note1, Note2, Note3, Note4, Note5, OrderBy, NumberOfRecords, AdditionalWhereClause)

 

Parameters UserName and UserPassword are not used at this moment.

 

Parameter Name

Type

Detail

detailLevel

String

The method can return customer data set from minimum to full detail. This may not be as important if both web services and web application reside in the same local area network. On the other hand, when large amount of customer data return over the Internet, it could result in slower performance. Therefore, choosing the appropriate detail level may help performance. The default value is “B” (Brief). Possible values are M, B, R, E, and F. Please see “Columns in DataTable “Items”” for more detail.

CustomerNo

String

This field uses “equal” search by default.

CustomerName

String

This field uses “like” search.

Address1

String

This field uses “like” search.

City

String

This field uses “like” search.

State

String

This field uses "equal" search.

PostalCode

String

This field uses “like” search.

Country

String

This field uses “like” search.

PhoneNo

String

This field uses “like” search.

Contact

String

This field uses “like” search.

CustomerType

String

This field uses "equal" search.

CreditLimit

String

Matches on the credit limit provided. May use operator if provided.

HoldFlag

String

This field uses "equal" search.

Collector

String

This field uses “like” search.

Territories

String

This field uses “like” search.

ShipVia

String

This field uses “like” search.

TermsCode

String

This field uses “like” search.

DiscountPct

String

Matches on the discount percent provided. May use operator if provided.

SalesmanNo

String

This field uses "equal" search.

SalesPTD

String

Matches on the sales period-to-date amount provided. May use operator if provided.

SalesYTD

String

Matches on the sales year-to-date amount provided. May use operator if provided.

SalesLastYear

String

Matches on the sales last-year amount provided. May use operator if provided.

AccountBalance

String

Matches on the account balance provided. May use operator if provided.

LastSalesDate

String

Matches on the last sales date provided. May use operator if provided.

AgeAmtPeriod1andUp

String

Matches on the period 1 aging amount. May use operator if provided.

AgeAmtPeriod2andUp

String

Matches on the period 2 aging amount. May use operator if provided.

AgeAmtPeriod3andUp

String

Matches on the period 3 aging amount. May use operator if provided.

AgeAmtPeriod4

String

Matches on the period 4 aging amount. May use operator if provided.

Note1

String

This field uses “like” search.

Note2

String

This field uses “like” search.

Note3

String

This field uses “like” search.

Note4

String

This field uses “like” search.

Note5

String

This field uses “like” search.

OrderBy

String

Can be any column in database table ARCUSFIL. Please see “Columns in ARCUSFIL” for available values. Multiple ORDER BY columns and ascending/descending sequence are possible. For example, you may pass a value like “CUS_LAST_SALE_DT, CUS_NO DESC” which will result in ORDER BY clause “ORDER BY CUS_LAST_SALE_DT, CUS_NO DESC.”

NumberOfRecords

Integer

Maximum number of records in output.

AdditionalWhereClause

String

The value passed here will be appended to the WHERE clause with AND condition.

 

Columns in ARCUSFIL

  • CUS_NO             
  • CUS_NAME           
  • CUS_CORR_NAME     
  • CUS_STREET1       
  • CUS_STREET2       
  • CUS_CITY           
  • CUS_ST             
  • CUS_ZIP           
  • CUS_COUNTRY       
  • CUS_CONTACT       
  • CUS_PHONE_NO       
  • CUS_START_DT       
  • CUS_SLM_NO         
  • CUS_TP             
  • CUS_BAL_METH       
  • CUS_STM_FREQ       
  • CUS_CR_LIMIT       
  • CUS_CR_RATING     
  • CUS_CR_HOLD_FG     
  • ARCUSFIL_FILLER_0001
  • CUS_COLLECTOR     
  • CUS_FIN_CHG_FG     
  • CUS_ORDER_LOC     
  • CUS_TERR           
  • CUS_AR_ACCT_NO     
  • CUS_SHIP_VIA_CD   
  • CUS_UPS_ZONE       
  • CUS_TERMS_CD       
  • CUS_DSC_PCT       
  • CUS_YTD_DSC_GIVEN 
  • CUS_TXBL_FG       
  • CUS_TX_CD1         
  • CUS_TX_CD2         
  • CUS_TX_CD3         
  • CUS_EXEMPT_NO     
  • CUS_SALES_PTD     
  • CUS_SALES_YTD     
  • CUS_SALES_LAST_YR 
  • CUS_COST_PTD       
  • CUS_COST_YTD       
  • CUS_COST_LAST_YR   
  • CUS_BALANCE       
  • CUS_HIGH_BALANCE   
  • CUS_LAST_SALE_DT   
  • CUS_LAST_SALE_AMT 
  • CUS_INV_YTD         
  • CUS_INV_LAST_YR   
  • CUS_PAID_INV_YTD   
  • CUS_LAST_PAY_DT   
  • CUS_LAST_PAY_AMT   
  • CUS_AVG_PAY_YTD   
  • CUS_AVG_PAY_LAST_YR
  • CUS_LAST_STM_AGE_DT
  • CUS_AMT_AGE_PD1   
  • CUS_AMT_AGE_PD2   
  • CUS_AMT_AGE_PD3   
  • CUS_AMT_AGE_PD4   
  • CUS_ALLOW_SUB_ITMS 
  • CUS_ALLOW_BO       
  • CUS_ALLOW_PART_SHIP
  • CUS_PRINT_DUNN_FG 
  • CUS_COMMENT1       
  • CUS_COMMENT2       
  • CUS_SEARCH_NAME   
  • CUS_NOTE_1         
  • CUS_NOTE_2         
  • CUS_NOTE_3         
  • CUS_NOTE_4         
  • CUS_NOTE_5         
  • CUS_USER_DATE     
  • CUS_USER_AMT       
  • CUS_EXEMPT_EXP_DATE
  • CUS_EXEMPT_REASON_CD
  • CUS_OUTSIDE_CITY_LM
  • CUS_GEO_CODE       
  • CUS_USE_BILL_TO_ADRR
  • CUS_BILL_TO_NO     
  • CUS_FORM_NO       
  • CUS_FAX_NUMBER     
  • CUS_SLM_START_DT   
  • CUS_ABC_CLASS     
  • CUS_FRT_PAY_CODE   
  • CUS_DEL_LEAD_TIME 
  • CUS_PICK_INV_AMT   
  • CUS_DEL_DAY_ERLY_ALW
  • CUS_SALES_YR_BF_LY 
  • CUS_ACCESS_DATE   
  • CUS_ACCESS_TIME   
  • CUS_IMMED_ORD_ACK 
  • CUS_TRANSFER_FLAG 
  • CUS_TRANSFER_TO_LOC
  • CUS_TRANSIT_DAYS 

 

Output Structure

Property Name

Type

Detail

ReturnCode

Integer

Contains return code. Zero means OK; for other return codes, please see “CustomerInquiry Return Code” section.

NumberOfRecordsFound

Integer

Number of records in “Customers” DataTable.

Customers

DataSet

Contains a DataTable name=“Customers.”

 

Columns in Customers DataTable

The method can return item data set from minimum to full detail. The size of the dataset may affect web application performance -- especially if the web services and web application servers are not in the same local area network (e.g., cross over the Internet). So based on the “detailLevel” this web services will return different level of details (columns) accordingly. The default detailLevel value is “B” (Brief).

 

 

detailLevel

Columns in DataTable “Items”

M

CUS_NO, CUS_NAME

B

(Default)

CUS_NO, CUS_NAME, CUS_CITY, CUS_ST, CUS_ZIP, CUS_PHONE, CUS_CONTACT

R

CUS_NO, CUS_NAME, CUS_CITY, CUS_ST, CUS_ZIP, CUS_PHONE, CUS_CONTACT, CUS_SALES_PTD,  CUS_SALES_YTD, CUS_SALES_LAST_YR, CUS_LAST_SALE_DT, CUS_LAST_SALE_AMT, CUS_SLM_NO, CUS_TERR, CUS_TP, CUS_DSC_PCT

E

CUS_NO, CUS_NAME, CUS_CITY, CUS_ST, CUS_ZIP, CUS_PHONE, CUS_CONTACT, CUS_SALES_PTD,  CUS_SALES_YTD, CUS_SALES_LAST_YR, CUS_LAST_SALE_DT, CUS_LAST_SALE_AMT, CUS_SLM_NO, CUS_TERR, CUS_TP, CUS_DSC_PCT, CUS_STREET1, CUS_STREET2, CUS_COUNTRY, CUS_FAX_NUMBER, CUS_START_DT, CUS-CR_LIMIT_CUS_CR_HOLD_FG, CUS_COLLECTOR, CUS_SHIP_VIA_CD, CUS_TERMS_CS, CUS_TXBL_FG, CUS_BALANCE, CUS_AMT_AGE_PD1, CUS_AMT_AGE_PD2, CUS_AMT_AGE_PD3, CUS_AMT_AGE_PD4

F

CUS_NO, CUS_NAME, CUS_CORR_NAME, CUS_STREET1, CUS_STREET2, CUS_CITY, CUS_ST, CUS_ZIP, CUS_COUNTRY, CUS_CONTACT, CUS_PHONE_NO, CUS_START_DT, CUS_SLM_NO, CUS_TP, CUS_BAL_METH. CUS_STM_FREQ, CUS_CR_LIMIT, CUS_CR_RATING, CUS_CR_HOLD_FG, ARCUSFIL_FILLER_0001, CUS_COLLECTOR, CUS_FIN_CHG_FG, CUS_ORDER_LOC, CUS_TERR, CUS_AR_MAIN_NO, CUS_AR_SUB_NO, CUS_AR_DP_NO, CUS_SHIP_VIA_CD, CUS_UPS_ZONE, CUS_TERMS_CD,  CUS_DSC_PCT, CUS_YTD_DSC_GIVEN, CUS_TXBL_FG, CUS_TX_CD1, CUS_TX_CD2, CUS_TX_CD3, CUS_EXEMPT_NO, CUS_SALES_PTD,  CUS_SALES_YTD, CUS_SALES_LAST_YR, CUS_COST_PTD, CUS_COST_YTD, CUS_COST_LAST_YR, CUS_BALANCE, CUS_HIGH_BALANCE, CUS_LAST_SALE_DT, CUS_LAST_SALE_AMT, CUS_INV_YTD, CUS_INV_LAST_YR, CUS_PAID_INV_YTD, CUS_LAST_PAY_DT, CUS_LAST_PAY_AMT, CUS_LAST_PAY_AMT, CUS_AVG_PAY_LAST_YR, CUS_LAST_STM_AGE_DT, CUS_AMT_AGE_PD1, CUS_AMT_AGE_PD2, CUS_AMT_AGE_PD3, CUS_AMT_AGE_PD4, CUS_ALLOW_SUB_ITMS, CUS_ALLOW_BO, CUS_ALLOW_PART_SHIP, CUS_PRINT_DUNN_FG, CUS_COMMENT1, CUS_COMMENT2, CUS_SEARCH_NAME, CUS_NOTE_1, CUS_NOTE_2, CUS_NOTE_3, CUS_NOTE_4, CUS_NOTE_5,CUS_USER_DATE, CUS_USER_AMT, CUS_EXEMPT_EXP_DATE, CUS_EXEMPT_REASON_CD, CUS_OUTSIDE_CITY_LM, CUS_GEO_CODE, CUS_USE_BILL_TO_ADRR, CUS_BILL_TO_NO, CUS_FORM_NO, CUS_FAX_NUMBER

 

Code Example (VB)

The following sample code will search for customer number “000100” and display its customer name.

 

Dim wsCustomerInfo As New webServicesCustomerInquiry.CusomerInquiry()

Dim Result As New webServicesCustomerInquiry.SearchCustomerResult

Result = wsCustomerInfo.SearchCustomer(“ ”, “ “, “M”, “000100”, “ “,“ “,“ “,“ “,“ “,“ “,“ “,“ “,“ “,“ “,“ “,“ “,“ “,“ “,“ “,“ “,“ “,“ “,“ “,“ “,“ “,“ “,“ “,“ “,“ “,“ “,“ “,“ “,“ “,“ “,“ “,“ “, , “ “)

If Result.ReturnCode = 0 Then

lblResult.Text = _

Result.Customers.Tables(0).Rows(0).Item("CUS_NAME").ToString

ElseIf Result.ReturnCode = 30001 Then

  lblResult.Text = "Customer not found"

Else

lblResult.Text = Result.ReturnCode.ToString

End If

 

GetCustomerInfo

 

This method uses the relational engine to execute the SQL command and retrieve the attributes, notes, links, eContact, and open item information for a specific customer.

 

Usage:

GetCustomerInfoResult = A.GetCustomerInfo(UserName, UserPassword, CustomerNo, GetAttributes, AttributesWebFlag, GetNotes, NotesWebFlag, GetLinks, GetEContact, GetCustomerData, GetOpenItem)

 

Parameters UserName and UserPassword are not used at this moment.

 

Parameter Name

Type

Detail

CustomerNo

String

Customer number.

GetAttributes

String

Specify Y to retrieve the corresponding attributes for the customer.  This can be helpful if you have certain attribute information to return on the searching result.  Do not indicate “Y” unless you need the data.  Otherwise, performance can slow down unnecessarily.

AttributesWebFlag

String

If you specify "Y" to previous parameters, this specifies the criteria that the attribute must be a web attributes before being returned.

GetNotes

String

Similar to getAttribute, but for notes.  Do not indicate “Y” unless you need the data.  Otherwise, performance can slow down unnecessarily.

NotesWebFlag

String

Similar to attributesWebFlag but for notes.

GetLinks

String

Specify “Y” to retrieve links.  Do not indicate “Y” unless you need the data.  Otherwise, performance can slow down unnecessarily.

GetEcontact

String

“Y” to retrieve eContacts. Do not indicate “Y” unless you need the data.  Otherwise, performance can  slow down unnecessarily.

GetCustomerData

String

Specify "Y" to retrieve the corresponding customer record.

GetOpenItem

String

Specify "Y" to retrieve the corresponding A/R Open Item records for the customer specified. Do not indicate “Y” unless you need the data.  Otherwise, performance can slow down unnecessarily.

 

GetCustomerInfoResult Structure

Property

Type

Detail

ReturnCode

Integer

Contains return code. Zero means OK; for other return codes, please see “EliloginService Return Code” section.

CustomerInfo

DataSet

Contains the following datasets: Attributes, EContacts, Links, Notes, Customer, and Open Item. For detail information of the dataset table, please refer to the following section.

 

SYATRFIL Structure

When GetAttribute = “Y.” This table contains the same column heading as the SYATRFIL table.  It will contain all attribute code records in the return dataset when you set GetAttribute = “Y.”

Property

Detail

SYATRFIL_CODE

 

SYATRFIL_DESC_1

 

SYATRFIL_DESC_2

 

SYATRFIL_REF_1_FLAG

 

SYATRFIL_REF_1_LIT

 

..

 

SYATRFIL_REF_5_FLAG

 

SYATRFIL_REF_5_LIT

 

SYATRFIL_DATE_1_FLAG

 

SYATRFIL_DATE_1_LIT

 

 

SYATRFIL_AMT_1_FLAG

 

SYATRFIL_AMT_1_LIT

 

 

SYATRFIL_HLD_ORD1

 

SYATRFIL_GRACE_PRD1

 

 

SYATRFIL_PRIME_FLD1

 

SYATRFIL_PRIME-FLD2

 

SYATRFIL_WEB_FLG

 

SYATRFIL_CHKBOX1_FLG

 

SYATRFIL_CHKBOX1_LIT

 

 

SYATRFIL_FILLER

 

 

When getAttribute = “Y.” This table contains the same column heading as SYATTRIB table.  It will contain all attribute code records in the return dataset when you set getAttribute = “Y.”

Property

Detail

ATTRIB_FILENAME

 

ATTRIB_REF_NUMBER

 

ATTRIB_CODE

 

ATTRIB_REF_1

 

 

ATTRIB_DATE_1

 

 

ATTRIB_AMT_1

 

 

ATTRIB_CREATE_DATE

 

ATTRIB_CREATE_TIME

 

ATTRIB_CREATE_BY

 

ATTRIB_FILLER

 

 

Notes Structure

When GetNotes = “Y.” This table contains the same column heading as the NOTE table.  It will contain all note records for the customer in the return dataset when you set GetNotes = “Y.”

 

Property

Detail

NOTE_FILE_NAME     

 

NOTE_FILE_REF_NO   

 

NOTE_FOLDER       

 

NOTE_CREATE_DATE   

 

NOTE_CREATE_TIME_HH

 

NOTE_CREATE_TIME_MM

 

NOTE_CREATE_TIME_SS

 

NOTE_TYPE         

 

NOTE_CREATE_BY_USER

 

NOTE_TASK_STATUS   

 

NOTE_FOLLOWUP_BY_NAM

 

NOTE_FOLLOWUP_DATE 

 

NOTE_FOLLOWUP_TIME 

 

NOTE_FILE_NAME_ALT 

 

NOTE_FILE_REF_NO_ALT

 

NOTE_TOPIC         

 

NOTE_CONTENT_1     

 

NOTE_CONTENT_2     

 

NOTE_CONTENT_3     

 

NOTE_CONTENT_4     

 

NOTE_CONTENT_5     

 

NOTE_CONTENT_6     

 

NOTE_CONTENT_7     

 

NOTE_CONTENT_8     

 

NOTE_CONTENT_9     

 

NOTE_CONTENT_10   

 

NOTE_MODIFY_DATE   

 

NOTE_MODIFY_HH     

 

NOTE_MODIFY_MM     

 

NOTE_MODIFY_SS     

 

NOTE_MODIFY_BY_USER

 

NOTE_READABLE_FLAG 

 

NOTE_CHANGEABLE_FLAG

 

NOTE_DELETEABLE_FLAG

 

NOTE_ORIG_FOLL_UP_DT

 

NOTE_TIME_FOLL_DT_CH

 

NOTE_ESTIMATED_TIME

 

NOTE_REMIND_DATE   

 

NOTE_REMIND_TIME   

 

NOTE_RECUR_TYPE   

 

NOTE_RECUR_FREQ   

 

NOTE_REM_AHEAD_TYPE

 

NOTE_REM_AHEAD_VAL 

 

NOTE_CONTENT_CR1   

 

NOTE_CONTENT_CR2   

 

NOTE_CONTENT_CR3   

 

NOTE_CONTENT_CR4   

 

NOTE_CONTENT_CR5   

 

NOTE_CONTENT_CR6   

 

NOTE_CONTENT_CR7   

 

NOTE_CONTENT_CR8   

 

NOTE_CONTENT_CR9   

 

NOTE_CONTENT_CR10 

 

NOTE_CONTINUED     

 

NOTES_FILLER_001

 

 

SYLNKFIL Structure

When GetLinks = “Y.” This table contains the same column heading as the SYLNKFIL table.  It will contain all link records for the customer in the return dataset when you set GetLinks = “Y.”

 

Property

Detail

SYLNKFIL_VALUE     

 

SYLNKFIL_OVERRIDE

 

SYLNKFILE_ADHOC_DESC

 

SYLNKTYP_TYPE

 

SYLNKTYP_DESCRIPTION

 

SYLNKTYP_TEMPLATE

 

 

EContact Structure

When GetEContact = “Y.” This table contains the same column heading as the SYCONTCT table.  It will contain all contact records for the customer in the return dataset when you set GetEContact = “Y.”

 

Property

Detail

SYCONREL_ROLE

 

SYCONREL_PRIMARY_REL

 

SYCONREL_POSITION

 

SYCONREL_PRIMARY_CT

 

SYCONTCT_ID

 

SYCONTCT_EMAIL_ADDR

 

SYCONTCT_NAME

 

SYCONTCT_LNK_ADR_FLG

 

SYCONTCT_ADDR_1

 

SYCONTCT_ADDR_2

 

SYCONTCT_CITY

 

SYCONTCT_STATE

 

SYCONTCT_ZIP

 

SYCONTCT_COUNTRY

 

SYCONTCT_LNK_TEL_FLG

 

SYCONTCT_PHONE

 

SYCONTCT_PHONE_EXT

 

SYCONTCT_LNK_FAX_FLG

 

SYCONTCT_FAX

 

SYCONTCT_PASSWD

 

SYCONTCT_PASSWD_HINT

 

SYCONTCT_PASSWD_HT_V

 

SYCONTCT_BLK_ACCESS

 

SYCONTCT_BLK_REASON

 

SYCONTCT_BLK_ACCS_DT

 

SYCONTCT_BLK_EMAIL

 

SYCONTCT_BLK_EM_DT

 

SYCONTCT_FILLER_01

 

SYCONTCT_LNK_BT_ADR

 

SYCONTCT_BT_ADDR_1

 

SYCONTCT_BT_ADDR_2

 

SYCONTCT_BT_CITY

 

SYCONTCT_BT_STAT

 

SYCONTCT_BT_ZIP

 

SYCONTCT_BT_COUNTRY

 

SYCONTCT_SRCH_NAME

 

SYCONTCT_CREATE_DT

 

SYCONTCT_CREATE_TIME

 

SYCONTCT_ACCEPT_HTML

 

SYCONTCT_HOME_PHONE

 

SYCONTCT_MOBL_PHONE

 

SYCONTCT_BOUNCEBACKS

 

SYCONTCT_COMPANY_NA

 

SYCONTCT_BIRTH_YEAR

 

SYCONTCT_BIRTH_MON

 

SYCONTCT_BIRTH_DAY

 

SYCONTCT_CREATED_BY

 

SYCONTCT_FILLER_03

 

 

Customer Structure

When GetCustomerData = “Y.” This table contains the same column heading as the ARCUSFIL table.  It will contain all fields for the customer in the return dataset when you set GetCustomerData = “Y.”

 

Property

Detail

CUS_NO             

 

CUS_NAME           

 

CUS_CORR_NAME     

 

CUS_STREET1         

 

CUS_STREET2       

 

CUS_CITY           

 

CUS_ST             

 

CUS_ZIP           

 

CUS_COUNTRY       

 

CUS_CONTACT       

 

CUS_PHONE_NO       

 

CUS_START_DT       

 

CUS_SLM_NO         

 

CUS_TP             

 

CUS_BAL_METH       

 

CUS_STM_FREQ       

 

CUS_CR_LIMIT       

 

CUS_CR_RATING     

 

CUS_CR_HOLD_FG     

 

ARCUSFIL_FILLER_0001

 

CUS_COLLECTOR     

 

CUS_FIN_CHG_FG     

 

CUS_ORDER_LOC     

 

CUS_TERR           

 

CUS_AR_MAIN_NO

 

CUS_AR_SUB_NO

 

CUS_AR_DP_NO

 

CUS_SHIP_VIA_CD   

 

CUS_UPS_ZONE       

 

CUS_TERMS_CD       

 

CUS_DSC_PCT       

 

CUS_YTD_DSC_GIVEN 

 

CUS_TXBL_FG       

 

CUS_TX_CD1         

 

CUS_TX_CD2         

 

CUS_TX_CD3         

 

CUS_EXEMPT_NO     

 

CUS_SALES_PTD     

 

CUS_SALES_YTD     

 

CUS_SALES_LAST_YR 

 

CUS_COST_PTD       

 

CUS_COST_YTD       

 

CUS_COST_LAST_YR   

 

CUS_BALANCE       

 

CUS_HIGH_BALANCE   

 

CUS_LAST_SALE_DT   

 

CUS_LAST_SALE_AMT 

 

CUS_INV_YTD       

 

CUS_INV_LAST_YR   

 

CUS_PAID_INV_YTD   

 

CUS_LAST_PAY_DT   

 

CUS_LAST_PAY_AMT   

 

CUS_AVG_PAY_YTD   

 

CUS_AVG_PAY_LAST_YR

 

CUS_LAST_STM_AGE_DT

 

CUS_AMT_AGE_PD1   

 

CUS_AMT_AGE_PD2   

 

CUS_AMT_AGE_PD3   

 

CUS_AMT_AGE_PD4   

 

CUS_ALLOW_SUB_ITMS 

 

CUS_ALLOW_BO       

 

CUS_ALLOW_PART_SHIP

 

CUS_PRINT_DUNN_FG 

 

CUS_COMMENT1       

 

CUS_COMMENT2       

 

CUS_SEARCH_NAME   

 

CUS_NOTE_1         

 

CUS_NOTE_2         

 

CUS_NOTE_3         

 

CUS_NOTE_4         

 

CUS_NOTE_5         

 

CUS_USER_DATE     

 

CUS_USER_AMT       

 

CUS_EXEMPT_EXP_DATE

 

CUS_EXEMPT_REASON_CD

 

CUS_OUTSIDE_CITY_LM

 

CUS_GEO_CODE       

 

CUS_USE_BILL_TO_ADRR

 

CUS_BILL_TO_NO     

 

CUS_FORM_NO       

 

CUS_FAX_NUMBER     

 

CUS_SLM_START_DT   

 

CUS_ABC_CLASS     

 

CUS_FRT_PAY_CODE   

 

CUS_DEL_LEAD_TIME 

 

CUS_PICK_INV_AMT   

 

CUS_DEL_DAY_ERLY_ALW

 

CUS_SALES_YR_BF_LY 

 

CUS_ACCESS_DATE   

 

CUS_ACCESS_TIME   

 

CUS_IMMED_ORD_ACK 

 

CUS_TRANSFER_FLAG 

 

CUS_TRANSFER_TO_LOC

 

CUS_TRANSIT_DAYS

 

 

 

Open Item Structure

When GetOpenItem = “Y.” This table contains the same column heading as the AROPNFIL table.  It will contain all open item records for the customer in the return dataset when you set GetOpenItem = “Y.”

 

Property

Detail

AR_OPN_CUS_NO

 

AR_OPNE_DOC_DT

 

AR_OPN_DOC_NO

 

AR_OPN_DOC_TP

 

AR_OPN_APPLY_TO

 

AR_OPN_CUS_NO_ALT

 

AR_OPN_APPLY_TO_ALT

 

AR_OPN_DOC_DUE_DT

 

AR_OPN_AMT1

 

AR_OPN_AMT2

 

AR_OPN_REF

 

AR_OPN_TERMS_CD

 

AR_OPN_SLM_NO

 

AR_OPN_APPLY_AMT

 

AR_OPN_ORIG_INV_NO

 

AR_OPN_REASON_CD

 

AR_OPN_FILLER

 

 

 

Code Example (VB)

The following sample code will search for customer number “000100” and return its attributes.

 

Dim wsCustomerInfo As New webServicesCustomerInquiry.CustomerInquiry()

Dim Result As New webServicesCustomerInquiry.CustomerInfoResult

Result = wsCustomerInfo.CustomerInfo(“ ”, “ “, “000100”, “Y“,“ “,“ “,“ “,“ “,“ “,“ “,“ “)

If Result.ReturnCode = 30001 Then

  lblResult.Text = "Customer not found"

Else

lblResult.Text = Result.ReturnCode.ToString

End If

 

If Result.ReturnCode = 0 Then

Return result

End If

 

GetARCodes

 

This method uses the relational engine to execute the SQL command and retrieve the all of the salesman, customer type, state, ship via, terms, and tax codes on file that is chosen.

 

Usage:

GetARCodesResult = A.GetARCodes(GetARSLMFIL, GetARCUSTYP, GetSTATEFIL, GetSHIPVIA, GetTERMS, GetTAX)

 

Parameter Name

Type

Detail

GetARSLMFIL

String

Specify Y to retrieve all salesman from the salesman file.  Do not indicate “Y” unless you need the data.  Otherwise, performance can  slow down unnecessarily.

GetARCUSTYP

String

Specify Y to retrieve all customer types from the customer type file.  Do not indicate “Y” unless you need the data.  Otherwise, performance can  slow down unnecessarily.

GetSTATEFIL

String

Specify Y to retrieve all states from the state file.  Do not indicate “Y” unless you need the data.  Otherwise, performance can slow down unnecessarily.

GetSHIPVIA

String

Specify Y to retrieve all ship via codes from the ship via code file.  Do not indicate “Y” unless you need the data.  Otherwise, performance can  slow down unnecessarily.

GetTERMS

String

Specify Y to retrieve all terms codes from the terms code file.  Do not indicate “Y” unless you need the data.  Otherwise, performance can slow down unnecessarily.

GetTAX

String

Specify Y to retrieve all tax codes from the tax code file.  Do not indicate “Y” unless you need the data.  Otherwise, performance can slow down unnecessarily.

 

GetARCodesResult Structure

Property

Type

Detail

ReturnCode

Integer

Contains return code. Zero means OK; for other return codes, please see “EliloginService Return Code” section.

ARCodes

DataSet

Contains the following datasets: Salesman, Customer Type, State, Ship Via, Terms and Tax codes. For detail information of the dataset table, please refer to the following section.

 

ARSLMFIL Structure

When GetARSLMFIL = “Y.” This table contains the same column heading as the ARSLMFIL table.  It will contain all salesman records in the return dataset when you set GetARSLMFIL = “Y.”

Property

Detail

SLM_NO

 

SLM_NAME

 

 

ARCUSTYP Structure

When GetARCUSTYP = “Y.” This table contains the same column heading as the ARCUSTYP table.  It will contain all customer type records in the return dataset when you set GetARCUSTYP = “Y.”

Property

Detail

CUST_TYPE

 

CUST_TYPE_DESC

 

 

STATEFIL Structure

When GetSTATEFIL = “Y.” This table contains the same column heading as the STATEFIL table.  It will contain all state records in the return dataset when you set GetSTATEFIL = “Y.”

Property

Detail

STATE_ID

 

STATE_DESC

 

 

SHIPVIA Structure

When GetSHIPVIA = “Y.” This table contains the same column heading as the SHIPVIA table.  It will contain all ship via code records in the return dataset when you set GetSHIPVIA = “Y.”

Property

Detail

SHIP_VIA_CD

 

SHIP_VIA_CD_DESC

 

 

TERMS Structure

When GetTERMS = “Y.” This table contains the same column heading as the TERMS table.  It will contain all terms code records in the return dataset when you set GetTERMS = “Y.”

Property

Detail

TERMS_CD

 

TERMS_CD_DESC

 

TAX Structure

When GetTAX = “Y.” This table contains the same column heading as the TAX table.  It will contain all tax code records in the return dataset when you set GetTAX = “Y.”

Property

Detail

TAX_CD1

 

TAX_CD1_DESC

 

 

 

CustomerInquiry Return Code

0 = OK (No Error),

10001 = Missing Customer Number

10002 = Invalid Detail Level

30000 = Database Error

30001 = No Record Found

30002 = General Error

 

Feedback and Knowledge Base