updIntegrationTable
Method Name : updIntegrationTable
- Purpose of usage :
Service method used to update Allowed Integration Tables in Axata WMS System
- Table Update request Fields :
Field Name |
Description |
Mandatory |
TableName |
Table Name to be updated |
None |
UpdateField |
Field Name to Update |
None |
UpdateValue |
Value to Update |
None |
IDField |
Unique Key key field name to be used to query the rows to be updated |
None |
IDValues (Array) |
Unique Key key field value list to be used to query the rows to be updated |
None |
- Update Permission data Table and fields :
Update Table Name |
Query Field |
Update Field |
ENT024 |
S24SIRA |
S24STAT |
ENT006 |
S06SIRA |
S06STAT |
ENT016_MST |
S16ID |
S16STAT |
ENT016_IRS |
S16SIRA |
S16STAT |
ENT044 |
S44ID |
S44STAT |
ENT0077 |
S77ID |
S77STAT |
Usage :
- Multiple ID values can be sent simultaneously .
- Not all fields have to be submitted.
- If generating XML for submission, the fields should be submitted in the order in the table above..
- Maximum number of return lines is limited (Parametric).
- Attempts outside of allowed tables or fields return an error
- Sample XML
- Request :
<soapenv:Envelope xmlns:soapenv="http://schemas.xmlsoap.org/soap/envelope/" xmlns:tem="http://tempuri.org/" xmlns:axat="http://axatawms">
<soapenv:Header/>
<soapenv:Body>
<tem:username>axataservice</tem:username>
<tem:password></tem:password>
<axat:Table>
<TableName>ENT016_MST</TableName>
<UpdateField>S16STAT</UpdateField>
<UpdateValue>1</UpdateValue>
<IDField>S16ID</IDField>
<IDValues>
<!--Zero or more repetitions:-->
<IDValue>1</IDValue>
<IDValue>2</IDValue>
<IDValue>3</IDValue>
</IDValues>
</axat:Table>
</soapenv:Body>
</soapenv:Envelope>
- Response :
<s:Envelope xmlns:s="http://schemas.xmlsoap.org/soap/envelope/">
<s:Body>
<state>0</state>
<message>Success</message>
<processResult xmlns:i="http://www.w3.org/2001/XMLSchema-instance">
<ProcessResult>
<LogState>0</LogState>
<LogMessage>Success</LogMessage>
<EntityID>0</EntityID>
<EntityCompany i:nil="true"/>
<EntityCode>1</EntityCode>
<EntitySubCode i:nil="true"/>
<HeaderExt1 i:nil="true"/>
<HeaderExt2 i:nil="true"/>
<HeaderExt3 i:nil="true"/>
<ResultItems/>
</ProcessResult>
<ProcessResult>
<LogState>0</LogState>
<LogMessage>Success</LogMessage>
<EntityID>0</EntityID>
<EntityCompany i:nil="true"/>
<EntityCode>2</EntityCode>
<EntitySubCode i:nil="true"/>
<HeaderExt1 i:nil="true"/>
<HeaderExt2 i:nil="true"/>
<HeaderExt3 i:nil="true"/>
<ResultItems/>
</ProcessResult>
<ProcessResult>
<LogState>0</LogState>
<LogMessage>Success</LogMessage>
<EntityID>0</EntityID>
<EntityCompany i:nil="true"/>
<EntityCode>3</EntityCode>
<EntitySubCode i:nil="true"/>
<HeaderExt1 i:nil="true"/>
<HeaderExt2 i:nil="true"/>
<HeaderExt3 i:nil="true"/>
<ResultItems/>
</ProcessResult>
</processResult>
</s:Body>
</s:Envelope>