Invoices
The table below describes the Invoices table in the Minimal database schema.
This table contains the following virtual tables:
This table contains the following foldable columns:
- Entity_Id
- Base_Currency_Code
- Base_Discount_Amount
- Base_Discount_Tax_Compensation_Amount
- Base_Grand_Total
- Base_Shipping_Amount
- Base_Shipping_Discount_Tax_Compensation_Amnt
- Base_Shipping_Incl_Tax
- Base_Shipping_Tax_Amount
- Base_Subtotal
- Base_Subtotal_Incl_Tax
- Base_Tax_Amount
- Base_To_Global_Rate
- Base_To_Order_Rate
- Base_Total_Refunded
- Billing_Address_Id
- Can_Void_Flag
- Created_At
- Discount_Amount
- Discount_Description
- Discount_Tax_Compensation_Amount
- Email_Sent
- Global_Currency_Code
- Grand_Total
- Increment_Id
- Is_Used_For_Refund
- Order_Currency_Code
- Order_Id
- Shipping_Address_Id
- Shipping_Amount
- Shipping_Discount_Tax_Compensation_Amount
- Shipping_Incl_Tax
- Shipping_Tax_Amount
- State
- Store_Currency_Code
- Store_Id
- Store_To_Base_Rate
- Store_To_Order_Rate
- Subtotal
- Subtotal_Incl_Tax
- Tax_Amount
- Total_Qty
- Transaction_Id
- Updated_At
| Column Name | SQL Type | Updatable | Nullable | Returnable |
|---|---|---|---|---|
|
Entity_Id Primary Key Foreign Key linked to column Entity_Id in Orders table |
SQL_INTEGER(unsigned) | False | False | True |
|
Base_Currency_Code |
SQL_VARCHAR(255) | True | True | False |
|
Base_Discount_Amount |
SQL_NUMERIC(12,4) | True | True | False |
|
Base_Discount_Tax_Compensation_Amount |
SQL_NUMERIC(12,4) | True | True | False |
|
Base_Grand_Total |
SQL_NUMERIC(12,4) | True | True | False |
|
Base_Shipping_Amount |
SQL_NUMERIC(12,4) | True | True | False |
|
Base_Shipping_Discount_Tax_Compensation_Amnt |
SQL_NUMERIC(12,4) | True | True | False |
|
Base_Shipping_Incl_Tax |
SQL_NUMERIC(12,4) | True | True | False |
|
Base_Shipping_Tax_Amount |
SQL_NUMERIC(12,4) | True | True | False |
|
Base_Subtotal |
SQL_NUMERIC(12,4) | True | True | False |
|
Base_Subtotal_Incl_Tax |
SQL_NUMERIC(12,4) | True | True | False |
|
Base_Tax_Amount |
SQL_NUMERIC(12,4) | True | True | False |
|
Base_To_Global_Rate |
SQL_NUMERIC(12,4) | True | True | False |
|
Base_To_Order_Rate |
SQL_NUMERIC(12,4) | True | True | False |
|
Base_Total_Refunded |
SQL_NUMERIC(12,4) | True | True | False |
|
Billing_Address_Id |
SQL_INTEGER(signed) | True | True | False |
|
Can_Void_Flag |
SQL_BIT | True | True | False |
|
Created_At |
SQL_TIMESTAMP | True | True | False |
|
Discount_Amount |
SQL_NUMERIC(12,4) | True | True | False |
|
Discount_Description |
SQL_VARCHAR(3000) | True | True | False |
|
Discount_Tax_Compensation_Amount |
SQL_NUMERIC(12,4) | True | True | False |
|
Email_Sent |
SQL_INTEGER(unsigned) | True | True | False |
|
Global_Currency_Code |
SQL_VARCHAR(255) | True | True | False |
|
Grand_Total |
SQL_NUMERIC(12,4) | True | True | False |
|
Increment_Id |
SQL_VARCHAR(255) | True | True | False |
|
Is_Used_For_Refund |
SQL_BIT | True | True | False |
|
Order_Currency_Code |
SQL_VARCHAR(255) | True | True | False |
|
Order_Id |
SQL_INTEGER(unsigned) | True | True | False |
|
Shipping_Address_Id |
SQL_INTEGER(signed) | True | True | False |
|
Shipping_Amount |
SQL_NUMERIC(12,4) | True | True | False |
|
Shipping_Discount_Tax_Compensation_Amount |
SQL_NUMERIC(12,4) | True | True | False |
|
Shipping_Incl_Tax |
SQL_NUMERIC(12,4) | True | True | False |
|
Shipping_Tax_Amount |
SQL_NUMERIC(12,4) | True | True | False |
|
State |
SQL_INTEGER(signed) | True | True | False |
|
Store_Currency_Code |
SQL_VARCHAR(255) | True | True | False |
|
Store_Id |
SQL_INTEGER(unsigned) | True | True | False |
|
Store_To_Base_Rate |
SQL_NUMERIC(12,4) | True | True | False |
|
Store_To_Order_Rate |
SQL_NUMERIC(12,4) | True | True | False |
|
Subtotal |
SQL_NUMERIC(12,4) | True | True | False |
|
Subtotal_Incl_Tax |
SQL_NUMERIC(12,4) | True | True | False |
|
Tax_Amount |
SQL_NUMERIC(12,4) | True | True | False |
|
Total_Qty |
SQL_NUMERIC(12,4) | True | True | False |
|
Transaction_Id |
SQL_VARCHAR(255) | True | True | False |
|
Updated_At |
SQL_TIMESTAMP | True | True | False |