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 |
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_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.