Skip to main content
Skip table of contents

ZF2INVHT - Header Information

CHAR(255)If you want to create ZUGFeRD files, fill the tables below with your data. If you need help with the filling, please contact the support.

Column nameIn use?StatusColumn definitionColumn descriptionTechnical termExample






HTKEYx
VARCHAR(15)Internal Pagination NumberInternal invoice number (i-effect column)







HTPDFxoptionalVARCHAR(200)PDF NameName of the file generated at the end (i-effect column)







HTTEMPLDIRxoptionalVARCHAR(100)Template Directory NameName of the template folder of the invoice (i-effect column)







HTDIRECTxrequiredCHAR(4)Direction of the ZUGFeRD
*IN, *OUT






Process control (required)






HTNTESTCH

VARCHAR(5)Test indicatorTest indicator

true / false








Grouping of business process information (required)








HTNPROCESSxoptionalVARCHAR(255)Process typeBusiness Process Type

Production material, other material,

Freight invoice








Grouping of the application recommendation information (required)








HTNAPPREFxrequiredVARCHAR(255)Application referenceRecommendation for use

BASIC = urn:cen.eu:en16931:2017#compliant#urn:zugferd.de:2p0:basic

COMFORT = urn:cen.eu:en16931:2017

EXTENDED = urn:cen.eu:en16931:2017#conformant#urn:zugferd.de:2p0:extended








Grouping of properties that affect the entire document. (required)








HTNDOCNRxrequiredVARCHAR(35)Document numberinvoice number2012-12345






HTNDOCTC

VARCHAR(255)Document Type(Free text)Document type (free text)INVOICE






HTNDOCTxrequiredCHAR(3)

 Document type (Code),

      

Code for the invoice type

380 = Commercial invoice

381 = Credit note display

83  = Value credit     

84  = Value exposure

more Codes can be found in the Codelist.








HTNDOCDxrequiredDATE '0001-01-01'

Document date

Date of invoice2018-12-10






HTNMSGFUNC

CHAR(5)

Indicator Original/Copy

Original/copy indicatortrue / false






LALLNG

CHAR(3)Language KeyLanguage code







Contractual due date of the invoice (optional)






HTNPAYD

DATE '0001-01-01'Payment dateContractual due date of the invoice2018-12-24






Free text at header level (optional)






Note table ZF2INVTX.






Grouping of business transaction information (optional)






Invoice item (optional)






Note table ZF2INVPI.






Grouping of contract details (required)






HTGBYREFxoptionalVARCHAR(35)Buyer referenceBuyer referenceINV 082






Detailed information about the seller (required)






HTGSEIDxoptionalVARCHAR(35)Identifier of the SellerIdentification of the seller (supplier number)







HTGSEGLNxempfohlenVARCHAR(35)Global identifier of the SellerGlobal identifier of the seller4000001000005






HTGSEGLNTxrequiredCHAR(5)Type of global IdentifierIdentification of the scheme

0021 : SWIFT

0088 : EAN

0060 : DUNS

0177 : ODETTE








HTGSENAMExrequiredVARCHAR(255)Company/Name of the SellerCompany name/name of the sellerSupplier Ltd.






HTGSDESC

VARCHAR(255)Other remaining information of the SellerOther legal information of the seller







Details of the organization (optional)






HTGSOID

xoptionalVARCHAR(35)Identifier of the OrganizationIdentification of the legal registration of the seller







HTGSOIDT

xoptionalVARCHAR(10)Type of Organization IdentifierIdentification of the scheme







HTGSOTRBN

xoptionalVARCHAR(50)Trading Business nametrade name of the seller







Detailinformationen zur Geschäftsanschrift des Verkäufers






HTGSOEZIP



VARCHAR(10)

ZIP Code of the Seller Organization

Postcode







HTGSOEAD1



VARCHAR(50)

Address line 1 of the Seller Organization

Address line 1







HTGSOEAD2



VARCHAR50)

Address line 2 of the Seller Organization

Address line 2







HTGSOEAD3



VARCHAR(50)

Address line 3 of the Seller Organization

Address line 3







HTGSOELC



VARCHAR(50)

City of the Seller Organization

City







HTGSOECR



VARCHAR(3)

Country ISO of the Seller Organization

Country (Code)







Contact details of the seller (optional)






HTGSECT

VARCHAR(50)Contact Name of the Sellerseller's contact pointKarin Mustermann






HTGSECTD

VARCHAR(50)Department name of the Sellerseller's contact pointInvoicing






Detailed information about the phone number of the seller (optional)






HTGSETE

VARCHAR(50)Phone number of the SellerPhone number of the seller+49 (123) 456789-0






Detailed information on the fax number of the seller (optional)






HTGSEFX

VARCHAR(50)Fax number of the SellerFax number of the seller+49 (123) 456789-999






