using System; using System.Collections.Generic; using System.Linq; using System.Text; using System.Threading.Tasks; namespace PayRollDAL.Query.OULevelSetting { public class OULevelSettingQB { public const string GET_OULEVELSETTING = @"SELECT OULEVELSETTING.OUID AS Id, ISNULL(ORGANIZATIONUNIT.ORGANIZATIONUNITCODE,'') AS Code, ISNULL(ORGANIZATIONUNIT.ORGANIZATIONUNITNAME,'') AS Name, OULEVELSETTING.RETIREMENTAGE AS OULevelSettingRetirementAge, OULEVELSETTING.CHARGESPERKILOMETER AS OULevelSettingChargesPerKilometer, OULEVELSETTING.SALARYPAYABLEACCOUNTID AS SalaryPayableAccountId, ISNULL(ACCOUNT.ACCOUNTCODE,'') AS SalaryPayableAccountCode, ISNULL(ACCOUNT.ACCOUNTNAME,'') AS SalaryPayableAccountName, OULEVELSETTING.EPFEMPLOYERPERCENTAGE AS OULevelSettingEPFEmployerPercentage, OULEVELSETTING.EPFEMPLOYERACTUALPERCENTAGE AS OULevelSettingEPFEmployerActualPercentage, OULEVELSETTING.FPFAPPLICABLE AS OULevelSettingFPFApplicable, OULEVELSETTING.FPFEMPLOYERPERCENTAGE AS OULevelSettingFPFEmployerPercentage, OULEVELSETTING.FPFEMPLOYERACTUALPERCENTAGE AS OULevelSettingFPFEmployerActualPercentage, OULEVELSETTING.DLIEMPLOYERPERCENTAGE AS OULevelSettingDLIEmployerPercentage, OULEVELSETTING.DLIEMPLOYERACTUALPERCENTAGE AS OULevelSettingDLIEmployerActualPercentage, OULEVELSETTING.EPFEMPLOYEEPERCENTAGE AS OULevelSettingEPFEmployeePercentage, OULEVELSETTING.EPFEMPLOYEEACTUALPERCENTAGE AS OULevelSettingEPFEmployeeActualPercentage, OULEVELSETTING.PFADMINPERCENTAGE AS OULevelSettingPFAdminPercentage, OULEVELSETTING.DLIADMINPERCENTAGE AS OULevelSettingDLIAdminPercentage, OULEVELSETTING.PFBANKNAME AS OULevelSettingPFBankName, OULEVELSETTING.PFBANKADDRESS1 AS OULevelSettingPFBankAddress1, OULEVELSETTING.PFBANKADDRESS2 AS OULevelSettingPFBankAddress2, OULEVELSETTING.PFBANKADDRESS3 AS OULevelSettingPFBankAddress3, OULEVELSETTING.PFBANKADDRESS4 AS OULevelSettingPFBankAddress4, OULEVELSETTING.EPFEMPLOYEEID AS EPFEmployeeId, ISNULL(FORMULA2.FORMULACODE,'') AS EPFEmployeeCode, ISNULL(FORMULA2.FORMULANAME,'') AS EPFEmployeeName, OULEVELSETTING.EPFEMPLOYERID AS EPFEmployerId, ISNULL(FORMULA3.FORMULACODE,'') AS EPFEmployerCode, ISNULL(FORMULA3.FORMULANAME,'') AS EPFEmployerName, OULEVELSETTING.FPFEMPLOYERID AS FPFEmployerId, ISNULL(FORMULA4.FORMULACODE,'') AS FPFEmployerCode, ISNULL(FORMULA4.FORMULANAME,'') AS FPFEmployerName, OULEVELSETTING.DLIWAGESID AS DLIWagesId, ISNULL(FORMULA5.FORMULACODE,'') AS DLIWagesCode, ISNULL(FORMULA5.FORMULANAME,'') AS DLIWagesName, OULEVELSETTING.DLIEMPLOYERID AS DLIEmployerId, ISNULL(FORMULA6.FORMULACODE,'') AS DLIEmployerCode, ISNULL(FORMULA6.FORMULANAME,'') AS DLIEmployerName, OULEVELSETTING.PFWAGESID AS PFWagesId, ISNULL(FORMULA7.FORMULACODE,'') AS PFWagesCode, ISNULL(FORMULA7.FORMULANAME,'') AS PFWagesName, OULEVELSETTING.PENSIONWAGEDID AS PensionWagedId, ISNULL(FORMULA8.FORMULACODE,'') AS PensionWagedCode, ISNULL(FORMULA8.FORMULANAME,'') AS PensionWagedName, OULEVELSETTING.PFNUMBER AS OULevelSettingPFNumber, OULEVELSETTING.PFGROUP AS OULevelSettingPFGroup, OULEVELSETTING.EPFCODE AS OULevelSettingEPFCode, OULEVELSETTING.PFPOSTINGTYPEID AS PFPostingTypeId, ISNULL(BIZTRANSACTION1.BIZTRANSACTIONCODE,'') AS PFPostingTypeCode, ISNULL(BIZTRANSACTION1.BIZTRANSACTIONNAME,'') AS PFPostingTypeName, OULEVELSETTING.ESINUMBER AS OULevelSettingESINumber, OULEVELSETTING.ESILOCALOFF AS OULevelSettingESILocalOff, OULEVELSETTING.ESIDISPENSARY AS OULevelSettingESIDispensary, OULEVELSETTING.ESIWAGECEILING AS OULevelSettingESIWageceiling, OULEVELSETTING.ESIEMPLOYEEPERCENTAGE AS OULevelSettingESIEmployeePercentage, OULEVELSETTING.ESIEMPLOYERPERCENTAGE AS OULevelSettingESIEmployerPercentage, OULEVELSETTING.ESIWAGEID AS ESIWageId, ISNULL(FORMULA9.FORMULACODE,'') AS ESIWageCode, ISNULL(FORMULA9.FORMULANAME,'') AS ESIWageName, OULEVELSETTING.ESIEMPLOYEEID AS ESIEmployeeId, ISNULL(FORMULA10.FORMULACODE,'') AS ESIEmployeeCode, ISNULL(FORMULA10.FORMULANAME,'') AS ESIEmployeeName, OULEVELSETTING.ESIEMPLOYERID AS ESIEmployerId, ISNULL(FORMULA11.FORMULACODE,'') AS ESIEmployerCode, ISNULL(FORMULA11.FORMULANAME,'') AS ESIEmployerName, OULEVELSETTING.ESILOPDAYSID AS ESILopDaysId, ISNULL(FORMULA12.FORMULACODE,'') AS ESILopDaysCode, ISNULL(FORMULA12.FORMULANAME,'') AS ESILopDaysName, OULEVELSETTING.ESIVOLSHARPFID AS ESIVolSharpId, ISNULL(FORMULA13.FORMULACODE,'') AS ESIVolSharpCode, ISNULL(FORMULA13.FORMULANAME,'') AS ESIVolSharpName, OULEVELSETTING.ESIEARNEDBASICID AS ESIEarnedBasicId, ISNULL(FORMULA14.FORMULACODE,'') AS ESIEarnedBasicCode, ISNULL(FORMULA14.FORMULANAME,'') AS ESIEarnedBasicName, OULEVELSETTING.ESIUPTODTID AS ESIUpToDtId, ISNULL(FORMULA15.FORMULACODE,'') AS ESIUpToDtCode, ISNULL(FORMULA15.FORMULANAME,'') AS ESIUpToDtName, OULEVELSETTING.ESIPOSTINGTYPEID AS ESIPostingTypeId, ISNULL(BIZTRANSACTION2.BIZTRANSACTIONCODE,'') AS ESIPostingTypeCode, ISNULL(BIZTRANSACTION2.BIZTRANSACTIONNAME,'') AS ESIPostingTypeName, OULEVELSETTING.TDSACCOUNTNUMBER AS OULevelSettingTDSAccountNumber, OULEVELSETTING.PANGIRNO AS OULevelSettingPangirNo, OULEVELSETTING.PAYNATURE AS OULevelSettingPayNature, OULEVELSETTING.TDSFORMULAID AS TDSFormulaId, ISNULL(FORMULA1.FORMULACODE,'') AS TDSFormulaCode, ISNULL(FORMULA1.FORMULANAME,'') AS TDSFormulaName, OULEVELSETTING.TDSPERCENTAGE AS OULevelSettingTDSPercentage, OULEVELSETTING.CIRCLEADDRESS1 AS OULevelSettingCircleAddress1, OULEVELSETTING.CIRCLEADDRESS2 AS OULevelSettingCircleAddress2, OULEVELSETTING.CIRCLEADDRESS3 AS OULevelSettingCircleAddress3, OULEVELSETTING.CIRCLEADDRESS4 AS OULevelSettingCircleAddress4, OULEVELSETTING.PACKEXCISESLNO AS OULevelSettingPackExciseSlNo, OULEVELSETTING.BACKDATEATTENDANCEDAY AS OULevelSettingBackDateAttendanceDay, OULEVELSETTING.PFLOPDAYSID AS PFLopDaysId, ISNULL(FORMULA16.FORMULACODE,'') AS PFLopDaysCode, ISNULL(FORMULA16.FORMULANAME,'') AS PFLopDaysName, OULEVELSETTING.REPAYMENTBIZTRANSACTIONTYPEID AS RepaymentPostingTypeId, ISNULL(BIZTRANSACTION3.BIZTRANSACTIONCODE,'') AS RepaymentPostingTypeCode, ISNULL(BIZTRANSACTION3.BIZTRANSACTIONNAME,'') AS RepaymentPostingTypeName, OULEVELSETTING.DLIADMINAMOUNTID AS DLIAdminAmountId, ISNULL(FORMULA18.FORMULACODE,'') AS DLIAdminAmountCode, ISNULL(FORMULA18.FORMULANAME,'') AS DLIAdminAmountName, OULEVELSETTING.PFADMINAMOUNTID AS PFAdminAmountId, ISNULL(FORMULA17.FORMULACODE,'') AS PFAdminAmountCode, ISNULL(FORMULA17.FORMULANAME,'') AS PFAdminAmountName, OULEVELSETTING.INTERACCOUNTID AS InterAccountId, ISNULL(INTERACCOUNT.ACCOUNTCODE,'') AS InterAccountCode, ISNULL(INTERACCOUNT.ACCOUNTNAME,'') AS InterAccountName, OULEVELSETTING.INTERBIZTRANSACTIONID AS InterBIZTransactionId, ISNULL(INTERBIZTRANSACTION.BIZTRANSACTIONCODE,'') AS InterBIZTransactionCode, ISNULL(INTERBIZTRANSACTION.BIZTRANSACTIONNAME,'') AS InterBIZTransactionName, OULEVELSETTING.QUALITYWEIGHTAGE AS OULevelSettingQualityWeightage, OULEVELSETTING.RATEWEIGHTAGE AS OULevelSettingRateWeightage, OULEVELSETTING.DELIVERYWEIGHTAGE AS OULevelSettingDeliveryWeightage, OULEVELSETTING.DELIVERYOUID AS DeliveryOuId, ISNULL(organizationunitdeliv.ORGANIZATIONUNITCODE,'') AS DeliveryOuCode, ISNULL(organizationunitdeliv.ORGANIZATIONUNITNAME,'') AS DeliveryOuName, OULEVELSETTING.TRANSFERSENDID AS TransferSendId, ISNULL(biztransactiontranssend.BIZTRANSACTIONCODE,'') AS TransferSendCode, ISNULL(biztransactiontranssend.BIZTRANSACTIONNAME,'') AS TransferSendName, OULEVELSETTING.TRANSFERRECEIVEDID AS TransferReceivedId, ISNULL(biztransactiontransreceiv.BIZTRANSACTIONCODE,'') AS TransferReceivedCode, ISNULL(biztransactiontransreceiv.BIZTRANSACTIONNAME,'') AS TransferReceivedName, OULEVELSETTING.PARTYID AS PartyId, ISNULL(PARTY.PARTYCODE,'') AS PartyCode, ISNULL(PARTY.PARTYNAME,'') AS PartyName, OULEVELSETTING.PARTYBRANCHID AS PartyBranchId, ISNULL(PARTYBRANCH.PARTYBRANCHCODE,'') AS PartyBranchCode, ISNULL(PARTYBRANCH.PARTYBRANCHNAME,'') AS PartyBranchName, OULEVELSETTING.INDENTID AS IndentId, ISNULL(biztransactionindent.BIZTRANSACTIONCODE,'') AS IndentCode, ISNULL(biztransactionindent.BIZTRANSACTIONNAME,'') AS IndentName, OULEVELSETTING.ADJUSTMENTBIZTRANSACTIONID AS AdjustmentBizTransactionId, ISNULL(biztransactionadjustment.BIZTRANSACTIONCODE,'') AS AdjustmentBizTransactionCode, ISNULL(biztransactionadjustment.BIZTRANSACTIONNAME,'') AS AdjustmentBizTransactionName, OULEVELSETTING.DELIVERYBIZTRANSACTIONID AS DeliveryBizTransactionId, ISNULL(biztransactiondelivery.BIZTRANSACTIONCODE,'') AS DeliveryBizTransactionCode, ISNULL(biztransactiondelivery.BIZTRANSACTIONNAME,'') AS DeliveryBizTransactionName, OULEVELSETTING.MRPBUYBIZTRANSACTIONID AS MRPBizTransactionId, ISNULL(MRPBizTransaction.BIZTRANSACTIONCODE,'') AS MRPBizTransactionCode, ISNULL(MRPBizTransaction.BIZTRANSACTIONNAME,'') AS MRPBizTransactionName, OULEVELSETTING.MRPMAKEBIZTRANSACTIONID AS MRPMakeBizTransactionId, ISNULL(MRPMakeBizTransaction.BIZTRANSACTIONCODE,'') AS MRPMakeBizTransactionCode, ISNULL(MRPMakeBizTransaction.BIZTRANSACTIONNAME,'') AS MRPMakeBizTransactionName, OULEVELSETTING.WORKORDERBIZTRANSACTIONID AS WorkOrderBizTransactionId, ISNULL(WorkOrderBizTransaction.BIZTRANSACTIONCODE,'') AS WorkOrderBizTransactionCode, ISNULL(WorkOrderBizTransaction.BIZTRANSACTIONNAME,'') AS WorkOrderBizTransactionName, OULEVELSETTING.SUBCONTRACTBIZTRANSACTIONID AS SubContractBizTransactionId, ISNULL(SubcontractBizTransaction.BIZTRANSACTIONCODE,'') AS SubContractBizTransactionCode, ISNULL(SubcontractBizTransaction.BIZTRANSACTIONNAME,'') AS SubContractBizTransactionName, OULEVELSETTING.MRPBUYACTIONTYPE AS OULevelSettingMRPBuyActionType, OULEVELSETTING.MRPMAKEACTIONTYPE AS OULevelSettingMRPMakeActionType, OULEVELSETTING.ABSENTLEAVEID AS AbsentLeaveId, ISNULL(oulsleave.LEAVECODE,'') AS AbsentLeaveCode, ISNULL(oulsleave.LEAVENAME,'') AS AbsentLeaveName, OULEVELSETTING.INTERMMBIZTRANSACTIONID AS InterMMBiztransactionId, ISNULL(MMBIZTRANSACTION.BIZTRANSACTIONCODE,'') AS InterMMBiztransactionCode, ISNULL(MMBIZTRANSACTION.BIZTRANSACTIONNAME,'') AS InterMMBiztransactionName, OULEVELSETTING.FROMLOCATIONID AS FromLocationId, ISNULL(fromLoc.LOCATIONCODE,'') AS FromLocationCode, ISNULL(fromLoc.LOCATIONNAME,'') AS FromLocationName, OULEVELSETTING.FROMCITYID AS FromCityId, ISNULL(fromCity.CITYCODE,'') AS FromCityCode, ISNULL(fromCity.CITYNAME,'') AS FromCityName, OULEVELSETTING.TOLOCATIONID AS ToLocationId, ISNULL(toLoc.LOCATIONCODE,'') AS ToLocationCode, ISNULL(toLoc.LOCATIONNAME,'') AS ToLocationName, OULEVELSETTING.TOCITYID AS ToCityId, ISNULL(toCity.CITYCODE,'') AS ToCityCode, ISNULL(toCity.CITYNAME,'') AS ToCityName, OULEVELSETTING.LOADSIMPLEBOOKING AS IsLoadSimpleBooking, OULEVELSETTING.DELIVERYTRACK AS DeliveryTrack, OULEVELSETTING.ACTIVITYBIZTRANSACTIONID AS ActivityBiztransactionId, ISNULL(actbiz.BIZTRANSACTIONCODE,'') AS ActivityBiztransactionCode, ISNULL(actbiz.BIZTRANSACTIONNAME,'') AS ActivityBiztransactionName, OULEVELSETTING.TASKBIZTRANSACTIONID AS ToDoBiztransactionId, ISNULL(todobiz.BIZTRANSACTIONCODE,'') AS ToDoBiztransactionCode, ISNULL(todobiz.BIZTRANSACTIONNAME,'') AS ToDoBiztransactionName, OULEVELSETTING.TITLE AS OULevelSettingTitle, OULEVELSETTING.SUBJECT AS OULevelSettingSubject, OULEVELSETTING.KEYWORDS AS OULevelSettingKeywords, OULEVELSETTING.CREATOR AS OULevelSettingCreator, OULEVELSETTING.PRODUCER AS OULevelSettingProducer, OULEVELSETTING.REASON AS OULevelSettingReason, OULEVELSETTING.LOCATION AS OULevelSettingLocation, OULEVELSETTING.CHEQUEBOUNCEBIZTRANSACTIONID AS ChequeBounceBIZtransactionId, ISNULL(chqboubiz.BIZTRANSACTIONCODE,'') AS ChequeBounceBIZtransactionCode, ISNULL(chqboubiz.BIZTRANSACTIONNAME,'') AS ChequeBounceBIZtransactionName, OULEVELSETTING.BOUNCECHARGESACCOUNTID AS BounceChargesAccountId, ISNULL(bouchracc.ACCOUNTCODE,'') AS BounceChargesAccountCode, ISNULL(bouchracc.ACCOUNTNAME,'') AS BounceChargesAccountName, OULEVELSETTING.SALARYGROSSFORMULAID AS SalaryGrossFormulaId, ISNULL(salgrossformula.FORMULACODE,'') AS SalaryGrossFormulaCode, ISNULL(salgrossformula.FORMULANAME,'') AS SalaryGrossFormulaName, OULEVELSETTING.OVERTIMETYPE AS OULevelSettingOvertimeType, OULEVELSETTING.ATTENDANCETYPE AS OULevelSettingAttendanceType, OULEVELSETTING.AUTOCALLBIZTRANSACTIONID AS AutoCallBIZTransactionId, ISNULL(autocall.BIZTRANSACTIONCODE,'') AS AutoCallBIZTransactionCode, ISNULL(autocall.BIZTRANSACTIONNAME,'') AS AutoCallBIZTransactionName, OULEVELSETTING.GRATUITYDAYSFORMULAID AS GratutiDaysFormulaId, ISNULL(gratuitydaysformula.FORMULACODE,'') AS GratutiDaysFormulaCode, ISNULL(gratuitydaysformula.FORMULANAME,'') AS GratutiDaysFormulaName, OULEVELSETTING.BONUSONAMOUNTFORMULAID AS BonusonAmountFormulaId, ISNULL(bonusamountformula.FORMULACODE,'') AS BonusonAmountFormulaCode, ISNULL(bonusamountformula.FORMULANAME,'') AS BonusonAmountFormulaName, OULEVELSETTING.BONUSFORMULAID AS BonusFormulaId, ISNULL(bonusformula.FORMULACODE,'') AS BonusFormulaCode, ISNULL(bonusformula.FORMULANAME,'') AS BonusFormulaName, OULEVELSETTING.DEFAULTBANKACCOUNTID AS DefaultBankAccountId, ISNULL(bankaccount.ACCOUNTCODE,'') AS DefaultBankAccountCode, ISNULL(bankaccount.ACCOUNTNAME,'') AS DefaultBankAccountName, OULEVELSETTING.TRIPADVANCEPOSTINGTYPE AS OULevelSettingTripAdvancePostingType, OULEVELSETTING.TRIPEXPENSEPOSTINGTYPE AS OULevelSettingTripExpensePostingType, OULEVELSETTING.TRIPSHORTAGEPOSTINGTYPE AS OULevelSettingTripShortagePostingType, OULEVELSETTING.TRIPHIRECHARGESPOSTINGTYPE AS OULevelSettingTripHireChargesPostingType, OULEVELSETTING.ADVANCEBIZTRANSACTIONID AS AdvanceBIZtransactionId, ISNULL(advancebiztransaction.BIZTRANSACTIONCODE,'') AS AdvanceBIZtransactionCode, ISNULL(advancebiztransaction.BIZTRANSACTIONNAME,'') AS AdvanceBIZtransactionName, OULEVELSETTING.ADVANCECREDITACCOUNTID AS AdvanceCreditAccountId, ISNULL(advancecredit.ACCOUNTCODE,'') AS AdvanceCreditAccountCode, ISNULL(advancecredit.ACCOUNTNAME,'') AS AdvanceCreditAccountName, OULEVELSETTING.EXPENSEBIZTRANSACTIONID AS ExpenseBIZtransactionId, ISNULL(expensebiztransaction.BIZTRANSACTIONCODE,'') AS ExpenseBIZtransactionCode, ISNULL(expensebiztransaction.BIZTRANSACTIONNAME,'') AS ExpenseBIZtransactionName, OULEVELSETTING.EXPENSECREDITACCOUNTID AS ExpenseCreditAccountId, ISNULL(expensecredit.ACCOUNTCODE,'') AS ExpenseCreditAccountCode, ISNULL(expensecredit.ACCOUNTNAME,'') AS ExpenseCreditAccountName, OULEVELSETTING.EXPENSEDEBITACCOUNTID AS ExpenseDebitAccountId, ISNULL(expensedebit.ACCOUNTCODE,'') AS ExpenseDebitAccountCode, ISNULL(expensedebit.ACCOUNTNAME,'') AS ExpenseDebitAccountName, OULEVELSETTING.SHORTAGEBIZTRANSACTIONID AS ShortageBIZtransactionId, ISNULL(shortagebiztransaction.BIZTRANSACTIONCODE,'') AS ShortageBIZtransactionCode, ISNULL(shortagebiztransaction.BIZTRANSACTIONNAME,'') AS ShortageBIZtransactionName, OULEVELSETTING.SHORTAGEACCOUNTID AS ShortageAccountId, ISNULL(shortageaccount.ACCOUNTCODE,'') AS ShortageAccountCode, ISNULL(shortageaccount.ACCOUNTNAME,'') AS ShortageAccountName, OULEVELSETTING.HIRECHARGESBIZTRANSACTIONID AS HireChargesBIZtransactionId, ISNULL(hirechargebiztransaction.BIZTRANSACTIONCODE,'') AS HireChargesBIZtransactionCode, ISNULL(hirechargebiztransaction.BIZTRANSACTIONNAME,'') AS HireChargesBIZtransactionName, OULEVELSETTING.HIRECHARGESACCOUNTID AS HireChargesAccountId, ISNULL(hirechargeaccount.ACCOUNTCODE,'') AS HireChargesAccountCode, ISNULL(hirechargeaccount.ACCOUNTNAME,'') AS HireChargesAccountName, OULEVELSETTING.STOCKVALUATIONTYPE AS OULevelSettingStockvaluationType, OULEVELSETTING.BRANCHTRANSFERINDENTBIZTRANSACTIONID AS BranchTransferBiztransactionId, ISNULL(Branchtransfertransaction.BIZTRANSACTIONCODE,'') AS BranchTransferBiztransactionCode, ISNULL(Branchtransfertransaction.BIZTRANSACTIONNAME,'') AS BranchTransferBiztransactionName, OULEVELSETTING.PTFORMULAID AS PTFormulaId, ISNULL(ptformula.FORMULACODE,'') AS PTFormulaCode, ISNULL(ptformula.FORMULANAME,'') AS PTFormulaName, OULEVELSETTING.PTCATEGORYFORMULAID AS PTCategoryFormulaId, ISNULL(ptcategoryformula.FORMULACODE,'') AS PTCategoryFormulaCode, ISNULL(ptcategoryformula.FORMULANAME,'') AS PTCategoryFormulaName, OULEVELSETTING.BOOKINGBIZTRANSACTIONID AS BookingBiztransactionId, ISNULL(bookingbiztransaction.BIZTRANSACTIONCODE,'') AS BookingBiztransactionCode, ISNULL(bookingbiztransaction.BIZTRANSACTIONNAME,'') AS BookingBiztransactionName, OULEVELSETTING.OTELIGABLEMINUTES AS OULevelSettingOTEligableMinutes, OULEVELSETTING.MAXIMUMOTINMONTH AS OULevelSettingMaximumOTInMonth, OULEVELSETTING.MAXALLOWEDTIMEFORMALE AS OULevelSettingMaxAllowedOTForMale, OULEVELSETTING.MAXALLOWEDTIMEFORFEMALE AS OULevelSettingMaxAllowedOTForFemale, OULEVELSETTING.MALEOTHOURSINEVENDAYS AS OULevelSettingMaleOTHoursInEvenDays, OULEVELSETTING.FEMALEOTHOURSINEVENDAYS AS OULevelSettingFemaleOTHoursInEvenDays, OULEVELSETTING.MALEOTHOURSINODDDAYS AS OULevelSettingMaleOTHoursInOddDays, OULEVELSETTING.FEMALEOTHOURSINODDDAYS AS OULevelSettingFemaleOTHoursInOddDays, OULEVELSETTING.OTEXPRESSIONFORMULAID AS OTExpressionFormulaId, ISNULL(otexpressionformula.FORMULACODE,'') AS OTExpressionFormulaCode, ISNULL(otexpressionformula.FORMULANAME,'') AS OTExpressionFormulaName, OULEVELSETTING.BREAKTIMEEXPRESSIONFORMULAID AS BreakTimeExpressionFormulaId, ISNULL(breaktimeexpressionformula.FORMULACODE,'') AS BreakTimeExpressionFormulaCode, ISNULL(breaktimeexpressionformula.FORMULANAME,'') AS BreakTimeExpressionFormulaName, OULEVELSETTING.COMPOFFLEAVEID AS CompOffLeaveId, ISNULL(compoff.LEAVECODE,'') AS CompOffLeaveCode, ISNULL(compoff.LEAVENAME,'') AS CompOffLeaveName, OULEVELSETTING.WORKSUBTYPEID AS WorkSubTypeId, ISNULL(workgcm.GCMCODE,'') AS WorkSubTypeCode, ISNULL(workgcm.GCMNAME,'') AS WorkSubTypeName, OULEVELSETTING.NETSALARYROUNDOFF AS OULevelSettingNetSalaryRoundOff, OULEVELSETTING.BATCHOTPIRUNDAYS AS OULevelSettingBatchOTPIRunDays, OULEVELSETTING.ISMSSAPPLICABLE AS OULevelSettingIsMssApplicable, OULEVELSETTING.PTGROSSFORMULAID AS PTGrossFormulaId, ISNULL(PTGROSSFORMULA.FORMULACODE,'') AS PTGrossFormulaCode, ISNULL(PTGROSSFORMULA.FORMULANAME,'') AS PTGrossFormulaName, OULEVELSETTING.SALEORDERBIZTRANSACTIONID AS SaleOrderBizTransactionId, ISNULL(saleorderbiztransaction.BIZTRANSACTIONCODE,'') AS SaleOrderBizTransactionCode, ISNULL(saleorderbiztransaction.BIZTRANSACTIONNAME,'') AS SaleOrderBizTransactionName, OULEVELSETTING.SALEINVOICEBIZTRANSACTIONID AS SaleInvoiceBizTransactionId, ISNULL(saleinvoicebiztransaction.BIZTRANSACTIONCODE,'') AS SaleInvoiceBizTransactionCode, ISNULL(saleinvoicebiztransaction.BIZTRANSACTIONNAME,'') AS SaleInvoiceBizTransactionName, OULEVELSETTING.RECEIPTBIZTRANSACTIONID AS ReceiptBizTransactionId, ISNULL(receiptbiztransaction.BIZTRANSACTIONCODE,'') AS ReceiptBizTransactionCode, ISNULL(receiptbiztransaction.BIZTRANSACTIONNAME,'') AS ReceiptBizTransactionName, OULEVELSETTING.RELEIVINGFORMULAID AS ReleivingFormulaId, ISNULL(releivingformula.FORMULACODE,'') AS ReleivingFormulaCode, ISNULL(releivingformula.FORMULANAME,'') AS ReleivingFormulaName, OULEVELSETTING.TERMINATIONFORMULAID AS TerminationFormulaId, ISNULL(terminationfromula.FORMULACODE,'') AS TerminationFormulaCode, ISNULL(terminationfromula.FORMULANAME,'') AS TerminationFormulaName, OULEVELSETTING.ENCASHFORMULAID AS EncashFormulaId, ISNULL(encashformula.FORMULACODE,'') AS EncashFormulaCode, ISNULL(encashformula.FORMULANAME,'') AS EncashFormulaName, OULEVELSETTING.LTAELEMENTFORMULAID AS LTAElementFormulaId, ISNULL(ltaelementformula.FORMULACODE,'') AS LTAElementFormulaCode, ISNULL(ltaelementformula.FORMULANAME,'') AS LTAElementFormulaName, OULEVELSETTING.LTAELIGIBLEDAYSFORMULAID AS LTAEligibleDaysFormulaId, ISNULL(ltaeligibledaysFormula.FORMULACODE,'') AS LTAEligibleDaysFormulaCode, ISNULL(ltaeligibledaysFormula.FORMULANAME,'') AS LTAEligibleDaysFormulaName, OULEVELSETTING.LTAAMOUNTPERDAYFORMULAID AS LTAAmountPerDayFormulaId, ISNULL(ltaamountperdayformula.FORMULACODE,'') AS LTAAmountPerDayFormulaCode, ISNULL(ltaamountperdayformula.FORMULANAME,'') AS LTAAmountPerDayFormulaName, OULEVELSETTING.ENCASHPOSTFIELDID AS EncashPostFieldId, ISNULL(encashpostfield.FIELDCODE,'') AS EncashPostFieldCode, ISNULL(encashpostfield.FIELDNAME,'') AS EncashPostFieldName, OULEVELSETTING.ENCASHSTATUS AS OULevelSettingEncashStatus, OULEVELSETTING.ENCASHELIGIBLEDAYS AS OULevelSettingEncashEligibleDays, OULEVELSETTING.ENCASHMAXIMUMDAYS AS OULevelSettingEncashMaximumDays, OULEVELSETTING.ISSTOREWISEVALUATION AS OULevelSettingIsStorewiseValuation, OULEVELSETTING.ADJUSTMENTTYPE AS OULevelSettingAdjustmentType FROM MOULEVELSETTING OULEVELSETTING LEFT JOIN MORGANIZATIONUNIT ORGANIZATIONUNIT ON OULEVELSETTING.OUID = ORGANIZATIONUNIT.OUID LEFT JOIN MACCOUNT ACCOUNT ON OULEVELSETTING.SALARYPAYABLEACCOUNTID = ACCOUNT.ACCOUNTID LEFT JOIN MBIZTRANSACTION BIZTRANSACTION1 ON OULEVELSETTING.PFPOSTINGTYPEID = BIZTRANSACTION1.BIZTRANSACTIONID LEFT JOIN MBIZTRANSACTION BIZTRANSACTION2 ON OULEVELSETTING.ESIPOSTINGTYPEID = BIZTRANSACTION2.BIZTRANSACTIONID LEFT JOIN MFORMULA FORMULA1 ON OULEVELSETTING.TDSFORMULAID = FORMULA1.FORMULAID LEFT JOIN MFORMULA FORMULA2 ON OULEVELSETTING.EPFEMPLOYEEID = FORMULA2.FORMULAID LEFT JOIN MFORMULA FORMULA3 ON OULEVELSETTING.EPFEMPLOYERID = FORMULA3.FORMULAID LEFT JOIN MFORMULA FORMULA4 ON OULEVELSETTING.FPFEMPLOYERID = FORMULA4.FORMULAID LEFT JOIN MFORMULA FORMULA5 ON OULEVELSETTING.DLIWAGESID = FORMULA5.FORMULAID LEFT JOIN MFORMULA FORMULA6 ON OULEVELSETTING.DLIEMPLOYERID = FORMULA6.FORMULAID LEFT JOIN MFORMULA FORMULA7 ON OULEVELSETTING.PFWAGESID = FORMULA7.FORMULAID LEFT JOIN MFORMULA FORMULA8 ON OULEVELSETTING.PENSIONWAGEDID = FORMULA8.FORMULAID LEFT JOIN MFORMULA FORMULA9 ON OULEVELSETTING.ESIWAGEID = FORMULA9.FORMULAID LEFT JOIN MFORMULA FORMULA10 ON OULEVELSETTING.ESIEMPLOYEEID = FORMULA10.FORMULAID LEFT JOIN MFORMULA FORMULA11 ON OULEVELSETTING.ESIEMPLOYERID = FORMULA11.FORMULAID LEFT JOIN MFORMULA FORMULA12 ON OULEVELSETTING.ESILOPDAYSID = FORMULA12.FORMULAID LEFT JOIN MFORMULA FORMULA13 ON OULEVELSETTING.ESIVOLSHARPFID = FORMULA13.FORMULAID LEFT JOIN MFORMULA FORMULA14 ON OULEVELSETTING.ESIEARNEDBASICID = FORMULA14.FORMULAID LEFT JOIN MFORMULA FORMULA15 ON OULEVELSETTING.ESIUPTODTID = FORMULA15.FORMULAID LEFT JOIN MFORMULA FORMULA16 ON OULEVELSETTING.PFLOPDAYSID = FORMULA16.FORMULAID LEFT JOIN MBIZTRANSACTION BIZTRANSACTION3 ON OULEVELSETTING.REPAYMENTBIZTRANSACTIONTYPEID = BIZTRANSACTION3.BIZTRANSACTIONID LEFT JOIN MFORMULA FORMULA17 ON OULEVELSETTING.PFADMINAMOUNTID = FORMULA17.FORMULAID LEFT JOIN MFORMULA FORMULA18 ON OULEVELSETTING.DLIADMINAMOUNTID = FORMULA18.FORMULAID LEFT JOIN MACCOUNT INTERACCOUNT ON OULEVELSETTING.INTERACCOUNTID = INTERACCOUNT.ACCOUNTID LEFT JOIN MBIZTRANSACTION INTERBIZTRANSACTION ON OULEVELSETTING.INTERBIZTRANSACTIONID = INTERBIZTRANSACTION.BIZTRANSACTIONID LEFT JOIN MPARTY PARTY ON OULEVELSETTING.PARTYID = PARTY.PARTYID LEFT JOIN MPARTYBRANCH PARTYBRANCH ON OULEVELSETTING.PARTYBRANCHID = PARTYBRANCH.PARTYBRANCHID LEFT JOIN MORGANIZATIONUNIT organizationunitdeliv ON OULEVELSETTING.DELIVERYOUID = organizationunitdeliv.OUID LEFT JOIN MBIZTRANSACTION biztransactiontranssend ON OULEVELSETTING.TRANSFERSENDID = biztransactiontranssend.BIZTRANSACTIONID LEFT JOIN MBIZTRANSACTION biztransactiontransreceiv ON OULEVELSETTING.TRANSFERRECEIVEDID = biztransactiontransreceiv.BIZTRANSACTIONID LEFT JOIN MBIZTRANSACTION biztransactionindent ON OULEVELSETTING.INDENTID = biztransactionindent.BIZTRANSACTIONID LEFT JOIN MBIZTRANSACTION biztransactionadjustment ON OULEVELSETTING.ADJUSTMENTBIZTRANSACTIONID = biztransactionadjustment.BIZTRANSACTIONID LEFT JOIN MBIZTRANSACTION biztransactiondelivery ON OULEVELSETTING.DELIVERYBIZTRANSACTIONID = biztransactiondelivery.BIZTRANSACTIONID LEFT JOIN MBIZTRANSACTION MRPBizTransaction ON OULEVELSETTING.MRPBUYBIZTRANSACTIONID = MRPBizTransaction.BIZTRANSACTIONID LEFT JOIN MBIZTRANSACTION MRPMakeBizTransaction ON OULEVELSETTING.MRPMAKEBIZTRANSACTIONID = MRPMakeBizTransaction.BIZTRANSACTIONID LEFT JOIN MBIZTRANSACTION WorkOrderBizTransaction ON OULEVELSETTING.WORKORDERBIZTRANSACTIONID = WorkOrderBizTransaction.BIZTRANSACTIONID LEFT JOIN MBIZTRANSACTION SubcontractBizTransaction ON OULEVELSETTING.SUBCONTRACTBIZTRANSACTIONID = SubcontractBizTransaction.BIZTRANSACTIONID LEFT JOIN MLEAVE oulsleave ON OULEVELSETTING.ABSENTLEAVEID = oulsleave.LEAVEID LEFT JOIN MBIZTRANSACTION MMBIZTRANSACTION ON OULEVELSETTING.INTERMMBIZTRANSACTIONID = MMBIZTRANSACTION.BIZTRANSACTIONID LEFT JOIN MLOCATION fromLoc ON OULEVELSETTING.FROMLOCATIONID = fromLoc.LOCATIONID LEFT JOIN MCITY fromCity ON OULEVELSETTING.FROMCITYID = fromCity.CITYID LEFT JOIN MLOCATION toLoc ON OULEVELSETTING.TOLOCATIONID = toLoc.LOCATIONID LEFT JOIN MCITY toCity ON OULEVELSETTING.TOCITYID = toCity.CITYID LEFT JOIN MBIZTRANSACTION actbiz ON OULEVELSETTING.ACTIVITYBIZTRANSACTIONID = actbiz.BIZTRANSACTIONID LEFT JOIN MBIZTRANSACTION todobiz ON OULEVELSETTING.TASKBIZTRANSACTIONID = todobiz.BIZTRANSACTIONID LEFT JOIN MBIZTRANSACTION chqboubiz ON OULEVELSETTING.CHEQUEBOUNCEBIZTRANSACTIONID = chqboubiz.BIZTRANSACTIONID LEFT JOIN MACCOUNT bouchracc ON OULEVELSETTING.BOUNCECHARGESACCOUNTID = bouchracc.ACCOUNTID LEFT JOIN MFORMULA salgrossformula ON OULEVELSETTING.SALARYGROSSFORMULAID = salgrossformula.FORMULAID LEFT JOIN MBIZTRANSACTION autocall ON OULEVELSETTING.AUTOCALLBIZTRANSACTIONID = autocall.BIZTRANSACTIONID LEFT JOIN MFORMULA gratuitydaysformula ON OULEVELSETTING.GRATUITYDAYSFORMULAID = gratuitydaysformula.FORMULAID LEFT JOIN MFORMULA bonusamountformula ON OULEVELSETTING.BONUSONAMOUNTFORMULAID = bonusamountformula.FORMULAID LEFT JOIN MFORMULA bonusformula ON OULEVELSETTING.BONUSFORMULAID = bonusformula.FORMULAID LEFT JOIN MACCOUNT bankaccount ON OULEVELSETTING.DEFAULTBANKACCOUNTID = bankaccount.ACCOUNTID LEFT JOIN MBIZTRANSACTION advancebiztransaction ON OULEVELSETTING.ADVANCEBIZTRANSACTIONID = advancebiztransaction.BIZTRANSACTIONID LEFT JOIN MACCOUNT advancecredit ON OULEVELSETTING.ADVANCECREDITACCOUNTID = advancecredit.ACCOUNTID LEFT JOIN MBIZTRANSACTION expensebiztransaction ON OULEVELSETTING.EXPENSEBIZTRANSACTIONID = expensebiztransaction.BIZTRANSACTIONID LEFT JOIN MACCOUNT expensecredit ON OULEVELSETTING.EXPENSECREDITACCOUNTID = expensecredit.ACCOUNTID LEFT JOIN MACCOUNT expensedebit ON OULEVELSETTING.EXPENSEDEBITACCOUNTID = expensedebit.ACCOUNTID LEFT JOIN MBIZTRANSACTION shortagebiztransaction ON OULEVELSETTING.SHORTAGEBIZTRANSACTIONID = shortagebiztransaction.BIZTRANSACTIONID LEFT JOIN MACCOUNT shortageaccount ON OULEVELSETTING.SHORTAGEACCOUNTID = shortageaccount.ACCOUNTID LEFT JOIN MBIZTRANSACTION hirechargebiztransaction ON OULEVELSETTING.HIRECHARGESBIZTRANSACTIONID = hirechargebiztransaction.BIZTRANSACTIONID LEFT JOIN MACCOUNT hirechargeaccount ON OULEVELSETTING.HIRECHARGESACCOUNTID = hirechargeaccount.ACCOUNTID LEFT JOIN MBIZTRANSACTION Branchtransfertransaction ON OULEVELSETTING.BRANCHTRANSFERINDENTBIZTRANSACTIONID = Branchtransfertransaction.BIZTRANSACTIONID LEFT JOIN MFORMULA ptformula ON OULEVELSETTING.PTFORMULAID = ptformula.FORMULAID LEFT JOIN MFORMULA ptcategoryformula ON OULEVELSETTING.PTCATEGORYFORMULAID = ptcategoryformula.FORMULAID LEFT JOIN MBIZTRANSACTION bookingbiztransaction ON OULEVELSETTING.BOOKINGBIZTRANSACTIONID = bookingbiztransaction.BIZTRANSACTIONID LEFT JOIN MFORMULA otexpressionformula ON OULEVELSETTING.OTEXPRESSIONFORMULAID = otexpressionformula.FORMULAID LEFT JOIN MFORMULA breaktimeexpressionformula ON OULEVELSETTING.BREAKTIMEEXPRESSIONFORMULAID = breaktimeexpressionformula.FORMULAID LEFT JOIN MGCM workgcm ON OULEVELSETTING.WORKSUBTYPEID = workgcm.GCMID LEFT JOIN MLEAVE compoff ON OULEVELSETTING.COMPOFFLEAVEID = compoff.LEAVEID LEFT JOIN MFORMULA PTGROSSFORMULA ON OULEVELSETTING.PTGROSSFORMULAID = PTGROSSFORMULA.FORMULAID LEFT JOIN MBIZTRANSACTION saleorderbiztransaction ON OULEVELSETTING.SALEORDERBIZTRANSACTIONID = saleorderbiztransaction.BIZTRANSACTIONID LEFT JOIN MBIZTRANSACTION saleinvoicebiztransaction ON OULEVELSETTING.SALEINVOICEBIZTRANSACTIONID = saleinvoicebiztransaction.BIZTRANSACTIONID LEFT JOIN MBIZTRANSACTION receiptbiztransaction ON OULEVELSETTING.RECEIPTBIZTRANSACTIONID = receiptbiztransaction.BIZTRANSACTIONID LEFT JOIN MFORMULA releivingformula ON OULEVELSETTING.RELEIVINGFORMULAID = releivingformula.FORMULAID LEFT JOIN MFORMULA terminationfromula ON OULEVELSETTING.TERMINATIONFORMULAID = terminationfromula.FORMULAID LEFT JOIN MFORMULA encashformula ON OULEVELSETTING.ENCASHFORMULAID = encashformula.FORMULAID LEFT JOIN MFORMULA ltaelementformula ON OULEVELSETTING.LTAELEMENTFORMULAID = ltaelementformula.FORMULAID LEFT JOIN MFORMULA ltaeligibledaysFormula ON OULEVELSETTING.LTAELIGIBLEDAYSFORMULAID = ltaeligibledaysFormula.FORMULAID LEFT JOIN MFORMULA ltaamountperdayformula ON OULEVELSETTING.LTAAMOUNTPERDAYFORMULAID = ltaamountperdayformula.FORMULAID LEFT JOIN MADDITIONDEDUCTION encashpostfield ON OULEVELSETTING.ENCASHPOSTFIELDID = encashpostfield.FIELDID WHERE (OULEVELSETTING.OUID = @ouid OR -1 = @ouid);"; public const string CHECK_OULEVELSETTING_EXISTS = @"SELECT COUNT(1) FROM MOULEVELSETTING WHERE OUID = @ouid;"; public const string GET_ALL_ACTIVE_OU_IDS = @"SELECT OUID FROM MORGANIZATIONUNIT WHERE OUID <> -1 AND STATUS = 1 ORDER BY OUID;"; public const string SAVE_OULEVELSETTING = @"INSERT INTO MOULEVELSETTING (OUID,RETIREMENTAGE,CHARGESPERKILOMETER,SALARYPAYABLEACCOUNTID,EPFEMPLOYERPERCENTAGE,EPFEMPLOYERACTUALPERCENTAGE,FPFAPPLICABLE,FPFEMPLOYERPERCENTAGE,FPFEMPLOYERACTUALPERCENTAGE,DLIEMPLOYERPERCENTAGE,DLIEMPLOYERACTUALPERCENTAGE,EPFEMPLOYEEPERCENTAGE,EPFEMPLOYEEACTUALPERCENTAGE,PFADMINPERCENTAGE,DLIADMINPERCENTAGE,PFBANKNAME,PFBANKADDRESS1,PFBANKADDRESS2,PFBANKADDRESS3,PFBANKADDRESS4,EPFEMPLOYEEID,EPFEMPLOYERID,FPFEMPLOYERID,DLIWAGESID,DLIEMPLOYERID,PFWAGESID,PENSIONWAGEDID,PFNUMBER,PFGROUP,EPFCODE,PFPOSTINGTYPEID,ESINUMBER,ESILOCALOFF,ESIDISPENSARY,ESIWAGECEILING,ESIEMPLOYEEPERCENTAGE,ESIEMPLOYERPERCENTAGE,ESIWAGEID,ESIEMPLOYEEID,ESIEMPLOYERID,ESILOPDAYSID,ESIVOLSHARPFID,ESIEARNEDBASICID,ESIUPTODTID,ESIPOSTINGTYPEID,TDSACCOUNTNUMBER,PANGIRNO,PAYNATURE,TDSFORMULAID,TDSPERCENTAGE,CIRCLEADDRESS1,CIRCLEADDRESS2,CIRCLEADDRESS3,CIRCLEADDRESS4,PACKEXCISESLNO,BACKDATEATTENDANCEDAY,PFLOPDAYSID,REPAYMENTBIZTRANSACTIONTYPEID,DLIADMINAMOUNTID,PFADMINAMOUNTID,INTERACCOUNTID,INTERBIZTRANSACTIONID,QUALITYWEIGHTAGE,RATEWEIGHTAGE,DELIVERYWEIGHTAGE,MRPBUYACTIONTYPE,MRPBUYBIZTRANSACTIONID,MRPMAKEACTIONTYPE,MRPMAKEBIZTRANSACTIONID,WORKORDERBIZTRANSACTIONID,SUBCONTRACTBIZTRANSACTIONID,DELIVERYOUID,TRANSFERSENDID,TRANSFERRECEIVEDID,PARTYID,PARTYBRANCHID,INDENTID,ADJUSTMENTBIZTRANSACTIONID,DELIVERYBIZTRANSACTIONID,ABSENTLEAVEID,INTERMMBIZTRANSACTIONID,LOADSIMPLEBOOKING,FROMCITYID,TOCITYID,FROMLOCATIONID,TOLOCATIONID,DELIVERYTRACK,TASKBIZTRANSACTIONID,ACTIVITYBIZTRANSACTIONID,TITLE,SUBJECT,KEYWORDS,CREATOR,PRODUCER,REASON,LOCATION,CHEQUEBOUNCEBIZTRANSACTIONID,BOUNCECHARGESACCOUNTID,SALARYGROSSFORMULAID,OVERTIMETYPE,ATTENDANCETYPE,AUTOCALLBIZTRANSACTIONID,GRATUITYDAYSFORMULAID,BONUSONAMOUNTFORMULAID,BONUSFORMULAID,DEFAULTBANKACCOUNTID,TRIPADVANCEPOSTINGTYPE,TRIPEXPENSEPOSTINGTYPE,TRIPSHORTAGEPOSTINGTYPE,TRIPHIRECHARGESPOSTINGTYPE,ADVANCEBIZTRANSACTIONID,ADVANCECREDITACCOUNTID,EXPENSEBIZTRANSACTIONID,EXPENSECREDITACCOUNTID,EXPENSEDEBITACCOUNTID,SHORTAGEBIZTRANSACTIONID,SHORTAGEACCOUNTID,HIRECHARGESBIZTRANSACTIONID,HIRECHARGESACCOUNTID,STOCKVALUATIONTYPE,BRANCHTRANSFERINDENTBIZTRANSACTIONID,PTFORMULAID,PTCATEGORYFORMULAID,BOOKINGBIZTRANSACTIONID,OTELIGABLEMINUTES,MAXIMUMOTINMONTH,MAXALLOWEDTIMEFORMALE,MAXALLOWEDTIMEFORFEMALE,MALEOTHOURSINEVENDAYS,FEMALEOTHOURSINEVENDAYS,MALEOTHOURSINODDDAYS,FEMALEOTHOURSINODDDAYS,OTEXPRESSIONFORMULAID,BREAKTIMEEXPRESSIONFORMULAID,COMPOFFLEAVEID,NETSALARYROUNDOFF,BATCHOTPIRUNDAYS,ISMSSAPPLICABLE,WORKSUBTYPEID,PTGROSSFORMULAID,SALEORDERBIZTRANSACTIONID,SALEINVOICEBIZTRANSACTIONID,RECEIPTBIZTRANSACTIONID,RELEIVINGFORMULAID,TERMINATIONFORMULAID,ENCASHSTATUS,ENCASHELIGIBLEDAYS,ENCASHMAXIMUMDAYS,ENCASHFORMULAID,ENCASHPOSTFIELDID,LTAELEMENTFORMULAID,LTAELIGIBLEDAYSFORMULAID,LTAAMOUNTPERDAYFORMULAID,ISSTOREWISEVALUATION,ADJUSTMENTTYPE) VALUES (@Id,@OULevelSettingRetirementAge,@OULevelSettingChargesPerKilometer,@SalaryPayableAccountId,@OULevelSettingEPFEmployerPercentage,@OULevelSettingEPFEmployerActualPercentage,@OULevelSettingFPFApplicable,@OULevelSettingFPFEmployerPercentage,@OULevelSettingFPFEmployerActualPercentage,@OULevelSettingDLIEmployerPercentage,@OULevelSettingDLIEmployerActualPercentage,@OULevelSettingEPFEmployeePercentage,@OULevelSettingEPFEmployeeActualPercentage,@OULevelSettingPFAdminPercentage,@OULevelSettingDLIAdminPercentage,@OULevelSettingPFBankName,@OULevelSettingPFBankAddress1,@OULevelSettingPFBankAddress2,@OULevelSettingPFBankAddress3,@OULevelSettingPFBankAddress4,@EPFEmployeeId,@EPFEmployerId,@FPFEmployerId,@DLIWagesId,@DLIEmployerId,@PFWagesId,@PensionWagedId,@OULevelSettingPFNumber,@OULevelSettingPFGroup,@OULevelSettingEPFCode,@PFPostingTypeId,@OULevelSettingESINumber,@OULevelSettingESILocalOff,@OULevelSettingESIDispensary,@OULevelSettingESIWageceiling,@OULevelSettingESIEmployeePercentage,@OULevelSettingESIEmployerPercentage,@ESIWageId,@ESIEmployeeId,@ESIEmployerId,@ESILopDaysId,@ESIVolSharpId,@ESIEarnedBasicId,@ESIUpToDtId,@ESIPostingTypeId,@OULevelSettingTDSAccountNumber,@OULevelSettingPangirNo,@OULevelSettingPayNature,@TDSFormulaId,@OULevelSettingTDSPercentage,@OULevelSettingCircleAddress1,@OULevelSettingCircleAddress2,@OULevelSettingCircleAddress3,@OULevelSettingCircleAddress4,@OULevelSettingPackExciseSlNo,@OULevelSettingBackDateAttendanceDay,@PFLopDaysId,@RepaymentPostingTypeId,@DLIAdminAmountId,@PFAdminAmountId,@InterAccountId,@InterBIZTransactionId,@OULevelSettingQualityWeightage,@OULevelSettingRateWeightage,@OULevelSettingDeliveryWeightage,@OULevelSettingMRPBuyActionType,@MRPBizTransactionId,@OULevelSettingMRPMakeActionType,@MRPMakeBizTransactionId,@WorkOrderBizTransactionId,@SubContractBizTransactionId,@DeliveryOuId,@TransferSendId,@TransferReceivedId,@PartyId,@PartyBranchId,@IndentId,@AdjustmentBizTransactionId,@DeliveryBizTransactionId,@AbsentLeaveId,@InterMMBiztransactionId,@IsLoadSimpleBooking,@FromCityId,@ToCityId,@FromLocationId,@ToLocationId,@DeliveryTrack,@ToDoBiztransactionId,@ActivityBiztransactionId,@OULevelSettingTitle,@OULevelSettingSubject,@OULevelSettingKeywords,@OULevelSettingCreator,@OULevelSettingProducer,@OULevelSettingReason,@OULevelSettingLocation,@ChequeBounceBIZtransactionId,@BounceChargesAccountId,@SalaryGrossFormulaId,@OULevelSettingOvertimeType,@OULevelSettingAttendanceType,@AutoCallBIZTransactionId,@GratutiDaysFormulaId,@BonusonAmountFormulaId,@BonusFormulaId,@DefaultBankAccountId,@OULevelSettingTripAdvancePostingType,@OULevelSettingTripExpensePostingType,@OULevelSettingTripShortagePostingType,@OULevelSettingTripHireChargesPostingType,@AdvanceBIZtransactionId,@AdvanceCreditAccountId,@ExpenseBIZtransactionId,@ExpenseCreditAccountId,@ExpenseDebitAccountId,@ShortageBIZtransactionId,@ShortageAccountId,@HireChargesBIZtransactionId,@HireChargesAccountId,@OULevelSettingStockvaluationType,@BranchTransferBiztransactionId,@PTFormulaId,@PTCategoryFormulaId,@BookingBiztransactionId,@OULevelSettingOTEligableMinutes,@OULevelSettingMaximumOTInMonth,@OULevelSettingMaxAllowedOTForMale,@OULevelSettingMaxAllowedOTForFemale,@OULevelSettingMaleOTHoursInEvenDays,@OULevelSettingFemaleOTHoursInEvenDays,@OULevelSettingMaleOTHoursInOddDays,@OULevelSettingFemaleOTHoursInOddDays,@OTExpressionFormulaId,@BreakTimeExpressionFormulaId,@CompOffLeaveId,@OULevelSettingNetSalaryRoundOff,@OULevelSettingBatchOTPIRunDays,@OULevelSettingIsMssApplicable,@WorkSubTypeId,@PTGrossFormulaId,@SaleOrderBizTransactionId,@SaleInvoiceBizTransactionId,@ReceiptBizTransactionId,@ReleivingFormulaId,@TerminationFormulaId,@OULevelSettingEncashStatus,@OULevelSettingEncashEligibleDays,@OULevelSettingEncashMaximumDays,@EncashFormulaId,@EncashPostFieldId,@LTAElementFormulaId,@LTAEligibleDaysFormulaId,@LTAAmountPerDayFormulaId,@OULevelSettingIsStorewiseValuation,@OULevelSettingAdjustmentType);"; public const string UPDATE_OULEVELSETTING = @"UPDATE MOULEVELSETTING SET RETIREMENTAGE = @OULevelSettingRetirementAge, CHARGESPERKILOMETER = @OULevelSettingChargesPerKilometer, SALARYPAYABLEACCOUNTID = @SalaryPayableAccountId, EPFEMPLOYERPERCENTAGE = @OULevelSettingEPFEmployerPercentage, EPFEMPLOYERACTUALPERCENTAGE = @OULevelSettingEPFEmployerActualPercentage, FPFAPPLICABLE = @OULevelSettingFPFApplicable, FPFEMPLOYERPERCENTAGE = @OULevelSettingFPFEmployerPercentage, FPFEMPLOYERACTUALPERCENTAGE = @OULevelSettingFPFEmployerActualPercentage, DLIEMPLOYERPERCENTAGE = @OULevelSettingDLIEmployerPercentage, DLIEMPLOYERACTUALPERCENTAGE = @OULevelSettingDLIEmployerActualPercentage, EPFEMPLOYEEPERCENTAGE = @OULevelSettingEPFEmployeePercentage, EPFEMPLOYEEACTUALPERCENTAGE = @OULevelSettingEPFEmployeeActualPercentage, PFADMINPERCENTAGE = @OULevelSettingPFAdminPercentage, DLIADMINPERCENTAGE = @OULevelSettingDLIAdminPercentage, PFBANKNAME = @OULevelSettingPFBankName, PFBANKADDRESS1 = @OULevelSettingPFBankAddress1, PFBANKADDRESS2 = @OULevelSettingPFBankAddress2, PFBANKADDRESS3 = @OULevelSettingPFBankAddress3, PFBANKADDRESS4 = @OULevelSettingPFBankAddress4, EPFEMPLOYEEID = @EPFEmployeeId, EPFEMPLOYERID = @EPFEmployerId, FPFEMPLOYERID = @FPFEmployerId, DLIWAGESID = @DLIWagesId, DLIEMPLOYERID = @DLIEmployerId, PFWAGESID = @PFWagesId, PENSIONWAGEDID = @PensionWagedId, PFNUMBER = @OULevelSettingPFNumber, PFGROUP = @OULevelSettingPFGroup, EPFCODE = @OULevelSettingEPFCode, PFPOSTINGTYPEID = @PFPostingTypeId, ESINUMBER = @OULevelSettingESINumber, ESILOCALOFF = @OULevelSettingESILocalOff, ESIDISPENSARY = @OULevelSettingESIDispensary, ESIWAGECEILING = @OULevelSettingESIWageceiling, ESIEMPLOYEEPERCENTAGE = @OULevelSettingESIEmployeePercentage, ESIEMPLOYERPERCENTAGE = @OULevelSettingESIEmployerPercentage, ESIWAGEID = @ESIWageId, ESIEMPLOYEEID = @ESIEmployeeId, ESIEMPLOYERID = @ESIEmployerId, ESILOPDAYSID = @ESILopDaysId, ESIVOLSHARPFID = @ESIVolSharpId, ESIEARNEDBASICID = @ESIEarnedBasicId, ESIUPTODTID = @ESIUpToDtId, ESIPOSTINGTYPEID = @ESIPostingTypeId, TDSACCOUNTNUMBER = @OULevelSettingTDSAccountNumber, PANGIRNO = @OULevelSettingPangirNo, PAYNATURE = @OULevelSettingPayNature, TDSFORMULAID = @TDSFormulaId, TDSPERCENTAGE = @OULevelSettingTDSPercentage, CIRCLEADDRESS1 = @OULevelSettingCircleAddress1, CIRCLEADDRESS2 = @OULevelSettingCircleAddress2, CIRCLEADDRESS3 = @OULevelSettingCircleAddress3, CIRCLEADDRESS4 = @OULevelSettingCircleAddress4, PACKEXCISESLNO = @OULevelSettingPackExciseSlNo, BACKDATEATTENDANCEDAY = @OULevelSettingBackDateAttendanceDay, PFLOPDAYSID = @PFLopDaysId, REPAYMENTBIZTRANSACTIONTYPEID = @RepaymentPostingTypeId, DLIADMINAMOUNTID = @DLIAdminAmountId, PFADMINAMOUNTID = @PFAdminAmountId, INTERACCOUNTID = @InterAccountId, INTERBIZTRANSACTIONID = @InterBIZTransactionId, QUALITYWEIGHTAGE = @OULevelSettingQualityWeightage, RATEWEIGHTAGE = @OULevelSettingRateWeightage, DELIVERYWEIGHTAGE = @OULevelSettingDeliveryWeightage, MRPBUYACTIONTYPE = @OULevelSettingMRPBuyActionType, MRPBUYBIZTRANSACTIONID = @MRPBizTransactionId, MRPMAKEACTIONTYPE = @OULevelSettingMRPMakeActionType, MRPMAKEBIZTRANSACTIONID = @MRPMakeBizTransactionId, WORKORDERBIZTRANSACTIONID = @WorkOrderBizTransactionId, SUBCONTRACTBIZTRANSACTIONID = @SubContractBizTransactionId, DELIVERYOUID = @DeliveryOuId, TRANSFERSENDID = @TransferSendId, TRANSFERRECEIVEDID = @TransferReceivedId, PARTYID = @PartyId, PARTYBRANCHID = @PartyBranchId, INDENTID = @IndentId, ADJUSTMENTBIZTRANSACTIONID = @AdjustmentBizTransactionId, DELIVERYBIZTRANSACTIONID = @DeliveryBizTransactionId, ABSENTLEAVEID = @AbsentLeaveId, INTERMMBIZTRANSACTIONID = @InterMMBiztransactionId, LOADSIMPLEBOOKING = @IsLoadSimpleBooking, FROMCITYID = @FromCityId, TOCITYID = @ToCityId, FROMLOCATIONID = @FromLocationId, TOLOCATIONID = @ToLocationId, DELIVERYTRACK = @DeliveryTrack, TASKBIZTRANSACTIONID = @ToDoBiztransactionId, ACTIVITYBIZTRANSACTIONID = @ActivityBiztransactionId, TITLE = @OULevelSettingTitle, SUBJECT = @OULevelSettingSubject, KEYWORDS = @OULevelSettingKeywords, CREATOR = @OULevelSettingCreator, PRODUCER = @OULevelSettingProducer, REASON = @OULevelSettingReason, LOCATION = @OULevelSettingLocation, CHEQUEBOUNCEBIZTRANSACTIONID = @ChequeBounceBIZtransactionId, BOUNCECHARGESACCOUNTID = @BounceChargesAccountId, SALARYGROSSFORMULAID = @SalaryGrossFormulaId, OVERTIMETYPE = @OULevelSettingOvertimeType, ATTENDANCETYPE = @OULevelSettingAttendanceType, AUTOCALLBIZTRANSACTIONID = @AutoCallBIZTransactionId, GRATUITYDAYSFORMULAID = @GratutiDaysFormulaId, BONUSONAMOUNTFORMULAID = @BonusonAmountFormulaId, BONUSFORMULAID = @BonusFormulaId, DEFAULTBANKACCOUNTID = @DefaultBankAccountId, TRIPADVANCEPOSTINGTYPE = @OULevelSettingTripAdvancePostingType, TRIPEXPENSEPOSTINGTYPE = @OULevelSettingTripExpensePostingType, TRIPSHORTAGEPOSTINGTYPE = @OULevelSettingTripShortagePostingType, TRIPHIRECHARGESPOSTINGTYPE = @OULevelSettingTripHireChargesPostingType, ADVANCEBIZTRANSACTIONID = @AdvanceBIZtransactionId, ADVANCECREDITACCOUNTID = @AdvanceCreditAccountId, EXPENSEBIZTRANSACTIONID = @ExpenseBIZtransactionId, EXPENSECREDITACCOUNTID = @ExpenseCreditAccountId, EXPENSEDEBITACCOUNTID = @ExpenseDebitAccountId, SHORTAGEBIZTRANSACTIONID = @ShortageBIZtransactionId, SHORTAGEACCOUNTID = @ShortageAccountId, HIRECHARGESBIZTRANSACTIONID = @HireChargesBIZtransactionId, HIRECHARGESACCOUNTID = @HireChargesAccountId, STOCKVALUATIONTYPE = @OULevelSettingStockvaluationType, BRANCHTRANSFERINDENTBIZTRANSACTIONID = @BranchTransferBiztransactionId, PTFORMULAID = @PTFormulaId, PTCATEGORYFORMULAID = @PTCategoryFormulaId, BOOKINGBIZTRANSACTIONID = @BookingBiztransactionId, OTELIGABLEMINUTES = @OULevelSettingOTEligableMinutes, MAXIMUMOTINMONTH = @OULevelSettingMaximumOTInMonth, MAXALLOWEDTIMEFORMALE = @OULevelSettingMaxAllowedOTForMale, MAXALLOWEDTIMEFORFEMALE = @OULevelSettingMaxAllowedOTForFemale, MALEOTHOURSINEVENDAYS = @OULevelSettingMaleOTHoursInEvenDays, FEMALEOTHOURSINEVENDAYS = @OULevelSettingFemaleOTHoursInEvenDays, MALEOTHOURSINODDDAYS = @OULevelSettingMaleOTHoursInOddDays, FEMALEOTHOURSINODDDAYS = @OULevelSettingFemaleOTHoursInOddDays, OTEXPRESSIONFORMULAID = @OTExpressionFormulaId, BREAKTIMEEXPRESSIONFORMULAID = @BreakTimeExpressionFormulaId, COMPOFFLEAVEID = @CompOffLeaveId, NETSALARYROUNDOFF = @OULevelSettingNetSalaryRoundOff, BATCHOTPIRUNDAYS = @OULevelSettingBatchOTPIRunDays, ISMSSAPPLICABLE = @OULevelSettingIsMssApplicable, WORKSUBTYPEID = @WorkSubTypeId, PTGROSSFORMULAID = @PTGrossFormulaId, SALEORDERBIZTRANSACTIONID = @SaleOrderBizTransactionId, SALEINVOICEBIZTRANSACTIONID = @SaleInvoiceBizTransactionId, RECEIPTBIZTRANSACTIONID = @ReceiptBizTransactionId, RELEIVINGFORMULAID = @ReleivingFormulaId, TERMINATIONFORMULAID = @TerminationFormulaId, ENCASHSTATUS = @OULevelSettingEncashStatus, ENCASHELIGIBLEDAYS = @OULevelSettingEncashEligibleDays, ENCASHMAXIMUMDAYS = @OULevelSettingEncashMaximumDays, ENCASHFORMULAID = @EncashFormulaId, ENCASHPOSTFIELDID = @EncashPostFieldId, LTAELEMENTFORMULAID = @LTAElementFormulaId, LTAELIGIBLEDAYSFORMULAID = @LTAEligibleDaysFormulaId, LTAAMOUNTPERDAYFORMULAID = @LTAAmountPerDayFormulaId, ISSTOREWISEVALUATION = @OULevelSettingIsStorewiseValuation, ADJUSTMENTTYPE = @OULevelSettingAdjustmentType WHERE OUID = @Id;"; public const string DELETE_OULEVELSETTING = @"DELETE FROM MOULEVELSETTING WHERE OUID = @ouid;"; public const string GET_OULEVELSETTINGFIELDS = @"SELECT a.OUID AS Id FROM MOULEVELSETTING a WHERE (@deliveryouid = -1 OR (a.DELIVERYOUID = @deliveryouid OR a.DELIVERYOUID = -1));"; } }