Finvoice is an XML invoice standard that is used in Finland.
If you receive XML invoices from one or more companies from there, the invoices may come in this format.
This topic lists the 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 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 6-3 Integration Specification.pdf. You can obtain this document from your ReadSoft representative.
|
INVOICES field |
Location of element mapped in the XML code |
|---|---|
|
Barcode |
/Finvoice/VirtualBankBarcode |
|
BuyerAddlCode |
/Finvoice/BuyerPartyDetails/BuyerPostalAddressDetails/BuyerPostCodeIdentifier |
|
BuyerContactPersonName |
/Finvoice/BuyerContactPersonName |
|
BuyerTaxNumber1 |
/Finvoice/BuyerPartyDetails/BuyerOrganisationTaxCode |
|
BuyerVATRegistrationNumber |
/Finvoice/BuyerPartyDetails/BuyerOrganisationTaxCode |
|
/Finvoice/DeliveryDetails/DeliveryDate If this element does not exist, use this alternative location: /Finvoice/DeliveryDetails/DeliveryPeriodDetails/StartDate |
|
|
DeliveryNote |
/Finvoice/DeliveryDetails/WaybillIdentifier |
|
DeliveryTerms |
/Finvoice/DeliveryDetails/DeliveryTermsText |
|
InvoiceBaselineDate |
/Finvoice/InvoiceDetails/InvoiceDate |
|
InvoiceCredit |
/Finvoice/InvoiceDetails/InvoiceTypeCode Extracted value ‘INV01’ is translated into 0 (Debit) Any other extracted value is translated into 1 (Credit) |
|
InvoiceCurrency |
/Finvoice/InvoiceDetails/InvoiceTotalVatIncludedAmount/@AmountCurrencyIdentifier |
|
InvoiceDate |
/Finvoice/InvoiceDetails/InvoiceDate |
|
InvoiceDiscountAmount |
/Finvoice/InvoiceDetails/PaymentTermsDetails/CashDiscountAmount |
|
InvoiceDiscountPercent |
/Finvoice/InvoiceDetails/PaymentTermsDetails/CashDiscountPercent |
|
InvoiceDueDate |
/Finvoice/EpiDetails/EpiPaymentInstructionDetails/EpiDateOptionDate |
|
InvoiceNumber |
/Finvoice/InvoiceDetails/InvoiceNumber |
| InvoiceOrderNumber |
/Finvoice/InvoiceDetails/OrderIdentifier |
|
InvoiceTaxAmount1 |
/Finvoice/InvoiceDetails/VatSpecificationDetails/VatRateAmount |
|
InvoiceTotalVATAmount |
/Finvoice/InvoiceDetails/InvoiceTotalVatAmount |
|
InvoiceTotalVATExcludedAmount |
/Finvoice/InvoiceDetails/InvoiceTotalVatExcludedAmount |
|
InvoiceTotalVATIncludedAmount |
/Finvoice/InvoiceDetails/InvoiceTotalVatIncludedAmount |
|
InvoiceTotalVATRatePercent |
/Finvoice/InvoiceDetails/VatSpecificationDetails/VatRatePercent |
|
InvoicingPeriodEnd |
/Finvoice/InvoiceDetails/InvoicingPeriodEndDate |
|
InvoicingPeriodStart |
/Finvoice/InvoiceDetails/InvoicingPeriodStartDate |
|
PaymentReferenceNumber |
/Finvoice/EpiDetails/EpiPaymentInstructionDetails/EpiRemittanceInfoIdentifier |
|
PaymentTerms |
/Finvoice/InvoiceDetails/PaymentTermsDetails/PaymentTermsFreeText |
|
PaymentTermsInterest |
/Finvoice/InvoiceDetails/PaymentTermsDetails/PaymentOverDueFineDetails/PaymentOverDueFinePercent |
|
PaymentType |
/Finvoice/EpiDetails/EpiPaymentInstructionDetails/EpiCharge/@ChargeOption |
|
SupplierAccountNumber1 |
/Finvoice/SellerInformationDetails/SellerAccountDetails/SellerAccountID Only takes the value from the section in which the value of /Finvoice/SellerInformationDetails/SellerAccountDetails/SellerAccountID/@IdentificationSchemeName is equal to BBAN’ |
|
SupplierAddressPostalCode |
/Finvoice/SellerPartyDetails/SellerPostalAddressDetails/SellerPostCodeIdentifier |
|
SupplierIBAN1 |
/Finvoice/SellerInformationDetails/SellerAccountDetails/SellerAccountID Only takes the value from the section in which the value of /Finvoice/SellerInformationDetails/SellerAccountDetails/SellerAccountID/@IdentificationSchemeName is equal to ‘IBAN’. |
|
SupplierTaxNumber1 |
/Finvoice/SellerPartyDetails/SellerOrganisationTaxCode |
|
SupplierVATRegistrationNumber |
/Finvoice/SellerPartyDetails/SellerOrganisationTaxCode |
| Line Item Fields | |
|
LIT_ArticleIdentifier |
/Finvoice/InvoiceRow/ArticleIdentifier |
|
LIT_ArticleName |
/Finvoice/InvoiceRow/ArticleName |
|
LIT_DeliveredQuantity |
/Finvoice/InvoiceRow/DeliveredQuantity |
|
LIT_DeliveredQuantityUnitCode |
/Finvoice/InvoiceRow/DeliveredQuantity/@QuantityUnitCode |
|
LIT_RowIdentifier |
/Finvoice/InvoiceRow/RowIdentifier |
|
LIT_UnitPriceAmount |
/Finvoice/InvoiceRow/UnitPriceAmount |
| LIT_VATAmount |
/Finvoice/InvoiceRow/RowVatAmount |
|
LIT_VATExcludedAmount |
/Finvoice/InvoiceRow/RowVatExcludedAmount |
| LIT_VATIncludedAmount |
/Finvoice/InvoiceRow/RowAmount |
|
LIT_VatRate |
/Finvoice/InvoiceRow/RowVatRatePercent |
| Attachments | |
| There is no default mapping for attachments in the Finvoice standard. If you want to add support for attachments for these XML invoices in your system, you need to add a field for it. | |
Supported XML invoice standard formats
Processing XML invoices using COLLECTOR: Overview
Optimizing XML invoice definitions
Creating rules to map values for fields in XML invoices