EDIFACT Data Mapping
In order for your invoice data to be supported without custom mapping for the EDIFACT standard, it should match the following expectations of where the information is found.
The EDIFACT versions supported are D96A and D97A. The data fields for a simple invoice are the same for the D96A and D97A versions. The following table shows where the invoice information is found in each version:
| Information for the: | Should be in this data element of the EDI source: | Qualifiers used | Mandatory or Conditional (M or C) |
|---|---|---|---|
| Invoice number | BGM01.4 (INVOICE NUMBER) | none | M |
| Invoice label | RFF01.2 | RFF01.1 = “ON” | M |
| Invoice date | DTM01.2 | DTM01.1 = “137” | M |
| Supplier VAT ID | RFF01.2 (ID CODE) | NAD01 = any of the following: SU (supplier) SE (seller) FH (seller as officially registered) OS (original shipper) SCO (supplier's corporate office) and RFF01.1 = any of the following: VX (value added tax registration number -Europe) 4G (Provincial tax identification) 4O (Canadian Goods & Services or Quebec Sales Tax Reference number) GT (Goods & Services Tax Registration Number) |
M |
| Supplier name | NAD02.1 (NAME) | NAD01 = any of: SU (supplier) SE (seller) FH (seller as officially registered) OS (original shipper) SCO (supplier's corporate office) |
M |
| Supplier address | NAD03.1 (ADDRESS) | NAD01 = any of: SU (supplier) SE (seller) FH (seller as officially registered) OS (original shipper) SCO (supplier's corporate office) |
M |
| Buyer VAT ID | REF01.2 (ID CODE) | NAD01 = any of BY (buyer) FG (buyer as officially registered) FD (buyer's parent company) BCO (buyer's corporate office) OY (ordering customer) UD (ultimate customer) and RFF01.1 = any of VX (value added tax registration number -Europe) 4G (Provincial tax identification) 4O (Canadian Goods & Services or Quebec Sales Tax Reference number) GT (Goods & Services Tax Registration Number) |
M |
| Buyer name | NAD02.1 (NAME) | NAD01 = any of BY (buyer) FG (buyer as officially registered) FD (buyer's parent company) BCO (buyer's corporate office) OY (ordering customer) UD (ultimate customer) |
M |
| Buyer address | NAD03.1 (ADDRESS) | NAD01 = any of BY (buyer) FG (buyer as officially registered) FD (buyer's parent company) BCO (buyer's corporate office) OY (ordering customer) UD (ultimate customer) |
M |
| Currency | CUX01.2 (CURRENCY CODE) | none | M |
| Language | none | none | M |
| Subtotal | MOA01.2 | MOA01.1 = “125” | M |
| Total tax due | MOA01.2 | MOA01.1 = “124” | M |
| Supplier COMM_ID | UNB02.1 | none | M |
| Total amount due | MOA01.2 | MOA01.1 = “128” | M |
| Late payment penalty | PCD01.2 | PCD01.1 = “15” | M |
| Payment term | N/A | none | C |
| Credit note label | UNH02.4 (Controlling Agency) | none | M |
| Original invoice reference ID | N/A | none | M |
| Original invoice date | N/A | none | M |
| Period of reference | UNH02.4 (Controlling Agency) | none | M |
| Credit reason | N/A | none | M |
| Item description | LIN03.1 (EAN) | none | M |
| Quantity invoiced | QTY01.2 | QTY01.1 = “47” | M |
| Unit price | PRI01.5 | PRI01.1 = “AAB” | M |
| Discount | PRI01.2 | PRI01.1 = “02G” | M |
| VAT rate (percentage) | TAX05.4 | TAX01 = “VAT” | M |
| VAT tax amount | PRI01.5 | Map PRI01.5 (where PRI01.1 = “AAB” {Net}) - PRI01.5 (where PRI01.1 = “AAB” {Gross}) | M |
| VAT amount payable | PRI01.5 | Map PRI01.5 (where PRI01.1 = “AAB” {Net}) - PRI01.5 (where PRI01.1 = “AAB” {Gross}) | M |
| VAT description | TAX02.4 | TAX = “VAT” | M |
| Tax law reference | N/A | none | M |
| Supply date | N/A | none | M |
| Pay date | N/A | none | M |