ZF2INVTX - General free texts
Header
Column name | In use? | Status | Column definition | Column description | Fachbegriff | Example |
|---|---|---|---|---|---|---|
| TXKEY | x | required | VARCHAR(15) | Internal pagination number | Internal invoice number (i-effect column) | |
| TXREF | x | required | DECIMAL(5, 0) | Reference ID to the Specified Table | Reference to the tables (i-effect column) | 0 = Document header/footer |
| TXLFD | x | required | DECIMAL(5, 0) | Order of the text | Order of the texts (i-effect column) | |
| TXQKEY | x | optional | VARCHAR(3) | Qualification of the text | Free text at document level (qualification of the text) | ST3 |
| TXTEXT | x | required | VARCHAR(1024) | Free text | Free text for the invoice (text content) | Billing as discussed with Mrs. Sample Woman. There are discounts and bonus agreements. |
| TXQKEYT | x | optional | VARCHAR(3) | Qualification of text type | Code for qualifying the free text for the invoice (code for type) | AAI : General Information SUR : Remarks of the seller REG : Regulatory information ABL : Legal information TXD : Information about the tax CUS : Customs information |
Position
Column name | In use? | Status | Column definition | Column description | Technical term | Example |
|---|---|---|---|---|---|---|
| TXKEY | x | required | VARCHAR(15) | Internal pagination number | Internal invoice number (i-effect column) | |
| TXREF | x | required | DECIMAL(5, 0) | Reference ID to the Specified Table | Reference to the tables (i-effect column) ZFINVOICPI (PIREF) | |
| TXLFD | x | required | DECIMAL(5, 0) | Order of the text | Order of the texts (i-effect column) | |
| TXQKEY | x | optional | VARCHAR(3) | Qualification of the text | Free text for position (code for content) | ST3 |
| TXTEXT | x | required | VARCHAR(1024) | Free text | Free text for the invoice item (text content) | Billing as discussed with Mrs. Sample Woman. There are discounts and bonus agreements. |
| TXQKEYT | x | optional | VARCHAR(3) | Qualification of text type | Free text for position (code for type) | AAI : General Information SUR : Remarks of the seller REG : Regulatory information ABL : Legal information TXD : Information about the tax CUS : Customs information |