E2B field mapping
This table shows how Tungsten AP Essentials maps internal fields with 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/BuyersOrder Number |
| 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/Postal Code |
| 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.