Doc.365-post.io

Create Warehouse order

  1. Summary

 

 

 

Warehouse order can be easily created through this function

 

 

 

 

 

 

 

 

 

 

  1. Request Content Explanation

 

 

 

 

 

 

#

Item

Description

1

Request URL

/api/system/itapi_edi2?edi_code=PDO_IMPORT &user_code={USERCODE}

2

Request Method

POST

3

Request Data Format

XML

4

Request Data Encoding

UTF-8

5

Complete URL Example

http://www1.jflog.com:8008/WHS_TEST/api/system/itapi_edi2?edi_code=PDO_IMPORT&user_code={USERCODE}

 

 

 

 

 

 

  1. Request Data Sample and Explanation

 

 

 

 

 

 

#

Node with Example

Explanation

Max Length

Remark

1

<?xml version=”1.0″ encoding=”UTF-8″?>

 

   

2

<Request>

 

   

3

<Auth>

 

   

4

<user_code>{USERCODE}</user_code>

API username

30

Mandatory

 

<password>{PASSWORD}</password>

API Password

30

Mandatory

5

</Auth>

 

 

 

6

<RequestID>##REQUEST_ID##</RequestID>

Request ID.

20

Generated by client. Will return in response message for reference

7

<RequestDate>2001-12-17T09:30:47+08:00</RequestDate>

Request time.

25

 

8

<PreStockOuts>

 

 

 

9

<PreStockOut>

 

   

10

<Header>

 

   

11

<RequestSeq>1</RequestSeq>

1 for 1st order, 2 for the 2nd, etc

 

Mandatory

12

<TransactionType>NEW</TransactionType>

Transaction type

 

Mandatory, NEW / UPDATE / DELETE

13

<Customer>CUSTCODE</Customer>

Customer Code

8

Mandatory,Pre-assign code

*Every customer has their own customer code in WMS system, please consult IT for the customer code

14

<IssueDate>2001-12-17T09:30:47+08:00</IssueDate>

Issue Date

   

15

<PDOPrefix>String</PDOPrefix>

 

30

 

16

<PreStockOutNo>String</PreStockOutNo>

Order No

30

Mandatory,

17

<Warehouse>WHSCODE</Warehouse>

Warehouse code

8

Mandatory

*Please consult IT for the WHS code

18

<EstPickUpDate>2001-12-17T09:30:47+08:00</EstPickUpDate>

Est Stock out date

   

19

<RefStockOutNumber>String</RefStockOutNumber>

Ref Stock out No

30

 

20

<DeliveryClient>String</DeliveryClient>

Delivery Client

8

Should be Customer Code

21

<DeliveryAddr>String</DeliveryAddr>

Delivery Address

255

 

22

<Remark>String</Remark>

Remark

255

 

23

<DeliveryZone>String</DeliveryZone>

HK Delivery Zone

5

Should be Zone Code

24

<CustomerRefNumber>String</CustomerRefNumber>

Customer Ref Number

60

 

25

<VehicleNo>String</VehicleNo>

Vehicle No

100

 

26

<PickUpBy>String</PickUpBy>

Pick Up By

100

 

27

<Contractor>String</Contractor>

Contractor

8

Should be Customer Code

28

<RefOrderID>ID97531</RefOrderID>

Ref Order ID

30

 

29

<RefPlatform>AMAZON-TESTCUST</RefPlatform>

Ref Sales Platform

20

 

30

<TrackNumber>string</TrackNumber>

Track number

60

 

31

<Freight>

 

 

For FMS system only

32

<LoadPort>Strin</LoadPort>

POL

5

UNCODE

33

<DischargePort>Strin</DischargePort>

POD

5

UNCODE

34

<Destination>Strin</Destination>

DEST

5

UNCODE

35

<SONumber>String</SONumber>

S/O Number

30

 

36

<JobNumber>String</JobNumber>

Job Number

60

 

37

<HAWBOrHBLNo>String</HAWBOrHBLNo>

HBL / HAWB Number

60

 

38

<MAWBOrMBLNo>String</MAWBOrMBLNo>

MBL/ MAWB Number

60

 

39

<SroNumber>String</SroNumber>

SRO Number

120

 

40

<QtyInWord>String</QtyInWord>

Print Total

255

 

41

<SeaFreight>

 

 

For FMS system only

42

<VesselName>String</VesselName>

Vessel Name

60

 

43

<Voyage>String</Voyage>

Voyage

40

 

44

<ETD>2001-12-17T09:30:47+08:00</ETD>

ETD

   

45

<ETA>2001-12-17T09:30:47+08:00</ETA>

ETA

   

46

