Skip to content

ElicustmService

ElicustmService.asmx

This web service provides methods related to customers. User can add, change, delete or view a customer; this web service also has methods for customer inquiries (search) by name or additional user-definable keys.

This web service provides the following methods:

·        AddCustomer

·        ChangeCustomer

·        DeleteCustomer

·        ViewCustomer

·        InquiryBy5Keys

·        InquiryByCustomerName

·        InquiryByCustomerNo

·        GetShipTo

Customer number in input fields of this web service will be padded with leading zeros to make it six digits long. For example, customer# “123” will become to “000123.”

 

AddCustomer

This method will add a new customer. To use this method, you need to have a default customer (customer number “&&&&&”). If a field’s value is not provided, most of the time this method will assign a value from default customer. Some fields will default to blank or zero, such as customer’s address, customer balance… etc.

Usage:

AddCustomerResult = A.AddCustomer(UserName, UserPassword, AddCustomerInput)

Parameters UserName and UserPassword are not used at this moment.

 

AddCustomerInput Structure

Property

Length

Type

Upper

Detail

CUS_COLLECTOR

3

String

Y

If this field is not provided, its value will be getting from default customer.

CUS_STREET1

30

String

 

Customer address 1.

If this field is not provided, its value will be blank.

CUS_STREET2

30

String

 

Customer address 2.

If this field is not provided, its value will be blank.

CUS_ALLOW_BO

1

String

 

Allow back order or not. The value should be “Y” or “N.”

If this field is not provided, its value will be obtained from default customer.

CUS_ALLOW_PART_SHIP

1

String

 

Allow partial ship. The value here should be “Y” or “N.” If the value is not provided, this method will be obtained from default customer.

CUS_ALLOW_SUB_ITMS

1

String

 

Allow substitute item. The value here should be “Y” or “N.” If the value is not provided, this method will be obtained from default customer.

CUS_AMT_AGE_PD1

9.2

Double

 

Age Amt 30 Days. If this field is not provided, its value will be zero.

CUS_AMT_AGE_PD2

9.2

Double

 

Age Amt 60 Days. If this field is not provided, its value will be zero.

CUS_AMT_AGE_PD3

9.2

Double

 

Age Amt 90 Days. If this field is not provided, its value will be zero.

CUS_AMT_AGE_PD4

9.2

Double

 

Age Amt 120 Days. If this field is not provided, its value will be zero.

CUS_AR_MAIN_NO

8

String

Y

Acct No (part 1). If the value is not provided, this method will get it from default customer.

CUS_AR_SUB_NO

8

String

Y

Acct No (part 2). If the value is not provided, this method will get it from default customer.

CUS_AR_DP_NO

8

String

Y

Acct No (part 3). If the value is not provided, this method will get it from default customer.

CUS_AVG_PAY_LAST_YR

5

Double

 

Avg Days Pay Last Yr. If this field is not provided, its value will be zero.

CUS_AVG_PAY_YTD

5

Double

 

Avg Days Pay YTD. If this field is not provided, its value will be zero.

CUS_BALANCE

9.2

Double

 

Customer balance. If this field is not provided, its value will be zero.

CUS_BAL_METH

1

String

Y

Customer balance method. If the value is not provided, this method will get it from default customer.

CUS_BILL_TO_NO

6

String

Y

Bill to number. If the value is not provided, this method will get it from default customer.

CUS_CITY

15

String

 

If this field is not provided, its value will be blank.

CUS_COMMENT1

30

String

Y

Customer comments (line 1). If the value is not provided, this method will get it from default customer.

CUS_COMMENT2

30

String

Y

Customer comments (line 2). If the value is not provided, this method will get it from default customer.

CUS_CONTACT

20

String

 

Contact. If this field is not provided, its value will be blank.

CUS_CORR_NAME

30

String

 

Corresponding name. If this field is not provided, its value will be blank.

CUS_COST_LAST_YR

9.2

Double

 

Cost last year. If this field is not provided, its value will be zero.

CUS_COST_PTD

9.2

Double

 

Cost period to date. If this field is not provided, its value will be zero.

CUS_COST_YTD

9.2

Double

 

Cost year to date. If this field is not provided, its value will be zero.

CUS_COUNTRY

10

String

Y

Country. If the value is not provided, this method will get it from default customer.

CUS_CR_HOLD_FG

1

String

Y

Credit hold flag. This field should be “Y” or “N.” If the value is not provided, this method will get it from default customer.

CUS_CR_LIMIT

9

Integer

 

Credit limit. If the value is not provided, this method will get it from default customer.

CUS_CR_RATING

4

String

Y

Credit rate. If the value is not provided, this method will get it from default customer.

CUS_NAME

30

String

 

Customer name. If this field is not provided, its value will be blank.

CUS_NO

6

String

Y

If you do not provide a customer number, this method will automatically assign one to the new customer. If you provide a customer number, this method will check if it is unique, and return an error code if it is not unique.

CUS_TP

5

String

Y

Cust type. If the value is not provided, this method will get it from default customer.

CUS_START_DT

8

Date

 

If this field is not provided, its value will be system date.

CUST_TYPE_DESC

15

String

 

This field is not used. Cust type description will be obtained from customer type file by given customer type.

CUS_DISC_PCT

3.2

Single

 

Discount %. If the value is not provided, this method will get it from default customer.

CUS_EXEMPT_EXP_DATE

8

Date

 

Exempt expire date. If the value is not provided, this method will get it from default customer.

CUS_EXEMPT_NO

15

String

Y

Exempt number. If the value is not provided, this method will get it from default customer.

CUS_EXEMPT_REASON_CD

1

String

Y

Exempt reason code. If the value is not provided, this method will get it from default customer.

CUS_FAX_NUMBER

12

String

