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