ZF23INVTX - Allgemeine Freitexte
Diese Datenbanktabelle besteht aus den folgenden Feldern
Spaltenname | Status | Spaltendefinition | Fachbegriff | Beispiel |
|---|---|---|---|---|
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 | Reihenfolge der Texte (i-effect Spalte) |
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. |
In der folgenden Auflistung können die zu den Feldern passenden Geschäftsregelnummern, die XML Zielelemente und weitere Erläuterungen entnommen werden
Spaltenname | XML Element | EN16931-ID | Beispiel |
|---|---|---|---|
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]. |