Method Name : addInboundPalletFull

  • Purpose of usage :

It is used to add Input Pallet 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

ENT019_Serial

Host_to_WMS

Pallet Serial

Inbound Pallet Seriales Detail Table

ENT019_PROP

Host_to_WMS

Pallet Property

Input Pallet Property Table
  • Integration Table Fields :


Transaction type :

Host_to_WMS




Table name :

ENT019




Explanation :

Inbound from production Pallet data Integration Tables




Field Name

Desc

Type

Len

Mandatory

S19SIRA

Unique ID (Identity)

[bigint]

 

 

S19PALN

Pallet Number

[decimal]

10,0

*

S19PYED

Free

[decimal]

10,0

 

S19ETKNO

Barcode label 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 - Inbound from production)

[nvarchar]

3

*

S19MAKN

Machine Code

[nvarchar]

50


S19TESS

Facility Code

[nvarchar]

50

 

S19UYER

Production place

[nvarchar]

50

 

S19PTIP

Pallet type

[nvarchar]

2

*

S19UTAR

Production date(YYYYMMDD)

[decimal]

8, 0

*

S19UZMN

Production zamanı (HHMMSS)

[decimal]

6, 0

*

S19EXPD

SKT (YYYYMMDD)

[decimal]

8, 0


S19PTAR

Palletize date (YYYYMMDD)

[decimal]

8, 0

*

S19PZMN

Palletlize time (HHMMSS)

[decimal]

6, 0

*

S19MIK

Quantity

[decimal]

15, 3

*

S19SIM

SIM

[decimal]

15, 3


S19AGR

Warehouse (kg)

[decimal]

15, 3

 

S19HAC

Volume (m3)

[decimal]

15, 6

 

S19PUAN

Desi

[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

Rejection Reason

[int]



S19SIST

System Code

[nvarchar]

10


S19ITAR

Transaction date (YYYYMMDD)

[decimal]

8, 0


S19IZMN

Transaction time (HHMMSS)

[decimal]

6, 0




Transaction type :

Host_to_WMS




Table Name :

ENT019_Serial




Table Description :

Production entry Pallet information Serialal number detail




Field Name

Desc

Type

Len

Mandatory

S19SIRA

Unique ID (Identity)

[bigint]

 

 

S19PALN

Pallet Number

[decimal]

10,0

*

S19Serial

Serial Number 1

[nvarchar]

100

*

S19Serial2

Serial Number 2

[nvarchar]

100


S19Serial3

Serial Number 3

[nvarchar]

100


S19SKOD

Company Code

[nvarchar]

2

*

S19SKU

SKU Code

[nvarchar]

50

*

S19LOT

Lot/Batch Number 1

[nvarchar]

50

*

S19LOT2

Lot/Batch Number 2

[nvarchar]

50


S19LOT3

Lot/Batch Number 3

[nvarchar]

50


S19UTAR

Production date (YYYYMMDD)

[decimal]

8, 0

*

S19UZMN

Production zamanı (HHMMSS)

[decimal]

6, 0

*

S19UNO

Production Number

[decimal]

13, 0

*

S19AGR

Weight Info (kg)

[decimal]

15, 3

*

S19SIM

SIM

[decimal]

15, 3


S19IPTK

Cancel Code (0-normal 1-cancel)

[decimal]

1, 0


S19HKOD

Movement type

[nvarchar]

3


S19SIPN

Order Number

[nvarchar]

50


S19ITAR

Transaction date (YYYYMMDD)

[decimal]

8, 0


S19IZMN

Transaction time (HHMMSS)

[decimal]

6, 0




Transaction type :

Host_to_WMS




Table Name :

ENT019_PROP




Table Description :

Productionden giriş Pallet Propertyler




Field Name

Desc

Type

Len

Mandatory

S19ID

Identity

[bigint]

 

 

S19SKOD

Company Code

[nvarchar]

4

*

S19MKOD

SKU Code

[nvarchar]

50

*

S19PROP

Property Code

[smallint]

 

*

S19VAL1

Property value 1

[nvarchar]

200


S19VAL2

Property value 2

[datetime]

 


S19VAL3

Property value 3

[float]

 


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#