i-effect Manual

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