Finvoice field mapping
This table shows how Tungsten AP Essentials maps internal fields with 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.