ZF23INVIP - Detailinformationen zu enthaltenen Produkten
Diese Datenbanktabelle besteht aus den folgenden Feldern
Spaltenname | Status | Spaltendefinition | Fachbegriff | Beschreibung |
|---|---|---|---|---|
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 | 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 | 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 |