If you want to create Xinvoices, fill in the tables below with your data. If you need help with the filling, please contact the support .
| XInvoice |
|---|
| Column name | Status | Column definition | Column description | Technical term | Example |
|---|
| HTKEY | required | VARCHAR(15) | Internal Pagination Number | Internal invoice number (i-effect column) | 132 | | HTDIRECT | required | CHAR(4) | Direction of XRechnung |
| *IN, *OUT |
| Process control (required) |
|---|
| Grouping of business process information (optional) |
|---|
| Column name | Status | Column definition | Column description | Technical term | Example |
|---|
| HTNPROCESS | optional | VARCHAR(255) | Process type | Business Process Type | Production material, other material, freight invoice |
|
| Grouping of recommended use information (required) |
|---|
| Column name | Status | Column definition | Column description | Technical term | Example |
|---|
| HTNAPPREF | required | VARCHAR(255) | Referenz zur Anwendung | Recommendation for use | XInvoice |
|
|
| Grouping of properties that affect the entire document. (required) |
|---|
| Column name | Status | Column definition | Column description | Technical term | Example |
|---|
| HTNDOCNR | required | VARCHAR(35) | Document number | invoice number | 2012-12345 | | HTNDOCT | required | CHAR(3) | Document type (Code), | Code for the invoice type | 326 = Partial invoice 380 = Commercial invoice 384 = Corrected invoic 389 = Self-billed invoice 381 = Credit note further codes are in the code list | | HTNDOCD | required | DATE '0001-01-01' | Document date | Date of invoice | 2018-12-10 |
| Free text at document level (optional) |
|---|
| Observe table ZF2INVTX. |
|
| Grouping of transaction information (required) |
|---|
| invoice item (required) |
|---|
| Note table ZF2INVPI. |
| Grouping of contract details (required) |
|---|
| Column name | Status | Column definition | Column description | Technical term | Example |
|---|
| HTGBYREF | required | VARCHAR(35) | Buyer reference | Buyer's reference | INV 082 |
| Detailed information about the seller (required) |
|---|
| Column name | Status | Column definition | Column description | Technical term | Example |
|---|
| HTGSEID | optional | VARCHAR(35) | Identifier of the Seller | Identification of the seller (supplier number) |
| | HTGSEGLN | optional* | VARCHAR(35) | Global identifier of the Seller | Global identifier of the seller | 4000001000005 | | HTGSEGLNT | required if HTGSEGLN is filled** | CHAR(5) | Type of global Identifier | Identification of the scheme | 0021 : SWIFT 0088 : EAN 0060 : DUNS 0177 : ODETTE other codes in the code list | | HTGSENAME | required | VARCHAR(255) | Company/Name of the Seller | Company name/name of the seller | Supplier GmbH | | HTGSDESC | optional | VARCHAR(255) | Other remaining information of the Seller | Other legal information of the seller |
|
| Details of the organisation (optional) |
|---|
| Column name | Status | Column definition | Column description | Technical term | Example |
|---|
HTGSOID | optional | VARCHAR(35) | Identifier of the Organization | Identification of the legal registration of the seller |
| HTGSOIDT | optional | VARCHAR(10) | Type of Organization Identifier | Identification of the scheme |
| HTGSOTRBN | optional | VARCHAR(50) | Trading Business name | Trade name of the seller |
|
|
| Contact details of the seller (required) |
|---|
| Column name | Status | Column definition | Column description | Technical term | Example |
|---|
| HTGSECT | required | VARCHAR(50) | Contact Name of the Seller | Contact name of the seller | Karin Mustermann | | HTGSECTD | optional* | VARCHAR(50) | Department name of the Seller | Department name of the seller | Invoicing |
| Detailed information on the seller's telephone number (required) |
|---|
| Column name | Status | Column definition | Column description | Technical term | Example |
|---|
| HTGSETE | required | VARCHAR(50) | Phone number of the Seller | Seller's telephone number | +49 (123) 456789-0 |
|
| Detailed information on the seller's email address (required) |
|---|
| Column name | Status | Column definition | Column description | Technical term | Example |
|---|
| HTGSEEM | required | VARCHAR(200) | Mail adress of the Seller | Email address of the seller | karin.mustermann@seller.tld |
|
|
| Postal address of the seller (required) |
|---|
| Column name | Status | Column definition | Column description | Technical term | Example |
|---|
| HTGSEZIP | required | VARCHAR(10) | ZIP Code of the Seller | Postcode of the seller address | 80333 | | HTGSEAD1 | optional | VARCHAR(50) | Adress line 1 of the Seller | Line 1 of the seller address | Supplier Street 20 | | HTGSEAD2 | optional | VARCHAR(50) | Adress line 2 of the Seller | Line 2 of the seller address | Building 3 | HTGSEAD3 | optional | VARCHAR(50) | Adress line 3 of the Seller | Line 3 of the seller address | Building 3 | | HTGSELC | required | VARCHAR(50) | City of the Seller | Place of the seller | Munich | | HTGSECR | required | CHAR(3) | Country ISO of the Seller | Country of seller (code) | DE | | HTGSCSDN | optional | VARCHAR(25) | Country federal state | Federal State |
|
|
| Details of the electronic address (optional) |
|---|
| Column name | Status | Column definition | Column description | Technical term | Example |
|---|
| HTGSURID | optional | VARCHAR(55) | Electronic address | Electronic address of the seller | 5790000435944 | | HTGSURIDT | required if HTGSURID is filled | VARCHAR(10) | Electronic address type | Identification of the scheme | Codes can be found in the code list |
|
| Detailed information on tax details of the seller (optional) |
|---|
| Column name | Status | Column definition | Column description | Technical term | Example |
|---|
| HTGSETAX | optional | VARCHAR(35) | Taxnumber of the Seller | Tax number of the seller (FC) | 01/113/40209 | | HTGSETAXT | optional | VARCHAR(35) | VAT of the Seller | Value added tax identification number (VA) | DE234567891 |
|
|
| Detailed information about the buyer (required) |
|---|
| Column name | Status | Column definition | Column description | Technical term | Example |
|---|
HTGBID | optional | VARCHAR(35) | Identifier of the Buyer | Identifier of the buyer (customer number) | B123456 | HTGBGLN | optional* | VARCHAR(35) | Global identifier of the Buyer | Global identifier of the buyer | 4000001000006 | HTGBGLNT | necessary if HTGBGLN is filled.** | CHAR(5) | Type of global Identifier | Identification of the scheme | 0021 : SWIFT 0088 : EAN 0060 : DUNS 0177 : ODETTE other codes in the code list | HTGBNAME | required | VARCHAR(255) | Company/Name of the Buyer | Company name/name of the buyer | Customers AG Middle |
| Details of the organisation (optional) |
|---|
| Column name | Status | Column definition | Column description | Technical term | Example |
|---|
HTGBOID | optional | VARCHAR(35) | Identifier of the Organization | Identification of the buyer's legal registration |
| HTGBOIDT | optional | VARCHAR(10) | Type of Organization Identifier | Identification of the scheme |
| HTGBOTRBN | optional | VARCHAR(50) | Trading Business name | Trade name of the buyer |
|
|
| Contact details of the buyer (optional) |
|---|
| Column name | Status | Column definition | Column description | Technical term | Example |
|---|
| HTGBCT | optional | VARCHAR(50) | Contact Name of the Buyer | Contact name of the buyer | Hans Muster | | HTGBCTD | optional | VARCHAR(50) | Department name of the Buyer | Department name of the buyer | Invoicing |
| Detailed information on the telephone number of the contact person (optional) |
|---|
| Column name | Status | Column definition | Column description | Technical term | Example |
|---|
HTGBTE | optional | VARCHAR(50) | Phone number of the Buyer | Telephone number of the buyer's contact point | +49 (123) 56789-0 |
|
| Detailed information on the email address of the contact person (optional) |
|---|
| Column name | Status | Column definition | Column description | Technical term | Example |
|---|
HTGBEM | optional | VARCHAR(200) | Mail adress of the Buyer | E-mail address of the buyer's contact point | hans.muster@buyer.tld |
|
|
| Detailed information on the buyer's address (required) |
|---|
| Column name | Status | Column definition | Column description | Technical term | Example |
|---|
HTGBZIP | required | VARCHAR(10) | ZIP Code of the Buyer | Postcode of the buyer | 69876 | HTGBAD1 | optional | VARCHAR(50) | Adress line 1 of the Buyer | Line 1 of the buyer address | Customer Street 15 | HTGBAD2 | optional | VARCHAR(50) | Adress line 2 of the Buyer | Line 2 of the buyer address | 3rd floor right | HTGBAD3 | optional | VARCHAR(50) | Adress line 3 of the Buyer | Line 3 of the buyer address | 3rd floor right | HTGBLC | required | VARCHAR(50) | City of the Buyer | City of buyer's address | Frankfurt | HTGBCR | required | CHAR(3) | Country ISO of the Buyer | Country code of the buyer address | DE | HTGBCSDN | optional | VARCHAR(25) | Country federal state | Federal State |
|
|
| Details of the electronic address (optional) |
|---|
| Column name | Status | Column definition | Column description | Technical term | Example |
|---|
HTGBURID | optional | VARCHAR(55) | Electronic address | Electronic address of the buyer |
| HTGBURIDT | optional | VARCHAR(10) | Electronic address type | Identification of the scheme | Codes can be found in the code list |
|
| Detailed information on tax details of the buyer (optional) |
|---|
| Column name | Status | Column definition | Column description | Technical term | Example |
|---|
HTGBTAXT | optional | VARCHAR(35) | VAT id of the Buyer | Value added tax identification number ("VA" in CII format) | DE234567781 |
|
|
| Tax representative of the seller (optional) |
|---|
| Column name | Status | Column definition | Column description | Technical term | Example |
|---|
HTGTNAME | required | VARCHAR(255) | Company/Name of the Seller Tax Representative | Name of the tax representative of the seller | Customers AG Middle |
| Postal address of the tax representative of the seller (required) |
|---|
| Column name | Status | Column definition | Column description | Technical term | Example |
|---|
HTGTZIP | optional | VARCHAR(10) | ZIP Code of the Seller Tax | Postcode of the tax representative's address |
| HTGTAD1 | optional | VARCHAR(50) | Address line 1 of the Seller Tax Representative | Line 1 of the tax representative document |
| HTGTAD2 | optional | VARCHAR(50) | Address line 2 of the Seller Tax Representative | Line 2 of the tax agent's document |
| HTGTAD3 | optional | VARCHAR(50) | Address line 3 of the Seller Tax Representative | Line 3 of the tax agent's document |
| HTGTLC | optional | VARCHAR(50) | City of the Seller Tax Representative | City of the tax attorney's office |
| HTGTCR | required | CHAR(3) | Country ISO of the Seller Tax Representative | Country code of the tax representative |
| HTGTCSDN | optional | VARCHAR(25) | Country federal state | Federal State |
|
|
| Detailed information on the tax number of the seller's tax representative (required) |
|---|
| Column name | Status | Column definition | Column description | Technical term | Example |
|---|
| HTGTTAXT | required | VARCHAR(35) | USTid of the Seller Tax Representative | Value added tax identification number ("VA" in CII format) |
|
|
|
| Detailed information on the corresponding order confirmation (optional) |
|---|
| Column name | Status | Column definition | Column description | Technical term | Example |
|---|
| HTGORDERNR | optional | VARCHAR(35) | Order number | Sales order reference |
|
|
| Details of the associated order (optional) |
|---|
| Column name | Status | Column definition | Column description | Technical term | Example |
|---|
HTGCORDNR | optional | VARCHAR(35) | Order number | Order reference |
|
|
| Details of the associated contract (optional) |
|---|
| Column name | Status | Column definition | Column description | Technical term | Example |
|---|
| HTGCONTRNR | optional | VARCHAR(35) | Agreement number | Contract reference |
|
|
| Justifying documents (optional) |
|---|
| Note table ZF2INVDR. |
| Detailed information on a project reference (optional) |
|---|
| Column name | Status | Column definition | Column description | Technical term | Example |
|---|
| HTSPPID | required | VARCHAR(10) | Project reference ID | Project reference |
| | HTSPPNA | required* | VARCHAR(35) | Project name | Project name |
|
|
|
| Grouping of delivery details (optional) |
|---|
| Delivery information (optional) |
|---|
| Column name | Status | Column definition | Column description | Technical term | Example |
|---|
| HTLWRDID | optional | VARCHAR(35) | Identifier of the were recipients | Identification of the consignee | TO123456 | | HTLWRDGLN | optional* | VARCHAR(35) | Global identifier of the were recipients | Global identifier of the consignee (GLN) | 4000001000007 | | HTLWRDGLNT | required if HTLWRDGLN is filled.** | CHAR(5) | Type of global identifier | Identification of the scheme | 0021 : SWIFT 0088 : EAN 0060 : DUNS 0177 : ODETTE other codes in the code list | | HTLWRDREC | required | VARCHAR(255) | Company/Name of the were recipients | Name/name of the consignee |
|
| Delivery address (optional) |
|---|
| Column name | Status | Column definition | Column description | Technical term | Example |
|---|
| HTLWRDPLZ | Required | VARCHAR(10) | ZIP Code of the were recipients | Postcode of delivery address |
| | HTLWRDAD1 | optional | VARCHAR(50) | Adress line 1 of the were recipients | Line 1 of the delivery address |
| | HTLWRDAD2 | optional | VARCHAR(50) | Adress line 2 of the were recipients | Line 2 of the delivery address |
| | HTLWRDAD3 | optional | VARCHAR(50) | Adress line 3 of the were recipients | Line 3 of the delivery address |
| | HTLWRDCITY | required | VARCHAR(50) | City of the were recipients | City of delivery address |
| | HTLWRDLC | required | CHAR(4) | Country ISO of the were recipients | Country code of delivery address |
| | HTLWRCSDN | optional | VARCHAR(25) | Country federal state | Federal State |
|
|
|
Detailed information on actual delivery (optional) Note: In Germany, the date of delivery and performance is a mandatory information on invoices. This can be done here or at item level. |
|---|
| Column name | Status | Column definition | Column description | Technical term | Example |
|---|
| HTLDTD | optional | DATE '0001-01-01' | Actual Delivery Time | Actual date of delivery | 2018-12-10 |
|
| Detailed information on the corresponding shipping notification (optional) |
|---|
| Spaltenname | Status | Column definition | Column description | Technical term | Example |
|---|
| HTLDANR | optional | VARCHAR(25) | Despatch advice number | Shipping notification reference |
|
|
| Detailinformationen zur zugehörigen Wareneingangsmeldung (optional) |
|---|
| Spaltenname | Status | Spaltendefinition | Spaltenbeschreibung | Fachbegriff | Beispiel |
|---|
| HTLWDANR | optional | VARCHAR(25) | Goods receipt notification number | Referenz auf die Wareneingangsmeldung |
|
|
|
| Grouping of payment and settlement details (required) |
|---|
| Column name | Status | Column definition | Column description | Technical term | Example |
|---|
| HTZGPCID | required | VARCHAR(15) | Creditor ID | Identification of the creditor |
| | HTZGPZR | recommended | VARCHAR(200) | Intended purpose | Intended use |
| | HTZGPTC | optional | VARCHAR(5) | Tax Currency Code | Code for the currency of the VAT accounting transaction |
| | HTZGPIC | required | VARCHAR(5) | Invoice Currency Code | Code for the invoicing currency |
|
| Creditor (optional) |
|---|
| Column name | Status | Column definition | Column description | Technical term | Example |
|---|
| HTZPRDREID | optional | VARCHAR(35) | Identifier of the Payment Receiver | Identification of the different payee |
| | HTZPRDGLN | optional* | VARCHAR(35) | Global identifier of the Payment Receiver | Global identifier of the different payee |
| | HTZPRDGLNT | required if HTZPRDGLN is filled.** | CHAR(5) | Type of global Identifier | Identification of the scheme | 0021 : SWIFT 0088 : EAN 0060 : DUNS 0177 : ODETTE other codes in the code list | | HTZPRDREC | required | VARCHAR(255) | Company/Name of the Payment Receiver | Name/name of the payee |
|
| Details of the organisation (optional) |
|---|
| Column name | Status | Column definition | Column description | Technical term | Example |
|---|
HTZPROID | optional | VARCHAR(35) | Identifier of the Organization | Identification of the legal registration of the payee |
| HTZPROIDT | optional | VARCHAR(10) | Type of Organization Identifier | Identification of the scheme | Codes can be found in the ISO/IEC 6523 code list | HTZPROTRBN | optional | VARCHAR(50) | Trading Business name | Trade name |
|
|
|
| Payment instructions (optional) |
|---|
| Note table ZF2INVPT. |
| Sales tax breakdown (required) |
|---|
| Observe table ZF2INVTI. |
| Detailed information on the accounting period (optional) |
|---|
| Column name | Status | Column definition | Column description | Technical term | Example |
|---|
| HTZBILLBP | optional | VARCHAR(15) | Beginning of the accounting period | Start of the financial period |
| | HTZBILLBPF | required if HTZBILLBP is filled.* | CHAR(3) | Date Format | Date, Format | 102 | | HTZBILLEP | optional | VARCHAR(15) | End of the accounting | End of the financial period |
| | HTZBILLEPF | required if HTZBILLEP is filled.* | CHAR(3) | Date Format | Date, Format | 102 |
|
| Surcharges and discounts at document level (optional) |
|---|
| Observe table ZF2INVAC. |
| Detailed information on payment conditions (optional) |
|---|
| Note table ZFINVTP. |
| Total sums at document level (required) |
|---|
| Column name | Status | Column definition | Column description | Technical term | Example |
|---|
| HTZTSMSLT | required | DECIMAL(15, 2) | Total amount of positions | Sum of the net amounts of all invoice items | 6913.60 | | HTZTSMSCT | optional | DECIMAL(15, 2) | Total amount of surcharges | Total surcharges at document level | 0.00 | | HTZTSMSAT | optional | DECIMAL(15, 2) | Total amounts of discounts | Total discounts at document level | 0.00 | | HTZTSMSTB1 | required | DECIMAL(15, 2) | Tax basic amount 1 | Total invoice amount without sales tax 1 | 6913.60 | | HTZTSMSTT1 | optional | DECIMAL(15, 2) | Tax total amount 1 | Total invoice VAT amount Total tax amount in accounting currency 1 | 1313.58 | | HTZTSMSRA | optional | DECIMAL(15, 2) | Rounding amount | Rounding amount |
| | HTZTSMSGT1 | required | DECIMAL(15, 2) | Grand total amount 1 | Total invoice amount including VAT 1 | 8227.18 | | HTZTSMSTPA | optional | DECIMAL(15, 2) | Deposit amount | Advance payment amount | 0.00 | | HTZTSMSDPA | required | DECIMAL(15, 2) | Payment amount | Amount due for payment | 8227.18 |
|
| Reference to previous invoices (optional) |
|---|
| Column name | Status | Column definition | Column description | Technical term | Example |
|---|
| HTZIRDIAID | required | VARCHAR(35) | Number of previous invoice | Number of the previous invoice |
| | HTZIRDFIDT | optional | DATE '0001-01-01' | Invoice Date of previous invoice | Date of invoice |
|
|
| Detailed information on the booking reference (optional) |
|---|
| Note table ZF2INVBR. |
|
|
|
| I-Effekt Felder |
|---|
| Column name | Status | Column definition | Column description | Technical term | Example |
|
|
|
|
|
|
|
|
|---|
| HTSTATE |
| VARCHAR(1) | State of Order | Status column | Empty string = Not processed, 1 = Processed |
|
|
|
|
|
|
|
| | HTSESSUM |
| DECIMAL(15, 0) | i-effect Session Number | i-effect session number |
|
|
|
|
|
|
|
|
| | HTPROCNUM |
| DECIMAL(15, 0) | i-effect File Process Number | i-effect file process number |
|
|
|
|
|
|
|
|
| | EXTERNAL_RECIPIENT | x |
| CHAR(255) | External recipient for SNDFILE | i-effect recipient from partner master data |
|
|
|
|
|
|
|
| | EXTERNAL_ORIGINATOR | x |
| CHAR(255) | External originator für SNDFILE | i-effect originator from partner master data |
|
|
|
|
|
|
|
|
|
*Field is not required in the UBL format of the X calculation
**Field is optional in UBL format of the X calculation
