# 11 Function Name : AddLeadDays Inputs Date String YYYYMMDD and Days integer.

# 20 AddYears2Date Inputs: Date String in YYYYMMDD and Years months and days to be added (eg., 22 Yrs 11 Months 2 Days) # Outputs Date in String YYYYMMDD 20220220 ©  FuturaInsTech.

#106 New Function to do Amount in Words in Receipts Inputs: Company, Amount, Currency # Outputs Values in Words ©  FuturaInsTech.

# 112 CalBonus - Calculate Bonus due on Anniversary Date NOTE: THIS IS CLONED FROM GetBonusByYear not to impact to other functions.

# 33 CalcFrequencyPrem - Calculate Frequency Premium as per Model Factor Provided Inputs: Company, Frequency Factor Method as mentioned in Q0006, Current Frequency, Annualized Premium of the Coverage Output Model Premium = Model Factor * Annualized Premium.

# 113 CalcInterimBonus - Calculate Interim Bonus using Interim Bonus Rates # Input: Company, Coverage, BonusMethod, StartDate, EffectiveDate, Bonus Date, Coverage Status, Sum Assured, Term, Premium Term # Output: Calculted Interim Bonus Amount as float64 # Date in YYYYMMDD as a string ©  FuturaInsTech.

# 155 ILP Products Only.

# 129 CalcMortPrem - Calculate Mortality Premium for ILP Inputs: Company, Policy, Benefit ID, History Code, Effective Date # Outputs Mortality Premium for the Frequency, Next Due Date and Error ©  FuturaInsTech.

# 115 CalRBonus - Calculate Bonus due on Annniversary Date OR Bonus Date # Input: Company, Coverage , Bonus Method, Coverage Start Date, Anniversary Date OR Bonus Date, Policy Status, Coverage SA, Coverage Term, Coverage Premium Term # Output: Calculted Bonus Amount as float64 # Date in YYYYMMDD as a string ©  FuturaInsTech.

# 32 CalcSaPremDiscount - Calculate Discounted Amount based on SA or Annualised Prem Inputs: Company, Discount Type (S/P) , Discount Method (As per Product), Annualised Prem SA Amount # Outputs Discounted Amount as float ©  FuturaInsTech.

#159 ILP Products Only.

********************************************************************************************* # 2 From Date Generally DOB To Date Generally RCD In case From Date is Lesser than To Date, it will be swapped internally Change YYYYMMDD format into Golang Date Format imethod is method used .

# 53 CalculateStampDuty - To Calculate Stamp Duty Inputs: Company, Coverage, Date in YYYYMMDD and SA YYYYMMDD generally Inception Date # Stamp Duty Value # Parameter USed P0036 This Function has to be used during NB as well as when SA increased ©  FuturaInsTech.

#69 CalculateStampDutyByPolicy - Stamp Duty for a Policy Inputs: Company, Policy # Outputs Stamp Duty ©  FuturaInsTech.

#185 Stamp Duty for Loan Calculation Inputs: CompanyID, SD Rate, Loan Amt, PolicyID # Outputs Stamp Duty Amount ©  FuturaInsTech.

# 130 CalcPolicyFee - Calculate PolicyFee for ILP Inputs: Company, Policy, Benefit Code, Benefit Code, Start Date of Benefit, Effective Date, Fee Method and Fee Frequency # Outputs Policy Fee for the Frequency, Next Due Date and Error ©  FuturaInsTech.

#207 CheckDateOpt - Utility to confirm if Date's opt value given is correct or incorrect Returns true if the given date satifies the opt value given Input: iDate # Output: true or false ©  FuturaInsTech.

#198 CheckNegativeFund from the fund value Inputs: CompanyID, iPolicy, iEffectiveDate, iHistoryCode # Outputs: oAmount,oStatus, ONegativeUnitsOrAmt ©  FuturaInsTech.

# 132 CheckPendingILP - Check Pending ILP Transaction on a Policy Inputs: Company, Policy, Benefit Code # Outputs Error Description ©  FuturaInsTech.

#103 Check Status # This function, take company code, history code, date and status as inputs # It returns status which is boolean and also output status which is string ©  FuturaInsTech.

# 13 Function : CompoundInterest # Purpose to Calculate Compounding Interest for a Given Days # Inputs Amount, Interest as float , Days # Outputs Actual Interest ©  FuturaInsTech.

# 21 Convert Map to Strucutre Inputs: Map and Interface # Outputs Error ©  FuturaInsTech.

#104 Create Communication # This function, Create Communication Records by getting input values as Company ID, History Code, Tranno, Date of Transaction, Policy Id, Client Id, Address Id, Receipt ID .

194 CreateCommunicationL for loan Inputs: CompanyID, PolicyID, ..

#104 Create Communication (New Version with Rollback) # This function, Create Communication Records by getting input values as Company ID, History Code, Tranno, Date of Transaction, Policy Id, Client Id, Address Id, Receipt ID .