Detailed information about the email address of the seller (optional)






HTGSEEM

VARCHAR(200)Mail adress of the SellerE-mail address of the sellerkarin.mustermann@seller.tld






Postanschrift des Verkäufers (required)






HTGSEZIPxoptionalVARCHAR(10)ZIP Code of the SellerPostcode of the seller address80333






HTGSEAD1xoptionalVARCHAR(50)Adress line 1 of the SellerLine 1 of the seller addressSupplier Street 20






HTGSEAD2xoptionalVARCHAR(50)Adress line 2 of the SellerLine 2 of the seller addressBuilding 3






HTGSEAD3

xoptionalVARCHAR(50)Adress line 3 of the SellerLine 3 of the seller addressBuilding 3






HTGSELCxoptionalVARCHAR(50)City of the SellerPlace of the sellerMunich






HTGSECRxrequiredCHAR(3)Country ISO of the SellerCountry of the seller (Code)DE






HTGSCSDNxoptionalVARCHAR(25)Country federal stateFederal state







Electronic address details (optional)






HTGSURIDxrequiredVARCHAR(55)Electronic addressElectronic address of the seller







HTGSURIDTxrequiredVARCHAR(10)Electronic address typeIdentification of the scheme







Detailed information on tax details of the seller (optional)






HTGSETAXxrequiredVARCHAR(35)Taxnumber of the SellerTax number of the seller (FC)01/113/40209






HTGSETAXTxrequiredVARCHAR(35)USTid of the SellerValue added tax identification number (VA)DE234567891






Detailed information about the buyer (required)






HTGBID

xoptionalVARCHAR(35)Identifier of the BuyerIdentifier of the buyer (customer number)B123456






HTGBGLN

xoptionalVARCHAR(35)Global identifier of the BuyerGlobal identifier of the buyer4000001000006






HTGBGLNT

xrequired wenn HTGBYGLN gefüllt ist.CHAR(5)Type of global IdentifierIdentification of the scheme







HTGBNAME

xrequiredVARCHAR(255)Company/Name of the BuyerCompany name/name of the buyerCustomers AG Middle






Details of the organization (optional)






HTGBOID

xoptionalVARCHAR(35)

Identifier of the Organization

Identification of the legal registration of the buyer







HTGBOIDT

xoptionalVARCHAR(10)

Type of Organization Identifier

Identification of the scheme







HTGBOTRBN

xoptionalVARCHAR(50)

Trading Business name

Trade name of the buyer







Detailed information on business address (optional) (EXTENDED only)






HTGBOEZIP



VARCHAR(10)

ZIP Code of the Buyer Organization

Postcode







HTGBOEAD1



VARCHAR(50)

Address line 1 of the Buyer Organization

Address line 1







HTGBOEAD2



VARCHAR(50)

Address line 2 of the Buyer Organization

Adresszeile 2







HTGBOEAD3



VARCHAR(50)

Address line 3 of the Buyer Organization

Adresszeile 3







HTGBOELC



VARCHAR(50)

City of the Buyer Organization

City







HTGBOECR



CHAR(3)

Country ISO of the Buyer Organization

Country (Code)







Contact details of the buyer (optional)






HTGBCT

VARCHAR(50)Contact Name of the BuyerContact point of the buyerHans Muster






HTGBCTD

VARCHAR(50)Department name of the BuyerContact point of the buyerInvoicing






Detailed information on the telephone number of the contact person (optional)






HTGBTE



VARCHAR(50)Phone number of the BuyerPhone number of the buyer's contact point+49 (123) 56789-0






Detailed information on the fax number of the contact person (optional)






HTGBFX



VARCHAR(50)Fax number of the buyerFax number of the buyer+49 (123) 56789-999






Detailed information on the email address of the contact person (optional)






HTGBEM



VARCHAR(200)Mail adress of the BuyerE-mail address of the buyer's contact pointhans.muster@buyer.tld






Detailed information on the address of the buyer (required)






HTGBZIP

xoptionalVARCHAR(10)ZIP Code of the BuyerPostcode of the buyer69876






HTGBAD1

xoptionalVARCHAR(50)Adress line 1 of the BuyerLine 1 of the buyer addressCustomer Street 15






HTGBAD2

xoptionalVARCHAR(50)Adress line 2 of the BuyerLine 2 of the buyer address3rd floor right






HTGBAD3

xoptionalVARCHAR(50)Adress line 3 of the BuyerLine 3 of the buyer address3rd floor right






HTGBLC

xoptionalVARCHAR(50)City of the BuyerCity of buyer's addressFrankfurt






HTGBCR

xrequiredCHAR(3)Country ISO of the BuyerCountry code of the buyer addressDE






HTGBCSDN

xoptionalVARCHAR(25)

Country federal state

Federal state







