UBL Mapping to Invoice Details fields

XML fields used for AI Learning

For AI learning, Semine will pull and use the available information in the field cbc:Name for each invoice line, located under cac:InvoiceLine and cac:Item.

cac:InvoiceLine

              cac:Item

                     cbc:Name

XML fields used for Dimension Extraction

For dimension extraction from the invoice lines Semine will look at the available information under the object cac:InvoiceLine -> Item.Name. If this is empty Semine will look at the fields called Item.SellersItemIdentification.ID

For dimension extraction from the invoice header Semine will get data from the first of the following fields:

1. BuyerReference
2. AccountingCustomerParty.BuyerContact.Name
3. AccountingCustomerParty.Party.Contact.ID
4. AccountingCustomerParty.Party.Contact.Name

Dimension extration from the invoice header will also look in the following fields:

AccountingCost

Note

BuyerReference

OrderReference.ID

OrderReference.SalesOrderID

ProjectReference.Id

More information about UBL Validator and general documentation can be found here:

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

UBL Mapping

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 Reference	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	-	Currently entered manually	-	-
Buyer Reference	Kjøper referanse	EHF 3.0 / UBL 3.0: cac: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

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	-
Description	cbc:Note		-

Invoice lines

Semine Field	UBL	ERP	Semine Mapping
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	-	Exported	Calculated based on cbc:EndDate - cbc:StartDate
Start	cac:InvoiceLine / cac:InvoicePeriod / cbc:StartDate	Exported