<Carrier>String</Carrier>

Carrier

8

Should be Carrier Code

47

<ContainerNumber>String</ContainerNumber>

Container Number

40

 

48

<ContainerSize>String</ContainerSize>

Container Size

30

 

49

<SealNumber>String</SealNumber>

Seal Number

40

 

50

<CYClosing>2001-12-17T09:30:47+08:00</CYClosing>

CY Closing date

   

51

<CFSClosing>2001-12-17T09:30:47+08:00</CFSClosing>

CFS Closing date

   

52

</SeaFreight>

 

   

53

<AirFreight>

 

 

For FMS system only

54

<FlightNumber>String</FlightNumber>

Flight Number

200

 

55

<FlightDate>2001-12-17T09:30:47+08:00</FlightDate>

Flight Date

   

56

<Terminal>String</Terminal>

Terminal

60

 

57

<ULDNumber>String</ULDNumber>

ULD Number

100

 

58

<RCLNumber>String</RCLNumber>

RCL Number

60

 

59

<RCLDate>2001-12-17T09:30:47+08:00</RCLDate>

RCL Date

   

60

</AirFreight>

 

   

61

</Freight>

 

   

62

<CustomInfo>

 

   

63

<FreeText1>String</FreeText1>

 

70

 

64

<FreeText2>String</FreeText2>

 

70

 

65

<FreeText3>String</FreeText3>

 

70

 

66

<FreeText4>String</FreeText4>

 

70

 

67

<FreeText5>String</FreeText5>

 

70

 

68

<FreeText6>String</FreeText6>

 

70

 

69

<FreeText7>String</FreeText7>

 

70

 

70

<FreeText8>String</FreeText8>

 

70

 

71

<FreeText9>String</FreeText9>

 

70

 

72

<FreeText10>String</FreeText10>

 

70

 

73

<FreeText11>String</FreeText11>

 

70

 

74

<FreeText12>String</FreeText12>

 

70

 

75

<FreeText13>String</FreeText13>

 

70

 

76

<FreeText14>String</FreeText14>

 

70

 

77

<FreeText15>String</FreeText15>

 

70

 

78

<FreeText16>String</FreeText16>

 

70

 

79

<FreeText17>String</FreeText17>

 

70

 

80

<FreeText18>String</FreeText18>

 

70

 

81

<FreeText19>String</FreeText19>

 

70

 

82

<FreeText20>String</FreeText20>

 

70

 

83

<FreeText21>String</FreeText21>

 

70

 

84

<FreeText22>String</FreeText22>

 

70

 

85

<FreeText23>String</FreeText23>

 

70

 

86

<FreeText24>String</FreeText24>

 

70

 

87

<FreeText25>String</FreeText25>

 

70

 

88

<FreeText26>String</FreeText26>

 

70

 

89

<FreeText27>String</FreeText27>

 

70

 

90

<FreeText28>String</FreeText28>

 

70

 

91

<FreeText29>String</FreeText29>

 

70

 

92

<FreeText30>String</FreeText30>

 

70

 

93

</CustomInfo>

 

   

94

<HeaderOthers>

 

   

95

<Contact>String</Contact>

Contact

100

 

96

<Dept>String</Dept>

Department

100

 

97

<Email>String</Email>

Email

100

 

98

<TelNumber>String</TelNumber>

Tel Number

100

 

99

<FaxNumber>String</FaxNumber>

Fax Number

100

 

100

</HeaderOthers>

 

   

101

<SoldToParty>

 

   

102

<Name>String</Name>

Address line 1 (Name)

255

 

103

<Name2>String</Name2>

Address line 2

255

 

104

<Name3>String</Name3>

Address line 3 

255

 

105

<Name4>String</Name4>

Address line 4 

255

 

106

<Street>String</Street>

Street

30

 

107

<CityName>String</CityName>

City Name

30

 

108

<CityCode>String</CityCode>

City Code

30

 

109

<State>String</State>

State

20

 

110

<CountryCode>String</CountryCode>

Country Code

2

 

111

<PostalCode>String</PostalCode>

Postal Code

20

 

112

<Region>string</Region>

Region

255

 

113

<Email>string</Email>

Email

200

 

114

<TelNumber>string</TelNumber>

Tel Number

30

 

115

<AccNumber>string</AccNumber>

Acc Number

20

 

116

</SoldToParty>

     

117

<ShipToParty>

     

118

<Name>String</Name>

Address line 1 (Name)

255

 

119

<Name2>String</Name2>

Address line 2

255

 

120

<Name3>String</Name3>

Address line 3 

255

 

121

<Name4>String</Name4>

Address line 4

255

 

