Start Time : 20/05/2025 12:39:53 Loading Structure. Get Struct from Cache Manager. User: rekhancia Role: default Calling webservice to get Structure from DB ASB XE3/32/64 DLL running [Compiled on 23/10/2024 5:01:00 AM] [File Version : 11.3.0.0]] [Product Version : 11.3][64Bit(260724)] DB Manager created Current ASB DLL folder : E:\Axpert113\Axpert Web\AxpertWebScripts Connecting to project : trustlineuat Connecting to project found : -1 Session key validation Session key validation completed Db Manager Connection starts Db Manager Connection XML receied : dbPostgredbxlocalhosttrustlineuat\trustlineuat creating connection starts... creating connection end... creating date xds... creating date xds end... PostGreConnect starts... PostGreConnect ends... db user : trustlineuat Select now() as sdt Time elapsed = 3 select props from axprops where lower(name)='app' order by blobno uXDS\dopen\ Check intransaction Time elapsed = 4 axprops xml = images\Agile-TrustLine-UATINR1FFFsmtp.office365.com587portalneo@trustlineindia.com9IntFlo!!$$*1100000FF SELECT Constraint_Name FROM AXCONSTRAINTS where 1=2 uXDS\dopen\ Check intransaction Time elapsed = 4 Db Manager Connection ends Connection to DB Successful Web App Name : Executing GetStructure webservice --------------------------------- Received XML : tstructstrclndbPostgredbxlocalhosttrustlineuat\trustlineuattrustlineuatdd/mm/yyyy hh24:mi:ssadminlocalBlackENGLISHtruet\\10.16.248.2\UAT_Attachment\UAT_TLReports\AxImportDbDir\\10.16.248.2\UAT_Attachment\UAT_TLReports\\10.16.248.2\UAT_Attachment\UAT_TLBusiness1025660000000FrekhanciadefaultdefaultFgmyjcxxozanv2o1zo21ssfafdefault~100trustlineuattrustlineuat0defaulthttps://appneo.trustlineindia.biz/trustlineuatwebScripts/trustlineuataxdeftrustlineuaten-us*asia/calcutta^english*5/20/2025 12:14:18 pm*~~9867~25~0~0~1~R~false~RccccncccccE:\Axpert113\Axpert Web\AxpertWebScripts Registering app/user variables for the session Registering DBMem variables Registering DBMem variables completed Registering ConfigParam variables Registering ConfigParam variables completed auth_path=E:\Axpert113\Axpert Web\AxpertWebScripts axp_clientlocale=en-us*asia/calcutta^english*5/20/2025 12:14:18 pm* axp_appschema=trustlineuat axp_devschema=trustlineuataxdef axp_apipath=https://appneo.trustlineindia.biz/trustlineuatwebScripts/ axp_connectionname=trustlineuat sesid=gmyjcxxozanv2o1zo21ssfaf ax_evalcopy=F rolename=default responsibilies=default millions=F axpimageserver= axglo_hide= axp_displaytext= axglo_user= fromuserlogin= axglo_recordid=1025660000000 axpimagepath= AxpServerPath=\\10.16.248.2\UAT_Attachment\UAT_TLBusiness AxpAttachmentPath=\\10.16.248.2\UAT_Attachment\UAT_TLReports AxpDbDirPath=\\10.16.248.2\UAT_Attachment\UAT_TLReports\AxImportDbDir LStr : ~~9867~25~0~0~1~R~false~R LReg Type : R User Group default User Roles default Registering app/user variables for the session completed select sessionid from connections where sessionid = :sesid uXDS\dopen\ Check intransaction Time elapsed = 4 Reading Structure from DB Sql : select props from tstructs where lower(name)= :name order by blobno Paramval : trcln ParamTYpe : c Param List : name select props from tstructs where lower(name)= :name order by blobno uXDS\dopen\ Check intransaction Time elapsed = 5 Step5 select ' '::varchar(250) as lval Time elapsed = 3 select ' '::varchar(250) as lval Time elapsed = 15 Evaluating client_code client_code = 1 Result = 1 Evaluating recordid recordid = 0 Result = 0 Evaluating IIF(recordid = 0, client_name) recordid = 0 client_name = 1 Calling function iif Result of iif = 1 Result = 1 Evaluating {F} Result = F Evaluating {India} Result = India Evaluating temp_nationality temp_nationality = 1 Result = 1 Evaluating {Single} Result = Single Evaluating {F} Result = F Evaluating {F} Result = F Evaluating date() Calling function date Result of date = 20/05/2025 Result = 20/05/2025 Evaluating {F} Result = F Evaluating {T} Result = T Evaluating AxpAttachmentPath AxpAttachmentPath = \\10.16.248.2\UAT_Attachment\UAT_TLReports Result = \\10.16.248.2\UAT_Attachment\UAT_TLReports Evaluating getallvalues({account_client_id},{,}) Calling function getallvalues Result of getallvalues = Result = Evaluating IIF(primary_emailid = duplicate_primarymail_id, {F},{T}) primary_emailid = 1 duplicate_primarymail_id = 1 Calling function iif Result of iif = F Result = F Evaluating {India} Result = India Evaluating AxpAttachmentPath AxpAttachmentPath = \\10.16.248.2\UAT_Attachment\UAT_TLReports Result = \\10.16.248.2\UAT_Attachment\UAT_TLReports Evaluating {Yes} Result = Yes Evaluating AxpAttachmentPath AxpAttachmentPath = \\10.16.248.2\UAT_Attachment\UAT_TLReports Result = \\10.16.248.2\UAT_Attachment\UAT_TLReports Evaluating fund_code + scheme_code + account_client_id fund_code = 1 scheme_code = 1 account_client_id = 1 Result = 111 Evaluating {F} Result = F Evaluating bank_ifsc_code + bank_account_number bank_ifsc_code = 1 bank_account_number = 1 Result = 11 Evaluating AxpAttachmentPath AxpAttachmentPath = \\10.16.248.2\UAT_Attachment\UAT_TLReports Result = \\10.16.248.2\UAT_Attachment\UAT_TLReports Evaluating activerow activerow = 1 Result = 1 Evaluating AxpAttachmentPath AxpAttachmentPath = \\10.16.248.2\UAT_Attachment\UAT_TLReports Result = \\10.16.248.2\UAT_Attachment\UAT_TLReports Evaluating SubStr(permanent_pin_zip,1,2) permanent_pin_zip = 1 Calling function substr Result of substr = 1 Result = 1 Evaluating permanent_temp_address permanent_temp_address = 1 Result = 1 Evaluating {T} Result = T Evaluating iif(same_aspermanent_address={T},permanent_house_number,{}) same_aspermanent_address = 1 permanent_house_number = 1 Calling function iif Result of iif = Result = Evaluating {T} Result = T Evaluating iif(same_aspermanent_address={T},permanent_locality_sublocality,{}) same_aspermanent_address = T permanent_locality_sublocality = 1 Calling function iif Result of iif = 1 Result = 1 Evaluating {T} Result = T Evaluating iif(same_aspermanent_address={T},permanent_city,{}) same_aspermanent_address = T permanent_city = 1 Calling function iif Result of iif = 1 Result = 1 Evaluating {T} Result = T Evaluating iif(same_aspermanent_address={T},permanent_pin_zip,{}) same_aspermanent_address = T permanent_pin_zip = 1 Calling function iif Result of iif = 1 Result = 1 Evaluating {T} Result = T Evaluating SubStr(communication_pin_zip,1,2) communication_pin_zip = 1 Calling function substr Result of substr = 1 Result = 1 Evaluating iif(same_aspermanent_address={T},permanent_pin_zip,{}) same_aspermanent_address = T permanent_pin_zip = 1 Calling function iif Result of iif = 1 Result = 1 Evaluating communication_temp_address communication_temp_address = 1 Result = 1 Evaluating AxpAttachmentPath AxpAttachmentPath = \\10.16.248.2\UAT_Attachment\UAT_TLReports Result = \\10.16.248.2\UAT_Attachment\UAT_TLReports Evaluating {No} Result = No Evaluating AxpAttachmentPath AxpAttachmentPath = \\10.16.248.2\UAT_Attachment\UAT_TLReports Result = \\10.16.248.2\UAT_Attachment\UAT_TLReports Evaluating AxpAttachmentPath AxpAttachmentPath = \\10.16.248.2\UAT_Attachment\UAT_TLReports Result = \\10.16.248.2\UAT_Attachment\UAT_TLReports Evaluating GetRowCount({joint_name}) Calling function getrowcount Result of getrowcount = 0 Result = 0 Evaluating Total({nominee_share}) Calling function total Result of total = 0 Result = 0 Evaluating GetRowCount({nominee_name}) Calling function getrowcount Result of getrowcount = 0 Result = 0 Evaluating iif( client_logincount = 0, {T}, {F}) client_logincount = 197509 Calling function iif Result of iif = F Result = F Evaluating Total({ubo_percentage}) Calling function total Result of total = 0 Result = 0 Evaluating GetRowCount({ubo_name}) Calling function getrowcount Result of getrowcount = 0 Result = 0 Check print forms Check Attachments Check track changes Executing SetViewControl procedure Executing SetDcAccess Executing AddBtnList Executing SetBtnAccess End of SetViewControl procedure Executing AddSQLResult Field Name : trcln Field Name : dc1 Field Name : client_code Field Name : docid Field Name : recid Field Name : logincount Field Name : title Field Name : client_name Field Name : client_name_check Field Name : client_display_name Field Name : father_name Field Name : spouse_name Field Name : gender Field Name : pan_number Field Name : dob_doi Field Name : politically_exp_person Field Name : occupation Field Name : country_of_birth Field Name : place_of_birth Field Name : temp_nationality Field Name : nationality Field Name : resident_status Field Name : kyc_status Field Name : ckyc_number Field Name : holding_status Field Name : tax_status Field Name : country_code Field Name : primary_mobileno Field Name : secondary_mobileno Field Name : ubo Field Name : nominee Field Name : primary_emailid Field Name : duplicate_primarymail_id Field Name : client_start_date Field Name : secondary_emailid Field Name : distributor_name Field Name : distributor_mailid Field Name : distributor_mobileno Field Name : rm_name Field Name : rm_emailid Field Name : rm_mobileno Field Name : cc_mailid1 Field Name : cc_mailid2 Field Name : cc_mailid3 Field Name : aml_check Field Name : active Field Name : remarks Field Name : axpfile_clientupload Field Name : axpfilepath_clientupload Field Name : clientids Field Name : client_logincount Field Name : control_fieldcheck Field Name : distributor_rm_detailid Field Name : dc2 Field Name : country_taxresident Field Name : tin_number Field Name : tin_authority Field Name : taxstatus_effectivefrom Field Name : axpfile_nriupload Field Name : axpfilepath_nriupload Field Name : dc3 Field Name : fund_code Field Name : scheme_code Field Name : account_status Field Name : ucc_code Field Name : miles_account_code Field Name : date_of_agreement Field Name : dp_id Field Name : account_client_id Field Name : account_activationdate Field Name : poa_agreement_date Field Name : poa_franking_date Field Name : poa_stamp_valuation Field Name : account_closuredate Field Name : axpfile_accountupload Field Name : axpfilepath_accountupload Field Name : duplicatecheck_ucccode Field Name : dc4 Field Name : bank_accounttype Field Name : bank_ifsc_code Field Name : accountno_length Field Name : account_firstchar Field Name : bank_account_number Field Name : bank_accountnumber_check Field Name : bank_name Field Name : bank_address Field Name : bank_pincode Field Name : bank_branchname Field Name : bank_micr_code Field Name : duplicate_accountnumber Field Name : axpfile_bankupload Field Name : axpfilepath_bankupload Field Name : dc5 Field Name : joint_title Field Name : joint_name Field Name : joint_dob Field Name : relationship_with_holder Field Name : joint_pan_number Field Name : joint_ckyc_number Field Name : joint_kyc_status Field Name : jointholder_rownumber Field Name : axpfile_jointupload Field Name : axpfilepath_jointupload Field Name : dc6 Field Name : permanent_house_number Field Name : permanent_locality_sublocality Field Name : permanent_city Creating picklist captions Creating picklist captions over Field Name : permanent_pin_zip Field Name : permanent_state Field Name : permanent_country Field Name : perpincode_start_digit Field Name : per_substring_pincode Field Name : permanent_temp_address Field Name : client_permanentaddress Field Name : same_aspermanent_address Field Name : communication_house_number Field Name : comm_locality_sublocality Field Name : communication_city Creating picklist captions Creating picklist captions over Field Name : communication_pin_zip Field Name : communication_state Field Name : comm_pincode_startdigit Field Name : comm_substring_pincode Field Name : communication_country Field Name : communication_temp_address Field Name : client_communicationaddress Field Name : axpfile_addressupload Field Name : axpfilepath_addressupload Field Name : dc7 Field Name : nominee_order Field Name : nominee_title Field Name : nominee_name Field Name : nominee_share Field Name : relationship_to_holder Field Name : nominee_date_of_birth Field Name : nominee_isminor Field Name : guardianname_isminor Field Name : guardian_relationship Field Name : guardian_mobileno Field Name : guardian_pan_number Field Name : guardian_ckyc_number Field Name : guardian_kyc_status Field Name : axpfile_nomineeupload Field Name : axpfilepath_nomineeupload Field Name : dc8 Field Name : ubo_order Field Name : ubo_title Field Name : ubo_name Field Name : ubo_dateofbirth Field Name : ubo_percentage Field Name : ubo_tin Field Name : ubo_pan_number Field Name : ubo_ckyc_number Field Name : ubo_kyc_status Field Name : axpfile_uboupload Field Name : axpfilepath_uboupload Field Name : dc9 Field Name : jointholder_rowcount Field Name : nominee_share_total Field Name : nominee_dcrowcount Field Name : clientlogin_createflag Field Name : ubo_share_total Field Name : ubo_rowcount Field Name : trcln1 Field Name : scripts Field Name : axpconfigs_trcln Field Name : comps Field Name : iframes Executing AddSQLResult Completed Select configname,cvalue from axpconfigs_trcln CDS Open Error Msg : csd query : Select configname,cvalue from axpconfigs_trcln $ Error msg : relation "axpconfigs_trcln" does not exist uXDS\open\ Exceptio relation "axpconfigs_trcln" does not exist SELECT A.STYPE,A.STRUCTNAME,A.CONTEXT,A.SFIELD,A.ICOLUMN,A.SBUTTON,A.HLINK,A.PROPS,A.PROPSVAL,A.PROPVALUE2,'SINGLE' as APPLYON FROM axpstructconfig a, axuserlevelgroups b WHERE A.USERROLES IN ('default') AND B.AXUSERNAME = :uname AND lower(a.stype) = :structure_type AND A.STRUCTNAME not in('ALL Reports','ALL Forms') UNION SELECT A.STYPE,A.STRUCTNAME,A.CONTEXT,A.SFIELD,A.ICOLUMN,A.SBUTTON,A.HLINK,A.PROPS,A.PROPSVAL,A.PROPVALUE2,'SINGLE' as APPLYON FROM axpstructconfig a WHERE coalesce(USERROLES, 'ALL') = 'ALL' AND lower(a.stype) = :structure_type AND structname = :sname AND A.STRUCTNAME not in('ALL Reports','ALL Forms') UNION SELECT A.STYPE, :sname STRUCTNAME,A.CONTEXT,A.SFIELD,A.ICOLUMN,A.SBUTTON,A.HLINK,A.PROPS,A.PROPSVAL,A.PROPVALUE2,'ALL' as APPLYON FROM axpstructconfig a, axuserlevelgroups b WHERE A.USERROLES IN ('default') AND B.AXUSERNAME = :uname AND lower(a.stype) = :structure_type AND A.STRUCTNAME in('ALL Reports','ALL Forms') UNION SELECT A.STYPE, :sname STRUCTNAME,A.CONTEXT,A.SFIELD,A.ICOLUMN,A.SBUTTON,A.HLINK,A.PROPS,A.PROPSVAL,A.PROPVALUE2,'ALL' as APPLYON FROM axpstructconfig a WHERE coalesce(USERROLES, 'ALL') = 'ALL' AND lower(a.stype) = :structure_type AND A.STRUCTNAME in('ALL Reports','ALL Forms') order by STYPE,STRUCTNAME,PROPS,APPLYON DESC uname=rekhancia structure_type=tstruct structure_type=tstruct sname=trcln sname=trcln uname=rekhancia structure_type=tstruct sname=trcln structure_type=tstruct Time elapsed = 16 Select names from templates where lower(iviewid) = 'trcln' Time elapsed = 2 sname=trcln select content from AX_LAYOUTDESIGN where lower(transid)= :sname and module= 'TSTRUCT' order by created_on desc sname=trcln Time elapsed = 10 Select * from axrulesdef where lower(transid) = 'trcln' order by rulegroup,rulename Time elapsed = 4 Select * from axrulesdef_conmsg where lower(btnstransid) = 'trcln' order by btnname Time elapsed = 10 select errcode,errmsg from axpdef_errcodes where lower(errlang) = 'english'and ((lower(applicabletransid) = 'trcln') or (lower(applicabletransid) like '%,trcln,%') or (lower(applicabletransid) like 'trcln,%') or (lower(applicabletransid) like '%,trcln')) order by errlang , applicabletransid Time elapsed = 4 CheckAxProcessDef starts... CheckAxProcessDef starts... select * from AxProcessDef where lower(transid)='trcln' and lower(active)='t' and lower(tasktype)='make' Time elapsed = 7 SELECT ppm.powner as processowner , ppm.pownerflg as processownerflg, ppm.amendment, pdv.* FROM AxprocessDefV2 pdv JOIN axpdef_peg_processmaster ppm ON pdv.processname = ppm.caption WHERE lower(transid)='trcln' and lower(active)='t' and lower(tasktype)='make' and (ppm.amendment is null or ppm.amendment = '' or lower(ppm.amendment)<> 't') Time elapsed = 14 CheckAxProcessDef ends. IsAmendmentEnabled starts... SELECT ppm.powner as processowner , ppm.pownerflg as processownerflg, ppm.amendment, pdv.* FROM AxprocessDefV2 pdv JOIN axpdef_peg_processmaster ppm ON pdv.processname = ppm.caption WHERE lower(transid)='trcln' and lower(active)='t' and lower(ppm.amendment) = 't' order by indexno Time elapsed = 12 IsAmendmentEnabled ends. CheckAxProcessDef ends. Structure XML : trclnClient MastertFalseFalseTrueFalseFalseNoneDefaultFalsedc1Client Master1client_detailsFalseTrueTrueTrueFalseFalseclient_codeClient CodeCharacter500Accept00TrueFalseFalseFalseFalseFalseFalseTrueFalseFalseFalseFalseFalseTrueedocid,slogincountTrueclient_code~docid,logincountdocidDocid Character500calculate00TrueFalseFalseFalseTrueclient_codeFalseFalseFalseFalseFalseTrueTruedocid,client_coderecidrecidNumeric150Accept00TrueFalseFalseTrueTrueFalseFalseFalserecordidTrueFalseFalseFalseFalseTrueTruerecidlogincountlogincountNumeric100Acceptselect count(1) as cnt from axusers a, client_details b where b.primary_emailid = a.pusername and b.client_code = :client_code00TrueFalseFalseTrueTrueFalseFalseFalseTrueFalseFalseFalseFalseTrueTruelogincount,client_code<a1>title</a1><a2>Title</a2><a69></a69><a3>Character</a3><a4>50</a4><a5>0</a5><a6>Accept</a6><a7><a22 txt="" firesql="false" param="n" pcount="0"></a22><a18></a18><a21>0</a21><a20>0</a20><a23>True</a23><a24>False</a24><a25/><a26 table="" cap="" stype="" scol="0"></a26><a27></a27><a28/><a29/><a30>False</a30><a40/><a41/><a63/></a7><a8>False</a8><a9>True</a9><a10>False</a10><a11>False</a11><a12>True</a12><a13></a13><a14></a14><a15>True</a15><a16>False</a16><a17>False</a17><a19>False</a19><a52>False</a52><a31></a31><a32></a32><a33></a33><a34></a34><a35></a35><a36></a36><a37></a37><a46></a46><a47></a47><a48 masking="No Mask" lastcharmask="0" firstcharmask="0" maskchar="X" maskroles=""></a48><a49></a49><a50></a50><a51></a51><a55>True</a55><a56></a56><a57></a57><a58></a58><a64></a64><a59></a59><a60></a60><a65></a65><a67>True</a67><a70></a70><a66>title</a66>client_nameClient NameCharacter2550Accept00TrueFalseFalseFalseFalseFalseFalseTrueFalseFalseFalseFalseFalseTruesclient_name_check,eclient_display_nameTrueclient_name~client_name_check,client_display_nameclient_name_checkClient NameCharacter500AcceptSELECT 1 FROM dual WHERE ( :client_name !~ '^[0-9]+$' AND :client_name ~ '[A-Za-z]+')00TrueFalseFalseTrueTrueFalseFalseFalseIIF(client_name_check =1,{T},{ cannot be only numeric})TrueFalseFalseFalseFalseTrueTrueclient_name_check,client_nameclient_display_nameDisplay NameCharacter2550Accept00TrueFalseFalseFalseFalseFalseFalseTrueIIF(recordid = 0, client_name)TrueFalseFalseFalseFalseTrueTrueclient_display_name,client_namefather_nameFather NameCharacter2550Accept00TrueFalseFalseFalseTrueFalseFalseTrueTrueFalseFalseFalseFalseTrueTruefather_namespouse_nameSpouse NameCharacter2550Accept00TrueFalseFalseFalseTrueFalseFalseTrueTrueFalseFalseFalseFalseTrueTruespouse_namegenderGenderCharacter200Selectselect lov_description from list_of_values a where lower(a.lov_category) = 'gender' and a.cancel = 'F' and a.active = 'T' order by 100FalseTrueFalseTrueFalseFalseTrueTrueTrueFalseFalseTrueTrueTruegenderpan_numberPAN#Character100Accept00TrueFalseFalseFalseFalseFalseFalseTrueTrueFalseFalseFalseFalseTrueTruepan_numberdob_doiDate of Birth/Date of IncorporationDate/Time100Accept00TrueFalseFalseFalseFalseFalseFalseTrueIIF(dob_doi > Date(), { Future date not allowed},{T})TrueFalseFalseFalseFalseTrueTruedob_doipolitically_exp_personPolitically Exposed PersonCharacter10Accept00TrueFalseFalseFalseTrueFalseFalseTrue{F}TrueFalseFalseFalseFalseTrueTruepolitically_exp_personoccupationOccupationCharacter500Selectselect lov_description from list_of_values a where lower(a.lov_category) = 'occupation' and a.cancel = 'F' and ( a.active = 'T' or :recordid > 0 ) order by 100FalseTrueFalseFalseFalseFalseTrueTrueTrueFalseFalseTrueTrueTrueoccupationcountry_of_birthCountry of BirthCharacter1000SelectSelect a1.global_mst_countryid,a1.n_country_name,a1.nationality from global_mst_country a1 where a1.active = 'T' and a1.cancel = 'F' order by a1.n_country_name00FalseTruen_country_nameglobal_mst_countryFalseFalseFalseFalseTrue{India}TrueTrueTrueFalseTrueTrueftemp_nationality,enationality,sresident_statusTruecountry_of_birth~temp_nationality,nationality,resident_statusplace_of_birthPlace of BirthCharacter2000Accept00TrueFalseFalseFalseFalseFalseFalseTrueTrueFalseFalseFalseFalseTrueTrueplace_of_birthtemp_nationalitytemp_nationalityCharacter1000Fill00country_of_birthnationalityFalseTrueTrueFalseFalseFalseTrueFalseFalseFalseFalseTrueenationality,sresident_statusTruetemp_nationality,country_of_birth~nationality,resident_statusnationalityNationalityCharacter500Selectselect a.nationality from global_mst_country a where a.cancel = 'F' and ( a.active = 'T' or :recordid > 0 ) order by 100FalseTrueFalseFalseFalseFalseTruetemp_nationalityTrueTrueFalseFalseTrueTruesresident_statusTruenationality,temp_nationality,country_of_birth~resident_statusresident_statusResident StatusCharacter500Selectselect lov_description from list_of_values a where lower(a.lov_category) = 'resident status' and a.cancel = 'F' and ( a.active = 'T' or :recordid > 0 ) and ( (lower( :nationality) = 'indian' and lower(a.lov_description) !='foreign national') or (lower( :nationality) != 'indian' and lower(a.lov_description) ='foreign national') ) order by 100TrueTrueFalseFalseFalseFalseTrueTrueTrueFalseFalseTrueTrueselect lov_description from list_of_values a where lower(a.lov_category) = 'resident status' and a.cancel = 'F' and a.active = 'T' and (lower( :nationality) = 'indian' and lower(a.lov_description) !='foreign national') or lower( :nationality) != 'indian') order by 1Trueresident_status,nationality,temp_nationality,country_of_birthkyc_statusKYC StatusCharacter2000Selectselect lov_description from list_of_values a where lower(a.lov_category) = 'kyc status' and a.cancel = 'F' and ( a.active = 'T' or :recordid > 0 ) order by 100FalseTrueFalseFalseFalseFalseTrueTrueTrueFalseFalseTrueTrueTruekyc_statusckyc_numberCKYC#Character150Accept00TrueFalseFalseFalseFalseFalseFalseTrueTrueFalseFalseFalseFalseTrueTrueckyc_numberholding_statusHolding StatusCharacter500Selectselect lov_description from list_of_values a where lower(a.lov_category) = 'holding status' and a.cancel = 'F' and ( a.active = 'T' or :recordid > 0 ) order by 100FalseTrueFalseFalseFalseFalseTrue{Single}TrueTrueFalseFalseTrueTrueTrueholding_statustax_statusTAX StatusCharacter1000Selectselect lov_description from list_of_values a where lower(a.lov_category) = 'tax status' and a.cancel = 'F' and ( a.active = 'T' or :recordid > 0 ) order by 100FalseTrueFalseFalseFalseFalseTrueTrueTrueFalseFalseTrueTrueTruetax_statuscountry_codeISD/STD CodeCharacter200Selectselect a.calling_code from global_mst_country a where ( a.active = 'T' or :recordid > 0 ) and a.cancel = 'F' order by 100FalseTrueFalseTrueFalseFalseTrueTrueTrueFalseFalseTrueTrueTruecountry_codeprimary_mobilenoPrimary Mobile No.Numeric100Accept00TrueFalseFalseFalseFalseFalseFalseTrueTrueFalseFalseFalseFalseTrueTrueprimary_mobilenosecondary_mobilenoSecondary Mobile No.Numeric100Accept00TrueFalseFalseFalseTrueFalseFalseTrueTrueFalseFalseFalseFalseTrueTruesecondary_mobilenouboUBOCharacter10Accept00TrueFalseFalseFalseTrueFalseFalseTrue{F}TrueFalseFalseFalseFalseTrueTrueubonomineeOpt. NomineeCharacter10Accept00TrueFalseFalseFalseTrueFalseFalseTrue{F}TrueFalseFalseFalseFalseTrueTruenomineeprimary_emailidPrimary Email IDCharacter2550Accept00TrueFalseFalseFalseFalseFalseFalseTrueTrueFalseFalseFalseFalseTruesduplicate_primarymail_id,sclient_logincount,econtrol_fieldcheck,eclientlogin_createflagMail Id provided here will be used to create LoginTrueprimary_emailid~duplicate_primarymail_id,client_logincount,control_fieldcheck,clientlogin_createflagduplicate_primarymail_idduplicate_primarymail_idCharacter2000Acceptselect a.username from axusers a where a.username = :primary_emailid 00TrueFalseFalseTrueTrueTrueFalseFalseTrueFalseFalseFalseFalseTrueecontrol_fieldcheckTrueduplicate_primarymail_id,primary_emailid~control_fieldcheckclient_start_dateclient_start_dateDate/Time100Accept00TrueFalseFalseTrueTrueFalseFalseTruedate() TrueFalseFalseFalseFalseTrueTrueclient_start_datesecondary_emailidSecondary Email IDCharacter2550Accept00TrueFalseFalseFalseTrueFalseFalseTrueTrueFalseFalseFalseFalseTrueTruesecondary_emailiddistributor_nameDistributor NameCharacter1000SelectSelect a1.distributor_rm_name,a1.distributor_rm_emailid,a1.distributor_rm_mobileno from distributor_rm_detail a1 where lower(a1.distributor_rm) = 'distributor' and a1.cancel = 'F' and ( a1.active = 'T' or :recordid > 0 ) order by a1.title_name00FalseTrueFalseTrueFalseFalseTrueTrueTrueFalseFalseTrueTruefdistributor_mailid,fdistributor_mobilenoTruedistributor_name~distributor_mailid,distributor_mobilenodistributor_mailidDistributor Email IDCharacter2550Fill00distributor_namedistributor_rm_emailidFalseFalseTrueTrueFalseTrueTrueFalseFalseFalseFalseTrueTruedistributor_mailid,distributor_namedistributor_mobilenoDistributor Mobile No.Numeric100Fill00distributor_namedistributor_rm_mobilenoFalseFalseTrueTrueFalseFalseTrueFalseFalseFalseFalseTrueTruedistributor_mobileno,distributor_namerm_nameRM NameCharacter1000SelectSelect a1.distributor_rm_name,a1.distributor_rm_emailid,a1.distributor_rm_mobileno,a1.distributor_rm_detailid from distributor_rm_detail a1 where lower(a1.distributor_rm) = 'rm' and a1.cancel = 'F' and ( a1.active = 'T' or :recordid > 0 ) order by a1.distributor_rm_name00FalseTrueFalseFalseFalseFalseTrueTrueTrueFalseFalseTrueTruefrm_emailid,frm_mobileno,fdistributor_rm_detailidTruerm_name~rm_emailid,rm_mobileno,distributor_rm_detailidrm_emailidRM Email IDCharacter2550Fill00rm_namedistributor_rm_emailidFalseFalseTrueTrueFalseTrueTrueFalseFalseFalseFalseTrueTruerm_emailid,rm_namerm_mobilenoRM Mobile No.Numeric100Fill00rm_namedistributor_rm_mobilenoFalseFalseTrueTrueFalseFalseTrueFalseFalseFalseFalseTrueTruerm_mobileno,rm_namecc_mailid1CC to Mail ID1Character2550Accept00TrueFalseFalseFalseTrueFalseFalseTrueTrueFalseFalseFalseFalseTrueTruecc_mailid1cc_mailid2CC to Mail ID2Character2550Accept00TrueFalseFalseFalseTrueFalseFalseTrueTrueFalseFalseFalseFalseTrueTruecc_mailid2cc_mailid3CC to Mail ID3Character2550Accept00TrueFalseFalseFalseTrueFalseFalseTrueTrueFalseFalseFalseFalseTrueTruecc_mailid3aml_checkAML CheckCharacter10Accept00TrueFalseFalseFalseTrueFalseFalseTrue{F}TrueFalseFalseFalseFalseTrueTrueaml_checkactiveActiveCharacter10Accept00TrueFalseFalseFalseTrueFalseFalseTrue{T}TrueFalseFalseFalseFalseTrueTruetrue~client_codeactiveremarksRemarksCharacter5000Accept00TrueFalseFalseFalseTrueFalseFalseTrueTrueFalseFalseFalseFalseTrueTrueremarksaxpfile_clientuploadUpload Documents [if any]Character20000Accept00TrueFalseFalseFalseTrueFalseFalseTrueTrueFalseFalseFalseFalseTrueTrueaxpfile_clientuploadaxpfilepath_clientuploadaxpfilepath_clientuploadCharacter500calculate00TrueFalseTrueFalseTrueAxpAttachmentPathTrueFalseFalseFalseFalseTrueTrueaxpfilepath_clientuploadclientidsClient IDCharacter5000calculate00TrueTrueFalseFalseTruegetallvalues({account_client_id},{,})TrueFalseFalseFalseFalseTrueTrueclientids,account_client_idclient_logincountclient_logincountNumeric100Acceptselect count(1) as cnt from axusers a where a.username = :primary_emailid00TrueFalseFalseTrueTrueFalseFalseFalseTrueFalseFalseFalseFalseTrueeclientlogin_createflagTrueclient_logincount,primary_emailid~clientlogin_createflagcontrol_fieldcheckcontrol_fieldcheckCharacter500calculate00TrueTrueTrueFalseFalseIIF(primary_emailid = duplicate_primarymail_id, {F},{T})TrueFalseFalseFalseFalseTrueTruecontrol_fieldcheck,primary_emailid,duplicate_primarymail_iddistributor_rm_detailidDistributor_Rm_DetailIdNumeric200Fill00rm_namedistributor_rm_detailidFalseTrueTrueFalseFalseTrueTrueFalseFalseFalseFalseTrueTruedistributor_rm_detailid,rm_namedc2NRI Details2client_nridetailsTrueTrueTrueTrueTrueFalsecountry_taxresidentCountry of Tax ResidentCharacter1000SelectSelect a1.global_mst_countryid,a1.n_country_name from global_mst_country a1 where ( a1.active = 'T' or :recordid > 0 ) and a1.cancel = 'F' order by a1.n_country_name00FalseTruen_country_nameglobal_mst_countryFalseTrueFalseFalseTrue{India}TrueTrueTrueFalseTrueTrueTruecountry_taxresidenttin_numberTIN#Character200Accept00TrueFalseFalseFalseTrueFalseFalseTrueTrueFalseFalseFalseFalseTrueTruetin_numbertin_authorityTIN Issuing AuthorityCharacter1000SelectSelect a1.global_mst_countryid,a1.n_country_name from global_mst_country a1 where ( a1.active = 'T' or :recordid > 0 ) and a1.cancel = 'F' order by a1.n_country_name00FalseTruen_country_nameglobal_mst_countryFalseTrueFalseFalseTrueTrueTrueTrueFalseTrueTrueTruetin_authoritytaxstatus_effectivefromTAX Status Effective FromDate/Time100Accept00TrueFalseFalseFalseTrueFalseFalseTrueTrueFalseFalseFalseFalseTrueTruetaxstatus_effectivefromaxpfile_nriuploadUpload Documents [if any]Character20000Accept00TrueFalseFalseFalseTrueFalseFalseTrueTrueFalseFalseFalseFalseTrueTrueaxpfile_nriuploadaxpfilepath_nriuploadaxpfilepath_nriuploadCharacter500calculate00TrueFalseTrueFalseFalseAxpAttachmentPathTrueFalseFalseFalseFalseTrueTrueaxpfilepath_nriuploaddc3Account Details3client_accountdetailsTrueTrueFalseTrueTrueFalsefund_codeFund CodeCharacter500SelectSelect distinct a1.fund_code from fund_scheme_details a1 where a1.cancel = 'F' and ( a1.active = 'T' or :recordid > 0 ) order by a1.fund_code00FalseTrueFalseFalseFalseFalseTrueTrueTrueFalseFalseTrueTruesscheme_code,eduplicatecheck_ucccodeTruefund_code~scheme_code,duplicatecheck_ucccode,account_client_idscheme_codeScheme CodeCharacter500Selectselect a.scheme_code from fund_scheme_details a where a.fund_code = :fund_code and ( a.active = 'T' or :recordid > 0 ) and a.cancel = 'F' order by 100FalseTrueFalseFalseFalseFalseTrueTrueTrueFalseFalseTrueTrueeduplicatecheck_ucccodeTruescheme_code,fund_code~duplicatecheck_ucccode,account_client_idaccount_statusAccount StatusCharacter200Select00FalseFalseYesNoFalseTrueFalseFalseTrue{Yes}TrueTrueFalseFalseTrueTrueTrueaccount_statusucc_codeUCC CodeCharacter500Accept00TrueFalseFalseFalseFalseFalseFalseTrueTrueFalseFalseFalseFalseTrueTrueucc_codemiles_account_codeMiles Account CodeCharacter500Accept00TrueFalseFalseFalseFalseFalseFalseTrueFalseFalseFalseFalseFalseTrueTruemiles_account_codedate_of_agreementDate of AgreementDate/Time100Accept00TrueFalseFalseFalseFalseFalseFalseTrueIIF(date_of_agreement > Date(),{ Future date not allowed},{T})TrueFalseFalseFalseFalseTrueTruedate_of_agreementdp_idDP IDCharacter200Selectselect a.lov_shortcode from list_of_values a where lower(a.lov_category) = 'dp id' and a.cancel = 'F' and ( a.active = 'T' or :recordid > 0 ) order by 100FalseTrueFalseTrueFalseFalseTrueTrueTrueFalseFalseTrueTrueTruedp_idaccount_client_idClient IDCharacter500Accept00TrueFalseFalseFalseFalseFalseFalseTrueTrueFalseFalseFalseFalseTrueeduplicatecheck_ucccode,eclientidsTrueaccount_client_id~duplicatecheck_ucccode,fund_code,scheme_code,clientidsaccount_activationdateActivation DateDate/Time100Accept00TrueFalseFalseFalseFalseFalseFalseTrueTrueFalseFalseFalseFalseTrueTrueaccount_activationdatepoa_agreement_datePOA Agreement DateDate/Time100Accept00TrueFalseFalseFalseTrueFalseFalseTrueIIF(poa_agreement_date > Date(),{ Future date not allowed},{T})TrueFalseFalseFalseFalseTrueTruepoa_agreement_datepoa_franking_datePOA Franking DateDate/Time100Accept00TrueFalseFalseFalseTrueFalseFalseTrueTrueFalseFalseFalseFalseTrueTruepoa_franking_datepoa_stamp_valuationPOA Stamp Valuation [INR]Numeric102Accept00TrueFalseFalseFalseTrueFalseFalseTrueTrueFalseFalseFalseFalseTrueTruepoa_stamp_valuationaccount_closuredateClosure DateDate/Time100Accept00TrueFalseFalseFalseTrueFalseFalseTrueTrueFalseFalseFalseFalseTrueTrueaccount_closuredateaxpfile_accountuploadUpload Documents [if any]Character20000Accept00TrueFalseFalseFalseTrueFalseFalseTrueTrueFalseFalseFalseFalseTrueTrueaxpfile_accountuploadaxpfilepath_accountuploadaxpfilepath_accountuploadCharacter500calculate00TrueFalseTrueFalseFalseAxpAttachmentPathTrueFalseFalseFalseFalseTrueTrueaxpfilepath_accountuploadduplicatecheck_ucccodeDuplicate UCC CodeCharacter5000calculate00TrueTrueFalseFalseFalsefund_code + scheme_code + account_client_id FalseFalseFalseFalseFalseTrueTrueduplicatecheck_ucccode,fund_code,scheme_code,account_client_iddc4Bank Details4client_bankdetailsTrueTrueFalseTrueTrueFalsebank_accounttypeAccount TypeCharacter150Selectselect lov_description from list_of_values a where lower(a.lov_category) = 'account type' and a.cancel = 'F' and ( a.active = 'T' or :recordid > 0 ) order by 100FalseTrueFalseFalseFalseFalseTrueTrueTrueFalseFalseTrueTrueTruebank_accounttypebank_ifsc_codeIFSC CodeCharacter110SelectSelect a1.global_mst_primarybanknameid,a1.ifsc_code,a1.primarybank_name,a1.primarybank_address,a1.primarybank_branch,a1.micr_code,a1.pin_code,a1.accountno_length from global_mst_primarybankname a1 where a1.cancel = 'F' and ( a1.active = 'T' or :recordid > 0 ) order by a1.ifsc_code00FalseTrueifsc_codeglobal_mst_primarybanknameFalseFalseFalseFalseTrueTrueTrueTrueFalseTrueTruefaccountno_length,fbank_name,fbank_address,fbank_pincode,fbank_branchname,fbank_micr_code,eduplicate_accountnumberTruebank_ifsc_code~accountno_length,bank_name,bank_address,bank_pincode,bank_branchname,bank_micr_code,duplicate_accountnumber,bank_account_numberaccountno_lengthaccountno_lengthNumeric100Fill00bank_ifsc_codeaccountno_lengthFalseTrueTrueFalseFalseFalseTrueFalseFalseFalseFalseTrueTrueaccountno_length,bank_ifsc_codeaccount_firstcharaccount_firstcharCharacter1000Acceptselect case when substring( :bank_account_number, 1,1) = chr(39) then 'T' else 'F' end as choice from dual 00TrueFalseFalseTrueTrueFalseFalseFalse{F}TrueFalseFalseFalseFalseTrueTrueaccount_firstchar,bank_account_numberbank_account_numberAccount NumberCharacter250Accept00TrueFalseFalseFalseFalseFalseFalseTrueiif(accountno_length <> 0, (IIF(GetLength(trim(bank_account_number)) = accountno_length, {T}, {Account Length has to be } + str(accountno_length))),{T}) TrueFalseFalseFalseFalseTruesbank_accountnumber_check,eduplicate_accountnumber,saccount_firstchariif( account_firstchar = {T}, trim(substr( bank_account_number, 1,100)), trim(bank_account_number)) iif( recordid > 0, account_firstchar, bank_account_number) iif( account_firstchar = {T}, trim(substr( bank_account_number, 2,100)), bank_account_number) iif( account_firstchar = {T}, trim(substr( bank_account_number, 2,100)), trim(bank_account_number))Truebank_account_number~bank_accountnumber_check,duplicate_accountnumber,bank_ifsc_code,account_firstcharbank_accountnumber_checkAccount NumberCharacter500Acceptselect 1 from dual where ( :bank_account_number ~ '^''?[0-9]+$')00TrueFalseFalseTrueTrueFalseFalseFalseIIF(bank_accountnumber_check =1,{T},{ cannot contain alphabets})TrueFalseFalseFalseFalseTrueTruebank_accountnumber_check,bank_account_numberbank_nameBank NameCharacter1000Fill00bank_ifsc_codeprimarybank_nameFalseFalseTrueTrueFalseFalseTrueFalseFalseFalseFalseTrueTruebank_name,bank_ifsc_codebank_addressBank AddressCharacter2500Fill00bank_ifsc_codeprimarybank_addressFalseFalseTrueTrueFalseFalseTrueFalseFalseFalseFalseTrueTruebank_address,bank_ifsc_codebank_pincodePIN/ZIP CodeNumeric60Fill00bank_ifsc_codepin_codeFalseFalseTrueTrueFalseFalseTrueFalseFalseFalseFalseTrueTruebank_pincode,bank_ifsc_codebank_branchnameBranch NameCharacter1000Fill00bank_ifsc_codeprimarybank_branchFalseFalseTrueTrueFalseFalseTrueFalseFalseFalseFalseTrueTruebank_branchname,bank_ifsc_codebank_micr_codeMICR CodeCharacter150Fill00bank_ifsc_codemicr_codeFalseFalseTrueTrueFalseFalseTrueFalseFalseFalseFalseTrueTruebank_micr_code,bank_ifsc_codeduplicate_accountnumberAccount No. Already ExistCharacter5000calculate00TrueTrueFalseFalseFalsebank_ifsc_code + bank_account_numberFalseFalseFalseFalseFalseTrueTrueduplicate_accountnumber,bank_ifsc_code,bank_account_numberaxpfile_bankuploadUpload Documents [if any]Character20000Accept00TrueFalseFalseFalseTrueFalseFalseTrueTrueFalseFalseFalseFalseTrueTrueaxpfile_bankuploadaxpfilepath_bankuploadaxpfilepath_bankuploadCharacter500calculate00TrueFalseTrueFalseFalseAxpAttachmentPathTrueFalseFalseFalseFalseTrueTrueaxpfilepath_bankuploaddc5Joint Holder Details5client_jointholderdetailsTrueTrueTrueTrueTrueFalsejoint_titleTitleCharacter500Accept00TrueFalseFalseFalseTrueFalseFalseTrueTrueFalseFalseFalseFalseTrueTruejoint_titlejoint_nameNameCharacter1000Accept00TrueFalseFalseFalseTrueFalseFalseTrueTrueFalseFalseFalseFalseTrueejointholder_rowcountTruetrue~joint_titlejoint_name~jointholder_rowcountjoint_dobDate of BirthDate/Time100Accept00TrueFalseFalseFalseTrueFalseFalseTrueIIF(joint_dob > Date(),{ Future date not allowed},{T})TrueFalseFalseFalseFalseTrueTruejoint_dobrelationship_with_holderRelationship with HolderCharacter400Selectselect lov_description from list_of_values a where lower(a.lov_category) = 'relationship' and a.cancel = 'F' and a.active = 'T' order by 100FalseTrueFalseTrueFalseFalseTrueTrueTrueFalseFalseTrueTrueTruerelationship_with_holderjoint_pan_numberJoint Holder PAN#Character100Accept00TrueFalseFalseFalseTrueFalseFalseTrueIIF((activerow > 0) & (joint_pan_number = pan_number),{ should not be same as Primary holder's PAN#},{T})TrueFalseFalseFalseFalseTrueTruejoint_pan_numberjoint_ckyc_numberCKYC#Character150Accept00TrueFalseFalseFalseTrueFalseFalseTrueTrueFalseFalseFalseFalseTrueTruejoint_ckyc_numberjoint_kyc_statusKYC StatusCharacter2000Selectselect lov_description from list_of_values a where lower(a.lov_category) = 'kyc status' and a.cancel = 'F' and ( a.active = 'T' or :recordid > 0 ) order by 100FalseTrueFalseTrueFalseFalseTrueTrueTrueFalseFalseTrueTrueTruejoint_kyc_statusjointholder_rownumberJoint Holder PAN #Character500calculate00TrueTrueFalseFalseFalseactiverowTrueFalseFalseFalseFalseTrueTruejointholder_rownumberaxpfile_jointuploadUpload Documents [if any]Character20000Accept00TrueFalseFalseFalseTrueFalseFalseTrueTrueFalseFalseFalseFalseTrueTrueaxpfile_jointuploadaxpfilepath_jointuploadaxpfilepath_jointuploadCharacter500calculate00TrueFalseTrueFalseFalseAxpAttachmentPathTrueFalseFalseFalseFalseTrueTrueaxpfilepath_jointuploaddc6Address Details6client_addressdetailsFalseTrueTrueTrueFalseFalsepermanent_house_numberAddress Line 1Character3000Accept00TrueFalseFalseFalseFalseFalseFalseTrueTrueFalseFalseFalseFalseTruespermanent_temp_address,eclient_permanentaddress,ecommunication_house_number,scommunication_temp_address,eclient_communicationaddressTruepermanent_house_number~permanent_temp_address,permanent_locality_sublocality,permanent_city,permanent_pin_zip,permanent_state,permanent_country,client_permanentaddress,communication_house_number,same_aspermanent_address,communication_temp_address,comm_locality_sublocality,communication_city,communication_pin_zip,communication_state,communication_country,client_communicationaddresspermanent_locality_sublocalityAddress Line 2Character3000Accept00TrueFalseFalseFalseTrueFalseFalseTrueTrueFalseFalseFalseFalseTruespermanent_temp_address,eclient_permanentaddress,ecomm_locality_sublocality,scommunication_temp_address,eclient_communicationaddressTruetrue~permanent_house_numberpermanent_locality_sublocality~permanent_temp_address,permanent_house_number,permanent_city,permanent_pin_zip,permanent_state,permanent_country,client_permanentaddress,comm_locality_sublocality,same_aspermanent_address,communication_temp_address,communication_house_number,communication_city,communication_pin_zip,communication_state,communication_country,client_communicationaddresspermanent_cityCityCharacter500SelectSELECT a.global_mst_cityid, a.n_city_description, b.n_state_description, c.n_country_name, a.pincode FROM global_mst_city a, global_mst_state b, global_mst_country c where a.state_description = b.global_mst_stateid and b.country = c.global_mst_countryid and a.cancel = 'F' and ( a.active = 'T' or :recordid > 0 ) {dynamicfilter a.n_city_description, b.n_state_description, c.n_country_name~City,State,Country} order by 200FalseTruen_city_descriptionglobal_mst_cityFalseFalseFalseFalseTrueTrueTrueTrueFalseTrueTruefpermanent_state,fpermanent_country,fperpincode_start_digit,spermanent_temp_address,eclient_permanentaddress,ecommunication_city,fcommunication_state,fcomm_pincode_startdigit,fcommunication_country,scommunication_temp_address,eclient_communicationaddressTruepermanent_city~permanent_state,permanent_country,perpincode_start_digit,permanent_temp_address,permanent_house_number,permanent_locality_sublocality,permanent_pin_zip,client_permanentaddress,communication_city,same_aspermanent_address,communication_state,comm_pincode_startdigit,communication_country,communication_temp_address,communication_house_number,comm_locality_sublocality,communication_pin_zip,client_communicationaddresspermanent_pin_zipPIN/ZIP CodeCharacter500Accept00TrueFalseFalseFalseTrueFalseFalseTrueTrueFalseFalseFalseFalseTrueeper_substring_pincode,spermanent_temp_address,eclient_permanentaddress,ecommunication_pin_zip,ecomm_substring_pincode,scommunication_temp_address,eclient_communicationaddressTruepermanent_pin_zip~per_substring_pincode,permanent_temp_address,permanent_house_number,permanent_locality_sublocality,permanent_city,permanent_state,permanent_country,client_permanentaddress,communication_pin_zip,same_aspermanent_address,comm_substring_pincode,communication_temp_address,communication_house_number,comm_locality_sublocality,communication_city,communication_state,communication_country,client_communicationaddresspermanent_stateState/ProvinceCharacter2000Fill00permanent_cityn_state_descriptionFalseFalseTrueTrueFalseFalseTrueFalseFalseFalseFalseTruespermanent_temp_address,eclient_permanentaddressTruepermanent_state,permanent_city~permanent_temp_address,permanent_house_number,permanent_locality_sublocality,permanent_pin_zip,permanent_country,client_permanentaddresspermanent_countryCountryCharacter1000Fill00permanent_cityn_country_nameFalseFalseTrueTrueFalseFalseTrueFalseFalseFalseFalseTruespermanent_temp_address,eclient_permanentaddressTruepermanent_country,permanent_city~permanent_temp_address,permanent_house_number,permanent_locality_sublocality,permanent_pin_zip,permanent_state,client_permanentaddressperpincode_start_digitStart DigitCharacter30Fill00permanent_citypincodeFalseTrueTrueFalseFalseFalseTrueFalseFalseFalseFalseTrueTrueperpincode_start_digit,permanent_cityper_substring_pincodePermanent CityCharacter30calculate00TrueTrueFalseFalseFalseSubStr(permanent_pin_zip,1,2)IIF(ISEmpty(permanent_pin_zip) = {T} | ISEmpty(perpincode_start_digit) = {T},{T},IIF(per_substring_pincode = perpincode_start_digit,{T},{ Invalid Pincode})) TrueFalseFalseFalseFalseTrueTrueper_substring_pincode,permanent_pin_zippermanent_temp_addresspermanent_temp_addressText40000Acceptselect :permanent_house_number ||chr(10)|| :permanent_locality_sublocality ||chr(10)|| :permanent_city ||'-'|| :permanent_pin_zip || chr(10)|| :permanent_state ||chr(10)|| :permanent_country 00TrueFalseFalseTrueTrueFalseFalseFalseTrueFalseFalseFalseFalseTrueeclient_permanentaddressTruepermanent_temp_address,permanent_house_number,permanent_locality_sublocality,permanent_city,permanent_pin_zip,permanent_state,permanent_country~client_permanentaddressclient_permanentaddressClient Permanent AddressText40000calculate00TrueTrueFalseFalseTruepermanent_temp_addressTrueFalseFalseFalseFalseTrueTrueclient_permanentaddress,permanent_temp_address,permanent_house_number,permanent_locality_sublocality,permanent_city,permanent_pin_zip,permanent_state,permanent_countrysame_aspermanent_addressSame as Permanent AddressCharacter10Accept00TrueFalseFalseFalseTrueFalseFalseTrue{T}TrueFalseFalseFalseFalseTrueecommunication_house_number,ecomm_locality_sublocality,ecommunication_city,ecommunication_pin_zip,fcommunication_state,fcomm_pincode_startdigit,ecomm_substring_pincode,fcommunication_country,scommunication_temp_address,eclient_communicationaddressTruesame_aspermanent_address~communication_house_number,permanent_house_number,comm_locality_sublocality,permanent_locality_sublocality,communication_city,permanent_city,communication_pin_zip,permanent_pin_zip,communication_state,comm_pincode_startdigit,comm_substring_pincode,communication_country,communication_temp_address,client_communicationaddresscommunication_house_numberAddress Line 1Character3000Accept00TrueFalseFalseFalseTrueFalseFalseTrueiif(same_aspermanent_address={T},permanent_house_number,{})TrueFalseFalseFalseFalseTruescommunication_temp_address,eclient_communicationaddressTruecommunication_house_number,same_aspermanent_address,permanent_house_number~communication_temp_address,comm_locality_sublocality,permanent_locality_sublocality,communication_city,permanent_city,communication_pin_zip,permanent_pin_zip,communication_state,communication_country,client_communicationaddresscomm_locality_sublocalityAddress Line 2Character3000Accept00TrueFalseFalseFalseTrueFalseFalseTrueiif(same_aspermanent_address={T},permanent_locality_sublocality,{})TrueFalseFalseFalseFalseTruescommunication_temp_address,eclient_communicationaddressTruecomm_locality_sublocality,same_aspermanent_address,permanent_locality_sublocality~communication_temp_address,communication_house_number,permanent_house_number,communication_city,permanent_city,communication_pin_zip,permanent_pin_zip,communication_state,communication_country,client_communicationaddresscommunication_cityCityCharacter1000SelectSELECT a.n_city_description, b.n_state_description, c.n_country_name, a.pincode FROM global_mst_city a, global_mst_state b, global_mst_country c where a.state_description = b.global_mst_stateid and b.country = c.global_mst_countryid and a.cancel = 'F' and ( a.active = 'T' or :recordid > 0 ) {dynamicfilter a.n_city_description, b.n_state_description, c.n_country_name~City,State,Country} order by 200FalseTrueFalseTrueFalseFalseTrueiif(same_aspermanent_address={T},permanent_city,{})TrueTrueFalseFalseTrueTruefcommunication_state,fcomm_pincode_startdigit,fcommunication_country,scommunication_temp_address,eclient_communicationaddressTruecommunication_city,same_aspermanent_address,permanent_city~communication_state,comm_pincode_startdigit,communication_country,communication_temp_address,communication_house_number,permanent_house_number,comm_locality_sublocality,permanent_locality_sublocality,communication_pin_zip,permanent_pin_zip,client_communicationaddresscommunication_pin_zipPIN/ZIP CodeCharacter500Accept00TrueFalseFalseFalseTrueFalseFalseTrueiif(same_aspermanent_address={T},permanent_pin_zip,{})TrueFalseFalseFalseFalseTrueecomm_substring_pincode,scommunication_temp_address,eclient_communicationaddressTruecommunication_pin_zip,same_aspermanent_address,permanent_pin_zip~comm_substring_pincode,communication_temp_address,communication_house_number,permanent_house_number,comm_locality_sublocality,permanent_locality_sublocality,communication_city,permanent_city,communication_state,communication_country,client_communicationaddresscommunication_stateState/ProvinceCharacter1000Fill00communication_cityn_state_descriptionFalseFalseTrueTrueFalseFalseTrueFalseFalseFalseFalseTruescommunication_temp_address,eclient_communicationaddressTruecommunication_state,communication_city,same_aspermanent_address,permanent_city~communication_temp_address,communication_house_number,permanent_house_number,comm_locality_sublocality,permanent_locality_sublocality,communication_pin_zip,permanent_pin_zip,communication_country,client_communicationaddresscomm_pincode_startdigitpincode_start_digitCharacter30Fill00communication_citypincodeFalseTrueTrueFalseFalseFalseTrueFalseFalseFalseFalseTrueTruecomm_pincode_startdigit,communication_city,same_aspermanent_address,permanent_citycomm_substring_pincodeCommunication CityCharacter30calculate00TrueTrueFalseFalseFalseSubStr(communication_pin_zip,1,2)IIF(ISEmpty(communication_pin_zip) = {T} | ISEmpty(comm_pincode_startdigit) = {T},{T},IIF(comm_substring_pincode = comm_pincode_startdigit,{T},{ Invalid Pincode}))TrueFalseFalseFalseFalseTrueTruecomm_substring_pincode,communication_pin_zip,same_aspermanent_address,permanent_pin_zipcommunication_countryCountryCharacter1000Fill00communication_cityn_country_nameFalseFalseTrueTrueFalseFalseTrueFalseFalseFalseFalseTruescommunication_temp_address,eclient_communicationaddressTruecommunication_country,communication_city,same_aspermanent_address,permanent_city~communication_temp_address,communication_house_number,permanent_house_number,comm_locality_sublocality,permanent_locality_sublocality,communication_pin_zip,permanent_pin_zip,communication_state,client_communicationaddresscommunication_temp_addresscommunication_temp_addressText40000Acceptselect :communication_house_number ||chr(10)|| :comm_locality_sublocality ||chr(10)|| :communication_city ||'-'|| :communication_pin_zip || chr(10)|| :communication_state ||chr(10)|| :communication_country00TrueFalseFalseTrueTrueFalseFalseFalseTrueFalseFalseFalseFalseTrueeclient_communicationaddressTruecommunication_temp_address,communication_house_number,same_aspermanent_address,permanent_house_number,comm_locality_sublocality,permanent_locality_sublocality,communication_city,permanent_city,communication_pin_zip,permanent_pin_zip,communication_state,communication_country~client_communicationaddressclient_communicationaddressClient Communication AddresssText40000calculate00TrueTrueFalseFalseTruecommunication_temp_addressTrueFalseFalseFalseFalseTrueTrueclient_communicationaddress,communication_temp_address,communication_house_number,same_aspermanent_address,permanent_house_number,comm_locality_sublocality,permanent_locality_sublocality,communication_city,permanent_city,communication_pin_zip,permanent_pin_zip,communication_state,communication_countryaxpfile_addressuploadUpload Documents [if any]Character20000Accept00TrueFalseFalseFalseTrueFalseFalseTrueTrueFalseFalseFalseFalseTrueTrueaxpfile_addressuploadaxpfilepath_addressuploadaxpfilepath_addressuploadCharacter500calculate00TrueFalseTrueFalseFalseAxpAttachmentPathTrueFalseFalseFalseFalseTrueTrueaxpfilepath_addressuploaddc7Nominee Details7client_nomineedetailsTrueTrueTrueTrueTrueFalsenominee_orderOrderCharacter200Selectselect lov_description from list_of_values a where lower(a.lov_category) = 'details' and a.cancel = 'F' and ( a.active = 'T' or :recordid > 0 ) order by 100FalseTrueTrueTrueFalseFalseFalseTrueTrueFalseFalseTrueTrueTruenominee_ordernominee_titleTitleCharacter500Accept00TrueFalseFalseFalseTrueFalseFalseTrueTrueFalseFalseFalseFalseTrueTruenominee_titlenominee_nameNominee NameCharacter2000Accept00TrueFalseFalseFalseTrueFalseFalseTrueTrueFalseFalseFalseFalseTrueenominee_dcrowcountTruenominee_name~nominee_dcrowcountnominee_shareNominee Share [Percent]Numeric102Accept00TrueFalseFalseFalseTrueFalseFalseTrueTrueFalseFalseFalseFalseTrueenominee_share_totalTruenominee_share~nominee_share_totalrelationship_to_holderRelationshipCharacter500Selectselect lov_description from list_of_values a where lower(a.lov_category) = 'relationship' and a.cancel = 'F' and ( a.active = 'T' or :recordid > 0 ) order by 100FalseTrueFalseTrueFalseFalseTrueTrueTrueFalseFalseTrueTrueTruerelationship_to_holdernominee_date_of_birthDate of BirthDate/Time100Accept00TrueFalseFalseFalseTrueFalseFalseTrueIIF(nominee_date_of_birth > Date(),{Future date not allowed},{T})TrueFalseFalseFalseFalseTrueTruenominee_date_of_birthnominee_isminorMinorCharacter50Select00FalseFalseYesNoFalseTrueFalseFalseTrue{No}TrueTrueFalseFalseTrueTrueTruenominee_isminorguardianname_isminorGuardian Name [if Minor]Character1000Accept00TrueFalseFalseFalseTrueFalseFalseTrueIIF(nominee_isminor = {No}, {T}, iif(ISEmpty(guardianname_isminor) = {T},{ Cannot be left empty if nominee is minor},{T}))TrueFalseFalseFalseFalseTrueTrueguardianname_isminorguardian_relationshipGuardian RelationshipCharacter500Selectselect lov_description from list_of_values a where lower(a.lov_category) = 'relationship' and a.cancel = 'F' and ( a.active = 'T' or :recordid > 0 ) order by 100FalseTrueFalseTrueFalseFalseTrueIIF(nominee_isminor = {No}, {T}, iif(ISEmpty(guardian_relationship) = {T},{ Cannot be left empty if nominee is minor},{T})) TrueTrueFalseFalseTrueTrueTrueguardian_relationshipguardian_mobilenoGuardian Mobile No.Numeric100Accept00TrueFalseFalseFalseTrueFalseFalseTrueIIF(nominee_isminor = {No}, {T}, iif(ISEmpty(guardian_mobileno) = {T},{ Cannot be left empty if nominee is minor},{T})) TrueFalseFalseFalseFalseTrueTrueguardian_mobilenoguardian_pan_numberGuardian PAN#Character100Accept00TrueFalseFalseFalseTrueFalseFalseTrueIIF(nominee_isminor = {No}, {T}, iif(ISEmpty(guardian_pan_number) = {T},{ Cannot be left empty if nominee is minor},{T})) TrueFalseFalseFalseFalseTrueTrueguardian_pan_numberguardian_ckyc_numberGuardian CKYC#Character150Accept00TrueFalseFalseFalseTrueFalseFalseTrueIIF(nominee_isminor = {No}, {T}, iif(ISEmpty(guardian_ckyc_number) = {T},{ Cannot be left empty if nominee is minor},{T})) TrueFalseFalseFalseFalseTrueTrueguardian_ckyc_numberguardian_kyc_statusGuardian KYC StatusCharacter2000Selectselect lov_description from list_of_values a where lower(a.lov_category) = 'kyc status' and a.cancel = 'F' and ( a.active = 'T' or :recordid > 0 ) order by 100FalseTrueFalseTrueFalseFalseTrueIIF(nominee_isminor = {No}, {T}, iif(ISEmpty(guardian_kyc_status) = {T},{ Cannot be left empty if nominee is minor},{T})) TrueTrueFalseFalseTrueTrueTrueguardian_kyc_statusaxpfile_nomineeuploadUpload Documents [if any]Character20000Accept00TrueFalseFalseFalseTrueFalseFalseTrueTrueFalseFalseFalseFalseTrueTrueaxpfile_nomineeuploadaxpfilepath_nomineeuploadaxpfilepath_nomineeuploadCharacter500calculate00TrueFalseTrueFalseFalseAxpAttachmentPathTrueFalseFalseFalseFalseTrueTrueaxpfilepath_nomineeuploaddc8UBO Details8client_ubodetailsTrueTrueTrueTrueTrueFalseubo_orderOrderCharacter200Selectselect lov_description from list_of_values a where lower(a.lov_category) = 'details' and a.cancel = 'F' and ( a.active = 'T' or :recordid > 0 ) order by 100FalseTrueTrueTrueFalseFalseFalseTrueTrueFalseFalseTrueTrueTrueubo_orderubo_titleTitleCharacter500Accept00TrueFalseFalseFalseTrueFalseFalseTrueTrueFalseFalseFalseFalseTrueTrueubo_titleubo_nameNameCharacter3000Accept00TrueFalseFalseFalseTrueFalseFalseTrueTrueFalseFalseFalseFalseTrueeubo_rowcountTrueubo_name~ubo_rowcountubo_dateofbirthDate of BirthDate/Time100Accept00TrueFalseFalseFalseTrueFalseFalseTrueIIF(ubo_dateofbirth > Date(),{ Future date not allowed},{T})TrueFalseFalseFalseFalseTrueTrueubo_dateofbirthubo_percentageUBO Share [Percent]Numeric102Accept00TrueFalseFalseFalseTrueFalseFalseTrueTrueFalseFalseFalseFalseTrueeubo_share_totalTrueubo_percentage~ubo_share_totalubo_tinTIN#Character150Accept00TrueFalseFalseFalseTrueFalseFalseTrueFalseFalseFalseFalseFalseTrueTrueubo_tinubo_pan_numberPAN#Character500Accept00TrueFalseFalseFalseTrueFalseFalseTrueTrueFalseFalseFalseFalseTrueTrueubo_pan_numberubo_ckyc_numberCKYC#Character150Accept00TrueFalseFalseFalseTrueFalseFalseTrueTrueFalseFalseFalseFalseTrueTrueubo_ckyc_numberubo_kyc_statusKYC StatusCharacter2000Selectselect lov_description from list_of_values a where lower(a.lov_category) = 'kyc status' and a.cancel = 'F' and ( a.active = 'T' or :recordid > 0 ) order by 100FalseTrueFalseTrueFalseFalseTrueTrueTrueFalseFalseTrueTrueTrueubo_kyc_statusaxpfile_ubouploadUpload Documents [if any]Character20000Accept00TrueFalseFalseFalseTrueFalseFalseTrueTrueFalseFalseFalseFalseTrueTrueaxpfile_ubouploadaxpfilepath_ubouploadaxpfilepath_ubouploadCharacter500calculate00TrueFalseTrueFalseFalseAxpAttachmentPathTrueFalseFalseFalseFalseTrueTrueaxpfilepath_ubouploaddc9Summary9client_detailsFalseTrueTrueTrueFalseFalsejointholder_rowcountJoint Holder Numeric50calculate00FalseTrueTrueFalseTrueGetRowCount({joint_name})IIF( lower(holding_status) = {joint} & jointholder_rowcount = 0, { Details cannot be left blank}, {T}) TrueFalseFalseFalseFalseTrueIIF( lower(holding_status = {joint} & jointholder_rowcount = 0, { Joint holding status cannot be left blank}, {T})Truejointholder_rowcount,joint_namenominee_share_totalTotal Nominees SharesNumeric102calculate00TrueTrueTrueFalseTrueTotal({nominee_share})TrueFalseFalseFalseFalseTrueTruenominee_share_total,nominee_sharenominee_dcrowcountNominee Share [Percent]Numeric100calculate00FalseTrueTrueFalseTrueGetRowCount({nominee_name})IIF(nominee = {T},IIF(nominee_dcrowcount > 0,IIF(nominee_share_total = 100,{T},{Total share of Nominee(s) must be 100%}),{One or more Nominees are mandatory}),{T})TrueFalseFalseFalseFalseTrueTruenominee_dcrowcount,nominee_nameclientlogin_createflagclientlogin_createflagCharacter10calculate00TrueTrueFalseFalseTrueiif( client_logincount = 0, {T}, {F}) TrueFalseFalseFalseFalseTrueTrueclientlogin_createflag,client_logincount,primary_emailidubo_share_totalTotal UBO SharesNumeric102calculate00TrueTrueTrueFalseTrueTotal({ubo_percentage})TrueFalseFalseFalseFalseTrueTrueubo_share_total,ubo_percentageubo_rowcountUBO DetailsNumeric200calculate00TrueTrueTrueFalseTrueGetRowCount({ubo_name})TrueFalseFalseFalseFalseTrueTrueubo_rowcount,ubo_nametrcln1To Portal Loginausrsdc1clientlogin_createflagFalseactiveprimary_emailidprimary_emailidclient_nameclientclient_start_dateADMINclient_codeprimary_mobilenoFalseFalseAxHideControls({dc5})AxHideControls({dc2})AxHideControls({dc7})AxHideControls({dc8})AxHideControls({dc9})if nominee = {T}AxUnhideControls({dc7})else AxHideControls({dc7})end AxHideControls({dc9})if holding_status = {Joint}AxUnhideControls({dc5})elseAxHideControls({dc5})endif nominee_isminor = {Yes}AxUnhideControls({guardianname_isminor}) AxUnhideControls({guardian_relationship})AxUnhideControls({guardian_mobileno})AxUnhideControls({guardian_pan_number})AxUnhideControls({guardian_ckyc_number})AxUnhideControls({guardian_kyc_status})else AxHideControls({guardianname_isminor})AxHideControls({guardian_relationship})AxHideControls({guardian_mobileno})AxHideControls({guardian_pan_number})AxHideControls({guardian_ckyc_number})AxHideControls({guardian_kyc_status})endif nominee_isminor = {No}AxHideControls({guardianname_isminor})AxHideControls({guardian_relationship})AxHideControls({guardian_mobileno})AxHideControls({guardian_pan_number})AxHideControls({guardian_ckyc_number})AxHideControls({guardian_kyc_status})elseAxUnhideControls({guardianname_isminor}) AxUnhideControls({guardian_relationship})AxUnhideControls({guardian_mobileno})AxUnhideControls({guardian_pan_number})AxUnhideControls({guardian_ckyc_number})AxUnhideControls({guardian_kyc_status})endif resident_status = {Resident Indian}AxHideControls({dc2})else AxUnhideControls({dc2})end if ubo = {T}AxUnhideControls({dc8})else AxHideControls({dc8})end if pan_number = joint_pan_number ShowMessage({Duplicate PAN Number not allowed},{Exception},{}) endsearchcolsaccount_activationdate,account_client_id,account_closuredate,account_status,active,aml_check,axpfile_accountupload,axpfile_addressupload,axpfile_bankupload,axpfile_clientupload,axpfile_jointupload,axpfile_nomineeupload,axpfile_nriupload,axpfile_uboupload,bank_account_number,bank_accounttype,bank_address,bank_branchname,bank_ifsc_code,bank_micr_code,bank_name,bank_pincode,cc_mailid1,cc_mailid2,cc_mailid3,ckyc_number,client_code,client_display_name,client_name,comm_locality_sublocality,communication_city,communication_country,communication_house_number,communication_pin_zip,communication_state,country_code,country_of_birth,country_taxresident,date_of_agreement,distributor_mailid,distributor_mobileno,distributor_name,dob_doi,dp_id,father_name,fund_code,gender,guardian_ckyc_number,guardian_kyc_status,guardian_mobileno,guardian_pan_number,guardian_relationship,guardianname_isminor,holding_status,joint_ckyc_number,joint_dob,joint_kyc_status,joint_name,joint_pan_number,joint_title,jointholder_rowcount,kyc_status,miles_account_code,nationality,nominee,nominee_date_of_birth,nominee_dcrowcount,nominee_isminor,nominee_name,nominee_share,nominee_title,occupation,pan_number,permanent_city,permanent_country,permanent_house_number,permanent_locality_sublocality,permanent_pin_zip,permanent_state,place_of_birth,poa_agreement_date,poa_franking_date,poa_stamp_valuation,politically_exp_person,primary_emailid,primary_mobileno,relationship_to_holder,relationship_with_holder,remarks,resident_status,rm_emailid,rm_mobileno,rm_name,same_aspermanent_address,scheme_code,secondary_emailid,secondary_mobileno,spouse_name,tax_status,taxstatus_effectivefrom,tin_authority,tin_number,title,ubo,ubo_ckyc_number,ubo_dateofbirth,ubo_kyc_status,ubo_name,ubo_pan_number,ubo_percentage,ubo_tin,ubo_title,ucc_codefirst_pagematerial-iconsskip_previousmaterial-iconsskip_nextmaterial-iconslast_pagematerial-iconsaddmaterial-iconssavematerial-iconssearchmaterial-iconsremovematerial-iconsremove_red_eyematerial-iconspicture_as_pdfmaterial-iconslistmaterial-iconslistmaterial-iconslistmaterial-iconsdc1dc2dc3dc4dc5dc6dc7dc8dc9Tstructtrclncamera optiontrueALLTstructtrclnCustom CSStrueALLTstructtrclnFile Upload Limit200ALLTstructtrclnGeneraltrueALLTstructtrclnGeneralfalseALLTstructtrclnGridEditinlineALL[{"transid":"trcln","compressedMode":true,"newDesign":true,"staticRunMode":false,"wizardDC":false,"selectedLayout":"default","selectedFontSize":"14","selectedControlHeight":"28","tstUpdatedOn":"01/08/2024 09:53:34","dcLayout":"default","formWidth":"100","formAlignment":"default","fieldCaptionWidth":"30","formLabel":[{"ftype":"label","id":"userFormLabel1","dc":6,"afterField":"divDc6","name":"Permanent Address","fontFamilly":"font-family: Tahoma, Geneva, sans-serif; font-size: 13.34px; color: rgb(0, 0, 0); font-weight: bold;","fontFamillyCode":"[Tahoma,t,f,f,clBlack,f,10]","hyperlinkJson":""},{"ftype":"label","id":"userFormLabel2","dc":6,"afterField":"divDc6","name":"Communication Address","fontFamilly":"font-family: Tahoma, Geneva, sans-serif; font-size: 13.34px; color: rgb(0, 0, 0); font-weight: bold;","fontFamillyCode":"[Tahoma,t,f,f,clBlack,f,10]","hyperlinkJson":""},{"ftype":"label","id":"userFormLabel3","dc":1,"afterField":"divDc1","name":"","fontFamilly":"","fontFamillyCode":"","hyperlinkJson":""}],"buttonFieldFont":[],"dcs":[{"dc_id":"1","isGrid":"F","gridStretch":false,"fieldsDesign":[{"fld_id":"client_code","x":0,"y":0,"width":4,"height":1,"visibility":true},{"fld_id":"active","x":4,"y":0,"width":3,"height":1,"visibility":true},{"fld_id":"userFormLabel3","x":7,"y":0,"width":20,"height":1,"visibility":true},{"fld_id":"axpfile_clientupload","x":27,"y":0,"width":9,"height":1,"visibility":true},{"fld_id":"title","x":0,"y":1,"width":3,"height":1,"visibility":true},{"fld_id":"client_name","x":3,"y":1,"width":10,"height":1,"visibility":true},{"fld_id":"client_display_name","x":13,"y":1,"width":11,"height":1,"visibility":true},{"fld_id":"dob_doi","x":24,"y":1,"width":7,"height":1,"visibility":true},{"fld_id":"gender","x":31,"y":1,"width":5,"height":1,"visibility":true},{"fld_id":"father_name","x":0,"y":2,"width":6,"height":1,"visibility":true},{"fld_id":"spouse_name","x":6,"y":2,"width":7,"height":1,"visibility":true},{"fld_id":"pan_number","x":13,"y":2,"width":5,"height":1,"visibility":true},{"fld_id":"occupation","x":18,"y":2,"width":6,"height":1,"visibility":true},{"fld_id":"country_of_birth","x":24,"y":2,"width":7,"height":1,"visibility":true},{"fld_id":"place_of_birth","x":31,"y":2,"width":5,"height":1,"visibility":true},{"fld_id":"nationality","x":0,"y":3,"width":6,"height":1,"visibility":true},{"fld_id":"resident_status","x":6,"y":3,"width":7,"height":1,"visibility":true},{"fld_id":"kyc_status","x":13,"y":3,"width":5,"height":1,"visibility":true},{"fld_id":"ckyc_number","x":18,"y":3,"width":6,"height":1,"visibility":true},{"fld_id":"holding_status","x":24,"y":3,"width":6,"height":1,"visibility":true},{"fld_id":"tax_status","x":30,"y":3,"width":6,"height":1,"visibility":true},{"fld_id":"country_code","x":0,"y":4,"width":3,"height":1,"visibility":true},{"fld_id":"primary_mobileno","x":3,"y":4,"width":4,"height":1,"visibility":true},{"fld_id":"secondary_mobileno","x":7,"y":4,"width":5,"height":1,"visibility":true},{"fld_id":"politically_exp_person","x":12,"y":4,"width":5,"height":1,"visibility":true},{"fld_id":"ubo","x":17,"y":4,"width":2,"height":1,"visibility":true},{"fld_id":"nominee","x":19,"y":4,"width":3,"height":1,"visibility":true},{"fld_id":"primary_emailid","x":22,"y":4,"width":8,"height":1,"visibility":true},{"fld_id":"secondary_emailid","x":30,"y":4,"width":6,"height":1,"visibility":true},{"fld_id":"distributor_name","x":0,"y":5,"width":8,"height":1,"visibility":true},{"fld_id":"distributor_mailid","x":8,"y":5,"width":22,"height":1,"visibility":true},{"fld_id":"distributor_mobileno","x":30,"y":5,"width":6,"height":1,"visibility":true},{"fld_id":"rm_name","x":0,"y":6,"width":8,"height":1,"visibility":true},{"fld_id":"rm_emailid","x":8,"y":6,"width":22,"height":1,"visibility":true},{"fld_id":"rm_mobileno","x":30,"y":6,"width":6,"height":1,"visibility":true},{"fld_id":"cc_mailid1","x":0,"y":7,"width":8,"height":1,"visibility":true},{"fld_id":"cc_mailid2","x":8,"y":7,"width":8,"height":1,"visibility":true},{"fld_id":"cc_mailid3","x":16,"y":7,"width":8,"height":1,"visibility":true},{"fld_id":"aml_check","x":24,"y":7,"width":3,"height":1,"visibility":true},{"fld_id":"remarks","x":27,"y":7,"width":9,"height":1,"visibility":true}],"tableDesign":null},{"dc_id":"2","isGrid":"T","gridStretch":false,"fieldsDesign":[{"fld_id":"country_taxresident","x":0,"y":0,"width":24,"height":1,"visibility":true},{"fld_id":"tin_number","x":24,"y":0,"width":9,"height":1,"visibility":true},{"fld_id":"tin_authority","x":0,"y":1,"width":24,"height":1,"visibility":true},{"fld_id":"taxstatus_effectivefrom","x":24,"y":1,"width":9,"height":1,"visibility":true},{"fld_id":"axpfile_nriupload","x":0,"y":2,"width":15,"height":1,"visibility":true}],"tableDesign":[{"fld_id":"uniqueEditDeleteAct2","width":39,"visibility":true},{"fld_id":"uniqueThHead2","width":41,"visibility":true},{"fld_id":"axp_recid2","width":0,"visibility":false},{"fld_id":"country_taxresident","width":201,"visibility":true},{"fld_id":"tin_number","width":138,"visibility":true},{"fld_id":"tin_authority","width":156,"visibility":true},{"fld_id":"taxstatus_effectivefrom","width":128,"visibility":true},{"fld_id":"axpfile_nriupload","width":216,"visibility":true},{"fld_id":"axpfilepath_nriupload","width":0,"visibility":false}]},{"dc_id":"3","isGrid":"T","gridStretch":false,"fieldsDesign":[{"fld_id":"fund_code","x":0,"y":0,"width":15,"height":1,"visibility":true},{"fld_id":"scheme_code","x":15,"y":0,"width":15,"height":1,"visibility":true},{"fld_id":"account_status","x":0,"y":1,"width":9,"height":1,"visibility":true},{"fld_id":"ucc_code","x":9,"y":1,"width":15,"height":1,"visibility":true},{"fld_id":"miles_account_code","x":0,"y":2,"width":15,"height":1,"visibility":true},{"fld_id":"date_of_agreement","x":15,"y":2,"width":9,"height":1,"visibility":true},{"fld_id":"dp_id","x":24,"y":2,"width":9,"height":1,"visibility":true},{"fld_id":"account_client_id","x":0,"y":3,"width":15,"height":1,"visibility":true},{"fld_id":"account_activationdate","x":15,"y":3,"width":9,"height":1,"visibility":true},{"fld_id":"poa_agreement_date","x":24,"y":3,"width":9,"height":1,"visibility":true},{"fld_id":"poa_franking_date","x":0,"y":4,"width":9,"height":1,"visibility":true},{"fld_id":"poa_stamp_valuation","x":9,"y":4,"width":9,"height":1,"visibility":true},{"fld_id":"account_closuredate","x":18,"y":4,"width":9,"height":1,"visibility":true},{"fld_id":"axpfile_accountupload","x":0,"y":5,"width":15,"height":1,"visibility":true}],"tableDesign":[{"fld_id":"uniqueEditDeleteAct3","width":39,"visibility":true},{"fld_id":"uniqueThHead3","width":41,"visibility":true},{"fld_id":"axp_recid3","width":0,"visibility":false},{"fld_id":"fund_code","width":118,"visibility":true},{"fld_id":"scheme_code","width":130,"visibility":true},{"fld_id":"account_status","width":95,"visibility":true},{"fld_id":"ucc_code","width":164,"visibility":true},{"fld_id":"miles_account_code","width":106,"visibility":true},{"fld_id":"date_of_agreement","width":125,"visibility":true},{"fld_id":"dp_id","width":105,"visibility":true},{"fld_id":"account_client_id","width":103,"visibility":true},{"fld_id":"account_activationdate","width":128,"visibility":true},{"fld_id":"poa_agreement_date","width":146,"visibility":true},{"fld_id":"poa_franking_date","width":138,"visibility":true},{"fld_id":"poa_stamp_valuation","width":118,"visibility":true},{"fld_id":"account_closuredate","width":112,"visibility":true},{"fld_id":"axpfile_accountupload","width":161,"visibility":true},{"fld_id":"axpfilepath_accountupload","width":0,"visibility":false},{"fld_id":"duplicatecheck_ucccode","width":0,"visibility":false}]},{"dc_id":"4","isGrid":"T","gridStretch":false,"fieldsDesign":[{"fld_id":"bank_accounttype","x":0,"y":0,"width":9,"height":1,"visibility":true},{"fld_id":"bank_ifsc_code","x":9,"y":0,"width":9,"height":1,"visibility":true},{"fld_id":"bank_account_number","x":18,"y":0,"width":9,"height":1,"visibility":true},{"fld_id":"bank_name","x":0,"y":1,"width":24,"height":1,"visibility":true},{"fld_id":"bank_address","x":0,"y":2,"width":36,"height":1,"visibility":true},{"fld_id":"bank_pincode","x":0,"y":3,"width":9,"height":1,"visibility":true},{"fld_id":"bank_branchname","x":9,"y":3,"width":24,"height":1,"visibility":true},{"fld_id":"bank_micr_code","x":0,"y":4,"width":9,"height":1,"visibility":true},{"fld_id":"axpfile_bankupload","x":9,"y":4,"width":15,"height":1,"visibility":true}],"tableDesign":[{"fld_id":"uniqueEditDeleteAct4","width":39,"visibility":true},{"fld_id":"uniqueThHead4","width":41,"visibility":true},{"fld_id":"axp_recid4","width":0,"visibility":false},{"fld_id":"bank_accounttype","width":140,"visibility":true},{"fld_id":"bank_ifsc_code","width":191,"visibility":true},{"fld_id":"accountno_length","width":0,"visibility":false},{"fld_id":"account_firstchar","width":0,"visibility":false},{"fld_id":"bank_account_number","width":205,"visibility":true},{"fld_id":"bank_accountnumber_check","width":0,"visibility":false},{"fld_id":"bank_name","width":205,"visibility":true},{"fld_id":"bank_address","width":409,"visibility":true},{"fld_id":"bank_pincode","width":114,"visibility":true},{"fld_id":"bank_branchname","width":194,"visibility":true},{"fld_id":"bank_micr_code","width":140,"visibility":true},{"fld_id":"duplicate_accountnumber","width":0,"visibility":false},{"fld_id":"axpfile_bankupload","width":192,"visibility":true},{"fld_id":"axpfilepath_bankupload","width":0,"visibility":false}]},{"dc_id":"5","isGrid":"T","gridStretch":false,"fieldsDesign":[{"fld_id":"joint_title","x":0,"y":0,"width":15,"height":1,"visibility":true},{"fld_id":"joint_name","x":0,"y":1,"width":24,"height":1,"visibility":true},{"fld_id":"joint_dob","x":24,"y":1,"width":9,"height":1,"visibility":true},{"fld_id":"relationship_with_holder","x":0,"y":2,"width":12,"height":1,"visibility":true},{"fld_id":"joint_pan_number","x":12,"y":2,"width":9,"height":1,"visibility":true},{"fld_id":"joint_ckyc_number","x":21,"y":2,"width":9,"height":1,"visibility":true},{"fld_id":"joint_kyc_status","x":0,"y":3,"width":36,"height":1,"visibility":true},{"fld_id":"axpfile_jointupload","x":0,"y":4,"width":15,"height":1,"visibility":true}],"tableDesign":[{"fld_id":"uniqueEditDeleteAct5","width":39,"visibility":true},{"fld_id":"uniqueThHead5","width":41,"visibility":true},{"fld_id":"axp_recid5","width":0,"visibility":false},{"fld_id":"joint_title","width":58,"visibility":true},{"fld_id":"joint_name","width":165,"visibility":true},{"fld_id":"joint_dob","width":121,"visibility":true},{"fld_id":"relationship_with_holder","width":143,"visibility":true},{"fld_id":"joint_pan_number","width":126,"visibility":true},{"fld_id":"joint_ckyc_number","width":203,"visibility":true},{"fld_id":"joint_kyc_status","width":193,"visibility":true},{"fld_id":"jointholder_rownumber","width":0,"visibility":false},{"fld_id":"axpfile_jointupload","width":157,"visibility":true},{"fld_id":"axpfilepath_jointupload","width":0,"visibility":false}]},{"dc_id":"6","isGrid":"F","gridStretch":false,"fieldsDesign":[{"fld_id":"userFormLabel1","x":0,"y":0,"width":19,"height":1,"visibility":true},{"fld_id":"permanent_house_number","x":0,"y":1,"width":16,"height":1,"visibility":true},{"fld_id":"permanent_locality_sublocality","x":17,"y":1,"width":16,"height":1,"visibility":true},{"fld_id":"permanent_city","x":0,"y":2,"width":11,"height":1,"visibility":true},{"fld_id":"permanent_pin_zip","x":11,"y":2,"width":5,"height":1,"visibility":true},{"fld_id":"permanent_state","x":17,"y":2,"width":11,"height":1,"visibility":true},{"fld_id":"permanent_country","x":28,"y":2,"width":5,"height":1,"visibility":true},{"fld_id":"same_aspermanent_address","x":0,"y":3,"width":16,"height":1,"visibility":true},{"fld_id":"userFormLabel2","x":0,"y":4,"width":9,"height":1,"visibility":true},{"fld_id":"communication_house_number","x":0,"y":5,"width":16,"height":1,"visibility":true},{"fld_id":"comm_locality_sublocality","x":17,"y":5,"width":16,"height":1,"visibility":true},{"fld_id":"communication_city","x":0,"y":6,"width":11,"height":1,"visibility":true},{"fld_id":"communication_pin_zip","x":11,"y":6,"width":5,"height":1,"visibility":true},{"fld_id":"communication_state","x":17,"y":6,"width":11,"height":1,"visibility":true},{"fld_id":"communication_country","x":28,"y":6,"width":5,"height":1,"visibility":true},{"fld_id":"axpfile_addressupload","x":0,"y":7,"width":16,"height":1,"visibility":true}],"tableDesign":null},{"dc_id":"7","isGrid":"T","gridStretch":false,"fieldsDesign":[{"fld_id":"nominee_title","x":0,"y":0,"width":15,"height":1,"visibility":true},{"fld_id":"nominee_name","x":0,"y":1,"width":36,"height":1,"visibility":true},{"fld_id":"nominee_share","x":0,"y":2,"width":9,"height":1,"visibility":true},{"fld_id":"relationship_to_holder","x":9,"y":2,"width":15,"height":1,"visibility":true},{"fld_id":"nominee_date_of_birth","x":24,"y":2,"width":9,"height":1,"visibility":true},{"fld_id":"nominee_isminor","x":0,"y":3,"width":9,"height":1,"visibility":true},{"fld_id":"guardianname_isminor","x":9,"y":3,"width":24,"height":1,"visibility":true},{"fld_id":"guardian_relationship","x":0,"y":4,"width":15,"height":1,"visibility":true},{"fld_id":"guardian_mobileno","x":15,"y":4,"width":9,"height":1,"visibility":true},{"fld_id":"guardian_pan_number","x":24,"y":4,"width":9,"height":1,"visibility":true},{"fld_id":"guardian_ckyc_number","x":0,"y":5,"width":9,"height":1,"visibility":true},{"fld_id":"guardian_kyc_status","x":0,"y":6,"width":36,"height":1,"visibility":true},{"fld_id":"axpfile_nomineeupload","x":0,"y":7,"width":15,"height":1,"visibility":true}],"tableDesign":[{"fld_id":"uniqueEditDeleteAct7","width":39,"visibility":true},{"fld_id":"uniqueThHead7","width":41,"visibility":true},{"fld_id":"axp_recid7","width":0,"visibility":false},{"fld_id":"nominee_order","width":0,"visibility":false},{"fld_id":"nominee_title","width":55,"visibility":true},{"fld_id":"nominee_name","width":248,"visibility":true},{"fld_id":"nominee_share","width":83,"visibility":true},{"fld_id":"relationship_to_holder","width":126,"visibility":true},{"fld_id":"nominee_date_of_birth","width":138,"visibility":true},{"fld_id":"nominee_isminor","width":56,"visibility":true},{"fld_id":"guardianname_isminor","width":149,"visibility":true},{"fld_id":"guardian_relationship","width":113,"visibility":true},{"fld_id":"guardian_mobileno","width":98,"visibility":true},{"fld_id":"guardian_pan_number","width":141,"visibility":true},{"fld_id":"guardian_ckyc_number","width":166,"visibility":true},{"fld_id":"guardian_kyc_status","width":151,"visibility":true},{"fld_id":"axpfile_nomineeupload","width":124,"visibility":true},{"fld_id":"axpfilepath_nomineeupload","width":0,"visibility":false}]},{"dc_id":"8","isGrid":"T","gridStretch":false,"fieldsDesign":[{"fld_id":"ubo_title","x":0,"y":0,"width":15,"height":1,"visibility":true},{"fld_id":"ubo_name","x":0,"y":1,"width":36,"height":1,"visibility":true},{"fld_id":"ubo_dateofbirth","x":0,"y":2,"width":9,"height":1,"visibility":true},{"fld_id":"ubo_percentage","x":9,"y":2,"width":9,"height":1,"visibility":true},{"fld_id":"ubo_tin","x":18,"y":2,"width":9,"height":1,"visibility":true},{"fld_id":"ubo_pan_number","x":0,"y":3,"width":15,"height":1,"visibility":true},{"fld_id":"ubo_ckyc_number","x":15,"y":3,"width":9,"height":1,"visibility":true},{"fld_id":"ubo_kyc_status","x":0,"y":4,"width":36,"height":1,"visibility":true},{"fld_id":"axpfile_uboupload","x":0,"y":5,"width":15,"height":1,"visibility":true}],"tableDesign":[{"fld_id":"uniqueEditDeleteAct8","width":39,"visibility":true},{"fld_id":"uniqueThHead8","width":41,"visibility":true},{"fld_id":"axp_recid8","width":0,"visibility":false},{"fld_id":"ubo_order","width":0,"visibility":false},{"fld_id":"ubo_title","width":54,"visibility":true},{"fld_id":"ubo_name","width":214,"visibility":true},{"fld_id":"ubo_dateofbirth","width":145,"visibility":true},{"fld_id":"ubo_percentage","width":73,"visibility":true},{"fld_id":"ubo_tin","width":85,"visibility":true},{"fld_id":"ubo_pan_number","width":123,"visibility":true},{"fld_id":"ubo_ckyc_number","width":166,"visibility":true},{"fld_id":"ubo_kyc_status","width":258,"visibility":true},{"fld_id":"axpfile_uboupload","width":180,"visibility":true},{"fld_id":"axpfilepath_uboupload","width":0,"visibility":false}]},{"dc_id":"9","isGrid":"F","gridStretch":false,"fieldsDesign":[{"fld_id":"nominee_dcrowcount","x":0,"y":0,"width":7,"height":1,"visibility":true},{"fld_id":"jointholder_rowcount","x":11,"y":0,"width":4,"height":1,"visibility":true}],"tableDesign":null}],"newdcs":null}]AxpAttachmentPath GetStructure webservice completed # 1#Saving to log insert into axpertlog (sessionid,username,calledon,callfinished,structname,recordid,servicename,serviceresult,timetaken,dbtimetaken,db_conntime) values ('gmyjcxxozanv2o1zo21ssfaf','rekhancia',to_timestamp('20/05/2025 12:39:53','dd/mm/yyyy hh24:mi:ss'),to_timestamp('20/05/2025 12:39:54','dd/mm/yyyy hh24:mi:ss'),null,0,'Get Structure','success',896,117,0) uXDS\pinsert\ Check intransaction Closing connection Freeing AxProvider Resources Destroying License Manager Destroying License Manager XDS Destroying License Manager Completed Freeing DbManager Resources Destroying Default xds in db manager Destroying connect object Disconnecting from db trustlineuat Keep Connection setting false Disconnecting... Disconnected... Dbx name = ConnectionName = DriverName = GetDriverFunc = LibraryName = VendorLib = Successfully disconnected from db trustlineuat Destroyed connect object Destroying GF Returning the structure. Getting Structure from DB rekhancia Role: default Recordid = 0 Opening Tstruct. ASB XE3/32/64 DLL running [Compiled on 24/03/2025 11:58:10 PM] [File Version : 11.3.0.0]] [Product Version : 11.3][64Bit(240325)] DB Manager created Current ASB DLL folder : E:\Axpert113\Axpert Web\AxpertWebScripts Connecting to project : trustlineuat Connecting to project found : -1 Session key validation Session key validation completed Db Manager Connection starts Db Manager Connection XML receied : dbPostgredbxlocalhosttrustlineuat\trustlineuat creating connection starts... creating connection end... creating date xds... creating date xds end... PostGreConnect starts... PostGreConnect ends... db user : trustlineuat Select now() as sdt Time elapsed = 1 select props from axprops where lower(name)='app' order by blobno uXDS\dopen\ Check intransaction Time elapsed = 4 axprops xml = images\Agile-TrustLine-UATINR1FFFsmtp.office365.com587portalneo@trustlineindia.com9IntFlo!!$$*1100000FF SELECT Constraint_Name FROM AXCONSTRAINTS where 1=2 uXDS\dopen\ Check intransaction Time elapsed = 2 Db Manager Connection ends Connection to DB Successful Executing Quick DoFormLoad webservice ------------------------------------- Registering app/user variables for the session Registering DBMem variables Registering DBMem variables completed Registering ConfigParam variables Registering ConfigParam variables completed auth_path=E:\Axpert113\Axpert Web\AxpertWebScripts axp_clientlocale=en-us*asia/calcutta^english*5/20/2025 12:14:18 pm* axp_appschema=trustlineuat axp_devschema=trustlineuataxdef axp_apipath=https://appneo.trustlineindia.biz/trustlineuatwebScripts/ axp_connectionname=trustlineuat sesid=gmyjcxxozanv2o1zo21ssfaf ax_evalcopy=F rolename=default responsibilies=default millions=F axpimageserver= axglo_hide= axp_displaytext= axglo_user= fromuserlogin= axglo_recordid=1025660000000 axpimagepath= AxpServerPath=\\10.16.248.2\UAT_Attachment\UAT_TLBusiness AxpAttachmentPath=\\10.16.248.2\UAT_Attachment\UAT_TLReports AxpDbDirPath=\\10.16.248.2\UAT_Attachment\UAT_TLReports\AxImportDbDir LStr : ~~9867~25~0~0~1~R~false~R LReg Type : R User Group default User Roles default Registering app/user variables for the session completed select sessionid from connections where sessionid = :sesid uXDS\dopen\ Check intransaction Time elapsed = 3 Received XML dbPostgredbxlocalhosttrustlineuat\trustlineuattrustlineuatdd/mm/yyyy hh24:mi:ssadminlocalBlackENGLISHtruet\\10.16.248.2\UAT_Attachment\UAT_TLReports\AxImportDbDir\\10.16.248.2\UAT_Attachment\UAT_TLReports\\10.16.248.2\UAT_Attachment\UAT_TLBusiness1025660000000FrekhanciadefaultdefaultFgmyjcxxozanv2o1zo21ssfafdefault~100trustlineuattrustlineuat0defaulthttps://appneo.trustlineindia.biz/trustlineuatwebScripts/trustlineuataxdeftrustlineuaten-us*asia/calcutta^english*5/20/2025 12:14:18 pm*~~9867~25~0~0~1~R~false~RccccncccccE:\Axpert113\Axpert Web\AxpertWebScripts Received SXML trclnClient MastertFalseFalseTrueFalseFalseNoneDefaultFalsedc1Client Master1client_detailsFalseTrueTrueTrueFalseFalseclient_codeClient CodeCharacter500Accept00TrueFalseFalseFalseFalseFalseFalseTrueFalseFalseFalseFalseFalseTrueedocid,slogincountTrueclient_code~docid,logincountdocidDocid Character500calculate00TrueFalseFalseFalseTrueclient_codeFalseFalseFalseFalseFalseTrueTruedocid,client_coderecidrecidNumeric150Accept00TrueFalseFalseTrueTrueFalseFalseFalserecordidTrueFalseFalseFalseFalseTrueTruerecidlogincountlogincountNumeric100Acceptselect count(1) as cnt from axusers a, client_details b where b.primary_emailid = a.pusername and b.client_code = :client_code00TrueFalseFalseTrueTrueFalseFalseFalseTrueFalseFalseFalseFalseTrueTruelogincount,client_code<a1>title</a1><a2>Title</a2><a69></a69><a3>Character</a3><a4>50</a4><a5>0</a5><a6>Accept</a6><a7><a22 txt="" firesql="false" param="n" pcount="0"></a22><a18></a18><a21>0</a21><a20>0</a20><a23>True</a23><a24>False</a24><a25 /><a26 table="" cap="" stype="" scol="0"></a26><a27></a27><a28 /><a29 /><a30>False</a30><a40 /><a41 /><a63 /></a7><a8>False</a8><a9>True</a9><a10>False</a10><a11>False</a11><a12>True</a12><a13></a13><a14></a14><a15>True</a15><a16>False</a16><a17>False</a17><a19>False</a19><a52>False</a52><a31></a31><a32></a32><a33></a33><a34></a34><a35></a35><a36></a36><a37></a37><a46></a46><a47></a47><a48 masking="No Mask" lastcharmask="0" firstcharmask="0" maskchar="X" maskroles=""></a48><a49></a49><a50></a50><a51></a51><a55>True</a55><a56></a56><a57></a57><a58></a58><a64></a64><a59></a59><a60></a60><a65></a65><a67>True</a67><a70></a70><a66>title</a66>client_nameClient NameCharacter2550Accept00TrueFalseFalseFalseFalseFalseFalseTrueFalseFalseFalseFalseFalseTruesclient_name_check,eclient_display_nameTrueclient_name~client_name_check,client_display_nameclient_name_checkClient NameCharacter500AcceptSELECT 1 FROM dual WHERE ( :client_name !~ '^[0-9]+$' AND :client_name ~ '[A-Za-z]+')00TrueFalseFalseTrueTrueFalseFalseFalseIIF(client_name_check =1,{T},{ cannot be only numeric})TrueFalseFalseFalseFalseTrueTrueclient_name_check,client_nameclient_display_nameDisplay NameCharacter2550Accept00TrueFalseFalseFalseFalseFalseFalseTrueIIF(recordid = 0, client_name)TrueFalseFalseFalseFalseTrueTrueclient_display_name,client_namefather_nameFather NameCharacter2550Accept00TrueFalseFalseFalseTrueFalseFalseTrueTrueFalseFalseFalseFalseTrueTruefather_namespouse_nameSpouse NameCharacter2550Accept00TrueFalseFalseFalseTrueFalseFalseTrueTrueFalseFalseFalseFalseTrueTruespouse_namegenderGenderCharacter200Selectselect lov_description from list_of_values a where lower(a.lov_category) = 'gender' and a.cancel = 'F' and a.active = 'T' order by 100FalseTrueFalseTrueFalseFalseTrueTrueTrueFalseFalseTrueTrueTruegenderpan_numberPAN#Character100Accept00TrueFalseFalseFalseFalseFalseFalseTrueTrueFalseFalseFalseFalseTrueTruepan_numberdob_doiDate of Birth/Date of IncorporationDate/Time100Accept00TrueFalseFalseFalseFalseFalseFalseTrueIIF(dob_doi > Date(), { Future date not allowed},{T})TrueFalseFalseFalseFalseTrueTruedob_doipolitically_exp_personPolitically Exposed PersonCharacter10Accept00TrueFalseFalseFalseTrueFalseFalseTrue{F}TrueFalseFalseFalseFalseTrueTruepolitically_exp_personoccupationOccupationCharacter500Selectselect lov_description from list_of_values a where lower(a.lov_category) = 'occupation' and a.cancel = 'F' and ( a.active = 'T' or :recordid > 0 ) order by 100FalseTrueFalseFalseFalseFalseTrueTrueTrueFalseFalseTrueTrueTrueoccupationcountry_of_birthCountry of BirthCharacter1000SelectSelect a1.global_mst_countryid,a1.n_country_name,a1.nationality from global_mst_country a1 where a1.active = 'T' and a1.cancel = 'F' order by a1.n_country_name00FalseTruen_country_nameglobal_mst_countryFalseFalseFalseFalseTrue{India}TrueTrueTrueFalseTrueTrueftemp_nationality,enationality,sresident_statusTruecountry_of_birth~temp_nationality,nationality,resident_statusplace_of_birthPlace of BirthCharacter2000Accept00TrueFalseFalseFalseFalseFalseFalseTrueTrueFalseFalseFalseFalseTrueTrueplace_of_birthtemp_nationalitytemp_nationalityCharacter1000Fill00country_of_birthnationalityFalseTrueTrueFalseFalseFalseTrueFalseFalseFalseFalseTrueenationality,sresident_statusTruetemp_nationality,country_of_birth~nationality,resident_statusnationalityNationalityCharacter500Selectselect a.nationality from global_mst_country a where a.cancel = 'F' and ( a.active = 'T' or :recordid > 0 ) order by 100FalseTrueFalseFalseFalseFalseTruetemp_nationalityTrueTrueFalseFalseTrueTruesresident_statusTruenationality,temp_nationality,country_of_birth~resident_statusresident_statusResident StatusCharacter500Selectselect lov_description from list_of_values a where lower(a.lov_category) = 'resident status' and a.cancel = 'F' and ( a.active = 'T' or :recordid > 0 ) and ( (lower( :nationality) = 'indian' and lower(a.lov_description) !='foreign national') or (lower( :nationality) != 'indian' and lower(a.lov_description) ='foreign national') ) order by 100TrueTrueFalseFalseFalseFalseTrueTrueTrueFalseFalseTrueTrueselect lov_description from list_of_values a where lower(a.lov_category) = 'resident status' and a.cancel = 'F' and a.active = 'T' and (lower( :nationality) = 'indian' and lower(a.lov_description) !='foreign national') or lower( :nationality) != 'indian') order by 1Trueresident_status,nationality,temp_nationality,country_of_birthkyc_statusKYC StatusCharacter2000Selectselect lov_description from list_of_values a where lower(a.lov_category) = 'kyc status' and a.cancel = 'F' and ( a.active = 'T' or :recordid > 0 ) order by 100FalseTrueFalseFalseFalseFalseTrueTrueTrueFalseFalseTrueTrueTruekyc_statusckyc_numberCKYC#Character150Accept00TrueFalseFalseFalseFalseFalseFalseTrueTrueFalseFalseFalseFalseTrueTrueckyc_numberholding_statusHolding StatusCharacter500Selectselect lov_description from list_of_values a where lower(a.lov_category) = 'holding status' and a.cancel = 'F' and ( a.active = 'T' or :recordid > 0 ) order by 100FalseTrueFalseFalseFalseFalseTrue{Single}TrueTrueFalseFalseTrueTrueTrueholding_statustax_statusTAX StatusCharacter1000Selectselect lov_description from list_of_values a where lower(a.lov_category) = 'tax status' and a.cancel = 'F' and ( a.active = 'T' or :recordid > 0 ) order by 100FalseTrueFalseFalseFalseFalseTrueTrueTrueFalseFalseTrueTrueTruetax_statuscountry_codeISD/STD CodeCharacter200Selectselect a.calling_code from global_mst_country a where ( a.active = 'T' or :recordid > 0 ) and a.cancel = 'F' order by 100FalseTrueFalseTrueFalseFalseTrueTrueTrueFalseFalseTrueTrueTruecountry_codeprimary_mobilenoPrimary Mobile No.Numeric100Accept00TrueFalseFalseFalseFalseFalseFalseTrueTrueFalseFalseFalseFalseTrueTrueprimary_mobilenosecondary_mobilenoSecondary Mobile No.Numeric100Accept00TrueFalseFalseFalseTrueFalseFalseTrueTrueFalseFalseFalseFalseTrueTruesecondary_mobilenouboUBOCharacter10Accept00TrueFalseFalseFalseTrueFalseFalseTrue{F}TrueFalseFalseFalseFalseTrueTrueubonomineeOpt. NomineeCharacter10Accept00TrueFalseFalseFalseTrueFalseFalseTrue{F}TrueFalseFalseFalseFalseTrueTruenomineeprimary_emailidPrimary Email IDCharacter2550Accept00TrueFalseFalseFalseFalseFalseFalseTrueTrueFalseFalseFalseFalseTruesduplicate_primarymail_id,sclient_logincount,econtrol_fieldcheck,eclientlogin_createflagMail Id provided here will be used to create LoginTrueprimary_emailid~duplicate_primarymail_id,client_logincount,control_fieldcheck,clientlogin_createflagduplicate_primarymail_idduplicate_primarymail_idCharacter2000Acceptselect a.username from axusers a where a.username = :primary_emailid 00TrueFalseFalseTrueTrueTrueFalseFalseTrueFalseFalseFalseFalseTrueecontrol_fieldcheckTrueduplicate_primarymail_id,primary_emailid~control_fieldcheckclient_start_dateclient_start_dateDate/Time100Accept00TrueFalseFalseTrueTrueFalseFalseTruedate() TrueFalseFalseFalseFalseTrueTrueclient_start_datesecondary_emailidSecondary Email IDCharacter2550Accept00TrueFalseFalseFalseTrueFalseFalseTrueTrueFalseFalseFalseFalseTrueTruesecondary_emailiddistributor_nameDistributor NameCharacter1000SelectSelect a1.distributor_rm_name,a1.distributor_rm_emailid,a1.distributor_rm_mobileno from distributor_rm_detail a1 where lower(a1.distributor_rm) = 'distributor' and a1.cancel = 'F' and ( a1.active = 'T' or :recordid > 0 ) order by a1.title_name00FalseTrueFalseTrueFalseFalseTrueTrueTrueFalseFalseTrueTruefdistributor_mailid,fdistributor_mobilenoTruedistributor_name~distributor_mailid,distributor_mobilenodistributor_mailidDistributor Email IDCharacter2550Fill00distributor_namedistributor_rm_emailidFalseFalseTrueTrueFalseTrueTrueFalseFalseFalseFalseTrueTruedistributor_mailid,distributor_namedistributor_mobilenoDistributor Mobile No.Numeric100Fill00distributor_namedistributor_rm_mobilenoFalseFalseTrueTrueFalseFalseTrueFalseFalseFalseFalseTrueTruedistributor_mobileno,distributor_namerm_nameRM NameCharacter1000SelectSelect a1.distributor_rm_name,a1.distributor_rm_emailid,a1.distributor_rm_mobileno,a1.distributor_rm_detailid from distributor_rm_detail a1 where lower(a1.distributor_rm) = 'rm' and a1.cancel = 'F' and ( a1.active = 'T' or :recordid > 0 ) order by a1.distributor_rm_name00FalseTrueFalseFalseFalseFalseTrueTrueTrueFalseFalseTrueTruefrm_emailid,frm_mobileno,fdistributor_rm_detailidTruerm_name~rm_emailid,rm_mobileno,distributor_rm_detailidrm_emailidRM Email IDCharacter2550Fill00rm_namedistributor_rm_emailidFalseFalseTrueTrueFalseTrueTrueFalseFalseFalseFalseTrueTruerm_emailid,rm_namerm_mobilenoRM Mobile No.Numeric100Fill00rm_namedistributor_rm_mobilenoFalseFalseTrueTrueFalseFalseTrueFalseFalseFalseFalseTrueTruerm_mobileno,rm_namecc_mailid1CC to Mail ID1Character2550Accept00TrueFalseFalseFalseTrueFalseFalseTrueTrueFalseFalseFalseFalseTrueTruecc_mailid1cc_mailid2CC to Mail ID2Character2550Accept00TrueFalseFalseFalseTrueFalseFalseTrueTrueFalseFalseFalseFalseTrueTruecc_mailid2cc_mailid3CC to Mail ID3Character2550Accept00TrueFalseFalseFalseTrueFalseFalseTrueTrueFalseFalseFalseFalseTrueTruecc_mailid3aml_checkAML CheckCharacter10Accept00TrueFalseFalseFalseTrueFalseFalseTrue{F}TrueFalseFalseFalseFalseTrueTrueaml_checkactiveActiveCharacter10Accept00TrueFalseFalseFalseTrueFalseFalseTrue{T}TrueFalseFalseFalseFalseTrueTruetrue~client_codeactiveremarksRemarksCharacter5000Accept00TrueFalseFalseFalseTrueFalseFalseTrueTrueFalseFalseFalseFalseTrueTrueremarksaxpfile_clientuploadUpload Documents [if any]Character20000Accept00TrueFalseFalseFalseTrueFalseFalseTrueTrueFalseFalseFalseFalseTrueTrueaxpfile_clientuploadaxpfilepath_clientuploadaxpfilepath_clientuploadCharacter500calculate00TrueFalseTrueFalseTrueAxpAttachmentPathTrueFalseFalseFalseFalseTrueTrueaxpfilepath_clientuploadclientidsClient IDCharacter5000calculate00TrueTrueFalseFalseTruegetallvalues({account_client_id},{,})TrueFalseFalseFalseFalseTrueTrueclientids,account_client_idclient_logincountclient_logincountNumeric100Acceptselect count(1) as cnt from axusers a where a.username = :primary_emailid00TrueFalseFalseTrueTrueFalseFalseFalseTrueFalseFalseFalseFalseTrueeclientlogin_createflagTrueclient_logincount,primary_emailid~clientlogin_createflagcontrol_fieldcheckcontrol_fieldcheckCharacter500calculate00TrueTrueTrueFalseFalseIIF(primary_emailid = duplicate_primarymail_id, {F},{T})TrueFalseFalseFalseFalseTrueTruecontrol_fieldcheck,primary_emailid,duplicate_primarymail_iddistributor_rm_detailidDistributor_Rm_DetailIdNumeric200Fill00rm_namedistributor_rm_detailidFalseTrueTrueFalseFalseTrueTrueFalseFalseFalseFalseTrueTruedistributor_rm_detailid,rm_namedc2NRI Details2client_nridetailsTrueTrueTrueTrueTrueFalsecountry_taxresidentCountry of Tax ResidentCharacter1000SelectSelect a1.global_mst_countryid,a1.n_country_name from global_mst_country a1 where ( a1.active = 'T' or :recordid > 0 ) and a1.cancel = 'F' order by a1.n_country_name00FalseTruen_country_nameglobal_mst_countryFalseTrueFalseFalseTrue{India}TrueTrueTrueFalseTrueTrueTruecountry_taxresidenttin_numberTIN#Character200Accept00TrueFalseFalseFalseTrueFalseFalseTrueTrueFalseFalseFalseFalseTrueTruetin_numbertin_authorityTIN Issuing AuthorityCharacter1000SelectSelect a1.global_mst_countryid,a1.n_country_name from global_mst_country a1 where ( a1.active = 'T' or :recordid > 0 ) and a1.cancel = 'F' order by a1.n_country_name00FalseTruen_country_nameglobal_mst_countryFalseTrueFalseFalseTrueTrueTrueTrueFalseTrueTrueTruetin_authoritytaxstatus_effectivefromTAX Status Effective FromDate/Time100Accept00TrueFalseFalseFalseTrueFalseFalseTrueTrueFalseFalseFalseFalseTrueTruetaxstatus_effectivefromaxpfile_nriuploadUpload Documents [if any]Character20000Accept00TrueFalseFalseFalseTrueFalseFalseTrueTrueFalseFalseFalseFalseTrueTrueaxpfile_nriuploadaxpfilepath_nriuploadaxpfilepath_nriuploadCharacter500calculate00TrueFalseTrueFalseFalseAxpAttachmentPathTrueFalseFalseFalseFalseTrueTrueaxpfilepath_nriuploaddc3Account Details3client_accountdetailsTrueTrueFalseTrueTrueFalsefund_codeFund CodeCharacter500SelectSelect distinct a1.fund_code from fund_scheme_details a1 where a1.cancel = 'F' and ( a1.active = 'T' or :recordid > 0 ) order by a1.fund_code00FalseTrueFalseFalseFalseFalseTrueTrueTrueFalseFalseTrueTruesscheme_code,eduplicatecheck_ucccodeTruefund_code~scheme_code,duplicatecheck_ucccode,account_client_idscheme_codeScheme CodeCharacter500Selectselect a.scheme_code from fund_scheme_details a where a.fund_code = :fund_code and ( a.active = 'T' or :recordid > 0 ) and a.cancel = 'F' order by 100FalseTrueFalseFalseFalseFalseTrueTrueTrueFalseFalseTrueTrueeduplicatecheck_ucccodeTruescheme_code,fund_code~duplicatecheck_ucccode,account_client_idaccount_statusAccount StatusCharacter200Select00FalseFalseYesNoFalseTrueFalseFalseTrue{Yes}TrueTrueFalseFalseTrueTrueTrueaccount_statusucc_codeUCC CodeCharacter500Accept00TrueFalseFalseFalseFalseFalseFalseTrueTrueFalseFalseFalseFalseTrueTrueucc_codemiles_account_codeMiles Account CodeCharacter500Accept00TrueFalseFalseFalseFalseFalseFalseTrueFalseFalseFalseFalseFalseTrueTruemiles_account_codedate_of_agreementDate of AgreementDate/Time100Accept00TrueFalseFalseFalseFalseFalseFalseTrueIIF(date_of_agreement > Date(),{ Future date not allowed},{T})TrueFalseFalseFalseFalseTrueTruedate_of_agreementdp_idDP IDCharacter200Selectselect a.lov_shortcode from list_of_values a where lower(a.lov_category) = 'dp id' and a.cancel = 'F' and ( a.active = 'T' or :recordid > 0 ) order by 100FalseTrueFalseTrueFalseFalseTrueTrueTrueFalseFalseTrueTrueTruedp_idaccount_client_idClient IDCharacter500Accept00TrueFalseFalseFalseFalseFalseFalseTrueTrueFalseFalseFalseFalseTrueeduplicatecheck_ucccode,eclientidsTrueaccount_client_id~duplicatecheck_ucccode,fund_code,scheme_code,clientidsaccount_activationdateActivation DateDate/Time100Accept00TrueFalseFalseFalseFalseFalseFalseTrueTrueFalseFalseFalseFalseTrueTrueaccount_activationdatepoa_agreement_datePOA Agreement DateDate/Time100Accept00TrueFalseFalseFalseTrueFalseFalseTrueIIF(poa_agreement_date > Date(),{ Future date not allowed},{T})TrueFalseFalseFalseFalseTrueTruepoa_agreement_datepoa_franking_datePOA Franking DateDate/Time100Accept00TrueFalseFalseFalseTrueFalseFalseTrueTrueFalseFalseFalseFalseTrueTruepoa_franking_datepoa_stamp_valuationPOA Stamp Valuation [INR]Numeric102Accept00TrueFalseFalseFalseTrueFalseFalseTrueTrueFalseFalseFalseFalseTrueTruepoa_stamp_valuationaccount_closuredateClosure DateDate/Time100Accept00TrueFalseFalseFalseTrueFalseFalseTrueTrueFalseFalseFalseFalseTrueTrueaccount_closuredateaxpfile_accountuploadUpload Documents [if any]Character20000Accept00TrueFalseFalseFalseTrueFalseFalseTrueTrueFalseFalseFalseFalseTrueTrueaxpfile_accountuploadaxpfilepath_accountuploadaxpfilepath_accountuploadCharacter500calculate00TrueFalseTrueFalseFalseAxpAttachmentPathTrueFalseFalseFalseFalseTrueTrueaxpfilepath_accountuploadduplicatecheck_ucccodeDuplicate UCC CodeCharacter5000calculate00TrueTrueFalseFalseFalsefund_code + scheme_code + account_client_id FalseFalseFalseFalseFalseTrueTrueduplicatecheck_ucccode,fund_code,scheme_code,account_client_iddc4Bank Details4client_bankdetailsTrueTrueFalseTrueTrueFalsebank_accounttypeAccount TypeCharacter150Selectselect lov_description from list_of_values a where lower(a.lov_category) = 'account type' and a.cancel = 'F' and ( a.active = 'T' or :recordid > 0 ) order by 100FalseTrueFalseFalseFalseFalseTrueTrueTrueFalseFalseTrueTrueTruebank_accounttypebank_ifsc_codeIFSC CodeCharacter110SelectSelect a1.global_mst_primarybanknameid,a1.ifsc_code,a1.primarybank_name,a1.primarybank_address,a1.primarybank_branch,a1.micr_code,a1.pin_code,a1.accountno_length from global_mst_primarybankname a1 where a1.cancel = 'F' and ( a1.active = 'T' or :recordid > 0 ) order by a1.ifsc_code00FalseTrueifsc_codeglobal_mst_primarybanknameFalseFalseFalseFalseTrueTrueTrueTrueFalseTrueTruefaccountno_length,fbank_name,fbank_address,fbank_pincode,fbank_branchname,fbank_micr_code,eduplicate_accountnumberTruebank_ifsc_code~accountno_length,bank_name,bank_address,bank_pincode,bank_branchname,bank_micr_code,duplicate_accountnumber,bank_account_numberaccountno_lengthaccountno_lengthNumeric100Fill00bank_ifsc_codeaccountno_lengthFalseTrueTrueFalseFalseFalseTrueFalseFalseFalseFalseTrueTrueaccountno_length,bank_ifsc_codeaccount_firstcharaccount_firstcharCharacter1000Acceptselect case when substring( :bank_account_number, 1,1) = chr(39) then 'T' else 'F' end as choice from dual 00TrueFalseFalseTrueTrueFalseFalseFalse{F}TrueFalseFalseFalseFalseTrueTrueaccount_firstchar,bank_account_numberbank_account_numberAccount NumberCharacter250Accept00TrueFalseFalseFalseFalseFalseFalseTrueiif(accountno_length <> 0, (IIF(GetLength(trim(bank_account_number)) = accountno_length, {T}, {Account Length has to be } + str(accountno_length))),{T}) TrueFalseFalseFalseFalseTruesbank_accountnumber_check,eduplicate_accountnumber,saccount_firstchariif( account_firstchar = {T}, trim(substr( bank_account_number, 1,100)), trim(bank_account_number)) iif( recordid > 0, account_firstchar, bank_account_number) iif( account_firstchar = {T}, trim(substr( bank_account_number, 2,100)), bank_account_number) iif( account_firstchar = {T}, trim(substr( bank_account_number, 2,100)), trim(bank_account_number))Truebank_account_number~bank_accountnumber_check,duplicate_accountnumber,bank_ifsc_code,account_firstcharbank_accountnumber_checkAccount NumberCharacter500Acceptselect 1 from dual where ( :bank_account_number ~ '^''?[0-9]+$')00TrueFalseFalseTrueTrueFalseFalseFalseIIF(bank_accountnumber_check =1,{T},{ cannot contain alphabets})TrueFalseFalseFalseFalseTrueTruebank_accountnumber_check,bank_account_numberbank_nameBank NameCharacter1000Fill00bank_ifsc_codeprimarybank_nameFalseFalseTrueTrueFalseFalseTrueFalseFalseFalseFalseTrueTruebank_name,bank_ifsc_codebank_addressBank AddressCharacter2500Fill00bank_ifsc_codeprimarybank_addressFalseFalseTrueTrueFalseFalseTrueFalseFalseFalseFalseTrueTruebank_address,bank_ifsc_codebank_pincodePIN/ZIP CodeNumeric60Fill00bank_ifsc_codepin_codeFalseFalseTrueTrueFalseFalseTrueFalseFalseFalseFalseTrueTruebank_pincode,bank_ifsc_codebank_branchnameBranch NameCharacter1000Fill00bank_ifsc_codeprimarybank_branchFalseFalseTrueTrueFalseFalseTrueFalseFalseFalseFalseTrueTruebank_branchname,bank_ifsc_codebank_micr_codeMICR CodeCharacter150Fill00bank_ifsc_codemicr_codeFalseFalseTrueTrueFalseFalseTrueFalseFalseFalseFalseTrueTruebank_micr_code,bank_ifsc_codeduplicate_accountnumberAccount No. Already ExistCharacter5000calculate00TrueTrueFalseFalseFalsebank_ifsc_code + bank_account_numberFalseFalseFalseFalseFalseTrueTrueduplicate_accountnumber,bank_ifsc_code,bank_account_numberaxpfile_bankuploadUpload Documents [if any]Character20000Accept00TrueFalseFalseFalseTrueFalseFalseTrueTrueFalseFalseFalseFalseTrueTrueaxpfile_bankuploadaxpfilepath_bankuploadaxpfilepath_bankuploadCharacter500calculate00TrueFalseTrueFalseFalseAxpAttachmentPathTrueFalseFalseFalseFalseTrueTrueaxpfilepath_bankuploaddc5Joint Holder Details5client_jointholderdetailsTrueTrueTrueTrueTrueFalsejoint_titleTitleCharacter500Accept00TrueFalseFalseFalseTrueFalseFalseTrueTrueFalseFalseFalseFalseTrueTruejoint_titlejoint_nameNameCharacter1000Accept00TrueFalseFalseFalseTrueFalseFalseTrueTrueFalseFalseFalseFalseTrueejointholder_rowcountTruetrue~joint_titlejoint_name~jointholder_rowcountjoint_dobDate of BirthDate/Time100Accept00TrueFalseFalseFalseTrueFalseFalseTrueIIF(joint_dob > Date(),{ Future date not allowed},{T})TrueFalseFalseFalseFalseTrueTruejoint_dobrelationship_with_holderRelationship with HolderCharacter400Selectselect lov_description from list_of_values a where lower(a.lov_category) = 'relationship' and a.cancel = 'F' and a.active = 'T' order by 100FalseTrueFalseTrueFalseFalseTrueTrueTrueFalseFalseTrueTrueTruerelationship_with_holderjoint_pan_numberJoint Holder PAN#Character100Accept00TrueFalseFalseFalseTrueFalseFalseTrueIIF((activerow > 0) & (joint_pan_number = pan_number),{ should not be same as Primary holder's PAN#},{T})TrueFalseFalseFalseFalseTrueTruejoint_pan_numberjoint_ckyc_numberCKYC#Character150Accept00TrueFalseFalseFalseTrueFalseFalseTrueTrueFalseFalseFalseFalseTrueTruejoint_ckyc_numberjoint_kyc_statusKYC StatusCharacter2000Selectselect lov_description from list_of_values a where lower(a.lov_category) = 'kyc status' and a.cancel = 'F' and ( a.active = 'T' or :recordid > 0 ) order by 100FalseTrueFalseTrueFalseFalseTrueTrueTrueFalseFalseTrueTrueTruejoint_kyc_statusjointholder_rownumberJoint Holder PAN #Character500calculate00TrueTrueFalseFalseFalseactiverowTrueFalseFalseFalseFalseTrueTruejointholder_rownumberaxpfile_jointuploadUpload Documents [if any]Character20000Accept00TrueFalseFalseFalseTrueFalseFalseTrueTrueFalseFalseFalseFalseTrueTrueaxpfile_jointuploadaxpfilepath_jointuploadaxpfilepath_jointuploadCharacter500calculate00TrueFalseTrueFalseFalseAxpAttachmentPathTrueFalseFalseFalseFalseTrueTrueaxpfilepath_jointuploaddc6Address Details6client_addressdetailsFalseTrueTrueTrueFalseFalsepermanent_house_numberAddress Line 1Character3000Accept00TrueFalseFalseFalseFalseFalseFalseTrueTrueFalseFalseFalseFalseTruespermanent_temp_address,eclient_permanentaddress,ecommunication_house_number,scommunication_temp_address,eclient_communicationaddressTruepermanent_house_number~permanent_temp_address,permanent_locality_sublocality,permanent_city,permanent_pin_zip,permanent_state,permanent_country,client_permanentaddress,communication_house_number,same_aspermanent_address,communication_temp_address,comm_locality_sublocality,communication_city,communication_pin_zip,communication_state,communication_country,client_communicationaddresspermanent_locality_sublocalityAddress Line 2Character3000Accept00TrueFalseFalseFalseTrueFalseFalseTrueTrueFalseFalseFalseFalseTruespermanent_temp_address,eclient_permanentaddress,ecomm_locality_sublocality,scommunication_temp_address,eclient_communicationaddressTruetrue~permanent_house_numberpermanent_locality_sublocality~permanent_temp_address,permanent_house_number,permanent_city,permanent_pin_zip,permanent_state,permanent_country,client_permanentaddress,comm_locality_sublocality,same_aspermanent_address,communication_temp_address,communication_house_number,communication_city,communication_pin_zip,communication_state,communication_country,client_communicationaddresspermanent_cityCityCharacter500SelectSELECT a.global_mst_cityid, a.n_city_description, b.n_state_description, c.n_country_name, a.pincode FROM global_mst_city a, global_mst_state b, global_mst_country c where a.state_description = b.global_mst_stateid and b.country = c.global_mst_countryid and a.cancel = 'F' and ( a.active = 'T' or :recordid > 0 ) {dynamicfilter a.n_city_description, b.n_state_description, c.n_country_name~City,State,Country} order by 200FalseTruen_city_descriptionglobal_mst_cityFalseFalseFalseFalseTrueTrueTrueTrueFalseTrueTruefpermanent_state,fpermanent_country,fperpincode_start_digit,spermanent_temp_address,eclient_permanentaddress,ecommunication_city,fcommunication_state,fcomm_pincode_startdigit,fcommunication_country,scommunication_temp_address,eclient_communicationaddressTruepermanent_city~permanent_state,permanent_country,perpincode_start_digit,permanent_temp_address,permanent_house_number,permanent_locality_sublocality,permanent_pin_zip,client_permanentaddress,communication_city,same_aspermanent_address,communication_state,comm_pincode_startdigit,communication_country,communication_temp_address,communication_house_number,comm_locality_sublocality,communication_pin_zip,client_communicationaddresspermanent_pin_zipPIN/ZIP CodeCharacter500Accept00TrueFalseFalseFalseTrueFalseFalseTrueTrueFalseFalseFalseFalseTrueeper_substring_pincode,spermanent_temp_address,eclient_permanentaddress,ecommunication_pin_zip,ecomm_substring_pincode,scommunication_temp_address,eclient_communicationaddressTruepermanent_pin_zip~per_substring_pincode,permanent_temp_address,permanent_house_number,permanent_locality_sublocality,permanent_city,permanent_state,permanent_country,client_permanentaddress,communication_pin_zip,same_aspermanent_address,comm_substring_pincode,communication_temp_address,communication_house_number,comm_locality_sublocality,communication_city,communication_state,communication_country,client_communicationaddresspermanent_stateState/ProvinceCharacter2000Fill00permanent_cityn_state_descriptionFalseFalseTrueTrueFalseFalseTrueFalseFalseFalseFalseTruespermanent_temp_address,eclient_permanentaddressTruepermanent_state,permanent_city~permanent_temp_address,permanent_house_number,permanent_locality_sublocality,permanent_pin_zip,permanent_country,client_permanentaddresspermanent_countryCountryCharacter1000Fill00permanent_cityn_country_nameFalseFalseTrueTrueFalseFalseTrueFalseFalseFalseFalseTruespermanent_temp_address,eclient_permanentaddressTruepermanent_country,permanent_city~permanent_temp_address,permanent_house_number,permanent_locality_sublocality,permanent_pin_zip,permanent_state,client_permanentaddressperpincode_start_digitStart DigitCharacter30Fill00permanent_citypincodeFalseTrueTrueFalseFalseFalseTrueFalseFalseFalseFalseTrueTrueperpincode_start_digit,permanent_cityper_substring_pincodePermanent CityCharacter30calculate00TrueTrueFalseFalseFalseSubStr(permanent_pin_zip,1,2)IIF(ISEmpty(permanent_pin_zip) = {T} | ISEmpty(perpincode_start_digit) = {T},{T},IIF(per_substring_pincode = perpincode_start_digit,{T},{ Invalid Pincode})) TrueFalseFalseFalseFalseTrueTrueper_substring_pincode,permanent_pin_zippermanent_temp_addresspermanent_temp_addressText40000Acceptselect :permanent_house_number ||chr(10)|| :permanent_locality_sublocality ||chr(10)|| :permanent_city ||'-'|| :permanent_pin_zip || chr(10)|| :permanent_state ||chr(10)|| :permanent_country 00TrueFalseFalseTrueTrueFalseFalseFalseTrueFalseFalseFalseFalseTrueeclient_permanentaddressTruepermanent_temp_address,permanent_house_number,permanent_locality_sublocality,permanent_city,permanent_pin_zip,permanent_state,permanent_country~client_permanentaddressclient_permanentaddressClient Permanent AddressText40000calculate00TrueTrueFalseFalseTruepermanent_temp_addressTrueFalseFalseFalseFalseTrueTrueclient_permanentaddress,permanent_temp_address,permanent_house_number,permanent_locality_sublocality,permanent_city,permanent_pin_zip,permanent_state,permanent_countrysame_aspermanent_addressSame as Permanent AddressCharacter10Accept00TrueFalseFalseFalseTrueFalseFalseTrue{T}TrueFalseFalseFalseFalseTrueecommunication_house_number,ecomm_locality_sublocality,ecommunication_city,ecommunication_pin_zip,fcommunication_state,fcomm_pincode_startdigit,ecomm_substring_pincode,fcommunication_country,scommunication_temp_address,eclient_communicationaddressTruesame_aspermanent_address~communication_house_number,permanent_house_number,comm_locality_sublocality,permanent_locality_sublocality,communication_city,permanent_city,communication_pin_zip,permanent_pin_zip,communication_state,comm_pincode_startdigit,comm_substring_pincode,communication_country,communication_temp_address,client_communicationaddresscommunication_house_numberAddress Line 1Character3000Accept00TrueFalseFalseFalseTrueFalseFalseTrueiif(same_aspermanent_address={T},permanent_house_number,{})TrueFalseFalseFalseFalseTruescommunication_temp_address,eclient_communicationaddressTruecommunication_house_number,same_aspermanent_address,permanent_house_number~communication_temp_address,comm_locality_sublocality,permanent_locality_sublocality,communication_city,permanent_city,communication_pin_zip,permanent_pin_zip,communication_state,communication_country,client_communicationaddresscomm_locality_sublocalityAddress Line 2Character3000Accept00TrueFalseFalseFalseTrueFalseFalseTrueiif(same_aspermanent_address={T},permanent_locality_sublocality,{})TrueFalseFalseFalseFalseTruescommunication_temp_address,eclient_communicationaddressTruecomm_locality_sublocality,same_aspermanent_address,permanent_locality_sublocality~communication_temp_address,communication_house_number,permanent_house_number,communication_city,permanent_city,communication_pin_zip,permanent_pin_zip,communication_state,communication_country,client_communicationaddresscommunication_cityCityCharacter1000SelectSELECT a.n_city_description, b.n_state_description, c.n_country_name, a.pincode FROM global_mst_city a, global_mst_state b, global_mst_country c where a.state_description = b.global_mst_stateid and b.country = c.global_mst_countryid and a.cancel = 'F' and ( a.active = 'T' or :recordid > 0 ) {dynamicfilter a.n_city_description, b.n_state_description, c.n_country_name~City,State,Country} order by 200FalseTrueFalseTrueFalseFalseTrueiif(same_aspermanent_address={T},permanent_city,{})TrueTrueFalseFalseTrueTruefcommunication_state,fcomm_pincode_startdigit,fcommunication_country,scommunication_temp_address,eclient_communicationaddressTruecommunication_city,same_aspermanent_address,permanent_city~communication_state,comm_pincode_startdigit,communication_country,communication_temp_address,communication_house_number,permanent_house_number,comm_locality_sublocality,permanent_locality_sublocality,communication_pin_zip,permanent_pin_zip,client_communicationaddresscommunication_pin_zipPIN/ZIP CodeCharacter500Accept00TrueFalseFalseFalseTrueFalseFalseTrueiif(same_aspermanent_address={T},permanent_pin_zip,{})TrueFalseFalseFalseFalseTrueecomm_substring_pincode,scommunication_temp_address,eclient_communicationaddressTruecommunication_pin_zip,same_aspermanent_address,permanent_pin_zip~comm_substring_pincode,communication_temp_address,communication_house_number,permanent_house_number,comm_locality_sublocality,permanent_locality_sublocality,communication_city,permanent_city,communication_state,communication_country,client_communicationaddresscommunication_stateState/ProvinceCharacter1000Fill00communication_cityn_state_descriptionFalseFalseTrueTrueFalseFalseTrueFalseFalseFalseFalseTruescommunication_temp_address,eclient_communicationaddressTruecommunication_state,communication_city,same_aspermanent_address,permanent_city~communication_temp_address,communication_house_number,permanent_house_number,comm_locality_sublocality,permanent_locality_sublocality,communication_pin_zip,permanent_pin_zip,communication_country,client_communicationaddresscomm_pincode_startdigitpincode_start_digitCharacter30Fill00communication_citypincodeFalseTrueTrueFalseFalseFalseTrueFalseFalseFalseFalseTrueTruecomm_pincode_startdigit,communication_city,same_aspermanent_address,permanent_citycomm_substring_pincodeCommunication CityCharacter30calculate00TrueTrueFalseFalseFalseSubStr(communication_pin_zip,1,2)IIF(ISEmpty(communication_pin_zip) = {T} | ISEmpty(comm_pincode_startdigit) = {T},{T},IIF(comm_substring_pincode = comm_pincode_startdigit,{T},{ Invalid Pincode}))TrueFalseFalseFalseFalseTrueTruecomm_substring_pincode,communication_pin_zip,same_aspermanent_address,permanent_pin_zipcommunication_countryCountryCharacter1000Fill00communication_cityn_country_nameFalseFalseTrueTrueFalseFalseTrueFalseFalseFalseFalseTruescommunication_temp_address,eclient_communicationaddressTruecommunication_country,communication_city,same_aspermanent_address,permanent_city~communication_temp_address,communication_house_number,permanent_house_number,comm_locality_sublocality,permanent_locality_sublocality,communication_pin_zip,permanent_pin_zip,communication_state,client_communicationaddresscommunication_temp_addresscommunication_temp_addressText40000Acceptselect :communication_house_number ||chr(10)|| :comm_locality_sublocality ||chr(10)|| :communication_city ||'-'|| :communication_pin_zip || chr(10)|| :communication_state ||chr(10)|| :communication_country00TrueFalseFalseTrueTrueFalseFalseFalseTrueFalseFalseFalseFalseTrueeclient_communicationaddressTruecommunication_temp_address,communication_house_number,same_aspermanent_address,permanent_house_number,comm_locality_sublocality,permanent_locality_sublocality,communication_city,permanent_city,communication_pin_zip,permanent_pin_zip,communication_state,communication_country~client_communicationaddressclient_communicationaddressClient Communication AddresssText40000calculate00TrueTrueFalseFalseTruecommunication_temp_addressTrueFalseFalseFalseFalseTrueTrueclient_communicationaddress,communication_temp_address,communication_house_number,same_aspermanent_address,permanent_house_number,comm_locality_sublocality,permanent_locality_sublocality,communication_city,permanent_city,communication_pin_zip,permanent_pin_zip,communication_state,communication_countryaxpfile_addressuploadUpload Documents [if any]Character20000Accept00TrueFalseFalseFalseTrueFalseFalseTrueTrueFalseFalseFalseFalseTrueTrueaxpfile_addressuploadaxpfilepath_addressuploadaxpfilepath_addressuploadCharacter500calculate00TrueFalseTrueFalseFalseAxpAttachmentPathTrueFalseFalseFalseFalseTrueTrueaxpfilepath_addressuploaddc7Nominee Details7client_nomineedetailsTrueTrueTrueTrueTrueFalsenominee_orderOrderCharacter200Selectselect lov_description from list_of_values a where lower(a.lov_category) = 'details' and a.cancel = 'F' and ( a.active = 'T' or :recordid > 0 ) order by 100FalseTrueTrueTrueFalseFalseFalseTrueTrueFalseFalseTrueTrueTruenominee_ordernominee_titleTitleCharacter500Accept00TrueFalseFalseFalseTrueFalseFalseTrueTrueFalseFalseFalseFalseTrueTruenominee_titlenominee_nameNominee NameCharacter2000Accept00TrueFalseFalseFalseTrueFalseFalseTrueTrueFalseFalseFalseFalseTrueenominee_dcrowcountTruenominee_name~nominee_dcrowcountnominee_shareNominee Share [Percent]Numeric102Accept00TrueFalseFalseFalseTrueFalseFalseTrueTrueFalseFalseFalseFalseTrueenominee_share_totalTruenominee_share~nominee_share_totalrelationship_to_holderRelationshipCharacter500Selectselect lov_description from list_of_values a where lower(a.lov_category) = 'relationship' and a.cancel = 'F' and ( a.active = 'T' or :recordid > 0 ) order by 100FalseTrueFalseTrueFalseFalseTrueTrueTrueFalseFalseTrueTrueTruerelationship_to_holdernominee_date_of_birthDate of BirthDate/Time100Accept00TrueFalseFalseFalseTrueFalseFalseTrueIIF(nominee_date_of_birth > Date(),{Future date not allowed},{T})TrueFalseFalseFalseFalseTrueTruenominee_date_of_birthnominee_isminorMinorCharacter50Select00FalseFalseYesNoFalseTrueFalseFalseTrue{No}TrueTrueFalseFalseTrueTrueTruenominee_isminorguardianname_isminorGuardian Name [if Minor]Character1000Accept00TrueFalseFalseFalseTrueFalseFalseTrueIIF(nominee_isminor = {No}, {T}, iif(ISEmpty(guardianname_isminor) = {T},{ Cannot be left empty if nominee is minor},{T}))TrueFalseFalseFalseFalseTrueTrueguardianname_isminorguardian_relationshipGuardian RelationshipCharacter500Selectselect lov_description from list_of_values a where lower(a.lov_category) = 'relationship' and a.cancel = 'F' and ( a.active = 'T' or :recordid > 0 ) order by 100FalseTrueFalseTrueFalseFalseTrueIIF(nominee_isminor = {No}, {T}, iif(ISEmpty(guardian_relationship) = {T},{ Cannot be left empty if nominee is minor},{T})) TrueTrueFalseFalseTrueTrueTrueguardian_relationshipguardian_mobilenoGuardian Mobile No.Numeric100Accept00TrueFalseFalseFalseTrueFalseFalseTrueIIF(nominee_isminor = {No}, {T}, iif(ISEmpty(guardian_mobileno) = {T},{ Cannot be left empty if nominee is minor},{T})) TrueFalseFalseFalseFalseTrueTrueguardian_mobilenoguardian_pan_numberGuardian PAN#Character100Accept00TrueFalseFalseFalseTrueFalseFalseTrueIIF(nominee_isminor = {No}, {T}, iif(ISEmpty(guardian_pan_number) = {T},{ Cannot be left empty if nominee is minor},{T})) TrueFalseFalseFalseFalseTrueTrueguardian_pan_numberguardian_ckyc_numberGuardian CKYC#Character150Accept00TrueFalseFalseFalseTrueFalseFalseTrueIIF(nominee_isminor = {No}, {T}, iif(ISEmpty(guardian_ckyc_number) = {T},{ Cannot be left empty if nominee is minor},{T})) TrueFalseFalseFalseFalseTrueTrueguardian_ckyc_numberguardian_kyc_statusGuardian KYC StatusCharacter2000Selectselect lov_description from list_of_values a where lower(a.lov_category) = 'kyc status' and a.cancel = 'F' and ( a.active = 'T' or :recordid > 0 ) order by 100FalseTrueFalseTrueFalseFalseTrueIIF(nominee_isminor = {No}, {T}, iif(ISEmpty(guardian_kyc_status) = {T},{ Cannot be left empty if nominee is minor},{T})) TrueTrueFalseFalseTrueTrueTrueguardian_kyc_statusaxpfile_nomineeuploadUpload Documents [if any]Character20000Accept00TrueFalseFalseFalseTrueFalseFalseTrueTrueFalseFalseFalseFalseTrueTrueaxpfile_nomineeuploadaxpfilepath_nomineeuploadaxpfilepath_nomineeuploadCharacter500calculate00TrueFalseTrueFalseFalseAxpAttachmentPathTrueFalseFalseFalseFalseTrueTrueaxpfilepath_nomineeuploaddc8UBO Details8client_ubodetailsTrueTrueTrueTrueTrueFalseubo_orderOrderCharacter200Selectselect lov_description from list_of_values a where lower(a.lov_category) = 'details' and a.cancel = 'F' and ( a.active = 'T' or :recordid > 0 ) order by 100FalseTrueTrueTrueFalseFalseFalseTrueTrueFalseFalseTrueTrueTrueubo_orderubo_titleTitleCharacter500Accept00TrueFalseFalseFalseTrueFalseFalseTrueTrueFalseFalseFalseFalseTrueTrueubo_titleubo_nameNameCharacter3000Accept00TrueFalseFalseFalseTrueFalseFalseTrueTrueFalseFalseFalseFalseTrueeubo_rowcountTrueubo_name~ubo_rowcountubo_dateofbirthDate of BirthDate/Time100Accept00TrueFalseFalseFalseTrueFalseFalseTrueIIF(ubo_dateofbirth > Date(),{ Future date not allowed},{T})TrueFalseFalseFalseFalseTrueTrueubo_dateofbirthubo_percentageUBO Share [Percent]Numeric102Accept00TrueFalseFalseFalseTrueFalseFalseTrueTrueFalseFalseFalseFalseTrueeubo_share_totalTrueubo_percentage~ubo_share_totalubo_tinTIN#Character150Accept00TrueFalseFalseFalseTrueFalseFalseTrueFalseFalseFalseFalseFalseTrueTrueubo_tinubo_pan_numberPAN#Character500Accept00TrueFalseFalseFalseTrueFalseFalseTrueTrueFalseFalseFalseFalseTrueTrueubo_pan_numberubo_ckyc_numberCKYC#Character150Accept00TrueFalseFalseFalseTrueFalseFalseTrueTrueFalseFalseFalseFalseTrueTrueubo_ckyc_numberubo_kyc_statusKYC StatusCharacter2000Selectselect lov_description from list_of_values a where lower(a.lov_category) = 'kyc status' and a.cancel = 'F' and ( a.active = 'T' or :recordid > 0 ) order by 100FalseTrueFalseTrueFalseFalseTrueTrueTrueFalseFalseTrueTrueTrueubo_kyc_statusaxpfile_ubouploadUpload Documents [if any]Character20000Accept00TrueFalseFalseFalseTrueFalseFalseTrueTrueFalseFalseFalseFalseTrueTrueaxpfile_ubouploadaxpfilepath_ubouploadaxpfilepath_ubouploadCharacter500calculate00TrueFalseTrueFalseFalseAxpAttachmentPathTrueFalseFalseFalseFalseTrueTrueaxpfilepath_ubouploaddc9Summary9client_detailsFalseTrueTrueTrueFalseFalsejointholder_rowcountJoint Holder Numeric50calculate00FalseTrueTrueFalseTrueGetRowCount({joint_name})IIF( lower(holding_status) = {joint} & jointholder_rowcount = 0, { Details cannot be left blank}, {T}) TrueFalseFalseFalseFalseTrueIIF( lower(holding_status = {joint} & jointholder_rowcount = 0, { Joint holding status cannot be left blank}, {T})Truejointholder_rowcount,joint_namenominee_share_totalTotal Nominees SharesNumeric102calculate00TrueTrueTrueFalseTrueTotal({nominee_share})TrueFalseFalseFalseFalseTrueTruenominee_share_total,nominee_sharenominee_dcrowcountNominee Share [Percent]Numeric100calculate00FalseTrueTrueFalseTrueGetRowCount({nominee_name})IIF(nominee = {T},IIF(nominee_dcrowcount > 0,IIF(nominee_share_total = 100,{T},{Total share of Nominee(s) must be 100%}),{One or more Nominees are mandatory}),{T})TrueFalseFalseFalseFalseTrueTruenominee_dcrowcount,nominee_nameclientlogin_createflagclientlogin_createflagCharacter10calculate00TrueTrueFalseFalseTrueiif( client_logincount = 0, {T}, {F}) TrueFalseFalseFalseFalseTrueTrueclientlogin_createflag,client_logincount,primary_emailidubo_share_totalTotal UBO SharesNumeric102calculate00TrueTrueTrueFalseTrueTotal({ubo_percentage})TrueFalseFalseFalseFalseTrueTrueubo_share_total,ubo_percentageubo_rowcountUBO DetailsNumeric200calculate00TrueTrueTrueFalseTrueGetRowCount({ubo_name})TrueFalseFalseFalseFalseTrueTrueubo_rowcount,ubo_nametrcln1To Portal Loginausrsdc1clientlogin_createflagFalseactiveprimary_emailidprimary_emailidclient_nameclientclient_start_dateADMINclient_codeprimary_mobilenoFalseFalseAxHideControls({dc5})AxHideControls({dc2})AxHideControls({dc7})AxHideControls({dc8})AxHideControls({dc9})if nominee = {T}AxUnhideControls({dc7})else AxHideControls({dc7})end AxHideControls({dc9})if holding_status = {Joint}AxUnhideControls({dc5})elseAxHideControls({dc5})endif nominee_isminor = {Yes}AxUnhideControls({guardianname_isminor}) AxUnhideControls({guardian_relationship})AxUnhideControls({guardian_mobileno})AxUnhideControls({guardian_pan_number})AxUnhideControls({guardian_ckyc_number})AxUnhideControls({guardian_kyc_status})else AxHideControls({guardianname_isminor})AxHideControls({guardian_relationship})AxHideControls({guardian_mobileno})AxHideControls({guardian_pan_number})AxHideControls({guardian_ckyc_number})AxHideControls({guardian_kyc_status})endif nominee_isminor = {No}AxHideControls({guardianname_isminor})AxHideControls({guardian_relationship})AxHideControls({guardian_mobileno})AxHideControls({guardian_pan_number})AxHideControls({guardian_ckyc_number})AxHideControls({guardian_kyc_status})elseAxUnhideControls({guardianname_isminor}) AxUnhideControls({guardian_relationship})AxUnhideControls({guardian_mobileno})AxUnhideControls({guardian_pan_number})AxUnhideControls({guardian_ckyc_number})AxUnhideControls({guardian_kyc_status})endif resident_status = {Resident Indian}AxHideControls({dc2})else AxUnhideControls({dc2})end if ubo = {T}AxUnhideControls({dc8})else AxHideControls({dc8})end if pan_number = joint_pan_number ShowMessage({Duplicate PAN Number not allowed},{Exception},{}) endfirst_pagematerial-iconsskip_previousmaterial-iconsskip_nextmaterial-iconslast_pagematerial-iconsaddmaterial-iconssavematerial-iconssearchmaterial-iconsremovematerial-iconsremove_red_eyematerial-iconspicture_as_pdfmaterial-iconslistmaterial-iconslistmaterial-iconslistmaterial-iconsdc1dc2dc3dc4dc5dc6dc7dc8dc9 Creating DbCall Evaluating {India} Result = Evaluating GetRowCount({joint_name}) Result = Evaluating IIF( lower(holding_status) = {joint} & jointholder_rowcount = 0, { Details cannot be left blank}, {T}) Result = Evaluating client_code Result = Evaluating recordid Result = Evaluating IIF(client_name_check =1,{T},{ cannot be only numeric}) Result = Evaluating IIF(recordid = 0, client_name) Result = Evaluating {F} Result = Evaluating {India} Result = Evaluating temp_nationality Result = Evaluating {Single} Result = Evaluating {F} Result = Evaluating {F} Result = Evaluating date() Result = Evaluating {F} Result = Evaluating {T} Result = Evaluating AxpAttachmentPath Result = Evaluating getallvalues({account_client_id},{,}) Result = Evaluating IIF(primary_emailid = duplicate_primarymail_id, {F},{T}) Result = Evaluating AxpAttachmentPath Result = Evaluating {Yes} Result = Evaluating AxpAttachmentPath Result = Evaluating fund_code + scheme_code + account_client_id Result = Evaluating {F} Result = Evaluating IIF(bank_accountnumber_check =1,{T},{ cannot contain alphabets}) Result = Evaluating bank_ifsc_code + bank_account_number Result = Evaluating AxpAttachmentPath Result = Evaluating activerow Result = Evaluating AxpAttachmentPath Result = Evaluating SubStr(permanent_pin_zip,1,2) Result = Evaluating IIF(ISEmpty(permanent_pin_zip) = {T} | ISEmpty(perpincode_start_digit) = {T},{T},IIF(per_substring_pincode = perpincode_start_digit,{T},{ Invalid Pincode})) Result = Evaluating permanent_temp_address Result = Evaluating {T} Result = Evaluating iif(same_aspermanent_address={T},permanent_house_number,{}) Result = Evaluating iif(same_aspermanent_address={T},permanent_locality_sublocality,{}) Result = Evaluating iif(same_aspermanent_address={T},permanent_city,{}) Result = Evaluating iif(same_aspermanent_address={T},permanent_pin_zip,{}) Result = Evaluating SubStr(communication_pin_zip,1,2) Result = Evaluating IIF(ISEmpty(communication_pin_zip) = {T} | ISEmpty(comm_pincode_startdigit) = {T},{T},IIF(comm_substring_pincode = comm_pincode_startdigit,{T},{ Invalid Pincode})) Result = Evaluating communication_temp_address Result = Evaluating AxpAttachmentPath Result = Evaluating {No} Result = Evaluating AxpAttachmentPath Result = Evaluating AxpAttachmentPath Result = Evaluating Total({nominee_share}) Result = Evaluating GetRowCount({nominee_name}) Result = Evaluating IIF(nominee = {T},IIF(nominee_dcrowcount > 0,IIF(nominee_share_total = 100,{T},{Total share of Nominee(s) must be 100%}),{One or more Nominees are mandatory}),{T}) Result = Evaluating iif( client_logincount = 0, {T}, {F}) Result = Evaluating Total({ubo_percentage}) Result = Evaluating GetRowCount({ubo_name}) Result = Evaluating iif(accountno_length <> 0, (IIF(GetLength(trim(bank_account_number)) = accountno_length, {T}, {Account Length has to be } + str(accountno_length))),{T}) Result = select * from AxAttachWorkflow where lower(transid) = 'trcln' Time elapsed = 7 Submiting & Registering data Registering Global variables data Registering Global variables data over Setting values over Creating Action object Time taken to connect and submit - 428 Action node in structure : AxHideControls({dc5})AxHideControls({dc2})AxHideControls({dc7})AxHideControls({dc8})AxHideControls({dc9}) Starting Action Execution - script1 Executing task - scripts Assigning expression set to parser Expression : AxHideControls({dc5}) AxHideControls({dc2}) AxHideControls({dc7}) AxHideControls({dc8}) AxHideControls({dc9}) Evaluating AxHideControls({dc5}) Result = Evaluating AxHideControls({dc2}) Result = Evaluating AxHideControls({dc7}) Result = Evaluating AxHideControls({dc8}) Result = Evaluating AxHideControls({dc9}) Result = Executing task scripts over Action Execution over - script1 Action node in structure : if nominee_isminor = {No}AxHideControls({guardianname_isminor})AxHideControls({guardian_relationship})AxHideControls({guardian_mobileno})AxHideControls({guardian_pan_number})AxHideControls({guardian_ckyc_number})AxHideControls({guardian_kyc_status})elseAxUnhideControls({guardianname_isminor}) AxUnhideControls({guardian_relationship})AxUnhideControls({guardian_mobileno})AxUnhideControls({guardian_pan_number})AxUnhideControls({guardian_ckyc_number})AxUnhideControls({guardian_kyc_status})end Starting Action Execution - script4 Executing task - scripts Assigning expression set to parser Expression : if nominee_isminor = {No} AxHideControls({guardianname_isminor}) AxHideControls({guardian_relationship}) AxHideControls({guardian_mobileno}) AxHideControls({guardian_pan_number}) AxHideControls({guardian_ckyc_number}) AxHideControls({guardian_kyc_status}) else AxUnhideControls({guardianname_isminor}) AxUnhideControls({guardian_relationship}) AxUnhideControls({guardian_mobileno}) AxUnhideControls({guardian_pan_number}) AxUnhideControls({guardian_ckyc_number}) AxUnhideControls({guardian_kyc_status}) end Evaluating nominee_isminor = {No} nominee_isminor = Result = 0 Evaluating AxUnhideControls({guardianname_isminor}) Result = Evaluating AxUnhideControls({guardian_relationship}) Result = Evaluating AxUnhideControls({guardian_mobileno}) Result = Evaluating AxUnhideControls({guardian_pan_number}) Result = Evaluating AxUnhideControls({guardian_ckyc_number}) Result = Evaluating AxUnhideControls({guardian_kyc_status}) Result = Executing task scripts over Action Execution over - script4 Quick Form Load JSON Executing fill Grid 1 Preparing client_code-accept Field Value - Preparing docid-calculate client_code = Field Value - Preparing recid-accept recordid = 0 Field Value - 0 Preparing logincount-accept client_code= select count(1) as cnt from axusers a, client_details b where b.primary_emailid = a.pusername and b.client_code = :client_code client_code= Time elapsed = 9 Query opened , Record count : 1 Field Value - 0 Preparing client_name-accept Field Value - Preparing client_name_check-accept client_name= SELECT 1 FROM dual WHERE ( :client_name !~ '^[0-9]+$' AND :client_name ~ '[A-Za-z]+') client_name= client_name= Time elapsed = 4 Query opened , Record count : 0 Field Value - Preparing client_display_name-accept recordid = 0 client_name = Result of iif = Field Value - Preparing politically_exp_person-accept Field Value - F DC to JSON DC1 Field to JSON politically_exp_person row 1 Preparing country_of_birth-select Select a1.global_mst_countryid,a1.n_country_name,a1.nationality from global_mst_country a1 where a1.active = 'T' and a1.cancel = 'F' order by a1.n_country_name Time elapsed = 5 Query opened , Record count : 90 Field Value - India Field to JSON country_of_birth row 1 Preparing temp_nationality-fill Field Value - Indian Field to JSON temp_nationality row 1 Preparing nationality-select temp_nationality = Indian recordid=0 select a.nationality from global_mst_country a where a.cancel = 'F' and ( a.active = 'T' or :recordid > 0 ) order by 1 recordid=0 Time elapsed = 0 Query opened , Record count : 90 Field Value - Indian Field to JSON nationality row 1 Preparing resident_status-select recordid=0 nationality=Indian select lov_description from list_of_values a where lower(a.lov_category) = 'resident status' and a.cancel = 'F' and ( a.active = 'T' or :recordid > 0 ) and ( (lower( :nationality) = 'indian' and lower(a.lov_description) !='foreign national') or (lower( :nationality) != 'indian' and lower(a.lov_description) ='foreign national') ) order by 1 recordid=0 nationality=Indian nationality=Indian Time elapsed = 0 Query opened , Record count : 4 Field Value - Preparing holding_status-select recordid=0 select lov_description from list_of_values a where lower(a.lov_category) = 'holding status' and a.cancel = 'F' and ( a.active = 'T' or :recordid > 0 ) order by 1 recordid=0 Time elapsed = 3 Query opened , Record count : 5 Field Value - Single Field to JSON holding_status row 1 Preparing ubo-accept Field Value - F Field to JSON ubo row 1 Preparing nominee-accept Field Value - F Field to JSON nominee row 1 Preparing primary_emailid-accept Field Value - Preparing duplicate_primarymail_id-accept primary_emailid= select a.username from axusers a where a.username = :primary_emailid primary_emailid= Time elapsed = 3 Query opened , Record count : 0 Field Value - Preparing client_start_date-accept Result of date = 20/05/2025 Field Value - 20/05/2025 Field to JSON client_start_date row 1 Preparing distributor_name-select Field Value - Preparing rm_name-select Field Value - Preparing aml_check-accept Field Value - F Field to JSON aml_check row 1 Preparing active-accept Field Value - T Field to JSON active row 1 Preparing axpfilepath_clientupload-calculate axpattachmentpath = \\10.16.248.2\UAT_Attachment\UAT_TLReports Field Value - \\10.16.248.2\UAT_Attachment\UAT_TLReports Field to JSON axpfilepath_clientupload row 1 Preparing clientids-calculate Result of getallvalues = Field Value - Preparing client_logincount-accept primary_emailid= select count(1) as cnt from axusers a where a.username = :primary_emailid primary_emailid= Time elapsed = 3 Query opened , Record count : 1 Field Value - 0 Preparing control_fieldcheck-calculate primary_emailid = duplicate_primarymail_id = Result of iif = F Field Value - F Field to JSON control_fieldcheck row 1 Executing fill Grid 2 Executing fill Grid 3 Executing fill Grid 4 Executing fill Grid 5 Executing fill Grid 6 Preparing permanent_house_number-accept Field Value - Preparing permanent_locality_sublocality-accept Field Value - Preparing permanent_city-select Field Value - Preparing permanent_pin_zip-accept Field Value - Preparing permanent_state-fill Field Value - Preparing permanent_country-fill Field Value - Preparing per_substring_pincode-calculate permanent_pin_zip = Result of substr = Field Value - Preparing permanent_temp_address-accept permanent_house_number= permanent_locality_sublocality= permanent_city= permanent_pin_zip= permanent_state= permanent_country= select :permanent_house_number ||chr(10)|| :permanent_locality_sublocality ||chr(10)|| :permanent_city ||'-'|| :permanent_pin_zip || chr(10)|| :permanent_state ||chr(10)|| :permanent_country permanent_house_number= permanent_locality_sublocality= permanent_city= permanent_pin_zip= permanent_state= permanent_country= Time elapsed = 5 Query opened , Record count : 1 Field Value - - DC to JSON DC6 Field to JSON permanent_temp_address row 1 Preparing client_permanentaddress-calculate permanent_temp_address = - Field Value - - Field to JSON client_permanentaddress row 1 Preparing same_aspermanent_address-accept Field Value - T Field to JSON same_aspermanent_address row 1 Preparing communication_house_number-accept same_aspermanent_address = T permanent_house_number = Result of iif = Field Value - Preparing comm_locality_sublocality-accept same_aspermanent_address = T permanent_locality_sublocality = Result of iif = Field Value - Preparing communication_city-select same_aspermanent_address = T permanent_city = Result of iif = Field Value - Preparing communication_pin_zip-accept same_aspermanent_address = T permanent_pin_zip = Result of iif = Field Value - Preparing communication_state-fill Field Value - Preparing comm_substring_pincode-calculate communication_pin_zip = Result of substr = Field Value - Preparing communication_country-fill Field Value - Preparing communication_temp_address-accept communication_house_number= comm_locality_sublocality= communication_city= communication_pin_zip= communication_state= communication_country= select :communication_house_number ||chr(10)|| :comm_locality_sublocality ||chr(10)|| :communication_city ||'-'|| :communication_pin_zip || chr(10)|| :communication_state ||chr(10)|| :communication_country communication_house_number= comm_locality_sublocality= communication_city= communication_pin_zip= communication_state= communication_country= Time elapsed = 6 Query opened , Record count : 1 Field Value - - Field to JSON communication_temp_address row 1 Preparing client_communicationaddress-calculate communication_temp_address = - Field Value - - Field to JSON client_communicationaddress row 1 Preparing axpfilepath_addressupload-calculate axpattachmentpath = \\10.16.248.2\UAT_Attachment\UAT_TLReports Field Value - \\10.16.248.2\UAT_Attachment\UAT_TLReports Field to JSON axpfilepath_addressupload row 1 Executing fill Grid 7 Executing fill Grid 8 Executing fill Grid 9 Preparing jointholder_rowcount-calculate Result of getrowcount = 0 Field Value - 0 Preparing nominee_share_total-calculate Result of total = 0 Field Value - 0.00 Preparing nominee_dcrowcount-calculate Result of getrowcount = 0 Field Value - 0 Preparing clientlogin_createflag-calculate client_logincount = 0 Result of iif = T Field Value - T DC to JSON DC9 Field to JSON clientlogin_createflag row 1 Preparing ubo_share_total-calculate Result of total = 0 Field Value - 0.00 Preparing ubo_rowcount-calculate Result of getrowcount = 0 Field Value - 0 DC to JSON DC to JSON DC to JSON DC to JSON DC to JSON DC to JSON Quick Form load JSON completed 203 Result : {"data":[{"n":"DC1","v":"1","t":"dc"},{"n":"axp_recid1","v":"0","r":"0","t":"s"},{"n":"politically_exp_person","v":"F","r":"0","t":"s"},{"n":"country_of_birth","v":"India","r":"0","idcol":"yes","id":"1527770000003","oldid":"0","t":"c"},{"n":"temp_nationality","v":"Indian","r":"0","t":"s"},{"n":"nationality","v":"Indian","r":"0","idcol":"no","id":"0","oldid":"0","t":"c"},{"n":"holding_status","v":"Single","r":"0","idcol":"no","id":"0","oldid":"0","t":"c"},{"n":"ubo","v":"F","r":"0","t":"s"},{"n":"nominee","v":"F","r":"0","t":"s"},{"n":"client_start_date","v":"20/05/2025","r":"0","t":"s"},{"n":"aml_check","v":"F","r":"0","t":"s"},{"n":"active","v":"T","r":"0","t":"s"},{"n":"axpfilepath_clientupload","v":"\\10.16.248.2\UAT_Attachment\UAT_TLReports","r":"0","t":"s"},{"n":"control_fieldcheck","v":"F","r":"0","t":"s"},{"n":"DC6","v":"1","t":"dc"},{"n":"axp_recid6","v":"0","r":"0","t":"s"},{"n":"permanent_temp_address","v":"

