XML invoice standard – OIOUBL (Invoice and Credit Note)
OIOUBL Invoice and OIOUBL Credit Note are XML invoice standards that are used in Denmark.
If you receive XML invoices from one or more companies from there, the invoices may come in this format.
This topic lists the Kofax ReadSoft Invoices field types that are normally mapped to elements in these documents and indicates where in the XML code the elements are normally found. The Kofax ReadSoft Invoices field types that are not normally mapped to XML elements are not listed here.
For more information on how the logic in Collector's intelligent XML functionality works with this standard, please see ReadSoft COLLECTOR Integration Specification.pdf. You can obtain this document from your Kofax representative.
Kofax ReadSoft Invoices field | Location of element mapped in the XML
code
For the Invoice version, "..." in each string below should be replaced by "/Invoice" For the Credit Note version, "..." in each string should be replaced by "/CreditNote" |
BuyerAddressPostalCode | .../AccountingCustomerParty/Party/PostalAddress/PostalZone |
BuyerContactPersonName | .../AccountingCustomerParty/Party/Contact/Name |
BuyerVATRegistrationNumber | .../AccountingCustomerParty/Party/PartyTaxScheme/CompanyID |
DeliveryDate | .../Delivery/ActualDeliveryDate |
InvoiceBaselineDate | .../IssueDate |
InvoiceCredit | 0 = invoice (debit)
1 = credit note |
InvoiceCurrency | .../DocumentCurrencyCode |
InvoiceDate | .../IssueDate |
InvoiceDueDate | .../PaymentMeans/PaymentDueDate |
InvoiceNumber | .../ID |
InvoiceOrderNumber | .../OrderReference/ID
If the value of this element is “n/a”, translate as empty string. |
InvoiceTaxAmount1 | .../TaxTotal/TaxSubtotal/TaxAmount
Only takes the value from the section in which the value of /Invoice/TaxTotal/TaxSubtotal/TaxCategory/ID is equal to ‘StandardRated’. |
InvoiceTotalVATAmount | .../TaxTotal/TaxAmount |
InvoiceTotalVATExcludedAmount | .../LegalMonetaryTotal/LineExtensionAmount |
InvoiceTotalVATIncludedAmount | .../LegalMonetaryTotal/PayableAmount |
InvoiceTotalVATRatePercent | .../TaxTotal/TaxSubtotal/TaxCategory/Percent
Only takes the value from the section in which the value of /Invoice/TaxTotal/TaxSubtotal/TaxCategory/ID is equal to ‘StandardRated’. |
Payment ReferenceNumber | .../PaymentMeans/PayeeFinancialAccount/
The value used here is derived from the combination of the values at these locations in the following way (if they exist): +/PaymentMeans/PaymentID </PaymentMeans/InstructionID +/PaymentMeans/AccountID < |
PaymentTerms | .../PaymentTerms/:ID |
PaymentTermsInterest | .../PaymentTerms/PenaltySurchargePercent |
PaymentType | /Invoice/PaymentMeans/PaymentChannelCode
If the node does not exist, the value is taken from this alternate location: /Invoice/PaymentMeans/PaymentMeansCode |
SupplierAccountNumber1 | .../PaymentMeans/PayeeFinancialAccount/ID |
SupplierAddressPostalCode | .../AccountingSupplierParty/Party/PostalAddress/PostalZone |
SupplierVATRegistrationNumber | .../AccountingSupplierParty/Party/PartyTaxScheme/CompanyID |
Line Item Fields (Invoices) | Location of element mapped in the XML code |
LIT_ArticleIdentifier | /Invoice/InvoiceLine/Item/SellersItemIdentification/ID |
LIT_ArticleName | /Invoice/InvoiceLine/Item/Description |
LIT_DeliveredQuantity | /Invoice/InvoiceLine/InvoicedQuantity |
LIT_DeliveredQuantityUnitCode | /Invoice/InvoiceLine/InvoicedQuantity/@unitCode |
LIT_RowIdentifier | /Invoice/InvoiceLine/ID |
LIT_UnitPriceAmount | /Invoice/InvoiceLine/Price/PriceAmount |
LIT_VatAmount | /Invoice/InvoiceLine/TaxTotal/TaxAmount |
LIT_VatExcludedAmount | /Invoice/InvoiceLine/LineExtensionAmount |
LIT_VatRate | /Invoice/InvoiceLine/TaxTotal/TaxSubtotal/TaxCategory/Percent |
Line Item Fields (Credit notes) | Location of element mapped in the XML code |
LIT_ArticleIdentifier | /CreditNote/CreditNoteLine/Item/SellersItemIdentification/ID |
LIT_ArticleName | /CreditNote/CreditNoteLine/Item/Description |
LIT_DeliveredQuantity | /CreditNote/CreditNoteLine/CreditedQuantity |
LIT_DeliveredQuantityUnitCode | /CreditNote/CreditNoteLine/CreditedQuantity/@unitCode |
LIT_RowIdentifier | /CreditNote/CreditNoteLine/ID |
LIT_UnitPriceAmount | /CreditNote/CreditNoteLine/Price/PriceAmount |
LIT_VatAmount | /CreditNote/CreditNoteLine/TaxTotal/TaxAmount |
LIT_VatExcludedAmount | /CreditNote/CreditNoteLine/LineExtensionAmount |
LIT_VatRate | /CreditNote/CreditNoteLine/TaxTotal/TaxSubtotal/TaxCategory/Percent |
Attachment fields | Location of element mapped in the XML
code
For the Invoice version, "..." in each string below should be replaced by "/Invoice" For the Credit Note version, "..." in each string should be replaced by "/CreditNote" |
Id | .../ID |
EmbeddedValue | .../Attachment/EmbeddedDocumentBinaryObject |
DataURI | .../Attachment/ExternalReference/URI |
DataType | .../DocumentTypeCode |
AdditionalInfo | .../Attachment/EmbeddedDocumentBinaryObject/@mimeCode |