This database table consists of the following fields
|
Column Name |
Status |
Column definition |
Technical term |
Description |
|---|---|---|---|---|
|
TXKEY |
required |
VARCHAR(15) |
Reference ID head |
Reference to ZF23INVHT.HTKEY |
|
TXREF |
required |
INTEGER(4) |
Reference ID line item |
Reference to the Head (“0”) or reference to ZF23INVPI.PILFD |
|
TXLFD |
required |
DECIMAL(5) |
Order of the text |
Sequence of records within TXKEY, TXREF |
|
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 |
Info |
|---|---|---|---|---|
|
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]. |