|
Column name |
Status |
Column definition |
Technical term |
Column description |
XML Element |
EN16931-ID |
Example |
|---|---|---|---|---|---|---|---|
|
HTKEY |
required |
VARCHAR(15) |
Internal Pagination Number |
Internal invoice number (i-effect column) |
|
|
|
|
HTPDF |
optional |
VARCHAR(200) |
PDF Name |
Name of the file generated at the end (i-effect column) |
|
|
|
|
HTTEMPLDIR |
optional |
VARCHAR(100) |
Template Directory Name |
Name of the invoice template folder (i-effect column) |
|
|
|
|
HTDIRECT |
required |
CHAR(4) |
Direction of the ZUGFeRD |
|
|
|
*IN, *OUT |
|
HTNTESTCH |
language code |
VARCHAR(5) |
Test indicator |
Test mark, value |
Indicator |
|
true / false |
|
HTNPROCESS |
optional |
VARCHAR(255) |
Process type |
business process type |
ID |
BT-23 |
Production material, other material, freight invoice |
|
HTNAPPREF |
required |
VARCHAR(255) |
Application reference |
specification identifier |
ID |
BT-24 |
extended_<Version>
|
|
HTNDOCNR |
required |
VARCHAR(35) |
Document number |
invoice number |
ID |
BT-1 |
2012-12345 |
|
HTNDOCTC |
required |
VARCHAR(255) |
Document Type(Free text) |
Document type (free text) |
|
|
INVOICE |
|
HTNDOCT |
required |
CHAR(3) |
Document type (Code), |
Code for the invoice type |
TypeCode |
BT-3 |
380 = Commercial invoice
|
|
HTNDOCD |
required |
DATE '0001-01-01' |
Document date |
invoice date |
|
|
10.12.2018 |
|
HTNMSGFUNC |
Only required if it is not a multiple item with identical content. |
CHAR(5) |
Indicator Original/Copy |
Original/copy indicator |
|
|
true / false |
|
LALLNG |
optional |
CHAR(3) |
Language Key |
language code |
|
|
|
|
HTNDOCD |
required |
DATE '0001-01-01' |
Document date |
invoice date |
DateTimeString |
BT-2 |
10.12.2018 |
|
HTNPAYD |
required |
DATE '0001-01-01' |
Payment date |
Contractual due date of the invoice, value |
DateTimeString |
|
24.12.2018 |
|
HTGBYREF |
optional |
VARCHAR(46) |
Buyer reference |
Buyer's reference |
BuyerReference |
BT-10 |
INV 082 |
|
HTGSEID |
optional |
VARCHAR(35) |
Identifier of the Seller |
Identification of the seller (supplier number) |
ID |
BT-29 |
|
|
HTGSEGLN |
recommended |
VARCHAR(35) |
Global identifier of the Seller |
Global identifier of the seller |
GlobalID |
BT-29-0 |
4E+12 |
|
HTGSEGLNT |
Required if HTGSEGLN is filled |
CHAR(5) |
Type of global Identifier |
Identification of the scheme |
schemeID |
BT-29-1 |
0021 : SWIFT
|
|
HTGSENAME |
required |
VARCHAR(255) |
Company/Name of the Seller |
Seller's name |
Name |
BT-27 |
Supplier Ltd. |
|
HTGSDESC |
optional |
VARCHAR(255) |
Other remaining information of the Seller |
Other legal information about the seller |
Description |
BT-33 |
|
|
HTGSOID |
optional |
VARCHAR(35) |
Identifier of the Organization |
Identification of the seller's legal registration |
ID |
BT-30 |
|
|
HTGSOIDT |
optional |
VARCHAR(10) |
Type of Organization Identifier |
Identification of the scheme |
schemeID |
BT-30-1 |
|
|
HTGSOTRBN |
optional |
VARCHAR(50) |
Trading Business name |
Trade name of the seller |
TradingBusinessName |
BT-28 |
|
|
HTGSOEZIP |
optional |
VARCHAR(10) |
ZIP Code of the Seller Organization |
postcode |
PostcodeCode |
|
|
|
HTGSOEAD1 |
optional |
VARCHAR(50) |
Address line 1 of the Seller Organization |
Address line 1 |
LineOne |
|
|
|
HTGSOEAD2 |
optional |
VARCHAR50) |
Address line 2 of the Seller Organization |
Address line 2 |
LineTwo |
|
|
|
HTGSOEAD3 |
optional |
VARCHAR(50) |
Address line 3 of the Seller Organization |
Address line 3 |
LineThree |
|
|
|
HTGSOELC |
optional |
VARCHAR(50) |
City of the Seller Organization |
City |
CityName |
|
|
|
HTGSOECR |
required |
VARCHAR(3) |
Country ISO of the Seller Organization |
Country (Code) |
CountryID |
|
|
|
HTGSECT |
dependent |
VARCHAR(50) |
Contact Name of the Seller |
Seller's contact point |
PersonName |
BT-41 |
Karin Mustermann |
|
HTGSECTD |
dependent |
VARCHAR(50) |
Department name of the Seller |
Seller's contact point |
DepartmentName |
BT-41-0 |
invoicing |
|
HTGSETE |
required |
VARCHAR(50) |
Phone number of the Seller |
Seller's telephone number |
CompleteNumber |
BT-42 |
+49 (123) 456789-0 |
|
HTGSEFX |
required |
VARCHAR(50) |
Fax number of the Seller |
Seller's fax number |
|
|
+49 (123) 456789-999 |
|
HTGSEEM |
required |
VARCHAR(200) |
Mail adress of the Seller |
Seller's email address |
URIID |
BT-43 |
|
|
HTGSEZIP |
optional |
VARCHAR(10) |
ZIP Code of the Seller |
Postcode of the seller's address |
PostcodeCode |
BT-38 |
80333 |
|
HTGSEAD1 |
optional |
VARCHAR(50) |
Adress line 1 of the Seller |
Line 1 of the seller's address |
LineOne |
BT-35 |
supplier street 20 |
|
HTGSEAD2 |
optional |
VARCHAR(50) |
Adress line 2 of the Seller |
Line 2 of the seller's address |
LineTwo |
BT-36 |
building 3 |
|
HTGSEAD3 |
optional |
VARCHAR(50) |
Adress line 3 of the Seller |
Line 3 of the seller's address |
LineThree |
BT-162 |
building 3 |
|
HTGSELC |
optional |
VARCHAR(50) |
City of the Seller |
City of the seller's address |
CityName |
BT-37 |
Munich |
|
HTGSECR |
required |
CHAR(3) |
Country ISO of the Seller |
Country code of the seller's address |
CountryID |
BT-40 |
DE |
|
HTGSCSDN |
optional |
VARCHAR(25) |
Country federal state |
state |
CountrySubDivisionName |
BT-39 |
|
|
HTGSURID |
required |
VARCHAR(55) |
Electronic address |
Seller's electronic address |
URIID |
BT-34 |
|
|
HTGSURIDT |
required |
VARCHAR(10) |
Electronic address type |
Identification of the scheme |
schemeID |
BT-34-1 |
|
|
HTGSETAX |
required |
VARCHAR(35) |
Taxnumber of the Seller |
Tax number of the seller |
ID |
BT-31, BT-32 |
01/113/40209 |
|
HTGSETAXT |
required |
VARCHAR(35) |
USTid of the Seller |
Umsatzsteueridentnummer des |
ID |
BT-31, BT-32 |
DE234567891 |
|
HTGBID |
optional |
VARCHAR(35) |
Identifier of the Buyer |
Identification of the buyer |
ID |
BT-46 |
B123456 |
|
HTGBGLN |
optional |
VARCHAR(35) |
Global identifier of the Buyer |
Global identifier of the buyer |
GlobalID |
BT-46-0 |
4E+12 |
|
HTGBGLNT |
Required if HTGBYGLN is filled. |
CHAR(5) |
Type of global Identifier |
Identification of the scheme |
schemeID |
BT-46-1 |
|
|
HTGBNAME |
required |
VARCHAR(255) |
Company/Name of the Buyer |
Name of the buyer |
Name |
BT-44 |
Kunden AG Mitte |
|
HTGBOID |
optional |
VARCHAR(35) |
Identifier of the Organization |
Identification of the buyer's legal registration |
ID |
BT-47 |
|
|
HTGBOIDT |
optional |
VARCHAR(10) |
Type of Organization Identifier |
Identification of the scheme |
schemeID |
BT-47-1 |
|
|
HTGBOTRBN |
optional |
VARCHAR(50) |
Trading Business name |
Trade name of the buyer |
TradingBusinessName |
BT-45 |
|
|
HTGBOEZIP |
optional |
VARCHAR(10) |
ZIP Code of the Buyer Organization |
postcode |
PostcodeCode |
|
|
|
HTGBOEAD1 |
optional |
VARCHAR(50) |
Address line 1 of the Buyer Organization |
address line 1 |
LineOne |
|
|
|
HTGBOEAD2 |
optional |
VARCHAR(50) |
Address line 2 of the Buyer Organization |
address line 2 |
LineTwo |
|
|
|
HTGBOEAD3 |
optional |
VARCHAR(50) |
Address line 3 of the Buyer Organization |
address line 3 |
LineThree |
|
|
|
HTGBOELC |
optional |
VARCHAR(50) |
City of the Buyer Organization |
City |
CityName |
|
|
|
HTGBOECR |
optional |
CHAR(3) |
Country ISO of the Buyer Organization |
Country (Code) |
CountryID |
|
|
|
HTGBCT |
optional |
VARCHAR(50) |
Contact Name of the Buyer |
Buyer's contact point |
PersonName |
BT-56 |
Hans Muster |
|
HTGBCTD |
optional |
VARCHAR(50) |
Department name of the Buyer |
Buyer's contact point |
DepartmentName |
BT-56-0 |
invoicing |
|
HTGBTE |
required |
VARCHAR(50) |
Phone number of the Buyer |
Telephone number of the buyer's contact point |
CompleteNumber |
BT-57 |
+49 (123) 56789-0 |
|
HTGBFX |
required |
VARCHAR(50) |
Fax number of tDetailangaben zu den Lieferbedingungenhe Buyer |
Buyer's fax number |
CompleteNumber |
|
+49 (123) 56789-999 |
|
HTGBEM |
required |
VARCHAR(200) |
Mail adress of the Buyer |
Email address of the buyer's contact point |
URIID |
BT-58 |
|
|
HTGBZIP |
optional |
VARCHAR(10) |
ZIP Code of the Buyer |
Buyer's postcode |
PostcodeCode |
BT-53 |
69876 |
|
HTGBAD1 |
optional |
VARCHAR(50) |
Adress line 1 of the Buyer |
Line 1 of the buyer's address |
LineOne |
BT-50 |
Kundenstraße 15 |
|
HTGBAD2 |
optional |
VARCHAR(50) |
Adress line 2 of the Buyer |
Line 2 of the buyer's address |
LineTwo |
BT-51 |
|
|
HTGBAD3 |
optional |
VARCHAR(50) |
Adress line 3 of the Buyer |
Line 3 of the buyer's address |
LineThree |
BT-163 |
|
|
HTGBLC |
optional |
VARCHAR(50) |
City of the Buyer |
City of buyer's address |
CityName |
BT-52 |
Frankfurt |
|
HTGBCR |
required |
CHAR(3) |
Country ISO of the Buyer |
Country code of the buyer's address |
CountryID |
BT-55 |
DE |
|
HTGBCSDN |
optional |
VARCHAR(25) |
Country federal state |
state |
CountrySubDivisionName |
BT-54 |
|
|
HTGBURID |
required |
VARCHAR(55) |
Electronic address |
Buyer's electronic address |
URIID |
BT-49 |
|
|
HTGBURIDT |
required |
VARCHAR(10) |
Electronic address type |
Identification of the scheme |
schemeID |
BT-49-1 |
|
|
HTGBTAX |
required |
VARCHAR(35) |
Taxnumber of the Buyer |
Tax number of the purchaser |
ID |
BT-48 |
201/123/12341 |
|
HTGBTAXT |
required |
VARCHAR(35) |
USTid of the Buyer |
Purchaser's VAT identification number |
ID |
BT-48 |
DE234567781 |
|
HTGTID |
optional |
VARCHAR(35) |
Identifier of the Seller Tax Representative |
Tax agent identifier |
ID |
|
B123456 |
|
HTGTGLN |
optional |
VARCHAR(35) |
Global identifier of the Seller Tax Representative |
Global identifier of the tax representative |
GlobalID |
|
4E+12 |
|
HTGTGLNT |
Required if HTGBYGLN is filled. |
CHAR(5) |
Type of global Identifier |
Identification of the scheme |
schemeID |
|
0021 : SWIFT
|
|
HTGTNAME |
required |
VARCHAR(255) |
Company/Name of the Seller Tax Representative |
Name of the seller's tax representative |
Name |
BT-62 |
Kunden AG Mitte |
|
HTGTOID |
optional |
VARCHAR(35) |
Identifier of the Organization |
Company registration number |
ID |
|
|
|
HTGTOIDT |
optional |
VARCHAR(10) |
Type of Organization Identifier |
Type of number |
schemeID |
|
|
|
HTGTOTRBN |
optional |
VARCHAR(50) |
Trading Business name |
trade name |
TradingBusinessName |
|
|
|
HTGTCT |
optional |
VARCHAR(50) |
Contact Name of the Seller Tax Representative |
contact person name |
PersonName |
|
Hans Muster |
|
HTGTCTD |
optional |
VARCHAR(50) |
Department name of the Seller Tax Representative |
department name |
DepartmentName |
|
Rechnungsstellung |
|
HTGTTE |
required |
VARCHAR(50) |
Phone number of the Seller Tax Representative |
Telephone number |
CompleteNumber |
|
+49 (123) 56789-0 |
|
HTGTFX |
required |
VARCHAR(50) |
Fax number of the Seller Tax Representative |
fax number |
CompleteNumber |
|
+49 (123) 56789-999 |
|
HTGTEM |
required |
VARCHAR(200) |
Mail address of the Seller Tax Representative |
Email address |
URIID |
|
|
|
HTGTZIP |
optional |
VARCHAR(10) |
ZIP Code of the Seller Tax |
Postcode of the tax representative's address |
PostcodeCode |
BT-67 |
|
|
HTGTAD1 |
optional |
VARCHAR(50) |
Address line 1 of the Seller Tax Representative |
Line 1 of the tax agent's address |
LineOne |
BT-64 |
|
|
HTGTAD2 |
optional |
VARCHAR(50) |
Address line 2 of the Seller Tax Representative |
Line 2 of the tax agent's address |
LineTwo |
BT-65 |
|
|
HTGTAD3 |
optional |
VARCHAR(50) |
Address line 3 of the Seller Tax Representative |
Line 3 of the tax agent's address |
LineThree |
BT-164 |
|
|
HTGTLC |
optional |
VARCHAR(50) |
City of the Seller Tax Representative |
City of the tax agent's address |
CityName |
BT-66 |
|
|
HTGTCR |
required |
CHAR(3) |
Country ISO of the Seller Tax Representative |
Country code of the tax representative's address |
CountryID |
CountryID |
|
|
HTGTCSDN |
optional |
VARCHAR(25) |
Country federal state |
state |
CountrySubDivisionName |
BT-68 |
|
|
HTGTURID |
required |
VARCHAR(55) |
Electronic address |
Electronic address |
URIID |
|
|
|
HTGTURIDT |
required |
VARCHAR(10) |
Electronic address type |
Type of electronic address |
schemeID |
|
|
|
HTGTTAX |
required |
VARCHAR(35) |
Taxnumber of the Seller Tax Representative |
VAT identification number of the seller's tax representative |
ID |
BT-63 |
|
|
HTGTTAXT |
required |
VARCHAR(35) |
USTid of the Seller Tax Representative |
Identification of the scheme |
schemeID |
BT-63-0 |
|
|
HTGUDID |
optional |
VARCHAR(35) |
Identifier of the deviating end user |
Identification of the non-standard end consumer |
ID |
|
|
|
HTGUDGLN |
optional |
VARCHAR(35) |
Global identifier of the deviating end user |
Global identifier of the different end consumer |
GlobalID |
|
|
|
HTGUDGLNT |
Required if HTGUDGLN is filled. |
CHAR(5) |
Type of global identifier |
Type of global identification number |
schemeID |
|
0021 : SWIFT
|
|
HTGUDNAME |
required |
VARCHAR(255) |
Company/Name of the deviating end user |
Name/company name of the end user |
Name |
|
|
|
HTGUDOID |
optional |
VARCHAR(35) |
Identifier of the Organization |
Company registration number |
ID |
|
|
|
HTGUDOIDT |
Required if HTGUDOID is filled. |
VARCHAR(10) |
Type of Organization Identifier |
Type of number |
schemeID |
|
|
|
HTGUDOTRBN |
optional |
VARCHAR(50) |
Trading Business name |
trade name |
TradingBusinessName |
|
|
|
HTGUDCT |
optional |
VARCHAR(50) |
Contact Name of the deviating end user |
Name of contact person |
PersonName |
|
|
|
HTGUDCTD |
optional |
VARCHAR(50) |
Department name of the deviating end user |
Department of the contact person |
DepartmentName |
|
|
|
HTGUDTE |
required |
VARCHAR(50) |
Phone number of the deviating end user |
Contact person's telephone number |
CompleteNumber |
|
|
|
HTGUDFX |
required |
VARCHAR(50) |
Fax number of the deviating end user |
Detailed information about the contact person's fax number |
CompleteNumber |
|
|
|
HTGUDEM |
required |
VARCHAR(200) |
Mail adress of the deviating end user |
Email address |
URIID |
|
|
|
HTGUDZIP |
optional |
VARCHAR(10) |
ZIP Code of the deviating end user |
postcode |
PostcodeCode |
|
|
|
HTGUDAD1 |
optional |
VARCHAR(50) |
Adress line 1 of the deviating end user |
address line 1 |
LineOne |
|
|
|
HTGUDAD2 |
optional |
VARCHAR(50) |
Adress line 2 of the deviating end user |
address line 2 |
LineTwo |
|
|
|
HTGUDAD3 |
optional |
VARCHAR(50) |
Adress line 3 of the deviating end user |
address line 3 |
LineThree |
|
|
|
HTGUDLC |
optional |
VARCHAR(50) |
City of the deviating end user |
City |
CityName |
|
|
|
HTGUDCR |
required |
CHAR(4) |
Country ISO of the deviating end user |
Country (Code) |
CountryID |
|
|
|
HTGUDCSDN |
optional |
VARCHAR(25) |
Country federal state |
state |
CountrySubDivisionName |
|
|
|
HTGUDURID |
required |
VARCHAR(55) |
Electronic address |
Electronic address |
URIID |
|
|
|
HTGUDURIDT |
required |
VARCHAR(10) |
Electronic address type |
Type of electronic address |
schemeID |
|
|
|
HTGUDTAX |
required |
VARCHAR(35) |
Taxnumber of the deviating end user |
Tax number of the purchaser, VAT identification number of the purchaser |
ID |
|
|
|
HTGUDTAXT |
required |
VARCHAR(35) |
USTid of the deviating end user |
Type of buyer's tax number |
schemeID |
|
|
|
HTGDPTERM |
optional |
VARCHAR(3) |
Delivery Conditions (CODE) |
Delivery terms (code) |
DeliveryTypeCode |
|
|
|
HTGORDERNR |
required |
VARCHAR(35) |
Order number |
sales order reference |
IssuerAssignedID |
BT-14 |
|
|
HTGORDERD |
optional |
DATE '0001-01-01' |
Date of order |
Details regarding the order confirmation date |
FormattedIssueDateTime |
|
|
|
HTGCORDNR |
required |
VARCHAR(35) |
Order number |
order reference |
IssuerAssignedID |
BT-13 |
|
|
HTGCORDD |
optional |
DATE '0001-01-01' |
Date of order |
Date of order |
FormattedIssueDateTime |
|
|
|
HTGCONTRNR |
required |
VARCHAR(35) |
Agreement number |
contract reference |
IssuerAssignedID |
BT-12 |
|
|
HTGCONTRD |
optional |
DATE '0001-01-01' |
Date of agreement |
contract date |
FormattedIssueDateTime |
|
|
|
HTSPPID |
required |
INTEGER |
Project reference ID |
project reference |
ID |
BT-11 |
|
|
HTSPPNA |
required |
VARCHAR(35) |
Project name |
project name |
Name |
BT-11-0 |
|
|
HTLWRDID |
optional |
VARCHAR(35) |
Identifier of the were recipients |
Identification of the delivery location |
ID |
BT-71 |
TO123456 |
|
HTLWRDGLN |
optional |
VARCHAR(35) |
Global identifier of the were recipients |
Global identifier of the delivery location code |
GlobalID |
BT-71-0 |
4E+12 |
|
HTLWRDGLNT |
Required if HTLWRDGLNT is filled. |
CHAR(5) |
Type of global identifier |
Identification of the scheme |
schemeID |
BT-71-1 |
0021 : SWIFT
|
|
HTLWRDREC |
required |
VARCHAR(255) |
Company/Name of the were recipients |
Name of the recipient of the goods or services |
Name |
BT-70 |
|
|
HTLWROID |
optional |
VARCHAR(35) |
Identifier of the Organization |
Company registration number |
ID |
|
|
|
HTLWROIDT |
optional |
VARCHAR(10) |
Type of Organization Identifier |
Type of number |
schemeID |
|
0021 : SWIFT
|
|
HTLWROTRBN |
optional |
VARCHAR(50) |
Trading Business name |
trade name |
TradingBusinessName |
|
|
|
HTLWRDCN |
optional |
VARCHAR(50) |
Contact Name of the were recipients |
Name of contact person |
PersonName |
|
|
|
HTLWRDDN |
optional |
VARCHAR(50) |
Department name of the were recipients |
Department of the contact person |
DepartmentName |
|
|
|
HTLWRDTEL |
required |
VARCHAR(50) |
Phone number of the were recipients |
Contact person's telephone number |
CompleteNumber |
|
|
|
HTLWRDFAX |
required |
VARCHAR(50) |
Fax number of the were recipients |
fax number |
CompleteNumber |
|
|
|
HTLWRDMAIL |
required |
VARCHAR(200) |
Mail adress of the were recipients |
Email address |
URIID |
|
|
|
HTLWRDPLZ |
optional |
VARCHAR(10) |
ZIP Code of the were recipients |
Postleitzahl der Lieferanschrift |
PostcodeCode |
BT-78 |
|
|
HTLWRDAD1 |
optional |
VARCHAR(50) |
Adress line 1 of the were recipients |
Line 1 of the delivery address |
LineOne |
BT-75 |
|
|
HTLWRDAD2 |
optional |
VARCHAR(50) |
Adress line 2 of the were recipients |
Line 2 of the delivery address |
LineTwo |
BT-76 |
|
|
HTLWRDAD3 |
optional |
VARCHAR(50) |
Adress line 3 of the were recipients |
Line 3 of the delivery address |
LineThree |
BT-165 |
|
|
HTLWRDCITY |
optional |
VARCHAR(50) |
City of the were recipients |
City of delivery address |
CityName |
BT-77 |
|
|
HTLWRDLC |
required |
CHAR(4) |
Country ISO of the were recipients |
Country code of the delivery address |
CountryID |
BT-80 |
|
|
HTLWRCSDN |
optional |
VARCHAR(25) |
Country federal state |
Bundesland |
CountrySubDivisionName |
BT-79 |
|
|
HTLWRURID |
optional |
VARCHAR(55) |
Eletronic address |
Electronic address |
URIID |
|
|
|
HTLWRURIDT |
optional |
VARCHAR(10) |
Eletronic address type |
Type of electronic address |
schemeID |
|
|
|
HTLWRDSNR |
optional |
VARCHAR(35) |
Taxnumber of the were recipients |
Tax number / VAT identification number |
ID |
|
|
|
HTLWRDASNR |
optional |
VARCHAR(35) |
USTid of the were recipients |
Type of tax number |
schemeID |
|
|
|
HTLFRDID |
optional |
VARCHAR(35) |
Identifier of the final recipient |
Identification of the final recipient |
ID |
|
|
|
HTLFRDGLN |
optional |
VARCHAR(35) |
Global identifier of the final recipient |
Global identifier of the final recipient |
GlobalID |
|
|
|
HTLFRDGLNT |
required wenn HTLFRDGLN gefüllt ist. |
CHAR(5) |
Type of global Identifier |
Identification of the scheme |
schemeID |
|
|
|
HTLFRDREC |
optional |
VARCHAR(255) |
Company/Name of the final recipient |
Name/company name of the final recipient |
Name |
|
|
|
HTLFROID |
optional |
VARCHAR(35) |
Identifier of the Organization |
Company registration number |
ID |
|
|
|
HTLFROIDT |
optional |
VARCHAR(10) |
Type of Organization Identifier |
Identification of the scheme |
schemeID |
|
|
|
HTLFROTRBN |
optional |
VARCHAR(50) |
Trading Business name |
trade name |
TradingBusinessName |
|
|
|
HTLFRDCN |
dependent |
VARCHAR(50) |
Contact Name of the final recipient |
Name of contact person |
PersonName |
|
|
|
HTLFRDDN |
dependent |
VARCHAR(50) |
Department name of the final recipient |
Department of the contact person |
DepartmentName |
|
|
|
HTLFRDTEL |
required |
VARCHAR(50) |
Phone number of the final recipient |
Contact person's telephone number |
CompleteNumber |
|
|
|
HTLFRDFAX |
required |
VARCHAR(50) |
Fax number of the final recipient |
fax number |
CompleteNumber |
|
|
|
HTLFRDMAIL |
required |
VARCHAR(200) |
Mail adress of the final recipient |
Email address |
URIID |
|
|
|
HTLFRDPLZ |
optional |
VARCHAR(10) |
ZIP Code of the final recipient |
postcode |
PostcodeCode |
|
|
|
HTLFRDAD1 |
optional |
VARCHAR(50) |
Adress line 1 of the final recipient |
Address line 1 |
LineOne |
|
|
|
HTLFRDAD2 |
optional |
VARCHAR(50) |
Adress line 2 of the final recipient |
Address line 2 |
LineTwo |
|
|
|
HTLFRDAD3 |
optional |
VARCHAR(50) |
Adress line 3 of the final recipient |
Address line 3 |
LineThree |
|
|
|
HTLFRDCITY |
optional |
VARCHAR(50) |
City of the final recipient |
City |
CityName |
|
|
|
HTLFRDLC |
required |
CHAR(4) |
Country ISO of the final recipient |
Country (code) |
CountryID |
|
|
|
HTLFRCSDN |
optional |
VARCHAR(25) |
Country federal state |
state |
CountrySubDivisionName |
|
|
|
HTLFRURID |
optional |
VARCHAR(55) |
Eletronic address |
Electronic address |
|
|
|
|
HTLFRURIDT |
optional |
VARCHAR(10) |
Eletronic address type |
Type of electronic address |
|
|
|
|
HTLFRDSNR |
optional |
VARCHAR(35) |
Taxnumber of the final recipient |
Tax number, VAT number |
ID |
|
|
|
HTLFRDASNR |
optional |
VARCHAR(35) |
USTid of the final recipient |
Type of tax number |
schemeID |
|
|
|
HTLCDID |
optional |
VARCHAR(35) |
Identifier of the consignor |
Identification of the sender |
ID |
|
|
|
HTLCDGLN |
optional |
VARCHAR(35) |
Global identifier of the consignor |
Global identifier of the sender |
GlobalID |
|
|
|
HTLCDGLNT |
Required if HTLCDGLN is filled. |
CHAR(5) |
Type of Organization Identifier |
Type of global identification number |
schemeID |
|
|
|
HTLCDREC |
required |
VARCHAR(255) |
Company/Name of the consignor |
Name/company name of the sender |
Name |
|
|
|
HTLCDOID |
optional |
VARCHAR(35) |
Identifier of the Organization |
Company registration number |
ID |
|
|
|
HTLCDOIDT |
optional |
VARCHAR(10) |
Type of Organization Identifier |
Type of number |
schemeID |
|
|
|
HTLCDOTRBN |
optional |
VARCHAR(50) |
Trading Business name |
trade name |
TradingBusinessName |
|
|
|
HTLCDCN |
optional |
VARCHAR(50) |
Contact Name of the consignor |
Name of contact person |
PersonName |
|
|
|
HTLCDDN |
optional |
VARCHAR(50) |
Department name of the consignor |
Department of the contact person |
DepartmentName |
|
|
|
HTLCDTEL |
required |
VARCHAR(50) |
Phone number of the consignor |
Contact person's telephone number |
CompleteNumber |
|
|
|
HTLCDFAX |
required |
VARCHAR(50) |
Fax number of the consignor |
fax number |
CompleteNumber |
|
|
|
HTLCDMAIL |
required |
VARCHAR(200) |
Mail adress of the consignor |
Email address |
|
|
|
|
HTLCDPLZ |
optional |
VARCHAR(10) |
ZIP Code of the consignor |
postcode |
PostcodeCode |
|
|
|
HTLCDAD1 |
optional |
VARCHAR(50) |
Adress line 1 of the consignor |
Address line 1 |
LineOne |
|
|
|
HTLCDAD2 |
optional |
VARCHAR(50) |
Adress line 2 of the consignor |
Address line 2 |
LineTwo |
|
|
|
HTLCDAD3 |
optional |
VARCHAR(50) |
Adress line 3 of the consignor |
Address line 3 |
LineThree |
|
|
|
HTLCDCITY |
optional |
VARCHAR(50) |
City of the consignor |
City |
CityName |
|
|
|
HTLCDLC |
required |
CHAR(4) |
Country ISO of the consignor |
Country ISO of the consignor(Code) |
CountryID |
|
|
|
HTLCDCSDN |
optional |
VARCHAR(25) |
Country federal state |
state |
CountrySubDivisionName |
|
|
|
HTLCDURID |
optional |
VARCHAR(55) |
Eletronic address |
Electronic address |
URIID |
|
|
|
HTLCDURIDT |
optional |
VARCHAR(10) |
Eletronic address type |
Type of electronic address |
schemeID |
|
|
|
HTLCDSNR |
optional |
VARCHAR(35) |
Taxnumber of the consignor |
Tax number, VAT number |
ID |
|
|
|
HTLCDASNR |
optional |
VARCHAR(35) |
USTid of the consignor |
Type of tax number |
schemeID |
|
|
|
HTLDTD |
required |
DATE '0001-01-01' |
Actual Delivery Time |
Actual delivery date |
OccurrenceDateTime |
|
10.12.2018 |
|
HTLDANR |
required |
VARCHAR(25) |
Despatch advice number |
delivery notification reference |
IssuerAssignedID |
BT-16 |
|
|
HTLDALD |
optional |
DATE '0001-01-01' |
Date of Despatch advice |
delivery notification date |
FormattedIssueDateTime |
FormattedIssueDateTime |
|
|
HTLWDANR |
required |
VARCHAR(25) |
Goods receipt notification number |
Reference to the goods receipt notification |
IssuerAssignedID |
BT-15 |
|
|
HTLWDALD |
optional |
DATE '0001-01-01' |
Date of goods receipt notification |
date of receipt of goods |
FormattedIssueDateTime |
|
|
|
HTLDLSNR |
required |
VARCHAR(35) |
Delivery Note number |
delivery note number |
IssuerAssignedID |
|
|
|
HTLDLSD |
optional |
DATE '0001-01-01' |
Date of Delivery Note |
delivery note date |
FormattedIssueDateTime |
|
|
|
HTZGPCID |
optional |
VARCHAR(35) |
Creditor ID |
Creditor identification |
CreditorReferenceID |
BG19, BT-90 |
|
|
HTZGPZR |
recommended |
VARCHAR(200) |
Intended purpose |
intended use |
PaymentReference |
BT-83 |
|
|
HTZGPTC |
optional |
VARCHAR(5) |
Tax Currency Code |
Code for the currency of the sales tax entry |
TaxCurrencyCode |
BT-6 |
|
|
HTZGPIC |
required |
VARCHAR(5) |
Invoice Currency Code |
Code for the invoice currency |
InvoiceCurrencyCode |
BT-5 |
|
|
HTZGPIRN |
optional |
INTEGER |
Issuer reference number |
Seller's reference number |
InvoiceIssuerReference |
|
|
|
HTZITDREID |
optional |
VARCHAR(35) |
Identifier of the Invoicing party Trade partner |
Identify |
ID |
|
|
|
HTZITDGLN |
optional |
VARCHAR(35) |
Global identifier of the Invoicing party Trade partner |
Global identifier |
GlobalID |
|
|
|
HTZITDGLNT |
Required if HTZITDGLN is filled. |
CHAR(5) |
Type of global Identifier |
Type of global identification number |
schemeID |
|
|
|
HTZIRDREC |
required |
VARCHAR(255) |
Company/Name of the Invoice recipient |
Name |
Name |
|
|
|
HTZITOID |
optional |
VARCHAR(35) |
Identifier of the Organization |
Company registration number |
ID |
|
|
|
HTZITOIDT |
optional |
VARCHAR(10) |
Type of Organization Identifier |
Type of number |
schemeID |
|
|
|
HTZITOTRBN |
optional |
VARCHAR(50) |
Trading Business name |
trade name |
TradingBusinessName |
|
|
|
HTZITDCN |
optional |
VARCHAR(50) |
Contact Name of the Invoicing party Trade partner |
contact person name |
PersonName |
|
|
|
HTZITDDN |
optional |
VARCHAR(50) |
Department name of the Invoicing party Trade partner |
department name |
DepartmentName |
|
|
|
HTZITDTEL |
required |
VARCHAR(50) |
Phone number of the Invoicing party Trade partner |
Telephone number |
CompleteNumber |
|
|
|
HTZITDFAX |
required |
VARCHAR(50) |
Fax number of the Invoicing party Trade partner |
fax number |
CompleteNumber |
|
|
|
HTZITDMAIL |
required |
VARCHAR(200) |
Mail address of the Invoicing party Trade partner |
Email address |
URIID |
|
|
|
HTZITDEPLZ |
optional |
VARCHAR(10) |
ZIP Code of the Invoicing party Trade partner |
postcode |
PostcodeCode |
|
|
|
HTZITDAD1 |
optional |
VARCHAR(50) |
Address line 1 of the Invoicing party Trade partner |
Address line 1 |
LineOne |
|
|
|
HTZITDAD2 |
optional |
VARCHAR(50) |
Address line 2 of the Invoicing party Trade partner |
Address line 2 |
LineTwo |
|
|
|
HTZITDAD3 |
optional |
VARCHAR(50) |
Address line 3 of the Invoicing party Trade partner |
Address line 3 |
LineThree |
|
|
|
HTZITDCITY |
optional |
VARCHAR(50) |
City of the Invoicing party Trade partner |
City |
CityName |
|
|
|
HTZITDLLC |
required |
CHAR(4) |
Country ISO of the Invoicing party Trade partner |
Country (Code) |
CountryID |
|
|
|
HTZITCSDN |
optional |
VARCHAR(25) |
Country federal state of the Invoicing party Trade partner |
state |
CountrySubDivisionName |
|
|
|
HTZITURID |
optional |
VARCHAR(55) |
Electronic address of the Invoicing party Trade partner |
Electronic address |
URIID |
|
|
|
HTZITURIDT |
optional |
VARCHAR(10) |
Electronic address type of the Invoicing party Trade partner |
Type of electronic address |
schemeID |
|
|
|
HTZITDSNR |
optional |
VARCHAR(35) |
Taxnumber of the Invoicing party Trade partner |
Tax number/VAT identification number |
ID |
|
|
|
HTZITDASNR |
optional |
VARCHAR(35) |
USTid of the Invoicing party Trade partner |
Type of tax number |
schemeID |
|
|
|
HTZIRDREID |
optional |
VARCHAR(35) |
Identifier of the Invoice recipient |
Identification of the invoice recipient |
ID |
|
|
|
HTZIRDGLN |
optional |
VARCHAR(35) |
Global identifier of the Invoice recipient |
Global identifier of the different invoice recipient |
GlobalID |
|
|
|
HTZIRDGLNT |
Required if HTZIRDGLN is filled. |
CHAR(5) |
Type of global Identifier |
Identification of the scheme |
schemeID |
|
|
|
HTZIRDREC |
required |
VARCHAR(255) |
Company/Name of the Invoice recipient |
Name/company name of the invoice recipient |
Name |
|
|
|
HTZIROID |
optional |
VARCHAR(35) |
Identifier of the Organization |
Company registration number |
ID |
|
|
|
HTZIROIDT |
optional |
VARCHAR(10) |
Type of Organization Identifier |
Type of number |
schemeID |
|
|
|
HTZIROTRBN |
optional |
VARCHAR(50) |
Trading Business name |
trade name |
TradingBusinessName |
|
|
|
HTZIRDCN |
optional |
VARCHAR(50) |
Contact Name of the Invoice recipient |
Name of contact person |
PersonName |
|
|
|
HTZIRDDN |
optional |
VARCHAR(50) |
Department name of the Invoice recipient |
Department of the contact person |
DepartmentName |
|
|
|
HTZIRDTEL |
required |
VARCHAR(50) |
Phone number of the Invoice recipient |
Contact person's telephone number |
CompleteNumber |
|
|
|
HTZIRDFAX |
required |
VARCHAR(50) |
Fax number of the Invoice recipient |
fax number |
CompleteNumber |
|
|
|
HTZIRDMAIL |
required |
VARCHAR(200) |
Mail adress of the Invoice recipient |
Email address |
URIID |
|
|
|
HTZIRDEPLZ |
optional |
VARCHAR(10) |
ZIP Code of the Invoice recipient |
postcode |
PostcodeCode |
|
|
|
HTZIRDAD1 |
optional |
VARCHAR(50) |
Adress line 1 of the Invoice recipient |
Line 1 of the invoice recipient's address |
LineOne |
|
|
|
HTZIRDAD2 |
optional |
VARCHAR(50) |
Adress line 2 of the Invoice recipient |
Line 2 of the invoice recipient's address |
LineTwo |
|
|
|
HTZIRDAD3 |
optional |
VARCHAR(50) |
Adress line 3 of the Invoice recipient |
Line 3 of the invoice recipient's address |
LineThree |
|
|
|
HTZIRDCITY |
optional |
VARCHAR(50) |
City of the Invoice recipient |
City of the invoice recipient's address |
CityName |
|
|
|
HTZIRDLLC |
required |
CHAR(4) |
Country ISO of the Invoice recipient |
Country code of the address of the invoice recipient |
CountryID |
|
|
|
HTZIRCSDN |
optional |
VARCHAR(25) |
Country federal state |
state |
CountrySubDivisionName |
|
|
|
HTZIRURID |
required |
VARCHAR(55) |
Electronic address |
Electronic address |
URIID |
|
|
|
HTZIRURIDT |
required |
VARCHAR(10) |
Electronic address type |
Type of electronic address |
schemeID |
|
|
|
HTZIRDSNR |
optional |
VARCHAR(35) |
Taxnumber of the Invoice recipient |
Tax number/VAT identification number |
ID |
|
|
|
HTZIRDASNR |
optional |
VARCHAR(35) |
USTid of the Invoice recipient |
Type of tax number |
schemeID |
|
|
|
HTZPRDREID |
optional |
VARCHAR(35) |
Identifier of the Payment Receiver |
Payee identification |
ID |
BT-60 |
|
|
HTZPRDGLN |
optional |
VARCHAR(35) |
Global identifier of the Payment Receiver |
Global identifier of the deviating |
GlobalID |
BT-60-0 |
|
|
HTZPRDGLNT |
Required if HTZPRDGLN is filled. |
CHAR(5) |
Type of global Identifier |
Identification of the scheme |
schemeID |
BT-60-1 |
|
|
HTZPRDREC |
required |
VARCHAR(255) |
Company/Name of the Payment Receiver |
Name/company name of the payee |
Name |
BT-59 |
|
|
HTZPROID |
optional |
VARCHAR(35) |
Identifier of the Organization |
Identification of the payee's legal registration |
ID |
BT-61 |
|
|
HTZPROIDT |
optional |
VARCHAR(10) |
Type of Organization Identifier |
Identification of the scheme |
schemeID |
BT-61-1 |
|
|
HTZPROTRBN |
optional |
VARCHAR(50) |
Trading Business name |
trade name |
TradingBusinessName |
|
|
|
HTZPRDCN |
optional |
VARCHAR(50) |
Contact Name of the Payment Receiver |
Name of the payee's contact person |
PersonName |
|
|
|
HTZPRDDN |
optional |
VARCHAR(50) |
Department name of the Payment Receiver |
Department of the payee's contact person |
DepartmentName |
|
|
|
HTZPRDTEL |
required |
VARCHAR(50) |
Phone number of the Payment Receiver |
Telephone number of the payee's contact person |
CompleteNumber |
|
|
|
HTZPRDFAX |
required |
VARCHAR(50) |
Fax number of the Payment Receiver |
Fax number of the payee's contact person |
CompleteNumber |
|
|
|
HTZPRDMAIL |
required |
VARCHAR(200) |
Mail adress of the Payment Receiver |
Email address of the payee's contact person |
URIID |
|
|
|
HTZPRDPLZ |
optional |
VARCHAR(10) |
ZIP Code of the Payment Receiver |
postcode |
PostcodeCode |
|
|
|
HTZPRDAD1 |
optional |
VARCHAR(50) |
Adress line 1 of the Payment Receiver |
Line 1 of the payee's address |
LineOne |
|
|
|
HTZPRDAD2 |
optional |
VARCHAR(50) |
Adress line 2 of the Payment Receiver |
Line 2 of the payee's address |
LineTwo |
|
|
|
HTZPRDAD3 |
optional |
VARCHAR(50) |
Adress line 3 of the Payment Receiver |
Line 3 of the payee's address |
LineThree |
|
|
|
HTZPRDCITY |
optional |
VARCHAR(50) |
City of the Payment Receiver |
City of the payee's address |
CityName |
|
|
|
HTZPRDLLC |
required |
CHAR(4) |
Country ISO of the Payment Receiver |
Country code of the payee's address |
CountryID |
|
|
|
HTZPRCSDN |
optional |
VARCHAR(25) |
Country federal state |
state |
CountrySubDivisionName |
|
|
|
HTZPRURID |
required |
VARCHAR(55) |
Electronic address |
Electronic address |
URIID |
|
|
|
HTZPRURIDT |
required |
VARCHAR(10) |
Electronic address type |
Type of electronic address |
schemeID |
|
|
|
HTZPRDSNR |
optional |
VARCHAR(35) |
Taxnumber of the Payment Receiver |
Tax number/VAT identification number |
ID |
|
|
|
HTZPRDASNR |
optional |
VARCHAR(35) |
USTid of the Payment Receiver |
Type of tax number |
schemeID |
|
|
|
HTZTASC |
required |
CHAR(5) |
Invoicing currency |
invoice currency |
SourceCurrencyCode |
|
|
|
HTZTATC |
required |
CHAR(5) |
Home currency |
home currency |
SourceCurrencyCode |
|
|
|
HTZTACR |
required |
DECIMAL(10, 5) |
Exchange rate |
conversion rate |
SourceCurrencyCode |
|
|
|
HTZTACD |
optional |
DATE '0001-01-01' |
Date for exchange rate |
Date of conversion rate |
ConversionRateDateTime |
|
|
|
HTZBILLPD |
optional |
VARCHAR(50) |
Description of Bill period |
Free text for the billing period |
Description |
|
|
|
HTZBILLBP |
optional |
VARCHAR(15) |
Beginning of the accounting period |
Start of the accounting period |
StartDateTime |
BT-73 |
|
|
HTZBILLBPF |
Required if HTZBILLBP is filled. |
CHAR(3) |
Date Format |
Date, Format |
format |
BT-73-0 |
102 |
|
HTZBILLEP |
optional |
VARCHAR(15) |
End of the accounting |
end of the accounting period |
EndDateTime |
BT-74 |
|
|
HTZBILLEPF |
Required if HTZBILLEP is filled. |
CHAR(3) |
Date Format |
Date, Format |
format |
BT-74-0 |
102 |
|
HTZTSMSLT |
required |
DECIMAL(15, 2) |
Total amount of positions |
invoice items |
LineTotalAmount |
BT-106 |
6913.60 |
|
HTZTSMSCT |
optional |
DECIMAL(15, 2) |
Total amount of surcharges |
Total of surcharges at document level |
ChargeTotalAmount |
BT-108 |
0.00 |
|
HTZTSMSAT |
optional |
DECIMAL(15, 2) |
Total amounts of discounts |
Total of deductions at document level |
AllowanceTotalAmount |
BT-107 |
0.00 |
|
HTZTSMSTB1 |
required |
DECIMAL(15, 2) |
Tax basic amount 1 |
Total invoice amount excluding VAT 1 |
TaxBasisTotalAmount |
BT-109 |
6913.60 |
|
HTZTSMSTB2 |
optional |
DECIMAL(15, 2) |
Tax basic amount 2 |
Total invoice amount excluding VAT 2 |
|
|
|
|
HTZTSMSTT1 |
required |
DECIMAL(15, 2) |
Tax total amount 1 |
Total amount of invoice sales tax Total tax amount in posting currency 1 |
TaxTotalAmount |
BT-110, BT-111 |
1313.58 |
|
HTZTSMSTT2 |
optional |
DECIMAL(15, 2) |
Tax total amount 2 |
Total amount of invoice sales tax Total tax amount in posting currency 2 |
|
|
|
|
HTZTSMSRA |
optional |
DECIMAL(15, 2) |
Rounding amount |
rounded amount |
RoundingAmount |
BT-114 |
|
|
HTZTSMSGT1 |
required |
DECIMAL(15, 2) |
Grand total amount 1 |
Total invoice amount including VAT 1 |
GrandTotalAmount |
BT-112 |
8227.18 |
|
HTZTSMSGT2 |
optional |
DECIMAL(15, 2) |
Grand total amount 2 |
Total invoice amount including VAT 2 |
|
|
|
|
HTZTSMSTPA |
optional |
DECIMAL(15, 2) |
Deposit amount |
advance payment amount |
TotalPrepaidAmount |
BT-113 |
0.00 |
|
HTZTSMSDPA |
required |
DECIMAL(15, 2) |
Payment amount |
payment amount |
DuePayableAmount |
BT-115 |
8227.18 |
|
HTZIRDIAID |
required |
VARCHAR(35) |
Number of previous invoice |
Number of the previous invoice |
IssuerAssignedID |
BT-25 |
|
|
HTZIRDFIDT |
optional |
DATE '0001-01-01' |
Invoice Date of previous invoice |
invoice date |
FormattedIssueDateTime |
|
|
|
HTSTATE |
|
VARCHAR(1) |
State of Order |
Status Column |
|
|
Empty string = Not processed,
|
|
HTSESSUM |
|
DECIMAL(15, 0) |
i-effect Session Number |
i-effect session number |
|
|
|
|
EXTERNAL_RECIPIENT |
|
CHAR(255) |
Externer Empfänger für SNDFILE |
i-effect recipient from the partner master data |
|
|
|
|
EXTERNAL_ORIGINATOR |
|
CHAR(255) |
Externer Absender für SNDFILE |
i-effect sender from the partner master |
|
|
|
|
HTZITDREC |
|
VARCHAR(255) |
|
|
|
|
|