Method Name : addOutboundOrder

  • Purpose of usage :

Used to add Outbound Orders to Axata WMS System.

  • Integration Tables :

Axata Table Name

Process type

Table Type

Description

ENT000

Host_to_WMS

Outbound Order

Outbound Order Master Table

ENT001

Host_to_WMS

Outbound Order List

Outbound Order Detail Table

ENT000_PROP

Host_to_WMS

Outbound Order List

Outbound Order Date Reference Table

ENT001_PROP

Host_to_WMS

Outbound Order List

Outbound Order Master PROP Table

  • Integration Table Fields :


Transaction type :

Host_to_WMS




Table Name :

ENT000




Table Description :

Outbound Order master integration table




Field Name

Desc

Type

Len

Mandatory

S00ID

Identity

[bigint]

 

 

S00SKOD

Company Code

[nvarchar]

2

*

S00TESN

Order Number (Unique)

[nvarchar]

50

*

S00SIPN

Reference Order Number

[nvarchar]

50


S00KTUR

Record type ('DEL' appears in the Cancellation record)

[nvarchar]

5


S00SORG

Not Used--

[nvarchar]

50


S00DKAN

Warehouse Code

[nvarchar]

2

*

S00TEST

Delivery Date (YYYYMMDD)

[nvarchar]

8


S00TESS

Delivery Time (HHMMSS)

[nvarchar]

6


S00SMUS

Sold To Firm Code

[nvarchar]

50

*

S00TMUS

Ship To Firm Code

[nvarchar]

50

*

S00TSEK

Delivery Type

[nvarchar]

5


S00NKOD

Transporter Code

[nvarchar]

50


S00FDRM

Order Type

'  ' - Warehouse output

'1' - Dispatch

'2' - Transfer to other Warehouse

[nvarchar]

1


S00FBLK

Destination Warehouse Code (about Transfer Orders)

[nvarchar]

2


S00SUSR

User who opened the order

[nvarchar]

12


S00MSIP

Customer Order Number

[nvarchar]

50


S00SNOT

Note

[nvarchar]

500


S00INT1

Delivery address 1

[nvarchar]

500


S00INT2

Delivery address 2

[nvarchar]

500


S00ACIN

Vehicle Type

[nvarchar]

20

 

S00ITAR

Transaction date (YYYYMMDD)

[decimal]

8,0


S00IZMN

Transaction time (HHMMSS)

[decimal]

6,0


S00IDOC


[nvarchar]

16


S00YUKN

Shipment no

[decimal]

10


S00HTP1

Movement Code (Host)

[nvarchar]

3


S00HTP2

Movement Code (WMS)

[nvarchar]

3

*

S00PLAKA

Vehicle plate to be loaded

[nvarchar]

50

 

S00Owner

Order Owner Firm Code

[nvarchar]

50


S00PRIO

Priority

[int]



S00PRIO

Cargo Firm

[nvarchar]

50


S00ISECOMM

is e-commerce order 0-no 1-yes

[bit]



S00EC_FIRADI

e-commerce firm name

[nvarchar]

200


S00EC_UKOD

e-commerce Country Code

[nvarchar]

3


S00EC_ILKOD

e-commerce Province Code

[nvarchar]

3


S00EC_ILCE

e-commerce County

[nvarchar]

100


S00EC_District

e-commerce District

[nvarchar]

100


S00EC_PKOD

e-commerce postal Code

[nvarchar]

10


S00EC_TEL1

e-commerce tel 1

[nvarchar]

50


S00EC_TEL2

e-commerce tel 2

[nvarchar]

50


S00EC_EMAIL

e-commerce email Address

[nvarchar]

1000


S00EC_PLATFORM

e-commerce source platform name

[nvarchar]

50


S00EC_ISKAPODEME

e-commerce pay at the door ?

[tinyint]



S00EC_TUTAR

e-commerce pay at the door amount

[money]



S00EC_HIZMETSEKLI

e-commerce form of service (cargo)

[nvarchar]

50


S00EC_TESLIMSEKLI

e-commerce mode of delivery (cargo)

[nvarchar]

50


S00EC_ODEMESEKLI

e-commerce form of payment (shipping)

[nvarchar]

50



Transaction type :

Host_to_WMS




Table Name :

ENT001




Table Description :

Outbound Order Item table




Field Name

