Page Comparison

1. Description

...

Panel

title	LXIROrder, CUSORD

LXIROrder (1)

LXIROrder\Envelope (1)

Element	Mand	Explanation	Lxir	EWS	Comment
FromPartner	J	From system	X	X
FromPartnerUser	J	Users from system / client	X	X
ToPartner	J	To system	X	X
ToPartnerUser	J	User System / Client	X	X
DateTime	N	Time to create the message (YY-MM-DD hh: mm)	X	X
ReferensNumber	J	The reference number of the message	X	X
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	X	X
DocumentName	CUSORD	J	Order message name: CUSORD	X	X
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)	X	X
Name2	CUSORD	J	Name field 2, customer	X	X
Name3		N	Name field 3, customer	-	X
Address1		J	Address field 1 (Delivery point)	X	X
Address2		N	Address field 2	X	X
Address3		N	Address field 3	X	X
State		N	Region / State	X	X
City		J	City (Place of Delivery)	X	X
PostalCode		J	Postcode (Delivery Point)	X	X
Country		J	Country (Place of Delivery)	X	X
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.	X	X
Contact1		N	Customer's shipping address 2 (Name2)	X	X
Email		N	Mail address for ship to (notification)	X	X
OrganisationNumber		N	Organization number
VatNumber		N	Vat number
PostGiroAccount		N	Post giro account
BankGiroAccount		N	Bank giro account

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.

X

AddressType

ShipTo
BillTo

Seller

ServicePoint

J

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

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	X	X
OrderNumberExternal	CUSORD	N	External order number	X	X
OrderNumberEndCustomer		N	End customer's order number	X	X	EWS=slutkundorderid
OrderDate		J	Order date (YY-MM-DD hh: mm)	X	X
SequenceNumber		N	Sequence number, 000	X	X
OrderType	N E F W	N	Order Type N = Normal Order E = Express Order F = Replacement Order W = Webshop Order	X	X
OrderReference		N	Reference	X	X	Your reference
OrderReference2		N	Our reference	X	X	Our reference
ShipToId		N	Customer number	X	X
BillToId		N	Bills	X	-
DeliveryMethod		N	Mode of delivery	X	X
ServicePointId		N	Identifier for Servicepoint, ServicePoint (Corresponds to DeliveryLocationId in LxirCustomerOrder1.0 format)	X	X	New field 090526
NoOfRows		N	Number of order lines	X	-
DeliveryRouteNumber		N	For route planning	X	X
WarehouseId		N	Internal stock No.	X	X
ForwarderPartyId		N	Customer number with carrier	X	-
VatPercent		J	VAT rate in percent	X	X
PalletRegistrationNumber		N	pallet Registration	X	X
Currency		J	Currency (SEK = Swedish kronor)	X	X
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	X	X	Nytt 2013-05-17
ConsolidateDelivery		N	Identity of orders to be collected	X	X	Nytt 2014-06-04
DepartureId		N	Retirement / Depa identity	X	X	Nytt 2015-05-11
RouteId		N	route number	X	X	Nytt 2015-05-11
CodFee		N	Withdrawal fee / Postal deposit etc.	-	X
DispatchFee		N	SERVICE FEE	-	X
AmountTotal		N	Total sum	X	X
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	X	X
InvoiceNumber		N	invoice number	X	X
DueDate		N	Due date for Invoice	X	X
PaymentTerms		N	Payment terms clear	X	X
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	X	X
AskedDeliveryDate		N	Asked delivery date	X		Ongoing specific field
SalesChannel		N	Sales channel, (nvarchar(100))		X
DeliveryStartDatetime		N	Delivery window start	X
DeliveryEndDatetime		N	Delivery window end		X
DeliveryMethodBulkId		N
DeliveryMethodAvailabilityToken		N
DeliveryMethodSortCode		N
DeliveryMethodPreparedTransportDocument		N

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

Element	Mand	Explanation	Lxir	EWS
Function	J	Code for the description	X	X
Description1	J	Description field 1	X	X
Description2	N	Description field 2	X	X
Description3	N	Description field 3	X	X

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

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

