Method Name : addSKUMaster

  • Purpose of usage :

It is used to add SKU Master Data and SKU Barcode, Unit, Pallette, SKU Properties to Axata WMS system at the same time.

Tables other than ENT004 may be sent empty. There are different methods to add other Properties..

  • Integration Tables :


Axata Table Name

Process type

Table Type

Description

ENT004

Host_to_WMS

Master Data

SKU Master Data

ENT003

Host_to_WMS

Barcode

SKU Barcode Master Data

ENT004_UNIT

Host_to_WMS

Unit

SKU Unit Master Data

ENT004_PL

Host_to_WMS

Pallet

SKU Pallet Property Data

ENT004_PROP

Host_to_WMS

Property

SKU Property Data

  • Integration Table Fields :


Transaction type :

Host_to_WMS




Table Name :

ENT004




Table Description :

SKU master




Field Name

Desc

Type

Len

Mandatory

S04ID

Identity

[bigint]

 

 

S04SKOD

Company Code

[nvarchar]

2

*

S04MKOD

SKU Code

[nvarchar]

50

*

S04KTAN

Short Description

[nvarchar]

20

*

S04UTAN

Long Description

[nvarchar]

100

*

S04SNFK

Classification Code

[nvarchar]

100


S04MGRP

Group Code

[nvarchar]

100


S04MKBR

Small Unit

[nvarchar]

3

*

S04MBBR

Large Unit

[nvarchar]

3

*

S04BKOR

Small/Big Ratio

[decimal]

15, 3

*

S04PSTAN

--

[decimal]

15, 3


S04AGRL

Gross Weight (gr)

[decimal]

15, 3


S04NETA

Net Weight (gr)

[decimal]

15, 3


S04EN

Width (mm)

[decimal]

15, 3


S04BOY

Length (mm)

[decimal]

15, 3


S04YUK

Height (mm)

[decimal]

15, 3


S04PUAN

Decimeter

[float]



S04HTIP

Free

[nvarchar]

20


S04HNUM

Free

[decimal]

20, 0


S04ROMUR

Shelf life (days)

[decimal]

5, 0


S04SKTAR

Inconvenient shipping time (days)

[decimal]

5, 0


S04RAFUY

Shelf life warning 1 (day)

[smallint]



S04RAFUY2

Shelf life warning 2 (days)

[smallint]



S04KKONT

Quality Control (0 - No, 1 - Yes)

[nvarchar]

1


S04LOT

Lot 1 Usage(0-No , 1- free, 2- Mandatory)

[nvarchar]

1


S04LOT2

Lot 2 Usage(0-No , 1- free, 2- Mandatory)

[tinyint]



S04LOT3

Lot 3 Usage(0-No , 1- free, 2- Mandatory)

[tinyint]



S04PALTIP

Standard pallet type

[nvarchar]

2


S04KULBRM

Unit used 0-small unit 1-large unit

[tinyint]

 


S04GTKON

Goods Receive date control 0-Production 1-SK.Date

[tinyint]



S04Serial

Serialal number 1 usage 0-No 1-Input/Output 2-Output

[tinyint]



S04Serial2

Serialal number 2 usage 0-No 1-Input/Output 2-Output




S04Serial3

Serialal number 3 usage 0-No 1-Input/Output 2-Output




S04DSIM

Variable SIM 0-No 1-Weight 2-Variable SIM

[tinyint]



S04FIFO

Rotation pattern 0-No FIFO 1-FIFO 2-FEFO

[tinyint]



S04FOFF

FIFO Offset time (days)

[decimal]

3, 0


S04FOFFE

FIFO Minus Offset (days)

[decimal]

3, 0


S04DBSUR

Waiting time in warehouse (days)

[decimal]

5, 0


S04KARAN

Quarantine time (hours)

[decimal]

3, 0


S04IKOD

Operation Code 0-Active 1-Input Hanger 2-Exit Hanger 3-General Hanger

[tinyint]



S04SERTIP

Seriales 1 singularity check 0-no 1-yes

[tinyint]



S04Serial2UN

Seriales 2 singularity check 0-no 1-yes

[tinyint]



S04Serial3UN

Seriales 3 singularity check 0-no 1-yes

[tinyint]



S04OND

Allow decimal input 0-no 1-yes

[tinyint]



S04ENT1

Free

[nvarchar]

50


S04ENT2

Free

[nvarchar]

50


S04ENT3

Free

[nvarchar]

50


S04GTIN

SKU GTIN Number

[nvarchar]

50


S04SRHVZ

Serialal pool usage 0-no 1-yes

[tinyint]



