INSERT INTO `_dtlmasterfiletemplatescolumns` (`code`, `master_file_templates_code`, `field_name`, `table_field_name`, `field_header_caption`, `can_display_on_table`, `can_show`, `can_add`, `can_edit`, `is_required`, `is_unique`, `alignment`, `data_type`, `max_length`, `data_source`, `data_source_database_name`, `data_source_table_name`, `data_source_table_alias`, `data_source_field_alias`, `data_source_value_pair`, `special_conditions`, `print_order`, `remarks`, `created_at`, `updated_at`, `created_user_mst_code`, `updated_user_mst_code`) VALUES
(1170, 107, 'VAT Rate', 'vat_rate', 'VAT Rate', 0, 1, 1, 1, 0, 0, 'left', 3, 30, 0, '', '', '', '', '', '', 98, '', '2015-06-11 00:06:13', '2015-06-11 00:06:13', 1, 1),
(1171, 107, 'Country', 'country_mst_code', 'Country', 0, 1, 1, 1, 0, 0, 'left', 7, 0, 2, 'bd926c5_iisaac_test', 'mstcountry', '1171', '1171-country_mst_code', 'code:country_name', '', 100, '', '2015-06-11 00:06:13', '2015-06-11 00:06:13', 1, 1),
(1172, 107, 'Region', 'region_mst_code', 'Region', 0, 1, 1, 1, 0, 0, 'left', 7, 0, 2, 'bd926c5_iisaac_test', 'mstregion', '1172', '1172-region_mst_code', 'code:region_name', 'chainingparentid=masterfiletransaction-id-7-1171-country_mst_code|chainingparentfield=country_mst_code', 106, '', '2015-06-11 00:06:13', '2015-06-11 00:06:13', 1, 1),
(1173, 107, 'Province', 'province_mst_code', 'Province', 0, 1, 1, 1, 0, 0, 'left', 7, 0, 2, 'bd926c5_iisaac_test', 'mstprovince', '1173', '1173-province_mst_code', 'code:province_name', 'chainingparentid=masterfiletransaction-id-7-1172-region_mst_code|chainingparentfield=region_mst_code', 107, '', '2015-06-11 00:06:13', '2015-06-11 00:06:13', 1, 1),
(1174, 107, 'City', 'city_mst_code', 'City', 0, 1, 1, 1, 0, 0, 'left', 7, 0, 2, 'bd926c5_iisaac_test', 'mstcity', '1174', '1174-city_mst_code', 'code:city_name', 'chainingparentid=masterfiletransaction-id-7-1173-province_mst_code|chainingparentfield=province_mst_code', 108, '', '2015-06-11 00:06:13', '2015-06-11 00:06:13', 1, 1),
(1175, 107, 'Barangay', 'barangay_mst_code', 'Barangay', 0, 1, 1, 1, 0, 0, 'left', 7, 0, 2, 'bd926c5_iisaac_test', 'mstbarangay', '1175', '1175-barangay_mst_code', 'code:barangay_name', 'chainingparentid=masterfiletransaction-id-7-1174-city_mst_code|chainingparentfield=city_mst_code', 109, '', '2015-06-11 00:06:13', '2015-06-11 00:06:13', 1, 1),
(1176, 107, 'Street Address', 'street_address', 'Street Address', 0, 1, 1, 1, 0, 0, 'left', 5, 500, 0, '', '', '', '', '', '', 114, '', '2015-06-11 00:06:13', '2015-06-11 00:06:13', 1, 1),
(1177, 107, 'Remarks', 'remarks', 'Remarks', 0, 1, 1, 1, 0, 0, 'left', 5, 50, 0, '', '', '', '', '', '', 122, '', '2015-06-11 00:06:13', '2015-06-11 00:06:13', 1, 1),
(1178, 107, 'Created by', 'created_user_mst_code', 'Username', 0, 1, 0, 0, 0, 0, 'left', 10, 50, 2, 'bd926c5_iisaac_test', 'mstuser', '1178', '1178-created_user_mst_code', 'code:whole_name', '', 124, '', '2015-06-11 00:06:13', '2015-06-11 00:06:13', 1, 1),
(1179, 107, 'Created at', 'created_at', 'Date time created', 0, 1, 0, 0, 0, 0, 'left', 4, 50, 0, '', '', '', '', '', 'usesformat=yes|formatmode=datetime|format=F d Y h:i a', 125, '', '2015-06-11 00:06:13', '2015-06-11 00:06:13', 1, 1),
(1180, 107, 'Last Updated By', 'updated_user_mst_code', 'Username', 0, 1, 0, 0, 0, 0, 'left', 10, 50, 2, 'bd926c5_iisaac_test', 'mstuser', '1180', '1180-updated_user_mst_code', 'code:whole_name', '', 130, '', '2015-06-11 00:06:13', '2015-06-11 00:06:13', 1, 1),
(1181, 107, 'Last updated at', 'updated_at', 'Date time updated', 0, 1, 0, 0, 0, 0, 'left', 4, 50, 0, '', '', '', '', '', 'usesformat=yes|formatmode=datetime|format=F d Y h:i a', 135, '', '2015-06-11 00:06:13', '2015-06-11 00:06:13', 1, 1),
(1182, 108, 'Internal Code', 'code', 'Code', 1, 1, 0, 0, 0, 0, 'left', 0, 20, 0, '', '', '', '', '', '', 0, '', '2015-06-11 00:20:50', '2015-06-11 00:20:50', 1, 1),
(1183, 108, 'Customer Code', 'customer_code', 'Customer Code', 1, 1, 1, 1, 1, 1, 'left', 1, 50, 0, '', '', '', '', '', '', 10, '', '2015-06-11 00:20:50', '2015-06-11 00:20:50', 1, 1),
(1184, 108, 'Type', 'customer_type', 'Type', 1, 1, 1, 1, 1, 0, 'left', 8, 0, 1, 'bd926c5_iisaac_test', '', '', '', '1:Individual|2:Corporate|3:Institutional|4:Groups', '', 15, '', '2015-06-11 00:20:50', '2015-06-11 00:20:50', 1, 1),
(1185, 108, 'Customer Group', 'customer_group_mst_code', 'Customer Group', 1, 1, 1, 1, 1, 0, 'left', 7, 0, 2, 'bd926c5_iisaac_test', 'mstcustomergroup', '1185', '1185-customer_group_mst_code', 'code:customer_group_name', '', 20, '', '2015-06-11 00:20:50', '2015-06-11 00:20:50', 1, 1),
(1186, 108, 'Institution Type', 'institution_type', 'Institution Type', 0, 1, 1, 1, 1, 0, 'left', 8, 0, 1, 'bd926c5_iisaac_test', '', '', '', '1:AFP|2:PNP|3:Others', '', 25, '', '2015-06-11 00:20:50', '2015-06-11 00:20:50', 1, 1),
(1187, 108, 'Tax Type', 'tax_type', 'Tax Type', 0, 1, 1, 1, 1, 0, 'left', 8, 0, 1, 'bd926c5_iisaac_test', '', '', '', '1:Vatable|2:Non-VAT|3:Zero Rated|4:Tax Exempt', '', 30, '', '2015-06-11 00:20:50', '2015-06-11 00:20:50', 1, 1),
(1188, 108, 'Customer Name', 'customer_name', 'Customer Name', 1, 1, 1, 1, 1, 0, 'left', 1, 150, 0, '', '', '', '', '', '', 45, '', '2015-06-11 00:20:50', '2015-06-11 00:20:50', 1, 1),
(1189, 108, 'First Name', 'first_name', 'First Name', 0, 1, 1, 1, 1, 0, 'left', 1, 150, 0, '', '', '', '', '', '', 50, '', '2015-06-11 00:20:50', '2015-06-11 00:20:50', 1, 1),
(1190, 108, 'Middle Name', 'middle_name', 'Middle Name', 0, 1, 1, 1, 0, 0, 'left', 1, 150, 0, '', '', '', '', '', '', 55, '', '2015-06-11 00:20:50', '2015-06-11 00:20:50', 1, 1),
(1191, 108, 'Last Name', 'last_name', 'Last Name', 0, 1, 1, 1, 1, 0, 'left', 1, 150, 0, '', '', '', '', '', '', 60, '', '2015-06-11 00:20:50', '2015-06-11 00:20:50', 1, 1),
(1192, 108, 'Contact Person', 'contact_person', 'Contact Person', 0, 1, 1, 1, 0, 0, 'left', 1, 150, 0, '', '', '', '', '', '', 65, '', '2015-06-11 00:20:50', '2015-06-11 00:20:50', 1, 1),
(1193, 108, 'TIN', 'tin', 'TIN', 0, 1, 1, 1, 0, 0, 'left', 1, 150, 0, '', '', '', '', '', 'customformat=yes|format=999-999-999-999', 70, '', '2015-06-11 00:20:50', '2015-06-11 00:20:50', 1, 1),
(1194, 108, 'Term Agreement', 'payment_term_mst_code', 'Term Agreement', 0, 1, 1, 1, 0, 0, 'left', 7, 0, 2, 'bd926c5_iisaac_test', 'mstpaymentterm', '1194', '1194-payment_term_mst_code', 'code:term_name', '', 75, '', '2015-06-11 00:20:50', '2015-06-11 00:20:50', 1, 1),
(1195, 108, 'E-mail Address', 'email_address', 'E-mail Address', 0, 1, 1, 1, 0, 0, 'left', 1, 150, 0, '', '', '', '', '', '', 80, '', '2015-06-11 00:20:50', '2015-06-11 00:20:50', 1, 1),
(1196, 108, 'Phone Number', 'contact_number', 'Phone Number', 0, 1, 1, 1, 0, 0, 'left', 1, 150, 0, '', '', '', '', '', '', 82, '', '2015-06-11 00:20:50', '2015-06-11 00:20:50', 1, 1),
(1197, 108, 'WHT Rate', 'wtax_rate', 'Withholding Tax Rate', 0, 1, 1, 1, 0, 0, 'left', 3, 30, 0, '', '', '', '', '', '', 90, '', '2015-06-11 00:20:50', '2015-06-11 00:20:50', 1, 1),
(1198, 108, 'VAT No.', 'vat_no', 'VAT No', 0, 1, 1, 1, 0, 0, 'left', 1, 150, 0, '', '', '', '', '', '', 95, '', '2015-06-11 00:20:50', '2015-06-11 00:20:50', 1, 1),
(1199, 108, 'VAT Rate', 'vat_rate', 'VAT Rate', 0, 1, 1, 1, 0, 0, 'left', 3, 30, 0, '', '', '', '', '', '', 98, '', '2015-06-11 00:20:50', '2015-06-11 00:20:50', 1, 1),
(1200, 108, 'Credit Limit', 'credit_limit', 'Credit Limit', 0, 1, 1, 0, 0, 0, 'left', 3, 30, 0, '', '', '', '', '', '', 99, '', '2015-06-11 00:20:50', '2015-06-11 00:20:50', 1, 1),
(1201, 108, 'Country', 'country_mst_code', 'Country', 0, 1, 1, 1, 0, 0, 'left', 7, 0, 2, 'bd926c5_iisaac_test', 'mstcountry', '1201', '1201-country_mst_code', 'code:country_name', '', 100, '', '2015-06-11 00:20:50', '2015-06-11 00:20:50', 1, 1),
(1202, 108, 'Region', 'region_mst_code', 'Region', 0, 1, 1, 1, 0, 0, 'left', 7, 0, 2, 'bd926c5_iisaac_test', 'mstregion', '1202', '1202-region_mst_code', 'code:region_name', 'chainingparentid=masterfiletransaction-id-7-1201-country_mst_code|chainingparentfield=country_mst_code', 106, '', '2015-06-11 00:20:50', '2015-06-11 00:20:50', 1, 1),
(1203, 108, 'Province', 'province_mst_code', 'Province', 0, 1, 1, 1, 0, 0, 'left', 7, 0, 2, 'bd926c5_iisaac_test', 'mstprovince', '1203', '1203-province_mst_code', 'code:province_name', 'chainingparentid=masterfiletransaction-id-7-1202-region_mst_code|chainingparentfield=region_mst_code', 107, '', '2015-06-11 00:20:50', '2015-06-11 00:20:50', 1, 1),
(1204, 108, 'City', 'city_mst_code', 'City', 0, 1, 1, 1, 0, 0, 'left', 7, 0, 2, 'bd926c5_iisaac_test', 'mstcity', '1204', '1204-city_mst_code', 'code:city_name', 'chainingparentid=masterfiletransaction-id-7-1203-province_mst_code|chainingparentfield=province_mst_code', 107, '', '2015-06-11 00:20:50', '2015-06-11 00:20:50', 1, 1),
(1205, 108, 'Barangay', 'barangay_mst_code', 'Barangay', 0, 1, 1, 1, 0, 0, 'left', 7, 0, 2, 'bd926c5_iisaac_test', 'mstbarangay', '1205', '1205-barangay_mst_code', 'code:barangay_name', 'chainingparentid=masterfiletransaction-id-7-1204-city_mst_code|chainingparentfield=city_mst_code', 109, '', '2015-06-11 00:20:50', '2015-06-11 00:20:50', 1, 1),
(1206, 108, 'Street Address', 'street_address', 'Street Address', 0, 1, 1, 1, 0, 0, 'left', 5, 500, 0, '', '', '', '', '', '', 114, '', '2015-06-11 00:20:50', '2015-06-11 00:20:50', 1, 1),
(1207, 108, 'Remarks', 'remarks', 'Remarks', 0, 1, 1, 1, 0, 0, 'left', 5, 50, 0, '', '', '', '', '', '', 122, '', '2015-06-11 00:20:50', '2015-06-11 00:20:50', 1, 1),
(1208, 108, 'Created by', 'created_user_mst_code', 'Username', 0, 1, 0, 0, 0, 0, 'left', 10, 50, 2, 'bd926c5_iisaac_test', 'mstuser', '1208', '1208-created_user_mst_code', 'code:whole_name', '', 124, '', '2015-06-11 00:20:50', '2015-06-11 00:20:50', 1, 1),
(1209, 108, 'Created at', 'created_at', 'Date time created', 0, 1, 0, 0, 0, 0, 'left', 4, 50, 0, '', '', '', '', '', 'usesformat=yes|formatmode=datetime|format=F d Y h:i a', 125, '', '2015-06-11 00:20:50', '2015-06-11 00:20:50', 1, 1),
(1210, 108, 'Last Updated By', 'updated_user_mst_code', 'Username', 0, 1, 0, 0, 0, 0, 'left', 10, 50, 2, 'bd926c5_iisaac_test', 'mstuser', '1210', '1210-updated_user_mst_code', 'code:whole_name', '', 130, '', '2015-06-11 00:20:50', '2015-06-11 00:20:50', 1, 1),
(1211, 108, 'Last updated at', 'updated_at', 'Date time updated', 0, 1, 0, 0, 0, 0, 'left', 4, 50, 0, '', '', '', '', '', 'usesformat=yes|formatmode=datetime|format=F d Y h:i a', 135, '', '2015-06-11 00:20:50', '2015-06-11 00:20:50', 1, 1),
(1212, 62, 'Internal Code', 'code', 'Code', 1, 1, 0, 0, 0, 0, 'left', 0, 20, 0, '', '', '', '', '', '', 0, '', '2015-06-11 00:28:36', '2015-06-11 00:28:36', 1, 1),
(1213, 62, 'Other Supplier Code', 'other_supplier_code', 'Other Supplier Code', 1, 1, 1, 1, 1, 1, 'left', 1, 50, 0, '', '', '', '', '', '', 10, '', '2015-06-11 00:28:36', '2015-06-11 00:28:36', 1, 1),
(1214, 62, 'Tax Type', 'tax_type', 'Tax Type', 0, 1, 1, 1, 1, 0, 'left', 8, 0, 1, 'bd926c5_iisaac_test', '', '', '', '1:Vatable|2:Non-VAT|3:Zero Rated|4:Tax Exempt', '', 30, '', '2015-06-11 00:28:36', '2015-06-11 00:28:36', 1, 1),
(1215, 62, 'Supplier Name', 'supplier_name', 'Supplier Name', 1, 1, 1, 1, 1, 0, 'left', 1, 500, 0, '', '', '', '', '', '', 45, '', '2015-06-11 00:28:36', '2015-06-11 00:28:36', 1, 1),
(1216, 62, 'TIN', 'tin', 'TIN', 0, 1, 1, 1, 0, 0, 'left', 1, 150, 0, '', '', '', '', '', 'customformat=yes|format=999-999-999-999', 70, '', '2015-06-11 00:28:36', '2015-06-11 00:28:36', 1, 1),
(1217, 62, 'WHT Rate', 'wtax_rate', 'Withholding Tax Rate', 0, 1, 1, 1, 0, 0, 'left', 3, 30, 0, '', '', '', '', '', '', 90, '', '2015-06-11 00:28:36', '2015-06-11 00:28:36', 1, 1),
(1218, 62, 'VAT No.', 'vat_no', 'VAT No', 0, 1, 1, 1, 0, 0, 'left', 1, 150, 0, '', '', '', '', '', '', 95, '', '2015-06-11 00:28:36', '2015-06-11 00:28:36', 1, 1),
(1219, 62, 'VAT Rate', 'vat_rate', 'VAT Rate', 0, 1, 1, 1, 0, 0, 'left', 3, 30, 0, '', '', '', '', '', '', 98, '', '2015-06-11 00:28:36', '2015-06-11 00:28:36', 1, 1),
(1220, 62, 'Country', 'country_mst_code', 'Country', 0, 1, 1, 1, 0, 0, 'left', 7, 0, 2, 'bd926c5_iisaac_test', 'mstcountry', '1220', '1220-country_mst_code', 'code:country_name', '', 100, '', '2015-06-11 00:28:36', '2015-06-11 00:28:36', 1, 1),
(1221, 62, 'Region', 'region_mst_code', 'Region', 0, 1, 1, 1, 0, 0, 'left', 7, 0, 2, 'bd926c5_iisaac_test', 'mstregion', '1221', '1221-region_mst_code', 'code:region_name', 'chainingparentid=masterfiletransaction-id-7-1220-country_mst_code|chainingparentfield=country_mst_code', 106, '', '2015-06-11 00:28:36', '2015-06-11 00:28:36', 1, 1),
(1222, 62, 'Province', 'province_mst_code', 'Province', 0, 1, 1, 1, 0, 0, 'left', 7, 0, 2, 'bd926c5_iisaac_test', 'mstprovince', '1222', '1222-province_mst_code', 'code:province_name', 'chainingparentid=masterfiletransaction-id-7-1221-region_mst_code|chainingparentfield=region_mst_code', 107, '', '2015-06-11 00:28:36', '2015-06-11 00:28:36', 1, 1),
(1223, 62, 'City', 'city_mst_code', 'City', 0, 1, 1, 1, 0, 0, 'left', 7, 0, 2, 'bd926c5_iisaac_test', 'mstcity', '1223', '1223-city_mst_code', 'code:city_name', 'chainingparentid=masterfiletransaction-id-7-1222-province_mst_code|chainingparentfield=province_mst_code', 107, '', '2015-06-11 00:28:36', '2015-06-11 00:28:36', 1, 1),
(1224, 62, 'Barangay', 'barangay_mst_code', 'Barangay', 0, 1, 1, 1, 0, 0, 'left', 7, 0, 2, 'bd926c5_iisaac_test', 'mstbarangay', '1224', '1224-barangay_mst_code', 'code:barangay_name', 'chainingparentid=masterfiletransaction-id-7-1223-city_mst_code|chainingparentfield=city_mst_code', 109, '', '2015-06-11 00:28:36', '2015-06-11 00:28:36', 1, 1),
(1225, 62, 'Street Address', 'street_address', 'Street Address', 0, 1, 1, 1, 0, 0, 'left', 5, 500, 0, '', '', '', '', '', '', 114, '', '2015-06-11 00:28:36', '2015-06-11 00:28:36', 1, 1),
(1226, 62, 'Remarks', 'remarks', 'Remarks', 0, 1, 1, 1, 0, 0, 'left', 5, 50, 0, '', '', '', '', '', '', 122, '', '2015-06-11 00:28:36', '2015-06-11 00:28:36', 1, 1),
(1227, 62, 'Created by', 'created_user_mst_code', 'Username', 0, 1, 0, 0, 0, 0, 'left', 10, 50, 2, 'bd926c5_iisaac_test', 'mstuser', '1227', '1227-created_user_mst_code', 'code:whole_name', '', 124, '', '2015-06-11 00:28:36', '2015-06-11 00:28:36', 1, 1),
(1228, 62, 'Created at', 'created_at', 'Date time created', 0, 1, 0, 0, 0, 0, 'left', 4, 50, 0, '', '', '', '', '', 'usesformat=yes|formatmode=datetime|format=F d Y h:i a', 125, '', '2015-06-11 00:28:36', '2015-06-11 00:28:36', 1, 1),
(1229, 62, 'Last Updated By', 'updated_user_mst_code', 'Username', 0, 1, 0, 0, 0, 0, 'left', 10, 50, 2, 'bd926c5_iisaac_test', 'mstuser', '1229', '1229-updated_user_mst_code', 'code:whole_name', '', 130, '', '2015-06-11 00:28:36', '2015-06-11 00:28:36', 1, 1),
(1230, 62, 'Last updated at', 'updated_at', 'Date time updated', 0, 1, 0, 0, 0, 0, 'left', 4, 50, 0, '', '', '', '', '', 'usesformat=yes|formatmode=datetime|format=F d Y h:i a', 135, '', '2015-06-11 00:28:36', '2015-06-11 00:28:36', 1, 1),
(1231, 111, 'Internal Code', 'code', 'Code', 1, 1, 0, 0, 0, 0, 'left', 0, 20, 0, '', '', '', '', '', '', 0, '', '2015-06-13 10:52:13', '2015-06-13 10:52:13', 1, 1),
(1232, 111, 'Address', 'complete_address', 'Address', 1, 1, 0, 0, 0, 0, 'left', 1, 500, 0, '', '', '', '', '', '', 10, '', '2015-06-13 10:52:13', '2015-06-13 10:52:13', 1, 1),
(1233, 111, 'Client', 'assured_mst_code', 'Client', 1, 1, 1, 1, 1, 0, 'left', 10, 10, 2, 'bd926c5_iisaac_test', 'mstassured', '1233', '1233-assured_mst_code', 'code:assured_name contact_person', 'remotelink=api/ReceiveSelect2Tables.php|templatefileloc=includes/typeaheadtemplates/mstassured.html', 20, '', '2015-06-13 10:52:13', '2015-06-13 10:52:13', 1, 1),
(1234, 111, 'Country', 'country_mst_code', 'Country', 0, 1, 1, 1, 0, 0, 'left', 7, 0, 2, 'bd926c5_iisaac_test', 'mstcountry', '1234', '1234-country_mst_code', 'code:country_name', '', 100, '', '2015-06-13 10:52:13', '2015-06-13 10:52:13', 1, 1),
(1235, 111, 'Region', 'region_mst_code', 'Region', 0, 1, 1, 1, 0, 0, 'left', 7, 0, 2, 'bd926c5_iisaac_test', 'mstregion', '1235', '1235-region_mst_code', 'code:region_name', 'chainingparentid=masterfiletransaction-id-7-1234-country_mst_code|chainingparentfield=country_mst_code', 106, '', '2015-06-13 10:52:13', '2015-06-13 10:52:13', 1, 1),
(1236, 111, 'Province', 'province_mst_code', 'Province', 0, 1, 1, 1, 0, 0, 'left', 7, 0, 2, 'bd926c5_iisaac_test', 'mstprovince', '1236', '1236-province_mst_code', 'code:province_name', 'chainingparentid=masterfiletransaction-id-7-1235-region_mst_code|chainingparentfield=region_mst_code', 107, '', '2015-06-13 10:52:13', '2015-06-13 10:52:13', 1, 1),
(1237, 111, 'City', 'city_mst_code', 'City', 0, 1, 1, 1, 0, 0, 'left', 7, 0, 2, 'bd926c5_iisaac_test', 'mstcity', '1237', '1237-city_mst_code', 'code:city_name', 'chainingparentid=masterfiletransaction-id-7-1236-province_mst_code|chainingparentfield=province_mst_code', 107, '', '2015-06-13 10:52:13', '2015-06-13 10:52:13', 1, 1),
(1238, 111, 'Barangay', 'barangay_mst_code', 'Barangay', 0, 1, 1, 1, 0, 0, 'left', 7, 0, 2, 'bd926c5_iisaac_test', 'mstbarangay', '1238', '1238-barangay_mst_code', 'code:barangay_name', 'chainingparentid=masterfiletransaction-id-7-1237-city_mst_code|chainingparentfield=city_mst_code', 109, '', '2015-06-13 10:52:13', '2015-06-13 10:52:13', 1, 1),
(1239, 111, 'Street Address', 'street_address', 'Street Address', 0, 1, 1, 1, 0, 0, 'left', 5, 500, 0, '', '', '', '', '', '', 114, '', '2015-06-13 10:52:13', '2015-06-13 10:52:13', 1, 1),
(1240, 111, 'Remarks', 'remarks', 'Remarks', 0, 1, 1, 1, 0, 0, 'left', 5, 50, 0, '', '', '', '', '', '', 122, '', '2015-06-13 10:52:13', '2015-06-13 10:52:13', 1, 1),
(1241, 111, 'Created by', 'created_user_mst_code', 'Username', 0, 1, 0, 0, 0, 0, 'left', 10, 50, 2, 'bd926c5_iisaac_test', 'mstuser', '1241', '1241-created_user_mst_code', 'code:whole_name', '', 124, '', '2015-06-13 10:52:13', '2015-06-13 10:52:13', 1, 1),
(1242, 111, 'Created at', 'created_at', 'Date time created', 0, 1, 0, 0, 0, 0, 'left', 4, 50, 0, '', '', '', '', '', 'usesformat=yes|formatmode=datetime|format=F d Y h:i a', 125, '', '2015-06-13 10:52:13', '2015-06-13 10:52:13', 1, 1),
(1243, 111, 'Last Updated By', 'updated_user_mst_code', 'Username', 0, 1, 0, 0, 0, 0, 'left', 10, 50, 2, 'bd926c5_iisaac_test', 'mstuser', '1243', '1243-updated_user_mst_code', 'code:whole_name', '', 130, '', '2015-06-13 10:52:13', '2015-06-13 10:52:13', 1, 1),
(1244, 111, 'Last updated at', 'updated_at', 'Date time updated', 0, 1, 0, 0, 0, 0, 'left', 4, 50, 0, '', '', '', '', '', 'usesformat=yes|formatmode=datetime|format=F d Y h:i a', 135, '', '2015-06-13 10:52:13', '2015-06-13 10:52:13', 1, 1),
(1245, 112, 'Internal Code', 'code', 'Code', 1, 1, 0, 0, 0, 0, 'left', 0, 20, 0, '', '', '', '', '', '', 0, '', '2015-06-13 11:19:04', '2015-06-13 11:19:04', 1, 1),
(1246, 112, 'Address', 'complete_address', 'Address', 1, 1, 0, 0, 0, 0, 'left', 1, 500, 0, '', '', '', '', '', '', 10, '', '2015-06-13 11:19:04', '2015-06-13 11:19:04', 1, 1),
(1247, 112, 'Licensed Interm.', 'agent_mst_code', 'Licensed Intermediary', 1, 1, 1, 1, 1, 0, 'left', 10, 10, 2, 'bd926c5_iisaac_test', 'mstagent', '1247', '1247-agent_mst_code', 'code:agent_name agent_code', 'remotelink=api/ReceiveSelect2Tables.php|templatefileloc=includes/typeaheadtemplates/mstagent.html', 20, '', '2015-06-13 11:19:04', '2015-06-13 11:19:04', 1, 1),
(1248, 112, 'Country', 'country_mst_code', 'Country', 0, 1, 1, 1, 0, 0, 'left', 7, 0, 2, 'bd926c5_iisaac_test', 'mstcountry', '1248', '1248-country_mst_code', 'code:country_name', '', 100, '', '2015-06-13 11:19:04', '2015-06-13 11:19:04', 1, 1),
(1249, 112, 'Region', 'region_mst_code', 'Region', 0, 1, 1, 1, 0, 0, 'left', 7, 0, 2, 'bd926c5_iisaac_test', 'mstregion', '1249', '1249-region_mst_code', 'code:region_name', 'chainingparentid=masterfiletransaction-id-7-1248-country_mst_code|chainingparentfield=country_mst_code', 106, '', '2015-06-13 11:19:04', '2015-06-13 11:19:04', 1, 1),
(1250, 112, 'Province', 'province_mst_code', 'Province', 0, 1, 1, 1, 0, 0, 'left', 7, 0, 2, 'bd926c5_iisaac_test', 'mstprovince', '1250', '1250-province_mst_code', 'code:province_name', 'chainingparentid=masterfiletransaction-id-7-1249-region_mst_code|chainingparentfield=region_mst_code', 107, '', '2015-06-13 11:19:04', '2015-06-13 11:19:04', 1, 1),
(1251, 112, 'City', 'city_mst_code', 'City', 0, 1, 1, 1, 0, 0, 'left', 7, 0, 2, 'bd926c5_iisaac_test', 'mstcity', '1251', '1251-city_mst_code', 'code:city_name', 'chainingparentid=masterfiletransaction-id-7-1250-province_mst_code|chainingparentfield=province_mst_code', 107, '', '2015-06-13 11:19:04', '2015-06-13 11:19:04', 1, 1),
(1252, 112, 'Barangay', 'barangay_mst_code', 'Barangay', 0, 1, 1, 1, 0, 0, 'left', 7, 0, 2, 'bd926c5_iisaac_test', 'mstbarangay', '1252', '1252-barangay_mst_code', 'code:barangay_name', 'chainingparentid=masterfiletransaction-id-7-1251-city_mst_code|chainingparentfield=city_mst_code', 109, '', '2015-06-13 11:19:04', '2015-06-13 11:19:04', 1, 1),
(1253, 112, 'Street Address', 'street_address', 'Street Address', 0, 1, 1, 1, 0, 0, 'left', 5, 500, 0, '', '', '', '', '', '', 114, '', '2015-06-13 11:19:04', '2015-06-13 11:19:04', 1, 1),
(1254, 112, 'Remarks', 'remarks', 'Remarks', 0, 1, 1, 1, 0, 0, 'left', 5, 50, 0, '', '', '', '', '', '', 122, '', '2015-06-13 11:19:04', '2015-06-13 11:19:04', 1, 1),
(1255, 112, 'Created by', 'created_user_mst_code', 'Username', 0, 1, 0, 0, 0, 0, 'left', 10, 50, 2, 'bd926c5_iisaac_test', 'mstuser', '1255', '1255-created_user_mst_code', 'code:whole_name', '', 124, '', '2015-06-13 11:19:04', '2015-06-13 11:19:04', 1, 1),
(1256, 112, 'Created at', 'created_at', 'Date time created', 0, 1, 0, 0, 0, 0, 'left', 4, 50, 0, '', '', '', '', '', 'usesformat=yes|formatmode=datetime|format=F d Y h:i a', 125, '', '2015-06-13 11:19:04', '2015-06-13 11:19:04', 1, 1),
(1257, 112, 'Last Updated By', 'updated_user_mst_code', 'Username', 0, 1, 0, 0, 0, 0, 'left', 10, 50, 2, 'bd926c5_iisaac_test', 'mstuser', '1257', '1257-updated_user_mst_code', 'code:whole_name', '', 130, '', '2015-06-13 11:19:04', '2015-06-13 11:19:04', 1, 1),
(1258, 112, 'Last updated at', 'updated_at', 'Date time updated', 0, 1, 0, 0, 0, 0, 'left', 4, 50, 0, '', '', '', '', '', 'usesformat=yes|formatmode=datetime|format=F d Y h:i a', 135, '', '2015-06-13 11:19:04', '2015-06-13 11:19:04', 1, 1),
(1259, 113, 'Internal Code', 'code', 'Code', 1, 1, 0, 0, 0, 0, 'left', 0, 20, 0, '', '', '', '', '', '', 0, '', '2015-06-14 22:43:10', '2015-06-14 22:43:10', 1, 1),
(1260, 113, 'Line', 'line_mst_code', 'Line', 1, 1, 1, 1, 1, 0, 'left', 7, 0, 2, 'bd926c5_iisaac_test', 'mstline', '1260', '1260-line_mst_code', 'code:line_name', '', 10, '', '2015-06-14 22:43:10', '2015-06-14 22:43:10', 1, 1),
(1261, 113, 'Subline', 'subline_mst_code', 'Subline', 1, 1, 1, 1, 1, 0, 'left', 7, 0, 2, 'bd926c5_iisaac_test', 'mstsubline', '1261', '1261-subline_mst_code', 'code:subline_name', 'chainingparentid=masterfiletransaction-id-7-1260-line_mst_code|chainingparentfield=line_mst_code', 20, '', '2015-06-14 22:43:10', '2015-06-14 22:43:10', 1, 1),
(1262, 113, 'Parent', 'parent_info_codes_mst_code', 'Parent Information Code', 1, 1, 1, 1, 0, 0, 'left', 7, 0, 2, 'bd926c5_iisaac_test', 'mstinfocodes', '1262', '1262-parent_info_codes_mst_code', 'code:info_code_name', 'condition=equals|condition_source_table_field=data_type|condition_source_table_field_value=11', 30, '', '2015-06-14 22:43:10', '2015-06-14 22:43:10', 1, 1),
(1263, 113, 'Information Code', 'info_codes_mst_code', 'Information Code', 1, 1, 1, 1, 1, 0, 'left', 7, 0, 2, 'bd926c5_iisaac_test', 'mstinfocodes', '1263', '1263-info_codes_mst_code', 'code:info_code_name', 'condition=not_equals|condition_source_table_field=data_type|condition_source_table_field_value=11', 40, '', '2015-06-14 22:43:10', '2015-06-14 22:43:10', 1, 1),
(1264, 113, 'Is Required?', 'is_required', 'Is Required', 0, 1, 1, 1, 1, 0, 'left', 8, 0, 1, 'bd926c5_iisaac_test', '', '', '', '1:Yes|2:No', '', 50, '', '2015-06-14 22:43:10', '2015-06-14 22:43:10', 1, 1),
(1265, 113, 'Is Unique?', 'is_unique', 'Is Unique', 0, 1, 1, 1, 1, 0, 'left', 8, 0, 1, 'bd926c5_iisaac_test', '', '', '', '1:Yes|2:No', '', 60, '', '2015-06-14 22:43:10', '2015-06-14 22:43:10', 1, 1),
(1266, 113, 'Display Order', 'display_order', 'Display order number', 1, 1, 1, 1, 1, 0, 'right', 2, 4, 0, '', '', '', '', '', '', 70, '', '2015-06-14 22:43:10', '2015-06-14 22:43:10', 1, 1),
(1267, 113, 'Memo Field (programmers use)', 'memo_field', 'Memo Field (programmers use)', 0, 1, 1, 1, 0, 0, 'left', 5, 2000, 0, '', '', '', '', '', '', 80, '', '2015-06-14 22:43:10', '2015-06-14 22:43:10', 1, 1),
(1268, 113, 'Special Condition 1 (programmers use)', 'special_condition1', 'Special Condition 1 (programmers use)', 0, 1, 1, 1, 0, 0, 'left', 5, 2000, 0, '', '', '', '', '', '', 90, '', '2015-06-14 22:43:10', '2015-06-14 22:43:10', 1, 1),
(1269, 113, 'Special Condition 2 (programmers use)', 'special_condition2', 'Special Condition 2 (programmers use)', 0, 1, 1, 1, 0, 0, 'left', 5, 2000, 0, '', '', '', '', '', '', 100, '', '2015-06-14 22:43:10', '2015-06-14 22:43:10', 1, 1),
(1270, 113, 'Remarks', 'remarks', 'Remarks', 0, 1, 1, 1, 0, 0, 'left', 5, 500, 0, '', '', '', '', '', '', 110, '', '2015-06-14 22:43:10', '2015-06-14 22:43:10', 1, 1),
(1271, 113, 'Created by', 'created_user_mst_code', 'Username', 0, 1, 0, 0, 0, 0, 'left', 10, 50, 2, 'bd926c5_iisaac_test', 'mstuser', '1271', '1271-created_user_mst_code', 'code:whole_name', '', 120, '', '2015-06-14 22:43:10', '2015-06-14 22:43:10', 1, 1),
(1272, 113, 'Created at', 'created_at', 'Date time created', 0, 1, 0, 0, 0, 0, 'left', 4, 50, 0, '', '', '', '', '', 'usesformat=yes|formatmode=datetime|format=F d Y h:i a', 130, '', '2015-06-14 22:43:10', '2015-06-14 22:43:10', 1, 1),
(1273, 113, 'Last Updated By', 'updated_user_mst_code', 'Username', 0, 1, 0, 0, 0, 0, 'left', 10, 50, 2, 'bd926c5_iisaac_test', 'mstuser', '1273', '1273-updated_user_mst_code', 'code:whole_name', '', 140, '', '2015-06-14 22:43:10', '2015-06-14 22:43:10', 1, 1),
(1274, 113, 'Last updated at', 'updated_at', 'Date time updated', 0, 1, 0, 0, 0, 0, 'left', 4, 50, 0, '', '', '', '', '', 'usesformat=yes|formatmode=datetime|format=F d Y h:i a', 150, '', '2015-06-14 22:43:10', '2015-06-14 22:43:10', 1, 1),
(1275, 114, 'Internal Code', 'code', 'Code', 1, 1, 0, 0, 0, 0, 'left', 0, 20, 0, '', '', '', '', '', '', 0, '', '2015-06-16 09:21:40', '2015-06-16 09:21:40', 1, 1),
(1276, 114, 'Tariff Code', 'tariff_code', 'Tariff Code', 1, 1, 1, 1, 1, 1, 'left', 1, 50, 0, '', '', '', '', '', '', 10, '', '2015-06-16 09:21:40', '2015-06-16 09:21:40', 1, 1),
(1277, 114, 'Occupancy', 'subline_mst_code', 'Occupancy (Subline)', 1, 1, 1, 1, 1, 0, 'left', 7, 0, 2, 'bd926c5_iisaac_test', 'mstsubline', '1277', '1277-subline_mst_code', 'code:subline_name', 'condition=equals|condition_source_table_field=line_mst_code|condition_source_table_field_value=1', 20, '', '2015-06-16 09:21:40', '2015-06-16 09:21:40', 1, 1),
(1278, 114, 'Tariff Name', 'tariff_name', 'Tariff Name', 1, 1, 1, 1, 1, 0, 'left', 1, 200, 0, '', '', '', '', '', '', 30, '', '2015-06-16 09:21:40', '2015-06-16 09:21:40', 1, 1),
(1279, 114, 'Description', 'description', 'Description', 0, 1, 1, 1, 0, 0, 'left', 5, 500, 0, '', '', '', '', '', '', 35, '', '2015-06-16 09:21:40', '2015-06-16 09:21:40', 1, 1),
(1280, 114, 'Tariff Rate', 'tariff_rate', 'Tariff Rate', 1, 1, 1, 1, 1, 0, 'left', 3, 30, 0, '', '', '', '', '', 'usesformat=yes|formatmode=number|format=5', 40, '', '2015-06-16 09:21:40', '2015-06-16 09:21:40', 1, 1),
(1281, 114, 'TRL', 'table_retention_limits_mst_code', 'Table of Retention Limits', 1, 1, 1, 1, 1, 0, 'left', 7, 0, 2, 'bd926c5_iisaac_test', 'msttableretentionlimits', '1281', '1281-table_retention_limits_mst_code', 'code:short_name description', 'custom_file_to_open=masterfiles$select_msttableretentionlimits', 50, '', '2015-06-16 09:21:40', '2015-06-16 09:21:40', 1, 1),
(1282, 114, 'Type', 'type', 'Type', 0, 1, 1, 1, 1, 0, 'left', 8, 0, 1, 'bd926c5_iisaac_test', '', '', '', '1:Basic|2:Allied', '', 60, '', '2015-06-16 09:21:40', '2015-06-16 09:21:40', 1, 1),
(1283, 114, 'Remarks', 'remarks', 'Remarks', 0, 1, 1, 1, 0, 0, 'left', 5, 500, 0, '', '', '', '', '', '', 110, '', '2015-06-16 09:21:40', '2015-06-16 09:21:40', 1, 1),
(1284, 114, 'Created by', 'created_user_mst_code', 'Username', 0, 1, 0, 0, 0, 0, 'left', 10, 50, 2, 'bd926c5_iisaac_test', 'mstuser', '1284', '1284-created_user_mst_code', 'code:whole_name', '', 120, '', '2015-06-16 09:21:40', '2015-06-16 09:21:40', 1, 1),
(1285, 114, 'Created at', 'created_at', 'Date time created', 0, 1, 0, 0, 0, 0, 'left', 4, 50, 0, '', '', '', '', '', 'usesformat=yes|formatmode=datetime|format=F d Y h:i a', 130, '', '2015-06-16 09:21:40', '2015-06-16 09:21:40', 1, 1),
(1286, 114, 'Last Updated By', 'updated_user_mst_code', 'Username', 0, 1, 0, 0, 0, 0, 'left', 10, 50, 2, 'bd926c5_iisaac_test', 'mstuser', '1286', '1286-updated_user_mst_code', 'code:whole_name', '', 140, '', '2015-06-16 09:21:40', '2015-06-16 09:21:40', 1, 1),
(1287, 114, 'Last updated at', 'updated_at', 'Date time updated', 0, 1, 0, 0, 0, 0, 'left', 4, 50, 0, '', '', '', '', '', 'usesformat=yes|formatmode=datetime|format=F d Y h:i a', 150, '', '2015-06-16 09:21:40', '2015-06-16 09:21:40', 1, 1),
(1288, 115, 'Internal Code', 'code', 'Code', 1, 1, 0, 0, 0, 0, 'left', 0, 20, 0, '', '', '', '', '', '', 0, '', '2015-06-16 09:50:38', '2015-06-16 09:50:38', 1, 1),
(1289, 115, 'Short Name', 'short_name', 'Short Name', 1, 1, 1, 1, 1, 0, 'left', 1, 50, 0, '', '', '', '', '', '', 10, '', '2015-06-16 09:50:38', '2015-06-16 09:50:38', 1, 1),
(1290, 115, 'TRL Year', 'trl_year', 'TRL Year', 1, 1, 1, 1, 1, 0, 'left', 2, 4, 0, '', '', '', '', '', 'customformat=yes|format=9999', 15, '', '2015-06-16 09:50:38', '2015-06-16 09:50:38', 1, 1),
(1292, 115, 'Description', 'description', 'Description', 1, 1, 1, 1, 0, 0, 'left', 5, 500, 0, '', '', '', '', '', '', 35, '', '2015-06-16 09:50:38', '2015-06-16 09:50:38', 1, 1),
(1294, 115, 'Remarks', 'remarks', 'Remarks', 0, 1, 1, 1, 0, 0, 'left', 5, 500, 0, '', '', '', '', '', '', 110, '', '2015-06-16 09:50:38', '2015-06-16 09:50:38', 1, 1),
(1295, 115, 'Created by', 'created_user_mst_code', 'Username', 0, 1, 0, 0, 0, 0, 'left', 10, 50, 2, 'bd926c5_iisaac_test', 'mstuser', '1295', '1295-created_user_mst_code', 'code:whole_name', '', 120, '', '2015-06-16 09:50:38', '2015-06-16 09:50:38', 1, 1),
(1296, 115, 'Created at', 'created_at', 'Date time created', 0, 1, 0, 0, 0, 0, 'left', 4, 50, 0, '', '', '', '', '', 'usesformat=yes|formatmode=datetime|format=F d Y h:i a', 130, '', '2015-06-16 09:50:38', '2015-06-16 09:50:38', 1, 1),
(1297, 115, 'Last Updated By', 'updated_user_mst_code', 'Username', 0, 1, 0, 0, 0, 0, 'left', 10, 50, 2, 'bd926c5_iisaac_test', 'mstuser', '1297', '1297-updated_user_mst_code', 'code:whole_name', '', 140, '', '2015-06-16 09:50:38', '2015-06-16 09:50:38', 1, 1),
(1298, 115, 'Last updated at', 'updated_at', 'Date time updated', 0, 1, 0, 0, 0, 0, 'left', 4, 50, 0, '', '', '', '', '', 'usesformat=yes|formatmode=datetime|format=F d Y h:i a', 150, '', '2015-06-16 09:50:38', '2015-06-16 09:50:38', 1, 1),
(1299, 116, 'Internal Code', 'code', 'Code', 1, 1, 0, 0, 0, 0, 'left', 0, 20, 0, '', '', '', '', '', '', 0, '', '2015-06-16 11:20:39', '2015-06-16 11:20:39', 1, 1),
(1300, 116, 'Bond Class', 'bond_groups_mst_code', 'Bond Class', 1, 1, 1, 1, 1, 0, 'right', 7, 0, 1, 'bd926c5_iisaac_test', '', '', '', '1:1|2:2|3:3|4:4|5:5', '', 20, '', '2015-06-16 11:20:39', '2015-06-16 11:20:39', 1, 1),
(1301, 116, 'Range From', 'range_low', 'Range From', 1, 1, 1, 1, 1, 0, 'right', 3, 30, 0, '', '', '', '', '', 'usesformat=yes|formatmode=number|format=2', 40, '', '2015-06-16 11:20:39', '2015-06-16 11:20:39', 1, 1),
(1302, 116, 'Range To', 'range_high', 'Range To', 1, 1, 1, 1, 1, 0, 'right', 3, 30, 0, '', '', '', '', '', 'usesformat=yes|formatmode=number|format=2', 50, '', '2015-06-16 11:20:39', '2015-06-16 11:20:39', 1, 1),
(1303, 116, 'Default Rate', 'default_rate', 'Default Rate', 1, 1, 1, 1, 1, 0, 'right', 3, 30, 0, '', '', '', '', '', 'usesformat=yes|formatmode=number|format=5', 60, '', '2015-06-16 11:20:39', '2015-06-16 11:20:39', 1, 1),
(1304, 116, 'Additional Amt.', 'additional_amount', 'Additional Amount', 1, 1, 1, 1, 1, 0, 'right', 3, 30, 0, '', '', '', '', '', 'usesformat=yes|formatmode=number|format=2', 70, '', '2015-06-16 11:20:39', '2015-06-16 11:20:39', 1, 1),
(1305, 116, 'Remarks', 'remarks', 'Remarks', 0, 1, 1, 1, 0, 0, 'left', 5, 500, 0, '', '', '', '', '', '', 110, '', '2015-06-16 11:20:39', '2015-06-16 11:20:39', 1, 1),
(1306, 116, 'Created by', 'created_user_mst_code', 'Username', 0, 1, 0, 0, 0, 0, 'left', 10, 50, 2, 'bd926c5_iisaac_test', 'mstuser', '1306', '1306-created_user_mst_code', 'code:whole_name', '', 120, '', '2015-06-16 11:20:39', '2015-06-16 11:20:39', 1, 1),
(1307, 116, 'Created at', 'created_at', 'Date time created', 0, 1, 0, 0, 0, 0, 'left', 4, 50, 0, '', '', '', '', '', 'usesformat=yes|formatmode=datetime|format=F d Y h:i a', 130, '', '2015-06-16 11:20:39', '2015-06-16 11:20:39', 1, 1),
(1308, 116, 'Last Updated By', 'updated_user_mst_code', 'Username', 0, 1, 0, 0, 0, 0, 'left', 10, 50, 2, 'bd926c5_iisaac_test', 'mstuser', '1308', '1308-updated_user_mst_code', 'code:whole_name', '', 140, '', '2015-06-16 11:20:39', '2015-06-16 11:20:39', 1, 1),
(1309, 116, 'Last updated at', 'updated_at', 'Date time updated', 0, 1, 0, 0, 0, 0, 'left', 4, 50, 0, '', '', '', '', '', 'usesformat=yes|formatmode=datetime|format=F d Y h:i a', 150, '', '2015-06-16 11:20:39', '2015-06-16 11:20:39', 1, 1),
(1310, 122, 'Internal Code', 'code', 'Code', 1, 1, 0, 0, 0, 0, 'left', 0, 20, 0, '', '', '', '', '', '', 0, '', '2015-06-23 17:19:28', '2015-06-23 17:19:28', 1, 1),
(1311, 122, 'Short Name', 'short_name', 'Short Name', 1, 1, 1, 1, 1, 1, 'left', 1, 50, 0, '', '', '', '', '', '', 5, '', '2015-06-23 17:19:28', '2015-06-23 17:19:28', 1, 1),
(1312, 122, 'Line', 'line_mst_code', 'Line', 1, 1, 1, 1, 1, 0, 'left', 7, 0, 2, 'bd926c5_iisaac_test', 'mstline', '1312', '1312-line_mst_code', 'code:line_name', '', 8, '', '2015-06-23 17:19:28', '2015-06-23 17:19:28', 1, 1),
(1313, 122, 'Claim Type Name', 'claim_type_name', 'Claim Type Name', 1, 1, 1, 1, 1, 0, 'left', 1, 150, 0, '', '', '', '', '', '', 10, '', '2015-06-23 17:19:28', '2015-06-23 17:19:28', 1, 1),
(1314, 122, 'Description', 'description', 'Description', 0, 1, 1, 1, 0, 0, 'left', 5, 200, 0, '', '', '', '', '', '', 15, '', '2015-06-23 17:19:28', '2015-06-23 17:19:28', 1, 1),
(1315, 122, 'Remarks', 'remarks', 'Remarks', 0, 1, 1, 1, 0, 0, 'left', 5, 50, 0, '', '', '', '', '', '', 75, '', '2015-06-23 17:19:28', '2015-06-23 17:19:28', 1, 1),
(1316, 122, 'Created by', 'created_user_mst_code', 'Username', 0, 1, 0, 0, 0, 0, 'left', 10, 50, 2, 'bd926c5_iisaac_test', 'mstuser', '1316', '1316-created_user_mst_code', 'code:whole_name', '', 80, '', '2015-06-23 17:19:28', '2015-06-23 17:19:28', 1, 1),
(1317, 122, 'Created at', 'created_at', 'Date time created', 0, 1, 0, 0, 0, 0, 'left', 4, 50, 0, '', '', '', '', '', 'usesformat=yes|formatmode=datetime|format=F d Y h:i a', 85, '', '2015-06-23 17:19:28', '2015-06-23 17:19:28', 1, 1),
(1318, 122, 'Last Updated By', 'updated_user_mst_code', 'Username', 0, 1, 0, 0, 0, 0, 'left', 10, 50, 2, 'bd926c5_iisaac_test', 'mstuser', '1318', '1318-updated_user_mst_code', 'code:whole_name', '', 90, '', '2015-06-23 17:19:28', '2015-06-23 17:19:28', 1, 1),
(1319, 122, 'Last updated at', 'updated_at', 'Date time updated', 0, 1, 0, 0, 0, 0, 'left', 4, 50, 0, '', '', '', '', '', 'usesformat=yes|formatmode=datetime|format=F d Y h:i a', 95, '', '2015-06-23 17:19:28', '2015-06-23 17:19:28', 1, 1),
(1320, 123, 'Internal Code', 'code', 'Code', 1, 1, 0, 0, 0, 0, 'left', 0, 20, 0, '', '', '', '', '', '', 0, '', '2015-06-23 18:10:57', '2015-06-23 18:10:57', 1, 1),
(1321, 123, 'Short Name', 'short_name', 'Short Name', 1, 1, 1, 1, 1, 1, 'left', 1, 50, 0, '', '', '', '', '', '', 5, '', '2015-06-23 18:10:57', '2015-06-23 18:10:57', 1, 1),
(1322, 123, 'Type', 'type', 'Type', 1, 1, 1, 1, 1, 0, 'left', 8, 0, 1, 'bd926c5_iisaac_test', '', '', '', '1:Loss|2:Expense', '', 10, '', '2015-06-23 18:10:57', '2015-06-23 18:10:57', 1, 1),
(1323, 123, 'Description', 'description', 'Description', 1, 1, 1, 1, 1, 0, 'left', 5, 200, 0, '', '', '', '', '', '', 15, '', '2015-06-23 18:10:57', '2015-06-23 18:10:57', 1, 1),
(1324, 123, 'Covered Lines', 'line_mst_codes', 'Lines', 0, 1, 1, 1, 1, 0, 'left', 9, 0, 2, 'bd926c5_iisaac_test', 'mstline', '1324', '1324-line_mst_codes', 'code:line_name', '', 20, '', '2015-06-23 18:10:57', '2015-06-23 18:10:57', 1, 1),
(1325, 123, 'Has Depreciation?', 'has_depreciation', 'Has Depreciation', 0, 1, 1, 1, 1, 0, 'left', 8, 0, 1, 'bd926c5_iisaac_test', '', '', '', '1:Yes|2:No', '', 25, '', '2015-06-23 18:10:57', '2015-06-23 18:10:57', 1, 1),
(1326, 123, 'Payee Types', 'payee_types', 'Payee Type', 0, 1, 1, 1, 1, 0, 'left', 9, 0, 1, 'bd926c5_iisaac_test', '', '', '', '1:Third Party claimant|2:Assured Claimant|3:Adjusters|4:Repair Shop|5:Supplier|7:Agent|8:Bank|9:Legal Fees|10:Reinsurers', '', 30, '', '2015-06-23 18:10:57', '2015-06-23 18:10:57', 1, 1),
(1327, 123, 'Remarks', 'remarks', 'Remarks', 0, 1, 1, 1, 0, 0, 'left', 5, 50, 0, '', '', '', '', '', '', 75, '', '2015-06-23 18:10:57', '2015-06-23 18:10:57', 1, 1),
(1328, 123, 'Created by', 'created_user_mst_code', 'Username', 0, 1, 0, 0, 0, 0, 'left', 10, 50, 2, 'bd926c5_iisaac_test', 'mstuser', '1328', '1328-created_user_mst_code', 'code:whole_name', '', 80, '', '2015-06-23 18:10:57', '2015-06-23 18:10:57', 1, 1),
(1329, 123, 'Created at', 'created_at', 'Date time created', 0, 1, 0, 0, 0, 0, 'left', 4, 50, 0, '', '', '', '', '', 'usesformat=yes|formatmode=datetime|format=F d Y h:i a', 85, '', '2015-06-23 18:10:57', '2015-06-23 18:10:57', 1, 1),
(1330, 123, 'Last Updated By', 'updated_user_mst_code', 'Username', 0, 1, 0, 0, 0, 0, 'left', 10, 50, 2, 'bd926c5_iisaac_test', 'mstuser', '1330', '1330-updated_user_mst_code', 'code:whole_name', '', 90, '', '2015-06-23 18:10:57', '2015-06-23 18:10:57', 1, 1),
(1331, 123, 'Last updated at', 'updated_at', 'Date time updated', 0, 1, 0, 0, 0, 0, 'left', 4, 50, 0, '', '', '', '', '', 'usesformat=yes|formatmode=datetime|format=F d Y h:i a', 95, '', '2015-06-23 18:10:57', '2015-06-23 18:10:57', 1, 1),
(1332, 125, 'Internal Code', 'code', 'Code', 1, 1, 0, 0, 0, 0, 'left', 0, 20, 0, '', '', '', '', '', '', 0, '', '2015-06-24 18:42:21', '2015-06-24 18:42:21', 1, 1),
(1333, 125, 'Short Name', 'short_name', 'Short Name', 0, 1, 1, 1, 1, 1, 'left', 1, 50, 0, '', '', '', '', '', '', 5, '', '2015-06-24 18:42:21', '2015-06-24 18:42:21', 1, 1),
(1334, 125, 'Endorsement Name', 'endorsement_name', 'Endorsement Name', 1, 1, 1, 1, 1, 0, 'left', 5, 100, 0, '', '', '', '', '', '', 10, '', '2015-06-24 18:42:21', '2015-06-24 18:42:21', 1, 1),
(1335, 125, 'Description', 'description', 'Description', 0, 1, 1, 1, 1, 0, 'left', 5, 500, 0, '', '', '', '', '', '', 15, '', '2015-06-24 18:42:21', '2015-06-24 18:42:21', 1, 1),
(1336, 125, 'Applicable Lines', 'endorsement_line_mst_codes', 'Applicable Lines', 0, 1, 1, 1, 0, 0, 'left', 9, 0, 2, 'bd926c5_iisaac_test', 'mstline', '1336', '1336-endorsement_line_mst_codes', 'code:line_name', '', 20, '', '2015-06-24 18:42:21', '2015-06-24 18:42:21', 1, 1),
(1337, 125, 'Applicable Sources', 'endorsement_source', 'Endorsement Source', 0, 1, 1, 1, 1, 0, 'left', 9, 0, 1, 'bd926c5_iisaac_test', '', '', '', '1:Direct Business|2:Reinsurance', '', 25, '', '2015-06-24 18:42:21', '2015-06-24 18:42:21', 1, 1),
(1338, 125, 'Endorsement Class', 'endorsement_class', 'Endorsement Class', 1, 1, 1, 1, 1, 0, 'left', 8, 0, 1, 'bd926c5_iisaac_test', '', '', '', '1:Normal|2:Cancellation|3:Reinstatement', '', 30, '', '2015-06-24 18:42:21', '2015-06-24 18:42:21', 1, 1),
(1339, 125, 'Endorsement Type', 'endorsement_type', 'Endorsement Type', 1, 1, 1, 1, 1, 0, 'left', 8, 0, 1, 'bd926c5_iisaac_test', '', '', '', '1:Premium|2:Non-Premium', '', 35, '', '2015-06-24 18:42:21', '2015-06-24 18:42:21', 1, 1),
(1340, 125, 'Endorsement Text', 'endorsement_text', 'Endorsement Text', 0, 1, 1, 1, 1, 0, 'left', 6, 5000, 0, '', '', '', '', '', '', 40, '', '2015-06-24 18:42:21', '2015-06-24 18:42:21', 1, 1),
(1341, 125, 'Remarks', 'remarks', 'Remarks', 0, 1, 1, 1, 0, 0, 'left', 5, 50, 0, '', '', '', '', '', '', 45, '', '2015-06-24 18:42:21', '2015-06-24 18:42:21', 1, 1),
(1342, 125, 'Created by', 'created_user_mst_code', 'Username', 0, 1, 0, 0, 0, 0, 'left', 10, 50, 2, 'bd926c5_iisaac_test', 'mstuser', '1342', '1342-created_user_mst_code', 'code:whole_name', '', 80, '', '2015-06-24 18:42:21', '2015-06-24 18:42:21', 1, 1),
(1343, 125, 'Created at', 'created_at', 'Date time created', 0, 1, 0, 0, 0, 0, 'left', 4, 50, 0, '', '', '', '', '', 'usesformat=yes|formatmode=datetime|format=F d Y h:i a', 85, '', '2015-06-24 18:42:21', '2015-06-24 18:42:21', 1, 1),
(1344, 125, 'Last Updated By', 'updated_user_mst_code', 'Username', 0, 1, 0, 0, 0, 0, 'left', 10, 50, 2, 'bd926c5_iisaac_test', 'mstuser', '1344', '1344-updated_user_mst_code', 'code:whole_name', '', 90, '', '2015-06-24 18:42:21', '2015-06-24 18:42:21', 1, 1),
(1345, 125, 'Last updated at', 'updated_at', 'Date time updated', 0, 1, 0, 0, 0, 0, 'left', 4, 50, 0, '', '', '', '', '', 'usesformat=yes|formatmode=datetime|format=F d Y h:i a', 95, '', '2015-06-24 18:42:21', '2015-06-24 18:42:21', 1, 1),
(1346, 25, '', '', '', 0, 0, 0, 0, 0, 0, '', 0, 0, 0, '', '', '', '', '', '', 0, '', '0000-00-00 00:00:00', '0000-00-00 00:00:00', 0, 0),
(1347, 46, 'Line', 'line_mst_code', 'Line', 0, 1, 1, 1, 1, 0, 'left', 9, 0, 2, 'bd926c5_iisaac_test', 'mstline', '1347', '1347-line_mst_code', 'code:line_name', '', 8, '', '2015-06-23 17:19:28', '2015-06-23 17:19:28', 1, 1),
(1351, 49, 'Line', 'line_mst_code', 'Line', 1, 1, 1, 1, 1, 0, 'left', 7, 0, 2, 'bd926c5_iisaac_test', 'mstline', '1351', '1351-line_mst_code', 'code:line_name', '', 40, '', '2015-05-23 14:18:48', '2015-05-23 14:18:48', 1, 1),
(1352, 36, '', 'code', '', 0, 0, 1, 1, 0, 0, 'left', 12, 30, 0, '', '', '', '', '', 'appparamkey=motorcar_line_internal_code', 35, '', '2015-05-21 01:05:09', '2015-05-21 01:05:09', 1, 1),
(1353, 37, '', 'code', '', 0, 0, 1, 1, 0, 0, 'left', 12, 50, 2, '', '', '1353', '1353-code', '', 'appparamkey=fire_line_internal_code', 50, '', '2015-05-22 01:24:41', '2015-05-22 01:24:41', 1, 1),
(1356, 86, 'Bond Group Name', 'bond_group_name', 'Bond Group Name', 1, 1, 0, 0, 0, 0, 'left', 4, 500, 0, '', '', '', '', '', '', 26, '', '0000-00-00 00:00:00', '0000-00-00 00:00:00', 0, 0),
(1357, 93, 'Licensed Interm.', 'agent_mst_code', 'Licensed Intermediary', 0, 1, 1, 1, 0, 0, 'left', 10, 10, 2, 'bd926c5_iisaac_test', 'mstagent', '1247', '1247-agent_mst_code', 'code:agent_name agent_code', 'remotelink=api/ReceiveSelect2Tables.php|templatefileloc=includes/typeaheadtemplates/mstagent.html', 73, '', '2015-06-13 11:19:04', '2015-06-13 11:19:04', 1, 1),
(1358, 93, 'Accessible Perils', 'applied_peril_mst_codes', 'Accessible Perils', 0, 1, 1, 1, 0, 0, 'left', 9, 0, 2, 'bd926c5_iisaac_test', 'mstperil', '945', '945-applied_peril_mst_codes', 'code:line_mst_code peril_name', 'chainingparentclass=masterfiletransaction-name-9-941-user_line_dtl_codes|chainingparentfield=line_mst_code', 72, '', '2015-06-06 10:32:56', '2015-06-06 10:32:56', 1, 1),
(1359, 130, 'Internal Code', 'code', 'Code', 1, 1, 0, 0, 0, 0, 'left', 0, 20, 0, '', '', '', '', '', '', 0, '', '2015-07-24 14:20:06', '2015-07-24 14:20:06', 1, 1),
(1360, 130, 'No. of Months', 'no_of_months', 'No. of Months', 1, 1, 1, 1, 1, 0, 'right', 2, 2, 0, '', '', '', '', '', '', 15, '', '2015-07-24 14:20:06', '2015-07-24 14:20:06', 1, 1),
(1361, 130, 'Percentage', 'percentage', 'Percentage', 1, 1, 1, 1, 1, 0, 'left', 2, 3, 0, '', '', '', '', '', 'usesformat=yes|formatmode=number|format=0', 45, '', '2015-07-24 14:20:06', '2015-07-24 14:20:06', 1, 1),
(1362, 130, 'Branch', 'branch_mst_code', 'Branch', 1, 1, 1, 1, 0, 0, 'left', 7, 0, 2, 'bd926c5_iisaac_test', 'mstbranch', 'mstbranch1362', 'mstbranch_field1362-branch_mst_code', 'code:branch_name', '', 15, '', '2015-07-24 14:20:06', '2015-07-24 14:20:06', 1, 1),
(1363, 130, 'Line', 'line_mst_code', 'Line', 1, 1, 1, 1, 0, 0, 'left', 7, 0, 2, 'bd926c5_iisaac_test', 'mstline', 'mstline1363', 'mstline_field1363-line_mst_code', 'code:line_name', '', 20, '', '2015-07-24 14:20:06', '2015-07-24 14:20:06', 1, 1),
(1364, 130, 'Remarks', 'remarks', 'Remarks', 0, 1, 1, 1, 0, 0, 'left', 5, 50, 0, '', '', '', '', '', '', 70, '', '2015-07-24 14:20:06', '2015-07-24 14:20:06', 1, 1),
(1365, 130, 'Created by', 'created_user_mst_code', 'Username', 0, 1, 0, 0, 0, 0, 'left', 10, 50, 2, 'bd926c5_iisaac_test', 'mstuser', 'mstuser1365', '', 'code:whole_name', '', 80, '', '2015-07-24 14:20:06', '2015-07-24 14:20:06', 1, 1),
(1366, 130, 'Created at', 'created_at', 'Date time created', 0, 1, 0, 0, 0, 0, 'left', 4, 50, 0, '', '', '', '', '', 'usesformat=yes|formatmode=datetime|format=F d Y h:i a', 85, '', '2015-07-24 14:20:06', '2015-07-24 14:20:06', 1, 1),
(1367, 130, 'Last Updated By', 'updated_user_mst_code', 'Username', 0, 1, 0, 0, 0, 0, 'left', 10, 50, 2, 'bd926c5_iisaac_test', 'mstuser', 'mstuser1367', '', 'code:whole_name', '', 90, '', '2015-07-24 14:20:06', '2015-07-24 14:20:06', 1, 1),
(1368, 130, 'Last updated at', 'updated_at', 'Date time updated', 0, 1, 0, 0, 0, 0, 'left', 4, 50, 0, '', '', '', '', '', 'usesformat=yes|formatmode=datetime|format=F d Y h:i a', 95, '', '2015-07-24 14:20:06', '2015-07-24 14:20:06', 1, 1),
(1369, 131, 'Internal Code', 'code', 'Code', 1, 1, 0, 0, 0, 0, 'left', 0, 20, 0, '', '', '', '', '', '', 0, '', '2015-07-30 14:31:30', '2015-07-30 14:31:30', 1, 1),
(1370, 131, 'Short Name', 'short_name', 'Short Name', 1, 1, 1, 1, 1, 1, 'left', 1, 50, 0, '', '', '', '', '', '', 5, '', '2015-07-30 14:31:30', '2015-07-30 14:31:30', 1, 1),
(1371, 131, 'Description', 'description', 'Description', 1, 1, 1, 1, 1, 1, 'left', 1, 150, 0, '', '', '', '', '', '', 15, '', '2015-07-30 14:31:30', '2015-07-30 14:31:30', 1, 1),
(1372, 131, 'Department', 'type_department', 'Department', 1, 1, 1, 1, 1, 0, 'left', 8, 0, 1, 'bd926c5_iisaac_test', '', '', '', '1:Underwriting|2:Collection|3:Reinsurance|4:Claims|5:Financials|6:HR Admin|7:Adhoc|8:Risk Management|9:Sales and Marketing|10:Audit', '', 35, '', '2015-07-30 14:31:30', '2015-07-30 14:31:30', 1, 1),
(1373, 131, 'Remarks', 'remarks', 'Remarks', 0, 1, 1, 1, 0, 0, 'left', 5, 50, 0, '', '', '', '', '', '', 75, '', '2015-07-30 14:31:30', '2015-07-30 14:31:30', 1, 1),
(1374, 131, 'Created by', 'created_user_mst_code', 'Username', 0, 1, 0, 0, 0, 0, 'left', 10, 50, 2, 'bd926c5_iisaac_test', 'mstuser', '', '', 'code:whole_name', '', 80, '', '2015-07-30 14:31:30', '2015-07-30 14:31:30', 1, 1),
(1375, 131, 'Created at', 'created_at', 'Date time created', 0, 1, 0, 0, 0, 0, 'left', 4, 50, 0, '', '', '', '', '', 'usesformat=yes|formatmode=datetime|format=F d Y h:i a', 85, '', '2015-07-30 14:31:30', '2015-07-30 14:31:30', 1, 1),
(1376, 131, 'Last Updated By', 'updated_user_mst_code', 'Username', 0, 1, 0, 0, 0, 0, 'left', 10, 50, 2, 'bd926c5_iisaac_test', 'mstuser', '', '', 'code:whole_name', '', 90, '', '2015-07-30 14:31:30', '2015-07-30 14:31:30', 1, 1),
(1377, 131, 'Last updated at', 'updated_at', 'Date time updated', 0, 1, 0, 0, 0, 0, 'left', 4, 50, 0, '', '', '', '', '', 'usesformat=yes|formatmode=datetime|format=F d Y h:i a', 95, '', '2015-07-30 14:31:30', '2015-07-30 14:31:30', 1, 1),
(1378, 132, 'Internal Code', 'code', 'Code', 1, 1, 0, 0, 0, 0, 'left', 0, 20, 0, '', '', '', '', '', '', 0, '', '2015-07-30 15:03:44', '2015-07-30 15:03:44', 1, 1),
(1380, 132, 'Printout Description', 'printouttype_mst_code', 'Printout Description', 1, 1, 1, 1, 1, 0, 'left', 7, 150, 2, 'bd926c5_iisaac_test', 'mstprintouttype', '1380', '1380-printouttype_mst_code', 'code:description', '', 10, '', '2015-07-30 15:03:44', '2015-07-30 15:03:44', 1, 1),
(1381, 132, 'Department', 'type_department', 'Department', 1, 1, 1, 1, 1, 0, 'left', 8, 0, 1, 'bd926c5_iisaac_test', '', '', '', '1:Underwriting|2:Collection|3:Reinsurance|4:Claims|5:Financials|6:HR Admin|7:Adhoc|8:Risk Management|9:Sales and Marketing|10:Audit', '', 5, '', '2015-07-30 15:03:44', '2015-07-30 15:03:44', 1, 1),
(1382, 132, 'Agent', 'agent_mst_code', 'Agent', 1, 1, 1, 1, 0, 0, 'left', 7, 50, 2, 'bd926c5_iisaac_test', 'mstagent', '1382', '1382-agent_mst_code', 'code:agent_name', '', 30, '', '2015-07-30 15:03:44', '2015-07-30 15:03:44', 1, 1),
(1383, 132, 'Branch', 'branch_mst_code', 'Branch', 1, 1, 1, 1, 0, 0, 'left', 7, 0, 2, 'bd926c5_iisaac_test', 'mstbranch', '1383', '1383-branch_mst_code', 'code:branch_name', '', 15, '', '2015-07-30 15:03:44', '2015-07-30 15:03:44', 1, 1),
(1384, 132, 'Line', 'line_mst_code', 'Line', 1, 1, 1, 1, 0, 0, 'left', 7, 0, 2, 'bd926c5_iisaac_test', 'mstline', '1384', '1384-line_mst_code', 'code:line_name', '', 20, '', '2015-07-30 15:03:44', '2015-07-30 15:03:44', 1, 1),
(1385, 132, 'Subline', 'subline_mst_code', 'Subline', 1, 1, 1, 1, 0, 0, 'left', 7, 0, 2, 'bd926c5_iisaac_test', 'mstsubline', '1385', '1385-subline_mst_code', 'code:subline_name', 'chainingparentid=masterfiletransaction-id-7-1384-line_mst_code|chainingparentfield=line_mst_code', 25, '', '2015-07-30 15:03:44', '2015-07-30 15:03:44', 1, 1),
(1386, 132, 'Printout Program Name', 'printout_program_name', 'Printout Program Name', 1, 1, 1, 1, 1, 0, 'left', 1, 150, 0, '', '', '', '', '', '', 35, '', '2015-07-30 15:03:44', '2015-07-30 15:03:44', 1, 1),
(1387, 132, 'Remarks', 'remarks', 'Remarks', 0, 1, 1, 1, 0, 0, 'left', 5, 50, 0, '', '', '', '', '', '', 75, '', '2015-07-30 15:03:44', '2015-07-30 15:03:44', 1, 1),
(1388, 132, 'Created by', 'created_user_mst_code', 'Username', 0, 1, 0, 0, 0, 0, 'left', 10, 50, 2, 'bd926c5_iisaac_test', 'mstuser', '', '', 'code:whole_name', '', 80, '', '2015-07-30 15:03:44', '2015-07-30 15:03:44', 1, 1),
(1389, 132, 'Created at', 'created_at', 'Date time created', 0, 1, 0, 0, 0, 0, 'left', 4, 50, 0, '', '', '', '', '', 'usesformat=yes|formatmode=datetime|format=F d Y h:i a', 85, '', '2015-07-30 15:03:44', '2015-07-30 15:03:44', 1, 1),
(1390, 132, 'Last Updated By', 'updated_user_mst_code', 'Username', 0, 1, 0, 0, 0, 0, 'left', 10, 50, 2, 'bd926c5_iisaac_test', 'mstuser', '', '', 'code:whole_name', '', 90, '', '2015-07-30 15:03:44', '2015-07-30 15:03:44', 1, 1);

