UBL Mapping to Invoice Details fields

UBL Validator and general documentation

• https://anskaffelser.dev/service/validator/
• https://docs.peppol.eu/poacc/billing/3.0/syntax/ubl-invoice/tree/ 

Seller / supplier

Semine field	Norwegian	UBL	ERP	Semine mapping
ERP ID	ERP Leverandør ID	-	Imported	Lookup based on Supplier Bank Account + Vat ID
Seller ref	Selgers referanse	cac:AccountingSupplierParty / cac:Party / cac:PartyName / cbc:Name	Imported
Seller NS	Selgers NS		Imported?	Semine Supplier Settings
Could be based on cac:AccountingSupplierParty / cac:Party / cac:Contact cbc:ElectronicMail	Imported??	Entered manually now
Buyer ref	Kjøper referanse	First found field in the following order: EHF 2.0 cac:AccountingCustomerParty / cac:Party / cac:Contact / cbc:Name cac:AccountingCustomerParty / cac:Party / cac:Contact / ID cac:AccountingCustomerParty / cac:Party / cac:BuyerContact / Name UBL 3.0 cbc:BuyerReference cac:Contact	Imported
VAT ID	MVA Nummer/Org Nummer	cac:AccountingSupplierParty / cac:Party / cbc:EndpointID	Imported	Required for auto matching invoice with supplier
Bank account	Bankkonto	cac:PaymentMeans / cac:PayeeFinancialAccount / cbc:ID	Imported	VAT ID + Bank Account is required for auto matching invoice with supplier
Currency	Valuta	cbc:DocumentCurrencyCode	Imported
Exchange Rate	Valutakurs			Imported
Reporting amount				Calculated
Project reference	Prosjekt	cac:ProjectReference

Buyer

Semine field	UBL	ERP	Semine mapping
Buyer	cac:AccountingCustomerParty / cac:Party / cbc:EndpointID	Imported	Lookup of client settings name based on cbc:EndpointID + Semine client VATID

Invoice

Semine field	UBL	ERP	Semine mapping
Invoice nr	cbc:ID	Exported
Invoice date	cbc:IssueDate	Exported
Due date	cbc:DueDate	Exported
KID	cac:PaymentMeans / cbc:PaymentID	Exported
Net amount	cac:LegalMonetaryTotal / cbc:TaxExclusiveAmount	Exported
VAT Amount Hi	cac:TaxTotal / cac:TaxSubtotal / cbc:TaxAmount  + cac:TaxTotal / cac:TaxSubtotal / cac:TaxCategory cbc:ID  S	Exported
VAT Amount Mid	cac:TaxTotal / cac:TaxSubtotal / cbc:TaxAmount  + cac:TaxTotal / cac:TaxSubtotal / cac:TaxCategory cbc:ID  ?	Exported
VAT Amount Low	cac:TaxTotal / cac:TaxSubtotal / cbc:TaxAmount  + cac:TaxTotal / cac:TaxSubtotal / cac:TaxCategory cbc:ID  ?	Exported
Total amount	cbc:PayableAmount	Exported

Invoice lines

Semine field	UBL	ERP	Semine mapping
Dimension Extractor	cac:InvoiceLine / * All fields inside cac:InvoiceLine are used for dimension extracton.		See also: Uttrekk av dimensjon
Line	cac:InvoiceLine / cbc:ID	Exported
IL Description	cac:InvoiceLine / cac:Item / cbc:Name	Exported
Invoice Text		Exported	Entered by user. If blank, IL Descripion is exported.
Qty	cac:InvoiceLine / cbc:InvoicedQuantity	Exported
Unit Price	cac:InvoiceLine / cac:Price / cbc:PriceAmount	Exported
Net Amount	cac:InvoiceLine / cbc:LineExtensionAmount	Exported
Vat %	cac:InvoiceLine / cac:Item / cac:ClassifiedTaxCategory cbc:ID  + cbc:Percent	Exported
Amount		Exported	Calculated based on Qty * Unit price
Periods	If the date extractor finds a date in the IL Description field ( cac:InvoiceLine / cac:Item / cbc:Name ), it will be used. Same logic for both EHF and PDF. Example: "House rent Q4" Not used cac:InvoiceLine / cac:InvoicePeriod / cbc:StartDate  cac:InvoiceLine / cac:InvoicePeriod / cbc:EndDate	Exported
Start	If the date extractor finds a date in the IL Description field ( cac:InvoiceLine / cac:Item / cbc:Name ) , it will be used. Same logic for both EHF and PDF. Example: "House rent Q4" Not used: cac:InvoiceLine / cac:InvoicePeriod / cbc:StartDate	Exported