Amazon Orders
TransdatiX.Convert Amazon Orders
Version 2.0.1 of 2008-07-28
Content
General
Converts orders of Amazon in EDIFACT D.96A ORDERS format into XML or CSV files.
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).
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 distinct code |
| Envelope | Nachricht |
| MessageID | Reference to MessageID in data group Message |
| SenderId | Sender identification |
| SenderIdType | Sender identification code qualifier |
| RecipientId | Recipient identification |
| RecipientIdType | Recipient identification code qualifier |
| TransmissionId | Interchange control reference |
| TestFlag | Test indicator |
| Order | Order head |
| MessageID | Reference to MessageID in data group Message |
| OrderID | Internal distinct code |
| Type | Type of message |
| Status | Order type |
| Number | Order number |
| Date | Order date |
| EarliestDeliveryDate | Earliest delivery Date requested |
| LatestDeliveryDate | Latest delivery Date requested |
| AccountNumber | Account number |
| PromotionalDealNumber | Promotional deal number |
| BuyerGLN | Buyer's GLN |
| BuyerName1 | Buyer's name |
| BuyerStreet1 | Buyer's street (1st line) |
| BuyerStreet2 | Buyer's street (2nd line) |
| BuyerStreet3 | Buyer's street (3rd line) |
| BuyerStreet4 | Buyer's street (4th line) |
| BuyerCity | Buyer's city |
| BuyerZipCode | Buyer's zip code |
| BuyerRegion | Buyer's state or province |
| BuyerCountryCode | Buyer's country |
| SupplierGLN | Supplier's GLN |
| DeliveryGLN | Delivery's GLN |
| DeliveryName1 | Delivery's name |
| DeliveryStreet1 | Delivery's street (1st line) |
| DeliveryStreet2 | Delivery's street (2nd line) |
| DeliveryCity | Delivery's city |
| DeliveryZipCode | Delivery's zip code |
| DeliveryRegion | Delivery's state or province |
| DeliveryCountryCode | Delivery's country |
| InvoiceeGLN | Invoicee's GLN |
| InvoiceeName1 | Invoicee's name (1st line) |
| InvoiceeName2 | Invoicee's name (2nd line) |
| InvoiceeStreet1 | Invoicee's street (1st line) |
| InvoiceeStreet2 | Invoicee's street (2nd line) |
| InvoiceeCity | Invoicee's city |
| InvoiceeZipCode | Invoicee's zip code |
| InvoiceeRegion | Invoicee's state or province |
| InvoiceeCountryCode | Invoicee's country |
| InvoiceeVatRegNr | Invoicee's VAT registration number |
| Currency | Currency |
| Pos | Order lines |
| MessageID | Referenz to MessageID in data group Message |
| OrderID | Referenz to OrderID in data group Order |
| PosID | Internal distinct code |
| Number | Line item number |
| ItemEAN | EAN item number |
| ItemUPC | UPC item number |
| ItemIdSupplier | Supplier's item number |
| Quantity | Ordered quantity |
| NetPrice | |
| Data group | Message | - | Message |
Message
MessageID - Key field
Format: alphanumeric
Hint: Internal distinct code
| Data group | Envelope | - | Nachricht |
Nachricht
MessageID - Key field
Format: alphanumeric
Hint: Reference to MessageID in data group Message
SenderId - Required field: yes
Format: alphanumeric with up to 13 character(s)
Hint: Sender identification
SenderIdType - Required field: yes
Possible values:
| 14 | = | EAN (European Article Numbering Association) |
RecipientId - Required field: yes
Format: alphanumeric with up to 13 character(s)
Hint: Recipient identification
RecipientIdType - Required field: yes
Possible values:
| 14 | = | EAN (European Article Numbering Association) |
TransmissionId - Required field: yes
Format: alphanumeric
Hint: Interchange control reference
Unique reference assigned by the sender to an interchange.
TestFlag - Required field: no
Possible values:
| 0 | = | No Test If not available (=production) |
| 1 | = | Test |
Indication that the interchange is a test.
| Data group | Order | - | Order head |
Order head
Contains the data of the order head
MessageID - Key field
Format: alphanumeric
Hint: Reference to MessageID in data group Message
OrderID - Key field
Format: alphanumeric
Hint: Internal distinct code
Type - Required field: yes
Possible values:
| ORDERS | = | Order |
Status - Required field: yes
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
EarliestDeliveryDate - Required field: no
Format: date
Hint: Earliest delivery Date requested
LatestDeliveryDate - Required field: no
Format: date
Hint: Latest delivery Date requested
AccountNumber - Required field: no
Format: alphanumeric with up to 35 character(s)
Hint: Account number
Identification number of an account
The account number is provided by the supplier. This account number identifies the order type, e.g. firstorder (items in stock) or backorder (items on backorder) resp. time-outs for deliveries (deliveries must arrive at the Amazon warehouse upon an agreed time).
PromotionalDealNumber - Required field: no
Format: alphanumeric with up to 35 character(s)
Hint: Promotional deal number
Number assigned by a vendor to a special promotion activity
The promotion deal number is provided by the Amazon buyer. This promotion deal number identifies an ID agreed between both parties (Amazon / Supplier)
BuyerGLN - Required field: yes
Format: alphanumeric with up to 13 character(s)
Hint: Buyer's GLN
BuyerName1 - Required field: yes
Format: alphanumeric with up to 35 character(s)
Hint: Buyer's name
BuyerStreet1 - Required field: yes
Format: alphanumeric with up to 35 character(s)
Hint: Buyer's street (1st line)
BuyerStreet2 - Required field: no
Format: alphanumeric with up to 35 character(s)
Hint: Buyer's street (2nd line)
BuyerStreet3 - Required field: no
Format: alphanumeric with up to 35 character(s)
Hint: Buyer's street (3rd line)
BuyerStreet4 - Required field: no
Format: alphanumeric with up to 35 character(s)
Hint: Buyer's street (4th line)
BuyerCity - Required field: yes
Format: alphanumeric with up to 35 character(s)
Hint: Buyer's city
BuyerZipCode - Required field: yes
Format: alphanumeric with up to 9 character(s)
Hint: Buyer's zip code
BuyerRegion - Required field: no
Format: alphanumeric with up to 35 character(s)
Hint: Buyer's state or province
BuyerCountryCode - Required field: yes
Format: alphanumeric with up to 3 character(s)
Hint: Buyer's country
SupplierGLN - Required field: yes
Format: alphanumeric with up to 35 character(s)
Hint: Supplier's GLN
DeliveryGLN - Required field: yes
Format: alphanumeric with up to 35 character(s)
Hint: Delivery's GLN
DeliveryName1 - Required field: yes
Format: alphanumeric with up to 35 character(s)
Hint: Delivery's name
DeliveryStreet1 - Required field: yes
Format: alphanumeric with up to 35 character(s)
Hint: Delivery's street (1st line)
DeliveryStreet2 - Required field: no
Format: alphanumeric with up to 35 character(s)
Hint: Delivery's street (2nd line)
DeliveryCity - Required field: yes
Format: alphanumeric with up to 35 character(s)
Hint: Delivery's city
DeliveryZipCode - Required field: yes
Format: alphanumeric with up to 9 character(s)
Hint: Delivery's zip code
DeliveryRegion - Required field: no
Format: alphanumeric with up to 35 character(s)
Hint: Delivery's state or province
DeliveryCountryCode - Required field: yes
Format: alphanumeric with up to 3 character(s)
Hint: Delivery's country
InvoiceeGLN - Required field: yes
Format: alphanumeric with up to 35 character(s)
Hint: Invoicee's GLN
InvoiceeName1 - Required field: yes
Format: alphanumeric with up to 35 character(s)
Hint: Invoicee's name (1st line)
InvoiceeName2 - Required field: no
Format: alphanumeric with up to 35 character(s)
Hint: Invoicee's name (2nd line)
InvoiceeStreet1 - Required field: no
Format: alphanumeric with up to 35 character(s)
Hint: Invoicee's street (1st line)
InvoiceeStreet2 - Required field: no
Format: alphanumeric with up to 35 character(s)
Hint: Invoicee's street (2nd line)
InvoiceeCity - Required field: yes
Format: alphanumeric with up to 35 character(s)
Hint: Invoicee's city
InvoiceeZipCode - Required field: yes
Format: alphanumeric with up to 9 character(s)
Hint: Invoicee's zip code
InvoiceeRegion - Required field: no
Format: alphanumeric with up to 35 character(s)
Hint: Invoicee's state or province
InvoiceeCountryCode - Required field: yes
Format: alphanumeric with up to 3 character(s)
Hint: Invoicee's country
InvoiceeVatRegNr - Required field: no
Format: alphanumeric with up to 35 character(s)
Hint: Invoicee's VAT registration number
Additional information for multinational vendor setups. If you are shipping to JP, US or CA, you will not receive a VAT number of the bill-to entitiy of JP, US or CA. This is only applicable for European setups.
Currency - Required field: yes
Format: alphanumeric with up to 3 character(s)
Hint: Currency
ISO code of order currency
| Data group | Pos | - | Order lines |
Order lines
MessageID - Key field
Format: alphanumeric
Hint: Referenz to MessageID in data group Message
OrderID - Key field
Format: alphanumeric
Hint: Referenz to OrderID in data group Order
PosID - Key field
Format: alphanumeric
Hint: Internal distinct code
Number - Required field: yes
Format: alphanumeric with up to 6 character(s)
Hint: Line item number
ItemEAN - Required field: no
Format: alphanumeric with up to 35 character(s)
Hint: EAN item number
ItemUPC - Required field: no
Format: alphanumeric with up to 35 character(s)
Hint: UPC item number
ItemIdSupplier - Required field: no
Format: alphanumeric with up to 35 character(s)
Hint: Supplier's item number
Quantity - Required field: yes
Format: decimal
Hint: Ordered quantity
NetPrice - Required field: yes
Format: decimal
Hint:
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-08-06, 00:12:45