Mapping for each master data type

Tabell 1. Visma Business Data to Master Data Management Master Data mapping
Visma Business Data		Master Data Management Master Data		Info
Table	Field	Type	Field	Info
Aktør (where Kundenr > 0 or Lev.nr > 0)	Aktørnr	Business	ID
	Navn		Name
	CompanyNo		OrganizationNumber	Complex type also containing a schemeId for the organisation number. This schemeId is determined by country ISO code
	Kundenr or Lev.nr		Types	Array of complex type defined as follow: Value is set to "Supplier" if the Lev.nr is non-zero - otherwise "Customer" typeIf is set to the Lev.nr if Lev.nr is non-zero - otherwise set to Kundenr
	Type: OfficeAddress Adresselinje 1-4 Postnr Poststed CountryNo => Country.ISO Type: InvoiceAddress InvoiceAddressLine1-4 InvoicePostCode InvoicePostalArea InvoiceCountryNo => Country.ISO		Addresses	List of 1 or 2 addresses: 1. OfficeAddress for every Business. 2. InvoiceAddress if InvoiceCustomerNo is non-zero
	Telefonnr Privat telefonnr Mobiltelefonnr Faksnr		PhoneNumbers	List of phone numbers taken from the stated fields (if not empty)
	E-postadresse		Emails	List of emails - always 1 entry.
	Web-side 1		URL
			ContactRefs	Array of Contact public ID in Master Data Management
	AssociateSocialMediaAccount.SocialMedia AssociateSocialMediaAccount.Account		SocialMediaAccounts	List of complex type containing Social Media accounts. Taken from line table to Associate.
	Ansvarsenhet 1-Ansvarsenhet 12		CostUnits	List of Cost Unit public ID in Master Data Management
			Active	Always true
	CreditDenied		CreditStop
	Motkonto lev.		CrossAccountNumber
	BankAccount PostalGiro Iban SwiftCode BankBranch BankNo => Bank.BankNo Bank.BankAccount BankIban Bank.SwiftCode Bank.BankBranch		BankAccount	Complex type based on the stated fields.
	Avg.kode lev.		SupplierTaxCodeId	Supplier Tax Code public ID
Aktør (Contact for > 0)	Aktørnr	Contact	ID
	Navn		Name
	Tittel		Title
	Adresselinje 1-4 Postnr Poststed CountryNo => Country.ISO		Address	Complex type created based on information on Aktør and the ISO from the Landnr through a lookup to Land table.
	Telefonnr Privat telefonnr Mobiltelefonnr Faksnr		PhoneNumbers	List of phone numbers taken from the stated fields (if not empty)
	E-postadresse		Emails
			BusinessRef	Reference to the Business public ID in Master Data Management
	Kundenr or Lev.nr		BusinessRefType	Complex type being defined as follow: Value is set to "Supplier" if the Lev.nr is non-zero - otherwise "Customer" typeIf is set to the Lev.nr if Lev.nr is non-zero - otherwise set to Kundenr
	AssociateSocialMediaAccount.SocialMedia AssociateSocialMediaAccount.Account		SocialMediaAccounts	List of complex type containing Social Media accounts. Taken from line table to Associate.
			Active	Always true
Hovedbokskonto	Kontonr	General Ledger Account	Number
	Navn		Name
	Sperret		Suspended
	Avg.kode		taxCodeId	Reference to the Tax Code public ID in Master Data Management
R1-R12 (Organisation Unit)		Cost Unit	CostUnitTypeId	Reference to the Cost Unit Type public ID in Master Data Management
	Nr		Number
	Navn		Name
	OrgUnitProcessing.Suspended		Suspended	Flag in OrgUnitProcessing field
	Reell startdato		ValidFrom
	Reell sluttdato		ValidTo
Bedriftsopplysninger (Organisation Unit Type*)		Cost Unit Type	Dimension	Org unit class determined on the the field in Bedriftsopplysninger table. Ansvarsenhet 1 ==> 1 Ansvarsenhet 2 ==> 2
Bedriftsopplysninger (Organisation Unit Type*)	Organisational unit 1 to Ansvarsenhet 12	Cost Unit Type	Name
Avgiftskode	Avg.kode	Tax Code	Number	Tax Code for lookup in tables. Internal ERP tax code.
	Beskrivelse		Name	Tax code description.
			Suspended	Always False
	Kostn. %		BaseRate	Base rates used for the tax code. BaseRate=100-Cost%
	Sats from underlying table Merverdiavgift		TaxPercentage	Tax Percentage
	Ny sats from underlying table Merverdiavgift		NewTaxPercentage	Upcoming Tax percentage.
	Fom. dato from underlying table Merverdiavgift		NewTaxEffectiveDate	Starting date for NewTaxPercentage.

* defined in Bedriftsopplysninger table in the fields Ansvarsenhet 1 - Ansvarsenhet 12