INSERT INTO `_dtlmasterfiletemplatescolumns` (`code`, `master_file_templates_code`, `field_name`, `table_field_name`, `field_header_caption`, `can_display_on_table`, `can_show`, `can_add`, `can_edit`, `is_required`, `is_unique`, `alignment`, `data_type`, `max_length`, `data_source`, `data_source_database_name`, `data_source_table_name`, `data_source_table_alias`, `data_source_field_alias`, `data_source_value_pair`, `special_conditions`, `print_order`, `remarks`, `created_at`, `updated_at`, `created_user_mst_code`, `updated_user_mst_code`) VALUES
(1674, 154, 'Internal Code', 'code', 'Code', 1, 1, 0, 0, 0, 0, 'left', 0, 20, 0, '', '', '', '', '', '', 0, '', '2019-02-26 21:34:14', '2019-02-26 21:34:14', 2, 2),
(1675, 154, 'Department', 'department_mst_code', 'Department', 1, 1, 1, 1, 1, 0, 'left', 7, 0, 2, 'bd926c5_iisaac_test', 'mstdepartment', '214', '214-department_mst_code', 'code:department_name', '', 25, '', '2019-02-26 21:34:14', '2019-02-26 21:34:14', 2, 2),
(1676, 154, 'Activity Name', 'activity_name', 'Issue Name', 1, 1, 1, 1, 1, 0, 'left', 1, 500, 0, '', '', '', '', '', '', 34, '', '2019-02-26 21:34:14', '2019-02-26 21:34:14', 2, 2),
(1677, 154, 'Remarks', 'remarks', 'Remarks', 0, 1, 1, 1, 0, 0, 'left', 5, 500, 0, '', '', '', '', '', '', 75, '', '2019-02-26 21:34:14', '2019-02-26 21:34:14', 2, 2),
(1678, 154, 'Created by', 'created_user_mst_code', 'Username', 0, 1, 0, 0, 0, 0, 'left', 10, 50, 2, 'bd926c5_iisaac_test', 'mstuser', '226', '226-created_user_mst_code', 'code:whole_name', '', 80, '', '2019-02-26 21:34:14', '2019-02-26 21:34:14', 2, 2),
(1679, 154, 'Created at', 'created_at', 'Date time created', 0, 1, 0, 0, 0, 0, 'left', 4, 50, 0, '', '', '', '', '', 'usesformat=yes|formatmode=datetime|format=F d Y h:i a', 85, '', '2019-02-26 21:34:14', '2019-02-26 21:34:14', 2, 2),
(1680, 154, 'Last Updated By', 'updated_user_mst_code', 'Username', 0, 1, 0, 0, 0, 0, 'left', 10, 50, 2, 'bd926c5_iisaac_test', 'mstuser', '228', '228-updated_user_mst_code', 'code:whole_name', '', 90, '', '2019-02-26 21:34:14', '2019-02-26 21:34:14', 2, 2),
(1681, 154, 'Last updated at', 'updated_at', 'Date time updated', 0, 1, 0, 0, 0, 0, 'left', 4, 50, 0, '', '', '', '', '', 'usesformat=yes|formatmode=datetime|format=F d Y h:i a', 95, '', '2019-02-26 21:34:14', '2019-02-26 21:34:14', 2, 2),
(1682, 154, 'Is Active?', 'is_active', 'Is Active?', 1, 1, 1, 1, 1, 0, 'left', 8, 0, 1, 'bd926c5_iisaac_test', '', '', '', '1:Yes|2:No', '', 45, '', '2019-02-26 21:34:14', '2019-02-26 21:34:14', 2, 2),
(1683, 154, 'Is Motorcar Claim?', 'is_motorcar_claim', 'Is Active?', 1, 1, 1, 1, 1, 0, 'left', 8, 0, 1, 'bd926c5_iisaac_test', '', '', '', '1:Yes|2:No', '', 47, '', '2019-02-26 21:34:14', '2019-02-26 21:34:14', 2, 2),
(1684, 154, 'SLA/TAT Days', 'service_level_agreement_days', 'SLA Days', 1, 1, 1, 1, 1, 0, 'left', 2, 3, 0, '', '', '', '', '', '', 38, '', '2019-02-26 21:34:14', '2019-02-26 21:34:14', 2, 2),
(1685, 154, 'Description', 'description', 'Description', 0, 1, 1, 1, 0, 0, 'left', 5, 5000, 0, '', '', '', '', '', '', 40, '', '2019-02-26 21:34:14', '2019-02-26 21:34:14', 2, 2),
(1686, 154, 'Order no.', 'order_no', 'SLA Days', 1, 1, 1, 1, 1, 0, 'left', 2, 3, 0, '', '', '', '', '', '', 45, '', '2019-02-28 13:42:03', '2019-02-28 13:42:03', 2, 2),
(1687, 154, 'Count in SLA/TAT?', 'count_in_sla', 'Count in SLA/TAT?', 1, 1, 1, 1, 1, 0, 'left', 8, 0, 1, 'bd926c5_iisaac_test', '', '', '', '1:Yes|0:No', '', 48, '', '2019-03-11 17:29:27', '2019-03-11 17:29:27', 2, 2),
(1688, 154, 'Aging Type', 'aging_type', 'Aging Type', 1, 1, 1, 1, 1, 0, 'left', 7, 0, 1, 'bd926c5_iisaac_test', '', '', '', '0:n/a|1:Policy Holder|6:Third Party|2:Claims Comittee|3:Billing|4:Adjuster''s Report|5:Acceptance Offer', '', 49, '', '2019-03-15 15:41:13', '2019-03-15 15:41:13', 2, 2),
(1689, 155, 'Internal Code', 'code', 'Code', 1, 1, 0, 0, 0, 0, 'left', 0, 20, 0, '', '', '', '', '', '', 0, '', '2019-04-02 10:31:16', '2019-04-02 10:31:16', 2, 2),
(1690, 155, 'Recipient Type Name', 'recipient_type_name', 'Recipient Type Name', 1, 1, 1, 1, 1, 0, 'left', 1, 50, 0, '', '', '', '', '', '', 34, '', '2019-04-02 10:31:16', '2019-04-02 10:31:16', 2, 2),
(1691, 155, 'Description', 'description', 'Description', 0, 1, 1, 1, 0, 0, 'left', 5, 800, 0, '', '', '', '', '', '', 40, '', '2019-04-02 10:31:16', '2019-04-02 10:31:16', 2, 2),
(1692, 155, 'Remarks', 'remarks', 'Remarks', 0, 1, 1, 1, 0, 0, 'left', 5, 500, 0, '', '', '', '', '', '', 75, '', '2019-04-02 10:31:16', '2019-04-02 10:31:16', 2, 2),
(1693, 155, 'Created by', 'created_user_mst_code', 'Username', 0, 1, 0, 0, 0, 0, 'left', 10, 50, 2, 'bd926c5_iisaac_test', 'mstuser', '226', '226-created_user_mst_code', 'code:whole_name', '', 80, '', '2019-04-02 10:31:16', '2019-04-02 10:31:16', 2, 2),
(1694, 155, 'Created at', 'created_at', 'Date time created', 0, 1, 0, 0, 0, 0, 'left', 4, 50, 0, '', '', '', '', '', 'usesformat=yes|formatmode=datetime|format=F d Y h:i a', 85, '', '2019-04-02 10:31:16', '2019-04-02 10:31:16', 2, 2),
(1695, 155, 'Last Updated By', 'updated_user_mst_code', 'Username', 0, 1, 0, 0, 0, 0, 'left', 10, 50, 2, 'bd926c5_iisaac_test', 'mstuser', '228', '228-updated_user_mst_code', 'code:whole_name', '', 90, '', '2019-04-02 10:31:16', '2019-04-02 10:31:16', 2, 2),
(1696, 155, 'Last updated at', 'updated_at', 'Date time updated', 0, 1, 0, 0, 0, 0, 'left', 4, 50, 0, '', '', '', '', '', 'usesformat=yes|formatmode=datetime|format=F d Y h:i a', 95, '', '2019-04-02 10:31:16', '2019-04-02 10:31:16', 2, 2),
(1697, 156, 'Internal Code', 'code', 'Code', 1, 1, 0, 0, 0, 0, 'left', 0, 20, 0, '', '', '', '', '', '', 0, '', '2019-04-02 10:31:16', '2019-04-02 10:31:16', 2, 2),
(1698, 156, 'Courier Type Name', 'courier_type', 'Courier Type Name', 1, 1, 1, 1, 1, 0, 'left', 1, 50, 0, '', '', '', '', '', '', 34, '', '2019-04-02 10:31:16', '2019-04-02 10:31:16', 2, 2),
(1699, 156, 'Description', 'description', 'Description', 0, 1, 1, 1, 0, 0, 'left', 5, 800, 0, '', '', '', '', '', '', 40, '', '2019-04-02 10:31:16', '2019-04-02 10:31:16', 2, 2),
(1700, 156, 'Remarks', 'remarks', 'Remarks', 0, 1, 1, 1, 0, 0, 'left', 5, 500, 0, '', '', '', '', '', '', 75, '', '2019-04-02 10:31:16', '2019-04-02 10:31:16', 2, 2),
(1701, 156, 'Created by', 'created_user_mst_code', 'Username', 0, 1, 0, 0, 0, 0, 'left', 10, 50, 2, 'bd926c5_iisaac_test', 'mstuser', '226', '226-created_user_mst_code', 'code:whole_name', '', 80, '', '2019-04-02 10:31:16', '2019-04-02 10:31:16', 2, 2),
(1702, 156, 'Created at', 'created_at', 'Date time created', 0, 1, 0, 0, 0, 0, 'left', 4, 50, 0, '', '', '', '', '', 'usesformat=yes|formatmode=datetime|format=F d Y h:i a', 85, '', '2019-04-02 10:31:16', '2019-04-02 10:31:16', 2, 2),
(1703, 156, 'Last Updated By', 'updated_user_mst_code', 'Username', 0, 1, 0, 0, 0, 0, 'left', 10, 50, 2, 'bd926c5_iisaac_test', 'mstuser', '228', '228-updated_user_mst_code', 'code:whole_name', '', 90, '', '2019-04-02 10:31:16', '2019-04-02 10:31:16', 2, 2),
(1704, 156, 'Last updated at', 'updated_at', 'Date time updated', 0, 1, 0, 0, 0, 0, 'left', 4, 50, 0, '', '', '', '', '', 'usesformat=yes|formatmode=datetime|format=F d Y h:i a', 95, '', '2019-04-02 10:31:16', '2019-04-02 10:31:16', 2, 2),
(1705, 157, 'Internal Code', 'code', 'Code', 1, 1, 0, 0, 0, 0, 'left', 0, 20, 0, '', '', '', '', '', '', 0, '', '2019-04-02 10:31:16', '2019-04-02 10:31:16', 2, 2),
(1706, 157, 'Short Name', 'short_name', 'Short Name', 1, 1, 1, 1, 1, 1, 'left', 1, 50, 0, '', '', '', '', '', '', 5, '', '2019-04-02 10:31:16', '2019-04-02 10:31:16', 2, 2),
(1707, 157, 'Courier Type', 'delivery_courier_type_mst_code', 'Courier Type', 1, 1, 1, 1, 1, 0, 'left', 7, 0, 2, 'bd926c5_iisaac_test', 'mstdeliverycouriertype', '214', '214-delivery_courier_type_mst_code', 'code:courier_type', '', 25, '', '2019-04-02 10:31:16', '2019-04-02 10:31:16', 2, 2),
(1708, 157, 'Courier Name', 'courier_name', 'Courier Name', 1, 1, 1, 1, 1, 0, 'left', 1, 500, 0, '', '', '', '', '', '', 34, '', '2019-04-02 10:31:16', '2019-04-02 10:31:16', 2, 2),
(1709, 157, 'Remarks', 'remarks', 'Remarks', 0, 1, 1, 1, 0, 0, 'left', 5, 500, 0, '', '', '', '', '', '', 75, '', '2019-04-02 10:31:16', '2019-04-02 10:31:16', 2, 2),
(1710, 157, 'Created by', 'created_user_mst_code', 'Username', 0, 1, 0, 0, 0, 0, 'left', 10, 50, 2, 'bd926c5_iisaac_test', 'mstuser', '226', '226-created_user_mst_code', 'code:whole_name', '', 80, '', '2019-04-02 10:31:16', '2019-04-02 10:31:16', 2, 2),
(1711, 157, 'Created at', 'created_at', 'Date time created', 0, 1, 0, 0, 0, 0, 'left', 4, 50, 0, '', '', '', '', '', 'usesformat=yes|formatmode=datetime|format=F d Y h:i a', 85, '', '2019-04-02 10:31:16', '2019-04-02 10:31:16', 2, 2),
(1712, 157, 'Last Updated By', 'updated_user_mst_code', 'Username', 0, 1, 0, 0, 0, 0, 'left', 10, 50, 2, 'bd926c5_iisaac_test', 'mstuser', '228', '228-updated_user_mst_code', 'code:whole_name', '', 90, '', '2019-04-02 10:31:16', '2019-04-02 10:31:16', 2, 2),
(1713, 157, 'Last updated at', 'updated_at', 'Date time updated', 0, 1, 0, 0, 0, 0, 'left', 4, 50, 0, '', '', '', '', '', 'usesformat=yes|formatmode=datetime|format=F d Y h:i a', 95, '', '2019-04-02 10:31:16', '2019-04-02 10:31:16', 2, 2),
(1714, 157, 'Is Active?', 'is_active', 'Is Active?', 1, 1, 1, 1, 1, 0, 'left', 8, 0, 1, 'bd926c5_iisaac_test', '', '', '', '1:Yes|2:No', '', 45, '', '2019-04-02 10:31:16', '2019-04-02 10:31:16', 2, 2),
(1715, 157, 'In-house?', 'is_inhouse', 'In-house?', 1, 1, 1, 1, 1, 0, 'left', 8, 0, 1, 'bd926c5_iisaac_test', '', '', '', '1:Yes|2:No', '', 46, '', '2019-04-02 10:31:16', '2019-04-02 10:31:16', 2, 2),
(1716, 158, 'Internal Code', 'code', 'Code', 1, 1, 0, 0, 0, 0, 'left', 0, 20, 0, '', '', '', '', '', '', 0, '', '2019-04-02 16:58:09', '2019-04-02 16:58:09', 2, 2),
(1717, 158, 'Reason Name', 'dnm_reason_name', 'Reason Name', 1, 1, 1, 1, 1, 0, 'left', 1, 50, 0, '', '', '', '', '', '', 34, '', '2019-04-02 16:58:09', '2019-04-02 16:58:09', 2, 2),
(1718, 158, 'Default Remarks', 'default_reason_remarks', 'Default Reason Remarks', 0, 1, 1, 1, 0, 0, 'left', 5, 800, 0, '', '', '', '', '', '', 40, '', '2019-04-02 16:58:09', '2019-04-02 16:58:09', 2, 2),
(1719, 158, 'Remarks', 'remarks', 'Remarks', 0, 1, 1, 1, 0, 0, 'left', 5, 500, 0, '', '', '', '', '', '', 75, '', '2019-04-02 16:58:09', '2019-04-02 16:58:09', 2, 2),
(1720, 158, 'Created by', 'created_user_mst_code', 'Username', 0, 1, 0, 0, 0, 0, 'left', 10, 50, 2, 'bd926c5_iisaac_test', 'mstuser', '226', '226-created_user_mst_code', 'code:whole_name', '', 80, '', '2019-04-02 16:58:09', '2019-04-02 16:58:09', 2, 2),
(1721, 158, 'Created at', 'created_at', 'Date time created', 0, 1, 0, 0, 0, 0, 'left', 4, 50, 0, '', '', '', '', '', 'usesformat=yes|formatmode=datetime|format=F d Y h:i a', 85, '', '2019-04-02 16:58:09', '2019-04-02 16:58:09', 2, 2),
(1722, 158, 'Last Updated By', 'updated_user_mst_code', 'Username', 0, 1, 0, 0, 0, 0, 'left', 10, 50, 2, 'bd926c5_iisaac_test', 'mstuser', '228', '228-updated_user_mst_code', 'code:whole_name', '', 90, '', '2019-04-02 16:58:09', '2019-04-02 16:58:09', 2, 2),
(1723, 158, 'Last updated at', 'updated_at', 'Date time updated', 0, 1, 0, 0, 0, 0, 'left', 4, 50, 0, '', '', '', '', '', 'usesformat=yes|formatmode=datetime|format=F d Y h:i a', 95, '', '2019-04-02 16:58:09', '2019-04-02 16:58:09', 2, 2),
(1724, 159, 'File Type', 'uploaded_file_type_mst_code', 'File Type', 1, 1, 0, 1, 1, 0, 'left', 10, 0, 2, 'bd926c5_iisaac_test', 'mstuploadingfiletype', '10', '10-uploaded_file_type_mst_code', 'code:file_type_name', 'remotelink=api/ReceiveSelect2Tables.php|templatefileloc=includes/typeaheadtemplates/mstuploadedfiletype.html', 20, '', '2019-05-08 19:10:29', '2019-05-08 19:10:29', 2, 2),
(1725, 160, 'Internal Code', 'code', 'Code', 1, 1, 0, 0, 0, 0, 'left', 0, 20, 0, '', '', '', '', '', '', 0, '', '2019-05-09 10:02:30', '2019-05-09 10:02:30', 2, 2),
(1726, 160, 'Short Name', 'short_name', 'Short Name', 1, 1, 1, 1, 1, 1, 'left', 1, 50, 0, '', '', '', '', '', '', 5, '', '2019-05-09 10:03:20', '2019-05-09 10:03:20', 2, 2),
(1727, 160, 'File Type Name', 'file_type_name', 'File Type Name', 1, 1, 1, 1, 1, 0, 'left', 1, 50, 0, '', '', '', '', '', '', 34, '', '2019-05-09 10:04:42', '2019-05-09 10:04:42', 2, 2),
(1728, 160, 'Description', 'description', 'Description', 1, 1, 1, 1, 1, 0, 'left', 1, 50, 0, '', '', '', '', '', '', 34, '', '2019-05-09 10:05:51', '2019-05-09 10:05:51', 2, 2),
(1729, 160, 'Remarks', 'remarks', 'Remarks', 0, 1, 1, 1, 0, 0, 'left', 5, 500, 0, '', '', '', '', '', '', 75, '', '2019-05-09 10:07:07', '2019-05-09 10:07:07', 2, 2),
(1730, 160, 'Created by', 'created_user_mst_code', 'Username', 0, 1, 0, 0, 0, 0, 'left', 10, 50, 2, 'bd926c5_iisaac_test', 'mstuser', '226', '226-created_user_mst_code', 'code:whole_name', '', 80, '', '2019-05-09 10:07:07', '2019-05-09 10:07:07', 2, 2),
(1731, 160, 'Created at', 'created_at', 'Date time created', 0, 1, 0, 0, 0, 0, 'left', 4, 50, 0, '', '', '', '', '', 'usesformat=yes|formatmode=datetime|format=F d Y h:i a', 85, '', '2019-05-09 10:07:07', '2019-05-09 10:07:07', 2, 2),
(1732, 160, 'Last Updated By', 'updated_user_mst_code', 'Username', 0, 1, 0, 0, 0, 0, 'left', 10, 50, 2, 'bd926c5_iisaac_test', 'mstuser', '228', '228-updated_user_mst_code', 'code:whole_name', '', 90, '', '2019-05-09 10:07:07', '2019-05-09 10:07:07', 2, 2),
(1733, 160, 'Last updated at', 'updated_at', 'Date time updated', 0, 1, 0, 0, 0, 0, 'left', 4, 50, 0, '', '', '', '', '', 'usesformat=yes|formatmode=datetime|format=F d Y h:i a', 95, '', '2019-05-09 10:07:07', '2019-05-09 10:07:07', 2, 2),
(1734, 159, 'Internal Code', 'code', 'Code', 1, 1, 0, 0, 0, 0, 'left', 0, 20, 0, '', '', '', '', '', '', 0, '', '2019-05-09 10:02:30', '2019-05-09 10:02:30', 2, 2),
(1826, 159, 'Transaction Number', 'transaction_type_trn_code', 'Transaction Number', 0, 1, 0, 0, 1, 0, 'left', 10, 0, 2, 'bd926c5_iisaac_test', 'trnorigpolicy', '20', '20-transaction_type_trn_code', 'code:policy_number', 'remotelink=api/ReceiveSelect2Tables.php|templatefileloc=includes/typeaheadtemplates/trnorigpolicy.html', 20, '', '2019-05-08 19:10:29', '2019-05-08 19:10:29', 2, 2),
(1827, 159, 'Column A', 'Field_0', 'Column A', 1, 1, 1, 1, 1, 0, 'left', 1, 50, 0, '', '', '', '', '', '', 34, '', '2019-05-09 10:05:51', '2019-05-09 10:05:51', 2, 2),
(1828, 159, 'Column B', 'Field_1', 'Column B', 1, 1, 1, 1, 1, 0, 'left', 1, 50, 0, '', '', '', '', '', '', 34, '', '2019-05-09 10:05:51', '2019-05-09 10:05:51', 2, 2),
(1829, 159, 'Column C', 'Field_2', 'Column C', 1, 1, 1, 1, 1, 0, 'left', 1, 50, 0, '', '', '', '', '', '', 34, '', '2019-05-09 10:05:51', '2019-05-09 10:05:51', 2, 2),
(1830, 159, 'Column D', 'Field_3', 'Column D', 0, 1, 1, 1, 1, 0, 'left', 1, 50, 0, '', '', '', '', '', '', 34, '', '2019-05-09 10:05:51', '2019-05-09 10:05:51', 2, 2),
(1831, 159, 'Column E', 'Field_4', 'Column E', 1, 1, 1, 1, 1, 0, 'left', 1, 50, 0, '', '', '', '', '', '', 34, '', '2019-05-09 10:05:51', '2019-05-09 10:05:51', 2, 2),
(1832, 159, 'Column F', 'Field_5', 'Column F', 0, 1, 1, 1, 1, 0, 'left', 1, 50, 0, '', '', '', '', '', '', 34, '', '2019-05-09 10:05:51', '2019-05-09 10:05:51', 2, 2),
(1833, 159, 'Column G', 'Field_6', 'Column G', 0, 1, 1, 1, 1, 0, 'left', 1, 50, 0, '', '', '', '', '', '', 34, '', '2019-05-09 10:05:51', '2019-05-09 10:05:51', 2, 2),
(1834, 159, 'Column H', 'Field_7', 'Column H', 0, 1, 1, 1, 1, 0, 'left', 1, 50, 0, '', '', '', '', '', '', 34, '', '2019-05-09 10:05:51', '2019-05-09 10:05:51', 2, 2),
(1835, 159, 'Column I', 'Field_8', 'Column I', 0, 1, 1, 1, 1, 0, 'left', 1, 50, 0, '', '', '', '', '', '', 34, '', '2019-05-09 10:05:51', '2019-05-09 10:05:51', 2, 2),
(1836, 159, 'Column J', 'Field_9', 'Column J', 0, 1, 1, 1, 1, 0, 'left', 1, 50, 0, '', '', '', '', '', '', 34, '', '2019-05-09 10:05:51', '2019-05-09 10:05:51', 2, 2),
(1837, 159, 'Column K', 'Field_10', 'Column K', 0, 1, 1, 1, 1, 0, 'left', 1, 50, 0, '', '', '', '', '', '', 34, '', '2019-05-09 10:05:51', '2019-05-09 10:05:51', 2, 2),
(1838, 159, 'Column L', 'Field_11', 'Column L', 0, 1, 1, 1, 1, 0, 'left', 1, 50, 0, '', '', '', '', '', '', 34, '', '2019-05-09 10:05:51', '2019-05-09 10:05:51', 2, 2),
(1839, 159, 'Column M', 'Field_12', 'Column M', 0, 1, 1, 1, 1, 0, 'left', 1, 50, 0, '', '', '', '', '', '', 34, '', '2019-05-09 10:05:51', '2019-05-09 10:05:51', 2, 2),
(1840, 159, 'Column N', 'Field_13', 'Column N', 0, 1, 1, 1, 1, 0, 'left', 1, 50, 0, '', '', '', '', '', '', 34, '', '2019-05-09 10:05:51', '2019-05-09 10:05:51', 2, 2),
(1841, 159, 'Column O', 'Field_14', 'Column O', 0, 1, 1, 1, 1, 0, 'left', 1, 50, 0, '', '', '', '', '', '', 34, '', '2019-05-09 10:05:51', '2019-05-09 10:05:51', 2, 2),
(1842, 159, 'Column P', 'Field_15', 'Column P', 0, 1, 1, 1, 1, 0, 'left', 1, 50, 0, '', '', '', '', '', '', 34, '', '2019-05-09 10:05:51', '2019-05-09 10:05:51', 2, 2),
(1843, 159, 'Column Q', 'Field_16', 'Column Q', 0, 1, 1, 1, 1, 0, 'left', 1, 50, 0, '', '', '', '', '', '', 34, '', '2019-05-09 10:05:51', '2019-05-09 10:05:51', 2, 2),
(1844, 159, 'Column R', 'Field_17', 'Column R', 0, 1, 1, 1, 1, 0, 'left', 1, 50, 0, '', '', '', '', '', '', 34, '', '2019-05-09 10:05:51', '2019-05-09 10:05:51', 2, 2),
(1845, 159, 'Column S', 'Field_18', 'Column S', 0, 1, 1, 1, 1, 0, 'left', 1, 50, 0, '', '', '', '', '', '', 34, '', '2019-05-09 10:05:51', '2019-05-09 10:05:51', 2, 2),
(1846, 159, 'Column T', 'Field_19', 'Column T', 0, 1, 1, 1, 1, 0, 'left', 1, 50, 0, '', '', '', '', '', '', 34, '', '2019-05-09 10:05:51', '2019-05-09 10:05:51', 2, 2),
(1847, 159, 'Column U', 'Field_20', 'Column U', 0, 1, 1, 1, 1, 0, 'left', 1, 50, 0, '', '', '', '', '', '', 34, '', '2019-05-09 10:05:51', '2019-05-09 10:05:51', 2, 2),
(1848, 159, 'Column V', 'Field_21', 'Column V', 0, 1, 1, 1, 1, 0, 'left', 1, 50, 0, '', '', '', '', '', '', 34, '', '2019-05-09 10:05:51', '2019-05-09 10:05:51', 2, 2),
(1849, 159, 'Column W', 'Field_22', 'Column W', 0, 1, 1, 1, 1, 0, 'left', 1, 50, 0, '', '', '', '', '', '', 34, '', '2019-05-09 10:05:51', '2019-05-09 10:05:51', 2, 2),
(1850, 159, 'Column X', 'Field_23', 'Column X', 0, 1, 1, 1, 1, 0, 'left', 1, 50, 0, '', '', '', '', '', '', 34, '', '2019-05-09 10:05:51', '2019-05-09 10:05:51', 2, 2),
(1851, 159, 'Column Y', 'Field_24', 'Column Y', 0, 1, 1, 1, 1, 0, 'left', 1, 50, 0, '', '', '', '', '', '', 34, '', '2019-05-09 10:05:51', '2019-05-09 10:05:51', 2, 2),
(1852, 159, 'Column Z', 'Field_25', 'Column Z', 0, 1, 1, 1, 1, 0, 'left', 1, 50, 0, '', '', '', '', '', '', 34, '', '2019-05-09 10:05:51', '2019-05-09 10:05:51', 2, 2),
(1853, 159, 'Column AA', 'Field_26', 'Column AA', 0, 1, 1, 1, 1, 0, 'left', 1, 50, 0, '', '', '', '', '', '', 34, '', '2019-05-09 10:05:51', '2019-05-09 10:05:51', 2, 2),
(1854, 159, 'Column AB', 'Field_27', 'Column AB', 0, 1, 1, 1, 1, 0, 'left', 1, 50, 0, '', '', '', '', '', '', 34, '', '2019-05-09 10:05:51', '2019-05-09 10:05:51', 2, 2),
(1855, 159, 'Column AC', 'Field_28', 'Column AC', 0, 1, 1, 1, 1, 0, 'left', 1, 50, 0, '', '', '', '', '', '', 34, '', '2019-05-09 10:05:51', '2019-05-09 10:05:51', 2, 2),
(1856, 159, 'Column AD', 'Field_29', 'Column AD', 0, 1, 1, 1, 1, 0, 'left', 1, 50, 0, '', '', '', '', '', '', 34, '', '2019-05-09 10:05:51', '2019-05-09 10:05:51', 2, 2),
(1857, 159, 'Column AE', 'Field_30', 'Column AE', 0, 1, 1, 1, 1, 0, 'left', 1, 50, 0, '', '', '', '', '', '', 34, '', '2019-05-09 10:05:51', '2019-05-09 10:05:51', 2, 2),
(1858, 159, 'Remarks', 'remarks', 'Remarks', 0, 1, 1, 1, 0, 0, 'left', 5, 500, 0, '', '', '', '', '', '', 75, '', '2019-05-09 10:07:07', '2019-05-09 10:07:07', 2, 2),
(1859, 159, 'Created by', 'created_user_mst_code', 'Username', 0, 1, 0, 0, 0, 0, 'left', 10, 50, 2, 'bd926c5_iisaac_test', 'mstuser', '226', '226-created_user_mst_code', 'code:whole_name', '', 80, '', '2019-05-09 10:07:07', '2019-05-09 10:07:07', 2, 2),
(1860, 159, 'Created at', 'created_at', 'Date time created', 0, 1, 0, 0, 0, 0, 'left', 4, 50, 0, '', '', '', '', '', 'usesformat=yes|formatmode=datetime|format=F d Y h:i a', 85, '', '2019-05-09 10:07:07', '2019-05-09 10:07:07', 2, 2),
(1861, 159, 'Last Updated By', 'updated_user_mst_code', 'Username', 0, 1, 0, 0, 0, 0, 'left', 10, 50, 2, 'bd926c5_iisaac_test', 'mstuser', '228', '228-updated_user_mst_code', 'code:whole_name', '', 90, '', '2019-05-09 10:07:07', '2019-05-09 10:07:07', 2, 2),
(1862, 159, 'Last updated at', 'updated_at', 'Date time updated', 0, 1, 0, 0, 0, 0, 'left', 4, 50, 0, '', '', '', '', '', 'usesformat=yes|formatmode=datetime|format=F d Y h:i a', 95, '', '2019-05-09 10:07:07', '2019-05-09 10:07:07', 2, 2),
(1863, 161, 'Internal Code', 'code', 'Code', 1, 1, 0, 0, 0, 0, 'left', 0, 20, 0, '', '', '', '', '', '', 0, '', '2019-05-22 19:15:47', '2019-05-22 19:15:47', 2, 2),
(1864, 161, 'Department', 'department_mst_code', 'Department', 1, 1, 1, 1, 1, 0, 'left', 7, 0, 2, 'bd926c5_iisaac_test', 'mstdepartment', '214', '214-department_mst_code', 'code:department_name', '', 25, '', '2019-05-22 19:15:47', '2019-05-22 19:15:47', 2, 2),
(1865, 161, 'Short Name', 'short_name', 'Short Name', 0, 1, 1, 1, 1, 0, 'left', 1, 3, 0, '', '', '', '', '', '', 30, '', '2019-05-22 19:15:47', '2019-05-22 19:15:47', 2, 2),
(1866, 161, 'Category Name', 'category_name', 'Category Name', 1, 1, 1, 1, 1, 0, 'left', 1, 500, 0, '', '', '', '', '', '', 34, '', '2019-05-22 19:15:47', '2019-05-22 19:15:47', 2, 2),
(1867, 161, 'Remarks', 'remarks', 'Remarks', 0, 1, 1, 1, 0, 0, 'left', 5, 500, 0, '', '', '', '', '', '', 75, '', '2019-05-22 19:15:47', '2019-05-22 19:15:47', 2, 2),
(1868, 161, 'Created by', 'created_user_mst_code', 'Username', 0, 1, 0, 0, 0, 0, 'left', 10, 50, 2, 'bd926c5_iisaac_test', 'mstuser', '226', '226-created_user_mst_code', 'code:whole_name', '', 80, '', '2019-05-22 19:15:47', '2019-05-22 19:15:47', 2, 2),
(1869, 161, 'Created at', 'created_at', 'Date time created', 0, 1, 0, 0, 0, 0, 'left', 4, 50, 0, '', '', '', '', '', 'usesformat=yes|formatmode=datetime|format=F d Y h:i a', 85, '', '2019-05-22 19:15:47', '2019-05-22 19:15:47', 2, 2),
(1870, 161, 'Last Updated By', 'updated_user_mst_code', 'Username', 0, 1, 0, 0, 0, 0, 'left', 10, 50, 2, 'bd926c5_iisaac_test', 'mstuser', '228', '228-updated_user_mst_code', 'code:whole_name', '', 90, '', '2019-05-22 19:15:47', '2019-05-22 19:15:47', 2, 2),
(1871, 161, 'Last updated at', 'updated_at', 'Date time updated', 0, 1, 0, 0, 0, 0, 'left', 4, 50, 0, '', '', '', '', '', 'usesformat=yes|formatmode=datetime|format=F d Y h:i a', 95, '', '2019-05-22 19:15:47', '2019-05-22 19:15:47', 2, 2),
(1872, 161, 'Is Active?', 'is_active', 'Is Active?', 0, 1, 1, 1, 1, 0, 'left', 8, 0, 1, 'bd926c5_iisaac_test', '', '', '', '1:Yes|2:No', '', 45, '', '2019-05-22 19:15:47', '2019-05-22 19:15:47', 2, 2),
(1873, 162, 'Internal Code', 'code', 'Code', 1, 1, 0, 0, 0, 0, 'left', 0, 20, 0, '', '', '', '', '', '', 0, '', '2019-05-22 19:33:30', '2019-05-22 19:33:30', 2, 2),
(1874, 162, 'Department', 'department_mst_code', 'Department', 1, 1, 1, 1, 1, 0, 'left', 7, 0, 2, 'bd926c5_iisaac_test', 'mstdepartment', '898', '898department_name-department_mst_code', 'code:department_name', '', 20, '', '2019-05-22 19:33:30', '2019-05-22 19:33:30', 2, 2),
(1875, 162, 'Call Category', 'customer_call_category_mst_code', 'Call Category', 1, 1, 1, 1, 1, 0, 'left', 7, 0, 2, 'bd926c5_iisaac_test', 'mstcustomercallcategory', '899', '899category_name-customer_call_category_mst_code', 'code:category_name', 'chainingparentid=masterfiletransaction-id-7-1874-department_mst_code|chainingparentfield=department_mst_code', 25, '', '2019-05-22 19:33:30', '2019-05-22 19:33:30', 2, 2),
(1876, 162, 'Caller Name', 'caller_name', 'Caller Name', 1, 1, 1, 1, 1, 0, 'left', 5, 500, 0, '', '', '', '', '', '', 30, '', '2019-05-22 19:33:30', '2019-05-22 19:33:30', 2, 2),
(1877, 162, 'Caller Number (optional)', 'caller_number', 'Caller Number', 0, 1, 1, 1, 0, 0, 'left', 5, 200, 0, '', '', '', '', '', '', 35, '', '2019-05-22 19:33:30', '2019-05-22 19:33:30', 2, 2),
(1878, 162, 'Caller Remarks', 'caller_remarks', 'Caller remarks', 0, 1, 1, 1, 0, 0, 'left', 5, 10000, 0, '', '', '', '', '', '', 40, '', '2019-05-22 19:33:30', '2019-05-22 19:33:30', 2, 2),
(1879, 162, 'Remarks', 'remarks', 'Remarks', 0, 1, 1, 1, 0, 0, 'left', 5, 50, 0, '', '', '', '', '', '', 75, '', '2019-05-22 19:33:30', '2019-05-22 19:33:30', 2, 2),
(1880, 162, 'Created by', 'created_user_mst_code', 'Username', 0, 1, 0, 0, 0, 0, 'left', 10, 50, 2, 'bd926c5_iisaac_test', 'mstuser', '901', '901-created_user_mst_code', 'code:whole_name', '', 80, '', '2019-05-22 19:33:30', '2019-05-22 19:33:30', 2, 2),
(1881, 162, 'Created at', 'created_at', 'Date time created', 0, 1, 0, 0, 0, 0, 'left', 4, 50, 0, '', '', '', '', '', 'usesformat=yes|formatmode=datetime|format=F d Y h:i a', 85, '', '2019-05-22 19:33:30', '2019-05-22 19:33:30', 2, 2),
(1882, 162, 'Last Updated By', 'updated_user_mst_code', 'Username', 0, 1, 0, 0, 0, 0, 'left', 10, 50, 2, 'bd926c5_iisaac_test', 'mstuser', '903', '903-updated_user_mst_code', 'code:whole_name', '', 90, '', '2019-05-22 19:33:30', '2019-05-22 19:33:30', 2, 2),
(1883, 162, 'Last updated at', 'updated_at', 'Date time updated', 0, 1, 0, 0, 0, 0, 'left', 4, 50, 0, '', '', '', '', '', 'usesformat=yes|formatmode=datetime|format=F d Y h:i a', 95, '', '2019-05-22 19:33:30', '2019-05-22 19:33:30', 2, 2),
(1884, 159, 'Transaction Item Number', 'transaction_type_item_trn_code', 'Transaction Item Number', 0, 1, 0, 0, 1, 0, 'left', 10, 0, 2, 'bd926c5_iisaac_test', 'trnorigpolicydtlitem', '20', '20-transaction_type_item_trn_code', 'code:item_no', 'remotelink=api/ReceiveSelect2Tables.php|templatefileloc=includes/typeaheadtemplates/trnorigpolicy.html', 20, '', '2019-05-08 19:10:29', '2019-05-08 19:10:29', 2, 2),
(1885, 159, 'Status', 'is_uploaded', 'Status', 1, 1, 0, 0, 1, 0, 'left', 10, 0, 1, 'bd926c5_iisaac_test', '', '', '', '0:For Uploading|1:Uploaded', '', 50, '', '2019-05-08 19:10:29', '2019-05-08 19:10:29', 2, 2),
(1886, 168, 'Internal Code', 'code', 'Code', 1, 1, 0, 0, 0, 0, 'left', 0, 20, 0, '', '', '', '', '', '', 0, '', '2019-09-02 14:43:15', '2019-09-02 14:43:15', 2, 2),
(1887, 168, 'Short Name', 'short_name', 'Short Name', 1, 1, 1, 1, 1, 0, 'left', 1, 20, 0, '', '', '', '', '', '', 30, '', '2019-09-02 14:43:15', '2019-09-02 14:43:15', 2, 2),
(1888, 168, 'Grouping Name', 'grouping_name', 'Category Name', 1, 1, 1, 1, 1, 0, 'left', 1, 500, 0, '', '', '', '', '', '', 34, '', '2019-09-02 14:43:15', '2019-09-02 14:43:15', 2, 2),
(1889, 168, 'Is Active?', 'is_active', 'Is Active?', 1, 1, 1, 1, 1, 0, 'left', 8, 0, 1, 'bd926c5_iisaac_test', '', '', '', '1:Yes|2:No', '', 45, '', '2019-09-02 14:43:15', '2019-09-02 14:43:15', 2, 2),
(1890, 168, 'Remarks', 'remarks', 'Remarks', 0, 1, 1, 1, 0, 0, 'left', 5, 500, 0, '', '', '', '', '', '', 75, '', '2019-09-02 14:43:15', '2019-09-02 14:43:15', 2, 2),
(1891, 168, 'Created by', 'created_user_mst_code', 'Username', 0, 1, 0, 0, 0, 0, 'left', 10, 50, 2, 'bd926c5_iisaac_test', 'mstuser', '226', '226-created_user_mst_code', 'code:whole_name', '', 80, '', '2019-09-02 14:43:15', '2019-09-02 14:43:15', 2, 2),
(1892, 168, 'Created at', 'created_at', 'Date time created', 0, 1, 0, 0, 0, 0, 'left', 4, 50, 0, '', '', '', '', '', 'usesformat=yes|formatmode=datetime|format=F d Y h:i a', 85, '', '2019-09-02 14:43:15', '2019-09-02 14:43:15', 2, 2),
(1893, 168, 'Last Updated By', 'updated_user_mst_code', 'Username', 0, 1, 0, 0, 0, 0, 'left', 10, 50, 2, 'bd926c5_iisaac_test', 'mstuser', '228', '228-updated_user_mst_code', 'code:whole_name', '', 90, '', '2019-09-02 14:43:15', '2019-09-02 14:43:15', 2, 2),
(1894, 168, 'Last updated at', 'updated_at', 'Date time updated', 0, 1, 0, 0, 0, 0, 'left', 4, 50, 0, '', '', '', '', '', 'usesformat=yes|formatmode=datetime|format=F d Y h:i a', 95, '', '2019-09-02 14:43:15', '2019-09-02 14:43:15', 2, 2),
(1895, 164, 'Internal Code', 'code', 'Code', 1, 1, 0, 0, 0, 0, 'left', 0, 20, 0, '', '', '', '', '', '', 0, '', '2019-09-02 15:00:51', '2019-09-02 15:00:51', 2, 2),
(1896, 164, 'Short Name', 'short_name', 'Short Name', 1, 1, 1, 1, 1, 0, 'left', 1, 20, 0, '', '', '', '', '', '', 10, '', '2019-09-02 15:00:51', '2019-09-02 15:00:51', 2, 2),
(1897, 164, 'PNB Grouping', 'pnb_grouping_mst_code', 'PNB Grouping', 1, 1, 1, 1, 1, 0, 'left', 7, 0, 2, 'bd926c5_iisaac_test', 'mstpnbgrouping', '898', '898-pnb_grouping_mst_code', 'code:grouping_name', '', 20, '', '2019-09-02 15:00:51', '2019-09-02 15:00:51', 2, 2),
(1898, 164, 'Region Name', 'region_name', 'Region Name', 1, 1, 1, 1, 1, 0, 'left', 1, 500, 0, '', '', '', '', '', '', 34, '', '2019-09-02 15:00:51', '2019-09-02 15:00:51', 2, 2),
(1899, 164, 'Is Active?', 'is_active', 'Is Active?', 1, 1, 1, 1, 1, 0, 'left', 8, 0, 1, 'bd926c5_iisaac_test', '', '', '', '1:Yes|2:No', '', 45, '', '2019-09-02 15:00:51', '2019-09-02 15:00:51', 2, 2),
(1900, 164, 'Remarks', 'remarks', 'Remarks', 0, 1, 1, 1, 0, 0, 'left', 5, 500, 0, '', '', '', '', '', '', 75, '', '2019-09-02 15:00:51', '2019-09-02 15:00:51', 2, 2),
(1901, 164, 'Created by', 'created_user_mst_code', 'Username', 0, 1, 0, 0, 0, 0, 'left', 10, 50, 2, 'bd926c5_iisaac_test', 'mstuser', '226', '226-created_user_mst_code', 'code:whole_name', '', 80, '', '2019-09-02 15:00:51', '2019-09-02 15:00:51', 2, 2),
(1902, 164, 'Created at', 'created_at', 'Date time created', 0, 1, 0, 0, 0, 0, 'left', 4, 50, 0, '', '', '', '', '', 'usesformat=yes|formatmode=datetime|format=F d Y h:i a', 85, '', '2019-09-02 15:00:51', '2019-09-02 15:00:51', 2, 2),
(1903, 164, 'Last Updated By', 'updated_user_mst_code', 'Username', 0, 1, 0, 0, 0, 0, 'left', 10, 50, 2, 'bd926c5_iisaac_test', 'mstuser', '228', '228-updated_user_mst_code', 'code:whole_name', '', 90, '', '2019-09-02 15:00:51', '2019-09-02 15:00:51', 2, 2),
(1904, 164, 'Last updated at', 'updated_at', 'Date time updated', 0, 1, 0, 0, 0, 0, 'left', 4, 50, 0, '', '', '', '', '', 'usesformat=yes|formatmode=datetime|format=F d Y h:i a', 95, '', '2019-09-02 15:00:51', '2019-09-02 15:00:51', 2, 2),
(1905, 165, 'Internal Code', 'code', 'Code', 1, 1, 0, 0, 0, 0, 'left', 0, 20, 0, '', '', '', '', '', '', 0, '', '2019-09-02 15:19:21', '2019-09-02 15:19:21', 2, 2),
(1906, 165, 'Short Name', 'short_name', 'Short Name', 1, 1, 1, 1, 1, 0, 'left', 1, 20, 0, '', '', '', '', '', '', 10, '', '2019-09-02 15:19:21', '2019-09-02 15:19:21', 2, 2),
(1907, 165, 'PNB Grouping', 'pnb_grouping_mst_code', 'PNB Grouping', 1, 1, 1, 1, 1, 0, 'left', 7, 0, 2, 'bd926c5_iisaac_test', 'mstpnbgrouping', '898', '898-pnb_grouping_mst_code', 'code:grouping_name', '', 20, '', '2019-09-02 15:19:21', '2019-09-02 15:19:21', 2, 2),
(1908, 165, 'PNB Region', 'pnb_region_mst_code', 'PNB Region', 1, 1, 1, 1, 1, 0, 'left', 7, 0, 2, 'bd926c5_iisaac_test', 'mstpnbregion', '899', '899-pnb_region_mst_code', 'code:region_name', 'chainingparentid=masterfiletransaction-id-7-1907-pnb_grouping_mst_code|chainingparentfield=pnb_grouping_mst_code', 25, '', '2019-09-02 15:19:21', '2019-09-02 15:19:21', 2, 2),
(1909, 165, 'Area/Unit Name', 'area_unit_name', 'Area/Unit Name', 1, 1, 1, 1, 1, 0, 'left', 1, 500, 0, '', '', '', '', '', '', 34, '', '2019-09-02 15:19:21', '2019-09-02 15:19:21', 2, 2),
(1910, 165, 'Is Active?', 'is_active', 'Is Active?', 1, 1, 1, 1, 1, 0, 'left', 8, 0, 1, 'bd926c5_iisaac_test', '', '', '', '1:Yes|2:No', '', 45, '', '2019-09-02 15:19:21', '2019-09-02 15:19:21', 2, 2),
(1911, 165, 'Remarks', 'remarks', 'Remarks', 0, 1, 1, 1, 0, 0, 'left', 5, 500, 0, '', '', '', '', '', '', 75, '', '2019-09-02 15:19:21', '2019-09-02 15:19:21', 2, 2),
(1912, 165, 'Created by', 'created_user_mst_code', 'Username', 0, 1, 0, 0, 0, 0, 'left', 10, 50, 2, 'bd926c5_iisaac_test', 'mstuser', '226', '226-created_user_mst_code', 'code:whole_name', '', 80, '', '2019-09-02 15:19:21', '2019-09-02 15:19:21', 2, 2),
(1913, 165, 'Created at', 'created_at', 'Date time created', 0, 1, 0, 0, 0, 0, 'left', 4, 50, 0, '', '', '', '', '', 'usesformat=yes|formatmode=datetime|format=F d Y h:i a', 85, '', '2019-09-02 15:19:21', '2019-09-02 15:19:21', 2, 2),
(1914, 165, 'Last Updated By', 'updated_user_mst_code', 'Username', 0, 1, 0, 0, 0, 0, 'left', 10, 50, 2, 'bd926c5_iisaac_test', 'mstuser', '228', '228-updated_user_mst_code', 'code:whole_name', '', 90, '', '2019-09-02 15:19:21', '2019-09-02 15:19:21', 2, 2),
(1915, 165, 'Last updated at', 'updated_at', 'Date time updated', 0, 1, 0, 0, 0, 0, 'left', 4, 50, 0, '', '', '', '', '', 'usesformat=yes|formatmode=datetime|format=F d Y h:i a', 95, '', '2019-09-02 15:19:21', '2019-09-02 15:19:21', 2, 2),
(1916, 166, 'Internal Code', 'code', 'Code', 1, 1, 0, 0, 0, 0, 'left', 0, 20, 0, '', '', '', '', '', '', 0, '', '2019-09-02 15:42:09', '2019-09-02 15:42:09', 2, 2),
(1917, 166, 'Account Officer Name', 'whole_name', 'Account Officer Name', 1, 0, 0, 0, 0, 0, 'left', 1, 600, 0, '', '', '', '', '', '', 10, '', '2019-09-02 15:42:09', '2019-09-02 15:42:09', 2, 2),
(1918, 166, 'PNB Grouping', 'pnb_grouping_mst_code', 'PNB Grouping', 1, 1, 1, 1, 1, 0, 'left', 7, 0, 2, 'bd926c5_iisaac_test', 'mstpnbgrouping', '898', '898-pnb_grouping_mst_code', 'code:grouping_name', '', 20, '', '2019-09-02 15:42:09', '2019-09-02 15:42:09', 2, 2),
(1919, 166, 'PNB Region', 'pnb_region_mst_code', 'PNB Region', 1, 1, 1, 1, 1, 0, 'left', 7, 0, 2, 'bd926c5_iisaac_test', 'mstpnbregion', '899', '899-pnb_region_mst_code', 'code:region_name', 'chainingparentid=masterfiletransaction-id-7-1918-pnb_grouping_mst_code|chainingparentfield=pnb_grouping_mst_code', 25, '', '2019-09-02 15:42:09', '2019-09-02 15:42:09', 2, 2),
(1920, 166, 'PNB Area/Unit', 'pnb_area_unit_mst_code', 'PNB Area/Unit', 1, 1, 1, 1, 1, 0, 'left', 7, 0, 2, 'bd926c5_iisaac_test', 'mstpnbareaunit', '900', '900-pnb_area_unit_mst_code', 'code:area_unit_name', 'chainingparentid=masterfiletransaction-id-7-1919-pnb_region_mst_code|chainingparentfield=pnb_region_mst_code', 30, '', '2019-09-02 15:42:09', '2019-09-02 15:42:09', 2, 2),
(1921, 166, 'First Name', 'first_name', 'First Name', 0, 1, 1, 1, 1, 0, 'left', 1, 200, 0, '', '', '', '', '', '', 35, '', '2019-09-02 15:42:09', '2019-09-02 15:42:09', 2, 2),
(1922, 166, 'Middle Name', 'middle_name', 'Middle Name', 0, 1, 1, 1, 0, 0, 'left', 1, 200, 0, '', '', '', '', '', '', 40, '', '2019-09-02 15:42:09', '2019-09-02 15:42:09', 2, 2),
(1923, 166, 'Last Name', 'last_name', 'Last Name', 0, 1, 1, 1, 1, 0, 'left', 1, 200, 0, '', '', '', '', '', '', 45, '', '2019-09-02 15:42:09', '2019-09-02 15:42:09', 2, 2),
(1924, 166, 'PNB ID no.', 'pnb_id_no', 'PNB ID no.', 1, 1, 1, 1, 0, 0, 'left', 1, 200, 0, '', '', '', '', '', '', 55, '', '2019-09-02 15:42:09', '2019-09-02 15:42:09', 2, 2),
(1925, 166, 'Is Active?', 'is_active', 'Is Active?', 1, 1, 1, 1, 1, 0, 'left', 8, 0, 1, 'bd926c5_iisaac_test', '', '', '', '1:Yes|2:No', '', 60, '', '2019-09-02 15:42:09', '2019-09-02 15:42:09', 2, 2),
(1926, 166, 'Phone Number', 'phone_number', 'Phone Number', 0, 1, 1, 1, 0, 0, 'left', 5, 200, 0, '', '', '', '', '', '', 65, '', '2019-09-02 15:42:09', '2019-09-02 15:42:09', 2, 2),
(1927, 166, 'Cellphone Number', 'cellphone_number', 'Cellphone Number', 0, 1, 1, 1, 0, 0, 'left', 5, 200, 0, '', '', '', '', '', '', 70, '', '2019-09-02 15:42:09', '2019-09-02 15:42:09', 2, 2),
(1928, 166, 'Email Address', 'email_address', 'Email Address', 0, 1, 1, 1, 0, 0, 'left', 5, 200, 0, '', '', '', '', '', '', 75, '', '2019-09-02 15:42:09', '2019-09-02 15:42:09', 2, 2),
(1929, 166, 'Mailing Address', 'complete_address', 'Mailing Address', 0, 1, 1, 1, 0, 0, 'left', 5, 1000, 0, '', '', '', '', '', '', 80, '', '2019-09-02 15:42:09', '2019-09-02 15:42:09', 2, 2),
(1930, 166, 'Remarks', 'remarks', 'Remarks', 0, 1, 1, 1, 0, 0, 'left', 5, 500, 0, '', '', '', '', '', '', 85, '', '2019-09-02 15:42:09', '2019-09-02 15:42:09', 2, 2),
(1931, 166, 'Created by', 'created_user_mst_code', 'Username', 0, 1, 0, 0, 0, 0, 'left', 10, 50, 2, 'bd926c5_iisaac_test', 'mstuser', '226', '226-created_user_mst_code', 'code:whole_name', '', 90, '', '2019-09-02 15:42:09', '2019-09-02 15:42:09', 2, 2),
(1932, 166, 'Created at', 'created_at', 'Date time created', 0, 1, 0, 0, 0, 0, 'left', 4, 50, 0, '', '', '', '', '', 'usesformat=yes|formatmode=datetime|format=F d Y h:i a', 95, '', '2019-09-02 15:42:09', '2019-09-02 15:42:09', 2, 2),
(1933, 166, 'Last Updated By', 'updated_user_mst_code', 'Username', 0, 1, 0, 0, 0, 0, 'left', 10, 50, 2, 'bd926c5_iisaac_test', 'mstuser', '228', '228-updated_user_mst_code', 'code:whole_name', '', 100, '', '2019-09-02 15:42:09', '2019-09-02 15:42:09', 2, 2),
(1934, 166, 'Last updated at', 'updated_at', 'Date time updated', 0, 1, 0, 0, 0, 0, 'left', 4, 50, 0, '', '', '', '', '', 'usesformat=yes|formatmode=datetime|format=F d Y h:i a', 105, '', '2019-09-02 15:42:09', '2019-09-02 15:42:09', 2, 2),
(1936, 167, 'Internal Code', 'code', 'Code', 1, 1, 0, 0, 0, 0, 'left', 0, 20, 0, '', '', '', '', '', '', 0, '', '2019-09-02 17:00:20', '2019-09-02 17:00:20', 2, 2),
(1937, 167, 'Branch Code', 'branch_code', 'Branch Code', 1, 1, 1, 1, 1, 1, 'left', 1, 50, 0, '', '', '', '', '', '', 10, '', '2019-09-02 17:00:20', '2019-09-02 17:00:20', 2, 2),
(1938, 167, 'PNB Grouping', 'pnb_grouping_mst_code', 'PNB Grouping', 1, 1, 1, 1, 1, 0, 'left', 7, 0, 2, 'bd926c5_iisaac_test', 'mstpnbgrouping', '898', '898-pnb_grouping_mst_code', 'code:grouping_name', '', 20, '', '2019-09-02 17:00:20', '2019-09-02 17:00:20', 2, 2),
(1939, 167, 'PNB Region', 'pnb_region_mst_code', 'PNB Region', 1, 1, 1, 1, 1, 0, 'left', 7, 0, 2, 'bd926c5_iisaac_test', 'mstpnbregion', '899', '899-pnb_region_mst_code', 'code:region_name', 'chainingparentid=masterfiletransaction-id-7-1938-pnb_grouping_mst_code|chainingparentfield=pnb_grouping_mst_code', 25, '', '2019-09-02 17:00:20', '2019-09-02 17:00:20', 2, 2),
(1940, 167, 'PNB Area/Unit', 'pnb_area_unit_mst_code', 'PNB Area/Unit', 1, 1, 1, 1, 1, 0, 'left', 7, 0, 2, 'bd926c5_iisaac_test', 'mstpnbareaunit', '900', '900-pnb_area_unit_mst_code', 'code:area_unit_name', 'chainingparentid=masterfiletransaction-id-7-1939-pnb_region_mst_code|chainingparentfield=pnb_region_mst_code', 30, '', '2019-09-02 17:00:20', '2019-09-02 17:00:20', 2, 2),
(1941, 167, 'Old Branch Code', 'old_branch_code', 'Old Branch Code', 1, 1, 1, 1, 0, 0, 'left', 1, 50, 0, '', '', '', '', '', '', 35, '', '2019-09-02 17:00:20', '2019-09-02 17:00:20', 2, 2),
(1942, 167, 'Other Branch Code', 'other_branch_code', 'Other Branch Code', 0, 1, 1, 1, 0, 0, 'left', 1, 50, 0, '', '', '', '', '', '', 40, '', '2019-09-02 17:00:20', '2019-09-02 17:00:20', 2, 2),
(1943, 167, 'Branch Name', 'branch_name', 'Branch Name', 1, 1, 1, 1, 1, 0, 'left', 1, 200, 0, '', '', '', '', '', '', 55, '', '2019-09-02 17:00:20', '2019-09-02 17:00:20', 2, 2),
(1944, 167, 'Is Active?', 'is_active', 'Is Active?', 1, 1, 1, 1, 1, 0, 'left', 8, 0, 1, 'bd926c5_iisaac_test', '', '', '', '1:Yes|2:No', '', 60, '', '2019-09-02 17:00:20', '2019-09-02 17:00:20', 2, 2),
(1945, 167, 'Phone Number', 'phone_number', 'Phone Number', 0, 1, 1, 1, 0, 0, 'left', 5, 200, 0, '', '', '', '', '', '', 65, '', '2019-09-02 17:00:20', '2019-09-02 17:00:20', 2, 2),
(1946, 167, 'Cellphone Number', 'cellphone_number', 'Cellphone Number', 0, 1, 1, 1, 0, 0, 'left', 5, 200, 0, '', '', '', '', '', '', 70, '', '2019-09-02 17:00:20', '2019-09-02 17:00:20', 2, 2),
(1947, 167, 'Email Address', 'email_address', 'Email Address', 0, 1, 1, 1, 0, 0, 'left', 5, 200, 0, '', '', '', '', '', '', 75, '', '2019-09-02 17:00:20', '2019-09-02 17:00:20', 2, 2),
(1948, 167, 'Mailing Address', 'complete_address', 'Mailing Address', 0, 1, 1, 1, 0, 0, 'left', 5, 1000, 0, '', '', '', '', '', '', 80, '', '2019-09-02 17:00:20', '2019-09-02 17:00:20', 2, 2),
(1949, 167, 'Contact Person', 'contact_person', 'Contact Person', 0, 1, 1, 1, 0, 0, 'left', 1, 200, 0, '', '', '', '', '', '', 83, '', '2019-09-02 17:00:20', '2019-09-02 17:00:20', 2, 2),
(1950, 167, 'Remarks', 'remarks', 'Remarks', 0, 1, 1, 1, 0, 0, 'left', 5, 500, 0, '', '', '', '', '', '', 85, '', '2019-09-02 17:00:20', '2019-09-02 17:00:20', 2, 2),
(1951, 167, 'Created by', 'created_user_mst_code', 'Username', 0, 1, 0, 0, 0, 0, 'left', 10, 50, 2, 'bd926c5_iisaac_test', 'mstuser', '226', '226-created_user_mst_code', 'code:whole_name', '', 90, '', '2019-09-02 17:00:20', '2019-09-02 17:00:20', 2, 2),
(1952, 167, 'Created at', 'created_at', 'Date time created', 0, 1, 0, 0, 0, 0, 'left', 4, 50, 0, '', '', '', '', '', 'usesformat=yes|formatmode=datetime|format=F d Y h:i a', 95, '', '2019-09-02 17:00:20', '2019-09-02 17:00:20', 2, 2),
(1953, 167, 'Last Updated By', 'updated_user_mst_code', 'Username', 0, 1, 0, 0, 0, 0, 'left', 10, 50, 2, 'bd926c5_iisaac_test', 'mstuser', '228', '228-updated_user_mst_code', 'code:whole_name', '', 100, '', '2019-09-02 17:00:20', '2019-09-02 17:00:20', 2, 2),
(1954, 167, 'Last updated at', 'updated_at', 'Date time updated', 0, 1, 0, 0, 0, 0, 'left', 4, 50, 0, '', '', '', '', '', 'usesformat=yes|formatmode=datetime|format=F d Y h:i a', 105, '', '2019-09-02 17:00:20', '2019-09-02 17:00:20', 2, 2),
(1955, 163, 'Internal Code', 'code', 'Code', 1, 1, 0, 0, 0, 0, 'left', 0, 20, 0, '', '', '', '', '', '', 0, '', '2019-09-02 17:18:32', '2019-09-02 17:18:32', 2, 2),
(1956, 163, 'Referror Name', 'whole_name', 'Referror Name', 1, 0, 0, 0, 0, 0, 'left', 1, 600, 0, '', '', '', '', '', '', 10, '', '2019-09-02 17:18:32', '2019-09-02 17:18:32', 2, 2),
(1957, 163, 'PNB Grouping', 'pnb_grouping_mst_code', 'PNB Grouping', 1, 1, 1, 1, 1, 0, 'left', 7, 0, 2, 'bd926c5_iisaac_test', 'mstpnbgrouping', '898', '898-pnb_grouping_mst_code', 'code:grouping_name', '', 20, '', '2019-09-02 17:18:32', '2019-09-02 17:18:32', 2, 2),
(1958, 163, 'PNB Region', 'pnb_region_mst_code', 'PNB Region', 1, 1, 1, 1, 1, 0, 'left', 7, 0, 2, 'bd926c5_iisaac_test', 'mstpnbregion', '899', '899-pnb_region_mst_code', 'code:region_name', 'chainingparentid=masterfiletransaction-id-7-1957-pnb_grouping_mst_code|chainingparentfield=pnb_grouping_mst_code', 25, '', '2019-09-02 17:18:32', '2019-09-02 17:18:32', 2, 2),
(1959, 163, 'PNB Area/Unit', 'pnb_area_unit_mst_code', 'PNB Area/Unit', 1, 1, 1, 1, 1, 0, 'left', 7, 0, 2, 'bd926c5_iisaac_test', 'mstpnbareaunit', '900', '900-pnb_area_unit_mst_code', 'code:area_unit_name', 'chainingparentid=masterfiletransaction-id-7-1958-pnb_region_mst_code|chainingparentfield=pnb_region_mst_code', 30, '', '2019-09-02 17:18:32', '2019-09-02 17:18:32', 2, 2),
(1960, 163, 'PNB Branch', 'pnb_branch_mst_code', 'PNB Branch', 1, 1, 1, 1, 1, 0, 'left', 7, 0, 2, 'bd926c5_iisaac_test', 'mstpnbbranch', '901', '901-pnb_branch_mst_code', 'code:branch_name', 'chainingparentid=masterfiletransaction-id-7-1959-pnb_area_unit_mst_code|chainingparentfield=pnb_area_unit_mst_code', 35, '', '2019-09-02 17:18:32', '2019-09-02 17:18:32', 2, 2),
(1961, 163, 'First Name', 'first_name', 'First Name', 0, 1, 1, 1, 1, 0, 'left', 1, 200, 0, '', '', '', '', '', '', 37, '', '2019-09-02 17:18:32', '2019-09-02 17:18:32', 2, 2),
(1962, 163, 'Middle Name', 'middle_name', 'Middle Name', 0, 1, 1, 1, 0, 0, 'left', 1, 200, 0, '', '', '', '', '', '', 40, '', '2019-09-02 17:18:32', '2019-09-02 17:18:32', 2, 2),
(1963, 163, 'Last Name', 'last_name', 'Last Name', 0, 1, 1, 1, 1, 0, 'left', 1, 200, 0, '', '', '', '', '', '', 45, '', '2019-09-02 17:18:32', '2019-09-02 17:18:32', 2, 2),
(1964, 163, 'Employee ID', 'employee_id', 'Employee ID', 1, 1, 1, 1, 0, 0, 'left', 1, 200, 0, '', '', '', '', '', '', 55, '', '2019-09-02 17:18:32', '2019-09-02 17:18:32', 2, 2),
(1965, 163, 'PNB Account Number', 'pnb_account_number', 'PNB Account Number', 0, 1, 1, 1, 0, 0, 'left', 1, 200, 0, '', '', '', '', '', '', 55, '', '2019-09-02 17:18:32', '2019-09-02 17:18:32', 2, 2),
(1966, 163, 'Is Active?', 'is_active', 'Is Active?', 1, 1, 1, 1, 1, 0, 'left', 8, 0, 1, 'bd926c5_iisaac_test', '', '', '', '1:Yes|2:No', '', 60, '', '2019-09-02 17:18:32', '2019-09-02 17:18:32', 2, 2),
(1967, 163, 'Phone Number', 'phone_number', 'Phone Number', 0, 1, 1, 1, 0, 0, 'left', 5, 200, 0, '', '', '', '', '', '', 65, '', '2019-09-02 17:18:32', '2019-09-02 17:18:32', 2, 2),
(1968, 163, 'Cellphone Number', 'cellphone_number', 'Cellphone Number', 0, 1, 1, 1, 0, 0, 'left', 5, 200, 0, '', '', '', '', '', '', 70, '', '2019-09-02 17:18:32', '2019-09-02 17:18:32', 2, 2),
(1969, 163, 'Email Address', 'email_address', 'Email Address', 0, 1, 1, 1, 0, 0, 'left', 5, 200, 0, '', '', '', '', '', '', 75, '', '2019-09-02 17:18:32', '2019-09-02 17:18:32', 2, 2),
(1970, 163, 'Mailing Address', 'complete_address', 'Mailing Address', 0, 1, 1, 1, 0, 0, 'left', 5, 1000, 0, '', '', '', '', '', '', 80, '', '2019-09-02 17:18:32', '2019-09-02 17:18:32', 2, 2),
(1971, 163, 'Remarks', 'remarks', 'Remarks', 0, 1, 1, 1, 0, 0, 'left', 5, 500, 0, '', '', '', '', '', '', 85, '', '2019-09-02 17:18:32', '2019-09-02 17:18:32', 2, 2),
(1972, 163, 'Created by', 'created_user_mst_code', 'Username', 0, 1, 0, 0, 0, 0, 'left', 10, 50, 2, 'bd926c5_iisaac_test', 'mstuser', '226', '226-created_user_mst_code', 'code:whole_name', '', 90, '', '2019-09-02 17:18:32', '2019-09-02 17:18:32', 2, 2),
(1973, 163, 'Created at', 'created_at', 'Date time created', 0, 1, 0, 0, 0, 0, 'left', 4, 50, 0, '', '', '', '', '', 'usesformat=yes|formatmode=datetime|format=F d Y h:i a', 95, '', '2019-09-02 17:18:32', '2019-09-02 17:18:32', 2, 2),
(1974, 163, 'Last Updated By', 'updated_user_mst_code', 'Username', 0, 1, 0, 0, 0, 0, 'left', 10, 50, 2, 'bd926c5_iisaac_test', 'mstuser', '228', '228-updated_user_mst_code', 'code:whole_name', '', 100, '', '2019-09-02 17:18:32', '2019-09-02 17:18:32', 2, 2),
(1975, 163, 'Last updated at', 'updated_at', 'Date time updated', 0, 1, 0, 0, 0, 0, 'left', 4, 50, 0, '', '', '', '', '', 'usesformat=yes|formatmode=datetime|format=F d Y h:i a', 105, '', '2019-09-02 17:18:32', '2019-09-02 17:18:32', 2, 2),
(1976, 163, 'ABIC Agent Code', 'agent_mst_code', 'ABIC Agent Code', 0, 1, 1, 1, 1, 0, 'left', 7, 50, 2, 'bd926c5_iisaac_test', 'mstagent', '1382', '1382-agent_mst_code', 'code:agent_name agent_code', 'remotelink=api/ReceiveTypeaheadTables.php|templatefileloc=includes/typeaheadtemplates/mstagent.html', 57, '', '2019-09-26 11:16:51', '2019-09-26 11:16:51', 2, 2),
(1977, 168, 'Office Code', 'office_code', 'Office Code', 0, 1, 1, 1, 1, 0, 'left', 1, 20, 0, '', '', '', '', '', '', 50, '', '2019-10-08 09:33:44', '2019-10-08 09:33:44', 2, 2),
(1978, 164, 'Office Code', 'office_code', 'Office Code', 0, 1, 1, 1, 1, 0, 'left', 1, 20, 0, '', '', '', '', '', '', 50, '', '2019-10-08 09:33:44', '2019-10-08 09:33:44', 2, 2),
(1979, 165, 'Office Code', 'office_code', 'Office Code', 0, 1, 1, 1, 1, 0, 'left', 1, 20, 0, '', '', '', '', '', '', 50, '', '2019-10-08 09:33:44', '2019-10-08 09:33:44', 2, 2),
(1980, 167, 'Zip Code', 'zip_code', 'Zip Code', 0, 1, 1, 1, 0, 0, 'left', 1, 6, 0, '', '', '', '', '', '', 82, '', '2019-10-08 13:06:54', '2019-10-08 13:06:54', 2, 2),
(1981, 167, 'Old Branch Name', 'old_branch_name', 'Old Branch Name', 0, 1, 1, 1, 0, 0, 'left', 1, 200, 0, '', '', '', '', '', '', 37, '', '2019-10-08 13:06:54', '2019-10-08 13:06:54', 2, 2),
(1982, 170, 'Internal Code', 'code', 'Code', 1, 1, 0, 0, 0, 0, 'left', 0, 20, 0, '', '', '', '', '', '', 0, '', '2019-02-26 21:34:14', '2019-02-26 21:34:14', 2, 2),
(1983, 170, 'Department', 'department_mst_code', 'Department', 1, 1, 1, 1, 1, 0, 'left', 7, 0, 2, 'bd926c5_iisaac_test', 'mstdepartment', '214', '214-department_mst_code', 'code:department_name', '', 25, '', '2019-02-26 21:34:14', '2019-02-26 21:34:14', 2, 2),
(1984, 170, 'Activity Name', 'activity_name', 'Issue Name', 1, 1, 1, 1, 1, 0, 'left', 1, 500, 0, '', '', '', '', '', '', 34, '', '2019-02-26 21:34:14', '2019-02-26 21:34:14', 2, 2),
(1985, 170, 'Remarks', 'remarks', 'Remarks', 0, 1, 1, 1, 0, 0, 'left', 5, 500, 0, '', '', '', '', '', '', 75, '', '2019-02-26 21:34:14', '2019-02-26 21:34:14', 2, 2),
(1986, 170, 'Created by', 'created_user_mst_code', 'Username', 0, 1, 0, 0, 0, 0, 'left', 10, 50, 2, 'bd926c5_iisaac_test', 'mstuser', '226', '226-created_user_mst_code', 'code:whole_name', '', 80, '', '2019-02-26 21:34:14', '2019-02-26 21:34:14', 2, 2),
(1987, 170, 'Created at', 'created_at', 'Date time created', 0, 1, 0, 0, 0, 0, 'left', 4, 50, 0, '', '', '', '', '', 'usesformat=yes|formatmode=datetime|format=F d Y h:i a', 85, '', '2019-02-26 21:34:14', '2019-02-26 21:34:14', 2, 2),
(1988, 170, 'Last Updated By', 'updated_user_mst_code', 'Username', 0, 1, 0, 0, 0, 0, 'left', 10, 50, 2, 'bd926c5_iisaac_test', 'mstuser', '228', '228-updated_user_mst_code', 'code:whole_name', '', 90, '', '2019-02-26 21:34:14', '2019-02-26 21:34:14', 2, 2),
(1989, 170, 'Last updated at', 'updated_at', 'Date time updated', 0, 1, 0, 0, 0, 0, 'left', 4, 50, 0, '', '', '', '', '', 'usesformat=yes|formatmode=datetime|format=F d Y h:i a', 95, '', '2019-02-26 21:34:14', '2019-02-26 21:34:14', 2, 2),
(1990, 170, 'Is Active?', 'is_active', 'Is Active?', 1, 1, 1, 1, 1, 0, 'left', 8, 0, 1, 'bd926c5_iisaac_test', '', '', '', '1:Yes|2:No', '', 45, '', '2019-02-26 21:34:14', '2019-02-26 21:34:14', 2, 2),
(1991, 170, 'SLA/TAT Days', 'service_level_agreement_days', 'SLA Days', 1, 1, 1, 1, 1, 0, 'left', 2, 3, 0, '', '', '', '', '', '', 38, '', '2019-02-26 21:34:14', '2019-02-26 21:34:14', 2, 2),
(1992, 170, 'Description', 'description', 'Description', 0, 1, 1, 1, 0, 0, 'left', 5, 5000, 0, '', '', '', '', '', '', 40, '', '2019-02-26 21:34:14', '2019-02-26 21:34:14', 2, 2),
(1993, 170, 'Order no.', 'order_no', 'SLA Days', 1, 1, 1, 1, 1, 0, 'left', 2, 3, 0, '', '', '', '', '', '', 45, '', '2019-02-28 13:42:03', '2019-02-28 13:42:03', 2, 2),
(1994, 73, 'RSMD Class', 'rsmd_class', 'RSMD Class', 1, 1, 1, 1, 1, 0, 'left', 2, 50, 0, '', '', '', '', '', '', 25, '', '2015-05-27 23:15:21', '2015-05-27 23:15:21', 1, 1),
(1995, 74, 'Is Active?', 'is_active', 'Is Active?', 1, 1, 1, 1, 1, 0, 'left', 8, 0, 1, 'bd926c5_iisaac_test', '', '', '', '1:Yes|2:No', '', 20, '', '2020-06-04 16:04:54', '2020-06-04 16:04:54', 2, 2),
(1996, 172, 'Internal Code', 'code', 'Primary Key', 1, 1, 0, 0, 0, 0, 'center', 0, 0, 0, '', '', '', '', '', '', 0, '', '2021-01-20 12:13:31', '2021-01-20 12:13:31', 69, 69),
(1997, 172, 'Description', 'description', 'Description of the action', 1, 1, 1, 1, 1, 1, 'left', 1, 30, 0, '', '', '', '', '', '', 5, '', '2021-01-20 12:13:31', '2021-01-20 12:13:31', 69, 69),
(1998, 172, 'API Key', 'api_key', 'API Key', 0, 1, 1, 0, 1, 0, 'left', 5, 100, 0, '', '', '', '', '', '', 10, '', '2021-01-20 12:13:31', '2021-01-20 12:13:31', 69, 69),
(1999, 172, 'IP Address', 'ip_address', 'IP Address', 1, 1, 1, 1, 1, 0, 'left', 1, 50, 0, '', '', '', '', '', '', 15, '', '2021-01-20 12:13:31', '2021-01-20 12:13:31', 69, 69);
INSERT INTO `_dtlmasterfiletemplatescolumns` (`code`, `master_file_templates_code`, `field_name`, `table_field_name`, `field_header_caption`, `can_display_on_table`, `can_show`, `can_add`, `can_edit`, `is_required`, `is_unique`, `alignment`, `data_type`, `max_length`, `data_source`, `data_source_database_name`, `data_source_table_name`, `data_source_table_alias`, `data_source_field_alias`, `data_source_value_pair`, `special_conditions`, `print_order`, `remarks`, `created_at`, `updated_at`, `created_user_mst_code`, `updated_user_mst_code`) VALUES
(2000, 172, 'Valid Date', 'valid_date', 'Valid Date', 1, 1, 1, 1, 0, 0, 'left', 4, 50, 0, '', '', '', '', '', 'usesformat=yes|formatmode=datetime|format=F d Y', 20, '', '2021-01-20 12:13:31', '2021-01-20 12:13:31', 69, 69),
(2001, 172, 'Is Active?', 'is_active', 'Is Active?', 1, 1, 1, 1, 1, 0, 'left', 8, 0, 1, 'bd926c5_iisaac_test', '', '', '', '1:Yes|2:No', '', 25, '', '2021-01-20 12:13:31', '2021-01-20 12:13:31', 69, 69),
(2002, 172, 'Remarks', 'remarks', 'Remarks', 0, 1, 1, 1, 0, 0, 'left', 5, 500, 3, '', '', '', '', '', '', 50, '', '2021-01-20 12:13:31', '2021-01-20 12:13:31', 69, 69),
(2003, 172, 'Created by', 'created_user_mst_code', 'Username', 0, 1, 0, 0, 0, 0, 'left', 10, 50, 2, 'bd926c5_iisaac_test', 'mstuser', '5', '5-created_user_mst_code', 'code:whole_name', '', 55, '', '2021-01-20 12:13:31', '2021-01-20 12:13:31', 69, 69),
(2004, 172, 'Created at', 'created_at', 'Date time created', 0, 1, 0, 0, 0, 0, 'left', 4, 50, 0, '', '', '', '', '', 'usesformat=yes|formatmode=datetime|format=F d Y h:i a', 60, '', '2021-01-20 12:13:31', '2021-01-20 12:13:31', 69, 69),
(2005, 172, 'Last Updated By', 'updated_user_mst_code', 'Username', 0, 1, 0, 0, 0, 0, 'left', 10, 50, 2, 'bd926c5_iisaac_test', 'mstuser', '7', '7-updated_user_mst_code', 'code:whole_name', '', 65, '', '2021-01-20 12:13:31', '2021-01-20 12:13:31', 69, 69),
(2006, 172, 'Last updated at', 'updated_at', 'Date time updated', 0, 1, 0, 0, 0, 0, 'left', 4, 50, 0, '', '', '', '', '', 'usesformat=yes|formatmode=datetime|format=F d Y h:i a', 70, '', '2021-01-20 12:13:31', '2021-01-20 12:13:31', 69, 69),
(2007, 101, 'Branch', 'branch_mst_code', 'Branch', 1, 1, 1, 1, 0, 0, 'left', 7, 0, 2, 'bd926c5_iisaac_test', 'mstbranch', 'mstagent_branch', 'mstagent_branch_code-branch_mst_code', 'code:branch_name', '', 4, '', '2021-01-20 17:58:04', '2021-01-20 17:58:04', 2, 2),
(2008, 16, 'Department Head User MST', 'department_head_user_mst_code', 'Department Head User MST', 1, 1, 1, 1, 1, 0, 'left', 10, 0, 2, 'bd926c5_iisaac_test', 'mstuser', 'deptuser', 'deptuser-department_head_user_mst_code', 'code:username whole_name user_image_code', 'remotelink=api/ReceiveSelect2Tables.php|templatefileloc=includes/typeaheadtemplates/mstuser.html', 28, '', '2021-03-23 10:33:31', '2021-03-23 10:33:31', 2, 2),
(2009, 173, 'Internal Code', 'code', 'Code', 1, 1, 0, 0, 0, 0, 'left', 0, 20, 0, '', '', '', '', '', '', 0, '', '2021-06-08 18:30:41', '2021-06-08 18:30:41', 2, 2),
(2010, 173, 'Short Name', 'short_name', 'Short Name', 1, 1, 1, 1, 1, 1, 'left', 1, 50, 0, '', '', '', '', '', '', 5, '', '2021-06-08 18:30:41', '2021-06-08 18:30:41', 2, 2),
(2011, 173, 'Reason Name', 'non_renewal_reason_name', 'Non Renewal Reason Name', 1, 1, 1, 1, 1, 1, 'left', 1, 200, 0, '', '', '', '', '', '', 15, '', '2021-06-08 18:30:41', '2021-06-08 18:30:41', 2, 2),
(2012, 173, 'Description', 'description', 'Description', 0, 1, 1, 1, 0, 0, 'left', 5, 500, 0, '', '', '', '', '', '', 20, '', '2021-06-08 18:30:41', '2021-06-08 18:30:41', 2, 2),
(2013, 173, 'Remarks', 'remarks', 'Remarks', 0, 1, 1, 1, 0, 0, 'left', 5, 50, 0, '', '', '', '', '', '', 75, '', '2021-06-08 18:30:41', '2021-06-08 18:30:41', 2, 2),
(2014, 173, 'Created by', 'created_user_mst_code', 'Username', 0, 1, 0, 0, 0, 0, 'left', 10, 50, 2, 'bd926c5_iisaac_test', 'mstuser', '503', '503-created_user_mst_code', 'code:whole_name', '', 80, '', '2021-06-08 18:30:41', '2021-06-08 18:30:41', 2, 2),
(2015, 173, 'Created at', 'created_at', 'Date time created', 0, 1, 0, 0, 0, 0, 'left', 4, 50, 0, '', '', '', '', '', 'usesformat=yes|formatmode=datetime|format=F d Y h:i a', 85, '', '2021-06-08 18:30:41', '2021-06-08 18:30:41', 2, 2),
(2016, 173, 'Last Updated By', 'updated_user_mst_code', 'Username', 0, 1, 0, 0, 0, 0, 'left', 10, 50, 2, 'bd926c5_iisaac_test', 'mstuser', '505', '505-updated_user_mst_code', 'code:whole_name', '', 90, '', '2021-06-08 18:30:41', '2021-06-08 18:30:41', 2, 2),
(2017, 173, 'Last updated at', 'updated_at', 'Date time updated', 0, 1, 0, 0, 0, 0, 'left', 4, 50, 0, '', '', '', '', '', 'usesformat=yes|formatmode=datetime|format=F d Y h:i a', 95, '', '2021-06-08 18:30:41', '2021-06-08 18:30:41', 2, 2),
(2018, 157, 'Designation', 'courier_designation', 'Designation', 1, 1, 1, 1, 1, 0, 'left', 8, 0, 1, 'bd926c5_iisaac_test', '', '', '', '0:n/a|1:Motorized Messenger|2:Company Driver', '', 47, '', '2021-09-21 10:25:16', '2021-09-21 10:25:16', 2, 2),
(2020, 174, 'Internal Code', 'code', 'Code', 1, 1, 0, 0, 0, 0, 'left', 0, 20, 0, '', '', '', '', '', '', 0, '', '2021-10-11 13:55:27', '2021-10-11 13:55:27', 2, 2),
(2021, 174, 'Department', 'type_department', 'Department', 1, 1, 1, 1, 1, 0, 'left', 8, 0, 1, 'bd926c5_iisaac_test', '', '', '', '1:Underwriting|2:Collection|3:Reinsurance|4:Claims|5:Financials|6:HR Admin|7:Adhoc|8:Risk Management|9:Sales and Marketing|10:Audit', '', 5, '', '2021-10-11 13:55:27', '2021-10-11 13:55:27', 2, 2),
(2022, 174, 'Report Type', 'report_type_mst_code', 'Report Type', 1, 1, 1, 1, 1, 0, 'left', 7, 150, 2, 'bd926c5_iisaac_test', 'mstreporttype', 'reptype', 'reptype-report_type_mst_code', 'code:description', '', 10, '', '2021-10-11 13:55:27', '2021-10-11 13:55:27', 2, 2),
(2023, 174, 'Genweb Report Name', 'genweb_report_name', 'Genweb Report Name', 1, 1, 1, 1, 1, 0, 'left', 1, 150, 0, '', '', '', '', '', '', 35, '', '2021-10-11 13:55:27', '2021-10-11 13:55:27', 1, 1),
(2024, 174, 'Report Filters', 'report_filters', 'Report Filters', 0, 1, 1, 1, 1, 0, 'left', 1, 2000, 0, '', '', '', '', '', '', 55, '', '2021-10-11 13:55:27', '2021-10-11 13:55:27', 2, 2),
(2025, 174, 'Program Name', 'main_program_name', 'Main Program Name', 1, 1, 1, 1, 1, 0, 'left', 1, 500, 0, '', '', '', '', '', '', 45, '', '2021-10-11 13:55:27', '2021-10-11 13:55:27', 2, 2),
(2026, 174, 'Remarks', 'remarks', 'Remarks', 0, 1, 1, 1, 0, 0, 'left', 5, 500, 3, '', '', '', '', '', '', 65, '', '2021-10-11 13:55:27', '2021-10-11 13:55:27', 2, 2),
(2027, 174, 'Created by', 'created_user_mst_code', 'Username', 0, 1, 0, 0, 0, 0, 'left', 10, 50, 2, 'bd926c5_iisaac_test', 'mstuser', '5', '5-created_user_mst_code', 'code:whole_name', '', 75, '', '2021-10-11 13:55:27', '2021-10-11 13:55:27', 2, 2),
(2028, 174, 'Created at', 'created_at', 'Date time created', 0, 1, 0, 0, 0, 0, 'left', 4, 50, 0, '', '', '', '', '', 'usesformat=yes|formatmode=datetime|format=F d Y h:i a', 85, '', '2021-10-11 13:55:27', '2021-10-11 13:55:27', 2, 2),
(2029, 174, 'Last Updated By', 'updated_user_mst_code', 'Username', 0, 1, 0, 0, 0, 0, 'left', 10, 50, 2, 'bd926c5_iisaac_test', 'mstuser', '7', '7-updated_user_mst_code', 'code:whole_name', '', 95, '', '2021-10-11 13:55:27', '2021-10-11 13:55:27', 2, 2),
(2030, 174, 'Last updated at', 'updated_at', 'Date time updated', 0, 1, 0, 0, 0, 0, 'left', 4, 50, 0, '', '', '', '', '', 'usesformat=yes|formatmode=datetime|format=F d Y h:i a', 105, '', '2021-10-11 13:55:27', '2021-10-11 13:55:27', 2, 2),
(2031, 175, 'Internal Code', 'code', 'Code', 1, 1, 0, 0, 0, 0, 'left', 0, 20, 0, '', '', '', '', '', '', 0, '', '2021-10-11 13:55:27', '2021-10-11 13:55:27', 2, 2),
(2032, 175, 'Genweb Report Name', 'genweb_report_name_mst_code', 'Genweb Report Name', 1, 1, 1, 1, 1, 0, 'left', 7, 0, 2, 'bd926c5_iisaac_test', 'mstgenwebreportsname', 'repname', 'repname-genweb_report_name_mst_code', 'code:genweb_report_name', '', 10, '', '2021-10-11 13:55:27', '2021-10-11 13:55:27', 2, 2),
(2033, 175, 'Report Filter', 'report_name_filter_mst_code', 'Report Filter', 1, 1, 1, 1, 1, 0, 'left', 7, 0, 2, 'bd926c5_iisaac_test', 'mstreportnamefilters', 'repfilter', 'repfilter-report_name_filter_mst_code', 'code:filter_name', '', 10, '', '2021-10-11 13:55:27', '2021-10-11 13:55:27', 2, 2),
(2034, 175, 'Is Required?', 'is_required', 'Is Required', 0, 1, 1, 1, 1, 0, 'left', 8, 0, 1, 'bd926c5_iisaac_test', '', '', '', '1:Yes|2:No', '', 50, '', '2021-10-11 13:55:27', '2021-10-11 13:55:27', 2, 2),
(2035, 175, 'Is Unique?', 'is_unique', 'Is Unique', 0, 1, 1, 1, 1, 0, 'left', 8, 0, 1, 'bd926c5_iisaac_test', '', '', '', '1:Yes|2:No', '', 60, '', '2021-10-11 13:55:27', '2021-10-11 13:55:27', 2, 2),
(2036, 175, 'Display Order', 'display_order', 'Display order number', 1, 1, 1, 1, 1, 0, 'right', 2, 4, 0, '', '', '', '', '', '', 70, '', '2021-10-11 13:55:27', '2021-10-11 13:55:27', 2, 2),
(2037, 175, 'Memo Field (programmers use)', 'memo_field', 'Memo Field (programmers use)', 0, 1, 1, 1, 0, 0, 'left', 5, 2000, 0, '', '', '', '', '', '', 80, '', '2021-10-11 13:55:27', '2021-10-11 13:55:27', 2, 2),
(2038, 175, 'Special Condition 1 (programmers use)', 'special_condition1', 'Special Condition 1 (programmers use)', 0, 1, 1, 1, 0, 0, 'left', 5, 2000, 0, '', '', '', '', '', '', 90, '', '2021-10-11 13:55:27', '2021-10-11 13:55:27', 2, 2),
(2039, 175, 'Special Condition 2 (programmers use)', 'special_condition2', 'Special Condition 2 (programmers use)', 0, 1, 1, 1, 0, 0, 'left', 5, 2000, 0, '', '', '', '', '', '', 100, '', '2021-10-11 13:55:27', '2021-10-11 13:55:27', 2, 2),
(2040, 175, 'Remarks', 'remarks', 'Remarks', 0, 1, 1, 1, 0, 0, 'left', 5, 500, 0, '', '', '', '', '', '', 110, '', '2021-10-11 13:55:27', '2021-10-11 13:55:27', 2, 2),
(2041, 175, 'Created by', 'created_user_mst_code', 'Username', 0, 1, 0, 0, 0, 0, 'left', 10, 50, 2, 'bd926c5_iisaac_test', 'mstuser', 'creus', 'creus-created_user_mst_code', 'code:whole_name', '', 120, '', '2021-10-11 13:55:27', '2021-10-11 13:55:27', 2, 2),
(2042, 175, 'Created at', 'created_at', 'Date time created', 0, 1, 0, 0, 0, 0, 'left', 4, 50, 0, '', '', '', '', '', 'usesformat=yes|formatmode=datetime|format=F d Y h:i a', 130, '', '2021-10-11 13:55:27', '2021-10-11 13:55:27', 2, 2),
(2043, 175, 'Last Updated By', 'updated_user_mst_code', 'Username', 0, 1, 0, 0, 0, 0, 'left', 10, 50, 2, 'bd926c5_iisaac_test', 'mstuser', 'upus', 'upus-updated_user_mst_code', 'code:whole_name', '', 143, '', '2021-10-11 13:55:27', '2021-10-11 13:55:27', 2, 2),
(2044, 175, 'Last updated at', 'updated_at', 'Date time updated', 0, 1, 0, 0, 0, 0, 'left', 4, 50, 0, '', '', '', '', '', 'usesformat=yes|formatmode=datetime|format=F d Y h:i a', 150, '', '2021-10-11 13:55:27', '2021-10-11 13:55:27', 2, 2),
(2045, 157, 'Image File Name', 'image_filename', 'Image File Name', 0, 1, 1, 1, 1, 0, 'left', 1, 500, 0, '', '', '', '', '', '', 49, '', '2019-04-02 10:31:16', '2019-04-02 10:31:16', 2, 2),
(2046, 176, 'Internal Code', 'code', 'Code', 1, 1, 0, 0, 0, 0, 'left', 0, 20, 0, '', '', '', '', '', '', 0, '', '2021-10-12 00:21:05', '2021-10-12 00:21:05', 2, 2),
(2047, 176, 'Short Code', 'short_name', 'Short Code', 1, 1, 1, 1, 1, 1, 'left', 1, 50, 0, '', '', '', '', '', '', 3, '', '2021-10-12 00:27:33', '2021-10-12 00:27:33', 2, 2),
(2048, 176, 'Branch', 'branch_mst_code', 'Branch', 1, 1, 1, 1, 1, 0, 'left', 7, 0, 2, 'bd926c5_iisaac_test', 'mstbranch', '400', '300-branch_mst_code', 'code:short_name branch_name', '', 1, '', '2021-10-12 00:50:24', '2021-10-12 00:50:24', 2, 2),
(2049, 176, 'Channel', 'channel_name', 'Channel', 1, 1, 1, 1, 1, 0, 'left', 1, 150, 0, '', '', '', '', '', '', 5, '', '2021-10-12 00:54:50', '2021-10-12 00:54:50', 2, 2),
(2050, 176, 'Remarks', 'remarks', 'Remarks', 0, 1, 1, 1, 0, 0, 'left', 5, 200, 0, '', '', '', '', '', '', 95, '', '2021-10-12 00:56:22', '2021-10-12 00:56:22', 2, 2),
(2051, 176, 'Created by', 'created_user_mst_code', 'Username', 0, 1, 0, 0, 0, 0, 'left', 10, 50, 2, 'bd926c5_iisaac_test', 'mstuser', '1010', '1010-created_user_mst_code', 'code:whole_name', '', 100, '', '2021-10-12 01:01:38', '2021-10-12 01:01:38', 2, 2),
(2052, 176, 'Created at', 'created_at', 'Date time created', 0, 1, 0, 0, 0, 0, 'left', 4, 50, 0, '', '', '', '', '', 'usesformat=yes|formatmode=datetime|format=F d Y h:i a', 105, '', '2021-10-12 01:03:34', '2021-10-12 01:03:34', 2, 2),
(2053, 176, 'Last Updated By', 'updated_user_mst_code', 'Username', 0, 1, 0, 0, 0, 0, 'left', 10, 50, 2, 'bd926c5_iisaac_test', 'mstuser', '1012', '1012-updated_user_mst_code', 'code:whole_name', '', 110, '', '2021-10-12 01:05:24', '2021-10-12 01:05:24', 2, 2),
(2054, 176, 'Last updated at', 'updated_at', 'Date time updated', 0, 1, 0, 0, 0, 0, 'left', 4, 50, 0, '', '', '', '', '', 'usesformat=yes|formatmode=datetime|format=F d Y h:i a', 115, '', '2021-10-12 01:06:03', '2021-10-12 01:06:03', 2, 2),
(2055, 177, 'Internal Code', 'code', 'Code', 1, 1, 0, 0, 0, 0, 'left', 0, 20, 0, '', '', '', '', '', '', 0, '', '2021-10-12 00:21:05', '2021-10-12 00:21:05', 2, 2),
(2056, 177, 'Short Code', 'short_name', 'Short Code', 1, 1, 1, 1, 1, 1, 'left', 1, 50, 0, '', '', '', '', '', '', 3, '', '2021-10-12 00:27:33', '2021-10-12 00:27:33', 2, 2),
(2057, 177, 'Channel', 'channel_mst_code', 'Channel', 1, 1, 1, 1, 1, 0, 'left', 7, 0, 2, 'bd926c5_iisaac_test', 'mstagentchannel', '400', '300-channel_mst_code', 'code:short_name channel_name', '', 1, '', '2021-10-12 00:50:24', '2021-10-12 00:50:24', 2, 2),
(2058, 177, 'Sub Channel', 'subchannel_name', 'Sub Channel', 1, 1, 1, 1, 1, 0, 'left', 1, 150, 0, '', '', '', '', '', '', 5, '', '2021-10-12 00:54:50', '2021-10-12 00:54:50', 2, 2),
(2059, 177, 'Remarks', 'remarks', 'Remarks', 0, 1, 1, 1, 0, 0, 'left', 5, 200, 0, '', '', '', '', '', '', 95, '', '2021-10-12 00:56:22', '2021-10-12 00:56:22', 2, 2),
(2060, 177, 'Created at', 'created_at', 'Date time created', 0, 1, 0, 0, 0, 0, 'left', 4, 50, 0, '', '', '', '', '', 'usesformat=yes|formatmode=datetime|format=F d Y h:i a', 105, '', '2021-10-12 01:03:34', '2021-10-12 01:03:34', 2, 2),
(2061, 177, 'Created by', 'created_user_mst_code', 'Username', 0, 1, 0, 0, 0, 0, 'left', 10, 50, 2, 'bd926c5_iisaac_test', 'mstuser', '1010', '1010-created_user_mst_code', 'code:whole_name', '', 100, '', '2021-10-12 01:01:38', '2021-10-12 01:01:38', 2, 2),
(2062, 177, 'Last Updated By', 'updated_user_mst_code', 'Username', 0, 1, 0, 0, 0, 0, 'left', 10, 50, 2, 'bd926c5_iisaac_test', 'mstuser', '1012', '1012-updated_user_mst_code', 'code:whole_name', '', 110, '', '2021-10-12 01:05:24', '2021-10-12 01:05:24', 2, 2),
(2063, 177, 'Last updated at', 'updated_at', 'Date time updated', 0, 1, 0, 0, 0, 0, 'left', 4, 50, 0, '', '', '', '', '', 'usesformat=yes|formatmode=datetime|format=F d Y h:i a', 115, '', '2021-10-12 01:06:03', '2021-10-12 01:06:03', 2, 2),
(2064, 101, 'Sub Channel', 'subchannel_mst_code', 'Sub Channel', 0, 1, 1, 1, 0, 0, 'left', 7, 0, 2, 'bd926c5_iisaac_test', 'mstagentsubchannel', '450', '450-subchannel_mst_code', 'code:subchannel_name', 'chainingparentid=masterfiletransaction-id-7-2065-channel_mst_code|chainingparentfield=channel_mst_code', 27, '', '2021-10-13 00:30:29', '2021-10-13 00:30:29', 2, 2),
(2065, 101, 'Channel', 'channel_mst_code', 'Channel', 0, 1, 1, 1, 0, 0, 'left', 7, 0, 2, 'bd926c5_iisaac_test', 'mstagentchannel', '440', '440-channel_mst_code', 'code:channel_name', '', 26, '', '2021-10-13 00:30:29', '2021-10-13 00:30:29', 2, 2),
(2066, 178, 'Internal Code', 'code', 'Code', 1, 1, 0, 0, 0, 0, 'left', 0, 20, 0, '', '', '', '', '', '', 0, '', '2021-12-07 11:04:42', '2021-12-07 11:04:42', 2, 2),
(2067, 178, 'Policy No', 'policy_no', 'Policy No', 1, 1, 1, 1, 1, 0, 'left', 1, 150, 0, '', '', '', '', '', '', 5, '', '2021-12-07 11:04:42', '2021-12-07 11:04:42', 2, 2),
(2068, 178, 'Channel', 'channel', 'Channel', 1, 1, 1, 1, 1, 0, 'left', 1, 150, 0, '', '', '', '', '', '', 10, '', '2021-12-07 11:04:42', '2021-12-07 11:04:42', 2, 2),
(2069, 178, 'Is Excluded?', 'is_excluded', 'Is Excluded?', 1, 1, 1, 1, 1, 0, 'left', 8, 0, 1, 'bd926c5_iisaac_test', '', '', '', '1:Yes|2:No', '', 15, '', '2021-12-07 11:04:42', '2021-12-07 11:04:42', 2, 2),
(2070, 178, 'Breakdown Percentage', 'breakdown_percentage', 'Breakdown Percentage', 1, 1, 1, 1, 0, 0, 'left', 3, 150, 0, '', '', '', '', '', '', 20, '', '2021-12-07 11:04:42', '2021-12-07 11:04:42', 2, 2),
(2071, 178, 'Remarks', 'remarks', 'Remarks', 0, 1, 1, 1, 0, 0, 'left', 5, 200, 0, '', '', '', '', '', '', 95, '', '2021-12-07 11:04:42', '2021-12-07 11:04:42', 2, 2),
(2072, 178, 'Created by', 'created_user_mst_code', 'Username', 0, 1, 0, 0, 0, 0, 'left', 10, 50, 2, 'bd926c5_iisaac_test', 'mstuser', '1010', '1010-created_user_mst_code', 'code:whole_name', '', 100, '', '2021-12-07 11:04:42', '2021-12-07 11:04:42', 2, 2),
(2073, 178, 'Created at', 'created_at', 'Date time created', 0, 1, 0, 0, 0, 0, 'left', 4, 50, 0, '', '', '', '', '', 'usesformat=yes|formatmode=datetime|format=F d Y h:i a', 105, '', '2021-12-07 11:04:42', '2021-12-07 11:04:42', 2, 2),
(2074, 178, 'Last Updated By', 'updated_user_mst_code', 'Username', 0, 1, 0, 0, 0, 0, 'left', 10, 50, 2, 'bd926c5_iisaac_test', 'mstuser', '1012', '1012-updated_user_mst_code', 'code:whole_name', '', 110, '', '2021-12-07 11:04:42', '2021-12-07 11:04:42', 2, 2),
(2075, 178, 'Last updated at', 'updated_at', 'Date time updated', 0, 1, 0, 0, 0, 0, 'left', 4, 50, 0, '', '', '', '', '', 'usesformat=yes|formatmode=datetime|format=F d Y h:i a', 115, '', '2021-12-07 11:04:42', '2021-12-07 11:04:42', 2, 2),
(2076, 93, 'Division/Unit/Channel', 'division_mst_code', 'Division/Unit/Channel', 1, 1, 1, 1, 0, 0, 'left', 7, 0, 2, 'bd926c5_iisaac_test', 'mstdivision', '215', '215-division_mst_code', 'code:division_name', '', 80, '', '2022-02-18 14:43:25', '2022-02-18 14:43:25', 2, 2),
(2077, 93, 'Branch', 'branch_mst_code', 'Branch', 1, 1, 1, 1, 0, 0, 'left', 7, 0, 2, 'bd926c5_iisaac_test', 'mstbranch', '212', '212-branch_mst_code', 'code:branch_name', '', 85, '', '2022-02-18 14:43:25', '2022-02-18 14:43:25', 2, 2),
(2078, 150, 'Is Active?', 'is_active', 'Is Active?', 1, 1, 1, 1, 1, 0, 'left', 8, 0, 1, 'bd926c5_iisaac_test', '', '', '', '1:Yes|2:No', '', 45, '', '2022-03-30 10:37:07', '2022-03-30 10:37:07', 69, 69),
(2079, 25, 'IC Cresta Zone', 'ic_cresta_zone', 'IC Cresta Zone', 0, 1, 0, 0, 0, 0, 'left', 1, 20, 0, '', '', '', '', '', '', 60, '', '2022-04-05 16:14:02', '2022-04-05 16:14:02', 2, 2),
(2080, 25, 'IC EQ Zone', 'ic_eq_zone', 'IC EQ Zone', 0, 1, 0, 0, 0, 0, 'left', 1, 20, 0, '', '', '', '', '', '', 65, '', '2022-04-05 16:14:02', '2022-04-05 16:14:02', 2, 2),
(2081, 25, 'IC TYP Zone', 'ic_typ_zone', 'IC TYP Zone', 0, 1, 0, 0, 0, 0, 'left', 1, 20, 0, '', '', '', '', '', '', 70, '', '2022-04-05 16:14:02', '2022-04-05 16:14:02', 2, 2),
(2082, 180, 'Internal Code', 'code', 'Code', 1, 1, 0, 0, 0, 0, 'left', 0, 20, 0, '', '', '', '', '', '', 0, '', '2022-04-13 09:48:24', '2022-04-13 09:48:24', 69, 69),
(2083, 180, 'Short Name', 'short_name', 'Short Name', 1, 1, 1, 1, 1, 1, 'left', 1, 50, 0, '', '', '', '', '', '', 10, '', '2022-04-13 09:48:24', '2022-04-13 09:48:24', 69, 69),
(2084, 180, 'Crediting Branch Name', 'crediting_branch_name', 'Crediting Branch Name', 1, 1, 1, 1, 1, 0, 'left', 1, 200, 0, '', '', '', '', '', '', 20, '', '2022-04-13 09:48:24', '2022-04-13 09:48:24', 69, 69),
(2085, 180, 'Division/Unit/Channel', 'division_mst_code', 'Division/Unit/Channel', 1, 1, 1, 1, 1, 0, 'left', 7, 0, 2, 'bd926c5_iisaac_test', 'mstdivision', '215', '215-division_mst_code', 'code:division_name', '', 30, '', '2022-04-13 09:48:24', '2022-04-13 09:48:24', 69, 69),
(2086, 180, 'Is Active?', 'is_active', 'Is Active?', 1, 1, 1, 1, 1, 0, 'left', 8, 0, 1, 'bd926c5_iisaac_test', '', '', '', '1:Yes|2:No', '', 40, '', '2022-04-13 09:48:24', '2022-04-13 09:48:24', 69, 69),
(2087, 180, 'Remarks', 'remarks', 'Remarks', 0, 1, 1, 1, 0, 0, 'left', 5, 50, 0, '', '', '', '', '', '', 80, '', '2022-04-13 09:48:24', '2022-04-13 09:48:24', 69, 69),
(2088, 180, 'Created by', 'created_user_mst_code', 'Username', 0, 1, 0, 0, 0, 0, 'left', 10, 50, 2, 'bd926c5_iisaac_test', 'mstuser', '175', '175-created_user_mst_code', 'code:whole_name', '', 90, '', '2022-04-13 09:48:24', '2022-04-13 09:48:24', 69, 69),
(2089, 180, 'Created at', 'created_at', 'Date time created', 0, 1, 0, 0, 0, 0, 'left', 4, 50, 0, '', '', '', '', '', 'usesformat=yes|formatmode=datetime|format=F d Y h:i a', 100, '', '2022-04-13 09:48:24', '2022-04-13 09:48:24', 69, 69),
(2090, 180, 'Last Updated By', 'updated_user_mst_code', 'Username', 0, 1, 0, 0, 0, 0, 'left', 10, 50, 2, 'bd926c5_iisaac_test', 'mstuser', '177', '177-updated_user_mst_code', 'code:whole_name', '', 110, '', '2022-04-13 09:48:24', '2022-04-13 09:48:24', 69, 69),
(2091, 180, 'Last updated at', 'updated_at', 'Date time updated', 0, 1, 0, 0, 0, 0, 'left', 4, 50, 0, '', '', '', '', '', 'usesformat=yes|formatmode=datetime|format=F d Y h:i a', 120, '', '2022-04-13 09:48:24', '2022-04-13 09:48:24', 69, 69),
(2092, 180, 'Default Quotation Days Valid', 'quotation_days_valid', 'Default Quotation Days Valid', 1, 1, 1, 1, 0, 0, 'right', 2, 3, 0, '', '', '', '', '', '', 50, '', '2022-04-27 10:40:48', '2022-04-27 10:40:48', 2, 2),
(2093, 158, 'Is Active?', 'is_active', 'Is Active?', 1, 1, 1, 1, 1, 0, 'left', 8, 0, 1, 'bd926c5_iisaac_test', '', '', '', '1:Yes|2:No', '', 45, '', '2022-04-27 15:11:09', '2022-04-27 15:11:09', 69, 69),
(2094, 158, 'Order no.', 'order_no', 'Order no.', 1, 1, 1, 1, 1, 0, 'left', 2, 3, 0, '', '', '', '', '', '', 55, '', '2022-04-27 15:12:27', '2022-04-27 15:12:27', 2, 2),
(2095, 181, 'Intermediary No.', 'INTM_NO', 'Intermediary No.', 1, 1, 0, 0, 0, 0, 'left', 0, 20, 0, '', '', '', '', '', '', 0, '', '2022-05-24 00:11:07', '2022-05-24 00:11:07', 2, 2),
(2096, 181, 'Intermediary Name', 'INTM_NAME', 'Intermediary Name', 1, 1, 0, 0, 0, 0, 'left', 1, 150, 0, '', '', '', '', '', '', 20, '', '2022-05-24 00:11:07', '2022-05-24 00:11:07', 2, 2),
(2099, 181, 'TIN', 'TIN', 'TIN', 0, 1, 0, 0, 0, 0, 'left', 1, 150, 0, '', '', '', '', '', '', 80, '', '2022-05-24 00:11:07', '2022-05-24 00:11:07', 2, 2),
(2100, 181, 'Employee No.', 'NICKNAME', 'Employee No.', 1, 1, 0, 0, 0, 0, 'left', 1, 150, 0, '', '', '', '', '', '', 100, '', '2022-05-24 00:11:07', '2022-05-24 00:11:07', 2, 2),
(2102, 181, 'License No.', 'CA_NO', 'License No.', 0, 1, 0, 0, 0, 0, 'left', 1, 150, 0, '', '', '', '', '', '', 140, '', '2022-05-24 00:11:07', '2022-05-24 00:11:07', 2, 2),
(2103, 181, 'License Tag', 'LIC_TAG', 'License Tag', 1, 1, 0, 0, 0, 0, 'left', 8, 150, 1, 'bd926c5_iisaac_test', '', '', '', 'Y:Licensed|N:Unlicensed', '', 160, '', '2022-05-24 00:11:07', '2022-05-24 00:11:07', 2, 2),
(2105, 181, 'WTax Rate', 'WTAX_RATE', 'WTax Rate', 0, 1, 0, 0, 0, 0, 'left', 3, 150, 0, '', '', '', '', '', 'usesformat=yes|formatmode=number|format=2', 200, '', '2022-05-24 00:11:07', '2022-05-24 00:11:07', 2, 2),
(2106, 181, 'Active Tag', 'ACTIVE_TAG', 'Active Tag', 1, 1, 0, 0, 0, 0, 'left', 8, 150, 1, 'bd926c5_iisaac_test', '', '', '', 'A:Active|I:Inactive', '', 220, '', '2022-05-24 00:11:07', '2022-05-24 00:11:07', 2, 2),
(2107, 181, 'Remarks', 'REMARKS', 'Remarks', 0, 1, 0, 0, 0, 0, 'left', 5, 1000, 0, '', '', '', '', '', '', 240, '', '2022-05-24 00:11:07', '2022-05-24 00:11:07', 2, 2),
(2108, 181, 'Date Encoded', 'BIRTHDATE', 'Date Encoded', 1, 1, 0, 0, 0, 0, 'left', 4, 200, 0, '', '', '', '', '', 'usesformat=yes|formatmode=datetime_genweb|format=m/d/Y', 260, '', '2022-05-24 00:11:07', '2022-05-24 00:11:07', 2, 2),
(2109, 181, 'Last Updated At', 'LAST_UPDATE', 'Last Updated At', 1, 1, 0, 0, 0, 0, 'left', 4, 200, 0, '', '', '', '', '', 'usesformat=yes|formatmode=datetime_genweb|format=m/d/Y', 280, '', '2022-05-24 00:11:07', '2022-05-24 00:11:07', 2, 2),
(2112, 182, 'ABICS Internal Code', 'CODE', 'ABICS Internal Code', 1, 1, 1, 1, 1, 1, 'left', 1, 20, 0, '', '', '', '', '', '', 0, '', '2022-05-31 15:12:52', '2022-05-31 15:12:52', 2, 2),
(2113, 182, 'ABICS Agent Code', 'AGENT_CODE', 'ABICS Agent Code', 1, 1, 1, 1, 1, 1, 'left', 1, 150, 0, '', '', '', '', '', '', 20, '', '2022-05-31 15:12:52', '2022-05-31 15:12:52', 2, 2),
(2114, 182, 'ABICS Agent Name', 'AGENT_NAME', 'ABICS Agent Name', 1, 1, 1, 1, 1, 1, 'left', 1, 150, 0, '', '', '', '', '', '', 30, '', '2022-05-31 15:12:52', '2022-05-31 15:12:52', 2, 2),
(2116, 182, 'License Tag', 'LIC_TAG', 'License Tag', 1, 1, 1, 1, 1, 0, 'center', 8, 150, 1, 'bd926c5_iisaac_test', '', '', '', 'N:Unlicensed', '', 50, '', '2022-05-31 15:12:52', '2022-05-31 15:12:52', 2, 2),
(2117, 182, 'Intermediary Type', 'INTM_TYPE', 'Intermediary Type', 1, 1, 0, 0, 0, 0, 'center', 1, 150, 0, '', '', '', '', '', '', 35, '', '2022-05-31 16:36:19', '2022-05-31 16:36:19', 2, 2),
(2118, 182, 'Referror''s Bank', 'SUBAGENT_BANK_NAME', 'Referror''s Bank', 0, 1, 1, 1, 0, 0, 'left', 1, 50, 0, '', '', '', '', '', '', 60, '', '2022-06-02 12:49:05', '2022-06-02 12:49:05', 2, 2),
(2119, 182, 'Referror''s Bank Account Name', 'SUBAGENT_BANK_ACCOUNT_NAME', 'Referror''s Bank Account Name', 0, 1, 1, 1, 0, 0, 'left', 1, 50, 0, '', '', '', '', '', '', 60, '', '2022-06-02 12:49:05', '2022-06-02 12:49:05', 2, 2),
(2120, 182, 'Referror''s Bank Account Number', 'SUBAGENT_BANK_ACCOUNT_NUMBER', 'Referror''s Bank Account Number', 0, 1, 1, 1, 0, 0, 'left', 1, 50, 0, '', '', '', '', '', '', 60, '', '2022-06-02 12:49:05', '2022-06-02 12:49:05', 2, 2),
(2121, 101, 'Is Subagent?', 'is_subagent', 'Is Subagent?', 0, 1, 1, 1, 1, 0, 'left', 8, 0, 1, 'bd926c5_iisaac_test', '', '', '', '1:Yes|2:No', '', 110, '', '2022-06-02 12:53:36', '2022-06-02 12:53:36', 2, 2),
(2123, 101, 'Referror''s Bank', 'subagent_bank_name', 'Referror''s Bank', 0, 1, 1, 1, 0, 0, 'left', 1, 50, 0, '', '', '', '', '', '', 130, '', '2022-06-02 12:56:28', '2022-06-02 12:56:28', 2, 2),
(2124, 101, 'Referror''s Bank Account Name', 'subagent_bank_account_name', 'Referror''s Bank Account Name', 0, 1, 1, 1, 0, 0, 'left', 1, 50, 0, '', '', '', '', '', '', 140, '', '2022-06-02 12:56:28', '2022-06-02 12:56:28', 2, 2),
(2125, 101, 'Referror''s Bank Account Number', 'subagent_bank_account_number', 'Referror''s Bank Account Number', 0, 1, 1, 1, 0, 0, 'left', 1, 50, 0, '', '', '', '', '', '', 150, '', '2022-06-02 12:56:28', '2022-06-02 12:56:28', 2, 2),
(2126, 37, 'Is Active?', 'is_active', 'Is Active?', 1, 1, 1, 1, 1, 0, 'left', 8, 0, 1, 'bd926c5_iisaac_test', '', '', '', '1:Yes|2:No', '', 27, '', '2022-06-15 09:57:29', '2022-06-15 09:57:29', 69, 69),
(2127, 181, 'Input VAT Rate', 'INPUT_VAT_RATE', 'Input VAT Rate', 0, 1, 0, 0, 0, 0, 'left', 3, 150, 0, '', '', '', '', '', 'usesformat=yes|formatmode=number|format=2', 210, '', '2022-06-22 15:41:09', '2022-06-22 15:41:09', 2, 2);

