Versions Compared

Old Version 11

changes.mady.by.user johanna.fallstrom

Saved on

compared with

New Version 12

changes.mady.by.user johanna.fallstrom

Saved on

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

1. Description

...

Panel
Panel
titleLXIROrder, CUSORD

LXIROrder (1)

LXIROrder\Envelope (1)

Element 

Code

Mand

Explanation

Lxir

EWS

Comment
FromPartner
J
From system
XX
FromPartnerUser
J
Users from system / client
XX
ToPartner
J
To system
XX

ToPartnerUser


J
User System / Client
XX
DateTime
N
Time to create the message (YY-MM-DD hh: mm)
XX
ReferensNumber
J
The reference number of the message
XX
InterchangeTest
N
Indicates test message


Deleted


LXIROrder\Header (1-999)

LXIROrder\Header\HeaderInfo (1)

Element 

Code

Mand

Explanation

Lxir

EWS

Comment
DocumentNumber
J

Order number reference number

XX

DocumentName

 CUSORDJ
Order message name: CUSORD
XX

CreationDate


N
Created date
--Part

LXIROrder\Header\Addresses(1-2)

LXIROrder\Header\ Addresses\Address(1)

Element 

Code

Mand

Explanation

Lxir

EWS

Name1
J
Name field 1, customer (Delivery point)
XX

Name2

CUSORDJ

Name field 2, customer

XX

Name3


N
Name field 3, customer
-X
Address1
J
Address field 1 (Delivery point)
XX
Address2
N
Address field 2
XX
Address3
N
Address field 3
XX

State


N
Region / State
XX
City
J
City (Place of Delivery)
XX
PostalCode
J

Postcode (Delivery Point)

XX
Country
J
Country (Place of Delivery)
XX
CountryCode
J
Country code (SE = Sweden) Specifies the language of the documents
X-
Phone
N
Phone in shipto (for notification) Phone in Billto refers to office telephone. Phone in 
Servicepoint refers to the telephone number of the delivery point.
XX
Contact1
N
Customer's shipping address 2 (Name2)
XX
Email
N

Mail address for ship to (notification)

XX

LXIROrder\Header\ Addresses\Information(1)

Element 

Code

Mand

Explanation

Lxir

EWS

Comment
PartyProfile
PIECE
J

Profile (constant) in ship and billto, in service points is this identity for the delivery point.

XX

AddressType


ShipTo
BillTo

Seller

ServicePoint		J
Specifies the type of address
ShipTo = Shipping address,
BillTo = Billing Address
seller =
ServicePoint = Delivery point


X

X

X

X


X

X

X

X

Seller Only supports BankGiroAccount

Postal Giro Account

organization Number

VATNUMBER

LXIROrder\Header\OrderHeader(1)

LXIROrder\Header\OrderHeader\OrderHeaderInfo(1)

Element 

Code

Mand

Explanation

Lxir

EWS

Comment
OrderNumber
J
Internal order number
XX

OrderNumberExternal

CUSORDN

External order number

XX

OrderNumberEndCustomer


N

End customer's order number

XX

EWS=slutkundorderid

OrderDate


J
Order date (YY-MM-DD hh: mm)
XX

SequenceNumber


N

Sequence number, 000

XX

OrderType


N
E
F

W

N
Order Type
N = Normal Order
E = Express Order
F = Replacement Order

W = Webshop Order
XX

OrderReference


N
Reference
XX
Your reference

OrderReference2


N
Our reference
XX
Our reference
ShipToId
N
Customer number
XX
BillToId
N
Bills
X-
DeliveryMethod
N
Mode of delivery
XX
ServicePointId
N
identifier for Servicepoint, ServicePoint
XX

New field 090526

NoOfRows
N
Number of order lines
X-
DeliveryRouteNumber
N
For route planning
XX
WarehouseId
N

Internal stock No.

XX
ForwarderPartyId
N

Customer number with carrier

X-
VatPercent
J

VAT rate in percent

XX
PalletRegistrationNumber
N

pallet Registration

XX

Currency


J

Currency (SEK = Swedish kronor)

XX

FreightCost


N
FREIGHT
--

OrderMethod


N

Order method used when booking

X-

Nytt 2012-05-07.

AllowPartialDelivery


N

Full or partial delivery information

X-

Nytt 2012-05-07

CompanyGroupId


N

Short name Goods owner / group

XX

Nytt 2013-05-17

ConsolidateDelivery


N

Identity of orders to be collected

XX