# 166 Create Hisotry Records (New Version) Inputs: Company, Policy, Method, Effective Date, Max Tranno, user,Hisotry Map # Outputs: error, ©  FuturaInsTech.

#111 ********************************************************************************************* This Function is to CreateReceipt Input Values are Company Code, Policy , Address, Amount, Collection Date, Currency, Collection Type, Reference Output Values are Receipt No and Error ©  FuturaInsTech ***.

# 24 Levels AddYears2Date Inputs: # Outputs ©  FuturaInsTech.

# 4 ********************************************************************************************* Author Ranga Convert Date format into String as YYYYMMDD FuturaInsTech *********************************************************************************************.

# 58 DateConvert - Convert Date into DD / MM / YYYY Format Inputs: Date in YYYYMMDD Outputs : DD/MM/YYYY ©  FuturaInsTech.

********************************************************************************************* # 1 Find out Difference between two Dates Date should be in 2029-11-05 00:00:00 +0000 UTC # Outputs are Years, Months, Days, Hours, Minutes, Seconds ©  FuturaInsTech *********************************************************************************************.

# 156 ILP Products Only.

GeneratePdf generates our pdf by adding text and images to the page then saving it to a file (name specified in params).

#88 GetAddressData - Printing Purpose Only Inputs: Company, Policy, Client, Address, Receipt and Date # Outputs Address Details as an Interface ©  FuturaInsTech.

# 123 GetaFundValue - Get Fund Value per Policy (Across All Benefits) Inputs: Company, Policy, Fund Code, Fund Price Date # Outputs Bid Amount, Offer Amount, Effective Date ©  FuturaInsTech.

# 125 GetFundValueByBeneift - Get Fund Summary based on a Benefit ID Inputs: Company, Policy, Benefit ID, Fund Code, Fund Price Date # Outputs Bid Amount, Offer Amount, Effective Date ©  FuturaInsTech.

#101 GetAgency Data - Printing Purpose Only Inputs: Company, Policy, Client, Address, Receipt, Agency and Date # Outputs Agency ©  FuturaInsTech.

#205 GetCalcDates - Utility to return a series of calculated dates Returns a Series of Calculated Dates - adjusted by mnth - optionally to return [B]eginning or [E]nding of the month or [N] day in iDate Inputs: DateFrom & DateTo in YYYYMMDD, month between -12 and 12, option B/E/N Dependant on #204 GetCalcDate # Outputs: An array of Calc Dates in YYYYMMDD between DateFrom & DateTo and Time format calc Date.

# 124 GetAllFundValueByBenefit - Get All Fund Values for a Given Benefit ID Inputs: Company, Policy, Benefit ID, Fund Code, Fund Price Date # Outputs Bid Amount, Offer Amount, Effective Date ©  FuturaInsTech.

# 122.

#188 OS Loan and OS Loan Interest Calculation Inputs: CompanyID, PolicyID, Effective Date # Outputs Outstanding Loan and Loan Interest ©  FuturaInsTech.

# 134 GetAllowedFunds - This function return all allowed funds for a particular benefit Inputs: Company, Coverage Code and Coverage Start Date Outputs : Fund Array consist of fund code, fund category, fund type and fund currency and error code ©  FuturaInsTech.

#17 GetAnnualPrem Inputs Premium float64, Frequency (Y/H/Q/M/S) # Outputs Annualized Premium float64 ©  FuturaInsTech.

# 22 GetAnnualRate - Get Annual Rate of the Coverage - No Model Discount/Staff Discount/SA/Prem Discount Inputs: Company, Coverage, Age (Attained Age), Gender(F/N/U), Term (2 Characters), Premium Method as PM001 - Term Based , PM002 Age Based, Mortality Clause "S" Smoker, "N" Non Smoker Outputs Annualized Premium as float (124.22) ©  FuturaInsTech.

#90 GetBenefitData - Printing Purpose Only Inputs: Company, Policy, Client, Address, Receipt and Date # Outputs Benefit Details as an Interface ©  FuturaInsTech.

# 28 GetBonus - Get Bonus for a Given Duration Inputs: Company, Bonus Method, Status, Coverage Start Date, Year of Policy, Policy Status, SA # Date in YYYYMMDD as a string # Outputs SB Term and SB Percentage ©  FuturaInsTech.

# 29 GetBonusByYear - Get Bonus for a Given Year Array of 10 Allowed Inputs: Company, Coverage , Bonus Method, Status, Coverage Start Date, Year of Policy, Policy Status, SA Date in YYYYMMDD as a string.

#100 GetBonsusValues Data - Printing Purpose Only Inputs: Company, Policy, Client, Address, Receipt and Date # Outputs Bonus Values ©  FuturaInsTech.