Electronic address details (optional)






HTGBURID

xrequiredVARCHAR(55)Electronic addressElectronic address of the buyer







HTGBURIDT

xrequiredVARCHAR(10)Electronic address typeIdentification of the scheme







Detailed information on tax details of the buyer (recommended)






HTGBTAX

xrequiredVARCHAR(35)Taxnumber of the BuyerTax number of the buyer (FC)201/123/12341






HTGBTAXT

xrequiredVARCHAR(35)USTid of the BuyerValue added tax identification number (VAT)DE234567781






Tax representative of the seller (optional)






HTGTID



VARCHAR(35)

Identifier of the Seller Tax Representative

Identifier of the tax representativeB123456






HTGTGLN



VARCHAR(35)

Global identifier of the Seller Tax Representative

Global identifier of the tax representative4000001000006






HTGTGLNT



CHAR(5)

Type of global Identifier

Identification of the scheme

0021 : SWIFT

0088 : EAN

0060 : DUNS

0177 : ODETTE








HTGTNAME

xrequiredVARCHAR(255)

Company/Name of the Seller Tax Representative

Name of the tax representative of the sellerCustomers AG Middle






Details of the organization (optional)








HTGTOID



VARCHAR(35)

Identifier of the Organization

Identifier of the tax representative







HTGTOIDT



VARCHAR(10)

Type of Organization Identifier

Global identifier of the tax representative







HTGTOTRBN



VARCHAR(50)

Trading Business name

Identification of the scheme







Detailed information on the contact person (optional)






HTGTCT



VARCHAR(50)

Contact Name of the Seller Tax Representative

Contact point of the buyerHans Muster






HTGTCTD



VARCHAR(50)

Department name of the Seller Tax Representative

Contact point of the buyerInvoicing






Detailed information on the telephone number of the contact person (optional)






HTGTTE



VARCHAR(50)

Phone number of the Seller Tax Representative

Phone number of the buyer's contact point+49 (123) 56789-0






Detailed information on the fax number of the contact person (optional)






HTGTFX



VARCHAR(50)

Fax number of the Seller Tax Representative

Fax number of the buyer+49 (123) 56789-999






Detailed information on the email address of the contact person (optional)






HTGTEM



VARCHAR(200)

Mail address of the Seller Tax Representative

E-mail address of the buyer's contact pointhans.muster@buyer.tld






Postal address of the tax representative of the seller (required)






HTGTZIP

xoptionalVARCHAR(10)

ZIP Code of the Seller Tax

Postcode of the tax agent's address







HTGTAD1

xoptionalVARCHAR(50)

Address line 1 of the Seller Tax Representative

Line 1 of the tax agent's document







HTGTAD2

xoptionalVARCHAR(50)

Address line 2 of the Seller Tax Representative

Line 2 of the tax agent's document







HTGTAD3

xoptionalVARCHAR(50)

Address line 3 of the Seller Tax Representative

Line 3 of the tax agent's document







HTGTLC

xoptionalVARCHAR(50)

City of the Seller Tax Representative

City of the tax attorney's office







HTGTCR

xrequiredCHAR(3)

Country ISO of the Seller Tax Representative

Country code of the tax representative address







HTGTCSDN

xoptionalVARCHAR(25)

Country federal state

Federal state







Electronic address details (optional)






HTGTURID

VARCHAR(55)

Electronic address

Electronic address







HTGTURIDT

VARCHAR(10)

Electronic address type

Type of electronic address







Detailed information on the tax number of the tax representative of the seller (required)






HTGTTAXxrequiredVARCHAR(35)

Taxnumber of the Seller Tax Representative

Tax number (FC)







HTGTTAXTxrequiredVARCHAR(35)

USTid of the Seller Tax Representative

Value added tax identification number (VAT)







Detailed information on the deviating end consumer (optional)






HTGUDID

VARCHAR(35)Identifier of the deviating end userIdentification of the deviating end user







HTGUDGLN

VARCHAR(35)Global identifier of the deviating end userGlobal identifier of the deviating end user







HTGUDGLNT



CHAR(5)Type of global identifierType of global identification number

0021 : SWIFT

0088 : EAN

0060 : DUNS

0177 : ODETTE








HTGUDNAME

VARCHAR(255)Company/Name of the deviating end userName/name of the end user







Details of the organization (optional)






HTGUDOID



VARCHAR(35)

Identifier of the Organization

Commercial register number







HTGUDOIDT



VARCHAR(10)

Type of Organization Identifier

Type of number







HTGUDOTRBN



VARCHAR(50)

Trading Business name

Trade name







Detailed information on the contact person of the deviating end user (optional)






HTGUDCT

VARCHAR(50)Contact Name of the deviating end userName of contact person







HTGUDCTD

VARCHAR(50)Department name of the deviating end userDepartment of the contact person







