| Name | Description | Type | Additional information |
|---|---|---|---|
| booking_id | integer |
None. |
|
| CN_NUMBER | string |
None. |
|
| Reference_No | string |
None. |
|
| booking_date | date |
None. |
|
| master_product | string |
None. |
|
| product_id | integer |
None. |
|
| servcie_id | integer |
None. |
|
| service_name | string |
None. |
|
| DetailEmailNotifyId | integer |
None. |
|
| DetailEmailNotifyText | string |
None. |
|
| payment_id | integer |
None. |
|
| client_id | integer |
None. |
|
| origin_country_id | integer |
None. |
|
| origin_city_id | integer |
None. |
|
| origin_city_name | string |
None. |
|
| destination_country_id | integer |
None. |
|
| destination_city_id | integer |
None. |
|
| destination_city_name | string |
None. |
|
| pcs | decimal number |
None. |
|
| weight | decimal number |
None. |
|
| packet_contents | string |
None. |
|
| shipper_address_type | integer |
None. |
|
| shipper_name | string |
None. |
|
| shipper_company | string |
None. |
|
| shipper_address1 | string |
None. |
|
| shipper_address2 | string |
None. |
|
| shipper_address3 | string |
None. |
|
| shipper_sim_carrier | integer |
None. |
|
| shipper_cell | string |
None. |
|
| shipper_phone | string |
None. |
|
| shipper_province | string |
None. |
|
| shipper_cnic | string |
None. |
|
| shipper_email_address | string |
None. |
|
| consignee_address_type | integer |
None. |
|
| consignee_name | string |
None. |
|
| consignee_company | string |
None. |
|
| consignee_address1 | string |
None. |
|
| consignee_address2 | string |
None. |
|
| consignee_address3 | string |
None. |
|
| consignee_sim_carrier | integer |
None. |
|
| consignee_cell | string |
None. |
|
| consignee_phone | string |
None. |
|
| consignee_province | integer |
None. |
|
| consignee_postalcode | integer |
None. |
|
| consignee_cnic | string |
None. |
|
| consignee_email_address | string |
None. |
|
| base_rate | decimal number |
None. |
|
| service_charges | decimal number |
None. |
|
| vas_charges | decimal number |
None. |
|
| raf_charges | decimal number |
None. |
|
| other_charges | decimal number |
None. |
|
| mtd_charges | decimal number |
None. |
|
| partner_amount | decimal number |
None. |
|
| partner_comission | decimal number |
None. |
|
| declare_value | decimal number |
None. |
|
| premimum_amount | decimal number |
None. |
|
| insured_items | integer |
None. |
|
| fuel_charges | decimal number |
None. |
|
| gst_amount | decimal number |
None. |
|
| discount_type | decimal number |
None. |
|
| discount_percent | decimal number |
None. |
|
| discount_amount | decimal number |
None. |
|
| mtd_date | string |
None. |
|
| mtd_time_slot | string |
None. |
|
| user_id | integer |
None. |
|
| booking_route | integer |
None. |
|
| create_date | date |
None. |
|
| transmission_flag | boolean |
None. |
|
| latitude | string |
None. |
|
| longitude | string |
None. |
|
| Lut | integer |
None. |