ZF23INVPC - Detailinformationen zur Produktklassifikation
Diese Datenbanktabelle besteht aus den folgenden Feldern
Spaltenname | Status | Spaltendefinition | Fachbegriff | Beschreibung |
|---|---|---|---|---|
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 | Reihenfolge der Klassikfikation |
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. |
In der folgenden Auflistung können die zu den Feldern passenden Geschäftsregelnummern, die XML Zielelemente und weitere Erläuterungen entnommen werden
Spaltenname | XML Element | EN16931-ID | Beispiel | 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 |