Desc

Type

Len

Mandatory

S01ID

Identity

[bigint]

 

 

S01SKOD

Company Code

[nvarchar]

2

*

S01TESL

Order Number (Unique)

[nvarchar]

50

*

S01KALN

Item Number

[nvarchar]

50

*

S01UKAL


[nvarchar]

50


S01FRDP


[nvarchar]

3


S01SKU

SKU Code

[nvarchar]

50

*

S01LOTN

Lot/Batch Number -1-

[nvarchar]

50


S01LOTN2

Lot/Batch Number -2-

[nvarchar]

50


S01LOTN3

Lot/Batch Number -3-

[nvarchar]

50


S01MIKT

Quantity

[decimal]

15,3

*

S01SIM

SIM (Standard Inner Quantity)

[decimal]

15,3

 

S01TMIK

Total Quantity

[decimal]

15,3

 

S01PICKSIM


[decimal]

15,3


S01OSMIK

Original Order Quantity

[decimal]

15,3


S01MURU

Customer SKU Code

[nvarchar]

35


S01MSTR

Customer FIFO date (YYYYMMDD) 1

[decimal]

8,0


S01MYTR

Customer FIFO date (YYYYMMDD) 2

[decimal]

8,0


S01HKOD


[nvarchar]

3


S01ITIP

Record type ('DEL' appears in the Cancellation record)

[nvarchar]

5


S01SARG


[nvarchar]

1


S01BNED

Bloke Code

[nvarchar]

2


S01NOT

Not

[nvarchar]

max


S01PRICE

Unit Price

[decimal]

15,2


S01ITAR

Transaction date (YYYYMMDD)

[decimal]

8,0


S01IZMN

Transaction time (HHMMSS)

[decimal]

6,0


S01IDOC


[nvarchar]

16



Transaction type :

Host_to_WMS




Table Name :

ENT000_PROP




Table Description :

Outbound Order master Properties




Field Name

Desc

Type

Len

Mandatory

S00ID

Identity

[bigint]

 

 

S00SKOD

Company Code

[nvarchar]

2

*

S00TESN

Order Number

[nvarchar]

50

*

S00PROP

Property Code

[decimal]

5,0

*

S00VAL1

Property value 1

[nvarchar]

100


S00VAL2

Property value 2

[float]



S00VAL3

Property value 3

[decimal]

8, 0


S00IKOD

0-New /Update 1-Cancel

[tinyint]



S00ITAR

Transaction date (YYYYMMDD)

[decimal]

8, 0


S00IZMN

Transaction time (HHMMSS)

[decimal]

6, 0



Transaction type :

Host_to_WMS




Table Name :

ENT001_PROP




Table Description :

Outbound Order detail Properties




Field Name

Desc

Type

Len

Mandatory

S01ID

Identity

[bigint]

 

 

S01SKOD

Company Code

[nvarchar]

2

*

S01TESL

Order Number

[nvarchar]

50

*

S01KALN

Item Number

[nvarchar]

50

*

S01PROP

Property Code

[smallint]


*

S01VAL1

Property value 1

[nvarchar]

500


S01VAL2

Property value 2

[float]



S01VAL3

Property value 3

[datetime]



S01IKOD

0-New /Update 1-Cancel

[tinyint]



S01ITAR

Transaction date (YYYYMMDD)

[decimal]

8, 0


S01IZMN

Transaction time (HHMMSS)

[decimal]