#80 Get Business Date Inputs: Company, User and Departemet # Outputs Business Date ©  FuturaInsTech 01 - NB 02 - Cash and Payment 03 - Maturity 04 - Death Claim 05 - Customer Service 06.

#204 GetCalcDate - Utility to return a calculated date Returns Calculated Date - adjusted by mnth - optionally to return [B]eginning or [E]nding of the month or [N] day in iDate - additionally verifying to return the given day if available in the month Inputs: YYYYMMDD Date, month between -12 and 12, option B/E/N, original day in iDate # Outputs: YYYYMMDD calc Date and Time format calc Date.

#87 GetClient Data - Printing Purpose Only Inputs: Company, Policy, Client, Address, Receipt and Date # Outputs Client Details as an Interface ©  FuturaInsTech.

#183 Get ClientWork Data - Printing Purpose Only Inputs: Company, Policy, Client, Address, Receipt and Date # Outputs Client Work Details as an Interface ©  FuturaInsTech.

#176 GetCoCurrIdName Inputs: Company Id # Outputs Currency ShortName and Currency LongName ©  FuturaInsTech.

# 40 GetCommissionRates - Get Commission Rates Inputs: Company, Coverage, Nof Instalments Collected (so far) and Date String in YYYYMMDD # Outputs Commission Rate ©  FuturaInsTech.

#95 GetCompAddData - Printing Purpose Only Inputs: Company, Policy, Client, Address, Receipt and Date # Outputs Component Add Details as an Interface ©  FuturaInsTech.

#86 GetCompany Data - Printing Purpose Only Inputs: Company, Policy, Client, Address, Receipt and Date # Outputs Company Details as an Interface ©  FuturaInsTech.

#175 GetCurrencyNamebyId Inputs: curr_id # Outputs Currency ShortName and Currency LongName ©  FuturaInsTech.

#206 GetDateOpt - Utility to find if the date is [B]eginning or [E]nding or [N]ormal Date Returns the option value as B/E/N of given date Input: iDate # Output: B or E or N.

# 56 GetDeathAmount - Give Death Amount based on coverage and reason of death Inputs: Company Code, Policy, Coverage, Effective Date and cause of Death # Death Amount ©  FuturaInsTech.

# 56 GetDeathAmountN - Give Death Amount based on coverage and reason of death using txn Inputs: Company Code, Policy, Coverage, Effective Date and cause of Death # Death Amount ©  FuturaInsTech.

# 98 (Redundant) Not in Use GetDeath Data - Printing Purpose Only Inputs: Company, Policy, Client, Address, Receipt and Date # Outputs Death Details as an Interface ©  FuturaInsTech Not Required.

# 119 GetErrorDesc - Get Error Description Inputs: Company, Language, Short Code # Long Description, Error ©  FuturaInsTech.

#102 GetExpi Data - Printing Purpose Only Inputs: Company, Policy, Client, Address, Receipt and Date # Outputs Expiry Interface Information ©  FuturaInsTech.

# 143 GetFundCPrice - Fetch the Available Fund Price approved to use as Current Price in calculations Inputs: Company, Fund Code, Processing Date # Outputs: Bid Price, Offer Price and Date of Price © FuturaInsTech.

#84 Get Future Date (Redundant) GetNextDue Could be used Inputs: From Date, Todate and Frequency # Outputs New Date ©  FuturaInsTech.

# 54 GetGlBal - To Get GL Balance for a given account code Inputs: Company, Policy, GL Account Code # Output GL Amount ©  FuturaInsTech.

# 140 Get GL Data Printing Purpose Only Inputs: Company Policy, From and To Date, History Code, GL Code,GL Sign Outputs : GL Data as interface ©  FuturaInsTech.

# 37 GetGSTPercentage - Get GST Percemtage for a given months Inputs: Company, Coverage and Date String in YYYYMMDD (Current Date), Key is Coverage Code, No of Months, Amount to be charged # Outputs GST Amount ©  FuturaInsTech.

#126 # GetILPAlloc - Get ILP Allocation Based on From and To Date Inputs: Company, Policy, Frequency, Start Date of Policy, Premium Adjusted Date, Coverage Code, Allocation Method, Gender, Amount Collected # Outputs Allocated , Non Allocated and Error ©  FuturaInsTech.

# 147 # GetIlpAnnsummaryData - ILP Anniversary Summary Data extraction for Communications © FuturaInsTech.

# 150 # GetIlpFundUnits - To return the current available Units in a Fund Inputs: Company, Policy, Benefit, Fund Code # Outputs: Return the available Units against the given Fund # Error: If given fund does not exist in the policy, then return zeroes.

# 162 GetIlpFundData - Get ILP Fund DAta (Printing Purpose Only) Inputs: Company, # Outputs: ©  FuturaInsTech.

#158 ILP Products Only.