Element	Code	Mand	Explanation	Lxir	EWS	Comment
OrderPosition		J	Order line position	X	X
OrderSubPosition		J	Order line subposition	X	X
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	X	X
ArticleId		J	Article	X	X
SupplierArticleID		?	Supplier's product number	X	X
PackageId	ST	J	Unit ST = Piece	X	X
SalesPackageID		J	Sales unit	X	X
OrderQuantity		J	Ordered quantity	X	X
SalesOrderQuantity		J	Sold quantity	X	X
Price		J	Price, 00000000.0000	X	X
SalesPrice		J	Selling price	X	X
VatPercent		J	VAT rate in percent 00,000	X	X
Currency		J	Currency	X	-
ShipDate		N	Shipping Date	X	-
ExpectedDeliveryDate		N*	Expected delivery date	X	X
OrderRowStatusCode	1 2	J	Order Line Status 1 = Incoming 2 = Reserved	X	X	"1" refers to listed lines and is used together with "Expecteddelivery"
ArticleName		N	Article Name	X	X
Intrastat				-	-	Should be replaced by CustomsCommodityCode
CustomsCommodityCode				-	X
VisibilityType		N	values AlwaysVisible nonpublic	X	X	Used only for OrderRowType = ”V” Value added service * If none is specified AlwaysVisible is used
StructureId		N	Is Supplymode is BOM then its "Position" Else if ParentOrderRowPosition is not empty then set to this	X	X
ArticleTypeId		N	Hard coded string 999 if supplymode is BOM		X

* 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	Mand	Explanation	Lxir	EWS
Function	J	Code for the description	X	X
Description1	J	Description field 1	X	X
Description2	N	Description field 2	X	X
Description3	N	Description field 3	X	X
Description4	N	Description field 4	X	X

Panel

title	Free 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
DEL	Intended for, Delivery instructions, Free text field "Notes on order headers" in LXIR (Delivery instructions in EWS)	X	X
MKS	Merchandising, Free text field "Marking on order head" in LXIR	X	X
TRA	Live instruction, Selected / selected options on additional services are sent in plain text, in Description1 "thermo" and coded in Description2 as "HOT".	X	X
HAN	Action ground from order head	X	X
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	X	X
DELIVERYTERMS	Delivery terms Combiterms Description1ska contain the numerical code according to incoterms 2000	-	X
EMCS-SND	Description1 the sender's EMCS identity	X	X
EMCS-REC	Description1 the recipient's EMCS identity	X	X
EMCS-ARC	Description1 contain ARC numbers	X	X

Panel

title	Free 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
MKS	Branding (shipping market in EWS and LXIR)	X	X
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	X	X
SER	Serial number	-	X
BAT	Batch number	-	X

...

Panel

LXIROrderResult (1)

Envelope (1) LXIROrderResult

Element	Mand	Explanation	Lxir	EWS	Comment
FromPartner	J	From system	X	X
FromPartnerUser	J	Users from system / client	X	X
ToPartner	J	To system	X	X
ToPartnerUser	J	User System / Client	X	X
DateTime	N	Time to create the message (YY-MM-DD hh: mm)	X	X
ReferensNumber	J	The reference number of the message	X	X
InterchangeTest	N	Indicates test message	-	-	deleted

Header (1-999)

Header (1) LXIROrderResult

Element	Code	Mand	Explanation	Lxir	EWS
CreationDate		J	Time when the message was created (YY-MM-DD hh: mm)	X	X
DocumentNumber		J	Order number reference number	X	X
DocumentName	CUSORD	J	Order Announcement Name: CORRES	X	X

LXIROrderResult \ header \ Order Head (1)

Element	Code	Mand	Explanation	Lxir	EWS	Comment
OrderNumber		J	Internal order number	X	X
SequenceNumber		J	sequence number	X	X

LXIROrderResult \ header \ Shipment (0-1)

