Finvoice field mapping
This table shows how Tungsten AP Essentials maps internal fields to Finvoice XML.
Tungsten AP Essentials does not support
Finvoice invoices with SOAP envelopes.
| Tungsten AP Essentials internal field name | Finvoice |
|---|---|
| Buyer fields | |
| Name | /BuyerPartyDetails/BuyerOrganisationName |
| Street | /BuyerPartyDetails/BuyerPostalAddressDetails/BuyerStreetName |
| POBox | /BuyerPartyDetails/BuyerPostalAddressDetails/PostOfficeBoxIdentifier |
| City | /BuyerPartyDetails/BuyerPostalAddressDetails/BuyerTownName |
| CountryCode | /BuyerPartyDetails/BuyerPostalAddressDetails/CountryCode |
| Country | /BuyerPartyDetails/BuyerPostalAddressDetails/CountryName |
| Supplier fields | |
| Name | /SellerPartyDetails/SellerOrganisationName |
| Street | /SellerPartyDetails/SellerPostalAddressDetails/SellerStreetName |
| POBox | /SellerPartyDetails/SellerPostalAddressDetails/PostOfficeBoxIdentifier |
| City | /SellerPartyDetails/SellerPostalAddressDetails/SellerTownName |
| CountryCode | /SellerPartyDetails/SellerPostalAddressDetails/CountryCode |
| Country | /SellerPartyDetails/SellerPostalAddressDetails/CountryName |
| Standard fields | |
| AddressName | |
| AddressOptionalName | |
| AddressPostalCity | |
| AddressPostalCode | |
| AddressStreet | |
| Barcode | /Finvoice/VirtualBankBarcode |
| BuyerAddressPostalCode | /Finvoice/BuyerPartyDetails/BuyerPostalAddressDetails/BuyerPostCodeIdentifier |
| BuyerContactPersonName | /Finvoice/BuyerContactPersonName |
| BuyerContactReference | |
| BuyerTaxNumber1 | /Finvoice/BuyerPartyDetails/BuyerOrganisationTaxCode |
| BuyerTaxNumber2 | |
| BuyerVATRegistrationNumber | /Finvoice/BuyerPartyDetails/BuyerOrganisationTaxCode |
| DeliveryCost | |
| DeliveryCostInsurance | |
| DeliveryCostPackaging | |
| DeliveryCostPostage | |
| DeliveryCostToll | |
| DeliveryDate | /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 |
| EsrAmount | |
| EsrNumber | |
| EsrReference | |
| InvoiceBaselineDate | /Finvoice/InvoiceDetails/InvoiceDate |
| InvoiceCredit | /Finvoice/InvoiceDetails/InvoiceTypeCode InvoiceCredit:
INV01 ='0' (Invoice) Any other value ='1' (Credit Note) Also, the document will be considered as Credit Note if the invoice total VAT included amount is negative. |
| 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 |
| InvoicePostingDate | |
| InvoiceTaxAmount1 | /Finvoice/InvoiceDetails/VatSpecificationDetails/VatRateAmount |
| InvoiceTaxAmount2 | |
| InvoiceTaxAmount3 | |
| InvoiceTaxAmount4 | |
| InvoiceTotalVATAmount | /Finvoice/InvoiceDetails/InvoiceTotalVatAmount |
| InvoiceTotalVatExcludedAmount | /Finvoice/InvoiceDetails/InvoiceTotalVatExcludedAmount |
| InvoiceTotalVatIncludedAmount | /Finvoice/InvoiceDetails/InvoiceTotalVatIncludedAmount |
| InvoiceTotalVatIncludedAmountSpelled | |
| 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'. |
| SupplierAccountNumber2 | |
| SupplierAccountNumber3 | |
| SupplierAccountNumber4 | |
| SupplierAddressPostalCode | /Finvoice/SellerPartyDetails/SellerPostalAddressDetails/ SellerPostCodeIdentifier |
| SupplierBankClearingNumber | |
| SupplierBankCodeNumber1 | |
| SupplierBankCodeNumber2 | |
| SupplierBankCodeNumber3 | |
| SupplierBankCodeNumber4 | |
| 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'. |
| SupplierIBAN2 | |
| SupplierIBAN3 | |
| SupplierIBAN4 | |
| SupplierTaxNumber1 | /Finvoice/SellerPartyDetails/SellerOrganisationTaxCode |
| SupplierTaxNumber2 | |
| 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_DiscountAmount | |
| LIT_DiscountPercent | |
| LIT_OrderNumber | |
| 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 |
| Note | /InvoiceDetails/Notes |
| Attachment fields | |
| ID | |
| FileName | |
| EmbeddedValue | |
| EmbeddedInfo | |
| DataURI | |
| SchemeURI | |
| DataType | |
| LinkType | |
| AdditionalInfo | |
Field mappings from incoming XML formats only map to standard fields. They do not map to custom fields. Consider using the XML document type if your current document type does not support the field mappings you require.