* admin_os_planner_detl_id name emp_id projects vendors project_coordinator cell_no

* admin_proj_detail_id oa_no proj_no org_id proj_name quantity proj_trgt_manf_date proj_trgt_date proj_manager proj_coord purchase_coord estmtd_no_parts proj_start_date proj_end_date proj_budget status_flag design_trgt_date hsn_code status_interval

* row_id oa_no po_no vendor file_name

* row_id project_id activity_name activity_st_dt activity_trgt_dt activity_budget responsibility status remarks entry_by entry_dt modify_by modify_dt

* assembly_id oa_no proj_no asmbly_drg_no sa_name sa_drg_no sa_per_asmbly sa_strt_date sa_trgt_date sa_actual_start_date sa_revised_date sa_end_date status_flag design_eng sa_drg_remarks sa_drg_last_aremarks_by_date_time sa_drg_aprov_by sa_remarks sa_drg_file sa_status sa_drg_file_flag

* assembly_id oa_no proj_no asmbly_drg_no sa_name sa_drg_no sa_per_asmbly sa_strt_date sa_trgt_date sa_actual_start_date sa_revised_date sa_end_date status_flag design_eng sa_drg_remarks sa_drg_last_aremarks_by_date_time sa_drg_aprov_by sa_remarks sa_drg_file sa_status sa_drg_file_flag

* id_assembly_details_remarks oa_no proj_no asmbly_drg_no sa_drg_no sa_name remarks remarks_date_time role username

* part_count grn_status oa_no grn_no vendor vendor_po_no

* row_id department_name

* row_id project_id activity_name activity_st_dt activity_trgt_dt activity_budget responsibility status remarks entry_by entry_dt modify_by modify_dt

* emp_id emp_name emp_profile_name emp_pwd emp_role emp_role_id org_id project_coordinator cell_no emp_email departments emp_active_status last_modified static_ip1 static_ip2 otp otp_time

* emp_id emp_name emp_profile_name emp_pwd emp_role emp_role_id org_id project_coordinator cell_no emp_email emp_active_status static_ip1 static_ip2 last_modified otp otp_time

* emp_role_id role_name

* emp_role_id role_name noneditable_fields

* inspection_id part_id vendor vendor_po_no insp_rep_no grn_no no_of_stg stg_no reqd_total_qty vendor_order_qty part_qty_recvd insp_qty_acpt insp_qty_rej insp_qty_rework remarks insp_acpt_name insp_person insp_date acpt_date no_of_insp flg_short_close ir_validate accept_with_out_disc accept_with_disc

* maping_id module rolename moduleaction

* material_issue_detl_id part_id os_planner emp_id vendor vendor_po_no raw_mat_spec raw_mat_dimension mat_req_qty mat_recd_qty vendor_po_qty mat_issue_qty mat_issue_dt dc_no dc_type

* id part_id raw_mat_spec mat_req_qty raw_mat_dimension mat_pr_no mat_pr_dt mat_recd_qty mat_recvd_date mat_po_no os_planner emp_id

* id part_id raw_mat_spec mat_req_qty mat_recd_qty raw_mat_dimension mat_pr_no mat_pr_dt request_status mat_rcpt_trgt_dt os_planner emp_id ir_validate remarks ir_validated_by ir_validation_date remarks_g store_keeper stock_update_date received_by approved_by

* id part_id mat_req_qty mat_pr_no ava_stock_qty pro_add_qty shelf_days remarks_stock

* message_id part_id org_id message msg_by msg_to msg_on msg_type msg_read msg_vendor

* org_id org_full_name org_short_name org_address_line_1 org_address_line_2 org_division_unit org_ph_no_1 org_ph_no_2 org_email org_website org_logo_path org_certification_logo_path org_iso_certified_title org_gstin_no org_pan_no org_excise_no org_services org_products org_misc_details org_currency_full org_currency_symbol org_currecny_short org_date_format org_estd_date org_active_status org_bucket