6, 0



  • Usage :
    • Multiple Outbound Order 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 Outbound Order data.
    • Sending Property Tables is optional. It may not be used when not required.
  • 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.Outbound">

  <soapenv:Header/>

  <soapenv:Body>

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

    <tem:password></tem:password>

    <axat:OutboundOrderList>

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

      <wms:OutboundOrderV1>

        <wms:ENT000>

          <S00SKOD>01</S00SKOD>

          <S00TESN>OUTTEST1</S00TESN>

          <S00SIPN>REFTEST1</S00SIPN>

          <S00KTUR></S00KTUR>

          <S00SORG></S00SORG>

          <S00DKAN>01</S00DKAN>

          <S00TEST>20200524</S00TEST>

          <S00TESS>121212</S00TESS>

          <S00SMUS>FSIPVEREN1</S00SMUS>

          <S00TMUS>FTESLIMNALAN</S00TMUS>

          <S00TADR>01</S00TADR>

          <S00TSEK>TSLIM</S00TSEK>

          <S00NKOD>NAKLIYECI</S00NKOD>

          <S00FDRM></S00FDRM>

          <S00FBLK></S00FBLK>

          <S00SUSR>USER</S00SUSR>

          <S00MSIP>MSIP1001</S00MSIP>

          <S00SNOT>SIPARIS NOT</S00SNOT>

          <S00INT1></S00INT1>

          <S00INT2></S00INT2>

          <S00ACIN>ARAC CINS</S00ACIN>

          <S00ITAR>20200523</S00ITAR>

          <S00IZMN>121212</S00IZMN>

          <S00IDOC></S00IDOC>

          <S00YUKN>1111</S00YUKN>

          <S00HTP1>H12</S00HTP1>

          <S00HTP2>H12</S00HTP2>

          <S00PLAKA>PLAKA</S00PLAKA>

          <S00SIST>SAP</S00SIST>

          <S00Owner>OWNERSHIP</S00Owner>

          <S00PRIO>0</S00PRIO>

          <ERP_ID>11111</ERP_ID>

          <S00CARGO>KARGO FIRM</S00CARGO>

          <S00ISECOMM>1</S00ISECOMM>

          <S00EC_FIRADI>ETIC FIRMA</S00EC_FIRADI>

          <S00EC_UKOD>TR</S00EC_UKOD>

          <S00EC_ILKOD>34</S00EC_ILKOD>

          <S00EC_ILCE>ILCE</S00EC_ILCE>

          <S00EC_District>District</S00EC_District>

          <S00EC_PKOD>41400</S00EC_PKOD>

          <S00EC_TEL1>5555555555</S00EC_TEL1>

          <S00EC_TEL2></S00EC_TEL2>

          <S00EC_EMAIL>XYZ@WER</S00EC_EMAIL>

          <S00EC_PLATFORM>PAZARYERI</S00EC_PLATFORM>

          <S00EC_ISKAPODEME>0</S00EC_ISKAPODEME>

          <S00EC_TUTAR>123.23</S00EC_TUTAR>

          <S00EC_HIZMETSEKLI>HIZMET SEKLI</S00EC_HIZMETSEKLI>

          <S00EC_TESLIMSEKLI>TESLIM SEKLI</S00EC_TESLIMSEKLI>

          <S00EC_ODEMESEKLI>ODEME SEKLI</S00EC_ODEMESEKLI>

        </wms:ENT000>

        <wms:ENT001_List>

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

          <ENT001>

            <S01SKOD>01</S01SKOD>

            <S01TESL>OUTTEST1</S01TESL>

            <S01KALN>1</S01KALN>

            <S01UKAL>10</S01UKAL>

            <S01SKU>TESTSKU1</S01SKU>

            <S01LOTN></S01LOTN>

            <S01LOTN2></S01LOTN2>

            <S01LOTN3></S01LOTN3>

            <S01MIKT>12</S01MIKT>

            <S01SIM>1</S01SIM>

            <S01TMIK>12</S01TMIK>

            <S01MURU>MSKU101</S01MURU>

          </ENT001>

        </wms:ENT001_List>

        <wms:ENT000_PROP_List>

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

          <ENT000_PROP>

            <S00SKOD>01</S00SKOD>

            <S00TESN>OUTTEST1</S00TESN>

            <S00PROP>111</S00PROP>

            <S00VAL1>11111</S00VAL1>

            <S00ITAR>20200523</S00ITAR>

            <S00IZMN>121212</S00IZMN>

          </ENT000_PROP>

        </wms:ENT000_PROP_List>

        <wms:ENT001_PROP_List>

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

          <ENT001_PROP>

            <S01SKOD>01</S01SKOD>

            <S01TESL>OUTTEST1</S01TESL>

            <S01KALN>1</S01KALN>

            <S01PROP>112</S01PROP>

            <S01VAL1>22222</S01VAL1>

            <S01ITAR>20200523</S01ITAR>

            <S01IZMN>121212</S01IZMN>

          </ENT001_PROP>

        </wms:ENT001_PROP_List>

      </wms:OutboundOrderV1>

    </axat:OutboundOrderList>

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

        <EntityCompany>01</EntityCompany>

        <EntityCode>OUTTEST1</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#