internal HssUtility.SQLserver.DB_insert Get_DBinsert()
{
HssUtility.SQLserver.DB_insert dbIns = new HssUtility.SQLserver.DB_insert(ADR_Group_Member.Get_cmdTP());
dbIns.AddValue("GroupID", this.GroupID.Value);
dbIns.AddValue("OwnerSID", this.OwnerSID.Value);
return(dbIns);
}
internal HssUtility.SQLserver.DB_insert Get_DBinsert()
{
HssUtility.SQLserver.DB_insert dbIns = new HssUtility.SQLserver.DB_insert(ADR_Member_Country.Get_cmdTP());
dbIns.AddValue("TaskOwner_SID", this.TaskOwner_SID.Value);
dbIns.AddValue("ISO2CntryCode", this.ISO2CntryCode.Value);
return(dbIns);
}
internal HssUtility.SQLserver.DB_insert Get_DBinsert()
{
this.LastModifyAt.Value = DateTime.Now;
HssUtility.SQLserver.DB_insert dbIns = new HssUtility.SQLserver.DB_insert(Hss_UserConfig.Get_cmdTP());
dbIns.AddValue("UserName", this.UserName); /*Optional 2*/
dbIns.AddValue("ConfigXML", this.ConfigXML); /*Optional 3*/
dbIns.AddValue("LastModifyAt", this.LastModifyAt); /*Optional 4*/
return(dbIns);
}
internal HssUtility.SQLserver.DB_insert Get_DBinsert()
{
HssUtility.SQLserver.DB_insert dbIns = new HssUtility.SQLserver.DB_insert(ADR_Group.Get_cmdTP());
dbIns.AddValue("GroupName", this.GroupName.Value);
dbIns.AddValue("Group_LeaderSID", this.Group_LeaderSID.Value);
dbIns.AddValue("Group_Email", this.Group_Email);/*Optional 4*/
return(dbIns);
}
internal HssUtility.SQLserver.DB_insert Get_DBinsert()
{
HssUtility.SQLserver.DB_insert dbIns = new HssUtility.SQLserver.DB_insert(Dividend_Detail_full.Get_cmdTP());
dbIns.AddValue("DTC_Number", this.DTC_Number.Value);
dbIns.AddValue("Status", this.Status); /*Optional 27*/
dbIns.AddValue("RecordDatePosition", this.RecordDatePosition); /*Optional 30*/
dbIns.AddValue("Dividend_FilingID", this.Dividend_FilingID); /*Optional 37*/
return(dbIns);
}
internal HssUtility.SQLserver.DB_insert Get_DBinsert()
{
HssUtility.SQLserver.DB_insert dbIns = new HssUtility.SQLserver.DB_insert(Country_ProcedureTypes.Get_cmdTP());
dbIns.AddValue("IsSponsored", this.IsSponsored);/*Optional 2*/
dbIns.AddValue("At_Source", this.At_Source.Value);
dbIns.AddValue("Quick_Refund", this.Quick_Refund.Value);
dbIns.AddValue("Long_Form", this.Long_Form.Value);
return(dbIns);
}
internal HssUtility.SQLserver.DB_insert Get_DBinsert()
{
HssUtility.SQLserver.DB_insert dbIns = new HssUtility.SQLserver.DB_insert(TestClass.Get_cmdTP());
dbIns.AddValue("Name", this.Name); /*Optional 2*/
dbIns.AddValue("Birthday", this.Birthday); /*Optional 3*/
dbIns.AddValue("Salary", this.Salary); /*Optional 4*/
dbIns.AddValue("IsMarried", this.IsMarried); /*Optional 5*/
return(dbIns);
}
internal HssUtility.SQLserver.DB_insert Get_DBinsert()
{
HssUtility.SQLserver.DB_insert dbIns = new HssUtility.SQLserver.DB_insert(EDI_country.Get_cmdTP());
dbIns.AddValue("name", this.name); /*Optional 2*/
dbIns.AddValue("currency_id", this.currency_id); /*Optional 3*/
dbIns.AddValue("iso2_cd", this.iso2_cd); /*Optional 4*/
dbIns.AddValue("iso3_cd", this.iso3_cd); /*Optional 5*/
return(dbIns);
}
internal HssUtility.SQLserver.DB_insert Get_DBinsert()
{
HssUtility.SQLserver.DB_insert dbIns = new HssUtility.SQLserver.DB_insert(StatutoryRate_edi.Get_cmdTP());
dbIns.AddValue("coi", this.coi); /*Optional 2*/
dbIns.AddValue("cor", this.cor); /*Optional 3*/
dbIns.AddValue("statry_rt", this.statry_rt); /*Optional 4*/
dbIns.AddValue("int_rt", this.int_rt); /*Optional 5*/
dbIns.AddValue("effect_dt", this.effect_dt); /*Optional 6*/
dbIns.AddValue("created_dt", this.created_dt); /*Optional 7*/
dbIns.AddValue("modified_dt", this.modified_dt); /*Optional 8*/
dbIns.AddValue("migratedId", this.migratedId); /*Optional 9*/
dbIns.AddValue("sec_type", this.sec_type); /*Optional 10*/
dbIns.AddValue("bo_typ", this.bo_typ); /*Optional 11*/
return(dbIns);
}
internal HssUtility.SQLserver.DB_insert Get_DBinsert()
{
HssUtility.SQLserver.DB_insert dbIns = new HssUtility.SQLserver.DB_insert(DividendXBRL.Get_cmdTP());
dbIns.AddValue("DividendIndex", this.DividendIndex);
dbIns.AddValue("Depositary", this.Depositary); /*Optional 3*/
dbIns.AddValue("XBRL_ReferenceNumber", this.XBRL_ReferenceNumber);
dbIns.AddValue("PSAFE", this.PSAFE); /*Optional 5*/
dbIns.AddValue("LastModifiedDate", this.LastModifiedDate); /*Optional 6*/
dbIns.AddValue("SourceType", this.SourceType); /*Optional 7*/
dbIns.AddValue("LastModifiedBy", this.LastModifiedBy); /*Optional 8*/
dbIns.AddValue("Announcement Identifier", this.Announcement_Identifier); /*Optional 9*/
dbIns.AddValue("Event Completeness", this.Event_Completeness); /*Optional 10*/
return(dbIns);
}
internal HssUtility.SQLserver.DB_insert Get_DBinsert()
{
HssUtility.SQLserver.DB_insert dbIns = new HssUtility.SQLserver.DB_insert(Dividend_Detail_full.Get_cmdTP());
//dbIns.AddValue("DividendIndex", this.DividendIndex.Value);
dbIns.AddValue("DTC_Number", this.DTC_Number.Value);
//dbIns.AddValue("Depositary", this.Depositary);/*Optional 10*/
dbIns.AddValue("BO_COR", this.BO_COR); /*Optional 18*/
dbIns.AddValue("BO_EntityType", this.BO_EntityType); /*Optional 19*/
dbIns.AddValue("ReclaimRate", this.ReclaimRate); /*Optional 22*/
dbIns.AddValue("CustodianID", this.CustodianID); /*Optional 25*/
dbIns.AddValue("Status", this.Status); /*Optional 27*/
dbIns.AddValue("RecordDatePosition", this.RecordDatePosition); /*Optional 30*/
dbIns.AddValue("ReclaimFeesType", this.ReclaimFeesType); /*Optional 41*/
dbIns.AddValue("PaidViaDTCC", this.PaidViaDTCC); /*Optional 120*/
return(dbIns);
}
internal HssUtility.SQLserver.DB_insert Get_DBinsert()
{
HssUtility.SQLserver.DB_insert dbIns = new HssUtility.SQLserver.DB_insert(Hss_DailyJobs.Get_cmdTP());
dbIns.AddValue("Job_Class", this.Job_Class); /*Optional 2*/
dbIns.AddValue("Job_ID", this.Job_ID); /*Optional 3*/
dbIns.AddValue("LastRunAt", this.LastRunAt); /*Optional 4*/
dbIns.AddValue("LastRunBy", this.LastRunBy); /*Optional 5*/
dbIns.AddValue("Locked", this.Locked); /*Optional 6*/
dbIns.AddValue("Notes", this.Notes); /*Optional 7*/
dbIns.AddValue("LastLockAt", this.LastLockAt); /*Optional 8*/
dbIns.AddValue("LastLockBy", this.LastLockBy); /*Optional 9*/
return(dbIns);
}
internal HssUtility.SQLserver.DB_insert Get_DBinsert()
{
HssUtility.SQLserver.DB_insert dbIns = new HssUtility.SQLserver.DB_insert(Schedule_Of_Fees_Per_Rate.Get_cmdTP());
dbIns.AddValue("Security_Type", this.Security_Type); /*Optional 2*/
dbIns.AddValue("Depositary", this.Depositary);
dbIns.AddValue("WithholdingRate", this.WithholdingRate); /*Optional 4*/
dbIns.AddValue("ADSC", this.ADSC); /*Optional 5*/
dbIns.AddValue("RateWithADSC", this.RateWithADSC); /*Optional 6*/
dbIns.AddValue("EffectiveDate", this.EffectiveDate); /*Optional 7*/
dbIns.AddValue("CreatedDate", this.CreatedDate); /*Optional 8*/
dbIns.AddValue("ImportBy", this.ImportBy); /*Optional 9*/
return(dbIns);
}
internal HssUtility.SQLserver.DB_insert Get_DBinsert()
{
HssUtility.SQLserver.DB_insert dbIns = new HssUtility.SQLserver.DB_insert(DepositaryIdemnification.Get_cmdTP());
dbIns.AddValue("depositary_info_id", this.depositary_info_id.Value);
dbIns.AddValue("language_id", this.language_id.Value);
dbIns.AddValue("idemnification", this.idemnification.Value);
dbIns.AddValue("idemnification2", this.idemnification2.Value);
dbIns.AddValue("idemnification_di", this.idemnification_di.Value);
dbIns.AddValue("idemnification2_di", this.idemnification2_di.Value);
dbIns.AddValue("idemnification_russia", this.idemnification_russia.Value);/*Optional 8*/
return(dbIns);
}
internal HssUtility.SQLserver.DB_insert Get_DBinsert()
{
HssUtility.SQLserver.DB_insert dbIns = new HssUtility.SQLserver.DB_insert(ADR_TaskOwner.Get_cmdTP());
dbIns.AddValue("OwnerSID", this.OwnerSID.Value);
dbIns.AddValue("OwnerName", this.OwnerName.Value);
dbIns.AddValue("Owner_LastName", this.Owner_LastName); /*Optional 4*/
dbIns.AddValue("Owner_FirstName", this.Owner_FirstName); /*Optional 5*/
//dbIns.AddValue("AllProperties", this.AllProperties);/*Optional 6*/
dbIns.AddValue("Telephone", this.Telephone); /*Optional 7*/
dbIns.AddValue("Email", this.Email); /*Optional 8*/
dbIns.AddValue("Department", this.Department); /*Optional 9*/
dbIns.AddValue("Title", this.Title); /*Optional 10*/
//dbIns.AddValue("Signature", this.Signature);/*Optional 11*/
return(dbIns);
}
internal HssUtility.SQLserver.DB_insert Get_DBinsert()
{
HssUtility.SQLserver.DB_insert dbIns = new HssUtility.SQLserver.DB_insert(Country.Get_cmdTP());
dbIns.AddValue("cntry_cd", this.cntry_cd.Value);
dbIns.AddValue("currency_id", this.currency_id); /*Optional 3*/
dbIns.AddValue("longform_coefficient", this.longform_coefficient); /*Optional 5*/
dbIns.AddValue("In_ESP", this.In_ESP); /*Optional 6*/
dbIns.AddValue("ISO3_cntry_cd", this.ISO3_cntry_cd); /*Optional 7*/
dbIns.AddValue("GlobeTaxEmail", this.GlobeTaxEmail); /*Optional 8*/
return(dbIns);
}
internal HssUtility.SQLserver.DB_insert Get_DBinsert()
{
HssUtility.SQLserver.DB_insert dbIns = new HssUtility.SQLserver.DB_insert(Task21_security.Get_cmdTP());
dbIns.AddValue("SecurityID", this.SecurityID); /*Optional 2*/
dbIns.AddValue("TaskName", this.TaskName); /*Optional 3*/
dbIns.AddValue("Status", this.Status); /*Optional 4*/
dbIns.AddValue("ValueStr", this.ValueStr); /*Optional 5*/
dbIns.AddValue("CreateBy", this.CreateBy); /*Optional 6*/
dbIns.AddValue("CreateDate", this.CreateDate); /*Optional 7*/
return(dbIns);
}
internal HssUtility.SQLserver.DB_insert Get_DBinsert()
{
HssUtility.SQLserver.DB_insert dbIns = new HssUtility.SQLserver.DB_insert(DividendCustodian.Get_cmdTP());
dbIns.AddValue("Custodian_Number", this.Custodian_Number);/*Optional 2*/
dbIns.AddValue("DividendIndex", this.DividendIndex.Value);
dbIns.AddValue("Custodian", this.Custodian.Value);
dbIns.AddValue("Custodian_Reported", this.Custodian_Reported); /*Optional 5*/
dbIns.AddValue("Custodian_Paid", this.Custodian_Paid); /*Optional 6*/
dbIns.AddValue("FavAtSourceADRs", this.FavAtSourceADRs); /*Optional 7*/
dbIns.AddValue("ExemptAtSourceADRs", this.ExemptAtSourceADRs); /*Optional 8*/
dbIns.AddValue("FavTransparentEntityADRs", this.FavTransparentEntityADRs); /*Optional 9*/
dbIns.AddValue("Custodian_Chargeback", this.Custodian_Chargeback); /*Optional 10*/
dbIns.AddValue("SafeKeeping_AccountNum", this.SafeKeeping_AccountNum); /*Optional 11*/
dbIns.AddValue("Cash_Account_Number", this.Cash_Account_Number); /*Optional 12*/
dbIns.AddValue("Custodial_Fees", this.Custodial_Fees); /*Optional 13*/
dbIns.AddValue("AtSourceFeePerShare", this.AtSourceFeePerShare.Value);
dbIns.AddValue("Custodian_Type", this.Custodian_Type); /*Optional 15*/
dbIns.AddValue("Depositary", this.Depositary); /*Optional 16*/
dbIns.AddValue("Currency", this.Currency); /*Optional 17*/
dbIns.AddValue("Base", this.Base); /*Optional 18*/
dbIns.AddValue("Custodial_Percent", this.Custodial_Percent); /*Optional 19*/
dbIns.AddValue("Maximum_Fees", this.Maximum_Fees); /*Optional 20*/
dbIns.AddValue("Minimum_Fees", this.Minimum_Fees); /*Optional 21*/
dbIns.AddValue("Contact_Name", this.Contact_Name); /*Optional 22*/
dbIns.AddValue("Reference_Number", this.Reference_Number); /*Optional 23*/
dbIns.AddValue("Address1", this.Address1); /*Optional 24*/
dbIns.AddValue("Address2", this.Address2); /*Optional 25*/
dbIns.AddValue("State", this.State); /*Optional 26*/
dbIns.AddValue("City", this.City); /*Optional 27*/
dbIns.AddValue("Zip", this.Zip); /*Optional 28*/
dbIns.AddValue("Comments", this.Comments); /*Optional 29*/
dbIns.AddValue("Email", this.Email); /*Optional 30*/
dbIns.AddValue("Fax", this.Fax); /*Optional 31*/
dbIns.AddValue("Phone", this.Phone); /*Optional 32*/
dbIns.AddValue("Country", this.Country); /*Optional 33*/
dbIns.AddValue("Primary_Contact", this.Primary_Contact); /*Optional 34*/
dbIns.AddValue("MasterFile", this.MasterFile); /*Optional 35*/
dbIns.AddValue("PDFFile", this.PDFFile); /*Optional 36*/
dbIns.AddValue("Paid_And_Locked", this.Paid_And_Locked.Value);
dbIns.AddValue("Paid_And_Locked_DateTime", this.Paid_And_Locked_DateTime); /*Optional 38*/
dbIns.AddValue("LastModifiedBy", this.LastModifiedBy); /*Optional 39*/
dbIns.AddValue("Billed_Date", this.Billed_Date); /*Optional 40*/
dbIns.AddValue("Paid_Date_Actual", this.Paid_Date_Actual); /*Optional 41*/
dbIns.AddValue("JPResidenceAtSourceADRs", this.JPResidenceAtSourceADRs); /*Optional 42*/
dbIns.AddValue("PSAFE", this.PSAFE); /*Optional 43*/
dbIns.AddValue("Election_Version", this.Election_Version); /*Optional 44*/
dbIns.AddValue("FavAtSourceADRs_RSH_Exclude", this.FavAtSourceADRs_RSH_Exclude); /*Optional 45*/
dbIns.AddValue("WriteOff", this.WriteOff); /*Optional 46*/
dbIns.AddValue("AffiliateRebate", this.AffiliateRebate); /*Optional 47*/
dbIns.AddValue("ModifiedDateTime", this.ModifiedDateTime); /*Optional 48*/
dbIns.AddValue("Custodial_FeeID", this.Custodial_FeeID); /*Optional 49*/
dbIns.AddValue("FeeType", this.FeeType); /*Optional 50*/
dbIns.AddValue("FavAtSourceADRs_Detail", this.FavAtSourceADRs_Detail); /*Optional 51*/
dbIns.AddValue("RSH_Email_TimeStamp", this.RSH_Email_TimeStamp); /*Optional 52*/
dbIns.AddValue("Bal_Email_TimeStamp", this.Bal_Email_TimeStamp); /*Optional 53*/
dbIns.AddValue("CreatedDateTime", this.CreatedDateTime); /*Optional 54*/
dbIns.AddValue("XBRL_ReferenceNumber", this.XBRL_ReferenceNumber); /*Optional 55*/
return(dbIns);
}
internal HssUtility.SQLserver.DB_insert Get_DBinsert()
{
this.LastModifiedBy.Value = Utility.CurrentUser;
this.LastModifiedDateTime.Value = DateTime.Now;
this.CreatedBy.Value = Utility.CurrentUser;
this.CreatedDateTime.Value = DateTime.Now;
HssUtility.SQLserver.DB_insert dbIns = new HssUtility.SQLserver.DB_insert(Task_Detail.Get_cmdTP());
dbIns.AddValue("TaskID", this.TaskID.Value);
dbIns.AddValue("TaskName", this.TaskName); /*Optional 3*/
dbIns.AddValue("Country", this.Country); /*Optional 4*/
dbIns.AddValue("Depositary", this.Depositary); /*Optional 5*/
dbIns.AddValue("Issue", this.Issue); /*Optional 6*/
dbIns.AddValue("CUSIP", this.CUSIP); /*Optional 7*/
dbIns.AddValue("RecordDate", this.RecordDate); /*Optional 8*/
dbIns.AddValue("SourceTable", this.SourceTable); /*Optional 9*/
dbIns.AddValue("SourceID", this.SourceID); /*Optional 10*/
dbIns.AddValue("StartDate", this.StartDate); /*Optional 11*/
dbIns.AddValue("PriorityDate", this.PriorityDate); /*Optional 12*/
dbIns.AddValue("EndDate", this.EndDate); /*Optional 13*/
dbIns.AddValue("Notes", this.Notes); /*Optional 14*/
dbIns.AddValue("Priority", this.Priority); /*Optional 15*/
dbIns.AddValue("Completed", this.Completed); /*Optional 16*/
dbIns.AddValue("CreatedBy", this.CreatedBy); /*Optional 17*/
dbIns.AddValue("CreatedDateTime", this.CreatedDateTime); /*Optional 18*/
dbIns.AddValue("CompletedBy", this.CompletedBy); /*Optional 19*/
dbIns.AddValue("CompletedDateTime", this.CompletedDateTime); /*Optional 20*/
dbIns.AddValue("LastModifiedBy", this.LastModifiedBy); /*Optional 21*/
dbIns.AddValue("LastModifiedDateTime", this.LastModifiedDateTime); /*Optional 22*/
return(dbIns);
}
internal HssUtility.SQLserver.DB_insert Get_DBinsert()
{
HssUtility.SQLserver.DB_insert dbIns = new HssUtility.SQLserver.DB_insert(FX_Input.Get_cmdTP());
dbIns.AddValue("CountryName", this.CountryName); /*Optional 2*/
dbIns.AddValue("Custodian", this.Custodian); /*Optional 3*/
dbIns.AddValue("AccountNumber", this.AccountNumber); /*Optional 4*/
dbIns.AddValue("Currency_Code", this.Currency_Code); /*Optional 5*/
dbIns.AddValue("FX_NotificationDate", this.FX_NotificationDate); /*Optional 6*/
dbIns.AddValue("LocalAmountReceived", this.LocalAmountReceived); /*Optional 7*/
dbIns.AddValue("Depositary_ReceivedDate", this.Depositary_ReceivedDate); /*Optional 8*/
dbIns.AddValue("FX_RequestedDate", this.FX_RequestedDate); /*Optional 9*/
dbIns.AddValue("FX_ReceivedDate", this.FX_ReceivedDate); /*Optional 10*/
dbIns.AddValue("Depositary", this.Depositary); /*Optional 11*/
dbIns.AddValue("FX_Rate", this.FX_Rate); /*Optional 12*/
dbIns.AddValue("USDAmountReceived", this.USDAmountReceived); /*Optional 13*/
dbIns.AddValue("ActualCheckRequestDate", this.ActualCheckRequestDate); /*Optional 14*/
dbIns.AddValue("PayToBrokerDate", this.PayToBrokerDate); /*Optional 15*/
dbIns.AddValue("LastModifiedBy", this.LastModifiedBy); /*Optional 16*/
dbIns.AddValue("ModifiedDateTime", this.ModifiedDateTime); /*Optional 17*/
dbIns.AddValue("Forex_Fee", this.Forex_Fee); /*Optional 18*/
return(dbIns);
}
internal HssUtility.SQLserver.DB_insert Get_DBinsert()
{
HssUtility.SQLserver.DB_insert dbIns = new HssUtility.SQLserver.DB_insert(RSH_log.Get_cmdTP());
dbIns.AddValue("DividendIndex", this.DividendIndex);
dbIns.AddValue("DTC", this.DTC);
dbIns.AddValue("Depositary", this.Depositary);
dbIns.AddValue("AccountNumber", this.AccountNumber); /*Optional 5*/
dbIns.AddValue("TIN", this.TIN); /*Optional 6*/
dbIns.AddValue("Shares", this.Shares); /*Optional 7*/
dbIns.AddValue("RegisteredName", this.RegisteredName); /*Optional 8*/
dbIns.AddValue("Address", this.Address); /*Optional 9*/
dbIns.AddValue("CountryCode", this.CountryCode); /*Optional 10*/
dbIns.AddValue("TaxStatus", this.TaxStatus); /*Optional 11*/
dbIns.AddValue("ForeignTaxWH", this.ForeignTaxWH); /*Optional 12*/
dbIns.AddValue("CUSIP", this.CUSIP); /*Optional 13*/
dbIns.AddValue("IssueNumber", this.IssueNumber); /*Optional 14*/
dbIns.AddValue("CitizenshipCode", this.CitizenshipCode); /*Optional 15*/
dbIns.AddValue("OwnerCode", this.OwnerCode); /*Optional 16*/
dbIns.AddValue("ZipCode", this.ZipCode); /*Optional 17*/
dbIns.AddValue("State", this.State); /*Optional 18*/
dbIns.AddValue("CityName", this.CityName); /*Optional 19*/
dbIns.AddValue("Agent", this.Agent); /*Optional 20*/
dbIns.AddValue("LOC", this.LOC); /*Optional 21*/
dbIns.AddValue("RecordDate", this.RecordDate); /*Optional 22*/
dbIns.AddValue("Comp_Num", this.Comp_Num); /*Optional 23*/
dbIns.AddValue("Class_CD", this.Class_CD); /*Optional 24*/
dbIns.AddValue("Tax_CD", this.Tax_CD); /*Optional 25*/
dbIns.AddValue("Shares2", this.Shares2); /*Optional 26*/
dbIns.AddValue("GlobeTax", this.GlobeTax); /*Optional 27*/
dbIns.AddValue("Dividend_Intention", this.Dividend_Intention); /*Optional 28*/
dbIns.AddValue("Holder_On_Date", this.Holder_On_Date); /*Optional 29*/
dbIns.AddValue("Tin_Status_1", this.Tin_Status_1); /*Optional 30*/
dbIns.AddValue("Tin_Status_Source", this.Tin_Status_Source); /*Optional 31*/
dbIns.AddValue("Tin_Exp_Date_1", this.Tin_Exp_Date_1); /*Optional 32*/
dbIns.AddValue("Tin_B_Count", this.Tin_B_Count); /*Optional 33*/
dbIns.AddValue("Holder_Type_Code", this.Holder_Type_Code); /*Optional 34*/
dbIns.AddValue("Last_Contact_Date", this.Last_Contact_Date); /*Optional 35*/
dbIns.AddValue("Last_Contact_Type", this.Last_Contact_Type); /*Optional 36*/
dbIns.AddValue("GlobeTax_Findings", this.GlobeTax_Findings); /*Optional 37*/
return(dbIns);
}
internal HssUtility.SQLserver.DB_insert Get_DBinsert()
{
HssUtility.SQLserver.DB_insert dbIns = new HssUtility.SQLserver.DB_insert(DTC_Participants.Get_cmdTP());
dbIns.AddValue("DTC", this.DTC);
dbIns.AddValue("DTC_Number", this.DTC_Number);
dbIns.AddValue("Company_Name", this.Company_Name);
dbIns.AddValue("ATTN", this.ATTN); /*Optional 4*/
dbIns.AddValue("Address1", this.Address1); /*Optional 5*/
dbIns.AddValue("Address2", this.Address2); /*Optional 6*/
dbIns.AddValue("City", this.City); /*Optional 7*/
dbIns.AddValue("State", this.State); /*Optional 8*/
dbIns.AddValue("Country", this.Country); /*Optional 9*/
dbIns.AddValue("Zip_Postal_Code", this.Zip_Postal_Code); /*Optional 10*/
dbIns.AddValue("Phone", this.Phone); /*Optional 11*/
dbIns.AddValue("Fax", this.Fax); /*Optional 12*/
dbIns.AddValue("WebsiteUrl", this.WebsiteUrl); /*Optional 13*/
dbIns.AddValue("Email", this.Email); /*Optional 14*/
dbIns.AddValue("Fixed_Payment_ATTN", this.Fixed_Payment_ATTN); /*Optional 15*/
dbIns.AddValue("Type", this.Type); /*Optional 16*/
dbIns.AddValue("Depositary", this.Depositary); /*Optional 17*/
dbIns.AddValue("RejectEmail", this.RejectEmail); /*Optional 18*/
dbIns.AddValue("PaymentEmail", this.PaymentEmail); /*Optional 19*/
dbIns.AddValue("DocInventoryEmail", this.DocInventoryEmail); /*Optional 20*/
dbIns.AddValue("SecurityTypeID", this.SecurityTypeID);
dbIns.AddValue("AccountNumber", this.AccountNumber);
dbIns.AddValue("IssuerCSD", this.IssuerCSD); /*Optional 23*/
dbIns.AddValue("ACH_Override", this.ACH_Override); /*Optional 24*/
dbIns.AddValue("ACH_Bank", this.ACH_Bank); /*Optional 25*/
dbIns.AddValue("ACH_ABA", this.ACH_ABA); /*Optional 26*/
dbIns.AddValue("ACH_Account", this.ACH_Account); /*Optional 27*/
dbIns.AddValue("ClearingSystem", this.ClearingSystem);
dbIns.AddValue("CustomWireMemo", this.CustomWireMemo); /*Optional 29*/
dbIns.AddValue("ModifiedDateTime", this.ModifiedDateTime); /*Optional 30*/
dbIns.AddValue("Email_backup", this.Email_backup); /*Optional 31*/
dbIns.AddValue("PaymentEmail_backup", this.PaymentEmail_backup); /*Optional 32*/
dbIns.AddValue("RejectEmail_backup", this.RejectEmail_backup); /*Optional 33*/
dbIns.AddValue("DocInventoryEmail_backup", this.DocInventoryEmail_backup); /*Optional 34*/
return(dbIns);
}
internal HssUtility.SQLserver.DB_insert Get_DBinsert()
{
HssUtility.SQLserver.DB_insert dbIns = new HssUtility.SQLserver.DB_insert(DTC_Position_Headers.Get_cmdTP());
dbIns.AddValue("ModelNumber", this.ModelNumber.Value);
dbIns.AddValue("Country", this.Country.Value);
dbIns.AddValue("Column_Header_Name", this.Column_Header_Name.Value);
dbIns.AddValue("Table_Column", this.Table_Column.Value);
dbIns.AddValue("Rate_Desc", this.Rate_Desc); /*Optional 6*/
dbIns.AddValue("WHRate", this.WHRate); /*Optional 7*/
dbIns.AddValue("ArmorColumn", this.ArmorColumn); /*Optional 8*/
dbIns.AddValue("Category", this.Category.Value);
dbIns.AddValue("DiscloseType", this.DiscloseType.Value);
dbIns.AddValue("SortOrder", this.SortOrder.Value);
dbIns.AddValue("ChargeBackFrom", this.ChargeBackFrom); /*Optional 12*/
dbIns.AddValue("LastModifiedBy", this.LastModifiedBy); /*Optional 13*/
dbIns.AddValue("ModifiedDateTime", this.ModifiedDateTime); /*Optional 14*/
return(dbIns);
}
internal HssUtility.SQLserver.DB_insert Get_DBinsert()
{
HssUtility.SQLserver.DB_insert dbIns = new HssUtility.SQLserver.DB_insert(XBRLfield.Get_cmdTP());
dbIns.AddValue("xbrlElement", this.xbrlElement.Value);
dbIns.AddValue("xbrlAttributeName", this.xbrlAttributeName); /*Optional 3*/
dbIns.AddValue("xbrlContextRefValue", this.xbrlContextRefValue); /*Optional 4*/
dbIns.AddValue("namespace", this.NameSpace); /*Optional 5*/
dbIns.AddValue("drwinFieldName", this.drwinFieldName); /*Optional 6*/
dbIns.AddValue("drwinControlType", this.drwinControlType); /*Optional 7*/
dbIns.AddValue("multiple", this.multiple); /*Optional 8*/
dbIns.AddValue("active", this.active); /*Optional 9*/
dbIns.AddValue("chkCompleteness", this.chkCompleteness); /*Optional 10*/
dbIns.AddValue("drwinFieldNameIncomplete", this.drwinFieldNameIncomplete); /*Optional 11*/
dbIns.AddValue("drwinFieldNameComplete", this.drwinFieldNameComplete); /*Optional 12*/
dbIns.AddValue("createdDate", this.createdDate.Value);
dbIns.AddValue("createdBy", this.createdBy.Value);
dbIns.AddValue("overridable", this.overridable);/*Optional 15*/
return(dbIns);
}
internal HssUtility.SQLserver.DB_insert Get_DBinsert()
{
HssUtility.SQLserver.DB_insert dbIns = new HssUtility.SQLserver.DB_insert(Dividend_Schedule_Of_Fees_DSC.Get_cmdTP());
dbIns.AddValue("DividendIndex", this.DividendIndex);
dbIns.AddValue("WHRate", this.WHRate);
dbIns.AddValue("LongFormFees", this.LongFormFees);
dbIns.AddValue("MinLongFormFee", this.MinLongFormFee);
dbIns.AddValue("Fee_Max", this.Fee_Max);
dbIns.AddValue("Fee_Consularization", this.Fee_Consularization);
dbIns.AddValue("FavAtSourceFee", this.FavAtSourceFee);
dbIns.AddValue("MinAtSourceFee", this.MinAtSourceFee);
dbIns.AddValue("ExemptAtSourceFee", this.ExemptAtSourceFee);
dbIns.AddValue("ShortFormFees", this.ShortFormFees);
dbIns.AddValue("Fee_AtSource", this.Fee_AtSource);
dbIns.AddValue("MinQuickRefundFee", this.MinQuickRefundFee);
dbIns.AddValue("FavTransparentEntityFee", this.FavTransparentEntityFee);
dbIns.AddValue("MinShortFormFee", this.MinShortFormFee);
dbIns.AddValue("Fee_QuickRefund", this.Fee_QuickRefund);
dbIns.AddValue("LastModifiedBy", this.LastModifiedBy); /*Optional 17*/
dbIns.AddValue("ModifiedDateTime", this.ModifiedDateTime); /*Optional 18*/
dbIns.AddValue("AdditionalDSCFee", this.AdditionalDSCFee); /*Optional 19*/
dbIns.AddValue("Source_FeeID", this.Source_FeeID); /*Optional 20*/
dbIns.AddValue("AdditionalDSCFee1", this.AdditionalDSCFee1); /*Optional 21*/
dbIns.AddValue("AtSourceModifiedBy", this.AtSourceModifiedBy); /*Optional 22*/
return(dbIns);
}
internal HssUtility.SQLserver.DB_insert Get_DBinsert()
{
HssUtility.SQLserver.DB_insert dbIns = new HssUtility.SQLserver.DB_insert(Dividend_Filing.Get_cmdTP());
dbIns.AddValue("DividendIndex", this.DividendIndex);
dbIns.AddValue("Custodian_Tax_Authority", this.Custodian_Tax_Authority); /*Optional 3*/
dbIns.AddValue("FiledDate", this.FiledDate);
dbIns.AddValue("Num_ADRs_Filed", this.Num_ADRs_Filed); /*Optional 5*/
dbIns.AddValue("Num_ORDs_Filed", this.Num_ORDs_Filed); /*Optional 6*/
dbIns.AddValue("FedEx_Number", this.FedEx_Number); /*Optional 7*/
dbIns.AddValue("Filing_Method", this.Filing_Method); /*Optional 8*/
dbIns.AddValue("Reference_Number", this.Reference_Number); /*Optional 9*/
dbIns.AddValue("Delivery_Status", this.Delivery_Status); /*Optional 10*/
dbIns.AddValue("Accept", this.Accept); /*Optional 11*/
dbIns.AddValue("LastModifiedBy", this.LastModifiedBy); /*Optional 12*/
dbIns.AddValue("ModifiedDateTime", this.ModifiedDateTime); /*Optional 13*/
dbIns.AddValue("Custodial_Receipt_Date", this.Custodial_Receipt_Date); /*Optional 14*/
dbIns.AddValue("CustodianID", this.CustodianID); /*Optional 15*/
dbIns.AddValue("ReclaimFeesType", this.ReclaimFeesType); /*Optional 16*/
dbIns.AddValue("Master_Reference_Number", this.Master_Reference_Number); /*Optional 17*/
dbIns.AddValue("FilingStatus", this.FilingStatus); /*Optional 18*/
dbIns.AddValue("Allowed_ReclaimFeesTypes", this.Allowed_ReclaimFeesTypes); /*Optional 19*/
dbIns.AddValue("FilingTo", this.FilingTo); /*Optional 20*/
return(dbIns);
}
internal HssUtility.SQLserver.DB_insert Get_DBinsert()
{
HssUtility.SQLserver.DB_insert dbIns = new HssUtility.SQLserver.DB_insert(SavedFiles_CSV.Get_cmdTP());
dbIns.AddValue("originalFileName", this.originalFileName); /*Optional 2*/
dbIns.AddValue("SavedFiles_CSV", this.savedfile_csv);
dbIns.AddValue("FileCreationDate", this.FileCreationDate); /*Optional 4*/
dbIns.AddValue("FTP_Source", this.FTP_Source); /*Optional 5*/
dbIns.AddValue("Status", this.Status); /*Optional 6*/
dbIns.AddValue("DividendIndex", this.DividendIndex); /*Optional 7*/
dbIns.AddValue("Depositary", this.Depositary); /*Optional 8*/
dbIns.AddValue("DTC", this.DTC); /*Optional 9*/
dbIns.AddValue("ProcessTime", this.ProcessTime); /*Optional 10*/
dbIns.AddValue("ProcessedBy", this.ProcessedBy); /*Optional 11*/
dbIns.AddValue("cpuFileName", this.cpuFileName); /*Optional 12*/
dbIns.AddValue("cpuSavedFiles_CSV", this.cpu_savedfile_csv); /*Optional 13*/
dbIns.AddValue("cpuStatus", this.cpuStatus); /*Optional 14*/
dbIns.AddValue("cpuProcessTime", this.cpuProcessTime); /*Optional 15*/
dbIns.AddValue("cpuProcessedBy", this.cpuProcessedBy); /*Optional 16*/
dbIns.AddValue("OriginalSchema", this.OriginalSchema); /*Optional 17*/
dbIns.AddValue("OriginalData", this.OriginalData); /*Optional 18*/
dbIns.AddValue("RecordDate", this.RecordDate); /*Optional 19*/
dbIns.AddValue("Sender", this.Sender); /*Optional 20*/
dbIns.AddValue("CUSIP", this.CUSIP); /*Optional 21*/
return(dbIns);
}
internal HssUtility.SQLserver.DB_insert Get_DBinsert()
{
HssUtility.SQLserver.DB_insert dbIns = new HssUtility.SQLserver.DB_insert(SavedFilesCustodianBalance.Get_cmdTP());
dbIns.AddValue("originalFileName", this.originalFileName);/*Optional 2*/
dbIns.AddValue("SavedFiles_XML_CB", this.SavedFiles_XML_CB);
dbIns.AddValue("AnnouncementName", this.AnnouncementName.Value);
dbIns.AddValue("AnnouncementSender", this.AnnouncementSender.Value);
dbIns.AddValue("AnnouncementIdentifier", this.AnnouncementIdentifier.Value);
dbIns.AddValue("AnnouncementDate", this.AnnouncementDate.Value);
dbIns.AddValue("UniqueUniversalEventIdentifier", this.UniqueUniversalEventIdentifier.Value);
dbIns.AddValue("SECURITY_IDENTIFIER_CUSIP", this.SECURITY_IDENTIFIER_CUSIP.Value);
dbIns.AddValue("ISSUER_NAME", this.ISSUER_NAME.Value);
dbIns.AddValue("ADR_RECORD_DATE", this.ADR_RECORD_DATE.Value);
dbIns.AddValue("ADRBase", this.ADRBase); /*Optional 12*/
dbIns.AddValue("OrdinaryShare", this.OrdinaryShare); /*Optional 13*/
dbIns.AddValue("source", this.source.Value);
dbIns.AddValue("processState", this.processState.Value);
dbIns.AddValue("WhenProcessed", this.WhenProcessed); /*Optional 16*/
dbIns.AddValue("Processedby", this.Processedby); /*Optional 17*/
dbIns.AddValue("flgLock", this.flgLock); /*Optional 18*/
dbIns.AddValue("WhenLocked_date", this.WhenLocked_date); /*Optional 19*/
dbIns.AddValue("LockedBy_userid", this.LockedBy_userid); /*Optional 20*/
dbIns.AddValue("createdby", this.createdby.Value);
dbIns.AddValue("createddate", this.createddate.Value);
dbIns.AddValue("ID_GTS_SFTP_InputSITEs", this.ID_GTS_SFTP_InputSITEs);/*Optional 23*/
return(dbIns);
}
internal HssUtility.SQLserver.DB_insert Get_DBinsert()
{
HssUtility.SQLserver.DB_insert dbIns = new HssUtility.SQLserver.DB_insert(Security.Get_cmdTP());
dbIns.AddValue("Name", this.Name.Value);
dbIns.AddValue("CUSIP", this.CUSIP); /*Optional 3*/
dbIns.AddValue("Country", this.Country.Value);
dbIns.AddValue("TickerSymbol", this.TickerSymbol); /*Optional 5*/
dbIns.AddValue("ISIN", this.ISIN); /*Optional 6*/
dbIns.AddValue("Sedol", this.Sedol); /*Optional 7*/
dbIns.AddValue("Depositary", this.Depositary); /*Optional 8*/
dbIns.AddValue("FirstFiler", this.FirstFiler); /*Optional 9*/
dbIns.AddValue("ClearingSystem", this.ClearingSystem); /*Optional 10*/
dbIns.AddValue("SecurityType", this.SecurityType); /*Optional 11*/
dbIns.AddValue("ModifiedDateTime", this.ModifiedDateTime); /*Optional 12*/
dbIns.AddValue("LastModifiedBy", this.LastModifiedBy); /*Optional 13*/
dbIns.AddValue("EffectiveDate", this.EffectiveDate.Value);
dbIns.AddValue("ADR_RATIO_ADR", this.ADR_RATIO_ADR); /*Optional 15*/
dbIns.AddValue("ADR_RATIO_ORD", this.ADR_RATIO_ORD); /*Optional 16*/
dbIns.AddValue("DutchName", this.DutchName); /*Optional 17*/
return(dbIns);
}
internal HssUtility.SQLserver.DB_insert Get_DBinsert()
{
HssUtility.SQLserver.DB_insert dbIns = new HssUtility.SQLserver.DB_insert(PrimaryCustodian.Get_cmdTP());
dbIns.AddValue("custodian_number", this.custodian_number.Value);
dbIns.AddValue("name", this.name.Value);
dbIns.AddValue("address1", this.address1); /*Optional 4*/
dbIns.AddValue("address2", this.address2); /*Optional 5*/
dbIns.AddValue("city", this.city); /*Optional 6*/
dbIns.AddValue("state", this.state); /*Optional 7*/
dbIns.AddValue("zip", this.zip); /*Optional 8*/
dbIns.AddValue("country_code", this.country_code.Value);
dbIns.AddValue("attn", this.attn); /*Optional 10*/
dbIns.AddValue("phone", this.phone); /*Optional 11*/
dbIns.AddValue("fax", this.fax); /*Optional 12*/
dbIns.AddValue("email", this.email); /*Optional 13*/
dbIns.AddValue("event_id", this.event_id.Value);
dbIns.AddValue("psafe", this.psafe.Value);
dbIns.AddValue("safe_keeping_account_number", this.safe_keeping_account_number);/*Optional 16*/
dbIns.AddValue("depositary_name", this.depositary_name.Value);
return(dbIns);
}