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 |
||||||||