getViewData
Method Name : getViewdata
- Purpose of usage :
It is used to extract data from DB View in Axata WMS System..
- Return Integration Tables :
GENERIC VIEW DATA - (View data table consisting of Row-Column )
- Query Request Fields :
Field Name |
Description |
Mandatory |
ViewName |
DB View Name |
None |
ViewQuery |
DB View Query Field List |
None |
ViewQuery - Field |
Field to Query |
|
ViewQuery - Field - Name |
Field to Query Name |
|
ViewQuery - Field - Value |
Field to Query Value |
- Usage :
- Query is made with the view name in the DB
- There is a limit of 10,000 rows for the query result. An error is returned if the limit is exceeded..
- Using ViewQuery Table is not Mandatory .
- Maximum 20 fields can be added to the ViewQuery List
- Added fields are connected with the AND operator.
- Return Table :
Field Name |
Description |
|
ViewName |
DB View Name |
|
ViewRowCount |
Number of Rows returned from View |
|
ViewData-Row |
View Row |
|
ViewData-Column |
View Column |
|
Column-Name |
View Column Name |
|
Value |
View Column Value |
This element contains the .Net field type as Attribute |
- Sample XML
- Request :
<soapenv:Envelope xmlns:soapenv="http://schemas.xmlsoap.org/soap/envelope/" xmlns:tem="http://tempuri.org/">
<soapenv:Header/>
<soapenv:Body>
<tem:username>axataservice</tem:username>
<tem:password></tem:password>
<ViewName>vw_WMS_Stock</ViewName>
<ViewQuery>
<!--Zero or more repetitions:-->
<Field>
<Name>SKUCode</Name>
<INValues>
<!--Zero or more repetitions:-->
<INValue>000000012000593</INValue>
</INValues>
</Field>
</ViewQuery>
</soapenv:Body>
</soapenv:Envelope>
- Response :
<s:Envelope xmlns:s="http://schemas.xmlsoap.org/soap/envelope/">
<s:Body>
<state>0</state>
<message>Success</message>
<ViewName>vw_WMS_Stock</ViewName>
<ViewRowCount>12</ViewRowCount>
<ViewData xmlns:i="http://www.w3.org/2001/XMLSchema-instance">
<Row>
<Columns>
<Column>
<Name>System_Code</Name>
<Value i:type="a:string" xmlns:a="http://www.w3.org/2001/XMLSchema">BTT</Value>
</Column>
<Column>
<Name>CompanyCode</Name>
<Value i:type="a:string" xmlns:a="http://www.w3.org/2001/XMLSchema">01</Value>
</Column>
<Column>
<Name>WarehouseCode</Name>
<Value i:type="a:string" xmlns:a="http://www.w3.org/2001/XMLSchema">01</Value>
</Column>
<Column>
<Name>SKUCode</Name>
<Value i:type="a:string" xmlns:a="http://www.w3.org/2001/XMLSchema">000000012000593</Value>
</Column>
<Column>
<Name>Lot1</Name>
<Value i:type="a:string" xmlns:a="http://www.w3.org/2001/XMLSchema"/>
</Column>
<Column>
<Name>Lot2</Name>
<Value i:type="a:string" xmlns:a="http://www.w3.org/2001/XMLSchema"/>
</Column>
<Column>
<Name>Lot3</Name>
<Value i:type="a:string" xmlns:a="http://www.w3.org/2001/XMLSchema"/>
</Column>
<Column>
<Name>Ready_Stock</Name>
<Value i:type="a:decimal" xmlns:a="http://www.w3.org/2001/XMLSchema">3.000</Value>
</Column>
<Column>
<Name>Ready_PalCount</Name>
<Value i:type="a:int" xmlns:a="http://www.w3.org/2001/XMLSchema">1</Value>
</Column>
<Column>
<Name>Ready_Weight</Name>
<Value i:type="a:decimal" xmlns:a="http://www.w3.org/2001/XMLSchema">0.000</Value>
</Column>
<Column>
<Name>Blocked_Stock</Name>
<Value i:type="a:decimal" xmlns:a="http://www.w3.org/2001/XMLSchema">0.000</Value>
</Column>
<Column>
<Name>Blocked_PalCount</Name>
<Value i:type="a:int" xmlns:a="http://www.w3.org/2001/XMLSchema">0</Value>
</Column>
<Column>
<Name>Blocked_Weight</Name>
<Value i:type="a:decimal" xmlns:a="http://www.w3.org/2001/XMLSchema">0.000</Value>
</Column>
<Column>
<Name>Quarantine_Stock</Name>
<Value i:type="a:decimal" xmlns:a="http://www.w3.org/2001/XMLSchema">0.000</Value>
</Column>
<Column>
<Name>Quarantine_PalCount</Name>
<Value i:type="a:int" xmlns:a="http://www.w3.org/2001/XMLSchema">0</Value>
</Column>
<Column>
<Name>Quarantine_Weight</Name>
<Value i:type="a:decimal" xmlns:a="http://www.w3.org/2001/XMLSchema">0.000</Value>
</Column>
<Column>
<Name>Pickarea_Stock</Name>
<Value i:type="a:decimal" xmlns:a="http://www.w3.org/2001/XMLSchema">0.000</Value>
</Column>
<Column>
<Name>Pickarea_PalCount</Name>
<Value i:type="a:decimal" xmlns:a="http://www.w3.org/2001/XMLSchema">0</Value>
</Column>
<Column>
<Name>Pickarea_Weight</Name>
<Value i:type="a:decimal" xmlns:a="http://www.w3.org/2001/XMLSchema">0.000</Value>
</Column>
<Column>
<Name>ManPickAreaRepl_Stock</Name>
<Value i:type="a:decimal" xmlns:a="http://www.w3.org/2001/XMLSchema">0.000</Value>
</Column>
<Column>
<Name>Ramp_Stock</Name>
<Value i:type="a:decimal" xmlns:a="http://www.w3.org/2001/XMLSchema">0.000</Value>
</Column>
<Column>
<Name>Ramp_Weight</Name>
<Value i:type="a:decimal" xmlns:a="http://www.w3.org/2001/XMLSchema">0.000</Value>
</Column>
<Column>
<Name>Unconfirmed_Stock</Name>
<Value i:type="a:decimal" xmlns:a="http://www.w3.org/2001/XMLSchema">0.000</Value>
</Column>
<Column>
<Name>Unconfirmed_Weight</Name>
<Value i:type="a:decimal" xmlns:a="http://www.w3.org/2001/XMLSchema">0.000</Value>
</Column>
<Column>
<Name>Total_Weight</Name>
<Value i:type="a:decimal" xmlns:a="http://www.w3.org/2001/XMLSchema">0.000</Value>
</Column>
<Column>
<Name>Total_Stock</Name>
<Value i:type="a:decimal" xmlns:a="http://www.w3.org/2001/XMLSchema">3.000</Value>
</Column>
<Column>
<Name>Not_Waybill_Stock</Name>
<Value i:type="a:decimal" xmlns:a="http://www.w3.org/2001/XMLSchema">0.000</Value>
</Column>
<Column>
<Name>Unconfirmed_ATF_Stock</Name>
<Value i:type="a:decimal" xmlns:a="http://www.w3.org/2001/XMLSchema">0.000</Value>
</Column>
<Column>
<Name>PackageCount</Name>
<Value i:type="a:int" xmlns:a="http://www.w3.org/2001/XMLSchema">0</Value>
</Column>
<Column>
<Name>TotalOrderQty</Name>
<Value i:type="a:decimal" xmlns:a="http://www.w3.org/2001/XMLSchema">3.000</Value>
</Column>
</Columns>
</Row>
<Row>
<Columns>
<Column>
<Name>System_Code</Name>
<Value i:type="a:string" xmlns:a="http://www.w3.org/2001/XMLSchema">BTT</Value>
</Column>
<Column>
<Name>CompanyCode</Name>
<Value i:type="a:string" xmlns:a="http://www.w3.org/2001/XMLSchema">01</Value>
</Column>
<Column>
<Name>WarehouseCode</Name>
<Value i:type="a:string" xmlns:a="http://www.w3.org/2001/XMLSchema">01</Value>
</Column>
<Column>
<Name>SKUCode</Name>
<Value i:type="a:string" xmlns:a="http://www.w3.org/2001/XMLSchema">000000012000593</Value>
</Column>
<Column>
<Name>Lot1</Name>
<Value i:type="a:string" xmlns:a="http://www.w3.org/2001/XMLSchema">1</Value>
</Column>
<Column>
<Name>Lot2</Name>
<Value i:type="a:string" xmlns:a="http://www.w3.org/2001/XMLSchema"/>
</Column>
<Column>
<Name>Lot3</Name>
<Value i:type="a:string" xmlns:a="http://www.w3.org/2001/XMLSchema"/>
</Column>
<Column>
<Name>Ready_Stock</Name>
<Value i:type="a:decimal" xmlns:a="http://www.w3.org/2001/XMLSchema">0.000</Value>
</Column>
<Column>
<Name>Ready_PalCount</Name>
<Value i:type="a:int" xmlns:a="http://www.w3.org/2001/XMLSchema">0</Value>
</Column>
<Column>
<Name>Ready_Weight</Name>
<Value i:type="a:decimal" xmlns:a="http://www.w3.org/2001/XMLSchema">0.000</Value>
</Column>
<Column>
<Name>Blocked_Stock</Name>
<Value i:type="a:decimal" xmlns:a="http://www.w3.org/2001/XMLSchema">10.000</Value>
</Column>
<Column>
<Name>Blocked_PalCount</Name>
<Value i:type="a:int" xmlns:a="http://www.w3.org/2001/XMLSchema">1</Value>
</Column>
<Column>
<Name>Blocked_Weight</Name>
<Value i:type="a:decimal" xmlns:a="http://www.w3.org/2001/XMLSchema">0.000</Value>
</Column>
<Column>
<Name>Quarantine_Stock</Name>
<Value i:type="a:decimal" xmlns:a="http://www.w3.org/2001/XMLSchema">0.000</Value>
</Column>
<Column>
<Name>Quarantine_PalCount</Name>
<Value i:type="a:int" xmlns:a="http://www.w3.org/2001/XMLSchema">0</Value>
</Column>
<Column>
<Name>Quarantine_Weight</Name>
<Value i:type="a:decimal" xmlns:a="http://www.w3.org/2001/XMLSchema">0.000</Value>
</Column>
<Column>
<Name>Pickarea_Stock</Name>
<Value i:type="a:decimal" xmlns:a="http://www.w3.org/2001/XMLSchema">0.000</Value>
</Column>
<Column>
<Name>Pickarea_PalCount</Name>
<Value i:type="a:decimal" xmlns:a="http://www.w3.org/2001/XMLSchema">0</Value>
</Column>
<Column>
<Name>Pickarea_Weight</Name>
<Value i:type="a:decimal" xmlns:a="http://www.w3.org/2001/XMLSchema">0.000</Value>
</Column>
<Column>
<Name>ManPickAreaRepl_Stock</Name>
<Value i:type="a:decimal" xmlns:a="http://www.w3.org/2001/XMLSchema">0.000</Value>
</Column>
<Column>
<Name>Ramp_Stock</Name>
<Value i:type="a:decimal" xmlns:a="http://www.w3.org/2001/XMLSchema">0.000</Value>
</Column>
<Column>
<Name>Ramp_Weight</Name>
<Value i:type="a:decimal" xmlns:a="http://www.w3.org/2001/XMLSchema">0.000</Value>
</Column>
<Column>
<Name>Unconfirmed_Stock</Name>
<Value i:type="a:decimal" xmlns:a="http://www.w3.org/2001/XMLSchema">0.000</Value>
</Column>
<Column>
<Name>Unconfirmed_Weight</Name>
<Value i:type="a:decimal" xmlns:a="http://www.w3.org/2001/XMLSchema">0.000</Value>
</Column>
<Column>
<Name>Total_Weight</Name>
<Value i:type="a:decimal" xmlns:a="http://www.w3.org/2001/XMLSchema">0.000</Value>
</Column>
<Column>
<Name>Total_Stock</Name>
<Value i:type="a:decimal" xmlns:a="http://www.w3.org/2001/XMLSchema">10.000</Value>
</Column>
<Column>
<Name>Not_Waybill_Stock</Name>
<Value i:type="a:decimal" xmlns:a="http://www.w3.org/2001/XMLSchema">0.000</Value>
</Column>
<Column>
<Name>Unconfirmed_ATF_Stock</Name>
<Value i:type="a:decimal" xmlns:a="http://www.w3.org/2001/XMLSchema">0.000</Value>
</Column>
<Column>
<Name>PackageCount</Name>
<Value i:type="a:int" xmlns:a="http://www.w3.org/2001/XMLSchema">0</Value>
</Column>
<Column>
<Name>TotalOrderQty</Name>
<Value i:type="a:decimal" xmlns:a="http://www.w3.org/2001/XMLSchema">2.000</Value>
</Column>
</Columns>
</Row>
</ViewData>
</s:Body>
</s:Envelope>