ZF2INVIP - Detailed information on included products (Zugferd 2.2.0 + XRechnung)
Column name | Status | Column definition | Technical term | Column description | XML Element | EN16931-ID | Example |
|---|---|---|---|---|---|---|---|
IPKEY | required | VARCHAR(15) | Internal pagination number | Internal invoice number (i-effect column) | |||
IPREF | required | DECIMAL(5, 0) | Reference ID to the Specified Table | Reference to table | 1 | ||
IPLFD | required | DECIMAL(5, 0) | Order of the included Products | Order of the items included | 1 | ||
IPPGIC | optional | VARCHAR(35) | Global identifier of the Product | Global identifier of the product | GlobalID | 4000001000005 (GTIN) | |
IPPSID | Required if IPPGIC is filled in. | CHAR(5) | Type of global article number | Type of global item number | schemeID | ||
IPPSAIC | optional | VARCHAR(35) | SKU Seller | Seller's item number | SellerAssignedID | ||
IPPBAIC | optional | VARCHAR(35) | SKU Buyer | Buyer's item number | BuyerAssignedID | ||
IPPNAME | required | VARCHAR(55) | Name of the Included Product | item description | Name | ||
IPPDESC | optional | VARCHAR(55) | Description of the Included Product | Product description | Description | ||
IPPUQC | optional | DECIMAL(15, 4) | Contained amount | Quantity, included | UnitQuantity | ||
IPPUQUC | Required if IPPUQC is filled. | CHAR(5) | Unit of measurement | Unit of measurement | unitCode |