-

","r":"0","t":"m"},{"n":"client_permanentaddress","v":"

-

","r":"0","t":"m"},{"n":"same_aspermanent_address","v":"T","r":"0","t":"s"},{"n":"communication_temp_address","v":"

-

","r":"0","t":"m"},{"n":"client_communicationaddress","v":"

-

","r":"0","t":"m"},{"n":"axpfilepath_addressupload","v":"\\10.16.248.2\UAT_Attachment\UAT_TLReports","r":"0","t":"s"},{"n":"DC9","v":"1","t":"dc"},{"n":"axp_recid9","v":"0","r":"0","t":"s"},{"n":"clientlogin_createflag","v":"T","r":"0","t":"s"}]}*$*{"globalVars":[{"n":"AxpAttachmentPath","v":"\\10.16.248.2\UAT_Attachment\UAT_TLReports"}]} Time taken by Quick FormLoad - 239 Quick DoFormLoad webservice completed Freeing DbCall Resources Freeing Store data Freeing DD Map Freeing Provide Link Freeing Validate Freeing Parser Freeing Poststr Freeing Maxrows Freeing Fnames Freeing NewMaxRows Freeing tlines Freeing workquery Freeing Struct Freeing EventList Freeing Tree Obj Freeing Workflow Obj Done - Workflow Obj Freeing DbCall Completed Freeing Action Obj Resources # 1#Saving to log insert into axpertlog (sessionid,username,calledon,callfinished,structname,recordid,servicename,serviceresult,timetaken,dbtimetaken,db_conntime) values ('gmyjcxxozanv2o1zo21ssfaf','rekhancia',to_timestamp('20/05/2025 12:39:54','dd/mm/yyyy hh24:mi:ss'),to_timestamp('20/05/2025 12:39:55','dd/mm/yyyy hh24:mi:ss'),'trcln',0,'Quick Form Load','success',685,55,0) uXDS\pinsert\ Check intransaction Closing connection Freeing AxProvider Resources Freeing DbManager Resources Destroying Default xds in db manager Destroying connect object Disconnecting from db trustlineuat Keep Connection setting false Disconnecting... Disconnected... Dbx name = ConnectionName = DriverName = GetDriverFunc = LibraryName = VendorLib = Successfully disconnected from db trustlineuat Destroyed connect object Destroying GF Getting structure from Cache. Loading tstruct.aspx completed End Time : 20/05/2025 12:39:55