E2B field mapping
This table shows how Tungsten AP Essentials maps internal fields to E2B.
| Tungsten AP Essentials internal field name | E2B |
|---|---|
| Buyer fields | |
| Name | /InvoiceHeader/Invoicee/Name |
| Street | /InvoiceHeader/Buyer/PostalAddress/Address1 |
| StreetSupplement | /InvoiceHeader/Buyer/PostalAddress/Address2 |
| City | /InvoiceHeader/Buyer/PostalAddress/PostalDistrict |
| CountryCode | /InvoiceHeader/Buyer/PostalAddress/CountryCode |
| Country | /InvoiceHeader/Buyer/PostalAddress/CountryName |
| Supplier fields | |
| Name | /InvoiceHeader/Supplier/Name |
| Street | /InvoiceHeader/Supplier/PostalAddress/Address1 |
| StreetSupplement | /InvoiceHeader/Supplier/PostalAddress/Address2 |
| City | /InvoiceHeader/Supplier/PostalAddress/PostalDistrict |
| CountryCode | /InvoiceHeader/Supplier/PostalAddress/CountryCode |
| Country | /InvoiceHeader/Supplier/PostalAddress/CountryName |
| Standard fields | |
| AddressName | |
| AddressOptionalName | |
| AddressPostalCity | |
| AddressPostalCode | |
| AddressStreet | |
| Barcode | |
| BuyerAddressPostalCode | /Invoice/InvoiceHeader/Buyer/PostalAddress/PostalCode |
| BuyerContactPersonName | /Invoice/InvoiceHeader/Buyer/ContactPerson/Name |
| BuyerContactReference | |
| BuyerTaxNumber1 | /Invoice/InvoiceHeader/Buyer/VatId |
| BuyerTaxNumber2 | /Invoice/InvoiceHeader/Buyer/OrgNumber |
| BuyerVATRegistrationNumber | /Invoice/InvoiceHeader/Buyer/VatId If this element does not exist, use this alternative location: /Invoice/InvoiceHeader/Buyer/OrgNumber |
| DeliveryCost | /invoice/InvoiceDiscountChargesAndTax/InvoiceCharges/Amount |
| DeliveryCostInsurance | |
| DeliveryCostPackaging | |
| DeliveryCostPostage | |
| DeliveryCostToll | |
| DeliveryDate | /Invoice/InvoiceHeader/InvoiceReferences/DeliveryDate |
| DeliveryNote | /Invoice/InvoiceHeader/InvoiceReferences/DeliveryNoteNum |
| DeliveryTerms | /Invoice/InvoiceHeader/InvoiceReferences/DeliveryTerms |
| EsrAmount | |
| EsrNumber | |
| EsrReference | |
| InvoiceBaselineDate | /Invoice/InvoiceHeader/InvoiceDate |
| InvoiceCredit | /Invoice/InvoiceHeader/InvoiceType Extracted value '380' is translated into 0 (Debit). Any other extracted value is translated into 1 (Credit). |
| InvoiceCurrency | /Invoice/InvoiceHeader/Payment/Currency |
| InvoiceDate | /Invoice/InvoiceHeader/InvoiceDate |
| InvoiceDiscountAmount | /Invoice/InvoiceDiscountChargesAndTax/InvoiceDiscount/Amount Or, if missing: /Invoice/InvoiceSummary/DiscountTotals/Amount |
| InvoiceDiscountPercent | /Invoice/InvoiceSummary/DiscountTotals/Percent |
| InvoiceDueDate | /Invoice/InvoiceHeader/Payment/DueDate |
| InvoiceNumber | /Invoice/InvoiceHeader/InvoiceNumber |
| InvoiceOrderNumber | /Invoice/InvoiceHeader/InvoiceReferences/BuyersOrderNumber |
| InvoicePostingDate | |
| InvoiceTaxAmount1 | /Invoice/InvoiceSummary/VatTotalsInfo/VatAmount |
| InvoiceTaxAmount2 | |
| InvoiceTaxAmount3 | |
| InvoiceTaxAmount4 | |
| InvoiceTotalVATAmount | /Invoice/InvoiceSummary/InvoiceTotals/VatTotalsAmount |
| InvoiceTotalVatExcludedAmount | /Invoice/InvoiceSummary/InvoiceTotals/NetAmount |
| InvoiceTotalVatIncludedAmount | /Invoice/InvoiceSummary/InvoiceTotals/GrossAmount |
| InvoiceTotalVatIncludedAmountSpelled | |
| InvoiceTotalVatRatePercent | /Invoice/InvoiceSummary/VatTotalsInfo/VatPercent |
| InvoicingPeriodEnd | |
| InvoicingPeriodStart | |
| PaymentReferenceNumber | /Invoice/InvoiceHeader/Payment/KidNumber |
| PaymentTerms | /Invoice/InvoiceHeader/Payment/PaymentTerms |
| PaymentTermsInterest | /Invoice/InvoiceHeader/Payment/OverDuePercent |
| PaymentType | |
| SupplierAccountNumber1 | /Invoice/InvoiceHeader/Supplier/AccountInformation/AccountNumber |
| SupplierAccountNumber2 | |
| SupplierAccountNumber3 | |
| SupplierAccountNumber4 | |
| SupplierAddressPostalCode | /Invoice/InvoiceHeader/Supplier/PostalAddress/PostalCode |
| SupplierBankClearingNumber | |
| SupplierBankCodeNumber1 | |
| SupplierBankCodeNumber2 | |
| SupplierBankCodeNumber3 | |
| SupplierBankCodeNumber4 | |
| SupplierIBAN1 | /Invoice/InvoiceHeader/Supplier/AccountInformation/IbanNumber |
| SupplierIBAN2 | |
| SupplierIBAN3 | |
| SupplierIBAN4 | |
| SupplierTaxNumber1 | /Invoice/InvoiceHeader/Supplier/VatId |
| SupplierTaxNumber2 | /Invoice/InvoiceHeader/Supplier/OrgNumber |
| SupplierVATRegistrationNumber | /Invoice/InvoiceHeader/Supplier/VatId If this element does not exist, use this alternative location: /Invoice/InvoiceHeader/Supplier/OrgNumber |
| Line-item fields | |
| LIT_ArticleIdentifier | /Invoice/InvoiceDetails/BaseItemDetails/SuppliersProductId |
| LIT_ArticleName | /Invoice/InvoiceDetails/BaseItemDetails/Description |
| LIT_DeliveredQuantity | /Invoice/InvoiceDetails/BaseItemDetails/QuantityInvoiced |
| LIT_DeliveredQuantityUnitCode | /Invoice/InvoiceDetails/BaseItemDetails/UnitOfMeasure |
| LIT_DiscountAmount | |
| LIT_DiscountPercent | |
| LIT_OrderNumber | |
| LIT_RowIdentifier | /Invoice/InvoiceDetails/BaseItemDetails/LineItemNum |
| LIT_UnitPriceAmount | /Invoice/InvoiceDetails/BaseItemDetails/UnitPrice |
| LIT_VatAmount | /Invoice/InvoiceDetails/BaseItemDetails/VatInfo/VatAmount |
| LIT_VatExcludedAmount | /Invoice/InvoiceDetails/BaseItemDetails/LineItemAmount |
| LIT_VatIncludedAmount | /Invoice/InvoiceDetails/BaseItemDetails/LineItemGrossAmount |
| LIT_VatRate | /Invoice/InvoiceDetails/BaseItemDetails/VatInfo/VatPercent |
| Attachment fields | |
| ID | /MessageHeader/Attachment/AttachmentName |
| FileName | |
| EmbeddedValue | |
| EmbeddedInfo | |
| DataURI | /MessageHeader/Attachment/AttachmentLocation |
| SchemeURI | |
| DataType | /MessageHeader/Attachment/AttachmentType |
| LinkType | /MessageHeader/Attachment/@type |
| AdditionalInfo | /MessageHeader/Attachment/AttachmentNumber |
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.