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' |