client-dispatch

Field	Usage	Mandatory	Data Type
id	ID		INT(10)
warehouse_id_origination	Original Warehouse ID	YES	INT(10)
warehouse_id_destination	Destination Warehouse ID	YES	INT(10)
warehouse_dispatch_freight_id	Warehouse Dispatch Fright ID	YES	INT(10)
client_vat_number_id	Client VAT Number ID		INT(10)
client_dispatch_delivery_type_id	Client Dispatch Delivery Type ID	YES	INT(10)
final_freight_method	Final freight Method	YES	ENUM('EXPRESS','AIR','SEA','OTHER')
reference	Client Dispatch Reference		VARCHAR(250)
delivery_reference	Delivery Reference		VARCHAR(50)
delivery_time	Estimated delivery time from Client		TIMESTAMP
confirm_delivery_time	Confirmed delivery time from Client		TIMESTAMP
type	Client Dispatch Type	YES	ENUM('NORMAL','TRANSFER')
client_dispatch_final_address_contact	Final address contact		VARCHAR(50)
client_dispatch_final_address_business_name	Final address business name		VARCHAR(50)
final_address_line1	Final address line 1		VARCHAR(100)
final_address_line2	Final address 2		VARCHAR(100)
final_address_line3	Final address 3		VARCHAR(100)
client_dispatch_final_address_city	Final address city		VARCHAR(50)
client_dispatch_final_address_county	Final address county		VARCHAR(50)
client_dispatch_final_address_post_code	Final address post code		VARCHAR(10)
client_dispatch_final_address_country_iso	Final address country ISO code		CHAR(2)
client_dispatch_final_address_telephone	Final address telephone number		VARCHAR(50)
client_dispatch_final_address_email	Final address contact email		VARCHAR(50)
note	Note		TEXT

fields

note

type

status

the status of client dispath

string，range list: 'DELETED','PREPARING','REVIEWING','DISPATCHED','FINISHED','CLIENT_PREPARING','PENDING','PROCESSING',

'PRECHECKING','PRECHECK_NOT_PASSED','PRECHECK_PASSED','CLIENT_DISPATCHED','LOCAL_WAREHOUSE_RECEIVED','LOCAL_WAREHOUSE_CHECK_NOT_PASS',

'LOCAL_WAREHOUSE_CHECK_PASSED','LOCAL_WAREHOUSE_DISPATCHED','LOCAL_WAREHOUSE_PALLETED','CUSTOMS_CLEARING','DESTINATION_WAREHOUSE_RECEIVED',

'DESTINATION_WAREHOUSE_STOCKED','LOCAL_WAREHOUSE_ALLOCATED','LOCAL_WAREHOUSE_TRUCK_LOADED','SAILED',

'ARRIVED_DESTINATION_PORT','CUSTOMS_CLEARED'

type

the type of client dispatch

string，range list: 'NORMAL','TRANSFER','SPONTANEOUS','CLIENT_TRANSFER'