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