Nytt 2014-06-04

DepartureId


N

Retirement / Depa identity

XX

Nytt 2015-05-11

RouteId
N

route number

XX

Nytt 2015-05-11

CodFee
N

Withdrawal fee / Postal deposit etc.

-X
DispatchFee
N

SERVICE FEE

-X
AmountTotal
N

Total sum

XX
VatAmountTotal
N

Tax Total Total

-X
OwnerId
N

Identity of resellers in the EWS

-X

Identitet för återförsäljare

InvoiceDate
N

invoice Date

XX
InvoiceNumber
N

invoice number

XX
DueDate
N

Due date for Invoice

XX
PaymentTerms
N

Payment terms clear

XX
PaymentType
N

Payment method short name

INV = Invoice

INV-P = Invoice

CCA = Credit Card American Express

CCV = Credit card Visa

CC = Credit card

COD = COD

XX
AskedDeliveryDate
NAsked delivery dateX
Ongoing specific field
SalesChannel
NSales channel, (nvarchar(100))
X
DeliveryStartDatetime
NDelivery window startX

DeliveryEndDatetime
NDelivery window end
X

LXIROrder\Header\OrderHeader\OrderHeaderDescriptions(0-99)

Element 

Code

Mand

Explanation

Lxir

EWS

Comment

Function


J

Code for the description

XX

Description1


J

Description field 1

XX

Description2


N

Description field 2

XX
Description3
N

Description field 3

XX

LXIROrder\Header\OrderHeader\OrderRow(1-99999)

LXIROrder\Header\OrderHeader\OrderRow\OrderRowInfo(1)

Element 

Code

Mand

Explanation

Lxir

EWS

Comment

OrderPosition


J

Order line position

XX

OrderSubPosition


J

Order line subposition

XX

OrderRowType

N

1

11

V

J

Order line type

N = Normal

1 = Postage / Shipping

11 = Credits' –Price should be negative

V = Value added service


X

X



X

X

X

X

X

X


OwnerNumber
N

Article owner

XX
ArticleId
J

Article

XX
SupplierArticleID
?

Supplier's product number

XX
PackageId


ST

J

Unit 
ST = Piece

XX

SalesPackageID


J

Sales unit

XX

OrderQuantity


J

Ordered quantity

XX

SalesOrderQuantity


J

Sold quantity

XX

Price


J

Price, 00000000.0000

XX

SalesPrice


J

Selling price

XX

VatPercent


J

VAT rate in percent 00,000

XX

Currency


J

Currency

X-

ShipDate


N

Shipping Date

X-

ExpectedDeliveryDate


N*

Expected delivery date

XX

OrderRowStatusCode


1

2

J

Order Line Status 
1 = Incoming 
2 = Reserved

XX

"1" refers to listed lines and is used together with "Expecteddelivery"

ArticleName


N

Article Name

XX

Intrastat




--

Should be replaced by CustomsCommodityCode

CustomsCommodityCode




-X

VisibilityType


N

values

AlwaysVisible

nonpublic

XX

Used only for

OrderRowType = ”V” Value added service


* If none is specified AlwaysVisible is used


* When orderrowstatuscode = '1' is specified, this is used to present a scheduled delivery date on delivery note to recipient.

LXIROrder \ header \ OrderHeader \ OrderRow \ OrderRowAdditions (0-1)

Element 

Code

Mand

Explanation

Lxir

EWS

Comment

OperationCode


N

Order Line Status 
1 = New Row


X

LXIROrder\Header\OrderHeader\OrderRow\OrderRowDescriptions(0-99)

Element 

Code

Mand

Explanation

Lxir

EWS

Comment

Function


J

Code for the description

 XX
Description1
J

Description field 1

XX
Description2
N

Description field 2

XX
Description3
N

Description field 3

XX
Description4
N

Description field 4

XX
Panel
titleFree Text Field MAIN

Free texts that are current are DEL, MKS, TRA, HAN, FREETEXT and TEXT 1 - 5. If free text is longer than 70 characters, the free text is cut (truncated).

Function

Explanation

Lxir

EWS

Comment

DEL

Intended for, Delivery instructions, Free text field "Notes on order headers" in LXIR (Delivery instructions in EWS)

XX
MKS

Merchandising, Free text field "Marking on order head" in LXIR

XX
TRA

Live instruction, Selected / selected options on additional services are sent in plain text, in Description1 "thermo" and coded in Description2 as "HOT".

XX
HAN

Action ground from order head