* org_id org_full_name org_short_name org_address_line_1 org_address_line_2 org_division_unit org_ph_no_1 org_ph_no_2 org_email org_website org_logo_path org_certification_logo_path org_iso_certified_title org_gstin_no org_pan_no org_excise_no org_services org_products org_misc_details org_currency_full org_currency_symbol org_currecny_short org_date_format org_estd_date org_active_status org_bucket

* id_param org_id parameter

* id_translations lang_iso_code id_param custom_parameter org_id param_help

* id part_id os_planner trgt_date vendor vendor_po_no grn_no dc_no dc_type no_of_stages stg_no vendor_order_qty part_rcpt_qty part_issue_qty part_issue_date part_issue_by vehicle_no mode_of_dispatch approximate_value e_sugam_no notes insp_rep_no dc_with_out_disc dc_with_disc

* part_recpt_id part_id os_planner trgt_dt vendor vendor_po_no no_of_stages stg_no vendor_order_qty part_rcpt_qty part_rcpt_dt grn_no grn_dt grn_created_by grn_status inward_invoice_no inward_invoice_dt inward_dc_no inward_dc_dt grn_closed_by grn_notes part_rcpt_updated_by part_rcpt_updated_dt grn_value_with_out_disc grn_value_with_disc

* part_recpt_id part_id os_planner trgt_dt vendor vendor_po_no no_of_stages stg_no vendor_order_qty part_rcpt_qty part_rcpt_dt grn_no grn_dt grn_created_by grn_status inward_invoice_no inward_invoice_dt inward_dc_no inward_dc_dt grn_closed_by grn_notes

* part_count grn_status oa_no vendor vendor_po_no grn_no

* id vendor oa_no vendor_po_no vendor_po_dt total_cost acpt_date payment_days

* row_id project_id department_id activity_name activity_st_dt activity_trgt_dt activity_budget entry_by entry_dt modify_by modify_dt

* oa_no proj_name proj_trgt_date status project_cost proj_budget

* part_id oa_no proj_no sa_name assy_drg_no sa_drg_no sa_per_assy part_name part_drg_no batch_no parts_per_assy vendor_order_qty actual_qty reqd_total_qty mat_req_qty mat_recd_qty mat_issue_qty part_rcpt_qty accepted_qty rejected_qty rework_qty rework_issue_qty part_issue_qty trgt_date class_of_parts status os_planner date_drg_issue raw_mat_spec raw_mat_dimension rev_del_dt remarks proj_remarks_by_date_time bom_qty part_acpt_date part_issue_assly_date part_issue_assly_qty no_of_stages status_flag start_dt end_dt pending_assly_issue_qty bom_upload_date design_eng part_drg_remarks part_drg_aprov_by drg_release_dt type final_insp_dt no_of_insp mr_na part_drg_release_by hsn_code sac_code revision uom model make website part_drg_file alternate_allow week_lead_time part_drg_file_flag sa_drg_file sa_drg_file_flag qc_require

* part_id oa_no proj_no sa_name assy_drg_no sa_drg_no sa_per_assy part_name part_drg_no batch_no parts_per_assy vendor_order_qty actual_qty reqd_total_qty mat_req_qty mat_recd_qty mat_issue_qty part_rcpt_qty accepted_qty rejected_qty rework_qty rework_issue_qty part_issue_qty trgt_date class_of_parts status os_planner date_drg_issue raw_mat_spec raw_mat_dimension rev_del_dt remarks proj_remarks_by_date_time bom_qty part_acpt_date part_issue_assly_date part_issue_assly_qty no_of_stages status_flag start_dt end_dt pending_assly_issue_qty bom_upload_date design_eng part_drg_remarks part_drg_aprov_by drg_release_dt type final_insp_dt no_of_insp mr_na part_drg_release_by hsn_code sac_code revision uom model make website alternate_allow week_lead_time part_drg_file part_drg_file_flag sa_drg_file sa_drg_file_flag qc_require

