XML Einrichten Version 1.2
XML Einrichten Version 1.2
Elements
ElementDescription
Mesage: Delivery note (DESADV)
Mesage: Invoice (INVOIC)
Mesage: Inventory (INVRPT)
Mesage: Order Change (ORDCHG)
Mesage: Order (ORDERS)
Message: Order Resopons (ORDRSP)
Mesage: Order status report (OSTRPT)
Mesage: Receiving advice(RECADV)
Mesage: Remittance advise (REMADV)
Complex Types
Complex TypeDescription
Start or end date of the accounting period
Actual delivery date
Enter subsequent additional information related to a position
Berichtigung Correction
Advised Delivery date/time
Border Crossing Number
Date of Border Crossing
Cash Discount defined by Date percentage and/or amount
Categorization of a product by categorization schema type, feature and option
Segment for conditions for the complete document
Segment for conditions for a single position
Handling instructions for a position
Confirmed delivery date
Group for contact information
Group for communication data of a contact person
Amount defined by decimal value and currency
Segment for delivery times
Date of the delivery note
Position within the delivery note
reference to the dispatch advise number
Goods issue date
Referenc to the dispatch number
Total amount for all conditions on head or line level
Foot section of the message
Head of the document
reference to a position of another document
Reference to other documents variable defined by qualifier
Information about the packaging pieces
Hint for the ORDRSP:
Pieces which contain more than one article position are defined below the first article position within the piece
Link between LINE and PACI (n..m)
Reference to another document or process
How to transfer for example ExcalibuR Idents?
DocRefNumber = GeoID or ConfigID
DocDate = Date of transfer from XCR
Reference to other documents variable defined by qualifier
Due date
Duration
Code list:
803 = Weeks
804 = Days
805 = Hours
806 = Mminutes
variable definition of a date format by format code
format description for a date info
102 = "CCYYMMDD"
203 = "CCYYMMDDHHMM"
616 = "CCYYWW"
Information about the end-consumer
Position within the order of the end-consumer
Group for financial information
Attention - Do not use anymore. will be cancelled in further versions
Gross price
Segment for textual information within the head of the message
Total amount if the invoice including all taxes from all tax rates
Date of the invoice
date of the consolidated invoice list
Last possible date for change of the order
not on detail defined position amount)
by code defined position amount)
Segment for textual information for a position
Group for measurement information
Format Version and handling
Segment for multimedia information for the document
Segment for multimeda information for a single position
Inventory movements
Segment for address information
sum of all net position amounts
Net amount of a position (Net price*Quantity)
Net price of an unit
Opening Hours, period during which a contact is available
DTM+306 = Working period
Qualifier 720 = THHMMTHHMM T=1=Monday
Segment for information about features and options for a single position
Subsequent to a feature information
Line within an order
Line within an order of an end-consumer
Number of an order
Date of the an order response
Line within an order response
reference to the number of the order response
Reference to the original order
Date of payment
Pick up date
Number of the customer order in a previous system
Number of position within the customer order in a previous system
Number of the previous invoice
Number of the previous order response
Price information
Price information with a defined price type by a qualifier
Processig stat within serveral processing types
-----------------------------------------------
Mapping für Bahag
Category=2,Code=002:STS+1+5 = (MUSS)Bestellung erhalten
Category=2,Code=102:STS+1+275 = (MUSS)Stornoanfrage des Kunden bestätigt
Category=2,Code=103:STS+1+71 = (MUSS)Storno durch Kunde nicht mehr möglich
Category=2,Code=104:STS+1+56 = (MUSS)Storno durch Lieferant
Category=1,Code=201:STS+1+24 = (MUSS)Ware versendet
Category=1,Code=202:STS+1+21 = (MUSS)Ware mit Spedition versendet
Category=1,Code=301:STS+1+64 = (MUSS)Abholauftrag für Retoure erhalten
Category=1,Code=302:STS+1+82 = (MUSS)Retoure: Ware vor Ort
Category=1,Code=303:STS+1+13 = (KANN)Endkunde: Abholtermin bestätigt
Category=1,Code=401:STS+1+216 = (KANN)Endkunde nicht erreicht - schriftliche Benachrichtigung zur Terminavisierung
Category=1,Code=402:STS+1+243 = (KANN)Endkunde: Terminavisierung nicht möglich
Category=1,Code=403:STS+1+209 = (KANN)Endkunde: Liefertermin bestätig
Category=1,Code=404:STS+1+212 = (KANN)Endkunde: Liefertermin geändert
Category=1,Code=405:STS+1+210 = (KANN)Endkunde: Nicht angetroffen - zweite Lieferung avisiert
Category=1,Code=406:STS+1+325 = (KANN)Endkunde: Annahme der Lieferung verweigert
Category=1,Code=407:STS+1+73 = (KANN)Endkunde: Lieferung unvollständig - Nachlieferung avisiert
Category=3,Code=501:STS+1+80 = (MUSS)Retoure: Prüfung wurde bestanden
Category=3,Code=502:STS+1+81 = (MUSS)Retoure: Prüfung wurde nicht bestanden
Category=3,Code=503:STS+1+218 = (KANN)Endkunde:Ware beschädigt
Category=5,Code=601:FTX+ZZZ:1 = (MUSS)Kunde wünscht Gutschrift
Category=5,Code=602:FTX+ZZZ:2 = (MUSS)Kunde wünscht Ersatzlieferung
-----------------------------------------------
Mapping für Otto
Auftrag
Category=1,Code=201: SENT
Category=2,Code=101: CANCELED_BY_OTTO
Category=2,Code=104, Reason=001: CANCELED_TIMEOUT
Category=2,Code=104, Reason=101: CANCELED_NOT_AVAILABLE
Retoure
Category=1,Code=302: ARRIVED
Category=3,Code=501: ACCEPTED
Category=3,Code=502: REJECTED
Identification information for an article
Quantity
Qualified quantity
Informationen zum gebuchten Wareneingang Information about the received packages
Requested delivery date
goods issue date/time
Qualified text information
Zeitenangaben in den Lieferzeiten Times within the delivery times section
Total amount
Qualified total amount
Total amountof a position
Unit value
Value date
Group to describe a tax
Sum of all tax amounts
Weight
Simple Types
Simple TypeDescription
Availabilty of the products
71 = Available
72 = Not Available
Unique barcode for this document
Batch Number
Internal number of the buyer at the manufacturer
Catalogue Ident for the catalogue from which the order has been produced
Feature
classification schema
HS = customs tariff number
NB = Batch Number
STQ = eCl@ss
value within a classification
1. Ident within a classification (ClassofGoodsFeature stays empty)
2. option value for the specified feature (ClassofGoodsFeature is defined)
Name (number) of the commission
Resaon for the correction
Grund für die Berichtigung
Code list:
1 = Vereinbarte Regulierung
7 = Akontozahlung
8 = Inklusive Gebühr für Mehrwegverpackung
17 = Transportschaden
19 = Handelsrabatt
21 = Werbekostenzuschuss
38 = Bonus
40 = Abzugsfähige Frachtkosten
15E = Delkredere
16E = Skonto
36E = Ständer- oder Regalauffüllservice
37E = Außerordentlicher Werbeservice
38E = Unterschiede im Steuersatz
currency coded. for example EUR
Delivery Conditions. Use the following code list
04E = Cash on delivery
despatch advise number
Dispatch number
Movement of inventory
Code list:
1 = from stock
2 = to stock
Discharging Time
DTime unit for the discharging Time
Document functional symbol
Code list:
Number of this document
Qualified reference to another content
Code list:
ABO = Reference to to the commission
DQ = Reference to the despatch advise number
IV = Reference to the Invoice
LI = Reference to the position
ON = Reference to the order
POR = Reference to the order response
XCG = Reference to the GeoID(XcalibuR)
XCC = Reference to the ConfigID(XcalibuR)
FCID = Reference to the FurncloudID(furnplan)
FSC = Reference to the FSC Certificate
PEFC = Reference to the PEFC Certificate
Type of the document
Code liste
35 = Inventory report
163 = Receiving advice
220 = Order
22E = Order generated by manufacturer
230 = Order response change
231 = Order Response
256 = Delivery Time report
348 = Order Status Report
351 = Dispatch advise
380 = Invoice
381 = Credit note
481 = Remittance advise
610 = Forwarding order
73E = Sales report
Code for the description of an date format
Code list:
102 = CCYYMMDD
201 = YYMMDDHHMM
615 = YYWW
616 = CCYYWW
720 = THHMMTHHMM
804 = Number of dayse
Example <DocumentDate FormatCode="102">20160331</DocumentDate>
Code for the type of adate
Code list:
2 = Recommended delivery date
3 = Invoice date
4 = Order date
11 = Delivery datum
18 = date of assembly installation
35 = real delivery date
48 = Duration
63 = Latest delivery data
64 = Earliest delivery date
69 = Promised delivery date
76 = Confirmed delivery date
79 = Goods issue date
137 = date of the document
138 = Payment date
157 = Information valid from
171 = Reference date
209 = Value date
743 = Latest possible order changing date
Employee ID of the salesman
Exchange Rate
Country of origin
Number of the goods receipt document
 
