ZF2INVHT - Header information (Zugferd 2.2.0 + XRechnung)
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) |