ZUGFeRD, Factur-X, and XRechnung field mapping
These tables show how Tungsten AP Essentials maps internal fields with the Cross Industry Invoice (CII) standard used in ZUGFeRD, Factur-X, XRechnung.
ZUGFeRD 2.3, Factur-X 1.0, XRechnung 3.0
| Tungsten AP Essentials internal field name | ZUGFeRD 2.3, Factur-X 1.0, XRechnung 3.0 |
|---|---|
| Buyer fields | |
| Name | BuyerTradeParty/Name |
| Identifier | BuyerTradeParty/GlobalID |
| BuyerContactPersonName | BuyerTradeParty/DefinedTradeContact/PersonName |
| BuyerVATRegistrationNumber | BuyerTradeParty/SpecifiedTaxRegistration/ID
...where the attribute schemeID=”VA” |
| CountryCode | BuyerTradeParty/PostalTradeAddress/CountryID |
| BuyerAddressPostalCode | BuyerTradeParty/PostalTradeAddress/PostcodeCode |
| Street | BuyerTradeParty/PostalTradeAddress/LineOne |
| StreetSupplement | BuyerTradeParty/PostalTradeAddress/LineTwo |
| City | BuyerTradeParty/PostalTradeAddress/CityName |
| TelephoneNumber | BuyerTradeParty/DefinedTradeContact/TelephoneUniversalCommunication/CompleteNumber |
| FaxNumber | BuyerTradeParty/DefinedTradeContact/FaxUniversalCommunication/CompleteNumber |
| BuyerTradeParty/DefinedTradeContact/EmailURIUniversalCommunication/URIID | |
| Supplier fields | |
| Name | SellerTradeParty/Name |
| Identifier | SellerTradeParty/GlobalID |
| Street | SellerTradeParty/PostalTradeAddress/LineOne |
| StreetSupplement | SellerTradeParty/PostalTradeAddress/LineTwo |
| PostalCode | SellerTradeParty/PostalTradeAddress/PostcodeCode |
| City | SellerTradeParty/PostalTradeAddress/CityName |
| CountryCode | SellerTradeParty/PostalTradeAddress/CountryID |
| TelephoneNumber | SellerTradeParty/DefinedTradeContact/TelephoneUniversalCommunication/CompleteNumber |
| FaxNumber | SellerTradeParty/DefinedTradeContact/FaxUniversalCommunication/CompleteNumber |
| SupplierVATRegistrationNumber | SellerTradeParty/SpecifiedTaxRegistration/ID where attribute schemeID="VA" |
| SupplierTaxNo1 | SellerTradeParty/SpecifiedTaxRegistration/ID where the attribute schemeID="FC" |
| SellerTradeParty/DefinedTradeContact/EmailURIUniversalCommunication/URIID | |
| Header fields | |
| ChargeAmount1, ChargeAmount2, ChargeAmount3, ChargeAmount4 |
|
| ContractNumber | /rsm:CrossIndustryInvoice/rsm:SupplyChainTradeTransaction/ram:ApplicableHeaderTradeAgreement/ram:ContractReferenceDocument/ram:IssuerAssignedID |
| DeliveryAddressName | /rsm:CrossIndustryInvoice/rsm:SupplyChainTradeTransaction/ram:ApplicableHeaderTradeDelivery/ram:ShipToTradeParty/ram:Name |
| DeliveryAddressStreet | /rsm:CrossIndustryInvoice/rsm:SupplyChainTradeTransaction/ram:ApplicableHeaderTradeDelivery/ram:ShipToTradeParty/ram:PostalTradeAddress/ram:LineOne
...and... /rsm:CrossIndustryInvoice/rsm:SupplyChainTradeTransaction/ram:ApplicableHeaderTradeDelivery/ram:ShipToTradeParty/ram:PostalTradeAddress/ram:LineTwo...with a space between the values. |
| DeliveryAddressCity | /rsm:CrossIndustryInvoice/rsm:SupplyChainTradeTransaction/ram:ApplicableHeaderTradeDelivery/ram:ShipToTradeParty/ram:PostalTradeAddress/ram:CityName |
| DeliveryAddressCountry | /rsm:CrossIndustryInvoice/rsm:SupplyChainTradeTransaction/ram:ApplicableHeaderTradeDelivery/ram:ShipToTradeParty/ram:PostalTradeAddress/ram:CountryID |
| DeliveryAddressZip | /rsm:CrossIndustryInvoice/rsm:SupplyChainTradeTransaction/ram:ApplicableHeaderTradeDelivery/ram:ShipToTradeParty/ram:PostalTradeAddress/ram:PostcodeCode |
| DeliveryCost | /rsm:CrossIndustryInvoice/rsm:SupplyChainTradeTransaction/ram:ApplicableHeaderTradeSettlement/ram:SpecifiedTradeSettlementHeaderMonetarySummation/ram:ChargeTotalAmount |
| DeliveryDate | /rsm:CrossIndustryInvoice/rsm:SupplyChainTradeTransaction/ram:ApplicableHeaderTradeDelivery/ram:ActualDeliverySupplyChainEvent/ram:OccurrenceDateTime/udt:DateTimeString/text() |
| DeliveryNote | /rsm:CrossIndustryInvoice/rsm:SupplyChainTradeTransaction/ram:ApplicableHeaderTradeDelivery/ram:DespatchAdviceReferencedDocument/ram:IssuerAssignedID |
| DeliveryTerms | /rsm:SupplyChainTradeTransaction/rsm:SupplyChainTradeTransaction/ram:ApplicableTradeDeliveryTerms |
| DiscountAmount1, DiscountAmount2, DiscountAmount3, DiscountAmount4 |
|
| InvoiceCredit |
InvoiceCredit is classified as credit if GrandTotal is a negative amount or if /rsm:CrossIndustryInvoice/rsm:ExchangedDocument/ram:TypeCode is set to any of these codes:
|
| InvoiceCurrency | /rsm:CrossIndustryInvoice/rsm:SupplyChainTradeTransaction/ram:ApplicableHeaderTradeSettlement/ram:InvoiceCurrencyCode |
| InvoiceDate | /rsm:ExchangedDocument/ram:IssueDateTime/udt:DateTimeString |
| InvoiceDiscountAmount | /rsm:CrossIndustryInvoice/rsm:SupplyChainTradeTransaction/ram:ApplicableHeaderTradeSettlement/ram:SpecifiedTradeSettlementHeaderMonetarySummation/ram:AllowanceTotalAmount |
| InvoiceDueDate | /rsm:SupplyChainTradeTransaction/ram:ApplicableHeaderTradeSettlement/ram:SpecifiedTradePaymentTerms/ram:DueDateDateTime/udt:DateTimeString |
| invoiceNumber | /rsm:ExchangedDocument/ram:ID |
| InvoiceOrderNumber | /rsm:CrossIndustryInvoice/rsm:SupplyChainTradeTransaction/ram:ApplicableHeaderTradeAgreement/ram:BuyerOrderReferencedDocument/ram:IssuerAssignedID |
| InvoicingPeriodStart | /rsm:CrossIndustryInvoice/rsm:SupplyChainTradeTransaction/ram:ApplicableHeaderTradeSettlement/ram:BillingSpecifiedPeriod/ram:StartDateTime/udt:DateTimeString |
| InvoicingPeriodEnd | /rsm:CrossIndustryInvoice/rsm:SupplyChainTradeTransaction/ram:ApplicableHeaderTradeSettlement/ram:BillingSpecifiedPeriod/ram:EndDateTime/udt:DateTimeString |
| InvoicePrepaidAmount | /rsm:CrossIndustryInvoice/rsm:SupplyChainTradeTransaction/ram:ApplicableHeaderTradeSettlement/ram:SpecifiedTradeSettlementHeaderMonetarySummation/ram:TotalPrepaidAmount |
| InvoiceTaxAmount1 | /rsm:CrossIndustryInvoice/rsm:SupplyChainTradeTransaction/ram:ApplicableHeaderTradeSettlement/ram:ApplicableTradeTax[1]/ram:CalculatedAmount |
| InvoiceTaxAmount2 | /rsm:CrossIndustryInvoice/rsm:SupplyChainTradeTransaction/ram:ApplicableHeaderTradeSettlement/ram:ApplicableTradeTax[2]/ram:CalculatedAmount |
| InvoiceTaxAmount3 | /rsm:CrossIndustryInvoice/rsm:SupplyChainTradeTransaction/ram:ApplicableHeaderTradeSettlement/ram:ApplicableTradeTax[3]/ram:CalculatedAmount |
| InvoiceTaxAmount4 | /rsm:CrossIndustryInvoice/rsm:SupplyChainTradeTransaction/ram:ApplicableHeaderTradeSettlement/ram:ApplicableTradeTax[4]/ram:CalculatedAmount |
| InvoiceNetAmount1 | /rsm:CrossIndustryInvoice/rsm:SupplyChainTradeTransaction/ram:ApplicableHeaderTradeSettlement/ram:ApplicableTradeTax[1]/ram:BasisAmount |
| InvoiceNetAmount2 | /rsm:CrossIndustryInvoice/rsm:SupplyChainTradeTransaction/ram:ApplicableHeaderTradeSettlement/ram:ApplicableTradeTax[2]/ram:BasisAmount |
| InvoiceNetAmount3 | /rsm:CrossIndustryInvoice/rsm:SupplyChainTradeTransaction/ram:ApplicableHeaderTradeSettlement/ram:ApplicableTradeTax[3]/ram:BasisAmount |
| InvoiceNetAmount4 | /rsm:CrossIndustryInvoice/rsm:SupplyChainTradeTransaction/ram:ApplicableHeaderTradeSettlement/ram:ApplicableTradeTax[4]/ram:BasisAmount |
| InvoiceTaxCode1 | /rsm:CrossIndustryInvoice/rsm:SupplyChainTradeTransaction/ram:ApplicableHeaderTradeSettlement/ram:ApplicableTradeTax[1]/ram:CategoryCode |
| InvoiceTaxCode2 | /rsm:CrossIndustryInvoice/rsm:SupplyChainTradeTransaction/ram:ApplicableHeaderTradeSettlement/ram:ApplicableTradeTax[2]/ram:CategoryCode |
| InvoiceTaxCode3 | /rsm:CrossIndustryInvoice/rsm:SupplyChainTradeTransaction/ram:ApplicableHeaderTradeSettlement/ram:ApplicableTradeTax[3]/ram:CategoryCode |
| InvoiceTaxCode4 | /rsm:CrossIndustryInvoice/rsm:SupplyChainTradeTransaction/ram:ApplicableHeaderTradeSettlement/ram:ApplicableTradeTax[4]/ram:CategoryCode |
| InvoiceTaxCurrency | /rsm:CrossIndustryInvoice/rsm:SupplyChainTradeTransaction/ram:ApplicableHeaderTradeSettlement/ram:TaxCurrencyCode |
| InvoiceTaxDescription1 | /rsm:CrossIndustryInvoice/rsm:SupplyChainTradeTransaction/ram:ApplicableHeaderTradeSettlement/ram:ApplicableTradeTax[1]/ram:ExceptionReason |
| InvoiceTaxDescription2 | /rsm:CrossIndustryInvoice/rsm:SupplyChainTradeTransaction/ram:ApplicableHeaderTradeSettlement/ram:ApplicableTradeTax[2]/ram:ExceptionReason |
| InvoiceTaxDescription3 | /rsm:CrossIndustryInvoice/rsm:SupplyChainTradeTransaction/ram:ApplicableHeaderTradeSettlement/ram:ApplicableTradeTax[3]/ram:ExceptionReason |
| InvoiceTaxDescription4 | /rsm:CrossIndustryInvoice/rsm:SupplyChainTradeTransaction/ram:ApplicableHeaderTradeSettlement/ram:ApplicableTradeTax[4]/ram:ExceptionReason |
| InvoiceTaxRate1 | /rsm:CrossIndustryInvoice/rsm:SupplyChainTradeTransaction/ram:ApplicableHeaderTradeSettlement/ram:ApplicableTradeTax[1]/ram:RateApplicablePercent |
| InvoiceTaxRate2 | /rsm:CrossIndustryInvoice/rsm:SupplyChainTradeTransaction/ram:ApplicableHeaderTradeSettlement/ram:ApplicableTradeTax[2]/ram:RateApplicablePercent |
| InvoiceTaxRate3 | /rsm:CrossIndustryInvoice/rsm:SupplyChainTradeTransaction/ram:ApplicableHeaderTradeSettlement/ram:ApplicableTradeTax[3]/ram:RateApplicablePercent |
| InvoiceTaxRate4 | /rsm:CrossIndustryInvoice/rsm:SupplyChainTradeTransaction/ram:ApplicableHeaderTradeSettlement/ram:ApplicableTradeTax[4]/ram:RateApplicablePercent |
| InvoiceTaxType1 | /rsm:CrossIndustryInvoice/rsm:SupplyChainTradeTransaction/ram:ApplicableHeaderTradeSettlement/ram:ApplicableTradeTax[1]/ram:TypeCode |
| InvoiceTaxType2 | /rsm:CrossIndustryInvoice/rsm:SupplyChainTradeTransaction/ram:ApplicableHeaderTradeSettlement/ram:ApplicableTradeTax[2]/ram:TypeCode |
| InvoiceTaxType3 | /rsm:CrossIndustryInvoice/rsm:SupplyChainTradeTransaction/ram:ApplicableHeaderTradeSettlement/ram:ApplicableTradeTax[3]/ram:TypeCode |
| InvoiceTaxType4 | /rsm:CrossIndustryInvoice/rsm:SupplyChainTradeTransaction/ram:ApplicableHeaderTradeSettlement/ram:ApplicableTradeTax[4]/ram:TypeCode |
| InvoiceTotalLineAmount | /rsm:CrossIndustryInvoice/rsm:SupplyChainTradeTransaction/ram:ApplicableHeaderTradeSettlement/ram:SpecifiedTradeSettlementHeaderMonetarySummation/ram:LineTotalAmount |
| InvoiceTotalVATAmount |
/rsm:CrossIndustryInvoice/rsm:SupplyChainTradeTransaction/ram:ApplicableHeaderTradeSettlement/ram:SpecifiedTradeSettlementHeaderMonetarySummation/ram:TaxTotalAmount If multiple TotalTaxAmount values exist with different currencies, TotalTaxAmount maps to the matching InvoiceCurrency field. |
| InvoiceTotalVatExcludedAmount | /rsm:CrossIndustryInvoice/rsm:SupplyChainTradeTransaction/ram:ApplicableHeaderTradeSettlement/ram:SpecifiedTradeSettlementHeaderMonetarySummation/ram:TaxBasisTotalAmount |
| InvoiceTotalVatIncludedAmount |
/rsm:CrossIndustryInvoice/rsm:SupplyChainTradeTransaction/ram:ApplicableHeaderTradeSettlement/ram:SpecifiedTradeSettlementHeaderMonetarySummation/ram:DuePayableAmount If this field does not exist, GrandTotalAmount is used. |
| InvoicingPeriodEnd | /rsm:CrossIndustryInvoice/rsm:SupplyChainTradeTransaction/ram:ApplicableHeaderTradeSettlement/ram:BillingSpecifiedPeriod/ram:EndDateTime/udt:DateTimeString |
| InvoicingPeriodStart | /rsm:CrossIndustryInvoice/rsm:SupplyChainTradeTransaction/ram:ApplicableHeaderTradeSettlement/ram:BillingSpecifiedPeriod/ram:StartDateTime/udt:DateTimeString |
| PaymentReferenceNumber | /rsm:CrossIndustryInvoiceType)/rsm:SupplyChainTradeTransaction/ram:ApplicableHeaderTradeSettlement/ram:PaymentReference |
| PaymentTerms |
/rsm:SpecifiedSupplyChainTradeTransaction/ram:ApplicableSupplyChainTradeSettlement/ram:SpecifiedTradePaymentTerms/ram:Description Since the text is often long, it is added at the top of the first page of the Invoice Notes page(s). |
| PaymentTermsInterest | /rsm:SupplyChainTradeTransaction/ram:ApplicableSupplyChainTradeSettlement/ram:SpecifiedTradePaymentTerms/ram:ApplicableTradePaymentPenaltyTerms/ram:CalculationPercent |
| PaymentType | /rsm:SupplyChainTradeTransaction/ram:ApplicableSupplyChainTradeSettlement/ram:SpecifiedTradeSettlementPaymentMeans/ram:TypeCode |
| SupplierIBAN1 | /rsm:SupplyChainTradeTransaction/ram:ApplicableHeaderTradeSettlement/ram:SpecifiedTradeSettlementPaymentMeans[1]/ram:PayeePartyCreditorFinancialAccount/ram:IBANID |
| SupplierIBAN2 | /rsm:SupplyChainTradeTransaction/ram:ApplicableHeaderTradeSettlement/ram:SpecifiedTradeSettlementPaymentMeans[2]/ram:PayeePartyCreditorFinancialAccount/ram:IBANID |
| SupplierIBAN3 | /rsm:SupplyChainTradeTransaction/ram:ApplicableHeaderTradeSettlement/ram:SpecifiedTradeSettlementPaymentMeans[3]/ram:PayeePartyCreditorFinancialAccount/ram:IBANID |
| SupplierIBAN4 | /rsm:SupplyChainTradeTransaction/ram:ApplicableHeaderTradeSettlement/ram:SpecifiedTradeSettlementPaymentMeans[4]/ram:PayeePartyCreditorFinancialAccount/ram:IBANID |
| SupplierSWIFT1 | /rsm:SupplyChainTradeTransaction/ram:ApplicableHeaderTradeSettlement/ram:SpecifiedTradeSettlementPaymentMeans[1]/ram:PayeeSpecifiedCreditorFinancialInstitution/ram:BICID |
| SupplierSWIFT2 | /rsm:SupplyChainTradeTransaction/ram:ApplicableHeaderTradeSettlement/ram:SpecifiedTradeSettlementPaymentMeans[2]/ram:PayeeSpecifiedCreditorFinancialInstitution/ram:BICID |
| SupplierSWIFT3 | /rsm:SupplyChainTradeTransaction/ram:ApplicableHeaderTradeSettlement/ram:SpecifiedTradeSettlementPaymentMeans[3]/ram:PayeeSpecifiedCreditorFinancialInstitution/ram:BICID |
| SupplierSWIFT4 | /rsm:SupplyChainTradeTransaction/ram:ApplicableHeaderTradeSettlement/ram:SpecifiedTradeSettlementPaymentMeans[4]/ram:PayeeSpecifiedCreditorFinancialInstitution/ram:BICID |
| SupplierTaxNumber1 | /ram:SellerTradeParty/ram:SpecifiedTaxRegistration/ram:ID
...where the attribe schemeID=”VA” |
| TotalTaxAmountInTaxCurrency |
/rsm:CrossIndustryInvoice/rsm:SupplyChainTradeTransaction/ram:ApplicableHeaderTradeSettlement/ram:SpecifiedTradeSettlementHeaderMonetarySummation/ram:TaxTotalAmount ...where the CurrencyID attribute of TaxTotalAmount is same as TaxCurrencyCode. |
| Line-item fields | |
| LIT_ArticleIdentifier | /rsm:CrossIndustryInvoice/rsm:SupplyChainTradeTransaction/ram:IncludedSupplyChainTradeLineItem/ram:SpecifiedTradeProduct/ram:SellerAssignedID |
| LIT_ArticleName | /rsm:CrossIndustryInvoice/rsm:SupplyChainTradeTransaction/ram:IncludedSupplyChainTradeLineItem/ram:SpecifiedTradeProduct/ram:Name |
| LIT_BuyerArticleNumber | /rsm:CrossIndustryInvoice/rsm:SupplyChainTradeTransaction/ram:IncludedSupplyChainTradeLineItem/ram:SpecifiedTradeProduct/ram:BuyerAssignedID |
| LIT_DeliveredQuantity | /rsm:CrossIndustryInvoice/rsm:SupplyChainTradeTransaction/ram:IncludedSupplyChainTradeLineItem/ram:SpecifiedLineTradeDelivery/ram:BilledQuantity |
| LIT_DeliveredQuantityUnitCode | /rsm:CrossIndustryInvoice/rsm:SupplyChainTradeTransaction/ram:IncludedSupplyChainTradeLineItem/ram:SpecifiedLineTradeDelivery/ram:BilledQuantity/@unitCode |
| LIT_DeliveryCost |
/rsm:CrossIndustryInvoice/rsm:SupplyChainTradeTransaction/ram:IncludedSupplyChainTradeLineItem/ram:SpecifiedLineTradeSettlement/ram:SpecifiedTradeAllowanceCharge[2]/ram:ActualAmount /rsm:CrossIndustryInvoice/rsm:SupplyChainTradeTransaction/ram:IncludedSupplyChainTradeLineItem/ram:SpecifiedLineTradeSettlement/ram:SpecifiedTradeAllowanceCharge[1]/ram:ChargeIndicator/udt:Indicator = True |
| LIT_DeliveryDate1 | /rsm:CrossIndustryInvoice/rsm:SupplyChainTradeTransaction/ram:IncludedSupplyChainTradeLineItem[1]/ram:SpecifiedLineTradeSettlement/ram:BillingSpecifiedPeriod/ram:StartDateTime/udt:DateTimeString |
| LIT_DeliveryDate2 | /rsm:CrossIndustryInvoice/rsm:SupplyChainTradeTransaction/ram:IncludedSupplyChainTradeLineItem[1]/ram:SpecifiedLineTradeSettlement/ram:BillingSpecifiedPeriod/ram:EndDateTime/udt:DateTimeString |
| LIT_VatDescription | /rsm:CrossIndustryInvoice/rsm:SupplyChainTradeTransaction/ram:IncludedSupplyChainTradeLineItem[1]/ram:SpecifiedLineTradeSettlement/ram:ApplicableTradeTax/ram:ExcemptionReason |
| LIT_DiscountAmount | /rsm:CrossIndustryInvoice/rsm:SupplyChainTradeTransaction/ram:IncludedSupplyChainTradeLineItem/ram:SpecifiedLineTradeSettlement/ram:SpecifiedTradeAllowanceCharge[2]/ram:ActualAmount
...when /rsm:CrossIndustryInvoice/rsm:SupplyChainTradeTransaction/ram:IncludedSupplyChainTradeLineItem/ram:SpecifiedLineTradeSettlement/ram:SpecifiedTradeAllowanceCharge[1]/ram:ChargeIndicator/udt:Indicator = False |
| LIT_DiscountPercent | /rsm:CrossIndustryInvoice/rsm:SupplyChainTradeTransaction/ram:IncludedSupplyChainTradeLineItem/ram:SpecifiedLineTradeSettlement/ram:SpecifiedTradeAllowanceCharge[1]/ram:CalculationPercent
...when /rsm:CrossIndustryInvoice/rsm:SupplyChainTradeTransaction/ram:IncludedSupplyChainTradeLineItem/ram:SpecifiedLineTradeSettlement/ram:SpecifiedTradeAllowanceCharge[1]/ram:ChargeIndicator/udt:Indicator = False |
| LIT_OrderNumber | /rsm:CrossIndustryInvoice/rsm:SupplyChainTradeTransaction/ram:IncludedSupplyChainTradeLineItem/ram:SpecifiedLineTradeAgreement/ram:BuyerOrderReferencedDocument/ram:IssuerAssignedID |
| LIT_PO_RowIdentifier | /rsm:CrossIndustryInvoice/rsm:SupplyChainTradeTransaction/ram:IncludedSupplyChainTradeLineItem/ram:SpecifiedLineTradeAgreement/ram:BuyerOrderReferencedDocument/ram:LineID |
| LIT_RowIdentifier | /rsm:CrossIndustryInvoice/rsm:SupplyChainTradeTransaction/ram:IncludedSupplyChainTradeLineItem/ram:AssociatedDocumentLineDocument/ram:LineID |
| LIT_UnitPriceAmount | SpecifiedLineTradeAgreement/NetPriceProductTradePrice/ChargeAmount |
| LIT_UnitPriceBasis | /rsm:CrossIndustryInvoice/rsm:SupplyChainTradeTransaction/ram:IncludedSupplyChainTradeLineItem/ram:SpecifiedLineTradeAgreement/ram:NetPriceProductTradePrice/ram:BasisQuantity |
| LIT_UniqueArticleNumber | /rsm:CrossIndustryInvoice/rsm:SupplyChainTradeTransaction/ram:IncludedSupplyChainTradeLineItem[1]/ram:SpecifiedTradeProduct/ram:GlobalID |
| LIT_VatAmount | /rsm:CrossIndustryInvoice/rsm:SupplyChainTradeTransaction/ram:IncludedSupplyChainTradeLineItem[1]/ram:SpecifiedLineTradeSettlement/ram:ApplicableTradeTax/ram:CalculatedAmount |
| LIT_VatCode | /rsm:CrossIndustryInvoice/rsm:SupplyChainTradeTransaction/ram:IncludedSupplyChainTradeLineItem[1]/ram:SpecifiedLineTradeSettlement/ram:ApplicableTradeTax/ram:CategoryCode |
| LIT_VatExcludedAmount | SpecifiedLineTradeSettlement/SpecifiedTradeSettlementLineMonetarySummation/LineTotalAmount |
| LIT_VatRate | /rsm:CrossIndustryInvoice/rsm:SupplyChainTradeTransaction/ram:IncludedSupplyChainTradeLineItem[1]/ram:SpecifiedLineTradeSettlement/ram:ApplicableTradeTax/ram:RateApplicablePercent |
| Attachment fields | |
| ID | Not mapped |
| FileName | Not mapped |
| EmbeddedValue | Not mapped |
| EmbeddedInfo | Not mapped |
| DataURI | Not mapped |
| SchemeURI | Not mapped |
| DataType | Not mapped |
| LinkType | Not mapped |
| AdditionalInfo | Not mapped |
| Invoice note field | |
| InvoiceNote |
/rsm:CrossIndustryInvoice/rsm:ExchangedDocument/ram:IncludedNote/ram:Content If a subject code (/rsm:CrossIndustryInvoice/rsm:ExchangedDocument/ram:IncludedNote/ram:SubjectCode) is set to TXD , it has the highest priority and Content is mapped. If there is no TXD subject code, subject code REG is mapped. If there is no TXD or REG subject code, Content is mapped regardless of the subject code. |
ZUGFeRD 2.0
| Tungsten AP Essentials internal field name | ZUGFeRD 2.0 |
|---|---|
| Buyer fields | |
| Name | BuyerTradeParty/Name |
| Identifier | BuyerTradeParty/GlobalID |
| BuyerVATRegistrationNumber | BuyerTradeParty/SpecifiedTaxRegistration/ID
...where the attribute schemeID=”VA” |
| CountryCode | BuyerTradeParty/PostalTradeAddress/CountryID |
| CountryName | |
| BuyerAddressPostalCode | BuyerTradeParty/PostalTradeAddress/PostcodeCode |
| Street | BuyerTradeParty/PostalTradeAddress/LineOne |
| StreetSupplement | BuyerTradeParty/PostalTradeAddress/LineTwo |
| POBox | |
| City | BuyerTradeParty/PostalTradeAddress/CityName |
| TelephoneNumber | BuyerTradeParty/DefinedTradeContact/TelephoneUniversalCommunication/CompleteNumber |
| FaxNumber | BuyerTradeParty/DefinedTradeContact/FaxUniversalCommunication/CompleteNumber |
| BuyerTradeParty/DefinedTradeContact/EmailURIUniversalCommunication/URIID | |
| BuyerTaxNumber1 | |
| BuyerTaxNumber2 | |
| Supplier fields | |
| Name | SellerTradeParty/Name |
| Identifier | SellerTradeParty/GlobalID |
| Street | SellerTradeParty/PostalTradeAddress/LineOne |
| StreetSupplement | SellerTradeParty/PostalTradeAddress/LineTwo |
| PostalCode | SellerTradeParty/PostalTradeAddress/PostcodeCode |
| City | SellerTradeParty/PostalTradeAddress/CityName |
| CountryCode | SellerTradeParty/PostalTradeAddress/CountryID |
| TelephoneNumber | SellerTradeParty/DefinedTradeContact/TelephoneUniversalCommunication/CompleteNumber |
| FaxNumber | SellerTradeParty/DefinedTradeContact/FaxUniversalCommunication/CompleteNumber |
| SupplierVATRegistrationNumber | SellerTradeParty/SpecifiedTaxRegistration/ID where attribute schemeID="VA" |
| SupplierTaxNo1 | SellerTradeParty/SpecifiedTaxRegistration/ID where the attribute schemeID="FC" |
| SellerTradeParty/DefinedTradeContact/EmailURIUniversalCommunication/URIID | |
| Standard fields | |
| BuyerContactPersonName | BuyerTradeParty/DefinedTradeContact/PersonName |
| DeliveryDate | SupplyChainTradeTransaction/ApplicableSupplyChainTradeDelivery/ActualDeliverySupplyChainEvent/OccurrenceDateTime/DateTimeString |
| DeliveryTerms | SupplyChainTradeTransaction/SupplyChainTradeTransaction/ApplicableTradeDeliveryTerms |
| InvoiceCredit | if
SupplyChainTradeTransaction/ApplicableSupplyChainTradeSettlement/SpecifiedTradeSettlementMonetarySummation/GrandTotalAmount < 0
then Credit else Debit |
| InvoiceCurrency | SupplyChainTradeTransaction/ApplicableHeaderTradeSettlement/InvoiceCurrencyCode |
| InvoiceDate | ExchangedDocument/IssueDateTime/DateTimeString |
| InvoiceDiscountAmount | SupplyChainTradeTransaction/ApplicableSupplyChainTradeSettlement/SpecifiedTradePaymentTerms/ApplicableTradePaymentDiscountTerms/ActualDiscountAmount |
| InvoiceDueDate | SupplyChainTradeTransaction/ApplicableHeaderTradeSettlement/SpecifiedTradePaymentTerms/DueDateDateTime/DateTimeString |
| invoiceNumber | ExchangedDocument/ID |
| InvoiceOrderNumber | SupplyChainTradeTransaction/ApplicableHeaderTradeSettlement/BuyerOrderReferencedDocument/ID |
| InvoiceTotalLineAmount | SupplyChainTradeTransaction/ApplicableHeaderTradeSettlement/ApplicableTradeTax/CalculatedAmount |
| InvoiceTotalVATAmount | SupplyChainTradeTransaction/ApplicableHeaderTradeSettlement/ApplicableTradeTax/CalculatedAmount |
| InvoiceTotalVatExcludedAmount | SupplyChainTradeTransaction/ApplicableHeaderTradeSettlement/ApplicableTradeTax/BasisAmount |
| InvoiceTotalVatIncludedAmount | SupplyChainTradeTransaction/ApplicableHeaderTradeSettlement/SpecifiedTradeSettlementHeaderMonetarySummation/GrandTotalAmount |
| InvoiceTotalVatRatePercent | First instance of:
SupplyChainTradeTransaction/ApplicableSupplyChainTradeSettlement/ApplicableTradeTax/ApplicablePercent |
| PaymentReferenceNumber | SupplyChainTradeTransaction/ApplicableSupplyChainTradeSettlement/PaymentReference |
| PaymentTerms | Taken from:
SpecifiedSupplyChainTradeTransaction/ApplicableSupplyChainTradeSettlement/ SpecifiedTradePaymentTerms/Description Since the text is often long, it is added at the top of the first page of the Invoice Notes page(s). |
| PaymentTermsInterest | SupplyChainTradeTransaction/ApplicableSupplyChainTradeSettlement/SpecifiedTradePaymentTerms/ApplicableTradePaymentPenaltyTerms/CalculationPercent |
| PaymentType | SupplyChainTradeTransaction/ApplicableSupplyChainTradeSettlement/SpecifiedTradeSettlementPaymentMeans/TypeCode |
| SupplierIBAN1 |
SupplyChainTradeTransaction/ApplicableHeaderTradeSettlement/SpecifiedTradeSettlementPaymentMeans[1]/PayeePartyCreditorFinancialAccount/IBANID |
| SupplierIBAN2 | SupplyChainTradeTransaction/ApplicableHeaderTradeSettlement/SpecifiedTradeSettlementPaymentMeans[2]/PayeePartyCreditorFinancialAccount/IBANID |
| SupplierIBAN3 | SupplyChainTradeTransaction/ApplicableHeaderTradeSettlement/SpecifiedTradeSettlementPaymentMeans[3]/PayeePartyCreditorFinancialAccount/IBANID |
| SupplierIBAN4 | SupplyChainTradeTransaction/ApplicableHeaderTradeSettlement/SpecifiedTradeSettlementPaymentMeans[4]/PayeePartyCreditorFinancialAccount/IBANID |
| SupplierSWIFT1 | SupplyChainTradeTransaction/ApplicableHeaderTradeSettlement/SpecifiedTradeSettlementPaymentMeans[1]/PayeeSpecifiedCreditorFinancialInstitution/BICID |
| SupplierSWIFT2 | SupplyChainTradeTransaction/ApplicableHeaderTradeSettlement/SpecifiedTradeSettlementPaymentMeans[2]/PayeeSpecifiedCreditorFinancialInstitution/BICID |
| SupplierSWIFT3 | SupplyChainTradeTransaction/ApplicableHeaderTradeSettlement/SpecifiedTradeSettlementPaymentMeans[3]/PayeeSpecifiedCreditorFinancialInstitution/BICID |
| SupplierSWIFT4 | SupplyChainTradeTransaction/ApplicableHeaderTradeSettlement/SpecifiedTradeSettlementPaymentMeans[4]/PayeeSpecifiedCreditorFinancialInstitution/BICID |
| SupplierTaxNumber1 | SellerTradeParty/SpecifiedTaxRegistration/ID
...where the attribe schemeID=”VA” |
| Line-item fields | |
| Note that the ParentNode for these is:
IncludedSupplyChainTradeLineItem |
|
| LIT_ArticleIdentifier | SpecifiedTradeProduct/GlobalID","SpecifiedTradeProduct/SellerAssignedID |
| LIT_ArticleName | SpecifiedTradeProduct/Name |
| LIT_DeliveredQuantity | SpecifiedLineTradeDelivery/BilledQuantity |
| LIT_DeliveredQuantityUnitCode | SpecifiedLineTradeDelivery/BilledQuantity/@unitCode |
| LIT_OrderNumber | SpecifiedLineTradeSettlement/BuyerOrderReferencedDocument/ID |
| LIT_RowIdentifier | AssociatedDocumentLineDocument/LineID |
| LIT_UnitPriceAmount | SpecifiedLineTradeAgreement/NetPriceProductTradePrice/ChargeAmount |
| LIT_VatExcludedAmount | SpecifiedLineTradeSettlement/SpecifiedTradeSettlementLineMonetarySummation/LineTotalAmount |
| LIT_VatRate | SpecifiedLineTradeSettlement/ApplicableTradeTax/RateApplicablePercent |
| Attachment fields | |
| ID | Not mapped |
| FileName | Not mapped |
| EmbeddedValue | Not mapped |
| EmbeddedInfo | Not mapped |
| DataURI | Not mapped |
| SchemeURI | Not mapped |
| DataType | Not mapped |
| LinkType | Not mapped |
| AdditionalInfo | Not mapped |
| Invoice note field | |
| InvoiceNote | Since the text is often very long, it is put on the note page of the invoice.
Payment Terms are listed first. The value is taken from: SupplyChainTradeTransaction/ApplicableSupplyChainTradeSettlement/SpecifiedTradePaymentTerms/Description All notes on fields are listed after payment terms, and they are extracted from one or several nodes with this path: HeaderExchangedDocument/IncludeNote/Content |
ZUGFeRD 1.0
| Tungsten AP Essentials internal field name | ZUGFeRD 1.0 |
|---|---|
| Buyer fields | |
| Name | BuyerTradeParty/Name |
| Identifier | BuyerTradeParty/GlobalID |
| BuyerVATRegistrationNumber | BuyerTradeParty/SpecifiedTaxRegistration/ID where the attribute schemeID=”VA” |
| CountryCode | BuyerTradeParty/PostalTradeAddress/CountryID |
| PostalCode | BuyerTradeParty/PostalTradeAddress/PostcodeCode |
| Street | BuyerTradeParty/PostalTradeAddress/LineOne |
| StreetSupplement | BuyerTradeParty/PostalTradeAddress/LineTwo |
| City | BuyerTradeParty/PostalTradeAddress/CityName |
| TelephoneNumber | BuyerTradeParty/DefinedTradeContact/TelephoneUniversalCommunication/CompleteNumber |
| FaxNumber | BuyerTradeParty/DefinedTradeContact/FaxUniversalCommunication/CompleteNumber |
| BuyerTradeParty/DefinedTradeContact/EmailURIUniversalCommunication/URIID | |
| Supplier fields | |
| Name | SellerTradeParty/Name |
| Identifier | SellerTradeParty/GlobalID |
| Street | SellerTradeParty/PostalTradeAddress/LineOne |
| StreetSupplement | SellerTradeParty/PostalTradeAddress/LineTwo |
| PostalCode | SellerTradeParty/PostalTradeAddress/PostcodeCode |
| City | SellerTradeParty/PostalTradeAddress/CityName |
| CountryCode | SellerTradeParty/PostalTradeAddress/CountryID |
| TelephoneNumber | SellerTradeParty/DefinedTradeContact/TelephoneUniversalCommunication/CompleteNumber |
| FaxNumber | SellerTradeParty/DefinedTradeContact/FaxUniversalCommunication/ CompleteNumber |
| SupplierVATRegistrationNumber | SellerTradeParty/SpecifiedTaxRegistration/ID where attribute schemeID="VA" |
| SupplierTaxNo1 | SellerTradeParty/SpecifiedTaxRegistration/ID where the attribute schemeID="FC" |
| SellerTradeParty /DefinedTradeContact/EmailURIUniversalCommunication/URIID | |
| Standard fields | |
| BuyerContactPersonName | BuyerTradeParty/DefinedTradeContact/PersonName |
| DeliveryDate | SpecifiedSupplyChainTradeTransaction/ApplicableSupplyChainTradeDelivery/ActualDeliverySupplyChainEvent/OccurrenceDateTime/DateTimeString |
| DeliveryTerms | SpecifiedSupplyChainTradeTransaction/ApplicableSupplyChainTradeAgreement/ApplicableTradeDeliveryTerms |
| InvoiceCredit | If SpecifiedSupplyChainTradeTransaction/ApplicableSupplyChainTradeSettlement/
SpecifiedTradeSettlementMonetarySummation/ GrandTotalAmount < 0
then Credit else Debit |
| InvoiceCurrency | SpecifiedSupplyChainTradeTransaction/ApplicableSupplyChainTradeSettlement/ SpecifiedTradeSettlementMonetarySummation/ GrandTotalAmount/@currencyID |
| InvoiceDate | HeaderExchangedDocument/IssueDateTime/DateTimeString |
| InvoiceDiscountAmount | SpecifiedSupplyChainTradeTransaction/ApplicableSupplyChainTradeSettlement/ SpecifiedTradePaymentTerms/ApplicableTradePaymentDiscountTerms/ActualDiscountAmount |
| InvoiceDueDate | SpecifiedSupplyChainTradeTransaction/ApplicableSupplyChainTradeSettlement/ SpecifiedTradePaymentTerms/DueDateDateTime/DateTimeString |
| invoiceNumber | HeaderExchangedDocument/ID |
| InvoiceOrderNumber | SpecifiedSupplyChainTradeTransaction/ApplicableSupplyChainTradeAgreement/ BuyerOrderReferencedDocument/ID |
| InvoiceTotalVATAmount | SpecifiedSupplyChainTradeTransaction/ApplicableSupplyChainTradeSettlement/SpecifiedTradeSettlementMonetarySummation/TaxTotalAmount |
| InvoiceTotalVatExcludedAmount | SpecifiedSupplyChainTradeTransaction/ApplicableSupplyChainTradeSettlement/SpecifiedTradeSettlementMonetarySummation/TaxBasisTotalAmount |
| InvoiceTotalVatIncludedAmount | SpecifiedSupplyChainTradeTransaction/ApplicableSupplyChainTradeSettlement/SpecifiedTradeSettlementMonetarySummation/GrandTotalAmount |
| InvoiceTotalVatRatePercent | First instance of:
SpecifiedSupplyChainTradeTransaction/ApplicableSupplyChainTradeSettlement /ApplicableTradeTax/ApplicablePercent |
| PaymentReferenceNumber | SpecifiedSupplyChainTradeTransaction/ApplicableSupplyChainTradeSettlement/PamentReference |
| PaymentTerms | Taken from:
SpecifiedSupplyChainTradeTransaction/ApplicableSupplyChainTradeSettlement/ SpecifiedTradePaymentTerms/Description Since the text is often long, it is added at the top of the first page of the Invoice Notes page(s). |
| PaymentTermsInterest | SpecifiedSupplyChainTradeTransaction/ApplicableSupplyChainTradeSettlement/ SpecifiedTradePaymentTerms/ApplicableTradePaymentPenaltyTerms/ CalculationPercent |
| PaymentType | SpecifiedSupplyChainTradeTransaction/ApplicableSupplyChainTradeSettlement/ SpecifiedTradeSettlementPaymentMeans/TypeCode |
| SupplierIBAN1 | CrossIndustryDocument/SpecifiedSupplyChainTradeTransaction/ApplicableSupplyChainTradeSettlement/SpecifiedTradeSettlementPaymentMeans[1]/PayeePartyCreditorFinancialAccount/IBANID |
| SupplierIBAN2 | CrossIndustryDocument/SpecifiedSupplyChainTradeTransaction/ApplicableSupplyChainTradeSettlement/SpecifiedTradeSettlementPaymentMeans[2]/PayeePartyCreditorFinancialAccount/IBANID |
| SupplierIBAN3 | CrossIndustryDocument/SpecifiedSupplyChainTradeTransaction/ApplicableSupplyChainTradeSettlement/SpecifiedTradeSettlementPaymentMeans[3]/PayeePartyCreditorFinancialAccount/IBANID |
| SupplierIBAN4 | CrossIndustryDocument/SpecifiedSupplyChainTradeTransaction/ApplicableSupplyChainTradeSettlement/SpecifiedTradeSettlementPaymentMeans[4]/PayeePartyCreditorFinancialAccount/IBANID |
| SupplierSWIFT1 | CrossIndustryDocument/SpecifiedSupplyChainTradeTransaction/ApplicableSupplyChainTradeSettlement/SpecifiedTradeSettlementPaymentMeans[1]/PayeeSpecifiedCreditorFinancialInstitution/BICID |
| SupplierSWIFT2 | CrossIndustryDocument/SpecifiedSupplyChainTradeTransaction/ApplicableSupplyChainTradeSettlement/SpecifiedTradeSettlementPaymentMeans[2]/PayeeSpecifiedCreditorFinancialInstitution/BICID |
| SupplierSWIFT3 | CrossIndustryDocument/SpecifiedSupplyChainTradeTransaction/ApplicableSupplyChainTradeSettlement/SpecifiedTradeSettlementPaymentMeans[3]/PayeeSpecifiedCreditorFinancialInstitution/BICID |
| SupplierSWIFT4 | CrossIndustryDocument/SpecifiedSupplyChainTradeTransaction/ApplicableSupplyChainTradeSettlement/SpecifiedTradeSettlementPaymentMeans[4]/PayeeSpecifiedCreditorFinancialInstitution/BICID |
| SupplierTaxNumber1 | SellerTradeParty/SpecifiedTaxRegistration/ID where the attribe schemeID=”VA” |
| Line-item fields | |
| Note that the ParentNode for these is:
IncludedSupplyChainTradeLineItem |
|
| LIT_ArticleIdentifier | /SpecifiedTradeProduct/SellerAssignedID |
| LIT_ArticleName | /SpecifiedTradeProduct/Name |
| LIT_DeliveredQuantity | /SpecifiedSupplyChainTradeDelivery/BilledQuantity |
| LIT_DeliveredQuantityUnitCode | /SpecifiedSupplyChainTradeDelivery/BilledQuantity/@UnitC |
| LIT_OrderNumber | /SpecifiedSupplyChainTradeAgreement/BuyerOrderReferencedDocument/ID |
| LIT_RowIdentifier | /AssociatedDocumentLineDocument/LineID |
| LIT_UnitPriceAmount | /SpecifiedSupplyChainTradeAgreement/NetPriceProductTradePrice/ChargeAmount |
| LIT_VatExcludedAmount | /SpecifiedSupplyChainTradeAgreement/NetPriceProductTradePrice/ChargeAmount |
| LIT_VatRate | /SpecifiedSupplyChainTradeSettlement/ApplicableTradeTax/ApplicablePercent |
| Attachment fields | |
| ID | Not mapped |
| FileName | Not mapped |
| EmbeddedValue | Not mapped |
| EmbeddedInfo | Not mapped |
| DataURI | Not mapped |
| SchemeURI | Not mapped |
| DataType | Not mapped |
| LinkType | Not mapped |
| AdditionalInfo | Not mapped |
| Invoice note field | |
| InvoiceNote | Since the text is often very long, it is put on the note page of the invoice.
Payment Terms are listed first. The value is taken from: SpecifiedSupplyChainTradeTransaction/ApplicableSupplyChainTradeSettlement/ SpecifiedTradePaymentTerms/Description All notes on fields are listed after payment terms, and they are extracted from one or several nodes with this path: HeaderExchangedDocument/IncludeNote/Content |
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.