This database table consists of the following fields
|
Column Name |
Status |
Column definition |
Technical term |
Description |
|---|---|---|---|---|
|
PCKEY |
required |
VARCHAR(15) |
Reference ID head |
Reference to ZF23INVHT.HTKEY |
|
PCREF |
required |
INTEGER(4, 0) |
Reference ID line item |
Reference to the Head (“0”) or reference to ZF23INVPI.PILFD |
|
PCLFD |
required |
DECIMAL(5, 0) |
Order of the Product Classification |
Sequence of records within PCKEY, PCREF |
|
PCCCC |
required |
VARCHAR(35) |
Item classification identifier |
A code for classifying the item by its type or nature. |
|
PCLIID |
required |
CHAR(4) |
Scheme identifier |
The identification scheme identifier of the Item classification identifier |
|
PCLIVEID |
optional |
CHAR(4) |
Scheme version identifer |
The version of the identification scheme. |
|
PCCCI |
optional |
VARCHAR(25) |
Classification name |
Name used to classify an item according to its type or nature. |
The following list contains the business rule numbers corresponding to the fields, the XML target elements and further explanations.
|
Column name |
XML Element |
EN16931-ID |
Example |
Info |
|---|---|---|---|---|
|
PCCCC |
/rsm:CrossIndustryInvoice/rsm:SupplyChainTradeTransaction/ram:IncludedSupplyChainTradeLineItem/ram:SpecifiedTradeProduct/ram:DesignatedProductClassification/ram:ClassCode |
BT-158 |
Classification codes are used to allow grouping of similar items for a various purposes e.g. public procurement (CPV), e-Commerce (UNSPSC) etc. |
|
|
PCLIID |
/rsm:CrossIndustryInvoice/rsm:SupplyChainTradeTransaction/ram:IncludedSupplyChainTradeLineItem/ram:SpecifiedTradeProduct/ram:DesignatedProductClassification/ram:ClassCode/@listID |
BT-158-1 |
The identification scheme shall be chosen from the entries in UNTDID 7143 [6]. |
|
|
PCLIVEID |
/rsm:CrossIndustryInvoice/rsm:SupplyChainTradeTransaction/ram:IncludedSupplyChainTradeLineItem/ram:SpecifiedTradeProduct/ram:DesignatedProductClassification/ram:ClassCode/@listVersionID |
BT-158-2 |
|
|
|
PCCCI |
/rsm:CrossIndustryInvoice/rsm:SupplyChainTradeTransaction/ram:IncludedSupplyChainTradeLineItem/ram:SpecifiedTradeProduct/ram:DesignatedProductClassification/ram:ClassName |
BT-X-13 |
|
|