ZF2INVHT - Kopf Informationen (Zugferd 2.2.0 + XRechnung)
^Spaltenname | Status | Spaltendefinition | Fachbegriff | Spaltenbeschreibung | XML Element | EN16931-ID | Beispiel |
|---|---|---|---|---|---|---|---|
HTKEY | required | VARCHAR(15) | Internal Pagination Number | Interne Rechnungsnummer (i-effect Spalte) | |||
HTPDF | optional | VARCHAR(200) | PDF Name | Name der am ende generierten Datei (i-effect Spalte) | |||
HTTEMPLDIR | optional | VARCHAR(100) | Template Directory Name | Name des Template Ordners der Rechnung (i-effect Spalte) | |||
HTDIRECT | required | CHAR(4) | Direction of the ZUGFeRD | *IN, *OUT | |||
HTNTESTCH | Sprachkennzeichen | VARCHAR(5) | Test indicator | Testkennzeichen, Wert | Indicator | true / false | |
HTNPROCESS | optional | VARCHAR(255) | Process type | Geschäftsprozesstyp | ID | BT-23 | Produktionsmaterial, sonstiges Material, Frachtrechnung |
HTNAPPREF | required | VARCHAR(255) | Application reference | Spezifikationskennung | ID | BT-24 | extended_<Version> |
HTNDOCNR | required | VARCHAR(35) | Document number | Rechnungsnummer | ID | BT-1 | 2012-12345 |
HTNDOCTC | required | VARCHAR(255) | Document Type(Free text) | Dokumentenart (Freitext) | RECHNUNG | ||
HTNDOCT | required | CHAR(3) | Document type (Code), | Code für den Rechnungstyp | TypeCode | BT-3 | 380 = Commercial invoice |
HTNDOCD | required | DATE '0001-01-01' | Document date | Rechnungsdatum | 10.12.2018 | ||
HTNMSGFUNC | Angabe nur erforderlich, falls es sich nicht um ein inhaltsgleiches Mehrstück handelt. | CHAR(5) | Indicator Original/Copy | Indikator Original/Kopie | true / false | ||
LALLNG | optional | CHAR(3) | Language Key | Sprachkennzeichen | |||
HTNDOCD | required | DATE '0001-01-01' | Document date | Rechnungsdatum | DateTimeString | BT-2 | 10.12.2018 |
HTNPAYD | required | DATE '0001-01-01' | Payment date | Vertragliches Fälligkeitsdatum der Rechnung, Wert | DateTimeString | 24.12.2018 | |
HTGBYREF | optional | VARCHAR(46) | Buyer reference | Referenz des Käufers | BuyerReference | BT-10 | INV 082 |
HTGSEID | optional | VARCHAR(35) | Identifier of the Seller | Kennung des Verkäufers (Lieferantennummer) | ID | BT-29 | |
HTGSEGLN | empfohlen | VARCHAR(35) | Global identifier of the Seller | Globaler Identifier des Verkäufers | GlobalID | BT-29-0 | 4E+12 |
HTGSEGLNT | required, wenn HTGSEGLN befüllt ist | CHAR(5) | Type of global Identifier | Kennung des Schemas | schemeID | BT-29-1 | 0021 : SWIFT |
HTGSENAME | required | VARCHAR(255) | Company/Name of the Seller | Name des Verkäufers | Name | BT-27 | Lieferant GmbH |
HTGSDESC | optional | VARCHAR(255) | Other remaining information of the Seller | Sonstige rechtliche Informationen des Verkäufers | Description | BT-33 | |
HTGSOID | optional | VARCHAR(35) | Identifier of the Organization | Kennung der rechtlichen Registrierung des Verkäufers | ID | BT-30 | |
HTGSOIDT | optional | VARCHAR(10) | Type of Organization Identifier | Kennung des Schemas | schemeID | BT-30-1 | |
HTGSOTRBN | optional | VARCHAR(50) | Trading Business name | Handelsname des Verkäufers | TradingBusinessName | BT-28 | |
HTGSOEZIP | optional | VARCHAR(10) | ZIP Code of the Seller Organization | Postleitzahl | PostcodeCode | ||
HTGSOEAD1 | optional | VARCHAR(50) | Address line 1 of the Seller Organization | Adresszeile 1 | LineOne | ||
HTGSOEAD2 | optional | VARCHAR50) | Address line 2 of the Seller Organization | Adresszeile 2 | LineTwo | ||
HTGSOEAD3 | optional | VARCHAR(50) | Address line 3 of the Seller Organization | Adresszeile 3 | LineThree | ||
HTGSOELC | optional | VARCHAR(50) | City of the Seller Organization | Ort | CityName | ||
HTGSOECR | required | VARCHAR(3) | Country ISO of the Seller Organization | Land (Code) | CountryID | ||
HTGSECT | abhängig | VARCHAR(50) | Contact Name of the Seller | Kontaktstelle des Verkäufers | PersonName | BT-41 | Karin Mustermann |
HTGSECTD | abhängig | VARCHAR(50) | Department name of the Seller | Kontaktstelle des Verkäufers | DepartmentName | BT-41-0 | Rechnungsstellung |
HTGSETE | required | VARCHAR(50) | Phone number of the Seller | Telefonnummer des Verkäufers | CompleteNumber | BT-42 | +49 (123) 456789-0 |
HTGSEFX | required | VARCHAR(50) | Fax number of the Seller | Faxnummer des Verkäufers | +49 (123) 456789-999 | ||
HTGSEEM | required | VARCHAR(200) | Mail adress of the Seller | Emailadresse des Verkäufers | URIID | BT-43 | |
HTGSEZIP | optional | VARCHAR(10) | ZIP Code of the Seller | Postleitzahl der Verkäuferanschrift | PostcodeCode | BT-38 | 80333 |
HTGSEAD1 | optional | VARCHAR(50) | Adress line 1 of the Seller | Zeile 1 der Verkäuferanschrift | LineOne | BT-35 | Lieferantenstraße 20 |
HTGSEAD2 | optional | VARCHAR(50) | Adress line 2 of the Seller | Zeile 2 der Verkäuferanschrift | LineTwo | BT-36 | Gebäude 3 |
HTGSEAD3 | optional | VARCHAR(50) | Adress line 3 of the Seller | Zeile 3 der Verkäuferanschrift | LineThree | BT-162 | Gebäude 3 |
HTGSELC | optional | VARCHAR(50) | City of the Seller | Stadt der Verkäuferanschrift | CityName | BT-37 | München |
HTGSECR | required | CHAR(3) | Country ISO of the Seller | Ländercode der Verkäuferanschrift | CountryID | BT-40 | DE |
HTGSCSDN | optional | VARCHAR(25) | Country federal state | Bundesland | CountrySubDivisionName | BT-39 | |
HTGSURID | required | VARCHAR(55) | Electronic address | Elektronischen Adresse des Verkäufers | URIID | BT-34 | |
HTGSURIDT | required | VARCHAR(10) | Electronic address type | Kennung des Schemas | schemeID | BT-34-1 | |
HTGSETAX | required | VARCHAR(35) | Taxnumber of the Seller | Steuernummer des Verkäufers | 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 | Kennung des Käufers | ID | BT-46 | B123456 |
HTGBGLN | optional | VARCHAR(35) | Global identifier of the Buyer | Globaler Identifier des Käufers | GlobalID | BT-46-0 | 4E+12 |
HTGBGLNT | required wenn HTGBYGLN gefüllt ist. | CHAR(5) | Type of global Identifier | Kennung des Schemas | schemeID | BT-46-1 | |
HTGBNAME | required | VARCHAR(255) | Company/Name of the Buyer | Name des Käufers | Name | BT-44 | Kunden AG Mitte |
HTGBOID | optional | VARCHAR(35) | Identifier of the Organization | Kennung der rechtlichen Registrierung des Käufers | ID | BT-47 | |
HTGBOIDT | optional | VARCHAR(10) | Type of Organization Identifier | Kennung des Schemas | schemeID | BT-47-1 | |
HTGBOTRBN | optional | VARCHAR(50) | Trading Business name | Handelsname des Käufers | TradingBusinessName | BT-45 | |
HTGBOEZIP | optional | VARCHAR(10) | ZIP Code of the Buyer Organization | Postleitzahl | PostcodeCode | ||
HTGBOEAD1 | optional | VARCHAR(50) | Address line 1 of the Buyer Organization | Adresszeile 1 | LineOne | ||
HTGBOEAD2 | optional | VARCHAR(50) | Address line 2 of the Buyer Organization | Adresszeile 2 | LineTwo | ||
HTGBOEAD3 | optional | VARCHAR(50) | Address line 3 of the Buyer Organization | Adresszeile 3 | LineThree | ||
HTGBOELC | optional | VARCHAR(50) | City of the Buyer Organization | Ort | CityName | ||
HTGBOECR | optional | CHAR(3) | Country ISO of the Buyer Organization | Land (Code) | CountryID | ||
HTGBCT | optional | VARCHAR(50) | Contact Name of the Buyer | Kontaktstelle des Käufers | PersonName | BT-56 | Hans Muster |
HTGBCTD | optional | VARCHAR(50) | Department name of the Buyer | Kontaktstelle des Käufers | DepartmentName | BT-56-0 | Rechnungsstellung |
HTGBTE | required | VARCHAR(50) | Phone number of the Buyer | Telefonnummer der Kontaktstelle des Käufers | CompleteNumber | BT-57 | +49 (123) 56789-0 |
HTGBFX | required | VARCHAR(50) | Fax number of tDetailangaben zu den Lieferbedingungenhe Buyer | Faxnummer des Käufers | CompleteNumber | +49 (123) 56789-999 | |
HTGBEM | required | VARCHAR(200) | Mail adress of the Buyer | E-Mail-Adresse der Kontaktstelle des Käufers | URIID | BT-58 | |
HTGBZIP | optional | VARCHAR(10) | ZIP Code of the Buyer | Postleitzahl des Käufers | PostcodeCode | BT-53 | 69876 |
HTGBAD1 | optional | VARCHAR(50) | Adress line 1 of the Buyer | Zeile 1 der Käuferanschrift | LineOne | BT-50 | Kundenstraße 15 |
HTGBAD2 | optional | VARCHAR(50) | Adress line 2 of the Buyer | Zeile 2 der Käuferanschrift | LineTwo | BT-51 |
|
HTGBAD3 | optional | VARCHAR(50) | Adress line 3 of the Buyer | Zeile 3 der Käuferanschrift | LineThree | BT-163 |
|
HTGBLC | optional | VARCHAR(50) | City of the Buyer | Stadt der Käuferanschrift | CityName | BT-52 | Frankfurt |
HTGBCR | required | CHAR(3) | Country ISO of the Buyer | Ländercode der Käuferanschrift | CountryID | BT-55 | DE |
HTGBCSDN | optional | VARCHAR(25) | Country federal state | Bundesland | CountrySubDivisionName | BT-54 | |
HTGBURID | required | VARCHAR(55) | Electronic address | Elektronische Adresse des Käufers | URIID | BT-49 | |
HTGBURIDT | required | VARCHAR(10) | Electronic address type | Kennung des Schemas | schemeID | BT-49-1 | |
HTGBTAX | required | VARCHAR(35) | Taxnumber of the Buyer | Steuernummer des Käufers | ID | BT-48 | 201/123/12341 |
HTGBTAXT | required | VARCHAR(35) | USTid of the Buyer | Umsatzsteuer-Identifikationsnummer des Käufers | ID | BT-48 | DE234567781 |
HTGTID | optional | VARCHAR(35) | Identifier of the Seller Tax Representative | Identifier des Steuerbevollmächtigten | ID | B123456 | |
HTGTGLN | optional | VARCHAR(35) | Global identifier of the Seller Tax Representative | Globaler Identifier des Steuerbevollmächtigten | GlobalID | 4E+12 | |
HTGTGLNT | required wenn HTGBYGLN gefüllt ist. | CHAR(5) | Type of global Identifier | Kennung des Schemas | schemeID | 0021 : SWIFT | |
HTGTNAME | required | VARCHAR(255) | Company/Name of the Seller Tax Representative | Name des Steuerbevollmächtigten des Verkäufers | Name | BT-62 | Kunden AG Mitte |
HTGTOID | optional | VARCHAR(35) | Identifier of the Organization | Handelsregisternummer | ID | ||
HTGTOIDT | optional | VARCHAR(10) | Type of Organization Identifier | Art der Nummer | schemeID | ||
HTGTOTRBN | optional | VARCHAR(50) | Trading Business name | Handelsname | TradingBusinessName | ||
HTGTCT | optional | VARCHAR(50) | Contact Name of the Seller Tax Representative | Ansprechpartnername | PersonName | Hans Muster | |
HTGTCTD | optional | VARCHAR(50) | Department name of the Seller Tax Representative | Abteilungsname | DepartmentName | Rechnungsstellung | |
HTGTTE | required | VARCHAR(50) | Phone number of the Seller Tax Representative | Telefonnummer | CompleteNumber | +49 (123) 56789-0 | |
HTGTFX | required | VARCHAR(50) | Fax number of the Seller Tax Representative | Faxnummer | CompleteNumber | +49 (123) 56789-999 | |
HTGTEM | required | VARCHAR(200) | Mail address of the Seller Tax Representative | Emailadresse | URIID | ||
HTGTZIP | optional | VARCHAR(10) | ZIP Code of the Seller Tax | Postleitzahl der Steuerbevollmächtigtenaschrift | PostcodeCode | BT-67 | |
HTGTAD1 | optional | VARCHAR(50) | Address line 1 of the Seller Tax Representative | Zeile 1 der Steuerbevollmächtigtenaschrift | LineOne | BT-64 | |
HTGTAD2 | optional | VARCHAR(50) | Address line 2 of the Seller Tax Representative | Zeile 2 der Steuerbevollmächtigtenaschrift | LineTwo | BT-65 | |
HTGTAD3 | optional | VARCHAR(50) | Address line 3 of the Seller Tax Representative | Zeile 3 der Steuerbevollmächtigtenaschrift | LineThree | BT-164 | |
HTGTLC | optional | VARCHAR(50) | City of the Seller Tax Representative | Stadt der Steuerbevollmächtigtenaschrift | CityName | BT-66 | |
HTGTCR | required | CHAR(3) | Country ISO of the Seller Tax Representative | Ländercode der Steuerbevollmächtigtenaschrift | CountryID | CountryID | |
HTGTCSDN | optional | VARCHAR(25) | Country federal state | Bundesland | CountrySubDivisionName | BT-68 | |
HTGTURID | required | VARCHAR(55) | Electronic address | Elektronischen Adresse | URIID | ||
HTGTURIDT | required | VARCHAR(10) | Electronic address type | Art der elektronischen Adresse | schemeID | ||
HTGTTAX | required | VARCHAR(35) | Taxnumber of the Seller Tax Representative | Umsatzsteuer-Identifikationsnummer des Steuerbevollmächtigten des Verkäufers | ID | BT-63 | |
HTGTTAXT | required | VARCHAR(35) | USTid of the Seller Tax Representative | Kennung des Schemas | schemeID | BT-63-0 | |
HTGUDID | optional | VARCHAR(35) | Identifier of the deviating end user | Identifikation des abweichenden Endverbrauchers | ID | ||
HTGUDGLN | optional | VARCHAR(35) | Global identifier of the deviating end user | Globaler Identifier des abweichenden Endverbrauchers | GlobalID | ||
HTGUDGLNT | required wenn HTGUDGLN gefüllt ist. | CHAR(5) | Type of global identifier | Art der globalen Identifikationsnummer | schemeID | 0021 : SWIFT | |
HTGUDNAME | required | VARCHAR(255) | Company/Name of the deviating end user | Name/Firmierung des Endverbrauchers | Name | ||
HTGUDOID | optional | VARCHAR(35) | Identifier of the Organization | Handelsregisternummer | ID | ||
HTGUDOIDT | required wenn HTGUDOID gefüllt ist. | VARCHAR(10) | Type of Organization Identifier | Art der Nummer | schemeID | ||
HTGUDOTRBN | optional | VARCHAR(50) | Trading Business name | Handelsname | TradingBusinessName | ||
HTGUDCT | optional | VARCHAR(50) | Contact Name of the deviating end user | Name des Ansprechpartners | PersonName | ||
HTGUDCTD | optional | VARCHAR(50) | Department name of the deviating end user | Abteilung des Ansprechpartners | DepartmentName | ||
HTGUDTE | required | VARCHAR(50) | Phone number of the deviating end user | Telefonnummer des Ansprechpartners | CompleteNumber | ||
HTGUDFX | required | VARCHAR(50) | Fax number of the deviating end user | Detailinformationen zur Faxnummer des Ansprechpartners | CompleteNumber | ||
HTGUDEM | required | VARCHAR(200) | Mail adress of the deviating end user | Emailadresse | URIID | ||
HTGUDZIP | optional | VARCHAR(10) | ZIP Code of the deviating end user | Postleitzahl | PostcodeCode | ||
HTGUDAD1 | optional | VARCHAR(50) | Adress line 1 of the deviating end user | Adresszeile 1 | LineOne | ||
HTGUDAD2 | optional | VARCHAR(50) | Adress line 2 of the deviating end user | Adresszeile 2 | LineTwo | ||
HTGUDAD3 | optional | VARCHAR(50) | Adress line 3 of the deviating end user | Adresszeile 3 | LineThree | ||
HTGUDLC | optional | VARCHAR(50) | City of the deviating end user | Ort | CityName | ||
HTGUDCR | required | CHAR(4) | Country ISO of the deviating end user | Land (Code) | CountryID | ||
HTGUDCSDN | optional | VARCHAR(25) | Country federal state | Bundesland | CountrySubDivisionName | ||
HTGUDURID | required | VARCHAR(55) | Electronic address | Elektronischen Adresse | URIID | ||
HTGUDURIDT | required | VARCHAR(10) | Electronic address type | Art der elektronischen Adresse | schemeID | ||
HTGUDTAX | required | VARCHAR(35) | Taxnumber of the deviating end user | Steuernummer des Käufers, Umsatzsteueridentnummer des Käufers | ID | ||
HTGUDTAXT | required | VARCHAR(35) | USTid of the deviating end user | Art der Steuernummer des Käufers | schemeID | ||
HTGDPTERM | optional | VARCHAR(3) | Delivery Conditions (CODE) | Lieferbedingung (Code) | DeliveryTypeCode | ||
HTGORDERNR | required | VARCHAR(35) | Order number | Verkaufsauftragsreferenz | IssuerAssignedID | BT-14 | |
HTGORDERD | optional | DATE '0001-01-01' | Date of order | Details zum Auftragsbestätigungsdatum | FormattedIssueDateTime | ||
HTGCORDNR | required | VARCHAR(35) | Order number | Bestellreferenz | IssuerAssignedID | BT-13 | |
HTGCORDD | optional | DATE '0001-01-01' | Date of order | Datum der Bestellung | FormattedIssueDateTime | ||
HTGCONTRNR | required | VARCHAR(35) | Agreement number | Vertragsreferenz | IssuerAssignedID | BT-12 | |
HTGCONTRD | optional | DATE '0001-01-01' | Date of agreement | Vertragsdatum | FormattedIssueDateTime | ||
HTSPPID | required | INTEGER | Project reference ID | Projektreferenz | ID | BT-11 | |
HTSPPNA | required | VARCHAR(35) | Project name | Projektname | Name | BT-11-0 | |
HTLWRDID | optional | VARCHAR(35) | Identifier of the were recipients | Kennung des Lieferorts | ID | BT-71 | TO123456 |
HTLWRDGLN | optional | VARCHAR(35) | Global identifier of the were recipients | Globaler Identifier der Kennung für den Lieferort | GlobalID | BT-71-0 | 4E+12 |
HTLWRDGLNT | required wenn HTLWRDGLNT gefüllt ist. | CHAR(5) | Type of global identifier | Kennung des Schemas | schemeID | BT-71-1 | 0021 : SWIFT |
HTLWRDREC | required | VARCHAR(255) | Company/Name of the were recipients | Name des Waren- oder Dienstleistungsempfängers | Name | BT-70 | |
HTLWROID | optional | VARCHAR(35) | Identifier of the Organization | Handelsregisternummer | ID | ||
HTLWROIDT | optional | VARCHAR(10) | Type of Organization Identifier | Art der Nummer | schemeID | 0021 : SWIFT | |
HTLWROTRBN | optional | VARCHAR(50) | Trading Business name | Handelsname | TradingBusinessName | ||
HTLWRDCN | optional | VARCHAR(50) | Contact Name of the were recipients | Name des Ansprechpartners | PersonName | ||
HTLWRDDN | optional | VARCHAR(50) | Department name of the were recipients | Abteilung des Ansprechpartners | DepartmentName | ||
HTLWRDTEL | required | VARCHAR(50) | Phone number of the were recipients | Telefonnummer des Ansprechpartners | CompleteNumber | ||
HTLWRDFAX | required | VARCHAR(50) | Fax number of the were recipients | Faxnummer | CompleteNumber | ||
HTLWRDMAIL | required | VARCHAR(200) | Mail adress of the were recipients | Emailadresse | 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 | Zeile 1 der Lieferanschrift | LineOne | BT-75 | |
HTLWRDAD2 | optional | VARCHAR(50) | Adress line 2 of the were recipients | Zeile 2 der Lieferanschrift | LineTwo | BT-76 | |
HTLWRDAD3 | optional | VARCHAR(50) | Adress line 3 of the were recipients | Zeile 3 der Lieferanschrift | LineThree | BT-165 | |
HTLWRDCITY | optional | VARCHAR(50) | City of the were recipients | Stadt der Lieferanschrift | CityName | BT-77 | |
HTLWRDLC | required | CHAR(4) | Country ISO of the were recipients | Ländercode der Lieferanschrift | CountryID | BT-80 | |
HTLWRCSDN | optional | VARCHAR(25) | Country federal state | Bundesland | CountrySubDivisionName | BT-79 | |
HTLWRURID | optional | VARCHAR(55) | Eletronic address | Elektronischen Adresse | URIID | ||
HTLWRURIDT | optional | VARCHAR(10) | Eletronic address type | Art der elektronischen Adresse | schemeID | ||
HTLWRDSNR | optional | VARCHAR(35) | Taxnumber of the were recipients | Steuernummer, Umsatzsteueridentnummer | ID | ||
HTLWRDASNR | optional | VARCHAR(35) | USTid of the were recipients | Art der Steuernummer | schemeID | ||
HTLFRDID | optional | VARCHAR(35) | Identifier of the final recipient | Identifikation des Endempfängers | ID | ||
HTLFRDGLN | optional | VARCHAR(35) | Global identifier of the final recipient | Globaler Identifier des Endempfängers | GlobalID | ||
HTLFRDGLNT | required wenn HTLFRDGLN gefüllt ist. | CHAR(5) | Type of global Identifier | Kennung des Schemas | schemeID | ||
HTLFRDREC | optional | VARCHAR(255) | Company/Name of the final recipient | Name/Firmierung des Endempfängers | Name | ||
HTLFROID | optional | VARCHAR(35) | Identifier of the Organization | Handelsregisternummer | ID | ||
HTLFROIDT | optional | VARCHAR(10) | Type of Organization Identifier | Kennung des Schemas | schemeID | ||
HTLFROTRBN | optional | VARCHAR(50) | Trading Business name | Handelsname | TradingBusinessName | ||
HTLFRDCN | abhängig | VARCHAR(50) | Contact Name of the final recipient | Name des Ansprechpartners | PersonName | ||
HTLFRDDN | abhängig | VARCHAR(50) | Department name of the final recipient | Abteilung des Ansprechpartners | DepartmentName | ||
HTLFRDTEL | required | VARCHAR(50) | Phone number of the final recipient | Telefonnummer des Ansprechpartners | CompleteNumber | ||
HTLFRDFAX | required | VARCHAR(50) | Fax number of the final recipient | Faxnummer | CompleteNumber | ||
HTLFRDMAIL | required | VARCHAR(200) | Mail adress of the final recipient | Emailadresse | URIID | ||
HTLFRDPLZ | optional | VARCHAR(10) | ZIP Code of the final recipient | Postleitzahl | PostcodeCode | ||
HTLFRDAD1 | optional | VARCHAR(50) | Adress line 1 of the final recipient | Adresszeile 1 | LineOne | ||
HTLFRDAD2 | optional | VARCHAR(50) | Adress line 2 of the final recipient | Adresszeile 2 | LineTwo | ||
HTLFRDAD3 | optional | VARCHAR(50) | Adress line 3 of the final recipient | Adresszeile 3 | LineThree | ||
HTLFRDCITY | optional | VARCHAR(50) | City of the final recipient | Ort | CityName | ||
HTLFRDLC | required | CHAR(4) | Country ISO of the final recipient | Land (Code) | CountryID | ||
HTLFRCSDN | optional | VARCHAR(25) | Country federal state | Bundesland | CountrySubDivisionName | ||
HTLFRURID | optional | VARCHAR(55) | Eletronic address | Elektronischen Adresse | |||
HTLFRURIDT | optional | VARCHAR(10) | Eletronic address type | Art der elektronischen Adresse | |||
HTLFRDSNR | optional | VARCHAR(35) | Taxnumber of the final recipient | Steuernummer, Umsatzsteueridentnummer | ID | ||
HTLFRDASNR | optional | VARCHAR(35) | USTid of the final recipient | Art der Steuernummer | schemeID | ||
HTLCDID | optional | VARCHAR(35) | Identifier of the consignor | Identifikation des Versenders | ID | ||
HTLCDGLN | optional | VARCHAR(35) | Global identifier of the consignor | Globaler Identifier des Versenders | GlobalID | ||
HTLCDGLNT | required wenn HTLCDGLN gefüllt ist. | CHAR(5) | Type of Organization Identifier | Art der globalen Identifikationsnummer | schemeID | ||
HTLCDREC | required | VARCHAR(255) | Company/Name of the consignor | Name/Firmierung des Versenders | Name | ||
HTLCDOID | optional | VARCHAR(35) | Identifier of the Organization | Handelsregisternummer | ID | ||
HTLCDOIDT | optional | VARCHAR(10) | Type of Organization Identifier | Art der Nummer | schemeID | ||
HTLCDOTRBN | optional | VARCHAR(50) | Trading Business name | Handelsname | TradingBusinessName | ||
HTLCDCN | optional | VARCHAR(50) | Contact Name of the consignor | Name des Ansprechpartners | PersonName | ||
HTLCDDN | optional | VARCHAR(50) | Department name of the consignor | Abteilung des Ansprechpartners | DepartmentName | ||
HTLCDTEL | required | VARCHAR(50) | Phone number of the consignor | Telefonnummer des Ansprechpartners | CompleteNumber | ||
HTLCDFAX | required | VARCHAR(50) | Fax number of the consignor | Faxnummer | CompleteNumber | ||
HTLCDMAIL | required | VARCHAR(200) | Mail adress of the consignor | Emailadresse | |||
HTLCDPLZ | optional | VARCHAR(10) | ZIP Code of the consignor | Postleitzahl | PostcodeCode | ||
HTLCDAD1 | optional | VARCHAR(50) | Adress line 1 of the consignor | Adresszeile 1 | LineOne | ||
HTLCDAD2 | optional | VARCHAR(50) | Adress line 2 of the consignor | Adresszeile 2 | LineTwo | ||
HTLCDAD3 | optional | VARCHAR(50) | Adress line 3 of the consignor | Adresszeile 3 | LineThree | ||
HTLCDCITY | optional | VARCHAR(50) | City of the consignor | Ort | CityName | ||
HTLCDLC | required | CHAR(4) | Country ISO of the consignor | Land (Code) | CountryID | ||
HTLCDCSDN | optional | VARCHAR(25) | Country federal state | Bundesland | CountrySubDivisionName | ||
HTLCDURID | optional | VARCHAR(55) | Eletronic address | Elektronischen Adresse | URIID | ||
HTLCDURIDT | optional | VARCHAR(10) | Eletronic address type | Art der elektronischen Adresse | schemeID | ||
HTLCDSNR | optional | VARCHAR(35) | Taxnumber of the consignor | Steuernummer, Umsatzsteueridentnummer | ID | ||
HTLCDASNR | optional | VARCHAR(35) | USTid of the consignor | Art der Steuernummer | schemeID | ||
HTLDTD | required | DATE '0001-01-01' | Actual Delivery Time | Tatsächlicher Lieferungszeitpunkt | OccurrenceDateTime | 10.12.2018 | |
HTLDANR | required | VARCHAR(25) | Despatch advice number | Lieferavisreferenz | IssuerAssignedID | BT-16 | |
HTLDALD | optional | DATE '0001-01-01' | Date of Despatch advice | Lieferavisdatum | FormattedIssueDateTime | FormattedIssueDateTime | |
HTLWDANR | required | VARCHAR(25) | Goods receipt notification number | Referenz auf die Wareneingangsmeldung | IssuerAssignedID | BT-15 | |
HTLWDALD | optional | DATE '0001-01-01' | Date of goods receipt notification | Wareneingangsdatum | FormattedIssueDateTime | ||
HTLDLSNR | required | VARCHAR(35) | Delivery Note number | Lieferscheinnummer | IssuerAssignedID | ||
HTLDLSD | optional | DATE '0001-01-01' | Date of Delivery Note | Lieferscheindatum | FormattedIssueDateTime | ||
HTZGPCID | optional | VARCHAR(35) | Creditor ID | Kennung des Gläubigers | CreditorReferenceID | BG19, BT-90 | |
HTZGPZR | empfohlen | VARCHAR(200) | Intended purpose | Verwendungszweck | PaymentReference | BT-83 | |
HTZGPTC | optional | VARCHAR(5) | Tax Currency Code | Code für die Währung der Umsatzsteuerbuchung | TaxCurrencyCode | BT-6 | |
HTZGPIC | required | VARCHAR(5) | Invoice Currency Code | Code für die Rechnungswährung | InvoiceCurrencyCode | BT-5 | |
HTZGPIRN | optional | INTEGER | Issuer reference number | Referenznummer des Verkäufers | InvoiceIssuerReference | ||
HTZITDREID | optional | VARCHAR(35) | Identifier of the Invoicing party Trade partner | Identifier | ID | ||
HTZITDGLN | optional | VARCHAR(35) | Global identifier of the Invoicing party Trade partner | Globaler Identifier | GlobalID | ||
HTZITDGLNT | required wenn HTZITDGLN gefüllt ist. | CHAR(5) | Type of global Identifier | Art der globalen Identifikationsnummer | schemeID | ||
HTZIRDREC | required | VARCHAR(255) | Company/Name of the Invoice recipient | Name | Name | ||
HTZITOID | optional | VARCHAR(35) | Identifier of the Organization | Handelsregisternummer | ID | ||
HTZITOIDT | optional | VARCHAR(10) | Type of Organization Identifier | Art der Nummer | schemeID | ||
HTZITOTRBN | optional | VARCHAR(50) | Trading Business name | Handelsname | TradingBusinessName | ||
HTZITDCN | optional | VARCHAR(50) | Contact Name of the Invoicing party Trade partner | Ansprechpartnername | PersonName | ||
HTZITDDN | optional | VARCHAR(50) | Department name of the Invoicing party Trade partner | Abteilungsname | DepartmentName | ||
HTZITDTEL | required | VARCHAR(50) | Phone number of the Invoicing party Trade partner | Telefonnummer | CompleteNumber | ||
HTZITDFAX | required | VARCHAR(50) | Fax number of the Invoicing party Trade partner | Faxnummer | CompleteNumber | ||
HTZITDMAIL | required | VARCHAR(200) | Mail address of the Invoicing party Trade partner | Emailadresse | URIID | ||
HTZITDEPLZ | optional | VARCHAR(10) | ZIP Code of the Invoicing party Trade partner | Postleitzahl | PostcodeCode | ||
HTZITDAD1 | optional | VARCHAR(50) | Address line 1 of the Invoicing party Trade partner | Adresszeile 1 | LineOne | ||
HTZITDAD2 | optional | VARCHAR(50) | Address line 2 of the Invoicing party Trade partner | Adresszeile 2 | LineTwo | ||
HTZITDAD3 | optional | VARCHAR(50) | Address line 3 of the Invoicing party Trade partner | Adresszeile 3 | LineThree | ||
HTZITDCITY | optional | VARCHAR(50) | City of the Invoicing party Trade partner | Ort | CityName | ||
HTZITDLLC | required | CHAR(4) | Country ISO of the Invoicing party Trade partner | Land (Code) | CountryID | ||
HTZITCSDN | optional | VARCHAR(25) | Country federal state of the Invoicing party Trade partner | Bundesland | CountrySubDivisionName | ||
HTZITURID | optional | VARCHAR(55) | Electronic address of the Invoicing party Trade partner | Elektronischen Adresse | URIID | ||
HTZITURIDT | optional | VARCHAR(10) | Electronic address type of the Invoicing party Trade partner | Art der elektronischen Adresse | schemeID | ||
HTZITDSNR | optional | VARCHAR(35) | Taxnumber of the Invoicing party Trade partner | Steuernummer, Umsatzsteueridentnummer | ID | ||
HTZITDASNR | optional | VARCHAR(35) | USTid of the Invoicing party Trade partner | Art der Steuernummer | schemeID | ||
HTZIRDREID | optional | VARCHAR(35) | Identifier of the Invoice recipient | Identifikation des Rechnungsempfängers | ID | ||
HTZIRDGLN | optional | VARCHAR(35) | Global identifier of the Invoice recipient | Globaler Identifier des abweichenden Rechnungsempfängers | GlobalID | ||
HTZIRDGLNT | required wenn HTZIRDGLN gefüllt ist. | CHAR(5) | Type of global Identifier | Kennung des Schemas | schemeID | ||
HTZIRDREC | required | VARCHAR(255) | Company/Name of the Invoice recipient | Name/Firmierung des Rechnungsempfängers | Name | ||
HTZIROID | optional | VARCHAR(35) | Identifier of the Organization | Handelsregisternummer | ID | ||
HTZIROIDT | optional | VARCHAR(10) | Type of Organization Identifier | Art der Nummer | schemeID | ||
HTZIROTRBN | optional | VARCHAR(50) | Trading Business name | Handelsname | TradingBusinessName | ||
HTZIRDCN | optional | VARCHAR(50) | Contact Name of the Invoice recipient | Name des Ansprechpartners | PersonName | ||
HTZIRDDN | optional | VARCHAR(50) | Department name of the Invoice recipient | Abteilung des Ansprechpartners | DepartmentName | ||
HTZIRDTEL | required | VARCHAR(50) | Phone number of the Invoice recipient | Telefonnummer des Ansprechpartners | CompleteNumber | ||
HTZIRDFAX | required | VARCHAR(50) | Fax number of the Invoice recipient | Faxnummer | CompleteNumber | ||
HTZIRDMAIL | required | VARCHAR(200) | Mail adress of the Invoice recipient | Emailadresse | URIID | ||
HTZIRDEPLZ | optional | VARCHAR(10) | ZIP Code of the Invoice recipient | Postleitzahl | PostcodeCode | ||
HTZIRDAD1 | optional | VARCHAR(50) | Adress line 1 of the Invoice recipient | Zeile 1 der Anschrift des Rechnungsempfängers | LineOne | ||
HTZIRDAD2 | optional | VARCHAR(50) | Adress line 2 of the Invoice recipient | Zeile 2 der Anschrift des Rechnungsempfängers | LineTwo | ||
HTZIRDAD3 | optional | VARCHAR(50) | Adress line 3 of the Invoice recipient | Zeile 3 der Anschrift des Rechnungsempfängers | LineThree | ||
HTZIRDCITY | optional | VARCHAR(50) | City of the Invoice recipient | Stadt der Anschrift des Rechnungsempfängers | CityName | ||
HTZIRDLLC | required | CHAR(4) | Country ISO of the Invoice recipient | Ländercode der Anschrift des Rechnungsempfängers | CountryID | ||
HTZIRCSDN | optional | VARCHAR(25) | Country federal state | Bundesland | CountrySubDivisionName | ||
HTZIRURID | required | VARCHAR(55) | Electronic address | Elektronischen Adresse | URIID | ||
HTZIRURIDT | required | VARCHAR(10) | Electronic address type | Art der elektronischen Adresse | schemeID | ||
HTZIRDSNR | optional | VARCHAR(35) | Taxnumber of the Invoice recipient | Steuernummer | ID | ||
Umsatzsteueridentnummer | |||||||
HTZIRDASNR | optional | VARCHAR(35) | USTid of the Invoice recipient | Art der Steuernummer | schemeID | ||
HTZPRDREID | optional | VARCHAR(35) | Identifier of the Payment Receiver | Kennung des Zahlungsempfängers | ID | BT-60 | |
HTZPRDGLN | optional | VARCHAR(35) | Global identifier of the Payment Receiver | Globaler Identifier des abweichenden | GlobalID | BT-60-0 | |
HTZPRDGLNT | required wenn HTZPRDGLN gefüllt ist. | CHAR(5) | Type of global Identifier | Kennung des Schemas | schemeID | BT-60-1 | |
HTZPRDREC | required | VARCHAR(255) | Company/Name of the Payment Receiver | Name/Firmierung des Zahlungsempfängers | Name | BT-59 | |
HTZPROID | optional | VARCHAR(35) | Identifier of the Organization | Kennung der rechtlichen Registrierung des Zahlungsempfängers | ID | BT-61 | |
HTZPROIDT | optional | VARCHAR(10) | Type of Organization Identifier | Kennung des Schemas | schemeID | BT-61-1 | |
HTZPROTRBN | optional | VARCHAR(50) | Trading Business name | Handelsname | TradingBusinessName | ||
HTZPRDCN | optional | VARCHAR(50) | Contact Name of the Payment Receiver | Name des Ansprechpartners des Zahlungsempfängers | PersonName | ||
HTZPRDDN | optional | VARCHAR(50) | Department name of the Payment Receiver | Abteilung des Ansprechpartners des Zahlungsempfängers | DepartmentName | ||
HTZPRDTEL | required | VARCHAR(50) | Phone number of the Payment Receiver | Telefonnummer des Ansprechpartner des Zahlungsempfängers | CompleteNumber | ||
HTZPRDFAX | required | VARCHAR(50) | Fax number of the Payment Receiver | Faxnummer des Ansprechpartners des Zahlungsempfängers | CompleteNumber | ||
HTZPRDMAIL | required | VARCHAR(200) | Mail adress of the Payment Receiver | Emailadresse des Ansprechpartners des Zahlungsempfängers | URIID | ||
HTZPRDPLZ | optional | VARCHAR(10) | ZIP Code of the Payment Receiver | Postleitzahl | PostcodeCode | ||
HTZPRDAD1 | optional | VARCHAR(50) | Adress line 1 of the Payment Receiver | Zeile 1 der Anschrift des Zahlungsempfängers | LineOne | ||
HTZPRDAD2 | optional | VARCHAR(50) | Adress line 2 of the Payment Receiver | Zeile 2 der Anschrift des Zahlungsempfängers | LineTwo | ||
HTZPRDAD3 | optional | VARCHAR(50) | Adress line 3 of the Payment Receiver | Zeile 3 der Anschrift des Zahlungsempfängers | LineThree | ||
HTZPRDCITY | optional | VARCHAR(50) | City of the Payment Receiver | Stadt der Anschrift des Zahlungsempfängers | CityName | ||
HTZPRDLLC | required | CHAR(4) | Country ISO of the Payment Receiver | Ländercode der Anschrift des Zahlungsempfängers | CountryID | ||
HTZPRCSDN | optional | VARCHAR(25) | Country federal state | Bundesland | CountrySubDivisionName | ||
HTZPRURID | required | VARCHAR(55) | Electronic address | Elektronischen Adresse | URIID | ||
HTZPRURIDT | required | VARCHAR(10) | Electronic address type | Art der elektronischen Adresse | schemeID | ||
HTZPRDSNR | optional | VARCHAR(35) | Taxnumber of the Payment Receiver | Steuernummer, Umsatzsteueridentnummer | ID | ||
HTZPRDASNR | optional | VARCHAR(35) | USTid of the Payment Receiver | Art der Steuernummer | schemeID | ||
HTZTASC | required | CHAR(5) | Invoicing currency | Rechnungswährung | SourceCurrencyCode | ||
HTZTATC | required | CHAR(5) | Home currency | Heimatwährung | SourceCurrencyCode | ||
HTZTACR | required | DECIMAL(10, 5) | Exchange rate | Umrechnungskurs | SourceCurrencyCode | ||
HTZTACD | optional | DATE '0001-01-01' | Date for exchange rate | Datum zum Umrechnungskurs | ConversionRateDateTime | ||
HTZBILLPD | optional | VARCHAR(50) | Description of Bill period | Freitext zur Rechnungsperiode | Description | ||
HTZBILLBP | optional | VARCHAR(15) | Beginning of the accounting period | Beginn der Rechnungsperiode | StartDateTime | BT-73 | |
HTZBILLBPF | required wenn HTZBILLBP gefüllt ist. | CHAR(3) | Date Format | Datum, Format | format | BT-73-0 | 102 |
HTZBILLEP | optional | VARCHAR(15) | End of the accounting | Ende der Rechnungsperiode | EndDateTime | BT-74 | |
HTZBILLEPF | required wenn HTZBILLEP gefüllt ist. | CHAR(3) | Date Format | Datum, Format | format | BT-74-0 | 102 |
HTZTSMSLT | required | DECIMAL(15, 2) | Total amount of positions | Summe der Nettobeträge aller Rechnungspositionen | LineTotalAmount | BT-106 | 6913.60 |
HTZTSMSCT | optional | DECIMAL(15, 2) | Total amount of surcharges | Summe der Zuschläge auf Dokumentenebene | ChargeTotalAmount | BT-108 | 0.00 |
HTZTSMSAT | optional | DECIMAL(15, 2) | Total amounts of discounts | Summe der Abschläge auf Dokumentenebene | AllowanceTotalAmount | BT-107 | 0.00 |
HTZTSMSTB1 | required | DECIMAL(15, 2) | Tax basic amount 1 | Rechnungsgesamtbetrag ohne Umsatzsteuer 1 | TaxBasisTotalAmount | BT-109 | 6913.60 |
HTZTSMSTB2 | optional | DECIMAL(15, 2) | Tax basic amount 2 | Rechnungsgesamtbetrag ohne Umsatzsteuer 2 | |||
HTZTSMSTT1 | required | DECIMAL(15, 2) | Tax total amount 1 | Gesamtbetrag der Rechnungsumsatzsteuer Steuergesamtbetrag in Buchungswährung 1 | TaxTotalAmount | BT-110, BT-111 | 1313.58 |
HTZTSMSTT2 | optional | DECIMAL(15, 2) | Tax total amount 2 | Gesamtbetrag der Rechnungsumsatzsteuer Steuergesamtbetrag in Buchungswährung 2 | |||
HTZTSMSRA | optional | DECIMAL(15, 2) | Rounding amount | Rundungsbetrag | RoundingAmount | BT-114 | |
HTZTSMSGT1 | required | DECIMAL(15, 2) | Grand total amount 1 | Rechnungsgesamtbetrag einschließlich Umsatzsteuer 1 | GrandTotalAmount | BT-112 | 8227.18 |
HTZTSMSGT2 | optional | DECIMAL(15, 2) | Grand total amount 2 | Rechnungsgesamtbetrag einschließlich Umsatzsteuer 2 | |||
HTZTSMSTPA | optional | DECIMAL(15, 2) | Deposit amount | Vorauszahlungsbetrag | TotalPrepaidAmount | BT-113 | 0.00 |
HTZTSMSDPA | required | DECIMAL(15, 2) | Payment amount | Fälliger Zahlungsbetrag | DuePayableAmount | BT-115 | 8227.18 |
HTZIRDIAID | required | VARCHAR(35) | Number of previous invoice | Nummer der vorausgegangenen Rechnung | IssuerAssignedID | BT-25 | |
HTZIRDFIDT | optional | DATE '0001-01-01' | Invoice Date of previous invoice | Rechnungsdatum | FormattedIssueDateTime | ||
HTSTATE | VARCHAR(1) | State of Order | Status Spalte | Leerer String = Nicht Verarbeitet, | |||
HTSESSUM | DECIMAL(15, 0) | i-effect Session Number | i-effect Sitzungsnummer | ||||
EXTERNAL_RECIPIENT | CHAR(255) | Externer Empfänger für SNDFILE | i-effect Empfänger aus dem Partnerstamm | ||||
EXTERNAL_ORIGINATOR | CHAR(255) | Externer Absender für SNDFILE | i-effect Absender aus dem Partnerstamm | ||||
HTZITDREC | VARCHAR(255) |