XX
FREETEXT

Free text

-X
TEXT1

Free text 1 for client

-X
TEXT2

Free text 2 for client

-X
TEXT3

Free text 3 for client

-X
TEXT4

Free text 4 for client

-X
TEXT5

Free text 5 for client

-X
OCR

OCR number

XX
DELIVERYTERMS

Delivery terms Combiterms Description1ska contain the numerical code according to incoterms 2000

-X

EMCS-SND

Description1 the sender's EMCS identity

XX

EMCS-REC

Description1 the recipient's EMCS identity

XX

EMCS-ARC

Description1 contain ARC numbers

XX
Panel
titleFree Text Field Row

Free texts that are current are MKS, TRA and HAN. If free text is longer than 70 characters, the free text is cut off (truncated).


A free text is sent per element, OrderRowDescriptions on. Thus, there can be several free text fields one after the other. Only Description1 is used, ie 70 characters are max in a free text.

(The five FTX_1 to the FTX_5 rows contained in the EWS message specification are seen as a long field where "#" is used as row separator between them and must be at position 70.)

Function

Explanation

Lxir

EWS

Comment

MKS

Branding (shipping market in EWS and LXIR)

XX
TRA

Live instruction, Selected / selected options on additional services are sent in plain text, in Description1 "thermo" and coded in

X-
HAN

Action ground from order line

XX
SERSerial number-X
BATBatch number-X

...

Panel

LXIROrderResult (1)

Envelope (1) LXIROrderResult

Element       

Code

Mand

Explanation

Lxir

EWS

Comment

FromPartner
JFrom systemXX
FromPartnerUser
JUsers from system / clientXX
ToPartner
JTo systemXX

ToPartnerUser


JUser System / ClientXX
DateTime
N

Time to create the message (YY-MM-DD hh: mm)

XX
ReferensNumber
J

The reference number of the message

XX
InterchangeTest
N

Indicates test message

 - -deleted

Header (1-999)

Header (1) LXIROrderResult

Element       

Code

Mand

Explanation

Lxir

EWS

Comment

CreationDate
J

Time when the message was created (YY-MM-DD hh: mm)

XX

DocumentNumber


J

Order number reference number

XX
DocumentName CUSORDJ

Order Announcement Name: CORRES

XX

LXIROrderResult \ header \ Order Head (1)

Element       

Code

Mand

Explanation

Lxir

EWS

Comment

OrderNumber
J

Internal order number

XX

SequenceNumber


J

sequence number

XX

LXIROrderResult \ header \ Shipment (0-1)

Element       

Code

Mand

Explanation

Lxir

EWS

Comment

ShipmentNumber
J

Shipping number

XX
ConsolidatedDelivery

False True

N

Delivered with previous orders

XX

Y / N

ShipmentOwner
N
XX
TransportWeight
J

Shipping weight

XX
TransportVolume
J

The volume of the broadcast

XX
TransportCost
J

The value of the consignment

XX

EWS Always sends 0

PackageNumber
J

Package number, semicolon separated

XX
PackageNumberOf
J

Number of packages

XX
PalletNumberOf
J

Number of pallets EUR

XX
PalletNumberOf2
J

Number of B-pallets

XX
PalletNumberOf3
N

Number of half pallets

XX
PalletNumberOf4
N

Number of SRS pallet

XX
DeliveryMethod
J

Delivery method and additional services (see note)

XX

LXIROrderResult \ header \ Shipment \ Packages (0-1)

LXIROrderResult \ header \ Shipment \ Package (1-99999)

Element   CodeMandExplanationLxirEWSComment
PackageNumber
JPackage number, semicolon separatedXX
PackageTypeDescription
N
XX
PackageType
J
XX
PackageWidth
J
XX
PackageLength
J
XX
PackageHeight
J
XX
PackageWeight
J
XX

LXIROrderResult \ header \ OrderRows (1-99999)

Element       

Code

Mand

Explanation

Lxir

EWS

Comment

OrderPosition
J

Order line position

XX
OrderSubPosition


J

Order line subposition

XX
OwnerNumber
J

Item owner, client number

XX
ArticleNumber
J

Article

XX
PickedQuantity
J

Picked quantity

XX
DiscrepancyQuantity
J

Remaining (deviating) quantity

XX


DiscrepancyCode


N 
S 
A 
U

N

