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 |
Sequence of records within IPKEY, IPREF |
|
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 |
|