S041B1SCAN

Allow single read on input S041B1SCAN

[tinyint]



S04C1B1SCAN

Allow single readout on output S041B1SCAN

[tinyint]



S04CUBISCAN

CUBIC Scan control

[bit]



S04OVERSIZE

Great product control

[bit]



S04SIOC

Ship with its own packaging control

[bit]



S04HISEC

Valuable product check

[bit]



S04HAZMAT

Hazardous product control

[bit]



S04FRAGILE

Fragile product control

[bit]



S042DBARUSE

2D Barcode Usage

[bit]



S04IZLN


[int]



S04ITAR

Transaction date (YYYYMMDD)

[decimal]

8, 0


S04IZMN

Transaction time (HHMMSS)

[decimal]

6, 0




Transaction type :

Host_to_WMS




Table Name :

ENT004_UNIT




Table Description :

SKU Unit Data




Field Name

Desc

Type

Len

Mandatory

S04ID

Identity

[bigint]



S04SKOD

Company Code

[nvarchar]

4

*

S04MKOD

SKU Code

[nvarchar]

50

*

S04BKOD

Unit Code

[nvarchar]

3

*

S04AKOD

Warehouse Code

[nvarchar]

2


S04CARP

Content amount

[float]


*

S04TYPE

Type (0-Master Unit 1-Other)

[tinyint]

 


S04GKUL

-

[tinyint]

 

*

S04IKUL

-

[tinyint]



S04CKUL

-

[tinyint]



S04DKUL

-

[tinyint]



S04INT

-

[tinyint]



S04OPTIP

-

[tinyint]



S04EN

Width (cm)

[decimal]

15,3


S04BOY

Length (cm)

[decimal]

15,3


S04YUK

Height (cm)

[decimal]

15,3


S04NAGR

Net Weight (gr)

[decimal]

15,3


S04BAGR

Gross Weight (gr)

[decimal]

15,3


S04DESI

Decimeter

[float]



S04DEFB

Is it a standard parcel (0-No 1-Yes)

[tinyint]



S04RECTYPE

Record Type (1-delete 0-insert/update)

[tinyint]



S04ITAR

Transaction date (YYYYMMDD)

[decimal]

8, 0


S04IZMN

Transaction time (HHMMSS)

[decimal]

6, 0


S04ERP_ID

Erp ID

[bigint]



S04WMSSTAT


[tinyint]





Transaction type :

Host_to_WMS


 


Table Name :

ENT003




Table Description :

SKU barcode Information




Field Name

Desc

Type

Len

Mandatory

S03ID

Identity

[bigint]

 

 

S03SKOD

Company Code

[nvarchar]

2

*

S03MKOD

SKU Code

[nvarchar]

50

*

S03BCODE

Barcode

[nvarchar]

100

*

S03ISDEF

is Default ? 0-No 1-Yes

[bit]



S03ITIP

Record Type 0-New 1-Delete 2-Delete all barcodes of the product

[decimal]

1,0


S03ITAR

Transaction date (YYYYMMDD)

[decimal]

8, 0


S03IZMN

Transaction time (HHMMSS)

[decimal]

6, 0


S03HTIP

Free

[nvarchar]

20


S03HNUM

Free

[decimal]

20, 0


S03UNIT

Unit

[nvarchar]

3


S03ERP_ID

Erp ID

[bigint]



S03WMSSTAT


[tinyint]





Transaction type :

Host_to_WMS


 


Table Name :

ENT004PL




Table Description :

SKU pallet standards




Field Name

Desc

Type

Len

Mandatory

S04ID

Identity

[bigint]

 

 

S04SKOD

Company Code

[nvarchar]

4

*

S04Warehouse

Warehouse Code

[nvarchar]

4


S04MKOD

SKU Code

[nvarchar]

50

*

S04PALTIP

Pallet Type

[nvarchar]

2

*

S04PSTD

Pallet Standard

[decimal]

15,3

*

S04ITIP

Status (0-Enable 1-Disable)

[int]



ERP_ID


[bigint]



S04LEVEL


[int]



S04BIRIM


[nvarchar]

3


S04WMSSTAT


[tinyint]



S04ITAR

Transaction date (YYYYMMDD)

[decimal]

8, 0


S04IZMN

Transaction time (HHMMSS)

[decimal]

6, 0




Transaction type :

Host_to_WMS




Table Name :

ENT004_PROP




Table Description :

SKU master additional Properties




Field Name

Desc

Type

Len

Mandatory

S04ID

Identity

[bigint]

 

 

S04SKOD

Company Code

[nvarchar]

4

*

