client-dispatch
URI: http://test.birdsystem.com/client/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 |
Custom filter fields when query record list :
| 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' |