Skip to main content
Skip table of contents

ZF23INVHT - Rechnungskopf

Diese Datenbanktabelle besteht aus den folgenden Feldern

Spaltenname

Status

Spaltendefinition

Fachbegriff

Beschreibung

HTKEY

required

VARCHAR(15)

Internal Pagination Number

Internal Page number

HTPDF

optional

VARCHAR(200)

PDF Name

Name of the generated PDF file (if HTNAPPREF = "ZUGFERD"). If the field is left blank, a default name is generated according to the pattern "ZUGFERD_<invoice number>_timestamp".

HTTEMPLDIR

optional

VARCHAR(100)

Template Directory Name

Name of the folder containing the templates for generating the PDF. If the field is left blank, the standard template included in the delivery will be used.

HTDIRECT

required

CHAR(4)

Direction of the ZUGFeRD

*IN oder *OUT

HTNTESTCH

optional

CHAR(5)

Test Indicator, value

“true” or empty

HTNPROCESS

required

VARCHAR(255)

Rule or standard

Identifies the business process context in which the transaction appears, to enable the Buyer to process the Invoice in an appropriate way.

HTNAPPREF

Content

XRECHNUNG 3.0

urn:cen.eu:en16931:2017#compliant#urn:xoev-de:kosit:standard:xrechnung_3.0

XRECHNUNG 2.3

urn:cen.eu:en16931:2017#compliant#urn:xoev-de:kosit:standard:xrechnung_2.3

XRECHNUNG 2.2

urn:cen.eu:en16931:2017#compliant#urn:xoev-de:kosit:standard:xrechnung_2.2

XRECHNUNG 2.1

urn:cen.eu:en16931:2017#compliant#urn:xoev-de:kosit:standard:xrechnung_2.1

XRECHNUNG 2.0

urn:cen.eu:en16931:2017#compliant#urn:xoev-de:kosit:standard:xrechnung_2.0

XRECHNUNG (Extension)

urn:cen.eu:en16931:2017#compliant#urn:xeinkauf.de:kosit:xrechnung_3.0#conformant#urn:xeinkauf.de:kosit:extension:xrechnung_3.0

ZUGFERD
(Extended Profil)

urn:cen.eu:en16931:2017#conformant#urn:factur-x.eu:1p0:extended

ZUGFERD
(Comfort Profil)

urn:cen.eu:en16931:2017

ZUGFERD
(xRechnung Profil)

urn:cen.eu:en16931:2017#compliant#urn:xeinkauf.de:kosit:xrechnung_3.0

PEPPOL

urn:cen.eu:en16931:2017#compliant#urn:fdc:peppol.eu:2017:poacc:billing:3.0

HTNBPROCESS

required

VARCHAR(255)

Business process type or data standard

HTNAPPREF

Content

XRECHNUNG

urn:fdc:peppol.eu:2017:poacc:billing:01:1.0

ZUGFERD

PEPPOL

urn:fdc:peppol.eu:2017:poacc:billing:01:1.0

HTNAPPFMT

required

VARCHAR(10)

Format

HTNAPPREF

Content

XRECHNUNG

UBL oder CII

ZUGFERD

COMFORT oder EXTENDED oder XRECHNUNG

PEPPOL

UBL

HTNAPPREF

required

VARCHAR(255)

Specification identifier

An identification of the specification containing the total set of rules regarding semantic content, cardinalities and business rules to which the data contained in the instance document conforms.

XRECHNUNG
ZUGFERD
PEPPOL

HTNAPPVER

required

VARCHAR(10)

Version

HTNAPPREF

Content

XRECHNUNG

3.0.2, 3.0.1, 2.3.1, 2.2.0, 2.1.1

ZUGFERD

2.3.2, 2.3.3

PEPPOL

3.0

HTNDOCNR

required

VARCHAR(35)

Invoice number

A unique identification of the Invoice.

HTNDOCTC

required

VARCHAR(255)

Document name

Text is the actual wording of anything written or printed. This EN 16931_ Text. Type is based on the Text. Type as defined in ISO 15000-5:2014, Annex B. Line breaks in the text may be present.

HTNDOCT

required

CHAR(3)

Invoice type code

A code specifying the functional type of the Invoice.

Code

Meaning

380

commercial invoice

381

credit note

384

invoice correction

HTNDOCD

required

DATE '0001-01-01'

Invoice issue date

The date when the Invoice was issued.

HTNMSGFUNC

optional

CHAR(5)

Copy indicator, value

Only required if it is not a multiple item with identical content.

LALLNG

optional

CHAR(3)

Invoice language code

Indicates the language used in the invoice document.

HTNPAYD

required

DATE '0001-01-01'

Contractual due date of the invoice, value

HTGBYREF

optional

VARCHAR(46)

Buyer reference

An identifier assigned by the Buyer used for internal routing purposes.

HTGDPTERM

optional

VARCHAR(3)

Delivery condition (Code)

The code specifying the type of delivery for these trade delivery terms.

HTGORDERNR

required

VARCHAR(35)

Sales order reference

An identifier of a referenced sales order, issued by the Seller.

HTGORDERD

optional

DATE '0001-01-01'

