ZF23INVIP - Detailed information on included products
This database table consists of the following fields
Column Name | Status | Column definition | Technical term | Description |
|---|---|---|---|---|
IPKEY | required | VARCHAR(15) | Reference to ZF23INVHT.HTKEY | Unique auto generated identifier |
IPREF | required | INTEGER(4, 0) | Reference ID to the Parent Table | Reference to the Head (“0”) or the line item (<> “0”) |
IPLFD | required | DECIMAL(5, 0) | Order of the included Products | Order of the items included |
IPPSAIC | optional | VARCHAR(35) | SellerAssignedID of Included Referenced Product | An identifier, assigned by the Seller, for the item. |
IPPBAIC | optional | VARCHAR(35) | BuyerAssignedID of Included Referenced Product | An identifier, assigned by the Buyer, for the item. |
IPPNAME | required | VARCHAR(55) | Name of Included Referenced Product | |
IPPDESC | optional | VARCHAR(55) | Description of Included Referenced Product | A description for an item. |
IPPUQC | optional | DECIMAL(15, 4) | UnitQuantity of Included Referenced Product | |
IPPUQUC | required wenn IPPUQC gefüllt ist. | CHAR(5) | Measurement unit |
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 |
|---|---|---|---|
IPPSAIC | /rsm:CrossIndustryInvoice/rsm:SupplyChainTradeTransaction/ram:IncludedSupplyChainTradeLineItem/ram:SpecifiedTradeProduct/ram:IncludedReferencedProduct/ram:SellerAssignedID | BT-X-16 | |
IPPBAIC | /rsm:CrossIndustryInvoice/rsm:SupplyChainTradeTransaction/ram:IncludedSupplyChainTradeLineItem/ram:SpecifiedTradeProduct/ram:IncludedReferencedProduct/ram:BuyerAssignedID | BT-X-17 | |
IPPNAME | /rsm:CrossIndustryInvoice/rsm:SupplyChainTradeTransaction/ram:IncludedSupplyChainTradeLineItem/ram:SpecifiedTradeProduct/ram:IncludedReferencedProduct/ram:Name | BT-X-18 | |
IPPDESC | /rsm:CrossIndustryInvoice/rsm:SupplyChainTradeTransaction/ram:IncludedSupplyChainTradeLineItem/ram:SpecifiedTradeProduct/ram:IncludedReferencedProduct/ram:Description | BT-X-19 | The Item description allows for describing the item and its features in more detail than the Item name. |
IPPUQC | /rsm:CrossIndustryInvoice/rsm:SupplyChainTradeTransaction/ram:IncludedSupplyChainTradeLineItem/ram:SpecifiedTradeProduct/ram:IncludedReferencedProduct/ram:UnitQuantity | BT-X-20 | |
IPPUQUC | /rsm:CrossIndustryInvoice/rsm:SupplyChainTradeTransaction/ram:IncludedSupplyChainTradeLineItem/ram:SpecifiedTradeProduct/ram:IncludedReferencedProduct/ram:UnitQuantity/@unitCode | BT-X-20-1 |