Invoices_Items
The table below describes the Invoices_Items table in the Minimal database schema.
This is a virtual table, and is linked to the Invoices table in the Minimal database schema (see Invoices).
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 Invoices table |
SQL_INTEGER(unsigned) | False |
|
Items_Index Primary Key |
SQL_INTEGER(unsigned) | True |
|
Items_Additional_Data |
SQL_VARCHAR(255) | True |
|
Items_Base_Cost |
SQL_NUMERIC(12,4) | True |
|
Items_Base_Discount_Amount |
SQL_NUMERIC(12,4) | True |
|
Items_Base_Discount_Tax_Compensation_Amount |
SQL_NUMERIC(12,4) | True |
|
Items_Base_Price |
SQL_NUMERIC(12,4) | True |
|
Items_Base_Price_Incl_Tax |
SQL_NUMERIC(12,4) | True |
|
Items_Base_Row_Total |
SQL_NUMERIC(12,4) | True |
|
Items_Base_Row_Total_Incl_Tax |
SQL_NUMERIC(12,4) | True |
|
Items_Base_Tax_Amount |
SQL_NUMERIC(12,4) | True |
|
Items_Description |
SQL_VARCHAR(3000) | True |
|
Items_Discount_Amount |
SQL_NUMERIC(12,4) | True |
|
Items_Discount_Tax_Compensation_Amount |
SQL_NUMERIC(12,4) | 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_Price_Incl_Tax |
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_Row_Total_Incl_Tax |
SQL_NUMERIC(12,4) | True |
|
Items_Sku |
SQL_VARCHAR(255) | True |
|
Items_Tax_Amount |
SQL_NUMERIC(12,4) | True |