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