Y

Fax number. If this field is not provided, its value will be blank.

CUS_FIN_CHG_FG

1

String

Y

Finance charge flag. This field should be “Y” or “N.” If the value is not provided, this method will get it from default customer.

CUS_FORM_NO

2

Integer

 

Invoice form number. If the value is not provided, this method will get it from default customer.

CUS_GEO_CODE

9

String

Y

Customer geo code. If the value is not provided, this method will get it from default customer.

CUS_HELD_ORD_AMT

9.2

Double

 

There is some legacy implementation issue here. Now this field is linked to “Sales year before last year”. The input property CUS_SALES_YR_BF_LY is also linked to the same field, which has higher priority than this field.

We suggest you use CUS_SALES_YR_BF_LY instead of this field.

CUS_HIGH_BALANCE

9.2

Double

 

Highest balance. If this field is not provided, its value will be zero.

CUS_INV_LAST_YR

6

Double

 

Invoices last year. If this field is not provided, its value will be zero.

CUS_INV_YTD

6

Double

 

Invoices year to date. If this field is not provided, its value will be zero.

CUS_LAST_PAY_AMT

9.2

Double

 

Last payment amount. If this field is not provided, its value will be zero.

CUS_LAST_PAY_DT

8

Date

 

Last payment date. If this field is not provided, its value will be zero.

CUS_LAST_SALE_AMT

9.2

Double

 

Last sale amount. If this field is not provided, its value will be zero.

CUS_LAST_SALE_DT

8

Date

 

Last sale date. If this field is not provided, its value will be zero.

CUS_LAST_STM_AGE_DT

8

Date

 

Last aging date. If this field is not provided, its value will be zero.

CUS_NOTE_1

30

String

Y

User Definable field 1. If the value is not provided, this method will get it from default customer.

CUS_NOTE_2

30

String

Y

User Definable field 2. If the value is not provided, this method will get it from default customer.

CUS_NOTE_3

30

String

Y

User Definable field 3. If the value is not provided, this method will get it from default customer.

CUS_NOTE_4

30

String

Y

User Definable field 4. If the value is not provided, this method will get it from default customer.

CUS_NOTE_5

30

String

Y

User Definable field 5. If the value is not provided, this method will get it from default customer.

CUS_OPEN_ORD_AMT

9.2

Double

 

There is some legacy implementation issue here. Now this field is linked to “Open order pick/invoiced amount.” The input property CUS_PICK_INV_AMT is also linked to the same field, which has higher priority than this field.

We suggest you to use CUS_PICK_INV_AMT instead of this field.

CUS_ORDER_LOC

2

String

Y

Customer order location. If the value is not provided, this method will get it from default customer.

CUS_OUTSIDE_CITY_LM

1

String

Y

Outside city limit. If the value is not provided, this method will get it from default customer.

CUS_PAID_INV_YTD

6

Integer

 

Invoices paid year to date. If this field is not provided, its value will be zero.

CUS_PHONE_NO

12

String

Y

Phone number. If this field is not provided, its value will be blank.

CUS_PRINT_DUNN_FG

1

String

Y

Print dunning letters flag. This field should be “Y” or “N.” If the value is not provided, this method will get it from default customer.

CUS_SALES_LAST_YR

9.2

Double

 

Sales last year. If this field is not provided, its value will be zero.

CUS_SLM_NO

3

String

Y

Salesman Number. If the value is not provided, this method will get it from default customer.

CUS_SALES_PTD

9.2

Double

 

Sales period to date. If this field is not provided, its value will be zero.

CUS_SALES_YTD

9.2

Double

 

Sales year to date. If this field is not provided, its value will be zero.

CUS_SEARCH_NAME

30

String

 

This field is not used. Customer search name is upper case of customer name.

SHIP_VIA_CD

2

String

Y

Ship via code. If the value is not provided, this method will get it from default customer.

CUS_SLM_STRT_DT

8

Date

 

Salesman start date. If the value is not provided, this method will get it from default customer.

CUS_ST

2

String

Y

State. If this field is not provided, its value will be blank.

CUS_STM_FREQ

1

String

Y

Customer statement frequency. If the value is not provided, this method will get it from default customer.

CUS_TXBL_FG

1

String

Y

Taxable flag. This field should be “Y” or “N.” If the value is not provided, this method will get it from default customer.

CUS_TX_CD1

3

String

Y

Tax code 1. If the value is not provided, this method will get it from default customer.

Note: If using the Avalara Integration, you will have to pass the state + "1" for tax code 1, the state + "2" for tax code 2 and the state + "3" for tax code 3. For example, if the state is Missouri, pass MO1 for tax code 1, MO2, for tax code 2, and MO3 for tax code 3. 

CUS_TX_CD2

3

String

Y

Tax code 2. If the value is not provided, this method will get it from default customer.

CUS_TX_CD3

3

String

Y

Tax code 3. If the value is not provided, this method will get it from default customer.

TERMS_CD

2

String

Y

Terms code. If the value is not provided, this method will get it from default customer.

CUS_TERR

2

String

Y

Territory. If the value is not provided, this method will get UPS zone from default customer.

CUS_UPS_ZONE

2

String

Y

UPS zone. If the value is not provided, this method will get UPS zone from default customer.

CUS_USE_BILL_TO_ADRR

1

String

Y

“Y”: Get Order Bill-To Address from Bill-To No, and Order Ship-To Address from this customer.

“N”: Get Order Bill-To Address and Order Ship-To Address from Bill-To No.

“S”: Get Order Bill-To Address and Order Ship-To Address from this customer.

If the value is not provided, this method will get it from default customer.

CUS_USER_AMT

7.2

Double

 

User definable amount. If the value is not provided, this method will get it from default customer.

CUS_USER_DATE

8

