Method Name : addInboundPallet

  • Purpose of usage :

It is used to add Input Pallette Data to Axata WMS System. Can be used for production entries.

  • Integration Tables :

Axata Table Name

Process type

Table Type

Description

ENT019

Host_to_WMS

Pallet

Input Pallet Addition Table
  • Integration Table Fields :


Transaction type :

Host_to_WMS




Table name :

ENT019




Explanation :

Input pallet information from production Integration Table




Field Name

Desc

Type

Len

Mandatory

S19SIRA

Unique ID (Identity)

[bigint]

 

 

S19PALN

Pallet Number

[decimal]

10,0

*

S19PYED

Free

[decimal]

10,0

 

S19ETKNO

Barcode Ticket Info

[nvarchar]

50


S19SKOD

Company Code

[nvarchar]

2

*

S19AKOD

Warehouse Code

[nvarchar]

2

*

S19SKU

SKU Code

[nvarchar]

50

*

S19LOT

Lot/Batch number -1-

[nvarchar]

50


S19LOT1

Lot/Batch number -2-

[nvarchar]

50


S19LOT2

Lot/Batch number -3-

[nvarchar]

50


S19Owner

Owner

[nvarchar]

15


S19HTIP

Movement type (101 - Enter from production)

[nvarchar]

3

*

S19MAKN

Machine Code

[nvarchar]

50


S19TESS

Plant Code

[nvarchar]

50

 

S19UYER

Production Plant

[nvarchar]

50

 

S19PTIP

Pallet type

[nvarchar]

2

*

S19UTAR

Production date(YYYYMMDD)

[decimal]

8, 0

*

S19UZMN

Production time (HHMMSS)

[decimal]

6, 0

*

S19EXPD

SKT (YYYYMMDD)

[decimal]

8, 0


S19PTAR

Palletizing date (YYYYMMDD)

[decimal]

8, 0

*

S19PZMN

Palletizing time (HHMMSS)

[decimal]

6, 0

*

S19MIK

Quantity

[decimal]

15, 3

*

S19SIM

SIM

[decimal]

15, 3


S19AGR

Warehouse (kg)

[decimal]

15, 3

 

S19HAC

Hacim (m3)

[decimal]

15, 6

 

S19PUAN

Decimeter

[decimal]

15, 0

 

S19IPTK

Process type 0-insert/update 1-delete

[decimal]

1, 0


S19BELN

Document Number

[nvarchar]

20


S19BELT

Document date (YYYYMMDD)

[decimal]

8, 0


S19REDN

Reason for rejection

[int]



S19SIST

System Code

[nvarchar]

10


S19ITAR

Transaction date (YYYYMMDD)

[decimal]

8, 0


S19IZMN

Transaction time (HHMMSS)

[decimal]

6, 0



  • Usage :
    • Multiple Pallet 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 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>axataservice</tem:username>

    <tem:password></tem:password>

    <axat:InboundPalletList>

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

      <ENT019>

        <S19PALN>11111122</S19PALN>

        <S19PYED>0</S19PYED>

        <S19SKU>01</S19SKU>

        <S19LOT></S19LOT>

        <S19LOT1></S19LOT1>

        <S19LOT2></S19LOT2>

        <S19Owner>FOwner1</S19Owner>

        <S19HTIP>H22</S19HTIP>

        <S19MAKN>MAKN</S19MAKN>

        <S19TESS>TESIS</S19TESS>

        <S19UYER>URETIM YERI</S19UYER>

        <S19PTIP>P</S19PTIP>

        <S19SKOD>01</S19SKOD>

        <S19AKOD>01</S19AKOD>

        <S19UTAR>20200523</S19UTAR>

        <S19UZMN>121212</S19UZMN>

        <S19PTAR>20200523</S19PTAR>

        <S19PZMN>141414</S19PZMN>

        <S19MIK>22</S19MIK>

        <S19SIM>10</S19SIM>

        <S19AGR>123.123</S19AGR>

        <S19HAC>123123.23</S19HAC>

        <S19PUAN>123123.33</S19PUAN>

        <S19IPTK>0</S19IPTK>

        <S19BELN>DocumentNO</S19BELN>

        <S19BELT>20200523</S19BELT>

        <S19REDN>0</S19REDN>

        <S19SIST></S19SIST>

        <S19ITAR>20200523</S19ITAR>

        <S19IZMN>111111</S19IZMN>

        <S19EXPD>20260405</S19EXPD>

      </ENT019>

    </axat:InboundPalletList>

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

        <EntityCompany>01</EntityCompany>

        <EntityCode>11111122</EntityCode>

        <EntitySubCode>01</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#