PEPPOL BIS 3.0 default mappings by format structure
Mappings listed in the order they appear in the format structure, separated by section.
| PEPPOL BIS 3.0 | Business NXT |
|---|---|
| ID | OrderDocument.InvoiceNo |
| IssueDate | OrderDocument.InvoiceDate |
| DueDate | OrderDocument.InvoiceDate + payment terms |
| InvoiceTypeCode | Hardcoded |
| Note | OrderDocumentNote.Note |
| TaxPointDate | OrderDocument.InvoiceDate |
| DocumentCurrencyCode | OrderDocument.CurrencyNo -> Currency.IsoCode |
| TaxCurrencyCode | CompanyInformation.CurrencyNo-> Currency.IsoCode |
| BuyerReference | OrderDocument.YourReference |
| OriginatorDocumentReference | OrderDocument.QuotationNo |
| OrderReference | OrderDocument.CustomerOrSupplierOrderNo |
| SalesOrderID | OrderDocument.OrderNo |
| BillingReference | OrderDocument.InvoiceReference |
| ContractDocumentReference | CompanyInformation.AutoInvoiceCustomerContractUnit |
| ProjectReference | CompanyInformation.AutoInvoiceProjectUnit |
| PEPPOL BIS 3.0 | Business NXT |
|---|---|
| EndpointID | CompanyInformation.CompanyNo |
| PartyIdentification | CompanyInformation.CompanyNo |
| Name | Company.Name |
| StreetName | CompanyInformation.Address1 |
| AdditionalStreetName | CompanyInformation.Address2 |
| CityName | CompanyInformation.PostalArea |
| PostalZone | CompanyInformation.PostCode |
| AddressLine | CompanyInformation.Address3 |
| CountryCode | CompanyInformation.CountryNo->Country.IsoCode |
| PartyTaxScheme CompanyID | CompanyInformation.EuVatRegistrationNo |
| PartyTaxScheme CompanyID | CompanyInformation.OrganisationType |
| PartyLegalEntity RegistrationName | Company.Name |
| PartyLegalEntity CompanyID | CompanyInformation.CompanyNo |
| PartyLegalEntity CompanyLegalForm | CompanyInformation.OrganisationType |
| Contact Name | OrderDocument.SellerBuyer->Associate.Name |
| Contact Telephone | OrderDocument.SellerBuyer->Associate.Phone |
| Contact ElectronicMail | OrderDocument.SellerBuyer->Associate.EmailAddress |
| PEPPOL BIS 3.0 | Business NXT |
|---|---|
| EndpointID | OrderDocument.InvoiceCustomerNo->Associate.CompanyNo |
| PartyIdentification | OrderDocument.InvoiceCustomerNo->Associate.CompanyNo |
| Name | OrderDocument.InvoiceCustomerNo->Associate.Name |
| StreetName | OrderDocument.InvoiceCustomerNo->Associate.Address1 |
| AdditionalStreetName | OrderDocument.InvoiceCustomerNo->Associate.Address2 |
| CityName | OrderDocument.InvoiceCustomerNo->Associate.PostalArea |
| PostalZone | OrderDocument.InvoiceCustomerNo->Associate.PostCode |
| AddressLine | OrderDocument.InvoiceCustomerNo->Associate.Address3 |
| CountryCode | OrderDocument.InvoiceCustomerNo->Associate.CountryNo->Country.IsoCode |
| PartyTaxScheme CompanyID | OrderDocument.InvoiceCustomerNo->Associate.EuVatRegistrationNo |
| PartyLegalEntity RegistrationName | OrderDocument.InvoiceCustomerNo->Associate.Name |
| PartyLegalEntity CompanyID | OrderDocument.InvoiceCustomerNo->Associate.CompanyNo |
| Contact Name | OrderDocument.Contact2->Associate.Name |
| Contact Telephone | OrderDocument.Contact2->Associate.Phone |
| Contact ElectronicMail | OrderDocument.InvoiceCustomerNo->Associate.AutoinvoiceEmailAddress |
| PEPPOL BIS 3.0 | Business NXT |
|---|---|
| PartyIdentification | OrderDocument.FactoringCompanyNo->FactoringCompany.FactoringCustomerNo->Associate.CompanyNo |
| Name | OrderDocument.FactoringCompanyNo->FactoringCompany.FactoringCustomerNo->Associate.Name |
| PartyLegalEntity CompanyID | OrderDocument.FactoringCompanyNo->FactoringCompany.FactoringCustomerNo->Associate.CompanyNo |
| PEPPOL BIS 3.0 | Business NXT |
|---|---|
| ActualDeliveryDate | OrderDocument.FinishDate |
| ID | OrderDocument.DeliveryAssociateNo->Associate.EanLocationCode |
| StreetName | OrderDocument.DeliveryAddress1 |
| AdditionalStreetName | OrderDocument.DeliveryAddress2 |
| CityName | OrderDocument.DeliveryPostalArea |
| PostalZone | OrderDocument.DeliveryPostCode |
| AddressLine | OrderDocument.DeliveryAddress3 |
| CountryCode | OrderDocument.DeliveryCountryNo->Country.IsoCode |
| Name | OrderDocument.DeliveryAssociateNo->Associate.Name |
| PEPPOL BIS 3.0 | Business NXT |
|---|---|
| PaymentMeansCode | Hardcoded |
| PaymentID | OrderDocument.Cid |
| PayeeFinancialAccount | CompanyInformation.BankAccount |
| PayeeFinancialAccount | CompanyInformation.IbanBic |
| PayeeFinancialAccount | CompanyInformation.PostalGiro |
| PayeeFinancialAccount | FactoringCompany.BankAccount (factoring) |
| FinancialInstitutionBranch | CompanyInformation.SwiftCode |
| Note | OrderDocument.PaymentTerms->PaymentTerms.Description |
| PEPPOL BIS 3.0 | Business NXT |
|---|---|
| ChargeIndicator | Hardcoded |
| AllowanceChargeReason | Hardcoded |
| Amount | OrderDocument.TotalDiscountAmount |
| Amount | OrderDocument.TotalDiscountPercent |
| Amount | OrderDocument.Freight1-4 |
| Amount | OrderDocument.CountryNo->Country.InvoiceFee |
| PEPPOL BIS 3.0 | Business NXT |
|---|---|
| TaxAmount | OrderDocument.VatAmountInCurrency |
| TaxAmount | OrderDocument.VatAmountDomestic |
| TaxSubTotal TaxableAmount | Sum of OrderDocumentLine.AmountInCurrency per VAT code |
| TaxSubTotal TaxAmount | Sum of OrderDocumentLine.VATAmountInCurrency per VAT code |
| TaxSubTotal TaxCategory | Hardcoded |
| TaxSubTotal Percent | OrderDocumentLine.VatRate |
| TaxSubTotal TaxExemptionReason | Hardcoded based on OrderDocument.TradeArea |
| TaxSubTotal TaxScheme | Hardcoded as “VAT” |
| PEPPOL BIS 3.0 | Business NXT |
|---|---|
| LineExtensionAmount | Sum of OrderDocumentLine.NetAmountInCurrency |
| TaxExclusiveAmount | OrderDocument.OrderSumGrossInCurrency-VatAmountInCurrency-RoundingInCurrency |
| TaxInclusiveAmount | OrderDocument.OrderSumGrossInCurrency-RoundingInCurrency |
| AllowanceTotalAmount | Sum of allowances in header AllowanceCharge section |
| ChargeTotalAmount | Sum of charges in header AllowanceCharge section |
| PayableRoundingAmount | OrderDocument.RoundingInCurrency |
| PayableAmount | OrderDocument.OrderSumGrossInCurrency |
| PEPPOL BIS 3.0 | Business NXT |
|---|---|
| ID | OrderDocumentLine.LineNo |
| Note | OrderDocumentLineNote.Note |
| InvoicedQuantity | OrderDocumentLine.Quantity |
| LineExtensionAmount | OrderDocumentLine.AmountInCurrency |
| AccountingCost | OrderDocumentLineAddition.AccountingCost |
| AllowanceCharge ChargeIndicator | Hardcoded |
| AllowanceCharge AllowanceChargeReason | Hardcoded |
| AllowanceCharge Amount | Calculated depending on type |
| Item Name | OrderDocumentLine.Description |
| BuyersItemIdentification | OrderDocumentLine.ProductNo->ProductCustomer.CustomersProductNo |
| SellersItemIdentification | OrderDocumentLine.ProductNo |
| StandardItemIdentification | OrderDocumentLine.ProductNo->Barcode.Barcode |
| OriginCountry | Product.SourceCountryNo->Country.IsoCode |
| ItemClassificationCode | OrderDocumentLine.EuGoodsStatisticsNo and/or Product.UnspscNo |
| ClassifiedTaxCategory | Hardcoded |
| Percent | OrderDocumentLine.VatRate |
| TaxScheme | Hardcoded as “VAT” |
| AdditionalItemProperty Name | Hardcoded as “EUDRReferenceNumber” |
| AdditionalItemProperty Value | OrderDocumentLine->Reservation.DdsReferenceNumber, OrderDocumentLine.DdsReferenceNumber |
| PriceAmount | OrderDocumentLine.AmountAfterDiscountInCurrency/Quantity |
| BaseQuantity | Calculated based on PriceAmount and Price unit settings |