Question & Answer
Question
EDIFACT Data Mapping
Answer
EDIFACT Data Mapping
In order for your invoice data to be supported withoutcustom mapping for the EDIFACT standard it should match the followingexpectations of where the information is found.
The EDIFACT versions supported are D96A and D97A. Thedata fields for a simple invoice are the same for the D96A and D97Aversions. The following table shows where the invoice informationis 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) and RFF01.1 = any of thefollowing: VX (value added tax registration number -Europe) | M |
| Supplier name | NAD02.1 (NAME) | NAD01 = any of: SU (supplier) | M |
| Supplier address | NAD03.1 (ADDRESS) | NAD01 = any of: SU (supplier) | M |
| Buyer VAT ID | REF01.2 (ID CODE) | NAD01 = any of BY (buyer) and RFF01.1= any of VX (value added tax registration number -Europe) | M |
| Buyer name | NAD02.1 (NAME) | NAD01 = any of BY (buyer) | M |
| Buyer address | NAD03.1 (ADDRESS) | NAD01 = any of BY (buyer) | 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 |
Was this topic helpful?
Document Information
Modified date:
08 December 2018
UID
ibm10759201