-- --------------------------------------------------------

--
-- Table structure for table `_dtlmasterfiletemplatesfilters`
--

CREATE TABLE IF NOT EXISTS `_dtlmasterfiletemplatesfilters` (
  `code` bigint(20) NOT NULL AUTO_INCREMENT,
  `master_file_templates_code` bigint(20) NOT NULL,
  `filter_name` varchar(500) COLLATE latin1_general_cs NOT NULL,
  `table_field_name` varchar(500) COLLATE latin1_general_cs NOT NULL,
  `filter_caption` varchar(1000) COLLATE latin1_general_cs NOT NULL,
  `data_type` int(2) NOT NULL,
  `max_length` int(4) NOT NULL,
  `data_source` tinyint(1) NOT NULL,
  `data_source_database_name` varchar(200) COLLATE latin1_general_cs NOT NULL,
  `data_source_table_name` varchar(50) COLLATE latin1_general_cs NOT NULL,
  `data_source_value_pair` varchar(5000) COLLATE latin1_general_cs NOT NULL,
  `special_conditions` varchar(5000) COLLATE latin1_general_cs NOT NULL,
  `print_order` int(3) NOT NULL,
  `remarks` varchar(500) COLLATE latin1_general_cs NOT NULL,
  `created_at` datetime NOT NULL,
  `updated_at` datetime NOT NULL,
  `created_user_mst_code` bigint(20) NOT NULL,
  `updated_user_mst_code` bigint(20) NOT NULL,
  PRIMARY KEY (`code`),
  KEY `masterfiletemplatesfilters` (`master_file_templates_code`)
) ENGINE=InnoDB  DEFAULT CHARSET=latin1 COLLATE=latin1_general_cs COMMENT='FOR PROGRAMMER''S USE ONLY. DON''T TOUCH' AUTO_INCREMENT=151 ;