Date

 

User definable date. If the value is not provided, this method will get it from default customer.

CUS_YTD_DSC_GIVEN

9.2

Double

 

Discount given year to date. If this field is not provided, its value will be zero.

CUS_ZIP

2

String

Y

Zip code. If this field is not provided, its value will be blank.

CUS_PICK_INV_AMT

9.2

Double

 

Open order pick/invoiced amount. The input property CUS_OPEN_ORD_AMT is also linked to the same field, which has lower priority than this field.

We suggest you to use this field instead of CUS_OPEN_ORD_AMT.

If there are no values in both fields, this method will get it from default customer.

CUS_SALES_YR_BF_LY

9.2

Double

 

Sales year before last year. The input property CUS_HELD_ORD_AMT is also linked to the same field, which has lower priority than this field.

We suggest you to use this field instead of CUS_HELD_ORD_AMT.

If there are no values in both fields, this method will get it from default customer.

CUS_ABC_CLASS

1

String

Y

ABC class. Should be “A,” “B” or “C.” If the value is not provided, this method will get it from default customer.

CUS_DEL_LEAD_TIME

3

Integer

 

Delivery lead time (“Ship To Days” field in Elliott customer file). If the value is not provided, this method will get it from default customer.

CUS_DEL_DAY_ERLY_ALW

3

Integer

 

Days delivery early allowed. If the value is not provided, this method will get it from default customer.

 

AddCustomerResult Structure

Property Name

Type

Detail

ReturnCode

Integer

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

ReturnMsg

String

This is description of return code. For example, if return code is zero, you can expect “OK” in this field.

CUS_NO

String

This is the customer number of just created customer.  It is possible you leave the CUS_NO in Input blank and cause system to sequentially assign the next customer number which is return in this field.

 

Code Example (VB)

The following sample code will add a customer. Most of the columns of this newly added customer will get its default value from default customer # “&&&&&&”.

 

Dim Service As New webServicesCustm.ElicustmService

Dim Result As New webServicesCustm.AddCustomerResult

Dim Input As New webServicesCustm.AddCustomerInput

Input.CUS_NO = “000001”

Input.CUS_NAME = “Netcellent System, Inc.”

Input.CUS_STREET1 = “4030 Valley Blvd. #100”

Input.CUS_CITY = “Walnut”

Input.CUS_ST = “CA”

Input.CUS_ZIP = “91789”

Input.CUS_CONTACT = “John”

Input.CUS_ORDER_LOC = “BR”

Result = Service.AddCustomer(“”, “”, Input)

If Result.ReturnCode = 0 Then

      lblResult.Text = “Cust# ” & Result.CUS_NO & “Added”

Else

  lblResult.Text = Result.ReturnMsg

  lblErrorCode.Text = Result.ReturnCode.ToString

End If

 

ChangeCustomer

This method can change a customer record. You must specify the Customer Number in order to change. This method supports clearing fields, you can pass a single space to a string field, or pass zero to a numeric field to clear it.  If you do not wish to clear the fields, simply do not assign value to the field. Then the field’s original value will not be changed.

Usage:

ChangeCustomerResult = A.ChangeCustomer(UserName, UserPassword, ChangeCustomerInput)

Parameters UserName and UserPassword are not used at this moment.

 

ChangeCustomerInput Structure

Property

Length

Type

Upper

Detail

CUS_COLLECTOR

3

String

Y

Collector.

CUS_STREET1

30

String

 

Customer address 1.

CUS_STREET2

30

String

 

Customer address 2.

CUS_ALLOW_BO

1

String

 

Allow back order or not. The value should be “Y” or “N”.

CUS_ALLOW_PART_SHIP

1

String

 

Allow partial ship. The value here should be “Y” or “N”.

CUS_ALLOW_SUB_ITMS

1

String

 

Allow substitute item. The value here should be “Y” or “N”.

CUS_AMT_AGE_PD1

9.2

Double

 

Age Amt 30 Days.

CUS_AMT_AGE_PD2

9.2

Double

 

Age Amt 60 Days.

CUS_AMT_AGE_PD3

9.2

Double

 

Age Amt 90 Days.

CUS_AMT_AGE_PD4

9.2

Double

 

Age Amt 120 Days.

CUS_AR_MAIN_NO

8

String

Y

Acct No (part 1).

CUS_AR_SUB_NO

8

String

Y

Acct No (part 2).

CUS_AR_DP_NO

8

String

Y

Acct No (part 3).

CUS_AVG_PAY_LAST_YR

5

Double

 

Avg Days Pay Last Yr.

CUS_AVG_PAY_YTD

5

Double

 

Avg Days Pay YTD.

CUS_BALANCE

9.2

Double

 

Customer balance.

CUS_BAL_METH

1

String

Y

Customer balance method.

CUS_BILL_TO_NO

6

String

Y

Bill to number.

CUS_CITY

15

String

 

City.

CUS_COMMENT1

30

String

Y

Customer comments (line 1).

CUS_COMMENT2

30

String

Y

Customer comments (line 2).

CUS_CONTACT

20

String

 

Contact.

CUS_CORR_NAME

30

String

 

Corresponding name.

CUS_COST_LAST_YR

9.2

Double

 

Cost last year.

CUS_COST_PTD

9.2

Double

 

Cost period to date.

CUS_COST_YTD

9.2

Double

 

Cost year to date.

CUS_COUNTRY

10

String

Y

Country.

CUS_CR_HOLD_FG

1

String

Y

Credit hold flag. This field should be “Y” or “N”.

CUS_CR_LIMIT

9

Integer

 

Credit limit.

CUS_CR_RATING

4

String

Y

Credit rate.

CUS_NAME

30

String

 

Customer name.

CUS_NO

6

String

Y