Detailed information on the telephone number of the contact person (optional)






HTGUDTE

VARCHAR(50)Phone number of the deviating end userTelephone number of the contact person







Detailed information on the fax number of the contact person (optional)






HTGUDFX

VARCHAR(50)Fax number of the deviating end userFax number







Detailed information on the email address of the contact person (optional)






HTGUDEM

VARCHAR(200)Mail adress of the deviating end usere-mail address







Detailed information on the address of the deviating end consumer (required)






HTGUDZIP

VARCHAR(10)ZIP Code of the deviating end userPostcode







HTGUDAD1

VARCHAR(50)Adress line 1 of the deviating end userAddress line 1







HTGUDAD2

VARCHAR(50)Adress line 2 of the deviating end userAddress line 2







HTGUDAD3

VARCHAR(50)Adress line 3 of the deviating end userAddress line 3







HTGUDLC

VARCHAR(50)City of the deviating end userCity







HTGUDCR

CHAR(4)Country ISO of the deviating end userCountry (Code)







HTGUDCSDN



VARCHAR(25)

Country federal state

Bundesland









Electronic address details (optional)






HTGUDURID



VARCHAR(55)

Electronic address

Electronic address









HTGUDURIDT



VARCHAR(10)

Electronic address type

Type of electronic address









Detailed information on the tax number of the alternative end consumer (optional)






HTGUDTAX

VARCHAR(35)Taxnumber of the deviating end userTax number







HTGUDTAXT

VARCHAR(35)USTid of the deviating end userValue added tax identification number







Detailed information on the delivery conditions (optional)






HTGDPTERM

VARCHAR(3)Delivery Conditions (CODE)Delivery condition (code)







Details of the associated order confirmation (optional)






HTGORDERNR

VARCHAR(35)Order numberSales order reference







HTGORDERD

DATE '0001-01-01'Date of orderDetails of the order confirmation date







Details of the associated order (optional)






HTGCORDNR

xrequiredVARCHAR(35)Order numberOrder reference







HTGCORDD



DATE '0001-01-01'Date of orderorder date







Details of the associated contract (optional)






HTGCONTRNR

VARCHAR(35)Agreement numberContract reference







HTGCONTRD

DATE '0001-01-01'Date of agreementContract date







Accounting documents () (optional)






Note table ZF2INVDR.






Detailed information on a project reference (optional)






HTSPPID

INTEGER

Project reference ID

Project reference







HTSPPNA

VARCHAR(35)

Project name

Project name







UltimateCustomerOrderReferencedDocument () (optional)






Note table ZF2INVUDR.






Grouping of delivery data (required)






Detailed information about the shipping method (EXTENDED only) (optional)






See table ZF2INVDM.






Delivery information (optional)








HTLWRDID

VARCHAR(35)Identifier of the were recipientsIdentification of the ship-to partyTO123456






HTLWRDGLN

VARCHAR(35)Global identifier of the were recipientsGlobal identifier of the ship-to party (GLN)4000001000007






HTLWRDGLNT

CHAR(5)Type of global identifierIdentification of the scheme

0021 : SWIFT

0088 : EAN

0060 : DUNS

0177 : ODETTE








HTLWRDREC

VARCHAR(255)Company/Name of the were recipientsName/name of the consignee







Details of the organization (optional)






HTLWROID

VARCHAR(35)Identifier of the OrganizationCommercial register number







HTLWROIDT

VARCHAR(10)Type of Organization IdentifierType of number

0021 : SWIFT

0088 : EAN

0060 : DUNS

0177 : ODETTE








HTLWROTRBN

VARCHAR(50)Trading Business nameTrade name







Detailed information on the contact person of the ship-to party (optional)






HTLWRDCN

VARCHAR(50)Contact Name of the were recipientsName of contact person







HTLWRDDN

VARCHAR(50)Department name of the were recipientsDepartment of the contact person







Detailed information on the telephone number of the contact person (optional)






HTLWRDTEL

VARCHAR(50)Phone number of the were recipientsTelefonnummer der Kontaktperson







Detailed information on the fax number of the contact person (optional)






HTLWRDFAX

VARCHAR(50)Fax number of the were recipientsFax number







Detailinformationen zur Emailadresse des Ansprechpartners (optional)






HTLWRDMAIL

VARCHAR(200)Mail adress of the were recipientsEmailadresse







Delivery address (optional)






HTLWRDPLZ

VARCHAR(10)ZIP Code of the were recipientsPostcode of the delivery address







HTLWRDAD1

VARCHAR(50)Address line 1 of the were recipientsLine 1 of the delivery address







HTLWRDAD2

VARCHAR(50)Address line 2 of the were recipientsLine 2 of the delivery address







HTLWRDAD3