# 138 # GetIlpFundUnits - To return the current available Units in a Fund Inputs: Company, Policy, Benefit, Fund Code # Outputs: Return the available Units against the given Fund # Error: If given fund does not exist in the policy, then return zeroes.

#197 Get IlpMortality and IlpFee values from the benefit Inputs: CompanyID, iBenefit # Outputs: IlpMortality,IlpFee,totUnpaidInterest ©  FuturaInsTech.

# 139 Get ILP Summary Data Printing Purpose Only Inputs: Company and Policy Outputs : Summary Data as interface ©  FuturaInsTech.

# 146 # GetIlpTranctionData - ILP transaction Data extraction for Communications © FuturaInsTech.

# 16 Function : ValidateItem # Inputs Company, Business Rule, Business Rule ID, From Date, Data # Outputs Error ©  FuturaInsTech.

#201 GetLoanIntrest from the loan table Inputs: CompanyID, iPolicy, iEffectiveDate,loantype # Outputs: LoanAmount, oLoanInt ©  FuturaInsTech.

#186 Get Loan Data Inputs: CompanyID, PolicyID and EffectiveDate # Outputs All Loan Data with Total Loan Details ©  FuturaInsTech.

#98 GetMatH Data - Printing Purpose Only (both header and detail) Inputs: Company, Policy, Client, Address, Receipt and Date # Outputs Maturity Header and Details Interface ©  FuturaInsTech.

#85 GetMaturityAmount - Get Maturity Amount Inputs: Company, Policy, Coverage, Effective Date # Outputs Maturity Amount ©  FuturaInsTech.

#189 Get Next Loan Number (Increment and return to use for new Loan) Inputs: CompanyID, PolicyID # Outputs Next Loan Sequence Number (Maximum Loan Number + 1) ©  FuturaInsTech.

# 38 GetMaxTranno - Get Transaction No and History Code Inputs: Company, Policy No, Method, Effective Date, User # Outputs History Code and New Tranno # It update PHISTORY Table ©  FuturaInsTech.

# 165 GetMaxTranno (New Version) Inputs: Company, Policy, Method, Effective Date, user # Outputs: uint ©  FuturaInsTech.

# 38 GetMaxTranno - Get Transaction No and History Code Inputs: Company, Policy No, Method, Effective Date, User # Outputs History Code and New Tranno # It update PHISTORY Table ©  FuturaInsTech.

# 65 GetMRTABenefit - SA, Interest Rate, Policy Year, Interim Period, Term Inputs: Company, Coverage and Date String in YYYYMMDD (Current Date), Key is Coverage Code, No of Months, Amount to be charged # Outputs Benefit ©  FuturaInsTech.

#92 GetMRTAData - Printing Purpose Only Inputs: Company, Policy, Client, Address, Receipt and Date # Outputs MRTA Details as an Interface ©  FuturaInsTech.

# 133 GetMrtaPrem - calculate MRTA Premium (New Version) Inputs: Company, Benefit Code, Initial SA, Initial Age, Gender, Term , Premium Paying Term, Interest, Interim Period, Start Date # Outputs Premium and Error Description ©  FuturaInsTech.

#66 GetMrtaPremO - MRTA Premium Inputs: Company, Coverage , Age Gender , Term, Premium Paying Term, Prem Method, Date String in YYYYMMDD and Mortality # Outputs MRTA Premium and Error ©  FuturaInsTech.

#105 Get Name # This function, Return Name of the Client in Long Name + Short Name + Sur Name Format # Input Variables Company Code and Client Code # Return is Name ©  FuturaInsTech.

# 142 ********************************************************************************************* Method : GetNewPremium Calculate Annual Premium and Model Premium (With Discount and Frequency Loading) # Inputs Company, Coverage Code, Start Date of Coverage, Age , Gender, Risk Term, Premium Term, Mortality Class, Sum Assured, Premium Method (Q0006), Discount Type, Discount Method, Frequency Method, Frequency # Outputs Annual Premium and Model Premium ©  FuturaInsTech.

# 5 ********************************************************************************************* This GetNextDue Function Give NextDue Date based on the frequency provided Inputs Date YYYYMMDD Frequency (Y/H/Q/M/S) Reversal Indicator (R) It Convert string into Date Fromat using DateFormat Function Then depends upon the frequency next due date is arrived If Reversal is "R" then previous Due Date will be calcualted.

#18 GetNextYr Inputs FromDate String (YYYYMMDD) Outputs ToDate String (YYYYMMDD) ©  FuturaInsTech.

# 7 ********************************************************************************************* To Calculate No of instalments Paid Inputs are From Date in YYYYMMDD, To Date in YYYYMMDD, Frequency (Y/H/Q/M/S) # Output Value is No of instalements ©  FuturaInsTech *********************************************************************************************.

#97 GetNominee Data - Printing Purpose Only Inputs: Company, Policy, Client, Address, Receipt and Date # Outputs Nominee Details as an Interface ©  FuturaInsTech.