Required. This is the key field to locate the customer record.

CUS_TP

5

String

Y

Cust type.

CUS_START_DT

8

Date

 

Start date.

CUST_TYPE_DESC

15

String

 

This field is not used.

CUS_DISC_PCT

3.2

Single

 

Discount %.

CUS_EXEMPT_EXP_DATE

8

Date

 

Exempt expire date.

CUS_EXEMPT_NO

15

String

Y

Exempt number.

CUS_EXEMPT_REASON_CD

1

String

Y

Exempt reason code.

CUS_FAX_NUMBER

12

String

Y

Fax number.

CUS_FIN_CHG_FG

1

String

Y

Finance charge flag. This field should be “Y” or “N”.

CUS_FORM_NO

2

Integer

 

Invoice form number.

CUS_GEO_CODE

9

String

Y

Customer geo code.

CUS_HELD_ORD_AMT

9.2

Double

 

This field is linked to “Sales year before last year”.

We suggest you to use CUS_SALES_YR_BF_LY instead of this field.

CUS_HIGH_BALANCE

9.2

Double

 

Highest balance.

CUS_INV_LAST_YR

6

Double

 

Invoices last year.

CUS_INV_YTD

6

Double

 

Invoices year to date.

CUS_LAST_PAY_AMT

9.2

Double

 

Last payment amount.

CUS_LAST_PAY_DT

8

Date

 

Last payment date.

CUS_LAST_SALE_AMT

9.2

Double

 

Last sale amount.

CUS_LAST_SALE_DT

8

Date

 

Last sale date.

CUS_LAST_STM_AGE_DT

8

Date

 

Last aging date.

CUS_NOTE_1

30

String

Y

User Definable field 1.

CUS_NOTE_2

30

String

Y

User Definable field 2.

CUS_NOTE_3

30

String

Y

User Definable field 3.

CUS_NOTE_4

30

String

Y

User Definable field 4.

CUS_NOTE_5

30

String

Y

User Definable field 5.

CUS_OPEN_ORD_AMT

9.2

Double

 

This field is linked to “Open order pick/invoiced amount”.

We suggest you to use CUS_PICK_INV_AMT instead of this field.

CUS_ORDER_LOC

2

String

Y

Customer order location.

CUS_OUTSIDE_CITY_LM

1

String

Y

Outside city limit.

CUS_PAID_INV_YTD

6

Integer

 

Invoices paid year to date.

CUS_PHONE_NO

12

String

Y

Phone number.

CUS_PRINT_DUNN_FG

1

String

Y

Print dunning letters flag. This field should be “Y” or “N”.

CUS_SALES_LAST_YR

9.2

Double

 

Sales last year.

CUS_SLM_NO

3

String

Y

Salesman Number.

CUS_SALES_PTD

9.2

Double

 

Sales period to date.

CUS_SALES_YTD

9.2

Double

 

Sales year to date.

CUS_SEARCH_NAME

30

String

 

This field is not used.

SHIP_VIA_CD

2

String

Y

Ship via code.

CUS_SLM_STRT_DT

8

Date

 

Salesman start date.

CUS_ST

2

String

Y

State.

CUS_STM_FREQ

1

String

Y

Customer statement frequency.

CUS_TXBL_FG

1

String

Y

Taxable flag. This field should be “Y” or “N”.

CUS_TX_CD1

3

String

Y

Tax code 1.

CUS_TX_CD2

3

String

Y

Tax code 2.

CUS_TX_CD3

3

String

Y

Tax code 3.

TERMS_CD

2

String

Y

Terms code.

CUS_TERR

2

String

Y

Territory.

CUS_UPS_ZONE

2

String

Y

UPS zone.

CUS_USE_BILL_TO_ADRR

1

String

Y

“Y”: Get Order Bill-To Address from Bill-To No, and Order Ship-To Address from this customer.

“N”: Get Order Bill-To Address and Order Ship-To Address from Bill-To No.

“S”: Get Order Bill-To Address and Order Ship-To Address from this customer.

CUS_USER_AMT

7.2

Double

 

User definable amount.

CUS_USER_DATE

8

Date

 

User definable date.

CUS_YTD_DSC_GIVEN

9.2

Double

 

Discount given year to date.

CUS_ZIP

2

String

Y

Zip code.

CUS_PICK_INV_AMT

9.2

Double

 

Open order pick/invoiced amount. The input property CUS_OPEN_ORD_AMT is also linked to the same field, which has lower priority than this field.

We suggest you to use this field instead of CUS_OPEN_ORD_AMT.

CUS_SALES_YR_BF_LY

9.2

Double

 

Sales year before last year. The input property CUS_HELD_ORD_AMT is also linked to the same field, which has lower priority than this field.

We suggest you to use this field instead of CUS_HELD_ORD_AMT.

CUS_ABC_CLASS

1

String

Y

ABC class. Should be “A”, “B” or “C”.

CUS_DEL_LEAD_TIME

3

Integer

 

Delivery lead time (“Ship To Days” field in Elliott customer file).

CUS_DEL_DAY_ERLY_ALW

3

Integer

 

Days delivery early allowed.

 

Output Parameter

Property Name

Type

Detail

ChangeCustomerResult

Integer

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

 

Code Example (VB)

The following sample code will put customer# “000001” on credit hold.

 

Dim Service As New webServicesCustm.ElicustmService

Dim Result As Integer

Dim Input As New webServicesCustm.ChangeCustomerInput

Input.CUS_NO = “000001”

Input.CUS_CR_HOLD_FG = “Y”

Result = Service.ChangeCustomer(“”, “”, Input)

If Result = 0 Then

   lblResult.Text = “Customer Data Has Been Changed.”

Else

  lblResult.Text = “Error While Changing Customer.”

  lblErrorCode.Text = Result.ToString