VARCHAR(50)Address line 3 of the were recipientsLine 3 of the delivery address







HTLWRDCITY

VARCHAR(50)City of the were recipientsCity of delivery address







HTLWRDLC

CHAR(4)Country ISO of the were recipientsCountry code of delivery address







HTLWRCSDN

VARCHAR(25)Country federal stateFederal state







Details of the electronic address (optional)






HTLWRURID

VARCHAR(55)Eletronic addressElectronic address







HTLWRURIDT

VARCHAR(10)Eletronic address typeType of electronic address







Detailed information on the tax number of the ship-to party (optional)






HTLWRDSNR

VARCHAR(35)Taxnumber of the were recipientsTax number







HTLWRDASNR

VARCHAR(35)USTid of the were recipientsValue added tax identification number







Detailed information on the different final recipient (optional)








HTLFRDID

VARCHAR(35)Identifier of the final recipientIdentification of the final recipient







HTLFRDGLN

VARCHAR(35)Global identifier of the final recipientGlobal identifier of the final recipient







HTLFRDGLNT

CHAR(5)Type of global IdentifierIdentification of the scheme







HTLFRDREC

VARCHAR(255)Company/Name of the final recipientName/name of the final recipient







Details of the organization (optional)






HTLFROID

VARCHAR(35)Identifier of the OrganizationCommercial register number







HTLFROIDT

VARCHAR(10)Type of Organization IdentifierIdentification of the scheme







HTLFROTRBN

VARCHAR(50)Trading Business nameTrade name







Detailed information on the contact person of the final recipient (optional)






HTLFRDCN

VARCHAR(50)Contact Name of the final recipientName of contact person







HTLFRDDN

VARCHAR(50)Department name of the final recipientDepartment of the contact person







Detailed information on the telephone number of the contact person (optional)






HTLFRDTEL

VARCHAR(50)Phone number of the final recipientTelephone number of the contact person







Detailed information on the fax number of the contact person (optional)






HTLFRDFAX

VARCHAR(50)Fax number of the final recipientFax number







Detailed information on the email address of the contact person (optional)






HTLFRDMAIL

VARCHAR(200)Mail adress of the final recipientemail address







Detailed information on the address of the final recipient (optional)






HTLFRDPLZ

VARCHAR(10)ZIP Code of the final recipientPostcode







HTLFRDAD1

VARCHAR(50)Address line 1 of the final recipientAddress line 1







HTLFRDAD2

VARCHAR(50)Address line 2 of the final recipientAddress line 2







HTLFRDAD3

VARCHAR(50)Address line 3 of the final recipientAddress line 3







HTLFRDCITY

VARCHAR(50)City of the final recipientCity







HTLFRDLC

CHAR(4)Country ISO of the final recipientCountry (code)







HTLFRCSDN

VARCHAR(25)Country federal stateFederal state







Details of the electronic address (optional)






HTLFRURID

VARCHAR(55)Eletronic addressElectronic address







HTLFRURIDT

VARCHAR(10)Eletronic address typeType of electronic address







Detailed information on tax data of the final recipient (optional)






HTLFRDSNR

VARCHAR(35)Taxnumber of the final recipientTax number







HTLFRDASNR

VARCHAR(35)USTid of the final recipientValue added tax identification number







Identification of the deviating shipper (optional)






HTLCDID

VARCHAR(35)Identifier of the consignorIdentification of the consignor







HTLCDGLN

VARCHAR(35)Global identifier of the consignorGlobal identifier of the sender







HTLCDGLNT

CHAR(5)Type of Organization IdentifierType of global identification number







HTLCDREC

VARCHAR(255)Company/Name of the consignorName/name of the sender







Details of the organization (optional)






HTLCDOID

VARCHAR(35)Identifier of the OrganizationCommercial register number







HTLCDOIDT

VARCHAR(10)Type of Organization IdentifierType of number







HTLCDOTRBN

VARCHAR(50)Trading Business nameTrade name







Detailed information on the shipper's contact person (optional)






HTLCDCN

VARCHAR(50)Contact Name of the consignorName of contact person







HTLCDDN

VARCHAR(50)Department name of the consignorDepartment of the contact person







Detailed information on the telephone number of the contact person (optional)






HTLCDTEL

VARCHAR(50)Phone number of the consignorTelephone number of the contact person







Detailed information on the fax number of the contact person (optional)






HTLCDFAX

VARCHAR(50)Fax number of the consignorFax number







Detailed information on the email address of the contact person (optional)






HTLCDMAIL

VARCHAR(200)Mail adress of the consignore-mail address







Detailed information on the sender's address (optional)






HTLCDPLZ

VARCHAR(10)ZIP Code of the consignorPostcode







HTLCDAD1

VARCHAR(50)Adress line 1 of the consignorAddress line 1







HTLCDAD2

