ZF2INVIP - Detailed information about included products
Column name | In use? | Status | Column definition | Column description | Technical term | Example |
|---|---|---|---|---|---|---|
| IPKEY | x | VARCHAR(15) | Internal pagination number | Internal invoice number (i-effect column) | ||
| IPREF | x | DECIMAL(5, 0) | Reference ID to the Specified Table | Reference to table ZFINVOICPI (PIREF) | 1 | |
| IPLFD | x | DECIMAL(5, 0) | Order of the included Products | Order of the included articles | 1 | |
| IPPGIC | x | optional | VARCHAR(35) | Global identifier of the Product | Global identifier of the product | 4000001000005 (GTIN) |
IPPSID | x | required if IPPGIC is filled. | CHAR(5) | Type of global article number | Type of global article number | |
| IPPSAIC | x | optional | VARCHAR(35) | SKU Seller | Seller's part number | |
| IPPBAIC | x | optional | VARCHAR(35) | SKU Buyer | Item number of the buyer | |
IPPNAME | x | required | VARCHAR(55) | Name of the Included Product | Article description | |
IPPDESC | x | optional | VARCHAR(55) | Description of the Included Product | Article description | |
IPPUQC | x | optional | DECIMAL(15, 4) | Contained amount | Quantity, contained | |
IPPUQUC | x | required if IPPUQC is filled | CHAR(5) | Unit of measurement | Unit of measurement |