|
Column name |
Status |
Column definition |
Technical term |
Column description |
XML Element |
EN16931-ID |
Example |
|---|---|---|---|---|---|---|---|
|
PCKEY |
required |
VARCHAR(15) |
Internal pagination number |
Internal invoice number (i-effect column) |
|
|
|
|
PCREF |
required |
DECIMAL(5, 0) |
Reference ID to the Specified Table |
Reference to table
|
|
|
1 |
|
PCLFD |
required |
DECIMAL(5, 0) |
Order of the Product Classification |
Order of classification |
|
|
1 |
|
PCCCC |
required |
VARCHAR(35) |
Classification of the Product(Code) |
Article classification identifier |
ClassCode |
BT-158 |
|
|
PCLIID |
required |
CHAR(4) |
ListID of Product Classification |
Identification of the scheme |
listID |
BT-158-1 |
|
|
PCLIVEID |
optional |
CHAR(4) |
ListVersionID of Product Classification |
Version of the schema |
listVersionID |
BT-158-2 |
2013 |
|
PCCCI |
optional |
VARCHAR(25) |
Name of Product Classification |
Classification name |
ClassName |
|
GPC, ECL, UNSPSC |