Fulfillment_Orders
The table below describes the Fulfillment_Orders table.
This table contains the following virtual table:
None of the columns in this table are nullable.
None of the columns in this table are foldable.
This table does not contain Return Primary Key columns.
| Column Name | SQL Type | Updatable |
|---|---|---|
|
fulfillment_order_id Primary Key |
SQL_BIGINT(unsigned) | True |
|
Shop_Id |
SQL_BIGINT(unsigned) | True |
|
address1 |
SQL_VARCHAR(1024) | True |
|
address2 |
SQL_VARCHAR(1024) | True |
|
assigned_location_id |
SQL_BIGINT(unsigned) | True |
|
city |
SQL_VARCHAR(1024) | True |
|
country_code |
SQL_VARCHAR(1024) | True |
|
delivery_method |
SQL_VARCHAR(1024) | True |
|
destination |
SQL_VARCHAR(1024) | True |
|
fulfill_at |
SQL_VARCHAR(1024) | True |
|
fulfillment_service_handle |
SQL_VARCHAR(1024) | True |
|
location_id |
SQL_VARCHAR(1024) | True |
|
name |
SQL_VARCHAR(1024) | True |
|
order_id |
SQL_BIGINT(unsigned) | True |
|
phone |
SQL_VARCHAR(1024) | True |
|
province |
SQL_VARCHAR(1024) | True |
|
request_status |
SQL_VARCHAR(1024) | True |
|
status |
SQL_VARCHAR(1024) | True |
|
zip |
SQL_VARCHAR(1024) | True |