EliatpobService

EliatpobService.asmx

This web service has a method for ATP (available to promise) inquiry.

 

ATPInquiry

This method returns ATP information for an item.

Usage:

ATPInquiryResult = A.ATPInquiry(UserName, UserPassword, ITEM_NO, LOC_CODE, Source)

Parameters UserName and UserPassword are not used at this moment.

 

Input Parameter

Parameter

Length

Type

Upper

Detail

ITEM_NO

15

String

Y

Required.

LOC_CODE

2

String

Y

If this field is blank, this method will summarize quantities from all locations.

Source

1

String

Y

Must be “S,” “P,” “B,” “F,” or blank. If this field is blank, this method will include all sources.

 

ATPInquiryResult Structure

Property

Type

Detail

ReturnCode

Integer

Contains return code. Zero means OK; for other return codes, please see “ElievprcService 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.

ITEM_PRICE

Double

 

ITEM_QTY_ON_HAND

Double

 

ITEM_QTY_ALLOC

Double

 

ITEM_QTY_ON_ORDER

Double

 

ATPRecord

DataSet

This data set has a data table "ATPRecords" which contains up to 1000 records with the following columns:

IM_ATP_TRX_DATE (data type: Date)

CustVendNo (data type: String)

RefName (data type: String)

IM_ATP_REC_TYPE (data type: String)

OrderNo (data type: String)

IM_ATP_LOCATION (data type: String)

IM_ATP_QTY_OPEN (data type: Double)

 

Code Example

The following sample code will return ATP information for item number “049” in location “P.”

 

Dim Service As New webServicesatpob.EliatpobService

Dim Result As New webServicesatpob.ATPInquiryResult

Dim ITEM_NO As String = “049”

Dim LOC_CODE As String = “P”

Result = Service.ATPInquiry(“”, “”, ITEM_NO, LOC_CODE, “”)

If Result.ReturnCode = 0 Then

   lblResult.Text = “ATP location: ” + _

   Result.ATPRecord.Tables(0).Rows(0).Item("IM_ATP_LOCATION")

Else

  lblResult.Text = “Error”

   lblErrorCode.Text = Result.ReturnCode.ToString

End If

 

EliatpobService Return Code

0 = OK                               

1 = File Error                       

2 = Item No Missing                   

3 = Table Size Must be <= 1000       

4 = Item Not On File                 

5 = Location Not On File             

6 = Source Invalid (Space, S, B, P, F)

CLS

Feedback and Knowledge Base