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 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 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 ReadSoft representative.
|
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 |
| 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 | |
| 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 attribe 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 |
Supported XML invoice standard formats
Processing XML invoices using COLLECTOR: Overview
Optimizing XML invoice definitions
Creating rules to map values for fields in XML invoices