Order confirmation date, value

Details zum Auftragsbestätigungsdatum

HTGCORDNR

required

VARCHAR(35)

Purchase order reference

An identifier of a referenced purchase order, issued by the Buyer.

HTGCORDD

optional

DATE '0001-01-01'

Order Date, value

HTGCONTRNR

required

VARCHAR(35)

Contract reference

The identification of a contract.

HTGCONTRD

optional

DATE '0001-01-01'

Contract date, value

HTSPPID

required

VARCHAR(1000)

Project reference

The identification of the project the invoice refers to.

HTSPPNA

required

VARCHAR(35)

Project name

The identification of the project the invoice refers to

HTLDTD

required

DATE '0001-01-01'

Actual delivery date

The date on which the supply of goods or services was made or completed.

HTLDANR

required

VARCHAR(25)

Despatch advice reference

An identifier of a referenced despatch advice.

HTLDALD

optional

DATE '0001-01-01'

Despatch advice date, value

HTLWDANR

required

VARCHAR(25)

Receiving advice reference

An identifier of a referenced receiving advice.

HTLWDALD

optional

DATE '0001-01-01'

Goods receipt date, value

HTLDLSNR

required

VARCHAR(25)

Delivery note reference

HTLDLSD

optional

DATE '0001-01-01'

Delivery note date, value

HTZGPCID

optional

VARCHAR(35)

Creditor ID, Bank assigned creditor identifier

Kennung des Gläubigers
Unique banking reference identifier of the Payee or Seller assigned by the Payee or Seller bank.

HTZGPZR

empfohlen

VARCHAR(200)

Remittance information

A textual value used to establish a link between the payment and the Invoice, issued by the Seller.

HTZGPTC

optional

CHAR(5)

VAT accounting currency code

The currency used for VAT accounting and reporting purposes as accepted or required in the country of the Seller.

HTZGPIC

required

CHAR(5)

Invoice currency code

The currency in which all Invoice amounts are given, except for the Total VAT amount in accounting currency.

HTZGPIRN

optional

INTEGER(4)

Seller reference number

HTZTASC

required

CHAR(5)

Invoice currency

HTZTATC

required

CHAR(5)

Local currency

HTZTACR

required

DECIMAL(10)

Exchange rate

HTZTACD

optional

DATE '0001-01-01'

Exchange rate date, value

HTZBILLPD

optional

VARCHAR(50)

Invoicing period description (free text)

HTZBILLBP

optional

VARCHAR(15)

Invoicing period start date

The date when the Invoice period starts.

HTZBILLBPF

required wenn HTZBILLBP gefüllt ist.

CHAR(3)

Date, format

HTZBILLEP

optional

VARCHAR(15)

Invoicing period end date

The date when the Invoice period ends.

HTZBILLEPF

required wenn HTZBILLEP gefüllt ist.

CHAR(3)

Date, format

HTZTSMSLT

required

DECIMAL(15)

Sum of Invoice line net amount

Sum of all Invoice line net amounts in the Invoice.

HTZTSMSCT

optional

DECIMAL(15)

Sum of charges on document level

Sum of all charges on document level in the Invoice.

HTZTSMSAT

optional

DECIMAL(15)

Sum of allowances on document level

Sum of all allowances on document level in the Invoice.

HTZTSMSTB1

required

DECIMAL(15)

Invoice total amount without VAT

The total amount of the Invoice without VAT.

HTZTSMSTB2

optional

DECIMAL(15)

Tax basic amount 2

Rechnungsgesamtbetrag ohne Umsatzsteuer 2

HTZTSMSTT1

required

DECIMAL(15)

Invoice total VAT amount

The total VAT amount for the Invoice.

Invoice currency code

HTZTSMSTT2

optional

DECIMAL(15)

Invoice total VAT amount in accounting currency

The VAT total amount expressed in the accounting currency accepted or required in the country of the Seller.

optional

VAT accounting currency code

HTZTSMSRA

optional

DECIMAL(15)

Rounding amount

The amount to be added to the invoice total to round the amount to be paid.

HTZTSMSGT1

required

DECIMAL(15)

Invoice total amount with VAT

The total amount of the Invoice with VAT.

HTZTSMSGT2

DECIMAL(15)

Invoice total VAT amount in accounting currency

The VAT total amount expressed in the accounting currency accepted or required in the country of the Seller.

HTZTSMSTPA

optional

DECIMAL(15)

Paid amount

The sum of amounts which have been paid in advance.

HTZTSMSDPA

required

DECIMAL(15)

Amount due for payment

The outstanding amount that is requested to be paid.

HTSTATE

VARCHAR(1)

State of Order

Status Spalte

HTSESSUM

DECIMAL(15)

i-effect Session Number

i-effect Sitzungsnummer

EXTERNAL_RECIPIENT

VARCHAR(255)

Externer Empfänger für SNDFILE

i-effect Empfänger aus dem Partnerstamm

EXTERNAL_ORIGINATOR

VARCHAR(255)

Externer Absender für SNDFILE

i-effect Absender aus dem Partnerstamm

JavaScript errors detected

Please note, these errors can depend on your browser setup.

If this problem persists, please contact our support.