Billa Bulgaria Orders
TransdatiX.Convert Billa Bulgaria Orders
Version 2.0.0 from 2006-12-18
Content
General
With this converter Orders from Billa Bulgaria in EDIFACT-format can be converted 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 Billa Bulgaria 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 |
| Function | Message Function |
| Number | Order Number |
| Date | Order Date |
| DeliveryDate | Delivery Date requested |
| FreeTextStatus | Type of free text information |
| FreeText1 | Free Text |
| FreeText2 | Free Text |
| FreeText3 | Free Text |
| FreeText4 | Free Text |
| FreeText5 | Free Text |
| BlanketOrderNumber | Number of the blanket order |
| PromotionalDealNumber | Number assigned by a vendor to a special promotion activity |
| BuyerGLN | The Buyer's GLN |
| SupplierGLN | The Supplier's GLN |
| DeliveryGLN | GLN of party to which goods should be delivered |
| UltimateCustomerGLN | GLN of the Ultimate Customer |
| OrderedByGLN | GLN of the party who issued an order (if different from Buyer) |
| InvoiceeGLN | GLN of the party to whom the invoice should be issued (if different from Buyer) |
| Currency | Currency |
| CashDiscountPercentage | Cash Discount Percentage |
| TransportMode | Mode of Transport |
| TransportMedium | Type of means of transport |
| TransportTermsFunction | Terms of delivery or transport |
| TransportTerms | Delivery terms |
| 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 |
| ItemEANCustomer | EAN of article |
| ItemIdSupplier | Supplier's article number |
| ItemIdBuyer | Buyer's asrticle number |
| ItemName | Article text |
| ItemName2 | Article text 2 |
| Quantity | Order quantity |
| Unit | Order Unit |
| DeliveryDate | requested date of delivery |
| MinimumShelfLifeRequested | Requested minimum shelf life |
| FreeTextStatus | Type of text information |
| FreeText1 | Free Text |
| FreeText2 | Free Text |
| FreeText3 | Free Text |
| FreeText4 | Free Text |
| FreeText5 | Free Text |
| NetPrice | Net price |
| QuantityPriceBasis | Reference quantity of price |
| UnitPriceBasis | Reference unit of price |
| DeliveryGLN | GLN of delivery party |
| 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 |
| Percentage | Percentage |
| Amount | Amount |
| UnitRate | Rate per unit |
| UnitRatePriceBasis | Reference unit for the rate per unit |
| 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 |
| 50E | = | Cross Docking Order |
| 224 | = | Rush Order |
| 226 | = | Call Off Order |
Function - Required field: no
Possible values:
| 9 | = | Original |
| 42 | = | Confirmation Message confirming a transaction previously agreed via other means (e.g. phone). |
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: no
Format: date
Hint: Delivery Date requested
FreeTextStatus - Required field: no
Possible values:
| AKT | = | Promotion |
| BES | = | Confirmation |
| ERS | = | Initial Order |
| MAR | = | Store Opening |
| MUS | = | Sample |
| NOR | = | Normal |
| SAM | = | Collected |
| SON | = | Special |
FreeText1 - Required field: no
Format: alphanumeric with up to 70 character(s)
Hint: Free Text
FreeText2 - Required field: no
Format: alphanumeric with up to 70 character(s)
Hint: Free Text
FreeText3 - Required field: no
Format: alphanumeric with up to 70 character(s)
Hint: Free Text
FreeText4 - Required field: no
Format: alphanumeric with up to 70 character(s)
Hint: Free Text
FreeText5 - Required field: no
Format: alphanumeric with up to 70 character(s)
Hint: Free Text
BlanketOrderNumber - Required field: no
Format: alphanumeric with up to 35 character(s)
Hint: Number of the blanket order
PromotionalDealNumber - Required field: no
Format: alphanumeric with up to 35 character(s)
Hint: Number assigned by a vendor to a special promotion activity
BuyerGLN - Required field: yes
Format: alphanumeric with up to 13 character(s)
Hint: The Buyer's GLN
SupplierGLN - Required field: yes
Format: alphanumeric with up to 13 character(s)
Hint: The Supplier's GLN
DeliveryGLN - Required field: yes
Format: alphanumeric with up to 13 character(s)
Hint: GLN of party to which goods should be delivered
UltimateCustomerGLN - Required field: no
Format: alphanumeric with up to 13 character(s)
Hint: GLN of the Ultimate Customer
OrderedByGLN - Required field: no
Format: alphanumeric with up to 13 character(s)
Hint: GLN of the party who issued an order (if different from Buyer)
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 Buyer)
Currency - Required field: no
Format: alphanumeric with up to 3 character(s)
Hint: Currency
ISO-Code of Order Currency
CashDiscountPercentage - Required field: no
Format: decimal
Hint: Cash Discount Percentage
TransportMode - Required field: no
Possible values:
| 20 | = | Rail transport |
| 30 | = | Road transport |
| 50 | = | Mail |
| 100 | = | Courier service |
TransportMedium - Required field: no
Possible values:
| 25 | = | Rail express |
| 34 | = | Road parcel express |
| 51 | = | Parcel post |
| 53 | = | Surface mail |
| 55 | = | Air mail |
| 31 | = | Truck |
TransportTermsFunction - Required field: no
Possible values:
| 4 | = | Collected by customer |
| 10E | = | Delivered by supplier |
TransportTerms - Required field: no
Format: alphanumeric with up to 3 character(s)
Hint: Delivery terms
INCOTERMS
| 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
ItemEANCustomer - Required field: yes
Format: alphanumeric with up to 13 character(s)
Hint: 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 asrticle number
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
DeliveryDate - Required field: no
Format: date
Hint: requested date of delivery
MinimumShelfLifeRequested - Required field: no
Format: integer
Hint: Requested minimum shelf life
For perishable products the Buyer is able to communicate the Supplier how many days from the day of delivery on the product should be durable at minimum
FreeTextStatus - Required field: no
Possible values:
| AKT | = | Promotion |
| BES | = | Confirmation |
| ERS | = | Initial Order |
| MAR | = | Store Opening |
| MUS | = | Sample |
| NOR | = | Normal |
| SAM | = | Collected |
| SON | = | Special |
FreeText1 - Required field: no
Format: alphanumeric with up to 70 character(s)
Hint: Free Text
FreeText2 - Required field: no
Format: alphanumeric with up to 70 character(s)
Hint: Free Text
FreeText3 - Required field: no
Format: alphanumeric with up to 70 character(s)
Hint: Free Text
FreeText4 - Required field: no
Format: alphanumeric with up to 70 character(s)
Hint: Free Text
FreeText5 - 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
QuantityPriceBasis - Required field: no
Format: decimal
Hint: Reference quantity of price
Reference quantity of position (if e.g. the accounting unit is diferent from the order unit)
UnitPriceBasis - Required field: no
Format: alphanumeric with up to 3 character(s)
Hint: Reference unit of price
See QuantityPriceBasis
DeliveryGLN - Required field: no
Format: alphanumeric with up to 13 character(s)
Hint: GLN of delivery party
| 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:
| FC | = | Freight charge |
| FA | = | Freight allowance (e.g. in case of pick-up by buyer) |
| DI | = | Discount |
CalculationLevel - Required field: no
Format: integer
Hint: Calculation level
Required in case of more than one allowance or charge
Percentage - Required field: no
Format: decimal
Hint: Percentage
Amount - Required field: no
Format: decimal
Hint: Amount
UnitRate - Required field: no
Format: decimal
Hint: Rate per unit
UnitRatePriceBasis - Required field: no
Format: alphanumeric with up to 3 character(s)
Hint: Reference unit for the rate per unit
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 2007-01-06, 10:17:02