|
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 |
|