ZF2INVHT - header information
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 |