End If

 

DeleteCustomer

This method will delete a customer by providing customer number.

Usage:

DeleteCustomerResult = A.DeleteCustomer(UserName, UserPassword, CUS_NO)

Parameters UserName and UserPassword are not used at this moment.

 

Input Parameter

Parameter

Length

Type

Upper

Detail

CUS_NO

6

String

Y

Required.

 

Output Parameter

Property Name

Type

Detail

DeleteCustomerResult

Integer

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

 

Code Example (VB)

The following sample code will delete customer# “000001”.

 

Dim Service As New webServicesCustm.ElicustmService

Dim Result As Integer

Result = Service.DeleteCustomer(“”, “”, “000001”)

If Result = 0 Then

   lblResult.Text = “Customer# 000001 Has Been Deleted.”

Else

  lblResult.Text = “Error While Deleting Customer.”

  lblErrorCode.Text = Result.ToString

End If

 

ViewCustomer

This method will return one customer record by providing a customer number.

Usage:

ViewCustomerResult = A.ViewCustomer(UserName, UserPassword, CUS_NO)

Parameters UserName and UserPassword are not used at this moment.

 

Input Parameter

Property

Length

Type

Upper

Detail

CUS_NO

6

String

Y

Required

 

ViewCustomerResult Structure

Please see “ChangeCustomerInput Structure” for the explanation of each field.

Property Name

Type

Detail

ReturnCode

Integer

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

ReturnMsg

String

This is description of return code. For example, if return code is zero, you can expect “OK” in this field.

CUS_COLLECTOR

String

 

CUS_STREET1

String

 

CUS_STREET2

String

 

CUS_ALLOW_BO

String

 

CUS_ALLOW_PART_SHIP

String

 

CUS_ALLOW_SUB_ITMS

String

 

CUS_AMT_AGE_PD1

Double

 

CUS_AMT_AGE_PD2

Double

 

CUS_AMT_AGE_PD3

Double

 

CUS_AMT_AGE_PD4

Double

 

CUS_AR_MAIN_NO

String

 

CUS_AR_SUB_NO

String

 

CUS_AR_DP_NO

String

 

CUS_AVG_PAY_LAST_YR

Double

 

CUS_AVG_PAY_YTD

Double

 

CUS_BALANCE

Double

 

CUS_BAL_METH

String

 

CUS_BILL_TO_NO

String

 

CUS_CITY

String

 

CUS_COMMENT1

String

 

CUS_COMMENT2

String

 

CUS_CONTACT

String

 

CUS_CORR_NAME

String

 

CUS_COST_LAST_YR

Double

 

CUS_COST_PTD

Double

 

CUS_COST_YTD

Double

 

CUS_COUNTRY

String

 

CUS_CR_HOLD_FG

String

 

CUS_CR_LIMIT

Integer

 

CUS_CR_RATING

String

 

CUS_NAME

String

 

CUS_NO

String

 

CUS_TP

String

 

CUS_START_DT

Date

 

CUST_TYPE_DESC

String

 

CUST_TYPE_USE_LABEL

String

 

CUS_DISC_PCT

Single

 

CUS_EXEMPT_EXP_DATE

Date

 

CUS_EXEMPT_NO

String

 

CUS_EXEMPT_REASON_CD

String

 

CUS_FAX_NUMBER

String

 

CUS_FIN_CHG_FG

String

 

CUS_FORM_NO

Integer

 

CUS_GEO_CODE

String

 

CUS_HELD_ORD_AMT

Double

 

CUS_HIGH_BALANCE

Double

 

CUS_INV_LAST_YR

Double

 

CUS_INV_YTD

Double

 

CUS_LAST_PAY_AMT

Double

 

CUS_LAST_PAY_DT

Date

 

CUS_LAST_SALE_AMT

Double

 

CUS_LAST_SALE_DT

Date

 

CUS_LAST_STM_AGE_DT

Date

 

CUS_NOTE_1

String

 

CUS_NOTE_2

String

 

CUS_NOTE_3

String

 

CUS_NOTE_4

String

 

CUS_NOTE_5

String

 

CUS_OPEN_ORD_AMT

Double

 

CUS_ORDER_LOC

String

 

CUS_OUTSIDE_CITY_LM

String

 

CUS_PAID_INV_YTD

Integer

 

CUS_PHONE_NO

String

 

CUS_PRINT_DUNN_FG

String

 

CUS_SALES_LAST_YR

Double

 

SLM_ADDRESS1

String

 

SLM_ADDRESS2

String

 

SLM_EMAIL

String

 

SLM_INIT

String

 

SLM_NAME

String

 

CUS_SLM_NO

String

 

SLM_PHONE_NO

String

 

SLM_TERR

String

 

CUS_SALES_PTD

Double

 

TAX_CD1_DESC

String

 

TAX_CD2_DESC

String

 

TAX_CD3_DESC

String

 

TAX_CD1_PCT

Double

 

TAX_CD2_PCT

Double

 

TAX_CD3_PCT

Double

 

TAX_FREIGHT1_FLAG

String

 

TAX_FREIGHT2_FLAG

String

 

TAX_FREIGHT3_FLAG

String

 

CUS_SALES_YTD

Double

 

CUS_SEARCH_NAME

String

 

CARRIER_BOL_REQ

String

 

MANIFEST_CARRIER_CD

String

 

MANIFEST_MODE_CODE

String

 

REQ_SHIPPING_VERIF

String

 

SHIP_VIA_CD

String

 

SHIP_VIA_CD_DESC

String

 

CUS_SLM_STRT_DT

Date

 

CUS_ST

String

 

CUS_STM_FREQ

String

 

CUS_TXBL_FG

String

 

CUS_TX_CD1

String

 

CUS_TX_CD2