# 161 GetP0050ItemCodeDesc - Get the Description of an item's Code Inputs: Company, ParamItem and Language # Outputs: Description ©  FuturaInsTech.

#199 GetP0059 from the param Inputs: CompanyID, iPolicy, iEffectiveDate, iHistoryCode # Outputs: oNegativeAmount, oNegativeMonths ©  FuturaInsTech.

#200 GetP0059 from the param Inputs: CompanyID, iPolicy, iEffectiveDate # Outputs: p0069Month, NoOfMonths ©  FuturaInsTech.

# 9 ********************************************************************************************* Function Name : GetPaidUp # Calculate Paidup Up Value Input Values RCD Date, Paid To Date, Premium Cessation Date in YYYYMMDD Format Frequency (Y/H/Q/M/S) Output is (Paid/Payable) * SA as float ©  FuturaInsTech *********************************************************************************************.

ITDMIO itemcoy = 2, itemtabl = 'T5687' itemitem = '091R' ITMFRM = 20220101.

# 43 GetParamDesc - Get Long and Short Description of an item Inputs: Company, Param , Param ITem and Language # Outputs Short Description, Long Description and Error ©  FuturaInsTech.

#174 GetPayingAuthorityData - Printing Purpose Only Inputs: Company, Pa, Client, Address, Receipt and Date # Outputs Paying Authority Details as an Interface ©  FuturaInsTech.

# 170 Get Previous Benefits Data (New Version) Inputs: CompanyID, PolicyID, HistoryCode, Tranno # Outputs: JSON Benefits Data © FuturaInsTech.

#157 GetPHistoryData (Printing Purpose) Input: Company, Policy No, Transaction Code and Effective Date Output: An Interface Record (History Information) © FuturaInsTech.

#89 GetPolicyData - Printing Purpose Only Inputs: Company, Policy, Client, Address, Receipt and Date # Outputs Policy Details as an Interface ©  FuturaInsTech.

# 169 Get Previous Policy Data (New Version) Inputs: CompanyID, PolicyID, HistoryCode, Tranno # Outputs: JSON Policy Data © FuturaInsTech.

#110 ********************************************************************************************* This Function Take a Date in YYYYMMDD format and Freq as Input and return the Premium Due Dates as a String value E.g: " " for "S", "1 of Mar Jun Sep Dec" for "Q", "1 of Every Month" for "M" ©  FuturaInsTech *********************************************************************************************.

#8 ********************************************************************************************* Function : GetPremium Paid Purpose : To Get Sum of Preium Paid between Two Duration for the given Premium based on Frequency Inputs FromDate, Todate in YYYYMMDD Format Frequency (Y/H/Q/M/S) Model Premium (eg., 1234.22) Output Premium is Mo of instalments Paid * Premium ©  FuturaInsTech *********************************************************************************************.

# 141 GetPremTaxGLData Extract PremTax Data (Printing Purpose Only) Input: Company, Policy, From and To Date Output: Interface © FuturaInsTech.

# 31 Redundant.

#93 GetReceiptData - Printing Purpose Only Inputs: Company, Policy, Client, Address, Receipt and Date # Outputs Receipt Details as an Interface ©  FuturaInsTech.

#94 GetSAChangeData - Printing Purpose Only Inputs: Company, Policy, Client, Address, Receipt and Date # Outputs SA Change Details as an Interface ©  FuturaInsTech.

# 27 ValidateQ0013 - Survival Benefit (Age Based) Inputs: Company, Coverage and Date String in YYYYMMDD # Outputs SB Term and SB Percentage ©  FuturaInsTech.

#91 GetSurvivalBenefit - Printing Purpose Only Inputs: Company, Policy, Client, Address, Receipt and Date # Outputs Survival Details as an Interface ©  FuturaInsTech.

#68 Surrender Amount Inputs: Company, Policy, Coverage , Effective Date, Term, Premium Term, Status, SA, Start Date, Surrender Method, NO of Instalments # Outputs Surrender Amount ©  FuturaInsTech.

#96 GetSurrenderH Data - Printing Purpose Only Inputs: Company, Policy, Client, Address, Receipt and Date # Outputs Surrender Header and Details as an Interface ©  FuturaInsTech.

#99 GetSurvBPay Data - Printing Purpose Only Inputs: Company, Policy, Client, Address, Receipt and Date # Outputs Survival Benefit Payment Interface ©  FuturaInsTech.

# 55 GetTolerance - To Get Tolerance for a Given Freqquency Inputs: Company, Transaciton Code, Currency, Product, Date # Output Tolerance Amount ©  FuturaInsTech.

# 64 GetTotalGSTPercentage - Get Unit Linked Mortality Prem for a given duration Inputs: Company, Coverage and Date String in YYYYMMDD (Current Date), Key is Coverage Code, No of Months, Amount to be charged # Outputs GST Amount ©  FuturaInsTech.

