Skip to main content
Skip table of contents

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

JavaScript errors detected

Please note, these errors can depend on your browser setup.

If this problem persists, please contact our support.