VARCHAR(50)Adress line 2 of the consignorAddress line 2







HTLCDAD3

VARCHAR(50)Adress line 3 of the consignorAddress line 3







HTLCDCITY

VARCHAR(50)City of the consignorCity







HTLCDLC

CHAR(4)Country ISO of the consignorCountry (code)







HTLCDCSDN

VARCHAR(25)Country federal stateFederal state







Details of the electronic address (optional)






HTLCDURID

VARCHAR(55)Eletronic addressElectronic address







HTLCDURIDT

VARCHAR(10)Eletronic address typeType of electronic address







Detailed information on tax details of the sender (optional)






HTLCDSNR

VARCHAR(35)Taxnumber of the consignorTax number







HTLCDASNR

VARCHAR(35)USTid of the consignorValue added tax identification number







Detailed information on the actual delivery (optional)

Note: In Germany, the date of delivery and performance is a mandatory entry on invoices. This can be specified here or at item level.








HTLDTDxrequiredDATE '0001-01-01'Actual Delivery TimeActual date of delivery2018-12-10






Detailed information on the corresponding shipping notification (optional)






HTLDANRxrequiredVARCHAR(25)Despatch advice numberShipping notification reference







HTLDALD

DATE '0001-01-01'Date of Despatch adviceShipping notification date







Detailed information on the corresponding final backflush (optional)






HTLWDANR

VARCHAR(25)Goods receipt notification numberReference to the final backflush







HTLWDALD

DATE '0001-01-01'Date of goods receipt notificationGoods receipt date







Detailed information on the corresponding delivery note (optional)






HTLDLSNR

VARCHAR(35)Delivery Note numberDelivery note number







HTLDLSD

DATE '0001-01-01'Date of Delivery NoteDelivery note date







Grouping of payment and invoice settlement details (required)






HTZGPCIDxoptionalVARCHAR(15)Creditor IDIdentification of the creditor







HTZGPZRxoptionalVARCHAR(200)Intended purposeIntended use







HTZGPTC

VARCHAR(5)Tax Currency CodeCode for the currency of the sales tax posting







HTZGPICxrequiredVARCHAR(5)Invoice Currency CodeCode for the invoice currency







HTZGPIRN

INTEGERIssuer reference numberSeller's reference number







Biller Trading party (optional)






HTZITDREID

VARCHAR(35)Identifier of the Invoicing party Trade partnerIdentification







HTZITDGLN

VARCHAR(35)Global identifier of the Invoicing party Trade partnerGlobal identifier







HTZITDGLNT

CHAR(5)Type of global IdentifierType of global identification number







HTZIRDREC

VARCHAR(255)Company/Name of the Invoice recipientName







Details of the organization (optional)






HTZITOID

VARCHAR(35)Identifier of the OrganizationCommercial register number







HTZITOIDT

VARCHAR(10)Type of Organization IdentifierType of number







HTZITOTRBN

VARCHAR(50)Trading Business nameTrade name







DefinedTradeContact (optional)






HTZITDCN

VARCHAR(50)Contact Name of the Invoicing party Trade partnerContact person name







HTZITDDN

VARCHAR(50)Department name of the Invoicing party Trade partnerDepartment name







Detailed information on the telephone number (optional)






HTZITDTEL

VARCHAR(50)Phone number of the Invoicing party Trade partnerPhone number







Detailed information about the fax number (optional)






HTZITDFAX

VARCHAR(50)Fax number of the Invoicing party Trade partnerFax number







Detailed information about the email address (optional)






HTZITDMAIL

VARCHAR(200)Mail address of the Invoicing party Trade partneremail address







PostalTradeAddress (optional)






HTZITDEPLZ

VARCHAR(10)ZIP Code of the Invoicing party Trade partnerPostcode







HTZITDAD1

VARCHAR(50)Address line 1 of the Invoicing party Trade partnerAddress line 1







HTZITDAD2

VARCHAR(50)Address line 2 of the Invoicing party Trade partnerAddress line 2







HTZITDAD3

VARCHAR(50)Address line 3 of the Invoicing party Trade partnerAddress line 3







HTZITDCITY

VARCHAR(50)City of the Invoicing party Trade partnerCity







HTZITDLLC

CHAR(4)Country ISO of the Invoicing party Trade partnerCountry (code)







HTZITCSDN

VARCHAR(25)Country federal state of the Invoicing party Trade partnerFederal state







Electronic address details (optional)






HTZITURID

VARCHAR(55)Electronic address of the Invoicing party Trade partnerElectronic address







HTZITURIDT

VARCHAR(10)Electronic address type of the Invoicing party Trade partnerType of electronic address







Detailed information on tax numbers (optional)






HTZITDSNR

VARCHAR(35)Taxnumber of the Invoicing party Trade partnerTax number (FC)







