Shipment_Items
The table below describes the Shipment_Items table in the Minimal database schema.
This is a virtual table, and is linked to the Shipment table in the Minimal database schema (see Shipment).
None of the columns in this table are updatable.
This table contains the following foldable column:
- Entity_Id
This table does not contain Return Primary Key columns.
| Column Name | SQL Type | Nullable |
|---|---|---|
|
Entity_Id Primary Key Foreign Key linked to column Entity_Id in Shipment table |
SQL_INTEGER(unsigned) | False |
|
Items_Index Primary Key |
SQL_INTEGER(unsigned) | True |
|
Items_Additional_Data |
SQL_VARCHAR(255) | True |
|
Items_Description |
SQL_VARCHAR(3000) | True |
|
Items_Entity_Id |
SQL_INTEGER(unsigned) | True |
|
Items_Name |
SQL_VARCHAR(255) | True |
|
Items_Order_Item_Id |
SQL_INTEGER(unsigned) | True |
|
Items_Parent_Id |
SQL_INTEGER(unsigned) | True |
|
Items_Price |
SQL_NUMERIC(12,4) | True |
|
Items_Product_Id |
SQL_INTEGER(unsigned) | True |
|
Items_Qty |
SQL_NUMERIC(12,4) | True |
|
Items_Row_Total |
SQL_NUMERIC(12,4) | True |
|
Items_Sku |
SQL_VARCHAR(255) | True |
|
Items_Weight |
SQL_NUMERIC(12,4) | True |