Head
|
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) |
0 = Document header/foot |
|
TXLFD |
x |
required |
DECIMAL(5, 0) |
Order of the text |
Order of the texts (i-effect column) |
|
|
TXQKEY |
|
|
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 |
Positions
|
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 |
|
|
VARCHAR(3) |
Qualification of the text |
Free text for position (code for content) |
ST3 |
|
TXTEXT |
|
|
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 |