ZF2INVTX - General free texts
Column name | Status | Column definition | Column description | Technical term | Example |
|---|---|---|---|---|---|
TXKEY | required | VARCHAR(15) | Internal pagination number | Reference to ZF2INVHT.HTKEY | 132 |
TXREF | Example | DECIMAL(5, 0) | Reference ID to the Specified Table | Referencing the tables (i-effect column) | TXREF = 0 : Document header/footer TXREF >= 1 : Position |
TXLFD | Example | DECIMAL(5, 0) | Order of the text | Order of texts (i-effect column) | <sequential number> |
Allgemeine Freitexte
Column name | TXREF = 0 | TXREF >= 1 | Column definition | Column description | Technical term | Example |
|---|---|---|---|---|---|---|
TXTEXT | Example | optional | VARCHAR(1024) | Free text | Free text for the invoice (text content) | Invoicing as discussed with Ms. Musterfrau. Discounts and bonus agreements are in place. |
TXQKEYT | optional |
| VARCHAR(3) | Qualification of text type | Code for qualifying the free text for the invoice (code for type) | AAI: General information SUR: Seller remarks EG: Regulatory information ABL: Legal information TXD: Tax information CUS: Customs information Further codes can be found in the code list. |
Dieses Feld wird für die jeweilige Referenz nicht benötigt