Instruction for the end consumer
Method of inventory rating
Code list:
1 = booked inventory
2 = counted inventory
Quantity unit of invetory
Type of inventory
Code list:
1 = Accepted inventory
2 = damaged inventory
3 = Customs inventory
4 = reserved Inventory
Number of the invoice summary list
Number of the invoice
Plate of the trailer
Plate of the truck
Number of the dispatch advise
Amount of the position
Code list:
66 = Net value = Gross price*Quantity - Conditions
203 = Gross value = Gross price*Quantity Remark: No Tax included
131 = Sum of all discounts and allowances
Number of position in a document
Loading Tackle
Location of goods
Number of packing pieces
Seal identifier
Is it possible to order the product
71 = yes
72 = No
Number of position in an order response
Number of the order response
Type of the order
Code ist:
FURN000 = Standard order for stock delivery
FURN050 = Standard order in commission
FURN100 = Promotional goods
FURN200 = Basic equipment
FURN210 = Sample
FURN250 = new opening
FURN300 = Spare parts delivery free of charge
FURN350 = Spare parts delivery free with charge
FURN400 = Complaint order
Number of the packing piece
Restrictions on partial delivery
Code list:
X2 = Partial delivery with subsequent delivery allowed
X1 = Partial delivery without subsequent delivery allowed
144 = KPartial delivery disallowed
Type of payment
Way of payment
Point of Sale (Identification by GLN possible)
Flag how to process the Position especially in the ORDCHG - Please refer to the Anwendungsempfehlung
Head = 1: Cancellation of the total order - all positions are canceled
Head = 4: Message contains changed information on header or positions - All positions or only positions with changes could be transmitted
Head = 5: Replacement. All positions will be transmitted. Accurate image of the new order
Head = 20: Change in Head: Changes only in delivery date or delivery location
Use the following codes for the Position Function Symbol
1 = Position added (valid if HEAD = 4)
2 = Position canceled (valid if HEAD = 1,4)
3 = Position modified (valid if HEAD = 4,5)
11 = Position unmodified (valid if HEAD = 4,20)
Prepaid amount on position
Codes for definition of pricetypes
Code list:
AAA = Net price
AAB = Gross price
INF = Imformation only. not billed
 