# 59 GetTranCode - To Get TranCode Inputs: Company, Program/Function Name Outputs: Transaction Code ©  FuturaInsTech.

# 35 GetULAllocRates - Get Unit Linked Allocation Percentage Inputs: Company, Date String in YYYYMMDD, Allocation Method as defined in Q0006, Frequency of the Policy RCD Date and Current Paid Todate in YYYYMMDD Format.

# 36 GetULMortPrem - Get Unit Linked Mortality Prem for a given duration Inputs: Company, Coverage and Date String in YYYYMMDD, SA, Fund Value, Attained Age, Gender # Outputs Premium ©  FuturaInsTech.

# 34 GetWaiverSA - Calculate Waiver SA of a Policy Inputs: Company, All Coverages under the policy , Waiver Method as per Q0006, Waiver Coverage Start Date, Premium of the Current Coverage First Check whether given coverage is available in Q0020 for the Waiver Method.

#109 Function to convert all digits of given number in words Inputs: For INR (Hundreds) # Outputs Values in Words ©  FuturaInsTech.

# 63.

#178 Intf2Int Inputs: Interface Variable Value # Outputs Int variable Value ©  FuturaInsTech.

#179 Intf2String Inputs: Interface Variable Value # Outputs String variable Value ©  FuturaInsTech.

#177 Intf2Uint Inputs: Interface Variable Value # Outputs Uint variable Value ©  FuturaInsTech.

# 52 (Redundant) It is replaced by Create Communication LetterCreate - To Create Letters Inputs: Company, Policy, Product, History Code and iDate # Stamp Duty Value # Parameter Used P0033 and P0034 ©  FuturaInsTech.

#192 Get Loan Bill Data For Letters Inputs: CompanyID, PolicyID, Effective Date # Outputs: Loan Bill Data ©  FuturaInsTech.

#193 Get Loan Capitalized Amount Inputs: CompanyID, PolicyID, Effective Date, Minimum Loan Date, Maximum Loan Date # Outputs: Loan Capitalized Amount, OpenLoanBal Date, CloseLoanBal Date ©  FuturaInsTech.

#19 ModeChange Inputs Old Frequency and New Frequency (Y/H/Q/M).

# 57 NewNofInstalments - Get No of instalments in Months Inputs: From Date, To Date # No of Instalments in Months ©  FuturaInsTech.

#70 NoOfDays - Get No of Days between two dates Inputs: From and To Dates # Outputs Year, Month, Week, Days , hrs , minutes, seconds, millie seconds and nano seconds ©  FuturaInsTech.

# 61 Number Func Convert Float to string Inputs: Float Outputs: String ©  FuturaInsTech.

# 62.

# 120 PostAllocation - This function apportion amount into different funds and investible and non investible Inputs: # Success/Failure ©  FuturaInsTech.

# 127 PostBuySell - Buy or Sell or Non Invested Posting Inputs: Function (Buy/Sell/NonInvested), Company, Policy, Contract Currency, Transaciton Code, Coverage Code, Coverage Start Date, Adjusted Date, Coverage ID, Amount (Non Invested/Invested/Mortality/Fee/Surrender), Tranno # Outputs Allocated , Non Allocated and Error ©  FuturaInsTech.

# 39 Post GL - Get Transaction No and History Code ©  FuturaInsTech.

# 39 Post GL - Get Transaction No and History Code (New Version with Rollback) ©  FuturaInsTech.

# 134 PostTopAllocation - This function apportion amount into different funds and investible and non investible (Top up Only) Inputs: # Success/Failure ©  FuturaInsTech.

# 131 PostUlpDeduction - Post ILP Deductions (Mortality/Policy Fee or Any other deductions) Inputs: Company, Policy, Benefit Code, Benefit ID, Amount to be deducted, History Code, Benefit Code, Start Date of Benefit, Effective Date and Tranno # Outputs Record is written in ILP Transaction Table ©  FuturaInsTech.

# 145 PostUlpDeductionByAmount - Post ILP Deductions by alloctype (used in Surrender & PartSurrender Penalty & GST Postings ) Inputs: Company, Policy, Benefit Code, Benefit ID, Amount to be deducted, History Code, Benefit Code, Start Date of Benefit, Effective Date, Tranno and Allocation Type # Outputs Record is written in ILP Transaction Table © FuturaInsTech.

# 145 PostUlpDeductionByAmountN - Post ILP Deductions by alloctype (used in Surrender & PartSurrender Penalty & GST Postings ) Using txn Inputs: Company, Policy, Benefit Code, Benefit ID, Amount to be deducted, History Code, Benefit Code, Start Date of Benefit, Effective Date, Tranno and Allocation Type # Outputs Record is written in ILP Transaction Table © FuturaInsTech.

