SymAppDatabase server=10.38.31.100;database=SymSSR-UAT;uid=sa;password=sa;Connect Timeout=600; SymAppDatabase AddressBook Address_,System.String Address_Email,System.String Address_Name,System.String Address_No,System.Int32 Address_Phones,System.String Company_,System.Int32 Group_Cat,System.String Locations_,System.String Updated_By,System.Int32 Updated_Date,System.DateTime 30 AddressBook SymAppDatabase SELECT Address_No,Address_Name,Address_Email,Group_Cat,[Company] AS Company_,Updated_By,Updated_Date,Address_Phones,[Address] AS Address_,[Locations] AS Locations_ FROM AddressBook Approvals Approval_No,System.Int32 Approval_Note,System.String Approval_Required,System.String Approval_Status,System.String Approved_By,System.Int32 Approved_Date,System.DateTime Company_,System.Int32 Exercise_No,System.Int32 Module_,System.String Record_No,System.Int32 Remark_,System.String Submitted_By,System.Int32 Submitted_Date,System.DateTime 30 Approvals SymAppDatabase SELECT Approval_No,[Company] AS Company_,Exercise_No,[Module] AS Module_,Approval_Note,Approval_Required,Record_No,Submitted_By,Submitted_Date,Approved_By,Approved_Date,Approval_Status,[Remark] AS Remark_ FROM Approvals ArchiveShareHolder Account_Qualifier,System.String Address_,System.String Address2_,System.String Allow_Duplicate,System.String Attend_,System.Int16 Bank_Account,System.String Bank_Name,System.String Bank_Swift_Code,System.String Beneficiary_Code,System.String CDS_Account,System.String Company_,System.Int32 Country_Code,System.String Created_By,System.Int32 Created_Date,System.DateTime Email_,System.String Exercise_No,System.Int32 Gift_,System.String Import_No,System.Int32 Investor_Id,System.String Investor_Type,System.String Joint_Account_indicator,System.String Meps_Routing_Code,System.String Mobile_Number,System.String Name_,System.String Nationality_Code,System.String NewIn2ndROD_,System.Int32 NotIn2ndROD_,System.Int32 OldInvestor_Id,System.String Participant_Branch_Code,System.Int32 Participant_Code,System.Int32 Participant_Name,System.String Post_Code,System.String RaceOwnership_Code,System.String Registered_Date,System.DateTime Rejection_Codes,System.String Serial_Number,System.String Share_Allocation,System.Int32 Share_Unit,System.Int32 ShareHolder_No,System.Int32 Source_Batch,System.Int32 Source_Type,System.Byte State_Code,System.String Status_Code,System.String Stock_Code,System.String Telephone_Number,System.String Town_,System.String Unregistered_Date,System.DateTime Updated_By,System.Int32 Updated_Date,System.DateTime 30 ArchiveShareHolder SymAppDatabase SELECT ShareHolder_No,[Name] AS Name_,Investor_Id,Share_Unit,[Address] AS Address_,Created_Date,Created_By,Updated_Date,Updated_By,[Gift] AS Gift_,[Attend] AS Attend_,Share_Allocation,OldInvestor_Id,[Address2] AS Address2_,[Town] AS Town_,Post_Code,State_Code,Country_Code,CDS_Account,Registered_Date,Unregistered_Date,[Company] AS Company_,Source_Batch,[NotIn2ndROD] AS NotIn2ndROD_,[NewIn2ndROD] AS NewIn2ndROD_,Exercise_No,Import_No,Source_Type,Participant_Code,Participant_Branch_Code,Participant_Name,Nationality_Code,RaceOwnership_Code,Investor_Type,Telephone_Number,Stock_Code,Serial_Number,Status_Code,Beneficiary_Code,Account_Qualifier,Allow_Duplicate,Rejection_Codes,Mobile_Number,Bank_Account,Joint_Account_indicator,Meps_Routing_Code,Bank_Swift_Code,Bank_Name,[Email] AS Email_ FROM ArchiveShareHolder ArchiveShareholderExerciseData CDS_Account,System.String Exercise_No,System.Int32 ShareholderExerciseData_No,System.Int32 30 ArchiveShareholderExerciseData SymAppDatabase SELECT ShareholderExerciseData_No,CDS_Account,Exercise_No FROM ArchiveShareholderExerciseData BankingTransaction Address_,System.String Address2_,System.String CDS_Account,System.String Chq_date,System.String Chq_no,System.String Company_,System.Int32 Created_By,System.Int32 Created_Date,System.DateTime Delivery_,System.String E_Reason,System.String E_Reject,System.String Exercise_No,System.Int32 File_Type,System.Int32 Import_No,System.Int32 Name_,System.String Noc_No,System.String Post_Code,System.String State_Code,System.String Status_,System.String Taxrate1_,System.String Taxrate2_,System.String Taxrate3_,System.String Taxrate4_,System.String Town_,System.String Transaction_No,System.Int32 30 BankingTransaction SymAppDatabase SELECT Transaction_No,[Name] AS Name_,[Address] AS Address_,[Address2] AS Address2_,[Town] AS Town_,Post_Code,State_Code,CDS_Account,Exercise_No,Import_No,[Delivery] AS Delivery_,[Taxrate1] AS Taxrate1_,[Taxrate2] AS Taxrate2_,[Taxrate3] AS Taxrate3_,[Taxrate4] AS Taxrate4_,Noc_No,[Status] AS Status_,E_Reject,E_Reason,Chq_no,Chq_date,File_Type,[Company] AS Company_,Created_By,Created_Date FROM BankingTransaction CalculationFormulas CalculationFormula_No,System.Int32 Exercise_Type,System.String Formula_,System.String Formula_Name,System.String Updated_By,System.Int32 Updated_Date,System.DateTime 30 CalculationFormulas SymAppDatabase SELECT CalculationFormula_No,Exercise_Type,Formula_Name,[Formula] AS Formula_,Updated_Date,Updated_By FROM CalculationFormulas Calldetails Action_Plan,System.String Action_Type,System.String Agent_ID,System.String Call_Date,System.DateTime Call_From,System.String Call_No,System.Int32 Call_To,System.String Case_Category,System.String Case_ID,System.Int32 Case_No,System.Int32 Comments_,System.String Duration_,System.Int32 Extension_,System.Int32 First_Time,System.Byte Hunt_Group,System.String Improvement_,System.String Notes_,System.String Score_,System.Decimal Status_,System.String UCID_,System.String User_No,System.Int32 30 Calldetails SymAppDatabase SELECT Call_No,User_No,Call_Date,[Duration] AS Duration_,Call_From,Call_To,Agent_ID,[Extension] AS Extension_,Action_Type,Case_No,[Notes] AS Notes_,Hunt_Group,[UCID] AS UCID_,Case_Category,First_Time,[Improvement] AS Improvement_,[Comments] AS Comments_,Action_Plan,[Status] AS Status_,[Score] AS Score_,Case_ID FROM Calldetails CalldetailsArchive Action_Plan,System.String Action_Type,System.String Agent_ID,System.String Call_Date,System.DateTime Call_From,System.String Call_No,System.Int32 Call_To,System.String Case_Category,System.String Case_ID,System.Int32 Case_No,System.Int32 Comments_,System.String Duration_,System.Int32 Extension_,System.Int32 First_Time,System.Byte Hunt_Group,System.String Improvement_,System.String Notes_,System.String Score_,System.Decimal Status_,System.String UCID_,System.String User_No,System.Int32 30 CalldetailsArchive SymAppDatabase SELECT Call_No,User_No,Call_Date,[Duration] AS Duration_,Call_From,Call_To,Agent_ID,[Extension] AS Extension_,Action_Type,Case_No,[Notes] AS Notes_,Hunt_Group,[UCID] AS UCID_,Case_Category,First_Time,[Improvement] AS Improvement_,[Comments] AS Comments_,Action_Plan,[Status] AS Status_,[Score] AS Score_,Case_ID FROM CalldetailsArchive CaseActivities Activity_No,System.Int32 Activity_Type,System.String Case_No,System.Int32 Created_By,System.Int32 Created_Date,System.DateTime Notes_,System.String Owner_Group,System.Int32 30 CaseActivities SymAppDatabase SELECT Activity_No,Case_No,Activity_Type,[Notes] AS Notes_,Created_By,Created_Date,Owner_Group FROM CaseActivities CaseHeader Account_No,System.String Bill_Received,System.DateTime Bill_Sent,System.DateTime Call_Category,System.String Call_No,System.Int32 Callback_,System.DateTime Callback_Count,System.Byte Case_Category,System.String Case_No,System.Int32 Case_Type,System.String Channel_,System.String Closed_,System.DateTime Company_,System.Int32 Complete_By,System.DateTime Created_By,System.Int32 Created_Date,System.DateTime CustAddress_,System.String Customer_,System.String Customer_Email,System.String Customer_Mobile,System.String Customer_Model,System.String Customer_No,System.Int32 Customer_Phone,System.String Customer_Phone_H,System.String Date_Pulled,System.DateTime Date_Returned,System.DateTime Escalated_,System.DateTime ESP_No,System.String Exercise_No,System.Int32 Expiry_Date,System.DateTime FCR_,System.Boolean FTime_Caller,System.Boolean ICS_No,System.String Issue_Month,System.String Legal_Case,System.Boolean Order_No,System.String Owner_,System.Int32 Owner_Group,System.Int32 Payment_Sent,System.DateTime Payment_Updated,System.DateTime Premium_Name,System.String Priority_,System.String Product_,System.String Product_Detail,System.String Product_Name,System.String Promo_Key,System.String Purchased_,System.DateTime Received_,System.DateTime RecLock_By,System.Int32 RecLock_Date,System.DateTime Remarks_,System.String Reply_Channel,System.String Service_Type,System.String SLA_Due,System.DateTime SR_No,System.Int32 Start_Date,System.DateTime Status_,System.String UDText_1,System.String UDText_2,System.String Updated_By,System.Int32 Updated_Date,System.DateTime Vendor_No,System.String Warranty_,System.DateTime 30 CaseHeader SymAppDatabase SELECT Case_No,[Company] AS Company_,[Status] AS Status_,[Priority] AS Priority_,Service_Type,Case_Type,[Channel] AS Channel_,Reply_Channel,Case_Category,Call_Category,Created_By,Created_Date,Updated_By,Updated_Date,[Escalated] AS Escalated_,[Received] AS Received_,[Callback] AS Callback_,[Owner] AS Owner_,Owner_Group,Customer_No,[Customer] AS Customer_,Customer_Phone,Customer_Phone_H,Customer_Mobile,Customer_Email,Customer_Model,[Purchased] AS Purchased_,[Warranty] AS Warranty_,[Remarks] AS Remarks_,ESP_No,SLA_Due,Call_No,[Closed] AS Closed_,Vendor_No,UDText_1,UDText_2,Complete_By,Callback_Count,RecLock_Date,RecLock_By,FTime_Caller,SR_No,[Product] AS Product_,[FCR] AS FCR_,Legal_Case,Order_No,Product_Detail,Promo_Key,ICS_No,Product_Name,Premium_Name,Issue_Month,[CustAddress] AS CustAddress_,Account_No,Expiry_Date,Start_Date,Payment_Sent,Bill_Sent,Bill_Received,Payment_Updated,Date_Returned,Date_Pulled,Exercise_No FROM CaseHeader CertData Approved_By,System.Int32 Approved_Date,System.DateTime CDS_Account,System.String Cert_No,System.Int32 CertData_No,System.Int32 CertHeader_No,System.Int32 Exercise_No,System.Int32 Expiry_Date,System.DateTime LastUpdated_By,System.Int32 LastUpdated_Date,System.DateTime MemberAcct_No,System.String OldCert_No,System.Int32 Register_By,System.Int32 Register_Date,System.DateTime Share_Unit,System.Int64 Share_Value,System.Decimal Status_,System.String Suspend_By,System.Int32 Suspend_Code,System.String Suspend_Date,System.DateTime Transaction_Status,System.String Transfer_Date,System.DateTime Transfer_No,System.String Verified_By,System.Int32 Verified_Date,System.DateTime 30 CertData SymAppDatabase SELECT CertData_No,CertHeader_No,Exercise_No,Cert_No,CDS_Account,MemberAcct_No,Share_Unit,Share_Value,[Status] AS Status_,Transaction_Status,Register_Date,Register_By,Expiry_Date,Suspend_Code,Suspend_Date,Suspend_By,Transfer_No,Transfer_Date,OldCert_No,LastUpdated_By,LastUpdated_Date,Approved_By,Approved_Date,Verified_By,Verified_Date FROM CertData CertHeader Cert_Type,System.String CertEnd_No,System.Int32 CertHeader_No,System.Int32 CertStart_No,System.Int32 Company_No,System.Int32 LastAssigned_Date,System.DateTime LastAssignedCert_No,System.Int32 Source_Type,System.Byte Stock_Code,System.String 30 CertHeader SymAppDatabase SELECT CertHeader_No,Company_No,Stock_Code,CertStart_No,CertEnd_No,LastAssignedCert_No,Source_Type,Cert_Type,LastAssigned_Date FROM CertHeader ChequeReplacement CDS_Account,System.String ChequeReplacement_,System.Int32 ChequeRequest_No,System.Int32 Company_,System.Int32 CopyofCheque_,System.Byte[] Exercise_No,System.Int32 NewCheque_No,System.Int32 NewChqSentDate_,System.DateTime PreviousBankingCheId_,System.Int32 PreviousCheque_Date,System.DateTime PreviousCheque_No,System.Int32 PreviousRepTransCheque_Id,System.Int32 Shareholder_No,System.Int32 Status_,System.String 30 ChequeReplacement SymAppDatabase SELECT ChequeRequest_No,CDS_Account,Exercise_No,[Company] AS Company_,[ChequeReplacement] AS ChequeReplacement_,[CopyofCheque] AS CopyofCheque_,[Status] AS Status_,PreviousCheque_No,PreviousCheque_Date,[PreviousBankingCheId] AS PreviousBankingCheId_,PreviousRepTransCheque_Id,[NewChqSentDate] AS NewChqSentDate_,NewCheque_No,Shareholder_No FROM ChequeReplacement ContactImport Active_,System.Byte Batch_No,System.Int32 Company_,System.Int32 ContactImportNo_,System.Int32 Created_By,System.Int32 Created_Date,System.DateTime Description_,System.String Format_No,System.Int32 SubBatch_No,System.Int32 Total_Created,System.Int32 Total_Dups,System.Int32 Total_Inserted,System.Int32 Total_Rejected,System.Int32 Total_Updated,System.Int32 Total_Upload,System.Int32 Updated_By,System.Int32 Updated_Date,System.DateTime 30 ContactImport SymAppDatabase SELECT [ContactImportNo] AS ContactImportNo_,Batch_No,[Description] AS Description_,Created_By,Created_Date,Updated_By,Updated_Date,Total_Created,Total_Upload,Total_Rejected,[Company] AS Company_,[Active] AS Active_,Format_No,Total_Dups,SubBatch_No,Total_Updated,Total_Inserted FROM ContactImport Customers Account_ID,System.String Address_,System.String Company_,System.Int32 Company_Name,System.String Country_,System.String Created_By,System.Int32 Created_Date,System.DateTime Customer_Name,System.String Customer_Name_Hiragana,System.String Customer_No,System.Int32 Customer_Type,System.String Email_,System.String Fax_,System.String Mail_Address,System.String Mail_Country,System.String Mail_Post_Code,System.String Mail_State,System.String Mobile_,System.String Phone_,System.String Phone_Ext,System.String Phone_H,System.String Post_Code,System.String Remarks_,System.String State_,System.String Updated_By,System.Int32 Updated_Date,System.DateTime 30 Customers SymAppDatabase SELECT Customer_No,Customer_Type,[Company] AS Company_,Created_By,Created_Date,Updated_By,Updated_Date,Customer_Name,Customer_Name_Hiragana,[Phone] AS Phone_,Phone_Ext,[Mobile] AS Mobile_,Phone_H,[Fax] AS Fax_,[Email] AS Email_,[Address] AS Address_,[State] AS State_,Post_Code,[Country] AS Country_,Mail_Address,Mail_State,Mail_Post_Code,Mail_Country,[Remarks] AS Remarks_,Company_Name,Account_ID FROM Customers DataEntryBatches Citibank_No,System.Int32 Company_,System.Int32 Completed_Date,System.DateTime DataEntryBatch_No,System.Int32 DE1_By,System.Int32 DE1_Complete,System.Int32 DE1_Lock_Date,System.DateTime DE1_Records,System.Int32 DE2_By,System.Int32 DE2_Complete,System.Int32 DE2_Lock_Date,System.DateTime DE2_Records,System.Int32 Deposit_Date,System.DateTime Employee_ID,System.Int32 Envelopes_,System.Int32 Exercise_No,System.Int32 Exported_By,System.Int32 Exported_Date,System.DateTime Images_,System.Int32 Mismatches_,System.Int32 MMC_By,System.Int32 MMC_Lock_Date,System.DateTime Proxy_No,System.Int32 Receive_Batch_No,System.Int32 ShareHolder_No,System.Int32 Status_,System.String Transaction_Type,System.String Updated_By,System.Int32 Updated_Date,System.DateTime Upload_By,System.Int32 Upload_Correction_By,System.Int32 Upload_Correction_Date,System.DateTime Upload_Date,System.DateTime Void_Count,System.Int32 Work_Unit_No,System.Int32 30 DataEntryBatches SymAppDatabase SELECT DataEntryBatch_No,Transaction_Type,[Images] AS Images_,[Envelopes] AS Envelopes_,[Mismatches] AS Mismatches_,Upload_Date,Upload_By,Completed_Date,[Status] AS Status_,Work_Unit_No,Employee_ID,Exported_By,Exported_Date,Receive_Batch_No,DE1_Complete,DE2_Complete,DE1_By,DE1_Lock_Date,DE2_By,DE2_Lock_Date,MMC_By,MMC_Lock_Date,Upload_Correction_By,Upload_Correction_Date,DE1_Records,DE2_Records,Citibank_No,Deposit_Date,Exercise_No,[Company] AS Company_,Void_Count,Updated_Date,Updated_By,ShareHolder_No,Proxy_No FROM DataEntryBatches DataEntryConfig DataEntryConfig_No,System.Int32 Exercise_No,System.Int32 Exercise_Type,System.String Updated_By,System.Int32 Updated_Date,System.DateTime 30 DataEntryConfig SymAppDatabase SELECT DataEntryConfig_No,Exercise_No,Exercise_Type,Updated_By,Updated_Date FROM DataEntryConfig DataEntryConfigItems Category_,System.String DataEntryConfig_No,System.Int32 DataEntryConfigItem_No,System.Int32 Enable_,System.Boolean Item_Name,System.String Label_,System.String Required_,System.Boolean Show_,System.Boolean 30 DataEntryConfigItems SymAppDatabase SELECT DataEntryConfigItem_No,DataEntryConfig_No,Item_Name,[Label] AS Label_,[Category] AS Category_,[Show] AS Show_,[Required] AS Required_,[Enable] AS Enable_ FROM DataEntryConfigItems DataEntryData CDS_Account,System.String Custom1_,System.String Custom2_,System.String Custom3_,System.String Custom4_,System.String Custom5_,System.String Custom6_,System.String DataEntry_By,System.Int32 DataEntry_Date,System.DateTime DataEntry_Envelope,System.Int32 DataEntry_PriRecord,System.Boolean DataEntry_Status,System.String DataEntry_SuplRecord,System.Int32 DataEntry_Trans_Type,System.String DataEntry_Type,System.String DataEntryBatch_No,System.Int32 DataEntryData_No,System.Int32 DE_Status,System.String ExcessPayment_Received1,System.Decimal ExcessPayment_Received2,System.Decimal ExcessPayment_Received3,System.Decimal ExcessPayment_Received4,System.Decimal ExcessPayment_Received5,System.Decimal ExcessPayment_Received6,System.Decimal ExcessRef_No1,System.String ExcessRef_No2,System.String ExcessRef_No3,System.String ExcessRef_No4,System.String ExcessRef_No5,System.String ExcessRef_No6,System.String Notes_,System.String Payment_Received1,System.Decimal Payment_Received2,System.Decimal Payment_Received3,System.Decimal Payment_Received4,System.Decimal Payment_Received5,System.Decimal Payment_Received6,System.Decimal Proxy_No,System.Int32 Ref_No1,System.String Ref_No2,System.String Ref_No3,System.String Ref_No4,System.String Ref_No5,System.String Ref_No6,System.String Serial_No,System.String ShareHolder_No,System.Int32 TakeUp_Excess_Req,System.Int32 TakeUp_Excess_Req1,System.Int32 TakeUp_Excess_Req2,System.Int32 TakeUp_Excess_Req3,System.Int32 TakeUp_Excess_Req4,System.Int32 TakeUp_Excess_Req5,System.Int32 TakeUp_Excess_Req6,System.Int32 TakeUp_Requested,System.Int32 TakeUp_Requested1,System.Int32 TakeUp_Requested2,System.Int32 TakeUp_Requested3,System.Int32 TakeUp_Requested4,System.Int32 TakeUp_Requested5,System.Int32 TakeUp_Requested6,System.Int32 30 DataEntryData SymAppDatabase SELECT DataEntryData_No,DataEntryBatch_No,DataEntry_PriRecord,DataEntry_Type,DataEntry_Trans_Type,DataEntry_Date,DataEntry_By,DataEntry_Status,DataEntry_Envelope,DataEntry_SuplRecord,ShareHolder_No,Proxy_No,CDS_Account,TakeUp_Requested,TakeUp_Excess_Req,[Notes] AS Notes_,DE_Status,Serial_No,Payment_Received1,Payment_Received2,Payment_Received3,Payment_Received4,Payment_Received5,Payment_Received6,Ref_No1,Ref_No2,Ref_No3,Ref_No4,Ref_No5,Ref_No6,TakeUp_Requested1,TakeUp_Requested2,TakeUp_Requested3,TakeUp_Requested4,TakeUp_Requested5,TakeUp_Requested6,[Custom1] AS Custom1_,[Custom2] AS Custom2_,[Custom3] AS Custom3_,[Custom4] AS Custom4_,[Custom5] AS Custom5_,[Custom6] AS Custom6_,ExcessPayment_Received1,ExcessPayment_Received2,ExcessPayment_Received3,ExcessPayment_Received4,ExcessPayment_Received5,ExcessPayment_Received6,ExcessRef_No1,ExcessRef_No2,ExcessRef_No3,ExcessRef_No4,ExcessRef_No5,ExcessRef_No6,TakeUp_Excess_Req1,TakeUp_Excess_Req2,TakeUp_Excess_Req3,TakeUp_Excess_Req4,TakeUp_Excess_Req5,TakeUp_Excess_Req6 FROM DataEntryData DocDistributionDetail Created_By,System.Int32 Created_Date,System.DateTime DocDistDetail_No,System.Int32 DocumentHeader_No,System.Int32 Place_,System.String Remark_,System.String Total_Document,System.Int32 Updated_By,System.Int32 Updated_Date,System.DateTime 30 DocDistributionDetail SymAppDatabase SELECT DocDistDetail_No,DocumentHeader_No,[Place] AS Place_,Total_Document,[Remark] AS Remark_,Created_By,Created_Date,Updated_By,Updated_Date FROM DocDistributionDetail DocDistributionHeader Company_,System.Int32 Created_By,System.Int32 Created_Date,System.DateTime DocDistHeader_No,System.Int32 Document_Type,System.String Exercise_No,System.Int32 30 DocDistributionHeader SymAppDatabase SELECT DocDistHeader_No,[Company] AS Company_,Exercise_No,Document_Type,Created_By,Created_Date FROM DocDistributionHeader EmailGroups Active_,System.Boolean Company_,System.Int32 Domain_Restrict,System.String Email_Country,System.String Email_To,System.String EmailGroup_No,System.Int32 Group_Cat,System.String Group_Email,System.String Group_Name,System.String Holiday_List,System.Int32 Manager_,System.Int32 Secure_Email,System.Boolean Sender_Email,System.String Signature_,System.String SLA_No,System.Int32 Updated_By,System.Int32 Updated_Date,System.DateTime 30 EmailGroups SymAppDatabase SELECT EmailGroup_No,[Company] AS Company_,Group_Name,Group_Email,Sender_Email,[Active] AS Active_,Group_Cat,Updated_By,Updated_Date,Holiday_List,Email_To,[Signature] AS Signature_,SLA_No,Email_Country,Secure_Email,Domain_Restrict,[Manager] AS Manager_ FROM EmailGroups EmailGroupSecureClients Client_Email,System.String Client_Email_New,System.String EmailGroup_No,System.Int32 EmailGroupSecureClient_No,System.Int32 Enabled_,System.Boolean Updated_By,System.Int32 Updated_Date,System.DateTime 30 EmailGroupSecureClients SymAppDatabase SELECT EmailGroupSecureClient_No,EmailGroup_No,Client_Email,[Enabled] AS Enabled_,Updated_By,Updated_Date,Client_Email_New FROM EmailGroupSecureClients EmailGroupSecureUsers Approver_,System.Boolean EmailGroup_No,System.Int32 EmailGroupSecureClient_No,System.Int32 EmailGroupSecureUser_No,System.Int32 Manager_,System.Boolean Reply_,System.Boolean Updated_By,System.Int32 Updated_Date,System.DateTime User_No,System.Int32 View_,System.Boolean 30 EmailGroupSecureUsers SymAppDatabase SELECT EmailGroupSecureUser_No,EmailGroup_No,User_No,EmailGroupSecureClient_No,[View] AS View_,[Reply] AS Reply_,[Manager] AS Manager_,[Approver] AS Approver_,Updated_By,Updated_Date FROM EmailGroupSecureUsers Emails Base_Email_No,System.Int32 Case_No,System.Int32 Category_,System.String Client_,System.String Company_,System.Int32 Complete_,System.Boolean Created_Date,System.DateTime Email_CC,System.String Email_From,System.String Email_From_Domain,System.String Email_From_Name,System.String Email_No,System.Int32 Email_ReplyTo,System.String Email_To,System.String Email_To_All,System.String EmailGroup_No,System.Int32 Has_Attachments,System.Boolean Inbound_,System.Boolean Owner_,System.Int32 Priority_,System.String Received_Date,System.DateTime RecLock_By,System.Int32 RecLock_Date,System.DateTime Reply_Date,System.DateTime SLA_Due,System.DateTime Sub_Category,System.String Subject_,System.String Text_Body,System.String Updated_By,System.Int32 Updated_Date,System.DateTime 30 Emails SymAppDatabase SELECT Email_No,EmailGroup_No,Base_Email_No,Email_To,Email_From,Email_From_Name,Email_From_Domain,Email_ReplyTo,Received_Date,[Subject] AS Subject_,Has_Attachments,[Priority] AS Priority_,[Owner] AS Owner_,[Category] AS Category_,Sub_Category,Case_No,[Complete] AS Complete_,Created_Date,Updated_Date,Updated_By,Reply_Date,Text_Body,[Inbound] AS Inbound_,RecLock_Date,RecLock_By,[Company] AS Company_,[Client] AS Client_,SLA_Due,Email_To_All,Email_CC FROM Emails EmailsArchive Base_Email_No,System.Int32 Case_No,System.Int32 Category_,System.String Company_,System.Int32 Complete_,System.Boolean Created_Date,System.DateTime Email_From,System.String Email_From_Domain,System.String Email_From_Name,System.String Email_No,System.Int32 Email_To,System.String EmailGroup_No,System.Int32 Has_Attachments,System.Boolean Inbound_,System.Boolean Owner_,System.Int32 Received_Date,System.DateTime RecLock_By,System.Int32 RecLock_Date,System.DateTime Reply_Date,System.DateTime Sub_Category,System.String Subject_,System.String Text_Body,System.String Updated_By,System.Int32 Updated_Date,System.DateTime 30 EmailsArchive SymAppDatabase SELECT Email_No,EmailGroup_No,Base_Email_No,Email_To,Email_From,Email_From_Name,Email_From_Domain,Received_Date,[Subject] AS Subject_,Has_Attachments,[Owner] AS Owner_,[Category] AS Category_,Sub_Category,Case_No,[Complete] AS Complete_,Created_Date,Updated_Date,Updated_By,Reply_Date,Text_Body,[Inbound] AS Inbound_,RecLock_Date,RecLock_By,[Company] AS Company_ FROM EmailsArchive ERodHash ADABRHCODE_,System.Int32 ADACODE_,System.Int32 ADANAME_,System.String ADDR1_,System.String ADDR2_,System.String ADDR3_,System.String BANK_ACC,System.String BANK_CODE,System.String BANK_NAME,System.String Company_,System.String COUNTCODE_,System.String Created_By,System.String Created_Date,System.DateTime EMAIL_,System.String HashID_,System.Int32 HEIR_,System.String IC_,System.String JOINT_ACC,System.String MEMNO_,System.Int32 MEPS_CODE,System.String NAME_,System.String NAMEQUAL_,System.String NATION_,System.String OLD_INV_ID,System.String PHONE_,System.String POSCODE_,System.String RACE_,System.String REJECTCODE_,System.String SERIALNO_,System.String SHARE_,System.Int32 STATECODE_,System.String STATUSCODE_,System.String STOCKCODE_,System.String TYPE_,System.String 30 ERodHash SymAppDatabase SELECT [HashID] AS HashID_,[IC] AS IC_,[ADACODE] AS ADACODE_,[ADABRHCODE] AS ADABRHCODE_,[ADANAME] AS ADANAME_,[MEMNO] AS MEMNO_,[NAME] AS NAME_,[ADDR1] AS ADDR1_,[ADDR2] AS ADDR2_,[ADDR3] AS ADDR3_,[POSCODE] AS POSCODE_,[STATECODE] AS STATECODE_,[COUNTCODE] AS COUNTCODE_,[NATION] AS NATION_,[RACE] AS RACE_,[TYPE] AS TYPE_,[PHONE] AS PHONE_,[STOCKCODE] AS STOCKCODE_,[SERIALNO] AS SERIALNO_,[SHARE] AS SHARE_,[STATUSCODE] AS STATUSCODE_,[HEIR] AS HEIR_,[NAMEQUAL] AS NAMEQUAL_,BANK_ACC,JOINT_ACC,MEPS_CODE,BANK_CODE,BANK_NAME,[EMAIL] AS EMAIL_,[REJECTCODE] AS REJECTCODE_,OLD_INV_ID,Created_By,Created_Date,[Company] AS Company_ FROM ERodHash ExcessCalc CalculationRule_,System.String ExcessCalc_No,System.Int32 Exercise_No,System.Int32 Process_By,System.Int32 Process_Date,System.DateTime RightIndex_,System.Int32 Round_No,System.Int32 RoundingRule_,System.String SortA_,System.String SortB_,System.String SortingOrderA_,System.String SortingOrderB_,System.String Status_,System.String 30 ExcessCalc SymAppDatabase SELECT ExcessCalc_No,Exercise_No,[RightIndex] AS RightIndex_,Round_No,[RoundingRule] AS RoundingRule_,[SortA] AS SortA_,[SortingOrderA] AS SortingOrderA_,[SortB] AS SortB_,[SortingOrderB] AS SortingOrderB_,[CalculationRule] AS CalculationRule_,[Status] AS Status_,Process_By,Process_Date FROM ExcessCalc ExerciseRejectCriteria Criteria_Text,System.String Exercise_No,System.Int32 ExerciseRejectCriteria_No,System.Int32 Section_,System.String Updated_By,System.Int32 Updated_Date,System.DateTime 30 ExerciseRejectCriteria SymAppDatabase SELECT ExerciseRejectCriteria_No,Exercise_No,[Section] AS Section_,Criteria_Text,Updated_By,Updated_Date FROM ExerciseRejectCriteria Exercises Allocation_Type1,System.String Allocation_Type2,System.String Allocation_Type3,System.String Allocation_Type4,System.String Allocation_Type5,System.String Allocation_Type6,System.String Allot_Held,System.Decimal Allot_Held1,System.Decimal Allot_Held2,System.Decimal Allot_Held3,System.Decimal Allot_Held4,System.Decimal Allot_Held5,System.Decimal Allot_Held6,System.Decimal Allot_Perc,System.Decimal Allot_Shares,System.Decimal Allot_Shares1,System.Decimal Allot_Shares2,System.Decimal Allot_Shares3,System.Decimal Allot_Shares4,System.Decimal Allot_Shares5,System.Decimal Allot_Shares6,System.Decimal Approved_By,System.Int32 Approved_Date,System.DateTime Client_Appr_By,System.Int32 Client_Appr_Date,System.DateTime Company_,System.Int32 Created_By,System.Int32 Created_Date,System.DateTime Div_Rate1,System.Decimal Div_Rate2,System.Decimal Div_Rate3,System.Decimal Div_Rate4,System.Decimal Div_Rate5,System.Decimal Div_Rate6,System.Decimal Div_Reinvest,System.Boolean Div_Reinvest_Max,System.Decimal Entitlement_Date,System.DateTime Excess_Calc1,System.String Excess_Calc2,System.String Excess_Calc3,System.String ExcessBankAccount1_,System.String ExcessBankAccount2_,System.String ExcessBankAccount3_,System.String ExcessBankAccount4_,System.String ExcessBankAccount5_,System.String ExcessBankAccount6_,System.String ExcessBankBranch1_,System.String ExcessBankBranch2_,System.String ExcessBankBranch3_,System.String ExcessBankBranch4_,System.String ExcessBankBranch5_,System.String ExcessBankBranch6_,System.String ExcessBankName1_,System.String ExcessBankName2_,System.String ExcessBankName3_,System.String ExcessBankName4_,System.String ExcessBankName5_,System.String ExcessBankName6_,System.String Exercise_No,System.Int32 Exercise_Type,System.String ImportFinalRODBy1_,System.Int32 ImportFinalRODBy2_,System.Int32 ImportFinalRODBy3_,System.Int32 ImportFinalRODBy4_,System.Int32 ImportFinalRODBy5_,System.Int32 ImportFinalRODBy6_,System.Int32 ImportFinalRODDate1_,System.DateTime ImportFinalRODDate2_,System.DateTime ImportFinalRODDate3_,System.DateTime ImportFinalRODDate4_,System.DateTime ImportFinalRODDate5_,System.DateTime ImportFinalRODDate6_,System.DateTime ImportFinalRODStatus1_,System.String ImportFinalRODStatus2_,System.String ImportFinalRODStatus3_,System.String ImportFinalRODStatus4_,System.String ImportFinalRODStatus5_,System.String ImportFinalRODStatus6_,System.String MainBankAccount1_,System.String MainBankAccount2_,System.String MainBankAccount3_,System.String MainBankAccount4_,System.String MainBankAccount5_,System.String MainBankAccount6_,System.String MainBankBranch1_,System.String MainBankBranch2_,System.String MainBankBranch3_,System.String MainBankBranch4_,System.String MainBankBranch5_,System.String MainBankBranch6_,System.String MainBankName1_,System.String MainBankName2_,System.String MainBankName3_,System.String MainBankName4_,System.String MainBankName5_,System.String MainBankName6_,System.String MaxRightOffer1_,System.Decimal MaxRightOffer2_,System.Decimal MaxRightOffer3_,System.Decimal MaxRightOffer4_,System.Decimal MaxRightOffer5_,System.Decimal MaxRightOffer6_,System.Decimal MinRightOffer1_,System.Decimal MinRightOffer2_,System.Decimal MinRightOffer3_,System.Decimal MinRightOffer4_,System.Decimal MinRightOffer5_,System.Decimal MinRightOffer6_,System.Decimal Par_Value,System.Decimal Payment_Date,System.DateTime Perc_Calc_Type,System.Boolean Req_Payment1,System.Boolean Req_Payment2,System.Boolean Req_Payment3,System.Boolean Req_Payment4,System.Boolean Req_Payment5,System.Boolean Req_Payment6,System.Boolean RightDesc1_,System.String RightDesc2_,System.String RightDesc3_,System.String RightDesc4_,System.String RightDesc5_,System.String RightDesc6_,System.String Rounding_Rule,System.String Rounding_Rule1,System.String Rounding_Rule2,System.String Rounding_Rule3,System.String Rounding_Rule4,System.String Rounding_Rule5,System.String Rounding_Rule6,System.String Share_Type1,System.String Share_Type2,System.String Share_Type3,System.String Share_Type4,System.String Share_Type5,System.String Share_Type6,System.String Share_Value,System.Decimal Share_Value1,System.Decimal Share_Value2,System.Decimal Share_Value3,System.Decimal Share_Value4,System.Decimal Share_Value5,System.Decimal Share_Value6,System.Decimal Shareholders_Total,System.Int32 Status_,System.String Stock_Code,System.String StockCode1_,System.String StockCode2_,System.String StockCode3_,System.String StockCode4_,System.String StockCode5_,System.String StockCode6_,System.String Submitted_By,System.Int32 Submitted_Date,System.DateTime Tax_Rate1,System.Decimal Tax_Rate2,System.Decimal Tax_Rate3,System.Decimal Tax_Rate4,System.Decimal Tax_Rate5,System.Decimal Tax_Rate6,System.Decimal Updated_By,System.Int32 Updated_Date,System.DateTime Variance_Avg_Perc,System.Decimal Variance_Total,System.Decimal Variation_Limit,System.Decimal Year_Ending_Date,System.DateTime 30 Exercises SymAppDatabase SELECT Exercise_No,Exercise_Type,[Company] AS Company_,[Status] AS Status_,Created_Date,Created_By,Updated_Date,Updated_By,Submitted_Date,Submitted_By,Approved_Date,Approved_By,Client_Appr_Date,Client_Appr_By,Year_Ending_Date,Entitlement_Date,Payment_Date,Share_Value,Rounding_Rule,Div_Reinvest,Div_Reinvest_Max,Div_Rate1,Div_Rate2,Div_Rate3,Div_Rate4,Div_Rate5,Div_Rate6,Tax_Rate1,Tax_Rate2,Tax_Rate3,Tax_Rate4,Tax_Rate5,Tax_Rate6,Variation_Limit,Perc_Calc_Type,Par_Value,Allot_Shares,Allot_Held,Allot_Perc,Excess_Calc1,Excess_Calc2,Excess_Calc3,Shareholders_Total,Variance_Total,Variance_Avg_Perc,Stock_Code,[RightDesc1] AS RightDesc1_,[RightDesc2] AS RightDesc2_,[RightDesc3] AS RightDesc3_,[RightDesc4] AS RightDesc4_,[RightDesc5] AS RightDesc5_,[RightDesc6] AS RightDesc6_,[StockCode1] AS StockCode1_,[StockCode2] AS StockCode2_,[StockCode3] AS StockCode3_,[StockCode4] AS StockCode4_,[StockCode5] AS StockCode5_,[StockCode6] AS StockCode6_,Allocation_Type1,Allocation_Type2,Allocation_Type3,Allocation_Type4,Allocation_Type5,Allocation_Type6,Allot_Shares1,Allot_Shares2,Allot_Shares3,Allot_Shares4,Allot_Shares5,Allot_Shares6,Allot_Held1,Allot_Held2,Allot_Held3,Allot_Held4,Allot_Held5,Allot_Held6,Share_Type1,Share_Type2,Share_Type3,Share_Type4,Share_Type5,Share_Type6,Share_Value1,Share_Value2,Share_Value3,Share_Value4,Share_Value5,Share_Value6,Req_Payment1,Req_Payment2,Req_Payment3,Req_Payment4,Req_Payment5,Req_Payment6,[MaxRightOffer1] AS MaxRightOffer1_,[MaxRightOffer2] AS MaxRightOffer2_,[MaxRightOffer3] AS MaxRightOffer3_,[MaxRightOffer4] AS MaxRightOffer4_,[MaxRightOffer5] AS MaxRightOffer5_,[MaxRightOffer6] AS MaxRightOffer6_,[MinRightOffer1] AS MinRightOffer1_,[MinRightOffer2] AS MinRightOffer2_,[MinRightOffer3] AS MinRightOffer3_,[MinRightOffer4] AS MinRightOffer4_,[MinRightOffer5] AS MinRightOffer5_,[MinRightOffer6] AS MinRightOffer6_,Rounding_Rule1,Rounding_Rule2,Rounding_Rule3,Rounding_Rule4,Rounding_Rule5,Rounding_Rule6,[ImportFinalRODStatus1] AS ImportFinalRODStatus1_,[ImportFinalRODStatus2] AS ImportFinalRODStatus2_,[ImportFinalRODStatus3] AS ImportFinalRODStatus3_,[ImportFinalRODStatus4] AS ImportFinalRODStatus4_,[ImportFinalRODStatus5] AS ImportFinalRODStatus5_,[ImportFinalRODStatus6] AS ImportFinalRODStatus6_,[ImportFinalRODBy1] AS ImportFinalRODBy1_,[ImportFinalRODBy2] AS ImportFinalRODBy2_,[ImportFinalRODBy3] AS ImportFinalRODBy3_,[ImportFinalRODBy4] AS ImportFinalRODBy4_,[ImportFinalRODBy5] AS ImportFinalRODBy5_,[ImportFinalRODBy6] AS ImportFinalRODBy6_,[ImportFinalRODDate1] AS ImportFinalRODDate1_,[ImportFinalRODDate2] AS ImportFinalRODDate2_,[ImportFinalRODDate3] AS ImportFinalRODDate3_,[ImportFinalRODDate4] AS ImportFinalRODDate4_,[ImportFinalRODDate5] AS ImportFinalRODDate5_,[ImportFinalRODDate6] AS ImportFinalRODDate6_,[MainBankName1] AS MainBankName1_,[MainBankName2] AS MainBankName2_,[MainBankName3] AS MainBankName3_,[MainBankName4] AS MainBankName4_,[MainBankName5] AS MainBankName5_,[MainBankName6] AS MainBankName6_,[MainBankBranch1] AS MainBankBranch1_,[MainBankBranch2] AS MainBankBranch2_,[MainBankBranch3] AS MainBankBranch3_,[MainBankBranch4] AS MainBankBranch4_,[MainBankBranch5] AS MainBankBranch5_,[MainBankBranch6] AS MainBankBranch6_,[MainBankAccount1] AS MainBankAccount1_,[MainBankAccount2] AS MainBankAccount2_,[MainBankAccount3] AS MainBankAccount3_,[MainBankAccount4] AS MainBankAccount4_,[MainBankAccount5] AS MainBankAccount5_,[MainBankAccount6] AS MainBankAccount6_,[ExcessBankName1] AS ExcessBankName1_,[ExcessBankName2] AS ExcessBankName2_,[ExcessBankName3] AS ExcessBankName3_,[ExcessBankName4] AS ExcessBankName4_,[ExcessBankName5] AS ExcessBankName5_,[ExcessBankName6] AS ExcessBankName6_,[ExcessBankBranch1] AS ExcessBankBranch1_,[ExcessBankBranch2] AS ExcessBankBranch2_,[ExcessBankBranch3] AS ExcessBankBranch3_,[ExcessBankBranch4] AS ExcessBankBranch4_,[ExcessBankBranch5] AS ExcessBankBranch5_,[ExcessBankBranch6] AS ExcessBankBranch6_,[ExcessBankAccount1] AS ExcessBankAccount1_,[ExcessBankAccount2] AS ExcessBankAccount2_,[ExcessBankAccount3] AS ExcessBankAccount3_,[ExcessBankAccount4] AS ExcessBankAccount4_,[ExcessBankAccount5] AS ExcessBankAccount5_,[ExcessBankAccount6] AS ExcessBankAccount6_ FROM Exercises ExerciseTags Exercise_No,System.Int32 ExerciseTag_No,System.Int32 Tag_Action,System.String Tag_Type,System.String Tag_Value,System.String Updated_By,System.Int32 Updated_Date,System.DateTime 30 ExerciseTags SymAppDatabase SELECT ExerciseTag_No,Exercise_No,Tag_Type,Tag_Value,Tag_Action,Updated_Date,Updated_By FROM ExerciseTags ExerciseTasks Actual_End_Date,System.DateTime Actual_Start_Date,System.DateTime Approver_Role,System.String Delayed_,System.Boolean End_Date,System.DateTime End_Date_Req,System.DateTime End_Requested,System.Boolean Exercise_No,System.Int32 ExerciseTask_No,System.Int32 Module_,System.String Notes_,System.String Owner_,System.Int32 Owner_Role,System.String RecordType_,System.String Sequence_,System.Int32 Start_Date,System.DateTime Start_Date_Req,System.DateTime Task_Name,System.String Task_Status,System.String TaskBlock_,System.String TaskDependency_,System.Int32 Updated_By,System.Int32 Updated_Date,System.DateTime 30 ExerciseTasks SymAppDatabase SELECT ExerciseTask_No,Exercise_No,Task_Name,Task_Status,Start_Date,End_Date,Actual_Start_Date,Actual_End_Date,[Module] AS Module_,Updated_By,Updated_Date,Approver_Role,Owner_Role,[Owner] AS Owner_,Start_Date_Req,End_Date_Req,[TaskDependency] AS TaskDependency_,[TaskBlock] AS TaskBlock_,[Sequence] AS Sequence_,[Delayed] AS Delayed_,[Notes] AS Notes_,End_Requested,[RecordType] AS RecordType_ FROM ExerciseTasks Forex Company_,System.Int32 Currency_,System.String Forex_,System.Decimal Forex_No,System.Int32 Updated_By,System.Int32 Updated_Date,System.DateTime 30 Forex SymAppDatabase SELECT Forex_No,[Currency] AS Currency_,[Forex] AS Forex_,Updated_By,Updated_Date,[Company] AS Company_ FROM Forex FormBoxes Box_No,System.Int32 BoxCode_,System.String BoxGroup_,System.String BoxType_,System.String Exercise_No,System.Int32 Form_No,System.Int32 Height_,System.Int32 Page_No,System.Int32 Width_,System.Int32 xCoordinate_,System.Int32 yCoordinate_,System.Int32 30 FormBoxes SymAppDatabase SELECT Box_No,[xCoordinate] AS xCoordinate_,[yCoordinate] AS yCoordinate_,[Width] AS Width_,[Height] AS Height_,Form_No,Page_No,[BoxGroup] AS BoxGroup_,[BoxType] AS BoxType_,[BoxCode] AS BoxCode_,Exercise_No FROM FormBoxes FormDataFields Field_Name,System.String Field_Value,System.String FormDataFields_No,System.Int32 FormDataHeader_No,System.Int32 Updated_By,System.Int32 Updated_Date,System.DateTime 30 FormDataFields SymAppDatabase SELECT FormDataFields_No,FormDataHeader_No,Field_Name,Field_Value,Updated_By,Updated_Date FROM FormDataFields FormDataHeader Approved_By,System.Int32 Approved_Date,System.DateTime Form_Text,System.String FormDataHeader_No,System.Int32 Updated_By,System.Int32 Updated_Date,System.DateTime Verified_By,System.Int32 Verified_Date,System.DateTime 30 FormDataHeader SymAppDatabase SELECT FormDataHeader_No,Form_Text,Approved_By,Approved_Date,Verified_By,Verified_Date,Updated_By,Updated_Date FROM FormDataHeader Groups Case_Owner_Set,System.Boolean Case_Type,System.String Company_,System.Int32 Display_Order,System.Byte Email_,System.String Group_No,System.Int32 Level_No,System.Byte Name_,System.String Owner_,System.Int32 Service_Type,System.String Updated_By,System.Int32 Updated_Date,System.DateTime 30 Groups SymAppDatabase SELECT Group_No,[Owner] AS Owner_,[Name] AS Name_,[Email] AS Email_,Level_No,Updated_By,Updated_Date,[Company] AS Company_,Display_Order,Case_Type,Case_Owner_Set,Service_Type FROM Groups HolidayList Company_,System.Int32 Country_,System.String Holiday_Date,System.DateTime HolidayList_Name,System.String HolidayList_No,System.Int32 Updated_By,System.Int32 Updated_Date,System.DateTime 30 HolidayList SymAppDatabase SELECT HolidayList_No,HolidayList_Name,Holiday_Date,[Country] AS Country_,[Company] AS Company_,Updated_By,Updated_Date FROM HolidayList HolidayListItems Holiday_Date,System.DateTime Holiday_No,System.Int32 HolidayList_No,System.Int32 Name_,System.String Updated_By,System.Int32 Updated_Date,System.DateTime 30 HolidayListItems SymAppDatabase SELECT Holiday_No,HolidayList_No,[Name] AS Name_,Holiday_Date,Updated_By,Updated_Date FROM HolidayListItems ImportSubFiles DataSource_,System.String File_Name,System.String File_Size,System.Int32 Import_No,System.Int32 ImportSub_By,System.Int32 ImportSub_Date,System.DateTime ImportSub_No,System.Int32 Index_No,System.Int32 Task_Module,System.String Total_Record,System.Int32 30 ImportSubFiles SymAppDatabase SELECT ImportSub_No,Import_No,Task_Module,[DataSource] AS DataSource_,Index_No,File_Name,File_Size,Total_Record,ImportSub_Date,ImportSub_By FROM ImportSubFiles MailBatch Assigned_To,System.Int32 Batch_No,System.Int32 Batch_Status,System.String Company_,System.Int32 Completed_By,System.Int32 Completed_Date,System.DateTime Created_By,System.Int32 Created_Date,System.DateTime DE_Status,System.String Exercise_No,System.Int32 MailBatch_No,System.Int32 Received_Date,System.DateTime Sealed_By,System.Int32 Sealed_Date,System.DateTime Total_Approved,System.Int32 Total_Form,System.Int32 Total_Invalid,System.Int32 Total_Rejected,System.Int32 Updated_By,System.Int32 Updated_Date,System.DateTime Verified_By,System.Int32 Verified_Date,System.DateTime 30 MailBatch SymAppDatabase SELECT MailBatch_No,Exercise_No,Batch_No,Total_Form,Total_Approved,Total_Rejected,Total_Invalid,Batch_Status,Received_Date,Created_Date,Created_By,Updated_Date,Updated_By,Completed_Date,Completed_By,Verified_Date,Verified_By,[Company] AS Company_,Assigned_To,DE_Status,Sealed_Date,Sealed_By FROM MailBatch MailDataEntry CDSAccount_No,System.String Company_,System.Int32 Created_By,System.Int32 Created_Date,System.DateTime MailBatch_No,System.Int32 MailDataEntry_No,System.Int32 Remark_,System.String Serial_No,System.String Status_,System.String Updated_By,System.Int32 Updated_Date,System.DateTime 30 MailDataEntry SymAppDatabase SELECT MailDataEntry_No,MailBatch_No,Serial_No,CDSAccount_No,[Status] AS Status_,[Remark] AS Remark_,Created_Date,Created_By,Updated_Date,Updated_By,[Company] AS Company_ FROM MailDataEntry MassEmail Bounced_,System.Int32 Campaign_No,System.Int32 Company_,System.Int32 Completed_Date,System.DateTime Contacts_,System.Int32 Extra_Addresses,System.String Format_,System.String Forwarded_,System.Int32 Group_No,System.Int32 HTMLText_,System.String Language_,System.String MassEmail_No,System.Int32 Opened_,System.Int32 Replied_,System.Int32 Scheduled_Date,System.DateTime SpecSearch_No,System.Int32 SQL_,System.String Status_,System.String Subject_,System.String Subscriptions_,System.String Updated_By,System.Int32 Updated_Date,System.DateTime 30 MassEmail SymAppDatabase SELECT MassEmail_No,[Company] AS Company_,[Language] AS Language_,Updated_By,Updated_Date,[Status] AS Status_,[SQL] AS SQL_,[HTMLText] AS HTMLText_,[Subject] AS Subject_,Group_No,Campaign_No,SpecSearch_No,[Contacts] AS Contacts_,Completed_Date,[Subscriptions] AS Subscriptions_,[Format] AS Format_,Extra_Addresses,[Bounced] AS Bounced_,[Replied] AS Replied_,[Opened] AS Opened_,[Forwarded] AS Forwarded_,Scheduled_Date FROM MassEmail MassEmailLink Active_,System.Int32 Clicked_,System.Int32 Link_No,System.Int32 Link_URL,System.String MassEmail_No,System.Int32 30 MassEmailLink SymAppDatabase SELECT Link_No,Link_URL,MassEmail_No,[Clicked] AS Clicked_,[Active] AS Active_ FROM MassEmailLink Polling Abstain_,System.Int32 Abstain_Perc,System.Int32 Abstain_Share,System.Decimal Against_,System.Int32 Against_Perc,System.Int32 Against_Share,System.Decimal BeforeAGM_,System.Int32 Company_,System.Int32 Created_By,System.Int32 Created_Date,System.DateTime Disabled_,System.Int32 For_,System.Int32 For_Perc,System.Int32 For_Share,System.Decimal Not_Indicated,System.Int32 NotIndicated_Perc,System.Int32 NotIndicated_Share,System.Decimal OrdinaryResolution_Code,System.String Poll_no,System.Int32 Poller_Type,System.String Proxy_No,System.Int32 share_unit,System.Int32 ShareHolder_No,System.Int32 Updated_By,System.Int32 Updated_Date,System.DateTime 30 Polling SymAppDatabase SELECT Poll_no,ShareHolder_No,OrdinaryResolution_Code,[For] AS For_,[Against] AS Against_,[Abstain] AS Abstain_,Not_Indicated,Created_By,Created_Date,Updated_By,Updated_Date,[BeforeAGM] AS BeforeAGM_,[Disabled] AS Disabled_,Proxy_No,Poller_Type,[Company] AS Company_,share_unit,For_Perc,Against_Perc,Abstain_Perc,NotIndicated_Perc,For_Share,Against_Share,Abstain_Share,NotIndicated_Share FROM Polling Products Month_Issue,System.String Product_Id,System.Int32 Product_Line,System.String Product_Title,System.String Promtion_Key,System.String Subscription_End,System.DateTime Subscription_Start,System.DateTime Subscription_Term,System.String Updated_By,System.Int32 Updated_Date,System.DateTime 30 Products SymAppDatabase SELECT Product_Id,Product_Title,Product_Line,Promtion_Key,Subscription_Term,Month_Issue,Subscription_Start,Subscription_End,Updated_By,Updated_Date FROM Products Proxy Address_,System.String Attend_,System.Int16 Backup_To,System.Int32 Company_,System.Int32 Created_By,System.Int32 Created_Date,System.DateTime Gift_,System.String IC_,System.String Is_Chairman,System.Int32 Name_,System.String NewIn2ndROD_,System.Int32 NotIn2ndROD_,System.Int32 Proxy_No,System.Int32 Registered_Date,System.DateTime Registered_Sequence,System.Int32 Share_Percentage,System.Int32 Share_Unit,System.Int32 ShareHolder_No,System.Int32 Source_Batch,System.Int32 Total_ShareUnit,System.Int32 Unregistered_Date,System.DateTime Updated_By,System.Int32 Updated_Date,System.DateTime 30 Proxy SymAppDatabase SELECT Proxy_No,ShareHolder_No,[Name] AS Name_,[IC] AS IC_,Share_Unit,[Address] AS Address_,Created_Date,Created_By,Updated_Date,Updated_By,[Gift] AS Gift_,[Attend] AS Attend_,Share_Percentage,Registered_Date,Unregistered_Date,Registered_Sequence,Is_Chairman,[Company] AS Company_,Source_Batch,Total_ShareUnit,Backup_To,[NotIn2ndROD] AS NotIn2ndROD_,[NewIn2ndROD] AS NewIn2ndROD_ FROM Proxy QuestionnaireA Answer_Correct,System.Byte Answer_No,System.Int32 Answer_Text,System.String Question_No,System.Int32 Questionnaire_No,System.Int32 30 QuestionnaireA SymAppDatabase SELECT Answer_No,Question_No,Questionnaire_No,Answer_Text,Answer_Correct FROM QuestionnaireA QuestionnaireQ Order_,System.Int32 Question_No,System.Int32 Question_Text,System.String Questionnaire_No,System.Int32 Type_,System.String 30 QuestionnaireQ SymAppDatabase SELECT Question_No,Questionnaire_No,Question_Text,[Order] AS Order_,[Type] AS Type_ FROM QuestionnaireQ Questionnaireresponses Company_,System.Int32 Questionnaire_No,System.Int32 Response_No,System.Int32 Score_,System.Decimal Updated_By,System.Int32 Updated_Date,System.DateTime 30 Questionnaireresponses SymAppDatabase SELECT Response_No,Questionnaire_No,Updated_By,Updated_Date,[Score] AS Score_,[Company] AS Company_ FROM Questionnaireresponses Questionnaireresponsesa Answer_No,System.Int32 Answer_Text,System.String Correct_,System.Byte Question_No,System.Int32 Response_No,System.Int32 ResponseA_No,System.Int32 30 Questionnaireresponsesa SymAppDatabase SELECT ResponseA_No,Response_No,Question_No,Answer_No,Answer_Text,[Correct] AS Correct_ FROM Questionnaireresponsesa Questionnaires Company_,System.Int32 Created_By,System.Int32 Created_Date,System.DateTime Enabled_,System.Byte Name_,System.String Questionnaire_No,System.Int32 ReAssess_Delay,System.Int32 ReAssess_Score,System.Int32 Updated_By,System.Int32 Updated_Date,System.DateTime 30 Questionnaires SymAppDatabase SELECT Questionnaire_No,[Name] AS Name_,[Enabled] AS Enabled_,Created_By,Created_Date,Updated_By,Updated_Date,[Company] AS Company_,ReAssess_Delay,ReAssess_Score FROM Questionnaires Ratingquestions Category_,System.String Company_,System.Int32 Question_,System.String Rate_Type,System.String Rating_Question_No,System.Int32 Updated_By,System.Int32 Updated_Date,System.DateTime 30 Ratingquestions SymAppDatabase SELECT Rating_Question_No,[Category] AS Category_,[Question] AS Question_,Updated_Date,Updated_By,[Company] AS Company_,Rate_Type FROM Ratingquestions Ratings Call_No,System.Int32 Category_,System.String Rating_No,System.Int32 Rating_Question_No,System.Int32 Response_,System.Byte 30 Ratings SymAppDatabase SELECT Rating_No,Rating_Question_No,[Response] AS Response_,Call_No,[Category] AS Category_ FROM Ratings ReplacementChequeVoucher CDS_Account,System.String ChequeReplacement_,System.Int32 ChequeRequest_No,System.Int32 Company_,System.Int32 CopyofCheque_,System.Byte[] Exercise_No,System.Int32 NewCheque_No,System.Int32 NewChqReqBy_,System.Int32 NewChqReqDate_,System.DateTime NewChqSentDate_,System.DateTime PreviousBankingCheId_,System.Int32 PreviousCheque_Date,System.DateTime PreviousCheque_No,System.Int32 PreviousRepTransCheque_Id,System.Int32 Status_,System.String StopApprovedCheBy_,System.Int32 StopApprovedCheDate_,System.DateTime StopReqCheBy_,System.Int32 StopReqCheDate_,System.DateTime 30 ReplacementChequeVoucher SymAppDatabase SELECT ChequeRequest_No,CDS_Account,Exercise_No,[Company] AS Company_,[ChequeReplacement] AS ChequeReplacement_,[StopReqCheDate] AS StopReqCheDate_,[StopApprovedCheDate] AS StopApprovedCheDate_,[CopyofCheque] AS CopyofCheque_,[Status] AS Status_,[StopReqCheBy] AS StopReqCheBy_,[StopApprovedCheBy] AS StopApprovedCheBy_,[NewChqReqBy] AS NewChqReqBy_,PreviousCheque_No,PreviousCheque_Date,[PreviousBankingCheId] AS PreviousBankingCheId_,PreviousRepTransCheque_Id,[NewChqReqDate] AS NewChqReqDate_,[NewChqSentDate] AS NewChqSentDate_,NewCheque_No FROM ReplacementChequeVoucher ScanData Black_,System.Int32 BoxGroup_,System.String DataEntryBatch_No,System.Int32 DataEntryData_No,System.Int32 Form_No,System.Int32 Page_No,System.Int32 ScanBy_,System.Int32 ScanData_No,System.Int32 ScanDate_,System.DateTime White_,System.Int32 30 ScanData SymAppDatabase SELECT ScanData_No,DataEntryBatch_No,DataEntryData_No,Form_No,Page_No,[BoxGroup] AS BoxGroup_,[White] AS White_,[Black] AS Black_,[ScanBy] AS ScanBy_,[ScanDate] AS ScanDate_ FROM ScanData ScanStats Complete_Date,System.DateTime File_Count,System.Int32 Files_,System.String Folder_Count,System.Int32 Scan_By,System.Int32 ScanStat_No,System.Int32 Start_Date,System.DateTime 30 ScanStats SymAppDatabase SELECT ScanStat_No,Start_Date,Complete_Date,Scan_By,File_Count,Folder_Count,[Files] AS Files_ FROM ScanStats ShareHolder Account_Qualifier,System.String Active1_,System.Boolean Active2_,System.Boolean Active3_,System.Boolean Active4_,System.Boolean Active5_,System.Boolean Active6_,System.Boolean Address_,System.String Address2_,System.String Allow_Duplicate,System.String Approved_By,System.Int32 Approved_Date,System.DateTime Attend_,System.Int16 Bank_Account,System.String Bank_Name,System.String Bank_Swift_Code,System.String Beneficiary_Code,System.String CDS_Account,System.String Company_,System.Int32 Country_Code,System.String Created_By,System.Int32 Created_Date,System.DateTime Email_,System.String Exercise_No,System.Int32 Gift_,System.String Import_No,System.Int32 Investor_Id,System.String Investor_Type,System.String Joint_Account_indicator,System.String Meps_Routing_Code,System.String Mobile_Number,System.String Name_,System.String Nationality_Code,System.String NewIn2ndROD_,System.Int32 NotIn2ndROD_,System.Int32 OldInvestor_Id,System.String Participant_Branch_Code,System.Int32 Participant_Code,System.Int32 Participant_Name,System.String Post_Code,System.String RaceOwnership_Code,System.String Registered_Date,System.DateTime Rejection_Codes,System.String Remark_,System.String Serial_Number,System.String Share_Allocation,System.Int32 Share_Unit,System.Int64 ShareHolder_No,System.Int32 Shareholder_Status,System.String Shareholder_Type,System.String Source_Batch,System.Int32 Source_Type,System.Byte SourceIndicator_,System.String State_Code,System.String Status_Code,System.String Stock_Code,System.String Telephone_Number,System.String Town_,System.String Unregistered_Date,System.DateTime Update_Pending_No,System.Int32 Updated_By,System.Int32 Updated_Date,System.DateTime Version_Status,System.String 30 ShareHolder SymAppDatabase SELECT ShareHolder_No,[Name] AS Name_,Investor_Id,Share_Unit,[Address] AS Address_,Created_Date,Created_By,Updated_Date,Updated_By,[Gift] AS Gift_,[Attend] AS Attend_,Share_Allocation,OldInvestor_Id,[Address2] AS Address2_,[Town] AS Town_,Post_Code,State_Code,Country_Code,CDS_Account,Registered_Date,Unregistered_Date,[Company] AS Company_,Source_Batch,[NotIn2ndROD] AS NotIn2ndROD_,[NewIn2ndROD] AS NewIn2ndROD_,[SourceIndicator] AS SourceIndicator_,Exercise_No,Import_No,Source_Type,Participant_Code,Participant_Branch_Code,Participant_Name,Nationality_Code,RaceOwnership_Code,Investor_Type,Telephone_Number,Stock_Code,Serial_Number,Status_Code,Beneficiary_Code,Account_Qualifier,Allow_Duplicate,Rejection_Codes,Mobile_Number,Bank_Account,Joint_Account_indicator,Meps_Routing_Code,Bank_Swift_Code,Bank_Name,[Email] AS Email_,Version_Status,Update_Pending_No,[Active1] AS Active1_,[Active2] AS Active2_,[Active3] AS Active3_,[Active4] AS Active4_,[Active5] AS Active5_,[Active6] AS Active6_,Shareholder_Type,Shareholder_Status,[Remark] AS Remark_,Approved_By,Approved_Date FROM ShareHolder ShareHolder_temp Address_,System.String Address2_,System.String Attend_,System.Int16 CDS_Account,System.String Company_,System.Int32 Country_Code,System.String Created_By,System.Int32 Created_Date,System.DateTime Gift_,System.String Investor_Id,System.String Name_,System.String NewIn2ndROD_,System.Int32 NotIn2ndROD_,System.Int32 OldInvestor_Id,System.String Post_Code,System.String Registered_Date,System.DateTime Share_Allocation,System.Int32 Share_Unit,System.Int32 ShareHolder_No,System.Int32 Source_Batch,System.Int32 SourceIndicator_,System.String State_Code,System.String Town_,System.String Unregistered_Date,System.DateTime Updated_By,System.Int32 Updated_Date,System.DateTime 30 ShareHolder_temp SymAppDatabase SELECT ShareHolder_No,[Name] AS Name_,Investor_Id,Share_Unit,[Address] AS Address_,Created_Date,Created_By,Updated_Date,Updated_By,[Gift] AS Gift_,[Attend] AS Attend_,Share_Allocation,OldInvestor_Id,[Address2] AS Address2_,[Town] AS Town_,Post_Code,State_Code,Country_Code,CDS_Account,Registered_Date,Unregistered_Date,[Company] AS Company_,Source_Batch,[NotIn2ndROD] AS NotIn2ndROD_,[NewIn2ndROD] AS NewIn2ndROD_,[SourceIndicator] AS SourceIndicator_ FROM ShareHolder_temp ShareHolderData Account_Qualifier,System.String Address_,System.String Address2_,System.String Allow_Duplicate,System.String Attend_,System.Int16 Bank_Account,System.String Bank_Name,System.String Bank_Swift_Code,System.String Beneficiary_Code,System.String CDS_Account,System.String Company_,System.Int32 Country_Code,System.String Created_By,System.Int32 Created_Date,System.DateTime Email_,System.String Exercise_No,System.Int32 Gift_,System.String Import_No,System.Int32 ImportSub_No,System.Int32 Investor_Id,System.String Investor_Type,System.String Joint_Account_indicator,System.String Meps_Routing_Code,System.String Mobile_Number,System.String Name_,System.String Nationality_Code,System.String NewIn2ndROD_,System.Int32 NotIn2ndROD_,System.Int32 OldInvestor_Id,System.String Participant_Branch_Code,System.Int32 Participant_Code,System.Int32 Participant_Name,System.String Post_Code,System.String RaceOwnership_Code,System.String Registered_Date,System.DateTime Rejection_Codes,System.String RightIndex_,System.Int32 Serial_Number,System.String Share_Allocation,System.Int32 Share_Unit,System.Int64 ShareHolderData_No,System.Int32 Source_Batch,System.Int32 Source_Type,System.Byte SourceIndicator_,System.String State_Code,System.String Status_Code,System.String Stock_Code,System.String Telephone_Number,System.String Town_,System.String Unregistered_Date,System.DateTime Update_Pending_No,System.Int32 Updated_By,System.Int32 Updated_Date,System.DateTime Version_Status,System.String 30 ShareHolderData SymAppDatabase SELECT ShareHolderData_No,[Name] AS Name_,Investor_Id,Share_Unit,[Address] AS Address_,Created_Date,Created_By,Updated_Date,Updated_By,[Gift] AS Gift_,[Attend] AS Attend_,Share_Allocation,OldInvestor_Id,[Address2] AS Address2_,[Town] AS Town_,Post_Code,State_Code,Country_Code,CDS_Account,Registered_Date,Unregistered_Date,[Company] AS Company_,Source_Batch,[NotIn2ndROD] AS NotIn2ndROD_,[NewIn2ndROD] AS NewIn2ndROD_,[SourceIndicator] AS SourceIndicator_,Exercise_No,Import_No,Source_Type,Participant_Code,Participant_Branch_Code,Participant_Name,Nationality_Code,RaceOwnership_Code,Investor_Type,Telephone_Number,Stock_Code,Serial_Number,Status_Code,Beneficiary_Code,Account_Qualifier,Allow_Duplicate,Rejection_Codes,Mobile_Number,Bank_Account,Joint_Account_indicator,Meps_Routing_Code,Bank_Swift_Code,Bank_Name,[Email] AS Email_,Version_Status,Update_Pending_No,[RightIndex] AS RightIndex_,ImportSub_No FROM ShareHolderData ShareholderExerciseCalc Excess_Remaining,System.Int32 ExcessAllotment_,System.Int32 Exercise_No,System.Int32 RightIndex_,System.Int32 Round_No,System.Byte ShareholderExerciseCalc_No,System.Int32 ShareholderExerciseData_No,System.Int32 Total_ExcessAllotment,System.Int32 30 ShareholderExerciseCalc SymAppDatabase SELECT ShareholderExerciseCalc_No,ShareholderExerciseData_No,Exercise_No,[RightIndex] AS RightIndex_,Round_No,[ExcessAllotment] AS ExcessAllotment_,Total_ExcessAllotment,Excess_Remaining FROM ShareholderExerciseCalc ShareholderExerciseData Allotment1_,System.Int32 Allotment2_,System.Int32 Allotment3_,System.Int32 Allotment4_,System.Int32 Allotment5_,System.Int32 Allotment6_,System.Int32 Batch_No,System.Int32 CDS_Account,System.String Custom1_,System.String Custom2_,System.String Custom3_,System.String Custom4_,System.String Custom5_,System.String Custom6_,System.String DE_Status,System.String DE_Unsealed,System.Boolean Delivery_,System.String ExcessPayment_Received1,System.Decimal ExcessPayment_Received2,System.Decimal ExcessPayment_Received3,System.Decimal ExcessPayment_Received4,System.Decimal ExcessPayment_Received5,System.Decimal ExcessPayment_Received6,System.Decimal ExcessRef_No1,System.String ExcessRef_No2,System.String ExcessRef_No3,System.String ExcessRef_No4,System.String ExcessRef_No5,System.String ExcessRef_No6,System.String Exercise_No,System.Int32 Gross_Total,System.Decimal Gross1_,System.Decimal Gross2_,System.Decimal Gross3_,System.Decimal Gross4_,System.Decimal Gross5_,System.Decimal Gross6_,System.Decimal Mother_Share_Holding,System.Int32 Net_Total,System.Decimal Net1_,System.Decimal Net2_,System.Decimal Net3_,System.Decimal Net4_,System.Decimal Net5_,System.Decimal Net6_,System.Decimal Notes_,System.String Payment_Received1,System.Decimal Payment_Received2,System.Decimal Payment_Received3,System.Decimal Payment_Received4,System.Decimal Payment_Received5,System.Decimal Payment_Received6,System.Decimal Prev_Allotment1,System.Int64 Prev_Allotment2,System.Int64 Prev_Allotment3,System.Int64 Prev_Allotment4,System.Int64 Prev_Allotment5,System.Int64 Prev_Allotment6,System.Int64 Prev_Net_Total,System.Decimal Prev_TakeUp_Allotment,System.Int32 Prev_TakeUp_Net_Total,System.Decimal Prev_TakeUp_Remainder,System.Decimal Ref_No1,System.String Ref_No2,System.String Ref_No3,System.String Ref_No4,System.String Ref_No5,System.String Ref_No6,System.String Serial_No,System.String ShareholderExerciseData_No,System.Int32 TakeUp_Allotment1,System.Int32 TakeUp_Allotment2,System.Int32 TakeUp_Allotment3,System.Int32 TakeUp_Allotment4,System.Int32 TakeUp_Allotment5,System.Int32 TakeUp_Allotment6,System.Int32 TakeUp_Excess,System.Int32 TakeUp_Excess_Alloc1,System.Int32 TakeUp_Excess_Alloc2,System.Int32 TakeUp_Excess_Alloc3,System.Int32 TakeUp_Excess_Alloc4,System.Int32 TakeUp_Excess_Alloc5,System.Int32 TakeUp_Excess_Alloc6,System.Int32 TakeUp_Excess_Req1,System.Int32 TakeUp_Excess_Req2,System.Int32 TakeUp_Excess_Req3,System.Int32 TakeUp_Excess_Req4,System.Int32 TakeUp_Excess_Req5,System.Int32 TakeUp_Excess_Req6,System.Int32 TakeUp_Gross_Allotment,System.Decimal TakeUp_Gross_Excess,System.Decimal TakeUp_Gross_Total1,System.Decimal TakeUp_Gross_Total2,System.Decimal TakeUp_Gross_Total3,System.Decimal TakeUp_Gross_Total4,System.Decimal TakeUp_Gross_Total5,System.Decimal TakeUp_Gross_Total6,System.Decimal TakeUp_Net_Total1,System.Decimal TakeUp_Net_Total2,System.Decimal TakeUp_Net_Total3,System.Decimal TakeUp_Net_Total4,System.Decimal TakeUp_Net_Total5,System.Decimal TakeUp_Net_Total6,System.Decimal TakeUp_Remainder1,System.Decimal TakeUp_Remainder2,System.Decimal TakeUp_Remainder3,System.Decimal TakeUp_Remainder4,System.Decimal TakeUp_Remainder5,System.Decimal TakeUp_Remainder6,System.Decimal TakeUp_Requested1,System.Int32 TakeUp_Requested2,System.Int32 TakeUp_Requested3,System.Int32 TakeUp_Requested4,System.Int32 TakeUp_Requested5,System.Int32 TakeUp_Requested6,System.Int32 TakeUp_Tax_Total1,System.Decimal TakeUp_Tax_Total2,System.Decimal TakeUp_Tax_Total3,System.Decimal TakeUp_Tax_Total4,System.Decimal TakeUp_Tax_Total5,System.Decimal TakeUp_Tax_Total6,System.Decimal Tax_Total,System.Decimal Tax1_,System.Decimal Tax2_,System.Decimal Tax3_,System.Decimal Tax4_,System.Decimal Tax5_,System.Decimal Tax6_,System.Decimal Updated_By,System.Int32 Updated_Date,System.DateTime 30 ShareholderExerciseData SymAppDatabase SELECT ShareholderExerciseData_No,CDS_Account,Exercise_No,Batch_No,Updated_Date,Updated_By,[Allotment1] AS Allotment1_,[Allotment2] AS Allotment2_,[Allotment3] AS Allotment3_,[Allotment4] AS Allotment4_,[Allotment5] AS Allotment5_,[Allotment6] AS Allotment6_,Prev_Allotment1,Prev_Allotment2,Prev_Allotment3,Prev_Allotment4,Prev_Allotment5,Prev_Allotment6,TakeUp_Requested1,TakeUp_Requested2,TakeUp_Requested3,TakeUp_Requested4,TakeUp_Requested5,TakeUp_Requested6,TakeUp_Allotment1,TakeUp_Allotment2,TakeUp_Allotment3,TakeUp_Allotment4,TakeUp_Allotment5,TakeUp_Allotment6,TakeUp_Excess_Req1,TakeUp_Excess_Req2,TakeUp_Excess_Req3,TakeUp_Excess_Req4,TakeUp_Excess_Req5,TakeUp_Excess_Req6,TakeUp_Excess_Alloc1,TakeUp_Excess_Alloc2,TakeUp_Excess_Alloc3,TakeUp_Excess_Alloc4,TakeUp_Excess_Alloc5,TakeUp_Excess_Alloc6,TakeUp_Gross_Total1,TakeUp_Gross_Total2,TakeUp_Gross_Total3,TakeUp_Gross_Total4,TakeUp_Gross_Total5,TakeUp_Gross_Total6,TakeUp_Tax_Total1,TakeUp_Tax_Total2,TakeUp_Tax_Total3,TakeUp_Tax_Total4,TakeUp_Tax_Total5,TakeUp_Tax_Total6,TakeUp_Net_Total1,TakeUp_Net_Total2,TakeUp_Net_Total3,TakeUp_Net_Total4,TakeUp_Net_Total5,TakeUp_Net_Total6,TakeUp_Remainder1,TakeUp_Remainder2,TakeUp_Remainder3,TakeUp_Remainder4,TakeUp_Remainder5,TakeUp_Remainder6,Payment_Received1,Payment_Received2,Payment_Received3,Payment_Received4,Payment_Received5,Payment_Received6,ExcessPayment_Received1,ExcessPayment_Received2,ExcessPayment_Received3,ExcessPayment_Received4,ExcessPayment_Received5,ExcessPayment_Received6,[Gross1] AS Gross1_,[Gross2] AS Gross2_,[Gross3] AS Gross3_,[Gross4] AS Gross4_,[Gross5] AS Gross5_,[Gross6] AS Gross6_,Gross_Total,[Net1] AS Net1_,[Net2] AS Net2_,[Net3] AS Net3_,[Net4] AS Net4_,[Net5] AS Net5_,[Net6] AS Net6_,Net_Total,[Tax1] AS Tax1_,[Tax2] AS Tax2_,[Tax3] AS Tax3_,[Tax4] AS Tax4_,[Tax5] AS Tax5_,[Tax6] AS Tax6_,Tax_Total,[Delivery] AS Delivery_,Serial_No,DE_Unsealed,DE_Status,[Notes] AS Notes_,Prev_TakeUp_Allotment,Prev_TakeUp_Net_Total,Prev_TakeUp_Remainder,Prev_Net_Total,Mother_Share_Holding,TakeUp_Excess,TakeUp_Gross_Allotment,TakeUp_Gross_Excess,Ref_No1,Ref_No2,Ref_No3,Ref_No4,Ref_No5,Ref_No6,ExcessRef_No1,ExcessRef_No2,ExcessRef_No3,ExcessRef_No4,ExcessRef_No5,ExcessRef_No6,[Custom1] AS Custom1_,[Custom2] AS Custom2_,[Custom3] AS Custom3_,[Custom4] AS Custom4_,[Custom5] AS Custom5_,[Custom6] AS Custom6_ FROM ShareholderExerciseData Sla Company_,System.Int32 EmailGroup_No,System.String EndTime_,System.DateTime Priority_,System.String SLA_,System.Int32 SLA_No,System.Int32 SLAType_,System.String StartTime_,System.DateTime Updated_By,System.Int32 Updated_Date,System.DateTime Workdays_,System.Byte 30 Sla SymAppDatabase SELECT SLA_No,[Priority] AS Priority_,[SLA] AS SLA_,[StartTime] AS StartTime_,[EndTime] AS EndTime_,[Workdays] AS Workdays_,[Company] AS Company_,Updated_Date,Updated_By,EmailGroup_No,[SLAType] AS SLAType_ FROM Sla SSRComparisondtl Comparison_No,System.Int32 Created_By,System.Int32 Created_Date,System.DateTime File_No1,System.Int32 File_No2,System.Int32 Updated_By,System.Int32 Updated_Date,System.DateTime 30 SSRComparisondtl SymAppDatabase SELECT Comparison_No,File_No1,File_No2,Created_By,Created_Date,Updated_By,Updated_Date FROM SSRComparisondtl SSRDividend Created_By,System.Int32 Created_Date,System.DateTime Dividend_ID,System.String Dividend_No,System.Int32 Dividend_Rate1,System.Decimal Dividend_Rate2,System.Decimal Dividend_Rate3,System.Decimal Dividend_Rate4,System.Decimal Dividend_Rate5,System.Decimal Dividend_Rate6,System.Decimal Dividend_Type,System.String Enabled_,System.Boolean Par_Value,System.Decimal Rounding_Rule,System.String Stock_No,System.Int32 Tax_Rate1,System.Decimal Tax_Rate2,System.Decimal Tax_Rate3,System.Decimal Tax_Rate4,System.Decimal Tax_Rate5,System.Decimal Tax_Rate6,System.Decimal Tax_Type,System.String Updated_By,System.Int32 Updated_Date,System.DateTime 30 SSRDividend SymAppDatabase SELECT Dividend_No,Stock_No,Dividend_ID,Dividend_Type,Rounding_Rule,Tax_Type,Par_Value,Dividend_Rate1,Dividend_Rate2,Dividend_Rate3,Dividend_Rate4,Dividend_Rate5,Dividend_Rate6,Tax_Rate1,Tax_Rate2,Tax_Rate3,Tax_Rate4,Tax_Rate5,Tax_Rate6,[Enabled] AS Enabled_,Created_By,Created_Date,Updated_By,Updated_Date FROM SSRDividend SSRDividendSampling Approved_By,System.Int32 Approved_Date,System.DateTime Created_By,System.Int32 Created_Date,System.DateTime Dividend_No,System.Int32 Rejected_By,System.Int32 Rejected_Date,System.DateTime Sampling_No,System.Int32 Status_,System.String Stock_No,System.Int32 Submitted_By,System.Int32 Submitted_Date,System.DateTime Updated_by,System.Int32 Updated_Date,System.DateTime 30 SSRDividendSampling SymAppDatabase SELECT Sampling_No,Stock_No,Dividend_No,[Status] AS Status_,Created_By,Created_Date,Updated_by,Updated_Date,Submitted_By,Submitted_Date,Approved_By,Approved_Date,Rejected_By,Rejected_Date FROM SSRDividendSampling SSRDividendSamplingData CDS_Account,System.Int64 Created_By,System.Int32 Created_Date,System.DateTime File_Net_Dividend,System.Decimal Gross_Dividend1,System.Decimal Gross_Dividend2,System.Decimal Gross_Dividend3,System.Decimal Gross_Dividend4,System.Decimal Gross_Dividend5,System.Decimal Gross_Dividend6,System.Decimal Income_Tax1,System.Decimal Income_Tax2,System.Decimal Income_Tax3,System.Decimal Income_Tax4,System.Decimal Income_Tax5,System.Decimal Income_Tax6,System.Decimal Net_Dividend1,System.Decimal Net_Dividend2,System.Decimal Net_Dividend3,System.Decimal Net_Dividend4,System.Decimal Net_Dividend5,System.Decimal Net_Dividend6,System.Decimal Record_No,System.Int64 Sampling_No,System.Int64 Share_Holding,System.Int64 Tally_,System.Boolean Tax_Rate1,System.Decimal Tax_Rate2,System.Decimal Tax_Rate3,System.Decimal Tax_Rate4,System.Decimal Tax_Rate5,System.Decimal Tax_Rate6,System.Decimal Total_Gross_Dividend,System.Decimal Total_Income_Tax,System.Decimal Total_Net_Dividend,System.Decimal Updated_By,System.Int32 Updated_Date,System.DateTime 30 SSRDividendSamplingData SymAppDatabase SELECT Record_No,Sampling_No,CDS_Account,Share_Holding,Tax_Rate1,Tax_Rate2,Tax_Rate3,Tax_Rate4,Tax_Rate5,Tax_Rate6,Gross_Dividend1,Gross_Dividend2,Gross_Dividend3,Gross_Dividend4,Gross_Dividend5,Gross_Dividend6,Income_Tax1,Income_Tax2,Income_Tax3,Income_Tax4,Income_Tax5,Income_Tax6,Net_Dividend1,Net_Dividend2,Net_Dividend3,Net_Dividend4,Net_Dividend5,Net_Dividend6,Total_Gross_Dividend,Total_Income_Tax,Total_Net_Dividend,File_Net_Dividend,[Tally] AS Tally_,Created_By,Created_Date,Updated_By,Updated_Date FROM SSRDividendSamplingData SSRDividendSamplingData12312 CDS_Account,System.Int32 Created_By,System.Int32 Created_Date,System.DateTime File_Net_Dividend,System.Decimal Gross_Dividend1,System.Decimal Gross_Dividend2,System.Decimal Gross_Dividend3,System.Decimal Gross_Dividend4,System.Decimal Gross_Dividend5,System.Decimal Gross_Dividend6,System.Decimal Income_Tax1,System.Decimal Income_Tax2,System.Decimal Income_Tax3,System.Decimal Income_Tax4,System.Decimal Income_Tax5,System.Decimal Income_Tax6,System.Decimal Net_Dividend1,System.Decimal Net_Dividend2,System.Decimal Net_Dividend3,System.Decimal Net_Dividend4,System.Decimal Net_Dividend5,System.Decimal Net_Dividend6,System.Decimal Record_No,System.Int64 Sampling_No,System.Int32 Share_Holding,System.Int64 Tally_,System.Boolean Tax_Rate1,System.Decimal Tax_Rate2,System.Decimal Tax_Rate3,System.Decimal Tax_Rate4,System.Decimal Tax_Rate5,System.Decimal Tax_Rate6,System.Decimal Total_Gross_Dividend,System.Decimal Total_Income_Tax,System.Decimal Total_Net_Dividend,System.Decimal Updated_By,System.Int32 Updated_Date,System.DateTime 30 SSRDividendSamplingData12312 SymAppDatabase SELECT Record_No,Sampling_No,CDS_Account,Share_Holding,Tax_Rate1,Tax_Rate2,Tax_Rate3,Tax_Rate4,Tax_Rate5,Tax_Rate6,Gross_Dividend1,Gross_Dividend2,Gross_Dividend3,Gross_Dividend4,Gross_Dividend5,Gross_Dividend6,Income_Tax1,Income_Tax2,Income_Tax3,Income_Tax4,Income_Tax5,Income_Tax6,Net_Dividend1,Net_Dividend2,Net_Dividend3,Net_Dividend4,Net_Dividend5,Net_Dividend6,Total_Gross_Dividend,Total_Income_Tax,Total_Net_Dividend,File_Net_Dividend,[Tally] AS Tally_,Created_By,Created_Date,Updated_By,Updated_Date FROM SSRDividendSamplingData12312 SSRDividendSamplingFile Created_By,System.Int32 Created_Date,System.DateTime DataFile_No,System.Int32 File_Name,System.String File_No,System.Int32 Full_File_Name,System.String Sampling_No,System.Int32 Updated_By,System.Int32 Updated_Date,System.DateTime 30 SSRDividendSamplingFile SymAppDatabase SELECT DataFile_No,Sampling_No,File_No,File_Name,Full_File_Name,Created_By,Created_Date,Updated_By,Updated_Date FROM SSRDividendSamplingFile SSRFile Created_By,System.Int32 Created_Date,System.DateTime Delimiter_Char,System.String Enabled_,System.Boolean File_Category,System.String File_Code,System.String File_Format,System.String File_Name,System.String File_No,System.Int32 File_Type,System.String Footer_Exist,System.Boolean Header_Exist,System.Boolean Updated_By,System.Int32 Updated_Date,System.DateTime 30 SSRFile SymAppDatabase SELECT File_No,File_Code,File_Name,File_Type,File_Format,File_Category,[Enabled] AS Enabled_,Delimiter_Char,Header_Exist,Footer_Exist,Updated_By,Updated_Date,Created_By,Created_Date FROM SSRFile SSRFileComparisonA Compare_to,System.Int32 Created_By,System.Int32 Created_Date,System.DateTime DataFile_No,System.Int32 File_Name,System.String File_No,System.Int32 File_Ref,System.Int32 Full_File_Name,System.String RejectFile_No,System.Int32 Updated_By,System.Int32 Updated_Date,System.DateTime 30 SSRFileComparisonA SymAppDatabase SELECT DataFile_No,RejectFile_No,File_Ref,File_No,File_Name,Full_File_Name,Compare_to,Created_By,Created_Date,Updated_By,Updated_Date FROM SSRFileComparisonA SSRFileComparisonB Compare_to,System.Int32 Created_By,System.Int32 Created_Date,System.DateTime DataFile_No,System.Int32 File_Name,System.String File_No,System.Int32 File_Ref,System.Int32 Full_File_Name,System.String RejectFile_No,System.Int32 Updated_By,System.Int32 Updated_Date,System.DateTime 30 SSRFileComparisonB SymAppDatabase SELECT DataFile_No,RejectFile_No,File_Ref,File_No,File_Name,Full_File_Name,Compare_to,Created_By,Created_Date,Updated_By,Updated_Date FROM SSRFileComparisonB SSRFileComparisonDtl Created_By,System.Int32 Created_Date,System.DateTime DataFile_No,System.Int32 File_Name,System.String File_No,System.Int32 Full_File_Name,System.String RejectFile_No,System.Int32 Updated_By,System.Int32 Updated_Date,System.DateTime 30 SSRFileComparisonDtl SymAppDatabase SELECT DataFile_No,RejectFile_No,File_No,File_Name,Full_File_Name,Created_By,Created_Date,Updated_By,Updated_Date FROM SSRFileComparisonDtl SSRFileData Bank_Account,System.String CDS_Account,System.String Created_By,System.Int32 Created_Date,System.DateTime DataFile_No,System.Int32 IncDistributeTaxRate_1,System.Decimal IncDistributeTaxRate_2,System.Decimal IncDistributeTaxRate_3,System.Decimal IncDistributeTaxRate_4,System.Decimal IncDistributeTaxRate_5,System.Decimal IncDistributeTaxRate_6,System.Decimal Investor_Name,System.String PMEMNO_,System.String Sampling_No,System.Int32 Share_Holding,System.Decimal Stock_Code,System.String Total_Amount,System.Decimal Updated_By,System.Int32 Updated_Date,System.DateTime 30 SSRFileData SymAppDatabase SELECT Sampling_No,DataFile_No,Stock_Code,CDS_Account,[PMEMNO] AS PMEMNO_,Investor_Name,Bank_Account,Share_Holding,Total_Amount,IncDistributeTaxRate_1,IncDistributeTaxRate_2,IncDistributeTaxRate_3,IncDistributeTaxRate_4,IncDistributeTaxRate_5,IncDistributeTaxRate_6,Created_By,Created_Date,Updated_By,Updated_Date FROM SSRFileData SSRFileFormat Column_Descr,System.String Column_Name,System.String Column_No,System.Int32 Created_By,System.Int32 Created_Date,System.DateTime Data_Length,System.String Data_Type,System.String File_No,System.Int32 File_Section,System.String From_Pos,System.String Primary_Key,System.Boolean Recon_,System.Boolean Required_,System.Boolean Special_Indicator,System.String To_Pos,System.String Updated_By,System.Int32 Updated_Date,System.DateTime 30 SSRFileFormat SymAppDatabase SELECT File_No,File_Section,Column_No,Column_Name,Column_Descr,Data_Type,From_Pos,To_Pos,Data_Length,[Required] AS Required_,Primary_Key,[Recon] AS Recon_,Special_Indicator,Updated_By,Updated_Date,Created_By,Created_Date FROM SSRFileFormat SSRFileRecon Dividend_No,System.Int32 File_Name1,System.String File_Name2,System.String File_Name3,System.String File_Name4,System.String File_No1,System.Int32 File_No2,System.Int32 File_No3,System.Int32 File_No4,System.Int32 Recon_By,System.Int32 Recon_Date,System.DateTime Recon_No,System.Int32 Stock_No,System.Int32 30 SSRFileRecon SymAppDatabase SELECT Recon_No,Stock_No,Dividend_No,File_No1,File_Name1,File_No2,File_Name2,File_No3,File_Name3,File_No4,File_Name4,Recon_By,Recon_Date FROM SSRFileRecon SSRFileReconFiles Created_By,System.Int32 Created_Date,System.DateTime DataFile_No,System.Int32 File_Name,System.String File_No,System.Int32 Full_File_Name,System.String Recon_No,System.Int32 Updated_By,System.Int32 Updated_Date,System.DateTime 30 SSRFileReconFiles SymAppDatabase SELECT DataFile_No,Recon_No,File_No,File_Name,Full_File_Name,Created_By,Created_Date,Updated_By,Updated_Date FROM SSRFileReconFiles SSRHashControlChkDtl Created_By,System.Int32 Created_Date,System.DateTime File_Name,System.String File_No,System.Int32 Full_File_Name,System.String Recon_No,System.Int32 ReconDtl_No,System.Int32 Total_Share,System.Decimal Updated_By,System.Int32 Updated_Date,System.DateTime 30 SSRHashControlChkDtl SymAppDatabase SELECT ReconDtl_No,Recon_No,File_No,File_Name,Full_File_Name,Total_Share,Created_By,Created_Date,Updated_By,Updated_Date FROM SSRHashControlChkDtl SSRHashControlChkMst Cds_hash,System.Decimal Created_By,System.Int32 Created_Date,System.DateTime Dividend_No,System.Int32 File_Pay,System.Decimal Net_Pay,System.Decimal No_Record,System.Int32 Recon_No,System.Int32 Stock_No,System.Int32 Total_Share,System.Decimal TotalWarrant_,System.Int32 Updated_By,System.Int32 Updated_Date,System.DateTime 30 SSRHashControlChkMst SymAppDatabase SELECT Recon_No,Stock_No,Dividend_No,No_Record,Total_Share,Cds_hash,Net_Pay,File_Pay,[TotalWarrant] AS TotalWarrant_,Created_By,Created_Date,Updated_By,Updated_Date FROM SSRHashControlChkMst SSRHashTotal Company_,System.String Control_Req_No,System.String Created_By,System.String Created_Date,System.DateTime File_Transfer_Date,System.String Filler_,System.String Hash_No,System.Int32 Lodgement_Date,System.String No_Of_Records,System.String Reference_Number,System.String Total_Hash_Acc_No,System.String Total_Quantity,System.String 30 SSRHashTotal SymAppDatabase SELECT Hash_No,Reference_Number,No_Of_Records,Total_Quantity,Total_Hash_Acc_No,Control_Req_No,File_Transfer_Date,Lodgement_Date,[Filler] AS Filler_,Created_By,Created_Date,[Company] AS Company_ FROM SSRHashTotal SSRInward Beneficial_Owner,System.String CDS_Branch,System.String CDS_No,System.String Client_code,System.String Clients_No,System.Int32 Counter_,System.String Created_By,System.Int32 Created_Date,System.DateTime DC_CR,System.String Quantity_,System.String Reference_No,System.String Stock_No,System.String Transferor_,System.String Trx_Date,System.String Trx_Type,System.String 30 SSRInward SymAppDatabase SELECT Clients_No,Client_code,Beneficial_Owner,CDS_Branch,CDS_No,[Counter] AS Counter_,Stock_No,Reference_No,Trx_Date,[Quantity] AS Quantity_,[Transferor] AS Transferor_,Trx_Type,DC_CR,Created_By,Created_Date FROM SSRInward SSRInwardDBFCheck ADABRHCODE_,System.String ADACODE_,System.String BATCH_,System.String BATDATE_,System.String BOCODE_,System.String CALC_CASH,System.String CALC_SHRO,System.String CALC_SHRW,System.String CDP_ACC,System.String CDP_NAME,System.String CDP_NAMEBO,System.String CDP_NATION,System.String CDP_NRIC,System.String CDP_OPTION,System.String CDSACCOUNT_,System.String CTRY_,System.String FTFDATE_,System.String FTFREF_,System.String IC_,System.String IND_,System.String ITEMNO_,System.String MEMNO_,System.String NADD1_,System.String NADD2_,System.String NADD3_,System.String NADD4_,System.String NADD5_,System.String NADD6_,System.String NATION_,System.String OFFER_CASH,System.String OFFER_SHR,System.String OLDIC_,System.String POSCODE_,System.String RACE_,System.String TYPE_,System.String VALSTATU_,System.String 30 SSRInwardDBFCheck SymAppDatabase SELECT [ITEMNO] AS ITEMNO_,[MEMNO] AS MEMNO_,[NADD1] AS NADD1_,[NADD2] AS NADD2_,[NADD3] AS NADD3_,[NADD4] AS NADD4_,[NADD5] AS NADD5_,[NADD6] AS NADD6_,[POSCODE] AS POSCODE_,[IC] AS IC_,[CTRY] AS CTRY_,[NATION] AS NATION_,[RACE] AS RACE_,[TYPE] AS TYPE_,[IND] AS IND_,[OLDIC] AS OLDIC_,[ADACODE] AS ADACODE_,[ADABRHCODE] AS ADABRHCODE_,[CDSACCOUNT] AS CDSACCOUNT_,[BOCODE] AS BOCODE_,[BATCH] AS BATCH_,[BATDATE] AS BATDATE_,[FTFDATE] AS FTFDATE_,[FTFREF] AS FTFREF_,OFFER_CASH,OFFER_SHR,CALC_CASH,CALC_SHRO,CALC_SHRW,[VALSTATU] AS VALSTATU_,CDP_OPTION,CDP_NAME,CDP_NRIC,CDP_NATION,CDP_ACC,CDP_NAMEBO FROM SSRInwardDBFCheck SSRInwardFileChecking Batch_No,System.String Created_By,System.Int32 Created_Date,System.DateTime DataFile_No,System.Int32 File_Name,System.String Full_File_Name,System.String Updated_By,System.Int32 Updated_Date,System.DateTime 30 SSRInwardFileChecking SymAppDatabase SELECT DataFile_No,Batch_No,File_Name,Full_File_Name,Created_By,Created_Date,Updated_By,Updated_Date FROM SSRInwardFileChecking SSRInwardSpliting Batch_no,System.String Cash_,System.Int32 Clients_no,System.String Share_,System.Int32 Split_No,System.Int32 TotalShare_,System.Int32 Updated_By,System.Int32 Updated_Date,System.DateTime 30 SSRInwardSpliting SymAppDatabase SELECT Split_No,Clients_no,[Share] AS Share_,[Cash] AS Cash_,[TotalShare] AS TotalShare_,Batch_no,Updated_By,Updated_Date FROM SSRInwardSpliting SSRNetPayReconDtl Created_By,System.Int32 Created_Date,System.DateTime File_Name,System.String File_No,System.Int32 Full_File_Name,System.String Recon_No,System.Int32 ReconDtl_No,System.Int32 Total_Pay,System.Decimal Updated_By,System.Int32 Updated_Date,System.DateTime 30 SSRNetPayReconDtl SymAppDatabase SELECT ReconDtl_No,Recon_No,File_No,File_Name,Full_File_Name,Total_Pay,Created_By,Created_Date,Updated_By,Updated_Date FROM SSRNetPayReconDtl SSRNetPayReconMst Created_By,System.Int32 Created_Date,System.DateTime Dividend_No,System.Int32 File_Pay,System.Decimal Net_Pay,System.Decimal Recon_No,System.Int32 Stock_No,System.Int32 TotalWarrant_,System.Int32 Updated_By,System.Int32 Updated_Date,System.DateTime 30 SSRNetPayReconMst SymAppDatabase SELECT Recon_No,Stock_No,Dividend_No,Net_Pay,File_Pay,[TotalWarrant] AS TotalWarrant_,Created_By,Created_Date,Updated_By,Updated_Date FROM SSRNetPayReconMst SSRReconErrorLog CDS_Account,System.String Column_No,System.Int32 Created_By,System.Int32 Created_Date,System.DateTime Dividend_No,System.Int32 ErrLog_No,System.Int32 Error_Msg,System.String Recon_No,System.Int32 Row_Content,System.String Row_No,System.Int32 Source_File,System.String Stock_Code,System.String Stock_No,System.Int32 Target_File,System.String 30 SSRReconErrorLog SymAppDatabase SELECT ErrLog_No,Recon_No,Stock_No,Dividend_No,Row_No,Column_No,CDS_Account,Stock_Code,Source_File,Target_File,Error_Msg,Row_Content,Created_By,Created_Date FROM SSRReconErrorLog SSRReconHistory Dividend_No,System.Int32 Done_Status,System.Boolean File_No1,System.Int32 File_No2,System.Int32 File_No3,System.Int32 File_No4,System.Int32 File_No5,System.Int32 File_No6,System.Int32 File1_,System.String File2_,System.String File3_,System.String File4_,System.String File5_,System.String File6_,System.String Recon_By,System.Int32 Recon_Date,System.DateTime Recon_No,System.Int32 Stock_No,System.Int32 30 SSRReconHistory SymAppDatabase SELECT Recon_No,Stock_No,Dividend_No,File_No1,[File1] AS File1_,File_No2,[File2] AS File2_,File_No3,[File3] AS File3_,File_No4,[File4] AS File4_,File_No5,[File5] AS File5_,File_No6,[File6] AS File6_,Recon_By,Recon_Date,Done_Status FROM SSRReconHistory SSRRejectFiles Created_By,System.Int32 Created_Date,System.DateTime DataFile_No,System.Int32 File_Name,System.String File_No,System.Int32 Full_File_Name,System.String RejectFile_No,System.Int32 Updated_By,System.Int32 Updated_Date,System.DateTime 30 SSRRejectFiles SymAppDatabase SELECT DataFile_No,RejectFile_No,File_No,File_Name,Full_File_Name,Created_By,Created_Date,Updated_By,Updated_Date FROM SSRRejectFiles SSRStock Acceptable_Range,System.Decimal Active_,System.Boolean Company_CDS,System.String Company_Name,System.String Company_No,System.Int32 Created_By,System.Int32 Created_Date,System.DateTime Sampling_No,System.Int32 Stock_Code,System.String Stock_Name,System.String Stock_No,System.Int32 Updated_By,System.Int32 Updated_Date,System.DateTime 30 SSRStock SymAppDatabase SELECT Stock_No,Company_Name,Company_No,Company_CDS,Stock_Name,Stock_Code,Sampling_No,Acceptable_Range,[Active] AS Active_,Updated_By,Updated_Date,Created_By,Created_Date FROM SSRStock SSRTANJMYS ADABRHCODE_,System.String ADACODE_,System.String ADANAME_,System.String ADDR1_,System.String ADDR2_,System.String ADDR3_,System.String ALLOWDUP_,System.String COUNTCODE_,System.String DELIVERY_,System.String GROSS1_,System.String GROSS2_,System.String GROSS3_,System.String GROSS4_,System.String GROSS5_,System.String GROSS6_,System.String HEIR_,System.String IC_,System.String MAIL_CTRY,System.String MEMNO_,System.String NAME_,System.String NAMEQUAL_,System.String NATION_,System.String NET1_,System.String NET2_,System.String NET3_,System.String NET4_,System.String NET5_,System.String NET6_,System.String OLD_INV_ID,System.String PHONE_,System.String PMEMNO_,System.String POSCODE_,System.String RACE_,System.String REJECTCODE_,System.String SERIALNO_,System.String SHARE_,System.String STATECODE_,System.String STATUSCODE_,System.String STOCKCODE_,System.String TAX1_,System.String TAX2_,System.String TAX3_,System.String TAX4_,System.String TAX5_,System.String TAX6_,System.String TAXRATE1_,System.String TAXRATE2_,System.String TAXRATE3_,System.String TAXRATE4_,System.String TOTNET_,System.String TYPE_,System.String 30 SSRTANJMYS SymAppDatabase SELECT [IC] AS IC_,[ADACODE] AS ADACODE_,[ADABRHCODE] AS ADABRHCODE_,[ADANAME] AS ADANAME_,[MEMNO] AS MEMNO_,[NAME] AS NAME_,[ADDR1] AS ADDR1_,[ADDR2] AS ADDR2_,[ADDR3] AS ADDR3_,[POSCODE] AS POSCODE_,[STATECODE] AS STATECODE_,[COUNTCODE] AS COUNTCODE_,[NATION] AS NATION_,[RACE] AS RACE_,[TYPE] AS TYPE_,[PHONE] AS PHONE_,[STOCKCODE] AS STOCKCODE_,[SERIALNO] AS SERIALNO_,[SHARE] AS SHARE_,[STATUSCODE] AS STATUSCODE_,[HEIR] AS HEIR_,[NAMEQUAL] AS NAMEQUAL_,[ALLOWDUP] AS ALLOWDUP_,[REJECTCODE] AS REJECTCODE_,OLD_INV_ID,[PMEMNO] AS PMEMNO_,MAIL_CTRY,[GROSS1] AS GROSS1_,[GROSS2] AS GROSS2_,[GROSS3] AS GROSS3_,[GROSS4] AS GROSS4_,[GROSS5] AS GROSS5_,[GROSS6] AS GROSS6_,[TAX1] AS TAX1_,[TAX2] AS TAX2_,[TAX3] AS TAX3_,[TAX4] AS TAX4_,[TAX5] AS TAX5_,[TAX6] AS TAX6_,[NET1] AS NET1_,[NET2] AS NET2_,[NET3] AS NET3_,[NET4] AS NET4_,[NET5] AS NET5_,[NET6] AS NET6_,[TOTNET] AS TOTNET_,[DELIVERY] AS DELIVERY_,[TAXRATE1] AS TAXRATE1_,[TAXRATE2] AS TAXRATE2_,[TAXRATE3] AS TAXRATE3_,[TAXRATE4] AS TAXRATE4_ FROM SSRTANJMYS SSRTANJUK _1E_13_,System.String C1_,System.String CP01_,System.String CRE06_,System.String Delivery_,System.String Design05_,System.String G_,System.String H_,System.String IVC_CODE_03_,System.String Joint_Holder_1_Name_Line_1_,System.String Joint_Holder_2_Name_Line_1_,System.String Joint_Holder_3_Name_Line_1_,System.String Main_Holder_Address_Line_1_,System.String Main_Holder_Address_Line_2_,System.String Main_Holder_Address_Line_3_,System.String Main_Holder_Address_Line_4_,System.String Main_Holder_Address_Line_5_,System.String Main_Holder_Name_Line_1_,System.String Main_Holder_Name_Line_2_,System.String Main_Holder_Name_Line_3_,System.String Main_Holder_Name_Line_4_,System.String Main_Holder_Name_Line_5_,System.String MainPC66_,System.String Pound_Sterling_,System.String Ringgit_Malaysia_,System.String T_,System.String 30 SSRTANJUK SymAppDatabase SELECT [CP01] AS CP01_,[IVC-CODE-03] AS IVC_CODE_03_,[CRE06] AS CRE06_,[Main Holder Name Line 1] AS Main_Holder_Name_Line_1_,[Main Holder Name Line 2] AS Main_Holder_Name_Line_2_,[Main Holder Name Line 3] AS Main_Holder_Name_Line_3_,[Main Holder Name Line 4] AS Main_Holder_Name_Line_4_,[Main Holder Name Line 5] AS Main_Holder_Name_Line_5_,[Joint Holder 1 Name Line 1] AS Joint_Holder_1_Name_Line_1_,[Joint Holder 2 Name Line 1] AS Joint_Holder_2_Name_Line_1_,[Joint Holder 3 Name Line 1] AS Joint_Holder_3_Name_Line_1_,[Design05] AS Design05_,[Main Holder Address Line 1] AS Main_Holder_Address_Line_1_,[Main Holder Address Line 2] AS Main_Holder_Address_Line_2_,[Main Holder Address Line 3] AS Main_Holder_Address_Line_3_,[Main Holder Address Line 4] AS Main_Holder_Address_Line_4_,[Main Holder Address Line 5] AS Main_Holder_Address_Line_5_,[MainPC66] AS MainPC66_,[H] AS H_,[G] AS G_,[T] AS T_,[C1] AS C1_,[1E+13] AS _1E_13_,[Ringgit Malaysia] AS Ringgit_Malaysia_,[Pound Sterling] AS Pound_Sterling_,[Delivery] AS Delivery_ FROM SSRTANJUK TaskHeader Active_,System.Boolean Approved_By,System.Int32 Approved_Date,System.DateTime Company_,System.Int32 Created_By,System.Int32 Created_Date,System.DateTime Description_,System.String Include_PublicHoliday,System.Boolean Include_Weekend,System.Boolean Status_,System.String TaskHeader_No,System.Int32 Type_,System.String Updated_By,System.Int32 Updated_Date,System.DateTime Verified_By,System.Int32 Verified_Date,System.DateTime 30 TaskHeader SymAppDatabase SELECT TaskHeader_No,[Company] AS Company_,[Description] AS Description_,[Type] AS Type_,[Status] AS Status_,[Active] AS Active_,Include_PublicHoliday,Include_Weekend,Created_By,Created_Date,Updated_By,Updated_Date,Verified_By,Verified_Date,Approved_By,Approved_Date FROM TaskHeader TaskList Approval_Status,System.String Approver_Role,System.String ComplianceApprove_,System.Boolean Module_,System.String Owner_Role,System.String Sequence_,System.Int32 Task_Name,System.String TaskBlock_,System.String TaskDependency_,System.Int32 TaskHeader_No,System.Int32 TaskList_No,System.Int32 Updated_By,System.Int32 Updated_Date,System.DateTime WorkingDuration_,System.Int32 30 TaskList SymAppDatabase SELECT TaskList_No,TaskHeader_No,Task_Name,[Module] AS Module_,Approver_Role,Owner_Role,[ComplianceApprove] AS ComplianceApprove_,[Sequence] AS Sequence_,[WorkingDuration] AS WorkingDuration_,[TaskDependency] AS TaskDependency_,[TaskBlock] AS TaskBlock_,Approval_Status,Updated_By,Updated_Date FROM TaskList tblMailCategory Code_,System.String DateDeleted_,System.DateTime Deleted_,System.Int16 Desc_,System.String DisplayType_,System.String IsFreeText_,System.Boolean MailCategoryID_,System.Int32 Type_,System.Int16 30 tblMailCategory SymAppDatabase SELECT [MailCategoryID] AS MailCategoryID_,[Type] AS Type_,[Code] AS Code_,[Desc] AS Desc_,[IsFreeText] AS IsFreeText_,[DisplayType] AS DisplayType_,[Deleted] AS Deleted_,[DateDeleted] AS DateDeleted_ FROM tblMailCategory tblMailIntake BatchID_,System.Int32 DateDeleted_,System.DateTime Deleted_,System.String IntakeDate_,System.DateTime IntakeType_,System.String MailCategoryID_,System.Int32 MailIntakeID_,System.Int32 Quantity_,System.Int32 30 tblMailIntake SymAppDatabase SELECT [MailIntakeID] AS MailIntakeID_,[BatchID] AS BatchID_,[IntakeDate] AS IntakeDate_,[MailCategoryID] AS MailCategoryID_,[Quantity] AS Quantity_,[IntakeType] AS IntakeType_,[Deleted] AS Deleted_,[DateDeleted] AS DateDeleted_ FROM tblMailIntake tblPaymentType Amex_,System.Int32 Cash_,System.Int32 Cheque_,System.Int32 CreditCard_,System.Int32 CreditOrder_,System.Int32 DateDeleted_,System.DateTime Deleted_,System.Int16 GroupBy_,System.String MailIntakeID_,System.Int32 MO_,System.Int32 NoesWithEnv_,System.Int32 NoesWithoutEnv_,System.Int32 NoPayment_,System.Int32 NoSource_,System.Int32 PaymentTypeID_,System.Int32 PostDatedChq_,System.Int32 ProblemPayment_,System.Int32 Unidentified_,System.Int32 30 tblPaymentType SymAppDatabase SELECT [PaymentTypeID] AS PaymentTypeID_,[MailIntakeID] AS MailIntakeID_,[Cash] AS Cash_,[Cheque] AS Cheque_,[MO] AS MO_,[CreditCard] AS CreditCard_,[Amex] AS Amex_,[NoPayment] AS NoPayment_,[NoSource] AS NoSource_,[Unidentified] AS Unidentified_,[CreditOrder] AS CreditOrder_,[NoesWithEnv] AS NoesWithEnv_,[NoesWithoutEnv] AS NoesWithoutEnv_,[ProblemPayment] AS ProblemPayment_,[PostDatedChq] AS PostDatedChq_,[Deleted] AS Deleted_,[DateDeleted] AS DateDeleted_,[GroupBy] AS GroupBy_ FROM tblPaymentType tblPostStatement BatchID_,System.Int32 Country_,System.String CreatedBy_,System.String DateCreated_,System.DateTime DateDeleted_,System.DateTime DateUpdated_,System.DateTime Deleted_,System.Int16 GrossIntake_Comment,System.String NetIntake_Comment,System.String PostOffice_Comment,System.String PostStatementID_,System.Int32 ReceivedDate_,System.DateTime TotalBRE_,System.Int32 TotalRegMail_,System.Int32 UpdatedBy_,System.String 30 tblPostStatement SymAppDatabase SELECT [PostStatementID] AS PostStatementID_,[ReceivedDate] AS ReceivedDate_,[Country] AS Country_,[TotalBRE] AS TotalBRE_,[TotalRegMail] AS TotalRegMail_,[BatchID] AS BatchID_,[CreatedBy] AS CreatedBy_,[DateCreated] AS DateCreated_,[UpdatedBy] AS UpdatedBy_,[DateUpdated] AS DateUpdated_,[Deleted] AS Deleted_,[DateDeleted] AS DateDeleted_,PostOffice_Comment,GrossIntake_Comment,NetIntake_Comment FROM tblPostStatement tblReturnLog Damaged_,System.Boolean DateDeleted_,System.DateTime Deleted_,System.Int16 Good_,System.Boolean MailIntakeID_,System.Int32 ProdNo_,System.String ProdTitle_,System.String Quantity_,System.Int32 ReceivedDate_,System.DateTime Remarks_,System.String ReturnLogID_,System.Int32 30 tblReturnLog SymAppDatabase SELECT [ReturnLogID] AS ReturnLogID_,[ReceivedDate] AS ReceivedDate_,[ProdNo] AS ProdNo_,[ProdTitle] AS ProdTitle_,[Good] AS Good_,[Damaged] AS Damaged_,[Quantity] AS Quantity_,[Remarks] AS Remarks_,[MailIntakeID] AS MailIntakeID_,[Deleted] AS Deleted_,[DateDeleted] AS DateDeleted_ FROM tblReturnLog tblSurvey DateDeleted_,System.DateTime Deleted_,System.Int16 DeliveryAgent_,System.String Edition_,System.String Issue_,System.String MailIntakeID_,System.Int32 ReportMonth_,System.String SurveyID_,System.Int32 SurveyType_,System.String 30 tblSurvey SymAppDatabase SELECT [SurveyID] AS SurveyID_,[SurveyType] AS SurveyType_,[Edition] AS Edition_,[Issue] AS Issue_,[ReportMonth] AS ReportMonth_,[DeliveryAgent] AS DeliveryAgent_,[MailIntakeID] AS MailIntakeID_,[Deleted] AS Deleted_,[DateDeleted] AS DateDeleted_ FROM tblSurvey tblSurveyMagazine DateDeleted_,System.DateTime Deleted_,System.Int16 DespatchDate_,System.DateTime InsideKL_,System.Boolean NoOfDays_,System.Int32 opt_2_1,System.Boolean opt_2_2,System.Boolean opt_2_3,System.Boolean opt_2_4,System.Boolean OutsideKL_,System.Boolean ReceivedDate_,System.DateTime SurveyID_,System.Int32 SurveyMagazineID_,System.Int32 30 tblSurveyMagazine SymAppDatabase SELECT [SurveyMagazineID] AS SurveyMagazineID_,[DespatchDate] AS DespatchDate_,[ReceivedDate] AS ReceivedDate_,[NoOfDays] AS NoOfDays_,opt_2_1,opt_2_2,opt_2_3,opt_2_4,[InsideKL] AS InsideKL_,[OutsideKL] AS OutsideKL_,[SurveyID] AS SurveyID_,[Deleted] AS Deleted_,[DateDeleted] AS DateDeleted_ FROM tblSurveyMagazine tblSurveyMusic AccountID_,System.String DateDeleted_,System.DateTime Deleted_,System.Int16 SurveyID_,System.Int32 SurveyMusicID_,System.Int32 30 tblSurveyMusic SymAppDatabase SELECT [SurveyMusicID] AS SurveyMusicID_,[AccountID] AS AccountID_,[SurveyID] AS SurveyID_,[Deleted] AS Deleted_,[DateDeleted] AS DateDeleted_ FROM tblSurveyMusic tblSurveyProduct Comment_,System.String DateDeleted_,System.DateTime Deleted_,System.Int16 DespatchDate_,System.DateTime InsideKL_,System.Boolean NoOfDays_,System.Int32 opt_2_1,System.Boolean opt_2_2,System.Boolean opt_2_3,System.Boolean opt_2_4,System.Boolean opt_2_5,System.Boolean opt_3_1,System.Boolean opt_3_2,System.Boolean opt_4_1,System.Boolean opt_4_2,System.Boolean opt_4_3,System.Boolean opt_4_4,System.Boolean opt_5_1,System.Boolean opt_5_2,System.Boolean opt_6_1_1,System.Boolean opt_6_1_2,System.Boolean opt_6_1_3,System.Boolean opt_6_1_4,System.Boolean opt_6_2_1,System.Boolean opt_6_2_2,System.Boolean opt_6_2_3,System.Boolean opt_6_2_4,System.Boolean opt_6_3_1,System.Boolean opt_6_3_2,System.Boolean opt_6_3_3,System.Boolean opt_6_3_4,System.Boolean opt_7_1,System.Boolean opt_7_2,System.Boolean opt_7_3,System.Boolean OutsideKL_,System.Boolean ProductReceivedDate_,System.DateTime SurveyID_,System.Int32 SurveyProductID_,System.Int32 30 tblSurveyProduct SymAppDatabase SELECT [SurveyProductID] AS SurveyProductID_,[DespatchDate] AS DespatchDate_,[ProductReceivedDate] AS ProductReceivedDate_,[NoOfDays] AS NoOfDays_,opt_2_1,opt_2_2,opt_2_3,opt_2_4,opt_2_5,opt_3_1,opt_3_2,opt_4_1,opt_4_2,opt_4_3,opt_4_4,opt_5_1,opt_5_2,opt_6_1_1,opt_6_1_2,opt_6_1_3,opt_6_1_4,opt_6_2_1,opt_6_2_2,opt_6_2_3,opt_6_2_4,opt_6_3_1,opt_6_3_2,opt_6_3_3,opt_6_3_4,opt_7_1,opt_7_2,opt_7_3,[Comment] AS Comment_,[InsideKL] AS InsideKL_,[OutsideKL] AS OutsideKL_,[SurveyID] AS SurveyID_,[Deleted] AS Deleted_,[DateDeleted] AS DateDeleted_ FROM tblSurveyProduct Userlog Action_By,System.Int32 Finish_Date,System.DateTime Info_,System.String Start_Date,System.DateTime Type_,System.String User_No,System.Int32 30 Userlog SymAppDatabase SELECT User_No,Start_Date,Finish_Date,[Type] AS Type_,[Info] AS Info_,Action_By FROM Userlog UserPABX Calls_ACD,System.Int32 Calls_Extn,System.Int32 Extension_,System.String Login_,System.String Period_End,System.DateTime Period_Start,System.DateTime Time_AUX,System.Int32 Time_Avail,System.Int32 Time_Hold,System.Int32 Time_Staffed,System.Int32 Time_Talk,System.Int32 Time_Wrap,System.Int32 User_No,System.Int32 UserPABX_No,System.Int32 30 UserPABX SymAppDatabase SELECT UserPABX_No,User_No,[Login] AS Login_,[Extension] AS Extension_,Period_Start,Period_End,Calls_ACD,Calls_Extn,Time_AUX,Time_Staffed,Time_Avail,Time_Talk,Time_Wrap,Time_Hold FROM UserPABX Users Active_,System.String Address_1,System.String Address_2,System.String Address_3,System.String Captcha_,System.Boolean Card_No,System.String Company_Restrict,System.String Country_,System.String Created_By,System.Int32 Created_Date,System.DateTime Customer_Type,System.String DE_Type,System.String Email_,System.String Email_Groups,System.String Employee_No,System.String Expires_,System.DateTime Fax_,System.String Groups_,System.String Invalid_Logins,System.Int32 Last_IP,System.String Last_Login,System.DateTime Location_,System.Int32 Login_,System.String Mobile_,System.String Name_,System.String Name_W,System.String Password_,System.String Phone_,System.String Postal_Code,System.String Rec_Type,System.String Role_,System.String Skills_,System.String State_,System.String Supervisor_,System.Int32 Updated_By,System.Int32 Updated_Date,System.DateTime User_No,System.Int32 Vendor_No,System.Int32 30 Users SymAppDatabase SELECT User_No,[Name] AS Name_,[Phone] AS Phone_,[Fax] AS Fax_,[Mobile] AS Mobile_,Address_1,Address_2,Address_3,[State] AS State_,Postal_Code,[Country] AS Country_,[Email] AS Email_,[Login] AS Login_,[Password] AS Password_,[Expires] AS Expires_,[Active] AS Active_,Last_IP,Last_Login,Created_By,Created_Date,Updated_By,Updated_Date,[Location] AS Location_,Rec_Type,Company_Restrict,[Supervisor] AS Supervisor_,Employee_No,Name_W,Card_No,Invalid_Logins,[Groups] AS Groups_,[Skills] AS Skills_,Email_Groups,Customer_Type,[Role] AS Role_,Vendor_No,DE_Type,[Captcha] AS Captcha_ FROM Users VoucherReplacement CDS_Account,System.String Company_,System.Int32 Exercise_No,System.Int32 PreviousVoucher_No,System.Int32 Shareholder_no,System.Int32 Status_,System.String VoucherReplacement_,System.Int32 VoucherRequest_No,System.Int32 30 VoucherReplacement SymAppDatabase SELECT VoucherRequest_No,CDS_Account,Exercise_No,[Company] AS Company_,[VoucherReplacement] AS VoucherReplacement_,[Status] AS Status_,PreviousVoucher_No,Shareholder_no FROM VoucherReplacement vw_DataEntryData Access_,System.String Account_Qualifier,System.String Address_,System.String Address2_,System.String Allotment1_,System.Int32 Allotment2_,System.Int32 Allotment3_,System.Int32 Allotment4_,System.Int32 Allotment5_,System.Int32 Allotment6_,System.Int32 Allow_Duplicate,System.String Attend_,System.Int16 Bank_Account,System.String Bank_Name,System.String Bank_Swift_Code,System.String Batch_No,System.Int32 Beneficiary_Code,System.String Cap_Max,System.Int32 Cap_Min,System.Int32 CDS_Account,System.String Citibank_No,System.Int32 Code_,System.String Code_No,System.Int32 Company_,System.Int32 Completed_Date,System.DateTime Country_Code,System.String Created_By,System.Int32 Created_Date,System.DateTime Custom1_,System.String Custom2_,System.String Custom3_,System.String Custom4_,System.String Custom5_,System.String Custom6_,System.String DataEntry_By,System.Int32 DataEntry_Date,System.DateTime DataEntry_Envelope,System.Int32 DataEntry_PriRecord,System.Boolean DataEntry_Status,System.String DataEntry_SuplRecord,System.Int32 DataEntry_Trans_Type,System.String DataEntry_Type,System.String DataEntryBatch_No,System.Int32 DataEntryData_No,System.Int32 DE_Status,System.String DE_Unsealed,System.Boolean DE1_By,System.Int32 DE1_Complete,System.Int32 DE1_Lock_Date,System.DateTime DE1_Records,System.Int32 DE2_By,System.Int32 DE2_Complete,System.Int32 DE2_Lock_Date,System.DateTime DE2_Records,System.Int32 Delivery_,System.String Deposit_Date,System.DateTime Description_,System.String Description2_,System.String Details_,System.String Email_,System.String Employee_ID,System.Int32 Enabled_,System.Boolean Envelopes_,System.Int32 ExcessPayment_Received1,System.Decimal ExcessPayment_Received2,System.Decimal ExcessPayment_Received3,System.Decimal ExcessPayment_Received4,System.Decimal ExcessPayment_Received5,System.Decimal ExcessPayment_Received6,System.Decimal ExcessRef_No1,System.String ExcessRef_No2,System.String ExcessRef_No3,System.String ExcessRef_No4,System.String ExcessRef_No5,System.String ExcessRef_No6,System.String Exercise_No,System.Int32 Exported_By,System.Int32 Exported_Date,System.DateTime Expr1_,System.Int32 Expr10_,System.Int32 Expr11_,System.Byte Expr12_,System.String Expr13_,System.Int32 Expr14_,System.Int32 Expr15_,System.String Expr16_,System.Int32 Expr17_,System.DateTime Expr18_,System.Int32 Expr19_,System.Int32 Expr2_,System.Int32 Expr20_,System.Int32 Expr21_,System.Int32 Expr22_,System.Int32 Expr23_,System.Int32 Expr24_,System.Int32 Expr25_,System.Int32 Expr26_,System.Int32 Expr27_,System.Int32 Expr28_,System.Int32 Expr29_,System.Int32 Expr3_,System.Int32 Expr30_,System.Int32 Expr31_,System.Decimal Expr32_,System.Decimal Expr33_,System.Decimal Expr34_,System.Decimal Expr35_,System.Decimal Expr36_,System.Decimal Expr37_,System.Decimal Expr38_,System.Decimal Expr39_,System.Decimal Expr4_,System.Int32 Expr40_,System.Decimal Expr41_,System.Decimal Expr42_,System.Decimal Expr43_,System.String Expr44_,System.String Expr45_,System.String Expr46_,System.String Expr47_,System.String Expr48_,System.String Expr49_,System.String Expr5_,System.DateTime Expr50_,System.String Expr51_,System.String Expr52_,System.String Expr53_,System.String Expr54_,System.String Expr55_,System.String Expr56_,System.String Expr57_,System.String Expr58_,System.String Expr59_,System.String Expr6_,System.Int32 Expr60_,System.String Expr61_,System.String Expr62_,System.String Expr63_,System.String Expr64_,System.Int32 Expr65_,System.Int32 Expr66_,System.DateTime Expr7_,System.String Expr8_,System.Int32 Expr9_,System.Int32 Gift_,System.String Gross_Total,System.Decimal Gross1_,System.Decimal Gross2_,System.Decimal Gross3_,System.Decimal Gross4_,System.Decimal Gross5_,System.Decimal Gross6_,System.Decimal Hash_,System.String Images_,System.Int32 Import_By,System.Int32 Import_Date,System.DateTime Import_No,System.Int32 Investor_Id,System.String Investor_Type,System.String Joint_Account_indicator,System.String Language_,System.String Meps_Routing_Code,System.String Mismatches_,System.Int32 MMC_By,System.Int32 MMC_Lock_Date,System.DateTime Mobile_Number,System.String Mother_Share_Holding,System.Int32 Name_,System.String Nationality_Code,System.String Net_Total,System.Decimal Net1_,System.Decimal Net2_,System.Decimal Net3_,System.Decimal Net4_,System.Decimal Net5_,System.Decimal Net6_,System.Decimal NewIn2ndROD_,System.Int32 Notes_,System.String NotIn2ndROD_,System.Int32 OldInvestor_Id,System.String Participant_Branch_Code,System.Int32 Participant_Code,System.Int32 Participant_Name,System.String Payment_Received1,System.Decimal Payment_Received2,System.Decimal Payment_Received3,System.Decimal Payment_Received4,System.Decimal Payment_Received5,System.Decimal Payment_Received6,System.Decimal Post_Code,System.String Prev_Allotment1,System.Int64 Prev_Allotment2,System.Int64 Prev_Allotment3,System.Int64 Prev_Allotment4,System.Int64 Prev_Allotment5,System.Int64 Prev_Allotment6,System.Int64 Prev_Import,System.Int32 Prev_Net_Total,System.Decimal Prev_TakeUp_Allotment,System.Int32 Prev_TakeUp_Net_Total,System.Decimal Prev_TakeUp_Remainder,System.Decimal Proxy_No,System.Int32 RaceOwnership_Code,System.String Receive_Batch_No,System.Int32 Ref_No1,System.String Ref_No2,System.String Ref_No3,System.String Ref_No4,System.String Ref_No5,System.String Ref_No6,System.String Registered_Date,System.DateTime Rejection_Codes,System.String Sequence_,System.Int32 Serial_No,System.String Serial_Number,System.String Share_Allocation,System.Int32 Share_Unit,System.Int64 ShareHolder_No,System.Int32 ShareholderExerciseData_No,System.Int32 Source_Batch,System.Int32 Source_Type,System.Byte SourceIndicator_,System.String State_Code,System.String Status_,System.String Status_Code,System.String Stock_Code,System.String TakeUp_Allotment1,System.Int32 TakeUp_Allotment2,System.Int32 TakeUp_Allotment3,System.Int32 TakeUp_Allotment4,System.Int32 TakeUp_Allotment5,System.Int32 TakeUp_Allotment6,System.Int32 TakeUp_Excess,System.Int32 TakeUp_Excess_Alloc1,System.Int32 TakeUp_Excess_Alloc2,System.Int32 TakeUp_Excess_Alloc3,System.Int32 TakeUp_Excess_Alloc4,System.Int32 TakeUp_Excess_Alloc5,System.Int32 TakeUp_Excess_Alloc6,System.Int32 TakeUp_Excess_Req,System.Int32 TakeUp_Excess_Req1,System.Int32 TakeUp_Excess_Req2,System.Int32 TakeUp_Excess_Req3,System.Int32 TakeUp_Excess_Req4,System.Int32 TakeUp_Excess_Req5,System.Int32 TakeUp_Excess_Req6,System.Int32 TakeUp_Gross_Allotment,System.Decimal TakeUp_Gross_Excess,System.Decimal TakeUp_Gross_Total1,System.Decimal TakeUp_Gross_Total2,System.Decimal TakeUp_Gross_Total3,System.Decimal TakeUp_Gross_Total4,System.Decimal TakeUp_Gross_Total5,System.Decimal TakeUp_Gross_Total6,System.Decimal TakeUp_Net_Total1,System.Decimal TakeUp_Net_Total2,System.Decimal TakeUp_Net_Total3,System.Decimal TakeUp_Net_Total4,System.Decimal TakeUp_Net_Total5,System.Decimal TakeUp_Net_Total6,System.Decimal TakeUp_Remainder1,System.Decimal TakeUp_Remainder2,System.Decimal TakeUp_Remainder3,System.Decimal TakeUp_Remainder4,System.Decimal TakeUp_Remainder5,System.Decimal TakeUp_Remainder6,System.Decimal TakeUp_Requested,System.Int32 TakeUp_Requested1,System.Int32 TakeUp_Requested2,System.Int32 TakeUp_Requested3,System.Int32 TakeUp_Requested4,System.Int32 TakeUp_Requested5,System.Int32 TakeUp_Requested6,System.Int32 TakeUp_Tax_Total1,System.Decimal TakeUp_Tax_Total2,System.Decimal TakeUp_Tax_Total3,System.Decimal TakeUp_Tax_Total4,System.Decimal TakeUp_Tax_Total5,System.Decimal TakeUp_Tax_Total6,System.Decimal Task_Module,System.String Tax_Total,System.Decimal Tax1_,System.Decimal Tax2_,System.Decimal Tax3_,System.Decimal Tax4_,System.Decimal Tax5_,System.Decimal Tax6_,System.Decimal Telephone_Number,System.String Town_,System.String Transaction_Type,System.String UDC_List,System.String Unregistered_Date,System.DateTime Update_Pending_No,System.Int32 Updated_By,System.Int32 Updated_Date,System.DateTime Upload_By,System.Int32 Upload_Correction_By,System.Int32 Upload_Correction_Date,System.DateTime Upload_Date,System.DateTime Version_,System.Byte Version_Status,System.String Void_Count,System.Int32 Work_Unit_No,System.Int32 30 vw_DataEntryData SymAppDatabase SELECT DataEntryBatch_No,Transaction_Type,[Images] AS Images_,[Envelopes] AS Envelopes_,[Mismatches] AS Mismatches_,Upload_Date,Upload_By,Completed_Date,[Status] AS Status_,Work_Unit_No,Employee_ID,Exported_By,Exported_Date,Receive_Batch_No,DE1_Complete,DE2_Complete,DE1_By,DE1_Lock_Date,DE2_By,DE2_Lock_Date,MMC_By,MMC_Lock_Date,Upload_Correction_By,Upload_Correction_Date,DE1_Records,DE2_Records,Citibank_No,Deposit_Date,Exercise_No,[Company] AS Company_,Void_Count,Updated_Date,Updated_By,ShareHolder_No,Proxy_No,DataEntryData_No,[Expr1] AS Expr1_,DataEntry_PriRecord,DataEntry_Type,DataEntry_Trans_Type,DataEntry_Date,DataEntry_By,DataEntry_Status,DataEntry_Envelope,DataEntry_SuplRecord,[Expr2] AS Expr2_,[Expr3] AS Expr3_,CDS_Account,TakeUp_Requested,TakeUp_Excess_Req,[Notes] AS Notes_,DE_Status,Serial_No,Payment_Received1,Payment_Received2,Payment_Received3,Payment_Received4,Payment_Received5,Payment_Received6,Ref_No1,Ref_No2,Ref_No3,Ref_No4,Ref_No5,Ref_No6,TakeUp_Requested1,TakeUp_Requested2,TakeUp_Requested3,TakeUp_Requested4,TakeUp_Requested5,TakeUp_Requested6,[Custom1] AS Custom1_,[Custom2] AS Custom2_,[Custom3] AS Custom3_,[Custom4] AS Custom4_,[Custom5] AS Custom5_,[Custom6] AS Custom6_,ExcessPayment_Received1,ExcessPayment_Received2,ExcessPayment_Received3,ExcessPayment_Received4,ExcessPayment_Received5,ExcessPayment_Received6,ExcessRef_No1,ExcessRef_No2,ExcessRef_No3,ExcessRef_No4,ExcessRef_No5,ExcessRef_No6,TakeUp_Excess_Req1,TakeUp_Excess_Req2,TakeUp_Excess_Req3,TakeUp_Excess_Req4,TakeUp_Excess_Req5,TakeUp_Excess_Req6,[Expr4] AS Expr4_,[Name] AS Name_,Investor_Id,Share_Unit,[Address] AS Address_,Created_Date,Created_By,[Expr5] AS Expr5_,[Expr6] AS Expr6_,[Gift] AS Gift_,[Attend] AS Attend_,Share_Allocation,OldInvestor_Id,[Address2] AS Address2_,[Town] AS Town_,Post_Code,State_Code,Country_Code,[Expr7] AS Expr7_,Registered_Date,Unregistered_Date,[Expr8] AS Expr8_,Source_Batch,[NotIn2ndROD] AS NotIn2ndROD_,[NewIn2ndROD] AS NewIn2ndROD_,[SourceIndicator] AS SourceIndicator_,[Expr9] AS Expr9_,Import_No,Source_Type,Participant_Code,Participant_Branch_Code,Participant_Name,Nationality_Code,RaceOwnership_Code,Investor_Type,Telephone_Number,Stock_Code,Serial_Number,Status_Code,Beneficiary_Code,Account_Qualifier,Allow_Duplicate,Rejection_Codes,Mobile_Number,Bank_Account,Joint_Account_indicator,Meps_Routing_Code,Bank_Swift_Code,Bank_Name,[Email] AS Email_,Version_Status,Update_Pending_No,[Expr10] AS Expr10_,[Expr11] AS Expr11_,[Expr12] AS Expr12_,Import_Date,Import_By,[Expr13] AS Expr13_,[Expr14] AS Expr14_,[Version] AS Version_,[Hash] AS Hash_,[Details] AS Details_,[Enabled] AS Enabled_,Task_Module,Prev_Import,ShareholderExerciseData_No,[Expr15] AS Expr15_,[Expr16] AS Expr16_,Batch_No,[Expr17] AS Expr17_,[Expr18] AS Expr18_,[Allotment1] AS Allotment1_,[Allotment2] AS Allotment2_,[Allotment3] AS Allotment3_,[Allotment4] AS Allotment4_,[Allotment5] AS Allotment5_,[Allotment6] AS Allotment6_,Prev_Allotment1,Prev_Allotment2,Prev_Allotment3,Prev_Allotment4,Prev_Allotment5,Prev_Allotment6,[Expr19] AS Expr19_,[Expr20] AS Expr20_,[Expr21] AS Expr21_,[Expr22] AS Expr22_,[Expr23] AS Expr23_,[Expr24] AS Expr24_,TakeUp_Allotment1,TakeUp_Allotment2,TakeUp_Allotment3,TakeUp_Allotment4,TakeUp_Allotment5,TakeUp_Allotment6,[Expr25] AS Expr25_,[Expr26] AS Expr26_,[Expr27] AS Expr27_,[Expr28] AS Expr28_,[Expr29] AS Expr29_,[Expr30] AS Expr30_,TakeUp_Excess_Alloc1,TakeUp_Excess_Alloc2,TakeUp_Excess_Alloc3,TakeUp_Excess_Alloc4,TakeUp_Excess_Alloc5,TakeUp_Excess_Alloc6,TakeUp_Gross_Total1,TakeUp_Gross_Total2,TakeUp_Gross_Total3,TakeUp_Gross_Total4,TakeUp_Gross_Total5,TakeUp_Gross_Total6,TakeUp_Tax_Total1,TakeUp_Tax_Total2,TakeUp_Tax_Total3,TakeUp_Tax_Total4,TakeUp_Tax_Total5,TakeUp_Tax_Total6,TakeUp_Net_Total1,TakeUp_Net_Total2,TakeUp_Net_Total3,TakeUp_Net_Total4,TakeUp_Net_Total5,TakeUp_Net_Total6,TakeUp_Remainder1,TakeUp_Remainder2,TakeUp_Remainder3,TakeUp_Remainder4,TakeUp_Remainder5,TakeUp_Remainder6,[Expr31] AS Expr31_,[Expr32] AS Expr32_,[Expr33] AS Expr33_,[Expr34] AS Expr34_,[Expr35] AS Expr35_,[Expr36] AS Expr36_,[Expr37] AS Expr37_,[Expr38] AS Expr38_,[Expr39] AS Expr39_,[Expr40] AS Expr40_,[Expr41] AS Expr41_,[Expr42] AS Expr42_,[Gross1] AS Gross1_,[Gross2] AS Gross2_,[Gross3] AS Gross3_,[Gross4] AS Gross4_,[Gross5] AS Gross5_,[Gross6] AS Gross6_,Gross_Total,[Net1] AS Net1_,[Net2] AS Net2_,[Net3] AS Net3_,[Net4] AS Net4_,[Net5] AS Net5_,[Net6] AS Net6_,Net_Total,[Tax1] AS Tax1_,[Tax2] AS Tax2_,[Tax3] AS Tax3_,[Tax4] AS Tax4_,[Tax5] AS Tax5_,[Tax6] AS Tax6_,Tax_Total,[Delivery] AS Delivery_,[Expr43] AS Expr43_,DE_Unsealed,[Expr44] AS Expr44_,[Expr45] AS Expr45_,Prev_TakeUp_Allotment,Prev_TakeUp_Net_Total,Prev_TakeUp_Remainder,Prev_Net_Total,Mother_Share_Holding,TakeUp_Excess,TakeUp_Gross_Allotment,TakeUp_Gross_Excess,[Expr46] AS Expr46_,[Expr47] AS Expr47_,[Expr48] AS Expr48_,[Expr49] AS Expr49_,[Expr50] AS Expr50_,[Expr51] AS Expr51_,[Expr52] AS Expr52_,[Expr53] AS Expr53_,[Expr54] AS Expr54_,[Expr55] AS Expr55_,[Expr56] AS Expr56_,[Expr57] AS Expr57_,[Expr58] AS Expr58_,[Expr59] AS Expr59_,[Expr60] AS Expr60_,[Expr61] AS Expr61_,[Expr62] AS Expr62_,[Expr63] AS Expr63_,Code_No,UDC_List,[Code] AS Code_,[Description] AS Description_,[Description2] AS Description2_,[Language] AS Language_,[Expr64] AS Expr64_,[Expr65] AS Expr65_,[Expr66] AS Expr66_,[Sequence] AS Sequence_,[Access] AS Access_,Cap_Min,Cap_Max FROM vw_DataEntryData vw_DataEntrySummary Citibank_No,System.Int32 Company_,System.Int32 Completed_Date,System.DateTime DataEntryBatch_No,System.Int32 DE1_By,System.Int32 DE1_Complete,System.Int32 DE1_Lock_Date,System.DateTime DE1_Records,System.Int32 DE2_By,System.Int32 DE2_Complete,System.Int32 DE2_Lock_Date,System.DateTime DE2_Records,System.Int32 Deposit_Date,System.DateTime Employee_ID,System.Int32 Envelopes_,System.Int32 Exercise_No,System.Int32 Exported_By,System.Int32 Exported_Date,System.DateTime Images_,System.Int32 Mismatches_,System.Int32 MMC_By,System.Int32 MMC_Lock_Date,System.DateTime Proxy_No,System.Int32 Receive_Batch_No,System.Int32 Shareholder_No,System.Int32 Status_,System.String Status_Desc,System.String Transaction_Type,System.String Transaction_Type_Desc,System.String Updated_By,System.Int32 Updated_By_Name,System.String Updated_Date,System.DateTime Upload_By,System.Int32 Upload_Correction_By,System.Int32 Upload_Correction_Date,System.DateTime Upload_Date,System.DateTime Void_Count,System.Int32 Work_Unit_No,System.Int32 30 vw_DataEntrySummary SymAppDatabase SELECT DataEntryBatch_No,Transaction_Type,[Images] AS Images_,[Envelopes] AS Envelopes_,[Mismatches] AS Mismatches_,Upload_Date,Upload_By,Completed_Date,[Status] AS Status_,Work_Unit_No,Employee_ID,Exported_By,Exported_Date,Receive_Batch_No,DE1_Complete,DE2_Complete,DE1_By,DE1_Lock_Date,DE2_By,DE2_Lock_Date,MMC_By,MMC_Lock_Date,Upload_Correction_By,Upload_Correction_Date,DE1_Records,DE2_Records,Citibank_No,Deposit_Date,Void_Count,Updated_Date,Updated_By,[Company] AS Company_,Exercise_No,Shareholder_No,Proxy_No,Transaction_Type_Desc,Status_Desc,Updated_By_Name FROM vw_DataEntrySummary vw_ShareholderData Account_Qualifier,System.String Address_,System.String Address2_,System.String Allotment1_,System.Int32 Allotment2_,System.Int32 Allotment3_,System.Int32 Allotment4_,System.Int32 Allotment5_,System.Int32 Allotment6_,System.Int32 Allow_Duplicate,System.String Attend_,System.Int16 Bank_Account,System.String Bank_Name,System.String Bank_Swift_Code,System.String Batch_No,System.Int32 Beneficiary_Code,System.String CDS_Account,System.String Company_,System.Int32 Country_Code,System.String Created_By,System.Int32 Created_Date,System.DateTime Custom1_,System.String Custom2_,System.String Custom3_,System.String Custom4_,System.String Custom5_,System.String Custom6_,System.String DE_Status,System.String DE_Status_Desc,System.String DE_Unsealed,System.Boolean Delivery_,System.String Email_,System.String ExcessPayment_Received1,System.Decimal ExcessPayment_Received2,System.Decimal ExcessPayment_Received3,System.Decimal ExcessPayment_Received4,System.Decimal ExcessPayment_Received5,System.Decimal ExcessPayment_Received6,System.Decimal ExcessRef_No1,System.String ExcessRef_No2,System.String ExcessRef_No3,System.String ExcessRef_No4,System.String ExcessRef_No5,System.String ExcessRef_No6,System.String Exercise_No,System.Int32 Gift_,System.String Gross_Total,System.Decimal Gross1_,System.Decimal Gross2_,System.Decimal Gross3_,System.Decimal Gross4_,System.Decimal Gross5_,System.Decimal Gross6_,System.Decimal Import_No,System.Int32 Investor_Id,System.String Investor_Type,System.String Joint_Account_indicator,System.String Meps_Routing_Code,System.String Mobile_Number,System.String Mother_Share_Holding,System.Int32 Name_,System.String Nationality_Code,System.String Net_Total,System.Decimal Net1_,System.Decimal Net2_,System.Decimal Net3_,System.Decimal Net4_,System.Decimal Net5_,System.Decimal Net6_,System.Decimal NewIn2ndROD_,System.Int32 Notes_,System.String NotIn2ndROD_,System.Int32 OldInvestor_Id,System.String Participant_Branch_Code,System.Int32 Participant_Code,System.Int32 Participant_Name,System.String Payment_Received1,System.Decimal Payment_Received2,System.Decimal Payment_Received3,System.Decimal Payment_Received4,System.Decimal Payment_Received5,System.Decimal Payment_Received6,System.Decimal Post_Code,System.String Prev_Allotment1,System.Int64 Prev_Allotment2,System.Int64 Prev_Allotment3,System.Int64 Prev_Allotment4,System.Int64 Prev_Allotment5,System.Int64 Prev_Allotment6,System.Int64 Prev_Net_Total,System.Decimal Prev_TakeUp_Allotment,System.Int32 Prev_TakeUp_Net_Total,System.Decimal Prev_TakeUp_Remainder,System.Decimal RaceOwnership_Code,System.String Ref_No1,System.String Ref_No2,System.String Ref_No3,System.String Ref_No4,System.String Ref_No5,System.String Ref_No6,System.String Registered_Date,System.DateTime Rejection_Codes,System.String Serial_No,System.String Serial_Number,System.String Share_Allocation,System.Int32 Share_Unit,System.Int64 ShareHolder_No,System.Int32 ShareholderExerciseData_No,System.Int32 Source_Batch,System.Int32 Source_Type,System.Byte State_Code,System.String Status_Code,System.String Stock_Code,System.String TakeUp_Allotment1,System.Int32 TakeUp_Allotment2,System.Int32 TakeUp_Allotment3,System.Int32 TakeUp_Allotment4,System.Int32 TakeUp_Allotment5,System.Int32 TakeUp_Allotment6,System.Int32 TakeUp_Excess,System.Int32 TakeUp_Excess_Alloc1,System.Int32 TakeUp_Excess_Alloc2,System.Int32 TakeUp_Excess_Alloc3,System.Int32 TakeUp_Excess_Alloc4,System.Int32 TakeUp_Excess_Alloc5,System.Int32 TakeUp_Excess_Alloc6,System.Int32 TakeUp_Excess_Req1,System.Int32 TakeUp_Excess_Req2,System.Int32 TakeUp_Excess_Req3,System.Int32 TakeUp_Excess_Req4,System.Int32 TakeUp_Excess_Req5,System.Int32 TakeUp_Excess_Req6,System.Int32 TakeUp_Gross_Allotment,System.Decimal TakeUp_Gross_Excess,System.Decimal TakeUp_Gross_Total1,System.Decimal TakeUp_Gross_Total2,System.Decimal TakeUp_Gross_Total3,System.Decimal TakeUp_Gross_Total4,System.Decimal TakeUp_Gross_Total5,System.Decimal TakeUp_Gross_Total6,System.Decimal TakeUp_Net_Total1,System.Decimal TakeUp_Net_Total2,System.Decimal TakeUp_Net_Total3,System.Decimal TakeUp_Net_Total4,System.Decimal TakeUp_Net_Total5,System.Decimal TakeUp_Net_Total6,System.Decimal TakeUp_Remainder1,System.Decimal TakeUp_Remainder2,System.Decimal TakeUp_Remainder3,System.Decimal TakeUp_Remainder4,System.Decimal TakeUp_Remainder5,System.Decimal TakeUp_Remainder6,System.Decimal TakeUp_Requested1,System.Int32 TakeUp_Requested2,System.Int32 TakeUp_Requested3,System.Int32 TakeUp_Requested4,System.Int32 TakeUp_Requested5,System.Int32 TakeUp_Requested6,System.Int32 TakeUp_Tax_Total1,System.Decimal TakeUp_Tax_Total2,System.Decimal TakeUp_Tax_Total3,System.Decimal TakeUp_Tax_Total4,System.Decimal TakeUp_Tax_Total5,System.Decimal TakeUp_Tax_Total6,System.Decimal Tax_Total,System.Decimal Tax1_,System.Decimal Tax2_,System.Decimal Tax3_,System.Decimal Tax4_,System.Decimal Tax5_,System.Decimal Tax6_,System.Decimal Telephone_Number,System.String Town_,System.String Unregistered_Date,System.DateTime Update_Pending_No,System.Int32 Updated_By,System.Int32 Updated_Date,System.DateTime Version_Status,System.String 30 vw_ShareholderData SymAppDatabase SELECT ShareHolder_No,[Name] AS Name_,Investor_Id,Share_Unit,[Address] AS Address_,Created_Date,Created_By,Updated_Date,Updated_By,[Gift] AS Gift_,[Attend] AS Attend_,Share_Allocation,OldInvestor_Id,[Address2] AS Address2_,[Town] AS Town_,Post_Code,State_Code,Country_Code,CDS_Account,Registered_Date,Unregistered_Date,[Company] AS Company_,Source_Batch,[NotIn2ndROD] AS NotIn2ndROD_,[NewIn2ndROD] AS NewIn2ndROD_,Exercise_No,Import_No,Source_Type,Participant_Code,Participant_Branch_Code,Participant_Name,Nationality_Code,RaceOwnership_Code,Investor_Type,Telephone_Number,Stock_Code,Serial_Number,Status_Code,Beneficiary_Code,Account_Qualifier,Allow_Duplicate,Rejection_Codes,Mobile_Number,Bank_Account,Joint_Account_indicator,Meps_Routing_Code,Bank_Swift_Code,Bank_Name,[Email] AS Email_,Version_Status,Update_Pending_No,ShareholderExerciseData_No,Batch_No,[Allotment1] AS Allotment1_,[Allotment2] AS Allotment2_,[Allotment3] AS Allotment3_,[Allotment4] AS Allotment4_,[Allotment5] AS Allotment5_,[Allotment6] AS Allotment6_,Prev_Allotment1,Prev_Allotment2,Prev_Allotment3,Prev_Allotment4,Prev_Allotment5,Prev_Allotment6,TakeUp_Allotment1,TakeUp_Allotment2,TakeUp_Allotment3,TakeUp_Allotment4,TakeUp_Allotment5,TakeUp_Allotment6,TakeUp_Excess_Req1,TakeUp_Excess_Req2,TakeUp_Excess_Req3,TakeUp_Excess_Req4,TakeUp_Excess_Req5,TakeUp_Excess_Req6,TakeUp_Excess_Alloc1,TakeUp_Excess_Alloc2,TakeUp_Excess_Alloc3,TakeUp_Excess_Alloc4,TakeUp_Excess_Alloc5,TakeUp_Excess_Alloc6,TakeUp_Gross_Total1,TakeUp_Gross_Total2,TakeUp_Gross_Total3,TakeUp_Gross_Total4,TakeUp_Gross_Total5,TakeUp_Gross_Total6,TakeUp_Tax_Total1,TakeUp_Tax_Total2,TakeUp_Tax_Total3,TakeUp_Tax_Total4,TakeUp_Tax_Total5,TakeUp_Tax_Total6,TakeUp_Net_Total1,TakeUp_Net_Total2,TakeUp_Net_Total3,TakeUp_Net_Total4,TakeUp_Net_Total5,TakeUp_Net_Total6,TakeUp_Remainder1,TakeUp_Remainder2,TakeUp_Remainder3,TakeUp_Remainder4,TakeUp_Remainder5,TakeUp_Remainder6,Payment_Received1,Payment_Received2,Payment_Received3,Payment_Received4,Payment_Received5,Payment_Received6,ExcessPayment_Received1,ExcessPayment_Received2,ExcessPayment_Received3,ExcessPayment_Received4,ExcessPayment_Received5,ExcessPayment_Received6,TakeUp_Requested1,TakeUp_Requested2,TakeUp_Requested3,TakeUp_Requested4,TakeUp_Requested5,TakeUp_Requested6,[Gross1] AS Gross1_,[Gross2] AS Gross2_,[Gross3] AS Gross3_,[Gross4] AS Gross4_,[Gross5] AS Gross5_,[Gross6] AS Gross6_,Gross_Total,[Net1] AS Net1_,[Net2] AS Net2_,[Net3] AS Net3_,[Net4] AS Net4_,[Net5] AS Net5_,[Net6] AS Net6_,Net_Total,[Tax1] AS Tax1_,[Tax2] AS Tax2_,[Tax3] AS Tax3_,[Tax4] AS Tax4_,[Tax5] AS Tax5_,[Tax6] AS Tax6_,Tax_Total,[Delivery] AS Delivery_,Serial_No,DE_Unsealed,DE_Status,[Notes] AS Notes_,Prev_TakeUp_Allotment,Prev_TakeUp_Net_Total,Prev_TakeUp_Remainder,Prev_Net_Total,Mother_Share_Holding,TakeUp_Excess,TakeUp_Gross_Allotment,TakeUp_Gross_Excess,Ref_No1,Ref_No2,Ref_No3,Ref_No4,Ref_No5,Ref_No6,ExcessRef_No1,ExcessRef_No2,ExcessRef_No3,ExcessRef_No4,ExcessRef_No5,ExcessRef_No6,[Custom1] AS Custom1_,[Custom2] AS Custom2_,[Custom3] AS Custom3_,[Custom4] AS Custom4_,[Custom5] AS Custom5_,[Custom6] AS Custom6_,DE_Status_Desc FROM vw_ShareholderData EngineV2 Report_No,_x0035_9 None;Black;2;Solid;False;4;Black Transparent Transparent 0,0.4,19,0.8 Transparent 0.8,0.2,2.8,0.6 Arial,10 0,0,0,0 Text2 Company_ Black Transparent 4.6,0.2,2.8,0.6 Arial,10 0,0,0,0 Text4 Country_ Black Transparent 8.8,0.2,2.8,0.6 Arial,10 0,0,0,0 Text6 HolidayList_Name Black HeaderBand1 Transparent 0,2,19,1.4 Transparent 0.8,0.2,1.6,0.6 Arial,10 0,0,0,0 Text1 {HolidayList.Company_} Black Transparent 4.6,0.2,1.6,0.6 Arial,10 0,0,0,0 Text3 {HolidayList.Country_} Black Transparent 8.8,0.2,1.6,0.6 Arial,10 0,0,0,0 Text5 {HolidayList.HolidayList_Name} Black HolidayList DataBand1 57cc2f8e0d834e84b3ed46930d6fb39b 1,1,1,1 Page1 29.7 21 Arial,100 [50:0:0:0] System.Dll System.Drawing.Dll System.Windows.Forms.Dll System.Data.Dll System.Xml.Dll Stimulsoft.Controls.Dll Stimulsoft.Base.Dll Stimulsoft.Report.Dll C:\WINDOWS\Microsoft.NET\Framework\v2.0.50727\Temporary ASP.NET Files\root\0721ea12\8c2290e3\App_Code.o1v1sq2m.dll Steve - Testing 1 11/24/2011 2:12:38 PM 11/24/2011 2:10:51 PM Steve - Testing 1.mrt 90dfe7c7e22f409e4c55d434527a6f45 Steve - Testing 1 Centimeters 2011.3.1111 VB