* part_id oa_no proj_no sa_name assy_drg_no sa_drg_no sa_per_assy part_name part_drg_no batch_no parts_per_assy vendor_order_qty actual_qty reqd_total_qty mat_req_qty mat_recd_qty mat_issue_qty part_rcpt_qty accepted_qty rejected_qty rework_qty rework_issue_qty part_issue_qty trgt_date class_of_parts status os_planner date_drg_issue raw_mat_spec raw_mat_dimension rev_del_dt remarks proj_remarks_by_date_time bom_qty part_acpt_date part_issue_assly_date part_issue_assly_qty no_of_stages status_flag start_dt end_dt pending_assly_issue_qty bom_upload_date design_eng part_drg_remarks part_drg_aprov_by drg_release_dt type final_insp_dt no_of_insp mr_na part_drg_release_by hsn_code sac_code revision uom model make website alternate_allow week_lead_time part_drg_file part_drg_file_flag sa_drg_file sa_drg_file_flag qc_require

* part_id oa_no proj_no sa_name assy_drg_no sa_drg_no sa_per_assy part_name part_drg_no batch_no parts_per_assy vendor_order_qty actual_qty reqd_total_qty mat_req_qty mat_recd_qty mat_issue_qty part_rcpt_qty accepted_qty rejected_qty rework_qty rework_issue_qty part_issue_qty trgt_date class_of_parts status os_planner date_drg_issue raw_mat_spec raw_mat_dimension rev_del_dt remarks proj_remarks_by_date_time bom_qty part_acpt_date part_issue_assly_date part_issue_assly_qty no_of_stages status_flag start_dt end_dt pending_assly_issue_qty bom_upload_date design_eng part_drg_remarks part_drg_aprov_by drg_release_dt type final_insp_dt no_of_insp mr_na part_drg_release_by hsn_code sac_code revision uom model make website alternate_allow week_lead_time part_drg_file part_drg_file_flag sa_drg_file sa_drg_file_flag qc_require

* proj_detl_id oa_no proj_no sa_name assy_drg_no sa_drg_no sa_drg_revision sa_per_assy part_name part_drg_no batch_no parts_per_assy reqd_total_qty bom_qty stages trgt_date class_of_parts raw_mat_spec raw_mat_dimension bom_upload_date design_eng part_drg_remarks part_drg_release_by drg_release_dt type revision revision_date make model uom website hsn_code sac_code alternate_allow week_lead_time last_modified_date last_modified_by part_drg_file part_drg_file_flag sa_drg_file sa_drg_file_flag remarks status_flag

* id part_id oa_no sa_name sa_drg_no part_name part_drg_no insp_rep_no reqd_total_qty piv_no Issue_qty issue_to issued_by issue_date class_of_parts remarks

* id part_id oa_no sa_name sa_drg_no part_name part_drg_no insp_rep_no reqd_total_qty piv_no Issue_qty issue_to issued_by issue_date class_of_parts remarks

* id part_id oa_no os_planner no_of_stages total_qty completed_qty pending_qty req_qty rcpt_qty po_qty issue_qty mr_na part_rcpt_qty part_issue_qty dispatch_qty status po_qty_firststg

* pur_parts_id oa_no proj_no assy_drg_no sa_name sa_drg_no sa_per_assy part_name part_drg_no parts_per_assy reqd_total_qty class_of_parts raw_mat_spec raw_mat_dimension bom_upload_date design_eng part_drg_remarks part_drg_aprov_by

* row_id project_id department_id activity_name activity_st_dt activity_trgt_dt actual_st_dt actual_trgt_dt activity_budget responsibility status remarks entry_by entry_dt modify_by modify_dt

* row_id additional_charge_type

* row_id class_of_part

* row_id record_type record_value

* row_id currency sub_text decimal_words symbol default

* row_id wo_no document_title document_file

* row_id doc_type pos1 pos2 pos3 pos4 pos5 pos6 pos7 pos8 pos9 version_prefix separator

