USE [cloudERP]
GO
/****** Object:  StoredProcedure [dbo].[test]    Script Date: 1/15/2020 8:32:15 PM ******/
DROP PROCEDURE [dbo].[test]
GO
/****** Object:  StoredProcedure [dbo].[pr_TableCleanup]    Script Date: 1/15/2020 8:32:15 PM ******/
DROP PROCEDURE [dbo].[pr_TableCleanup]
GO
/****** Object:  StoredProcedure [dbo].[pr_createsinglecolumnmaster_table]    Script Date: 1/15/2020 8:32:15 PM ******/
DROP PROCEDURE [dbo].[pr_createsinglecolumnmaster_table]
GO
/****** Object:  StoredProcedure [db_sop].[pr_vouchergenerationforsale]    Script Date: 1/15/2020 8:32:15 PM ******/
DROP PROCEDURE [db_sop].[pr_vouchergenerationforsale]
GO
/****** Object:  StoredProcedure [db_sop].[pr_vouchergeneration]    Script Date: 1/15/2020 8:32:15 PM ******/
DROP PROCEDURE [db_sop].[pr_vouchergeneration]
GO
/****** Object:  StoredProcedure [db_sop].[pr_saveorderuploadinfo]    Script Date: 1/15/2020 8:32:15 PM ******/
DROP PROCEDURE [db_sop].[pr_saveorderuploadinfo]
GO
/****** Object:  StoredProcedure [db_sop].[pr_saveinvoice]    Script Date: 1/15/2020 8:32:15 PM ******/
DROP PROCEDURE [db_sop].[pr_saveinvoice]
GO
/****** Object:  StoredProcedure [db_sop].[pr_savedrcrnote]    Script Date: 1/15/2020 8:32:15 PM ******/
DROP PROCEDURE [db_sop].[pr_savedrcrnote]
GO
/****** Object:  StoredProcedure [db_sop].[pr_savecustomerorder]    Script Date: 1/15/2020 8:32:15 PM ******/
DROP PROCEDURE [db_sop].[pr_savecustomerorder]
GO
/****** Object:  StoredProcedure [db_sop].[pr_savecontractreview]    Script Date: 1/15/2020 8:32:15 PM ******/
DROP PROCEDURE [db_sop].[pr_savecontractreview]
GO
/****** Object:  StoredProcedure [db_sop].[pr_save_saleswork_order]    Script Date: 1/15/2020 8:32:15 PM ******/
DROP PROCEDURE [db_sop].[pr_save_saleswork_order]
GO
/****** Object:  StoredProcedure [db_sop].[pr_save_order_fileuploadinfo]    Script Date: 1/15/2020 8:32:15 PM ******/
DROP PROCEDURE [db_sop].[pr_save_order_fileuploadinfo]
GO
/****** Object:  StoredProcedure [db_sop].[pr_report_customersaleregister]    Script Date: 1/15/2020 8:32:15 PM ******/
DROP PROCEDURE [db_sop].[pr_report_customersaleregister]
GO
/****** Object:  StoredProcedure [db_sop].[pr_report_customerorderregister]    Script Date: 1/15/2020 8:32:15 PM ******/
DROP PROCEDURE [db_sop].[pr_report_customerorderregister]
GO
/****** Object:  StoredProcedure [db_sop].[pr_report_commanapiformarketing]    Script Date: 1/15/2020 8:32:15 PM ******/
DROP PROCEDURE [db_sop].[pr_report_commanapiformarketing]
GO
/****** Object:  StoredProcedure [db_sop].[pr_report_commanapiforcustomerorder]    Script Date: 1/15/2020 8:32:15 PM ******/
DROP PROCEDURE [db_sop].[pr_report_commanapiforcustomerorder]
GO
/****** Object:  StoredProcedure [db_sop].[pr_printjobworkdata]    Script Date: 1/15/2020 8:32:15 PM ******/
DROP PROCEDURE [db_sop].[pr_printjobworkdata]
GO
/****** Object:  StoredProcedure [db_sop].[pr_printcustomerorder]    Script Date: 1/15/2020 8:32:15 PM ******/
DROP PROCEDURE [db_sop].[pr_printcustomerorder]
GO
/****** Object:  StoredProcedure [db_sop].[pr_printcustomerinvoiceexport]    Script Date: 1/15/2020 8:32:15 PM ******/
DROP PROCEDURE [db_sop].[pr_printcustomerinvoiceexport]
GO
/****** Object:  StoredProcedure [db_sop].[pr_printcustomerinvoice]    Script Date: 1/15/2020 8:32:15 PM ******/
DROP PROCEDURE [db_sop].[pr_printcustomerinvoice]
GO
/****** Object:  StoredProcedure [db_sop].[pr_gettermsandconditions]    Script Date: 1/15/2020 8:32:15 PM ******/
DROP PROCEDURE [db_sop].[pr_gettermsandconditions]
GO
/****** Object:  StoredProcedure [db_sop].[pr_getsaleworkorderlist]    Script Date: 1/15/2020 8:32:15 PM ******/
DROP PROCEDURE [db_sop].[pr_getsaleworkorderlist]
GO
/****** Object:  StoredProcedure [db_sop].[pr_getsaleworkorderdata]    Script Date: 1/15/2020 8:32:15 PM ******/
DROP PROCEDURE [db_sop].[pr_getsaleworkorderdata]
GO
/****** Object:  StoredProcedure [db_sop].[pr_getpendingordersPI]    Script Date: 1/15/2020 8:32:15 PM ******/
DROP PROCEDURE [db_sop].[pr_getpendingordersPI]
GO
/****** Object:  StoredProcedure [db_sop].[pr_getpendingorders]    Script Date: 1/15/2020 8:32:15 PM ******/
DROP PROCEDURE [db_sop].[pr_getpendingorders]
GO
/****** Object:  StoredProcedure [db_sop].[pr_getpaymentterms]    Script Date: 1/15/2020 8:32:15 PM ******/
DROP PROCEDURE [db_sop].[pr_getpaymentterms]
GO
/****** Object:  StoredProcedure [db_sop].[pr_getordertypecustomers]    Script Date: 1/15/2020 8:32:15 PM ******/
DROP PROCEDURE [db_sop].[pr_getordertypecustomers]
GO
/****** Object:  StoredProcedure [db_sop].[pr_getnotelist]    Script Date: 1/15/2020 8:32:15 PM ******/
DROP PROCEDURE [db_sop].[pr_getnotelist]
GO
/****** Object:  StoredProcedure [db_sop].[pr_getlastpino]    Script Date: 1/15/2020 8:32:15 PM ******/
DROP PROCEDURE [db_sop].[pr_getlastpino]
GO
/****** Object:  StoredProcedure [db_sop].[pr_getlastoano]    Script Date: 1/15/2020 8:32:15 PM ******/
DROP PROCEDURE [db_sop].[pr_getlastoano]
GO
/****** Object:  StoredProcedure [db_sop].[pr_getinvoicelist]    Script Date: 1/15/2020 8:32:15 PM ******/
DROP PROCEDURE [db_sop].[pr_getinvoicelist]
GO
/****** Object:  StoredProcedure [db_sop].[pr_getinvoicedata]    Script Date: 1/15/2020 8:32:15 PM ******/
DROP PROCEDURE [db_sop].[pr_getinvoicedata]
GO
/****** Object:  StoredProcedure [db_sop].[pr_GetGSTR1_Data]    Script Date: 1/15/2020 8:32:15 PM ******/
DROP PROCEDURE [db_sop].[pr_GetGSTR1_Data]
GO
/****** Object:  StoredProcedure [db_sop].[pr_getDrCrDetail]    Script Date: 1/15/2020 8:32:15 PM ******/
DROP PROCEDURE [db_sop].[pr_getDrCrDetail]
GO
/****** Object:  StoredProcedure [db_sop].[pr_getdocumentsreqd]    Script Date: 1/15/2020 8:32:15 PM ******/
DROP PROCEDURE [db_sop].[pr_getdocumentsreqd]
GO
/****** Object:  StoredProcedure [db_sop].[pr_getdeliveryscheduledata]    Script Date: 1/15/2020 8:32:15 PM ******/
DROP PROCEDURE [db_sop].[pr_getdeliveryscheduledata]
GO
/****** Object:  StoredProcedure [db_sop].[pr_getcustomersinvoice]    Script Date: 1/15/2020 8:32:15 PM ******/
DROP PROCEDURE [db_sop].[pr_getcustomersinvoice]
GO
/****** Object:  StoredProcedure [db_sop].[pr_getcustomerorderprintppc]    Script Date: 1/15/2020 8:32:16 PM ******/
DROP PROCEDURE [db_sop].[pr_getcustomerorderprintppc]
GO
/****** Object:  StoredProcedure [db_sop].[pr_getcustomerorderlist]    Script Date: 1/15/2020 8:32:16 PM ******/
DROP PROCEDURE [db_sop].[pr_getcustomerorderlist]
GO
/****** Object:  StoredProcedure [db_sop].[pr_getcustomerorderitems]    Script Date: 1/15/2020 8:32:16 PM ******/
DROP PROCEDURE [db_sop].[pr_getcustomerorderitems]
GO
/****** Object:  StoredProcedure [db_sop].[pr_getcustomerorderdatabyno]    Script Date: 1/15/2020 8:32:16 PM ******/
DROP PROCEDURE [db_sop].[pr_getcustomerorderdatabyno]
GO
/****** Object:  StoredProcedure [db_sop].[pr_getcustomerorderdata]    Script Date: 1/15/2020 8:32:16 PM ******/
DROP PROCEDURE [db_sop].[pr_getcustomerorderdata]
GO
/****** Object:  StoredProcedure [db_sop].[pr_getcontractreviewdata]    Script Date: 1/15/2020 8:32:16 PM ******/
DROP PROCEDURE [db_sop].[pr_getcontractreviewdata]
GO
/****** Object:  StoredProcedure [db_sop].[pr_confirmorderbyprdn]    Script Date: 1/15/2020 8:32:16 PM ******/
DROP PROCEDURE [db_sop].[pr_confirmorderbyprdn]
GO
/****** Object:  StoredProcedure [db_sop].[pr_confirminvoice]    Script Date: 1/15/2020 8:32:16 PM ******/
DROP PROCEDURE [db_sop].[pr_confirminvoice]
GO
/****** Object:  StoredProcedure [db_sop].[pr_commonapicustomerorder]    Script Date: 1/15/2020 8:32:16 PM ******/
DROP PROCEDURE [db_sop].[pr_commonapicustomerorder]
GO
/****** Object:  StoredProcedure [db_sop].[pr_cancelinvoice]    Script Date: 1/15/2020 8:32:16 PM ******/
DROP PROCEDURE [db_sop].[pr_cancelinvoice]
GO
/****** Object:  StoredProcedure [db_qc].[pr_saveqcsetup]    Script Date: 1/15/2020 8:32:16 PM ******/
DROP PROCEDURE [db_qc].[pr_saveqcsetup]
GO
/****** Object:  StoredProcedure [db_qc].[pr_saveqcinspectionrpt]    Script Date: 1/15/2020 8:32:16 PM ******/
DROP PROCEDURE [db_qc].[pr_saveqcinspectionrpt]
GO
/****** Object:  StoredProcedure [db_qc].[pr_getsetupqcdetails]    Script Date: 1/15/2020 8:32:16 PM ******/
DROP PROCEDURE [db_qc].[pr_getsetupqcdetails]
GO
/****** Object:  StoredProcedure [db_qc].[pr_getqctestlist]    Script Date: 1/15/2020 8:32:16 PM ******/
DROP PROCEDURE [db_qc].[pr_getqctestlist]
GO
/****** Object:  StoredProcedure [db_qc].[pr_getQcintimationList]    Script Date: 1/15/2020 8:32:16 PM ******/
DROP PROCEDURE [db_qc].[pr_getQcintimationList]
GO
/****** Object:  StoredProcedure [db_qc].[pr_getintimationdetails]    Script Date: 1/15/2020 8:32:16 PM ******/
DROP PROCEDURE [db_qc].[pr_getintimationdetails]
GO
/****** Object:  StoredProcedure [db_qc].[pr_commonapiqc]    Script Date: 1/15/2020 8:32:16 PM ******/
DROP PROCEDURE [db_qc].[pr_commonapiqc]
GO
/****** Object:  StoredProcedure [db_qc].[pr_commonapiinspectionrpt]    Script Date: 1/15/2020 8:32:16 PM ******/
DROP PROCEDURE [db_qc].[pr_commonapiinspectionrpt]
GO
/****** Object:  StoredProcedure [db_production].[pr_savewo]    Script Date: 1/15/2020 8:32:16 PM ******/
DROP PROCEDURE [db_production].[pr_savewo]
GO
/****** Object:  StoredProcedure [db_production].[pr_saveproductionplan]    Script Date: 1/15/2020 8:32:16 PM ******/
DROP PROCEDURE [db_production].[pr_saveproductionplan]
GO
/****** Object:  StoredProcedure [db_production].[pr_savemovementcardtemplate]    Script Date: 1/15/2020 8:32:16 PM ******/
DROP PROCEDURE [db_production].[pr_savemovementcardtemplate]
GO
/****** Object:  StoredProcedure [db_production].[pr_savejobmovementcard]    Script Date: 1/15/2020 8:32:16 PM ******/
DROP PROCEDURE [db_production].[pr_savejobmovementcard]
GO
/****** Object:  StoredProcedure [db_production].[pr_releasebatch]    Script Date: 1/15/2020 8:32:16 PM ******/
DROP PROCEDURE [db_production].[pr_releasebatch]
GO
/****** Object:  StoredProcedure [db_production].[pr_jobmovementcardcommanapi]    Script Date: 1/15/2020 8:32:16 PM ******/
DROP PROCEDURE [db_production].[pr_jobmovementcardcommanapi]
GO
/****** Object:  StoredProcedure [db_production].[pr_getwolist]    Script Date: 1/15/2020 8:32:16 PM ******/
DROP PROCEDURE [db_production].[pr_getwolist]
GO
/****** Object:  StoredProcedure [db_production].[pr_getwodata]    Script Date: 1/15/2020 8:32:16 PM ******/
DROP PROCEDURE [db_production].[pr_getwodata]
GO
/****** Object:  StoredProcedure [db_production].[pr_getuserbatches]    Script Date: 1/15/2020 8:32:16 PM ******/
DROP PROCEDURE [db_production].[pr_getuserbatches]
GO
/****** Object:  StoredProcedure [db_production].[pr_getplanlist]    Script Date: 1/15/2020 8:32:16 PM ******/
DROP PROCEDURE [db_production].[pr_getplanlist]
GO
/****** Object:  StoredProcedure [db_production].[pr_getplandata]    Script Date: 1/15/2020 8:32:16 PM ******/
DROP PROCEDURE [db_production].[pr_getplandata]
GO
/****** Object:  StoredProcedure [db_production].[pr_getmovementtemplates]    Script Date: 1/15/2020 8:32:16 PM ******/
DROP PROCEDURE [db_production].[pr_getmovementtemplates]
GO
/****** Object:  StoredProcedure [db_production].[pr_getmovementtemplatedata]    Script Date: 1/15/2020 8:32:16 PM ******/
DROP PROCEDURE [db_production].[pr_getmovementtemplatedata]
GO
/****** Object:  StoredProcedure [db_production].[pr_getjobmovementcards]    Script Date: 1/15/2020 8:32:16 PM ******/
DROP PROCEDURE [db_production].[pr_getjobmovementcards]
GO
/****** Object:  StoredProcedure [db_production].[pr_getjobmovementcarddata]    Script Date: 1/15/2020 8:32:16 PM ******/
DROP PROCEDURE [db_production].[pr_getjobmovementcarddata]
GO
/****** Object:  StoredProcedure [db_production].[pr_getjobdata]    Script Date: 1/15/2020 8:32:16 PM ******/
DROP PROCEDURE [db_production].[pr_getjobdata]
GO
/****** Object:  StoredProcedure [db_production].[pr_getjobcards]    Script Date: 1/15/2020 8:32:16 PM ******/
DROP PROCEDURE [db_production].[pr_getjobcards]
GO
/****** Object:  StoredProcedure [db_production].[pr_getcustomerorderitemsforWO]    Script Date: 1/15/2020 8:32:16 PM ******/
DROP PROCEDURE [db_production].[pr_getcustomerorderitemsforWO]
GO
/****** Object:  StoredProcedure [db_production].[pr_getbatchdata]    Script Date: 1/15/2020 8:32:16 PM ******/
DROP PROCEDURE [db_production].[pr_getbatchdata]
GO
/****** Object:  StoredProcedure [db_production].[pr_generatewoandpo]    Script Date: 1/15/2020 8:32:16 PM ******/
DROP PROCEDURE [db_production].[pr_generatewoandpo]
GO
/****** Object:  StoredProcedure [db_production].[pr_generatebatchno]    Script Date: 1/15/2020 8:32:16 PM ******/
DROP PROCEDURE [db_production].[pr_generatebatchno]
GO
/****** Object:  StoredProcedure [db_production].[pr_confirmplan]    Script Date: 1/15/2020 8:32:16 PM ******/
DROP PROCEDURE [db_production].[pr_confirmplan]
GO
/****** Object:  StoredProcedure [db_production].[pr_commonapiplan]    Script Date: 1/15/2020 8:32:16 PM ******/
DROP PROCEDURE [db_production].[pr_commonapiplan]
GO
/****** Object:  StoredProcedure [db_production].[pr_commonapimovementcard]    Script Date: 1/15/2020 8:32:16 PM ******/
DROP PROCEDURE [db_production].[pr_commonapimovementcard]
GO
/****** Object:  StoredProcedure [db_production].[pr_allocatebatch]    Script Date: 1/15/2020 8:32:16 PM ******/
DROP PROCEDURE [db_production].[pr_allocatebatch]
GO
/****** Object:  StoredProcedure [db_production].[jobwisenetrequirement]    Script Date: 1/15/2020 8:32:16 PM ******/
DROP PROCEDURE [db_production].[jobwisenetrequirement]
GO
/****** Object:  StoredProcedure [db_production].[generaterequisition]    Script Date: 1/15/2020 8:32:16 PM ******/
DROP PROCEDURE [db_production].[generaterequisition]
GO
/****** Object:  StoredProcedure [db_production].[batchwisenetrequirement]    Script Date: 1/15/2020 8:32:16 PM ******/
DROP PROCEDURE [db_production].[batchwisenetrequirement]
GO
/****** Object:  StoredProcedure [db_production].[batchwisegrossrequirement]    Script Date: 1/15/2020 8:32:16 PM ******/
DROP PROCEDURE [db_production].[batchwisegrossrequirement]
GO
/****** Object:  StoredProcedure [db_mt].[pr_saveticket_images]    Script Date: 1/15/2020 8:32:16 PM ******/
DROP PROCEDURE [db_mt].[pr_saveticket_images]
GO
/****** Object:  StoredProcedure [db_mt].[pr_savemaintenanceticket]    Script Date: 1/15/2020 8:32:16 PM ******/
DROP PROCEDURE [db_mt].[pr_savemaintenanceticket]
GO
/****** Object:  StoredProcedure [db_mt].[pr_getticketslist]    Script Date: 1/15/2020 8:32:16 PM ******/
DROP PROCEDURE [db_mt].[pr_getticketslist]
GO
/****** Object:  StoredProcedure [db_mt].[pr_getticketdata]    Script Date: 1/15/2020 8:32:16 PM ******/
DROP PROCEDURE [db_mt].[pr_getticketdata]
GO
/****** Object:  StoredProcedure [db_mt].[pr_commonapiticket]    Script Date: 1/15/2020 8:32:16 PM ******/
DROP PROCEDURE [db_mt].[pr_commonapiticket]
GO
/****** Object:  StoredProcedure [db_mm].[reports_supplierwisependingorders1]    Script Date: 1/15/2020 8:32:16 PM ******/
DROP PROCEDURE [db_mm].[reports_supplierwisependingorders1]
GO
/****** Object:  StoredProcedure [db_mm].[reports_supplierwisependingorders]    Script Date: 1/15/2020 8:32:16 PM ******/
DROP PROCEDURE [db_mm].[reports_supplierwisependingorders]
GO
/****** Object:  StoredProcedure [db_mm].[reports_supplierwisegrnregister]    Script Date: 1/15/2020 8:32:16 PM ******/
DROP PROCEDURE [db_mm].[reports_supplierwisegrnregister]
GO
/****** Object:  StoredProcedure [db_mm].[reports_stockvaluation]    Script Date: 1/15/2020 8:32:16 PM ******/
DROP PROCEDURE [db_mm].[reports_stockvaluation]
GO
/****** Object:  StoredProcedure [db_mm].[reports_ResumeRegister]    Script Date: 1/15/2020 8:32:16 PM ******/
DROP PROCEDURE [db_mm].[reports_ResumeRegister]
GO
/****** Object:  StoredProcedure [db_mm].[reports_purchaserRegister1]    Script Date: 1/15/2020 8:32:16 PM ******/
DROP PROCEDURE [db_mm].[reports_purchaserRegister1]
GO
/****** Object:  StoredProcedure [db_mm].[reports_purchaseRegister]    Script Date: 1/15/2020 8:32:16 PM ******/
DROP PROCEDURE [db_mm].[reports_purchaseRegister]
GO
/****** Object:  StoredProcedure [db_mm].[reports_purchase]    Script Date: 1/15/2020 8:32:16 PM ******/
DROP PROCEDURE [db_mm].[reports_purchase]
GO
/****** Object:  StoredProcedure [db_mm].[reports_pendingindentregister]    Script Date: 1/15/2020 8:32:16 PM ******/
DROP PROCEDURE [db_mm].[reports_pendingindentregister]
GO
/****** Object:  StoredProcedure [db_mm].[reports_nonmovingstock]    Script Date: 1/15/2020 8:32:16 PM ******/
DROP PROCEDURE [db_mm].[reports_nonmovingstock]
GO
/****** Object:  StoredProcedure [db_mm].[reports_itemwisependingpo]    Script Date: 1/15/2020 8:32:16 PM ******/
DROP PROCEDURE [db_mm].[reports_itemwisependingpo]
GO
/****** Object:  StoredProcedure [db_mm].[reports_item-wise-minmaxlevel_test]    Script Date: 1/15/2020 8:32:16 PM ******/
DROP PROCEDURE [db_mm].[reports_item-wise-minmaxlevel_test]
GO
/****** Object:  StoredProcedure [db_mm].[reports_item-wise-minmaxlevel]    Script Date: 1/15/2020 8:32:16 PM ******/
DROP PROCEDURE [db_mm].[reports_item-wise-minmaxlevel]
GO
/****** Object:  StoredProcedure [db_mm].[reports_itemwiseindent]    Script Date: 1/15/2020 8:32:16 PM ******/
DROP PROCEDURE [db_mm].[reports_itemwiseindent]
GO
/****** Object:  StoredProcedure [db_mm].[reports_itemwisegrnregister]    Script Date: 1/15/2020 8:32:16 PM ******/
DROP PROCEDURE [db_mm].[reports_itemwisegrnregister]
GO
/****** Object:  StoredProcedure [db_mm].[reports_intimationtoiqc]    Script Date: 1/15/2020 8:32:16 PM ******/
DROP PROCEDURE [db_mm].[reports_intimationtoiqc]
GO
/****** Object:  StoredProcedure [db_mm].[reports_indetorwisependingindent]    Script Date: 1/15/2020 8:32:16 PM ******/
DROP PROCEDURE [db_mm].[reports_indetorwisependingindent]
GO
/****** Object:  StoredProcedure [db_mm].[reports_indentregster]    Script Date: 1/15/2020 8:32:16 PM ******/
DROP PROCEDURE [db_mm].[reports_indentregster]
GO
/****** Object:  StoredProcedure [db_mm].[reports_grnregister1]    Script Date: 1/15/2020 8:32:16 PM ******/
DROP PROCEDURE [db_mm].[reports_grnregister1]
GO
/****** Object:  StoredProcedure [db_mm].[reports_grnregister]    Script Date: 1/15/2020 8:32:16 PM ******/
DROP PROCEDURE [db_mm].[reports_grnregister]
GO
/****** Object:  StoredProcedure [db_mm].[reports_drcrnote]    Script Date: 1/15/2020 8:32:16 PM ******/
DROP PROCEDURE [db_mm].[reports_drcrnote]
GO
/****** Object:  StoredProcedure [db_mm].[reports_drcradvice]    Script Date: 1/15/2020 8:32:16 PM ******/
DROP PROCEDURE [db_mm].[reports_drcradvice]
GO
/****** Object:  StoredProcedure [db_mm].[reports_dprregister]    Script Date: 1/15/2020 8:32:16 PM ******/
DROP PROCEDURE [db_mm].[reports_dprregister]
GO
/****** Object:  StoredProcedure [db_mm].[pr_usageofiteminbom]    Script Date: 1/15/2020 8:32:16 PM ******/
DROP PROCEDURE [db_mm].[pr_usageofiteminbom]
GO
/****** Object:  StoredProcedure [db_mm].[pr_updatepurchasefollowup]    Script Date: 1/15/2020 8:32:16 PM ******/
DROP PROCEDURE [db_mm].[pr_updatepurchasefollowup]
GO
/****** Object:  StoredProcedure [db_mm].[pr_update_item_code_initemmaster]    Script Date: 1/15/2020 8:32:16 PM ******/
DROP PROCEDURE [db_mm].[pr_update_item_code_initemmaster]
GO
/****** Object:  StoredProcedure [db_mm].[pr_Supplierlist]    Script Date: 1/15/2020 8:32:16 PM ******/
DROP PROCEDURE [db_mm].[pr_Supplierlist]
GO
/****** Object:  StoredProcedure [db_mm].[pr_stockledger]    Script Date: 1/15/2020 8:32:16 PM ******/
DROP PROCEDURE [db_mm].[pr_stockledger]
GO
/****** Object:  StoredProcedure [db_mm].[pr_savevendorallocationlistapprovals]    Script Date: 1/15/2020 8:32:16 PM ******/
DROP PROCEDURE [db_mm].[pr_savevendorallocationlistapprovals]
GO
/****** Object:  StoredProcedure [db_mm].[pr_savevendorallocationlist]    Script Date: 1/15/2020 8:32:16 PM ******/
DROP PROCEDURE [db_mm].[pr_savevendorallocationlist]
GO
/****** Object:  StoredProcedure [db_mm].[pr_savestktransfer]    Script Date: 1/15/2020 8:32:16 PM ******/
DROP PROCEDURE [db_mm].[pr_savestktransfer]
GO
/****** Object:  StoredProcedure [db_mm].[pr_savergp]    Script Date: 1/15/2020 8:32:16 PM ******/
DROP PROCEDURE [db_mm].[pr_savergp]
GO
/****** Object:  StoredProcedure [db_mm].[pr_saverequisition]    Script Date: 1/15/2020 8:32:16 PM ******/
DROP PROCEDURE [db_mm].[pr_saverequisition]
GO
/****** Object:  StoredProcedure [db_mm].[pr_savepopassing]    Script Date: 1/15/2020 8:32:16 PM ******/
DROP PROCEDURE [db_mm].[pr_savepopassing]
GO
/****** Object:  StoredProcedure [db_mm].[pr_savepo]    Script Date: 1/15/2020 8:32:16 PM ******/
DROP PROCEDURE [db_mm].[pr_savepo]
GO
/****** Object:  StoredProcedure [db_mm].[pr_saveplan]    Script Date: 1/15/2020 8:32:16 PM ******/
DROP PROCEDURE [db_mm].[pr_saveplan]
GO
/****** Object:  StoredProcedure [db_mm].[pr_savepackingbom]    Script Date: 1/15/2020 8:32:16 PM ******/
DROP PROCEDURE [db_mm].[pr_savepackingbom]
GO
/****** Object:  StoredProcedure [db_mm].[pr_savenrgp]    Script Date: 1/15/2020 8:32:16 PM ******/
DROP PROCEDURE [db_mm].[pr_savenrgp]
GO
/****** Object:  StoredProcedure [db_mm].[pr_saveitemcategory]    Script Date: 1/15/2020 8:32:16 PM ******/
DROP PROCEDURE [db_mm].[pr_saveitemcategory]
GO
/****** Object:  StoredProcedure [db_mm].[pr_saveitem_images]    Script Date: 1/15/2020 8:32:16 PM ******/
DROP PROCEDURE [db_mm].[pr_saveitem_images]
GO
/****** Object:  StoredProcedure [db_mm].[pr_saveissuereturn]    Script Date: 1/15/2020 8:32:16 PM ******/
DROP PROCEDURE [db_mm].[pr_saveissuereturn]
GO
/****** Object:  StoredProcedure [db_mm].[pr_saveissuance]    Script Date: 1/15/2020 8:32:16 PM ******/
DROP PROCEDURE [db_mm].[pr_saveissuance]
GO
/****** Object:  StoredProcedure [db_mm].[pr_saveinwardnote]    Script Date: 1/15/2020 8:32:16 PM ******/
DROP PROCEDURE [db_mm].[pr_saveinwardnote]
GO
/****** Object:  StoredProcedure [db_mm].[pr_saveindentpassing]    Script Date: 1/15/2020 8:32:16 PM ******/
DROP PROCEDURE [db_mm].[pr_saveindentpassing]
GO
/****** Object:  StoredProcedure [db_mm].[pr_saveindent]    Script Date: 1/15/2020 8:32:17 PM ******/
DROP PROCEDURE [db_mm].[pr_saveindent]
GO
/****** Object:  StoredProcedure [db_mm].[pr_savehsnmaster]    Script Date: 1/15/2020 8:32:17 PM ******/
DROP PROCEDURE [db_mm].[pr_savehsnmaster]
GO
/****** Object:  StoredProcedure [db_mm].[pr_savegstmaster]    Script Date: 1/15/2020 8:32:17 PM ******/
DROP PROCEDURE [db_mm].[pr_savegstmaster]
GO
/****** Object:  StoredProcedure [db_mm].[pr_savegrniqc]    Script Date: 1/15/2020 8:32:17 PM ******/
DROP PROCEDURE [db_mm].[pr_savegrniqc]
GO
/****** Object:  StoredProcedure [db_mm].[pr_savegrnconfirmation]    Script Date: 1/15/2020 8:32:17 PM ******/
DROP PROCEDURE [db_mm].[pr_savegrnconfirmation]
GO
/****** Object:  StoredProcedure [db_mm].[pr_savegrn]    Script Date: 1/15/2020 8:32:17 PM ******/
DROP PROCEDURE [db_mm].[pr_savegrn]
GO
/****** Object:  StoredProcedure [db_mm].[pr_savedpr]    Script Date: 1/15/2020 8:32:17 PM ******/
DROP PROCEDURE [db_mm].[pr_savedpr]
GO
/****** Object:  StoredProcedure [db_mm].[pr_savedestruction]    Script Date: 1/15/2020 8:32:17 PM ******/
DROP PROCEDURE [db_mm].[pr_savedestruction]
GO
/****** Object:  StoredProcedure [db_mm].[pr_savebom]    Script Date: 1/15/2020 8:32:17 PM ******/
DROP PROCEDURE [db_mm].[pr_savebom]
GO
/****** Object:  StoredProcedure [db_mm].[pr_printrequisitiondata]    Script Date: 1/15/2020 8:32:17 PM ******/
DROP PROCEDURE [db_mm].[pr_printrequisitiondata]
GO
/****** Object:  StoredProcedure [db_mm].[pr_printpo]    Script Date: 1/15/2020 8:32:17 PM ******/
DROP PROCEDURE [db_mm].[pr_printpo]
GO
/****** Object:  StoredProcedure [db_mm].[pr_printissuancedata]    Script Date: 1/15/2020 8:32:17 PM ******/
DROP PROCEDURE [db_mm].[pr_printissuancedata]
GO
/****** Object:  StoredProcedure [db_mm].[pr_printgrndata]    Script Date: 1/15/2020 8:32:17 PM ******/
DROP PROCEDURE [db_mm].[pr_printgrndata]
GO
/****** Object:  StoredProcedure [db_mm].[pr_print_requisition]    Script Date: 1/15/2020 8:32:17 PM ******/
DROP PROCEDURE [db_mm].[pr_print_requisition]
GO
/****** Object:  StoredProcedure [db_mm].[pr_mrpgrossreqd]    Script Date: 1/15/2020 8:32:17 PM ******/
DROP PROCEDURE [db_mm].[pr_mrpgrossreqd]
GO
/****** Object:  StoredProcedure [db_mm].[pr_itemstockarwise]    Script Date: 1/15/2020 8:32:17 PM ******/
DROP PROCEDURE [db_mm].[pr_itemstockarwise]
GO
/****** Object:  StoredProcedure [db_mm].[pr_itemenquiry]    Script Date: 1/15/2020 8:32:17 PM ******/
DROP PROCEDURE [db_mm].[pr_itemenquiry]
GO
/****** Object:  StoredProcedure [db_mm].[pr_getvendorallocationlistpos]    Script Date: 1/15/2020 8:32:17 PM ******/
DROP PROCEDURE [db_mm].[pr_getvendorallocationlistpos]
GO
/****** Object:  StoredProcedure [db_mm].[pr_getvendorallocationlistitems]    Script Date: 1/15/2020 8:32:17 PM ******/
DROP PROCEDURE [db_mm].[pr_getvendorallocationlistitems]
GO
/****** Object:  StoredProcedure [db_mm].[pr_getvendorallocationlistforapprovals]    Script Date: 1/15/2020 8:32:17 PM ******/
DROP PROCEDURE [db_mm].[pr_getvendorallocationlistforapprovals]
GO
/****** Object:  StoredProcedure [db_mm].[pr_getvendorallocationlist]    Script Date: 1/15/2020 8:32:17 PM ******/
DROP PROCEDURE [db_mm].[pr_getvendorallocationlist]
GO
/****** Object:  StoredProcedure [db_mm].[pr_gettermsandconditions]    Script Date: 1/15/2020 8:32:17 PM ******/
DROP PROCEDURE [db_mm].[pr_gettermsandconditions]
GO
/****** Object:  StoredProcedure [db_mm].[pr_getsupplierpos]    Script Date: 1/15/2020 8:32:17 PM ******/
DROP PROCEDURE [db_mm].[pr_getsupplierpos]
GO
/****** Object:  StoredProcedure [db_mm].[pr_getsupplierpoitems]    Script Date: 1/15/2020 8:32:17 PM ******/
DROP PROCEDURE [db_mm].[pr_getsupplierpoitems]
GO
/****** Object:  StoredProcedure [db_mm].[pr_getsubcostcentre]    Script Date: 1/15/2020 8:32:17 PM ******/
DROP PROCEDURE [db_mm].[pr_getsubcostcentre]
GO
/****** Object:  StoredProcedure [db_mm].[pr_getstore]    Script Date: 1/15/2020 8:32:17 PM ******/
DROP PROCEDURE [db_mm].[pr_getstore]
GO
/****** Object:  StoredProcedure [db_mm].[pr_getstktransferList]    Script Date: 1/15/2020 8:32:17 PM ******/
DROP PROCEDURE [db_mm].[pr_getstktransferList]
GO
/****** Object:  StoredProcedure [db_mm].[pr_getstktransferdata]    Script Date: 1/15/2020 8:32:17 PM ******/
DROP PROCEDURE [db_mm].[pr_getstktransferdata]
GO
/****** Object:  StoredProcedure [db_mm].[pr_getstandardbomdata]    Script Date: 1/15/2020 8:32:17 PM ******/
DROP PROCEDURE [db_mm].[pr_getstandardbomdata]
GO
/****** Object:  StoredProcedure [db_mm].[pr_getsaledashboardstatuswise]    Script Date: 1/15/2020 8:32:17 PM ******/
DROP PROCEDURE [db_mm].[pr_getsaledashboardstatuswise]
GO
/****** Object:  StoredProcedure [db_mm].[pr_getsaledashboardenquires]    Script Date: 1/15/2020 8:32:17 PM ******/
DROP PROCEDURE [db_mm].[pr_getsaledashboardenquires]
GO
/****** Object:  StoredProcedure [db_mm].[pr_getsaledashboarddata]    Script Date: 1/15/2020 8:32:17 PM ******/
DROP PROCEDURE [db_mm].[pr_getsaledashboarddata]
GO
/****** Object:  StoredProcedure [db_mm].[pr_getrgplist]    Script Date: 1/15/2020 8:32:17 PM ******/
DROP PROCEDURE [db_mm].[pr_getrgplist]
GO
/****** Object:  StoredProcedure [db_mm].[pr_getrgpdata]    Script Date: 1/15/2020 8:32:17 PM ******/
DROP PROCEDURE [db_mm].[pr_getrgpdata]
GO
/****** Object:  StoredProcedure [db_mm].[pr_getrequisitionlist]    Script Date: 1/15/2020 8:32:17 PM ******/
DROP PROCEDURE [db_mm].[pr_getrequisitionlist]
GO
/****** Object:  StoredProcedure [db_mm].[pr_getrequisitiondatasukhi]    Script Date: 1/15/2020 8:32:17 PM ******/
DROP PROCEDURE [db_mm].[pr_getrequisitiondatasukhi]
GO
/****** Object:  StoredProcedure [db_mm].[pr_getrequisitiondataravi]    Script Date: 1/15/2020 8:32:17 PM ******/
DROP PROCEDURE [db_mm].[pr_getrequisitiondataravi]
GO
/****** Object:  StoredProcedure [db_mm].[pr_getrequisitiondata_mohit]    Script Date: 1/15/2020 8:32:17 PM ******/
DROP PROCEDURE [db_mm].[pr_getrequisitiondata_mohit]
GO
/****** Object:  StoredProcedure [db_mm].[pr_getrequisitiondata]    Script Date: 1/15/2020 8:32:17 PM ******/
DROP PROCEDURE [db_mm].[pr_getrequisitiondata]
GO
/****** Object:  StoredProcedure [db_mm].[pr_getpurchaseaccounts]    Script Date: 1/15/2020 8:32:17 PM ******/
DROP PROCEDURE [db_mm].[pr_getpurchaseaccounts]
GO
/****** Object:  StoredProcedure [db_mm].[pr_getposupplieranduser]    Script Date: 1/15/2020 8:32:17 PM ******/
DROP PROCEDURE [db_mm].[pr_getposupplieranduser]
GO
/****** Object:  StoredProcedure [db_mm].[pr_getpolistforpassing]    Script Date: 1/15/2020 8:32:17 PM ******/
DROP PROCEDURE [db_mm].[pr_getpolistforpassing]
GO
/****** Object:  StoredProcedure [db_mm].[pr_getpolist]    Script Date: 1/15/2020 8:32:17 PM ******/
DROP PROCEDURE [db_mm].[pr_getpolist]
GO
/****** Object:  StoredProcedure [db_mm].[pr_getpodata]    Script Date: 1/15/2020 8:32:17 PM ******/
DROP PROCEDURE [db_mm].[pr_getpodata]
GO
/****** Object:  StoredProcedure [db_mm].[pr_getplanlist]    Script Date: 1/15/2020 8:32:17 PM ******/
DROP PROCEDURE [db_mm].[pr_getplanlist]
GO
/****** Object:  StoredProcedure [db_mm].[pr_getplandata]    Script Date: 1/15/2020 8:32:17 PM ******/
DROP PROCEDURE [db_mm].[pr_getplandata]
GO
/****** Object:  StoredProcedure [db_mm].[pr_getpendingreqn]    Script Date: 1/15/2020 8:32:17 PM ******/
DROP PROCEDURE [db_mm].[pr_getpendingreqn]
GO
/****** Object:  StoredProcedure [db_mm].[pr_getpaymentterms]    Script Date: 1/15/2020 8:32:17 PM ******/
DROP PROCEDURE [db_mm].[pr_getpaymentterms]
GO
/****** Object:  StoredProcedure [db_mm].[pr_getnrgplist]    Script Date: 1/15/2020 8:32:17 PM ******/
DROP PROCEDURE [db_mm].[pr_getnrgplist]
GO
/****** Object:  StoredProcedure [db_mm].[pr_getnrgpdata]    Script Date: 1/15/2020 8:32:17 PM ******/
DROP PROCEDURE [db_mm].[pr_getnrgpdata]
GO
/****** Object:  StoredProcedure [db_mm].[pr_getletterbanklist]    Script Date: 1/15/2020 8:32:17 PM ******/
DROP PROCEDURE [db_mm].[pr_getletterbanklist]
GO
/****** Object:  StoredProcedure [db_mm].[pr_getlaststktransferno]    Script Date: 1/15/2020 8:32:17 PM ******/
DROP PROCEDURE [db_mm].[pr_getlaststktransferno]
GO
/****** Object:  StoredProcedure [db_mm].[pr_getlastreqnno]    Script Date: 1/15/2020 8:32:17 PM ******/
DROP PROCEDURE [db_mm].[pr_getlastreqnno]
GO
/****** Object:  StoredProcedure [db_mm].[pr_getlastpono]    Script Date: 1/15/2020 8:32:17 PM ******/
DROP PROCEDURE [db_mm].[pr_getlastpono]
GO
/****** Object:  StoredProcedure [db_mm].[pr_getlastnrgpno]    Script Date: 1/15/2020 8:32:17 PM ******/
DROP PROCEDURE [db_mm].[pr_getlastnrgpno]
GO
/****** Object:  StoredProcedure [db_mm].[pr_getlastissuereturnno]    Script Date: 1/15/2020 8:32:17 PM ******/
DROP PROCEDURE [db_mm].[pr_getlastissuereturnno]
GO
/****** Object:  StoredProcedure [db_mm].[pr_getlastissuanceno]    Script Date: 1/15/2020 8:32:17 PM ******/
DROP PROCEDURE [db_mm].[pr_getlastissuanceno]
GO
/****** Object:  StoredProcedure [db_mm].[pr_getlastindentno]    Script Date: 1/15/2020 8:32:17 PM ******/
DROP PROCEDURE [db_mm].[pr_getlastindentno]
GO
/****** Object:  StoredProcedure [db_mm].[pr_getlastgrnno]    Script Date: 1/15/2020 8:32:17 PM ******/
DROP PROCEDURE [db_mm].[pr_getlastgrnno]
GO
/****** Object:  StoredProcedure [db_mm].[pr_getlastdprno]    Script Date: 1/15/2020 8:32:17 PM ******/
DROP PROCEDURE [db_mm].[pr_getlastdprno]
GO
/****** Object:  StoredProcedure [db_mm].[pr_getlastdestructionno]    Script Date: 1/15/2020 8:32:17 PM ******/
DROP PROCEDURE [db_mm].[pr_getlastdestructionno]
GO
/****** Object:  StoredProcedure [db_mm].[pr_getitemsuppliers]    Script Date: 1/15/2020 8:32:17 PM ******/
DROP PROCEDURE [db_mm].[pr_getitemsuppliers]
GO
/****** Object:  StoredProcedure [db_mm].[pr_getitemsforbombasereqn]    Script Date: 1/15/2020 8:32:17 PM ******/
DROP PROCEDURE [db_mm].[pr_getitemsforbombasereqn]
GO
/****** Object:  StoredProcedure [db_mm].[pr_getitemlistpo]    Script Date: 1/15/2020 8:32:17 PM ******/
DROP PROCEDURE [db_mm].[pr_getitemlistpo]
GO
/****** Object:  StoredProcedure [db_mm].[pr_getitemlistplan]    Script Date: 1/15/2020 8:32:17 PM ******/
DROP PROCEDURE [db_mm].[pr_getitemlistplan]
GO
/****** Object:  StoredProcedure [db_mm].[pr_getitemlistforiqc]    Script Date: 1/15/2020 8:32:17 PM ******/
DROP PROCEDURE [db_mm].[pr_getitemlistforiqc]
GO
/****** Object:  StoredProcedure [db_mm].[pr_getitemlistforgrnconfirmation]    Script Date: 1/15/2020 8:32:17 PM ******/
DROP PROCEDURE [db_mm].[pr_getitemlistforgrnconfirmation]
GO
/****** Object:  StoredProcedure [db_mm].[pr_getitemlistforbomindent]    Script Date: 1/15/2020 8:32:17 PM ******/
DROP PROCEDURE [db_mm].[pr_getitemlistforbomindent]
GO
/****** Object:  StoredProcedure [db_mm].[pr_getitemlistforbombasedrequisition]    Script Date: 1/15/2020 8:32:17 PM ******/
DROP PROCEDURE [db_mm].[pr_getitemlistforbombasedrequisition]
GO
/****** Object:  StoredProcedure [db_mm].[pr_getitemlist]    Script Date: 1/15/2020 8:32:17 PM ******/
DROP PROCEDURE [db_mm].[pr_getitemlist]
GO
/****** Object:  StoredProcedure [db_mm].[pr_getitemindents]    Script Date: 1/15/2020 8:32:17 PM ******/
DROP PROCEDURE [db_mm].[pr_getitemindents]
GO
/****** Object:  StoredProcedure [db_mm].[pr_getitemcategoryuserrights]    Script Date: 1/15/2020 8:32:17 PM ******/
DROP PROCEDURE [db_mm].[pr_getitemcategoryuserrights]
GO
/****** Object:  StoredProcedure [db_mm].[pr_getitemcategorylist]    Script Date: 1/15/2020 8:32:17 PM ******/
DROP PROCEDURE [db_mm].[pr_getitemcategorylist]
GO
/****** Object:  StoredProcedure [db_mm].[pr_getitemcategorydata]    Script Date: 1/15/2020 8:32:17 PM ******/
DROP PROCEDURE [db_mm].[pr_getitemcategorydata]
GO
/****** Object:  StoredProcedure [db_mm].[pr_getissuereturnlist]    Script Date: 1/15/2020 8:32:17 PM ******/
DROP PROCEDURE [db_mm].[pr_getissuereturnlist]
GO
/****** Object:  StoredProcedure [db_mm].[pr_getissuereturndata]    Script Date: 1/15/2020 8:32:17 PM ******/
DROP PROCEDURE [db_mm].[pr_getissuereturndata]
GO
/****** Object:  StoredProcedure [db_mm].[pr_getissuancelist]    Script Date: 1/15/2020 8:32:17 PM ******/
DROP PROCEDURE [db_mm].[pr_getissuancelist]
GO
/****** Object:  StoredProcedure [db_mm].[pr_getissuancedata]    Script Date: 1/15/2020 8:32:17 PM ******/
DROP PROCEDURE [db_mm].[pr_getissuancedata]
GO
/****** Object:  StoredProcedure [db_mm].[pr_getinwardnotelist]    Script Date: 1/15/2020 8:32:17 PM ******/
DROP PROCEDURE [db_mm].[pr_getinwardnotelist]
GO
/****** Object:  StoredProcedure [db_mm].[pr_getinwardnotedata]    Script Date: 1/15/2020 8:32:17 PM ******/
DROP PROCEDURE [db_mm].[pr_getinwardnotedata]
GO
/****** Object:  StoredProcedure [db_mm].[pr_getindentor]    Script Date: 1/15/2020 8:32:17 PM ******/
DROP PROCEDURE [db_mm].[pr_getindentor]
GO
/****** Object:  StoredProcedure [db_mm].[pr_getindentlist]    Script Date: 1/15/2020 8:32:17 PM ******/
DROP PROCEDURE [db_mm].[pr_getindentlist]
GO
/****** Object:  StoredProcedure [db_mm].[pr_getindentitems]    Script Date: 1/15/2020 8:32:17 PM ******/
DROP PROCEDURE [db_mm].[pr_getindentitems]
GO
/****** Object:  StoredProcedure [db_mm].[pr_getindentdetailforpassing]    Script Date: 1/15/2020 8:32:17 PM ******/
DROP PROCEDURE [db_mm].[pr_getindentdetailforpassing]
GO
/****** Object:  StoredProcedure [db_mm].[pr_getindentdeptandindenter]    Script Date: 1/15/2020 8:32:17 PM ******/
DROP PROCEDURE [db_mm].[pr_getindentdeptandindenter]
GO
/****** Object:  StoredProcedure [db_mm].[pr_getindentdata]    Script Date: 1/15/2020 8:32:17 PM ******/
DROP PROCEDURE [db_mm].[pr_getindentdata]
GO
/****** Object:  StoredProcedure [db_mm].[pr_gethsndata]    Script Date: 1/15/2020 8:32:17 PM ******/
DROP PROCEDURE [db_mm].[pr_gethsndata]
GO
/****** Object:  StoredProcedure [db_mm].[pr_getgstdata]    Script Date: 1/15/2020 8:32:17 PM ******/
DROP PROCEDURE [db_mm].[pr_getgstdata]
GO
/****** Object:  StoredProcedure [db_mm].[pr_getgrnlistforconfirmation]    Script Date: 1/15/2020 8:32:17 PM ******/
DROP PROCEDURE [db_mm].[pr_getgrnlistforconfirmation]
GO
/****** Object:  StoredProcedure [db_mm].[pr_getgrnlistforbillpassing]    Script Date: 1/15/2020 8:32:17 PM ******/
DROP PROCEDURE [db_mm].[pr_getgrnlistforbillpassing]
GO
/****** Object:  StoredProcedure [db_mm].[pr_getgrnlist]    Script Date: 1/15/2020 8:32:17 PM ******/
DROP PROCEDURE [db_mm].[pr_getgrnlist]
GO
/****** Object:  StoredProcedure [db_mm].[pr_getgrndata]    Script Date: 1/15/2020 8:32:17 PM ******/
DROP PROCEDURE [db_mm].[pr_getgrndata]
GO
/****** Object:  StoredProcedure [db_mm].[pr_getgrncategory]    Script Date: 1/15/2020 8:32:17 PM ******/
DROP PROCEDURE [db_mm].[pr_getgrncategory]
GO
/****** Object:  StoredProcedure [db_mm].[pr_getenqstatus]    Script Date: 1/15/2020 8:32:17 PM ******/
DROP PROCEDURE [db_mm].[pr_getenqstatus]
GO
/****** Object:  StoredProcedure [db_mm].[pr_getdrcrnoteforbillpassing]    Script Date: 1/15/2020 8:32:17 PM ******/
DROP PROCEDURE [db_mm].[pr_getdrcrnoteforbillpassing]
GO
/****** Object:  StoredProcedure [db_mm].[pr_getdprlist]    Script Date: 1/15/2020 8:32:17 PM ******/
DROP PROCEDURE [db_mm].[pr_getdprlist]
GO
/****** Object:  StoredProcedure [db_mm].[pr_getdprdata]    Script Date: 1/15/2020 8:32:17 PM ******/
DROP PROCEDURE [db_mm].[pr_getdprdata]
GO
/****** Object:  StoredProcedure [db_mm].[pr_getdestructionList]    Script Date: 1/15/2020 8:32:17 PM ******/
DROP PROCEDURE [db_mm].[pr_getdestructionList]
GO
/****** Object:  StoredProcedure [db_mm].[pr_getdestructiondata]    Script Date: 1/15/2020 8:32:18 PM ******/
DROP PROCEDURE [db_mm].[pr_getdestructiondata]
GO
/****** Object:  StoredProcedure [db_mm].[pr_getdeptwisereservedstock]    Script Date: 1/15/2020 8:32:18 PM ******/
DROP PROCEDURE [db_mm].[pr_getdeptwisereservedstock]
GO
/****** Object:  StoredProcedure [db_mm].[pr_getdepartment]    Script Date: 1/15/2020 8:32:18 PM ******/
DROP PROCEDURE [db_mm].[pr_getdepartment]
GO
/****** Object:  StoredProcedure [db_mm].[pr_getcostcentre]    Script Date: 1/15/2020 8:32:18 PM ******/
DROP PROCEDURE [db_mm].[pr_getcostcentre]
GO
/****** Object:  StoredProcedure [db_mm].[pr_getcompanybranches]    Script Date: 1/15/2020 8:32:18 PM ******/
DROP PROCEDURE [db_mm].[pr_getcompanybranches]
GO
/****** Object:  StoredProcedure [db_mm].[pr_getcommanapireport]    Script Date: 1/15/2020 8:32:18 PM ******/
DROP PROCEDURE [db_mm].[pr_getcommanapireport]
GO
/****** Object:  StoredProcedure [db_mm].[pr_getbrandlist]    Script Date: 1/15/2020 8:32:18 PM ******/
DROP PROCEDURE [db_mm].[pr_getbrandlist]
GO
/****** Object:  StoredProcedure [db_mm].[pr_getbomversion]    Script Date: 1/15/2020 8:32:18 PM ******/
DROP PROCEDURE [db_mm].[pr_getbomversion]
GO
/****** Object:  StoredProcedure [db_mm].[pr_getbomlist]    Script Date: 1/15/2020 8:32:18 PM ******/
DROP PROCEDURE [db_mm].[pr_getbomlist]
GO
/****** Object:  StoredProcedure [db_mm].[pr_getbomdata]    Script Date: 1/15/2020 8:32:18 PM ******/
DROP PROCEDURE [db_mm].[pr_getbomdata]
GO
/****** Object:  StoredProcedure [db_mm].[pr_get_standard_customized_bomlist]    Script Date: 1/15/2020 8:32:18 PM ******/
DROP PROCEDURE [db_mm].[pr_get_standard_customized_bomlist]
GO
/****** Object:  StoredProcedure [db_mm].[pr_generatepoforVAL]    Script Date: 1/15/2020 8:32:18 PM ******/
DROP PROCEDURE [db_mm].[pr_generatepoforVAL]
GO
/****** Object:  StoredProcedure [db_mm].[pr_explodeBOM_bomid_wise]    Script Date: 1/15/2020 8:32:18 PM ******/
DROP PROCEDURE [db_mm].[pr_explodeBOM_bomid_wise]
GO
/****** Object:  StoredProcedure [db_mm].[pr_explodeBOM]    Script Date: 1/15/2020 8:32:18 PM ******/
DROP PROCEDURE [db_mm].[pr_explodeBOM]
GO
/****** Object:  StoredProcedure [db_mm].[pr_explod_bom_only_subassbly]    Script Date: 1/15/2020 8:32:18 PM ******/
DROP PROCEDURE [db_mm].[pr_explod_bom_only_subassbly]
GO
/****** Object:  StoredProcedure [db_mm].[pr_copycustbom]    Script Date: 1/15/2020 8:32:18 PM ******/
DROP PROCEDURE [db_mm].[pr_copycustbom]
GO
/****** Object:  StoredProcedure [db_mm].[pr_copybom]    Script Date: 1/15/2020 8:32:18 PM ******/
DROP PROCEDURE [db_mm].[pr_copybom]
GO
/****** Object:  StoredProcedure [db_mm].[pr_confirmvendorallocationlist]    Script Date: 1/15/2020 8:32:18 PM ******/
DROP PROCEDURE [db_mm].[pr_confirmvendorallocationlist]
GO
/****** Object:  StoredProcedure [db_mm].[pr_commonapirgp]    Script Date: 1/15/2020 8:32:18 PM ******/
DROP PROCEDURE [db_mm].[pr_commonapirgp]
GO
/****** Object:  StoredProcedure [db_mm].[pr_commonapirequisition]    Script Date: 1/15/2020 8:32:18 PM ******/
DROP PROCEDURE [db_mm].[pr_commonapirequisition]
GO
/****** Object:  StoredProcedure [db_mm].[pr_commonapipurchaseorder]    Script Date: 1/15/2020 8:32:18 PM ******/
DROP PROCEDURE [db_mm].[pr_commonapipurchaseorder]
GO
/****** Object:  StoredProcedure [db_mm].[pr_commonapinrgp]    Script Date: 1/15/2020 8:32:18 PM ******/
DROP PROCEDURE [db_mm].[pr_commonapinrgp]
GO
/****** Object:  StoredProcedure [db_mm].[pr_commonapiitemmaster]    Script Date: 1/15/2020 8:32:18 PM ******/
DROP PROCEDURE [db_mm].[pr_commonapiitemmaster]
GO
/****** Object:  StoredProcedure [db_mm].[pr_commonapiitemlist]    Script Date: 1/15/2020 8:32:18 PM ******/
DROP PROCEDURE [db_mm].[pr_commonapiitemlist]
GO
/****** Object:  StoredProcedure [db_mm].[pr_commonapiitemcategoryrights]    Script Date: 1/15/2020 8:32:18 PM ******/
DROP PROCEDURE [db_mm].[pr_commonapiitemcategoryrights]
GO
/****** Object:  StoredProcedure [db_mm].[pr_commonapiindent]    Script Date: 1/15/2020 8:32:18 PM ******/
DROP PROCEDURE [db_mm].[pr_commonapiindent]
GO
/****** Object:  StoredProcedure [db_mm].[pr_commonapigrn]    Script Date: 1/15/2020 8:32:18 PM ******/
DROP PROCEDURE [db_mm].[pr_commonapigrn]
GO
/****** Object:  StoredProcedure [db_mm].[pr_commonapidpr]    Script Date: 1/15/2020 8:32:18 PM ******/
DROP PROCEDURE [db_mm].[pr_commonapidpr]
GO
/****** Object:  StoredProcedure [db_mm].[pr_commonapibom]    Script Date: 1/15/2020 8:32:18 PM ******/
DROP PROCEDURE [db_mm].[pr_commonapibom]
GO
/****** Object:  StoredProcedure [db_mm].[pr_checksupplierbillno]    Script Date: 1/15/2020 8:32:18 PM ******/
DROP PROCEDURE [db_mm].[pr_checksupplierbillno]
GO
/****** Object:  StoredProcedure [db_mm].[pr_cancelpendingreqn]    Script Date: 1/15/2020 8:32:18 PM ******/
DROP PROCEDURE [db_mm].[pr_cancelpendingreqn]
GO
/****** Object:  StoredProcedure [db_mm].[pr_advicegenerationshortage]    Script Date: 1/15/2020 8:32:18 PM ******/
DROP PROCEDURE [db_mm].[pr_advicegenerationshortage]
GO
/****** Object:  StoredProcedure [db_mm].[pr_advicegenerationrejection]    Script Date: 1/15/2020 8:32:18 PM ******/
DROP PROCEDURE [db_mm].[pr_advicegenerationrejection]
GO
/****** Object:  StoredProcedure [db_mm].[pr_advicegenerationratediffdr]    Script Date: 1/15/2020 8:32:18 PM ******/
DROP PROCEDURE [db_mm].[pr_advicegenerationratediffdr]
GO
/****** Object:  StoredProcedure [db_mm].[pogrossrequirement]    Script Date: 1/15/2020 8:32:18 PM ******/
DROP PROCEDURE [db_mm].[pogrossrequirement]
GO
/****** Object:  StoredProcedure [db_mktg].[reports_quoteregister]    Script Date: 1/15/2020 8:32:18 PM ******/
DROP PROCEDURE [db_mktg].[reports_quoteregister]
GO
/****** Object:  StoredProcedure [db_mktg].[reports_marketingregister]    Script Date: 1/15/2020 8:32:18 PM ******/
DROP PROCEDURE [db_mktg].[reports_marketingregister]
GO
/****** Object:  StoredProcedure [db_mktg].[reports_enquiryregister]    Script Date: 1/15/2020 8:32:18 PM ******/
DROP PROCEDURE [db_mktg].[reports_enquiryregister]
GO
/****** Object:  StoredProcedure [db_mktg].[pr_savetenderitemmaster]    Script Date: 1/15/2020 8:32:18 PM ******/
DROP PROCEDURE [db_mktg].[pr_savetenderitemmaster]
GO
/****** Object:  StoredProcedure [db_mktg].[pr_saverejectreason]    Script Date: 1/15/2020 8:32:18 PM ******/
DROP PROCEDURE [db_mktg].[pr_saverejectreason]
GO
/****** Object:  StoredProcedure [db_mktg].[pr_savequoteuploadinfo]    Script Date: 1/15/2020 8:32:18 PM ******/
DROP PROCEDURE [db_mktg].[pr_savequoteuploadinfo]
GO
/****** Object:  StoredProcedure [db_mktg].[pr_savequotefollowup]    Script Date: 1/15/2020 8:32:18 PM ******/
DROP PROCEDURE [db_mktg].[pr_savequotefollowup]
GO
/****** Object:  StoredProcedure [db_mktg].[pr_savequoteactions]    Script Date: 1/15/2020 8:32:18 PM ******/
DROP PROCEDURE [db_mktg].[pr_savequoteactions]
GO
/****** Object:  StoredProcedure [db_mktg].[pr_savequote_pi]    Script Date: 1/15/2020 8:32:18 PM ******/
DROP PROCEDURE [db_mktg].[pr_savequote_pi]
GO
/****** Object:  StoredProcedure [db_mktg].[pr_savequotation]    Script Date: 1/15/2020 8:32:18 PM ******/
DROP PROCEDURE [db_mktg].[pr_savequotation]
GO
/****** Object:  StoredProcedure [db_mktg].[pr_saveIntimationto]    Script Date: 1/15/2020 8:32:18 PM ******/
DROP PROCEDURE [db_mktg].[pr_saveIntimationto]
GO
/****** Object:  StoredProcedure [db_mktg].[pr_saveholdreason]    Script Date: 1/15/2020 8:32:18 PM ******/
DROP PROCEDURE [db_mktg].[pr_saveholdreason]
GO
/****** Object:  StoredProcedure [db_mktg].[pr_savefwdtodept]    Script Date: 1/15/2020 8:32:18 PM ******/
DROP PROCEDURE [db_mktg].[pr_savefwdtodept]
GO
/****** Object:  StoredProcedure [db_mktg].[pr_savefwdtodealer]    Script Date: 1/15/2020 8:32:18 PM ******/
DROP PROCEDURE [db_mktg].[pr_savefwdtodealer]
GO
/****** Object:  StoredProcedure [db_mktg].[pr_saveenquirytoquote]    Script Date: 1/15/2020 8:32:18 PM ******/
DROP PROCEDURE [db_mktg].[pr_saveenquirytoquote]
GO
/****** Object:  StoredProcedure [db_mktg].[pr_saveenquirycategoryrights]    Script Date: 1/15/2020 8:32:18 PM ******/
DROP PROCEDURE [db_mktg].[pr_saveenquirycategoryrights]
GO
/****** Object:  StoredProcedure [db_mktg].[pr_saveenquiry]    Script Date: 1/15/2020 8:32:18 PM ******/
DROP PROCEDURE [db_mktg].[pr_saveenquiry]
GO
/****** Object:  StoredProcedure [db_mktg].[pr_saveenqfollowup]    Script Date: 1/15/2020 8:32:18 PM ******/
DROP PROCEDURE [db_mktg].[pr_saveenqfollowup]
GO
/****** Object:  StoredProcedure [db_mktg].[pr_saveenqactions]    Script Date: 1/15/2020 8:32:18 PM ******/
DROP PROCEDURE [db_mktg].[pr_saveenqactions]
GO
/****** Object:  StoredProcedure [db_mktg].[pr_save_quote_pi]    Script Date: 1/15/2020 8:32:18 PM ******/
DROP PROCEDURE [db_mktg].[pr_save_quote_pi]
GO
/****** Object:  StoredProcedure [db_mktg].[pr_revisedprintcustomerinvoice]    Script Date: 1/15/2020 8:32:18 PM ******/
DROP PROCEDURE [db_mktg].[pr_revisedprintcustomerinvoice]
GO
/****** Object:  StoredProcedure [db_mktg].[pr_report_commanapiformarketing]    Script Date: 1/15/2020 8:32:18 PM ******/
DROP PROCEDURE [db_mktg].[pr_report_commanapiformarketing]
GO
/****** Object:  StoredProcedure [db_mktg].[pr_printquoterevisedprint]    Script Date: 1/15/2020 8:32:18 PM ******/
DROP PROCEDURE [db_mktg].[pr_printquoterevisedprint]
GO
/****** Object:  StoredProcedure [db_mktg].[pr_printquoteprint]    Script Date: 1/15/2020 8:32:18 PM ******/
DROP PROCEDURE [db_mktg].[pr_printquoteprint]
GO
/****** Object:  StoredProcedure [db_mktg].[pr_printcustomerinvoice]    Script Date: 1/15/2020 8:32:18 PM ******/
DROP PROCEDURE [db_mktg].[pr_printcustomerinvoice]
GO
/****** Object:  StoredProcedure [db_mktg].[pr_marketingterms]    Script Date: 1/15/2020 8:32:18 PM ******/
DROP PROCEDURE [db_mktg].[pr_marketingterms]
GO
/****** Object:  StoredProcedure [db_mktg].[pr_gettermsandcondition]    Script Date: 1/15/2020 8:32:18 PM ******/
DROP PROCEDURE [db_mktg].[pr_gettermsandcondition]
GO
/****** Object:  StoredProcedure [db_mktg].[pr_getstatuslist]    Script Date: 1/15/2020 8:32:18 PM ******/
DROP PROCEDURE [db_mktg].[pr_getstatuslist]
GO
/****** Object:  StoredProcedure [db_mktg].[pr_getrevisedpidata]    Script Date: 1/15/2020 8:32:18 PM ******/
DROP PROCEDURE [db_mktg].[pr_getrevisedpidata]
GO
/****** Object:  StoredProcedure [db_mktg].[pr_getreviseddata]    Script Date: 1/15/2020 8:32:18 PM ******/
DROP PROCEDURE [db_mktg].[pr_getreviseddata]
GO
/****** Object:  StoredProcedure [db_mktg].[pr_getresumedetails]    Script Date: 1/15/2020 8:32:18 PM ******/
DROP PROCEDURE [db_mktg].[pr_getresumedetails]
GO
/****** Object:  StoredProcedure [db_mktg].[pr_getquotepidata]    Script Date: 1/15/2020 8:32:18 PM ******/
DROP PROCEDURE [db_mktg].[pr_getquotepidata]
GO
/****** Object:  StoredProcedure [db_mktg].[pr_getQuoteinvoicelist]    Script Date: 1/15/2020 8:32:18 PM ******/
DROP PROCEDURE [db_mktg].[pr_getQuoteinvoicelist]
GO
/****** Object:  StoredProcedure [db_mktg].[pr_getquotefollowuplist]    Script Date: 1/15/2020 8:32:18 PM ******/
DROP PROCEDURE [db_mktg].[pr_getquotefollowuplist]
GO
/****** Object:  StoredProcedure [db_mktg].[pr_getQuotationlist]    Script Date: 1/15/2020 8:32:18 PM ******/
DROP PROCEDURE [db_mktg].[pr_getQuotationlist]
GO
/****** Object:  StoredProcedure [db_mktg].[pr_getquotationdata]    Script Date: 1/15/2020 8:32:18 PM ******/
DROP PROCEDURE [db_mktg].[pr_getquotationdata]
GO
/****** Object:  StoredProcedure [db_mktg].[pr_getinvoicedata]    Script Date: 1/15/2020 8:32:18 PM ******/
DROP PROCEDURE [db_mktg].[pr_getinvoicedata]
GO
/****** Object:  StoredProcedure [db_mktg].[pr_getenquirylist]    Script Date: 1/15/2020 8:32:18 PM ******/
DROP PROCEDURE [db_mktg].[pr_getenquirylist]
GO
/****** Object:  StoredProcedure [db_mktg].[pr_getenquirydata]    Script Date: 1/15/2020 8:32:18 PM ******/
DROP PROCEDURE [db_mktg].[pr_getenquirydata]
GO
/****** Object:  StoredProcedure [db_mktg].[pr_getenquiryactions]    Script Date: 1/15/2020 8:32:18 PM ******/
DROP PROCEDURE [db_mktg].[pr_getenquiryactions]
GO
/****** Object:  StoredProcedure [db_mktg].[pr_getenqstatus]    Script Date: 1/15/2020 8:32:18 PM ******/
DROP PROCEDURE [db_mktg].[pr_getenqstatus]
GO
/****** Object:  StoredProcedure [db_mktg].[pr_getenqphoneoremailwise]    Script Date: 1/15/2020 8:32:18 PM ******/
DROP PROCEDURE [db_mktg].[pr_getenqphoneoremailwise]
GO
/****** Object:  StoredProcedure [db_mktg].[pr_getenqfollowuplist]    Script Date: 1/15/2020 8:32:18 PM ******/
DROP PROCEDURE [db_mktg].[pr_getenqfollowuplist]
GO
/****** Object:  StoredProcedure [db_mktg].[pr_getenqfollowup]    Script Date: 1/15/2020 8:32:18 PM ******/
DROP PROCEDURE [db_mktg].[pr_getenqfollowup]
GO
/****** Object:  StoredProcedure [db_mktg].[pr_getcustomerorprspect]    Script Date: 1/15/2020 8:32:18 PM ******/
DROP PROCEDURE [db_mktg].[pr_getcustomerorprspect]
GO
/****** Object:  StoredProcedure [db_mktg].[pr_getbsegmentchild]    Script Date: 1/15/2020 8:32:18 PM ******/
DROP PROCEDURE [db_mktg].[pr_getbsegmentchild]
GO
/****** Object:  StoredProcedure [db_mktg].[pr_convertquotetoorder]    Script Date: 1/15/2020 8:32:18 PM ******/
DROP PROCEDURE [db_mktg].[pr_convertquotetoorder]
GO
/****** Object:  StoredProcedure [db_mktg].[pr_convertquote_to_pi]    Script Date: 1/15/2020 8:32:18 PM ******/
DROP PROCEDURE [db_mktg].[pr_convertquote_to_pi]
GO
/****** Object:  StoredProcedure [db_mktg].[pr_commonapiquote]    Script Date: 1/15/2020 8:32:18 PM ******/
DROP PROCEDURE [db_mktg].[pr_commonapiquote]
GO
/****** Object:  StoredProcedure [db_mktg].[pr_commonapienquirycategoryrights]    Script Date: 1/15/2020 8:32:18 PM ******/
DROP PROCEDURE [db_mktg].[pr_commonapienquirycategoryrights]
GO
/****** Object:  StoredProcedure [db_mktg].[pr_commonapienq]    Script Date: 1/15/2020 8:32:18 PM ******/
DROP PROCEDURE [db_mktg].[pr_commonapienq]
GO
/****** Object:  StoredProcedure [db_mktg].[pr_commonapi_quotepi]    Script Date: 1/15/2020 8:32:18 PM ******/
DROP PROCEDURE [db_mktg].[pr_commonapi_quotepi]
GO
/****** Object:  StoredProcedure [db_mktg].[pr_checkquoteactions]    Script Date: 1/15/2020 8:32:18 PM ******/
DROP PROCEDURE [db_mktg].[pr_checkquoteactions]
GO
/****** Object:  StoredProcedure [db_mktg].[pr_checkenquiryactions]    Script Date: 1/15/2020 8:32:18 PM ******/
DROP PROCEDURE [db_mktg].[pr_checkenquiryactions]
GO
/****** Object:  StoredProcedure [db_mktg].[pr_checkduplicate_customer_prospect_supplier_emailphone]    Script Date: 1/15/2020 8:32:18 PM ******/
DROP PROCEDURE [db_mktg].[pr_checkduplicate_customer_prospect_supplier_emailphone]
GO
/****** Object:  StoredProcedure [db_mktg].[pr_changestatus]    Script Date: 1/15/2020 8:32:18 PM ******/
DROP PROCEDURE [db_mktg].[pr_changestatus]
GO
/****** Object:  StoredProcedure [db_masters].[pr_vouchercategory]    Script Date: 1/15/2020 8:32:18 PM ******/
DROP PROCEDURE [db_masters].[pr_vouchercategory]
GO
/****** Object:  StoredProcedure [db_masters].[pr_saveuser]    Script Date: 1/15/2020 8:32:18 PM ******/
DROP PROCEDURE [db_masters].[pr_saveuser]
GO
/****** Object:  StoredProcedure [db_masters].[pr_savesupplier]    Script Date: 1/15/2020 8:32:18 PM ******/
DROP PROCEDURE [db_masters].[pr_savesupplier]
GO
/****** Object:  StoredProcedure [db_masters].[pr_savestatus]    Script Date: 1/15/2020 8:32:19 PM ******/
DROP PROCEDURE [db_masters].[pr_savestatus]
GO
/****** Object:  StoredProcedure [db_masters].[pr_saveprospetoctcustomer]    Script Date: 1/15/2020 8:32:19 PM ******/
DROP PROCEDURE [db_masters].[pr_saveprospetoctcustomer]
GO
/****** Object:  StoredProcedure [db_masters].[pr_saveprospectcustomer]    Script Date: 1/15/2020 8:32:19 PM ******/
DROP PROCEDURE [db_masters].[pr_saveprospectcustomer]
GO
/****** Object:  StoredProcedure [db_masters].[pr_SavePODetails]    Script Date: 1/15/2020 8:32:19 PM ******/
DROP PROCEDURE [db_masters].[pr_SavePODetails]
GO
/****** Object:  StoredProcedure [db_masters].[pr_Savemst_machine]    Script Date: 1/15/2020 8:32:19 PM ******/
DROP PROCEDURE [db_masters].[pr_Savemst_machine]
GO
/****** Object:  StoredProcedure [db_masters].[pr_savemodel]    Script Date: 1/15/2020 8:32:19 PM ******/
DROP PROCEDURE [db_masters].[pr_savemodel]
GO
/****** Object:  StoredProcedure [db_masters].[pr_saveitemmaster]    Script Date: 1/15/2020 8:32:19 PM ******/
DROP PROCEDURE [db_masters].[pr_saveitemmaster]
GO
/****** Object:  StoredProcedure [db_masters].[pr_saveemployee]    Script Date: 1/15/2020 8:32:19 PM ******/
DROP PROCEDURE [db_masters].[pr_saveemployee]
GO
/****** Object:  StoredProcedure [db_masters].[pr_savedoctitle]    Script Date: 1/15/2020 8:32:19 PM ******/
DROP PROCEDURE [db_masters].[pr_savedoctitle]
GO
/****** Object:  StoredProcedure [db_masters].[pr_savedocsubject]    Script Date: 1/15/2020 8:32:19 PM ******/
DROP PROCEDURE [db_masters].[pr_savedocsubject]
GO
/****** Object:  StoredProcedure [db_masters].[pr_savecustomer]    Script Date: 1/15/2020 8:32:19 PM ******/
DROP PROCEDURE [db_masters].[pr_savecustomer]
GO
/****** Object:  StoredProcedure [db_masters].[pr_savecountrymaster]    Script Date: 1/15/2020 8:32:19 PM ******/
DROP PROCEDURE [db_masters].[pr_savecountrymaster]
GO
/****** Object:  StoredProcedure [db_masters].[pr_purchaseaccounts]    Script Date: 1/15/2020 8:32:19 PM ******/
DROP PROCEDURE [db_masters].[pr_purchaseaccounts]
GO
/****** Object:  StoredProcedure [db_masters].[pr_getZoneList]    Script Date: 1/15/2020 8:32:19 PM ******/
DROP PROCEDURE [db_masters].[pr_getZoneList]
GO
/****** Object:  StoredProcedure [db_masters].[pr_getVoucherCategories]    Script Date: 1/15/2020 8:32:19 PM ******/
DROP PROCEDURE [db_masters].[pr_getVoucherCategories]
GO
/****** Object:  StoredProcedure [db_masters].[pr_getSuplierData]    Script Date: 1/15/2020 8:32:19 PM ******/
DROP PROCEDURE [db_masters].[pr_getSuplierData]
GO
/****** Object:  StoredProcedure [db_masters].[pr_getSuplierContactInfox]    Script Date: 1/15/2020 8:32:19 PM ******/
DROP PROCEDURE [db_masters].[pr_getSuplierContactInfox]
GO
/****** Object:  StoredProcedure [db_masters].[pr_getStateList]    Script Date: 1/15/2020 8:32:19 PM ******/
DROP PROCEDURE [db_masters].[pr_getStateList]
GO
/****** Object:  StoredProcedure [db_masters].[pr_getRegionList]    Script Date: 1/15/2020 8:32:19 PM ******/
DROP PROCEDURE [db_masters].[pr_getRegionList]
GO
/****** Object:  StoredProcedure [db_masters].[pr_getquotebusinesssegmentlist]    Script Date: 1/15/2020 8:32:19 PM ******/
DROP PROCEDURE [db_masters].[pr_getquotebusinesssegmentlist]
GO
/****** Object:  StoredProcedure [db_masters].[pr_getprospectcustomerData]    Script Date: 1/15/2020 8:32:19 PM ******/
DROP PROCEDURE [db_masters].[pr_getprospectcustomerData]
GO
/****** Object:  StoredProcedure [db_masters].[pr_getmst_machineData]    Script Date: 1/15/2020 8:32:19 PM ******/
DROP PROCEDURE [db_masters].[pr_getmst_machineData]
GO
/****** Object:  StoredProcedure [db_masters].[pr_getModel]    Script Date: 1/15/2020 8:32:19 PM ******/
DROP PROCEDURE [db_masters].[pr_getModel]
GO
/****** Object:  StoredProcedure [db_masters].[pr_getmake]    Script Date: 1/15/2020 8:32:19 PM ******/
DROP PROCEDURE [db_masters].[pr_getmake]
GO
/****** Object:  StoredProcedure [db_masters].[pr_getitemuom]    Script Date: 1/15/2020 8:32:19 PM ******/
DROP PROCEDURE [db_masters].[pr_getitemuom]
GO
/****** Object:  StoredProcedure [db_masters].[pr_getitemtype]    Script Date: 1/15/2020 8:32:19 PM ******/
DROP PROCEDURE [db_masters].[pr_getitemtype]
GO
/****** Object:  StoredProcedure [db_masters].[pr_getitemlist]    Script Date: 1/15/2020 8:32:19 PM ******/
DROP PROCEDURE [db_masters].[pr_getitemlist]
GO
/****** Object:  StoredProcedure [db_masters].[pr_getitemdata]    Script Date: 1/15/2020 8:32:19 PM ******/
DROP PROCEDURE [db_masters].[pr_getitemdata]
GO
/****** Object:  StoredProcedure [db_masters].[pr_getitemcategorylist]    Script Date: 1/15/2020 8:32:19 PM ******/
DROP PROCEDURE [db_masters].[pr_getitemcategorylist]
GO
/****** Object:  StoredProcedure [db_masters].[pr_getitembrands]    Script Date: 1/15/2020 8:32:19 PM ******/
DROP PROCEDURE [db_masters].[pr_getitembrands]
GO
/****** Object:  StoredProcedure [db_masters].[pr_gethsnlist]    Script Date: 1/15/2020 8:32:19 PM ******/
DROP PROCEDURE [db_masters].[pr_gethsnlist]
GO
/****** Object:  StoredProcedure [db_masters].[pr_getgstlist]    Script Date: 1/15/2020 8:32:19 PM ******/
DROP PROCEDURE [db_masters].[pr_getgstlist]
GO
/****** Object:  StoredProcedure [db_masters].[pr_geterpmodules]    Script Date: 1/15/2020 8:32:19 PM ******/
DROP PROCEDURE [db_masters].[pr_geterpmodules]
GO
/****** Object:  StoredProcedure [db_masters].[pr_getemployeelist]    Script Date: 1/15/2020 8:32:19 PM ******/
DROP PROCEDURE [db_masters].[pr_getemployeelist]
GO
/****** Object:  StoredProcedure [db_masters].[pr_getemployeedata]    Script Date: 1/15/2020 8:32:19 PM ******/
DROP PROCEDURE [db_masters].[pr_getemployeedata]
GO
/****** Object:  StoredProcedure [db_masters].[pr_getDesignation]    Script Date: 1/15/2020 8:32:19 PM ******/
DROP PROCEDURE [db_masters].[pr_getDesignation]
GO
/****** Object:  StoredProcedure [db_masters].[pr_getDepartments]    Script Date: 1/15/2020 8:32:19 PM ******/
DROP PROCEDURE [db_masters].[pr_getDepartments]
GO
/****** Object:  StoredProcedure [db_masters].[pr_getcustomerData]    Script Date: 1/15/2020 8:32:19 PM ******/
DROP PROCEDURE [db_masters].[pr_getcustomerData]
GO
/****** Object:  StoredProcedure [db_masters].[pr_Getcommonapiformakeandmodel]    Script Date: 1/15/2020 8:32:19 PM ******/
DROP PROCEDURE [db_masters].[pr_Getcommonapiformakeandmodel]
GO
/****** Object:  StoredProcedure [db_masters].[pr_Getcommonapiformachinemasterjobcard]    Script Date: 1/15/2020 8:32:19 PM ******/
DROP PROCEDURE [db_masters].[pr_Getcommonapiformachinemasterjobcard]
GO
/****** Object:  StoredProcedure [db_masters].[pr_Getcommonapiformachinemaster]    Script Date: 1/15/2020 8:32:19 PM ******/
DROP PROCEDURE [db_masters].[pr_Getcommonapiformachinemaster]
GO
/****** Object:  StoredProcedure [db_masters].[pr_getbusinesssegmentlist]    Script Date: 1/15/2020 8:32:19 PM ******/
DROP PROCEDURE [db_masters].[pr_getbusinesssegmentlist]
GO
/****** Object:  StoredProcedure [db_masters].[pr_getbusinesssegment]    Script Date: 1/15/2020 8:32:19 PM ******/
DROP PROCEDURE [db_masters].[pr_getbusinesssegment]
GO
/****** Object:  StoredProcedure [db_masters].[pr_getbomitems]    Script Date: 1/15/2020 8:32:19 PM ******/
DROP PROCEDURE [db_masters].[pr_getbomitems]
GO
/****** Object:  StoredProcedure [db_masters].[pr_getAreaList]    Script Date: 1/15/2020 8:32:19 PM ******/
DROP PROCEDURE [db_masters].[pr_getAreaList]
GO
/****** Object:  StoredProcedure [db_masters].[pr_getAllUsers]    Script Date: 1/15/2020 8:32:19 PM ******/
DROP PROCEDURE [db_masters].[pr_getAllUsers]
GO
/****** Object:  StoredProcedure [db_masters].[pr_getAllSupliersList]    Script Date: 1/15/2020 8:32:19 PM ******/
DROP PROCEDURE [db_masters].[pr_getAllSupliersList]
GO
/****** Object:  StoredProcedure [db_masters].[pr_getAllSupliersCategoryList]    Script Date: 1/15/2020 8:32:19 PM ******/
DROP PROCEDURE [db_masters].[pr_getAllSupliersCategoryList]
GO
/****** Object:  StoredProcedure [db_masters].[pr_getAllprospectList]    Script Date: 1/15/2020 8:32:19 PM ******/
DROP PROCEDURE [db_masters].[pr_getAllprospectList]
GO
/****** Object:  StoredProcedure [db_masters].[pr_getAllmst_machineList]    Script Date: 1/15/2020 8:32:19 PM ******/
DROP PROCEDURE [db_masters].[pr_getAllmst_machineList]
GO
/****** Object:  StoredProcedure [db_masters].[pr_getAllCustomerList]    Script Date: 1/15/2020 8:32:19 PM ******/
DROP PROCEDURE [db_masters].[pr_getAllCustomerList]
GO
/****** Object:  StoredProcedure [db_masters].[pr_getAllCustomerCategoryList]    Script Date: 1/15/2020 8:32:19 PM ******/
DROP PROCEDURE [db_masters].[pr_getAllCustomerCategoryList]
GO
/****** Object:  StoredProcedure [db_masters].[pr_getAllCurrencies]    Script Date: 1/15/2020 8:32:19 PM ******/
DROP PROCEDURE [db_masters].[pr_getAllCurrencies]
GO
/****** Object:  StoredProcedure [db_masters].[pr_getAllCountry]    Script Date: 1/15/2020 8:32:19 PM ******/
DROP PROCEDURE [db_masters].[pr_getAllCountry]
GO
/****** Object:  StoredProcedure [db_masters].[pr_getAllCity]    Script Date: 1/15/2020 8:32:19 PM ******/
DROP PROCEDURE [db_masters].[pr_getAllCity]
GO
/****** Object:  StoredProcedure [db_masters].[pr_getAllBank]    Script Date: 1/15/2020 8:32:19 PM ******/
DROP PROCEDURE [db_masters].[pr_getAllBank]
GO
/****** Object:  StoredProcedure [db_masters].[pr_commonapiletters]    Script Date: 1/15/2020 8:32:19 PM ******/
DROP PROCEDURE [db_masters].[pr_commonapiletters]
GO
/****** Object:  StoredProcedure [db_masters].[pr_commonapiemployee]    Script Date: 1/15/2020 8:32:19 PM ******/
DROP PROCEDURE [db_masters].[pr_commonapiemployee]
GO
/****** Object:  StoredProcedure [db_masters].[pr_commonapi_Usermst]    Script Date: 1/15/2020 8:32:19 PM ******/
DROP PROCEDURE [db_masters].[pr_commonapi_Usermst]
GO
/****** Object:  StoredProcedure [db_hr].[prgetresumelist]    Script Date: 1/15/2020 8:32:19 PM ******/
DROP PROCEDURE [db_hr].[prgetresumelist]
GO
/****** Object:  StoredProcedure [db_hr].[pr_updateresumestatus]    Script Date: 1/15/2020 8:32:19 PM ******/
DROP PROCEDURE [db_hr].[pr_updateresumestatus]
GO
/****** Object:  StoredProcedure [db_hr].[pr_savetrainingcalender]    Script Date: 1/15/2020 8:32:19 PM ******/
DROP PROCEDURE [db_hr].[pr_savetrainingcalender]
GO
/****** Object:  StoredProcedure [db_hr].[pr_saveresumeuploadinfo]    Script Date: 1/15/2020 8:32:19 PM ******/
DROP PROCEDURE [db_hr].[pr_saveresumeuploadinfo]
GO
/****** Object:  StoredProcedure [db_hr].[pr_saveresumequalification]    Script Date: 1/15/2020 8:32:19 PM ******/
DROP PROCEDURE [db_hr].[pr_saveresumequalification]
GO
/****** Object:  StoredProcedure [db_hr].[pr_saveresumeexperience]    Script Date: 1/15/2020 8:32:19 PM ******/
DROP PROCEDURE [db_hr].[pr_saveresumeexperience]
GO
/****** Object:  StoredProcedure [db_hr].[pr_savehdrresume]    Script Date: 1/15/2020 8:32:19 PM ******/
DROP PROCEDURE [db_hr].[pr_savehdrresume]
GO
/****** Object:  StoredProcedure [db_hr].[pr_saveemp_uploadinfo]    Script Date: 1/15/2020 8:32:19 PM ******/
DROP PROCEDURE [db_hr].[pr_saveemp_uploadinfo]
GO
/****** Object:  StoredProcedure [db_hr].[pr_SaveApraisal]    Script Date: 1/15/2020 8:32:19 PM ******/
DROP PROCEDURE [db_hr].[pr_SaveApraisal]
GO
/****** Object:  StoredProcedure [db_hr].[pr_gettraininglist]    Script Date: 1/15/2020 8:32:19 PM ******/
DROP PROCEDURE [db_hr].[pr_gettraininglist]
GO
/****** Object:  StoredProcedure [db_hr].[pr_gettrainingData]    Script Date: 1/15/2020 8:32:19 PM ******/
DROP PROCEDURE [db_hr].[pr_gettrainingData]
GO
/****** Object:  StoredProcedure [db_hr].[pr_getresumestatus]    Script Date: 1/15/2020 8:32:19 PM ******/
DROP PROCEDURE [db_hr].[pr_getresumestatus]
GO
/****** Object:  StoredProcedure [db_hr].[pr_getresumelist]    Script Date: 1/15/2020 8:32:19 PM ******/
DROP PROCEDURE [db_hr].[pr_getresumelist]
GO
/****** Object:  StoredProcedure [db_hr].[pr_getresumedetails]    Script Date: 1/15/2020 8:32:19 PM ******/
DROP PROCEDURE [db_hr].[pr_getresumedetails]
GO
/****** Object:  StoredProcedure [db_hr].[pr_getresumedata]    Script Date: 1/15/2020 8:32:19 PM ******/
DROP PROCEDURE [db_hr].[pr_getresumedata]
GO
/****** Object:  StoredProcedure [db_hr].[pr_getGetAppraisaldata]    Script Date: 1/15/2020 8:32:19 PM ******/
DROP PROCEDURE [db_hr].[pr_getGetAppraisaldata]
GO
/****** Object:  StoredProcedure [db_hr].[pr_getcommanapi_appraisal]    Script Date: 1/15/2020 8:32:19 PM ******/
DROP PROCEDURE [db_hr].[pr_getcommanapi_appraisal]
GO
/****** Object:  StoredProcedure [db_hr].[pr_getappraisallist]    Script Date: 1/15/2020 8:32:19 PM ******/
DROP PROCEDURE [db_hr].[pr_getappraisallist]
GO
/****** Object:  StoredProcedure [db_hr].[pr_commonapitraining]    Script Date: 1/15/2020 8:32:19 PM ******/
DROP PROCEDURE [db_hr].[pr_commonapitraining]
GO
/****** Object:  StoredProcedure [db_hr].[pr_commonapihr]    Script Date: 1/15/2020 8:32:19 PM ******/
DROP PROCEDURE [db_hr].[pr_commonapihr]
GO
/****** Object:  StoredProcedure [db_general].[pr_ValidateLogin]    Script Date: 1/15/2020 8:32:19 PM ******/
DROP PROCEDURE [db_general].[pr_ValidateLogin]
GO
/****** Object:  StoredProcedure [db_general].[pr_userlogs]    Script Date: 1/15/2020 8:32:19 PM ******/
DROP PROCEDURE [db_general].[pr_userlogs]
GO
/****** Object:  StoredProcedure [db_general].[pr_scriptupdate_report]    Script Date: 1/15/2020 8:32:19 PM ******/
DROP PROCEDURE [db_general].[pr_scriptupdate_report]
GO
/****** Object:  StoredProcedure [db_general].[pr_scriptupdate]    Script Date: 1/15/2020 8:32:19 PM ******/
DROP PROCEDURE [db_general].[pr_scriptupdate]
GO
/****** Object:  StoredProcedure [db_general].[pr_script_update_databasechanges]    Script Date: 1/15/2020 8:32:19 PM ******/
DROP PROCEDURE [db_general].[pr_script_update_databasechanges]
GO
/****** Object:  StoredProcedure [db_general].[pr_script_forinsertalltablescolumn]    Script Date: 1/15/2020 8:32:19 PM ******/
DROP PROCEDURE [db_general].[pr_script_forinsertalltablescolumn]
GO
/****** Object:  StoredProcedure [db_general].[pr_saveuserrights]    Script Date: 1/15/2020 8:32:19 PM ******/
DROP PROCEDURE [db_general].[pr_saveuserrights]
GO
/****** Object:  StoredProcedure [db_general].[pr_Savesinglecolumnmasters]    Script Date: 1/15/2020 8:32:19 PM ******/
DROP PROCEDURE [db_general].[pr_Savesinglecolumnmasters]
GO
/****** Object:  StoredProcedure [db_general].[pr_savemultilevelmastersList]    Script Date: 1/15/2020 8:32:19 PM ******/
DROP PROCEDURE [db_general].[pr_savemultilevelmastersList]
GO
/****** Object:  StoredProcedure [db_general].[pr_savemanagementgroupactivities]    Script Date: 1/15/2020 8:32:19 PM ******/
DROP PROCEDURE [db_general].[pr_savemanagementgroupactivities]
GO
/****** Object:  StoredProcedure [db_general].[pr_saveletter_banks]    Script Date: 1/15/2020 8:32:19 PM ******/
DROP PROCEDURE [db_general].[pr_saveletter_banks]
GO
/****** Object:  StoredProcedure [db_general].[pr_saveitemcategoryrights]    Script Date: 1/15/2020 8:32:19 PM ******/
DROP PROCEDURE [db_general].[pr_saveitemcategoryrights]
GO
/****** Object:  StoredProcedure [db_general].[pr_Savedoublecolumnmasters]    Script Date: 1/15/2020 8:32:19 PM ******/
DROP PROCEDURE [db_general].[pr_Savedoublecolumnmasters]
GO
/****** Object:  StoredProcedure [db_general].[pr_savedoublecolumnmaster]    Script Date: 1/15/2020 8:32:19 PM ******/
DROP PROCEDURE [db_general].[pr_savedoublecolumnmaster]
GO
/****** Object:  StoredProcedure [db_general].[pr_reports_getreportsparameters]    Script Date: 1/15/2020 8:32:20 PM ******/
DROP PROCEDURE [db_general].[pr_reports_getreportsparameters]
GO
/****** Object:  StoredProcedure [db_general].[pr_reports]    Script Date: 1/15/2020 8:32:20 PM ******/
DROP PROCEDURE [db_general].[pr_reports]
GO
/****** Object:  StoredProcedure [db_general].[pr_poststus]    Script Date: 1/15/2020 8:32:20 PM ******/
DROP PROCEDURE [db_general].[pr_poststus]
GO
/****** Object:  StoredProcedure [db_general].[pr_POPreparedByUsers]    Script Date: 1/15/2020 8:32:20 PM ******/
DROP PROCEDURE [db_general].[pr_POPreparedByUsers]
GO
/****** Object:  StoredProcedure [db_general].[pr_PoItemsPopulate]    Script Date: 1/15/2020 8:32:20 PM ******/
DROP PROCEDURE [db_general].[pr_PoItemsPopulate]
GO
/****** Object:  StoredProcedure [db_general].[pr_PlanPoPopulate]    Script Date: 1/15/2020 8:32:20 PM ******/
DROP PROCEDURE [db_general].[pr_PlanPoPopulate]
GO
/****** Object:  StoredProcedure [db_general].[pr_getuserrights]    Script Date: 1/15/2020 8:32:20 PM ******/
DROP PROCEDURE [db_general].[pr_getuserrights]
GO
/****** Object:  StoredProcedure [db_general].[pr_getusermenus]    Script Date: 1/15/2020 8:32:20 PM ******/
DROP PROCEDURE [db_general].[pr_getusermenus]
GO
/****** Object:  StoredProcedure [db_general].[pr_getSupplierSpAll]    Script Date: 1/15/2020 8:32:20 PM ******/
DROP PROCEDURE [db_general].[pr_getSupplierSpAll]
GO
/****** Object:  StoredProcedure [db_general].[pr_getsinglecolumnmastersList]    Script Date: 1/15/2020 8:32:20 PM ******/
DROP PROCEDURE [db_general].[pr_getsinglecolumnmastersList]
GO
/****** Object:  StoredProcedure [db_general].[pr_getrolesrights]    Script Date: 1/15/2020 8:32:20 PM ******/
DROP PROCEDURE [db_general].[pr_getrolesrights]
GO
/****** Object:  StoredProcedure [db_general].[pr_getnotifications]    Script Date: 1/15/2020 8:32:20 PM ******/
DROP PROCEDURE [db_general].[pr_getnotifications]
GO
/****** Object:  StoredProcedure [db_general].[pr_getnotificationdata]    Script Date: 1/15/2020 8:32:20 PM ******/
DROP PROCEDURE [db_general].[pr_getnotificationdata]
GO
/****** Object:  StoredProcedure [db_general].[pr_getmultilevelmastersList]    Script Date: 1/15/2020 8:32:20 PM ******/
DROP PROCEDURE [db_general].[pr_getmultilevelmastersList]
GO
/****** Object:  StoredProcedure [db_general].[pr_getmodulereports]    Script Date: 1/15/2020 8:32:20 PM ******/
DROP PROCEDURE [db_general].[pr_getmodulereports]
GO
/****** Object:  StoredProcedure [db_general].[pr_getmanagementgroups]    Script Date: 1/15/2020 8:32:20 PM ******/
DROP PROCEDURE [db_general].[pr_getmanagementgroups]
GO
/****** Object:  StoredProcedure [db_general].[pr_getmanagementgroupactivities]    Script Date: 1/15/2020 8:32:20 PM ******/
DROP PROCEDURE [db_general].[pr_getmanagementgroupactivities]
GO
/****** Object:  StoredProcedure [db_general].[pr_getletterbanklist]    Script Date: 1/15/2020 8:32:20 PM ******/
DROP PROCEDURE [db_general].[pr_getletterbanklist]
GO
/****** Object:  StoredProcedure [db_general].[pr_getletterbankdata]    Script Date: 1/15/2020 8:32:20 PM ******/
DROP PROCEDURE [db_general].[pr_getletterbankdata]
GO
/****** Object:  StoredProcedure [db_general].[pr_getdoublecolumnmastersList1]    Script Date: 1/15/2020 8:32:20 PM ******/
DROP PROCEDURE [db_general].[pr_getdoublecolumnmastersList1]
GO
/****** Object:  StoredProcedure [db_general].[pr_getdoublecolumnmastersList]    Script Date: 1/15/2020 8:32:20 PM ******/
DROP PROCEDURE [db_general].[pr_getdoublecolumnmastersList]
GO
/****** Object:  StoredProcedure [db_general].[pr_getdoublecolumnmastersdata]    Script Date: 1/15/2020 8:32:20 PM ******/
DROP PROCEDURE [db_general].[pr_getdoublecolumnmastersdata]
GO
/****** Object:  StoredProcedure [db_general].[pr_getdoublecolumndatalist]    Script Date: 1/15/2020 8:32:20 PM ******/
DROP PROCEDURE [db_general].[pr_getdoublecolumndatalist]
GO
/****** Object:  StoredProcedure [db_general].[pr_getCustomerSpAll]    Script Date: 1/15/2020 8:32:20 PM ******/
DROP PROCEDURE [db_general].[pr_getCustomerSpAll]
GO
/****** Object:  StoredProcedure [db_general].[pr_getallstatusList]    Script Date: 1/15/2020 8:32:20 PM ******/
DROP PROCEDURE [db_general].[pr_getallstatusList]
GO
/****** Object:  StoredProcedure [db_general].[pr_generateaccesstoken]    Script Date: 1/15/2020 8:32:20 PM ******/
DROP PROCEDURE [db_general].[pr_generateaccesstoken]
GO
/****** Object:  StoredProcedure [db_general].[pr_companybranches]    Script Date: 1/15/2020 8:32:20 PM ******/
DROP PROCEDURE [db_general].[pr_companybranches]
GO
/****** Object:  StoredProcedure [db_general].[pr_commonapimgmtplanner]    Script Date: 1/15/2020 8:32:20 PM ******/
DROP PROCEDURE [db_general].[pr_commonapimgmtplanner]
GO
/****** Object:  StoredProcedure [db_general].[pr_changeLoginpassword]    Script Date: 1/15/2020 8:32:20 PM ******/
DROP PROCEDURE [db_general].[pr_changeLoginpassword]
GO
/****** Object:  StoredProcedure [db_general].[Find_Text_In_SP]    Script Date: 1/15/2020 8:32:20 PM ******/
DROP PROCEDURE [db_general].[Find_Text_In_SP]
GO
/****** Object:  StoredProcedure [db_fcr].[pr_savefcr]    Script Date: 1/15/2020 8:32:20 PM ******/
DROP PROCEDURE [db_fcr].[pr_savefcr]
GO
/****** Object:  StoredProcedure [db_fcr].[pr_getfcrdata]    Script Date: 1/15/2020 8:32:20 PM ******/
DROP PROCEDURE [db_fcr].[pr_getfcrdata]
GO
/****** Object:  StoredProcedure [db_fcr].[pr_getFcrComplaintlist]    Script Date: 1/15/2020 8:32:20 PM ******/
DROP PROCEDURE [db_fcr].[pr_getFcrComplaintlist]
GO
/****** Object:  StoredProcedure [db_fcr].[pr_commonapifcr]    Script Date: 1/15/2020 8:32:20 PM ******/
DROP PROCEDURE [db_fcr].[pr_commonapifcr]
GO
/****** Object:  StoredProcedure [db_accounts].[pr_voucherdata]    Script Date: 1/15/2020 8:32:20 PM ******/
DROP PROCEDURE [db_accounts].[pr_voucherdata]
GO
/****** Object:  StoredProcedure [db_accounts].[pr_vouchercategory]    Script Date: 1/15/2020 8:32:20 PM ******/
DROP PROCEDURE [db_accounts].[pr_vouchercategory]
GO
/****** Object:  StoredProcedure [db_accounts].[pr_saveyearopening]    Script Date: 1/15/2020 8:32:20 PM ******/
DROP PROCEDURE [db_accounts].[pr_saveyearopening]
GO
/****** Object:  StoredProcedure [db_accounts].[pr_savevoucher]    Script Date: 1/15/2020 8:32:20 PM ******/
DROP PROCEDURE [db_accounts].[pr_savevoucher]
GO
/****** Object:  StoredProcedure [db_accounts].[pr_savepaymentrequirment]    Script Date: 1/15/2020 8:32:20 PM ******/
DROP PROCEDURE [db_accounts].[pr_savepaymentrequirment]
GO
/****** Object:  StoredProcedure [db_accounts].[pr_savechequeissueddetail]    Script Date: 1/15/2020 8:32:20 PM ******/
DROP PROCEDURE [db_accounts].[pr_savechequeissueddetail]
GO
/****** Object:  StoredProcedure [db_accounts].[pr_PrintJournal]    Script Date: 1/15/2020 8:32:20 PM ******/
DROP PROCEDURE [db_accounts].[pr_PrintJournal]
GO
/****** Object:  StoredProcedure [db_accounts].[pr_PrintCashJournal]    Script Date: 1/15/2020 8:32:20 PM ******/
DROP PROCEDURE [db_accounts].[pr_PrintCashJournal]
GO
/****** Object:  StoredProcedure [db_accounts].[pr_ministatementofaccount]    Script Date: 1/15/2020 8:32:20 PM ******/
DROP PROCEDURE [db_accounts].[pr_ministatementofaccount]
GO
/****** Object:  StoredProcedure [db_accounts].[pr_manageGLAccountHeads]    Script Date: 1/15/2020 8:32:20 PM ******/
DROP PROCEDURE [db_accounts].[pr_manageGLAccountHeads]
GO
/****** Object:  StoredProcedure [db_accounts].[pr_manageGLAccountGroup]    Script Date: 1/15/2020 8:32:20 PM ******/
DROP PROCEDURE [db_accounts].[pr_manageGLAccountGroup]
GO
/****** Object:  StoredProcedure [db_accounts].[pr_grouptrial]    Script Date: 1/15/2020 8:32:20 PM ******/
DROP PROCEDURE [db_accounts].[pr_grouptrial]
GO
/****** Object:  StoredProcedure [db_accounts].[pr_getvouchersubcategory]    Script Date: 1/15/2020 8:32:20 PM ******/
DROP PROCEDURE [db_accounts].[pr_getvouchersubcategory]
GO
/****** Object:  StoredProcedure [db_accounts].[pr_getVoucherList]    Script Date: 1/15/2020 8:32:20 PM ******/
DROP PROCEDURE [db_accounts].[pr_getVoucherList]
GO
/****** Object:  StoredProcedure [db_accounts].[pr_getvoucherdata]    Script Date: 1/15/2020 8:32:20 PM ******/
DROP PROCEDURE [db_accounts].[pr_getvoucherdata]
GO
/****** Object:  StoredProcedure [db_accounts].[pr_gettrial]    Script Date: 1/15/2020 8:32:20 PM ******/
DROP PROCEDURE [db_accounts].[pr_gettrial]
GO
/****** Object:  StoredProcedure [db_accounts].[pr_getSupplierBanker]    Script Date: 1/15/2020 8:32:20 PM ******/
DROP PROCEDURE [db_accounts].[pr_getSupplierBanker]
GO
/****** Object:  StoredProcedure [db_accounts].[pr_getPrintChequeList]    Script Date: 1/15/2020 8:32:20 PM ******/
DROP PROCEDURE [db_accounts].[pr_getPrintChequeList]
GO
/****** Object:  StoredProcedure [db_accounts].[pr_getpaymentrequirmentlist]    Script Date: 1/15/2020 8:32:20 PM ******/
DROP PROCEDURE [db_accounts].[pr_getpaymentrequirmentlist]
GO
/****** Object:  StoredProcedure [db_accounts].[pr_getPaymentRequirementDetail]    Script Date: 1/15/2020 8:32:20 PM ******/
DROP PROCEDURE [db_accounts].[pr_getPaymentRequirementDetail]
GO
/****** Object:  StoredProcedure [db_accounts].[pr_getPartyWiseChequeIssuedList]    Script Date: 1/15/2020 8:32:20 PM ******/
DROP PROCEDURE [db_accounts].[pr_getPartyWiseChequeIssuedList]
GO
/****** Object:  StoredProcedure [db_accounts].[pr_getlastvoucherno]    Script Date: 1/15/2020 8:32:20 PM ******/
DROP PROCEDURE [db_accounts].[pr_getlastvoucherno]
GO
/****** Object:  StoredProcedure [db_accounts].[pr_getGLAccountHeadsList]    Script Date: 1/15/2020 8:32:20 PM ******/
DROP PROCEDURE [db_accounts].[pr_getGLAccountHeadsList]
GO
/****** Object:  StoredProcedure [db_accounts].[pr_getFAUserGroups]    Script Date: 1/15/2020 8:32:20 PM ******/
DROP PROCEDURE [db_accounts].[pr_getFAUserGroups]
GO
/****** Object:  StoredProcedure [db_accounts].[pr_getcurrentvoucherdata]    Script Date: 1/15/2020 8:32:20 PM ******/
DROP PROCEDURE [db_accounts].[pr_getcurrentvoucherdata]
GO
/****** Object:  StoredProcedure [db_accounts].[pr_getChequeCalendar]    Script Date: 1/15/2020 8:32:20 PM ******/
DROP PROCEDURE [db_accounts].[pr_getChequeCalendar]
GO
/****** Object:  StoredProcedure [db_accounts].[pr_getcashbook]    Script Date: 1/15/2020 8:32:20 PM ******/
DROP PROCEDURE [db_accounts].[pr_getcashbook]
GO
/****** Object:  StoredProcedure [db_accounts].[pr_getCashBankAccounts]    Script Date: 1/15/2020 8:32:20 PM ******/
DROP PROCEDURE [db_accounts].[pr_getCashBankAccounts]
GO
/****** Object:  StoredProcedure [db_accounts].[pr_getAllAccountsforyearopening]    Script Date: 1/15/2020 8:32:20 PM ******/
DROP PROCEDURE [db_accounts].[pr_getAllAccountsforyearopening]
GO
/****** Object:  StoredProcedure [db_accounts].[pr_getAllAccounts]    Script Date: 1/15/2020 8:32:20 PM ******/
DROP PROCEDURE [db_accounts].[pr_getAllAccounts]
GO
/****** Object:  StoredProcedure [db_accounts].[pr_getAccountswitoutCashBank]    Script Date: 1/15/2020 8:32:20 PM ******/
DROP PROCEDURE [db_accounts].[pr_getAccountswitoutCashBank]
GO
/****** Object:  StoredProcedure [db_accounts].[pr_getAccountStatement]    Script Date: 1/15/2020 8:32:20 PM ******/
DROP PROCEDURE [db_accounts].[pr_getAccountStatement]
GO
/****** Object:  StoredProcedure [db_accounts].[pr_confirmpaymentrequirment]    Script Date: 1/15/2020 8:32:20 PM ******/
DROP PROCEDURE [db_accounts].[pr_confirmpaymentrequirment]
GO
/****** Object:  StoredProcedure [db_accounts].[pr_CashBook]    Script Date: 1/15/2020 8:32:20 PM ******/
DROP PROCEDURE [db_accounts].[pr_CashBook]
GO
/****** Object:  StoredProcedure [db_accounts].[pr_accountsgrouptree]    Script Date: 1/15/2020 8:32:20 PM ******/
DROP PROCEDURE [db_accounts].[pr_accountsgrouptree]
GO