# 144 # PostUlpDeductionByFundAmount - Post ILP Deductions by alloctype for a Specific Fund Inputs: Company, Policy, Benefit, Fund Code, Amount to be deducted, History Code, Benefit Code, Start Date of Benefit, Effective Date, Tranno and Allocation Type # Outputs Record is written in ILP Transaction Table © FuturaInsTech.

# 148 # PostUlpDeductionByFundUnits - Post ILP Deductions by alloctype for a Specific Fund Inputs: Company, Policy, Benefit, Fund Code, % of Units to be deducted, History Code, Benefit Code, Start Date of Benefit, Effective Date, Tranno and Allocation Type # Outputs Record is written in ILP Transaction Table © FuturaInsTech.

# 149 PostUlpDeductionByUnits - Post ILP Deductions by alloctype (used in PartSurrender Penalty & GST Postings ) Inputs: Company, Policy, Benefit Code, Benefit ID, % of Units to be deducted, History Code, Benefit Code, Start Date of Benefit, Effective Date, Tranno and Allocation Type # Outputs Record is written in ILP Transaction Table © FuturaInsTech.

#67 RevGL Move - Reverse GL Move Inputs: Transaction No, User Company and Policy # Outputs Reversal Records ©  FuturaInsTech.

# 10 func RoundAmt(iAmount float64, iMethod string) (oAmount float64) { Function Name : Round Float To Round to 2 or 3 or 4 Decimals # Inputs Amount and Precision which is 2 or 3 or 4 # Output Return Value after Round ©  FuturaInsTech.

# 51 Survival Benefit Creation Inputs: Company, Coverage, Date (Inception) in YYYYMMDD, SA, Type as A/T (Age or Term), Method of SB, Term of the Policy, Age at Inception, Trannsaction No # Outputs SB Rates are creatd in SURVB Table ©  FuturaInsTech.

# 12 Function Name : Simple Interest Calculation # Inputs Principal, Interest and No of Days # Output Interest only ©  FuturaInsTech.

#180 SplitDateString Inputs: String Date Value in YYYYMMDD Format # Outputs Year, Month and Date ©  FuturaInsTech.

# 3 ********************************************************************************************* This Function Take input as YYYYMMDD and Give Result in this format 2023-02-01 00:00:00 +0000 UTC ©  FuturaInsTech *********************************************************************************************.

# 116 StringDateDiff - Calculate Bonus due on Annniversary Date OR Bonus Date # Input: # Output: # ©  FuturaInsTech.

# 45 TDFAnniD - Time Driven Function - Update Anniversary Date Inputs: Company, Policy, Function ANNID, Transaction No.

# 44 TDFBillD - Time Driven Function - Update Next Bill Date Inputs: Company, Policy, Function BILLD, Transaction No.

#83 TDFColl - Time Driven Function - Create Collection Record in TDF Inputs: Company, Policy, Function CollD and iDate (Which is passed).

# 47 TDFExpidD - Time Driven Function - Expiry Date Updation Inputs: Company, Policy, Function EXPID, Transaction No.

# 48 TDFExpidS - Time Driven Function - Expiry Date Updation Inputs: Company, Policy, Function EXPID, Transaction No.

# 118 TDFExtrD - Time Driven Function - Expiry Date Updation Inputs: Company, Policy, Functio EXTRD, Transaction No.

# 128 TDFFUNDF - Time Driven Function - ILP Fee Inputs: Company, Policy, Function FUNDF, Transaction No.

# 128 TDFFUNDM - Time Driven Function - Mortality Premium Inputs: Company, Policy, Function FUNDM, Transaction No.

# 121 TDFFUNDP - Time Driven Function - Update Fund Price Inputs: Company, Policy, Function FUNDP, Transaction No.

#82 TdfhUpdate - Time Driven Function - Update TDF Header File Inputs: Company, Policy # It has to loop through TDFPOLICIES and update earliest due in Tdfh # Outputs Old Record is Soft Deleted and New Record is Created in TDFH ©  FuturaInsTech.

#82 TdfhUpdateN - Time Driven Function - Update TDF Header File Inputs: Company, Policy (New Version with Rollback) # It has to loop through TDFPOLICIES and update earliest due in Tdfh # Outputs Old Record is Soft Deleted and New Record is Created in TDFH ©  FuturaInsTech.

# 114 TDFIBD - Time Driven Function - Income Benefit Date Updation Inputs: Company, Policy, Function IBEN, Transaction No.

#81 TDFLapsD - Time Driven Function - Update Lapse Date as per Q0005 Parameter Inputs: Company, Policy, Function LAPSD, Transaction No.

#191 TDF Loan Interest Capitalization Process Inputs: CompanyID, PolicyID, Function, Tran No, # Outputs Error ©  FuturaInsTech.