S04MKOD

SKU Code

[nvarchar]

50

*

S04PROP

Property Code

[smallint]

 

*

S04VAL1

Property value 1

[nvarchar]

200

*

S04VAL2

Property value 2

[datetime]

 

*

S04VAL3

Property value 3

[float]

 

*

S04ITAR

Transaction date (YYYYMMDD)

[decimal]

8, 0


S04IZMN

Transaction time (HHMMSS)

[decimal]

6, 0


S04ERP_ID

Erp ID

[bigint]



S04TMZM


[datetime]



  • Usage :
    • Multiple SKU information can be sent simultaneously.
    • Each SKU can contain more than one sub Property (Barcode, Unit, Pallette, Prop) table within itself.
    • 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 SKU.


  • Sample XML
    • Request :

<soapenv:Envelope xmlns:soapenv="http://schemas.xmlsoap.org/soap/envelope/" xmlns:tem="http://tempuri.org/" xmlns:axat="http://axatawms" xmlns:wms="http://schemas.datacontract.org/2004/07/WMSServiceCore.Models.SKUMaster">

  <soapenv:Header/>

  <soapenv:Body>

    <tem:username>axataservice</tem:username>

    <tem:password></tem:password>

    <axat:SKUMasterList>

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

      <wms:SKUMaster>

        <wms:ENT004>

          <S04SKOD>01</S04SKOD>

          <S04MKOD>DENEMESKU</S04MKOD>

          <S04KTAN>DENEME SKU TANIM</S04KTAN>

          <S04UTAN>DENEME SKU UZUN TANIM</S04UTAN>

          <S04SNFK>TEXTIL</S04SNFK>

          <S04MGRP>AYAKKABI</S04MGRP>

          <S04MKBR>ADT</S04MKBR>

          <S04MBBR>KOL</S04MBBR>

          <S04BKOR>10</S04BKOR>

          <S04PSTAN>0</S04PSTAN>

          <S04AGRL>100</S04AGRL>

          <S04NETA>80</S04NETA>

          <S04EN>10</S04EN>

          <S04BOY>20</S04BOY>

          <S04YUK>15</S04YUK>

          <S04PUAN>12233</S04PUAN>

        </wms:ENT004>

        <wms:ENT003_List>

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

          <ENT003>

            <S03SKOD>01</S03SKOD>

            <S03MKOD>DENEMESKU</S03MKOD>

            <S03BCODE>B0101010101</S03BCODE>

            <S03ISDEF>0</S03ISDEF>

            <S03ITIP>1</S03ITIP>

            <S03ITAR>20200523</S03ITAR>

            <S03IZMN>121212</S03IZMN>

          </ENT003>

        </wms:ENT003_List>

        <wms:ENT004_UNIT_List>

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

          <ENT004_UNIT>

            <S04SKOD>01</S04SKOD>

            <S04MKOD>DENEMESKU</S04MKOD>

            <S04BKOD>ADT</S04BKOD>

            <S04AKOD>01</S04AKOD>

            <S04CARP>15</S04CARP>

            <S04TYPE>1</S04TYPE>

            <S04GKUL>0</S04GKUL>

            <S04IKUL>0</S04IKUL>

            <S04CKUL>0</S04CKUL>

            <S04DKUL>0</S04DKUL>

          </ENT004_UNIT>

        </wms:ENT004_UNIT_List>

        <wms:ENT004PL_List>

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

          <ENT004PL>

            <S04SKOD>01</S04SKOD>

            <S04Warehouse>01</S04Warehouse>

            <S04MKOD>DENEMESKU</S04MKOD>

            <S04PALTIP>10</S04PALTIP>

            <S04PSTD>84</S04PSTD>

            <S04ITIP>1</S04ITIP>

            <S04ITAR>20200523</S04ITAR>

            <S04IZMN>121212</S04IZMN>

          </ENT004PL>

        </wms:ENT004PL_List>

        <wms:ENT004_PROP_List>

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

          <ENT004_PROP>

            <S04SKOD>01</S04SKOD>

            <S04MKOD>DENEMESKU</S04MKOD>

            <S04PROP>101</S04PROP>

            <S04VAL1>1111</S04VAL1>

            <S04ITAR>20200523</S04ITAR>

            <S04IZMN>121212</S04IZMN>

          </ENT004_PROP>

        </wms:ENT004_PROP_List>

      </wms:SKUMaster>

    </axat:SKUMasterList>

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

        <EntityCompany>01</EntityCompany>

        <EntityCode>DENEMESKU</EntityCode>

        <EntitySubCode i:nil="true"/>

        <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#