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			VARCHAR(5)	Test indicator	Test indicator	true / false
Grouping of business process information (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 entire document. (required)
HTNDOCNR	x	required	VARCHAR(35)	Document number	invoice number	2012-12345
HTNDOCTC			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			CHAR(5)	Indicator Original/Copy	Original/copy indicator	true / false
LALLNG			CHAR(3)	Language Key	Language code
Contractual due date of the invoice (dependent)
HTNPAYD			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 (optional)
Invoice item (optional)
Note table ZF2INVPI.
Grouping of the contract details (required)
HTGBYREF	x	optional	VARCHAR(35)	Buyer reference	Buyer's reference	INV 082
Detailinformationen zum Verkäufer (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	Supplier 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			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	x	abhängig	VARCHAR(50)	Kontakt Name des Verkäufers	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			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	Lieferantenstraße 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	City of the seller	Munich
HTGSECR	x	required	CHAR(3)	Country ISO of the Seller	Country of seller (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 (VAT)	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	Customers AG Middle
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 business address (optional) ()
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	Address line 2
HTGBOEAD3			VARCHAR(50)	Address line 3 of the Buyer Organization	Address line 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	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			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 (VAT)	DE234567781
Tax representative of the seller (optional)
HTGTID			VARCHAR(35)	Identifier of the Seller Tax Representative	Identifier of the tax representative	B123456
HTGTGLN			VARCHAR(35)	Global identifier of the Seller Tax Representative	Global identifier of the tax representative	4000001000006
HTGTGLNT			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			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 buyer	Hans Muster
HTGTCTD			VARCHAR(50)	Department name of the Seller Tax Representative	Contact point of the buyer	Invoicing
Detailinformationen zur Telefonnummer des Ansprechpartners (optional)
HTGTTE			VARCHAR(50)	Phone number of the Seller Tax Representative	Telefonnummer der Kontaktstelle des Käufers	+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 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		required	VARCHAR(55)	Electronic address	Electronic address
HTGTURIDT		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 (VAT)
Detailed information on the deviating end consumer (optional)
HTGUDID			VARCHAR(35)	Identifier of the deviating end user	Identification of the deviating end user
HTGUDGLN			VARCHAR(35)	Global identifier of the deviating end user	Global identifier of the deviating end user
HTGUDGLNT			CHAR(5)	Type of global identifier	Type of global identification number	0021 : SWIFT 0088 : EAN 0060 : DUNS 0177 : ODETTE
HTGUDNAME			VARCHAR(255)	Company/Name of the deviating end user	Name/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 user	Name of contact person
HTGUDCTD			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			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			VARCHAR(50)	Fax number of the deviating end user	Fax number
Detailed information on the email address of the contact person (optional)
HTGUDEM			VARCHAR(200)	Mail adress of the deviating end user	email address
Detailed information on the address of the deviating end consumer (required)
HTGUDZIP			VARCHAR(10)	ZIP Code of the deviating end user	Postcode
HTGUDAD1			VARCHAR(50)	Adress line 1 of the deviating end user	Address line 1
HTGUDAD2			VARCHAR(50)	Adress line 2 of the deviating end user	Address line 2
HTGUDAD3			VARCHAR(50)	Adress line 3 of the deviating end user	Address line 3
HTGUDLC			VARCHAR(50)	City of the deviating end user	City
HTGUDCR			CHAR(4)	Country ISO of the deviating end user	Country (code)
HTGUDCSDN			VARCHAR(25)	Country federal state	Federal state
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 user	Tax number
HTGUDTAXT			VARCHAR(35)	USTid of the deviating end user	Value 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	x	required	VARCHAR(35)	Order number	Sales order reference
HTGORDERD			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			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			DATE '0001-01-01'	Date of agreement	Contract date
Justifying documents (x) (optional)
Note table ZF2INVDR.
Detailed information on a project reference (optional)
HTSPPID	x	required	VARCHAR(10)	Project reference ID	Project reference
HTSPPNA	x	required	VARCHAR(35)	Project name	Project name
UltimateCustomerOrderReferencedDocument (EXTENDED only) (optional)
Note table ZF2INVUDR.
Grouping of delivery data (required)
Detailed information on the shipping method (EXTENDED only) (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			VARCHAR(35)	Identifier of the Organization	Commercial register number
HTLWROIDT			VARCHAR(10)	Type of Organization Identifier	Type of number	0021 : SWIFT 0088 : EAN 0060 : DUNS 0177 : ODETTE
HTLWROTRBN			VARCHAR(50)	Trading Business name	Trade name
Detailed information on the contact person of the ship-to party (optional)
HTLWRDCN			VARCHAR(50)	Contact Name of the were recipients	Name of contact person
HTLWRDDN			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			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			VARCHAR(50)	Fax number of the were recipients	Fax number
Detailed information on the email address of the contact person (optional)
HTLWRDMAIL			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			VARCHAR(55)	Eletronic address	Electronic address
HTLWRURIDT			VARCHAR(10)	Eletronic address type	Type of electronic address
Detailed information on the tax number of the ship-to party (optional)
HTLWRDSNR			VARCHAR(35)	Taxnumber of the were recipients	Steuernummer
HTLWRDASNR			VARCHAR(35)	USTid of the were recipients	Value added tax identification number
Detailed information on the different final recipient (optional)
HTLFRDID			VARCHAR(35)	Identifier of the final recipient	Identification of the final recipient
HTLFRDGLN			VARCHAR(35)	Global identifier of the final recipient	Global identifier of the final recipient
HTLFRDGLNT			CHAR(5)	Type of global Identifier	Identification of the scheme
HTLFRDREC			VARCHAR(255)	Company/Name of the final recipient	Name/name of the final recipient
Details of the organization (optional)
HTLFROID			VARCHAR(35)	Identifier of the Organization	Commercial register number
HTLFROIDT			VARCHAR(10)	Type of Organization Identifier	Identification of the scheme
HTLFROTRBN			VARCHAR(50)	Trading Business name	Trade name
Detailed information on the contact person of the final recipient (optional)
HTLFRDCN			VARCHAR(50)	Contact Name of the final recipient	Name of contact person
HTLFRDDN			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			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			VARCHAR(50)	Fax number of the final recipient	Fax number
Detailed information on the email address of the contact person (optional)
HTLFRDMAIL			VARCHAR(200)	Mail adress of the final recipient	email address
Detailed information on the address of the final recipient (optional)
HTLFRDPLZ			VARCHAR(10)	ZIP Code of the final recipient	Postcode
HTLFRDAD1			VARCHAR(50)	Adress line 1 of the final recipient	Address line 1
HTLFRDAD2			VARCHAR(50)	Adress line 2 of the final recipient	Address line 2
HTLFRDAD3			VARCHAR(50)	Adress line 3 of the final recipient	Address line 3
HTLFRDCITY			VARCHAR(50)	City of the final recipient	City
HTLFRDLC			CHAR(4)	Country ISO of the final recipient	Country (code)
HTLFRCSDN			VARCHAR(25)	Country federal state	Federal state
Electronic address details (optional)
HTLFRURID			VARCHAR(55)	Eletronic address	Electronic address
HTLFRURIDT			VARCHAR(10)	Eletronic address type	Type of electronic address
Detailed information on tax data of the final recipient (optional)
HTLFRDSNR			VARCHAR(35)	Taxnumber of the final recipient	Tax number
HTLFRDASNR			VARCHAR(35)	USTid of the final recipient	Value added tax identification number
Identification of the deviating shipper (optional)
HTLCDID			VARCHAR(35)	Identifier of the consignor	Identification of the consignor
HTLCDGLN			VARCHAR(35)	Global identifier of the consignor	Global identifier of the sender
HTLCDGLNT			CHAR(5)	Type of Organization Identifier	Type of global identification number
HTLCDREC			VARCHAR(255)	Company/Name of the consignor	Name/name of the sender
Details of the organization (optional)
HTLCDOID			VARCHAR(35)	Identifier of the Organization	Commercial register number
HTLCDOIDT			VARCHAR(10)	Type of Organization Identifier	Type of number
HTLCDOTRBN			VARCHAR(50)	Trading Business name	Trade name
Detailed information on the shipper's contact person (optional)
HTLCDCN			VARCHAR(50)	Contact Name of the consignor	Name of contact person
HTLCDDN			VARCHAR(50)	Department name of the consignor	Department of the contact person
Detailed information on the telephone number of the contact person (optional)
HTLCDTEL			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			VARCHAR(50)	Fax number of the consignor	Fax number
Detailed information on the email address of the contact person (optional)
HTLCDMAIL			VARCHAR(200)	Mail adress of the consignor	email address
Detailed information on the sender's address (optional)
HTLCDPLZ			VARCHAR(10)	ZIP Code of the consignor	Postcode
HTLCDAD1			VARCHAR(50)	Adress line 1 of the consignor	Address line 1
HTLCDAD2			VARCHAR(50)	Adress line 2 of the consignor	Address line 2
HTLCDAD3			VARCHAR(50)	Adress line 3 of the consignor	Address line 3
HTLCDCITY			VARCHAR(50)	City of the consignor	City
HTLCDLC			CHAR(4)	Country ISO of the consignor	Country (code)
HTLCDCSDN			VARCHAR(25)	Country federal state	Federal state
Electronic address details (optional)
HTLCDURID			VARCHAR(55)	Eletronic address	Electronic address
HTLCDURIDT			VARCHAR(10)	Eletronic address type	Type of electronic address
Detailed information on tax details of the sender (optional)
HTLCDSNR			VARCHAR(35)	Taxnumber of the consignor	Tax number
HTLCDASNR			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		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		optional	DATE '0001-01-01'	Date of goods receipt notification	Goods receipt date
Detailed information on the corresponding delivery note (optional)
HTLDLSNR			VARCHAR(35)	Delivery Note number	Delivery note number
HTLDLSD			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			INTEGER	Issuer reference number	Seller's reference number
RechnungsstellerHandelspartei (optional)
HTZITDREID			VARCHAR(35)	Identifier of the Invoicing party Trade partner	Identifier
HTZITDGLN			VARCHAR(35)	Global identifier of the Invoicing party Trade partner	Global Identifier
HTZITDGLNT			CHAR(5)	Type of global Identifier	Type of global identification number
HTZIRDREC			VARCHAR(255)	Company/Name of the Invoice recipient	Name
Details of the organization (optional)
HTZITOID			VARCHAR(35)	Identifier of the Organization	Commercial register number
HTZITOIDT			VARCHAR(10)	Type of Organization Identifier	Type of number
HTZITOTRBN			VARCHAR(50)	Trading Business name	Trade name
DefinierterHandelskontakt (optional)
HTZITDCN			VARCHAR(50)	Contact Name of the Invoicing party Trade partner	Contact person name
HTZITDDN			VARCHAR(50)	Department name of the Invoicing party Trade partner	Department name
Detailed information on the telephone number (optional)
HTZITDTEL			VARCHAR(50)	Phone number of the Invoicing party Trade partner	Phone number
Detailed information about the fax number (optional)
HTZITDFAX			VARCHAR(50)	Fax number of the Invoicing party Trade partner	Fax number
Detailed information about the email address (optional)
HTZITDMAIL			VARCHAR(200)	Mail address of the Invoicing party Trade partner	email address
PostalTradeAddress (optional)
HTZITDEPLZ			VARCHAR(10)	ZIP Code of the Invoicing party Trade partner	Postcode
HTZITDAD1			VARCHAR(50)	Address line 1 of the Invoicing party Trade partner	Address line 1
HTZITDAD2			VARCHAR(50)	Address line 2 of the Invoicing party Trade partner	Address line 2
HTZITDAD3			VARCHAR(50)	Address line 3 of the Invoicing party Trade partner	Address line 3
HTZITDCITY			VARCHAR(50)	City of the Invoicing party Trade partner	City
HTZITDLLC			CHAR(4)	Country ISO of the Invoicing party Trade partner	Country (Code)
HTZITCSDN			VARCHAR(25)	Country federal state of the Invoicing party Trade partner	Federal state
Electronic address details (optional)
HTZITURID			VARCHAR(55)	Electronic address of the Invoicing party Trade partner	Electronic address
HTZITURIDT			VARCHAR(10)	Electronic address type of the Invoicing party Trade partner	Type of electronic address
Detailed information on tax numbers (optional)
HTZITDSNR			VARCHAR(35)	Taxnumber of the Invoicing party Trade partner	Tax number (FC)
HTZITDASNR			VARCHAR(35)	USTid of the Invoicing party Trade partner	Tax number (VA)
Detailed information on the different invoice recipient (optional)
HTZIRDREID			VARCHAR(35)	Identifier of the Invoice recipient	Identification of the invoice recipient
HTZIRDGLN			VARCHAR(35)	Global identifier of the Invoice recipient	Global identifier of the different invoice recipient
HTZIRDGLNT			CHAR(5)	Type of global Identifier	Identification of the scheme
HTZIRDREC			VARCHAR(255)	Company/Name of the Invoice recipient	Name/name of the invoice recipient
Details of the organization (optional)
HTZIROID			VARCHAR(35)	Identifier of the Organization	Commercial register number
HTZIROIDT			VARCHAR(10)	Type of Organization Identifier	Type of number
HTZIROTRBN			VARCHAR(50)	Trading Business name	Trade name
Detailed information on the contact person of the invoice recipient (optional)
HTZIRDCN			VARCHAR(50)	Contact Name of the Invoice recipient	Name of contact person
HTZIRDDN			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			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			VARCHAR(50)	Fax number of the Invoice recipient	Fax number
Detailed information on the email address of the contact person (optional)
HTZIRDMAIL			VARCHAR(200)	Mail adress of the Invoice recipient	email address
Detailed information on the address of the invoice recipient (recommended)
HTZIRDEPLZ			VARCHAR(10)	ZIP Code of the Invoice recipient	Postcode
HTZIRDAD1			VARCHAR(50)	Adress line 1 of the Invoice recipient	Line 1 of the address of the invoice recipient
HTZIRDAD2			VARCHAR(50)	Adress line 2 of the Invoice recipient	Line 2 of the address of the invoice recipient
HTZIRDAD3			VARCHAR(50)	Adress line 3 of the Invoice recipient	Line 3 of the address of the invoice recipient
HTZIRDCITY			VARCHAR(50)	City of the Invoice recipient	City of the address of the invoice recipient
HTZIRDLLC			CHAR(4)	Country ISO of the Invoice recipient	Country code of the address of the invoice recipient
HTZIRCSDN			VARCHAR(25)	Country federal state	Federal state
Electronic address details (optional)
HTZIRURID			VARCHAR(55)	Electronic address	Electronic address
HTZIRURIDT			VARCHAR(10)	Electronic address type	Type of electronic address
Detailed information on the tax number of the invoice recipient (optional)
HTZIRDSNR			VARCHAR(35)	Taxnumber of the Invoice recipient	Tax number
HTZIRDASNR			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 wenn HTZPRDGLN gefüllt ist.	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			VARCHAR(50)	Contact Name of the Payment Receiver	Name of the payee's contact person
HTZPRDDN			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			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			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			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 (recommended)
HTZPRDPLZ			VARCHAR(10)	ZIP Code of the Payment Receiver	Postcode
HTZPRDAD1			VARCHAR(50)	Adress line 1 of the Payment Receiver	Line 1 of the payee's address
HTZPRDAD2			VARCHAR(50)	Adress line 2 of the Payment Receiver	Line 2 of the payee's address
HTZPRDAD3			VARCHAR(50)	Adress line 3 of the Payment Receiver	Line 3 of the payee's address
HTZPRDCITY			VARCHAR(50)	City of the Payment Receiver	City of the payee's address
HTZPRDLLC			CHAR(4)	Country ISO of the Payment Receiver	Country code of the payee's address
HTZPRCSDN			VARCHAR(25)	Country federal state	Federal 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 Receiver	Tax number (FC)
HTZPRDASNR			VARCHAR(35)	USTid of the Payment Receiver	Value added tax number (VAT)
Specification of invoice currency, home currency and the exchange rate (optional)
HTZTASC			CHAR(5)	Invoicing currency	Invoice currency
HTZTATC			CHAR(5)	Home currency	Local currency
HTZTACR			DECIMAL(10, 5)	Exchange rate	Conversion rate
HTZTACD			DATE '0001-01-01'	Date for exchange rate	Date 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 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 wenn HTZBILLBP gefüllt ist.	CHAR(3)	Date Format	Date, Format	102
HTZBILLEP	x	optional	VARCHAR(15)	End of the accounting	End of the financial period
HTZBILLEPF	x	required wenn HTZBILLEP gefüllt ist.	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 ZFINVTP.
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		DECIMAL(15, 2)	Deposit amount	Advance payment amount	0.00
HTZTSMSDPA	x		DECIMAL(15, 2)	Payment amount	Payment amount due	8227.18
Reference to previous invoices (optional)
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			VARCHAR(1)	State of Order	Status column	Empty string = Not processed, 1 = Processed
HTSESSUM			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