#195 TDF Loan Deposit Adjustment process Inputs: CompanyID, PolicyID, Function, Tran No, # Outputs Error ©  FuturaInsTech.

#190 TDF Loan Interest Billing Process Inputs: CompanyID, PolicyID, Function, Tran No, # Outputs Error ©  FuturaInsTech.

# 49 TDFReraD - Time Driven Function - Expiry Date Updation Inputs: Company, Policy, Function EXPID, Transaction No.

# 46 TDFReraD - Time Driven Function - ReRate Date Updation Inputs: Company, Policy, Function RERAD, Transaction No.

# 50 TDFSurbD - Time Driven Function - Survival Benefit Date Updation Inputs: Company, Policy, Function SURVB, Transaction No.

# 41 UpdateGlBal ©  FuturaInsTech.

# 41 UpdateGlBal (New Version with Rollback) ©  FuturaInsTech.

# 135 Validate the Address Table Fields mandatory as required by P0065 Rules Inputs: Address Model, Company, Language, Key (Program name) Outputs : Error ©  FuturaInsTech.

#172 Validate Agency (New Version) Return Error when Agency is not valid Inputs: agency model, user company, user language, validdate # Outputs: nil or error © FuturaInsTech.

# 137 Validate the Bank Table Fields mandatory as required by P0065 Rules Inputs: Bank Model, Company, Language, Key (Program name) Outputs : Error ©  FuturaInsTech.

# 164 Validate the PolicyFields mandatory as required by P0065 Rules Inputs: Company, # Outputs: ©  FuturaInsTech.

# 152 Validate the BenefitFields mandatory as required by P0065 Rules Input: Benefit Model, Company, User Language, Transaction Code and Coverage Code Output: Error © FuturaInsTech.

#181 Validate BillType(New Version) Return Error when BillType is not valid Inputs: billtype string,payingAuthority uint, user company, user language, # Outputs: nil or error # Only SSI validation implemented © FuturaInsTech.

# 136 Validate the Client Table Fields mandatory as required by P0065 Rules Inputs: Cleint Mode, Company, Language, Key (Program name) Outputs : Error ©  FuturaInsTech.

#184 Get Validate Client Work Inputs: ClientWork data, Company, Language, Date and Key Detail # Outputs string error ©  FuturaInsTech.

# 23 ValidateCoverageQ0011 - Rider is Allowed for Product or Not Validation Inputs: Company, Product, Coverage and Date String in YYYYMMDD Outputs Product Found or Not "Y" Means Found "N" Means Not Found ©  FuturaInsTech.

# 14 Function : ValidateFields # Function, FieldName, FieldValue, User ID and User Type # Outputs Error ©  FuturaInsTech.

# 171 Validate Frequency (New Version) Return False when current frequency premium dues are pending, else true Inputs: RCD, PTD, Curr Freq, New Freq # Outputs: True or False © FuturaInsTech.

# 15 Function : ValidateItem # Inputs UserId, Name, Item, FieldName, Errors # Outputs Error ©  FuturaInsTech.

# 153 Validate the MrtaFields mandatory as required by P0065 Rules ??? Input: MRTA Model, Company, User Language, Transaction Code and Coverage Code Output: Error © FuturaInsTech.

# 167 Validate Nominee (New Version) Inputs: Nominee Model, Company id, User Language, History Code # Outputs: error, ©  FuturaInsTech.

#182 Validate Paying Authority(New Version) Return Error when Paying Authority is not valid Inputs: payingAuthority uint, user company, user language, # Outputs: nil or error © FuturaInsTech.

# 173 Validate the PolicyData and Benefits Data as required by Q0011 Rules Inputs: Policy Data, Benefit(s) Data, Lang Id, # Outputs: error ©  FuturaInsTech.

# 163 Validate the PolicyFields mandatory as required by P0065 Rules Inputs: Company, # Outputs: ©  FuturaInsTech.

# 151 Validate the ValidatePolicyFields mandatory as required by P0065 Rules Input: Policy Model, Company, User Language, Transaction Code and Coverage Code Output: Error © FuturaInsTech.

# 25 ValidateQ0012 - Survival Benefit (Term Based) Inputs: Company, Coverage and Date String in YYYYMMDD # Outputs SB Term and SB Percentage ©  FuturaInsTech.

# 26 ValidateQ0013 - Survival Benefit (Age Based) Inputs: Company, Coverage and Date String in YYYYMMDD # Outputs SB Term and SB Percentage ©  FuturaInsTech.

# 42 Post GL - Get Transaction No and History Code ©  FuturaInsTech.

#107 Function to convert INR amounts in words Inputs: For INR (Lakhs) # Outputs Values in Words ©  FuturaInsTech.

#108 Function to convert USD,SGD,EURO,GBP..

# 60 WrapInArray Inputs: Interfaces Outputs: Interfaces ©  FuturaInsTech.