--
-- Dumping data for table `_dtlmasterfiletemplatesfilters`
--

INSERT INTO `_dtlmasterfiletemplatesfilters` (`code`, `master_file_templates_code`, `filter_name`, `table_field_name`, `filter_caption`, `data_type`, `max_length`, `data_source`, `data_source_database_name`, `data_source_table_name`, `data_source_value_pair`, `special_conditions`, `print_order`, `remarks`, `created_at`, `updated_at`, `created_user_mst_code`, `updated_user_mst_code`) VALUES
(1, 7, 'Type', 'bank_type', 'Bank Type', 8, 0, 1, 'bd926c5_iisaac_test', '', ':All|1:Bank|2:Financial Institution', '', 1, '', '2015-05-09 11:33:23', '2015-05-09 11:33:23', 1, 1),
(2, 8, 'Company', 'company_mst_code', 'Company', 7, 0, 2, 'bd926c5_iisaac_test', 'mstcompany', 'code:company_name', '', 0, '', '2015-05-10 23:06:33', '2015-05-10 23:06:33', 1, 1),
(3, 8, 'Branch', 'branch_mst_code', 'Branch', 7, 0, 2, 'bd926c5_iisaac_test', 'mstbranch', 'code:branch_name', 'chainingparentid=filter-id-7-2-company_mst_code|chainingparentfield=company_mst_code', 5, '', '2015-05-10 23:06:33', '2015-05-10 23:06:33', 1, 1),
(4, 8, 'Bank', 'bank_mst_code', 'Bank', 7, 0, 2, 'bd926c5_iisaac_test', 'mstbank', 'code:bank_name', '', 10, '', '2015-05-10 23:08:07', '2015-05-10 23:08:07', 1, 1),
(5, 8, 'Account Type', 'account_type', 'Account Type', 8, 0, 1, 'bd926c5_iisaac_test', '', ':All|1:Savings Account|2:Current Account', '', 18, '', '2015-05-10 23:08:07', '2015-05-10 23:08:07', 1, 1),
(6, 9, 'Country', 'country_mst_code', 'Country', 7, 0, 2, 'bd926c5_iisaac_test', 'mstcountry', 'code:country_name', '', 1, '', '2015-05-13 19:38:10', '2015-05-13 19:38:10', 1, 1),
(7, 9, 'Region', 'region_mst_code', 'Region', 7, 0, 2, 'bd926c5_iisaac_test', 'mstregion', 'code:region_name', 'chainingparentid=filter-id-7-6-country_mst_code|chainingparentfield=country_mst_code', 2, '', '2015-05-13 19:42:58', '2015-05-13 19:42:58', 1, 1),
(8, 9, 'Province', 'province_mst_code', 'Province', 7, 0, 2, 'bd926c5_iisaac_test', 'mstprovince', 'code:province_name', 'chainingparentid=filter-id-7-7-region_mst_code|chainingparentfield=region_mst_code', 3, '', '2015-05-13 19:42:58', '2015-05-13 19:42:58', 1, 1),
(9, 9, 'City', 'city_mst_code', 'City', 7, 0, 2, 'bd926c5_iisaac_test', 'mstcity', 'code:city_name', 'chainingparentid=filter-id-7-8-province_mst_code|chainingparentfield=province_mst_code', 4, '', '2015-05-13 19:42:58', '2015-05-13 19:42:58', 1, 1),
(10, 10, 'Country', 'country_mst_code', 'Country', 7, 0, 2, 'bd926c5_iisaac_test', 'mstcountry', 'code:country_name', '', 1, '', '2015-05-13 19:52:53', '2015-05-13 19:52:53', 1, 1),
(11, 10, 'Region', 'region_mst_code', 'Region', 7, 0, 2, 'bd926c5_iisaac_test', 'mstregion', 'code:region_name', 'chainingparentid=filter-id-7-10-country_mst_code|chainingparentfield=country_mst_code', 2, '', '2015-05-13 19:52:53', '2015-05-13 19:52:53', 1, 1),
(12, 10, 'Province', 'province_mst_code', 'Province', 7, 0, 2, 'bd926c5_iisaac_test', 'mstprovince', 'code:province_name', 'chainingparentid=filter-id-7-11-region_mst_code|chainingparentfield=region_mst_code', 3, '', '2015-05-13 19:52:53', '2015-05-13 19:52:53', 1, 1),
(13, 10, 'City', 'city_mst_code', 'City', 7, 0, 2, 'bd926c5_iisaac_test', 'mstcity', 'code:city_name', 'chainingparentid=filter-id-7-12-province_mst_code|chainingparentfield=province_mst_code', 4, '', '2015-05-13 19:52:53', '2015-05-13 19:52:53', 1, 1),
(14, 12, 'Country', 'country_mst_code', 'Country', 7, 0, 2, 'bd926c5_iisaac_test', 'mstcountry', 'code:country_name', '', 1, '', '2015-05-13 23:43:20', '2015-05-13 23:43:20', 1, 1),
(15, 12, 'Region', 'region_mst_code', 'Region', 7, 0, 2, 'bd926c5_iisaac_test', 'mstregion', 'code:region_name', 'chainingparentid=filter-id-7-14-country_mst_code|chainingparentfield=country_mst_code', 2, '', '2015-05-13 23:43:20', '2015-05-13 23:43:20', 1, 1),
(16, 12, 'Province', 'province_mst_code', 'Province', 7, 0, 2, 'bd926c5_iisaac_test', 'mstprovince', 'code:province_name', 'chainingparentid=filter-id-7-15-region_mst_code|chainingparentfield=region_mst_code', 3, '', '2015-05-13 23:43:20', '2015-05-13 23:43:20', 1, 1),
(17, 18, 'Document Type', 'document_type_mst_code', 'Document Type', 7, 0, 2, 'bd926c5_iisaac_test', 'mstdocumenttype', 'code:description', '', 5, '', '2015-05-16 00:04:20', '2015-05-16 00:04:20', 1, 1),
(18, 18, 'Company', 'company_mst_code', 'Company', 7, 0, 2, 'bd926c5_iisaac_test', 'mstcompany', 'code:company_name', '', 10, '', '2015-05-16 00:04:20', '2015-05-16 00:04:20', 1, 1),
(19, 18, 'Branch', 'branch_mst_code', 'Branch', 7, 0, 2, 'bd926c5_iisaac_test', 'mstbranch', 'code:branch_name', 'chainingparentid=filter-id-7-18-company_mst_code|chainingparentfield=company_mst_code', 15, '', '2015-05-16 00:04:20', '2015-05-16 00:04:20', 1, 1),
(20, 18, 'Line', 'line_mst_code', 'Line', 7, 0, 2, 'bd926c5_iisaac_test', 'mstline', 'code:line_name', '', 20, '', '2015-05-16 00:04:20', '2015-05-16 00:04:20', 1, 1),
(21, 18, 'Subline', 'subline_mst_code', 'Subline', 7, 0, 2, 'bd926c5_iisaac_test', 'mstsubline', 'code:subline_name', 'chainingparentid=filter-id-7-20-line_mst_code|chainingparentfield=line_mst_code', 25, '', '2015-05-16 00:04:20', '2015-05-16 00:04:20', 1, 1),
(22, 18, 'Type', 'series_type', 'Series Type', 8, 0, 1, 'bd926c5_iisaac_test', '', ':All|1:System Generated|2:Manual', '', 30, '', '2015-05-16 00:04:20', '2015-05-16 00:04:20', 1, 1),
(23, 20, 'Company', 'company_mst_code', 'Company', 7, 0, 2, 'bd926c5_iisaac_test', 'mstcompany', 'code:company_name', '', 10, '', '2015-05-17 04:10:35', '2015-05-17 04:10:35', 1, 1),
(24, 20, 'Branch', 'branch_mst_code', 'Branch', 7, 0, 2, 'bd926c5_iisaac_test', 'mstbranch', 'code:branch_name', 'chainingparentid=filter-id-7-23-company_mst_code|chainingparentfield=company_mst_code', 15, '', '2015-05-17 04:10:35', '2015-05-17 04:10:35', 1, 1),
(25, 20, 'Division', 'division_mst_code', 'Division', 7, 0, 2, 'bd926c5_iisaac_test', 'mstdivision', 'code:division_name', '', 20, '', '2015-05-17 04:10:35', '2015-05-17 04:10:35', 1, 1),
(26, 20, 'Department', 'department_mst_code', 'Department', 7, 0, 2, 'bd926c5_iisaac_test', 'mstdepartment', 'code:department_name', '', 25, '', '2015-05-17 04:10:35', '2015-05-17 04:10:35', 1, 1),
(27, 22, 'Enabled?', 'is_enabled', 'Is Enabled?', 8, 0, 1, 'bd926c5_iisaac_test', '', ':All|1:Yes|2:No', '', 1, '', '2015-05-17 11:27:45', '2015-05-17 11:27:45', 1, 1),
(28, 25, 'Country', 'country_mst_code', 'Country', 7, 0, 2, 'bd926c5_iisaac_test', 'mstcountry', 'code:country_name', '', 1, '', '2015-05-13 19:38:10', '2015-05-13 19:38:10', 1, 1),
(29, 25, 'Region', 'region_mst_code', 'Region', 7, 0, 2, 'bd926c5_iisaac_test', 'mstregion', 'code:region_name', 'chainingparentid=filter-id-7-28-country_mst_code|chainingparentfield=country_mst_code', 2, '', '2015-05-13 19:52:53', '2015-05-13 19:52:53', 1, 1),
(30, 29, 'Country', 'country_mst_code', 'Country', 7, 0, 2, 'bd926c5_iisaac_test', 'mstcountry', 'code:country_name', '', 1, '', '2015-05-13 19:38:10', '2015-05-13 19:38:10', 1, 1),
(31, 29, 'Region', 'region_mst_code', 'Region', 7, 0, 2, 'bd926c5_iisaac_test', 'mstregion', 'code:region_name', 'chainingparentid=filter-id-7-30-country_mst_code|chainingparentfield=country_mst_code', 2, '', '2015-05-13 19:42:58', '2015-05-13 19:42:58', 1, 1),
(32, 29, 'Province', 'province_mst_code', 'Province', 7, 0, 2, 'bd926c5_iisaac_test', 'mstprovince', 'code:province_name', 'chainingparentid=filter-id-7-31-region_mst_code|chainingparentfield=region_mst_code', 3, '', '2015-05-13 19:42:58', '2015-05-13 19:42:58', 1, 1),
(33, 29, 'City', 'city_mst_code', 'City', 7, 0, 2, 'bd926c5_iisaac_test', 'mstcity', 'code:city_name', 'chainingparentid=filter-id-7-32-province_mst_code|chainingparentfield=province_mst_code', 4, '', '2015-05-13 19:42:58', '2015-05-13 19:42:58', 1, 1),
(34, 33, 'Industry Group', 'industry_group_mst_code', 'Industry Group', 7, 0, 2, 'bd926c5_iisaac_test', 'mstindustrygroup', 'code:description', '', 10, '', '2015-05-20 20:44:56', '2015-05-20 20:44:56', 1, 1),
(35, 36, 'Line', 'line_mst_code', 'Line', 7, 0, 2, 'bd926c5_iisaac_test', 'mstline', 'code:line_name', '', 10, '', '2015-05-21 01:07:23', '2015-05-21 01:07:23', 1, 1),
(36, 37, 'Line', 'line_mst_code', 'Line', 7, 0, 2, 'bd926c5_iisaac_test', 'mstline', 'code:line_name', '', 10, '', '2015-05-22 01:24:41', '2015-05-22 01:24:41', 1, 1),
(37, 41, 'Line', 'line_mst_code', 'Line', 7, 0, 2, 'bd926c5_iisaac_test', 'mstline', 'code:line_name', '', 10, '', '2015-05-23 11:37:52', '2015-05-23 11:37:52', 1, 1),
(38, 41, 'Subline', 'subline_mst_code', 'Subline', 7, 0, 2, 'bd926c5_iisaac_test', 'mstsubline', 'code:subline_name', 'chainingparentid=filter-id-7-37-line_mst_code|chainingparentfield=line_mst_code', 15, '', '2015-05-23 11:37:52', '2015-05-23 11:37:52', 1, 1),
(39, 48, 'Status Type', 'status_type', 'Status Type', 8, 0, 1, 'bd926c5_iisaac_test', '', ':All|1:Valid|2:Invalid', '', 15, '', '2015-05-23 11:42:54', '2015-05-23 11:42:54', 1, 1),
(40, 50, 'Line', 'line_mst_code', 'Line', 7, 0, 2, 'bd926c5_iisaac_test', 'mstline', 'code:line_name', '', 10, '', '2015-05-23 14:24:00', '2015-05-23 14:24:00', 1, 1),
(41, 51, 'Loss/Expense Desc.', 'claims_loss_expense_desc_code', 'Loss/Expense Description', 7, 0, 2, 'bd926c5_iisaac_test', 'mstclaimslossexpensedescription', 'code:description', '', 10, '', '2015-05-23 14:42:11', '2015-05-23 14:42:11', 1, 1),
(42, 53, 'Parent G/L Code', 'parent_chart_of_accounts_mst_code', 'Parent Chart of Accounts Code', 7, 0, 2, 'bd926c5_iisaac_test', 'mstchartofaccounts', 'code:gl_code account_title', '', 10, '', '2015-05-23 16:24:17', '2015-05-23 16:24:17', 1, 1),
(43, 53, 'Is Active?', 'is_active', 'Is Active?', 8, 0, 1, 'bd926c5_iisaac_test', '', ':All|1:Yes|2:No', '', 25, '', '2015-05-23 16:24:17', '2015-05-23 16:24:17', 1, 1),
(44, 53, 'Account Type', 'account_type', 'Account Type', 7, 0, 1, 'bd926c5_iisaac_test', '', 'A:Assets|L:Liabilities|C:Equity|I:Income|E:Expenses', '', 30, '', '2015-05-23 16:24:17', '2015-05-23 16:24:17', 1, 1),
(45, 54, 'Account Type', 'account_type', 'Account Type', 7, 0, 1, 'bd926c5_iisaac_test', '', 'A:Assets|L:Liabilities|C:Equity|I:Income|E:Expenses', '', 30, '', '2015-05-23 16:30:22', '2015-05-23 16:30:22', 1, 1),
(46, 55, 'Account Type', 'account_type', 'Account Type', 7, 0, 1, 'bd926c5_iisaac_test', '', 'A:Assets|L:Liabilities|C:Equity|I:Income|E:Expenses', '', 30, '', '2015-05-23 16:39:01', '2015-05-23 16:39:01', 1, 1),
(47, 55, 'Report Type', 'report_type_mst_code', 'Report Type', 7, 0, 2, 'bd926c5_iisaac_test', 'mstglreporttype', 'code:report_type_name', '', 60, '', '2015-05-23 16:39:01', '2015-05-23 16:39:01', 1, 1),
(48, 56, 'Report Type', 'gl_report_type_mst_code', 'Report Type', 7, 0, 2, 'bd926c5_iisaac_test', 'mstglreporttype', 'code:report_type_name', '', 20, '', '2015-05-23 18:39:08', '2015-05-23 18:39:08', 1, 1),
(49, 56, 'G/L Group', 'gl_group_mst_code', 'G/L Group', 7, 0, 2, 'bd926c5_iisaac_test', 'mstglgroup', 'code:description', 'chainingparentid=filter-id-7-48-gl_report_type_mst_code|chainingparentfield=report_type_mst_code', 25, '', '2015-05-23 18:39:08', '2015-05-23 18:39:08', 1, 1),
(50, 56, 'G/L Category', 'gl_category_mst_code', 'G/L Category', 7, 0, 2, 'bd926c5_iisaac_test', 'mstglcategory', 'code:description', '', 35, '', '2015-05-23 18:39:08', '2015-05-23 18:39:08', 1, 1),
(51, 65, 'Type', 'transaction_type', 'Transaction Type', 8, 0, 1, 'bd926c5_iisaac_test', '', ':All|1:A/P|2:A/R|3:C/V|4:O/R|5:J/V', '', 10, '', '2015-05-24 20:54:04', '2015-05-24 20:54:04', 1, 1),
(52, 67, 'From Unit', 'from_unit_mst_code', 'From Unit', 7, 0, 2, 'bd926c5_iisaac_test', 'mstunit', 'code:description', '', 5, '', '2015-05-24 21:05:33', '2015-05-24 21:05:33', 1, 1),
(53, 67, 'To Unit', 'to_unit_mst_code', 'To Unit', 7, 0, 2, 'bd926c5_iisaac_test', 'mstunit', 'code:description', '', 15, '', '2015-05-24 21:05:33', '2015-05-24 21:05:33', 1, 1),
(54, 69, 'Item Class', 'item_class_mst_code', 'Item Class', 7, 0, 2, 'bd926c5_iisaac_test', 'mstitemclass', 'code:description', '', 10, '', '2015-05-24 21:16:08', '2015-05-24 21:16:08', 1, 1),
(55, 70, 'Item Class', 'item_class_mst_code', 'Item Class', 7, 0, 2, 'bd926c5_iisaac_test', 'mstitemclass', 'code:description', '', 10, '', '2015-05-24 21:26:21', '2015-05-24 21:26:21', 1, 1),
(56, 70, 'Item Subclass', 'item_subclass_mst_code', 'Item Subclass', 7, 0, 2, 'bd926c5_iisaac_test', 'mstitemsubclass', 'code:description', 'chainingparentid=filter-id-7-55-item_class_mst_code|chainingparentfield=item_class_mst_code', 15, '', '2015-05-24 21:26:21', '2015-05-24 21:26:21', 1, 1),
(57, 71, 'Data Type', 'data_type', 'Data Type', 7, 0, 1, 'bd926c5_iisaac_test', '', '1:Character(One Line)|2:Integer|3:Decimal|4:Date|5:Character(Multiline)|6:Character(Text Editor)|7:Combo Box|8:Radio Button|9:Checkbox|10:Lookup|11:Parent', '', 20, '', '2015-05-24 23:50:12', '2015-05-24 23:50:12', 1, 1),
(58, 75, 'Calamity Area', 'calamity_area_province_mst_code', 'Capital Area', 7, 0, 2, 'bd926c5_iisaac_test', 'mstprovince', 'code:province_name', '', 8, '', '2015-05-27 23:58:39', '2015-05-27 23:58:39', 1, 1),
(59, 75, 'Calamity Type', 'calamity_type', 'Calamity Type', 7, 0, 1, 'bd926c5_iisaac_test', '', '1:Typhoon|2:Earthquake|3:Flood|4:Typhoon and Flood', '', 20, '', '2015-05-27 23:58:39', '2015-05-27 23:58:39', 1, 1),
(60, 76, 'MV Type', 'mv_type_mst_code', 'MV Type', 7, 0, 2, 'bd926c5_iisaac_test', 'mstmvtype', 'code:mv_type_name', '', 20, '', '2015-05-27 23:59:28', '2015-05-27 23:59:28', 1, 1),
(61, 78, 'Vehicle Details', 'vehicle_details_mst_code', 'Vehicle Details', 7, 0, 2, 'bd926c5_iisaac_test', 'mstvehicledetails', 'code:vehicle_complete_details', '', 20, '', '2015-05-28 22:03:44', '2015-05-28 22:03:44', 1, 1),
(62, 84, 'Cargo Class', 'cargo_class_mst_code', 'Cargo Class', 7, 0, 2, 'bd926c5_iisaac_test', 'mstcargoclass', 'code:cargo_class_name', '', 10, '', '2015-05-28 23:13:29', '2015-05-28 23:13:29', 1, 1),
(63, 86, 'Line', 'line_mst_code', 'Line', 7, 0, 2, 'bd926c5_iisaac_test', 'mstline', 'code:line_name', 'condition=equals|condition_source_table_field=code|condition_source_table_field_value=7\n', 20, '', '2015-05-28 23:32:38', '2015-05-28 23:32:38', 1, 1),
(64, 86, 'Subline', 'subline_mst_code', 'Subline', 7, 0, 2, 'bd926c5_iisaac_test', 'mstsubline', 'code:subline_name', 'chainingparentid=filter-id-7-63-line_mst_code|chainingparentfield=line_mst_code', 25, '', '2015-05-28 23:32:38', '2015-05-28 23:32:38', 1, 1),
(65, 100, 'Is Active?', 'is_active', 'Is Active?', 8, 0, 1, 'bd926c5_iisaac_test', '', ':All|1:Yes|2:No', '', 50, '', '2015-06-09 23:34:44', '2015-06-09 23:34:44', 1, 1),
(66, 99, 'Company', 'company_mst_code', 'Company', 7, 0, 2, 'bd926c5_iisaac_test', 'mstcompany', 'code:company_name', '', 10, '', '2015-06-09 23:36:09', '2015-06-09 23:36:09', 1, 1),
(67, 99, 'Branch', 'branch_mst_code', 'Branch', 7, 0, 2, 'bd926c5_iisaac_test', 'mstbranch', 'code:branch_name', 'chainingparentid=filter-id-7-66-company_mst_code|chainingparentfield=company_mst_code', 15, '', '2015-06-09 23:36:09', '2015-06-09 23:36:09', 1, 1),
(71, 99, 'Is Closed?', 'is_closed', 'Is Closed?', 8, 0, 1, 'bd926c5_iisaac_test', '', ':All|1:Yes|2:No', '', 35, '', '2015-06-09 23:36:09', '2015-06-09 23:36:09', 1, 1),
(72, 101, 'Type', 'agent_type', 'Type', 8, 0, 1, 'bd926c5_iisaac_test', '', ':All|1:Individual|2:Corporate|3:Institutional|4:Groups', '', 5, '', '2015-06-09 23:49:46', '2015-06-09 23:49:46', 1, 1),
(73, 101, 'Agent Type', 'agent_type_mst_code', 'Agent Type', 7, 0, 2, 'bd926c5_iisaac_test', 'mstagenttype', 'code:agent_type_description', '', 57, '', '2015-06-09 23:49:46', '2015-06-09 23:49:46', 1, 1),
(74, 100, 'Client Type', 'assured_type', 'Client Type', 8, 0, 1, 'bd926c5_iisaac_test', '', ':All|1:Individual|2:Corporate|3:Institutional|4:Groups', '', 5, '', '2015-06-10 17:48:09', '2015-06-10 17:48:09', 1, 1),
(75, 101, 'Is Active?', 'is_active', 'Is Active?', 8, 0, 1, 'bd926c5_iisaac_test', '', ':All|1:Yes|2:No', '', 50, '', '2015-06-10 17:49:57', '2015-06-10 17:49:57', 1, 1),
(76, 102, 'Type', 'solicitor_type', 'Type', 8, 0, 1, 'bd926c5_iisaac_test', '', ':All|1:Individual|2:Corporate|3:Institutional|4:Groups', '', 5, '', '2015-06-10 22:15:23', '2015-06-10 22:15:23', 1, 1),
(77, 103, 'Reinsurer Type', 'reinsurer_type_mst_code', 'Reinsurer Type', 7, 0, 2, 'bd926c5_iisaac_test', 'mstreinsurertype', 'code:reinsurer_type_name', '', 20, '', '2015-06-10 22:48:04', '2015-06-10 22:48:04', 1, 1),
(78, 103, 'Local Type', 'local_type', 'Local Type', 8, 0, 1, 'bd926c5_iisaac_test', '', ':All|1:Local|2:Foreign|3:ASEAN', '', 30, '', '2015-06-10 22:48:04', '2015-06-10 22:48:04', 1, 1),
(79, 104, 'Adjuster Type', 'adjuster_type', 'Adjuster Type', 8, 0, 1, 'bd926c5_iisaac_test', '', ':All|1:Outside Adjusters|2:In-house Adjusters', '', 30, '', '2015-06-10 23:04:49', '2015-06-10 23:04:49', 1, 1),
(80, 107, 'Type', 'supplier_type', 'Type', 8, 0, 1, 'bd926c5_iisaac_test', '', ':All|1:Individual|2:Corporate|3:Institutional|4:Groups', '', 15, '', '2015-06-11 00:11:43', '2015-06-11 00:11:43', 1, 1),
(81, 107, 'Supplier Group', 'supplier_group_mst_code', 'Supplier Group', 7, 0, 2, 'bd926c5_iisaac_test', 'mstsuppliergroup', 'code:supplier_group_name', '', 20, '', '2015-06-11 00:11:43', '2015-06-11 00:11:43', 1, 1),
(82, 108, 'Type', 'customer_type', 'Type', 8, 0, 1, 'bd926c5_iisaac_test', '', ':All|1:Individual|2:Corporate|3:Institutional|4:Groups', '', 15, '', '2015-06-11 00:25:01', '2015-06-11 00:25:01', 1, 1),
(83, 108, 'Customer Group', 'customer_group_mst_code', 'Customer Group', 7, 0, 2, 'bd926c5_iisaac_test', 'mstcustomergroup', 'code:customer_group_name', '', 20, '', '2015-06-11 00:25:01', '2015-06-11 00:25:01', 1, 1),
(84, 19, 'Document Type', 'document_type', 'Document Type', 8, 0, 1, 'bd926c5_iisaac_test', '', ':All|1:Insurance Related|2:Others', '', 15, '', '2015-06-11 09:38:29', '2015-06-11 09:38:29', 1, 1),
(85, 19, 'Series Level', 'series_level', 'Series Level', 7, 0, 1, 'bd926c5_iisaac_test', '', '1:Company Level|2:Branch Level|3:Line Level|4:Subline Level|5:User Level', '', 20, '', '2015-06-11 09:38:29', '2015-06-11 09:38:29', 1, 1),
(86, 113, 'Line', 'line_mst_code', 'Line', 7, 0, 2, 'bd926c5_iisaac_test', 'mstline', 'code:line_name', '', 10, '', '2015-06-14 22:50:44', '2015-06-14 22:50:44', 1, 1),
(87, 113, 'Subline', 'subline_mst_code', 'Subline', 7, 0, 2, 'bd926c5_iisaac_test', 'mstsubline', 'code:subline_name', 'chainingparentid=filter-id-7-86-line_mst_code|chainingparentfield=line_mst_code', 20, '', '2015-06-14 22:50:44', '2015-06-14 22:50:44', 1, 1),
(88, 113, 'Parent Information Code', 'parent_info_codes_mst_code', 'Parent Information Code', 7, 0, 2, 'bd926c5_iisaac_test', 'mstinfocodes', 'code:info_code_name', 'condition=equals|condition_source_table_field=data_type|condition_source_table_field_value=11', 30, '', '2015-06-14 22:50:44', '2015-06-14 22:50:44', 1, 1),
(89, 79, 'Subline', 'subline_mst_code', 'Subline', 7, 0, 2, 'bd926c5_iisaac_test', 'mstsubline', 'code:subline_name', 'condition=equals|condition_source_table_field=line_mst_code|condition_source_table_field_value=2', 25, '', '2015-05-28 23:32:38', '2015-05-28 23:32:38', 1, 1),
(90, 114, 'Occupancy', 'subline_mst_code', 'Occupancy (Subline)', 7, 0, 2, 'bd926c5_iisaac_test', 'mstsubline', 'code:subline_name', 'condition=equals|condition_source_table_field=line_mst_code|condition_source_table_field_value=1', 20, '', '2015-06-16 09:35:53', '2015-06-16 09:35:53', 1, 1),
(91, 114, 'TRL', 'table_retention_limits_mst_code', 'Table of Retention Limits', 7, 0, 2, 'bd926c5_iisaac_test', 'msttableretentionlimits', 'code:short_name description', 'custom_file_to_open=masterfiles$select_msttableretentionlimits', 50, '', '2015-06-16 09:35:53', '2015-06-16 09:35:53', 1, 1),
(93, 32, 'Base Currency', 'base_currency_mst_code', 'Base Currency', 7, 0, 2, 'bd926c5_iisaac_test', 'mstcurrency', 'code:currency_name', '', 5, '', '2015-06-18 13:15:07', '2015-06-18 13:15:07', 1, 1),
(94, 32, 'From Currency', 'from_currency_mst_code', 'From Currency', 7, 0, 2, 'bd926c5_iisaac_test', 'mstcurrency', 'code:currency_name', '', 10, '', '2015-06-18 13:15:07', '2015-06-18 13:15:07', 1, 1),
(95, 32, 'To Currency', 'to_currency_mst_code', 'To Currency', 7, 0, 2, 'bd926c5_iisaac_test', 'mstcurrency', 'code:currency_name', '', 15, '', '2015-06-18 13:15:07', '2015-06-18 13:15:07', 1, 1),
(96, 111, 'Client', 'assured_mst_code', 'Client', 10, 10, 2, 'bd926c5_iisaac_test', 'mstassured', 'code:assured_name contact_person', 'remotelink=api/ReceiveSelect2Tables.php|templatefileloc=includes/typeaheadtemplates/mstassured.html', 10, '', '2015-06-22 10:25:50', '2015-06-22 10:25:50', 1, 1),
(97, 122, 'Line', 'line_mst_code', 'Line', 7, 0, 2, 'bd926c5_iisaac_test', 'mstline', 'code:line_name', '', 20, '', '2015-06-23 17:23:35', '2015-06-23 17:23:35', 1, 1),
(98, 123, 'Type', 'type', 'Type', 8, 0, 1, 'bd926c5_iisaac_test', '', ':All|1:Loss|2:Expense', '', 10, '', '2015-06-23 18:15:38', '2015-06-23 18:15:38', 1, 1),
(99, 123, 'Covered Lines', 'line_mst_codes', 'Lines', 9, 0, 2, 'bd926c5_iisaac_test', 'mstline', 'code:line_name', '', 20, '', '2015-06-23 18:15:38', '2015-06-23 18:15:38', 1, 1),
(100, 123, 'Has Depreciation?', 'has_depreciation', 'Has Depreciation', 8, 0, 1, 'bd926c5_iisaac_test', '', ':All|1:Yes|2:No', '', 25, '', '2015-06-23 18:15:38', '2015-06-23 18:15:38', 1, 1),
(101, 123, 'Payee Types', 'payee_types', 'Payee Type', 9, 0, 1, 'bd926c5_iisaac_test', '', '1:Third Party claimant|2:Assured Claimant|3:Adjusters|4:Repair Shop|5:Supplier|6:Others', '', 30, '', '2015-06-23 18:15:38', '2015-06-23 18:15:38', 1, 1),
(102, 125, 'Applicable Lines', 'endorsement_line_mst_codes', 'Applicable Lines', 9, 0, 2, 'bd926c5_iisaac_test', 'mstline', 'code:line_name', '', 20, '', '2015-06-24 18:54:05', '2015-06-24 18:54:05', 1, 1),
(103, 125, 'Applicable Sources', 'endorsement_source', 'Endorsement Source', 9, 0, 1, 'bd926c5_iisaac_test', '', '1:Direct Business|2:Reinsurance', '', 25, '', '2015-06-24 18:54:05', '2015-06-24 18:54:05', 1, 1),
(104, 125, 'Endorsement Class', 'endorsement_class', 'Endorsement Class', 8, 0, 1, 'bd926c5_iisaac_test', '', ':All|1:Normal|2:Cancellation|3:Reinstatement', '', 30, '', '2015-06-24 18:54:05', '2015-06-24 18:54:05', 1, 1),
(105, 125, 'Endorsement Type', 'endorsement_type', 'Endorsement Type', 8, 0, 1, 'bd926c5_iisaac_test', '', ':All|1:Premium|2:Non-Premium', '', 35, '', '2015-06-24 18:54:05', '2015-06-24 18:54:05', 1, 1),
(106, 11, 'Company', 'company_mst_code', 'Company', 7, 0, 2, 'bd926c5_iisaac_test', 'mstcompany', 'code:company_name', '', 0, '', '2015-05-10 23:06:33', '2015-05-10 23:06:33', 1, 1),
(107, 31, 'User', 'action_user_mst_code', 'Name', 10, 0, 2, 'bd926c5_iisaac_test', 'mstuser', 'code:username whole_name user_image_code', 'remotelink=api/ReceiveSelect2Tables.php|templatefileloc=includes/typeaheadtemplates/mstuser.html', 70, '', '0000-00-00 00:00:00', '0000-00-00 00:00:00', 0, 0),
(108, 31, 'Modules', 'module_mst_code', 'Module', 7, 0, 2, 'bd926c5_iisaac_test', 'mstmodule', 'code:module_name', '', 55, '', '0000-00-00 00:00:00', '0000-00-00 00:00:00', 0, 0),
(109, 31, 'Action', 'module_action_mst_code', 'Module Action', 7, 0, 2, 'bd926c5_iisaac_test', 'mstmoduleaction', 'code:action_name', '', 70, '', '0000-00-00 00:00:00', '0000-00-00 00:00:00', 0, 0),
(111, 21, 'Module', 'module_mst_code', 'Module Name', 7, 0, 2, 'bd926c5_iisaac_test', 'mstmodule', 'code:module_name', '', 1, '', '0000-00-00 00:00:00', '0000-00-00 00:00:00', 0, 0),
(112, 21, 'Parent', 'menu_item_mst_code', 'Parent Menu', 7, 0, 2, 'bd926c5_iisaac_test', 'mstmenuitem', 'code:menu_name', '', 2, '', '0000-00-00 00:00:00', '0000-00-00 00:00:00', 0, 0),
(113, 21, 'Menu Type', 'type', 'Menu Type', 8, 0, 1, 'bd926c5_iisaac_test', '', ':All|1:Parent|2:Detail', '', 4, '', '0000-00-00 00:00:00', '0000-00-00 00:00:00', 0, 0),
(114, 46, 'Line', 'line_mst_code', 'Line', 7, 0, 2, 'bd926c5_iisaac_test', 'mstline', 'code:line_name', '', 1, '', '0000-00-00 00:00:00', '0000-00-00 00:00:00', 0, 0),
(115, 115, 'TRL Year', 'trl_year', 'TRL Year', 2, 4, 0, '', '', '', 'customformat=yes|format=9999', 5, '', '2015-06-26 13:33:40', '2015-06-26 13:33:40', 1, 1),
(116, 49, 'Line', 'line_mst_code', 'Line', 7, 0, 2, 'bd926c5_iisaac_test', 'mstline', 'code:line_name', '', 20, '', '2015-05-16 00:04:20', '2015-05-16 00:04:20', 1, 1),
(117, 76, 'Manufacturer', 'manufacturer_mst_code', 'Manufacturer', 10, 50, 2, 'bd926c5_iisaac_test', 'mstmanufacturer', 'code:short_name manufacturer_name', 'remotelink=api/ReceiveSelect2Tables.php|templatefileloc=includes/typeaheadtemplates/mstmanufacturer.html', 10, '', '2015-06-22 10:25:50', '2015-06-22 10:25:50', 1, 1),
(118, 61, 'Supplier', 'supplier_mst_code', 'supplier', 10, 10, 2, 'bd926c5_iisaac_test', 'mstsupplier', 'code:supplier_code supplier_name', 'remotelink=api/ReceiveSelect2Tables.php|templatefileloc=includes/typeaheadtemplates/mstsupplier.html', 10, '', '2015-06-22 10:25:50', '2015-06-22 10:25:50', 1, 1),
(119, 116, 'Bond Class', 'bond_groups_mst_code', 'Bond Class', 7, 0, 1, 'bd926c5_iisaac_test', '', '1:1|2:2|3:3|4:4|5:5', '', 0, '', '0000-00-00 00:00:00', '0000-00-00 00:00:00', 0, 0),
(120, 130, 'Branch', 'branch_mst_code', 'Branch', 7, 0, 2, 'bd926c5_iisaac_test', 'mstbranch', 'code:branch_name', '', 15, '', '2015-07-24 14:57:33', '2015-07-24 14:57:33', 1, 1),
(121, 130, 'Line', 'line_mst_code', 'Line', 7, 0, 2, 'bd926c5_iisaac_test', 'mstline', 'code:line_name', '', 20, '', '2015-07-24 14:57:33', '2015-07-24 14:57:33', 1, 1),
(122, 133, 'Line', 'line_mst_code', 'Line', 7, 0, 2, 'bd926c5_iisaac_test', 'mstline', 'code:line_name', '', 10, '', '2015-06-14 22:50:44', '2015-06-14 22:50:44', 1, 1),
(123, 133, 'Subline', 'subline_mst_code', 'Subline', 7, 0, 2, 'bd926c5_iisaac_test', 'mstsubline', 'code:subline_name', 'chainingparentid=filter-id-7-122-line_mst_code|chainingparentfield=line_mst_code', 20, '', '2015-06-14 22:50:44', '2015-06-14 22:50:44', 1, 1),
(124, 134, 'Company', 'company_mst_code', 'Company', 7, 0, 2, 'bd926c5_iisaac_test', 'mstcompany', 'code:company_name', '', 0, '', '2015-09-11 14:51:28', '2015-09-11 14:51:28', 1, 1),
(127, 134, 'Branch', 'branch_mst_code', 'Branch', 7, 0, 2, 'bd926c5_iisaac_test', 'mstbranch', 'code:branch_name', 'chainingparentid=filter-id-7-124-company_mst_code|chainingparentfield=company_mst_code', 15, '', '2015-09-11 16:47:11', '2015-09-11 16:47:11', 1, 1),
(128, 136, 'Country', 'country_mst_code', 'Country', 7, 0, 2, 'bd926c5_iisaac_test', 'mstcountry', 'code:country_name', '', 1, '', '2015-05-13 19:38:10', '2015-05-13 19:38:10', 1, 1),
(129, 136, 'Region', 'region_mst_code', 'Region', 7, 0, 2, 'bd926c5_iisaac_test', 'mstregion', 'code:region_name', 'chainingparentid=filter-id-7-128-country_mst_code|chainingparentfield=country_mst_code', 2, '', '2015-05-13 19:42:58', '2015-05-13 19:42:58', 1, 1),
(130, 136, 'Province', 'province_mst_code', 'Province', 7, 0, 2, 'bd926c5_iisaac_test', 'mstprovince', 'code:province_name', 'chainingparentid=filter-id-7-127-region_mst_code|chainingparentfield=region_mst_code', 3, '', '2015-05-13 19:42:58', '2015-05-13 19:42:58', 1, 1),
(131, 136, 'City', 'city_mst_code', 'City', 7, 0, 2, 'bd926c5_iisaac_test', 'mstcity', 'code:city_name', 'chainingparentid=filter-id-7-128-province_mst_code|chainingparentfield=province_mst_code', 4, '', '2015-05-13 19:42:58', '2015-05-13 19:42:58', 1, 1),
(132, 10, 'Barangay', 'barangay_mst_code', 'Barangay', 7, 0, 2, 'bd926c5_iisaac_test', 'mstbarangay', 'code:barangay_name', 'chainingparentid=filter-id-7-13-city_mst_code|chainingparentfield=city_mst_code', 5, '', '2015-05-13 19:52:53', '2015-05-13 19:52:53', 1, 1),
(133, 10, 'District', 'district_mst_code', 'District', 7, 0, 2, 'bd926c5_iisaac_test', 'mstdistrict', 'code:district_name', 'chainingparentid=filter-id-7-13-city_mst_code|chainingparentfield=city_mst_code', 6, '', '2015-05-13 19:52:53', '2015-05-13 19:52:53', 1, 1),
(134, 101, 'Source of Business', 'source_of_business_mst_code', 'Source of Business', 7, 0, 2, 'bd926c5_iisaac_test', 'mstsourceofbusiness', 'code:source_name', '', 56, '', '2017-11-16 13:56:51', '2017-11-16 13:56:51', 2, 2),
(135, 159, 'Status', 'is_uploaded', 'Status', 7, 0, 1, 'bd926c5_iisaac_test', '', ':All|0:For Uploading|1:Uploaded', '', 1, '', '2019-07-17 13:23:35', '2019-07-17 13:23:35', 2, 2),
(136, 159, 'File Type', 'uploaded_file_type_mst_code', 'File Type', 7, 0, 2, 'bd926c5_iisaac_test', 'mstuploadingfiletype', 'code:short_name', '', 1, '', '2020-04-01 17:45:47', '2020-04-01 17:45:47', 2, 2),
(137, 177, 'Channel', 'channel_mst_code', 'Channel', 7, 0, 2, 'bd926c5_iisaac_test', 'mstagentchannel', 'code:channel_name', '', 57, '', '2021-10-11 23:25:55', '2021-10-11 23:25:55', 2, 2),
(138, 93, 'Division', 'division_mst_code', 'Division', 7, 0, 2, 'bd926c5_iisaac_test', 'mstdivision', 'code:division_name', '', 15, '', '2022-02-22 10:41:35', '2022-02-22 10:41:35', 2, 2),
(139, 93, 'Department', 'department_mst_code', 'Department', 7, 0, 2, 'bd926c5_iisaac_test', 'mstdepartment', 'code:department_name', '', 10, '', '2022-02-22 10:41:35', '2022-02-22 10:41:35', 2, 2),
(140, 93, 'Is Active?', 'is_active', 'Is Active?', 8, 0, 1, 'bd926c5_iisaac_test', '', ':All|1:Yes|2:No', '', 5, '', '2022-02-22 10:41:35', '2022-02-22 10:41:35', 2, 2),
(141, 93, 'Branch', 'branch_mst_code', 'Branch', 7, 0, 2, 'bd926c5_iisaac_test', 'mstbranch', 'code:branch_name', '', 20, '', '2022-02-22 10:42:21', '2022-02-22 10:42:21', 2, 2),
(142, 180, 'Division', 'division_mst_code', 'Division', 7, 0, 2, 'bd926c5_iisaac_test', 'mstdivision', 'code:division_name', '', 15, '', '2022-04-13 09:58:19', '2022-04-13 09:58:19', 2, 2),
(143, 180, 'Is Active?', 'is_active', 'Is Active?', 8, 0, 1, 'bd926c5_iisaac_test', '', ':All|1:Yes|2:No', '', 5, '', '2022-04-13 09:58:19', '2022-04-13 09:58:19', 2, 2),
(147, 181, 'License Tag', 'LIC_TAG', 'License Tag', 8, 50, 1, 'bd926c5_iisaac_test', '', ':All|Y:Licensed|N:Unlicensed', '', 40, '', '2022-05-24 11:47:18', '2022-05-24 11:47:18', 2, 2),
(148, 181, 'Active Tag', 'ACTIVE_TAG', 'Active Tag', 8, 50, 1, 'bd926c5_iisaac_test', '', ':All|A:Active|I:Inactive', '', 50, '', '2022-05-24 11:47:18', '2022-05-24 11:47:18', 2, 2);

