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 |