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*/
}