ZF2INVHT - header information | i-effect Handbuch

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 name	In use?	Status	Column definition	Column description	Technical term	Example
HTKEY	x		VARCHAR(15)	Internal Pagination Number	Internal invoice number (i-effect column)
HTPDF	x	optional	VARCHAR(200)	PDF Name	Name of the file generated at the end (i-effect column)
HTTEMPLDIR	x	optional	VARCHAR(100)	Template Directory Name	Name of the template folder of the invoice (i-effect column)
HTDIRECT	x	required	CHAR(4)	Direction of the ZUGFeRD		IN, OUT
Process control (required)
HTNTESTCH	x	optional	VARCHAR(5)	Test indicator	Test indicator	true / false
Gruppierung der Geschäftsprozessinformationen (required)
HTNPROCESS	x	optional	VARCHAR(255)	Process type	Business Process Type	Production material, other material, Freight invoice
Grouping of the application recommendation information (required)
HTNAPPREF	x	required	VARCHAR(255)	Application reference	Recommendation 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 document as a whole. (required)
HTNDOCNR	x	required	VARCHAR(35)	Document number	invoice number	2012-12345
HTNDOCTC	x	required	VARCHAR(255)	Document Type(Free text)	Document type (free text)	INVOICE
HTNDOCT	x	required	CHAR(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.
HTNDOCD	x	required	DATE '0001-01-01'	Document date	Date of invoice	2018-12-10
HTNMSGFUNC	x	Specification only required if the item is not a multiple of the same content.	CHAR(5)	Indicator Original/Copy	Original/copy indicator	true / false
LALLNG	x	optional	CHAR(3)	Language Key	Language code
Contractual due date of the invoice (dependent)
HTNPAYD	x	required	DATE '0001-01-01'	Payment date	Contractual due date of the invoice	2018-12-24
Free text at header level (optional)
Note table ZF2INVTX.
Grouping of information on the business transaction (required)
Invoice item (optional)
Note table ZF2INVPI.
Grouping of contract details (required)
HTGBYREF	x	optional	VARCHAR(35)	Buyer reference	Buyer's reference	INV 082
Detailed information about the seller (required)
HTGSEID	x	optional	VARCHAR(35)	Identifier of the Seller	Identification of the seller (supplier number)
HTGSEGLN	x	empfohlen	VARCHAR(35)	Global identifier of the Seller	Global identifier of the seller	4000001000005
HTGSEGLNT	x	required	CHAR(5)	Type of global Identifier	Identification of the scheme	0021 : SWIFT 0088 : EAN 0060 : DUNS 0177 : ODETTE
HTGSENAME	x	required	VARCHAR(255)	Company/Name of the Seller	Company name/name of the seller	Lieferant GmbH
HTGSDESC	x	optional	VARCHAR(255)	Other remaining information of the Seller	Other legal information of the seller
Details of the organization (optional)
HTGSOID	x	optional	VARCHAR(35)	Identifier of the Organization	Identification of the legal registration of the seller
HTGSOIDT	x	optional	VARCHAR(10)	Type of Organization Identifier	Identification of the scheme
HTGSOTRBN	x	optional	VARCHAR(50)	Trading Business name	trade name of the seller
Detailed information on the business address of the seller
HTGSOEZIP	x		VARCHAR(10)	ZIP Code of the Seller Organization	Postcode
HTGSOEAD1	x	optional	VARCHAR(50)	Address line 1 of the Seller Organization	Address line 1
HTGSOEAD2	x	optional	VARCHAR50)	Address line 2 of the Seller Organization	Address line 2
HTGSOEAD3	x	optional	VARCHAR(50)	Address line 3 of the Seller Organization	Address line 3
HTGSOELC	x	optional	VARCHAR(50)	City of the Seller Organization	City
HTGSOECR	x	required	VARCHAR(3)	Country ISO of the Seller Organization	Country (code)
Contact details of the seller (optional)
HTGSECT	x	abhängig	VARCHAR(50)	Contact Name of the Seller	seller's contact point	Karin Mustermann
HTGSECTD	x	abhängig	VARCHAR(50)	Department name of the Seller	seller's contact point	Invoicing
Detailed information about the phone number of the seller (optional)
HTGSETE	x	required	VARCHAR(50)	Phone number of the Seller	Phone number of the seller	+49 (123) 456789-0
Detailed information on the fax number of the seller (optional)
HTGSEFX	x	required	VARCHAR(50)	Fax number of the Seller	Fax number of the seller	+49 (123) 456789-999
Detailed information about the email address of the seller (optional)
HTGSEEM	x	required	VARCHAR(200)	Mail adress of the Seller	Email address of the seller	karin.mustermann@seller.tld
Postal address of the seller (required)
HTGSEZIP	x	optional	VARCHAR(10)	ZIP Code of the Seller	Postcode of the seller address	80333
HTGSEAD1	x	optional	VARCHAR(50)	Adress line 1 of the Seller	Line 1 of the seller address	Supplier Street 20
HTGSEAD2	x	optional	VARCHAR(50)	Adress line 2 of the Seller	Line 2 of the seller address	Building 3
HTGSEAD3	x	optional	VARCHAR(50)	Adress line 3 of the Seller	Line 3 of the seller address	Building 3
HTGSELC	x	optional	VARCHAR(50)	City of the Seller	Place of the seller	Munich
HTGSECR	x	required	CHAR(3)	Country ISO of the Seller	Land des Verkäufers (Code)	DE
HTGSCSDN	x	optional	VARCHAR(25)	Country federal state	Federal state
Electronic address details (optional)
HTGSURID	x	required	VARCHAR(55)	Electronic address	Electronic address of the seller
HTGSURIDT	x	required	VARCHAR(10)	Electronic address type	Identification of the scheme
Detailed information on tax details of the seller (optional)
HTGSETAX	x	required	VARCHAR(35)	Taxnumber of the Seller	Tax number of the seller (FC)	01/113/40209
HTGSETAXT	x	required	VARCHAR(35)	USTid of the Seller	Value added tax identification number (VA)	DE234567891
Detailed information about the buyer (required)
HTGBID	x	optional	VARCHAR(35)	Identifier of the Buyer	Identifier of the buyer (customer number)	B123456
HTGBGLN	x	optional	VARCHAR(35)	Global identifier of the Buyer	Global identifier of the buyer	4000001000006
HTGBGLNT	x	required wenn HTGBYGLN gefüllt ist.	CHAR(5)	Type of global Identifier	Identification of the scheme
HTGBNAME	x	required	VARCHAR(255)	Company/Name of the Buyer	Company name/name of the buyer	Kunden AG Mitte
Details of the organization (optional)
HTGBOID	x	optional	VARCHAR(35)	Identifier of the Organization	Identification of the legal registration of the buyer
HTGBOIDT	x	optional	VARCHAR(10)	Type of Organization Identifier	Identification of the scheme
HTGBOTRBN	x	optional	VARCHAR(50)	Trading Business name	Trade name of the buyer
Detailed information on the business address (optional)
HTGBOEZIP	x	optional	VARCHAR(10)	ZIP Code of the Buyer Organization	Postcode
HTGBOEAD1	x	optional	VARCHAR(50)	Address line 1 of the Buyer Organization	Address line 1
HTGBOEAD2	x	optional	VARCHAR(50)	Address line 2 of the Buyer Organization	Address line 2
HTGBOEAD3	x	optional	VARCHAR(50)	Address line 3 of the Buyer Organization	Address line 3
HTGBOELC	x	optional	VARCHAR(50)	City of the Buyer Organization	City
HTGBOECR	x	optional	CHAR(3)	Country ISO of the Buyer Organization	Country (code)
Contact details of the buyer (optional)
HTGBCT	x	optional	VARCHAR(50)	Contact Name of the Buyer	Contact point of the buyer	Hans Muster
HTGBCTD	x	optional	VARCHAR(50)	Department name of the Buyer	Contact point of the buyer	Invoicing
Detailed information on the telephone number of the contact person (optional)
HTGBTE	x	required	VARCHAR(50)	Phone number of the Buyer	Phone number of the buyer's contact point	+49 (123) 56789-0
Detailed information on the fax number of the contact person (optional)
HTGBFX	x	required	VARCHAR(50)	Fax number of the Buyer	Fax number of the buyer	+49 (123) 56789-999
Detailed information on the email address of the contact person (optional)
HTGBEM	x	required	VARCHAR(200)	Mail adress of the Buyer	E-mail address of the buyer's contact point	hans.muster@buyer.tld
Detailed information on the address of the buyer (required)
HTGBZIP	x	optional	VARCHAR(10)	ZIP Code of the Buyer	Postcode of the buyer	69876
HTGBAD1	x	optional	VARCHAR(50)	Adress line 1 of the Buyer	Line 1 of the buyer address	Customer Street 15
HTGBAD2	x	optional	VARCHAR(50)	Adress line 2 of the Buyer	Line 2 of the buyer address	3rd floor right
HTGBAD3	x	optional	VARCHAR(50)	Adress line 3 of the Buyer	Line 3 of the buyer address	3rd floor right
HTGBLC	x	optional	VARCHAR(50)	City of the Buyer	City of buyer's address	Frankfurt
HTGBCR	x	required	CHAR(3)	Country ISO of the Buyer	Country code of the buyer address	DE
HTGBCSDN	x	optional	VARCHAR(25)	Country federal state	Federal state
Electronic address details (optional)
HTGBURID	x	required	VARCHAR(55)	Electronic address	Electronic address of the buyer
HTGBURIDT	x	required	VARCHAR(10)	Electronic address type	Identification of the scheme
Detailed information on tax details of the buyer (recommended)
HTGBTAX	x	required	VARCHAR(35)	Taxnumber of the Buyer	Tax number of the buyer (FC)	201/123/12341
HTGBTAXT	x	required	VARCHAR(35)	USTid of the Buyer	Value added tax identification number (VA)	DE234567781
Tax representative of the seller (optional)
HTGTID	x	optional	VARCHAR(35)	Identifier of the Seller Tax Representative	Identifier of the tax representative	B123456
HTGTGLN	x	optional	VARCHAR(35)	Global identifier of the Seller Tax Representative	Global identifier of the tax representative	4000001000006
HTGTGLNT	x	required wenn HTGBYGLN gefüllt ist.	CHAR(5)	Type of global Identifier	Identification of the scheme	0021 : SWIFT 0088 : EAN 0060 : DUNS 0177 : ODETTE
HTGTNAME	x	required	VARCHAR(255)	Company/Name of the Seller Tax Representative	Name of the tax representative of the seller	Kunden AG Mitte
Details of the organization (optional)
HTGTOID	x	optional	VARCHAR(35)	Identifier of the Organization	Identifier of the tax representative
HTGTOIDT	x	optional	VARCHAR(10)	Type of Organization Identifier	Global identifier of the tax representative
HTGTOTRBN	x	optional	VARCHAR(50)	Trading Business name	Identification of the scheme
Detailed information on the contact person (optional)
HTGTCT	x	optional	VARCHAR(50)	Contact Name of the Seller Tax Representative	Contact point of the buyer	Hans Muster
HTGTCTD	x	optional	VARCHAR(50)	Department name of the Seller Tax Representative	Contact point of the buyer	Invoicing
Detailed information on the telephone number of the contact person (optional)
HTGTTE	x	required	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	x	required	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	x	required	VARCHAR(200)	Mail address of the Seller Tax Representative	E-mail address of the buyer's contact point	hans.muster@buyer.tld
Postal address of the tax representative of the seller (required)
HTGTZIP	x	optional	VARCHAR(10)	ZIP Code of the Seller Tax	Postcode of the tax agent's address
HTGTAD1	x	optional	VARCHAR(50)	Address line 1 of the Seller Tax Representative	Line 1 of the tax agent's document
HTGTAD2	x	optional	VARCHAR(50)	Address line 2 of the Seller Tax Representative	Line 2 of the tax agent's document
HTGTAD3	x	optional	VARCHAR(50)	Address line 3 of the Seller Tax Representative	Line 3 of the tax agent's document
HTGTLC	x	optional	VARCHAR(50)	City of the Seller Tax Representative	City of the tax attorney's office
HTGTCR	x	required	CHAR(3)	Country ISO of the Seller Tax Representative	Country code of the tax representative address
HTGTCSDN	x	optional	VARCHAR(25)	Country federal state	Federal state
Electronic address details (optional)
HTGTURID	x	required	VARCHAR(55)	Electronic address	Electronic address
HTGTURIDT	x	required	VARCHAR(10)	Electronic address type	Type of electronic address
Detailed information on the tax number of the tax representative of the seller (required)
HTGTTAX	x	required	VARCHAR(35)	Taxnumber of the Seller Tax Representative	Tax number (FC)
HTGTTAXT	x	required	VARCHAR(35)	USTid of the Seller Tax Representative	Value added tax identification number (VA)
Detailed information on the deviating end consumer (optional)
HTGUDID	x	optional	VARCHAR(35)	Identifier of the deviating end user	Identification of the deviating end user
HTGUDGLN	x	optional	VARCHAR(35)	Global identifier of the deviating end user	Global identifier of the deviating end user
HTGUDGLNT	x	required wenn HTGUDGLN gefüllt ist.	CHAR(5)	Type of global identifier	Type of global identification number	0021 : SWIFT 0088 : EAN 0060 : DUNS 0177 : ODETTE
HTGUDNAME	x	required	VARCHAR(255)	Company/Name of the deviating end user	Name/name of the end user
Details of the organization (optional)
HTGUDOID	x	optional	VARCHAR(35)	Identifier of the Organization	Commercial register number
HTGUDOIDT	x	required wenn HTGUDOID gefüllt ist.	VARCHAR(10)	Type of Organization Identifier	Type of number
HTGUDOTRBN	x	optional	VARCHAR(50)	Trading Business name	Trade name
Detailed information on the contact person of the deviating end user (optional)
HTGUDCT	x	optional	VARCHAR(50)	Contact Name of the deviating end user	Name of contact person
HTGUDCTD	x	optional	VARCHAR(50)	Department name of the deviating end user	Department of the contact person
Detailed information on the telephone number of the contact person (optional)
HTGUDTE	x	required	VARCHAR(50)	Phone number of the deviating end user	Telephone number of the contact person
Detailed information on the fax number of the contact person (optional)
HTGUDFX	x	required	VARCHAR(50)	Fax number of the deviating end user	Fax number
Detailed information on the email address of the contact person (optional)
HTGUDEM	x	required	VARCHAR(200)	Mail adress of the deviating end user	email address
Detailed information on the address of the deviating end consumer (required)
HTGUDZIP	x	optional	VARCHAR(10)	ZIP Code of the deviating end user	Postcode
HTGUDAD1	x	optional	VARCHAR(50)	Adress line 1 of the deviating end user	Address line 1
HTGUDAD2	x	optional	VARCHAR(50)	Adress line 2 of the deviating end user	Address line 2
HTGUDAD3	x	optional	VARCHAR(50)	Adress line 3 of the deviating end user	Address line 3
HTGUDLC	x	optional	VARCHAR(50)	City of the deviating end user	City
HTGUDCR	x	required	CHAR(4)	Country ISO of the deviating end user	Country (code)
HTGUDCSDN	x	optional	VARCHAR(25)	Country federal state	Federal state
Electronic address details (optional)
HTGUDURID	x	required	VARCHAR(55)	Electronic address	Electronic address
HTGUDURIDT	x	required	VARCHAR(10)	Electronic address type	Type of electronic address
Detailed information on the tax number of the alternative end consumer (optional)
HTGUDTAX	x	required	VARCHAR(35)	Taxnumber of the deviating end user	Tax number
HTGUDTAXT	x	required	VARCHAR(35)	USTid of the deviating end user	Value added tax identification number
Detailed information on the delivery conditions (optional)
HTGDPTERM	x	optional	VARCHAR(3)	Delivery Conditions (CODE)	Delivery condition (code)
Details of the associated order confirmation (optional)
HTGORDERNR	x	required	VARCHAR(35)	Order number	Sales order reference
HTGORDERD	x	optional	DATE '0001-01-01'	Date of order	Details of the order confirmation date
Details of the associated order (optional)
HTGCORDNR	x	required	VARCHAR(35)	Order number	Order reference
HTGCORDD	x	optional	DATE '0001-01-01'	Date of order	order date
Details of the associated contract (optional)
HTGCONTRNR	x	required	VARCHAR(35)	Agreement number	Contract reference
HTGCONTRD	x	optional	DATE '0001-01-01'	Date of agreement	Contract date
Justifying documents (optional)
Note table ZF2INVDR.
Detailed information on a project reference (optional)
HTSPPID	x	required	INTEGER	Project reference ID	Project reference
HTSPPNA	x	required	VARCHAR(35)	Project name	Project name
UltimateCustomerOrderReferencedDocument (x) (optional)
Note table ZF2INVUDR.
Grouping of delivery data (required)
Detailed information on the shipping method (x) (optional)
Note table ZF2INVDM.
Delivery information (optional)
HTLWRDID	x	optional	VARCHAR(35)	Identifier of the were recipients	Identification of the ship-to party	TO123456
HTLWRDGLN	x	optional	VARCHAR(35)	Global identifier of the were recipients	Global identifier of the ship-to party (GLN)	4000001000007
HTLWRDGLNT	x	required wenn HTLWRDGLNT gefüllt ist.	CHAR(5)	Type of global identifier	Identification of the scheme	0021 : SWIFT 0088 : EAN 0060 : DUNS 0177 : ODETTE
HTLWRDREC	x	required	VARCHAR(255)	Company/Name of the were recipients	Name/name of the consignee
Details of the organization (optional)
HTLWROID	x	optional	VARCHAR(35)	Identifier of the Organization	Commercial register number
HTLWROIDT	x	optional	VARCHAR(10)	Type of Organization Identifier	Type of number	0021 : SWIFT 0088 : EAN 0060 : DUNS 0177 : ODETTE
HTLWROTRBN	x	optional	VARCHAR(50)	Trading Business name	Trade name
Detailed information on the contact person of the ship-to party (optional)
HTLWRDCN	x	optional	VARCHAR(50)	Contact Name of the were recipients	Name of contact person
HTLWRDDN	x	optional	VARCHAR(50)	Department name of the were recipients	Department of the contact person
Detailed information on the telephone number of the contact person (optional)
HTLWRDTEL	x	required	VARCHAR(50)	Phone number of the were recipients	Telephone number of the contact person
Detailed information on the fax number of the contact person (optional)
HTLWRDFAX	x	required	VARCHAR(50)	Fax number of the were recipients	Fax number
Detailed information on the email address of the contact person (optional)
HTLWRDMAIL	x	required	VARCHAR(200)	Mail adress of the were recipients	email address
Delivery address (optional)
HTLWRDPLZ	x	optional	VARCHAR(10)	ZIP Code of the were recipients	Postcode of the delivery address
HTLWRDAD1	x	optional	VARCHAR(50)	Adress line 1 of the were recipients	Line 1 of the delivery address
HTLWRDAD2	x	optional	VARCHAR(50)	Adress line 2 of the were recipients	Line 2 of the delivery address
HTLWRDAD3	x	optional	VARCHAR(50)	Adress line 3 of the were recipients	Line 3 of the delivery address
HTLWRDCITY	x	optional	VARCHAR(50)	City of the were recipients	City of delivery address
HTLWRDLC	x	required	CHAR(4)	Country ISO of the were recipients	Country code of delivery address
HTLWRCSDN	x	optional	VARCHAR(25)	Country federal state	Federal state
Electronic address details (optional)
HTLWRURID	x	optional	VARCHAR(55)	Eletronic address	Electronic address
HTLWRURIDT	x	optional	VARCHAR(10)	Eletronic address type	Type of electronic address
Detailed information on the tax number of the ship-to party (optional)
HTLWRDSNR	x	optional	VARCHAR(35)	Taxnumber of the were recipients	Tax number
HTLWRDASNR	x	optional	VARCHAR(35)	USTid of the were recipients	Umsatzsteueridentnummer
Detailed information on the different final recipient (optional)
HTLFRDID	x	optional	VARCHAR(35)	Identifier of the final recipient	Identification of the final recipient
HTLFRDGLN	x	optional	VARCHAR(35)	Global identifier of the final recipient	Global identifier of the final recipient
HTLFRDGLNT	x	required wenn HTLFRDGLN gefüllt ist.	CHAR(5)	Type of global Identifier	Identification of the scheme
HTLFRDREC	x	optional	VARCHAR(255)	Company/Name of the final recipient	Name/name of the final recipient
Details of the organization (optional)
HTLFROID	x	optional	VARCHAR(35)	Identifier of the Organization	Commercial register number
HTLFROIDT	x	optional	VARCHAR(10)	Type of Organization Identifier	Identification of the scheme
HTLFROTRBN	x	optional	VARCHAR(50)	Trading Business name	Trade name
Detailed information on the contact person of the final recipient (optional)
HTLFRDCN	x	abhängig	VARCHAR(50)	Contact Name of the final recipient	Name of contact person
HTLFRDDN	x	abhängig	VARCHAR(50)	Department name of the final recipient	Department of the contact person
Detailed information on the telephone number of the contact person (optional)
HTLFRDTEL	x	required	VARCHAR(50)	Phone number of the final recipient	Telephone number of the contact person
Detailed information on the fax number of the contact person (optional)
HTLFRDFAX	x	required	VARCHAR(50)	Fax number of the final recipient	Fax number
Detailed information on the email address of the contact person (optional)
HTLFRDMAIL	x	required	VARCHAR(200)	Mail adress of the final recipient	email address
Detailed information on the address of the final recipient (optional)
HTLFRDPLZ	x	optional	VARCHAR(10)	ZIP Code of the final recipient	Postcode
HTLFRDAD1	x	optional	VARCHAR(50)	Adress line 1 of the final recipient	Address line 1
HTLFRDAD2	x	optional	VARCHAR(50)	Adress line 2 of the final recipient	Address line 2
HTLFRDAD3	x	optional	VARCHAR(50)	Adress line 3 of the final recipient	Address line 3
HTLFRDCITY	x	optional	VARCHAR(50)	City of the final recipient	City
HTLFRDLC	x	required	CHAR(4)	Country ISO of the final recipient	Country (code)
HTLFRCSDN	x	optional	VARCHAR(25)	Country federal state	Federal state
Electronic address details (optional)
HTLFRURID	x	optional	VARCHAR(55)	Eletronic address	Electronic address
HTLFRURIDT	x	optional	VARCHAR(10)	Eletronic address type	Type of electronic address
Detailed information on tax data of the final recipient (optional)
HTLFRDSNR	x	optional	VARCHAR(35)	Taxnumber of the final recipient	Tax number
HTLFRDASNR	x	optional	VARCHAR(35)	USTid of the final recipient	Value added tax identification number
Identification of the deviating shipper (optional)
HTLCDID	x	optional	VARCHAR(35)	Identifier of the consignor	Identification of the consignor
HTLCDGLN	x	optional	VARCHAR(35)	Global identifier of the consignor	Global identifier of the sender
HTLCDGLNT	x	required wenn HTLCDGLN gefüllt ist.	CHAR(5)	Type of Organization Identifier	Type of global identification number
HTLCDREC	x	required	VARCHAR(255)	Company/Name of the consignor	Name/name of the sender
Details of the organization (optional)
HTLCDOID	x	optional	VARCHAR(35)	Identifier of the Organization	Commercial register number
HTLCDOIDT	x	optional	VARCHAR(10)	Type of Organization Identifier	Type of number
HTLCDOTRBN	x	optional	VARCHAR(50)	Trading Business name	Trade name
Detailed information on the shipper's contact person (optional)
HTLCDCN	x	optional	VARCHAR(50)	Contact Name of the consignor	Name of contact person
HTLCDDN	x	optional	VARCHAR(50)	Department name of the consignor	Department of the contact person
Detailed information on the telephone number of the contact person (optional)
HTLCDTEL	x	required	VARCHAR(50)	Phone number of the consignor	Telephone number of the contact person
Detailed information on the fax number of the contact person (optional)
HTLCDFAX	x	required	VARCHAR(50)	Fax number of the consignor	Fax number
Detailed information on the email address of the contact person (optional)
HTLCDMAIL	x	required	VARCHAR(200)	Mail adress of the consignor	Emailadresse
Detailed information on the sender's address (optional)
HTLCDPLZ	x	optional	VARCHAR(10)	ZIP Code of the consignor	Postcode
HTLCDAD1	x	optional	VARCHAR(50)	Adress line 1 of the consignor	Address line 1
HTLCDAD2	x	optional	VARCHAR(50)	Adress line 2 of the consignor	Address line 2
HTLCDAD3	x	optional	VARCHAR(50)	Adress line 3 of the consignor	Address line 3
HTLCDCITY	x	optional	VARCHAR(50)	City of the consignor	City
HTLCDLC	x	required	CHAR(4)	Country ISO of the consignor	Country (code)
HTLCDCSDN	x	optional	VARCHAR(25)	Country federal state	Federal state
Electronic address details (optional)
HTLCDURID	x	optional	VARCHAR(55)	Eletronic address	Electronic address
HTLCDURIDT	x	optional	VARCHAR(10)	Eletronic address type	Type of electronic address
Detailed information on tax details of the sender (optional)
HTLCDSNR	x	optional	VARCHAR(35)	Taxnumber of the consignor	Tax number
HTLCDASNR	x	optional	VARCHAR(35)	USTid of the consignor	Value 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.
HTLDTD	x	required	DATE '0001-01-01'	Actual Delivery Time	Actual date of delivery	2018-12-10
Detailed information on the corresponding shipping notification (optional)
HTLDANR	x	required	VARCHAR(25)	Despatch advice number	Shipping notification reference
HTLDALD	x	optional	DATE '0001-01-01'	Date of Despatch advice	Shipping notification date
Detailed information on the corresponding final backflush (optional)
HTLWDANR	x	required	VARCHAR(25)	Goods receipt notification number	Reference to the final backflush
HTLWDALD	x	optional	DATE '0001-01-01'	Date of goods receipt notification	Goods receipt date
Detailed information on the corresponding delivery note (optional)
HTLDLSNR	x	required	VARCHAR(35)	Delivery Note number	Delivery note number
HTLDLSD	x	optional	DATE '0001-01-01'	Date of Delivery Note	Delivery note date
Grouping of payment and invoice settlement details (required)
HTZGPCID	x	optional	VARCHAR(15)	Creditor ID	Identification of the creditor
HTZGPZR	x	empfohlen	VARCHAR(200)	Intended purpose	Intended use
HTZGPTC	x	optional	VARCHAR(5)	Tax Currency Code	Code for the currency of the sales tax posting
HTZGPIC	x	required	VARCHAR(5)	Invoice Currency Code	Code for the invoice currency
HTZGPIRN	x	optional	INTEGER	Issuer reference number	Seller's reference number
InvoicerTradeParty (optional)
HTZITDREID	x	optional	VARCHAR(35)	Identifier of the Invoicing party Trade partner	Identifier
HTZITDGLN	x	optional	VARCHAR(35)	Global identifier of the Invoicing party Trade partner	Global identifier
HTZITDGLNT	x	required wenn HTZITDGLN gefüllt ist.	CHAR(5)	Type of global Identifier	Type of global identification number
HTZIRDREC	x	required	VARCHAR(255)	Company/Name of the Invoice recipient	Name
Details of the organization (optional)
HTZITOID	x	optional	VARCHAR(35)	Identifier of the Organization	Commercial register number
HTZITOIDT	x	optional	VARCHAR(10)	Type of Organization Identifier	Type of number
HTZITOTRBN	x	optional	VARCHAR(50)	Trading Business name	Trade name	Type of global identification number
DefinierterHandelskontakt (optional)
HTZITDCN	x	optional	VARCHAR(50)	Contact Name of the Invoicing party Trade partner	Contact person name
HTZITDDN	x	optional	VARCHAR(50)	Department name of the Invoicing party Trade partner	Department name
Detailed information on the telephone number (optional)
HTZITDTEL	x	required	VARCHAR(50)	Phone number of the Invoicing party Trade partner	Phone number
Detailed information about the fax number (optional)
HTZITDFAX	x	required	VARCHAR(50)	Fax number of the Invoicing party Trade partner	Faxnummer
Detailed information about the email address (optional)
HTZITDMAIL	x	required	VARCHAR(200)	Mail address of the Invoicing party Trade partner	email address
PostalTradeAddress (optional)
HTZITDEPLZ	x	optional	VARCHAR(10)	ZIP Code of the Invoicing party Trade partner	Postcode
HTZITDAD1	x	optional	VARCHAR(50)	Address line 1 of the Invoicing party Trade partner	Address line 1
HTZITDAD2	x	optional	VARCHAR(50)	Address line 2 of the Invoicing party Trade partner	Address line 2
HTZITDAD3	x	optional	VARCHAR(50)	Address line 3 of the Invoicing party Trade partner	Address line 3
HTZITDCITY	x	optional	VARCHAR(50)	City of the Invoicing party Trade partner	City
HTZITDLLC	x	required	CHAR(4)	Country ISO of the Invoicing party Trade partner	Country (code)
HTZITCSDN	x	optional	VARCHAR(25)	Country federal state of the Invoicing party Trade partner	Federal state
Electronic address details (optional)
HTZITURID	x	optional	VARCHAR(55)	Electronic address of the Invoicing party Trade partner	Electronic address
HTZITURIDT	x	optional	VARCHAR(10)	Electronic address type of the Invoicing party Trade partner	Type of electronic address
Detailed information on tax numbers (optional)
HTZITDSNR	x	optional	VARCHAR(35)	Taxnumber of the Invoicing party Trade partner	Tax number (FC)
HTZITDASNR	x	optional	VARCHAR(35)	USTid of the Invoicing party Trade partner	Tax number (VA)
Detailed information on the different invoice recipient (optional)
HTZIRDREID	x	optional	VARCHAR(35)	Identifier of the Invoice recipient	Identification of the invoice recipient
HTZIRDGLN	x	optional	VARCHAR(35)	Global identifier of the Invoice recipient	Global identifier of the different invoice recipient
HTZIRDGLNT	x	required wenn HTZIRDGLN gefüllt ist.	CHAR(5)	Type of global Identifier	Identification of the scheme
HTZIRDREC	x	required	VARCHAR(255)	Company/Name of the Invoice recipient	Name/name of the invoice recipient
Details of the organization (optional)
HTZIROID	x	optional	VARCHAR(35)	Identifier of the Organization	Commercial register number
HTZIROIDT	x	optional	VARCHAR(10)	Type of Organization Identifier	Type of number
HTZIROTRBN	x	optional	VARCHAR(50)	Trading Business name	Trade name
Detailed information on the contact person of the invoice recipient (optional)
HTZIRDCN	x	optional	VARCHAR(50)	Contact Name of the Invoice recipient	Name of contact person
HTZIRDDN	x	optional	VARCHAR(50)	Department name of the Invoice recipient	Department of the contact person
Detailed information on the telephone number of the contact person (optional)
HTZIRDTEL	x	required	VARCHAR(50)	Phone number of the Invoice recipient	Telephone number of the contact person
Detailed information on the fax number of the contact person (optional)
HTZIRDFAX	x	required	VARCHAR(50)	Fax number of the Invoice recipient	Fax number
Detailed information on the email address of the contact person (optional)
HTZIRDMAIL	x	required	VARCHAR(200)	Mail adress of the Invoice recipient	email address
Detailed information on the address of the invoice recipient (recommended)
HTZIRDEPLZ	x	optional	VARCHAR(10)	ZIP Code of the Invoice recipient	Postcode
HTZIRDAD1	x	optional	VARCHAR(50)	Adress line 1 of the Invoice recipient	Line 1 of the address of the invoice recipient
HTZIRDAD2	x	optional	VARCHAR(50)	Adress line 2 of the Invoice recipient	Line 2 of the address of the invoice recipient
HTZIRDAD3	x	optional	VARCHAR(50)	Adress line 3 of the Invoice recipient	Line 3 of the address of the invoice recipient
HTZIRDCITY	x	optional	VARCHAR(50)	City of the Invoice recipient	City of the address of the invoice recipient
HTZIRDLLC	x	required	CHAR(4)	Country ISO of the Invoice recipient	Country code of the address of the invoice recipient
HTZIRCSDN	x	optional	VARCHAR(25)	Country federal state	Federal state
Electronic address details (optional)
HTZIRURID	x	required	VARCHAR(55)	Electronic address	Electronic address
HTZIRURIDT	x	required	VARCHAR(10)	Electronic address type	Type of electronic address
Detailed information on the tax number of the invoice recipient (optional)
HTZIRDSNR	x	optional	VARCHAR(35)	Taxnumber of the Invoice recipient	Tax number
HTZIRDASNR	x	optional	VARCHAR(35)	USTid of the Invoice recipient	Value added tax identification number
Payee (optional)
HTZPRDREID	x	optional	VARCHAR(35)	Identifier of the Payment Receiver	Identification of the alternative payee
HTZPRDGLN	x	optional	VARCHAR(35)	Global identifier of the Payment Receiver	Global identifier of the deviating
HTZPRDGLNT	x	required if HTZPRDGLN is filled	CHAR(5)	Type of global Identifier	Identification of the scheme
HTZPRDREC	x	required	VARCHAR(255)	Company/Name of the Payment Receiver	Name/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	x	optional	VARCHAR(50)	Contact Name of the Payment Receiver	Name of the payee's contact person
HTZPRDDN	x	optional	VARCHAR(50)	Department name of the Payment Receiver	Department of the payee's contact person
Detailed information on the telephone number of the contact person (optional)
HTZPRDTEL	x	required	VARCHAR(50)	Phone number of the Payment Receiver	Telephone number of the payee's contact person
Detailed information on the fax number of the contact person (optional)
HTZPRDFAX	x	required	VARCHAR(50)	Fax number of the Payment Receiver	Fax number of the payee's contact person
Detailed information on the email address of the contact person (optional)
HTZPRDMAIL	x	required	VARCHAR(200)	Mail adress of the Payment Receiver	Email address of the contact person of the payee
Detailed information on the address of the payee (optional)
HTZPRDPLZ	x	optional	VARCHAR(10)	ZIP Code of the Payment Receiver	Postcode
HTZPRDAD1	x	optional	VARCHAR(50)	Adress line 1 of the Payment Receiver	Line 1 of the payee's address
HTZPRDAD2	x	optional	VARCHAR(50)	Adress line 2 of the Payment Receiver	Line 2 of the payee's address
HTZPRDAD3	x	optional	VARCHAR(50)	Adress line 3 of the Payment Receiver	Line 3 of the payee's address
HTZPRDCITY	x	optional	VARCHAR(50)	City of the Payment Receiver	City of the payee's address
HTZPRDLLC	x	required	VCHAR(4)	Country ISO of the Payment Receiver	Country code of the payee's address
HTZPRCSDN	x	optional	VARCHAR(25)	Country federal state	Federal state
Electronic address details (optional)
HTZPRURID	x	required	VARCHAR(55)	Electronic address	Electronic address
HTZPRURIDT	x	required	VARCHAR(10)	Electronic address type	Type of electronic address
Detailed information on the tax number of the alternative payee (optional)
HTZPRDSNR	x	optional	VARCHAR(35)	Taxnumber of the Payment Receiver	Tax number (FC)
HTZPRDASNR	x	optional	VARCHAR(35)	USTid of the Payment Receiver	Value added tax number (VA)
Specification of invoice currency, home currency and the exchange rate (optional)
HTZTASC	x	required	CHAR(5)	Invoicing currency	Invoice currency
HTZTATC	x	required	CHAR(5)	Home currency	Local currency
HTZTACR	x	required	DECIMAL(10, 5)	Exchange rate	Conversion rate
HTZTACD	x	optional	DATE '0001-01-01'	Date for exchange rate	Date at exchange rate
Payment instructions (optional)
Note table ZFINVOICPT.
Sales tax breakdown (optional)
Note table ZFINVOICTI.
Detailed information on the billing period (dependent)
HTZBILLPD	x	optional	VARCHAR(50)	Description of Bill period	Free text for the accounting period
HTZBILLBP	x	optional	VARCHAR(15)	Beginning of the accounting period	Beginning of the financial period
HTZBILLBPF	x	required if HTZBILLBP is filled	CHAR(3)	Date Format	Date, Format	102
HTZBILLEP	x	optional	VARCHAR(15)	End of the accounting	End of the financial period
HTZBILLEPF	x	required if HTZBILLEP is filled	CHAR(3)	Date Format	Date, Format	102
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 ZFINVOICTP.
Totals at document level (required)
HTZTSMSLT	x	required	DECIMAL(15, 2)	Total amount of positions	Total of the net amounts of all invoice items	6913.60
HTZTSMSCT	x	optional	DECIMAL(15, 2)	Total amount of surcharges	Total surcharges at document level	0.00
HTZTSMSAT	x	optional	DECIMAL(15, 2)	Total amounts of discounts	Total discounts at document level	0.00
HTZTSMSTB1	x	required	DECIMAL(15, 2)	Tax basic amount 1	Total invoice amount without sales tax 1	6913.60
HTZTSMSTB2	x	optional	DECIMAL(15, 2)	Tax basic amount 2	Total invoice amount without sales tax 2
HTZTSMSTT1	x	required	DECIMAL(15, 2)	Tax total amount 1	Total amount of invoice sales tax Total tax amount in posting currency 1	1313.58
HTZTSMSTT2	x	optional	DECIMAL(15, 2)	Tax total amount 2	Total amount of invoice turnover tax Total tax amount in posting currency 2
HTZTSMSRA	x	optional	DECIMAL(15, 2)	Rounding amount	Rounding amount
HTZTSMSGT1	x	required	DECIMAL(15, 2)	Grand total amount 1	Total invoice amount including sales tax 1	8227.18
HTZTSMSGT2	x	optional	DECIMAL(15, 2)	Grand total amount 2	Total invoice amount including sales tax 2
HTZTSMSTPA	x	optional	DECIMAL(15, 2)	Deposit amount	Advance payment amount	0.00
HTZTSMSDPA	x	required	DECIMAL(15, 2)	Payment amount	Payment amount due	8227.18
Reference to previous invoices (optional)Total invoice amount without sales tax 1
HTZIRDIAID	x	required	VARCHAR(35)	Number of previous invoice	Number of the previous invoice
HTZIRDFIDT	x	optional	DATE '0001-01-01'	Invoice Date of previous invoice	Date of invoice
Detailed information on the booking reference (optional)
Note table ZF2INVBR.
Tax information on advance payments received (optional)
Note table ZF2INVAP.
i-effect fields
HTSTATE	x		VARCHAR(1)	State of Order	Status column	Empty string = Not processed, 1 = Processed
HTSESSUM	x		DECIMAL(15, 0)	i-effect Session Number	i-effect session number
EXTERNAL_RECIPIENT	x		CHAR(255)	External recipient for SNDFILE	i-effect recipient from partner master data
EXTERNAL_ORIGINATOR	x		CHAR(255)	External originator für SNDFILE	i-effect originator from partner master data