If you want to create a XRechnung, fill in the tables below with your data. If you need help with the filling, please contact the support .
|
XRechnung
|
|
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
|
XRechnung
|
|
|
|
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
