Cross Industry Invoice (CII) standard (ZUGFeRD, Factur-X, XRechnung)
These tables show how Tungsten AP Essentials maps internal fields to the Cross-Industry Invoice (CII) standard used in ZUGFeRD, Factur-X, and 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 | CrossIndustryInvoice/SupplyChainTradeTransaction/ApplicableHeaderTradeAgreement/ContractReferenceDocument/IssuerAssignedID |
| BuyerContactReference † | CrossIndustryInvoice/SupplyChainTradeTransaction/ApplicableHeaderTradeAgreement/BuyerReference |
| BusinessProcessTypeId † | ExchangedDocumentContext/BusinessProcessSpecifiedDocumentContextParameter/ID |
| DeliveryAddressName | CrossIndustryInvoice/SupplyChainTradeTransaction/ApplicableHeaderTradeDelivery/ShipToTradeParty/Name |
| DeliveryAddressStreet | CrossIndustryInvoice/SupplyChainTradeTransaction/ApplicableHeaderTradeDelivery/ShipToTradeParty/PostalTradeAddress/LineOne
and CrossIndustryInvoice/SupplyChainTradeTransaction/ApplicableHeaderTradeDelivery/ShipToTradeParty/PostalTradeAddress/LineTwo with a space between the values. |
| DeliveryAddressCity | CrossIndustryInvoice/SupplyChainTradeTransaction/ApplicableHeaderTradeDelivery/ShipToTradeParty/PostalTradeAddress/CityName |
| DeliveryAddressCountry | CrossIndustryInvoice/SupplyChainTradeTransaction/ApplicableHeaderTradeDelivery/ShipToTradeParty/PostalTradeAddress/CountryID |
| DeliveryAddressZip | CrossIndustryInvoice/SupplyChainTradeTransaction/ApplicableHeaderTradeDelivery/ShipToTradeParty/PostalTradeAddress/PostcodeCode |
| DeliveryCost | CrossIndustryInvoice/SupplyChainTradeTransaction/ApplicableHeaderTradeSettlement/SpecifiedTradeSettlementHeaderMonetarySummation/ChargeTotalAmount |
| DeliveryDate | CrossIndustryInvoice/SupplyChainTradeTransaction/ApplicableHeaderTradeDelivery/ActualDeliverySupplyChainEvent/OccurrenceDateTime/udt:DateTimeString/text() |
| DeliveryNote | CrossIndustryInvoice/SupplyChainTradeTransaction/ApplicableHeaderTradeDelivery/DespatchAdviceReferencedDocument/IssuerAssignedID |
| DeliveryTerms | SupplyChainTradeTransaction/ApplicableHeaderTradeAgreement/ApplicableTradeDeliveryTerms/Description |
| DiscountAmount1, DiscountAmount2, DiscountAmount3, DiscountAmount4 |
|
| InvoiceCredit |
InvoiceCredit is classified as credit if GrandTotal is a negative amount or if CrossIndustryInvoice/ExchangedDocument/TypeCode is set to any of these codes:
|
| InvoiceCurrency | CrossIndustryInvoice/SupplyChainTradeTransaction/ApplicableHeaderTradeSettlement/InvoiceCurrencyCode |
| InvoiceDate | ExchangedDocument/IssueDateTime/udt:DateTimeString |
| InvoiceDiscountAmount | CrossIndustryInvoice/SupplyChainTradeTransaction/ApplicableHeaderTradeSettlement/SpecifiedTradeSettlementHeaderMonetarySummation/AllowanceTotalAmount |
| InvoiceDueDate | SupplyChainTradeTransaction/ApplicableHeaderTradeSettlement/SpecifiedTradePaymentTerms/DueDateDateTime/udt:DateTimeString |
| invoiceNumber | ExchangedDocument/ID |
| InvoiceTypeId † | ExchangedDocument/TypeCode |
| InvoiceOrderNumber | CrossIndustryInvoice/SupplyChainTradeTransaction/ApplicableHeaderTradeAgreement/BuyerOrderReferencedDocument/IssuerAssignedID |
| SalesOrderNumber † | CrossIndustryInvoice/SupplyChainTradeTransaction/ApplicableHeaderTradeAgreement/SellerOrderReferencedDocument/IssuerAssignedID |
| ReceiptAdviceReference † | CrossIndustryInvoice/SupplyChainTradeTransaction/ApplicableHeaderTradeDelivery/ReceivingAdviceReferencedDocument/IssuerAssignedID |
| TenderReference † | CrossIndustryInvoice/SupplyChainTradeTransaction/ApplicableHeaderTradeAgreement/AdditionalReferencedDocument Takes the value from the node whose TypeCode child node equals "50". |
| ProjectNumber † | CrossIndustryInvoice/SupplyChainTradeTransaction/ApplicableHeaderTradeAgreement/SpecifiedProcuringProject/ID |
| InvoiceObject † | CrossIndustryInvoice/SupplyChainTradeTransaction/ApplicableHeaderTradeAgreement/AdditionalReferencedDocument Takes the value from the node whose TypeCode child node equals "130". |
| AdditionalReference1 † | CrossIndustryInvoice/SupplyChainTradeTransaction/ApplicableHeaderTradeAgreement/AdditionalReferencedDocument Takes the value from the node whose TypeCode child node equals "916". |
| InvoiceNoteText1 † | ExchangedDocument/IncludedNote/Content Takes the value from the first occurrence. |
| PrecedingInvoiceNumber † | SupplyChainTradeTransaction/ApplicableHeaderTradeSettlement/InvoiceReferencedDocument/IssuerAssignedID |
| BuyerEndpointID † | CrossIndustryInvoice/SupplyChainTradeTransaction/ApplicableHeaderTradeAgreement/BuyerTradeParty/URIUniversalCommunication/URIID |
| InvoicingPeriodStart | CrossIndustryInvoice/SupplyChainTradeTransaction/ApplicableHeaderTradeSettlement/BillingSpecifiedPeriod/StartDateTime/udt:DateTimeString |
| InvoicingPeriodEnd | CrossIndustryInvoice/SupplyChainTradeTransaction/ApplicableHeaderTradeSettlement/BillingSpecifiedPeriod/EndDateTime/udt:DateTimeString |
| InvoicePrepaidAmount | CrossIndustryInvoice/SupplyChainTradeTransaction/ApplicableHeaderTradeSettlement/SpecifiedTradeSettlementHeaderMonetarySummation/TotalPrepaidAmount |
| InvoiceTaxAmount1 | CrossIndustryInvoice/SupplyChainTradeTransaction/ApplicableHeaderTradeSettlement/ApplicableTradeTax[1]/CalculatedAmount |
| InvoiceTaxAmount2 | CrossIndustryInvoice/SupplyChainTradeTransaction/ApplicableHeaderTradeSettlement/ApplicableTradeTax[2]/CalculatedAmount |
| InvoiceTaxAmount3 | CrossIndustryInvoice/SupplyChainTradeTransaction/ApplicableHeaderTradeSettlement/ApplicableTradeTax[3]/CalculatedAmount |
| InvoiceTaxAmount4 | CrossIndustryInvoice/SupplyChainTradeTransaction/ApplicableHeaderTradeSettlement/ApplicableTradeTax[4]/CalculatedAmount |
| InvoiceNetAmount1 | CrossIndustryInvoice/SupplyChainTradeTransaction/ApplicableHeaderTradeSettlement/ApplicableTradeTax[1]/BasisAmount |
| InvoiceNetAmount2 | CrossIndustryInvoice/SupplyChainTradeTransaction/ApplicableHeaderTradeSettlement/ApplicableTradeTax[2]/BasisAmount |
| InvoiceNetAmount3 | CrossIndustryInvoice/SupplyChainTradeTransaction/ApplicableHeaderTradeSettlement/ApplicableTradeTax[3]/BasisAmount |
| InvoiceNetAmount4 | CrossIndustryInvoice/SupplyChainTradeTransaction/ApplicableHeaderTradeSettlement/ApplicableTradeTax[4]/BasisAmount |
| InvoiceTaxCode1 | CrossIndustryInvoice/SupplyChainTradeTransaction/ApplicableHeaderTradeSettlement/ApplicableTradeTax[1]/CategoryCode |
| InvoiceTaxCode2 | CrossIndustryInvoice/SupplyChainTradeTransaction/ApplicableHeaderTradeSettlement/ApplicableTradeTax[2]/CategoryCode |
| InvoiceTaxCode3 | CrossIndustryInvoice/SupplyChainTradeTransaction/ApplicableHeaderTradeSettlement/ApplicableTradeTax[3]/CategoryCode |
| InvoiceTaxCode4 | CrossIndustryInvoice/SupplyChainTradeTransaction/ApplicableHeaderTradeSettlement/ApplicableTradeTax[4]/CategoryCode |
| InvoiceTaxCurrency | CrossIndustryInvoice/SupplyChainTradeTransaction/ApplicableHeaderTradeSettlement/TaxCurrencyCode |
| InvoiceTaxDescription1 | CrossIndustryInvoice/SupplyChainTradeTransaction/ApplicableHeaderTradeSettlement/ApplicableTradeTax[1]/ExemptionReason |
| InvoiceTaxDescription2 | CrossIndustryInvoice/SupplyChainTradeTransaction/ApplicableHeaderTradeSettlement/ApplicableTradeTax[2]/ExemptionReason |
| InvoiceTaxDescription3 | CrossIndustryInvoice/SupplyChainTradeTransaction/ApplicableHeaderTradeSettlement/ApplicableTradeTax[3]/ExemptionReason |
| InvoiceTaxDescription4 | CrossIndustryInvoice/SupplyChainTradeTransaction/ApplicableHeaderTradeSettlement/ApplicableTradeTax[4]/ExemptionReason |
| InvoiceTaxRate1 | CrossIndustryInvoice/SupplyChainTradeTransaction/ApplicableHeaderTradeSettlement/ApplicableTradeTax[1]/RateApplicablePercent |
| InvoiceTaxRate2 | CrossIndustryInvoice/SupplyChainTradeTransaction/ApplicableHeaderTradeSettlement/ApplicableTradeTax[2]/RateApplicablePercent |
| InvoiceTaxRate3 | CrossIndustryInvoice/SupplyChainTradeTransaction/ApplicableHeaderTradeSettlement/ApplicableTradeTax[3]/RateApplicablePercent |
| InvoiceTaxRate4 | CrossIndustryInvoice/SupplyChainTradeTransaction/ApplicableHeaderTradeSettlement/ApplicableTradeTax[4]/RateApplicablePercent |
| InvoiceTaxType1 | CrossIndustryInvoice/SupplyChainTradeTransaction/ApplicableHeaderTradeSettlement/ApplicableTradeTax[1]/TypeCode |
| InvoiceTaxType2 | CrossIndustryInvoice/SupplyChainTradeTransaction/ApplicableHeaderTradeSettlement/ApplicableTradeTax[2]/TypeCode |
| InvoiceTaxType3 | CrossIndustryInvoice/SupplyChainTradeTransaction/ApplicableHeaderTradeSettlement/ApplicableTradeTax[3]/TypeCode |
| InvoiceTaxType4 | CrossIndustryInvoice/SupplyChainTradeTransaction/ApplicableHeaderTradeSettlement/ApplicableTradeTax[4]/TypeCode |
| InvoiceTotalLineAmount | CrossIndustryInvoice/SupplyChainTradeTransaction/ApplicableHeaderTradeSettlement/SpecifiedTradeSettlementHeaderMonetarySummation/LineTotalAmount |
| InvoiceTotalVATAmount |
CrossIndustryInvoice/SupplyChainTradeTransaction/ApplicableHeaderTradeSettlement/SpecifiedTradeSettlementHeaderMonetarySummation/TaxTotalAmount If multiple TotalTaxAmount values exist with different currencies, TotalTaxAmount maps to the matching InvoiceCurrency field. |
| InvoiceTotalVatExcludedAmount | CrossIndustryInvoice/SupplyChainTradeTransaction/ApplicableHeaderTradeSettlement/SpecifiedTradeSettlementHeaderMonetarySummation/TaxBasisTotalAmount |
| InvoiceTotalVatIncludedAmount |
CrossIndustryInvoice/SupplyChainTradeTransaction/ApplicableHeaderTradeSettlement/SpecifiedTradeSettlementHeaderMonetarySummation/DuePayableAmount If this field does not exist, GrandTotalAmount is used. |
| PaymentReferenceNumber | /CrossIndustryInvoiceType)/SupplyChainTradeTransaction/ApplicableHeaderTradeSettlement/PaymentReference |
| PaymentTerms |
/SupplyChainTradeTransaction/ApplicableHeaderTradeSettlement/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/ApplicableHeaderTradeSettlement/SpecifiedTradePaymentTerms/ApplicableTradePaymentPenaltyTerms/CalculationPercent |
| PaymentType | SupplyChainTradeTransaction/ApplicableSupplyChainTradeSettlement/SpecifiedTradeSettlementPaymentMeans/TypeCode |
| SupplierEndpointID * | CrossIndustryInvoice/SupplyChainTradeTransaction/ApplicableHeaderTradeAgreement/SellerTradeParty/URIUniversalCommunication/URIID |
| 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 attribute schemeID="FC" |
| TotalTaxAmountInTaxCurrency |
CrossIndustryInvoice/SupplyChainTradeTransaction/ApplicableHeaderTradeSettlement/SpecifiedTradeSettlementHeaderMonetarySummation/TaxTotalAmount where the CurrencyID attribute of TaxTotalAmount is same as TaxCurrencyCode. |
| Line-item fields | |
| LIT_ArticleDescription * | CrossIndustryInvoice/SupplyChainTradeTransaction/IncludedSupplyChainTradeLineItem/SpecifiedTradeProduct/Description |
| LIT_ArticleIdentifier | CrossIndustryInvoice/SupplyChainTradeTransaction/IncludedSupplyChainTradeLineItem/SpecifiedTradeProduct/SellerAssignedID |
| LIT_ArticleName | CrossIndustryInvoice/SupplyChainTradeTransaction/IncludedSupplyChainTradeLineItem/SpecifiedTradeProduct/Name |
| LIT_BuyerArticleNumber | CrossIndustryInvoice/SupplyChainTradeTransaction/IncludedSupplyChainTradeLineItem/SpecifiedTradeProduct/BuyerAssignedID |
| LIT_DeliveredQuantity | CrossIndustryInvoice/SupplyChainTradeTransaction/IncludedSupplyChainTradeLineItem/SpecifiedLineTradeDelivery/BilledQuantity |
| LIT_DeliveredQuantityUnitCode | CrossIndustryInvoice/SupplyChainTradeTransaction/IncludedSupplyChainTradeLineItem/SpecifiedLineTradeDelivery/BilledQuantity/@unitCode |
| LIT_DeliveryCost |
CrossIndustryInvoice/SupplyChainTradeTransaction/IncludedSupplyChainTradeLineItem/SpecifiedLineTradeSettlement/SpecifiedTradeAllowanceCharge[2]/ActualAmount CrossIndustryInvoice/SupplyChainTradeTransaction/IncludedSupplyChainTradeLineItem/SpecifiedLineTradeSettlement/SpecifiedTradeAllowanceCharge[1]/ChargeIndicator/udt:Indicator = True |
| LIT_DeliveryDate1 | CrossIndustryInvoice/SupplyChainTradeTransaction/IncludedSupplyChainTradeLineItem[1]/SpecifiedLineTradeSettlement/BillingSpecifiedPeriod/StartDateTime/udt:DateTimeString |
| LIT_DeliveryDate2 | CrossIndustryInvoice/SupplyChainTradeTransaction/IncludedSupplyChainTradeLineItem[1]/SpecifiedLineTradeSettlement/BillingSpecifiedPeriod/EndDateTime/udt:DateTimeString |
| LIT_VatDescription | CrossIndustryInvoice/SupplyChainTradeTransaction/IncludedSupplyChainTradeLineItem[1]/SpecifiedLineTradeSettlement/ApplicableTradeTax/ExemptionReason |
| LIT_DiscountAmount | CrossIndustryInvoice/SupplyChainTradeTransaction/IncludedSupplyChainTradeLineItem/SpecifiedLineTradeSettlement/SpecifiedTradeAllowanceCharge[2]/ActualAmount
when CrossIndustryInvoice/SupplyChainTradeTransaction/IncludedSupplyChainTradeLineItem/SpecifiedLineTradeSettlement/SpecifiedTradeAllowanceCharge[1]/ChargeIndicator/udt:Indicator = False |
| LIT_DiscountPercent | CrossIndustryInvoice/SupplyChainTradeTransaction/IncludedSupplyChainTradeLineItem/SpecifiedLineTradeSettlement/SpecifiedTradeAllowanceCharge[1]/CalculationPercent
when CrossIndustryInvoice/SupplyChainTradeTransaction/IncludedSupplyChainTradeLineItem/SpecifiedLineTradeSettlement/SpecifiedTradeAllowanceCharge[1]/ChargeIndicator/udt:Indicator = False |
| LIT_OrderNumber | CrossIndustryInvoice/SupplyChainTradeTransaction/IncludedSupplyChainTradeLineItem/SpecifiedLineTradeAgreement/BuyerOrderReferencedDocument/IssuerAssignedID |
| LIT_PO_RowIdentifier | CrossIndustryInvoice/SupplyChainTradeTransaction/IncludedSupplyChainTradeLineItem/SpecifiedLineTradeAgreement/BuyerOrderReferencedDocument/LineID |
| LIT_AdditionalReference † | IncludedSupplyChainTradeLineItem/SpecifiedLineTradeAgreement/AdditionalReferencedDocument Takes the value from the node whose TypeCode child node equals "130". |
| LIT_RowIdentifier | CrossIndustryInvoice/SupplyChainTradeTransaction/IncludedSupplyChainTradeLineItem/AssociatedDocumentLineDocument/LineID |
| LIT_UnitPriceAmount | SpecifiedLineTradeAgreement/NetPriceProductTradePrice/ChargeAmount |
| LIT_UnitPriceBasis | CrossIndustryInvoice/SupplyChainTradeTransaction/IncludedSupplyChainTradeLineItem/SpecifiedLineTradeAgreement/NetPriceProductTradePrice/BasisQuantity |
| LIT_UniqueArticleNumber | CrossIndustryInvoice/SupplyChainTradeTransaction/IncludedSupplyChainTradeLineItem[1]/SpecifiedTradeProduct/GlobalID |
| LIT_VatAmount | CrossIndustryInvoice/SupplyChainTradeTransaction/IncludedSupplyChainTradeLineItem[1]/SpecifiedLineTradeSettlement/ApplicableTradeTax/CalculatedAmount |
| LIT_VatCode | CrossIndustryInvoice/SupplyChainTradeTransaction/IncludedSupplyChainTradeLineItem[1]/SpecifiedLineTradeSettlement/ApplicableTradeTax/CategoryCode |
| LIT_VatExcludedAmount | SpecifiedLineTradeSettlement/SpecifiedTradeSettlementLineMonetarySummation/LineTotalAmount |
| LIT_VatRate | CrossIndustryInvoice/SupplyChainTradeTransaction/IncludedSupplyChainTradeLineItem[1]/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 |
CrossIndustryInvoice/ExchangedDocument/IncludedNote/Content If a subject code (CrossIndustryInvoice/ExchangedDocument/IncludedNote/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 |
| 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/ApplicableHeaderTradeAgreement/ApplicableTradeDeliveryTerms/Description |
| 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 | SupplyChainTradeTransaction/ApplicableHeaderTradeSettlement/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/ApplicableHeaderTradeSettlement/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 attribute 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/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 | |
| Note that the ParentNode for these is:
IncludedSupplyChainTradeLineItem |
|
| LIT_ArticleIdentifier | SpecifiedTradeProduct/SellerAssignedID |
| LIT_ArticleName | SpecifiedTradeProduct/Name |
| LIT_DeliveredQuantity | SpecifiedSupplyChainTradeDelivery/BilledQuantity |
| LIT_DeliveredQuantityUnitCode | SpecifiedSupplyChainTradeDelivery/BilledQuantity/@unitCode |
| 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.