HTZITDASNR

VARCHAR(35)USTid of the Invoicing party Trade partnerTax number (VAT)







Detailed information on the different invoice recipient (optional)








HTZIRDREID

VARCHAR(35)Identifier of the Invoice recipientIdentification of the invoice recipient







HTZIRDGLN

VARCHAR(35)Global identifier of the Invoice recipientGlobal identifier of the different invoice recipient







HTZIRDGLNT

CHAR(5)Type of global IdentifierIdentification of the scheme







HTZIRDREC

VARCHAR(255)Company/Name of the Invoice recipientName/name of the invoice recipient







Details of the organization (optional)






HTZIROID



VARCHAR(35)Identifier of the OrganizationCommercial register number







HTZIROIDT



VARCHAR(10)Type of Organization IdentifierType of number







HTZIROTRBN



VARCHAR(50)Trading Business nameTrade name







Detailed information on the contact person of the invoice recipient (optional)






HTZIRDCN

VARCHAR(50)Contact Name of the Invoice recipientName of contact person







HTZIRDDN

VARCHAR(50)Department name of the Invoice recipientDepartment of the contact person







Detailed information on the telephone number of the contact person (optional)






HTZIRDTEL

VARCHAR(50)Phone number of the Invoice recipientTelephone number of the contact person







Detailed information on the fax number of the contact person (optional)






HTZIRDFAX

VARCHAR(50)Fax number of the Invoice recipientFax number







Detailed information on the email address of the contact person (optional)






HTZIRDMAIL

VARCHAR(200)Mail adress of the Invoice recipientEmailadresse







Detailed information on the address of the invoice recipient (recommended)






HTZIRDEPLZ

VARCHAR(10)ZIP Code of the Invoice recipientPostcode







HTZIRDAD1

VARCHAR(50)Adress line 1 of the Invoice recipientLine 1 of the address of the invoice recipient







HTZIRDAD2

VARCHAR(50)Adress line 2 of the Invoice recipientLine 2 of the address of the invoice recipient







HTZIRDAD3

VARCHAR(50)Adress line 3 of the Invoice recipientLine 3 of the address of the invoice recipient







HTZIRDCITY

VARCHAR(50)City of the Invoice recipientCity of the address of the invoice recipient







HTZIRDLLC

CHAR(4)Country ISO of the Invoice recipientCountry code of the address of the invoice recipient







HTZIRCSDN

VARCHAR(25)Country federal stateFederal state







Electronic address details (optional)






HTZIRURID

VARCHAR(55)Electronic addressElectronic address







HTZIRURIDT

VARCHAR(10)Electronic address typeType of electronic address







Detailed information on the tax number of the invoice recipient (optional)






HTZIRDSNR

VARCHAR(35)Taxnumber of the Invoice recipientTax number







HTZIRDASNR

VARCHAR(35)USTid of the Invoice recipientValue added tax identification number







Payee (optional)






HTZPRDREIDxoptionalVARCHAR(35)Identifier of the Payment ReceiverIdentification of the alternative payee







HTZPRDGLNxoptionalVARCHAR(35)Global identifier of the Payment ReceiverGlobal identifier of the deviating







HTZPRDGLNTxrequired wenn HTZPRDGLN gefüllt ist.CHAR(5)Type of global IdentifierIdentification of the scheme







HTZPRDRECxrequiredVARCHAR(255)Company/Name of the Payment ReceiverName/name of the payee















HTZPROID

x

optional

VARCHAR(35)

Identifier of the Organization

Identification of the legal registration of the payee









HTZPROIDT

x

optional

VARCHAR(10)

Type of Organization Identifier

Identification of the scheme









HTZPROTRBN

x

optional

VARCHAR(50)

Trading Business name

Trade name









Detailed information on the contact person of the payee (optional)






HTZPRDCN

VARCHAR(50)Contact Name of the Payment ReceiverName of the payee's contact person







HTZPRDDN

VARCHAR(50)Department name of the Payment ReceiverDepartment of the payee's contact person







Detailed information on the telephone number of the contact person (optional)






HTZPRDTEL

VARCHAR(50)Phone number of the Payment ReceiverTelephone number of the payee's contact person







Detailed information on the fax number of the contact person (optional)






HTZPRDFAX

VARCHAR(50)Fax number of the Payment ReceiverFax number of the payee's contact person







Detailed information on the email address of the contact person (optional)






HTZPRDMAIL

VARCHAR(200)Mail adress of the Payment ReceiverEmail address of the contact person of the payee







Detailed information on the address of the payee (recommended)






HTZPRDPLZ

VARCHAR(10)ZIP Code of the Payment ReceiverPostcode







HTZPRDAD1

VARCHAR(50)Adress line 1 of the Payment ReceiverLine 1 of the payee's address







HTZPRDAD2