--
-- Constraints for dumped tables
--

--
-- Constraints for table `dtlagentaddress`
--
ALTER TABLE `dtlagentaddress`
  ADD CONSTRAINT `dtlagentaddress_ibfk_1` FOREIGN KEY (`agent_mst_code`) REFERENCES `mstagent` (`code`) ON DELETE CASCADE ON UPDATE CASCADE;

--
-- Constraints for table `dtlcurrencyforex`
--
ALTER TABLE `dtlcurrencyforex`
  ADD CONSTRAINT `FK02` FOREIGN KEY (`base_currency_mst_code`) REFERENCES `mstcurrency` (`code`) ON DELETE CASCADE ON UPDATE CASCADE,
  ADD CONSTRAINT `FK03` FOREIGN KEY (`from_currency_mst_code`) REFERENCES `mstcurrency` (`code`) ON DELETE CASCADE ON UPDATE CASCADE,
  ADD CONSTRAINT `FK04` FOREIGN KEY (`to_currency_mst_code`) REFERENCES `mstcurrency` (`code`) ON DELETE CASCADE ON UPDATE CASCADE;

--
-- Constraints for table `dtlentrysetup`
--
ALTER TABLE `dtlentrysetup`
  ADD CONSTRAINT `dtlentrysetup_ibfk_1` FOREIGN KEY (`entry_setup_hdr_code`) REFERENCES `hdrentrysetup` (`code`) ON DELETE CASCADE ON UPDATE CASCADE;

