i-effect Manual

ZF23INVIDT - Tax identifications

This database table consists of the following fields

Column Name

Status

Column definition

Technical term

Description

IDTKEY

required

VARCHAR(15)

Reference to ZF23INVHT.HTKEY

Unique auto generated identifier

IDTREF

required

DECIMAL(5, 0)

Reference ID to the Parent Table

Reference to the Head (“0”) or the line item (<> “0”)

IDTGROUP

required

VARCHAR(35)

Code specifying the type of partner details

One of the codes in the table below to indicated what type of partner identification is contained in this record

ID

required

VARCHAR(50)

Tax number


IDTYPE

required

VARCHAR(50)

Type of tax identifier

VA - Value added Tax identifier
FC - Legal Tax number