Identification of the promotion
Information whether a product is variable in quantity
Code list:
VQ = yes
= no
Code for definition of the type of a quantity
Code list:
12 = Delivered quantity
21 = ordered quantity
35 = Price calculation quantity
47 = Billed quantity
53 = Minimum order quantity
54 = Maximum order quantity
131 = confirmed order quantity
129 = Units per unit price
131 = Delivered quantity
182 = canceled quantity
Number of the remittance advise
Serial Number
Mark in the shipped package
Type of stack
Tax Identification number
Technical partner of the document (GLN)
Number of the Cash register
Code for deinition of a total document amount
Code list:
22 = Cash on delivery amount
44 = Delivery value
77 = Total Invoice amount = 125+124
79 = Sum of all Net Line Amounts = (Type 66)
86 = Total document amount = 125+124-113
131 = Sum of all charges and allowances
125 = Taxable amount = 79 - 131
124 = Sum of all taxes
113 = Sum of all prepayments
Number of the (delivery) tour
Type of packaging
GS1: http://www.gs1.se/eancom_2002/ean02s4/user/part3/dc8m.htm
Code list:
09= Pallet that must be returned
201= Euro pallet
CT=carton
PK=Package generaln
type of product
Code list:
BA = Basic product doe variant definition
TU = Trading unit
NO = Nor order product, Packaging, Service
PR1 = Bonus Pack - not ordered but delivered and not billed
NDU = No delivery unit
FMD = Article of another manufacturer
SER = Service
type and reason for a quantity deviation
Type of shipping mark SSCC
Code list:
BJ = NVE
Conditions fpr transport
Code list:
5 = Standard
12 = Special agreements
type of the goods in transport
Codeliste:
12 = Standard
11 = Dangerous goods
Transport Services
Code list:
5 = Standard: The cargo has to be delivered as instructed
20 = Retrieval
37 = assembly service
59 = 2 Men Handling
?? = 4 Men Handling
Transport Geschwindigkeit
Codeliste:
1 = Express
2 = High Speed
3 = Standard
4 = according to contract with the carrier
Unit
Sales tax identification number
Tax rate
workflow instructions referencing to the starting point: order message
D = Drop Shipping to an endconsumer. Delivery address in NAD + UC
L = Lagerauftrag. Delivery to a stock. Delivery address in NAD + DP
CD= Crossdocking. Delivery to a crossdocing stock. Delivery address in NAD + DP
Number at Zentralregulierer