--
-- Constraints for table `dtlinfocodes`
--
ALTER TABLE `dtlinfocodes`
  ADD CONSTRAINT `dtlinfocodes_ibfk_1` FOREIGN KEY (`line_mst_code`) REFERENCES `mstline` (`code`) ON DELETE CASCADE ON UPDATE CASCADE,
  ADD CONSTRAINT `dtlinfocodes_ibfk_2` FOREIGN KEY (`subline_mst_code`) REFERENCES `mstsubline` (`code`) ON DELETE CASCADE ON UPDATE CASCADE;

--
-- Constraints for table `dtlinfocodesarrangement`
--
ALTER TABLE `dtlinfocodesarrangement`
  ADD CONSTRAINT `dtlinfocodesarrangement_ibfk_1` FOREIGN KEY (`line_mst_code`) REFERENCES `mstline` (`code`) ON DELETE CASCADE ON UPDATE CASCADE,
  ADD CONSTRAINT `dtlinfocodesarrangement_ibfk_2` FOREIGN KEY (`subline_mst_code`) REFERENCES `mstsubline` (`code`) ON DELETE CASCADE ON UPDATE CASCADE;

--
-- Constraints for table `dtlplantype`
--
ALTER TABLE `dtlplantype`
  ADD CONSTRAINT `dtlplantype_ibfk_1` FOREIGN KEY (`plan_type_mst_code`) REFERENCES `mstplantype` (`code`) ON DELETE CASCADE ON UPDATE CASCADE;