String

 

CUS_TX_CD3

String

 

TERMS_ABS_DIS_DUE_DT

Date

 

TERMS_ABS_DUE_DATE

Date

 

TERMS_CD

String

 

MANIFEST_COD_TRX_FLG

String

 

MANIFEST_COD_TERMS

String

 

TERMS_CD_DUE_DAY

Integer

 

TERMS_CD_DESC

String

 

TERMS_CD_DISC_DAYS

Integer

 

TERMS_CD_DISC_PCT

Double

 

TERMS_CD_DUE_DAYS

Integer

 

TERMS_EXTRA_CHRG_CD

String

 

TERMS_EXTRA_CHRG

Double

 

TERMS_PROX_MON_END

Integer

 

TERMS_PROX_TERMS

String

 

TERMS_PROX_TERMS_DSC

Integer

 

CUS_TERR

String

 

CUS_UPS_ZONE

String

 

CUS_USE_BILL_TO_ADRR

String

 

CUS_USER_AMT

Double

 

CUS_USER_DATE

Date

 

CUS_YTD_DSC_GIVEN

Double

 

CUS_ZIP

String

 

CUS_PICK_INV_AMT

Double

 

CUS_SALES_YR_BF_LY

Double

 

CUS_ABC_CLASS

String

 

CUS_DEL_LEAD_TIME

Integer

 

CUS_DEL_DAY_ERLY_ALW

Integer

 

CUS_ACCESS_DATE

Date

 

CUS_ACCESS_TIME

Integer

 

 

Code Example (VB)

The following sample code will return the record of customer# “000001”.

 

Dim Service As New webServicesCustm.ElicustmService

Dim Result As New webServicesCustm.ViewCustomerResult

Result = Service.ViewCustomer(“”, “”, “000001”)

If Result.ReturnCode = 0 Then

   lblResult.Text = “Customer Name: ” & Result.CUS_NAME

Else

  lblResult.Text = “Error While Viewing Customer.”

  lblErrorCode.Text = Result.ReturnMsg

End If

 

 

 

InquiryBy5Keys

This method will return up to 999 customer records by providing the customer search key name and its value as a starting point.

Usage:

InquiryBy5KeysResult = A.InquiryBy5Keys(UserName, UserPassword, KeyName, StartingKeyValue, TableSize)

Parameters UserName and UserPassword are not used at this moment.

 

Input Parameters

Parameter

Length

Type

Upper

Detail

KeyName

15

String

Y

Required. The value here must be one of the following or you will get error code 29:

ADDRESS-1

CITY

ZIP-CODE

TELEPHONE

FAXNUMBER

CONTACT

COMMENT-1

COMMENT-2

NOTE-1

NOTE-2

NOTE-3

NOTE-4

NOTE-5

ACCT-DATE

USER-DATE

CUST-TYPE

CREDIT-RATE

CORRESP-NAME

BILL-TO-NO

COUNTRY

EXEMPT-NO

 

If provided value is one of the above, but it’s not in one of the five “Additional search key for customer” in Elliott Global Setup, you will not find any customer, which is error code 28.

StartingKeyValue

30

String

Y

The start value of keyname field.

TableSize

3

Integer

 

Since this is a begin search, so we need to limit the number of CustomerRecord returned by using this value. The default value is 100 and the maximum value is 999.

 

InquiryBy5KeysResult Structure

Property Name

Type

Detail

ReturnCode

Integer

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

ReturnMsg

String

This is description of return code. For example, if return code is zero, you can expect “OK” in this field.

TableCount

Integer

Indicates how many records in CustomerRecord() array.

CustomerRecord()

CustomerRecord

Contains up to 999 customer records. See the following section for the structure of CustomerRecord.

 

CustomerRecord Structure

Please see “ChangeCustomerInput Structure” for the explanation of each field.

Property Name

Type

Detail

CUS_NO

String

 

CUS_NAME

String

 

CUS_CORR_NAME

String

 

CUS_STREET1

String

 

CUS_STREET2

String

 

CUS_CITY

String

 

CUS_ST

String

 

CUS_ZIP

String

 

CUS_COUNTRY

String

 

CUS_CONTACT

String

 

CUS_PHONE_NO

String

 

CUS_START_DT

Date

 

CUS_SLM_NO

String

 

CUS_TP

String

 

CUS_BAL_METH

String

 

CUS_STM_FREQ

String

 

CUS_CR_LIMIT

Integer

 

CUS_CR_RATING

String

 

CUS_CR_HOLD_FG

String

 

FILLER_0001

String

 

CUS_COLLECTOR

String

 

CUS_FIN_CHG_FG

String

 

CUS_ORDER_LOC

String

 

CUS_TERR

String

 

CUS_AR_MAIN_NO

String

 

CUS_AR_SUB_NO

String

 

CUS_AR_DP_NO

String

 

CUS_SHIP_VIA_CD

String

 

CUS_UPS_ZONE

String

 

CUS_TERMS_CD

String

 

CUS_DSC_PCT

Double

 

CUS_YTD_DSC_GIVEN

Double

 

CUS_TXBL_FG

String

 

CUS_TX_CD1

String

 

CUS_TX_CD2

String

 

CUS_TX_CD3

String

 

CUS_EXEMPT_NO

String

 

CUS_SALES_PTD

Double

 

CUS_SALES_YTD

Double

 

CUS_SALES_LAST_YR

Double

 

CUS_COST_PTD

Double

 

CUS_COST_YTD

Double

 

CUS_COST_LAST_YR

Double

 

CUS_BALANCE

Double

 

CUS_HIGH_BALANCE

Double

 

CUS_LAST_SALE_DT

Date

 

CUS_LAST_SALE_AMT

Double

 

CUS_INV_YTD

Integer

 

