Method Name : addSKUProductTree

  • Purpose of usage :

Used to Add BOM Data to Axata WMS System.  

  • Integration Tables :

Axata Table Name

Process type

Table Type

Description

ENT022

Host_to_WMS

SKU Bom

SKU BOM Table

  • Integration Table Fields :

       

Transaction type :

Host_to_WMS




Table Name :

ENT022




Table Description :

SKU BOM




Field Name

Desc

Type

Len

Mandatory

S2SID

Identity

[bigint]



S22SKOD

Company Code

[nvarchar]

2

*

S22SKU1

Main SKU Code

[nvarchar]

50

*

S22SKU2

Sub SKU Code

[nvarchar]

50

*

S22BKOD

--

[decimal]

2


S22MIK

Content Quantity

[decimal]

15, 3

*

S22BTAR

----

[decimal]

8


S22TIP

Record Type(1-Delete 0-Insert/Update)

[decimal]

1, 0

*

S22ITAR

Transaction date (YYYYMMDD)

[decimal]

8, 0


S22IZMN

Transaction time (HHMMSS)

[decimal]

6, 0


S22HTIP


[nvarchar]

20


S22HNUM


[decimal]

20,0


S22ERP_ID

Erp ID


[bigint]



  • Usage :
    • Multiple SKU BOM data 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 posts is limited (Parametric).
    • A separate processResult object is returned for each pallet blocking data.
  • 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></tem:username>

    <tem:password></tem:password>

    <axat:ENT022_List>

      <!--Zero or more repetitions:-->

      <ENT022>

        <S22SKOD>01</S22SKOD>

        <S22SKU1>SKU01</S22SKU1>

        <S22SKU2>SKU02</S22SKU2>

        <S22BKOD>1</S22BKOD>

        <S22MIK>3</S22MIK>

        <S22BTAR>20210517</S22BTAR>

        <S22TIP>0</S22TIP>

        <S22HTIP>111</S22HTIP>

        <S22HNUM>123456789</S22HNUM>

      </ENT022>

    </axat:ENT022_List>

  </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>10057</EntityID>

        <EntityCompany>01</EntityCompany>

        <EntityCode>SKU01</EntityCode>

        <EntitySubCode>SKU02</EntitySubCode>

        <HeaderExt1 i:nil="true"/>

        <HeaderExt2 i:nil="true"/>

        <HeaderExt3 i:nil="true"/>

        <ResultItems/>

      </ProcessResult>

    </processResult>

  </s:Body>

</s:Envelope>


  • Sample c# Source Code :

       Sample Add Method Code C#