This web service has a method for ATP (available to promise) inquiry.
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
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