ZF23INVIP - Detailinformationen zu enthaltenen Produkten
Diese Datenbanktabelle besteht aus den folgenden Feldern
Column Name | Status | Column definition | Technical term | Description |
|---|---|---|---|---|
IPKEY | required | VARCHAR(15) | Reference to ZF23INVHT.HTKEY | Unique auto generated identifier |
IPREF | required | DECIMAL(5, 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 | Reihenfolge der inbegriffenen Artikel |
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 |
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 |
|---|---|---|---|
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 |