Praktiker Orders
TransdatiX.Convert Praktiker Orders
Version 2.0.1 from 2008-05-06
Content
General
This module converts EDIFACT-Orders from Praktiker Bau- und Heimwerkermärkte Holding AG to XML or CSV.
How to start the Converter
This TransdatiX.Convert converts your incoming data to the XML or CSV format as stated below. This output data then can either be directly imported by a program or delivered to a destination system by using a TransdatiX.Adapt.You can use this TransdatiX.Convert for example fully automated within a process together with a TransdatiX.Adapt which is required for your target system. Also a integrated data transmission can be realized in one process. Read more about defining processes using the TransdatiX.Configurator (this document is only available in german yet).
Hints
The converter requires the order data from Praktiker in EDIFACT-format.Two interfaces are contained for converting EDIFACT-data either to XML or CSV.
The interface ConvertToXml generates an XML output file that includes the whole data structure.
The interface ConvertToCsv generates four CSV output files:
- Envelope - Transmission Section
Contains all data of the data group Envelope - Order - Order Heading Section
Contains all data of the data group Order - Pos - Order Position Section
Contains all data of the data group Pos - PosCharge - Allowance or charge applied to the Position
Contains all data of the data group PosCharge
Structure of data - Overview
The following listing shows the formal data structure accepted by the converter. Bold descripitions means, that an element is required, excepting a term is quoted explicit within the description of the element.Element name | Description |
| Root | Root element |
| Message | Message |
| MessageID | Internal unique Identification |
| Envelope | Transmission Section |
| MessageID | Reference to MessageID in data group Message |
| SenderId | Sender |
| RecipientId | Recipient |
| MessageType | EDIFACT Message Type Identifier |
| TransmissionId | Message Reference Number |
| TestFlag | Test Indicator |
| Order | Order Heading Section |
| MessageID | Reference to MessageID in data group Message |
| OrderID | Internal unique Identification |
| Status | Order Type |
| Number | Order Number |
| Date | Order Date |
| DeliveryDate | Delivery Date requested |
| EarliestDeliveryDate | Earliest delivery Date requested |
| LatestDeliveryDate | Latest delivery Date requested |
| FreeText1 | Free delivery text |
| FreeText2 | Free delivery text |
| FreeText3 | Free delivery text |
| PromotionalDealNumber | Number assigned by a vendor to a special promotion activity |
| UltimateCustomerReferenceNumber | Ultimate customer's reference number |
| BuyerGLN | Buyer's GLN (Praktiker central office) |
| BuyerName | Buyer's name |
| BuyerStreet | Buyer's street |
| BuyerCity | Buyer's city |
| BuyerZipCode | Buyer's zip code |
| BuyerCountryCode | Buyer's country |
| SupplierGLN | Supplier's GLN |
| DeliveryGLN | GLN of the Praktiker super store to which goods should be delivered |
| DeliveryName | Delivery's name |
| DeliveryStreet | Delivery's street |
| DeliveryCity | Delivery's city |
| DeliveryZipCode | Delivery's zip code |
| DeliveryCountryCode | Delivery's country |
| UltimateCustomerName | Ultimate customer's name |
| UltimateCustomerStreet | Ultimate customer's street |
| UltimateCustomerCity | Ultimate customer's city |
| UltimateCustomerZipCode | Ultimate customer's zip code |
| UltimateCustomerCountryCode | Ultimate customer's country |
| UltimateCustomerContactTelephone | Ultimate customer's telephone number |
| InvoiceeGLN | GLN of the party to whom the invoice should be issued (if different from Delivery) |
| Currency | Currency |
| PaymentDays | Number of days when the payment should be completed |
| Pos | Order Detail Section |
| MessageID | Reference to MessageID in data group Message |
| OrderID | Reference to OrderID in data group Order |
| PosID | Internal unique Identification |
| Number | Position number |
| ItemEANSupplier | Supplier's EAN of article |
| ItemEANCustomer | Customer's EAN of article |
| ItemIdSupplier | Supplier's article number |
| ItemIdBuyer | Buyer's part number (Praktiker) |
| ItemName | Article text |
| ItemName2 | Article text 2 |
| Quantity | Order quantity |
| Unit | Order Unit |
| FreeText1 | Free Text |
| NetPrice | Net price |
| GrossPrice | Gross price |
| PosCharge | Position based allowances/charges |
| MessageID | Referene to MessageID in data group Message |
| OrderID | Reference to InvoiceID in data group Invoice |
| PosID | Reference to PosID in data group Pos |
| Status | Type of allowance or charge |
| Qualifier | Class of allowance or charge |
| CalculationLevel | Calculation level |
| Quantity | Discrete quantity |
| Unit | Unit of discrete quantity |
| Percentage | Percentage |
| Amount | Amount |
| Data group | Message | - | Message |
Message
MessageID - Key field
Format: alphanumeric
Hint: Internal unique Identification
| Data group | Envelope | - | Transmission Section |
Transmission Section
MessageID - Key field
Format: alphanumeric
Hint: Reference to MessageID in data group Message
SenderId - Required field: yes
Format: alphanumeric with up to 35 character(s)
Hint: Sender
Mailbox-ID of Message Sender
RecipientId - Required field: yes
Format: alphanumeric with up to 35 character(s)
Hint: Recipient
Mailbox-ID of Message Recipient
MessageType - Required field: no
Format: alphanumeric with up to 14 character(s)
Hint: EDIFACT Message Type Identifier
If a transmission includes only Messages of the same type the message type can be specified within the envelope as an information for the recipient .
TransmissionId - Required field: no
Format: alphanumeric with up to 14 character(s)
Hint: Message Reference Number
Unique Reference for the transmission generated by the sender.
TestFlag - Required field: no
Possible values:
| 1 | = | Interchange is a test |
Only used during testing period
| Data group | Order | - | Order Heading Section |
Order Heading Section
Includes the Heading Data
MessageID - Key field
Format: alphanumeric
Hint: Reference to MessageID in data group Message
OrderID - Key field
Format: alphanumeric
Hint: Internal unique Identification
Status - Required field: no
Possible values:
| 220 | = | Order |
Number - Required field: yes
Format: alphanumeric with up to 35 character(s)
Hint: Order Number
Date - Required field: yes
Format: date
Hint: Order Date
DeliveryDate - Required field: yes
Format: date
Hint: Delivery Date requested
EarliestDeliveryDate - Required field: no
Format: date
Hint: Earliest delivery Date requested
LatestDeliveryDate - Required field: no
Format: date
Hint: Latest delivery Date requested
FreeText1 - Required field: no
Format: alphanumeric with up to 70 character(s)
Hint: Free delivery text
FreeText2 - Required field: no
Format: alphanumeric with up to 70 character(s)
Hint: Free delivery text
FreeText3 - Required field: no
Format: alphanumeric with up to 70 character(s)
Hint: Free delivery text
PromotionalDealNumber - Required field: no
Format: alphanumeric with up to 35 character(s)
Hint: Number assigned by a vendor to a special promotion activity
UltimateCustomerReferenceNumber - Required field: no
Format: alphanumeric with up to 35 character(s)
Hint: Ultimate customer's reference number
If this information is provided, it is a special order for an ultimate customer
BuyerGLN - Required field: yes
Format: alphanumeric with up to 13 character(s)
Hint: Buyer's GLN (Praktiker central office)
BuyerName - Required field: no
Format: alphanumeric with up to 35 character(s)
Hint: Buyer's name
BuyerStreet - Required field: no
Format: alphanumeric with up to 35 character(s)
Hint: Buyer's street
BuyerCity - Required field: no
Format: alphanumeric with up to 35 character(s)
Hint: Buyer's city
BuyerZipCode - Required field: no
Format: alphanumeric with up to 9 character(s)
Hint: Buyer's zip code
BuyerCountryCode - Required field: no
Format: alphanumeric with up to 35 character(s)
Hint: Buyer's country
SupplierGLN - Required field: yes
Format: alphanumeric with up to 13 character(s)
Hint: Supplier's GLN
DeliveryGLN - Required field: yes
Format: alphanumeric with up to 13 character(s)
Hint: GLN of the Praktiker super store to which goods should be delivered
DeliveryName - Required field: no
Format: alphanumeric with up to 35 character(s)
Hint: Delivery's name
DeliveryStreet - Required field: no
Format: alphanumeric with up to 35 character(s)
Hint: Delivery's street
DeliveryCity - Required field: no
Format: alphanumeric with up to 35 character(s)
Hint: Delivery's city
DeliveryZipCode - Required field: no
Format: alphanumeric with up to 9 character(s)
Hint: Delivery's zip code
DeliveryCountryCode - Required field: no
Format: alphanumeric with up to 35 character(s)
Hint: Delivery's country
UltimateCustomerName - Required field: no
Format: alphanumeric with up to 35 character(s)
Hint: Ultimate customer's name
Only used if the goods should be delivered to this address
UltimateCustomerStreet - Required field: no
Format: alphanumeric with up to 35 character(s)
Hint: Ultimate customer's street
Only used if the goods should be delivered to this address
UltimateCustomerCity - Required field: no
Format: alphanumeric with up to 35 character(s)
Hint: Ultimate customer's city
Only used if the goods should be delivered to this address
UltimateCustomerZipCode - Required field: no
Format: alphanumeric with up to 9 character(s)
Hint: Ultimate customer's zip code
Only used if the goods should be delivered to this address
UltimateCustomerCountryCode - Required field: no
Format: alphanumeric with up to 35 character(s)
Hint: Ultimate customer's country
Only used if the goods should be delivered to this address
UltimateCustomerContactTelephone - Required field: no
Format: alphanumeric with up to 35 character(s)
Hint: Ultimate customer's telephone number
Only used if the goods should be delivered to this address
InvoiceeGLN - Required field: no
Format: alphanumeric with up to 13 character(s)
Hint: GLN of the party to whom the invoice should be issued (if different from Delivery)
Currency - Required field: no
Format: alphanumeric with up to 3 character(s)
Hint: Currency
ISO-Code of Order Currency
PaymentDays - Required field: no
Format: integer
Hint: Number of days when the payment should be completed
| Data group | Pos | - | Order Detail Section |
Order Detail Section
MessageID - Key field
Format: alphanumeric
Hint: Reference to MessageID in data group Message
OrderID - Key field
Format: alphanumeric
Hint: Reference to OrderID in data group Order
PosID - Key field
Format: alphanumeric
Hint: Internal unique Identification
Number - Required field: no
Format: integer
Hint: Position number
ItemEANSupplier - Required field: no
Format: alphanumeric with up to 13 character(s)
Hint: Supplier's EAN of article
ItemEANCustomer - Required field: no
Format: alphanumeric with up to 13 character(s)
Hint: Customer's EAN of article
ItemIdSupplier - Required field: no
Format: alphanumeric with up to 35 character(s)
Hint: Supplier's article number
ItemIdBuyer - Required field: no
Format: alphanumeric with up to 35 character(s)
Hint: Buyer's part number (Praktiker)
ItemName - Required field: no
Format: alphanumeric with up to 35 character(s)
Hint: Article text
ItemName2 - Required field: no
Format: alphanumeric with up to 35 character(s)
Hint: Article text 2
Quantity - Required field: yes
Format: decimal
Hint: Order quantity
Unit - Required field: no
Format: alphanumeric with up to 3 character(s)
Hint: Order Unit
FreeText1 - Required field: no
Format: alphanumeric with up to 70 character(s)
Hint: Free Text
NetPrice - Required field: no
Format: decimal
Hint: Net price
Net price per unit including allowances/charges and excluding taxes
GrossPrice - Required field: no
Format: decimal
Hint: Gross price
Gross price per unit excluding allowances/charges and excluding taxes
| Data group | PosCharge | - | Position based allowances/charges |
Position based allowances/charges
MessageID - Key field
Format: alphanumeric
Hint: Referene to MessageID in data group Message
OrderID - Key field
Format: alphanumeric
Hint: Reference to InvoiceID in data group Invoice
PosID - Key field
Format: alphanumeric
Hint: Reference to PosID in data group Pos
Status - Required field: yes
Possible values:
| A | = | Allowance |
| C | = | Charge |
Qualifier - Required field: no
Possible values:
| DI | = | Discount |
CalculationLevel - Required field: no
Format: integer
Hint: Calculation level
Required in case of more than one allowance or charge
Quantity - Required field: no
Format: decimal
Hint: Discrete quantity
Unit - Required field: no
Format: alphanumeric with up to 3 character(s)
Hint: Unit of discrete quantity
Percentage - Required field: no
Format: decimal
Hint: Percentage
Amount - Required field: no
Format: decimal
Hint: Amount
Legal notes
All information contained in this document is provided without any whatsoever guarantees. TransdatiX expressly refuses all liability claims, explicit or implicit, including claims regarding suitability for selling or specific purpose. In no case TransdatiX or one of its suppliers can be held responsible for any damages, occuring direct or indirect, quite accidentally or as a consequential damage. Especially business losses, data losses or special damages are excluded explicitly from liability, even if TransdatiX or its suppliers pointed to the possibility of such damages. In any case liability claims are rejected to the legal highest possible dimension.
© 2002 - 2007 TransdatiX Software
Generated automatically 2008-05-06, 15:52:25