OIOUBL Invoice and OIOUBL Credit Note are XML document standards that are used in Denmark.
If you receive XML documents from one or more companies from there, the documents may come in this format.
This topic lists the ENTRANCE field types that are normally mapped to elements in these documents and indicates where in the XML code the elements are normally found. The ENTRANCE 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 6-3 Integration Specification.pdf. You can obtain this document from your ReadSoft representative.
|
ENTRANCE 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 |
.../cac:AccountingCustomerParty/cac:Party/cac:PostalAddress/cbc:PostalZone |
|
BuyerContactPersonName |
.../cac:AccountingCustomerParty/cac:Party/ cac:Contact/cbc:Name |
|
BuyerVATRegistrationNumber |
.../cac:AccountingCustomerParty/cac:Party/cac:PartyTaxScheme/cbc:CompanyID |
|
DeliveryDate |
.../cac:Delivery/cbc:ActualDeliveryDate |
|
InvoiceBaselineDate |
.../cbc:IssueDate |
|
InvoiceCredit |
.../cbc:InvoiceTypeCode Extracted value ‘380’ is translated to 0 (Debit). Credit Note is represented by another OIOUBL message. |
|
InvoiceCurrency |
.../cbc:DocumentCurrencyCode |
|
InvoiceDate |
.../cbc:IssueDate |
|
InvoiceDueDate |
.../cac:PaymentMeans/cbc:PaymentDueDate |
|
InvoiceNumber |
.../cbc:ID |
| InvoiceOrderNumber |
.../cac:OrderReference/cbc:ID If the value of this element is “n/a”, translate as empty string. |
|
InvoiceTaxAmount1 |
.../cac:TaxTotal/cac:TaxSubtotal/cbc:TaxAmount Only takes the value from the section in which the value of /Invoice/cac:TaxTotal/cac:TaxSubtotal/cac:TaxCategory/cbc:ID is equal to ‘StandardRated’. |
|
InvoiceTotalVATAmount |
.../cac:TaxTotal/cbc:TaxAmount |
|
InvoiceTotalVATExcludedAmount |
.../cac:LegalMonetaryTotal/cbc:LineExtensionAmount |
|
InvoiceTotalVATIncludedAmount |
.../cac:LegalMonetaryTotal/cbc:PayableAmount |
|
InvoiceTotalVATRatePercent |
.../cac:TaxTotal/cac:TaxSubtotal/cac:TaxCategory/cbc:Percent Only takes the value from the section in which the value of /Invoice/cac:TaxTotal/cac:TaxSubtotal/cac:TaxCategory/cac:ID is equal to ‘StandardRated’. |
|
Payment ReferenceNumber |
.../cac:PaymentMeans/cac:PayeeFinancialAccount/cbc:PaymentNote If the node does not exist, the value is taken from this alternate location: /Invoice/cac:PaymentMeans/cbc:InstructionID |
|
PaymentTerms |
.../cac:PaymentTerms/cbc:ID |
|
PaymentTermsInterest |
.../cac:PaymentTerms/cbc:PenaltySurchargePercent |
|
PaymentType |
/Invoice/cac:PaymentMeans/cbc:PaymentChannelCode If the node does not exist, the value is taken from this alternate location: /Invoice/cac:PaymentMeans/cbc:PaymentMeansCode |
|
SupplierAccountNumber1 |
.../cac:PaymentMeans/cac:PayeeFinancialAccount/cbc:ID If the node does not exist, the value is taken from this alternate location: /Invoice/cac:PaymentMeans/cac:CreditAccount/cbc:AccountID |
|
SupplierAddressPostalCode |
.../cac:AccountingSupplierParty/cac:Party/cac:PostalAddress/cbc:PostalZone |
|
SupplierVATRegistrationNumber |
.../cac:AccountingSupplierParty/cac:Party/cac:PartyTaxScheme/cbc:CompanyID |
| Line Item Fields (Invoices) | |
|
LIT_ArticleIdentifier |
/Invoice/cac:InvoiceLine/cac:Item/cac:SellersItemIdentification/cbc:ID |
|
LIT_ArticleName |
/Invoice/cac:InvoiceLine/cac:Item/cbc:Description |
|
LIT_DeliveredQuantity |
/Invoice/cac:InvoiceLine/cbc:InvoicedQuantity |
|
LIT_DeliveredQuantityUnitCode |
/Invoice/cac:InvoiceLine/cbc:InvoicedQuantity/@unitCode |
|
LIT_RowIdentifier |
/Invoice/cac:InvoiceLine/cbc:ID |
|
LIT_UnitPriceAmount |
/Invoice/cac:InvoiceLine/cac:Price/cbc:PriceAmount |
|
LIT_VatAmount |
/Invoice/cac:InvoiceLine/cac:TaxTotal/cbc:TaxAmount |
|
LIT_VatExcludedAmount |
/Invoice/cac:InvoiceLine/cbc:LineExtensionAmount |
|
LIT_VatRate |
/Invoice/cac:InvoiceLine/cac:TaxTotal/cac:TaxSubtotal/cac:TaxCategory/cbc:Percent |
|
Line Item Fields (Credit notes) |
|
|
LIT_ArticleIdentifier |
/CreditNote/cac:CreditNoteLine/cac:Item/cac:SellersItemIdentification/cbc:ID |
|
LIT_ArticleName |
/CreditNote/cac:CreditNoteLine/cac:Item/cbc:Description |
|
LIT_DeliveredQuantity |
/CreditNote/cac:CreditNoteLine/cbc:CreditedQuantity |
|
LIT_DeliveredQuantityUnitCode |
/CreditNote/cac:CreditNoteLine/cbc:CreditedQuantity/@unitCode |
|
LIT_RowIdentifier |
/CreditNote/cac:CreditNoteLine/cbc:ID |
|
LIT_UnitPriceAmount |
/CreditNote/cac:CreditNoteLine/cac:Price/cbc:PriceAmount |
|
LIT_VatAmount |
/CreditNote/cac:CreditNoteLine/cac:TaxTotal/cbc:TaxAmount |
|
LIT_VatExcludedAmount |
/CreditNote/cac:CreditNoteLine/cbc:LineExtensionAmount |
|
LIT_VatRate |
/CreditNote/cac:CreditNoteLine/cac:TaxTotal/cac:TaxSubtotal/cac:TaxCategory/cbc: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 |
.../DocumentReference/cbc:ID |
|
EmbeddedValue |
.../DocumentReference/Attachment/EmbeddedDocumentBinaryObject |
|
DataURI |
.../DocumentReference/cbc:Xpath |
|
DataType |
.../DocumentReference/cbc:DocumentTypeCode |
|
AdditionalInfo |
.../DocumentReference/Attachment/ExternalReference |
Supported XML document standard formats
Processing XML documents using COLLECTOR: Overview
Optimizing XML document definitions
Creating rules to map values for fields in XML documents