122

<Street>String</Street>

Address line 5 

255

 

123

<CityName>String</CityName>

City Name

255

 

124

<CityCode>String</CityCode>

City Code

255

 

125

<State>String</State>

State

20

 

126

<CountryCode>String</CountryCode>

Country Code 

2

 

127

<PostalCode>String</PostalCode>

Postal Code

20

 

128

<Region>string</Region>

Region

255

 

129

<Email>string</Email>

Email

200

 

130

<TelNumber>string</TelNumber>

Tel Number

30

 

131

<ID>string</ID>

ID

20

 

132

<IDType>string</IDType>

ID Type

1

 

133

<IDImg1>Base64 string</IDImg1>

Base64 image 1

 

 

134

<IDImg2>Base64 string</IDImg2>

Base64 image 2

 

 

135

<AccNumber>string</AccNumber>

Acc Number

20

 

136

<LockerNumber>string</LockerNumber>

Locker Number

60

 

137

</ShipToParty>

     

138

</Header>

     

139

<Detail>

     

140

<Seq>1</Seq>

1 for 1st line, 2 for the 2nd, etc

 

Reset by order

141

<ItemNumber>String</ItemNumber>

Item no

30

Mandatory

142

<ItemSize>String</ItemSize>

Style 1

30

 

143

<ItemClass>String</ItemClass>

Style 2

30

 

144

<ItemColor>String</ItemColor>

Style 3

30

 

145

<ItemSeason>String</ItemSeason>

Style 4

30

 

146

<LotNumber>String</LotNumber>

 

30

 

147

<OutClientLotNumber>String</OutClientLotNumber>

Specified client lot no

30

Specified batch#/lot# for allocation

148

<POLineNo>String</POLineNo>

 

6

 

149

<PKG>3</PKG>

Outer Package

12(2)

 

150

<Unit>CTN</Unit>

Outer Package Unit

3

 

151

<InnerPKG>3</InnerPKG>

Inner Package

12(2)

Mandatory , Pieces

152

<InnerUnit>PCS</InnerUnit>

Inner Package Unit

3

Mandatory

153

<UnitPrice>3.141</UnitPrice>

Unit Price

12(3)

 

154

<UnitCurrency>Str</UnitCurrency>

Unit Currency

3

 

155

<CBM>3.141</CBM>

CBM

12(3)

 

156

<GrossWeight>3.14</GrossWeight>

Gross Weight

12(2)

 

157

<NetWeight>3.14</NetWeight>

Net Weight

12(2)

 

158

<Length>3.14</Length>

Length

12(2)

 

159

<Width>3.14</Width>

Width

12(2)

 

160

<Height>3.14</Height>

Height

12(2)

 

161

<Contact>string</Contact>

Contact

100

 

162

<Department>string</Department>

Department

100

 

163

<Email>string</Email>

Email

100

 

164

<TelNumber>string</TelNumber>

Tel Number

100

 

165

<FaxNumber>string</FaxNumber>

Fax Number

100

 

166

<Marks>String</Marks>

Marks 

255

 

167

<Description>String</Description>

Description

255

 

168

<Remark>String</Remark>

Remark for detail line

255

 

169

<WHSLoc>String</WHSLoc>

WHS Location

40

 

170

<PONumber>String</PONumber>

PO Number

35

 

171

<HSCode>String</HSCode>

HS Code

255

 

172

<TransactionID>DetailID</TransactionID>

Transaction ID 

60

 

173

<PLTNumber>string</PLTNumber>

PLT Number

60

 

174

<PLTLength>1.23</PLTLength>

PLT Length

12(2)

 

175

<PLTWidth>1.23</PLTWidth>

PLT Width

12(2)

 

176

<PLTHeight>1.23</PLTHeight>

PLT Height

12(2)

 

177

<PLTCBM>1.234</PLTCBM>

PLT CBM

12(3)

 

178

<PLTGrossWeight>1.23</PLTGrossWeight>

PLT Gross Weight

12(2)

 

179

<PLTNetWeight>1.23</PLTNetWeight>

PLT Net Weight

12(2)

 

180

<CTNNumber>string</CTNNumber>

CTN Number

60

 

181

<CTNLength>1.23</CTNLength>

CTN Length

12(2)

 

182

<CTNWidth>1.23</CTNWidth>

CTN Width

12(2)

 

183

<CTNHeight>1.23</CTNHeight>

CTN Height

12(2)

 

184

<CTNCBM>1.234</CTNCBM>

CTN CBM

12(3)

 

185

<CTNGrossWeight>1.23</CTNGrossWeight>

CTN Gross Weight

12(2)

 