--
-- Constraints for table `dtlsignatory`
--
ALTER TABLE `dtlsignatory`
  ADD CONSTRAINT `FK06` FOREIGN KEY (`signatory_mst_code`) REFERENCES `mstsignatory` (`code`) ON DELETE CASCADE ON UPDATE CASCADE,
  ADD CONSTRAINT `FK07` FOREIGN KEY (`company_mst_code`) REFERENCES `mstcompany` (`code`) ON DELETE CASCADE ON UPDATE CASCADE,
  ADD CONSTRAINT `FK08` FOREIGN KEY (`branch_mst_code`) REFERENCES `mstbranch` (`code`) ON DELETE CASCADE ON UPDATE CASCADE,
  ADD CONSTRAINT `FK09` FOREIGN KEY (`signatory_user_mst_code`) REFERENCES `mstuser` (`code`) ON DELETE CASCADE ON UPDATE CASCADE;

--
-- Constraints for table `dtlsystemchat`
--
ALTER TABLE `dtlsystemchat`
  ADD CONSTRAINT `FK10` FOREIGN KEY (`sender_user_mst_code`) REFERENCES `mstuser` (`code`) ON DELETE CASCADE ON UPDATE CASCADE;

--
-- Constraints for table `dtltaxcharges`
--
ALTER TABLE `dtltaxcharges`
  ADD CONSTRAINT `dtltaxcharges_ibfk_1` FOREIGN KEY (`tax_charges_mst_code`) REFERENCES `msttaxcharges` (`code`) ON DELETE CASCADE ON UPDATE CASCADE;

--
-- Constraints for table `dtltreatystructurepanels`
--
ALTER TABLE `dtltreatystructurepanels`
  ADD CONSTRAINT `dtltreatystructurepanels_ibfk_1` FOREIGN KEY (`treaty_structures_mst_code`) REFERENCES `msttreatystructures` (`code`) ON DELETE CASCADE ON UPDATE CASCADE,
  ADD CONSTRAINT `dtltreatystructurepanels_ibfk_2` FOREIGN KEY (`treaty_structures_dtl_code`) REFERENCES `dtltreatystructures` (`code`) ON DELETE CASCADE ON UPDATE CASCADE;

--
-- Constraints for table `dtltreatystructures`
--
ALTER TABLE `dtltreatystructures`
  ADD CONSTRAINT `dtltreatystructures_ibfk_1` FOREIGN KEY (`treaty_structures_mst_code`) REFERENCES `msttreatystructures` (`code`) ON DELETE CASCADE ON UPDATE CASCADE,
  ADD CONSTRAINT `dtltreatystructures_ibfk_2` FOREIGN KEY (`distribution_share_mst_code`) REFERENCES `mstdistributionshare` (`code`) ON DELETE CASCADE ON UPDATE CASCADE;

