ZF23INVPP - Product attributes
This database table consists of the following fields
Column Name | Status | Column definition | Technical term | Description |
|---|---|---|---|---|
PPKEY | required | VARCHAR(15) | Reference to ZF23INVHT.HTKEY | Unique auto generated identifier |
PPREF | required | v | 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 | Order of product properties |
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 | If PPCVM is filled in, then this field is required. | CHAR(3) | Unit of measure | |
PPCVT | required | VARCHAR(200) | Item attribute value | The value of the attribute or property of the item. |
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 |
|---|---|---|---|
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". |