Amazon invoices
TransdatiX.Convert Amazon invoices
Version 2.0.1 of 2008-08-04
Content
General
Converts XML or CSV files to a EDIFACT D.96A INVOIC file for Amazon.
How to start the Converter
To use this TransdatiX.Convert you first have to export your outbound data to CSV- or XML-file(s). All you need to prepare your data for this converter can be found here (this document is currently only available in german).Then you have various possibilities to start the TransdatiX.Convert, e.g. by defining a process, in which you also include a TransdatiX.Comm to automate conversion and transmission. More information on the TransdatiX.Configurator as well as further automation technologies can be found here (this document is currently only available in german).
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 of file |
| Message | Root element of 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 |
| Invoice | Invoice head |
| MessageID | Internal distinct code |
| InvoiceID | Internal invoice number |
| Type | Type of message |
| Status | Record type |
| Function | Function |
| Number | Invoice number |
| Date | Invoice date |
| DeliveryDate | Delivery date |
| TaxPointDate | Tax point date |
| FreeText1 | Free text information |
| FreeText2 | Free text information |
| FreeText3 | Free text information |
| OrderNumber | Order number |
| OrderDate | Date of order |
| DeliveryNoteNumber | Number of delivery note |
| DeliveryNoteDate | Date of delivery note |
| BuyerGLN | Buyer's GLN |
| BuyerName1 | Buyer's name (1st line) |
| BuyerName2 | Buyer's name (2nd line) |
| BuyerName3 | Buyer's name (3rd line) |
| BuyerName4 | Buyer's name (4th line) |
| BuyerName5 | Buyer's name (5th line) |
| BuyerName6 | Buyer's name (6th line) |
| 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 |
| SupplierName1 | Supplier's name (1st line) |
| SupplierName2 | Supplier's name (2nd line) |
| SupplierName3 | Supplier's name (3rd line) |
| SupplierName4 | Supplier's name (4th line) |
| SupplierName5 | Supplier's name (5th line) |
| SupplierName6 | Supplier's name (6th line) |
| SupplierStreet1 | Supplier's street (1st line) |
| SupplierStreet2 | Supplier's street (2nd line) |
| SupplierStreet3 | Supplier's street (3rd line) |
| SupplierStreet4 | Supplier's street (4th line) |
| SupplierCity | Supplier's city |
| SupplierZipCode | Supplier's zip code |
| SupplierRegion | Supplier's state or province |
| SupplierCountryCode | Supplier's country |
| SupplierVatRegNr | Supplier's VAT registration number |
| SupplierFiscalNumber | Supplier's fiscal number |
| DeliveryGLN | Delivery's GLN |
| DeliveryName1 | Delivery's name (1st line) |
| DeliveryName2 | Delivery's name (2nd line) |
| DeliveryName3 | Delivery's name (3rd line) |
| DeliveryName4 | Delivery's name (4th line) |
| DeliveryName5 | Delivery's name (5th line) |
| DeliveryName6 | Delivery's name (6th line) |
| DeliveryStreet1 | Delivery's street (1st line) |
| DeliveryStreet2 | Delivery's street (2nd line) |
| DeliveryStreet3 | Delivery's street (3rd line) |
| DeliveryStreet4 | Delivery's street (4th 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) |
| InvoiceeName3 | Invoicee's name (3rd line) |
| InvoiceeName4 | Invoicee's name (4th line) |
| InvoiceeName5 | Invoicee's name (5th line) |
| InvoiceeName6 | Invoicee's name (6th line) |
| InvoiceeStreet1 | Invoicee's street (1st line) |
| InvoiceeStreet2 | Invoicee's street (2nd line) |
| InvoiceeStreet3 | Invoicee's street (3rd line) |
| InvoiceeStreet4 | Invoicee's street (4th 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 |
| PaymentDays | Time for payment in days |
| CashDiscountPercentage | Cash discount percentage |
| TotalAmount | Invoice amount |
| InvoiceCharge | Invoice's charges and allowances |
| MessageID | Internal distinct code |
| InvoiceID | Internal invoice number |
| Status | Type of charge or allowance |
| Qualifier | Type of charge or allowance |
| Amount | Amount |
| InvoiceTax | Duty/Tax/Fee details |
| MessageID | Internal distinct code |
| InvoiceID | Internal invoice number |
| Status | Type of tax |
| Qualifier | Tax code |
| Percentage | Tax percentage |
| BasisAmount | Total tax basis amount |
| Amount | Tax amount |
| InvoicePos | Invoice line item |
| MessageID | Internal distinct code |
| InvoiceID | Internal invoice number |
| InvoicePosID | Unique line number |
| Number | Line item number |
| ItemEAN | EAN item number |
| ItemUPC | UPC item number |
| ItemIdSupplier | Supplier's item number |
| ItemName | Item description |
| QuantityInvoiced | InvoicedQuantity |
| UnitInvoiced | Unit |
| NetPrice | Net price of item |
| QuantityPriceBasis | Reference quantity of price |
| UnitPriceBasis | Reference unit of price |
| NetAmount | Net amount of line item |
| OrderNumber | Referenced order number |
| OrderDate | Date of referenced order number |
| DeliveryNoteNumber | Referenced delivery note number |
| DeliveryNoteDate | Date of referenced delivery note |
| InvoicePosTax | Duty/Tax/Fee details |
| MessageID | Internal distinct code |
| InvoiceID | Internal invoice number |
| InvoicePosID | Unique line number |
| Status | Type of tax |
| Qualifier | Tax code |
| Percentage | VAT percentage |
| BasisAmount | Tax basis amount |
| Amount | Tax amount |
| Data group | Message | - | Root element of message |
Root element of 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: no
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 | Invoice | - | Invoice head |
Invoice head
MessageID - Key field
Format: alphanumeric
Hint: Internal distinct code
InvoiceID - Key field
Format: alphanumeric
Hint: Internal invoice number
Type - Required field: yes
Possible values:
| INVOIC | = | Invoice |
Status - Required field: yes
Possible values:
| 380 | = | Comercial invoice |
Function - Required field: yes
Possible values:
| 7 | = | Duplicate |
| 9 | = | Original |
| 43 | = | Additional transmission Message already transmitted via another communication channel. This transmission is to provide electronically processable data only. |
Number - Required field: yes
Format: alphanumeric with up to 17 character(s)
Hint: Invoice number
Date - Required field: yes
Format: date
Hint: Invoice date
DeliveryDate - Required field: no
Format: date
Hint: Delivery date
TaxPointDate - Required field: no
Format: date
Hint: Tax point date
FreeText1 - Required field: no
Format: alphanumeric with up to 70 character(s)
Hint: Free text information
FreeText2 - Required field: no
Format: alphanumeric with up to 70 character(s)
Hint: Free text information
FreeText3 - Required field: no
Format: alphanumeric with up to 70 character(s)
Hint: Free text information
OrderNumber - Required field: no
Format: alphanumeric with up to 16 character(s)
Hint: Order number
OrderDate - Required field: no
Format: date
Hint: Date of order
DeliveryNoteNumber - Required field: no
Format: alphanumeric with up to 16 character(s)
Hint: Number of delivery note
DeliveryNoteDate - Required field: no
Format: date
Hint: Date of delivery note
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 (1st line)
BuyerName2 - Required field: no
Format: alphanumeric with up to 35 character(s)
Hint: Buyer's name (2nd line)
BuyerName3 - Required field: no
Format: alphanumeric with up to 35 character(s)
Hint: Buyer's name (3rd line)
BuyerName4 - Required field: no
Format: alphanumeric with up to 35 character(s)
Hint: Buyer's name (4th line)
BuyerName5 - Required field: no
Format: alphanumeric with up to 35 character(s)
Hint: Buyer's name (5th line)
BuyerName6 - Required field: no
Format: alphanumeric with up to 35 character(s)
Hint: Buyer's name (6th line)
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
SupplierName1 - Required field: yes
Format: alphanumeric with up to 35 character(s)
Hint: Supplier's name (1st line)
SupplierName2 - Required field: no
Format: alphanumeric with up to 35 character(s)
Hint: Supplier's name (2nd line)
SupplierName3 - Required field: no
Format: alphanumeric with up to 35 character(s)
Hint: Supplier's name (3rd line)
SupplierName4 - Required field: no
Format: alphanumeric with up to 35 character(s)
Hint: Supplier's name (4th line)
SupplierName5 - Required field: no
Format: alphanumeric with up to 35 character(s)
Hint: Supplier's name (5th line)
SupplierName6 - Required field: no
Format: alphanumeric with up to 35 character(s)
Hint: Supplier's name (6th line)
SupplierStreet1 - Required field: yes
Format: alphanumeric with up to 35 character(s)
Hint: Supplier's street (1st line)
SupplierStreet2 - Required field: no
Format: alphanumeric with up to 35 character(s)
Hint: Supplier's street (2nd line)
SupplierStreet3 - Required field: no
Format: alphanumeric with up to 35 character(s)
Hint: Supplier's street (3rd line)
SupplierStreet4 - Required field: no
Format: alphanumeric with up to 35 character(s)
Hint: Supplier's street (4th line)
SupplierCity - Required field: yes
Format: alphanumeric with up to 35 character(s)
Hint: Supplier's city
SupplierZipCode - Required field: yes
Format: alphanumeric with up to 9 character(s)
Hint: Supplier's zip code
SupplierRegion - Required field: no
Format: alphanumeric with up to 35 character(s)
Hint: Supplier's state or province
SupplierCountryCode - Required field: yes
Format: alphanumeric with up to 3 character(s)
Hint: Supplier's country
SupplierVatRegNr - Required field: yes
Format: alphanumeric with up to 35 character(s)
Hint: Supplier's VAT registration number
SupplierFiscalNumber - Required field: no
Format: alphanumeric with up to 35 character(s)
Hint: Supplier's fiscal number
DeliveryGLN - Required field: no
Format: alphanumeric with up to 35 character(s)
Hint: Delivery's GLN
Note: DeliveryGLN, DeliveryName1, DeliveryStreet1, DeliveryCity, DeliveryCountryCode and DeliveryZipCode must be given or omitted together
DeliveryName1 - Required field: no
Format: alphanumeric with up to 35 character(s)
Hint: Delivery's name (1st line)
Note: DeliveryGLN, DeliveryName1, DeliveryStreet1, DeliveryCity, DeliveryCountryCode and DeliveryZipCode must be given or omitted together
DeliveryName2 - Required field: no
Format: alphanumeric with up to 35 character(s)
Hint: Delivery's name (2nd line)
DeliveryName3 - Required field: no
Format: alphanumeric with up to 35 character(s)
Hint: Delivery's name (3rd line)
DeliveryName4 - Required field: no
Format: alphanumeric with up to 35 character(s)
Hint: Delivery's name (4th line)
DeliveryName5 - Required field: no
Format: alphanumeric with up to 35 character(s)
Hint: Delivery's name (5th line)
DeliveryName6 - Required field: no
Format: alphanumeric with up to 35 character(s)
Hint: Delivery's name (6th line)
DeliveryStreet1 - Required field: no
Format: alphanumeric with up to 35 character(s)
Hint: Delivery's street (1st line)
Note: DeliveryGLN, DeliveryName1, DeliveryStreet1, DeliveryCity, DeliveryCountryCode and DeliveryZipCode must be given or omitted together
DeliveryStreet2 - Required field: no
Format: alphanumeric with up to 35 character(s)
Hint: Delivery's street (2nd line)
DeliveryStreet3 - Required field: no
Format: alphanumeric with up to 35 character(s)
Hint: Delivery's street (3rd line)
DeliveryStreet4 - Required field: no
Format: alphanumeric with up to 35 character(s)
Hint: Delivery's street (4th line)
DeliveryCity - Required field: no
Format: alphanumeric with up to 35 character(s)
Hint: Delivery's city
Note: DeliveryGLN, DeliveryName1, DeliveryStreet1, DeliveryCity, DeliveryCountryCode and DeliveryZipCode must be given or omitted together
DeliveryZipCode - Required field: no
Format: alphanumeric with up to 9 character(s)
Hint: Delivery's zip code
Note: DeliveryGLN, DeliveryName1, DeliveryStreet1, DeliveryCity, DeliveryCountryCode and DeliveryZipCode must be given or omitted together
DeliveryRegion - Required field: no
Format: alphanumeric with up to 35 character(s)
Hint: Delivery's state or province
DeliveryCountryCode - Required field: no
Format: alphanumeric with up to 3 character(s)
Hint: Delivery's country
Note: DeliveryGLN, DeliveryName1, DeliveryStreet1, DeliveryCity, DeliveryCountryCode and DeliveryZipCode must be given or omitted together
InvoiceeGLN - Required field: no
Format: alphanumeric with up to 35 character(s)
Hint: Invoicee's GLN
Note: InvoiceeGLN, InvoiceeName1, InvoiceeStreet1, InvoiceeCity, InvoiceeCountryCode and InvoiceeZipCode must be given or omitted together
InvoiceeName1 - Required field: no
Format: alphanumeric with up to 35 character(s)
Hint: Invoicee's name (1st line)
Note: InvoiceeGLN, InvoiceeName1, InvoiceeStreet1, InvoiceeCity, InvoiceeCountryCode and InvoiceeZipCode must be given or omitted together
InvoiceeName2 - Required field: no
Format: alphanumeric with up to 35 character(s)
Hint: Invoicee's name (2nd line)
InvoiceeName3 - Required field: no
Format: alphanumeric with up to 35 character(s)
Hint: Invoicee's name (3rd line)
InvoiceeName4 - Required field: no
Format: alphanumeric with up to 35 character(s)
Hint: Invoicee's name (4th line)
InvoiceeName5 - Required field: no
Format: alphanumeric with up to 35 character(s)
Hint: Invoicee's name (5th line)
InvoiceeName6 - Required field: no
Format: alphanumeric with up to 35 character(s)
Hint: Invoicee's name (6th line)
InvoiceeStreet1 - Required field: no
Format: alphanumeric with up to 35 character(s)
Hint: Invoicee's street (1st line)
Note: InvoiceeGLN, InvoiceeName1, InvoiceeStreet1, InvoiceeCity, InvoiceeCountryCode and InvoiceeZipCode must be given or omitted together
InvoiceeStreet2 - Required field: no
Format: alphanumeric with up to 35 character(s)
Hint: Invoicee's street (2nd line)
InvoiceeStreet3 - Required field: no
Format: alphanumeric with up to 35 character(s)
Hint: Invoicee's street (3rd line)
InvoiceeStreet4 - Required field: no
Format: alphanumeric with up to 35 character(s)
Hint: Invoicee's street (4th line)
InvoiceeCity - Required field: no
Format: alphanumeric with up to 35 character(s)
Hint: Invoicee's city
Note: InvoiceeGLN, InvoiceeName1, InvoiceeStreet1, InvoiceeCity, InvoiceeCountryCode and InvoiceeZipCode must be given or omitted together
InvoiceeZipCode - Required field: no
Format: alphanumeric with up to 9 character(s)
Hint: Invoicee's zip code
Note: InvoiceeGLN, InvoiceeName1, InvoiceeStreet1, InvoiceeCity, InvoiceeCountryCode and InvoiceeZipCode must be given or omitted together
InvoiceeRegion - Required field: no
Format: alphanumeric with up to 35 character(s)
Hint: Invoicee's state or province
InvoiceeCountryCode - Required field: no
Format: alphanumeric with up to 3 character(s)
Hint: Invoicee's country
Note: InvoiceeGLN, InvoiceeName1, InvoiceeStreet1, InvoiceeCity, InvoiceeCountryCode and InvoiceeZipCode must be given or omitted together
InvoiceeVatRegNr - Required field: yes
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 the currency (3 chars)
PaymentDays - Required field: yes
Format: integer
Hint: Time for payment in days
CashDiscountPercentage - Required field: no
Format: decimal
Hint: Cash discount percentage
TotalAmount - Required field: yes
Format: decimal
Hint: Invoice amount
Invoice gross amount considering all charges, allowances and taxes
| Data group | InvoiceCharge | - | Invoice's charges and allowances |
Invoice's charges and allowances
MessageID - Key field
Format: alphanumeric
Hint: Internal distinct code
InvoiceID - Key field
Format: alphanumeric
Hint: Internal invoice number
Status - Required field: yes
Possible values:
| C | = | Charge for the whole invoice |
Qualifier - Required field: yes
Possible values:
| DI | = | Discount |
| FC | = | Freight charge |
| PC | = | Packing |
| SH | = | Special handling service |
Amount - Required field: yes
Format: decimal
Hint: Amount
Charge or allowance amount
| Data group | InvoiceTax | - | Duty/Tax/Fee details |
Duty/Tax/Fee details
MessageID - Key field
Format: alphanumeric
Hint: Internal distinct code
InvoiceID - Key field
Format: alphanumeric
Hint: Internal invoice number
Status - Required field: no
Possible values:
| 6 | = | Duty |
| 7 | = | Tax (default) |
Qualifier - Required field: no
Possible values:
| VAT | = | VAT |
Percentage - Required field: yes
Format: decimal
Hint: Tax percentage
BasisAmount - Required field: no
Format: decimal
Hint: Total tax basis amount
Tax basis amount corresponding to the given percentage
Amount - Required field: no
Format: decimal
Hint: Tax amount
Tax amount of invoice corresponding to the given percentage
| Data group | InvoicePos | - | Invoice line item |
Invoice line item
MessageID - Key field
Format: alphanumeric
Hint: Internal distinct code
InvoiceID - Key field
Format: alphanumeric
Hint: Internal invoice number
InvoicePosID - Key field
Format: alphanumeric
Hint: Unique line number
Number - Required field: yes
Format: integer
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
ItemName - Required field: no
Format: alphanumeric with up to 35 character(s)
Hint: Item description
QuantityInvoiced - Required field: yes
Format: decimal
Hint: InvoicedQuantity
UnitInvoiced - Required field: no
Format: alphanumeric with up to 3 character(s)
Hint: Unit
NetPrice - Required field: yes
Format: decimal
Hint: Net price of item
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
NetAmount - Required field: yes
Format: decimal
Hint: Net amount of line item
OrderNumber - Required field: yes
Format: alphanumeric ***
Hint: Referenced order number
OrderDate - Required field: no
Format: date
Hint: Date of referenced order number
DeliveryNoteNumber - Required field: no
Format: alphanumeric ***
Hint: Referenced delivery note number
DeliveryNoteDate - Required field: no
Format: date
Hint: Date of referenced delivery note
| Data group | InvoicePosTax | - | Duty/Tax/Fee details |
Duty/Tax/Fee details
MessageID - Key field
Format: alphanumeric
Hint: Internal distinct code
InvoiceID - Key field
Format: alphanumeric
Hint: Internal invoice number
InvoicePosID - Key field
Format: alphanumeric
Hint: Unique line number
Status - Required field: no
Possible values:
| 7 | = | Tax (default) |
Qualifier - Required field: no
Possible values:
| VAT | = | VAT (default) |
Percentage - Required field: yes
Format: decimal
Hint: VAT percentage
BasisAmount - Required field: no
Format: decimal
Hint: Tax basis amount
Amount - Required field: no
Format: decimal
Hint: Tax 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-08-06, 00:12:08