* row_id editable_fields column_name

* row_id doc_type pos1 pos2 pos3 pos4 pos5 prefix separator year sl_no_length year_separator

* row_id doc_type doc_no doc_date doc_description

* row_id page_id page_label

* row_id page_id page_label

* row_id module_id module_name module_icon entry_by entry_dt modify_by modify_dt

* row_id module_id option_id option_name option_controller entry_by entry_dt entry_tm modify_by modify_dt modify_tm option_remarks

* row_id page_name page_description

* row_id page_name page_description

* row_id wo_no sa_name part_name part_id stage_no stage_weightage part_approve mat_req mat_recpt vendor_po mat_issue mfg part_recpt part_issue reject rework accept assembly raw_mat_na mr_na multi_stage total_qty status

* row_id wo_no sa_name part_name part_id stage_no stage_weightage part_approve mat_req mat_recpt vendor_po mat_issue mfg part_recpt part_issue reject rework accept assembly raw_mat_na mr_na multi_stage total_qty status

* row_id wo_no sa_name part_name part_id stage_no stage_weightage part_approve mat_req mat_recpt vendor_po mat_issue mfg part_recpt part_issue reject rework accept assembly raw_mat_na mr_na multi_stage total_qty status

* row_id wo_no sa_name sa_drg_no part_id doc_type doc_file

* row_id part_type

* row_id project_id interval_dt planned_status actual_status

* row_id parameter_name parameter_field parameter_type parameter_field_type

* row_id parameter_id parameter_priority

* row_id parameter_id parameter_value1 parameter_value2

* row_id user_name parameter_id parameter_value1 parameter_value2 access

* row_id type A B C

* row_id rawmat_spec

* row_id service_name

* row_id activity_name status_percent activity_weightage column_name

* row_id project_id activity_id subactivity_name subactivity_st_dt subactivity_trgt_dt actual_st_dt actual_trgt_dt subactivity_budget responsibility status remarks entry_by entry_dt modify_by modify_dt

* row_id tax_slab

* row_id terms_type terms_description

* row_id user_name mrn grn inspection issue dispatch

* row_id uom_name

* row_id emp_id option_id entry_by entry_dt entry_tm entry_ip entry_lat entry_log modify_by modify_dt modify_tm modify_ip modify_lat modify_log

* id user_id user_name event table_name old_values new_values url name ip_address user_agent created_at

* vendor_detail_id vendor_id org_id name address phone_no mobile_no email website products services contact_person iso_9001_certified vat_reg_no service_tax pan_no tan_no exercise_reg_no job_approved_type vendor_reg_no os_planner gst_no vendor_active_status comp_reg_type gst_reg_type

* vendor_po_id wo_no mrn_no vendor vendor_id vendor_address vendor_gst ship_to vendor_po_no type vendor_po_dt validated_date gst_type gst_tax_prcnt gst_total with_without_raw verified_date terms_n_conditions sub_total discount_amount sub_total_amount total_cost total_words currency rupees_per_doller currency_amount pf_prcnt freight insurance dispatch payment incoterms delivery documents prepared_by verified_by issued_date poRemarks pack_instructions po_validate_status po_validate po_validated_by po_validated_date po_prepared_date po_validated_role po_amendment_req_reason po_amendment_req_by po_amendment_req_date po_amendment_req_status po_amendment_req_approve_by po_amendment_req_approve_date po_amendment_no po_amendment_date po_amended_by quotation_ref quotation_date cancelled po_cancel_reason po_cancel_req_by po_cancel_req_date po_cancel_req_status po_cancelled_by po_cancelled_date transportation_charge additional_charge_type additional_charges internal_comment