Discrepancy Code: 
N = balance exists, cannot be picked (temporary pick-up obstruction) 
S = end of stock 
A = agreed over-delivery 
U = agreed sub-delivery Balance available, can not be picked. Reservation attempts are postponed for 1 working day until picking takes place.
S = Out of stock. 
A = Agreed overdelivery.
U = Agreed sub-delivery. 

M = Manual handling.

D = Balance available, can not be picked. Reservation attempts are possible immediately.

XX
SerialNumber
N

Serial number?

XX
BatchNumber
N

BatchNumber

XX
ConsNote

parcel number

XX

Same as Packagenumber on OrderHead

DiscrepancyCode N

Balance available cannot be picked (temporary picking obstacle). Customer order line is sent from LXIR , can not be picked. Reservation attempts are postponed for 1 working day until picking takes place. Sales order will be resent from XTND BACKEND the next picking day until picking has taken place.   Otherwise, the same information is sent as the original order.  EWS XTND WMS handles this as a new order.   Now the same message as the original order is sent again but now with the following information in In the element LXIROrder \ Header \ tOrderHeader:

Element       

Explanation

Lxir

EWS

Comment

\ Header \ OrderHeader


X

\ OrderHeaderInfo \ OrderNumber

Same as the original order.

X

\ OrderHeaderInfo \ SequenceNumber

Listed one step for each time OrderNumber is sent to the EWSXTND WMS.

X

The current line that received the code "N":


X

\ OrderRow \ OrderRowInfo \ ShipDate

Next day for a new try.

X

\ OrderRow \ OrderRowInfo \ OrderQuantity

Remaining numberquantity. 

X

In LxiRXTND BACKEND, the order lines will remain continue to be reserved.   An N-receipt does not release the reservation.   This means that for an N -acknowledgmentreceipt, one the order will go towards the same transmissionshipment.   If in one and the same message two lines are normally acknowledged normally and one with N then , these lines will still be on the same transmissionshipment.   The two normal rows will be sent away when the remaining row is acknowledged for to eg External system.

N-receipt is thus a temporary code that should only be used during for one and the same day.

DiscrepancyCode S

Out of stock.  Receipt For XTND BACKEND, acknowledgment with 0 (zero) in the field \ OrderRows PickedQuantity can be sent to LXIR\ PickedQuantity may occur, but it is often the case that a part is delivered. Automatically leads to inventory in the EWS. some are delivered. Wait for an ITECHG message with inventory code ST on the articleproduct.   Recalculation takes place on a confirmed date thereafter.   In LxiRXTND BACKEND, what is not delivered will be reserved and moved forward one day.

Code S should not normally occur.   It should be noted that in LXIR one XTND BACKEND you can choose that partial delivery is not allowed and this can then lead to a partial delivery despite the choice.

DiscrepancyCode A

Agreed over delivery ie
Note

The S code and "does not work well together. The desired delivery date is postponed by one day, a possible picking shift means that the order still goes down directly again for picking in that scenario.

The same applies if the order is typed as express or express order.

DiscrepancyCode A

Agreed overdelivery i.e. an agreement with the customer.   If the number picked exceeds the ordered number, a new row with a new subposition and status picked must be created on the part that is handed over.

DiscrepancyCode U

Agreed subcontracting ie an , i.e. an agreement with the customer . OrderRows PickedQuantity + OrderRows that results in cancellation of the deviating number.

A check is made that \ OrderRows \ PickedQuantity + \ OrderRows \ DiscrepancyQuantity = ordered quantity. If this is not correct, it should be loggedIf this is true. If nothing has been picked up, the entire line should be set to cancel and the reservation of stored units released. In other cases, the number picked to be picked is set. The rest is added to a new row with new subposition and status canceled, then the units are releasedthe case, an error logging will take place.

DiscrepancyCode M

The code M stands for Manual Handling. Not supported in XTND WMS, but external storage systems such as Ongoing can in some cases set this code which then indicates that the system will require the line to be handled manually in XTND Backend. De-reservation is made of a reserved balance. Shipdate and NextReservationAttempt are set for the far future. The order line is blocked for reservation with the flag "WaitReservation".

DiscrepancyCode D

Balance available, can not be picked. Reservation attempts are possible immediately. This is the same logic as the N-receipt, i.e. a de-reservation is made. However, expectedDeliveryDate and Shipdate do not change on the order line, unlike the N acknowledgment which postpones the dates one working day.

ConsNote

Here comes the shipping number in some cases and it depends on the delivery method and settings in the EWS. If a shipping number is created per order, it can be sent but not if it is the same shipping number for several different orders. 

...