ZF23INVPP - Artikelattribute
Diese Datenbanktabelle besteht aus den folgenden Feldern
Spaltenname | Status | Spaltendefinition | Fachbegriff | Beschreibung |
|---|---|---|---|---|
PPKEY | required | VARCHAR(15) | Reference to ZF23INVHT.HTKEY | Unique auto generated identifier |
PPREF | required | INTEGER(4, 0) | Reference ID to the Parent Table | Reference to the Head (“0”) or the line item (<> “0”) |
PPLFD | required | DECIMAL(5, 0) | Order of the Product Characteristic | Reihenfolge des Produkteigenschaft |
PPCTC | required | VARCHAR(35) | Item Attribute Type (Code) | |
PPDESC | required | VARCHAR(55) | Item attribute name | The name of the attribute or property of the item. |
PPCVM | optional | INTEGER(4, 0) | Item Attribute Value (numerical measurand) | |
PPCVMC | Wenn PPCVM gefüllt ist, dann ist dieses Feld required. | CHAR(3) | Unit of measure | |
PPCVT | required | VARCHAR(200) | Item attribute value | The value of the attribute or property of the item. |
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 |
|---|---|---|---|
PPCTC | /rsm:CrossIndustryInvoice/rsm:SupplyChainTradeTransaction/ram:IncludedSupplyChainTradeLineItem/ram:SpecifiedTradeProduct/ram:ApplicableProductCharacteristic/ram:TypeCode | BT-X-11 | To ensure automated processing of the article attributes without bilateral reconciliation, only values from the code list UNTDED 6313+Factur-X-Extension should be used. |
PPDESC | /rsm:CrossIndustryInvoice/rsm:SupplyChainTradeTransaction/ram:IncludedSupplyChainTradeLineItem/ram:SpecifiedTradeProduct/ram:ApplicableProductCharacteristic/ram:Description | BT-160 | Such as "Colour". |
PPCVM | /rsm:CrossIndustryInvoice/rsm:SupplyChainTradeTransaction/ram:IncludedSupplyChainTradeLineItem/ram:SpecifiedTradeProduct/ram:ApplicableProductCharacteristic/ram:ValueMeasure | BT-X-12 | |
PPCVMC | /rsm:CrossIndustryInvoice/rsm:SupplyChainTradeTransaction/ram:IncludedSupplyChainTradeLineItem/ram:SpecifiedTradeProduct/ram:ApplicableProductCharacteristic/ram:ValueMeasure/@unitCode | BT-X-12-0 | |
PPCVT | /rsm:CrossIndustryInvoice/rsm:SupplyChainTradeTransaction/ram:IncludedSupplyChainTradeLineItem/ram:SpecifiedTradeProduct/ram:ApplicableProductCharacteristic/ram:Value | BT-161 | Such as "Red". |