186

<CTNNetWeight>1.23</CTNNetWeight>

CTN Net Weight

12(2)

 

187

<CustomInfo>

 

   

188

<FreeText1>String</FreeText1>

FreeText1 for detail line

70

 

189

<FreeText2>String</FreeText2>

 

70

 

190

<FreeText3>String</FreeText3>

 

70

 

191

<FreeText4>String</FreeText4>

 

70

 

192

<FreeText5>String</FreeText5>

 

70

 

193

<FreeText6>String</FreeText6>

 

70

 

194

<FreeText7>String</FreeText7>

 

70

 

195

<FreeText8>String</FreeText8>

 

70

 

196

<FreeText9>String</FreeText9>

 

70

 

197

<FreeText10>String</FreeText10>

 

70

 

198

<FreeText11>String</FreeText11>

 

70

 

199

<FreeText12>String</FreeText12>

 

70

 

200

<FreeText13>String</FreeText13>

 

70

 

201

<FreeText14>String</FreeText14>

 

70

 

202

<FreeText15>String</FreeText15>

 

70

 

203

<FreeText16>String</FreeText16>

 

70

 

204

<FreeText17>String</FreeText17>

 

70

 

205

<FreeText18>String</FreeText18>

 

70

 

206

<FreeText19>String</FreeText19>

 

70

 

207

<FreeText20>String</FreeText20>

 

70

 

208

</CustomInfo>

 

   

209

</Detail>

 

   

210

</PreStockOut>

 

   

211

</PreStockOuts>

 

   

212

</Request>

 

 

 

 

 

 

 

 

 

 

 

 

  1. Response Data Sample and Explanation 1

 

 

 

 

 

 

 

 

 

#

Node with Example

Explanation

Remark

1

<?xml version=”1.0″ encoding=”UTF-8″?>

 

 

2

<Response>

 

 

3

<RequestID>##REQUEST_ID##</RequestID>

Your Request ID

 

4

<ResponseID>HTI01000048</ResponseID>

Response ID

 

5

<ResponseDate>2018-01-11T17:16:38+08:00</ResponseDate>

Response Date

 

6

<ResponseStatus>SUCCESS</ResponseStatus>

Response Status或

SUCCESS , FAIL

7

<ResponseMessage>Pre Stock Out: CAT0220001  Imported in System Fully Allocate</ResponseMessage>

ResponseMessage

 

8

<PreStockOuts>

 

 

9

<PreStockOut>

 

 

10

<RequestSeq>1</RequestSeq>

Your Request Seq 

 

11

<ProcessStatus>SUCCESS</ProcessStatus>

Process Status

SUCCESS , FAIL 

12

<ProcessMessage />

Process Message

No detail if success

13

</PreStockOut>

 

 

14

</PreStockOuts>

 

 

15

</Response>

 

 

 

 

 

 

 

 

  1. Response Data Sample and Explanation 2

 

 

 

 

 

 

#

Node with Example

Explanation

Remark

1

<?xml version=”1.0″ encoding=”UTF-8″?>

 

 

2

<Response>

 

 

3

<RequestID>##REQUEST_ID##</RequestID>

Your Request ID

 

4

<ResponseID>HTI01000048</ResponseID>

Response ID

 

5

<ResponseDate>2018-01-11T17:16:38+08:00</ResponseDate>

Response Date

 

6

<ResponseStatus>FAIL</ResponseStatus>

Response Status或

SUCCESS , FAIL

7

<ResponseMessage>No Orders are Loaded</ResponseMessage>

ResponseMessage

 

8

<PreStockOuts>

 

 

9

<PreStockOut>

 

 

10

<RequestSeq>1</RequestSeq>

Your Request Seq 

 

11

<ProcessStatus>FAIL</ProcessStatus>

Process Status

SUCCESS , FAIL 

12

<ProcessMessage>Missing Details</ProcessMessage>

Process Message

Error detail

13

</PreStockOut>

 

 

14

</PreStockOuts>

 

 

15

</Response>

 

 

 

 

 

 

 

 

  1. Fail Response explanation

 

 

 

 

 

 

Type

Status

ResponseMessage

Reason

Solution

ResponseStatus

FAIL

RequestSeq cannot be duplicated!

<RequestSeq> duplicated with same value

Amend the <RequestSeq> value with different value

ResponseStatus

FAIL

Missing Details

Pre Stock out missing details when insert or update pre stock out record

Fill the pre stock out details

ResponseStatus

FAIL

Order is already Delivered

Shipment already stocked out

Confirm the order # is correct and delete stock out record with same order #

ResponseStatus

FAIL

Order is already Exists

