ZF23INVPC - Detailed information on product classification
This database table consists of the following fields
Column Name | Status | Column definition | Technical term | Description |
|---|---|---|---|---|
PCKEY | required | VARCHAR(15) | Reference to ZF23INVHT.HTKEY | Unique auto generated identifier |
PCREF | required | INTEGER(4, 0) | Reference ID to the Parent Table | Reference to the Head (“0”) or the line item (<> “0”) |
PCLFD | required | DECIMAL(5, 0) | Order of the Product Classification | Order of classification |
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 |
|---|---|---|---|
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 |