Default mapping for suppliers
Content from an incoming invoice XML is mapped when creating new suppliers.
The supplier data created from invoice XML files is downloaded to the Accounting document tables, and in the
tables below, you can find the origin of the data. The Business NXT fields are displayed by API identification: TableName.ColumnName to make
it easier to identify both the table and the field as a single value in a readable
format.
Note:
To display table and field names with API identification in Business NXT, select API identifiers under
Management > Application settings
in the menu.
Supplier
| PEPPOL BIS 3.0 source | Business NXT | Comment |
|---|---|---|
| DocumentCurrencyCode | Currency.IsoCode->Associate.CurrencyNo | |
| AccountingSupplierParty EndpointID | Associate.CompanyNo | Alternative mapping for supplier lookup/creation if CompanyID is not found. |
| AccountingSupplierParty Name | Associate.Name | |
| AccountingSupplierParty StreetName | Associate.AddressLine1 | |
| AccountingSupplierParty AdditionalStreetName | Associate.AddressLine2 | |
| AccountingSupplierParty AddressLine | Associate.AddressLine3 | |
| AccountingSupplierParty PostalZone | Associate.PostCode | |
| AccountingSupplierParty CityName | Associate.PostalArea | |
| AccountingSupplierParty Country IdentificationCode | Country.ISO->Associate.CountryNo | |
| AccountingSupplierParty PartyTaxScheme CompanyID | Associate.EuVatRegistrationNo | |
| AccountingSupplierParty PartyLegalEntity RegistrationName | Associate.Name | Alternative mapping for supplier creation if PartyName is not found |
| AccountingSupplierParty PartyLegalEntity CompanyID | Associate.CompanyNo | Used as supplier lookup to source Supplier no for voucher: AccountingDocument.SupplierNo->Voucher.CreditAccountNo |
| AccountingSupplierParty Contact Name | Associate.Name | The value is added on a separate new associate and linked to supplier through Associate.ContactFor |
| AccountingSupplierParty Contact Telephone | Associate.Phone | The value is added on a separate new associate and linked to supplier through Associate.ContactFor |
| AccountingSupplierParty Contact ElectronicMail | Associate.EmailAddress | The value is added on a separate new associate and linked to supplier through Associate.ContactFor |
| PaymentMeans PayeeFinancialAccount ID | Associate.BankAccount or Associate.Iban | |
| PaymentMeans FinancialInstitutionBranch ID | Associate.SwiftCode |
Supplier
| Business NXT | PEPPOL BIS 3.0 source | Comment |
|---|---|---|
| Associate.CurrencyNo | DocumentCurrencyCode | |
| Associate.CompanyNo | AccountingSupplierParty EndpointID | Alternative mapping for supplier lookup/creation if CompanyID is not found. |
| Associate.Name | AccountingSupplierParty Name | |
| Associate.AddressLine1 | AccountingSupplierParty StreetName | |
| Associate.AddressLine2 | AccountingSupplierParty AdditionalStreetName | |
| Associate.AddressLine3 | AccountingSupplierParty AddressLine | |
| Associate.PostCode | AccountingSupplierParty PostalZone | |
| Associate.PostalArea | AccountingSupplierParty CityName | |
| Country.ISO->Associate.CountryNo | AccountingSupplierParty Country IdentificationCode | |
| Associate.EuVatRegistrationNo | AccountingSupplierParty PartyTaxScheme CompanyID | |
| Associate.Name | AccountingSupplierParty PartyLegalEntity RegistrationName | Alternative mapping for supplier creation if PartyName is not found |
| Associate.CompanyNo | AccountingSupplierParty PartyLegalEntity CompanyID | Used as supplier lookup to source Supplier no for voucher: AccountingDocument.SupplierNo->Voucher.CreditAccountNo |
| Associate.Name | AccountingSupplierParty Contact Name | The value is added on a separate new associate and linked to supplier through Associate.ContactFor |
| Associate.Phone | AccountingSupplierParty Contact Telephone | The value is added on a separate new associate and linked to supplier through Associate.ContactFor |
| Associate.EmailAddress | AccountingSupplierParty Contact ElectronicMail | The value is added on a separate new associate and linked to supplier through Associate.ContactFor |
| Associate.BankAccount or Associate.Iban | PaymentMeans PayeeFinancialAccount ID | |
| Associate.SwiftCode | PaymentMeans FinancialInstitutionBranch ID |