* 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 product_category 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

* 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

* dc_summary_id dc_no grn_no vendor vendor_po_no vendor_po_date dc_created_date dc_created_by parts_count parts_issue_qty accept_qty reject_qty rework_qty rework_issue_qty pending_qty total_cost_without_tax total_cost_taxable os_planner oa_no last_updated

* 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 emp_active_status static_ip1 static_ip2 last_modified otp otp_time

* emp_role_id role_name noneditable_fields

* grn_summary_id grn_no vendor vendor_po_no vendor_po_dt grn_created_date grn_created_by grn_type grn_status parts_count vendor_order_qty parts_receipt_qty accept_qty reject_qty rework_qty rework_issue_qty pending_qty grn_closed_date grn_closed_by total_cost_without_tax total_cost_taxable os_planner oa_no last_updated

* 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 rework_issue_qty remarks insp_acpt_name insp_person insp_date acpt_date no_of_insp flg_short_close ir_validate accept_with_out_tax accept_with_tax storage_location

* inspection_summary_id vendor vendor_po_no vendor_po_date grn_no parts_count parts_receipt_qty rework_rcpt_qty accept_qty reject_qty rework_qty rework_issue_qty pending_qty os_planner oa_no inspected_by inspected_date accepted_cost_without_tax accepted_cost_with_tax last_updated

* 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 hsn_code sac_code

* 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 reqd_total_qty 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 e_way_bill_no notes insp_rep_no dc_value_with_out_tax dc_value_with_tax

* part_recpt_id part_id os_planner trgt_dt vendor vendor_po_no no_of_stages stg_no reqd_total_qty vendor_order_qty part_rcpt_qty part_rcpt_dt grn_no grn_dt grn_created_by grn_status grn_type rework_rcpt_qty inward_invoice_no inward_invoice_dt inward_dc_no inward_dc_dt grn_closed_by grn_notes e_way_bill_no part_rcpt_updated_by part_rcpt_updated_dt grn_value_adisc_before_gst grn_value_adisc_with_gst grn_cancel_reason grn_cancel_req_by grn_cancel_req_date grn_cancel_req_status grn_cancelled_by grn_cancelled_date request_cancel_by request_cancel_date cancel_request_status

* 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 product_category 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 return_accept_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 inventory_id drawing_updated_by drawing_updated_date drg_update_status

* 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 riv_no reqd_total_qty piv_no return_issue_qty return_accept_qty return_reject_qty return_rework_qty return_issue_to return_issued_by return_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 return_accept_qty return_issue_qty

* 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

* part_id oa_no proj_no sa_name assy_drg_no sa_drg_no sa_per_assy part_name part_drg_no status start_dt date_drg_issue trgt_date parts_per_assy reqd_total_qty class_of_parts os_planner no_of_stages mat_pr_no mat_pr_dt mat_req_qty mat_recd_qty mat_recvd_date raw_mat_spec raw_mat_dimension remarks vendor vendor_po_no vendor_po_dt vendor_order_qty vendor_trgt_date no_of_days stg_no insp_rep_no mat_issue_qty mat_issue_dt dc_no part_rcpt_qty part_rcpt_dt insp_qty_acpt insp_qty_rework insp_qty_rej insp_date assmbly_issue_qty disp_issue_date design_eng part_drg_aprov_by end_dt bom_upload_date ir_validate po_validate

* transfer_id from_part_id to_part_id from_oa to_oa from_sa_name to_sa_name transfer_qty part_transfer_req_reason part_transfer_req_by part_transfer_req_date part_transfer_req_status part_transfer_req_approve_by part_transfer_req_approve_date part_transfer_no part_transfer_date part_transfer_by tv_no

* 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

* Inventory_id part_name part_drg_no batch_no vendor_order_qty actual_qty reqd_total_qty mat_req_qty mat_recd_qty part_rcpt_qty accepted_qty rejected_qty rework_qty rework_issue_qty part_issue_qty trgt_date class_of_parts status raw_mat_spec raw_mat_dimension remarks stock_remarks_by_date_time bom_qty no_of_stages status_flag pending_assly_issue_qty type mr_na hsn_code sac_code uom model make website STOCK_AVAILABILITY_ALWAYS_ONDEMAND SAFTEY_STOCK_LEVEL NUMBER_OF_UNITS_IN_THE_BATCH PART_SPACE_CONSTRAINT MINIMUM_ORDER_QUANTITY SHELF_LIFE PART_AVAILABILITY_TO_UPCOMING_PROJECT_SCHEDULE PART_OR_PRODUCT PART_ACCESS_RESTRICTED inventory_update_by inventory_update_date

* row_id doc_type doc_no doc_date doc_description

* 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 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 product_category

* 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 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 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 country country_code 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 subtotal_adisc 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 internal_comment request_cancel_by request_cancel_date cancel_request_status amend_request_cancel_by amend_request_cancel_date amend_request_status transport_wotax insurance_wotax packing_wotax total_parts_count total_qty_count total_accepted_qty total_received_qty total_reject_qty total_rework_qty total_rwk_recv_qty total_rework_issue_qty total_issued_qty

* vendor_po_detl_id wo_no part_id unit_price unit_of_measure discount_prcnt total_single_part unit_cost_per_part_wdisc tax_unit_insurence_price tax_unit_transport_price tax_unit_packing_price unit_insurence_price unit_transport_price unit_packing_price unit_total_price_before_gst unit_cost_per_part_adisc_wtax 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 reqd_total_qty

テーブルを選択してください admin_os_planner_detl admin_project_details annexure_doc assembly_activities assembly_details assembly_details_remarks closed_grn_summary_view dc_summary_details department dispatch_activities employee_details employee_roles grn_summary_details inspection_details inspection_summary_details mapusermodule material_issue_detl mat_rcpt_detl mat_req_detl mat_req_stock message org_settings parameter parameter_translations part_issue_details part_rcpt_detl pending_grn_summary_view po_cost_table project_planner project_summary_view proj_detl proj_detl_temp return_issue_details tbldispatchcomponent tblpendcnt tblpurparts temp_detl_view transfer_request_detl 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_inventory_mst t_iso_doc_no_mst t_label_mst t_module_mst t_option_mst t_page_mst t_parts_status 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_product_category_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_transfer_param_mst t_transfer_param_pripority_mst t_transfer_param_values_mst t_transfer_param_val_mapping_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_details_remarks closed_grn_summary_view dc_summary_details department dispatch_activities employee_details employee_roles grn_summary_details inspection_details inspection_summary_details mapusermodule material_issue_detl mat_rcpt_detl mat_req_detl mat_req_stock message org_settings parameter parameter_translations part_issue_details part_rcpt_detl pending_grn_summary_view po_cost_table project_planner project_summary_view proj_detl proj_detl_temp return_issue_details tbldispatchcomponent tblpendcnt tblpurparts temp_detl_view transfer_request_detl 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_inventory_mst t_iso_doc_no_mst t_label_mst t_module_mst t_option_mst t_page_mst t_parts_status 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_product_category_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_transfer_param_mst t_transfer_param_pripority_mst t_transfer_param_values_mst t_transfer_param_val_mapping_mst t_uom_mst t_user_modules_mst user_audit_trails vendor_details vendor_po vendor_po_detl .	カラムを選択してください