internal void Init_from_reader(HssUtility.SQLserver.DB_reader reader)
{
if (reader == null || reader.IsClosed)
{
return;
}
this.pk_ID = reader.GetInt("Dividend_PayID");
reader.GetInt("DividendIndex", this.DividendIndex);
reader.GetDateTime("PaymentReferenceDate", this.PaymentReferenceDate); /*Optional 3*/
reader.GetString("Depositary", this.Depositary); /*Optional 4*/
reader.GetDateTime("FXValueDate", this.FXValueDate); /*Optional 5*/
reader.GetDecimal("DivFXRate", this.DivFXRate); /*Optional 6*/
reader.GetString("LastModifiedBy", this.LastModifiedBy); /*Optional 7*/
reader.GetDateTime("ModifiedDateTime", this.ModifiedDateTime); /*Optional 8*/
reader.GetBool("Paid_And_Locked", this.Paid_And_Locked); /*Optional 9*/
reader.GetDateTime("Paid_And_Locked_Date", this.Paid_And_Locked_Date); /*Optional 10*/
reader.GetDateTime("Billed_Date", this.Billed_Date); /*Optional 11*/
reader.GetDateTime("Paid_Date_Actual", this.Paid_Date_Actual); /*Optional 12*/
reader.GetString("WriteOff", this.WriteOff); /*Optional 13*/
reader.GetInt("FX_InputID", this.FX_InputID); /*Optional 14*/
reader.GetInt("CustodianID", this.CustodianID); /*Optional 15*/
this.SyncWithDB();
}
internal void Init_from_reader(HssUtility.SQLserver.DB_reader reader)
{
if (reader == null || reader.IsClosed)
{
return;
}
this.pk_ID = reader.GetInt("Dividend_FeeID");
reader.GetInt("DividendIndex", this.DividendIndex);
reader.GetDecimal("WHRate", this.WHRate);
reader.GetDecimal("LongFormFees", this.LongFormFees);
reader.GetDecimal("MinLongFormFee", this.MinLongFormFee);
reader.GetDecimal("Fee_Max", this.Fee_Max);
reader.GetDecimal("Fee_Consularization", this.Fee_Consularization);
reader.GetDecimal("FavAtSourceFee", this.FavAtSourceFee);
reader.GetDecimal("MinAtSourceFee", this.MinAtSourceFee);
reader.GetDecimal("ExemptAtSourceFee", this.ExemptAtSourceFee);
reader.GetDecimal("ShortFormFees", this.ShortFormFees);
reader.GetDecimal("Fee_AtSource", this.Fee_AtSource);
reader.GetDecimal("MinQuickRefundFee", this.MinQuickRefundFee);
reader.GetDecimal("FavTransparentEntityFee", this.FavTransparentEntityFee);
reader.GetDecimal("MinShortFormFee", this.MinShortFormFee);
reader.GetDecimal("Fee_QuickRefund", this.Fee_QuickRefund);
reader.GetString("LastModifiedBy", this.LastModifiedBy); /*Optional 17*/
reader.GetDateTime("ModifiedDateTime", this.ModifiedDateTime); /*Optional 18*/
reader.GetDecimal("AdditionalDSCFee", this.AdditionalDSCFee); /*Optional 19*/
reader.GetInt("Source_FeeID", this.Source_FeeID); /*Optional 20*/
reader.GetDecimal("AdditionalDSCFee1", this.AdditionalDSCFee1); /*Optional 21*/
reader.GetString("AtSourceModifiedBy", this.AtSourceModifiedBy); /*Optional 22*/
this.SyncWithDB();
}
internal void Init_from_reader(HssUtility.SQLserver.DB_reader reader)
{
if (reader == null || reader.IsClosed)
{
return;
}
this.pk_ID = reader.GetInt("id_XBRLField");
reader.GetString("xbrlElement", this.xbrlElement);
reader.GetString("xbrlAttributeName", this.xbrlAttributeName); /*Optional 3*/
reader.GetString("xbrlContextRefValue", this.xbrlContextRefValue); /*Optional 4*/
reader.GetString("namespace", this.NameSpace); /*Optional 5*/
reader.GetString("drwinFieldName", this.drwinFieldName); /*Optional 6*/
reader.GetString("drwinControlType", this.drwinControlType); /*Optional 7*/
reader.GetBool("multiple", this.multiple); /*Optional 8*/
reader.GetBool("active", this.active); /*Optional 9*/
reader.GetBool("chkCompleteness", this.chkCompleteness); /*Optional 10*/
reader.GetString("drwinFieldNameIncomplete", this.drwinFieldNameIncomplete); /*Optional 11*/
reader.GetString("drwinFieldNameComplete", this.drwinFieldNameComplete); /*Optional 12*/
reader.GetDateTime("createdDate", this.createdDate);
reader.GetString("createdBy", this.createdBy);
reader.GetBool("overridable", this.overridable);/*Optional 15*/
this.SyncWithDB();
}
internal void Init_from_reader(HssUtility.SQLserver.DB_reader reader)
{
if (reader == null || reader.IsClosed)
{
return;
}
this.pk_ID = reader.GetInt("ID");
reader.GetString("TaskOwner_SID", this.TaskOwner_SID);
reader.GetString("ISO2CntryCode", this.ISO2CntryCode);
this.SyncWithDB();
}
internal void Init_from_reader(HssUtility.SQLserver.DB_reader reader)
{
if (reader == null || reader.IsClosed)
{
return;
}
this.pk_ID = reader.GetInt("ID");
reader.GetString("UserName", this.UserName); /*Optional 2*/
reader.GetString("ConfigXML", this.ConfigXML); /*Optional 3*/
reader.GetDateTime("LastModifyAt", this.LastModifyAt); /*Optional 4*/
this.SyncWithDB();
}
internal void Init_from_reader(HssUtility.SQLserver.DB_reader reader)
{
if (reader == null || reader.IsClosed)
{
return;
}
this.pk_ID = reader.GetInt("GroupID");
reader.GetString("GroupName", this.GroupName);
reader.GetString("Group_LeaderSID", this.Group_LeaderSID);
reader.GetString("Group_Email", this.Group_Email);/*Optional 4*/
this.SyncWithDB();
}
internal void Init_from_reader(HssUtility.SQLserver.DB_reader reader)
{
if (reader == null || reader.IsClosed)
{
return;
}
this.pk_ID = reader.GetInt("FeesID");
reader.GetString("Country", this.Country);
reader.GetString("Security_Type", this.Security_Type); /*Optional 3*/
reader.GetString("Depositary", this.Depositary);
reader.GetDecimal("ShortFormFees", this.ShortFormFees); /*Optional 5*/
reader.GetDecimal("LongFormFees", this.LongFormFees); /*Optional 6*/
reader.GetDecimal("FavAtSourceFee", this.FavAtSourceFee); /*Optional 7*/
reader.GetDecimal("ExemptAtSourceFee", this.ExemptAtSourceFee); /*Optional 8*/
reader.GetDecimal("FavTransparentEntityFee", this.FavTransparentEntityFee); /*Optional 9*/
reader.GetDecimal("MinAtSourceFee", this.MinAtSourceFee); /*Optional 10*/
reader.GetDecimal("MinLongFormFee", this.MinLongFormFee); /*Optional 11*/
reader.GetDecimal("MinQuickRefundFee", this.MinQuickRefundFee); /*Optional 12*/
reader.GetDecimal("MinShortFormFee", this.MinShortFormFee); /*Optional 13*/
reader.GetDateTime("EffectiveDate", this.EffectiveDate);
reader.GetDateTime("CreatedDate", this.CreatedDate); /*Optional 15*/
reader.GetString("ImportBy", this.ImportBy); /*Optional 16*/
reader.GetString("Notes", this.Notes); /*Optional 17*/
reader.GetInt("SecurityTypeID", this.SecurityTypeID);
reader.GetString("IncomeEventID", this.IncomeEventID); /*Optional 19*/
reader.GetString("Issue", this.Issue); /*Optional 20*/
reader.GetString("CUSIP", this.CUSIP); /*Optional 21*/
reader.GetDecimal("AdditionalDSCFee", this.AdditionalDSCFee); /*Optional 22*/
this.SyncWithDB();
}
internal void Init_from_reader(HssUtility.SQLserver.DB_reader reader)
{
if (reader == null || reader.IsClosed)
{
return;
}
this.pk_ID = reader.GetString("cntry_cd");
reader.GetString("name", this.name); /*Optional 2*/
reader.GetInt("currency_id", this.currency_id); /*Optional 3*/
reader.GetString("iso2_cd", this.iso2_cd); /*Optional 4*/
reader.GetString("iso3_cd", this.iso3_cd); /*Optional 5*/
this.SyncWithDB();
}
internal void Init_from_reader(HssUtility.SQLserver.DB_reader reader)
{
if (reader == null || reader.IsClosed)
{
return;
}
this.pk_ID = reader.GetInt("DetailID");
reader.GetString("DTC_Number", this.DTC_Number);
reader.GetInt("CustodianID", this.CustodianID); /*Optional 25*/
reader.GetString("Status", this.Status); /*Optional 27*/
reader.GetDecimal("RecordDatePosition", this.RecordDatePosition); /*Optional 30*/
reader.GetInt("Dividend_FilingID", this.Dividend_FilingID); /*Optional 37*/
this.SyncWithDB();
}
internal void Init_from_reader(HssUtility.SQLserver.DB_reader reader)
{
if (reader == null || reader.IsClosed)
{
return;
}
this.pk_ID = reader.GetInt("ID");
reader.GetInt("SecurityID", this.SecurityID); /*Optional 2*/
reader.GetString("TaskName", this.TaskName); /*Optional 3*/
reader.GetString("Status", this.Status); /*Optional 4*/
reader.GetString("ValueStr", this.ValueStr); /*Optional 5*/
reader.GetString("CreateBy", this.CreateBy); /*Optional 6*/
reader.GetDateTime("CreateDate", this.CreateDate); /*Optional 7*/
this.SyncWithDB();
}
internal void Init_from_reader(HssUtility.SQLserver.DB_reader reader)
{
if (reader == null || reader.IsClosed)
{
return;
}
this.pk_ID = reader.GetString("name");
reader.GetString("cntry_cd", this.cntry_cd);
reader.GetInt("currency_id", this.currency_id); /*Optional 3*/
reader.GetDecimal("longform_coefficient", this.longform_coefficient); /*Optional 5*/
reader.GetBool("In_ESP", this.In_ESP); /*Optional 6*/
reader.GetString("ISO3_cntry_cd", this.ISO3_cntry_cd); /*Optional 7*/
reader.GetString("GlobeTaxEmail", this.GlobeTaxEmail); /*Optional 8*/
this.SyncWithDB();
}
internal void Init_from_reader(HssUtility.SQLserver.DB_reader reader)
{
if (reader == null || reader.IsClosed)
{
return;
}
this.pk_ID = reader.GetInt("depositary_idemnification_id");
this.depositary_info_id.Value = reader.GetInt("depositary_info_id");
this.language_id.Value = reader.GetInt("language_id");
this.idemnification.Value = reader.GetString("idemnification");
this.idemnification2.Value = reader.GetString("idemnification2");
this.idemnification_di.Value = reader.GetString("idemnification_di");
this.idemnification2_di.Value = reader.GetString("idemnification2_di");
this.idemnification_russia.Value = reader.GetString("idemnification_russia");/*Optional 8*/
this.SyncWithDB();
}
internal void Init_from_reader(HssUtility.SQLserver.DB_reader reader)
{
if (reader == null || reader.IsClosed)
{
return;
}
this.pk_ID = reader.GetString("Country");
reader.GetString("Security_Type", this.Security_Type); /*Optional 2*/
reader.GetString("Depositary", this.Depositary);
reader.GetDecimal("WithholdingRate", this.WithholdingRate); /*Optional 4*/
reader.GetDecimal("ADSC", this.ADSC); /*Optional 5*/
reader.GetDecimal("RateWithADSC", this.RateWithADSC); /*Optional 6*/
reader.GetDateTime("EffectiveDate", this.EffectiveDate); /*Optional 7*/
reader.GetDateTime("CreatedDate", this.CreatedDate); /*Optional 8*/
reader.GetString("ImportBy", this.ImportBy); /*Optional 9*/
this.SyncWithDB();
}
internal void Init_from_reader(HssUtility.SQLserver.DB_reader reader)
{
if (reader == null || reader.IsClosed)
{
return;
}
this.pk_ID = reader.GetInt("ID");
reader.GetString("Job_Class", this.Job_Class); /*Optional 2*/
reader.GetInt("Job_ID", this.Job_ID); /*Optional 3*/
reader.GetDateTime("LastRunAt", this.LastRunAt); /*Optional 4*/
reader.GetString("LastRunBy", this.LastRunBy); /*Optional 5*/
reader.GetBool("Locked", this.Locked); /*Optional 6*/
reader.GetString("Notes", this.Notes); /*Optional 7*/
reader.GetDateTime("LastLockAt", this.LastLockAt); /*Optional 8*/
reader.GetString("LastLockBy", this.LastLockBy); /*Optional 9*/
this.SyncWithDB();
}
internal void Init_from_reader(HssUtility.SQLserver.DB_reader reader)
{
if (reader == null || reader.IsClosed)
{
return;
}
this.pk_ID = reader.GetInt("id");
reader.GetString("coi", this.coi); /*Optional 2*/
reader.GetString("cor", this.cor); /*Optional 3*/
reader.GetDecimal("statry_rt", this.statry_rt); /*Optional 4*/
reader.GetDecimal("int_rt", this.int_rt); /*Optional 5*/
reader.GetDateTime("effect_dt", this.effect_dt); /*Optional 6*/
reader.GetDateTime("created_dt", this.created_dt); /*Optional 7*/
reader.GetDateTime("modified_dt", this.modified_dt); /*Optional 8*/
reader.GetInt("migratedId", this.migratedId); /*Optional 9*/
reader.GetInt("sec_type", this.sec_type); /*Optional 10*/
reader.GetString("bo_typ", this.bo_typ); /*Optional 11*/
this.SyncWithDB();
}
internal void Init_from_reader(HssUtility.SQLserver.DB_reader reader)
{
if (reader == null || reader.IsClosed)
{
return;
}
this.pk_ID = reader.GetInt("FX_InputID");
reader.GetString("CountryName", this.CountryName); /*Optional 2*/
reader.GetString("Custodian", this.Custodian); /*Optional 3*/
reader.GetString("AccountNumber", this.AccountNumber); /*Optional 4*/
reader.GetString("Currency_Code", this.Currency_Code); /*Optional 5*/
reader.GetDateTime("FX_NotificationDate", this.FX_NotificationDate); /*Optional 6*/
reader.GetDecimal("LocalAmountReceived", this.LocalAmountReceived); /*Optional 7*/
reader.GetDateTime("Depositary_ReceivedDate", this.Depositary_ReceivedDate); /*Optional 8*/
reader.GetDateTime("FX_RequestedDate", this.FX_RequestedDate); /*Optional 9*/
reader.GetDateTime("FX_ReceivedDate", this.FX_ReceivedDate); /*Optional 10*/
reader.GetString("Depositary", this.Depositary); /*Optional 11*/
reader.GetDecimal("FX_Rate", this.FX_Rate); /*Optional 12*/
reader.GetDecimal("USDAmountReceived", this.USDAmountReceived); /*Optional 13*/
reader.GetDateTime("ActualCheckRequestDate", this.ActualCheckRequestDate); /*Optional 14*/
reader.GetDateTime("PayToBrokerDate", this.PayToBrokerDate); /*Optional 15*/
reader.GetString("LastModifiedBy", this.LastModifiedBy); /*Optional 16*/
reader.GetDateTime("ModifiedDateTime", this.ModifiedDateTime); /*Optional 17*/
reader.GetDecimal("Forex_Fee", this.Forex_Fee); /*Optional 18*/
this.SyncWithDB();
}
internal void Init_from_reader(HssUtility.SQLserver.DB_reader reader)
{
if (reader == null || reader.IsClosed)
{
return;
}
this.pk_ID = reader.GetInt("DetailID");
//reader.GetInt("DividendIndex", this.DividendIndex);
reader.GetString("DTC_Number", this.DTC_Number);
//reader.GetString("Depositary", this.Depositary);/*Optional 10*/
reader.GetString("BO_COR", this.BO_COR); /*Optional 18*/
reader.GetString("BO_EntityType", this.BO_EntityType); /*Optional 19*/
reader.GetDecimal("ReclaimRate", this.ReclaimRate); /*Optional 22*/
reader.GetInt("CustodianID", this.CustodianID); /*Optional 25*/
reader.GetString("Status", this.Status); /*Optional 27*/
reader.GetDecimal("RecordDatePosition", this.RecordDatePosition); /*Optional 30*/
reader.GetString("ReclaimFeesType", this.ReclaimFeesType); /*Optional 41*/
reader.GetBool("PaidViaDTCC", this.PaidViaDTCC); /*Optional 120*/
this.SyncWithDB();
}
internal void Init_from_reader(HssUtility.SQLserver.DB_reader reader)
{
if (reader == null || reader.IsClosed)
{
return;
}
this.pk_ID = reader.GetInt("ID");
reader.GetInt("GroupID", this.GroupID);
reader.GetString("OwnerSID", this.OwnerSID);
this.SyncWithDB();
}
internal void Init_from_reader(HssUtility.SQLserver.DB_reader reader)
{
if (reader == null || reader.IsClosed)
{
return;
}
this.pk_ID = reader.GetInt("id");
reader.GetString("cntry_cd", this.cntry_cd);
reader.GetString("bo_cor", this.bo_cor);
reader.GetInt("timebar", this.timebar);
reader.GetBool("eoy", this.eoy);
reader.GetBool("pay_dt", this.pay_dt);
reader.GetInt("expect_dt", this.expect_dt);
reader.GetDateTime("effect_dt", this.effect_dt);
reader.GetDateTime("from_dt", this.from_dt);
reader.GetDateTime("created_dt", this.created_dt);
reader.GetDateTime("modified_dt", this.modified_dt);
reader.GetInt("migratedId", this.migratedId);
reader.GetInt("sec_type", this.sec_type);
this.SyncWithDB();
}
internal void Init_from_reader(HssUtility.SQLserver.DB_reader reader)
{
if (reader == null || reader.IsClosed)
{
return;
}
this.pk_ID = reader.GetString("Country");
reader.GetBool("IsSponsored", this.IsSponsored);/*Optional 2*/
reader.GetBool("At_Source", this.At_Source);
reader.GetBool("Quick_Refund", this.Quick_Refund);
reader.GetBool("Long_Form", this.Long_Form);
this.SyncWithDB();
}
internal void Init_from_reader(HssUtility.SQLserver.DB_reader reader)
{
if (reader == null || reader.IsClosed)
{
return;
}
this.pk_ID = reader.GetInt("Queue_ID");
reader.GetInt("DividendIndex", this.DividendIndex);
reader.GetString("TabName", this.TabName);
reader.GetString("FieldName", this.FieldName);
reader.GetString("ColumnName", this.ColumnName);
reader.GetString("PreviousValue", this.PreviousValue); /*Optional 6*/
reader.GetString("NewValue", this.NewValue); /*Optional 7*/
reader.GetString("DataType", this.DataType);
reader.GetString("UserID", this.UserID);
reader.GetDateTime("QueueDateTime", this.QueueDateTime);
reader.GetString("Status", this.Status);
reader.GetString("ApprovedBy", this.ApprovedBy);
reader.GetString("Event", this.Event); /*Optional 13*/
reader.GetBool("Active", this.Active); /*Optional 14*/
this.SyncWithDB();
}
internal void Init_from_reader(HssUtility.SQLserver.DB_reader reader)
{
if (reader == null || reader.IsClosed)
{
return;
}
this.pk_ID = reader.GetInt("ID");
reader.GetString("Name", this.Name); /*Optional 2*/
reader.GetDateTime("Birthday", this.Birthday); /*Optional 3*/
reader.GetDecimal("Salary", this.Salary); /*Optional 4*/
reader.GetBool("IsMarried", this.IsMarried); /*Optional 5*/
this.SyncWithDB();
}
internal void Init_from_reader(HssUtility.SQLserver.DB_reader reader)
{
if (reader == null || reader.IsClosed)
{
return;
}
this.pk_ID = reader.GetInt("OwnerID");
reader.GetString("OwnerSID", this.OwnerSID);
reader.GetString("OwnerName", this.OwnerName);
reader.GetString("Owner_LastName", this.Owner_LastName); /*Optional 4*/
reader.GetString("Owner_FirstName", this.Owner_FirstName); /*Optional 5*/
reader.GetString("Telephone", this.Telephone); /*Optional 7*/
reader.GetString("Email", this.Email); /*Optional 8*/
reader.GetString("Department", this.Department); /*Optional 9*/
reader.GetString("Title", this.Title); /*Optional 10*/
this.SyncWithDB();
}
internal void Init_from_reader(HssUtility.SQLserver.DB_reader reader)
{
if (reader == null || reader.IsClosed)
{
return;
}
this.pk_ID = reader.GetInt("XBRL_ID");
reader.GetInt("DividendIndex", this.DividendIndex);
reader.GetString("Depositary", this.Depositary); /*Optional 3*/
reader.GetString("XBRL_ReferenceNumber", this.XBRL_ReferenceNumber);
reader.GetString("PSAFE", this.PSAFE); /*Optional 5*/
reader.GetDateTime("LastModifiedDate", this.LastModifiedDate); /*Optional 6*/
reader.GetString("SourceType", this.SourceType); /*Optional 7*/
reader.GetString("LastModifiedBy", this.LastModifiedBy); /*Optional 8*/
reader.GetString("Announcement Identifier", this.Announcement_Identifier); /*Optional 9*/
reader.GetString("Event Completeness", this.Event_Completeness); /*Optional 10*/
this.SyncWithDB();
}
internal void Init_from_reader(HssUtility.SQLserver.DB_reader reader)
{
if (reader == null || reader.IsClosed)
{
return;
}
this.pk_ID = reader.GetInt("ID");
reader.GetInt("ModelNumber", this.ModelNumber);
reader.GetString("Country", this.Country);
reader.GetString("Column_Header_Name", this.Column_Header_Name);
reader.GetString("Table_Column", this.Table_Column);
reader.GetString("Rate_Desc", this.Rate_Desc); /*Optional 6*/
reader.GetDecimal("WHRate", this.WHRate); /*Optional 7*/
reader.GetString("ArmorColumn", this.ArmorColumn); /*Optional 8*/
reader.GetString("Category", this.Category);
reader.GetString("DiscloseType", this.DiscloseType);
reader.GetInt("SortOrder", this.SortOrder);
reader.GetDecimal("ChargeBackFrom", this.ChargeBackFrom); /*Optional 12*/
reader.GetString("LastModifiedBy", this.LastModifiedBy); /*Optional 13*/
reader.GetDateTime("ModifiedDateTime", this.ModifiedDateTime); /*Optional 14*/
this.SyncWithDB();
}
internal void Init_from_reader(HssUtility.SQLserver.DB_reader reader)
{
if (reader == null || reader.IsClosed)
{
return;
}
this.pk_ID = reader.GetInt("ID");
reader.GetString("FileName", this.FileName); /*Optional 2*/
reader.GetDateTime("CreateTime", this.CreateTime); /*Optional 3*/
this.FileBinary = reader.GetBytes("FileBinary"); /*Optional 4*/
reader.GetString("CreateBy", this.CreateBy); /*Optional 5*/
reader.GetInt("Status", this.Status); /*Optional 6*/
reader.GetString("CUSIP", this.CUSIP); /*Optional 7*/
reader.GetDateTime("RecordDate", this.RecordDate); /*Optional 8*/
reader.GetString("SecurityName", this.SecurityName); /*Optional 9*/
reader.GetDateTime("LastModifyAt", this.LastModifyAt); /*Optional 10*/
reader.GetString("LastModifyBy", this.LastModifyBy); /*Optional 11*/
reader.GetString("LastModifyAction", this.LastModifyAction); /*Optional 12*/
this.SyncWithDB();
}
internal void Init_from_reader(HssUtility.SQLserver.DB_reader reader)
{
if (reader == null || reader.IsClosed)
{
return;
}
this.pk_ID = reader.GetInt("SecurityID");
reader.GetString("Name", this.Name);
reader.GetString("CUSIP", this.CUSIP); /*Optional 3*/
reader.GetString("Country", this.Country);
reader.GetString("TickerSymbol", this.TickerSymbol); /*Optional 5*/
reader.GetString("ISIN", this.ISIN); /*Optional 6*/
reader.GetString("Sedol", this.Sedol); /*Optional 7*/
reader.GetString("Depositary", this.Depositary); /*Optional 8*/
reader.GetString("FirstFiler", this.FirstFiler); /*Optional 9*/
reader.GetString("ClearingSystem", this.ClearingSystem); /*Optional 10*/
reader.GetString("SecurityType", this.SecurityType); /*Optional 11*/
reader.GetDateTime("ModifiedDateTime", this.ModifiedDateTime); /*Optional 12*/
reader.GetString("LastModifiedBy", this.LastModifiedBy); /*Optional 13*/
reader.GetDateTime("EffectiveDate", this.EffectiveDate);
reader.GetDecimal("ADR_RATIO_ADR", this.ADR_RATIO_ADR); /*Optional 15*/
reader.GetDecimal("ADR_RATIO_ORD", this.ADR_RATIO_ORD); /*Optional 16*/
reader.GetString("DutchName", this.DutchName); /*Optional 17*/
this.SyncWithDB();
}
internal void Init_from_reader(HssUtility.SQLserver.DB_reader reader)
{
if (reader == null || reader.IsClosed)
{
return;
}
this.pk_ID = reader.GetInt("id_SavedFiles_CSV");
reader.GetString("originalFileName", this.originalFileName); /*Optional 2*/
this.savedfile_csv = reader.GetBytes("SavedFiles_CSV");
reader.GetDateTime("FileCreationDate", this.FileCreationDate); /*Optional 4*/
reader.GetString("FTP_Source", this.FTP_Source); /*Optional 5*/
reader.GetString("Status", this.Status); /*Optional 6*/
reader.GetString("DividendIndex", this.DividendIndex); /*Optional 7*/
reader.GetString("Depositary", this.Depositary); /*Optional 8*/
reader.GetInt("DTC", this.DTC); /*Optional 9*/
reader.GetDateTime("ProcessTime", this.ProcessTime); /*Optional 10*/
reader.GetString("ProcessedBy", this.ProcessedBy); /*Optional 11*/
reader.GetString("cpuFileName", this.cpuFileName); /*Optional 12*/
this.cpu_savedfile_csv = reader.GetBytes("cpuSavedFiles_CSV"); /*Optional 13*/
reader.GetString("cpuStatus", this.cpuStatus); /*Optional 14*/
reader.GetDateTime("cpuProcessTime", this.cpuProcessTime); /*Optional 15*/
reader.GetString("cpuProcessedBy", this.cpuProcessedBy); /*Optional 16*/
reader.GetString("OriginalSchema", this.OriginalSchema); /*Optional 17*/
reader.GetString("OriginalData", this.OriginalData); /*Optional 18*/
reader.GetDateTime("RecordDate", this.RecordDate); /*Optional 19*/
reader.GetString("Sender", this.Sender); /*Optional 20*/
reader.GetString("CUSIP", this.CUSIP); /*Optional 21*/
this.SyncWithDB();
}
internal void Init_from_reader(HssUtility.SQLserver.DB_reader reader)
{
if (reader == null || reader.IsClosed)
{
return;
}
this.pk_ID = reader.GetInt("RSHID");
reader.GetInt("DividendIndex", this.DividendIndex);
reader.GetInt("DTC", this.DTC);
reader.GetString("Depositary", this.Depositary);
reader.GetString("AccountNumber", this.AccountNumber); /*Optional 5*/
reader.GetString("TIN", this.TIN); /*Optional 6*/
reader.GetDecimal("Shares", this.Shares); /*Optional 7*/
reader.GetString("RegisteredName", this.RegisteredName); /*Optional 8*/
reader.GetString("Address", this.Address); /*Optional 9*/
reader.GetString("CountryCode", this.CountryCode); /*Optional 10*/
reader.GetString("TaxStatus", this.TaxStatus); /*Optional 11*/
reader.GetDecimal("ForeignTaxWH", this.ForeignTaxWH); /*Optional 12*/
reader.GetString("CUSIP", this.CUSIP); /*Optional 13*/
reader.GetString("IssueNumber", this.IssueNumber); /*Optional 14*/
reader.GetString("CitizenshipCode", this.CitizenshipCode); /*Optional 15*/
reader.GetString("OwnerCode", this.OwnerCode); /*Optional 16*/
reader.GetString("ZipCode", this.ZipCode); /*Optional 17*/
reader.GetString("State", this.State); /*Optional 18*/
reader.GetString("CityName", this.CityName); /*Optional 19*/
reader.GetString("Agent", this.Agent); /*Optional 20*/
reader.GetInt("LOC", this.LOC); /*Optional 21*/
reader.GetDateTime("RecordDate", this.RecordDate); /*Optional 22*/
reader.GetString("Comp_Num", this.Comp_Num); /*Optional 23*/
reader.GetString("Class_CD", this.Class_CD); /*Optional 24*/
reader.GetString("Tax_CD", this.Tax_CD); /*Optional 25*/
reader.GetDecimal("Shares2", this.Shares2); /*Optional 26*/
reader.GetString("GlobeTax", this.GlobeTax); /*Optional 27*/
reader.GetString("Dividend_Intention", this.Dividend_Intention); /*Optional 28*/
reader.GetDateTime("Holder_On_Date", this.Holder_On_Date); /*Optional 29*/
reader.GetString("Tin_Status_1", this.Tin_Status_1); /*Optional 30*/
reader.GetString("Tin_Status_Source", this.Tin_Status_Source); /*Optional 31*/
reader.GetDateTime("Tin_Exp_Date_1", this.Tin_Exp_Date_1); /*Optional 32*/
reader.GetInt("Tin_B_Count", this.Tin_B_Count); /*Optional 33*/
reader.GetString("Holder_Type_Code", this.Holder_Type_Code); /*Optional 34*/
reader.GetDateTime("Last_Contact_Date", this.Last_Contact_Date); /*Optional 35*/
reader.GetString("Last_Contact_Type", this.Last_Contact_Type); /*Optional 36*/
reader.GetString("GlobeTax_Findings", this.GlobeTax_Findings); /*Optional 37*/
this.SyncWithDB();
}
internal void Init_from_reader(HssUtility.SQLserver.DB_reader reader)
{
if (reader == null || reader.IsClosed)
{
return;
}
this.pk_ID = reader.GetInt("DTC");
reader.GetString("DTC_Number", this.DTC_Number);
reader.GetString("Company_Name", this.Company_Name);
reader.GetString("ATTN", this.ATTN); /*Optional 4*/
reader.GetString("Address1", this.Address1); /*Optional 5*/
reader.GetString("Address2", this.Address2); /*Optional 6*/
reader.GetString("City", this.City); /*Optional 7*/
reader.GetString("State", this.State); /*Optional 8*/
reader.GetString("Country", this.Country); /*Optional 9*/
reader.GetString("Zip_Postal_Code", this.Zip_Postal_Code); /*Optional 10*/
reader.GetString("Phone", this.Phone); /*Optional 11*/
reader.GetString("Fax", this.Fax); /*Optional 12*/
reader.GetString("WebsiteUrl", this.WebsiteUrl); /*Optional 13*/
reader.GetString("Email", this.Email); /*Optional 14*/
reader.GetString("Fixed_Payment_ATTN", this.Fixed_Payment_ATTN); /*Optional 15*/
reader.GetString("Type", this.Type); /*Optional 16*/
reader.GetString("Depositary", this.Depositary); /*Optional 17*/
reader.GetString("RejectEmail", this.RejectEmail); /*Optional 18*/
reader.GetString("PaymentEmail", this.PaymentEmail); /*Optional 19*/
reader.GetString("DocInventoryEmail", this.DocInventoryEmail); /*Optional 20*/
reader.GetString("SecurityTypeID", this.SecurityTypeID);
reader.GetString("AccountNumber", this.AccountNumber);
reader.GetString("IssuerCSD", this.IssuerCSD); /*Optional 23*/
reader.GetBool("ACH_Override", this.ACH_Override); /*Optional 24*/
reader.GetString("ACH_Bank", this.ACH_Bank); /*Optional 25*/
reader.GetString("ACH_ABA", this.ACH_ABA); /*Optional 26*/
reader.GetString("ACH_Account", this.ACH_Account); /*Optional 27*/
reader.GetString("ClearingSystem", this.ClearingSystem);
reader.GetString("CustomWireMemo", this.CustomWireMemo); /*Optional 29*/
reader.GetDateTime("ModifiedDateTime", this.ModifiedDateTime); /*Optional 30*/
reader.GetString("Email_backup", this.Email_backup); /*Optional 31*/
reader.GetString("PaymentEmail_backup", this.PaymentEmail_backup); /*Optional 32*/
reader.GetString("RejectEmail_backup", this.RejectEmail_backup); /*Optional 33*/
reader.GetString("DocInventoryEmail_backup", this.DocInventoryEmail_backup); /*Optional 34*/
this.SyncWithDB();
}