SHOW CREATE TABLE fcl_bl;

CREATE TABLE `fcl_bl` (
  `BolId` varchar(50) DEFAULT NULL,
  `Bol` int(20) NOT NULL AUTO_INCREMENT,
  `Bol_date` datetime NOT NULL,
  `BookingNo` varchar(20) DEFAULT NULL,
  `QuuoteNo` varchar(20) DEFAULT NULL,
  `terminal` varchar(200) DEFAULT NULL,
  `PORT` varchar(200) DEFAULT NULL,
  `PortofDischarge` varchar(200) DEFAULT NULL,
  `Vessel` varchar(500) DEFAULT NULL,
  `Voyages` varchar(50) DEFAULT NULL,
  `Shipper_No` varchar(10) DEFAULT NULL,
  `Forward_agent_No` varchar(10) DEFAULT NULL,
  `Streamship_notify_party` varchar(500) DEFAULT NULL,
  `House_Shipper_No` varchar(10) DEFAULT NULL,
  `House_Notify_Party` varchar(500) DEFAULT NULL,
  `steam_ship_bl` varchar(20) DEFAULT NULL,
  `House_BL` varchar(20) DEFAULT NULL,
  `Import_Orgin_BLNo` varchar(30) DEFAULT NULL,
  `Place_of_Reciept` varchar(50) DEFAULT NULL,
  `Point_of_Country_and_Origin` varchar(50) DEFAULT NULL,
  `Forwarding_Agent` varchar(500) DEFAULT NULL,
  `Export_reference` varchar(500) DEFAULT NULL,
  `Domestic_routing` varchar(500) DEFAULT NULL,
  `Transhipment_To` varchar(30) DEFAULT NULL,
  `Onward_Inland_Routing` varchar(800) DEFAULT NULL,
  `Port_of_Loading` varchar(200) DEFAULT NULL,
  `consignee_No` varchar(10) DEFAULT NULL,
  `houseConsignee` varchar(10) DEFAULT NULL,
  `shipper_address` varchar(500) DEFAULT NULL,
  `consignee_address` varchar(500) DEFAULT NULL,
  `house_shipper_address` varchar(500) DEFAULT NULL,
  `house_consignee_address` varchar(500) DEFAULT NULL,
  `streamShipLine` varchar(40) DEFAULT NULL,
  `total` double(10,2) DEFAULT NULL,
  `billTrdPrty` varchar(20) DEFAULT NULL,
  `total_costs` double(10,2) DEFAULT NULL,
  `forwarder_no` varchar(20) DEFAULT NULL,
  `rate_by_agent` varchar(20) DEFAULT NULL,
  `notify_party` varchar(20) DEFAULT NULL,
  `house_notify_party_no` varchar(20) DEFAULT NULL,
  `bill_third_party_address` varchar(200) DEFAULT NULL,
  `total_cost_code` double(10,2) DEFAULT NULL,
  `master_bl` varchar(20) DEFAULT NULL,
  `container_no` varchar(20) DEFAULT NULL,
  `ready_to_post` varchar(5) DEFAULT NULL,
  `status` varchar(20) DEFAULT NULL,
  `bl_terms` varchar(20) DEFAULT NULL,
  `shipment_type` varchar(20) DEFAULT NULL,
  `agent_name` varchar(70) DEFAULT NULL,
  `house_shipper_name` varchar(60) DEFAULT NULL,
  `shipper_name` varchar(60) DEFAULT NULL,
  `consignee_name` varchar(60) DEFAULT NULL,
  `house_consignee_name` varchar(60) DEFAULT NULL,
  `notify_party_name` varchar(60) DEFAULT NULL,
  `house_notify_party_name` varchar(60) DEFAULT NULL,
  `forwarding_agent_name` varchar(60) DEFAULT NULL,
  `original_terminal` varchar(20) DEFAULT NULL,
  `billing_terminal` varchar(100) DEFAULT NULL,
  `third_party_name` varchar(80) DEFAULT NULL,
  `agent_address` varchar(200) DEFAULT NULL,
  `sail_date` datetime DEFAULT NULL,
  `book_no` varchar(20) DEFAULT NULL,
  `original_printing` varchar(4) DEFAULT NULL,
  `non_negotiable_printing` varchar(4) DEFAULT NULL,
  `express_bl_printing` varchar(4) DEFAULT NULL,
  `no_of_originals` varchar(10) DEFAULT NULL,
  `pre_carriage` varchar(50) DEFAULT NULL,
  `pre_carriage_POR` varchar(50) DEFAULT NULL,
  `loading_pier` varchar(50) DEFAULT NULL,
  `shipper_source` varchar(50) DEFAULT NULL,
  `consignee_source` varchar(50) DEFAULT NULL,
  `notifyParty_source` varchar(50) DEFAULT NULL,
  `master_bl_comments` varchar(500) DEFAULT NULL,
  `master_bl_notes` varchar(750) DEFAULT NULL,
  `value_of_goods` varchar(20) DEFAULT NULL,
  `bl_by` varchar(20) DEFAULT NULL,
  `update_by` varchar(20) DEFAULT NULL,
  `bkg_no` int(11) DEFAULT NULL,
  `imports_freight_release` varchar(4) DEFAULT NULL,
  `file_number` varchar(10) DEFAULT NULL,
  `inttra` varchar(10) DEFAULT NULL,
  `ready_to_edi` varchar(10) DEFAULT NULL,
  `bl_audited` varchar(10) DEFAULT NULL,
  `received_master` varchar(10) DEFAULT NULL,
  `bl_closed` varchar(10) DEFAULT NULL,
  `AES` varchar(100) DEFAULT NULL,
  `filetype` varchar(10) DEFAULT NULL,
  `file_no` varchar(10) DEFAULT NULL,
  `ssline_name` varchar(80) DEFAULT NULL,
  `ssline_no` varchar(60) DEFAULT NULL,
  `original_bl_required` varchar(4) DEFAULT NULL,
  `fclbl_clause` varchar(10) DEFAULT NULL,
  `fclbl_clause_description` varchar(500) DEFAULT NULL,
  `print_containers_on_bl` varchar(20) DEFAULT NULL,
  `shipper_loads_and_counts` varchar(20) DEFAULT NULL,
  `print_phrase` varchar(20) DEFAULT NULL,
  `agents_for_carrier` varchar(20) DEFAULT NULL,
  `alternate_pol` varchar(20) DEFAULT NULL,
  `manifest_print_report` varchar(20) DEFAULT NULL,
  `default_agent` varchar(4) DEFAULT NULL,
  `agent` varchar(80) DEFAULT NULL,
  `agent_no` varchar(20) DEFAULT NULL,
  `bill_to_party` varchar(20) DEFAULT NULL,
  `ss_bldestinationChargesPreCol` varchar(4) DEFAULT NULL,
  `dest_remarks` varchar(1000) DEFAULT NULL,
  `move_type` varchar(30) DEFAULT NULL,
  `Zip` varchar(30) DEFAULT NULL,
  `ramp_city` varchar(80) DEFAULT NULL,
  `no_days` varchar(80) DEFAULT NULL,
  `routed_by_agent` varchar(80) DEFAULT NULL,
  `routedby_agents_country` varchar(20) DEFAULT NULL,
  `VoyageInternal` varchar(20) DEFAULT NULL,
  `rates_remarks` varchar(1000) DEFAULT NULL,
  `door_of_origin` varchar(50) DEFAULT NULL,
  `door_of_destination` varchar(80) DEFAULT NULL,
  `line_move` varchar(30) DEFAULT NULL,
  `commodity_code` varchar(20) DEFAULT NULL,
  `commodity_desc` varchar(80) DEFAULT NULL,
  `routedAgent_check` varchar(4) DEFAULT NULL,
  `eta` date DEFAULT NULL,
  `no_of_packages` varchar(4) DEFAULT NULL,
  `auto_deduct_ffcomm` varchar(1) DEFAULT NULL,
  `manifested_by` varchar(60) DEFAULT NULL,
  `manifested_date` datetime DEFAULT NULL,
  `receivedMaster_by` varchar(60) DEFAULT NULL,
  `receivedMaster_date` datetime DEFAULT NULL,
  `audited_by` varchar(60) DEFAULT NULL,
  `audited_date` datetime DEFAULT NULL,
  `closed_by` varchar(60) DEFAULT NULL,
  `closed_date` datetime DEFAULT NULL,
  `commissionsAdded_by` varchar(60) DEFAULT NULL,
  `commissionsAdded_date` datetime DEFAULT NULL,
  `accrualConverted_by` varchar(60) DEFAULT NULL,
  `accrualConverted_date` datetime DEFAULT NULL,
  `bill_to_code` varchar(20) DEFAULT NULL,
  `confirm_on_board` varchar(2) DEFAULT NULL,
  `verfiy_ETA` date DEFAULT NULL,
  `confirm_by` varchar(30) DEFAULT NULL,
  `confirm_on` datetime DEFAULT NULL,
  `void` varchar(2) DEFAULT NULL,
  `void_by` varchar(40) DEFAULT NULL,
  `void_date` date DEFAULT NULL,
  `conf_onboard_comments` varchar(200) DEFAULT NULL,
  `destination_charges_pre_col` varchar(20) DEFAULT NULL,
  `total_containers` varchar(4) DEFAULT NULL,
  `country_of_origin` varchar(4) DEFAULT NULL,
  `new_master_bL` varchar(20) DEFAULT NULL,
  `proof` varchar(4) DEFAULT NULL,
  `pre_alert` varchar(4) DEFAULT NULL,
  `non_negotiable` varchar(4) DEFAULT NULL,
  `Import_AMS_House_Bl` varchar(30) DEFAULT NULL,
  `importFlag` varchar(2) DEFAULT NULL,
  `import_release` varchar(2) DEFAULT NULL,
  `import_verified_eta` datetime DEFAULT NULL,
  `import_release_comments` varchar(200) DEFAULT NULL,
  `send_copy_to` varchar(50) DEFAULT NULL,
  `master_consignee_check` varchar(3) DEFAULT NULL,
  `master_notify_check` varchar(3) DEFAULT NULL,
  `consignee_check` varchar(3) DEFAULT NULL,
  `notify_check` varchar(3) DEFAULT NULL,
  `date_in_yard` datetime DEFAULT NULL,
  `date_out_yard` datetime DEFAULT NULL,
  `manifest_rev` varchar(20) DEFAULT NULL,
  `print_rev` varchar(5) DEFAULT NULL,
  `inbond_number` varchar(200) DEFAULT NULL,
  `inbond_date` datetime DEFAULT NULL,
  `inbond_port` varchar(20) DEFAULT NULL,
  `door_origin_as_plor` varchar(4) DEFAULT NULL,
  `door_destination_as_final_delivery_house` varchar(4) DEFAULT NULL,
  `collect_third_party` varchar(4) DEFAULT NULL,
  `door_destination_as_final_delivery_master` varchar(4) DEFAULT NULL,
  `house_shipper_check` varchar(3) DEFAULT NULL,
  `check_number` varchar(20) DEFAULT NULL,
  `paid_by` varchar(100) DEFAULT NULL,
  `payment_release` varchar(3) DEFAULT NULL,
  `payment_released_on` datetime DEFAULT NULL,
  `payment_release_comment` varchar(200) DEFAULT NULL,
  `payment_amount` double(10,2) DEFAULT NULL,
  `edi_created_by` varchar(100) DEFAULT NULL,
  `edi_created_on` datetime DEFAULT NULL,
  `alternate_port` varchar(50) DEFAULT NULL,
  `edi_consignee_check` varchar(3) DEFAULT NULL,
  `edi_shipper_check` varchar(3) DEFAULT NULL,
  `edi_notifyparty_check` varchar(3) DEFAULT NULL,
  `print_alternate_port` varchar(4) DEFAULT NULL,
  `trim_trailing_zeros_for_qty` varchar(4) DEFAULT NULL,
  `break_bulk` varchar(4) DEFAULT NULL,
  `hazmat` varchar(4) DEFAULT NULL,
  `rates_non_rates` varchar(4) DEFAULT NULL,
  `corrected_after_manifest` varchar(4) DEFAULT NULL,
  `cost_of_goods` double(10,2) DEFAULT NULL,
  `edit_house_shipper_check` varchar(4) DEFAULT NULL,
  `insurance` varchar(4) DEFAULT NULL,
  `insurance_rate` double(10,2) DEFAULT NULL,
  `directconsign_check` varchar(4) DEFAULT NULL,
  `over_paid_status` tinyint(1) DEFAULT '0',
  `converted_to_ap` tinyint(1) DEFAULT '0',
  `import_warehouse_name` varchar(100) DEFAULT NULL,
  `import_warehouse_code` varchar(50) DEFAULT NULL,
  `import_warehouse_address` varchar(500) DEFAULT NULL,
  `import_pickup_remarks` varchar(500) DEFAULT NULL,
  `edit_house_notify_check` varchar(4) DEFAULT NULL,
  `edit_house_consignee_check` varchar(4) DEFAULT NULL,
  `omit_term_and_port` varchar(3) DEFAULT NULL,
  `hbl_pol_override` varchar(4) DEFAULT NULL,
  `hbl_pod_override` varchar(4) DEFAULT NULL,
  `hbl_fd_override` varchar(4) DEFAULT NULL,
  `hbl_pol` varchar(50) DEFAULT NULL,
  `hbl_pod` varchar(50) DEFAULT NULL,
  `hbl_fd` varchar(50) DEFAULT NULL,
  `internal_Remark` varchar(500) DEFAULT NULL,
  `service_Contract_No` varchar(3) DEFAULT NULL,
  `editAgentName_Check` varchar(4) DEFAULT NULL,
  `local_drayage` varchar(4) DEFAULT NULL,
  `replace_Arrival` varchar(3) DEFAULT NULL,
  `certified_true_copy` varchar(5) DEFAULT NULL,
  `port_cut_off` datetime DEFAULT NULL,
  `doc_cut_off` datetime DEFAULT NULL,
  `earlier_PickUp_Date` datetime DEFAULT NULL,
  `rated_manifest` varchar(3) DEFAULT NULL,
  `ramp_check` varchar(4) DEFAULT NULL,
  `eta_fd` date DEFAULT NULL,
  `vesselname_check` varchar(4) DEFAULT NULL,
  `manual_vesselname` varchar(100) DEFAULT NULL,
  `correction_count` int(10) DEFAULT NULL,
  `omit_letter_countrycode` varchar(4) DEFAULT 'no',
  PRIMARY KEY (`Bol`),
  KEY `fcl_bl_idx01` (`file_no`),
  KEY `fcl_bl_idx02` (`BolId`),
  KEY `fcl_bl_idx03` (`sail_date`),
  KEY `fcl_bl_idx04` (`file_number`),
  KEY `fcl_bl_idx05` (`ready_to_post`,`manifested_date`),
  KEY `shipper_no_idx` (`Shipper_No`),
  KEY `house_shipper_no_idx` (`House_Shipper_No`),
  KEY `consignee_no_idx` (`consignee_No`),
  KEY `houseconsignee_idx` (`houseConsignee`),
  KEY `notify_party_idx` (`notify_party`),
  KEY `house_notify_party_no_idx` (`house_notify_party_no`),
  KEY `forward_agent_no_idx` (`Forward_agent_No`),
  KEY `ssline_no_idx` (`ssline_no`),
  KEY `billtrdprty_idx` (`billTrdPrty`),
  KEY `agent_no_idx` (`agent_no`)
) ENGINE=InnoDB AUTO_INCREMENT=1669 DEFAULT CHARSET=latin1;