public static HssUtility.SQLserver.CmdTemplate Get_cmdTP()
{
if (ADR_TaskOwner.DBcmd_TP != null)
{
return(ADR_TaskOwner.DBcmd_TP);
}
ADR_TaskOwner.DBcmd_TP = new HssUtility.SQLserver.CmdTemplate();
ADR_TaskOwner.DBcmd_TP.tableName = "ADR_TaskOwner";
ADR_TaskOwner.DBcmd_TP.schema = "dbo";
ADR_TaskOwner.DBcmd_TP.AddColumn("OwnerID");
ADR_TaskOwner.DBcmd_TP.AddColumn("OwnerSID");
ADR_TaskOwner.DBcmd_TP.AddColumn("OwnerName");
ADR_TaskOwner.DBcmd_TP.AddColumn("Owner_LastName"); /*Optional 4*/
ADR_TaskOwner.DBcmd_TP.AddColumn("Owner_FirstName"); /*Optional 5*/
//ADR_TaskOwner.DBcmd_TP.AddColumn("AllProperties");/*Optional 6*/
ADR_TaskOwner.DBcmd_TP.AddColumn("Telephone"); /*Optional 7*/
ADR_TaskOwner.DBcmd_TP.AddColumn("Email"); /*Optional 8*/
ADR_TaskOwner.DBcmd_TP.AddColumn("Department"); /*Optional 9*/
ADR_TaskOwner.DBcmd_TP.AddColumn("Title"); /*Optional 10*/
//ADR_TaskOwner.DBcmd_TP.AddColumn("Signature");/*Optional 11*/
return(ADR_TaskOwner.DBcmd_TP);
}
public static HssUtility.SQLserver.CmdTemplate Get_cmdTP()
{
if (EventContactInfo.DBcmd_TP != null)
{
return(EventContactInfo.DBcmd_TP);
}
EventContactInfo.DBcmd_TP = new HssUtility.SQLserver.CmdTemplate();
EventContactInfo.DBcmd_TP.tableName = "EventContactInfo";
EventContactInfo.DBcmd_TP.schema = "dbo";
EventContactInfo.DBcmd_TP.AddColumn("event_contact_info_id");
EventContactInfo.DBcmd_TP.AddColumn("event_id");
EventContactInfo.DBcmd_TP.AddColumn("contact_company_name"); /*Optional 3*/
EventContactInfo.DBcmd_TP.AddColumn("contact_address1"); /*Optional 4*/
EventContactInfo.DBcmd_TP.AddColumn("contact_address2"); /*Optional 5*/
EventContactInfo.DBcmd_TP.AddColumn("contact_country_code"); /*Optional 6*/
EventContactInfo.DBcmd_TP.AddColumn("contact_attn"); /*Optional 7*/
EventContactInfo.DBcmd_TP.AddColumn("contact_phone"); /*Optional 8*/
EventContactInfo.DBcmd_TP.AddColumn("contact_fax"); /*Optional 9*/
EventContactInfo.DBcmd_TP.AddColumn("contact_email"); /*Optional 10*/
EventContactInfo.DBcmd_TP.AddColumn("contact_city"); /*Optional 11*/
EventContactInfo.DBcmd_TP.AddColumn("contact_state"); /*Optional 12*/
EventContactInfo.DBcmd_TP.AddColumn("contact_zip"); /*Optional 13*/
return(EventContactInfo.DBcmd_TP);
}
public static HssUtility.SQLserver.CmdTemplate Get_cmdTP()
{
if (Dividend_Filing.DBcmd_TP != null)
{
return(Dividend_Filing.DBcmd_TP);
}
Dividend_Filing.DBcmd_TP = new HssUtility.SQLserver.CmdTemplate();
Dividend_Filing.DBcmd_TP.tableName = "Dividend_Filing";
Dividend_Filing.DBcmd_TP.schema = "dbo";
Dividend_Filing.DBcmd_TP.AddColumn("Dividend_FilingID");
Dividend_Filing.DBcmd_TP.AddColumn("DividendIndex");
Dividend_Filing.DBcmd_TP.AddColumn("Custodian_Tax_Authority"); /*Optional 3*/
Dividend_Filing.DBcmd_TP.AddColumn("FiledDate");
Dividend_Filing.DBcmd_TP.AddColumn("Num_ADRs_Filed"); /*Optional 5*/
Dividend_Filing.DBcmd_TP.AddColumn("Num_ORDs_Filed"); /*Optional 6*/
Dividend_Filing.DBcmd_TP.AddColumn("FedEx_Number"); /*Optional 7*/
Dividend_Filing.DBcmd_TP.AddColumn("Filing_Method"); /*Optional 8*/
Dividend_Filing.DBcmd_TP.AddColumn("Reference_Number"); /*Optional 9*/
Dividend_Filing.DBcmd_TP.AddColumn("Delivery_Status"); /*Optional 10*/
Dividend_Filing.DBcmd_TP.AddColumn("Accept"); /*Optional 11*/
Dividend_Filing.DBcmd_TP.AddColumn("LastModifiedBy"); /*Optional 12*/
Dividend_Filing.DBcmd_TP.AddColumn("ModifiedDateTime"); /*Optional 13*/
Dividend_Filing.DBcmd_TP.AddColumn("Custodial_Receipt_Date"); /*Optional 14*/
Dividend_Filing.DBcmd_TP.AddColumn("CustodianID"); /*Optional 15*/
Dividend_Filing.DBcmd_TP.AddColumn("ReclaimFeesType"); /*Optional 16*/
Dividend_Filing.DBcmd_TP.AddColumn("Master_Reference_Number"); /*Optional 17*/
Dividend_Filing.DBcmd_TP.AddColumn("FilingStatus"); /*Optional 18*/
Dividend_Filing.DBcmd_TP.AddColumn("Allowed_ReclaimFeesTypes"); /*Optional 19*/
Dividend_Filing.DBcmd_TP.AddColumn("FilingTo"); /*Optional 20*/
return(Dividend_Filing.DBcmd_TP);
}
public static HssUtility.SQLserver.CmdTemplate Get_cmdTP()
{
if (Security.DBcmd_TP != null)
{
return(Security.DBcmd_TP);
}
Security.DBcmd_TP = new HssUtility.SQLserver.CmdTemplate();
Security.DBcmd_TP.tableName = "Securities";
Security.DBcmd_TP.schema = "dbo";
Security.DBcmd_TP.AddColumn("SecurityID");
Security.DBcmd_TP.AddColumn("Name");
Security.DBcmd_TP.AddColumn("CUSIP"); /*Optional 3*/
Security.DBcmd_TP.AddColumn("Country");
Security.DBcmd_TP.AddColumn("TickerSymbol"); /*Optional 5*/
Security.DBcmd_TP.AddColumn("ISIN"); /*Optional 6*/
Security.DBcmd_TP.AddColumn("Sedol"); /*Optional 7*/
Security.DBcmd_TP.AddColumn("Depositary"); /*Optional 8*/
Security.DBcmd_TP.AddColumn("FirstFiler"); /*Optional 9*/
Security.DBcmd_TP.AddColumn("ClearingSystem"); /*Optional 10*/
Security.DBcmd_TP.AddColumn("SecurityType"); /*Optional 11*/
Security.DBcmd_TP.AddColumn("ModifiedDateTime"); /*Optional 12*/
Security.DBcmd_TP.AddColumn("LastModifiedBy"); /*Optional 13*/
Security.DBcmd_TP.AddColumn("EffectiveDate");
Security.DBcmd_TP.AddColumn("ADR_RATIO_ADR"); /*Optional 15*/
Security.DBcmd_TP.AddColumn("ADR_RATIO_ORD"); /*Optional 16*/
Security.DBcmd_TP.AddColumn("DutchName"); /*Optional 17*/
return(Security.DBcmd_TP);
}
public static HssUtility.SQLserver.CmdTemplate Get_cmdTP()
{
if (SPR_file.DBcmd_TP != null)
{
return(SPR_file.DBcmd_TP);
}
SPR_file.DBcmd_TP = new HssUtility.SQLserver.CmdTemplate();
SPR_file.DBcmd_TP.tableName = "DTCC_FTP_files";
SPR_file.DBcmd_TP.schema = "Task";
SPR_file.DBcmd_TP.AddColumn("ID");
SPR_file.DBcmd_TP.AddColumn("FileName"); /*Optional 2*/
SPR_file.DBcmd_TP.AddColumn("CreateTime"); /*Optional 3*/
SPR_file.DBcmd_TP.AddColumn("FileBinary"); /*Optional 4*/
SPR_file.DBcmd_TP.AddColumn("CreateBy"); /*Optional 5*/
SPR_file.DBcmd_TP.AddColumn("Status"); /*Optional 6*/
SPR_file.DBcmd_TP.AddColumn("CUSIP"); /*Optional 7*/
SPR_file.DBcmd_TP.AddColumn("RecordDate"); /*Optional 8*/
SPR_file.DBcmd_TP.AddColumn("SecurityName"); /*Optional 9*/
SPR_file.DBcmd_TP.AddColumn("LastModifyAt"); /*Optional 10*/
SPR_file.DBcmd_TP.AddColumn("LastModifyBy"); /*Optional 11*/
SPR_file.DBcmd_TP.AddColumn("LastModifyAction"); /*Optional 12*/
return(SPR_file.DBcmd_TP);
}
public static HssUtility.SQLserver.CmdTemplate Get_cmdTP()
{
if (EDI_times.DBcmd_TP != null)
{
return(EDI_times.DBcmd_TP);
}
EDI_times.DBcmd_TP = new HssUtility.SQLserver.CmdTemplate();
EDI_times.DBcmd_TP.tableName = "times";
EDI_times.DBcmd_TP.schema = "dbo";
EDI_times.DBcmd_TP.AddColumn("id");
EDI_times.DBcmd_TP.AddColumn("cntry_cd");
EDI_times.DBcmd_TP.AddColumn("bo_cor");
EDI_times.DBcmd_TP.AddColumn("timebar");
EDI_times.DBcmd_TP.AddColumn("eoy");
EDI_times.DBcmd_TP.AddColumn("pay_dt");
EDI_times.DBcmd_TP.AddColumn("expect_dt");
EDI_times.DBcmd_TP.AddColumn("effect_dt");
EDI_times.DBcmd_TP.AddColumn("from_dt");
EDI_times.DBcmd_TP.AddColumn("created_dt");
EDI_times.DBcmd_TP.AddColumn("modified_dt");
EDI_times.DBcmd_TP.AddColumn("migratedId");
EDI_times.DBcmd_TP.AddColumn("sec_type");
return(EDI_times.DBcmd_TP);
}
public static HssUtility.SQLserver.CmdTemplate Get_cmdTP()
{
if (XBRLfield.DBcmd_TP != null)
{
return(XBRLfield.DBcmd_TP);
}
XBRLfield.DBcmd_TP = new HssUtility.SQLserver.CmdTemplate();
XBRLfield.DBcmd_TP.tableName = "XBRLField";
XBRLfield.DBcmd_TP.schema = "dbo";
XBRLfield.DBcmd_TP.AddColumn("id_XBRLField");
XBRLfield.DBcmd_TP.AddColumn("xbrlElement");
XBRLfield.DBcmd_TP.AddColumn("xbrlAttributeName"); /*Optional 3*/
XBRLfield.DBcmd_TP.AddColumn("xbrlContextRefValue"); /*Optional 4*/
XBRLfield.DBcmd_TP.AddColumn("namespace"); /*Optional 5*/
XBRLfield.DBcmd_TP.AddColumn("drwinFieldName"); /*Optional 6*/
XBRLfield.DBcmd_TP.AddColumn("drwinControlType"); /*Optional 7*/
XBRLfield.DBcmd_TP.AddColumn("multiple"); /*Optional 8*/
XBRLfield.DBcmd_TP.AddColumn("active"); /*Optional 9*/
XBRLfield.DBcmd_TP.AddColumn("chkCompleteness"); /*Optional 10*/
XBRLfield.DBcmd_TP.AddColumn("drwinFieldNameIncomplete"); /*Optional 11*/
XBRLfield.DBcmd_TP.AddColumn("drwinFieldNameComplete"); /*Optional 12*/
XBRLfield.DBcmd_TP.AddColumn("createdDate");
XBRLfield.DBcmd_TP.AddColumn("createdBy");
XBRLfield.DBcmd_TP.AddColumn("overridable");/*Optional 15*/
return(XBRLfield.DBcmd_TP);
}
public static HssUtility.SQLserver.CmdTemplate Get_cmdTP()
{
if (Dividend_Payment.DBcmd_TP != null)
{
return(Dividend_Payment.DBcmd_TP);
}
Dividend_Payment.DBcmd_TP = new HssUtility.SQLserver.CmdTemplate();
Dividend_Payment.DBcmd_TP.tableName = "Dividend_Payment";
Dividend_Payment.DBcmd_TP.schema = "dbo";
Dividend_Payment.DBcmd_TP.AddColumn("Dividend_PayID");
Dividend_Payment.DBcmd_TP.AddColumn("DividendIndex");
Dividend_Payment.DBcmd_TP.AddColumn("PaymentReferenceDate"); /*Optional 3*/
Dividend_Payment.DBcmd_TP.AddColumn("Depositary"); /*Optional 4*/
Dividend_Payment.DBcmd_TP.AddColumn("FXValueDate"); /*Optional 5*/
Dividend_Payment.DBcmd_TP.AddColumn("DivFXRate"); /*Optional 6*/
Dividend_Payment.DBcmd_TP.AddColumn("LastModifiedBy"); /*Optional 7*/
Dividend_Payment.DBcmd_TP.AddColumn("ModifiedDateTime"); /*Optional 8*/
Dividend_Payment.DBcmd_TP.AddColumn("Paid_And_Locked"); /*Optional 9*/
Dividend_Payment.DBcmd_TP.AddColumn("Paid_And_Locked_Date"); /*Optional 10*/
Dividend_Payment.DBcmd_TP.AddColumn("Billed_Date"); /*Optional 11*/
Dividend_Payment.DBcmd_TP.AddColumn("Paid_Date_Actual"); /*Optional 12*/
Dividend_Payment.DBcmd_TP.AddColumn("WriteOff"); /*Optional 13*/
Dividend_Payment.DBcmd_TP.AddColumn("FX_InputID"); /*Optional 14*/
Dividend_Payment.DBcmd_TP.AddColumn("CustodianID"); /*Optional 15*/
return(Dividend_Payment.DBcmd_TP);
}
public static HssUtility.SQLserver.CmdTemplate Get_cmdTP()
{
if (DTC_Position_Headers.DBcmd_TP != null)
{
return(DTC_Position_Headers.DBcmd_TP);
}
DTC_Position_Headers.DBcmd_TP = new HssUtility.SQLserver.CmdTemplate();
DTC_Position_Headers.DBcmd_TP.tableName = "DTC_Position_Headers";
DTC_Position_Headers.DBcmd_TP.schema = "dbo";
DTC_Position_Headers.DBcmd_TP.AddColumn("ID");
DTC_Position_Headers.DBcmd_TP.AddColumn("ModelNumber");
DTC_Position_Headers.DBcmd_TP.AddColumn("Country");
DTC_Position_Headers.DBcmd_TP.AddColumn("Column_Header_Name");
DTC_Position_Headers.DBcmd_TP.AddColumn("Table_Column");
DTC_Position_Headers.DBcmd_TP.AddColumn("Rate_Desc"); /*Optional 6*/
DTC_Position_Headers.DBcmd_TP.AddColumn("WHRate"); /*Optional 7*/
DTC_Position_Headers.DBcmd_TP.AddColumn("ArmorColumn"); /*Optional 8*/
DTC_Position_Headers.DBcmd_TP.AddColumn("Category");
DTC_Position_Headers.DBcmd_TP.AddColumn("DiscloseType");
DTC_Position_Headers.DBcmd_TP.AddColumn("SortOrder");
DTC_Position_Headers.DBcmd_TP.AddColumn("ChargeBackFrom"); /*Optional 12*/
DTC_Position_Headers.DBcmd_TP.AddColumn("LastModifiedBy"); /*Optional 13*/
DTC_Position_Headers.DBcmd_TP.AddColumn("ModifiedDateTime"); /*Optional 14*/
return(DTC_Position_Headers.DBcmd_TP);
}
public static HssUtility.SQLserver.CmdTemplate Get_cmdTP()
{
if (FX_Input.DBcmd_TP != null)
{
return(FX_Input.DBcmd_TP);
}
FX_Input.DBcmd_TP = new HssUtility.SQLserver.CmdTemplate();
FX_Input.DBcmd_TP.tableName = "FX_Input";
FX_Input.DBcmd_TP.schema = "dbo";
FX_Input.DBcmd_TP.AddColumn("FX_InputID");
FX_Input.DBcmd_TP.AddColumn("CountryName"); /*Optional 2*/
FX_Input.DBcmd_TP.AddColumn("Custodian"); /*Optional 3*/
FX_Input.DBcmd_TP.AddColumn("AccountNumber"); /*Optional 4*/
FX_Input.DBcmd_TP.AddColumn("Currency_Code"); /*Optional 5*/
FX_Input.DBcmd_TP.AddColumn("FX_NotificationDate"); /*Optional 6*/
FX_Input.DBcmd_TP.AddColumn("LocalAmountReceived"); /*Optional 7*/
FX_Input.DBcmd_TP.AddColumn("Depositary_ReceivedDate"); /*Optional 8*/
FX_Input.DBcmd_TP.AddColumn("FX_RequestedDate"); /*Optional 9*/
FX_Input.DBcmd_TP.AddColumn("FX_ReceivedDate"); /*Optional 10*/
FX_Input.DBcmd_TP.AddColumn("Depositary"); /*Optional 11*/
FX_Input.DBcmd_TP.AddColumn("FX_Rate"); /*Optional 12*/
FX_Input.DBcmd_TP.AddColumn("USDAmountReceived"); /*Optional 13*/
FX_Input.DBcmd_TP.AddColumn("ActualCheckRequestDate"); /*Optional 14*/
FX_Input.DBcmd_TP.AddColumn("PayToBrokerDate"); /*Optional 15*/
FX_Input.DBcmd_TP.AddColumn("LastModifiedBy"); /*Optional 16*/
FX_Input.DBcmd_TP.AddColumn("ModifiedDateTime"); /*Optional 17*/
FX_Input.DBcmd_TP.AddColumn("Forex_Fee"); /*Optional 18*/
return(FX_Input.DBcmd_TP);
}
public static HssUtility.SQLserver.CmdTemplate Get_cmdTP()
{
if (PrimaryCustodian.DBcmd_TP != null)
{
return(PrimaryCustodian.DBcmd_TP);
}
PrimaryCustodian.DBcmd_TP = new HssUtility.SQLserver.CmdTemplate();
PrimaryCustodian.DBcmd_TP.tableName = "PrimaryCustodian";
PrimaryCustodian.DBcmd_TP.schema = "dbo";
PrimaryCustodian.DBcmd_TP.AddColumn("primary_custodian_id");
PrimaryCustodian.DBcmd_TP.AddColumn("custodian_number");
PrimaryCustodian.DBcmd_TP.AddColumn("name");
PrimaryCustodian.DBcmd_TP.AddColumn("address1"); /*Optional 4*/
PrimaryCustodian.DBcmd_TP.AddColumn("address2"); /*Optional 5*/
PrimaryCustodian.DBcmd_TP.AddColumn("city"); /*Optional 6*/
PrimaryCustodian.DBcmd_TP.AddColumn("state"); /*Optional 7*/
PrimaryCustodian.DBcmd_TP.AddColumn("zip"); /*Optional 8*/
PrimaryCustodian.DBcmd_TP.AddColumn("country_code");
PrimaryCustodian.DBcmd_TP.AddColumn("attn"); /*Optional 10*/
PrimaryCustodian.DBcmd_TP.AddColumn("phone"); /*Optional 11*/
PrimaryCustodian.DBcmd_TP.AddColumn("fax"); /*Optional 12*/
PrimaryCustodian.DBcmd_TP.AddColumn("email"); /*Optional 13*/
PrimaryCustodian.DBcmd_TP.AddColumn("event_id");
PrimaryCustodian.DBcmd_TP.AddColumn("psafe");
PrimaryCustodian.DBcmd_TP.AddColumn("safe_keeping_account_number");/*Optional 16*/
PrimaryCustodian.DBcmd_TP.AddColumn("depositary_name");
return(PrimaryCustodian.DBcmd_TP);
}
public static HssUtility.SQLserver.CmdTemplate Get_cmdTP()
{
if (SavedFiles_CSV.DBcmd_TP != null)
{
return(SavedFiles_CSV.DBcmd_TP);
}
SavedFiles_CSV.DBcmd_TP = new HssUtility.SQLserver.CmdTemplate();
SavedFiles_CSV.DBcmd_TP.tableName = "SavedFiles_CSV";
SavedFiles_CSV.DBcmd_TP.schema = "RSH";
SavedFiles_CSV.DBcmd_TP.AddColumn("id_SavedFiles_CSV");
SavedFiles_CSV.DBcmd_TP.AddColumn("originalFileName"); /*Optional 2*/
SavedFiles_CSV.DBcmd_TP.AddColumn("SavedFiles_CSV");
SavedFiles_CSV.DBcmd_TP.AddColumn("FileCreationDate"); /*Optional 4*/
SavedFiles_CSV.DBcmd_TP.AddColumn("FTP_Source"); /*Optional 5*/
SavedFiles_CSV.DBcmd_TP.AddColumn("Status"); /*Optional 6*/
SavedFiles_CSV.DBcmd_TP.AddColumn("DividendIndex"); /*Optional 7*/
SavedFiles_CSV.DBcmd_TP.AddColumn("Depositary"); /*Optional 8*/
SavedFiles_CSV.DBcmd_TP.AddColumn("DTC"); /*Optional 9*/
SavedFiles_CSV.DBcmd_TP.AddColumn("ProcessTime"); /*Optional 10*/
SavedFiles_CSV.DBcmd_TP.AddColumn("ProcessedBy"); /*Optional 11*/
SavedFiles_CSV.DBcmd_TP.AddColumn("cpuFileName"); /*Optional 12*/
SavedFiles_CSV.DBcmd_TP.AddColumn("cpuSavedFiles_CSV"); /*Optional 13*/
SavedFiles_CSV.DBcmd_TP.AddColumn("cpuStatus"); /*Optional 14*/
SavedFiles_CSV.DBcmd_TP.AddColumn("cpuProcessTime"); /*Optional 15*/
SavedFiles_CSV.DBcmd_TP.AddColumn("cpuProcessedBy"); /*Optional 16*/
SavedFiles_CSV.DBcmd_TP.AddColumn("OriginalSchema"); /*Optional 17*/
SavedFiles_CSV.DBcmd_TP.AddColumn("OriginalData"); /*Optional 18*/
SavedFiles_CSV.DBcmd_TP.AddColumn("RecordDate"); /*Optional 19*/
SavedFiles_CSV.DBcmd_TP.AddColumn("Sender"); /*Optional 20*/
SavedFiles_CSV.DBcmd_TP.AddColumn("CUSIP"); /*Optional 21*/
return(SavedFiles_CSV.DBcmd_TP);
}
public static HssUtility.SQLserver.CmdTemplate Get_cmdTP()
{
if (StatutoryRate_edi.DBcmd_TP != null)
{
return(StatutoryRate_edi.DBcmd_TP);
}
StatutoryRate_edi.DBcmd_TP = new HssUtility.SQLserver.CmdTemplate();
StatutoryRate_edi.DBcmd_TP.tableName = "edi_strtapprv";
StatutoryRate_edi.DBcmd_TP.schema = "dbo";
StatutoryRate_edi.DBcmd_TP.AddColumn("id");
StatutoryRate_edi.DBcmd_TP.AddColumn("coi"); /*Optional 2*/
StatutoryRate_edi.DBcmd_TP.AddColumn("cor"); /*Optional 3*/
StatutoryRate_edi.DBcmd_TP.AddColumn("statry_rt"); /*Optional 4*/
StatutoryRate_edi.DBcmd_TP.AddColumn("int_rt"); /*Optional 5*/
StatutoryRate_edi.DBcmd_TP.AddColumn("effect_dt"); /*Optional 6*/
StatutoryRate_edi.DBcmd_TP.AddColumn("created_dt"); /*Optional 7*/
StatutoryRate_edi.DBcmd_TP.AddColumn("modified_dt"); /*Optional 8*/
StatutoryRate_edi.DBcmd_TP.AddColumn("migratedId"); /*Optional 9*/
StatutoryRate_edi.DBcmd_TP.AddColumn("sec_type"); /*Optional 10*/
StatutoryRate_edi.DBcmd_TP.AddColumn("bo_typ"); /*Optional 11*/
return(StatutoryRate_edi.DBcmd_TP);
}
public static HssUtility.SQLserver.CmdTemplate Get_cmdTP()
{
if (Dividend_Detail_simpleEF.DBcmd_TP != null)
{
return(Dividend_Detail_simpleEF.DBcmd_TP);
}
Dividend_Detail_simpleEF.DBcmd_TP = new HssUtility.SQLserver.CmdTemplate();
Dividend_Detail_simpleEF.DBcmd_TP.tableName = "Dividend_Detail";
Dividend_Detail_simpleEF.DBcmd_TP.AddColumn("DetailID");
//Dividend_Detail_simpleEF.DBcmd_TP.AddColumn("DividendIndex");
Dividend_Detail_simpleEF.DBcmd_TP.AddColumn("DTC_Number");
//Dividend_Detail_simpleEF.DBcmd_TP.AddColumn("Depositary");/*Optional 10*/
Dividend_Detail_simpleEF.DBcmd_TP.AddColumn("BO_COR"); /*Optional 18*/
Dividend_Detail_simpleEF.DBcmd_TP.AddColumn("BO_EntityType"); /*Optional 19*/
Dividend_Detail_simpleEF.DBcmd_TP.AddColumn("ReclaimRate"); /*Optional 22*/
Dividend_Detail_simpleEF.DBcmd_TP.AddColumn("CustodianID"); /*Optional 25*/
Dividend_Detail_simpleEF.DBcmd_TP.AddColumn("Status"); /*Optional 27*/
Dividend_Detail_simpleEF.DBcmd_TP.AddColumn("RecordDatePosition"); /*Optional 30*/
Dividend_Detail_simpleEF.DBcmd_TP.AddColumn("ReclaimFeesType"); /*Optional 41*/
Dividend_Detail_simpleEF.DBcmd_TP.AddColumn("PaidViaDTCC"); /*Optional 120*/
return(Dividend_Detail_simpleEF.DBcmd_TP);
}
public static HssUtility.SQLserver.CmdTemplate Get_cmdTP()
{
if (Dividend_Control_Queue.DBcmd_TP != null)
{
return(Dividend_Control_Queue.DBcmd_TP);
}
Dividend_Control_Queue.DBcmd_TP = new HssUtility.SQLserver.CmdTemplate();
Dividend_Control_Queue.DBcmd_TP.tableName = "Dividend_Control_Queue";
Dividend_Control_Queue.DBcmd_TP.schema = "dbo";
Dividend_Control_Queue.DBcmd_TP.AddColumn("Queue_ID");
Dividend_Control_Queue.DBcmd_TP.AddColumn("DividendIndex");
Dividend_Control_Queue.DBcmd_TP.AddColumn("TabName");
Dividend_Control_Queue.DBcmd_TP.AddColumn("FieldName");
Dividend_Control_Queue.DBcmd_TP.AddColumn("ColumnName");
Dividend_Control_Queue.DBcmd_TP.AddColumn("PreviousValue"); /*Optional 6*/
Dividend_Control_Queue.DBcmd_TP.AddColumn("NewValue"); /*Optional 7*/
Dividend_Control_Queue.DBcmd_TP.AddColumn("DataType");
Dividend_Control_Queue.DBcmd_TP.AddColumn("UserID");
Dividend_Control_Queue.DBcmd_TP.AddColumn("QueueDateTime");
Dividend_Control_Queue.DBcmd_TP.AddColumn("Status");
Dividend_Control_Queue.DBcmd_TP.AddColumn("ApprovedBy");
Dividend_Control_Queue.DBcmd_TP.AddColumn("Event"); /*Optional 13*/
Dividend_Control_Queue.DBcmd_TP.AddColumn("Active"); /*Optional 14*/
return(Dividend_Control_Queue.DBcmd_TP);
}
public static HssUtility.SQLserver.CmdTemplate Get_cmdTP()
{
if (Depositary.DBcmd_TP != null)
{
return(Depositary.DBcmd_TP);
}
Depositary.DBcmd_TP = new HssUtility.SQLserver.CmdTemplate();
Depositary.DBcmd_TP.tableName = "Depositaries";
Depositary.DBcmd_TP.schema = "dbo";
Depositary.DBcmd_TP.AddColumn("ID");
Depositary.DBcmd_TP.AddColumn("DepositaryID");
Depositary.DBcmd_TP.AddColumn("DepositaryName");
Depositary.DBcmd_TP.AddColumn("DepositaryDisplayName"); /*Optional 4*/
Depositary.DBcmd_TP.AddColumn("DepositaryShortName"); /*Optional 5*/
Depositary.DBcmd_TP.AddColumn("DepositaryIndex"); /*Optional 6*/
Depositary.DBcmd_TP.AddColumn("Depositary_Contact"); /*Optional 7*/
Depositary.DBcmd_TP.AddColumn("Depositary_Phone"); /*Optional 8*/
Depositary.DBcmd_TP.AddColumn("Depositary_Address1"); /*Optional 9*/
Depositary.DBcmd_TP.AddColumn("Depositary_Address2"); /*Optional 10*/
Depositary.DBcmd_TP.AddColumn("Depositary_City"); /*Optional 11*/
Depositary.DBcmd_TP.AddColumn("Depositary_State"); /*Optional 12*/
Depositary.DBcmd_TP.AddColumn("Active"); /*Optional 13*/
Depositary.DBcmd_TP.AddColumn("UniqueDepositaryIndex"); /*Optional 14*/
Depositary.DBcmd_TP.AddColumn("SecurityTypeID"); /*Optional 15*/
Depositary.DBcmd_TP.AddColumn("ESP_DepositaryName"); /*Optional 16*/
Depositary.DBcmd_TP.AddColumn("ESP_DepositaryAddress1"); /*Optional 17*/
Depositary.DBcmd_TP.AddColumn("ESP_DepositaryAddress2"); /*Optional 18*/
Depositary.DBcmd_TP.AddColumn("ESP_Phone"); /*Optional 19*/
Depositary.DBcmd_TP.AddColumn("ESP_Fax"); /*Optional 20*/
Depositary.DBcmd_TP.AddColumn("ESP_InternationalPhone"); /*Optional 21*/
Depositary.DBcmd_TP.AddColumn("ESP_DepositaryFullName"); /*Optional 22*/
Depositary.DBcmd_TP.AddColumn("ESP_Idemnification"); /*Optional 23*/
Depositary.DBcmd_TP.AddColumn("ESP_Idemnification2"); /*Optional 24*/
Depositary.DBcmd_TP.AddColumn("ESP_Idemnification_DI"); /*Optional 25*/
Depositary.DBcmd_TP.AddColumn("ESP_Idemnification2_DI"); /*Optional 26*/
Depositary.DBcmd_TP.AddColumn("ESP_DepositaryAccount"); /*Optional 27*/
Depositary.DBcmd_TP.AddColumn("ESP_DepositaryIBANCode"); /*Optional 28*/
Depositary.DBcmd_TP.AddColumn("ESP_DepositaryBIC"); /*Optional 29*/
Depositary.DBcmd_TP.AddColumn("ESP_DepositaryBank"); /*Optional 30*/
Depositary.DBcmd_TP.AddColumn("Nominee"); /*Optional 31*/
Depositary.DBcmd_TP.AddColumn("Nominee_Address"); /*Optional 32*/
Depositary.DBcmd_TP.AddColumn("ESP_Idemnification_RUSSIA"); /*Optional 33*/
Depositary.DBcmd_TP.AddColumn("ActiveFirstFiler"); /*Optional 34*/
Depositary.DBcmd_TP.AddColumn("PaymentInvoiceCurrency");
Depositary.DBcmd_TP.AddColumn("ClearingSystem"); /*Optional 36*/
Depositary.DBcmd_TP.AddColumn("ACH_Enabled"); /*Optional 37*/
Depositary.DBcmd_TP.AddColumn("Originated_ACH_Company_ID"); /*Optional 38*/
Depositary.DBcmd_TP.AddColumn("Originated_Account_Number"); /*Optional 39*/
Depositary.DBcmd_TP.AddColumn("ACH_ModifiedBy"); /*Optional 40*/
Depositary.DBcmd_TP.AddColumn("ACH_ModifiedDateTime"); /*Optional 41*/
Depositary.DBcmd_TP.AddColumn("ModifiedDateTime"); /*Optional 42*/
Depositary.DBcmd_TP.AddColumn("Unique_DepositaryName"); /*Optional 43*/
return(Depositary.DBcmd_TP);
}
public static HssUtility.SQLserver.CmdTemplate Get_cmdTP()
{
if (RSH_log.DBcmd_TP != null)
{
return(RSH_log.DBcmd_TP);
}
RSH_log.DBcmd_TP = new HssUtility.SQLserver.CmdTemplate();
RSH_log.DBcmd_TP.tableName = "RSHLog";
RSH_log.DBcmd_TP.schema = "dbo";
RSH_log.DBcmd_TP.AddColumn("RSHID");
RSH_log.DBcmd_TP.AddColumn("DividendIndex");
RSH_log.DBcmd_TP.AddColumn("DTC");
RSH_log.DBcmd_TP.AddColumn("Depositary");
RSH_log.DBcmd_TP.AddColumn("AccountNumber"); /*Optional 5*/
RSH_log.DBcmd_TP.AddColumn("TIN"); /*Optional 6*/
RSH_log.DBcmd_TP.AddColumn("Shares"); /*Optional 7*/
RSH_log.DBcmd_TP.AddColumn("RegisteredName"); /*Optional 8*/
RSH_log.DBcmd_TP.AddColumn("Address"); /*Optional 9*/
RSH_log.DBcmd_TP.AddColumn("CountryCode"); /*Optional 10*/
RSH_log.DBcmd_TP.AddColumn("TaxStatus"); /*Optional 11*/
RSH_log.DBcmd_TP.AddColumn("ForeignTaxWH"); /*Optional 12*/
RSH_log.DBcmd_TP.AddColumn("CUSIP"); /*Optional 13*/
RSH_log.DBcmd_TP.AddColumn("IssueNumber"); /*Optional 14*/
RSH_log.DBcmd_TP.AddColumn("CitizenshipCode"); /*Optional 15*/
RSH_log.DBcmd_TP.AddColumn("OwnerCode"); /*Optional 16*/
RSH_log.DBcmd_TP.AddColumn("ZipCode"); /*Optional 17*/
RSH_log.DBcmd_TP.AddColumn("State"); /*Optional 18*/
RSH_log.DBcmd_TP.AddColumn("CityName"); /*Optional 19*/
RSH_log.DBcmd_TP.AddColumn("Agent"); /*Optional 20*/
RSH_log.DBcmd_TP.AddColumn("LOC"); /*Optional 21*/
RSH_log.DBcmd_TP.AddColumn("RecordDate"); /*Optional 22*/
RSH_log.DBcmd_TP.AddColumn("Comp_Num"); /*Optional 23*/
RSH_log.DBcmd_TP.AddColumn("Class_CD"); /*Optional 24*/
RSH_log.DBcmd_TP.AddColumn("Tax_CD"); /*Optional 25*/
RSH_log.DBcmd_TP.AddColumn("Shares2"); /*Optional 26*/
RSH_log.DBcmd_TP.AddColumn("GlobeTax"); /*Optional 27*/
RSH_log.DBcmd_TP.AddColumn("Dividend_Intention"); /*Optional 28*/
RSH_log.DBcmd_TP.AddColumn("Holder_On_Date"); /*Optional 29*/
RSH_log.DBcmd_TP.AddColumn("Tin_Status_1"); /*Optional 30*/
RSH_log.DBcmd_TP.AddColumn("Tin_Status_Source"); /*Optional 31*/
RSH_log.DBcmd_TP.AddColumn("Tin_Exp_Date_1"); /*Optional 32*/
RSH_log.DBcmd_TP.AddColumn("Tin_B_Count"); /*Optional 33*/
RSH_log.DBcmd_TP.AddColumn("Holder_Type_Code"); /*Optional 34*/
RSH_log.DBcmd_TP.AddColumn("Last_Contact_Date"); /*Optional 35*/
RSH_log.DBcmd_TP.AddColumn("Last_Contact_Type"); /*Optional 36*/
RSH_log.DBcmd_TP.AddColumn("GlobeTax_Findings"); /*Optional 37*/
return(RSH_log.DBcmd_TP);
}
public static HssUtility.SQLserver.CmdTemplate Get_cmdTP()
{
if (XBRL_SavedFile.DBcmd_TP != null)
{
return(XBRL_SavedFile.DBcmd_TP);
}
XBRL_SavedFile.DBcmd_TP = new HssUtility.SQLserver.CmdTemplate();
XBRL_SavedFile.DBcmd_TP.tableName = "SavedFiles";
XBRL_SavedFile.DBcmd_TP.schema = "RECEIVEFILE";
XBRL_SavedFile.DBcmd_TP.AddColumn("id_SavedfilesRcvd");
XBRL_SavedFile.DBcmd_TP.AddColumn("savedfile");
XBRL_SavedFile.DBcmd_TP.AddColumn("EventType");
XBRL_SavedFile.DBcmd_TP.AddColumn("DRWINIncomeEventID"); /*Optional 4*/
XBRL_SavedFile.DBcmd_TP.AddColumn("cusip"); /*Optional 5*/
XBRL_SavedFile.DBcmd_TP.AddColumn("ISIN"); /*Optional 6*/
XBRL_SavedFile.DBcmd_TP.AddColumn("originalFileName"); /*Optional 7*/
XBRL_SavedFile.DBcmd_TP.AddColumn("DepositaryName"); /*Optional 8*/
XBRL_SavedFile.DBcmd_TP.AddColumn("AnnouncementDate"); /*Optional 9*/
XBRL_SavedFile.DBcmd_TP.AddColumn("EventCompleteness"); /*Optional 10*/
XBRL_SavedFile.DBcmd_TP.AddColumn("UniqueUniversalEventIdentifier"); /*Optional 11*/
XBRL_SavedFile.DBcmd_TP.AddColumn("DepositoryReceiptSponsorIndicator"); /*Optional 12*/
XBRL_SavedFile.DBcmd_TP.AddColumn("PaymentDate"); /*Optional 13*/
XBRL_SavedFile.DBcmd_TP.AddColumn("RecordDate"); /*Optional 14*/
XBRL_SavedFile.DBcmd_TP.AddColumn("CountryOfIssue"); /*Optional 15*/
XBRL_SavedFile.DBcmd_TP.AddColumn("ContextRefBase"); /*Optional 16*/
XBRL_SavedFile.DBcmd_TP.AddColumn("Source"); /*Optional 17*/
XBRL_SavedFile.DBcmd_TP.AddColumn("processState");
XBRL_SavedFile.DBcmd_TP.AddColumn("WhenProcessed"); /*Optional 19*/
XBRL_SavedFile.DBcmd_TP.AddColumn("Processedby"); /*Optional 20*/
XBRL_SavedFile.DBcmd_TP.AddColumn("flgLock"); /*Optional 21*/
XBRL_SavedFile.DBcmd_TP.AddColumn("WhenLocked_date"); /*Optional 22*/
XBRL_SavedFile.DBcmd_TP.AddColumn("LockedBy_userid"); /*Optional 23*/
XBRL_SavedFile.DBcmd_TP.AddColumn("createdby");
XBRL_SavedFile.DBcmd_TP.AddColumn("createddate");
XBRL_SavedFile.DBcmd_TP.AddColumn("AnnouncementIdentifier"); /*Optional 26*/
XBRL_SavedFile.DBcmd_TP.AddColumn("FirstFilerFlag"); /*Optional 27*/
XBRL_SavedFile.DBcmd_TP.AddColumn("UnderlyingSecurityIssuerCountryofIncorporation"); /*Optional 28*/
XBRL_SavedFile.DBcmd_TP.AddColumn("id_SavedFiles_CSV"); /*Optional 29*/
XBRL_SavedFile.DBcmd_TP.AddColumn("DividendIndex"); /*Optional 30*/
XBRL_SavedFile.DBcmd_TP.AddColumn("AnnouncementType"); /*Optional 31*/
XBRL_SavedFile.DBcmd_TP.AddColumn("ID_GTS_SFTP_InputSITEs"); /*Optional 32*/
XBRL_SavedFile.DBcmd_TP.AddColumn("recNum"); /*Optional 33*/
XBRL_SavedFile.DBcmd_TP.AddColumn("flgEmailSent"); /*Optional 34*/
XBRL_SavedFile.DBcmd_TP.AddColumn("EmailSentDate"); /*Optional 35*/
return(XBRL_SavedFile.DBcmd_TP);
}
public static HssUtility.SQLserver.CmdTemplate Get_cmdTP()
{
if (DTC_Participants.DBcmd_TP != null)
{
return(DTC_Participants.DBcmd_TP);
}
DTC_Participants.DBcmd_TP = new HssUtility.SQLserver.CmdTemplate();
DTC_Participants.DBcmd_TP.tableName = "DTC_Participants";
DTC_Participants.DBcmd_TP.schema = "dbo";
DTC_Participants.DBcmd_TP.AddColumn("DTC");
DTC_Participants.DBcmd_TP.AddColumn("DTC_Number");
DTC_Participants.DBcmd_TP.AddColumn("Company_Name");
DTC_Participants.DBcmd_TP.AddColumn("ATTN"); /*Optional 4*/
DTC_Participants.DBcmd_TP.AddColumn("Address1"); /*Optional 5*/
DTC_Participants.DBcmd_TP.AddColumn("Address2"); /*Optional 6*/
DTC_Participants.DBcmd_TP.AddColumn("City"); /*Optional 7*/
DTC_Participants.DBcmd_TP.AddColumn("State"); /*Optional 8*/
DTC_Participants.DBcmd_TP.AddColumn("Country"); /*Optional 9*/
DTC_Participants.DBcmd_TP.AddColumn("Zip_Postal_Code"); /*Optional 10*/
DTC_Participants.DBcmd_TP.AddColumn("Phone"); /*Optional 11*/
DTC_Participants.DBcmd_TP.AddColumn("Fax"); /*Optional 12*/
DTC_Participants.DBcmd_TP.AddColumn("WebsiteUrl"); /*Optional 13*/
DTC_Participants.DBcmd_TP.AddColumn("Email"); /*Optional 14*/
DTC_Participants.DBcmd_TP.AddColumn("Fixed_Payment_ATTN"); /*Optional 15*/
DTC_Participants.DBcmd_TP.AddColumn("Type"); /*Optional 16*/
DTC_Participants.DBcmd_TP.AddColumn("Depositary"); /*Optional 17*/
DTC_Participants.DBcmd_TP.AddColumn("RejectEmail"); /*Optional 18*/
DTC_Participants.DBcmd_TP.AddColumn("PaymentEmail"); /*Optional 19*/
DTC_Participants.DBcmd_TP.AddColumn("DocInventoryEmail"); /*Optional 20*/
DTC_Participants.DBcmd_TP.AddColumn("SecurityTypeID");
DTC_Participants.DBcmd_TP.AddColumn("AccountNumber");
DTC_Participants.DBcmd_TP.AddColumn("IssuerCSD"); /*Optional 23*/
DTC_Participants.DBcmd_TP.AddColumn("ACH_Override"); /*Optional 24*/
DTC_Participants.DBcmd_TP.AddColumn("ACH_Bank"); /*Optional 25*/
DTC_Participants.DBcmd_TP.AddColumn("ACH_ABA"); /*Optional 26*/
DTC_Participants.DBcmd_TP.AddColumn("ACH_Account"); /*Optional 27*/
DTC_Participants.DBcmd_TP.AddColumn("ClearingSystem");
DTC_Participants.DBcmd_TP.AddColumn("CustomWireMemo"); /*Optional 29*/
DTC_Participants.DBcmd_TP.AddColumn("ModifiedDateTime"); /*Optional 30*/
DTC_Participants.DBcmd_TP.AddColumn("Email_backup"); /*Optional 31*/
DTC_Participants.DBcmd_TP.AddColumn("PaymentEmail_backup"); /*Optional 32*/
DTC_Participants.DBcmd_TP.AddColumn("RejectEmail_backup"); /*Optional 33*/
DTC_Participants.DBcmd_TP.AddColumn("DocInventoryEmail_backup"); /*Optional 34*/
return(DTC_Participants.DBcmd_TP);
}
public static HssUtility.SQLserver.CmdTemplate Get_cmdTP()
{
if (ADR_Member_Country.DBcmd_TP != null)
{
return(ADR_Member_Country.DBcmd_TP);
}
ADR_Member_Country.DBcmd_TP = new HssUtility.SQLserver.CmdTemplate();
ADR_Member_Country.DBcmd_TP.tableName = "ADR_Member_Country";
ADR_Member_Country.DBcmd_TP.schema = "dbo";
ADR_Member_Country.DBcmd_TP.AddColumn("ID");
ADR_Member_Country.DBcmd_TP.AddColumn("TaskOwner_SID");
ADR_Member_Country.DBcmd_TP.AddColumn("ISO2CntryCode");
return(ADR_Member_Country.DBcmd_TP);
}
public static HssUtility.SQLserver.CmdTemplate Get_cmdTP()
{
if (ADR_Group_Member.DBcmd_TP != null)
{
return(ADR_Group_Member.DBcmd_TP);
}
ADR_Group_Member.DBcmd_TP = new HssUtility.SQLserver.CmdTemplate();
ADR_Group_Member.DBcmd_TP.tableName = "ADR_Group_Member";
ADR_Group_Member.DBcmd_TP.schema = "dbo";
ADR_Group_Member.DBcmd_TP.AddColumn("ID");
ADR_Group_Member.DBcmd_TP.AddColumn("GroupID");
ADR_Group_Member.DBcmd_TP.AddColumn("OwnerSID");
return(ADR_Group_Member.DBcmd_TP);
}
public static HssUtility.SQLserver.CmdTemplate Get_cmdTP()
{
if (ADR_Group.DBcmd_TP != null)
{
return(ADR_Group.DBcmd_TP);
}
ADR_Group.DBcmd_TP = new HssUtility.SQLserver.CmdTemplate();
ADR_Group.DBcmd_TP.tableName = "ADR_Group";
ADR_Group.DBcmd_TP.schema = "dbo";
ADR_Group.DBcmd_TP.AddColumn("GroupID");
ADR_Group.DBcmd_TP.AddColumn("GroupName");
ADR_Group.DBcmd_TP.AddColumn("Group_LeaderSID");
ADR_Group.DBcmd_TP.AddColumn("Group_Email");/*Optional 4*/
return(ADR_Group.DBcmd_TP);
}
public static HssUtility.SQLserver.CmdTemplate Get_cmdTP()
{
if (Hss_UserConfig.DBcmd_TP != null)
{
return(Hss_UserConfig.DBcmd_TP);
}
Hss_UserConfig.DBcmd_TP = new HssUtility.SQLserver.CmdTemplate();
Hss_UserConfig.DBcmd_TP.tableName = "Hss_UserConfig";
Hss_UserConfig.DBcmd_TP.schema = "Task";
Hss_UserConfig.DBcmd_TP.AddColumn("ID");
Hss_UserConfig.DBcmd_TP.AddColumn("UserName"); /*Optional 2*/
Hss_UserConfig.DBcmd_TP.AddColumn("ConfigXML"); /*Optional 3*/
Hss_UserConfig.DBcmd_TP.AddColumn("LastModifyAt"); /*Optional 4*/
return(Hss_UserConfig.DBcmd_TP);
}
public static HssUtility.SQLserver.CmdTemplate Get_cmdTP()
{
if (Country_ProcedureTypes.DBcmd_TP != null)
{
return(Country_ProcedureTypes.DBcmd_TP);
}
Country_ProcedureTypes.DBcmd_TP = new HssUtility.SQLserver.CmdTemplate();
Country_ProcedureTypes.DBcmd_TP.tableName = "Country_ProcedureTypes";
Country_ProcedureTypes.DBcmd_TP.schema = "dbo";
Country_ProcedureTypes.DBcmd_TP.AddColumn("Country");
Country_ProcedureTypes.DBcmd_TP.AddColumn("IsSponsored");/*Optional 2*/
Country_ProcedureTypes.DBcmd_TP.AddColumn("At_Source");
Country_ProcedureTypes.DBcmd_TP.AddColumn("Quick_Refund");
Country_ProcedureTypes.DBcmd_TP.AddColumn("Long_Form");
return(Country_ProcedureTypes.DBcmd_TP);
}
public static HssUtility.SQLserver.CmdTemplate Get_cmdTP()
{
if (Dividend_Detail_simpleAP.DBcmd_TP != null)
{
return(Dividend_Detail_simpleAP.DBcmd_TP);
}
Dividend_Detail_simpleAP.DBcmd_TP = new HssUtility.SQLserver.CmdTemplate();
Dividend_Detail_simpleAP.DBcmd_TP.tableName = "Dividend_Detail";
Dividend_Detail_simpleAP.DBcmd_TP.AddColumn("DetailID");
Dividend_Detail_simpleAP.DBcmd_TP.AddColumn("DTC_Number");
Dividend_Detail_simpleAP.DBcmd_TP.AddColumn("CustodianID"); /*Optional 25*/
Dividend_Detail_simpleAP.DBcmd_TP.AddColumn("Status"); /*Optional 27*/
Dividend_Detail_simpleAP.DBcmd_TP.AddColumn("RecordDatePosition"); /*Optional 30*/
Dividend_Detail_simpleAP.DBcmd_TP.AddColumn("Dividend_FilingID"); /*Optional 37*/
return(Dividend_Detail_simpleAP.DBcmd_TP);
}
public static HssUtility.SQLserver.CmdTemplate Get_cmdTP()
{
if (EDI_country.DBcmd_TP != null)
{
return(EDI_country.DBcmd_TP);
}
EDI_country.DBcmd_TP = new HssUtility.SQLserver.CmdTemplate();
EDI_country.DBcmd_TP.tableName = "edi_cntrytable";
EDI_country.DBcmd_TP.schema = "dbo";
EDI_country.DBcmd_TP.AddColumn("cntry_cd");
EDI_country.DBcmd_TP.AddColumn("name"); /*Optional 2*/
EDI_country.DBcmd_TP.AddColumn("currency_id"); /*Optional 3*/
EDI_country.DBcmd_TP.AddColumn("iso2_cd"); /*Optional 4*/
EDI_country.DBcmd_TP.AddColumn("iso3_cd"); /*Optional 5*/
return(EDI_country.DBcmd_TP);
}
public static HssUtility.SQLserver.CmdTemplate Get_cmdTP()
{
if (Custodian.DBcmd_TP != null)
{
return(Custodian.DBcmd_TP);
}
Custodian.DBcmd_TP = new HssUtility.SQLserver.CmdTemplate();
Custodian.DBcmd_TP.tableName = "Custodians";
Custodian.DBcmd_TP.schema = "dbo";
Custodian.DBcmd_TP.AddColumn("Custodian_Number");
Custodian.DBcmd_TP.AddColumn("Custodian_ShortName");
Custodian.DBcmd_TP.AddColumn("Custodian_FullName");
Custodian.DBcmd_TP.AddColumn("Account_Number"); /*Optional 4*/
Custodian.DBcmd_TP.AddColumn("Safekeeping_Number"); /*Optional 5*/
Custodian.DBcmd_TP.AddColumn("Language"); /*Optional 6*/
Custodian.DBcmd_TP.AddColumn("Country_Code"); /*Optional 7*/
Custodian.DBcmd_TP.AddColumn("Title"); /*Optional 8*/
Custodian.DBcmd_TP.AddColumn("From_FirstName"); /*Optional 9*/
Custodian.DBcmd_TP.AddColumn("From_LastName"); /*Optional 10*/
Custodian.DBcmd_TP.AddColumn("From_Company"); /*Optional 11*/
Custodian.DBcmd_TP.AddColumn("From_Address1"); /*Optional 12*/
Custodian.DBcmd_TP.AddColumn("From_Address2"); /*Optional 13*/
Custodian.DBcmd_TP.AddColumn("From_Address3"); /*Optional 14*/
Custodian.DBcmd_TP.AddColumn("From_Address4"); /*Optional 15*/
Custodian.DBcmd_TP.AddColumn("From_Address5"); /*Optional 16*/
Custodian.DBcmd_TP.AddColumn("Telephone"); /*Optional 17*/
Custodian.DBcmd_TP.AddColumn("Fax"); /*Optional 18*/
Custodian.DBcmd_TP.AddColumn("DefaultCustodianType"); /*Optional 19*/
Custodian.DBcmd_TP.AddColumn("PrimaryAllowed"); /*Optional 20*/
Custodian.DBcmd_TP.AddColumn("Tax_Authority"); /*Optional 21*/
Custodian.DBcmd_TP.AddColumn("TA_ATTN"); /*Optional 22*/
Custodian.DBcmd_TP.AddColumn("TA_Address1"); /*Optional 23*/
Custodian.DBcmd_TP.AddColumn("TA_Address2"); /*Optional 24*/
Custodian.DBcmd_TP.AddColumn("Custodian_Alias"); /*Optional 25*/
Custodian.DBcmd_TP.AddColumn("TA_Phone"); /*Optional 26*/
Custodian.DBcmd_TP.AddColumn("TA_FAX"); /*Optional 27*/
Custodian.DBcmd_TP.AddColumn("Custodian_Ref_Number"); /*Optional 28*/
Custodian.DBcmd_TP.AddColumn("JPM_Custodian_Ref_Num"); /*Optional 29*/
return(Custodian.DBcmd_TP);
}
public static HssUtility.SQLserver.CmdTemplate Get_cmdTP()
{
if (TestClass.DBcmd_TP != null)
{
return(TestClass.DBcmd_TP);
}
TestClass.DBcmd_TP = new HssUtility.SQLserver.CmdTemplate();
TestClass.DBcmd_TP.tableName = "Person_test";
TestClass.DBcmd_TP.schema = "rules";
TestClass.DBcmd_TP.AddColumn("ID");
TestClass.DBcmd_TP.AddColumn("Name"); /*Optional 2*/
TestClass.DBcmd_TP.AddColumn("Birthday"); /*Optional 3*/
TestClass.DBcmd_TP.AddColumn("Salary"); /*Optional 4*/
TestClass.DBcmd_TP.AddColumn("IsMarried"); /*Optional 5*/
return(TestClass.DBcmd_TP);
}
public static HssUtility.SQLserver.CmdTemplate Get_cmdTP()
{
if (Country.DBcmd_TP != null)
{
return(Country.DBcmd_TP);
}
Country.DBcmd_TP = new HssUtility.SQLserver.CmdTemplate();
Country.DBcmd_TP.tableName = "Countries";
Country.DBcmd_TP.schema = "dbo";
Country.DBcmd_TP.AddColumn("name");
Country.DBcmd_TP.AddColumn("cntry_cd");
Country.DBcmd_TP.AddColumn("currency_id"); /*Optional 3*/
Country.DBcmd_TP.AddColumn("longform_coefficient"); /*Optional 5*/
Country.DBcmd_TP.AddColumn("In_ESP"); /*Optional 6*/
Country.DBcmd_TP.AddColumn("ISO3_cntry_cd"); /*Optional 7*/
Country.DBcmd_TP.AddColumn("GlobeTaxEmail"); /*Optional 8*/
return(Country.DBcmd_TP);
}
public static HssUtility.SQLserver.CmdTemplate Get_cmdTP()
{
if (Task21_security.DBcmd_TP != null)
{
return(Task21_security.DBcmd_TP);
}
Task21_security.DBcmd_TP = new HssUtility.SQLserver.CmdTemplate();
Task21_security.DBcmd_TP.tableName = "Task_21";
Task21_security.DBcmd_TP.schema = "Task";
Task21_security.DBcmd_TP.AddColumn("ID");
Task21_security.DBcmd_TP.AddColumn("SecurityID"); /*Optional 2*/
Task21_security.DBcmd_TP.AddColumn("TaskName"); /*Optional 3*/
Task21_security.DBcmd_TP.AddColumn("Status"); /*Optional 4*/
Task21_security.DBcmd_TP.AddColumn("ValueStr"); /*Optional 5*/
Task21_security.DBcmd_TP.AddColumn("CreateBy"); /*Optional 6*/
Task21_security.DBcmd_TP.AddColumn("CreateDate"); /*Optional 7*/
return(Task21_security.DBcmd_TP);
}