--
-- Constraints for table `dtltreatystructuresclauses`
--
ALTER TABLE `dtltreatystructuresclauses`
  ADD CONSTRAINT `dtltreatystructuresclauses_ibfk_1` FOREIGN KEY (`treaty_structures_mst_code`) REFERENCES `msttreatystructures` (`code`) ON DELETE CASCADE ON UPDATE CASCADE,
  ADD CONSTRAINT `dtltreatystructuresclauses_ibfk_2` FOREIGN KEY (`treaty_structures_dtl_code`) REFERENCES `dtltreatystructures` (`code`) ON DELETE CASCADE ON UPDATE CASCADE;

--
-- Constraints for table `dtltreatystructurescommission`
--
ALTER TABLE `dtltreatystructurescommission`
  ADD CONSTRAINT `dtltreatystructurescommission_ibfk_1` FOREIGN KEY (`treaty_structures_mst_code`) REFERENCES `msttreatystructures` (`code`) ON DELETE CASCADE ON UPDATE CASCADE,
  ADD CONSTRAINT `dtltreatystructurescommission_ibfk_2` FOREIGN KEY (`treaty_structures_dtl_code`) REFERENCES `dtltreatystructures` (`code`) ON DELETE CASCADE ON UPDATE CASCADE,
  ADD CONSTRAINT `dtltreatystructurescommission_ibfk_3` FOREIGN KEY (`treaty_structures_panels_dtl_code`) REFERENCES `dtltreatystructurepanels` (`code`) ON DELETE CASCADE ON UPDATE CASCADE;

--
-- Constraints for table `dtltreatystructuressubpanels`
--
ALTER TABLE `dtltreatystructuressubpanels`
  ADD CONSTRAINT `dtltreatystructuressubpanels_ibfk_1` FOREIGN KEY (`treaty_structures_mst_code`) REFERENCES `msttreatystructures` (`code`) ON DELETE CASCADE ON UPDATE CASCADE,
  ADD CONSTRAINT `dtltreatystructuressubpanels_ibfk_2` FOREIGN KEY (`treaty_structures_dtl_code`) REFERENCES `dtltreatystructures` (`code`) ON DELETE CASCADE ON UPDATE CASCADE,
  ADD CONSTRAINT `dtltreatystructuressubpanels_ibfk_3` FOREIGN KEY (`treaty_structures_panels_dtl_code`) REFERENCES `dtltreatystructurepanels` (`code`) ON DELETE CASCADE ON UPDATE CASCADE;

--
-- Constraints for table `dtluserpassword`
--
ALTER TABLE `dtluserpassword`
  ADD CONSTRAINT `FK12` FOREIGN KEY (`user_mst_code`) REFERENCES `mstuser` (`code`) ON DELETE CASCADE ON UPDATE CASCADE;

--
-- Constraints for table `mstatc`
--
ALTER TABLE `mstatc`
  ADD CONSTRAINT `FK13` FOREIGN KEY (`chart_of_accounts_mst_code`) REFERENCES `iisaac_abic_financials_db`.`mstchartofaccounts` (`code`) ON DELETE CASCADE ON UPDATE CASCADE;

--
-- Constraints for table `mstbankaccount`
--
ALTER TABLE `mstbankaccount`
  ADD CONSTRAINT `FK14` FOREIGN KEY (`company_mst_code`) REFERENCES `mstcompany` (`code`) ON DELETE CASCADE ON UPDATE CASCADE,
  ADD CONSTRAINT `FK15` FOREIGN KEY (`branch_mst_code`) REFERENCES `mstbranch` (`code`) ON DELETE CASCADE ON UPDATE CASCADE,
  ADD CONSTRAINT `FK16` FOREIGN KEY (`bank_mst_code`) REFERENCES `mstbank` (`code`) ON DELETE CASCADE ON UPDATE CASCADE,
  ADD CONSTRAINT `FK17` FOREIGN KEY (`chart_of_accounts_mst_code`) REFERENCES `iisaac_abic_financials_db`.`mstchartofaccounts` (`code`) ON DELETE CASCADE ON UPDATE CASCADE;

--
-- Constraints for table `mstbarangay`
--
ALTER TABLE `mstbarangay`
  ADD CONSTRAINT `FK19` FOREIGN KEY (`province_mst_code`) REFERENCES `mstprovince` (`code`) ON DELETE CASCADE ON UPDATE CASCADE,
  ADD CONSTRAINT `FK21` FOREIGN KEY (`city_mst_code`) REFERENCES `mstcity` (`code`) ON DELETE CASCADE ON UPDATE CASCADE,
  ADD CONSTRAINT `mstbarangay_ibfk_1` FOREIGN KEY (`country_mst_code`) REFERENCES `mstcountry` (`code`) ON DELETE CASCADE ON UPDATE CASCADE;

--
-- Constraints for table `mstblock`
--
ALTER TABLE `mstblock`
  ADD CONSTRAINT `mstblock_ibfk_1` FOREIGN KEY (`country_mst_code`) REFERENCES `mstcountry` (`code`) ON DELETE CASCADE ON UPDATE CASCADE,
  ADD CONSTRAINT `mstblock_ibfk_2` FOREIGN KEY (`region_mst_code`) REFERENCES `mstregion` (`code`) ON DELETE CASCADE ON UPDATE CASCADE,
  ADD CONSTRAINT `mstblock_ibfk_3` FOREIGN KEY (`province_mst_code`) REFERENCES `mstprovince` (`code`) ON DELETE CASCADE ON UPDATE CASCADE,
  ADD CONSTRAINT `mstblock_ibfk_4` FOREIGN KEY (`city_mst_code`) REFERENCES `mstcity` (`code`) ON DELETE CASCADE ON UPDATE CASCADE;

--
-- Constraints for table `mstbondrate`
--
ALTER TABLE `mstbondrate`
  ADD CONSTRAINT `mstbondrate_ibfk_1` FOREIGN KEY (`bond_groups_mst_code`) REFERENCES `mstbondgroups` (`code`) ON DELETE CASCADE ON UPDATE CASCADE;

--
-- Constraints for table `mstbrokerfeerates`
--
ALTER TABLE `mstbrokerfeerates`
  ADD CONSTRAINT `mstbrokerfeerates_ibfk_1` FOREIGN KEY (`reinsurer_mst_code`) REFERENCES `mstreinsurer` (`code`) ON DELETE CASCADE ON UPDATE CASCADE;

--
-- Constraints for table `mstcargotype`
--
ALTER TABLE `mstcargotype`
  ADD CONSTRAINT `mstcargotype_ibfk_1` FOREIGN KEY (`cargo_class_mst_code`) REFERENCES `mstcargoclass` (`code`) ON DELETE CASCADE ON UPDATE CASCADE;

--
-- Constraints for table `mstcity`
--
ALTER TABLE `mstcity`
  ADD CONSTRAINT `mstcity_ibfk_1` FOREIGN KEY (`country_mst_code`) REFERENCES `mstcountry` (`code`) ON DELETE CASCADE ON UPDATE CASCADE,
  ADD CONSTRAINT `mstcity_ibfk_2` FOREIGN KEY (`region_mst_code`) REFERENCES `mstregion` (`code`) ON DELETE CASCADE ON UPDATE CASCADE,
  ADD CONSTRAINT `mstcity_ibfk_3` FOREIGN KEY (`province_mst_code`) REFERENCES `mstprovince` (`code`) ON DELETE CASCADE ON UPDATE CASCADE;

--
-- Constraints for table `mstclaimtype`
--
ALTER TABLE `mstclaimtype`
  ADD CONSTRAINT `mstclaimtype_ibfk_1` FOREIGN KEY (`line_mst_code`) REFERENCES `mstline` (`code`) ON DELETE CASCADE ON UPDATE CASCADE;

--
-- Constraints for table `mstdeductible`
--
ALTER TABLE `mstdeductible`
  ADD CONSTRAINT `mstdeductible_ibfk_1` FOREIGN KEY (`line_mst_code`) REFERENCES `mstline` (`code`) ON DELETE CASCADE ON UPDATE CASCADE,
  ADD CONSTRAINT `mstdeductible_ibfk_2` FOREIGN KEY (`subline_mst_code`) REFERENCES `mstsubline` (`code`) ON DELETE CASCADE ON UPDATE CASCADE;

--
-- Constraints for table `mstdepartment`
--
ALTER TABLE `mstdepartment`
  ADD CONSTRAINT `mstdepartment_ibfk_1` FOREIGN KEY (`division_mst_code`) REFERENCES `mstdivision` (`code`) ON DELETE CASCADE ON UPDATE CASCADE;

--
-- Constraints for table `mstdocumentseries`
--
ALTER TABLE `mstdocumentseries`
  ADD CONSTRAINT `mstdocumentseries_ibfk_4` FOREIGN KEY (`document_type_mst_code`) REFERENCES `mstdocumenttype` (`code`) ON DELETE CASCADE ON UPDATE CASCADE,
  ADD CONSTRAINT `mstdocumentseries_ibfk_5` FOREIGN KEY (`company_mst_code`) REFERENCES `mstcompany` (`code`) ON DELETE CASCADE ON UPDATE CASCADE,
  ADD CONSTRAINT `mstdocumentseries_ibfk_6` FOREIGN KEY (`branch_mst_code`) REFERENCES `mstbranch` (`code`) ON DELETE CASCADE ON UPDATE CASCADE;

--
-- Constraints for table `mstfairmarketvalue`
--
ALTER TABLE `mstfairmarketvalue`
  ADD CONSTRAINT `mstfairmarketvalue_ibfk_1` FOREIGN KEY (`vehicle_details_mst_code`) REFERENCES `mstvehicledetails` (`code`) ON DELETE CASCADE ON UPDATE CASCADE;

--
-- Constraints for table `mstmotorcarclass`
--
ALTER TABLE `mstmotorcarclass`
  ADD CONSTRAINT `mstmotorcarclass_ibfk_1` FOREIGN KEY (`subline_mst_code`) REFERENCES `mstsubline` (`code`) ON DELETE CASCADE ON UPDATE CASCADE;

--
-- Constraints for table `mstmotorcarperilpremiums`
--
ALTER TABLE `mstmotorcarperilpremiums`
  ADD CONSTRAINT `mstmotorcarperilpremiums_ibfk_1` FOREIGN KEY (`line_mst_code`) REFERENCES `mstline` (`code`) ON DELETE CASCADE ON UPDATE CASCADE,
  ADD CONSTRAINT `mstmotorcarperilpremiums_ibfk_2` FOREIGN KEY (`subline_mst_code`) REFERENCES `mstsubline` (`code`) ON DELETE CASCADE ON UPDATE CASCADE,
  ADD CONSTRAINT `mstmotorcarperilpremiums_ibfk_3` FOREIGN KEY (`peril_mst_code`) REFERENCES `mstperil` (`code`) ON DELETE CASCADE ON UPDATE CASCADE;

--
-- Constraints for table `mstnatureofloss`
--
ALTER TABLE `mstnatureofloss`
  ADD CONSTRAINT `mstnatureofloss_ibfk_1` FOREIGN KEY (`line_mst_code`) REFERENCES `mstline` (`code`) ON DELETE CASCADE ON UPDATE CASCADE;

--
-- Constraints for table `mstperil`
--
ALTER TABLE `mstperil`
  ADD CONSTRAINT `mstperil_ibfk_1` FOREIGN KEY (`line_mst_code`) REFERENCES `mstline` (`code`) ON DELETE CASCADE ON UPDATE CASCADE;

--
-- Constraints for table `mstplantype`
--
ALTER TABLE `mstplantype`
  ADD CONSTRAINT `mstplantype_ibfk_1` FOREIGN KEY (`line_mst_code`) REFERENCES `mstline` (`code`) ON DELETE CASCADE ON UPDATE CASCADE,
  ADD CONSTRAINT `mstplantype_ibfk_2` FOREIGN KEY (`subline_mst_code`) REFERENCES `mstsubline` (`code`) ON DELETE CASCADE ON UPDATE CASCADE;

--
-- Constraints for table `mstriinwardcommrate`
--
ALTER TABLE `mstriinwardcommrate`
  ADD CONSTRAINT `mstriinwardcommrate_ibfk_1` FOREIGN KEY (`reinsurer_mst_code`) REFERENCES `mstreinsurer` (`code`) ON DELETE CASCADE ON UPDATE CASCADE;

--
-- Constraints for table `mstrioutwardcommrate`
--
ALTER TABLE `mstrioutwardcommrate`
  ADD CONSTRAINT `mstrioutwardcommrate_ibfk_1` FOREIGN KEY (`reinsurer_mst_code`) REFERENCES `mstreinsurer` (`code`) ON DELETE CASCADE ON UPDATE CASCADE;

--
-- Constraints for table `mstsignatory`
--
ALTER TABLE `mstsignatory`
  ADD CONSTRAINT `mstsignatory_ibfk_1` FOREIGN KEY (`company_mst_code`) REFERENCES `mstcompany` (`code`) ON DELETE CASCADE ON UPDATE CASCADE,
  ADD CONSTRAINT `mstsignatory_ibfk_2` FOREIGN KEY (`branch_mst_code`) REFERENCES `mstbranch` (`code`) ON DELETE CASCADE ON UPDATE CASCADE;

--
-- Constraints for table `msttaxcharges`
--
ALTER TABLE `msttaxcharges`
  ADD CONSTRAINT `msttaxcharges_ibfk_1` FOREIGN KEY (`branch_mst_code`) REFERENCES `iisaac_abic_system_db`.`mstbranch` (`code`) ON DELETE CASCADE ON UPDATE CASCADE,
  ADD CONSTRAINT `msttaxcharges_ibfk_2` FOREIGN KEY (`line_mst_code`) REFERENCES `mstline` (`code`) ON DELETE CASCADE ON UPDATE CASCADE,
  ADD CONSTRAINT `msttaxcharges_ibfk_3` FOREIGN KEY (`taxes_mst_code`) REFERENCES `msttaxes` (`code`) ON DELETE CASCADE ON UPDATE CASCADE;

--
-- Constraints for table `msttreatystructures`
--
ALTER TABLE `msttreatystructures`
  ADD CONSTRAINT `msttreatystructures_ibfk_1` FOREIGN KEY (`line_mst_code`) REFERENCES `mstline` (`code`) ON DELETE CASCADE ON UPDATE CASCADE;

--
-- Constraints for table `mstunitconversion`
--
ALTER TABLE `mstunitconversion`
  ADD CONSTRAINT `mstunitconversion_ibfk_1` FOREIGN KEY (`from_unit_mst_code`) REFERENCES `mstunit` (`code`) ON DELETE CASCADE ON UPDATE CASCADE,
  ADD CONSTRAINT `mstunitconversion_ibfk_2` FOREIGN KEY (`to_unit_mst_code`) REFERENCES `mstunit` (`code`) ON DELETE CASCADE ON UPDATE CASCADE;

--
-- Constraints for table `mstzipcode`
--
ALTER TABLE `mstzipcode`
  ADD CONSTRAINT `mstzipcode_ibfk_1` FOREIGN KEY (`country_mst_code`) REFERENCES `mstcountry` (`code`) ON DELETE CASCADE ON UPDATE CASCADE,
  ADD CONSTRAINT `mstzipcode_ibfk_2` FOREIGN KEY (`region_mst_code`) REFERENCES `mstregion` (`code`) ON DELETE CASCADE ON UPDATE CASCADE,
  ADD CONSTRAINT `mstzipcode_ibfk_3` FOREIGN KEY (`province_mst_code`) REFERENCES `mstprovince` (`code`) ON DELETE CASCADE ON UPDATE CASCADE,
  ADD CONSTRAINT `mstzipcode_ibfk_4` FOREIGN KEY (`city_mst_code`) REFERENCES `mstcity` (`code`) ON DELETE CASCADE ON UPDATE CASCADE;

--
-- Constraints for table `trnaptransactiondtlitems`
--
ALTER TABLE `trnaptransactiondtlitems`
  ADD CONSTRAINT `trnaptransactiondtlitems_ibfk_1` FOREIGN KEY (`ap_transaction_trn_code`) REFERENCES `trnaptransaction` (`code`) ON DELETE CASCADE ON UPDATE CASCADE;

--
-- Constraints for table `trnaptransactiondtlreplenishment`
--
ALTER TABLE `trnaptransactiondtlreplenishment`
  ADD CONSTRAINT `trnaptransactiondtlreplenishment_ibfk_1` FOREIGN KEY (`ap_transaction_trn_code`) REFERENCES `trnaptransaction` (`code`) ON DELETE CASCADE ON UPDATE CASCADE,
  ADD CONSTRAINT `trnaptransactiondtlreplenishment_ibfk_2` FOREIGN KEY (`ap_transaction_item_trn_code`) REFERENCES `trnaptransactiondtlitems` (`code`) ON DELETE CASCADE ON UPDATE CASCADE;

--
-- Constraints for table `trnaptransactiondtlsl`
--
ALTER TABLE `trnaptransactiondtlsl`
  ADD CONSTRAINT `trnaptransactiondtlsl_ibfk_1` FOREIGN KEY (`ap_transaction_trn_code`) REFERENCES `trnaptransaction` (`code`) ON DELETE CASCADE ON UPDATE CASCADE,
  ADD CONSTRAINT `trnaptransactiondtlsl_ibfk_2` FOREIGN KEY (`ap_transaction_item_trn_code`) REFERENCES `trnaptransactiondtlitems` (`code`) ON DELETE CASCADE ON UPDATE CASCADE;

--
-- Constraints for table `trnarapoffsettingdtlitems`
--
ALTER TABLE `trnarapoffsettingdtlitems`
  ADD CONSTRAINT `trnarapoffsettingdtlitems_ibfk_1` FOREIGN KEY (`arap_offsetting_trn_code`) REFERENCES `trnarapoffsetting` (`code`) ON DELETE CASCADE ON UPDATE CASCADE;

--
-- Constraints for table `trnartransactiondtlitems`
--
ALTER TABLE `trnartransactiondtlitems`
  ADD CONSTRAINT `trnartransactiondtlitems_ibfk_1` FOREIGN KEY (`ar_transaction_trn_code`) REFERENCES `trnartransaction` (`code`) ON DELETE CASCADE ON UPDATE CASCADE;

--
-- Constraints for table `trnartransactiondtlsl`
--
ALTER TABLE `trnartransactiondtlsl`
  ADD CONSTRAINT `trnartransactiondtlsl_ibfk_1` FOREIGN KEY (`ar_transaction_trn_code`) REFERENCES `trnartransaction` (`code`) ON DELETE CASCADE ON UPDATE CASCADE,
  ADD CONSTRAINT `trnartransactiondtlsl_ibfk_2` FOREIGN KEY (`ar_transaction_item_trn_code`) REFERENCES `trnartransaction` (`code`) ON DELETE CASCADE ON UPDATE CASCADE;

--
-- Constraints for table `trncashcheckvoucherdtloptrn`
--
ALTER TABLE `trncashcheckvoucherdtloptrn`
  ADD CONSTRAINT `trncashcheckvoucherdtloptrn_ibfk_1` FOREIGN KEY (`cash_check_voucher_trn_code`) REFERENCES `trncashcheckvoucher` (`code`) ON DELETE CASCADE ON UPDATE CASCADE;

--
-- Constraints for table `trncashcheckvoucherdtloptrnitems`
--
ALTER TABLE `trncashcheckvoucherdtloptrnitems`
  ADD CONSTRAINT `trncashcheckvoucherdtloptrnitems_ibfk_1` FOREIGN KEY (`cash_check_voucher_trn_code`) REFERENCES `trncashcheckvoucher` (`code`) ON DELETE CASCADE ON UPDATE CASCADE,
  ADD CONSTRAINT `trncashcheckvoucherdtloptrnitems_ibfk_2` FOREIGN KEY (`cash_check_voucher_trn_optrn_code`) REFERENCES `trncashcheckvoucherdtloptrn` (`code`) ON DELETE CASCADE ON UPDATE CASCADE;

--
-- Constraints for table `trncashcheckvoucherdtloptrnreplenishment`
--
ALTER TABLE `trncashcheckvoucherdtloptrnreplenishment`
  ADD CONSTRAINT `trncashcheckvoucherdtloptrnreplenishment_ibfk_1` FOREIGN KEY (`cash_check_voucher_trn_code`) REFERENCES `trncashcheckvoucher` (`code`) ON DELETE CASCADE ON UPDATE CASCADE,
  ADD CONSTRAINT `trncashcheckvoucherdtloptrnreplenishment_ibfk_2` FOREIGN KEY (`cash_check_voucher_trn_optrn_code`) REFERENCES `trncashcheckvoucherdtloptrn` (`code`) ON DELETE CASCADE ON UPDATE CASCADE,
  ADD CONSTRAINT `trncashcheckvoucherdtloptrnreplenishment_ibfk_3` FOREIGN KEY (`cash_check_voucher_trn_optrn_item_code`) REFERENCES `trncashcheckvoucher` (`code`) ON DELETE CASCADE ON UPDATE CASCADE;

--
-- Constraints for table `trncashcheckvoucherdtloptrnsl`
--
ALTER TABLE `trncashcheckvoucherdtloptrnsl`
  ADD CONSTRAINT `trncashcheckvoucherdtloptrnsl_ibfk_1` FOREIGN KEY (`cash_check_voucher_trn_code`) REFERENCES `trncashcheckvoucher` (`code`) ON DELETE CASCADE ON UPDATE CASCADE,
  ADD CONSTRAINT `trncashcheckvoucherdtloptrnsl_ibfk_2` FOREIGN KEY (`cash_check_voucher_trn_optrn_code`) REFERENCES `trncashcheckvoucherdtloptrn` (`code`) ON DELETE CASCADE ON UPDATE CASCADE,
  ADD CONSTRAINT `trncashcheckvoucherdtloptrnsl_ibfk_3` FOREIGN KEY (`cash_check_voucher_trn_optrn_item_code`) REFERENCES `trncashcheckvoucherdtloptrnitems` (`code`) ON DELETE CASCADE ON UPDATE CASCADE;

--
-- Constraints for table `trnclaimsdtlsubmitteddocsfiles`
--
ALTER TABLE `trnclaimsdtlsubmitteddocsfiles`
  ADD CONSTRAINT `trnclaimsdtlsubmitteddocsfiles_ibfk_1` FOREIGN KEY (`claims_trn_code`) REFERENCES `iisaac_abic_insurance_db`.`trnclaims` (`code`) ON DELETE CASCADE ON UPDATE CASCADE,
  ADD CONSTRAINT `trnclaimsdtlsubmitteddocsfiles_ibfk_2` FOREIGN KEY (`claims_trn_submitted_docs_code`) REFERENCES `iisaac_abic_insurance_db`.`trnclaimsdtlsubmitteddocs` (`code`) ON DELETE CASCADE ON UPDATE CASCADE;

--
-- Constraints for table `trnglbudgetdtlperiods`
--
ALTER TABLE `trnglbudgetdtlperiods`
  ADD CONSTRAINT `trnglbudgetdtlperiods_ibfk_1` FOREIGN KEY (`gl_budget_trn_code`) REFERENCES `trnglbudget` (`code`) ON DELETE CASCADE ON UPDATE CASCADE;

--
-- Constraints for table `trnintpolicydtlitemperils`
--
ALTER TABLE `trnintpolicydtlitemperils`
  ADD CONSTRAINT `trnintpolicydtlitemperils_ibfk_1` FOREIGN KEY (`int_policy_trn_code`) REFERENCES `trnintpolicy` (`code`) ON DELETE CASCADE ON UPDATE CASCADE,
  ADD CONSTRAINT `trnintpolicydtlitemperils_ibfk_2` FOREIGN KEY (`int_policy_item_dtl_code`) REFERENCES `trnintpolicydtlitem` (`code`) ON DELETE CASCADE ON UPDATE CASCADE;

--
-- Constraints for table `trnjournalvoucherdtlitems`
--
ALTER TABLE `trnjournalvoucherdtlitems`
  ADD CONSTRAINT `trnjournalvoucherdtlitems_ibfk_1` FOREIGN KEY (`journal_voucher_trn_code`) REFERENCES `trnjournalvoucher` (`code`) ON DELETE CASCADE ON UPDATE CASCADE;

--
-- Constraints for table `trnjournalvoucherdtlsl`
--
ALTER TABLE `trnjournalvoucherdtlsl`
  ADD CONSTRAINT `trnjournalvoucherdtlsl_ibfk_1` FOREIGN KEY (`journal_voucher_trn_code`) REFERENCES `trnjournalvoucher` (`code`) ON DELETE CASCADE ON UPDATE CASCADE,
  ADD CONSTRAINT `trnjournalvoucherdtlsl_ibfk_2` FOREIGN KEY (`journal_voucher_trn_items_code`) REFERENCES `trnjournalvoucherdtlitems` (`code`) ON DELETE CASCADE ON UPDATE CASCADE;

--
-- Constraints for table `trnofficialreceiptsdtlartrans`
--
ALTER TABLE `trnofficialreceiptsdtlartrans`
  ADD CONSTRAINT `trnofficialreceiptsdtlartrans_ibfk_1` FOREIGN KEY (`official_receipts_trn_code`) REFERENCES `trnofficialreceipts` (`code`) ON DELETE CASCADE ON UPDATE CASCADE;

--
-- Constraints for table `trnofficialreceiptsdtlartransitems`
--
ALTER TABLE `trnofficialreceiptsdtlartransitems`
  ADD CONSTRAINT `trnofficialreceiptsdtlartransitems_ibfk_1` FOREIGN KEY (`official_receipts_trn_code`) REFERENCES `trnofficialreceipts` (`code`) ON DELETE CASCADE ON UPDATE CASCADE,
  ADD CONSTRAINT `trnofficialreceiptsdtlartransitems_ibfk_2` FOREIGN KEY (`official_receipts_trn_ar_trans_code`) REFERENCES `trnofficialreceiptsdtlartrans` (`code`) ON DELETE CASCADE ON UPDATE CASCADE;

--
-- Constraints for table `trnofficialreceiptsdtlartranssl`
--
ALTER TABLE `trnofficialreceiptsdtlartranssl`
  ADD CONSTRAINT `trnofficialreceiptsdtlartranssl_ibfk_1` FOREIGN KEY (`official_receipts_trn_code`) REFERENCES `trnofficialreceipts` (`code`) ON DELETE CASCADE ON UPDATE CASCADE,
  ADD CONSTRAINT `trnofficialreceiptsdtlartranssl_ibfk_2` FOREIGN KEY (`official_receipts_trn_ar_trans_code`) REFERENCES `trnofficialreceiptsdtlartrans` (`code`) ON DELETE CASCADE ON UPDATE CASCADE,
  ADD CONSTRAINT `trnofficialreceiptsdtlartranssl_ibfk_3` FOREIGN KEY (`official_receipts_trn_ar_trans_item_code`) REFERENCES `trnofficialreceiptsdtlartransitems` (`code`) ON DELETE CASCADE ON UPDATE CASCADE;

--
-- Constraints for table `trnofficialreceiptsdtlcollections`
--
ALTER TABLE `trnofficialreceiptsdtlcollections`
  ADD CONSTRAINT `trnofficialreceiptsdtlcollections_ibfk_1` FOREIGN KEY (`official_receipts_trn_code`) REFERENCES `trnofficialreceipts` (`code`) ON DELETE CASCADE ON UPDATE CASCADE;

--
-- Constraints for table `trnofficialreceiptsdtlreturnaptrans`
--
ALTER TABLE `trnofficialreceiptsdtlreturnaptrans`
  ADD CONSTRAINT `trnofficialreceiptsdtlreturnaptrans_ibfk_1` FOREIGN KEY (`official_receipts_trn_code`) REFERENCES `trnofficialreceipts` (`code`) ON DELETE CASCADE ON UPDATE CASCADE;

--
-- Constraints for table `trnofficialreceiptsdtlreturnaptransitems`
--
ALTER TABLE `trnofficialreceiptsdtlreturnaptransitems`
  ADD CONSTRAINT `trnofficialreceiptsdtlreturnaptransitems_ibfk_1` FOREIGN KEY (`official_receipts_trn_code`) REFERENCES `trnofficialreceipts` (`code`) ON DELETE CASCADE ON UPDATE CASCADE,
  ADD CONSTRAINT `trnofficialreceiptsdtlreturnaptransitems_ibfk_2` FOREIGN KEY (`official_receipts_trn_return_ap_trans_code`) REFERENCES `trnofficialreceiptsdtlreturnaptrans` (`code`) ON DELETE CASCADE ON UPDATE CASCADE;

--
-- Constraints for table `trnordepositsdtlchecks`
--
ALTER TABLE `trnordepositsdtlchecks`
  ADD CONSTRAINT `trnordepositsdtlchecks_ibfk_1` FOREIGN KEY (`or_deposits_trn_code`) REFERENCES `trnordeposits` (`code`) ON DELETE CASCADE ON UPDATE CASCADE,
  ADD CONSTRAINT `trnordepositsdtlchecks_ibfk_2` FOREIGN KEY (`or_deposits_trn_or_code`) REFERENCES `trnordepositsdtlor` (`code`) ON DELETE CASCADE ON UPDATE CASCADE;

--
-- Constraints for table `trnordepositsdtlor`
--
ALTER TABLE `trnordepositsdtlor`
  ADD CONSTRAINT `trnordepositsdtlor_ibfk_1` FOREIGN KEY (`or_deposits_trn_code`) REFERENCES `trnordeposits` (`code`) ON DELETE CASCADE ON UPDATE CASCADE;

--
-- Constraints for table `trnorderofpaymentsdtlitems`
--
ALTER TABLE `trnorderofpaymentsdtlitems`
  ADD CONSTRAINT `trnorderofpaymentsdtlitems_ibfk_1` FOREIGN KEY (`order_of_payments_trn_code`) REFERENCES `trnorderofpayments` (`code`) ON DELETE CASCADE ON UPDATE CASCADE;

--
-- Constraints for table `trnprovisionaryreceiptsdtlitems`
--
ALTER TABLE `trnprovisionaryreceiptsdtlitems`
  ADD CONSTRAINT `trnprovisionaryreceiptsdtlitems_ibfk_1` FOREIGN KEY (`provisionary_receipts_trn_code`) REFERENCES `trnprovisionaryreceipts` (`code`) ON DELETE CASCADE ON UPDATE CASCADE;

--
-- Constraints for table `trnpurchasecounterreceiptsdtlitems`
--
ALTER TABLE `trnpurchasecounterreceiptsdtlitems`
  ADD CONSTRAINT `trnpurchasecounterreceiptsdtlitems_ibfk_1` FOREIGN KEY (`purchase_counter_receipt_trn_code`) REFERENCES `trnpurchasecounterreceipttrn` (`code`) ON DELETE CASCADE ON UPDATE CASCADE;

--
-- Constraints for table `trnpurchasedrsidtlitems`
--
ALTER TABLE `trnpurchasedrsidtlitems`
  ADD CONSTRAINT `trnpurchasedrsidtlitems_ibfk_1` FOREIGN KEY (`purchase_drsi_trn_code`) REFERENCES `trnpurchasedrsi` (`code`) ON DELETE CASCADE ON UPDATE CASCADE;

--
-- Constraints for table `trnpurchaseorderdtlitems`
--
ALTER TABLE `trnpurchaseorderdtlitems`
  ADD CONSTRAINT `trnpurchaseorderdtlitems_ibfk_1` FOREIGN KEY (`purchase_order_trn_code`) REFERENCES `trnpurchaseorder` (`code`) ON DELETE CASCADE ON UPDATE CASCADE;

--
-- Constraints for table `trnpurchasereturndtlitems`
--
ALTER TABLE `trnpurchasereturndtlitems`
  ADD CONSTRAINT `trnpurchasereturndtlitems_ibfk_1` FOREIGN KEY (`purchase_return_trn_code`) REFERENCES `trnpurchasereturn` (`code`) ON DELETE CASCADE ON UPDATE CASCADE;

--
-- Constraints for table `trnrecurringtemplatedtlhistory`
--
ALTER TABLE `trnrecurringtemplatedtlhistory`
  ADD CONSTRAINT `trnrecurringtemplatedtlhistory_ibfk_1` FOREIGN KEY (`recurring_template_trn_code`) REFERENCES `trnrecurringtemplate` (`code`) ON DELETE CASCADE ON UPDATE CASCADE;

--
-- Constraints for table `trnrecurringtemplatedtlinfo`
--
ALTER TABLE `trnrecurringtemplatedtlinfo`
  ADD CONSTRAINT `trnrecurringtemplatedtlinfo_ibfk_1` FOREIGN KEY (`recurring_template_trn_code`) REFERENCES `trnrecurringtemplate` (`code`) ON DELETE CASCADE ON UPDATE CASCADE;

--
-- Constraints for table `trnrecurringtemplatedtlitems`
--
ALTER TABLE `trnrecurringtemplatedtlitems`
  ADD CONSTRAINT `trnrecurringtemplatedtlitems_ibfk_1` FOREIGN KEY (`recurring_template_trn_code`) REFERENCES `trnrecurringtemplate` (`code`) ON DELETE CASCADE ON UPDATE CASCADE;

--
-- Constraints for table `trnrecurringtemplatedtlsl`
--
ALTER TABLE `trnrecurringtemplatedtlsl`
  ADD CONSTRAINT `trnrecurringtemplatedtlsl_ibfk_1` FOREIGN KEY (`recurring_template_trn_code`) REFERENCES `trnrecurringtemplate` (`code`) ON DELETE CASCADE ON UPDATE CASCADE,
  ADD CONSTRAINT `trnrecurringtemplatedtlsl_ibfk_2` FOREIGN KEY (`recurring_template_trn_item_code`) REFERENCES `trnrecurringtemplatedtlinfo` (`code`) ON DELETE CASCADE ON UPDATE CASCADE;

