Feature #162
openBSP Reco Tracker
Start date:
02/25/2023
Due date:
% Done:
60%
Estimated time:
Owner(Agency):
Travvise
Time Taken(HH):
Module:
BSP Reco Tracker
Tested By:
Code Reviewed By:
Subtasks
Related issues
Updated by Anil KV 12 months ago
SELECT ... FROM reconciliation.tbl_bsp_file_import_master fim LEFT JOIN document.tbl_documents fid ON fim.fk_documents_id = fid.pk_documents_id ***If ststus = Reco Done' LEFT JOIN reconciliation.tbl_bsp_reco_master rcm ON rcm.fk_bsp_file_import_master_id = fim.pk_bsp_file_import_master_id LEFT JOIN document.tbl_documents rcd ON rcm.fk_documents_id = rcd.pk_documents_id