CUS_INV_LAST_YR

Integer

 

CUS_PAID_INV_YTD

Integer

 

CUS_LAST_PAY_DT

Date

 

CUS_LAST_PAY_AMT

Double

 

CUS_AVG_PAY_YTD

Integer

 

CUS_AVG_PAY_LAST_YR

Integer

 

CUS_LAST_STM_AGE_DT

Date

 

CUS_AMT_AGE_PD1

Double

 

CUS_AMT_AGE_PD2

Double

 

CUS_AMT_AGE_PD3

Double

 

CUS_AMT_AGE_PD4

Double

 

CUS_ALLOW_SUB_ITMS

String

 

CUS_ALLOW_BO

String

 

CUS_ALLOW_PART_SHIP

String

 

CUS_PRINT_DUNN_FG

String

 

CUS_COMMENT1

String

 

CUS_COMMENT2

String

 

CUS_SEARCH_NAME

String

 

CUS_NOTE_1

String

 

CUS_NOTE_2

String

 

CUS_NOTE_3

String

 

CUS_NOTE_4

String

 

CUS_NOTE_5

String

 

CUS_USER_DATE

Date

 

CUS_USER_AMT

Double

 

CUS_EXEMPT_EXP_DATE

Date

 

CUS_EXEMPT_REASON_CD

String

 

CUS_OUTSIDE_CITY_LM

String

 

CUS_GEO_CODE

String

 

CUS_USE_BILL_TO_ADRR

String

 

CUS_BILL_TO_NO

String

 

CUS_FORM_NO

Integer

 

CUS_FAX_NUMBER

String

 

CUS_SLM_STRT_DT

Date

 

CUS_PICK_INV_AMT

Double

 

CUS_SALES_YR_BF_LY

Double

 

CUS_FRY_PAY_CODE

String

 

CUS_ABC_CLASS

String

 

CUS_DEL_LEAD_TIME

Integer

 

CUS_DEL_DAY_ERLY_ALW

Integer

 

CUS_ACCESS_DATE

Date

 

CUS_ACCESS_TIME

Integer

 

FILLER_2

String

 

 

Code Example (VB)

The following sample code will return up to 50 customer records whose zip code is equal or greater than “91700”.

 

Dim Service As New webServicesCustm.ElicustmService

Dim Result As New webServicesCustm.InquiryBy5KeysResult

Dim KeyName As String = “ZIP-CODE”

Dim StartingKeyValue As String = “91700”

Dim TableSize As Integer = 50

Result = Service.InquiryBy5Keys(“”, “”,KeyName, StartingKeyValue, TableSize)

If Result.ReturnCode = 0 Then

   lblResult.Text = “First Customer No.: ” & _

                    Result.CustomerRecord(0).CUS_NO & _

                    “  Name: ” & _

                    Result.CustomerRecord(0).CUS_NAME

ElseIf Result.ReturnCode = 28

  lblResult.Text = “No record found.”

Else

  lblResult.Text = “Error While Querying Customer.”

  lblErrorCode.Text = Result.ReturnMsg

End If

 

InquiryByCustomerName

This method will return up to 999 customer records by providing starting customer name.

Usage:

InquiryByCustomerNameResult = A.InquiryByCustomerName(UserName, UserPassword, StartingCustomerName, TableSize)

Parameters UserName and UserPassword are not used at this moment.

 

Input Parameters

Parameter

Length

Type

Upper

Detail

StartingCustomerName

30

String

Y

 

TableSize

3

Integer

 

Size of return CustomerRecord array. Default is 100 and Default is 100 and max value is 999.

 

InquiryByCustomerNameResult Structure

Property Name

Type

Detail

ReturnCode

Integer

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

ReturnMsg

String

This is description of return code. For example, if return code is zero, you can expect “OK” in this field.

TableCount

Integer

Indicates how many records in CustomerRecord.

CustomerRecord()

CustomerRecord

Contains up to 999 customer records. See “CustomerRecord Structure” in InquiryBy5Keys method for more detail.

 

Code Example (VB)

The following sample codes will return up to 50 customer records starting from customer name “Netcellent”.

 

Dim Service As New webServicesCustm.ElicustmService

Dim Result As New webServicesCustm.InquiryByCustomerNameResult

Dim StartingCustomerName As String = “Netcellent”

Dim TableSize As Integer = 50

Result = Service.InquiryByCustomerName(“”, “”, StartingCustomerName, _

TableSize)

If Result.ReturnCode = 0 Then

   lblResult.Text = “First Customer No.: ” & _

  Result.CustomerRecord(0).CUS_NO & _

  “  Name: ” & Result.CustomerRecord(0).CUS_NAME

ElseIf Result.ReturnCode = 28 Then

  lblResult.Text = "No record found."

Else

  lblResult.Text = “Error While Querying Customer.”

  lblErrorCode.Text = Result.ReturnMsg

End If

 

InquiryByCustomerNo

This method will return up to 999 customer records by providing starting customer number.  This method is different from ViewCustomer where it will perform an exact search on customer number and only return one record if found.

Usage:

InquiryByCustomerNo = A.InquiryByCustomerNo(UserName, UserPassword, StartingCustomerNo, TableSize)

Parameters UserName and UserPassword are not used at this moment.

 

Input Parameters

Parameter

Length

Type

Upper

Detail

StartingCustomerNo

6

String

Y

 

TableSize

3

Integer

 

Size of return CustomerRecord array. Default is 100 and max value is 999.

 

InquiryByCustomerNoResult Structure

Property Name

Type

Detail

ReturnCode

Integer

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

ReturnMsg

String

This is description of return code. For example, if return code is zero, you can expect “OK” in this field.

TableCount

Integer

Indicates how many records in CustomerRecord.

CustomerRecord()

CustomerRecord

 

 

Code Example (VB)

The following sample code will return up to 50 customer records starting from customer number “234000”.

 

Dim Service As New webServicesCustm.ElicustmService

Dim Result As New webServicesCustm.InquiryByCustomerNoResult

Dim StartingCustomerNo As String = “234000”

Dim TableSize As Integer = 50

Result = Service.InquiryByCustomerNo(“”, “”,StartingCustomerNo, TableSize)

If Result.ReturnCode = 0 Then

   lblResult.Text = “First Customer No.: ” & _

                    Result.CustomerRecord(0).CUS_NO & _

                    “  Name: ” &  Result.CustomerRecord(0).CUS_NAME

ElseIf Result.ReturnCode = 28 Then

  lblResult.Text = "No record found"

Else

  lblResult.Text = “Error While Querying Customer.”

  lblErrorCode.Text = Result.ReturnMsg

End If

 

GetShipTo

This method will return all Ship-To records for the provided customer number. There’s no maximum limit on the number of ship-to records that can be returned in the dataset.

Usage:

GetShipToResult = A.GetShipTo(UserName, UserPassword, SHIP_TO_CUST_NO)

Parameters UserName and UserPassword are not used at this moment.

 

Input Parameters

Parameter

Length

Type

Upper

Detail

SHIP_TO_CUST_NO

 

String

 

Required.

 

GetShipToResult Structure

Property Name

Type

Detail

ReturnCode

Integer

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

ReturnMsg

String

This is description of return code. For example, if return code is zero, you can expect “OK” in this field.

CustomerShipTo

DataSet

This dataset has a table “CPSHPFIL” which contains the following fields:

SHIP_TO_CUST_NO

SHIP_TO_NO

SHIP_TO_NAME

SHIP_TO_ADDRESS1

SHIP_TO_ADDRESS2

SHIP_TO_CITY

FILLER_003

SHIP_TO_STATE

FILLER_004

SHIP_TO_ZIPCODE

SHIP_TO_COUNTRY

SHIP_TO_EXE_REA_CODE

SHIP_TO_OUT_CITY_LM

SHIP_TO_VIA_CODE

SHIP_TO_SALESMAN_NO

FILLER_0001

SHIP_TO_EXE_EXP_DATE

SHIP_TO_UPS_ZONE

SHIP_TO_TAX_CODE1

SHIP_TO_TAX_CODE2

SHIP_TO_TAX_CODE3

SHIP_TO_FRE_FRM_FLG

SHIP_TO_GEO_CODE

SHIP_TO_TAXABLE_FLAG

FILLER_002

SHIP_TO_XREF_NO

CPSHPFIL_FILLER_003

TAX_CODE1_DESC

TAX_CODE2_DESC

TAX_CODE3_DESC

TAX_CODE1_PCT

TAX_CODE2_PCT

TAX_CODE3_PCT

 

Code Example (VB)

The following sample codes will return ship-to records for customer# “000001”.

 

Dim Service As New webServicesCustm.ElicustmService

Dim Result As New webServicesCustm.GetShipToResult

Dim SHIP_TO_CUST_NO As String = “000001”

Result = Service.GetShipTo(“”, “”,SHIP_TO_CUST_NO)

If Result.ReturnCode = 0 Then

   lblResult.Text = “First Ship-To No.: ” & _

      Result.CustomerShipTo.Tables(0).Rows(0).Item("SHIP_TO_NO") & _

                “  Ship-To Name: ” & _

  Result.CustomerShipTo.Tables(0).Rows(0).Item("SHIP_TO_NAME")

ElseIf Result.ReturnCode = 30001 Then

  lblResult.Text = "No record found"

Else

  lblResult.Text = “Error While Quering Customer.”

  lblErrorCode.Text = Result.ReturnMsg

End If

 

ElicustmService Return Code

 0 = OK

 1 = File Error

 2 = Data Missing (Customer No Missing) (Inquiry/Change/Delete)

 3 = NSI Control File Not Found (Add)

 4 = Customer Not On File (Inquiry/Change/Delete)

 5 = No Default Customer '&&&&&&' (Add)

 6 = Data Missing (Customer Name Missing) (Add)

 7 = Salesman Not On File (Add)

 8 = Customer Type Not On File (Add)

 9 = Balance Method Must Be "B" or "O" (Add)

10 = Statement Frequency Must Be "N", "D", "W", "M", "S", "Q" (Add)

11 = Ship Via Code Not On File (Add)

12 = Terms Code Not On File (Add)

13 = Credit Hold Flag Must Be "Y" or "N" (Add)

14 = Fin Chg Flag Must Be "Y" or "N" (Add)

15 = A/R Account No Not On File (Add)

16 = Taxable Flag Must Be "Y" or "N" (Add)

17 = Allow Substitute Item Flag Must Be "Y" or "N" (Add)

18 = Backorderable Flag Must Be "Y" or "N" (Add)

19 = Partial Shipment Flag Must Be "Y" or "N" (Add)

20 = Print Dunning Letter Flag Must Be "Y" or "N" (Add)

21 = Tax Code Not On File (Add)

22 = Duplication For Tax Code 1 & 2 & 3 (Add)

23 = Customer No Exist, Cannot Be Added (Add)

24 = Exempt Reason Code Must Be "Y" or "N" (Add)

25 = Outside City Limit Must Be "Y" or "N" (Add)

26 = Use Bill To Addr Must Be "Y" or "N" (Add)

27 = Bill To Customer Not On File (Add)

28 = No Customer For This Inquiry

29 = Invalid Key Name

30 = Customer Record Locked

30000 = Database Error (GetShipTo) - This is likely a DDF mismatch issue

30001 = No record found (GetShipTo)

CLS

Feedback and Knowledge Base