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 ID head | Reference to ZF23INVHT.HTKEY |
IPREF | required | INTEGER(4, 0) | Reference ID line item | Reference to the Head (“0”) or reference to ZF23INVPI.PILFD |
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 | Info |
|---|---|---|---|---|
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 |