addOutboundOrder
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 :