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");
this.DepositaryID.Value = reader.GetString("DepositaryID");
this.DepositaryName.Value = reader.GetString("DepositaryName");
this.DepositaryDisplayName.Value = reader.GetString("DepositaryDisplayName"); /*Optional 4*/
this.DepositaryShortName.Value = reader.GetString("DepositaryShortName"); /*Optional 5*/
this.DepositaryIndex.Value = reader.GetInt("DepositaryIndex"); /*Optional 6*/
this.Depositary_Contact.Value = reader.GetString("Depositary_Contact"); /*Optional 7*/
this.Depositary_Phone.Value = reader.GetString("Depositary_Phone"); /*Optional 8*/
this.Depositary_Address1.Value = reader.GetString("Depositary_Address1"); /*Optional 9*/
this.Depositary_Address2.Value = reader.GetString("Depositary_Address2"); /*Optional 10*/
this.Depositary_City.Value = reader.GetString("Depositary_City"); /*Optional 11*/
this.Depositary_State.Value = reader.GetString("Depositary_State"); /*Optional 12*/
this.Active.Value = reader.GetBool("Active"); /*Optional 13*/
this.UniqueDepositaryIndex.Value = reader.GetString("UniqueDepositaryIndex"); /*Optional 14*/
this.SecurityTypeID.Value = reader.GetInt("SecurityTypeID"); /*Optional 15*/
this.ESP_DepositaryName.Value = reader.GetString("ESP_DepositaryName"); /*Optional 16*/
this.ESP_DepositaryAddress1.Value = reader.GetString("ESP_DepositaryAddress1"); /*Optional 17*/
this.ESP_DepositaryAddress2.Value = reader.GetString("ESP_DepositaryAddress2"); /*Optional 18*/
this.ESP_Phone.Value = reader.GetString("ESP_Phone"); /*Optional 19*/
this.ESP_Fax.Value = reader.GetString("ESP_Fax"); /*Optional 20*/
this.ESP_InternationalPhone.Value = reader.GetString("ESP_InternationalPhone"); /*Optional 21*/
this.ESP_DepositaryFullName.Value = reader.GetString("ESP_DepositaryFullName"); /*Optional 22*/
this.ESP_Idemnification.Value = reader.GetString("ESP_Idemnification"); /*Optional 23*/
this.ESP_Idemnification2.Value = reader.GetString("ESP_Idemnification2"); /*Optional 24*/
this.ESP_Idemnification_DI.Value = reader.GetString("ESP_Idemnification_DI"); /*Optional 25*/
this.ESP_Idemnification2_DI.Value = reader.GetString("ESP_Idemnification2_DI"); /*Optional 26*/
this.ESP_DepositaryAccount.Value = reader.GetString("ESP_DepositaryAccount"); /*Optional 27*/
this.ESP_DepositaryIBANCode.Value = reader.GetString("ESP_DepositaryIBANCode"); /*Optional 28*/
this.ESP_DepositaryBIC.Value = reader.GetString("ESP_DepositaryBIC"); /*Optional 29*/
this.ESP_DepositaryBank.Value = reader.GetString("ESP_DepositaryBank"); /*Optional 30*/
this.Nominee.Value = reader.GetString("Nominee"); /*Optional 31*/
this.Nominee_Address.Value = reader.GetString("Nominee_Address"); /*Optional 32*/
this.ESP_Idemnification_RUSSIA.Value = reader.GetString("ESP_Idemnification_RUSSIA"); /*Optional 33*/
this.ActiveFirstFiler.Value = reader.GetBool("ActiveFirstFiler"); /*Optional 34*/
this.PaymentInvoiceCurrency.Value = reader.GetString("PaymentInvoiceCurrency");
this.ClearingSystem.Value = reader.GetString("ClearingSystem"); /*Optional 36*/
this.ACH_Enabled.Value = reader.GetBool("ACH_Enabled"); /*Optional 37*/
this.Originated_ACH_Company_ID.Value = reader.GetString("Originated_ACH_Company_ID"); /*Optional 38*/
this.Originated_Account_Number.Value = reader.GetString("Originated_Account_Number"); /*Optional 39*/
this.ACH_ModifiedBy.Value = reader.GetString("ACH_ModifiedBy"); /*Optional 40*/
this.ACH_ModifiedDateTime.Value = reader.GetDateTime("ACH_ModifiedDateTime", Utility.MinDate); /*Optional 41*/
this.ModifiedDateTime.Value = reader.GetDateTime("ModifiedDateTime", Utility.MinDate); /*Optional 42*/
this.Unique_DepositaryName.Value = reader.GetString("Unique_DepositaryName"); /*Optional 43*/
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("id_SavedFilesCustodianBalance");
reader.GetString("originalFileName", this.originalFileName);/*Optional 2*/
this.SavedFiles_XML_CB = reader.GetBytes("SavedFiles_XML_CB");
reader.GetString("AnnouncementName", this.AnnouncementName);
reader.GetString("AnnouncementSender", this.AnnouncementSender);
reader.GetString("AnnouncementIdentifier", this.AnnouncementIdentifier);
reader.GetString("AnnouncementDate", this.AnnouncementDate);
reader.GetString("UniqueUniversalEventIdentifier", this.UniqueUniversalEventIdentifier);
reader.GetString("SECURITY_IDENTIFIER_CUSIP", this.SECURITY_IDENTIFIER_CUSIP);
reader.GetString("ISSUER_NAME", this.ISSUER_NAME);
reader.GetString("ADR_RECORD_DATE", this.ADR_RECORD_DATE);
reader.GetString("ADRBase", this.ADRBase); /*Optional 12*/
reader.GetString("OrdinaryShare", this.OrdinaryShare); /*Optional 13*/
reader.GetString("source", this.source);
reader.GetInt("processState", this.processState);
reader.GetDateTime("WhenProcessed", this.WhenProcessed); /*Optional 16*/
reader.GetString("Processedby", this.Processedby); /*Optional 17*/
reader.GetBool("flgLock", this.flgLock); /*Optional 18*/
reader.GetDateTime("WhenLocked_date", this.WhenLocked_date); /*Optional 19*/
reader.GetString("LockedBy_userid", this.LockedBy_userid); /*Optional 20*/
reader.GetString("createdby", this.createdby);
reader.GetDateTime("createddate", this.createddate);
reader.GetInt("ID_GTS_SFTP_InputSITEs", this.ID_GTS_SFTP_InputSITEs);/*Optional 23*/
this.SyncWithDB();
}
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_FilingID");
reader.GetInt("DividendIndex", this.DividendIndex);
reader.GetString("Custodian_Tax_Authority", this.Custodian_Tax_Authority); /*Optional 3*/
reader.GetDateTime("FiledDate", this.FiledDate);
reader.GetInt("Num_ADRs_Filed", this.Num_ADRs_Filed); /*Optional 5*/
reader.GetInt("Num_ORDs_Filed", this.Num_ORDs_Filed); /*Optional 6*/
reader.GetString("FedEx_Number", this.FedEx_Number); /*Optional 7*/
reader.GetString("Filing_Method", this.Filing_Method); /*Optional 8*/
reader.GetString("Reference_Number", this.Reference_Number); /*Optional 9*/
reader.GetString("Delivery_Status", this.Delivery_Status); /*Optional 10*/
reader.GetBool("Accept", this.Accept); /*Optional 11*/
reader.GetString("LastModifiedBy", this.LastModifiedBy); /*Optional 12*/
reader.GetDateTime("ModifiedDateTime", this.ModifiedDateTime); /*Optional 13*/
reader.GetDateTime("Custodial_Receipt_Date", this.Custodial_Receipt_Date); /*Optional 14*/
reader.GetInt("CustodianID", this.CustodianID); /*Optional 15*/
reader.GetString("ReclaimFeesType", this.ReclaimFeesType); /*Optional 16*/
reader.GetString("Master_Reference_Number", this.Master_Reference_Number); /*Optional 17*/
reader.GetString("FilingStatus", this.FilingStatus); /*Optional 18*/
reader.GetString("Allowed_ReclaimFeesTypes", this.Allowed_ReclaimFeesTypes); /*Optional 19*/
reader.GetString("FilingTo", this.FilingTo); /*Optional 20*/
this.SyncWithDB();
}
internal void Init_from_reader(HssUtility.SQLserver.DB_reader reader)
{
if (reader == null || reader.IsClosed)
{
return;
}
this.pk_ID = reader.GetInt("TaskDetailID");
reader.GetInt("TaskID", this.TaskID);
reader.GetString("TaskName", this.TaskName); /*Optional 3*/
reader.GetString("Country", this.Country); /*Optional 4*/
reader.GetString("Depositary", this.Depositary); /*Optional 5*/
reader.GetString("Issue", this.Issue); /*Optional 6*/
reader.GetString("CUSIP", this.CUSIP); /*Optional 7*/
reader.GetDateTime("RecordDate", this.RecordDate); /*Optional 8*/
reader.GetString("SourceTable", this.SourceTable); /*Optional 9*/
reader.GetString("SourceID", this.SourceID); /*Optional 10*/
reader.GetDateTime("StartDate", this.StartDate); /*Optional 11*/
reader.GetDateTime("PriorityDate", this.PriorityDate); /*Optional 12*/
reader.GetDateTime("EndDate", this.EndDate); /*Optional 13*/
reader.GetString("Notes", this.Notes); /*Optional 14*/
reader.GetInt("Priority", this.Priority); /*Optional 15*/
reader.GetBool("Completed", this.Completed); /*Optional 16*/
reader.GetString("CreatedBy", this.CreatedBy); /*Optional 17*/
reader.GetDateTime("CreatedDateTime", this.CreatedDateTime); /*Optional 18*/
reader.GetString("CompletedBy", this.CompletedBy); /*Optional 19*/
reader.GetDateTime("CompletedDateTime", this.CompletedDateTime); /*Optional 20*/
reader.GetString("LastModifiedBy", this.LastModifiedBy); /*Optional 21*/
reader.GetDateTime("LastModifiedDateTime", this.LastModifiedDateTime); /*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_SavedfilesRcvd");
this.savedfile = reader.GetBytes("savedfile");
reader.GetString("EventType", this.EventType);
reader.GetString("DRWINIncomeEventID", this.DRWINIncomeEventID); /*Optional 4*/
reader.GetString("cusip", this.cusip); /*Optional 5*/
reader.GetString("ISIN", this.ISIN); /*Optional 6*/
reader.GetString("originalFileName", this.originalFileName); /*Optional 7*/
reader.GetString("DepositaryName", this.DepositaryName); /*Optional 8*/
reader.GetDateTime("AnnouncementDate", this.AnnouncementDate); /*Optional 9*/
reader.GetString("EventCompleteness", this.EventCompleteness); /*Optional 10*/
reader.GetString("UniqueUniversalEventIdentifier", this.UniqueUniversalEventIdentifier); /*Optional 11*/
reader.GetBool("DepositoryReceiptSponsorIndicator", this.DepositoryReceiptSponsorIndicator); /*Optional 12*/
reader.GetDateTime("PaymentDate", this.PaymentDate); /*Optional 13*/
reader.GetDateTime("RecordDate", this.RecordDate); /*Optional 14*/
reader.GetString("CountryOfIssue", this.CountryOfIssue); /*Optional 15*/
reader.GetString("ContextRefBase", this.ContextRefBase); /*Optional 16*/
reader.GetString("Source", this.Source); /*Optional 17*/
reader.GetInt("processState", this.processState);
reader.GetDateTime("WhenProcessed", this.WhenProcessed); /*Optional 19*/
reader.GetString("Processedby", this.Processedby); /*Optional 20*/
reader.GetBool("flgLock", this.flgLock); /*Optional 21*/
reader.GetDateTime("WhenLocked_date", this.WhenLocked_date); /*Optional 22*/
reader.GetString("LockedBy_userid", this.LockedBy_userid); /*Optional 23*/
reader.GetString("createdby", this.createdby);
reader.GetDateTime("createddate", this.createddate);
reader.GetInt("AnnouncementIdentifier", this.AnnouncementIdentifier); /*Optional 26*/
reader.GetBool("FirstFilerFlag", this.FirstFilerFlag); /*Optional 27*/
reader.GetString("UnderlyingSecurityIssuerCountryofIncorporation", this.UnderlyingSecurityIssuerCountryofIncorporation); /*Optional 28*/
reader.GetInt("id_SavedFiles_CSV", this.id_SavedFiles_CSV); /*Optional 29*/
reader.GetInt("DividendIndex", this.DividendIndex); /*Optional 30*/
reader.GetString("AnnouncementType", this.AnnouncementType); /*Optional 31*/
reader.GetInt("ID_GTS_SFTP_InputSITEs", this.ID_GTS_SFTP_InputSITEs); /*Optional 32*/
reader.GetInt("recNum", this.recNum); /*Optional 33*/
reader.GetBool("flgEmailSent", this.flgEmailSent); /*Optional 34*/
reader.GetDateTime("EmailSentDate", this.EmailSentDate); /*Optional 35*/
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.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.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("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();
}
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("Custodian_Number");
reader.GetString("Custodian_ShortName", this.Custodian_ShortName);
reader.GetString("Custodian_FullName", this.Custodian_FullName);
reader.GetString("Account_Number", this.Account_Number); /*Optional 4*/
reader.GetString("Safekeeping_Number", this.Safekeeping_Number); /*Optional 5*/
reader.GetString("Language", this.Language); /*Optional 6*/
reader.GetString("Country_Code", this.Country_Code); /*Optional 7*/
reader.GetString("Title", this.Title); /*Optional 8*/
reader.GetString("From_FirstName", this.From_FirstName); /*Optional 9*/
reader.GetString("From_LastName", this.From_LastName); /*Optional 10*/
reader.GetString("From_Company", this.From_Company); /*Optional 11*/
reader.GetString("From_Address1", this.From_Address1); /*Optional 12*/
reader.GetString("From_Address2", this.From_Address2); /*Optional 13*/
reader.GetString("From_Address3", this.From_Address3); /*Optional 14*/
reader.GetString("From_Address4", this.From_Address4); /*Optional 15*/
reader.GetString("From_Address5", this.From_Address5); /*Optional 16*/
reader.GetString("Telephone", this.Telephone); /*Optional 17*/
reader.GetString("Fax", this.Fax); /*Optional 18*/
reader.GetString("DefaultCustodianType", this.DefaultCustodianType); /*Optional 19*/
reader.GetBool("PrimaryAllowed", this.PrimaryAllowed); /*Optional 20*/
reader.GetString("Tax_Authority", this.Tax_Authority); /*Optional 21*/
reader.GetString("TA_ATTN", this.TA_ATTN); /*Optional 22*/
reader.GetString("TA_Address1", this.TA_Address1); /*Optional 23*/
reader.GetString("TA_Address2", this.TA_Address2); /*Optional 24*/
reader.GetString("Custodian_Alias", this.Custodian_Alias); /*Optional 25*/
reader.GetString("TA_Phone", this.TA_Phone); /*Optional 26*/
reader.GetString("TA_FAX", this.TA_FAX); /*Optional 27*/
reader.GetString("Custodian_Ref_Number", this.Custodian_Ref_Number); /*Optional 28*/
reader.GetString("JPM_Custodian_Ref_Num", this.JPM_Custodian_Ref_Num); /*Optional 29*/
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("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();
}
public string FedEx_Number = null; //not in template
internal void Init_from_reader(HssUtility.SQLserver.DB_reader reader)
{
if (reader == null || reader.IsClosed)
{
return;
}
this.DetailID = reader.GetInt("DetailID");
this.DividendIndex = reader.GetInt("DividendIndex");
this.ClaimID = reader.GetLong("ClaimID");/*Optional 3*/
this.Issue = reader.GetString("Issue");
this.DTC_Number = reader.GetString("DTC_Number");
this.DTC_Name = reader.GetString("DTC_Name"); /*Optional 6*/
this.DTC_Address1 = reader.GetString("DTC_Address1"); /*Optional 7*/
this.DTC_Address2 = reader.GetString("DTC_Address2"); /*Optional 8*/
this.DTC_ATTN = reader.GetString("DTC_ATTN"); /*Optional 9*/
this.Depositary = reader.GetString("Depositary"); /*Optional 10*/
this.DTC_PositionID = reader.GetInt("DTC_PositionID"); /*Optional 11*/
this.BoName = reader.GetString("BoName"); /*Optional 12*/
this.BoAddress1 = reader.GetString("BoAddress1"); /*Optional 13*/
this.BoAddress2 = reader.GetString("BoAddress2"); /*Optional 14*/
this.BoAddress3 = reader.GetString("BoAddress3"); /*Optional 15*/
this.BoAddress4 = reader.GetString("BoAddress4"); /*Optional 16*/
this.BoAddress5 = reader.GetString("BoAddress5"); /*Optional 17*/
this.BO_COR = reader.GetString("BO_COR"); /*Optional 18*/
this.BO_EntityType = reader.GetString("BO_EntityType"); /*Optional 19*/
this.BoTaxID = reader.GetString("BoTaxID"); /*Optional 20*/
this.ReceivedDate = reader.GetDateTime("ReceivedDate"); /*Optional 21*/
this.ReclaimRate = reader.GetDecimal("ReclaimRate"); /*Optional 22*/
reader.GetDecimal("ClaimType"); /*Optional 23*/
reader.GetString("Custodian"); /*Optional 24*/
reader.GetInt("CustodianID"); /*Optional 25*/
reader.GetDecimal("ReclaimAmount"); /*Optional 26*/
reader.GetString("Status"); /*Optional 27*/
reader.GetDateTime("CreatedDate"); /*Optional 28*/
reader.GetDateTime("PaymentReferenceDate"); /*Optional 29*/
reader.GetDecimal("RecordDatePosition"); /*Optional 30*/
reader.GetString("Internal_Ref_Number"); /*Optional 31*/
reader.GetString("Internal_Batch_Num"); /*Optional 32*/
reader.GetString("External_Client_Ref_Num"); /*Optional 33*/
reader.GetString("External_Claim_Ref_Num"); /*Optional 34*/
reader.GetString("External_Batch_Num"); /*Optional 35*/
reader.GetString("Notes"); /*Optional 36*/
reader.GetInt("Dividend_FilingID"); /*Optional 37*/
reader.GetInt("Dividend_PayID"); /*Optional 38*/
reader.GetString("CurrentMode"); /*Optional 39*/
reader.GetString("Editor"); /*Optional 40*/
reader.GetString("ReclaimFeesType"); /*Optional 41*/
reader.GetString("Filing_Reference_Number"); /*Optional 42*/
reader.GetDateTime("ModifiedDateTime"); /*Optional 43*/
reader.GetString("LastModifiedBy"); /*Optional 44*/
reader.GetString("External_Service_Provider_Name"); /*Optional 45*/
reader.GetBool("NewRow");
reader.GetDecimal("Override_Fees"); /*Optional 47*/
reader.GetDecimal("Residency_Percent"); /*Optional 48*/
reader.GetInt("EST_Time_To_Pay"); /*Optional 49*/
reader.GetBool("Override_Rate"); /*Optional 50*/
reader.GetDecimal("Override_Custodial_Fees"); /*Optional 51*/
reader.GetString("EntityType_France"); /*Optional 52*/
reader.GetDecimal("Interest_Paid_EUR"); /*Optional 53*/
reader.GetString("Custodial_Ref_Num"); /*Optional 54*/
reader.GetDateTime("Custodial_Report_Date"); /*Optional 55*/
reader.GetString("Custodial_Report_Status"); /*Optional 56*/
reader.GetString("LawOfEstablishment"); /*Optional 57*/
reader.GetBool("CERT"); /*Optional 58*/
reader.GetString("Validation"); /*Optional 59*/
reader.GetString("Validation_Reason"); /*Optional 60*/
reader.GetString("Broker_BO_Name"); /*Optional 61*/
reader.GetBool("Paid_And_Locked"); /*Optional 62*/
reader.GetString("Category"); /*Optional 63*/
reader.GetString("Name_Of_Underlying_Holder"); /*Optional 64*/
reader.GetString("Entity_Name"); /*Optional 65*/
reader.GetDecimal("PercentOfShares_Held_UH"); /*Optional 66*/
reader.GetInt("RSHID"); /*Optional 67*/
reader.GetString("ParentID"); /*Optional 68*/
reader.GetString("ThreadID"); /*Optional 69*/
reader.GetString("ESPAccountNumber"); /*Optional 70*/
reader.GetInt("Tier"); /*Optional 71*/
reader.GetString("Tier2AccountNumber"); /*Optional 72*/
reader.GetString("Tier3AccountNumber"); /*Optional 73*/
reader.GetString("Tier4AccountNumber"); /*Optional 74*/
reader.GetString("Tier5AccountNumber"); /*Optional 75*/
reader.GetInt("ClientID");
reader.GetBool("Designated"); /*Optional 77*/
reader.GetInt("PID");
reader.GetInt("BOIndex"); /*Optional 79*/
reader.GetInt("TotalParticipants"); /*Optional 80*/
reader.GetInt("TotalTreatyParticipants"); /*Optional 81*/
reader.GetDateTime("DateOfFiscalYearEnd"); /*Optional 82*/
reader.GetString("RejectReasons"); /*Optional 83*/
reader.GetString("Tier6AccountNumber"); /*Optional 84*/
reader.GetString("Tier7AccountNumber"); /*Optional 85*/
reader.GetString("BoEmail"); /*Optional 86*/
reader.GetString("BOAccountNumber"); /*Optional 87*/
reader.GetDateTime("StatusDate"); /*Optional 88*/
reader.GetString("RejectParty"); /*Optional 89*/
reader.GetDateTime("AuditDeadline"); /*Optional 90*/
reader.GetBool("ExtensionRequested"); /*Optional 91*/
reader.GetDateTime("ExtensionDeadline"); /*Optional 92*/
reader.GetString("ElectionOption"); /*Optional 93*/
reader.GetInt("DocStatus_ESP"); /*Optional 94*/
reader.GetString("DocStatus"); /*Optional 95*/
reader.GetInt("boclient_id"); /*Optional 96*/
reader.GetString("pension_plan"); /*Optional 97*/
reader.GetString("VoucherStatus"); /*Optional 98*/
reader.GetDateTime("VoucherDate"); /*Optional 99*/
reader.GetString("LocalMarketID"); /*Optional 100*/
reader.GetInt("Dividend_RejectionID"); /*Optional 101*/
reader.GetDecimal("Depositary_Fees_USD_Locked"); /*Optional 102*/
reader.GetDecimal("Custodial_Fees_EUR_Locked"); /*Optional 103*/
reader.GetDecimal("Custodial_Fees_USD_Locked"); /*Optional 104*/
reader.GetDecimal("Net_Amount_Paid_USD_Locked"); /*Optional 105*/
reader.GetDecimal("Net_Amount_Paid_EUR_Locked"); /*Optional 106*/
reader.GetDateTime("BoBirthDate"); /*Optional 107*/
reader.GetString("BoLastName"); /*Optional 108*/
reader.GetString("BoFirstName"); /*Optional 109*/
reader.GetInt("ClientListingID"); /*Optional 110*/
reader.GetString("BoData"); /*Optional 111*/
reader.GetString("Status_Detail"); /*Optional 112*/
reader.GetDateTime("Doc_Deadline"); /*Optional 113*/
reader.GetString("Kenmerk_Number"); /*Optional 114*/
reader.GetString("Kenmerk_Status"); /*Optional 115*/
reader.GetDateTime("Kenmerk_Status_Date"); /*Optional 116*/
reader.GetString("FileLinking_Status"); /*Optional 117*/
reader.GetInt("Filing_Attempts"); /*Optional 118*/
reader.GetString("Kenmerk_Status_Reason"); /*Optional 119*/
reader.GetBool("PaidViaDTCC"); /*Optional 120*/
reader.GetString("COI"); /*Optional 121*/
reader.GetInt("Par_ID"); /*Optional 122*/
reader.GetDecimal("Depositary_FeesA_USD_Locked"); /*Optional 123*/
reader.GetString("Payment_Cycle"); /*Optional 124*/
reader.GetDateTime("Payment_Cycle_DateTime"); /*Optional 125*/
reader.GetString("StatusUpdatedBy"); /*Optional 126*/
reader.GetString("FundISIN"); /*Optional 127*/
reader.GetDateTime("PurchaseDate"); /*Optional 128*/
reader.GetString("ORDNUNGS_NR"); /*Optional 129*/
reader.GetString("NewBoTaxID"); /*Optional 130*/
reader.GetString("AuditStatus"); /*Optional 131*/
reader.GetDateTime("AuditStatusDate"); /*Optional 132*/
}
internal void Init_from_reader(HssUtility.SQLserver.DB_reader reader)
{
if (reader == null || reader.IsClosed)
{
return;
}
this.pk_ID = reader.GetInt("CustodianID");
reader.GetInt("Custodian_Number", this.Custodian_Number);/*Optional 2*/
reader.GetInt("DividendIndex", this.DividendIndex);
reader.GetString("Custodian", this.Custodian);
reader.GetDecimal("Custodian_Reported", this.Custodian_Reported); /*Optional 5*/
reader.GetDecimal("Custodian_Paid", this.Custodian_Paid); /*Optional 6*/
reader.GetDecimal("FavAtSourceADRs", this.FavAtSourceADRs); /*Optional 7*/
reader.GetDecimal("ExemptAtSourceADRs", this.ExemptAtSourceADRs); /*Optional 8*/
reader.GetDecimal("FavTransparentEntityADRs", this.FavTransparentEntityADRs); /*Optional 9*/
reader.GetDecimal("Custodian_Chargeback", this.Custodian_Chargeback); /*Optional 10*/
reader.GetString("SafeKeeping_AccountNum", this.SafeKeeping_AccountNum); /*Optional 11*/
reader.GetString("Cash_Account_Number", this.Cash_Account_Number); /*Optional 12*/
reader.GetDecimal("Custodial_Fees", this.Custodial_Fees); /*Optional 13*/
reader.GetDecimal("AtSourceFeePerShare", this.AtSourceFeePerShare);
reader.GetString("Custodian_Type", this.Custodian_Type); /*Optional 15*/
reader.GetString("Depositary", this.Depositary); /*Optional 16*/
reader.GetString("Currency", this.Currency); /*Optional 17*/
reader.GetDecimal("Base", this.Base); /*Optional 18*/
reader.GetDecimal("Custodial_Percent", this.Custodial_Percent); /*Optional 19*/
reader.GetDecimal("Maximum_Fees", this.Maximum_Fees); /*Optional 20*/
reader.GetDecimal("Minimum_Fees", this.Minimum_Fees); /*Optional 21*/
reader.GetString("Contact_Name", this.Contact_Name); /*Optional 22*/
reader.GetString("Reference_Number", this.Reference_Number); /*Optional 23*/
reader.GetString("Address1", this.Address1); /*Optional 24*/
reader.GetString("Address2", this.Address2); /*Optional 25*/
reader.GetString("State", this.State); /*Optional 26*/
reader.GetString("City", this.City); /*Optional 27*/
reader.GetString("Zip", this.Zip); /*Optional 28*/
reader.GetString("Comments", this.Comments); /*Optional 29*/
reader.GetString("Email", this.Email); /*Optional 30*/
reader.GetString("Fax", this.Fax); /*Optional 31*/
reader.GetString("Phone", this.Phone); /*Optional 32*/
reader.GetString("Country", this.Country); /*Optional 33*/
reader.GetBool("Primary_Contact", this.Primary_Contact); /*Optional 34*/
reader.GetString("MasterFile", this.MasterFile); /*Optional 35*/
reader.GetString("PDFFile", this.PDFFile); /*Optional 36*/
reader.GetBool("Paid_And_Locked", this.Paid_And_Locked);
reader.GetDateTime("Paid_And_Locked_DateTime", this.Paid_And_Locked_DateTime); /*Optional 38*/
reader.GetString("LastModifiedBy", this.LastModifiedBy); /*Optional 39*/
reader.GetDateTime("Billed_Date", this.Billed_Date); /*Optional 40*/
reader.GetDateTime("Paid_Date_Actual", this.Paid_Date_Actual); /*Optional 41*/
reader.GetDecimal("JPResidenceAtSourceADRs", this.JPResidenceAtSourceADRs); /*Optional 42*/
reader.GetString("PSAFE", this.PSAFE); /*Optional 43*/
reader.GetInt("Election_Version", this.Election_Version); /*Optional 44*/
reader.GetDecimal("FavAtSourceADRs_RSH_Exclude", this.FavAtSourceADRs_RSH_Exclude); /*Optional 45*/
reader.GetString("WriteOff", this.WriteOff); /*Optional 46*/
reader.GetDecimal("AffiliateRebate", this.AffiliateRebate); /*Optional 47*/
reader.GetDateTime("ModifiedDateTime", this.ModifiedDateTime); /*Optional 48*/
reader.GetInt("Custodial_FeeID", this.Custodial_FeeID); /*Optional 49*/
reader.GetString("FeeType", this.FeeType); /*Optional 50*/
reader.GetString("FavAtSourceADRs_Detail", this.FavAtSourceADRs_Detail); /*Optional 51*/
reader.GetDateTime("RSH_Email_TimeStamp", this.RSH_Email_TimeStamp); /*Optional 52*/
reader.GetDateTime("Bal_Email_TimeStamp", this.Bal_Email_TimeStamp); /*Optional 53*/
reader.GetDateTime("CreatedDateTime", this.CreatedDateTime); /*Optional 54*/
reader.GetString("XBRL_ReferenceNumber", this.XBRL_ReferenceNumber); /*Optional 55*/
this.SyncWithDB();
}