i-effect Manual

ZF2INVPC - Detailed information about product classification


Column name

In use?

Status

Column definition

Column description

Technical term

Example

PCKEY

x


VARCHAR(15)

Internal pagination number

Internal invoice number (i-effect column)


PCREF

x


 DECIMAL(5, 0)

Reference ID to the Specified Table

Reference to table

ZFINVOICPI (PIREF)

1

PCLFD

x


 DECIMAL(5, 0)

Order of the Product Classification

Order of classification

1

PCCCC

x

required

VARCHAR(35)

Classification of the Product(Code)

Identification of the article classification


PCLIID

x

required

CHAR(4)

ListID of Product Classification

Identification of the scheme


PCLIVEID

x

optional

CHAR(4)

ListVersionID of Product Classification

Version of the schema

2013

PCCCI



VARCHAR(25)

Name of Product Classification

Classification name

GPC, ECL, UNSPSC