Svefaktura field mapping
This table shows how Tungsten AP Essentials maps internal fields with Svefaktura XML.
| Tungsten AP Essentials internal field name | Svefaktura XML |
|---|---|
| Buyer fields | |
| Name | /BuyerParty/Party/PartyName |
| Street | /BuyerParty/Party/Address/StreetName |
| POBox | /BuyerParty/Party/Address/PostBox |
| City | /BuyerParty/Party/Address/CityName |
| CountryCode | /BuyerParty/Party/Address/Country/IdentificationCode |
| Supplier fields | |
| Name | /SellerParty/Party/PartyName |
| Street | /SellerParty/Party/Address/StreetName |
| StreetSupplement | /SellerParty/Party/Address/PostBox |
| City | /SellerParty/Party/Address/CityName |
| CountryCode | /SellerParty/Party/Address/Country/IdentificationCode |
| Standard fields | |
| AddressName | |
| AddressOptionalName | |
| AddressPostalCity | |
| AddressPostalCode | |
| AddressStreet | |
| Barcode | |
| BuyerAddressPostalCode | /Invoice/BuyerParty/Party/Address/PostalZone |
| BuyerContactPersonName | /Invoice/BuyerParty/Party/Contact/Name |
| BuyerContactReference | |
| BuyerTaxNumber1 | /Invoice/BuyerParty/PartyTaxScheme/CompanyID
Takes the value from the section in which the value of /Invoice/BuyerParty/PartyTaxScheme/TaxScheme/ID is equal to "VAT". |
| BuyerTaxNumber2 | /Invoice/BuyerParty/PartyTaxScheme/CompanyID
Takes the value from the section in which the value of /Invoice/BuyerParty/PartyTaxScheme/TaxScheme/ID is equal to "SWT". |
| BuyerVATRegistrationNumber | /Invoice/BuyerParty/PartyTaxScheme/CompanyID
Takes the value from the section in which the value of /Invoice/BuyerParty/PartyTaxScheme/TaxScheme/ID is equal to "VAT". |
| ChargeAmount1 |
/Invoice/AllowanceCharge[1]/Amount ...if /Invoice/AllowanceCharge[1]/ChargeIndicator = true
This field is only available in the XML document type.
|
| ChargeAmount2 |
/Invoice/AllowanceCharge[2]/Amount ...if /Invoice/AllowanceCharge[2]/ChargeIndicator = true
This field is only available in the XML document type.
|
| ChargeAmount3 |
/Invoice/AllowanceCharge[3]/Amount ...if /Invoice/AllowanceCharge[3]/ChargeIndicator = true
This field is only available in the XML document type.
|
| ChargeAmount4 |
/Invoice/AllowanceCharge[4]/Amount ...if /Invoice/AllowanceCharge[4]/ChargeIndicator = true
This field is only available in the XML document type.
|
| DiscountAmount1 |
/Invoice/AllowanceCharge[1]/Amount ...if /Invoice/AllowanceCharge[1]/ChargeIndicator = false
This field is only available in the XML document type.
|
| DiscountAmount2 |
/Invoice/AllowanceCharge[2]/Amount ...if /Invoice/AllowanceCharge[2]/ChargeIndicator = false
This field is only available in the XML document type.
|
| DiscountAmount3 |
/Invoice/AllowanceCharge[3]/Amount ...if /Invoice/AllowanceCharge[3]/ChargeIndicator = false
This field is only available in the XML document type.
|
| DiscountAmount4 |
/Invoice/AllowanceCharge[4]/Amount ...if /Invoice/AllowanceCharge[4]/ChargeIndicator = false
This field is only available in the XML document type.
|
| DeliveryCost | |
| DeliveryCostInsurance | |
| DeliveryCostPackaging | |
| DeliveryCostPostage | |
| DeliveryCostToll | |
| DeliveryDate | /Invoice/Delivery/ActualDeliveryDateTime |
| DeliveryNote | /Invoice/InvoiceLine/DespatchLineReference/DocumentReference/ID |
| DeliveryTerms | /Invoice/DeliveryTerms/SpecialTerms |
| EsrAmount | |
| EsrNumber | |
| EsrReference | |
| InvoiceBaselineDate | /Invoice/IssueDate |
| InvoiceCredit | /Invoice/InvoiceTypeCode
Extracted value "380" is translated into 0 (Debit) Any other extracted value is translated into 1 (Credit) |
| InvoiceCurrency | /Invoice/InvoiceCurrencyCode |
| InvoiceDate | /Invoice/IssueDate |
| InvoiceDueDate | /Invoice/PaymentMeans/DuePaymentDate |
| InvoiceNumber | /Invoice/ID |
| InvoiceOrderNumber | /Invoice/InvoiceLine/OrderLineReference/OrderReference/BuyersID |
| InvoicePostingDate | |
| InvoiceTaxAmount1 | /Invoice/TaxTotal/TaxSubTotal/TaxAmount
Only takes the value from the section in which the value of /Invoice/TaxTotal/TaxSubTotal/TaxCategory/ID is not equal to "E". |
| InvoiceTaxAmount2 | |
| InvoiceTaxAmount3 | |
| InvoiceTaxAmount4 | |
| InvoiceTotalVATAmount | /Invoice/TaxTotal/TotalTaxAmount |
| InvoiceTotalVatExcludedAmount | /Invoice/LegalTotal/ TaxExclusiveTotalAmount |
| InvoiceTotalVatIncludedAmount | /Invoice/LegalTotal/TaxInclusiveTotalAmount |
| InvoiceTotalVatIncludedAmountSpelled | |
| InvoiceTotalVatRatePercent | /Invoice/TaxTotal/TaxSubTotal/TaxCategory/Percent
Only takes the value from the section in which the value of /Invoice/TaxTotal/TaxSubTotal/TaxCategory/ID is not equal to "E". |
| InvoicingPeriodEnd | /Invoice/InvoicingPeriod/EndDateTime |
| InvoicingPeriodStart | /Invoice/InvoicingPeriod/StartDateTime |
| PaymentReferenceNumber | /Invoice/PaymentMeans/PayeeFinancialAccount/PaymentInstructionID |
| PaymentTerms | /Invoice/PaymentTerms/Note |
| PaymentTermsInterest | /Invoice/PaymentTerms/PenaltySurchargePercent |
| PaymentType | /Invoice/PaymentMeans/PaymentMeansTypeCode |
| SupplierAccountNumber1 | /Invoice/PaymentMeans/PayeeFinancialAccount/ID
Only takes the value from the section in which the value of /Invoice/PaymentMeans/PayeeFinancialAccount/FinancialInstitutionBranch/FinancialInstitution/ID is equal to "PGSISESS" (PlusGiro) |
| SupplierAccountNumber2 | /Invoice/PaymentMeans/PayeeFinancialAccount/ID
Only takes the value from the section in which the value of /Invoice/PaymentMeans/PayeeFinancialAccount/FinancialInstitutionBranch/FinancialInstitution/ID is equal to "BGABSESS" (BankGiro). |
| SupplierAccountNumber3 | /Invoice/PaymentMeans/PayeeFinancialAccount/ID
Only takes the value from the section in which the value of /Invoice/PaymentMeans/PayeeFinancialAccount/FinancialInstitutionBranch/FinancialInstitution/ID is not equal to "PGSISESS" (PlusGiro) or "BGABSESS" (BankGiro). |
| SupplierAccountNumber4 | |
| SupplierAddressPostalCode | /Invoice/SellerParty/Party/Address/PostalZone |
| SupplierBankClearingNumber | |
| SupplierBankCodeNumber1 | |
| SupplierBankCodeNumber2 | |
| SupplierBankCodeNUmber3 | |
| SupplierBankCodeNumber4 | |
| SupplierIBAN1 | |
| SupplierIBAN2 | |
| SupplierIBAN3 | |
| SupplierIBAN4 | |
| SupplierTaxNumber1 | /Invoice/SellerParty/PartyTaxScheme/CompanyID
Takes the value from the section in which the value of /Invoice/SellerParty/PartyTaxScheme/TaxScheme/ID is equal to "VAT". |
| SupplierTaxNumber2 | /Invoice/SellerParty/PartyTaxScheme/CompanyID
Takes the value from the section in which the value of /Invoice/SellerParty/PartyTaxScheme/TaxScheme/ID is equal to "SWT". |
| SupplierVATRegistrationNumber | /Invoice/SellerParty/PartyTaxScheme/CompanyID
Takes the value from the section in which the value of /Invoice/SellerParty/PartyTaxScheme/TaxScheme/ID is equal to 'VAT'. |
| Line-item fields | |
| LIT_ArticleIdentifier | /Invoice/InvoiceLine/Item/SellersItemIdentification/ID |
| LIT_ArticleName | /Invoice/InvoiceLine/Item/Description |
| LIT_DeliveredQuantity | /Invoice/InvoiceLine/InvoicedQuantity |
| LIT_DeliveredQuantityUnitCode | /Invoice/InvoiceLine/InvoicedQuantity/@quantityUnitCode |
| LIT_DiscountAmount | |
| LIT_DiscountPercent | |
| LIT_OrderNumber | /Invoice/InvoiceLine/OrderLineReference/OrderReference/BuyersID |
| LIT_RowIdentifier | /Invoice/InvoiceLine/ID |
| LIT_UnitPriceAmount | /Invoice/InvoiceLine/Item/BasePrice/PriceAmount |
| LIT_VatAmount | |
| LIT_VatExcludedAmount | /Invoice/InvoiceLine/LineExtensionAmount |
| LIT_VatIncludedAmount | |
| LIT_VatRate | /Invoice/InvoiceLine/Item/TaxCategory/Percent |
| Attachment fields | |
| ID | /Invoice/AdditionalDocumentReference/ID |
| FileName | |
| EmbeddedValue | |
| EmbeddedInfo | |
| DataURI | /Invoice/AdditionalDocumentReference/ ID/@identificationSchemeDataURI |
| SchemeURI | /Invoice/AdditionalDocumentReference/ID/@identificationSchemeURI |
| DataType | /Invoice/AdditionalDocumentReference/ID/@identificationSchemeName |
| LinkType | |
| AdditionalInfo | /Invoice/AdditionalDocumentReference/ID/@identificationSchemeID |
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.