Versions Compared

Old Version 20

changes.mady.by.user Ellen Fransson

Saved on

compared with

New Version 21

changes.mady.by.user Lasse Sääf

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
OrganisationNumber
NOrganization number

VatNumber
NVat number

PostGiroAccount
NPost giro account

BankGiroAccount
NBank 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.

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
(Corresponds to DeliveryLocationId in LxirCustomerOrder1.0 format)
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
DeliveryMethodBulkId 
N



DeliveryMethodAvailabilityToken 
N



DeliveryMethodSortCode 
N



DeliveryMethodPreparedTransportDocument 
N



RequirePickingPackaging
NTrue, False
X10.9

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


StructureId
NIs Supplymode is BOM then its "Position" Else if ParentOrderRowPosition is not empty then set to thisXX
ArticleTypeId
NHard coded string 999 if supplymode is BOM
X
ShopNumber
N

X10.9

* 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

...