Element	Code	Mand	Explanation	Lxir	EWS	Comment
ShipmentNumber		J	Shipping number	X	X
ConsolidatedDelivery	False True	N	Delivered with previous orders	X	X	Y / N
ShipmentOwner		N		X	X
TransportWeight		J	Shipping weight	X	X
TransportVolume		J	The volume of the broadcast	X	X
TransportCost		J	The value of the consignment	X	X	EWS Always sends 0
PackageNumber		J	Package number, semicolon separated	X	X
PackageNumberOf		J	Number of packages	X	X
PalletNumberOf		J	Number of pallets EUR	X	X
PalletNumberOf2		J	Number of B-pallets	X	X
PalletNumberOf3		N	Number of half pallets	X	X
PalletNumberOf4		N	Number of SRS pallet	X	X
DeliveryMethod		J	Delivery method and additional services (see note)	X	X

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

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

Element	Mand	Explanation	Lxir	EWS
PackageNumber	J	Package number, semicolon separated	X	X
PackageTypeDescription	N		X	X
PackageType	J		X	X
PackageWidth	J		X	X
PackageLength	J		X	X
PackageHeight	J		X	X
PackageWeight	J		X	X

LXIROrderResult \ header \ OrderRows (1-99999)

Element	Code	Mand	Explanation	Lxir	EWS	Comment
OrderPosition		J	Order line position	X	X
OrderSubPosition		J	Order line subposition	X	X
OwnerNumber		J	Item owner, client number	X	X
ArticleNumber		J	Article	X	X
PickedQuantity		J	Picked quantity	X	X
DiscrepancyQuantity		J	Remaining (deviating) quantity	X	X
DiscrepancyCode	N S A U	N	Discrepancy Code: N = 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.	X	X
SerialNumber		N	Serial number?	X	X
BatchNumber		N	BatchNumber	X	X
ConsNote			parcel number	X	X	Same as Packagenumber on OrderHead
IMEINumber		N		?	X	v9.11
MacAddress		N		?	X	v9.11
AntiTheftID		N		?	X	v9.11
UUID		N		?	X	v9.11
WLANMAC		N		?	X	v9.11
MSPKID		N		?	X	v9.11

DiscrepancyCode N

Balance available, can not be picked. Reservation attempts are postponed for 1 working day until picking takes place. Sales order will be resent from XTND Extend Commerce BACKEND the next picking day until picking has taken place. Otherwise, the same information is sent as the original order. XTND WMS Extend Commerce 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 the element LXIROrder \ Header \ OrderHeader:

Element	Explanation	Lxir
\ Header \ OrderHeader		X
\ OrderHeaderInfo \ OrderNumber	Same as the original order.	X
\ OrderHeaderInfo \ SequenceNumber	Listed one step for each time OrderNumber is sent to the XTND WMSExtend Commerce 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 quantity.	X

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

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

DiscrepancyCode S

Out of stock. For XTND Extend Commerce BACKEND, acknowledgment with 0 (zero) in the field \ OrderRows \ PickedQuantity may occur, but it is often the case that some are delivered. Wait for an ITECHG message with inventory code ST on the product. Recalculation takes place on a confirmed date thereafter. In XTND BACKENDExtend Commerce 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 XTND BACKEND Extend Commerce BACKEND you can choose that partial delivery is not allowed and this can then lead to a partial delivery despite the choice.

Note

The S code and "Picking days in advance"(warehouse settings) 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, i.e. an agreement with the customer that results in cancellation of the deviating number.

A check is made that \ OrderRows \ PickedQuantity + \ OrderRows \ DiscrepancyQuantity = ordered quantity. If this is not the case, an error logging will take place.

DiscrepancyCode M

The code M stands for Manual Handling. Not supported in XTND Extend Commerce 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 BackendExtend Commerce 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.

...

Versions Compared

Old Version 19

New Version 20

Key

1. Description

DiscrepancyCode N

DiscrepancyCode S

DiscrepancyCode A

DiscrepancyCode U

DiscrepancyCode M

DiscrepancyCode D

ConsNote