ZF2INVHT - Header Information
CHAR(255)If you want to create ZUGFeRD files, fill the tables below with your data. If you need help with the filling, please contact the support.
| Column 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 (optional) | |||||||||||||
| 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 business transaction information (optional) | |||||||||||||
| Invoice item (optional) | |||||||||||||
| Note table ZF2INVPI. | |||||||||||||
| Grouping of contract details (required) | |||||||||||||
| HTGBYREF | x | optional | VARCHAR(35) | Buyer reference | Buyer 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 | Supplier Ltd. | |||||||
| HTGSDESC | 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 | ||||||||
| Detailinformationen zur Geschäftsanschrift des Verkäufers | |||||||||||||
HTGSOEZIP | VARCHAR(10) | ZIP Code of the Seller Organization | Postcode | ||||||||||
HTGSOEAD1 | VARCHAR(50) | Address line 1 of the Seller Organization | Address line 1 | ||||||||||
HTGSOEAD2 | VARCHAR50) | Address line 2 of the Seller Organization | Address line 2 | ||||||||||
HTGSOEAD3 | VARCHAR(50) | Address line 3 of the Seller Organization | Address line 3 | ||||||||||
HTGSOELC | VARCHAR(50) | City of the Seller Organization | City | ||||||||||
HTGSOECR | VARCHAR(3) | Country ISO of the Seller Organization | Country (Code) | ||||||||||
| Contact details of the seller (optional) | |||||||||||||
| HTGSECT | VARCHAR(50) | Contact Name of the Seller | seller's contact point | Karin Mustermann | |||||||||
| HTGSECTD | VARCHAR(50) | Department name of the Seller | seller's contact point | Invoicing | |||||||||
| Detailed information about the phone number of the seller (optional) | |||||||||||||
| HTGSETE | 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 | VARCHAR(200) | Mail adress of the Seller | E-mail address of the seller | karin.mustermann@seller.tld | |||||||||
| Postanschrift des Verkäufers (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 | Country of the 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 (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 | 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) (EXTENDED only) | |||||||||||||
HTGBOEZIP | VARCHAR(10) | ZIP Code of the Buyer Organization | Postcode | ||||||||||
HTGBOEAD1 | VARCHAR(50) | Address line 1 of the Buyer Organization | Address line 1 | ||||||||||
HTGBOEAD2 | VARCHAR(50) | Address line 2 of the Buyer Organization | Adresszeile 2 | ||||||||||
HTGBOEAD3 | VARCHAR(50) | Address line 3 of the Buyer Organization | Adresszeile 3 | ||||||||||
HTGBOELC | VARCHAR(50) | City of the Buyer Organization | City | ||||||||||
HTGBOECR | CHAR(3) | Country ISO of the Buyer Organization | Country (Code) | ||||||||||
| Contact details of the buyer (optional) | |||||||||||||
| HTGBCT | VARCHAR(50) | Contact Name of the Buyer | Contact point of the buyer | Hans Muster | |||||||||
| HTGBCTD | 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 | 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 | 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 | Customers AG Middle | |||||||
Details of the organization (optional) | |||||||||||||
HTGTOID | VARCHAR(35) | Identifier of the Organization | Identifier of the tax representative | ||||||||||
HTGTOIDT | VARCHAR(10) | Type of Organization Identifier | Global identifier of the tax representative | ||||||||||
HTGTOTRBN | VARCHAR(50) | Trading Business name | Identification of the scheme | ||||||||||
| Detailed information on the contact person (optional) | |||||||||||||
HTGTCT | VARCHAR(50) | Contact Name of the Seller Tax Representative | Contact point of the buyer | Hans Muster | |||||||||
HTGTCTD | 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 | VARCHAR(50) | Phone number of the Seller Tax Representative | Phone number of the buyer's contact point | +49 (123) 56789-0 | |||||||||
| Detailed information on the fax number of the contact person (optional) | |||||||||||||
HTGTFX | VARCHAR(50) | Fax number of the Seller Tax Representative | Fax number of the buyer | +49 (123) 56789-999 | |||||||||
| Detailed information on the email address of the contact person (optional) | |||||||||||||
HTGTEM | VARCHAR(200) | Mail address of the Seller Tax Representative | E-mail address of the buyer's contact 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 | VARCHAR(55) | Electronic address | Electronic address | ||||||||||
| HTGTURIDT | VARCHAR(10) | Electronic address type | Type of electronic address | ||||||||||
| Detailed information on the tax number of the tax representative of the seller (required) | |||||||||||||
| 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 | e-mail 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 | Bundesland | ||||||||||
| Electronic address details (optional) | |||||||||||||
HTGUDURID | VARCHAR(55) | Electronic address | Electronic address | ||||||||||
HTGUDURIDT | VARCHAR(10) | Electronic address type | Type of electronic address | ||||||||||
| Detailed information on the tax number of the alternative end consumer (optional) | |||||||||||||
| HTGUDTAX | VARCHAR(35) | Taxnumber of the deviating end 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 | 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 | VARCHAR(35) | Agreement number | Contract reference | ||||||||||
| HTGCONTRD | DATE '0001-01-01' | Date of agreement | Contract date | ||||||||||
| Accounting documents () (optional) | |||||||||||||
| Note table ZF2INVDR. | |||||||||||||
| Detailed information on a project reference (optional) | |||||||||||||
| HTSPPID | INTEGER | Project reference ID | Project reference | ||||||||||
| HTSPPNA | VARCHAR(35) | Project name | Project name | ||||||||||
| UltimateCustomerOrderReferencedDocument () (optional) | |||||||||||||
| Note table ZF2INVUDR. | |||||||||||||
| Grouping of delivery data (required) | |||||||||||||
| Detailed information about the shipping method (EXTENDED only) (optional) | |||||||||||||
| See table ZF2INVDM. | |||||||||||||
Delivery information (optional) | |||||||||||||
| HTLWRDID | VARCHAR(35) | Identifier of the were recipients | Identification of the ship-to party | TO123456 | |||||||||
| HTLWRDGLN | VARCHAR(35) | Global identifier of the were recipients | Global identifier of the ship-to party (GLN) | 4000001000007 | |||||||||
| HTLWRDGLNT | CHAR(5) | Type of global identifier | Identification of the scheme | 0021 : SWIFT 0088 : EAN 0060 : DUNS 0177 : ODETTE | |||||||||
| HTLWRDREC | 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 | Telefonnummer der Kontaktperson | ||||||||||
| Detailed information on the fax number of the contact person (optional) | |||||||||||||
| HTLWRDFAX | VARCHAR(50) | Fax number of the were recipients | Fax number | ||||||||||
| Detailinformationen zur Emailadresse des Ansprechpartners (optional) | |||||||||||||
| HTLWRDMAIL | VARCHAR(200) | Mail adress of the were recipients | Emailadresse | ||||||||||
| Delivery address (optional) | |||||||||||||
| HTLWRDPLZ | VARCHAR(10) | ZIP Code of the were recipients | Postcode of the delivery address | ||||||||||
| HTLWRDAD1 | VARCHAR(50) | Address line 1 of the were recipients | Line 1 of the delivery address | ||||||||||
| HTLWRDAD2 | VARCHAR(50) | Address line 2 of the were recipients | Line 2 of the delivery address | ||||||||||
| HTLWRDAD3 | VARCHAR(50) | Address line 3 of the were recipients | Line 3 of the delivery address | ||||||||||
| HTLWRDCITY | VARCHAR(50) | City of the were recipients | City of delivery address | ||||||||||
| HTLWRDLC | CHAR(4) | Country ISO of the were recipients | Country code of delivery address | ||||||||||
| HTLWRCSDN | VARCHAR(25) | Country federal state | Federal state | ||||||||||
| Details of the electronic address (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 | Tax number | ||||||||||
| 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) | Address line 1 of the final recipient | Address line 1 | ||||||||||
| HTLFRDAD2 | VARCHAR(50) | Address line 2 of the final recipient | Address line 2 | ||||||||||
| HTLFRDAD3 | VARCHAR(50) | Address 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 | ||||||||||
| Details of the electronic address (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 | e-mail 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 | ||||||||||
| Details of the electronic address (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 | DATE '0001-01-01' | Date of Despatch advice | Shipping notification date | ||||||||||
| Detailed information on the corresponding final backflush (optional) | |||||||||||||
| HTLWDANR | VARCHAR(25) | Goods receipt notification number | Reference to the final backflush | ||||||||||
| HTLWDALD | 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 | optional | VARCHAR(200) | Intended purpose | Intended use | ||||||||
| HTZGPTC | 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 | ||||||||||
| Biller Trading party (optional) | |||||||||||||
| HTZITDREID | VARCHAR(35) | Identifier of the Invoicing party Trade partner | Identification | ||||||||||
| 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 | ||||||||||
| DefinedTradeContact (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 (VAT) | ||||||||||
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 | Emailadresse | ||||||||||
| 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 | VARCHAR(15) | Beginning of the accounting period | Beginning of the financial period | ||||||||||
| HTZBILLBPF | CHAR(3) | Date Format | Date, Format | 102 | |||||||||
| HTZBILLEP | VARCHAR(15) | End of the accounting | End of the financial period | ||||||||||
| HTZBILLEPF | 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 ZF2INVTP. | |||||||||||||
| 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 | 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 | DECIMAL(15, 2) | Deposit amount | Advance payment amount | 0.00 | |||||||||
| HTZTSMSDPA | 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 (EXTENDED only) (optional) | |||||||||||||
| Note table ZF2INVAP. | |||||||||||||
| i-effect Felder | |||||||||||||
| 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 | |||||||||
| HTPROCNUM | x | DECIMAL(15, 0) | i-effect File Process Number | i-effect File Process 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 | |||||||||