* vendor_po_detl_id wo_no part_id unit_price unit_of_measure discount_prcnt total_single_part hsn_code sac_code mpn vendor vendor_id vendor_address vendor_gst vendor_order_qty mat_issue_qty part_rcpt_qty accepted_qty rejected_qty rework_qty rework_issue_qty part_issue_qty insp_rep_no vendor_po_no vendor_po_dt quotation_ref quotation_date vendor_trgt_date os_planner stg_no no_of_days po_amendment_no po_amendment_date po_amended_by po_validate po_validated_by po_validated_date po_prepared_date po_validated_role vendor_part_status raw_mat_spec raw_mat_dimension model make part_alternate_name part_note part_removed_by part_removed_dt

テーブルを選択してください admin_os_planner_detl admin_project_details annexure_doc assembly_activities assembly_details assembly_details1 assembly_details_remarks closed_grn_summary_view department dispatch_activities employee_details employee_details1 employee_roles employee_roles1 inspection_details mapusermodule material_issue_detl mat_rcpt_detl mat_req_detl mat_req_stock message org_settings org_settings1 parameter parameter_translations part_issue_details part_rcpt_detl part_rcpt_detl_1 pending_grn_summary_view po_cost_table project_planner project_summary_view proj_detl proj_detl1 proj_detl_back proj_detl_new proj_detl_temp tbldispatchcomponent tbldispatchcomponent2 tblpendcnt tblpurparts t_activities_mst t_additional_charges_mst t_class_of_parts_mst t_control_mst t_currency_mst t_documents_mst t_drawing_format_mst t_editable_fields_mst t_format_mst t_iso_doc_no_mst t_label_mst t_label_mst1 t_module_mst t_option_mst t_page_mst t_page_mst-27-07-2023 t_parts_status t_parts_status1 t_parts_status_new t_part_docs_mst t_part_type_mst t_planned_status_trn t_po_param_mst t_po_param_pripority_mst t_po_param_values_mst t_po_param_val_mapping_mst t_qcrequire_mst t_rawmatspec_mst t_services_mst t_status_weightage t_subactivities_mst t_tax_mst t_terms_mst t_transaction_edit_mst t_uom_mst t_user_modules_mst user_audit_trails vendor_details vendor_po vendor_po_detl . カラムを選択してください
表示

条件

ソート	昇順	降順
次の値として追加する	AND	OR
Op	= > >= < <= != LIKE LIKE %...% NOT LIKE NOT LIKE %...% IN (...) NOT IN (...) BETWEEN NOT BETWEEN IS NULL IS NOT NULL REGEXP REGEXP ^...$ NOT REGEXP	テキスト 別のカラム
	テーブルを選択してください admin_os_planner_detl admin_project_details annexure_doc assembly_activities assembly_details assembly_details1 assembly_details_remarks closed_grn_summary_view department dispatch_activities employee_details employee_details1 employee_roles employee_roles1 inspection_details mapusermodule material_issue_detl mat_rcpt_detl mat_req_detl mat_req_stock message org_settings org_settings1 parameter parameter_translations part_issue_details part_rcpt_detl part_rcpt_detl_1 pending_grn_summary_view po_cost_table project_planner project_summary_view proj_detl proj_detl1 proj_detl_back proj_detl_new proj_detl_temp tbldispatchcomponent tbldispatchcomponent2 tblpendcnt tblpurparts t_activities_mst t_additional_charges_mst t_class_of_parts_mst t_control_mst t_currency_mst t_documents_mst t_drawing_format_mst t_editable_fields_mst t_format_mst t_iso_doc_no_mst t_label_mst t_label_mst1 t_module_mst t_option_mst t_page_mst t_page_mst-27-07-2023 t_parts_status t_parts_status1 t_parts_status_new t_part_docs_mst t_part_type_mst t_planned_status_trn t_po_param_mst t_po_param_pripority_mst t_po_param_values_mst t_po_param_val_mapping_mst t_qcrequire_mst t_rawmatspec_mst t_services_mst t_status_weightage t_subactivities_mst t_tax_mst t_terms_mst t_transaction_edit_mst t_uom_mst t_user_modules_mst user_audit_trails vendor_details vendor_po vendor_po_detl .	カラムを選択してください