XML invoice standard - ZUGFeRD

ZUGFeRD is an XML invoice standard that is used in Germany.

If you receive XML invoices from one or more companies from there, the invoices may come in this format.

This topic lists the Kofax ReadSoft Invoices field types that are normally mapped to elements in these documents and indicates where in the XML code the elements are normally found. The Kofax ReadSoft Invoices field types that are not normally mapped to XML elements are not listed here.

For more information on how the logic in Collector's intelligent XML functionality works with this standard, please see ReadSoft COLLECTOR Integration Specification.pdf. You can obtain this document from your Kofax representative.

Kofax ReadSoft Invoices field Location of element mapped in the XML code
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 BuyerTradePorty/PostalTradeAddress/LineTwo
City BuyerTradeParty/PostalTradeAddress/CityName
TelephoneNumber BuyerTradeParty/DefinedTradeContact/TelephoneUniversalCommunication/CompleteNumber
FaxNumber BuyerTradeParty/DefinedTradeContact/FaxUniversalCommunication/CompleteNumber
Email 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"
Email SellerTradeParty /DefinedTradeContact/EmailURIUniversalCommunication/URIID
Kofax ReadSoft Invoices Standard Field Types Location of element mapped in the XML code
BuyerContactReference 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/

ApplciableSupplyChainTradeAgreement/

BuyerOrderReferencedDocumen/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 PaymentReferenceNumber SpecifiedSupplyChainTradeTransaction/

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 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 attribute schemeID=”VA”
Line Item Fields Location of element mapped in the XML code

Note that the ParentNode for these is:

IncludedSupplyChainTradeLineItem

LIT_ArticleIdentifier /SpecifiedTradeProduct/SellerAssignedID
LIT_ArticleName /SpecifiedTradeProduct/Name
LIT_DeliveredQuantity /SpecifiedSupplyCainTradeDelivery/BilledQuantity
LIT_DeliveredQuantityUnitCode /SpecifiedSupplyChainTradeDelivery/BilledQuantity/@UnitC
LIT_OrderNumber /SpecifiedSupplyChainTradeAgreement/BuyerOrderReferenceDocument/ID
LIT_RowIdentifier /AssociatedDocumentLineDocument/LineID
LIT_UnitPriceAmount /SpecifiedSupplyChainTradeAgreement/NetPriceProductTradePrice/

ChargeAmount

LIT_VATExcludedAmount /SpecifiedSupplyChainTradeAgreement/

NetPriceProductTradePrice/

ChargeAmount

LIT_VATRate /SpecifiedSupplyChainTradeSettlement/ApplicableTradeTax/ApplicablePercent
Attachment fields Location of element mapped in the XML code
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 Location of element mapped in the XML code
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