System found existing pre stock out record having same number you provided when you trying to insert a new order

Correct the pre stock out number

ResponseStatus

FAIL

No Orders are Loaded

No database transaction is made

Contact IT support for assistance

ProcessStatus

FAIL

Nothing to Import!

Pre Stock out missing details when insert or update pre stock out record

Fill the pre stock out details

ProcessStatus

FAIL

Customer cannot Empty!

Missing customer value

Fill the customer code

ProcessStatus

FAIL

Warehouse cannot Empty!

Missing warehouse value

Fill the warehouse code

ProcessStatus

FAIL

Customer Code [##CUST_CODE##] not Exist!

Customer code not found

Check and correct the customer code

ProcessStatus

FAIL

Warehouse Code [##WHS_CODE##] not Exist!

Warehouse code not found

Check and correct the warehouse code

ProcessStatus

FAIL

Pre-Stock Out [##PRE_STOCK_OUT_NUM##] already Exist! Cannot Import!

System found existing pre stock out record having same number you provided when you trying to insert a new order

Correct the pre stock out number

ProcessStatus

FAIL

Delivery Client Code [##DELIVERY_CLIENT_CODE##] not Exist!

Delivery client code not found

Check and correct the delivery client code

ProcessStatus

FAIL

Load Port [##LOAD_PORT##] not Exist!

Load port not found

Check and correct the load port

ProcessStatus

FAIL

Discharge Port [##DISCHARGE_PORT##] not Exist!

Discharge port not found

Check and correct the discharge port

ProcessStatus

FAIL

Destination Port [##DESTINATION_PORT##] not Exist!

Destination port not found

Check and correct the destination port

ProcessStatus

FAIL

Inner PKG must not empty and must be number!

InnerPKG is not numeric

Check and correct InnerPKG value

ProcessStatus

FAIL

PKG must be number!

PKG is not numeric

Check and correct PKG value

ProcessStatus

FAIL

PKG cannot < 0!

PKG lesser than 0

Check and correct PKG value

ProcessStatus

FAIL

CBM, KGS, Length, Width, Height, Net Weight Information got Problem!

CBM, KGS or Dimension value is not numeric or having too much decimal behind

Check and correct those field (CBM = 3 Decimals, KGS and dimension = 2 Decimals)

ProcessStatus

FAIL

PKG Unit cannot Empty!

Missing PKG Unit

Check and correct the PKG Unit value

ProcessStatus

FAIL

Inner PKG Unit cannot Empty!

Missing InnerPKG Unit

Check and correct the Inner PKG Unit value

ProcessStatus

FAIL

PKG unit [##PKG_UNIT##] is not Exist!

PKG Unit not exists

Check and correct the PKG Unit value

ProcessStatus

FAIL

Inner PKG unit [##INNER_PKG_UNIT##] is not Exist!

InnerPKG Unit not exists

Check and correct the Inner PKG Unit value

ProcessStatus

FAIL

Item no cannot Empty!

Missing Item Number

Check and fill the item number

ProcessStatus

FAIL

Item no [##ITEM_NO##] is not Exist!

Item number not exists

Check and correct the item number

ProcessStatus

FAIL

Pick Up Date cannot Empty!

Missing pick up date

Fill the pick up date

ProcessStatus

FAIL

Issue Date [##ISSUE_DATE##] is invalid Format!

Incorrect format of issue date

Check and correct the issue date

ProcessStatus

FAIL

Pick up Date [##PICKUP_DATE##] is invalid Format!

Incorrect format of pick up date

Check and correct the pick up date

ProcessStatus

FAIL

Pickup Time [##PICKUP_TIME##] is invalid Format!

Incorrect format of pick up time

Check and correct the pick up time

ProcessStatus

FAIL

Date Col 1 [##DATE_COL1##] is invalid Format!

Incorrect date format provided for column date_col1

Correct the value of date_col1

ProcessStatus

FAIL

Date Col 2 [##DATE_COL2##] is invalid Format!

Incorrect date format provided for column date_col2

Correct the value of date_col2

ProcessStatus

FAIL

Date Col 3 [##DATE_COL3##] is invalid Format!

Incorrect date format provided for column date_col3

Correct the value of date_col3

ProcessStatus

FAIL

Column [##COLUMN_NAME##] is over (max length = ##LENGTH_OF_COLUMN##)!

Input value is too long for specify column

Correct the input value

ProcessStatus

FAIL

Pre Stock Out set ID Error!

Transaction error

Contact IT support for assistance

ProcessStatus

FAIL

Gen Pre Stock Out Number Error!

Error when generating pre stock out

Contact IT support for assistance