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.
| ||||||||||||||||||||||
HTNBPROCESS | required | VARCHAR(255) | Business process type or data standard |
| ||||||||||||||||||||||
HTNAPPFMT | required | VARCHAR(10) | Format |
| ||||||||||||||||||||||
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 | ||||||||||||||||||||||
HTNAPPVER | required | VARCHAR(10) | Version |
| ||||||||||||||||||||||
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.
| ||||||||||||||||||||||
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 | ||||||||||||||||||||||
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 |