VARCHAR(50)Adress line 2 of the Payment ReceiverLine 2 of the payee's address







HTZPRDAD3

VARCHAR(50)Adress line 3 of the Payment ReceiverLine 3 of the payee's address







HTZPRDCITY

VARCHAR(50)City of the Payment ReceiverCity of the payee's address







HTZPRDLLC

CHAR(4)Country ISO of the Payment ReceiverCountry code of the payee's address







HTZPRCSDN

VARCHAR(25)Country federal stateFederal state







Electronic address details (optional)






HTZPRURID



VARCHAR(55)

Electronic address

Electronic address









HTZPRURIDT



VARCHAR(10)

Electronic address type

Type of electronic address









Detailed information on the tax number of the alternative payee (optional)






HTZPRDSNR

VARCHAR(35)Taxnumber of the Payment ReceiverTax number (FC)







HTZPRDASNR

VARCHAR(35)USTid of the Payment ReceiverValue added tax number (VAT)







Specification of invoice currency, home currency and the exchange rate (optional)






HTZTASC

CHAR(5)Invoicing currencyInvoice currency







HTZTATC

CHAR(5)Home currencyLocal currency







HTZTACR

DECIMAL(10, 5)Exchange rateConversion rate







HTZTACD

DATE '0001-01-01'Date for exchange rateDate at exchange rate







Payment instructions (optional)






Note table ZF2INVPT.






Sales tax breakdown (optional)






Note table ZF2INVTI.








Detailed information on the billing period (dependent)






HTZBILLPD

VARCHAR(50)Description of Bill periodFree text for the accounting period







HTZBILLBP

VARCHAR(15)Beginning of the accounting periodBeginning of the financial period







HTZBILLBPF

CHAR(3)Date FormatDate, Format102






HTZBILLEP

VARCHAR(15)End of the accountingEnd of the financial period







HTZBILLEPF

CHAR(3)Date FormatDate, Format102






Surcharges and discounts at document level (optional)






Note table ZF2INVAC.






Detailed information on logistic service fees (optional)






Note table ZF2INVSC.






Detailed information on payment terms (optional)






Note table ZF2INVTP.








Totals at document level (required)






HTZTSMSLTxrequiredDECIMAL(15, 2)Total amount of positionsTotal of the net amounts of all invoice items6913.60






HTZTSMSCTxoptionalDECIMAL(15, 2)Total amount of surchargesTotal surcharges at document level0.00






HTZTSMSATxoptionalDECIMAL(15, 2)Total amounts of discountsTotal discounts at document level0.00






HTZTSMSTB1xrequiredDECIMAL(15, 2)Tax basic amount 1Total invoice amount without sales tax 16913.60






HTZTSMSTB2xoptionalDECIMAL(15, 2)Tax basic amount 2Total invoice amount without sales tax 2







HTZTSMSTT1xrequiredDECIMAL(15, 2)Tax total amount 1Total amount of invoice sales tax Total tax amount in posting currency 11313.58






HTZTSMSTT2xoptionalDECIMAL(15, 2)Tax total amount 2Total amount of invoice turnover tax Total tax amount in posting currency 2







HTZTSMSRA

DECIMAL(15, 2)Rounding amountRounding amount







HTZTSMSGT1xrequiredDECIMAL(15, 2)

Grand total amount 1

Total invoice amount including sales tax 18227.18






HTZTSMSGT2xoptionalDECIMAL(15, 2)

Grand total amount 2

Total invoice amount including sales tax 2







HTZTSMSTPA

DECIMAL(15, 2)Deposit amountAdvance payment amount0.00






HTZTSMSDPA

DECIMAL(15, 2)Payment amountPayment amount due8227.18






Reference to previous invoices (optional)






HTZIRDIAIDxrequiredVARCHAR(35)Number of previous invoiceNumber of the previous invoice







HTZIRDFIDTxoptionalDATE '0001-01-01'Invoice Date of previous invoiceDate of invoice







Detailed information on the booking reference (optional)






Note table ZF2INVBR.






Tax information on advance payments received (EXTENDED only) (optional)






Note table ZF2INVAP.






i-effect Felder






HTSTATEx
VARCHAR(1)

State of Order

Status column

Empty string = Not processed,

1 = Processed








HTSESSUMx
DECIMAL(15, 0)i-effect Session Numberi-effect Session number







HTPROCNUMx
DECIMAL(15, 0)i-effect File Process Numberi-effect File Process number







EXTERNAL_RECIPIENTx
CHAR(255)External recipient for SNDFILEi-effect recipient from partner master data







EXTERNAL_ORIGINATORx
CHAR(255)External originator für SNDFILEi-effect originator from partner master data
JavaScript errors detected

Please note, these errors can depend on your browser setup.

If this problem persists, please contact our support.