ZF23INVTX - General free texts
This database table consists of the following fields
Column Name | Status | Column definition | Technical term | Description |
|---|---|---|---|---|
TXKEY | required | VARCHAR(15) | Reference to ZF23INVHT.HTKEY | Unique auto generated identifier |
TXREF | required | INTEGER(4) | Reference ID to the Parent Table | Reference to the Head (“0”) or the line item (<> “0”) |
TXLFD | required | DECIMAL(5) | Order of the text | Order of texts (i-effect column) |
TXQKEY | optional | VARCHAR(255) | Free text on line level (code) | A code to classify the content of the invoice note. |
TXTEXT | required | VARCHAR(1024) | Invoice note | A textual note that gives unstructured information that is relevant to the Invoice as a whole. |
TXQKEYT | optional | VARCHAR(3) | Invoice note subject code | The subject of the textual note in BT-22. |
The following list contains the business rule numbers corresponding to the fields, the XML target elements and further explanations.
Column name | XML Element | EN16931-ID | Example |
|---|---|---|---|
TXQKEY | /rsm:CrossIndustryInvoice/rsm:SupplyChainTradeTransaction/ram:IncludedSupplyChainTradeLineItem/ram:AssociatedDocumentLineDocument/ram:IncludedNote/ram:ContentCode | BT-X-9 | The code is agreed bilaterally and must have the same meaning as BT-127. |
TXTEXT | /rsm:CrossIndustryInvoice/rsm:ExchangedDocument/ram:IncludedNote/ram:Content | BT-22 | Such as the reason for any correction or assignment note in case the invoice has been factored. |
TXQKEYT | /rsm:CrossIndustryInvoice/rsm:ExchangedDocument/ram:IncludedNote/ram:SubjectCode | BT-21 | To be chosen from the entries in UNTDID 4451 [6]. |