最近
`precitec_test`.`t_format_mst`
`precitec_test`.`t_documents_mst`
`phpmyadmin`.`pma__bookmark`
`mysql`.`plugin`
`mysql`.`slow_log`
`mysql`.`columns_priv`
`precitec_test`.`t_transfer_param_val_mapping_mst`
`mysql`.`help_keyword`
`phpmyadmin`.`pma__navigationhiding`
`mysql`.`help_relation`
お気に入り
`precitec_test`.`t_user_modules_mst`
新規作成
information_schema
mechalonic_db
mysql
performance_schema
phpmyadmin
precitec_test
test
ナビゲーションパネル
ナビゲーションツリー
サーバ
データベース
テーブル
ナビゲーションパネル
ナビゲーションパネルの外観をカスタマイズ。
ナビゲーションパネル
データベースナビゲーションをツリーとして表示する
ナビゲーションパネル内のデータベースツリーをセレクタで置き換えます
メインパネルへのリンク
現在のデータベースまたはテーブルを強調表示してメインパネルとリンクします。
ロゴを表示する
ナビゲーションパネル内にロゴを表示します。
ロゴのリンク URL
ナビゲーションパネルのロゴが指す URL。
ロゴリンクのターゲット
リンク先のページをメイン ウィンドウ (
main
) または新しいウィンドウ (
new
) で開く。
main
new
強調表示を有効にする
マウスカーソルの下のサーバ名を強調表示します。
最初のレベルで最大項目数
ナビゲーションツリーの最初のレベルの各ページに表示できる項目の数。
項目表示数を絞るための入力欄が現れる最小の項目数
入力欄を表示します (テーブル、ビュー、ルーチンおよびイベント) の項目の最小数を定義します。
最近使用したテーブル
最近使用したテーブルの最大数。0 で無効になります。
お気に入りのテーブル
お気に入りのテーブルの最大数。0 で無効になります。
ナビゲーションパネル幅
ナビゲーションパネルを折りたたむには、0に設定します。
負でない値ではありません!
ナビゲーションツリー
ナビゲーションツリーをカスタマイズ。
ナビゲーションツリー
項目の最大数
ナビゲーションツリーの各ページに表示できる項目数。
ツリー内項目をグループ化
ナビゲーションツリーの項目をグループ化します(上のデータベースタブとテーブルタブで定義されている区切り記号によって決まります)。
ナビゲーションツリーの展開を有効にします
ナビゲーションパネルでツリー展開の設定。
ツリーでテーブルを表示
ナビゲーションツリーのデータベース下のテーブルを表示
ツリーでビューを表示
ナビゲーションツリーのデータベース下のビューを表示
ツリーで関数を表示
ナビゲーションツリーのデータベース下の関数を表示するかどうか
ツリーでプロシージャを表示
ナビゲーションツリーのデータベース下のプロシージャを表示するかどうか
ツリーでイベントを表示
ナビゲーションツリーのデータベース下のイベントを表示
1つのデータベースを展開する
ナビゲーションツリーで1つデータベースを自動的に展開するかどうか。
サーバ
サーバの表示オプション。
サーバ
サーバ選択を表示する
ナビゲーションパネルの上部にサーバ選択を表示します。
サーバをリストで表示する
サーバの一覧をドロップダウンの代わりにリストで表示します。
データベース
データベースの表示オプション。
データベース
データベース表示数を絞るための入力欄が現れる最小のデータベース数
データベースツリーの区切り
ツリーレベルにデータベースを区切るための文字列。
テーブル
テーブル表示オプション.
テーブル
クイックアクセスアイコンのリンク先
構造
SQL
検索
挿入
表示
2番目のクイックアクセスアイコンのリンク先
構造
SQL
検索
挿入
表示
テーブルツリーの区切り
ツリーレベルにテーブルを区切るための文字列。
テーブルツリーの最大の深さ
ここにファイルをドロップします
SQL アップロード (
0
)
x
-
隠されたナビゲーションツリー項目を表示します。
Javascript を有効にしてください!
サーバ: localhost
データベース: precitec_test
構造
SQL
検索
クエリ
(現在)
エクスポート
インポート
操作
権限
ルーチン
イベント
トリガ
SQL コマンドの追跡
デザイナ
主要カラム
コンソール
クリア
履歴
オプション
ブックマーク
SQL のデバッグ
クエリを実行するには、Ctrl キーを押しながら Enter キーを押します
Enterキーを押してクエリを実行する
昇順
降順
順序:
SQL のデバッグ
カウント
実行順
所要時間
並び順:
グループ クエリ
クエリのクループを解除
折りたたむ
展開
トレースを表示
トレースを非表示
カウント
所要時間
ブックマーク
更新
追加
ブックマークはありません
ブックマークを追加
ラベル:
対象先のデータベース:
ブックマークを共有
OK
オプション
デフォルトに設定
クエリメッセージを常に展開する
開始時にクエリ履歴を表示
現在のクエリを表示
Enterでクエリを実行し、Shift+Enterで新しい行を挿入します。永続的にするには、設定を確認してください。
暗いテーマに切り替える
折りたたむ
展開
再クエリ
編集
EXPLAIN
プロファイリング
ブックマーク
問い合わせ失敗
データベース :
問い合わせた時間 :
読み込み中
ENUM/SET エディタ
ビューを作成する
複数テーブルクエリ
例によるクエリ
ビジュアルビルダ
に切り替え
保存された条件での検索:
新しいブックマーク
カラム:
`admin_os_planner_detl`.*
`admin_os_planner_detl`.`admin_os_planner_detl_id`
`admin_os_planner_detl`.`name`
`admin_os_planner_detl`.`emp_id`
`admin_os_planner_detl`.`projects`
`admin_os_planner_detl`.`vendors`
`admin_os_planner_detl`.`project_coordinator`
`admin_os_planner_detl`.`cell_no`
`admin_project_details`.*
`admin_project_details`.`admin_proj_detail_id`
`admin_project_details`.`oa_no`
`admin_project_details`.`proj_no`
`admin_project_details`.`org_id`
`admin_project_details`.`proj_name`
`admin_project_details`.`product_category`
`admin_project_details`.`quantity`
`admin_project_details`.`proj_trgt_manf_date`
`admin_project_details`.`proj_trgt_date`
`admin_project_details`.`proj_manager`
`admin_project_details`.`proj_coord`
`admin_project_details`.`purchase_coord`
`admin_project_details`.`estmtd_no_parts`
`admin_project_details`.`proj_start_date`
`admin_project_details`.`proj_end_date`
`admin_project_details`.`proj_budget`
`admin_project_details`.`status_flag`
`admin_project_details`.`design_trgt_date`
`admin_project_details`.`hsn_code`
`admin_project_details`.`status_interval`
`annexure_doc`.*
`annexure_doc`.`row_id`
`annexure_doc`.`oa_no`
`annexure_doc`.`po_no`
`annexure_doc`.`vendor`
`annexure_doc`.`file_name`
`assembly_activities`.*
`assembly_activities`.`row_id`
`assembly_activities`.`project_id`
`assembly_activities`.`activity_name`
`assembly_activities`.`activity_st_dt`
`assembly_activities`.`activity_trgt_dt`
`assembly_activities`.`activity_budget`
`assembly_activities`.`responsibility`
`assembly_activities`.`status`
`assembly_activities`.`remarks`
`assembly_activities`.`entry_by`
`assembly_activities`.`entry_dt`
`assembly_activities`.`modify_by`
`assembly_activities`.`modify_dt`
`assembly_details`.*
`assembly_details`.`assembly_id`
`assembly_details`.`oa_no`
`assembly_details`.`proj_no`
`assembly_details`.`asmbly_drg_no`
`assembly_details`.`sa_name`
`assembly_details`.`sa_drg_no`
`assembly_details`.`sa_per_asmbly`
`assembly_details`.`sa_strt_date`
`assembly_details`.`sa_trgt_date`
`assembly_details`.`sa_actual_start_date`
`assembly_details`.`sa_revised_date`
`assembly_details`.`sa_end_date`
`assembly_details`.`status_flag`
`assembly_details`.`design_eng`
`assembly_details`.`sa_drg_remarks`
`assembly_details`.`sa_drg_last_aremarks_by_date_time`
`assembly_details`.`sa_drg_aprov_by`
`assembly_details`.`sa_remarks`
`assembly_details`.`sa_drg_file`
`assembly_details`.`sa_status`
`assembly_details`.`sa_drg_file_flag`
`assembly_details_remarks`.*
`assembly_details_remarks`.`id_assembly_details_remarks`
`assembly_details_remarks`.`oa_no`
`assembly_details_remarks`.`proj_no`
`assembly_details_remarks`.`asmbly_drg_no`
`assembly_details_remarks`.`sa_drg_no`
`assembly_details_remarks`.`sa_name`
`assembly_details_remarks`.`remarks`
`assembly_details_remarks`.`remarks_date_time`
`assembly_details_remarks`.`role`
`assembly_details_remarks`.`username`
`closed_grn_summary_view`.*
`closed_grn_summary_view`.`part_count`
`closed_grn_summary_view`.`grn_status`
`closed_grn_summary_view`.`oa_no`
`closed_grn_summary_view`.`grn_no`
`closed_grn_summary_view`.`vendor`
`closed_grn_summary_view`.`vendor_po_no`
`dc_summary_details`.*
`dc_summary_details`.`dc_summary_id`
`dc_summary_details`.`dc_no`
`dc_summary_details`.`grn_no`
`dc_summary_details`.`vendor`
`dc_summary_details`.`vendor_po_no`
`dc_summary_details`.`vendor_po_date`
`dc_summary_details`.`dc_created_date`
`dc_summary_details`.`dc_created_by`
`dc_summary_details`.`parts_count`
`dc_summary_details`.`parts_issue_qty`
`dc_summary_details`.`accept_qty`
`dc_summary_details`.`reject_qty`
`dc_summary_details`.`rework_qty`
`dc_summary_details`.`rework_issue_qty`
`dc_summary_details`.`pending_qty`
`dc_summary_details`.`total_cost_without_tax`
`dc_summary_details`.`total_cost_taxable`
`dc_summary_details`.`os_planner`
`dc_summary_details`.`oa_no`
`dc_summary_details`.`last_updated`
`department`.*
`department`.`row_id`
`department`.`department_name`
`dispatch_activities`.*
`dispatch_activities`.`row_id`
`dispatch_activities`.`project_id`
`dispatch_activities`.`activity_name`
`dispatch_activities`.`activity_st_dt`
`dispatch_activities`.`activity_trgt_dt`
`dispatch_activities`.`activity_budget`
`dispatch_activities`.`responsibility`
`dispatch_activities`.`status`
`dispatch_activities`.`remarks`
`dispatch_activities`.`entry_by`
`dispatch_activities`.`entry_dt`
`dispatch_activities`.`modify_by`
`dispatch_activities`.`modify_dt`
`employee_details`.*
`employee_details`.`emp_id`
`employee_details`.`emp_name`
`employee_details`.`emp_profile_name`
`employee_details`.`emp_pwd`
`employee_details`.`emp_role`
`employee_details`.`emp_role_id`
`employee_details`.`org_id`
`employee_details`.`project_coordinator`
`employee_details`.`cell_no`
`employee_details`.`emp_email`
`employee_details`.`emp_active_status`
`employee_details`.`static_ip1`
`employee_details`.`static_ip2`
`employee_details`.`last_modified`
`employee_details`.`otp`
`employee_details`.`otp_time`
`employee_roles`.*
`employee_roles`.`emp_role_id`
`employee_roles`.`role_name`
`employee_roles`.`noneditable_fields`
`grn_summary_details`.*
`grn_summary_details`.`grn_summary_id`
`grn_summary_details`.`grn_no`
`grn_summary_details`.`vendor`
`grn_summary_details`.`vendor_po_no`
`grn_summary_details`.`vendor_po_dt`
`grn_summary_details`.`grn_created_date`
`grn_summary_details`.`grn_created_by`
`grn_summary_details`.`grn_type`
`grn_summary_details`.`grn_status`
`grn_summary_details`.`parts_count`
`grn_summary_details`.`vendor_order_qty`
`grn_summary_details`.`parts_receipt_qty`
`grn_summary_details`.`accept_qty`
`grn_summary_details`.`reject_qty`
`grn_summary_details`.`rework_qty`
`grn_summary_details`.`rework_issue_qty`
`grn_summary_details`.`pending_qty`
`grn_summary_details`.`grn_closed_date`
`grn_summary_details`.`grn_closed_by`
`grn_summary_details`.`total_cost_without_tax`
`grn_summary_details`.`total_cost_taxable`
`grn_summary_details`.`os_planner`
`grn_summary_details`.`oa_no`
`grn_summary_details`.`last_updated`
`inspection_details`.*
`inspection_details`.`inspection_id`
`inspection_details`.`part_id`
`inspection_details`.`vendor`
`inspection_details`.`vendor_po_no`
`inspection_details`.`insp_rep_no`
`inspection_details`.`grn_no`
`inspection_details`.`no_of_stg`
`inspection_details`.`stg_no`
`inspection_details`.`reqd_total_qty`
`inspection_details`.`vendor_order_qty`
`inspection_details`.`part_qty_recvd`
`inspection_details`.`insp_qty_acpt`
`inspection_details`.`insp_qty_rej`
`inspection_details`.`insp_qty_rework`
`inspection_details`.`rework_issue_qty`
`inspection_details`.`remarks`
`inspection_details`.`insp_acpt_name`
`inspection_details`.`insp_person`
`inspection_details`.`insp_date`
`inspection_details`.`acpt_date`
`inspection_details`.`no_of_insp`
`inspection_details`.`flg_short_close`
`inspection_details`.`ir_validate`
`inspection_details`.`accept_with_out_tax`
`inspection_details`.`accept_with_tax`
`inspection_details`.`storage_location`
`inspection_summary_details`.*
`inspection_summary_details`.`inspection_summary_id`
`inspection_summary_details`.`vendor`
`inspection_summary_details`.`vendor_po_no`
`inspection_summary_details`.`vendor_po_date`
`inspection_summary_details`.`grn_no`
`inspection_summary_details`.`parts_count`
`inspection_summary_details`.`parts_receipt_qty`
`inspection_summary_details`.`rework_rcpt_qty`
`inspection_summary_details`.`accept_qty`
`inspection_summary_details`.`reject_qty`
`inspection_summary_details`.`rework_qty`
`inspection_summary_details`.`rework_issue_qty`
`inspection_summary_details`.`pending_qty`
`inspection_summary_details`.`os_planner`
`inspection_summary_details`.`oa_no`
`inspection_summary_details`.`inspected_by`
`inspection_summary_details`.`inspected_date`
`inspection_summary_details`.`accepted_cost_without_tax`
`inspection_summary_details`.`accepted_cost_with_tax`
`inspection_summary_details`.`last_updated`
`mapusermodule`.*
`mapusermodule`.`maping_id`
`mapusermodule`.`module`
`mapusermodule`.`rolename`
`mapusermodule`.`moduleaction`
`mat_rcpt_detl`.*
`mat_rcpt_detl`.`id`
`mat_rcpt_detl`.`part_id`
`mat_rcpt_detl`.`raw_mat_spec`
`mat_rcpt_detl`.`mat_req_qty`
`mat_rcpt_detl`.`raw_mat_dimension`
`mat_rcpt_detl`.`mat_pr_no`
`mat_rcpt_detl`.`mat_pr_dt`
`mat_rcpt_detl`.`mat_recd_qty`
`mat_rcpt_detl`.`mat_recvd_date`
`mat_rcpt_detl`.`mat_po_no`
`mat_rcpt_detl`.`os_planner`
`mat_rcpt_detl`.`emp_id`
`mat_req_detl`.*
`mat_req_detl`.`id`
`mat_req_detl`.`part_id`
`mat_req_detl`.`raw_mat_spec`
`mat_req_detl`.`mat_req_qty`
`mat_req_detl`.`mat_recd_qty`
`mat_req_detl`.`raw_mat_dimension`
`mat_req_detl`.`mat_pr_no`
`mat_req_detl`.`mat_pr_dt`
`mat_req_detl`.`request_status`
`mat_req_detl`.`mat_rcpt_trgt_dt`
`mat_req_detl`.`os_planner`
`mat_req_detl`.`emp_id`
`mat_req_detl`.`ir_validate`
`mat_req_detl`.`remarks`
`mat_req_detl`.`ir_validated_by`
`mat_req_detl`.`ir_validation_date`
`mat_req_detl`.`remarks_g`
`mat_req_detl`.`store_keeper`
`mat_req_detl`.`stock_update_date`
`mat_req_detl`.`received_by`
`mat_req_detl`.`approved_by`
`mat_req_stock`.*
`mat_req_stock`.`id`
`mat_req_stock`.`part_id`
`mat_req_stock`.`mat_req_qty`
`mat_req_stock`.`mat_pr_no`
`mat_req_stock`.`ava_stock_qty`
`mat_req_stock`.`pro_add_qty`
`mat_req_stock`.`shelf_days`
`mat_req_stock`.`remarks_stock`
`material_issue_detl`.*
`material_issue_detl`.`material_issue_detl_id`
`material_issue_detl`.`part_id`
`material_issue_detl`.`os_planner`
`material_issue_detl`.`emp_id`
`material_issue_detl`.`vendor`
`material_issue_detl`.`vendor_po_no`
`material_issue_detl`.`raw_mat_spec`
`material_issue_detl`.`raw_mat_dimension`
`material_issue_detl`.`mat_req_qty`
`material_issue_detl`.`mat_recd_qty`
`material_issue_detl`.`vendor_po_qty`
`material_issue_detl`.`mat_issue_qty`
`material_issue_detl`.`mat_issue_dt`
`material_issue_detl`.`dc_no`
`material_issue_detl`.`dc_type`
`message`.*
`message`.`message_id`
`message`.`part_id`
`message`.`org_id`
`message`.`message`
`message`.`msg_by`
`message`.`msg_to`
`message`.`msg_on`
`message`.`msg_type`
`message`.`msg_read`
`message`.`msg_vendor`
`org_settings`.*
`org_settings`.`org_id`
`org_settings`.`org_full_name`
`org_settings`.`org_short_name`
`org_settings`.`org_address_line_1`
`org_settings`.`org_address_line_2`
`org_settings`.`org_division_unit`
`org_settings`.`org_ph_no_1`
`org_settings`.`org_ph_no_2`
`org_settings`.`org_email`
`org_settings`.`org_website`
`org_settings`.`org_logo_path`
`org_settings`.`org_certification_logo_path`
`org_settings`.`org_iso_certified_title`
`org_settings`.`org_gstin_no`
`org_settings`.`org_pan_no`
`org_settings`.`org_excise_no`
`org_settings`.`org_services`
`org_settings`.`org_products`
`org_settings`.`org_misc_details`
`org_settings`.`org_currency_full`
`org_settings`.`org_currency_symbol`
`org_settings`.`org_currecny_short`
`org_settings`.`org_date_format`
`org_settings`.`org_estd_date`
`org_settings`.`org_active_status`
`org_settings`.`org_bucket`
`org_settings`.`hsn_code`
`org_settings`.`sac_code`
`parameter`.*
`parameter`.`id_param`
`parameter`.`org_id`
`parameter`.`parameter`
`parameter_translations`.*
`parameter_translations`.`id_translations`
`parameter_translations`.`lang_iso_code`
`parameter_translations`.`id_param`
`parameter_translations`.`custom_parameter`
`parameter_translations`.`org_id`
`parameter_translations`.`param_help`
`part_issue_details`.*
`part_issue_details`.`id`
`part_issue_details`.`part_id`
`part_issue_details`.`os_planner`
`part_issue_details`.`trgt_date`
`part_issue_details`.`vendor`
`part_issue_details`.`vendor_po_no`
`part_issue_details`.`grn_no`
`part_issue_details`.`dc_no`
`part_issue_details`.`dc_type`
`part_issue_details`.`no_of_stages`
`part_issue_details`.`stg_no`
`part_issue_details`.`reqd_total_qty`
`part_issue_details`.`vendor_order_qty`
`part_issue_details`.`part_rcpt_qty`
`part_issue_details`.`part_issue_qty`
`part_issue_details`.`part_issue_date`
`part_issue_details`.`part_issue_by`
`part_issue_details`.`vehicle_no`
`part_issue_details`.`mode_of_dispatch`
`part_issue_details`.`approximate_value`
`part_issue_details`.`e_sugam_no`
`part_issue_details`.`e_way_bill_no`
`part_issue_details`.`notes`
`part_issue_details`.`insp_rep_no`
`part_issue_details`.`dc_value_with_out_tax`
`part_issue_details`.`dc_value_with_tax`
`part_rcpt_detl`.*
`part_rcpt_detl`.`part_recpt_id`
`part_rcpt_detl`.`part_id`
`part_rcpt_detl`.`os_planner`
`part_rcpt_detl`.`trgt_dt`
`part_rcpt_detl`.`vendor`
`part_rcpt_detl`.`vendor_po_no`
`part_rcpt_detl`.`no_of_stages`
`part_rcpt_detl`.`stg_no`
`part_rcpt_detl`.`reqd_total_qty`
`part_rcpt_detl`.`vendor_order_qty`
`part_rcpt_detl`.`part_rcpt_qty`
`part_rcpt_detl`.`part_rcpt_dt`
`part_rcpt_detl`.`grn_no`
`part_rcpt_detl`.`grn_dt`
`part_rcpt_detl`.`grn_created_by`
`part_rcpt_detl`.`grn_status`
`part_rcpt_detl`.`grn_type`
`part_rcpt_detl`.`rework_rcpt_qty`
`part_rcpt_detl`.`inward_invoice_no`
`part_rcpt_detl`.`inward_invoice_dt`
`part_rcpt_detl`.`inward_dc_no`
`part_rcpt_detl`.`inward_dc_dt`
`part_rcpt_detl`.`grn_closed_by`
`part_rcpt_detl`.`grn_notes`
`part_rcpt_detl`.`e_way_bill_no`
`part_rcpt_detl`.`part_rcpt_updated_by`
`part_rcpt_detl`.`part_rcpt_updated_dt`
`part_rcpt_detl`.`grn_value_adisc_before_gst`
`part_rcpt_detl`.`grn_value_adisc_with_gst`
`part_rcpt_detl`.`grn_cancel_reason`
`part_rcpt_detl`.`grn_cancel_req_by`
`part_rcpt_detl`.`grn_cancel_req_date`
`part_rcpt_detl`.`grn_cancel_req_status`
`part_rcpt_detl`.`grn_cancelled_by`
`part_rcpt_detl`.`grn_cancelled_date`
`part_rcpt_detl`.`request_cancel_by`
`part_rcpt_detl`.`request_cancel_date`
`part_rcpt_detl`.`cancel_request_status`
`pending_grn_summary_view`.*
`pending_grn_summary_view`.`part_count`
`pending_grn_summary_view`.`grn_status`
`pending_grn_summary_view`.`oa_no`
`pending_grn_summary_view`.`vendor`
`pending_grn_summary_view`.`vendor_po_no`
`pending_grn_summary_view`.`grn_no`
`po_cost_table`.*
`po_cost_table`.`id`
`po_cost_table`.`vendor`
`po_cost_table`.`oa_no`
`po_cost_table`.`vendor_po_no`
`po_cost_table`.`vendor_po_dt`
`po_cost_table`.`total_cost`
`po_cost_table`.`acpt_date`
`po_cost_table`.`payment_days`
`proj_detl`.*
`proj_detl`.`part_id`
`proj_detl`.`oa_no`
`proj_detl`.`proj_no`
`proj_detl`.`product_category`
`proj_detl`.`sa_name`
`proj_detl`.`assy_drg_no`
`proj_detl`.`sa_drg_no`
`proj_detl`.`sa_per_assy`
`proj_detl`.`part_name`
`proj_detl`.`part_drg_no`
`proj_detl`.`batch_no`
`proj_detl`.`parts_per_assy`
`proj_detl`.`vendor_order_qty`
`proj_detl`.`actual_qty`
`proj_detl`.`reqd_total_qty`
`proj_detl`.`mat_req_qty`
`proj_detl`.`mat_recd_qty`
`proj_detl`.`mat_issue_qty`
`proj_detl`.`part_rcpt_qty`
`proj_detl`.`accepted_qty`
`proj_detl`.`rejected_qty`
`proj_detl`.`rework_qty`
`proj_detl`.`rework_issue_qty`
`proj_detl`.`part_issue_qty`
`proj_detl`.`trgt_date`
`proj_detl`.`class_of_parts`
`proj_detl`.`status`
`proj_detl`.`os_planner`
`proj_detl`.`date_drg_issue`
`proj_detl`.`raw_mat_spec`
`proj_detl`.`raw_mat_dimension`
`proj_detl`.`rev_del_dt`
`proj_detl`.`remarks`
`proj_detl`.`proj_remarks_by_date_time`
`proj_detl`.`bom_qty`
`proj_detl`.`part_acpt_date`
`proj_detl`.`part_issue_assly_date`
`proj_detl`.`part_issue_assly_qty`
`proj_detl`.`return_accept_qty`
`proj_detl`.`no_of_stages`
`proj_detl`.`status_flag`
`proj_detl`.`start_dt`
`proj_detl`.`end_dt`
`proj_detl`.`pending_assly_issue_qty`
`proj_detl`.`bom_upload_date`
`proj_detl`.`design_eng`
`proj_detl`.`part_drg_remarks`
`proj_detl`.`part_drg_aprov_by`
`proj_detl`.`drg_release_dt`
`proj_detl`.`type`
`proj_detl`.`final_insp_dt`
`proj_detl`.`no_of_insp`
`proj_detl`.`mr_na`
`proj_detl`.`part_drg_release_by`
`proj_detl`.`hsn_code`
`proj_detl`.`sac_code`
`proj_detl`.`revision`
`proj_detl`.`uom`
`proj_detl`.`model`
`proj_detl`.`make`
`proj_detl`.`website`
`proj_detl`.`alternate_allow`
`proj_detl`.`week_lead_time`
`proj_detl`.`part_drg_file`
`proj_detl`.`part_drg_file_flag`
`proj_detl`.`sa_drg_file`
`proj_detl`.`sa_drg_file_flag`
`proj_detl`.`qc_require`
`proj_detl`.`inventory_id`
`proj_detl`.`drawing_updated_by`
`proj_detl`.`drawing_updated_date`
`proj_detl`.`drg_update_status`
`proj_detl_temp`.*
`proj_detl_temp`.`proj_detl_id`
`proj_detl_temp`.`oa_no`
`proj_detl_temp`.`proj_no`
`proj_detl_temp`.`sa_name`
`proj_detl_temp`.`assy_drg_no`
`proj_detl_temp`.`sa_drg_no`
`proj_detl_temp`.`sa_drg_revision`
`proj_detl_temp`.`sa_per_assy`
`proj_detl_temp`.`part_name`
`proj_detl_temp`.`part_drg_no`
`proj_detl_temp`.`batch_no`
`proj_detl_temp`.`parts_per_assy`
`proj_detl_temp`.`reqd_total_qty`
`proj_detl_temp`.`bom_qty`
`proj_detl_temp`.`stages`
`proj_detl_temp`.`trgt_date`
`proj_detl_temp`.`class_of_parts`
`proj_detl_temp`.`raw_mat_spec`
`proj_detl_temp`.`raw_mat_dimension`
`proj_detl_temp`.`bom_upload_date`
`proj_detl_temp`.`design_eng`
`proj_detl_temp`.`part_drg_remarks`
`proj_detl_temp`.`part_drg_release_by`
`proj_detl_temp`.`drg_release_dt`
`proj_detl_temp`.`type`
`proj_detl_temp`.`revision`
`proj_detl_temp`.`revision_date`
`proj_detl_temp`.`make`
`proj_detl_temp`.`model`
`proj_detl_temp`.`uom`
`proj_detl_temp`.`website`
`proj_detl_temp`.`hsn_code`
`proj_detl_temp`.`sac_code`
`proj_detl_temp`.`alternate_allow`
`proj_detl_temp`.`week_lead_time`
`proj_detl_temp`.`last_modified_date`
`proj_detl_temp`.`last_modified_by`
`proj_detl_temp`.`part_drg_file`
`proj_detl_temp`.`part_drg_file_flag`
`proj_detl_temp`.`sa_drg_file`
`proj_detl_temp`.`sa_drg_file_flag`
`proj_detl_temp`.`remarks`
`proj_detl_temp`.`status_flag`
`project_planner`.*
`project_planner`.`row_id`
`project_planner`.`project_id`
`project_planner`.`department_id`
`project_planner`.`activity_name`
`project_planner`.`activity_st_dt`
`project_planner`.`activity_trgt_dt`
`project_planner`.`activity_budget`
`project_planner`.`entry_by`
`project_planner`.`entry_dt`
`project_planner`.`modify_by`
`project_planner`.`modify_dt`
`project_summary_view`.*
`project_summary_view`.`oa_no`
`project_summary_view`.`proj_name`
`project_summary_view`.`proj_trgt_date`
`project_summary_view`.`status`
`project_summary_view`.`project_cost`
`project_summary_view`.`proj_budget`
`return_issue_details`.*
`return_issue_details`.`id`
`return_issue_details`.`part_id`
`return_issue_details`.`oa_no`
`return_issue_details`.`sa_name`
`return_issue_details`.`sa_drg_no`
`return_issue_details`.`part_name`
`return_issue_details`.`part_drg_no`
`return_issue_details`.`riv_no`
`return_issue_details`.`reqd_total_qty`
`return_issue_details`.`piv_no`
`return_issue_details`.`return_issue_qty`
`return_issue_details`.`return_accept_qty`
`return_issue_details`.`return_reject_qty`
`return_issue_details`.`return_rework_qty`
`return_issue_details`.`return_issue_to`
`return_issue_details`.`return_issued_by`
`return_issue_details`.`return_issue_date`
`return_issue_details`.`class_of_parts`
`return_issue_details`.`remarks`
`t_activities_mst`.*
`t_activities_mst`.`row_id`
`t_activities_mst`.`project_id`
`t_activities_mst`.`department_id`
`t_activities_mst`.`activity_name`
`t_activities_mst`.`activity_st_dt`
`t_activities_mst`.`activity_trgt_dt`
`t_activities_mst`.`actual_st_dt`
`t_activities_mst`.`actual_trgt_dt`
`t_activities_mst`.`activity_budget`
`t_activities_mst`.`responsibility`
`t_activities_mst`.`status`
`t_activities_mst`.`remarks`
`t_activities_mst`.`entry_by`
`t_activities_mst`.`entry_dt`
`t_activities_mst`.`modify_by`
`t_activities_mst`.`modify_dt`
`t_additional_charges_mst`.*
`t_additional_charges_mst`.`row_id`
`t_additional_charges_mst`.`additional_charge_type`
`t_class_of_parts_mst`.*
`t_class_of_parts_mst`.`row_id`
`t_class_of_parts_mst`.`class_of_part`
`t_control_mst`.*
`t_control_mst`.`row_id`
`t_control_mst`.`record_type`
`t_control_mst`.`record_value`
`t_currency_mst`.*
`t_currency_mst`.`row_id`
`t_currency_mst`.`currency`
`t_currency_mst`.`sub_text`
`t_currency_mst`.`decimal_words`
`t_currency_mst`.`symbol`
`t_currency_mst`.`default`
`t_documents_mst`.*
`t_documents_mst`.`row_id`
`t_documents_mst`.`wo_no`
`t_documents_mst`.`document_title`
`t_documents_mst`.`document_file`
`t_drawing_format_mst`.*
`t_drawing_format_mst`.`row_id`
`t_drawing_format_mst`.`doc_type`
`t_drawing_format_mst`.`pos1`
`t_drawing_format_mst`.`pos2`
`t_drawing_format_mst`.`pos3`
`t_drawing_format_mst`.`pos4`
`t_drawing_format_mst`.`pos5`
`t_drawing_format_mst`.`pos6`
`t_drawing_format_mst`.`pos7`
`t_drawing_format_mst`.`pos8`
`t_drawing_format_mst`.`pos9`
`t_drawing_format_mst`.`version_prefix`
`t_drawing_format_mst`.`separator`
`t_editable_fields_mst`.*
`t_editable_fields_mst`.`row_id`
`t_editable_fields_mst`.`editable_fields`
`t_editable_fields_mst`.`column_name`
`t_format_mst`.*
`t_format_mst`.`row_id`
`t_format_mst`.`doc_type`
`t_format_mst`.`pos1`
`t_format_mst`.`pos2`
`t_format_mst`.`pos3`
`t_format_mst`.`pos4`
`t_format_mst`.`pos5`
`t_format_mst`.`prefix`
`t_format_mst`.`separator`
`t_format_mst`.`year`
`t_format_mst`.`sl_no_length`
`t_format_mst`.`year_separator`
`t_inventory_mst`.*
`t_inventory_mst`.`Inventory_id`
`t_inventory_mst`.`part_name`
`t_inventory_mst`.`part_drg_no`
`t_inventory_mst`.`batch_no`
`t_inventory_mst`.`vendor_order_qty`
`t_inventory_mst`.`actual_qty`
`t_inventory_mst`.`reqd_total_qty`
`t_inventory_mst`.`mat_req_qty`
`t_inventory_mst`.`mat_recd_qty`
`t_inventory_mst`.`part_rcpt_qty`
`t_inventory_mst`.`accepted_qty`
`t_inventory_mst`.`rejected_qty`
`t_inventory_mst`.`rework_qty`
`t_inventory_mst`.`rework_issue_qty`
`t_inventory_mst`.`part_issue_qty`
`t_inventory_mst`.`trgt_date`
`t_inventory_mst`.`class_of_parts`
`t_inventory_mst`.`status`
`t_inventory_mst`.`raw_mat_spec`
`t_inventory_mst`.`raw_mat_dimension`
`t_inventory_mst`.`remarks`
`t_inventory_mst`.`stock_remarks_by_date_time`
`t_inventory_mst`.`bom_qty`
`t_inventory_mst`.`no_of_stages`
`t_inventory_mst`.`status_flag`
`t_inventory_mst`.`pending_assly_issue_qty`
`t_inventory_mst`.`type`
`t_inventory_mst`.`mr_na`
`t_inventory_mst`.`hsn_code`
`t_inventory_mst`.`sac_code`
`t_inventory_mst`.`uom`
`t_inventory_mst`.`model`
`t_inventory_mst`.`make`
`t_inventory_mst`.`website`
`t_inventory_mst`.`STOCK_AVAILABILITY_ALWAYS_ONDEMAND`
`t_inventory_mst`.`SAFTEY_STOCK_LEVEL`
`t_inventory_mst`.`NUMBER_OF_UNITS_IN_THE_BATCH`
`t_inventory_mst`.`PART_SPACE_CONSTRAINT`
`t_inventory_mst`.`MINIMUM_ORDER_QUANTITY`
`t_inventory_mst`.`SHELF_LIFE`
`t_inventory_mst`.`PART_AVAILABILITY_TO_UPCOMING_PROJECT_SCHEDULE`
`t_inventory_mst`.`PART_OR_PRODUCT`
`t_inventory_mst`.`PART_ACCESS_RESTRICTED`
`t_inventory_mst`.`inventory_update_by`
`t_inventory_mst`.`inventory_update_date`
`t_iso_doc_no_mst`.*
`t_iso_doc_no_mst`.`row_id`
`t_iso_doc_no_mst`.`doc_type`
`t_iso_doc_no_mst`.`doc_no`
`t_iso_doc_no_mst`.`doc_date`
`t_iso_doc_no_mst`.`doc_description`
`t_label_mst`.*
`t_label_mst`.`row_id`
`t_label_mst`.`page_id`
`t_label_mst`.`page_label`
`t_module_mst`.*
`t_module_mst`.`row_id`
`t_module_mst`.`module_id`
`t_module_mst`.`module_name`
`t_module_mst`.`module_icon`
`t_module_mst`.`entry_by`
`t_module_mst`.`entry_dt`
`t_module_mst`.`modify_by`
`t_module_mst`.`modify_dt`
`t_option_mst`.*
`t_option_mst`.`row_id`
`t_option_mst`.`module_id`
`t_option_mst`.`option_id`
`t_option_mst`.`option_name`
`t_option_mst`.`option_controller`
`t_option_mst`.`entry_by`
`t_option_mst`.`entry_dt`
`t_option_mst`.`entry_tm`
`t_option_mst`.`modify_by`
`t_option_mst`.`modify_dt`
`t_option_mst`.`modify_tm`
`t_option_mst`.`option_remarks`
`t_page_mst`.*
`t_page_mst`.`row_id`
`t_page_mst`.`page_name`
`t_page_mst`.`page_description`
`t_part_docs_mst`.*
`t_part_docs_mst`.`row_id`
`t_part_docs_mst`.`wo_no`
`t_part_docs_mst`.`sa_name`
`t_part_docs_mst`.`sa_drg_no`
`t_part_docs_mst`.`part_id`
`t_part_docs_mst`.`doc_type`
`t_part_docs_mst`.`doc_file`
`t_part_type_mst`.*
`t_part_type_mst`.`row_id`
`t_part_type_mst`.`part_type`
`t_parts_status`.*
`t_parts_status`.`row_id`
`t_parts_status`.`wo_no`
`t_parts_status`.`sa_name`
`t_parts_status`.`part_name`
`t_parts_status`.`part_id`
`t_parts_status`.`stage_no`
`t_parts_status`.`stage_weightage`
`t_parts_status`.`part_approve`
`t_parts_status`.`mat_req`
`t_parts_status`.`mat_recpt`
`t_parts_status`.`vendor_po`
`t_parts_status`.`mat_issue`
`t_parts_status`.`mfg`
`t_parts_status`.`part_recpt`
`t_parts_status`.`part_issue`
`t_parts_status`.`reject`
`t_parts_status`.`rework`
`t_parts_status`.`accept`
`t_parts_status`.`assembly`
`t_parts_status`.`raw_mat_na`
`t_parts_status`.`mr_na`
`t_parts_status`.`multi_stage`
`t_parts_status`.`total_qty`
`t_parts_status`.`status`
`t_planned_status_trn`.*
`t_planned_status_trn`.`row_id`
`t_planned_status_trn`.`project_id`
`t_planned_status_trn`.`interval_dt`
`t_planned_status_trn`.`planned_status`
`t_planned_status_trn`.`actual_status`
`t_po_param_mst`.*
`t_po_param_mst`.`row_id`
`t_po_param_mst`.`parameter_name`
`t_po_param_mst`.`parameter_field`
`t_po_param_mst`.`parameter_type`
`t_po_param_mst`.`parameter_field_type`
`t_po_param_pripority_mst`.*
`t_po_param_pripority_mst`.`row_id`
`t_po_param_pripority_mst`.`parameter_id`
`t_po_param_pripority_mst`.`parameter_priority`
`t_po_param_val_mapping_mst`.*
`t_po_param_val_mapping_mst`.`row_id`
`t_po_param_val_mapping_mst`.`user_name`
`t_po_param_val_mapping_mst`.`parameter_id`
`t_po_param_val_mapping_mst`.`parameter_value1`
`t_po_param_val_mapping_mst`.`parameter_value2`
`t_po_param_val_mapping_mst`.`access`
`t_po_param_values_mst`.*
`t_po_param_values_mst`.`row_id`
`t_po_param_values_mst`.`parameter_id`
`t_po_param_values_mst`.`parameter_value1`
`t_po_param_values_mst`.`parameter_value2`
`t_product_category_mst`.*
`t_product_category_mst`.`row_id`
`t_product_category_mst`.`product_category`
`t_qcrequire_mst`.*
`t_qcrequire_mst`.`row_id`
`t_qcrequire_mst`.`type`
`t_qcrequire_mst`.`A`
`t_qcrequire_mst`.`B`
`t_qcrequire_mst`.`C`
`t_rawmatspec_mst`.*
`t_rawmatspec_mst`.`row_id`
`t_rawmatspec_mst`.`rawmat_spec`
`t_services_mst`.*
`t_services_mst`.`row_id`
`t_services_mst`.`service_name`
`t_status_weightage`.*
`t_status_weightage`.`row_id`
`t_status_weightage`.`activity_name`
`t_status_weightage`.`status_percent`
`t_status_weightage`.`activity_weightage`
`t_status_weightage`.`column_name`
`t_subactivities_mst`.*
`t_subactivities_mst`.`row_id`
`t_subactivities_mst`.`project_id`
`t_subactivities_mst`.`activity_id`
`t_subactivities_mst`.`subactivity_name`
`t_subactivities_mst`.`subactivity_st_dt`
`t_subactivities_mst`.`subactivity_trgt_dt`
`t_subactivities_mst`.`actual_st_dt`
`t_subactivities_mst`.`actual_trgt_dt`
`t_subactivities_mst`.`subactivity_budget`
`t_subactivities_mst`.`responsibility`
`t_subactivities_mst`.`status`
`t_subactivities_mst`.`remarks`
`t_subactivities_mst`.`entry_by`
`t_subactivities_mst`.`entry_dt`
`t_subactivities_mst`.`modify_by`
`t_subactivities_mst`.`modify_dt`
`t_tax_mst`.*
`t_tax_mst`.`row_id`
`t_tax_mst`.`tax_slab`
`t_terms_mst`.*
`t_terms_mst`.`row_id`
`t_terms_mst`.`terms_type`
`t_terms_mst`.`terms_description`
`t_transaction_edit_mst`.*
`t_transaction_edit_mst`.`row_id`
`t_transaction_edit_mst`.`user_name`
`t_transaction_edit_mst`.`mrn`
`t_transaction_edit_mst`.`grn`
`t_transaction_edit_mst`.`inspection`
`t_transaction_edit_mst`.`issue`
`t_transaction_edit_mst`.`dispatch`
`t_transfer_param_mst`.*
`t_transfer_param_mst`.`row_id`
`t_transfer_param_mst`.`parameter_name`
`t_transfer_param_mst`.`parameter_field`
`t_transfer_param_mst`.`parameter_type`
`t_transfer_param_mst`.`parameter_field_type`
`t_transfer_param_pripority_mst`.*
`t_transfer_param_pripority_mst`.`row_id`
`t_transfer_param_pripority_mst`.`parameter_id`
`t_transfer_param_pripority_mst`.`parameter_priority`
`t_transfer_param_val_mapping_mst`.*
`t_transfer_param_val_mapping_mst`.`row_id`
`t_transfer_param_val_mapping_mst`.`user_name`
`t_transfer_param_val_mapping_mst`.`parameter_id`
`t_transfer_param_val_mapping_mst`.`parameter_value1`
`t_transfer_param_val_mapping_mst`.`parameter_value2`
`t_transfer_param_val_mapping_mst`.`access`
`t_transfer_param_values_mst`.*
`t_transfer_param_values_mst`.`row_id`
`t_transfer_param_values_mst`.`parameter_id`
`t_transfer_param_values_mst`.`parameter_value1`
`t_transfer_param_values_mst`.`parameter_value2`
`t_uom_mst`.*
`t_uom_mst`.`row_id`
`t_uom_mst`.`uom_name`
`t_user_modules_mst`.*
`t_user_modules_mst`.`row_id`
`t_user_modules_mst`.`emp_id`
`t_user_modules_mst`.`option_id`
`t_user_modules_mst`.`entry_by`
`t_user_modules_mst`.`entry_dt`
`t_user_modules_mst`.`entry_tm`
`t_user_modules_mst`.`entry_ip`
`t_user_modules_mst`.`entry_lat`
`t_user_modules_mst`.`entry_log`
`t_user_modules_mst`.`modify_by`
`t_user_modules_mst`.`modify_dt`
`t_user_modules_mst`.`modify_tm`
`t_user_modules_mst`.`modify_ip`
`t_user_modules_mst`.`modify_lat`
`t_user_modules_mst`.`modify_log`
`tbldispatchcomponent`.*
`tbldispatchcomponent`.`id`
`tbldispatchcomponent`.`part_id`
`tbldispatchcomponent`.`oa_no`
`tbldispatchcomponent`.`sa_name`
`tbldispatchcomponent`.`sa_drg_no`
`tbldispatchcomponent`.`part_name`
`tbldispatchcomponent`.`part_drg_no`
`tbldispatchcomponent`.`insp_rep_no`
`tbldispatchcomponent`.`reqd_total_qty`
`tbldispatchcomponent`.`piv_no`
`tbldispatchcomponent`.`Issue_qty`
`tbldispatchcomponent`.`issue_to`
`tbldispatchcomponent`.`issued_by`
`tbldispatchcomponent`.`issue_date`
`tbldispatchcomponent`.`class_of_parts`
`tbldispatchcomponent`.`remarks`
`tbldispatchcomponent`.`return_accept_qty`
`tbldispatchcomponent`.`return_issue_qty`
`tblpendcnt`.*
`tblpendcnt`.`id`
`tblpendcnt`.`part_id`
`tblpendcnt`.`oa_no`
`tblpendcnt`.`os_planner`
`tblpendcnt`.`no_of_stages`
`tblpendcnt`.`total_qty`
`tblpendcnt`.`completed_qty`
`tblpendcnt`.`pending_qty`
`tblpendcnt`.`req_qty`
`tblpendcnt`.`rcpt_qty`
`tblpendcnt`.`po_qty`
`tblpendcnt`.`issue_qty`
`tblpendcnt`.`mr_na`
`tblpendcnt`.`part_rcpt_qty`
`tblpendcnt`.`part_issue_qty`
`tblpendcnt`.`dispatch_qty`
`tblpendcnt`.`status`
`tblpendcnt`.`po_qty_firststg`
`tblpurparts`.*
`tblpurparts`.`pur_parts_id`
`tblpurparts`.`oa_no`
`tblpurparts`.`proj_no`
`tblpurparts`.`assy_drg_no`
`tblpurparts`.`sa_name`
`tblpurparts`.`sa_drg_no`
`tblpurparts`.`sa_per_assy`
`tblpurparts`.`part_name`
`tblpurparts`.`part_drg_no`
`tblpurparts`.`parts_per_assy`
`tblpurparts`.`reqd_total_qty`
`tblpurparts`.`class_of_parts`
`tblpurparts`.`raw_mat_spec`
`tblpurparts`.`raw_mat_dimension`
`tblpurparts`.`bom_upload_date`
`tblpurparts`.`design_eng`
`tblpurparts`.`part_drg_remarks`
`tblpurparts`.`part_drg_aprov_by`
`temp_detl_view`.*
`temp_detl_view`.`part_id`
`temp_detl_view`.`oa_no`
`temp_detl_view`.`proj_no`
`temp_detl_view`.`sa_name`
`temp_detl_view`.`assy_drg_no`
`temp_detl_view`.`sa_drg_no`
`temp_detl_view`.`sa_per_assy`
`temp_detl_view`.`part_name`
`temp_detl_view`.`part_drg_no`
`temp_detl_view`.`status`
`temp_detl_view`.`start_dt`
`temp_detl_view`.`date_drg_issue`
`temp_detl_view`.`trgt_date`
`temp_detl_view`.`parts_per_assy`
`temp_detl_view`.`reqd_total_qty`
`temp_detl_view`.`class_of_parts`
`temp_detl_view`.`os_planner`
`temp_detl_view`.`no_of_stages`
`temp_detl_view`.`mat_pr_no`
`temp_detl_view`.`mat_pr_dt`
`temp_detl_view`.`mat_req_qty`
`temp_detl_view`.`mat_recd_qty`
`temp_detl_view`.`mat_recvd_date`
`temp_detl_view`.`raw_mat_spec`
`temp_detl_view`.`raw_mat_dimension`
`temp_detl_view`.`remarks`
`temp_detl_view`.`vendor`
`temp_detl_view`.`vendor_po_no`
`temp_detl_view`.`vendor_po_dt`
`temp_detl_view`.`vendor_order_qty`
`temp_detl_view`.`vendor_trgt_date`
`temp_detl_view`.`no_of_days`
`temp_detl_view`.`stg_no`
`temp_detl_view`.`insp_rep_no`
`temp_detl_view`.`mat_issue_qty`
`temp_detl_view`.`mat_issue_dt`
`temp_detl_view`.`dc_no`
`temp_detl_view`.`part_rcpt_qty`
`temp_detl_view`.`part_rcpt_dt`
`temp_detl_view`.`insp_qty_acpt`
`temp_detl_view`.`insp_qty_rework`
`temp_detl_view`.`insp_qty_rej`
`temp_detl_view`.`insp_date`
`temp_detl_view`.`assmbly_issue_qty`
`temp_detl_view`.`disp_issue_date`
`temp_detl_view`.`design_eng`
`temp_detl_view`.`part_drg_aprov_by`
`temp_detl_view`.`end_dt`
`temp_detl_view`.`bom_upload_date`
`temp_detl_view`.`ir_validate`
`temp_detl_view`.`po_validate`
`transfer_request_detl`.*
`transfer_request_detl`.`transfer_id`
`transfer_request_detl`.`from_part_id`
`transfer_request_detl`.`to_part_id`
`transfer_request_detl`.`from_oa`
`transfer_request_detl`.`to_oa`
`transfer_request_detl`.`from_sa_name`
`transfer_request_detl`.`to_sa_name`
`transfer_request_detl`.`transfer_qty`
`transfer_request_detl`.`part_transfer_req_reason`
`transfer_request_detl`.`part_transfer_req_by`
`transfer_request_detl`.`part_transfer_req_date`
`transfer_request_detl`.`part_transfer_req_status`
`transfer_request_detl`.`part_transfer_req_approve_by`
`transfer_request_detl`.`part_transfer_req_approve_date`
`transfer_request_detl`.`part_transfer_no`
`transfer_request_detl`.`part_transfer_date`
`transfer_request_detl`.`part_transfer_by`
`transfer_request_detl`.`tv_no`
`user_audit_trails`.*
`user_audit_trails`.`id`
`user_audit_trails`.`user_id`
`user_audit_trails`.`user_name`
`user_audit_trails`.`event`
`user_audit_trails`.`table_name`
`user_audit_trails`.`old_values`
`user_audit_trails`.`new_values`
`user_audit_trails`.`url`
`user_audit_trails`.`name`
`user_audit_trails`.`ip_address`
`user_audit_trails`.`user_agent`
`user_audit_trails`.`created_at`
`vendor_details`.*
`vendor_details`.`vendor_detail_id`
`vendor_details`.`vendor_id`
`vendor_details`.`org_id`
`vendor_details`.`name`
`vendor_details`.`address`
`vendor_details`.`country`
`vendor_details`.`country_code`
`vendor_details`.`phone_no`
`vendor_details`.`mobile_no`
`vendor_details`.`email`
`vendor_details`.`website`
`vendor_details`.`products`
`vendor_details`.`services`
`vendor_details`.`contact_person`
`vendor_details`.`iso_9001_certified`
`vendor_details`.`vat_reg_no`
`vendor_details`.`service_tax`
`vendor_details`.`pan_no`
`vendor_details`.`tan_no`
`vendor_details`.`exercise_reg_no`
`vendor_details`.`job_approved_type`
`vendor_details`.`vendor_reg_no`
`vendor_details`.`os_planner`
`vendor_details`.`gst_no`
`vendor_details`.`vendor_active_status`
`vendor_details`.`comp_reg_type`
`vendor_details`.`gst_reg_type`
`vendor_po`.*
`vendor_po`.`vendor_po_id`
`vendor_po`.`wo_no`
`vendor_po`.`mrn_no`
`vendor_po`.`vendor`
`vendor_po`.`vendor_id`
`vendor_po`.`vendor_address`
`vendor_po`.`vendor_gst`
`vendor_po`.`ship_to`
`vendor_po`.`vendor_po_no`
`vendor_po`.`type`
`vendor_po`.`vendor_po_dt`
`vendor_po`.`validated_date`
`vendor_po`.`gst_type`
`vendor_po`.`gst_tax_prcnt`
`vendor_po`.`gst_total`
`vendor_po`.`with_without_raw`
`vendor_po`.`verified_date`
`vendor_po`.`terms_n_conditions`
`vendor_po`.`sub_total`
`vendor_po`.`discount_amount`
`vendor_po`.`subtotal_adisc`
`vendor_po`.`sub_total_amount`
`vendor_po`.`total_cost`
`vendor_po`.`total_words`
`vendor_po`.`currency`
`vendor_po`.`rupees_per_doller`
`vendor_po`.`currency_amount`
`vendor_po`.`pf_prcnt`
`vendor_po`.`freight`
`vendor_po`.`insurance`
`vendor_po`.`dispatch`
`vendor_po`.`payment`
`vendor_po`.`incoterms`
`vendor_po`.`delivery`
`vendor_po`.`documents`
`vendor_po`.`prepared_by`
`vendor_po`.`verified_by`
`vendor_po`.`issued_date`
`vendor_po`.`poRemarks`
`vendor_po`.`pack_instructions`
`vendor_po`.`po_validate_status`
`vendor_po`.`po_validate`
`vendor_po`.`po_validated_by`
`vendor_po`.`po_validated_date`
`vendor_po`.`po_prepared_date`
`vendor_po`.`po_validated_role`
`vendor_po`.`po_amendment_req_reason`
`vendor_po`.`po_amendment_req_by`
`vendor_po`.`po_amendment_req_date`
`vendor_po`.`po_amendment_req_status`
`vendor_po`.`po_amendment_req_approve_by`
`vendor_po`.`po_amendment_req_approve_date`
`vendor_po`.`po_amendment_no`
`vendor_po`.`po_amendment_date`
`vendor_po`.`po_amended_by`
`vendor_po`.`quotation_ref`
`vendor_po`.`quotation_date`
`vendor_po`.`cancelled`
`vendor_po`.`po_cancel_reason`
`vendor_po`.`po_cancel_req_by`
`vendor_po`.`po_cancel_req_date`
`vendor_po`.`po_cancel_req_status`
`vendor_po`.`po_cancelled_by`
`vendor_po`.`po_cancelled_date`
`vendor_po`.`transportation_charge`
`vendor_po`.`internal_comment`
`vendor_po`.`request_cancel_by`
`vendor_po`.`request_cancel_date`
`vendor_po`.`cancel_request_status`
`vendor_po`.`amend_request_cancel_by`
`vendor_po`.`amend_request_cancel_date`
`vendor_po`.`amend_request_status`
`vendor_po`.`transport_wotax`
`vendor_po`.`insurance_wotax`
`vendor_po`.`packing_wotax`
`vendor_po`.`total_parts_count`
`vendor_po`.`total_qty_count`
`vendor_po`.`total_accepted_qty`
`vendor_po`.`total_received_qty`
`vendor_po`.`total_reject_qty`
`vendor_po`.`total_rework_qty`
`vendor_po`.`total_rwk_recv_qty`
`vendor_po`.`total_rework_issue_qty`
`vendor_po`.`total_issued_qty`
`vendor_po_detl`.*
`vendor_po_detl`.`vendor_po_detl_id`
`vendor_po_detl`.`wo_no`
`vendor_po_detl`.`part_id`
`vendor_po_detl`.`unit_price`
`vendor_po_detl`.`unit_of_measure`
`vendor_po_detl`.`discount_prcnt`
`vendor_po_detl`.`total_single_part`
`vendor_po_detl`.`unit_cost_per_part_wdisc`
`vendor_po_detl`.`tax_unit_insurence_price`
`vendor_po_detl`.`tax_unit_transport_price`
`vendor_po_detl`.`tax_unit_packing_price`
`vendor_po_detl`.`unit_insurence_price`
`vendor_po_detl`.`unit_transport_price`
`vendor_po_detl`.`unit_packing_price`
`vendor_po_detl`.`unit_total_price_before_gst`
`vendor_po_detl`.`unit_cost_per_part_adisc_wtax`
`vendor_po_detl`.`hsn_code`
`vendor_po_detl`.`sac_code`
`vendor_po_detl`.`mpn`
`vendor_po_detl`.`vendor`
`vendor_po_detl`.`vendor_id`
`vendor_po_detl`.`vendor_address`
`vendor_po_detl`.`vendor_gst`
`vendor_po_detl`.`vendor_order_qty`
`vendor_po_detl`.`mat_issue_qty`
`vendor_po_detl`.`part_rcpt_qty`
`vendor_po_detl`.`accepted_qty`
`vendor_po_detl`.`rejected_qty`
`vendor_po_detl`.`rework_qty`
`vendor_po_detl`.`rework_issue_qty`
`vendor_po_detl`.`part_issue_qty`
`vendor_po_detl`.`insp_rep_no`
`vendor_po_detl`.`vendor_po_no`
`vendor_po_detl`.`vendor_po_dt`
`vendor_po_detl`.`quotation_ref`
`vendor_po_detl`.`quotation_date`
`vendor_po_detl`.`vendor_trgt_date`
`vendor_po_detl`.`os_planner`
`vendor_po_detl`.`stg_no`
`vendor_po_detl`.`no_of_days`
`vendor_po_detl`.`po_amendment_no`
`vendor_po_detl`.`po_amendment_date`
`vendor_po_detl`.`po_amended_by`
`vendor_po_detl`.`po_validate`
`vendor_po_detl`.`po_validated_by`
`vendor_po_detl`.`po_validated_date`
`vendor_po_detl`.`po_prepared_date`
`vendor_po_detl`.`po_validated_role`
`vendor_po_detl`.`vendor_part_status`
`vendor_po_detl`.`raw_mat_spec`
`vendor_po_detl`.`raw_mat_dimension`
`vendor_po_detl`.`model`
`vendor_po_detl`.`make`
`vendor_po_detl`.`part_alternate_name`
`vendor_po_detl`.`part_note`
`vendor_po_detl`.`part_removed_by`
`vendor_po_detl`.`part_removed_dt`
`vendor_po_detl`.`reqd_total_qty`
`admin_os_planner_detl`.*
`admin_os_planner_detl`.`admin_os_planner_detl_id`
`admin_os_planner_detl`.`name`
`admin_os_planner_detl`.`emp_id`
`admin_os_planner_detl`.`projects`
`admin_os_planner_detl`.`vendors`
`admin_os_planner_detl`.`project_coordinator`
`admin_os_planner_detl`.`cell_no`
`admin_project_details`.*
`admin_project_details`.`admin_proj_detail_id`
`admin_project_details`.`oa_no`
`admin_project_details`.`proj_no`
`admin_project_details`.`org_id`
`admin_project_details`.`proj_name`
`admin_project_details`.`product_category`
`admin_project_details`.`quantity`
`admin_project_details`.`proj_trgt_manf_date`
`admin_project_details`.`proj_trgt_date`
`admin_project_details`.`proj_manager`
`admin_project_details`.`proj_coord`
`admin_project_details`.`purchase_coord`
`admin_project_details`.`estmtd_no_parts`
`admin_project_details`.`proj_start_date`
`admin_project_details`.`proj_end_date`
`admin_project_details`.`proj_budget`
`admin_project_details`.`status_flag`
`admin_project_details`.`design_trgt_date`
`admin_project_details`.`hsn_code`
`admin_project_details`.`status_interval`
`annexure_doc`.*
`annexure_doc`.`row_id`
`annexure_doc`.`oa_no`
`annexure_doc`.`po_no`
`annexure_doc`.`vendor`
`annexure_doc`.`file_name`
`assembly_activities`.*
`assembly_activities`.`row_id`
`assembly_activities`.`project_id`
`assembly_activities`.`activity_name`
`assembly_activities`.`activity_st_dt`
`assembly_activities`.`activity_trgt_dt`
`assembly_activities`.`activity_budget`
`assembly_activities`.`responsibility`
`assembly_activities`.`status`
`assembly_activities`.`remarks`
`assembly_activities`.`entry_by`
`assembly_activities`.`entry_dt`
`assembly_activities`.`modify_by`
`assembly_activities`.`modify_dt`
`assembly_details`.*
`assembly_details`.`assembly_id`
`assembly_details`.`oa_no`
`assembly_details`.`proj_no`
`assembly_details`.`asmbly_drg_no`
`assembly_details`.`sa_name`
`assembly_details`.`sa_drg_no`
`assembly_details`.`sa_per_asmbly`
`assembly_details`.`sa_strt_date`
`assembly_details`.`sa_trgt_date`
`assembly_details`.`sa_actual_start_date`
`assembly_details`.`sa_revised_date`
`assembly_details`.`sa_end_date`
`assembly_details`.`status_flag`
`assembly_details`.`design_eng`
`assembly_details`.`sa_drg_remarks`
`assembly_details`.`sa_drg_last_aremarks_by_date_time`
`assembly_details`.`sa_drg_aprov_by`
`assembly_details`.`sa_remarks`
`assembly_details`.`sa_drg_file`
`assembly_details`.`sa_status`
`assembly_details`.`sa_drg_file_flag`
`assembly_details_remarks`.*
`assembly_details_remarks`.`id_assembly_details_remarks`
`assembly_details_remarks`.`oa_no`
`assembly_details_remarks`.`proj_no`
`assembly_details_remarks`.`asmbly_drg_no`
`assembly_details_remarks`.`sa_drg_no`
`assembly_details_remarks`.`sa_name`
`assembly_details_remarks`.`remarks`
`assembly_details_remarks`.`remarks_date_time`
`assembly_details_remarks`.`role`
`assembly_details_remarks`.`username`
`closed_grn_summary_view`.*
`closed_grn_summary_view`.`part_count`
`closed_grn_summary_view`.`grn_status`
`closed_grn_summary_view`.`oa_no`
`closed_grn_summary_view`.`grn_no`
`closed_grn_summary_view`.`vendor`
`closed_grn_summary_view`.`vendor_po_no`
`dc_summary_details`.*
`dc_summary_details`.`dc_summary_id`
`dc_summary_details`.`dc_no`
`dc_summary_details`.`grn_no`
`dc_summary_details`.`vendor`
`dc_summary_details`.`vendor_po_no`
`dc_summary_details`.`vendor_po_date`
`dc_summary_details`.`dc_created_date`
`dc_summary_details`.`dc_created_by`
`dc_summary_details`.`parts_count`
`dc_summary_details`.`parts_issue_qty`
`dc_summary_details`.`accept_qty`
`dc_summary_details`.`reject_qty`
`dc_summary_details`.`rework_qty`
`dc_summary_details`.`rework_issue_qty`
`dc_summary_details`.`pending_qty`
`dc_summary_details`.`total_cost_without_tax`
`dc_summary_details`.`total_cost_taxable`
`dc_summary_details`.`os_planner`
`dc_summary_details`.`oa_no`
`dc_summary_details`.`last_updated`
`department`.*
`department`.`row_id`
`department`.`department_name`
`dispatch_activities`.*
`dispatch_activities`.`row_id`
`dispatch_activities`.`project_id`
`dispatch_activities`.`activity_name`
`dispatch_activities`.`activity_st_dt`
`dispatch_activities`.`activity_trgt_dt`
`dispatch_activities`.`activity_budget`
`dispatch_activities`.`responsibility`
`dispatch_activities`.`status`
`dispatch_activities`.`remarks`
`dispatch_activities`.`entry_by`
`dispatch_activities`.`entry_dt`
`dispatch_activities`.`modify_by`
`dispatch_activities`.`modify_dt`
`employee_details`.*
`employee_details`.`emp_id`
`employee_details`.`emp_name`
`employee_details`.`emp_profile_name`
`employee_details`.`emp_pwd`
`employee_details`.`emp_role`
`employee_details`.`emp_role_id`
`employee_details`.`org_id`
`employee_details`.`project_coordinator`
`employee_details`.`cell_no`
`employee_details`.`emp_email`
`employee_details`.`emp_active_status`
`employee_details`.`static_ip1`
`employee_details`.`static_ip2`
`employee_details`.`last_modified`
`employee_details`.`otp`
`employee_details`.`otp_time`
`employee_roles`.*
`employee_roles`.`emp_role_id`
`employee_roles`.`role_name`
`employee_roles`.`noneditable_fields`
`grn_summary_details`.*
`grn_summary_details`.`grn_summary_id`
`grn_summary_details`.`grn_no`
`grn_summary_details`.`vendor`
`grn_summary_details`.`vendor_po_no`
`grn_summary_details`.`vendor_po_dt`
`grn_summary_details`.`grn_created_date`
`grn_summary_details`.`grn_created_by`
`grn_summary_details`.`grn_type`
`grn_summary_details`.`grn_status`
`grn_summary_details`.`parts_count`
`grn_summary_details`.`vendor_order_qty`
`grn_summary_details`.`parts_receipt_qty`
`grn_summary_details`.`accept_qty`
`grn_summary_details`.`reject_qty`
`grn_summary_details`.`rework_qty`
`grn_summary_details`.`rework_issue_qty`
`grn_summary_details`.`pending_qty`
`grn_summary_details`.`grn_closed_date`
`grn_summary_details`.`grn_closed_by`
`grn_summary_details`.`total_cost_without_tax`
`grn_summary_details`.`total_cost_taxable`
`grn_summary_details`.`os_planner`
`grn_summary_details`.`oa_no`
`grn_summary_details`.`last_updated`
`inspection_details`.*
`inspection_details`.`inspection_id`
`inspection_details`.`part_id`
`inspection_details`.`vendor`
`inspection_details`.`vendor_po_no`
`inspection_details`.`insp_rep_no`
`inspection_details`.`grn_no`
`inspection_details`.`no_of_stg`
`inspection_details`.`stg_no`
`inspection_details`.`reqd_total_qty`
`inspection_details`.`vendor_order_qty`
`inspection_details`.`part_qty_recvd`
`inspection_details`.`insp_qty_acpt`
`inspection_details`.`insp_qty_rej`
`inspection_details`.`insp_qty_rework`
`inspection_details`.`rework_issue_qty`
`inspection_details`.`remarks`
`inspection_details`.`insp_acpt_name`
`inspection_details`.`insp_person`
`inspection_details`.`insp_date`
`inspection_details`.`acpt_date`
`inspection_details`.`no_of_insp`
`inspection_details`.`flg_short_close`
`inspection_details`.`ir_validate`
`inspection_details`.`accept_with_out_tax`
`inspection_details`.`accept_with_tax`
`inspection_details`.`storage_location`
`inspection_summary_details`.*
`inspection_summary_details`.`inspection_summary_id`
`inspection_summary_details`.`vendor`
`inspection_summary_details`.`vendor_po_no`
`inspection_summary_details`.`vendor_po_date`
`inspection_summary_details`.`grn_no`
`inspection_summary_details`.`parts_count`
`inspection_summary_details`.`parts_receipt_qty`
`inspection_summary_details`.`rework_rcpt_qty`
`inspection_summary_details`.`accept_qty`
`inspection_summary_details`.`reject_qty`
`inspection_summary_details`.`rework_qty`
`inspection_summary_details`.`rework_issue_qty`
`inspection_summary_details`.`pending_qty`
`inspection_summary_details`.`os_planner`
`inspection_summary_details`.`oa_no`
`inspection_summary_details`.`inspected_by`
`inspection_summary_details`.`inspected_date`
`inspection_summary_details`.`accepted_cost_without_tax`
`inspection_summary_details`.`accepted_cost_with_tax`
`inspection_summary_details`.`last_updated`
`mapusermodule`.*
`mapusermodule`.`maping_id`
`mapusermodule`.`module`
`mapusermodule`.`rolename`
`mapusermodule`.`moduleaction`
`mat_rcpt_detl`.*
`mat_rcpt_detl`.`id`
`mat_rcpt_detl`.`part_id`
`mat_rcpt_detl`.`raw_mat_spec`
`mat_rcpt_detl`.`mat_req_qty`
`mat_rcpt_detl`.`raw_mat_dimension`
`mat_rcpt_detl`.`mat_pr_no`
`mat_rcpt_detl`.`mat_pr_dt`
`mat_rcpt_detl`.`mat_recd_qty`
`mat_rcpt_detl`.`mat_recvd_date`
`mat_rcpt_detl`.`mat_po_no`
`mat_rcpt_detl`.`os_planner`
`mat_rcpt_detl`.`emp_id`
`mat_req_detl`.*
`mat_req_detl`.`id`
`mat_req_detl`.`part_id`
`mat_req_detl`.`raw_mat_spec`
`mat_req_detl`.`mat_req_qty`
`mat_req_detl`.`mat_recd_qty`
`mat_req_detl`.`raw_mat_dimension`
`mat_req_detl`.`mat_pr_no`
`mat_req_detl`.`mat_pr_dt`
`mat_req_detl`.`request_status`
`mat_req_detl`.`mat_rcpt_trgt_dt`
`mat_req_detl`.`os_planner`
`mat_req_detl`.`emp_id`
`mat_req_detl`.`ir_validate`
`mat_req_detl`.`remarks`
`mat_req_detl`.`ir_validated_by`
`mat_req_detl`.`ir_validation_date`
`mat_req_detl`.`remarks_g`
`mat_req_detl`.`store_keeper`
`mat_req_detl`.`stock_update_date`
`mat_req_detl`.`received_by`
`mat_req_detl`.`approved_by`
`mat_req_stock`.*
`mat_req_stock`.`id`
`mat_req_stock`.`part_id`
`mat_req_stock`.`mat_req_qty`
`mat_req_stock`.`mat_pr_no`
`mat_req_stock`.`ava_stock_qty`
`mat_req_stock`.`pro_add_qty`
`mat_req_stock`.`shelf_days`
`mat_req_stock`.`remarks_stock`
`material_issue_detl`.*
`material_issue_detl`.`material_issue_detl_id`
`material_issue_detl`.`part_id`
`material_issue_detl`.`os_planner`
`material_issue_detl`.`emp_id`
`material_issue_detl`.`vendor`
`material_issue_detl`.`vendor_po_no`
`material_issue_detl`.`raw_mat_spec`
`material_issue_detl`.`raw_mat_dimension`
`material_issue_detl`.`mat_req_qty`
`material_issue_detl`.`mat_recd_qty`
`material_issue_detl`.`vendor_po_qty`
`material_issue_detl`.`mat_issue_qty`
`material_issue_detl`.`mat_issue_dt`
`material_issue_detl`.`dc_no`
`material_issue_detl`.`dc_type`
`message`.*
`message`.`message_id`
`message`.`part_id`
`message`.`org_id`
`message`.`message`
`message`.`msg_by`
`message`.`msg_to`
`message`.`msg_on`
`message`.`msg_type`
`message`.`msg_read`
`message`.`msg_vendor`
`org_settings`.*
`org_settings`.`org_id`
`org_settings`.`org_full_name`
`org_settings`.`org_short_name`
`org_settings`.`org_address_line_1`
`org_settings`.`org_address_line_2`
`org_settings`.`org_division_unit`
`org_settings`.`org_ph_no_1`
`org_settings`.`org_ph_no_2`
`org_settings`.`org_email`
`org_settings`.`org_website`
`org_settings`.`org_logo_path`
`org_settings`.`org_certification_logo_path`
`org_settings`.`org_iso_certified_title`
`org_settings`.`org_gstin_no`
`org_settings`.`org_pan_no`
`org_settings`.`org_excise_no`
`org_settings`.`org_services`
`org_settings`.`org_products`
`org_settings`.`org_misc_details`
`org_settings`.`org_currency_full`
`org_settings`.`org_currency_symbol`
`org_settings`.`org_currecny_short`
`org_settings`.`org_date_format`
`org_settings`.`org_estd_date`
`org_settings`.`org_active_status`
`org_settings`.`org_bucket`
`org_settings`.`hsn_code`
`org_settings`.`sac_code`
`parameter`.*
`parameter`.`id_param`
`parameter`.`org_id`
`parameter`.`parameter`
`parameter_translations`.*
`parameter_translations`.`id_translations`
`parameter_translations`.`lang_iso_code`
`parameter_translations`.`id_param`
`parameter_translations`.`custom_parameter`
`parameter_translations`.`org_id`
`parameter_translations`.`param_help`
`part_issue_details`.*
`part_issue_details`.`id`
`part_issue_details`.`part_id`
`part_issue_details`.`os_planner`
`part_issue_details`.`trgt_date`
`part_issue_details`.`vendor`
`part_issue_details`.`vendor_po_no`
`part_issue_details`.`grn_no`
`part_issue_details`.`dc_no`
`part_issue_details`.`dc_type`
`part_issue_details`.`no_of_stages`
`part_issue_details`.`stg_no`
`part_issue_details`.`reqd_total_qty`
`part_issue_details`.`vendor_order_qty`
`part_issue_details`.`part_rcpt_qty`
`part_issue_details`.`part_issue_qty`
`part_issue_details`.`part_issue_date`
`part_issue_details`.`part_issue_by`
`part_issue_details`.`vehicle_no`
`part_issue_details`.`mode_of_dispatch`
`part_issue_details`.`approximate_value`
`part_issue_details`.`e_sugam_no`
`part_issue_details`.`e_way_bill_no`
`part_issue_details`.`notes`
`part_issue_details`.`insp_rep_no`
`part_issue_details`.`dc_value_with_out_tax`
`part_issue_details`.`dc_value_with_tax`
`part_rcpt_detl`.*
`part_rcpt_detl`.`part_recpt_id`
`part_rcpt_detl`.`part_id`
`part_rcpt_detl`.`os_planner`
`part_rcpt_detl`.`trgt_dt`
`part_rcpt_detl`.`vendor`
`part_rcpt_detl`.`vendor_po_no`
`part_rcpt_detl`.`no_of_stages`
`part_rcpt_detl`.`stg_no`
`part_rcpt_detl`.`reqd_total_qty`
`part_rcpt_detl`.`vendor_order_qty`
`part_rcpt_detl`.`part_rcpt_qty`
`part_rcpt_detl`.`part_rcpt_dt`
`part_rcpt_detl`.`grn_no`
`part_rcpt_detl`.`grn_dt`
`part_rcpt_detl`.`grn_created_by`
`part_rcpt_detl`.`grn_status`
`part_rcpt_detl`.`grn_type`
`part_rcpt_detl`.`rework_rcpt_qty`
`part_rcpt_detl`.`inward_invoice_no`
`part_rcpt_detl`.`inward_invoice_dt`
`part_rcpt_detl`.`inward_dc_no`
`part_rcpt_detl`.`inward_dc_dt`
`part_rcpt_detl`.`grn_closed_by`
`part_rcpt_detl`.`grn_notes`
`part_rcpt_detl`.`e_way_bill_no`
`part_rcpt_detl`.`part_rcpt_updated_by`
`part_rcpt_detl`.`part_rcpt_updated_dt`
`part_rcpt_detl`.`grn_value_adisc_before_gst`
`part_rcpt_detl`.`grn_value_adisc_with_gst`
`part_rcpt_detl`.`grn_cancel_reason`
`part_rcpt_detl`.`grn_cancel_req_by`
`part_rcpt_detl`.`grn_cancel_req_date`
`part_rcpt_detl`.`grn_cancel_req_status`
`part_rcpt_detl`.`grn_cancelled_by`
`part_rcpt_detl`.`grn_cancelled_date`
`part_rcpt_detl`.`request_cancel_by`
`part_rcpt_detl`.`request_cancel_date`
`part_rcpt_detl`.`cancel_request_status`
`pending_grn_summary_view`.*
`pending_grn_summary_view`.`part_count`
`pending_grn_summary_view`.`grn_status`
`pending_grn_summary_view`.`oa_no`
`pending_grn_summary_view`.`vendor`
`pending_grn_summary_view`.`vendor_po_no`
`pending_grn_summary_view`.`grn_no`
`po_cost_table`.*
`po_cost_table`.`id`
`po_cost_table`.`vendor`
`po_cost_table`.`oa_no`
`po_cost_table`.`vendor_po_no`
`po_cost_table`.`vendor_po_dt`
`po_cost_table`.`total_cost`
`po_cost_table`.`acpt_date`
`po_cost_table`.`payment_days`
`proj_detl`.*
`proj_detl`.`part_id`
`proj_detl`.`oa_no`
`proj_detl`.`proj_no`
`proj_detl`.`product_category`
`proj_detl`.`sa_name`
`proj_detl`.`assy_drg_no`
`proj_detl`.`sa_drg_no`
`proj_detl`.`sa_per_assy`
`proj_detl`.`part_name`
`proj_detl`.`part_drg_no`
`proj_detl`.`batch_no`
`proj_detl`.`parts_per_assy`
`proj_detl`.`vendor_order_qty`
`proj_detl`.`actual_qty`
`proj_detl`.`reqd_total_qty`
`proj_detl`.`mat_req_qty`
`proj_detl`.`mat_recd_qty`
`proj_detl`.`mat_issue_qty`
`proj_detl`.`part_rcpt_qty`
`proj_detl`.`accepted_qty`
`proj_detl`.`rejected_qty`
`proj_detl`.`rework_qty`
`proj_detl`.`rework_issue_qty`
`proj_detl`.`part_issue_qty`
`proj_detl`.`trgt_date`
`proj_detl`.`class_of_parts`
`proj_detl`.`status`
`proj_detl`.`os_planner`
`proj_detl`.`date_drg_issue`
`proj_detl`.`raw_mat_spec`
`proj_detl`.`raw_mat_dimension`
`proj_detl`.`rev_del_dt`
`proj_detl`.`remarks`
`proj_detl`.`proj_remarks_by_date_time`
`proj_detl`.`bom_qty`
`proj_detl`.`part_acpt_date`
`proj_detl`.`part_issue_assly_date`
`proj_detl`.`part_issue_assly_qty`
`proj_detl`.`return_accept_qty`
`proj_detl`.`no_of_stages`
`proj_detl`.`status_flag`
`proj_detl`.`start_dt`
`proj_detl`.`end_dt`
`proj_detl`.`pending_assly_issue_qty`
`proj_detl`.`bom_upload_date`
`proj_detl`.`design_eng`
`proj_detl`.`part_drg_remarks`
`proj_detl`.`part_drg_aprov_by`
`proj_detl`.`drg_release_dt`
`proj_detl`.`type`
`proj_detl`.`final_insp_dt`
`proj_detl`.`no_of_insp`
`proj_detl`.`mr_na`
`proj_detl`.`part_drg_release_by`
`proj_detl`.`hsn_code`
`proj_detl`.`sac_code`
`proj_detl`.`revision`
`proj_detl`.`uom`
`proj_detl`.`model`
`proj_detl`.`make`
`proj_detl`.`website`
`proj_detl`.`alternate_allow`
`proj_detl`.`week_lead_time`
`proj_detl`.`part_drg_file`
`proj_detl`.`part_drg_file_flag`
`proj_detl`.`sa_drg_file`
`proj_detl`.`sa_drg_file_flag`
`proj_detl`.`qc_require`
`proj_detl`.`inventory_id`
`proj_detl`.`drawing_updated_by`
`proj_detl`.`drawing_updated_date`
`proj_detl`.`drg_update_status`
`proj_detl_temp`.*
`proj_detl_temp`.`proj_detl_id`
`proj_detl_temp`.`oa_no`
`proj_detl_temp`.`proj_no`
`proj_detl_temp`.`sa_name`
`proj_detl_temp`.`assy_drg_no`
`proj_detl_temp`.`sa_drg_no`
`proj_detl_temp`.`sa_drg_revision`
`proj_detl_temp`.`sa_per_assy`
`proj_detl_temp`.`part_name`
`proj_detl_temp`.`part_drg_no`
`proj_detl_temp`.`batch_no`
`proj_detl_temp`.`parts_per_assy`
`proj_detl_temp`.`reqd_total_qty`
`proj_detl_temp`.`bom_qty`
`proj_detl_temp`.`stages`
`proj_detl_temp`.`trgt_date`
`proj_detl_temp`.`class_of_parts`
`proj_detl_temp`.`raw_mat_spec`
`proj_detl_temp`.`raw_mat_dimension`
`proj_detl_temp`.`bom_upload_date`
`proj_detl_temp`.`design_eng`
`proj_detl_temp`.`part_drg_remarks`
`proj_detl_temp`.`part_drg_release_by`
`proj_detl_temp`.`drg_release_dt`
`proj_detl_temp`.`type`
`proj_detl_temp`.`revision`
`proj_detl_temp`.`revision_date`
`proj_detl_temp`.`make`
`proj_detl_temp`.`model`
`proj_detl_temp`.`uom`
`proj_detl_temp`.`website`
`proj_detl_temp`.`hsn_code`
`proj_detl_temp`.`sac_code`
`proj_detl_temp`.`alternate_allow`
`proj_detl_temp`.`week_lead_time`
`proj_detl_temp`.`last_modified_date`
`proj_detl_temp`.`last_modified_by`
`proj_detl_temp`.`part_drg_file`
`proj_detl_temp`.`part_drg_file_flag`
`proj_detl_temp`.`sa_drg_file`
`proj_detl_temp`.`sa_drg_file_flag`
`proj_detl_temp`.`remarks`
`proj_detl_temp`.`status_flag`
`project_planner`.*
`project_planner`.`row_id`
`project_planner`.`project_id`
`project_planner`.`department_id`
`project_planner`.`activity_name`
`project_planner`.`activity_st_dt`
`project_planner`.`activity_trgt_dt`
`project_planner`.`activity_budget`
`project_planner`.`entry_by`
`project_planner`.`entry_dt`
`project_planner`.`modify_by`
`project_planner`.`modify_dt`
`project_summary_view`.*
`project_summary_view`.`oa_no`
`project_summary_view`.`proj_name`
`project_summary_view`.`proj_trgt_date`
`project_summary_view`.`status`
`project_summary_view`.`project_cost`
`project_summary_view`.`proj_budget`
`return_issue_details`.*
`return_issue_details`.`id`
`return_issue_details`.`part_id`
`return_issue_details`.`oa_no`
`return_issue_details`.`sa_name`
`return_issue_details`.`sa_drg_no`
`return_issue_details`.`part_name`
`return_issue_details`.`part_drg_no`
`return_issue_details`.`riv_no`
`return_issue_details`.`reqd_total_qty`
`return_issue_details`.`piv_no`
`return_issue_details`.`return_issue_qty`
`return_issue_details`.`return_accept_qty`
`return_issue_details`.`return_reject_qty`
`return_issue_details`.`return_rework_qty`
`return_issue_details`.`return_issue_to`
`return_issue_details`.`return_issued_by`
`return_issue_details`.`return_issue_date`
`return_issue_details`.`class_of_parts`
`return_issue_details`.`remarks`
`t_activities_mst`.*
`t_activities_mst`.`row_id`
`t_activities_mst`.`project_id`
`t_activities_mst`.`department_id`
`t_activities_mst`.`activity_name`
`t_activities_mst`.`activity_st_dt`
`t_activities_mst`.`activity_trgt_dt`
`t_activities_mst`.`actual_st_dt`
`t_activities_mst`.`actual_trgt_dt`
`t_activities_mst`.`activity_budget`
`t_activities_mst`.`responsibility`
`t_activities_mst`.`status`
`t_activities_mst`.`remarks`
`t_activities_mst`.`entry_by`
`t_activities_mst`.`entry_dt`
`t_activities_mst`.`modify_by`
`t_activities_mst`.`modify_dt`
`t_additional_charges_mst`.*
`t_additional_charges_mst`.`row_id`
`t_additional_charges_mst`.`additional_charge_type`
`t_class_of_parts_mst`.*
`t_class_of_parts_mst`.`row_id`
`t_class_of_parts_mst`.`class_of_part`
`t_control_mst`.*
`t_control_mst`.`row_id`
`t_control_mst`.`record_type`
`t_control_mst`.`record_value`
`t_currency_mst`.*
`t_currency_mst`.`row_id`
`t_currency_mst`.`currency`
`t_currency_mst`.`sub_text`
`t_currency_mst`.`decimal_words`
`t_currency_mst`.`symbol`
`t_currency_mst`.`default`
`t_documents_mst`.*
`t_documents_mst`.`row_id`
`t_documents_mst`.`wo_no`
`t_documents_mst`.`document_title`
`t_documents_mst`.`document_file`
`t_drawing_format_mst`.*
`t_drawing_format_mst`.`row_id`
`t_drawing_format_mst`.`doc_type`
`t_drawing_format_mst`.`pos1`
`t_drawing_format_mst`.`pos2`
`t_drawing_format_mst`.`pos3`
`t_drawing_format_mst`.`pos4`
`t_drawing_format_mst`.`pos5`
`t_drawing_format_mst`.`pos6`
`t_drawing_format_mst`.`pos7`
`t_drawing_format_mst`.`pos8`
`t_drawing_format_mst`.`pos9`
`t_drawing_format_mst`.`version_prefix`
`t_drawing_format_mst`.`separator`
`t_editable_fields_mst`.*
`t_editable_fields_mst`.`row_id`
`t_editable_fields_mst`.`editable_fields`
`t_editable_fields_mst`.`column_name`
`t_format_mst`.*
`t_format_mst`.`row_id`
`t_format_mst`.`doc_type`
`t_format_mst`.`pos1`
`t_format_mst`.`pos2`
`t_format_mst`.`pos3`
`t_format_mst`.`pos4`
`t_format_mst`.`pos5`
`t_format_mst`.`prefix`
`t_format_mst`.`separator`
`t_format_mst`.`year`
`t_format_mst`.`sl_no_length`
`t_format_mst`.`year_separator`
`t_inventory_mst`.*
`t_inventory_mst`.`Inventory_id`
`t_inventory_mst`.`part_name`
`t_inventory_mst`.`part_drg_no`
`t_inventory_mst`.`batch_no`
`t_inventory_mst`.`vendor_order_qty`
`t_inventory_mst`.`actual_qty`
`t_inventory_mst`.`reqd_total_qty`
`t_inventory_mst`.`mat_req_qty`
`t_inventory_mst`.`mat_recd_qty`
`t_inventory_mst`.`part_rcpt_qty`
`t_inventory_mst`.`accepted_qty`
`t_inventory_mst`.`rejected_qty`
`t_inventory_mst`.`rework_qty`
`t_inventory_mst`.`rework_issue_qty`
`t_inventory_mst`.`part_issue_qty`
`t_inventory_mst`.`trgt_date`
`t_inventory_mst`.`class_of_parts`
`t_inventory_mst`.`status`
`t_inventory_mst`.`raw_mat_spec`
`t_inventory_mst`.`raw_mat_dimension`
`t_inventory_mst`.`remarks`
`t_inventory_mst`.`stock_remarks_by_date_time`
`t_inventory_mst`.`bom_qty`
`t_inventory_mst`.`no_of_stages`
`t_inventory_mst`.`status_flag`
`t_inventory_mst`.`pending_assly_issue_qty`
`t_inventory_mst`.`type`
`t_inventory_mst`.`mr_na`
`t_inventory_mst`.`hsn_code`
`t_inventory_mst`.`sac_code`
`t_inventory_mst`.`uom`
`t_inventory_mst`.`model`
`t_inventory_mst`.`make`
`t_inventory_mst`.`website`
`t_inventory_mst`.`STOCK_AVAILABILITY_ALWAYS_ONDEMAND`
`t_inventory_mst`.`SAFTEY_STOCK_LEVEL`
`t_inventory_mst`.`NUMBER_OF_UNITS_IN_THE_BATCH`
`t_inventory_mst`.`PART_SPACE_CONSTRAINT`
`t_inventory_mst`.`MINIMUM_ORDER_QUANTITY`
`t_inventory_mst`.`SHELF_LIFE`
`t_inventory_mst`.`PART_AVAILABILITY_TO_UPCOMING_PROJECT_SCHEDULE`
`t_inventory_mst`.`PART_OR_PRODUCT`
`t_inventory_mst`.`PART_ACCESS_RESTRICTED`
`t_inventory_mst`.`inventory_update_by`
`t_inventory_mst`.`inventory_update_date`
`t_iso_doc_no_mst`.*
`t_iso_doc_no_mst`.`row_id`
`t_iso_doc_no_mst`.`doc_type`
`t_iso_doc_no_mst`.`doc_no`
`t_iso_doc_no_mst`.`doc_date`
`t_iso_doc_no_mst`.`doc_description`
`t_label_mst`.*
`t_label_mst`.`row_id`
`t_label_mst`.`page_id`
`t_label_mst`.`page_label`
`t_module_mst`.*
`t_module_mst`.`row_id`
`t_module_mst`.`module_id`
`t_module_mst`.`module_name`
`t_module_mst`.`module_icon`
`t_module_mst`.`entry_by`
`t_module_mst`.`entry_dt`
`t_module_mst`.`modify_by`
`t_module_mst`.`modify_dt`
`t_option_mst`.*
`t_option_mst`.`row_id`
`t_option_mst`.`module_id`
`t_option_mst`.`option_id`
`t_option_mst`.`option_name`
`t_option_mst`.`option_controller`
`t_option_mst`.`entry_by`
`t_option_mst`.`entry_dt`
`t_option_mst`.`entry_tm`
`t_option_mst`.`modify_by`
`t_option_mst`.`modify_dt`
`t_option_mst`.`modify_tm`
`t_option_mst`.`option_remarks`
`t_page_mst`.*
`t_page_mst`.`row_id`
`t_page_mst`.`page_name`
`t_page_mst`.`page_description`
`t_part_docs_mst`.*
`t_part_docs_mst`.`row_id`
`t_part_docs_mst`.`wo_no`
`t_part_docs_mst`.`sa_name`
`t_part_docs_mst`.`sa_drg_no`
`t_part_docs_mst`.`part_id`
`t_part_docs_mst`.`doc_type`
`t_part_docs_mst`.`doc_file`
`t_part_type_mst`.*
`t_part_type_mst`.`row_id`
`t_part_type_mst`.`part_type`
`t_parts_status`.*
`t_parts_status`.`row_id`
`t_parts_status`.`wo_no`
`t_parts_status`.`sa_name`
`t_parts_status`.`part_name`
`t_parts_status`.`part_id`
`t_parts_status`.`stage_no`
`t_parts_status`.`stage_weightage`
`t_parts_status`.`part_approve`
`t_parts_status`.`mat_req`
`t_parts_status`.`mat_recpt`
`t_parts_status`.`vendor_po`
`t_parts_status`.`mat_issue`
`t_parts_status`.`mfg`
`t_parts_status`.`part_recpt`
`t_parts_status`.`part_issue`
`t_parts_status`.`reject`
`t_parts_status`.`rework`
`t_parts_status`.`accept`
`t_parts_status`.`assembly`
`t_parts_status`.`raw_mat_na`
`t_parts_status`.`mr_na`
`t_parts_status`.`multi_stage`
`t_parts_status`.`total_qty`
`t_parts_status`.`status`
`t_planned_status_trn`.*
`t_planned_status_trn`.`row_id`
`t_planned_status_trn`.`project_id`
`t_planned_status_trn`.`interval_dt`
`t_planned_status_trn`.`planned_status`
`t_planned_status_trn`.`actual_status`
`t_po_param_mst`.*
`t_po_param_mst`.`row_id`
`t_po_param_mst`.`parameter_name`
`t_po_param_mst`.`parameter_field`
`t_po_param_mst`.`parameter_type`
`t_po_param_mst`.`parameter_field_type`
`t_po_param_pripority_mst`.*
`t_po_param_pripority_mst`.`row_id`
`t_po_param_pripority_mst`.`parameter_id`
`t_po_param_pripority_mst`.`parameter_priority`
`t_po_param_val_mapping_mst`.*
`t_po_param_val_mapping_mst`.`row_id`
`t_po_param_val_mapping_mst`.`user_name`
`t_po_param_val_mapping_mst`.`parameter_id`
`t_po_param_val_mapping_mst`.`parameter_value1`
`t_po_param_val_mapping_mst`.`parameter_value2`
`t_po_param_val_mapping_mst`.`access`
`t_po_param_values_mst`.*
`t_po_param_values_mst`.`row_id`
`t_po_param_values_mst`.`parameter_id`
`t_po_param_values_mst`.`parameter_value1`
`t_po_param_values_mst`.`parameter_value2`
`t_product_category_mst`.*
`t_product_category_mst`.`row_id`
`t_product_category_mst`.`product_category`
`t_qcrequire_mst`.*
`t_qcrequire_mst`.`row_id`
`t_qcrequire_mst`.`type`
`t_qcrequire_mst`.`A`
`t_qcrequire_mst`.`B`
`t_qcrequire_mst`.`C`
`t_rawmatspec_mst`.*
`t_rawmatspec_mst`.`row_id`
`t_rawmatspec_mst`.`rawmat_spec`
`t_services_mst`.*
`t_services_mst`.`row_id`
`t_services_mst`.`service_name`
`t_status_weightage`.*
`t_status_weightage`.`row_id`
`t_status_weightage`.`activity_name`
`t_status_weightage`.`status_percent`
`t_status_weightage`.`activity_weightage`
`t_status_weightage`.`column_name`
`t_subactivities_mst`.*
`t_subactivities_mst`.`row_id`
`t_subactivities_mst`.`project_id`
`t_subactivities_mst`.`activity_id`
`t_subactivities_mst`.`subactivity_name`
`t_subactivities_mst`.`subactivity_st_dt`
`t_subactivities_mst`.`subactivity_trgt_dt`
`t_subactivities_mst`.`actual_st_dt`
`t_subactivities_mst`.`actual_trgt_dt`
`t_subactivities_mst`.`subactivity_budget`
`t_subactivities_mst`.`responsibility`
`t_subactivities_mst`.`status`
`t_subactivities_mst`.`remarks`
`t_subactivities_mst`.`entry_by`
`t_subactivities_mst`.`entry_dt`
`t_subactivities_mst`.`modify_by`
`t_subactivities_mst`.`modify_dt`
`t_tax_mst`.*
`t_tax_mst`.`row_id`
`t_tax_mst`.`tax_slab`
`t_terms_mst`.*
`t_terms_mst`.`row_id`
`t_terms_mst`.`terms_type`
`t_terms_mst`.`terms_description`
`t_transaction_edit_mst`.*
`t_transaction_edit_mst`.`row_id`
`t_transaction_edit_mst`.`user_name`
`t_transaction_edit_mst`.`mrn`
`t_transaction_edit_mst`.`grn`
`t_transaction_edit_mst`.`inspection`
`t_transaction_edit_mst`.`issue`
`t_transaction_edit_mst`.`dispatch`
`t_transfer_param_mst`.*
`t_transfer_param_mst`.`row_id`
`t_transfer_param_mst`.`parameter_name`
`t_transfer_param_mst`.`parameter_field`
`t_transfer_param_mst`.`parameter_type`
`t_transfer_param_mst`.`parameter_field_type`
`t_transfer_param_pripority_mst`.*
`t_transfer_param_pripority_mst`.`row_id`
`t_transfer_param_pripority_mst`.`parameter_id`
`t_transfer_param_pripority_mst`.`parameter_priority`
`t_transfer_param_val_mapping_mst`.*
`t_transfer_param_val_mapping_mst`.`row_id`
`t_transfer_param_val_mapping_mst`.`user_name`
`t_transfer_param_val_mapping_mst`.`parameter_id`
`t_transfer_param_val_mapping_mst`.`parameter_value1`
`t_transfer_param_val_mapping_mst`.`parameter_value2`
`t_transfer_param_val_mapping_mst`.`access`
`t_transfer_param_values_mst`.*
`t_transfer_param_values_mst`.`row_id`
`t_transfer_param_values_mst`.`parameter_id`
`t_transfer_param_values_mst`.`parameter_value1`
`t_transfer_param_values_mst`.`parameter_value2`
`t_uom_mst`.*
`t_uom_mst`.`row_id`
`t_uom_mst`.`uom_name`
`t_user_modules_mst`.*
`t_user_modules_mst`.`row_id`
`t_user_modules_mst`.`emp_id`
`t_user_modules_mst`.`option_id`
`t_user_modules_mst`.`entry_by`
`t_user_modules_mst`.`entry_dt`
`t_user_modules_mst`.`entry_tm`
`t_user_modules_mst`.`entry_ip`
`t_user_modules_mst`.`entry_lat`
`t_user_modules_mst`.`entry_log`
`t_user_modules_mst`.`modify_by`
`t_user_modules_mst`.`modify_dt`
`t_user_modules_mst`.`modify_tm`
`t_user_modules_mst`.`modify_ip`
`t_user_modules_mst`.`modify_lat`
`t_user_modules_mst`.`modify_log`
`tbldispatchcomponent`.*
`tbldispatchcomponent`.`id`
`tbldispatchcomponent`.`part_id`
`tbldispatchcomponent`.`oa_no`
`tbldispatchcomponent`.`sa_name`
`tbldispatchcomponent`.`sa_drg_no`
`tbldispatchcomponent`.`part_name`
`tbldispatchcomponent`.`part_drg_no`
`tbldispatchcomponent`.`insp_rep_no`
`tbldispatchcomponent`.`reqd_total_qty`
`tbldispatchcomponent`.`piv_no`
`tbldispatchcomponent`.`Issue_qty`
`tbldispatchcomponent`.`issue_to`
`tbldispatchcomponent`.`issued_by`
`tbldispatchcomponent`.`issue_date`
`tbldispatchcomponent`.`class_of_parts`
`tbldispatchcomponent`.`remarks`
`tbldispatchcomponent`.`return_accept_qty`
`tbldispatchcomponent`.`return_issue_qty`
`tblpendcnt`.*
`tblpendcnt`.`id`
`tblpendcnt`.`part_id`
`tblpendcnt`.`oa_no`
`tblpendcnt`.`os_planner`
`tblpendcnt`.`no_of_stages`
`tblpendcnt`.`total_qty`
`tblpendcnt`.`completed_qty`
`tblpendcnt`.`pending_qty`
`tblpendcnt`.`req_qty`
`tblpendcnt`.`rcpt_qty`
`tblpendcnt`.`po_qty`
`tblpendcnt`.`issue_qty`
`tblpendcnt`.`mr_na`
`tblpendcnt`.`part_rcpt_qty`
`tblpendcnt`.`part_issue_qty`
`tblpendcnt`.`dispatch_qty`
`tblpendcnt`.`status`
`tblpendcnt`.`po_qty_firststg`
`tblpurparts`.*
`tblpurparts`.`pur_parts_id`
`tblpurparts`.`oa_no`
`tblpurparts`.`proj_no`
`tblpurparts`.`assy_drg_no`
`tblpurparts`.`sa_name`
`tblpurparts`.`sa_drg_no`
`tblpurparts`.`sa_per_assy`
`tblpurparts`.`part_name`
`tblpurparts`.`part_drg_no`
`tblpurparts`.`parts_per_assy`
`tblpurparts`.`reqd_total_qty`
`tblpurparts`.`class_of_parts`
`tblpurparts`.`raw_mat_spec`
`tblpurparts`.`raw_mat_dimension`
`tblpurparts`.`bom_upload_date`
`tblpurparts`.`design_eng`
`tblpurparts`.`part_drg_remarks`
`tblpurparts`.`part_drg_aprov_by`
`temp_detl_view`.*
`temp_detl_view`.`part_id`
`temp_detl_view`.`oa_no`
`temp_detl_view`.`proj_no`
`temp_detl_view`.`sa_name`
`temp_detl_view`.`assy_drg_no`
`temp_detl_view`.`sa_drg_no`
`temp_detl_view`.`sa_per_assy`
`temp_detl_view`.`part_name`
`temp_detl_view`.`part_drg_no`
`temp_detl_view`.`status`
`temp_detl_view`.`start_dt`
`temp_detl_view`.`date_drg_issue`
`temp_detl_view`.`trgt_date`
`temp_detl_view`.`parts_per_assy`
`temp_detl_view`.`reqd_total_qty`
`temp_detl_view`.`class_of_parts`
`temp_detl_view`.`os_planner`
`temp_detl_view`.`no_of_stages`
`temp_detl_view`.`mat_pr_no`
`temp_detl_view`.`mat_pr_dt`
`temp_detl_view`.`mat_req_qty`
`temp_detl_view`.`mat_recd_qty`
`temp_detl_view`.`mat_recvd_date`
`temp_detl_view`.`raw_mat_spec`
`temp_detl_view`.`raw_mat_dimension`
`temp_detl_view`.`remarks`
`temp_detl_view`.`vendor`
`temp_detl_view`.`vendor_po_no`
`temp_detl_view`.`vendor_po_dt`
`temp_detl_view`.`vendor_order_qty`
`temp_detl_view`.`vendor_trgt_date`
`temp_detl_view`.`no_of_days`
`temp_detl_view`.`stg_no`
`temp_detl_view`.`insp_rep_no`
`temp_detl_view`.`mat_issue_qty`
`temp_detl_view`.`mat_issue_dt`
`temp_detl_view`.`dc_no`
`temp_detl_view`.`part_rcpt_qty`
`temp_detl_view`.`part_rcpt_dt`
`temp_detl_view`.`insp_qty_acpt`
`temp_detl_view`.`insp_qty_rework`
`temp_detl_view`.`insp_qty_rej`
`temp_detl_view`.`insp_date`
`temp_detl_view`.`assmbly_issue_qty`
`temp_detl_view`.`disp_issue_date`
`temp_detl_view`.`design_eng`
`temp_detl_view`.`part_drg_aprov_by`
`temp_detl_view`.`end_dt`
`temp_detl_view`.`bom_upload_date`
`temp_detl_view`.`ir_validate`
`temp_detl_view`.`po_validate`
`transfer_request_detl`.*
`transfer_request_detl`.`transfer_id`
`transfer_request_detl`.`from_part_id`
`transfer_request_detl`.`to_part_id`
`transfer_request_detl`.`from_oa`
`transfer_request_detl`.`to_oa`
`transfer_request_detl`.`from_sa_name`
`transfer_request_detl`.`to_sa_name`
`transfer_request_detl`.`transfer_qty`
`transfer_request_detl`.`part_transfer_req_reason`
`transfer_request_detl`.`part_transfer_req_by`
`transfer_request_detl`.`part_transfer_req_date`
`transfer_request_detl`.`part_transfer_req_status`
`transfer_request_detl`.`part_transfer_req_approve_by`
`transfer_request_detl`.`part_transfer_req_approve_date`
`transfer_request_detl`.`part_transfer_no`
`transfer_request_detl`.`part_transfer_date`
`transfer_request_detl`.`part_transfer_by`
`transfer_request_detl`.`tv_no`
`user_audit_trails`.*
`user_audit_trails`.`id`
`user_audit_trails`.`user_id`
`user_audit_trails`.`user_name`
`user_audit_trails`.`event`
`user_audit_trails`.`table_name`
`user_audit_trails`.`old_values`
`user_audit_trails`.`new_values`
`user_audit_trails`.`url`
`user_audit_trails`.`name`
`user_audit_trails`.`ip_address`
`user_audit_trails`.`user_agent`
`user_audit_trails`.`created_at`
`vendor_details`.*
`vendor_details`.`vendor_detail_id`
`vendor_details`.`vendor_id`
`vendor_details`.`org_id`
`vendor_details`.`name`
`vendor_details`.`address`
`vendor_details`.`country`
`vendor_details`.`country_code`
`vendor_details`.`phone_no`
`vendor_details`.`mobile_no`
`vendor_details`.`email`
`vendor_details`.`website`
`vendor_details`.`products`
`vendor_details`.`services`
`vendor_details`.`contact_person`
`vendor_details`.`iso_9001_certified`
`vendor_details`.`vat_reg_no`
`vendor_details`.`service_tax`
`vendor_details`.`pan_no`
`vendor_details`.`tan_no`
`vendor_details`.`exercise_reg_no`
`vendor_details`.`job_approved_type`
`vendor_details`.`vendor_reg_no`
`vendor_details`.`os_planner`
`vendor_details`.`gst_no`
`vendor_details`.`vendor_active_status`
`vendor_details`.`comp_reg_type`
`vendor_details`.`gst_reg_type`
`vendor_po`.*
`vendor_po`.`vendor_po_id`
`vendor_po`.`wo_no`
`vendor_po`.`mrn_no`
`vendor_po`.`vendor`
`vendor_po`.`vendor_id`
`vendor_po`.`vendor_address`
`vendor_po`.`vendor_gst`
`vendor_po`.`ship_to`
`vendor_po`.`vendor_po_no`
`vendor_po`.`type`
`vendor_po`.`vendor_po_dt`
`vendor_po`.`validated_date`
`vendor_po`.`gst_type`
`vendor_po`.`gst_tax_prcnt`
`vendor_po`.`gst_total`
`vendor_po`.`with_without_raw`
`vendor_po`.`verified_date`
`vendor_po`.`terms_n_conditions`
`vendor_po`.`sub_total`
`vendor_po`.`discount_amount`
`vendor_po`.`subtotal_adisc`
`vendor_po`.`sub_total_amount`
`vendor_po`.`total_cost`
`vendor_po`.`total_words`
`vendor_po`.`currency`
`vendor_po`.`rupees_per_doller`
`vendor_po`.`currency_amount`
`vendor_po`.`pf_prcnt`
`vendor_po`.`freight`
`vendor_po`.`insurance`
`vendor_po`.`dispatch`
`vendor_po`.`payment`
`vendor_po`.`incoterms`
`vendor_po`.`delivery`
`vendor_po`.`documents`
`vendor_po`.`prepared_by`
`vendor_po`.`verified_by`
`vendor_po`.`issued_date`
`vendor_po`.`poRemarks`
`vendor_po`.`pack_instructions`
`vendor_po`.`po_validate_status`
`vendor_po`.`po_validate`
`vendor_po`.`po_validated_by`
`vendor_po`.`po_validated_date`
`vendor_po`.`po_prepared_date`
`vendor_po`.`po_validated_role`
`vendor_po`.`po_amendment_req_reason`
`vendor_po`.`po_amendment_req_by`
`vendor_po`.`po_amendment_req_date`
`vendor_po`.`po_amendment_req_status`
`vendor_po`.`po_amendment_req_approve_by`
`vendor_po`.`po_amendment_req_approve_date`
`vendor_po`.`po_amendment_no`
`vendor_po`.`po_amendment_date`
`vendor_po`.`po_amended_by`
`vendor_po`.`quotation_ref`
`vendor_po`.`quotation_date`
`vendor_po`.`cancelled`
`vendor_po`.`po_cancel_reason`
`vendor_po`.`po_cancel_req_by`
`vendor_po`.`po_cancel_req_date`
`vendor_po`.`po_cancel_req_status`
`vendor_po`.`po_cancelled_by`
`vendor_po`.`po_cancelled_date`
`vendor_po`.`transportation_charge`
`vendor_po`.`internal_comment`
`vendor_po`.`request_cancel_by`
`vendor_po`.`request_cancel_date`
`vendor_po`.`cancel_request_status`
`vendor_po`.`amend_request_cancel_by`
`vendor_po`.`amend_request_cancel_date`
`vendor_po`.`amend_request_status`
`vendor_po`.`transport_wotax`
`vendor_po`.`insurance_wotax`
`vendor_po`.`packing_wotax`
`vendor_po`.`total_parts_count`
`vendor_po`.`total_qty_count`
`vendor_po`.`total_accepted_qty`
`vendor_po`.`total_received_qty`
`vendor_po`.`total_reject_qty`
`vendor_po`.`total_rework_qty`
`vendor_po`.`total_rwk_recv_qty`
`vendor_po`.`total_rework_issue_qty`
`vendor_po`.`total_issued_qty`
`vendor_po_detl`.*
`vendor_po_detl`.`vendor_po_detl_id`
`vendor_po_detl`.`wo_no`
`vendor_po_detl`.`part_id`
`vendor_po_detl`.`unit_price`
`vendor_po_detl`.`unit_of_measure`
`vendor_po_detl`.`discount_prcnt`
`vendor_po_detl`.`total_single_part`
`vendor_po_detl`.`unit_cost_per_part_wdisc`
`vendor_po_detl`.`tax_unit_insurence_price`
`vendor_po_detl`.`tax_unit_transport_price`
`vendor_po_detl`.`tax_unit_packing_price`
`vendor_po_detl`.`unit_insurence_price`
`vendor_po_detl`.`unit_transport_price`
`vendor_po_detl`.`unit_packing_price`
`vendor_po_detl`.`unit_total_price_before_gst`
`vendor_po_detl`.`unit_cost_per_part_adisc_wtax`
`vendor_po_detl`.`hsn_code`
`vendor_po_detl`.`sac_code`
`vendor_po_detl`.`mpn`
`vendor_po_detl`.`vendor`
`vendor_po_detl`.`vendor_id`
`vendor_po_detl`.`vendor_address`
`vendor_po_detl`.`vendor_gst`
`vendor_po_detl`.`vendor_order_qty`
`vendor_po_detl`.`mat_issue_qty`
`vendor_po_detl`.`part_rcpt_qty`
`vendor_po_detl`.`accepted_qty`
`vendor_po_detl`.`rejected_qty`
`vendor_po_detl`.`rework_qty`
`vendor_po_detl`.`rework_issue_qty`
`vendor_po_detl`.`part_issue_qty`
`vendor_po_detl`.`insp_rep_no`
`vendor_po_detl`.`vendor_po_no`
`vendor_po_detl`.`vendor_po_dt`
`vendor_po_detl`.`quotation_ref`
`vendor_po_detl`.`quotation_date`
`vendor_po_detl`.`vendor_trgt_date`
`vendor_po_detl`.`os_planner`
`vendor_po_detl`.`stg_no`
`vendor_po_detl`.`no_of_days`
`vendor_po_detl`.`po_amendment_no`
`vendor_po_detl`.`po_amendment_date`
`vendor_po_detl`.`po_amended_by`
`vendor_po_detl`.`po_validate`
`vendor_po_detl`.`po_validated_by`
`vendor_po_detl`.`po_validated_date`
`vendor_po_detl`.`po_prepared_date`
`vendor_po_detl`.`po_validated_role`
`vendor_po_detl`.`vendor_part_status`
`vendor_po_detl`.`raw_mat_spec`
`vendor_po_detl`.`raw_mat_dimension`
`vendor_po_detl`.`model`
`vendor_po_detl`.`make`
`vendor_po_detl`.`part_alternate_name`
`vendor_po_detl`.`part_note`
`vendor_po_detl`.`part_removed_by`
`vendor_po_detl`.`part_removed_dt`
`vendor_po_detl`.`reqd_total_qty`
`admin_os_planner_detl`.*
`admin_os_planner_detl`.`admin_os_planner_detl_id`
`admin_os_planner_detl`.`name`
`admin_os_planner_detl`.`emp_id`
`admin_os_planner_detl`.`projects`
`admin_os_planner_detl`.`vendors`
`admin_os_planner_detl`.`project_coordinator`
`admin_os_planner_detl`.`cell_no`
`admin_project_details`.*
`admin_project_details`.`admin_proj_detail_id`
`admin_project_details`.`oa_no`
`admin_project_details`.`proj_no`
`admin_project_details`.`org_id`
`admin_project_details`.`proj_name`
`admin_project_details`.`product_category`
`admin_project_details`.`quantity`
`admin_project_details`.`proj_trgt_manf_date`
`admin_project_details`.`proj_trgt_date`
`admin_project_details`.`proj_manager`
`admin_project_details`.`proj_coord`
`admin_project_details`.`purchase_coord`
`admin_project_details`.`estmtd_no_parts`
`admin_project_details`.`proj_start_date`
`admin_project_details`.`proj_end_date`
`admin_project_details`.`proj_budget`
`admin_project_details`.`status_flag`
`admin_project_details`.`design_trgt_date`
`admin_project_details`.`hsn_code`
`admin_project_details`.`status_interval`
`annexure_doc`.*
`annexure_doc`.`row_id`
`annexure_doc`.`oa_no`
`annexure_doc`.`po_no`
`annexure_doc`.`vendor`
`annexure_doc`.`file_name`
`assembly_activities`.*
`assembly_activities`.`row_id`
`assembly_activities`.`project_id`
`assembly_activities`.`activity_name`
`assembly_activities`.`activity_st_dt`
`assembly_activities`.`activity_trgt_dt`
`assembly_activities`.`activity_budget`
`assembly_activities`.`responsibility`
`assembly_activities`.`status`
`assembly_activities`.`remarks`
`assembly_activities`.`entry_by`
`assembly_activities`.`entry_dt`
`assembly_activities`.`modify_by`
`assembly_activities`.`modify_dt`
`assembly_details`.*
`assembly_details`.`assembly_id`
`assembly_details`.`oa_no`
`assembly_details`.`proj_no`
`assembly_details`.`asmbly_drg_no`
`assembly_details`.`sa_name`
`assembly_details`.`sa_drg_no`
`assembly_details`.`sa_per_asmbly`
`assembly_details`.`sa_strt_date`
`assembly_details`.`sa_trgt_date`
`assembly_details`.`sa_actual_start_date`
`assembly_details`.`sa_revised_date`
`assembly_details`.`sa_end_date`
`assembly_details`.`status_flag`
`assembly_details`.`design_eng`
`assembly_details`.`sa_drg_remarks`
`assembly_details`.`sa_drg_last_aremarks_by_date_time`
`assembly_details`.`sa_drg_aprov_by`
`assembly_details`.`sa_remarks`
`assembly_details`.`sa_drg_file`
`assembly_details`.`sa_status`
`assembly_details`.`sa_drg_file_flag`
`assembly_details_remarks`.*
`assembly_details_remarks`.`id_assembly_details_remarks`
`assembly_details_remarks`.`oa_no`
`assembly_details_remarks`.`proj_no`
`assembly_details_remarks`.`asmbly_drg_no`
`assembly_details_remarks`.`sa_drg_no`
`assembly_details_remarks`.`sa_name`
`assembly_details_remarks`.`remarks`
`assembly_details_remarks`.`remarks_date_time`
`assembly_details_remarks`.`role`
`assembly_details_remarks`.`username`
`closed_grn_summary_view`.*
`closed_grn_summary_view`.`part_count`
`closed_grn_summary_view`.`grn_status`
`closed_grn_summary_view`.`oa_no`
`closed_grn_summary_view`.`grn_no`
`closed_grn_summary_view`.`vendor`
`closed_grn_summary_view`.`vendor_po_no`
`dc_summary_details`.*
`dc_summary_details`.`dc_summary_id`
`dc_summary_details`.`dc_no`
`dc_summary_details`.`grn_no`
`dc_summary_details`.`vendor`
`dc_summary_details`.`vendor_po_no`
`dc_summary_details`.`vendor_po_date`
`dc_summary_details`.`dc_created_date`
`dc_summary_details`.`dc_created_by`
`dc_summary_details`.`parts_count`
`dc_summary_details`.`parts_issue_qty`
`dc_summary_details`.`accept_qty`
`dc_summary_details`.`reject_qty`
`dc_summary_details`.`rework_qty`
`dc_summary_details`.`rework_issue_qty`
`dc_summary_details`.`pending_qty`
`dc_summary_details`.`total_cost_without_tax`
`dc_summary_details`.`total_cost_taxable`
`dc_summary_details`.`os_planner`
`dc_summary_details`.`oa_no`
`dc_summary_details`.`last_updated`
`department`.*
`department`.`row_id`
`department`.`department_name`
`dispatch_activities`.*
`dispatch_activities`.`row_id`
`dispatch_activities`.`project_id`
`dispatch_activities`.`activity_name`
`dispatch_activities`.`activity_st_dt`
`dispatch_activities`.`activity_trgt_dt`
`dispatch_activities`.`activity_budget`
`dispatch_activities`.`responsibility`
`dispatch_activities`.`status`
`dispatch_activities`.`remarks`
`dispatch_activities`.`entry_by`
`dispatch_activities`.`entry_dt`
`dispatch_activities`.`modify_by`
`dispatch_activities`.`modify_dt`
`employee_details`.*
`employee_details`.`emp_id`
`employee_details`.`emp_name`
`employee_details`.`emp_profile_name`
`employee_details`.`emp_pwd`
`employee_details`.`emp_role`
`employee_details`.`emp_role_id`
`employee_details`.`org_id`
`employee_details`.`project_coordinator`
`employee_details`.`cell_no`
`employee_details`.`emp_email`
`employee_details`.`emp_active_status`
`employee_details`.`static_ip1`
`employee_details`.`static_ip2`
`employee_details`.`last_modified`
`employee_details`.`otp`
`employee_details`.`otp_time`
`employee_roles`.*
`employee_roles`.`emp_role_id`
`employee_roles`.`role_name`
`employee_roles`.`noneditable_fields`
`grn_summary_details`.*
`grn_summary_details`.`grn_summary_id`
`grn_summary_details`.`grn_no`
`grn_summary_details`.`vendor`
`grn_summary_details`.`vendor_po_no`
`grn_summary_details`.`vendor_po_dt`
`grn_summary_details`.`grn_created_date`
`grn_summary_details`.`grn_created_by`
`grn_summary_details`.`grn_type`
`grn_summary_details`.`grn_status`
`grn_summary_details`.`parts_count`
`grn_summary_details`.`vendor_order_qty`
`grn_summary_details`.`parts_receipt_qty`
`grn_summary_details`.`accept_qty`
`grn_summary_details`.`reject_qty`
`grn_summary_details`.`rework_qty`
`grn_summary_details`.`rework_issue_qty`
`grn_summary_details`.`pending_qty`
`grn_summary_details`.`grn_closed_date`
`grn_summary_details`.`grn_closed_by`
`grn_summary_details`.`total_cost_without_tax`
`grn_summary_details`.`total_cost_taxable`
`grn_summary_details`.`os_planner`
`grn_summary_details`.`oa_no`
`grn_summary_details`.`last_updated`
`inspection_details`.*
`inspection_details`.`inspection_id`
`inspection_details`.`part_id`
`inspection_details`.`vendor`
`inspection_details`.`vendor_po_no`
`inspection_details`.`insp_rep_no`
`inspection_details`.`grn_no`
`inspection_details`.`no_of_stg`
`inspection_details`.`stg_no`
`inspection_details`.`reqd_total_qty`
`inspection_details`.`vendor_order_qty`
`inspection_details`.`part_qty_recvd`
`inspection_details`.`insp_qty_acpt`
`inspection_details`.`insp_qty_rej`
`inspection_details`.`insp_qty_rework`
`inspection_details`.`rework_issue_qty`
`inspection_details`.`remarks`
`inspection_details`.`insp_acpt_name`
`inspection_details`.`insp_person`
`inspection_details`.`insp_date`
`inspection_details`.`acpt_date`
`inspection_details`.`no_of_insp`
`inspection_details`.`flg_short_close`
`inspection_details`.`ir_validate`
`inspection_details`.`accept_with_out_tax`
`inspection_details`.`accept_with_tax`
`inspection_details`.`storage_location`
`inspection_summary_details`.*
`inspection_summary_details`.`inspection_summary_id`
`inspection_summary_details`.`vendor`
`inspection_summary_details`.`vendor_po_no`
`inspection_summary_details`.`vendor_po_date`
`inspection_summary_details`.`grn_no`
`inspection_summary_details`.`parts_count`
`inspection_summary_details`.`parts_receipt_qty`
`inspection_summary_details`.`rework_rcpt_qty`
`inspection_summary_details`.`accept_qty`
`inspection_summary_details`.`reject_qty`
`inspection_summary_details`.`rework_qty`
`inspection_summary_details`.`rework_issue_qty`
`inspection_summary_details`.`pending_qty`
`inspection_summary_details`.`os_planner`
`inspection_summary_details`.`oa_no`
`inspection_summary_details`.`inspected_by`
`inspection_summary_details`.`inspected_date`
`inspection_summary_details`.`accepted_cost_without_tax`
`inspection_summary_details`.`accepted_cost_with_tax`
`inspection_summary_details`.`last_updated`
`mapusermodule`.*
`mapusermodule`.`maping_id`
`mapusermodule`.`module`
`mapusermodule`.`rolename`
`mapusermodule`.`moduleaction`
`mat_rcpt_detl`.*
`mat_rcpt_detl`.`id`
`mat_rcpt_detl`.`part_id`
`mat_rcpt_detl`.`raw_mat_spec`
`mat_rcpt_detl`.`mat_req_qty`
`mat_rcpt_detl`.`raw_mat_dimension`
`mat_rcpt_detl`.`mat_pr_no`
`mat_rcpt_detl`.`mat_pr_dt`
`mat_rcpt_detl`.`mat_recd_qty`
`mat_rcpt_detl`.`mat_recvd_date`
`mat_rcpt_detl`.`mat_po_no`
`mat_rcpt_detl`.`os_planner`
`mat_rcpt_detl`.`emp_id`
`mat_req_detl`.*
`mat_req_detl`.`id`
`mat_req_detl`.`part_id`
`mat_req_detl`.`raw_mat_spec`
`mat_req_detl`.`mat_req_qty`
`mat_req_detl`.`mat_recd_qty`
`mat_req_detl`.`raw_mat_dimension`
`mat_req_detl`.`mat_pr_no`
`mat_req_detl`.`mat_pr_dt`
`mat_req_detl`.`request_status`
`mat_req_detl`.`mat_rcpt_trgt_dt`
`mat_req_detl`.`os_planner`
`mat_req_detl`.`emp_id`
`mat_req_detl`.`ir_validate`
`mat_req_detl`.`remarks`
`mat_req_detl`.`ir_validated_by`
`mat_req_detl`.`ir_validation_date`
`mat_req_detl`.`remarks_g`
`mat_req_detl`.`store_keeper`
`mat_req_detl`.`stock_update_date`
`mat_req_detl`.`received_by`
`mat_req_detl`.`approved_by`
`mat_req_stock`.*
`mat_req_stock`.`id`
`mat_req_stock`.`part_id`
`mat_req_stock`.`mat_req_qty`
`mat_req_stock`.`mat_pr_no`
`mat_req_stock`.`ava_stock_qty`
`mat_req_stock`.`pro_add_qty`
`mat_req_stock`.`shelf_days`
`mat_req_stock`.`remarks_stock`
`material_issue_detl`.*
`material_issue_detl`.`material_issue_detl_id`
`material_issue_detl`.`part_id`
`material_issue_detl`.`os_planner`
`material_issue_detl`.`emp_id`
`material_issue_detl`.`vendor`
`material_issue_detl`.`vendor_po_no`
`material_issue_detl`.`raw_mat_spec`
`material_issue_detl`.`raw_mat_dimension`
`material_issue_detl`.`mat_req_qty`
`material_issue_detl`.`mat_recd_qty`
`material_issue_detl`.`vendor_po_qty`
`material_issue_detl`.`mat_issue_qty`
`material_issue_detl`.`mat_issue_dt`
`material_issue_detl`.`dc_no`
`material_issue_detl`.`dc_type`
`message`.*
`message`.`message_id`
`message`.`part_id`
`message`.`org_id`
`message`.`message`
`message`.`msg_by`
`message`.`msg_to`
`message`.`msg_on`
`message`.`msg_type`
`message`.`msg_read`
`message`.`msg_vendor`
`org_settings`.*
`org_settings`.`org_id`
`org_settings`.`org_full_name`
`org_settings`.`org_short_name`
`org_settings`.`org_address_line_1`
`org_settings`.`org_address_line_2`
`org_settings`.`org_division_unit`
`org_settings`.`org_ph_no_1`
`org_settings`.`org_ph_no_2`
`org_settings`.`org_email`
`org_settings`.`org_website`
`org_settings`.`org_logo_path`
`org_settings`.`org_certification_logo_path`
`org_settings`.`org_iso_certified_title`
`org_settings`.`org_gstin_no`
`org_settings`.`org_pan_no`
`org_settings`.`org_excise_no`
`org_settings`.`org_services`
`org_settings`.`org_products`
`org_settings`.`org_misc_details`
`org_settings`.`org_currency_full`
`org_settings`.`org_currency_symbol`
`org_settings`.`org_currecny_short`
`org_settings`.`org_date_format`
`org_settings`.`org_estd_date`
`org_settings`.`org_active_status`
`org_settings`.`org_bucket`
`org_settings`.`hsn_code`
`org_settings`.`sac_code`
`parameter`.*
`parameter`.`id_param`
`parameter`.`org_id`
`parameter`.`parameter`
`parameter_translations`.*
`parameter_translations`.`id_translations`
`parameter_translations`.`lang_iso_code`
`parameter_translations`.`id_param`
`parameter_translations`.`custom_parameter`
`parameter_translations`.`org_id`
`parameter_translations`.`param_help`
`part_issue_details`.*
`part_issue_details`.`id`
`part_issue_details`.`part_id`
`part_issue_details`.`os_planner`
`part_issue_details`.`trgt_date`
`part_issue_details`.`vendor`
`part_issue_details`.`vendor_po_no`
`part_issue_details`.`grn_no`
`part_issue_details`.`dc_no`
`part_issue_details`.`dc_type`
`part_issue_details`.`no_of_stages`
`part_issue_details`.`stg_no`
`part_issue_details`.`reqd_total_qty`
`part_issue_details`.`vendor_order_qty`
`part_issue_details`.`part_rcpt_qty`
`part_issue_details`.`part_issue_qty`
`part_issue_details`.`part_issue_date`
`part_issue_details`.`part_issue_by`
`part_issue_details`.`vehicle_no`
`part_issue_details`.`mode_of_dispatch`
`part_issue_details`.`approximate_value`
`part_issue_details`.`e_sugam_no`
`part_issue_details`.`e_way_bill_no`
`part_issue_details`.`notes`
`part_issue_details`.`insp_rep_no`
`part_issue_details`.`dc_value_with_out_tax`
`part_issue_details`.`dc_value_with_tax`
`part_rcpt_detl`.*
`part_rcpt_detl`.`part_recpt_id`
`part_rcpt_detl`.`part_id`
`part_rcpt_detl`.`os_planner`
`part_rcpt_detl`.`trgt_dt`
`part_rcpt_detl`.`vendor`
`part_rcpt_detl`.`vendor_po_no`
`part_rcpt_detl`.`no_of_stages`
`part_rcpt_detl`.`stg_no`
`part_rcpt_detl`.`reqd_total_qty`
`part_rcpt_detl`.`vendor_order_qty`
`part_rcpt_detl`.`part_rcpt_qty`
`part_rcpt_detl`.`part_rcpt_dt`
`part_rcpt_detl`.`grn_no`
`part_rcpt_detl`.`grn_dt`
`part_rcpt_detl`.`grn_created_by`
`part_rcpt_detl`.`grn_status`
`part_rcpt_detl`.`grn_type`
`part_rcpt_detl`.`rework_rcpt_qty`
`part_rcpt_detl`.`inward_invoice_no`
`part_rcpt_detl`.`inward_invoice_dt`
`part_rcpt_detl`.`inward_dc_no`
`part_rcpt_detl`.`inward_dc_dt`
`part_rcpt_detl`.`grn_closed_by`
`part_rcpt_detl`.`grn_notes`
`part_rcpt_detl`.`e_way_bill_no`
`part_rcpt_detl`.`part_rcpt_updated_by`
`part_rcpt_detl`.`part_rcpt_updated_dt`
`part_rcpt_detl`.`grn_value_adisc_before_gst`
`part_rcpt_detl`.`grn_value_adisc_with_gst`
`part_rcpt_detl`.`grn_cancel_reason`
`part_rcpt_detl`.`grn_cancel_req_by`
`part_rcpt_detl`.`grn_cancel_req_date`
`part_rcpt_detl`.`grn_cancel_req_status`
`part_rcpt_detl`.`grn_cancelled_by`
`part_rcpt_detl`.`grn_cancelled_date`
`part_rcpt_detl`.`request_cancel_by`
`part_rcpt_detl`.`request_cancel_date`
`part_rcpt_detl`.`cancel_request_status`
`pending_grn_summary_view`.*
`pending_grn_summary_view`.`part_count`
`pending_grn_summary_view`.`grn_status`
`pending_grn_summary_view`.`oa_no`
`pending_grn_summary_view`.`vendor`
`pending_grn_summary_view`.`vendor_po_no`
`pending_grn_summary_view`.`grn_no`
`po_cost_table`.*
`po_cost_table`.`id`
`po_cost_table`.`vendor`
`po_cost_table`.`oa_no`
`po_cost_table`.`vendor_po_no`
`po_cost_table`.`vendor_po_dt`
`po_cost_table`.`total_cost`
`po_cost_table`.`acpt_date`
`po_cost_table`.`payment_days`
`proj_detl`.*
`proj_detl`.`part_id`
`proj_detl`.`oa_no`
`proj_detl`.`proj_no`
`proj_detl`.`product_category`
`proj_detl`.`sa_name`
`proj_detl`.`assy_drg_no`
`proj_detl`.`sa_drg_no`
`proj_detl`.`sa_per_assy`
`proj_detl`.`part_name`
`proj_detl`.`part_drg_no`
`proj_detl`.`batch_no`
`proj_detl`.`parts_per_assy`
`proj_detl`.`vendor_order_qty`
`proj_detl`.`actual_qty`
`proj_detl`.`reqd_total_qty`
`proj_detl`.`mat_req_qty`
`proj_detl`.`mat_recd_qty`
`proj_detl`.`mat_issue_qty`
`proj_detl`.`part_rcpt_qty`
`proj_detl`.`accepted_qty`
`proj_detl`.`rejected_qty`
`proj_detl`.`rework_qty`
`proj_detl`.`rework_issue_qty`
`proj_detl`.`part_issue_qty`
`proj_detl`.`trgt_date`
`proj_detl`.`class_of_parts`
`proj_detl`.`status`
`proj_detl`.`os_planner`
`proj_detl`.`date_drg_issue`
`proj_detl`.`raw_mat_spec`
`proj_detl`.`raw_mat_dimension`
`proj_detl`.`rev_del_dt`
`proj_detl`.`remarks`
`proj_detl`.`proj_remarks_by_date_time`
`proj_detl`.`bom_qty`
`proj_detl`.`part_acpt_date`
`proj_detl`.`part_issue_assly_date`
`proj_detl`.`part_issue_assly_qty`
`proj_detl`.`return_accept_qty`
`proj_detl`.`no_of_stages`
`proj_detl`.`status_flag`
`proj_detl`.`start_dt`
`proj_detl`.`end_dt`
`proj_detl`.`pending_assly_issue_qty`
`proj_detl`.`bom_upload_date`
`proj_detl`.`design_eng`
`proj_detl`.`part_drg_remarks`
`proj_detl`.`part_drg_aprov_by`
`proj_detl`.`drg_release_dt`
`proj_detl`.`type`
`proj_detl`.`final_insp_dt`
`proj_detl`.`no_of_insp`
`proj_detl`.`mr_na`
`proj_detl`.`part_drg_release_by`
`proj_detl`.`hsn_code`
`proj_detl`.`sac_code`
`proj_detl`.`revision`
`proj_detl`.`uom`
`proj_detl`.`model`
`proj_detl`.`make`
`proj_detl`.`website`
`proj_detl`.`alternate_allow`
`proj_detl`.`week_lead_time`
`proj_detl`.`part_drg_file`
`proj_detl`.`part_drg_file_flag`
`proj_detl`.`sa_drg_file`
`proj_detl`.`sa_drg_file_flag`
`proj_detl`.`qc_require`
`proj_detl`.`inventory_id`
`proj_detl`.`drawing_updated_by`
`proj_detl`.`drawing_updated_date`
`proj_detl`.`drg_update_status`
`proj_detl_temp`.*
`proj_detl_temp`.`proj_detl_id`
`proj_detl_temp`.`oa_no`
`proj_detl_temp`.`proj_no`
`proj_detl_temp`.`sa_name`
`proj_detl_temp`.`assy_drg_no`
`proj_detl_temp`.`sa_drg_no`
`proj_detl_temp`.`sa_drg_revision`
`proj_detl_temp`.`sa_per_assy`
`proj_detl_temp`.`part_name`
`proj_detl_temp`.`part_drg_no`
`proj_detl_temp`.`batch_no`
`proj_detl_temp`.`parts_per_assy`
`proj_detl_temp`.`reqd_total_qty`
`proj_detl_temp`.`bom_qty`
`proj_detl_temp`.`stages`
`proj_detl_temp`.`trgt_date`
`proj_detl_temp`.`class_of_parts`
`proj_detl_temp`.`raw_mat_spec`
`proj_detl_temp`.`raw_mat_dimension`
`proj_detl_temp`.`bom_upload_date`
`proj_detl_temp`.`design_eng`
`proj_detl_temp`.`part_drg_remarks`
`proj_detl_temp`.`part_drg_release_by`
`proj_detl_temp`.`drg_release_dt`
`proj_detl_temp`.`type`
`proj_detl_temp`.`revision`
`proj_detl_temp`.`revision_date`
`proj_detl_temp`.`make`
`proj_detl_temp`.`model`
`proj_detl_temp`.`uom`
`proj_detl_temp`.`website`
`proj_detl_temp`.`hsn_code`
`proj_detl_temp`.`sac_code`
`proj_detl_temp`.`alternate_allow`
`proj_detl_temp`.`week_lead_time`
`proj_detl_temp`.`last_modified_date`
`proj_detl_temp`.`last_modified_by`
`proj_detl_temp`.`part_drg_file`
`proj_detl_temp`.`part_drg_file_flag`
`proj_detl_temp`.`sa_drg_file`
`proj_detl_temp`.`sa_drg_file_flag`
`proj_detl_temp`.`remarks`
`proj_detl_temp`.`status_flag`
`project_planner`.*
`project_planner`.`row_id`
`project_planner`.`project_id`
`project_planner`.`department_id`
`project_planner`.`activity_name`
`project_planner`.`activity_st_dt`
`project_planner`.`activity_trgt_dt`
`project_planner`.`activity_budget`
`project_planner`.`entry_by`
`project_planner`.`entry_dt`
`project_planner`.`modify_by`
`project_planner`.`modify_dt`
`project_summary_view`.*
`project_summary_view`.`oa_no`
`project_summary_view`.`proj_name`
`project_summary_view`.`proj_trgt_date`
`project_summary_view`.`status`
`project_summary_view`.`project_cost`
`project_summary_view`.`proj_budget`
`return_issue_details`.*
`return_issue_details`.`id`
`return_issue_details`.`part_id`
`return_issue_details`.`oa_no`
`return_issue_details`.`sa_name`
`return_issue_details`.`sa_drg_no`
`return_issue_details`.`part_name`
`return_issue_details`.`part_drg_no`
`return_issue_details`.`riv_no`
`return_issue_details`.`reqd_total_qty`
`return_issue_details`.`piv_no`
`return_issue_details`.`return_issue_qty`
`return_issue_details`.`return_accept_qty`
`return_issue_details`.`return_reject_qty`
`return_issue_details`.`return_rework_qty`
`return_issue_details`.`return_issue_to`
`return_issue_details`.`return_issued_by`
`return_issue_details`.`return_issue_date`
`return_issue_details`.`class_of_parts`
`return_issue_details`.`remarks`
`t_activities_mst`.*
`t_activities_mst`.`row_id`
`t_activities_mst`.`project_id`
`t_activities_mst`.`department_id`
`t_activities_mst`.`activity_name`
`t_activities_mst`.`activity_st_dt`
`t_activities_mst`.`activity_trgt_dt`
`t_activities_mst`.`actual_st_dt`
`t_activities_mst`.`actual_trgt_dt`
`t_activities_mst`.`activity_budget`
`t_activities_mst`.`responsibility`
`t_activities_mst`.`status`
`t_activities_mst`.`remarks`
`t_activities_mst`.`entry_by`
`t_activities_mst`.`entry_dt`
`t_activities_mst`.`modify_by`
`t_activities_mst`.`modify_dt`
`t_additional_charges_mst`.*
`t_additional_charges_mst`.`row_id`
`t_additional_charges_mst`.`additional_charge_type`
`t_class_of_parts_mst`.*
`t_class_of_parts_mst`.`row_id`
`t_class_of_parts_mst`.`class_of_part`
`t_control_mst`.*
`t_control_mst`.`row_id`
`t_control_mst`.`record_type`
`t_control_mst`.`record_value`
`t_currency_mst`.*
`t_currency_mst`.`row_id`
`t_currency_mst`.`currency`
`t_currency_mst`.`sub_text`
`t_currency_mst`.`decimal_words`
`t_currency_mst`.`symbol`
`t_currency_mst`.`default`
`t_documents_mst`.*
`t_documents_mst`.`row_id`
`t_documents_mst`.`wo_no`
`t_documents_mst`.`document_title`
`t_documents_mst`.`document_file`
`t_drawing_format_mst`.*
`t_drawing_format_mst`.`row_id`
`t_drawing_format_mst`.`doc_type`
`t_drawing_format_mst`.`pos1`
`t_drawing_format_mst`.`pos2`
`t_drawing_format_mst`.`pos3`
`t_drawing_format_mst`.`pos4`
`t_drawing_format_mst`.`pos5`
`t_drawing_format_mst`.`pos6`
`t_drawing_format_mst`.`pos7`
`t_drawing_format_mst`.`pos8`
`t_drawing_format_mst`.`pos9`
`t_drawing_format_mst`.`version_prefix`
`t_drawing_format_mst`.`separator`
`t_editable_fields_mst`.*
`t_editable_fields_mst`.`row_id`
`t_editable_fields_mst`.`editable_fields`
`t_editable_fields_mst`.`column_name`
`t_format_mst`.*
`t_format_mst`.`row_id`
`t_format_mst`.`doc_type`
`t_format_mst`.`pos1`
`t_format_mst`.`pos2`
`t_format_mst`.`pos3`
`t_format_mst`.`pos4`
`t_format_mst`.`pos5`
`t_format_mst`.`prefix`
`t_format_mst`.`separator`
`t_format_mst`.`year`
`t_format_mst`.`sl_no_length`
`t_format_mst`.`year_separator`
`t_inventory_mst`.*
`t_inventory_mst`.`Inventory_id`
`t_inventory_mst`.`part_name`
`t_inventory_mst`.`part_drg_no`
`t_inventory_mst`.`batch_no`
`t_inventory_mst`.`vendor_order_qty`
`t_inventory_mst`.`actual_qty`
`t_inventory_mst`.`reqd_total_qty`
`t_inventory_mst`.`mat_req_qty`
`t_inventory_mst`.`mat_recd_qty`
`t_inventory_mst`.`part_rcpt_qty`
`t_inventory_mst`.`accepted_qty`
`t_inventory_mst`.`rejected_qty`
`t_inventory_mst`.`rework_qty`
`t_inventory_mst`.`rework_issue_qty`
`t_inventory_mst`.`part_issue_qty`
`t_inventory_mst`.`trgt_date`
`t_inventory_mst`.`class_of_parts`
`t_inventory_mst`.`status`
`t_inventory_mst`.`raw_mat_spec`
`t_inventory_mst`.`raw_mat_dimension`
`t_inventory_mst`.`remarks`
`t_inventory_mst`.`stock_remarks_by_date_time`
`t_inventory_mst`.`bom_qty`
`t_inventory_mst`.`no_of_stages`
`t_inventory_mst`.`status_flag`
`t_inventory_mst`.`pending_assly_issue_qty`
`t_inventory_mst`.`type`
`t_inventory_mst`.`mr_na`
`t_inventory_mst`.`hsn_code`
`t_inventory_mst`.`sac_code`
`t_inventory_mst`.`uom`
`t_inventory_mst`.`model`
`t_inventory_mst`.`make`
`t_inventory_mst`.`website`
`t_inventory_mst`.`STOCK_AVAILABILITY_ALWAYS_ONDEMAND`
`t_inventory_mst`.`SAFTEY_STOCK_LEVEL`
`t_inventory_mst`.`NUMBER_OF_UNITS_IN_THE_BATCH`
`t_inventory_mst`.`PART_SPACE_CONSTRAINT`
`t_inventory_mst`.`MINIMUM_ORDER_QUANTITY`
`t_inventory_mst`.`SHELF_LIFE`
`t_inventory_mst`.`PART_AVAILABILITY_TO_UPCOMING_PROJECT_SCHEDULE`
`t_inventory_mst`.`PART_OR_PRODUCT`
`t_inventory_mst`.`PART_ACCESS_RESTRICTED`
`t_inventory_mst`.`inventory_update_by`
`t_inventory_mst`.`inventory_update_date`
`t_iso_doc_no_mst`.*
`t_iso_doc_no_mst`.`row_id`
`t_iso_doc_no_mst`.`doc_type`
`t_iso_doc_no_mst`.`doc_no`
`t_iso_doc_no_mst`.`doc_date`
`t_iso_doc_no_mst`.`doc_description`
`t_label_mst`.*
`t_label_mst`.`row_id`
`t_label_mst`.`page_id`
`t_label_mst`.`page_label`
`t_module_mst`.*
`t_module_mst`.`row_id`
`t_module_mst`.`module_id`
`t_module_mst`.`module_name`
`t_module_mst`.`module_icon`
`t_module_mst`.`entry_by`
`t_module_mst`.`entry_dt`
`t_module_mst`.`modify_by`
`t_module_mst`.`modify_dt`
`t_option_mst`.*
`t_option_mst`.`row_id`
`t_option_mst`.`module_id`
`t_option_mst`.`option_id`
`t_option_mst`.`option_name`
`t_option_mst`.`option_controller`
`t_option_mst`.`entry_by`
`t_option_mst`.`entry_dt`
`t_option_mst`.`entry_tm`
`t_option_mst`.`modify_by`
`t_option_mst`.`modify_dt`
`t_option_mst`.`modify_tm`
`t_option_mst`.`option_remarks`
`t_page_mst`.*
`t_page_mst`.`row_id`
`t_page_mst`.`page_name`
`t_page_mst`.`page_description`
`t_part_docs_mst`.*
`t_part_docs_mst`.`row_id`
`t_part_docs_mst`.`wo_no`
`t_part_docs_mst`.`sa_name`
`t_part_docs_mst`.`sa_drg_no`
`t_part_docs_mst`.`part_id`
`t_part_docs_mst`.`doc_type`
`t_part_docs_mst`.`doc_file`
`t_part_type_mst`.*
`t_part_type_mst`.`row_id`
`t_part_type_mst`.`part_type`
`t_parts_status`.*
`t_parts_status`.`row_id`
`t_parts_status`.`wo_no`
`t_parts_status`.`sa_name`
`t_parts_status`.`part_name`
`t_parts_status`.`part_id`
`t_parts_status`.`stage_no`
`t_parts_status`.`stage_weightage`
`t_parts_status`.`part_approve`
`t_parts_status`.`mat_req`
`t_parts_status`.`mat_recpt`
`t_parts_status`.`vendor_po`
`t_parts_status`.`mat_issue`
`t_parts_status`.`mfg`
`t_parts_status`.`part_recpt`
`t_parts_status`.`part_issue`
`t_parts_status`.`reject`
`t_parts_status`.`rework`
`t_parts_status`.`accept`
`t_parts_status`.`assembly`
`t_parts_status`.`raw_mat_na`
`t_parts_status`.`mr_na`
`t_parts_status`.`multi_stage`
`t_parts_status`.`total_qty`
`t_parts_status`.`status`
`t_planned_status_trn`.*
`t_planned_status_trn`.`row_id`
`t_planned_status_trn`.`project_id`
`t_planned_status_trn`.`interval_dt`
`t_planned_status_trn`.`planned_status`
`t_planned_status_trn`.`actual_status`
`t_po_param_mst`.*
`t_po_param_mst`.`row_id`
`t_po_param_mst`.`parameter_name`
`t_po_param_mst`.`parameter_field`
`t_po_param_mst`.`parameter_type`
`t_po_param_mst`.`parameter_field_type`
`t_po_param_pripority_mst`.*
`t_po_param_pripority_mst`.`row_id`
`t_po_param_pripority_mst`.`parameter_id`
`t_po_param_pripority_mst`.`parameter_priority`
`t_po_param_val_mapping_mst`.*
`t_po_param_val_mapping_mst`.`row_id`
`t_po_param_val_mapping_mst`.`user_name`
`t_po_param_val_mapping_mst`.`parameter_id`
`t_po_param_val_mapping_mst`.`parameter_value1`
`t_po_param_val_mapping_mst`.`parameter_value2`
`t_po_param_val_mapping_mst`.`access`
`t_po_param_values_mst`.*
`t_po_param_values_mst`.`row_id`
`t_po_param_values_mst`.`parameter_id`
`t_po_param_values_mst`.`parameter_value1`
`t_po_param_values_mst`.`parameter_value2`
`t_product_category_mst`.*
`t_product_category_mst`.`row_id`
`t_product_category_mst`.`product_category`
`t_qcrequire_mst`.*
`t_qcrequire_mst`.`row_id`
`t_qcrequire_mst`.`type`
`t_qcrequire_mst`.`A`
`t_qcrequire_mst`.`B`
`t_qcrequire_mst`.`C`
`t_rawmatspec_mst`.*
`t_rawmatspec_mst`.`row_id`
`t_rawmatspec_mst`.`rawmat_spec`
`t_services_mst`.*
`t_services_mst`.`row_id`
`t_services_mst`.`service_name`
`t_status_weightage`.*
`t_status_weightage`.`row_id`
`t_status_weightage`.`activity_name`
`t_status_weightage`.`status_percent`
`t_status_weightage`.`activity_weightage`
`t_status_weightage`.`column_name`
`t_subactivities_mst`.*
`t_subactivities_mst`.`row_id`
`t_subactivities_mst`.`project_id`
`t_subactivities_mst`.`activity_id`
`t_subactivities_mst`.`subactivity_name`
`t_subactivities_mst`.`subactivity_st_dt`
`t_subactivities_mst`.`subactivity_trgt_dt`
`t_subactivities_mst`.`actual_st_dt`
`t_subactivities_mst`.`actual_trgt_dt`
`t_subactivities_mst`.`subactivity_budget`
`t_subactivities_mst`.`responsibility`
`t_subactivities_mst`.`status`
`t_subactivities_mst`.`remarks`
`t_subactivities_mst`.`entry_by`
`t_subactivities_mst`.`entry_dt`
`t_subactivities_mst`.`modify_by`
`t_subactivities_mst`.`modify_dt`
`t_tax_mst`.*
`t_tax_mst`.`row_id`
`t_tax_mst`.`tax_slab`
`t_terms_mst`.*
`t_terms_mst`.`row_id`
`t_terms_mst`.`terms_type`
`t_terms_mst`.`terms_description`
`t_transaction_edit_mst`.*
`t_transaction_edit_mst`.`row_id`
`t_transaction_edit_mst`.`user_name`
`t_transaction_edit_mst`.`mrn`
`t_transaction_edit_mst`.`grn`
`t_transaction_edit_mst`.`inspection`
`t_transaction_edit_mst`.`issue`
`t_transaction_edit_mst`.`dispatch`
`t_transfer_param_mst`.*
`t_transfer_param_mst`.`row_id`
`t_transfer_param_mst`.`parameter_name`
`t_transfer_param_mst`.`parameter_field`
`t_transfer_param_mst`.`parameter_type`
`t_transfer_param_mst`.`parameter_field_type`
`t_transfer_param_pripority_mst`.*
`t_transfer_param_pripority_mst`.`row_id`
`t_transfer_param_pripority_mst`.`parameter_id`
`t_transfer_param_pripority_mst`.`parameter_priority`
`t_transfer_param_val_mapping_mst`.*
`t_transfer_param_val_mapping_mst`.`row_id`
`t_transfer_param_val_mapping_mst`.`user_name`
`t_transfer_param_val_mapping_mst`.`parameter_id`
`t_transfer_param_val_mapping_mst`.`parameter_value1`
`t_transfer_param_val_mapping_mst`.`parameter_value2`
`t_transfer_param_val_mapping_mst`.`access`
`t_transfer_param_values_mst`.*
`t_transfer_param_values_mst`.`row_id`
`t_transfer_param_values_mst`.`parameter_id`
`t_transfer_param_values_mst`.`parameter_value1`
`t_transfer_param_values_mst`.`parameter_value2`
`t_uom_mst`.*
`t_uom_mst`.`row_id`
`t_uom_mst`.`uom_name`
`t_user_modules_mst`.*
`t_user_modules_mst`.`row_id`
`t_user_modules_mst`.`emp_id`
`t_user_modules_mst`.`option_id`
`t_user_modules_mst`.`entry_by`
`t_user_modules_mst`.`entry_dt`
`t_user_modules_mst`.`entry_tm`
`t_user_modules_mst`.`entry_ip`
`t_user_modules_mst`.`entry_lat`
`t_user_modules_mst`.`entry_log`
`t_user_modules_mst`.`modify_by`
`t_user_modules_mst`.`modify_dt`
`t_user_modules_mst`.`modify_tm`
`t_user_modules_mst`.`modify_ip`
`t_user_modules_mst`.`modify_lat`
`t_user_modules_mst`.`modify_log`
`tbldispatchcomponent`.*
`tbldispatchcomponent`.`id`
`tbldispatchcomponent`.`part_id`
`tbldispatchcomponent`.`oa_no`
`tbldispatchcomponent`.`sa_name`
`tbldispatchcomponent`.`sa_drg_no`
`tbldispatchcomponent`.`part_name`
`tbldispatchcomponent`.`part_drg_no`
`tbldispatchcomponent`.`insp_rep_no`
`tbldispatchcomponent`.`reqd_total_qty`
`tbldispatchcomponent`.`piv_no`
`tbldispatchcomponent`.`Issue_qty`
`tbldispatchcomponent`.`issue_to`
`tbldispatchcomponent`.`issued_by`
`tbldispatchcomponent`.`issue_date`
`tbldispatchcomponent`.`class_of_parts`
`tbldispatchcomponent`.`remarks`
`tbldispatchcomponent`.`return_accept_qty`
`tbldispatchcomponent`.`return_issue_qty`
`tblpendcnt`.*
`tblpendcnt`.`id`
`tblpendcnt`.`part_id`
`tblpendcnt`.`oa_no`
`tblpendcnt`.`os_planner`
`tblpendcnt`.`no_of_stages`
`tblpendcnt`.`total_qty`
`tblpendcnt`.`completed_qty`
`tblpendcnt`.`pending_qty`
`tblpendcnt`.`req_qty`
`tblpendcnt`.`rcpt_qty`
`tblpendcnt`.`po_qty`
`tblpendcnt`.`issue_qty`
`tblpendcnt`.`mr_na`
`tblpendcnt`.`part_rcpt_qty`
`tblpendcnt`.`part_issue_qty`
`tblpendcnt`.`dispatch_qty`
`tblpendcnt`.`status`
`tblpendcnt`.`po_qty_firststg`
`tblpurparts`.*
`tblpurparts`.`pur_parts_id`
`tblpurparts`.`oa_no`
`tblpurparts`.`proj_no`
`tblpurparts`.`assy_drg_no`
`tblpurparts`.`sa_name`
`tblpurparts`.`sa_drg_no`
`tblpurparts`.`sa_per_assy`
`tblpurparts`.`part_name`
`tblpurparts`.`part_drg_no`
`tblpurparts`.`parts_per_assy`
`tblpurparts`.`reqd_total_qty`
`tblpurparts`.`class_of_parts`
`tblpurparts`.`raw_mat_spec`
`tblpurparts`.`raw_mat_dimension`
`tblpurparts`.`bom_upload_date`
`tblpurparts`.`design_eng`
`tblpurparts`.`part_drg_remarks`
`tblpurparts`.`part_drg_aprov_by`
`temp_detl_view`.*
`temp_detl_view`.`part_id`
`temp_detl_view`.`oa_no`
`temp_detl_view`.`proj_no`
`temp_detl_view`.`sa_name`
`temp_detl_view`.`assy_drg_no`
`temp_detl_view`.`sa_drg_no`
`temp_detl_view`.`sa_per_assy`
`temp_detl_view`.`part_name`
`temp_detl_view`.`part_drg_no`
`temp_detl_view`.`status`
`temp_detl_view`.`start_dt`
`temp_detl_view`.`date_drg_issue`
`temp_detl_view`.`trgt_date`
`temp_detl_view`.`parts_per_assy`
`temp_detl_view`.`reqd_total_qty`
`temp_detl_view`.`class_of_parts`
`temp_detl_view`.`os_planner`
`temp_detl_view`.`no_of_stages`
`temp_detl_view`.`mat_pr_no`
`temp_detl_view`.`mat_pr_dt`
`temp_detl_view`.`mat_req_qty`
`temp_detl_view`.`mat_recd_qty`
`temp_detl_view`.`mat_recvd_date`
`temp_detl_view`.`raw_mat_spec`
`temp_detl_view`.`raw_mat_dimension`
`temp_detl_view`.`remarks`
`temp_detl_view`.`vendor`
`temp_detl_view`.`vendor_po_no`
`temp_detl_view`.`vendor_po_dt`
`temp_detl_view`.`vendor_order_qty`
`temp_detl_view`.`vendor_trgt_date`
`temp_detl_view`.`no_of_days`
`temp_detl_view`.`stg_no`
`temp_detl_view`.`insp_rep_no`
`temp_detl_view`.`mat_issue_qty`
`temp_detl_view`.`mat_issue_dt`
`temp_detl_view`.`dc_no`
`temp_detl_view`.`part_rcpt_qty`
`temp_detl_view`.`part_rcpt_dt`
`temp_detl_view`.`insp_qty_acpt`
`temp_detl_view`.`insp_qty_rework`
`temp_detl_view`.`insp_qty_rej`
`temp_detl_view`.`insp_date`
`temp_detl_view`.`assmbly_issue_qty`
`temp_detl_view`.`disp_issue_date`
`temp_detl_view`.`design_eng`
`temp_detl_view`.`part_drg_aprov_by`
`temp_detl_view`.`end_dt`
`temp_detl_view`.`bom_upload_date`
`temp_detl_view`.`ir_validate`
`temp_detl_view`.`po_validate`
`transfer_request_detl`.*
`transfer_request_detl`.`transfer_id`
`transfer_request_detl`.`from_part_id`
`transfer_request_detl`.`to_part_id`
`transfer_request_detl`.`from_oa`
`transfer_request_detl`.`to_oa`
`transfer_request_detl`.`from_sa_name`
`transfer_request_detl`.`to_sa_name`
`transfer_request_detl`.`transfer_qty`
`transfer_request_detl`.`part_transfer_req_reason`
`transfer_request_detl`.`part_transfer_req_by`
`transfer_request_detl`.`part_transfer_req_date`
`transfer_request_detl`.`part_transfer_req_status`
`transfer_request_detl`.`part_transfer_req_approve_by`
`transfer_request_detl`.`part_transfer_req_approve_date`
`transfer_request_detl`.`part_transfer_no`
`transfer_request_detl`.`part_transfer_date`
`transfer_request_detl`.`part_transfer_by`
`transfer_request_detl`.`tv_no`
`user_audit_trails`.*
`user_audit_trails`.`id`
`user_audit_trails`.`user_id`
`user_audit_trails`.`user_name`
`user_audit_trails`.`event`
`user_audit_trails`.`table_name`
`user_audit_trails`.`old_values`
`user_audit_trails`.`new_values`
`user_audit_trails`.`url`
`user_audit_trails`.`name`
`user_audit_trails`.`ip_address`
`user_audit_trails`.`user_agent`
`user_audit_trails`.`created_at`
`vendor_details`.*
`vendor_details`.`vendor_detail_id`
`vendor_details`.`vendor_id`
`vendor_details`.`org_id`
`vendor_details`.`name`
`vendor_details`.`address`
`vendor_details`.`country`
`vendor_details`.`country_code`
`vendor_details`.`phone_no`
`vendor_details`.`mobile_no`
`vendor_details`.`email`
`vendor_details`.`website`
`vendor_details`.`products`
`vendor_details`.`services`
`vendor_details`.`contact_person`
`vendor_details`.`iso_9001_certified`
`vendor_details`.`vat_reg_no`
`vendor_details`.`service_tax`
`vendor_details`.`pan_no`
`vendor_details`.`tan_no`
`vendor_details`.`exercise_reg_no`
`vendor_details`.`job_approved_type`
`vendor_details`.`vendor_reg_no`
`vendor_details`.`os_planner`
`vendor_details`.`gst_no`
`vendor_details`.`vendor_active_status`
`vendor_details`.`comp_reg_type`
`vendor_details`.`gst_reg_type`
`vendor_po`.*
`vendor_po`.`vendor_po_id`
`vendor_po`.`wo_no`
`vendor_po`.`mrn_no`
`vendor_po`.`vendor`
`vendor_po`.`vendor_id`
`vendor_po`.`vendor_address`
`vendor_po`.`vendor_gst`
`vendor_po`.`ship_to`
`vendor_po`.`vendor_po_no`
`vendor_po`.`type`
`vendor_po`.`vendor_po_dt`
`vendor_po`.`validated_date`
`vendor_po`.`gst_type`
`vendor_po`.`gst_tax_prcnt`
`vendor_po`.`gst_total`
`vendor_po`.`with_without_raw`
`vendor_po`.`verified_date`
`vendor_po`.`terms_n_conditions`
`vendor_po`.`sub_total`
`vendor_po`.`discount_amount`
`vendor_po`.`subtotal_adisc`
`vendor_po`.`sub_total_amount`
`vendor_po`.`total_cost`
`vendor_po`.`total_words`
`vendor_po`.`currency`
`vendor_po`.`rupees_per_doller`
`vendor_po`.`currency_amount`
`vendor_po`.`pf_prcnt`
`vendor_po`.`freight`
`vendor_po`.`insurance`
`vendor_po`.`dispatch`
`vendor_po`.`payment`
`vendor_po`.`incoterms`
`vendor_po`.`delivery`
`vendor_po`.`documents`
`vendor_po`.`prepared_by`
`vendor_po`.`verified_by`
`vendor_po`.`issued_date`
`vendor_po`.`poRemarks`
`vendor_po`.`pack_instructions`
`vendor_po`.`po_validate_status`
`vendor_po`.`po_validate`
`vendor_po`.`po_validated_by`
`vendor_po`.`po_validated_date`
`vendor_po`.`po_prepared_date`
`vendor_po`.`po_validated_role`
`vendor_po`.`po_amendment_req_reason`
`vendor_po`.`po_amendment_req_by`
`vendor_po`.`po_amendment_req_date`
`vendor_po`.`po_amendment_req_status`
`vendor_po`.`po_amendment_req_approve_by`
`vendor_po`.`po_amendment_req_approve_date`
`vendor_po`.`po_amendment_no`
`vendor_po`.`po_amendment_date`
`vendor_po`.`po_amended_by`
`vendor_po`.`quotation_ref`
`vendor_po`.`quotation_date`
`vendor_po`.`cancelled`
`vendor_po`.`po_cancel_reason`
`vendor_po`.`po_cancel_req_by`
`vendor_po`.`po_cancel_req_date`
`vendor_po`.`po_cancel_req_status`
`vendor_po`.`po_cancelled_by`
`vendor_po`.`po_cancelled_date`
`vendor_po`.`transportation_charge`
`vendor_po`.`internal_comment`
`vendor_po`.`request_cancel_by`
`vendor_po`.`request_cancel_date`
`vendor_po`.`cancel_request_status`
`vendor_po`.`amend_request_cancel_by`
`vendor_po`.`amend_request_cancel_date`
`vendor_po`.`amend_request_status`
`vendor_po`.`transport_wotax`
`vendor_po`.`insurance_wotax`
`vendor_po`.`packing_wotax`
`vendor_po`.`total_parts_count`
`vendor_po`.`total_qty_count`
`vendor_po`.`total_accepted_qty`
`vendor_po`.`total_received_qty`
`vendor_po`.`total_reject_qty`
`vendor_po`.`total_rework_qty`
`vendor_po`.`total_rwk_recv_qty`
`vendor_po`.`total_rework_issue_qty`
`vendor_po`.`total_issued_qty`
`vendor_po_detl`.*
`vendor_po_detl`.`vendor_po_detl_id`
`vendor_po_detl`.`wo_no`
`vendor_po_detl`.`part_id`
`vendor_po_detl`.`unit_price`
`vendor_po_detl`.`unit_of_measure`
`vendor_po_detl`.`discount_prcnt`
`vendor_po_detl`.`total_single_part`
`vendor_po_detl`.`unit_cost_per_part_wdisc`
`vendor_po_detl`.`tax_unit_insurence_price`
`vendor_po_detl`.`tax_unit_transport_price`
`vendor_po_detl`.`tax_unit_packing_price`
`vendor_po_detl`.`unit_insurence_price`
`vendor_po_detl`.`unit_transport_price`
`vendor_po_detl`.`unit_packing_price`
`vendor_po_detl`.`unit_total_price_before_gst`
`vendor_po_detl`.`unit_cost_per_part_adisc_wtax`
`vendor_po_detl`.`hsn_code`
`vendor_po_detl`.`sac_code`
`vendor_po_detl`.`mpn`
`vendor_po_detl`.`vendor`
`vendor_po_detl`.`vendor_id`
`vendor_po_detl`.`vendor_address`
`vendor_po_detl`.`vendor_gst`
`vendor_po_detl`.`vendor_order_qty`
`vendor_po_detl`.`mat_issue_qty`
`vendor_po_detl`.`part_rcpt_qty`
`vendor_po_detl`.`accepted_qty`
`vendor_po_detl`.`rejected_qty`
`vendor_po_detl`.`rework_qty`
`vendor_po_detl`.`rework_issue_qty`
`vendor_po_detl`.`part_issue_qty`
`vendor_po_detl`.`insp_rep_no`
`vendor_po_detl`.`vendor_po_no`
`vendor_po_detl`.`vendor_po_dt`
`vendor_po_detl`.`quotation_ref`
`vendor_po_detl`.`quotation_date`
`vendor_po_detl`.`vendor_trgt_date`
`vendor_po_detl`.`os_planner`
`vendor_po_detl`.`stg_no`
`vendor_po_detl`.`no_of_days`
`vendor_po_detl`.`po_amendment_no`
`vendor_po_detl`.`po_amendment_date`
`vendor_po_detl`.`po_amended_by`
`vendor_po_detl`.`po_validate`
`vendor_po_detl`.`po_validated_by`
`vendor_po_detl`.`po_validated_date`
`vendor_po_detl`.`po_prepared_date`
`vendor_po_detl`.`po_validated_role`
`vendor_po_detl`.`vendor_part_status`
`vendor_po_detl`.`raw_mat_spec`
`vendor_po_detl`.`raw_mat_dimension`
`vendor_po_detl`.`model`
`vendor_po_detl`.`make`
`vendor_po_detl`.`part_alternate_name`
`vendor_po_detl`.`part_note`
`vendor_po_detl`.`part_removed_by`
`vendor_po_detl`.`part_removed_dt`
`vendor_po_detl`.`reqd_total_qty`
エイリアス:
表示:
ソート:
昇順
降順
昇順
降順
昇順
降順
ソート順:
1
2
3
1
2
3
1
2
3
条件:
挿入:
および:
削除:
または:
修正:
または:
および:
挿入
削除
または:
および:
挿入
削除
挿入
削除
条件行の追加または削除:
-3
-2
-1
0
1
2
3
カラムの追加または削除:
-3
-2
-1
0
1
2
3
利用するテーブル
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
mat_rcpt_detl
mat_req_detl
mat_req_stock
material_issue_detl
message
org_settings
parameter
parameter_translations
part_issue_details
part_rcpt_detl
pending_grn_summary_view
po_cost_table
proj_detl
proj_detl_temp
project_planner
project_summary_view
return_issue_details
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_part_docs_mst
t_part_type_mst
t_parts_status
t_planned_status_trn
t_po_param_mst
t_po_param_pripority_mst
t_po_param_val_mapping_mst
t_po_param_values_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_val_mapping_mst
t_transfer_param_values_mst
t_uom_mst
t_user_modules_mst
tbldispatchcomponent
tblpendcnt
tblpurparts
temp_detl_view
transfer_request_detl
user_audit_trails
vendor_details
vendor_po
vendor_po_detl
データベース
precitec_test
のSQL: