// ----------------------
// <auto-generated>
//     generated using a custom program
// </auto-generated>
// ----------------------

export interface Account {
    AccountNumber?: string | null ;
    AccountPayoff?: number | null ;
    AccountPayoffDate?: string | null ;
    AccountType?: string | null ;
    AccountTypeText?: string | null ;
    ActivatedByUserID?: number | null ;
    ActivationDate?: string | null ;
    AdditionalInsuredNames?: string | null ;
    AddOnInterest?: number | null ;
    AgencyControlOverNoticeOfCancellation?: string | null ;
    AgentID?: number | null ;
    AmountFinanced?: number | null ;
    BalanceDue?: number | null ;
    BalanceDueNoFees?: number | null ;
    BalanceDueNoWriteOffs?: number | null ;
    BalanceDueWithFees?: number | null ;
    BuyRate?: number | null ;
    CancelConfirmed?: string | null ;
    CancelFeesDue?: number | null ;
    CancellationDate?: string | null ;
    CancelReason?: string | null ;
    CurPaymentAmount?: number | null ;
    CurPaymentNumber?: number | null ;
    CurStatusCode?: string | null ;
    CurStatusCodeText?: string | null ;
    DayBeforeCancellationDate?: string | null ;
    DepartmentCode?: string | null ;
    DownPayment?: number | null ;
    DownPaymentBalance?: number | null ;
    DownPaymentDue?: number | null ;
    EffectiveCancellationDate?: string | null ;
    EffectiveDate: string;
    EffectiveInterestRate?: number | null ;
    FeesWrittenOff?: number | null ;
    FirstPaymentDueDate?: string | null ;
    ID: number;
    InsuredID?: number | null ;
    InsuredPaymentType?: string | null ;
    InterestEarned?: number | null ;
    InterestPaid?: number | null ;
    InterestRate?: number | null ;
    InterestWrittenOff?: number | null ;
    LastPaymentDueDate?: string | null ;
    LastUpdate?: string | null ;
    LateChargesDue?: number | null ;
    MaturityDate?: string | null ;
    NextCancellationDate?: string | null ;
    NextMonthAccountPayoff?: number | null ;
    NextMonthAccountPayoffDate?: string | null ;
    NextPaymentDueDate?: string | null ;
    NextPaymentDueWithLate?: number | null ;
    NextPaymentDueWithLateDate?: string | null ;
    NextStatementDate?: string | null ;
    NSFFeesDue?: number | null ;
    NumPayments?: number | null ;
    OriginationState?: string | null ;
    OtherChargesDue?: number | null ;
    PaymentDue?: number | null ;
    PaymentType?: string | null ;
    PayoffValidDate?: string | null ;
    PolicyNumbers?: string | null ;
    PrincipalPaid?: number | null ;
    PrincipalWrittenOff?: number | null ;
    QuoteID?: number | null ;
    QuoteNumber?: string | null ;
    RateTableID?: number | null ;
    RefundPayableTo?: string | null ;
    RefundSendTo?: string | null ;
    RequireCertifiedFunds?: string | null ;
    SalesExecutiveName?: string | null ;
    SetupFeeDue?: number | null ;
    SetUpFeeWrittenOff?: number | null ;
    SignedAgreement?: string | null ;
    SiteID?: string | null ;
    SolicitorID?: number | null ;
    StatusChanged?: string | null ;
    SubStatusChanged?: string | null ;
    SubStatusCode?: string | null ;
    SubStatusString?: string | null ;
    SuspendDate?: string | null ;
    Suspended?: string | null ;
    Territory?: string | null ;
    TotalAccountInterest?: number | null ;
    TotalAmountDue?: number | null ;
}

export interface AccountPolicyBalanceEqualException {
    accountID: number;
    Diff?: number | null ;
}

export interface Account_100 {
    AccountNumber?: string | null ;
    AccountPayoff?: number | null ;
    AccountPayoffDate?: string | null ;
    AccountType?: string | null ;
    AccountTypeText?: string | null ;
    ActivatedByUserID?: number | null ;
    ActivationDate?: string | null ;
    ActivationDateMMMyyyy?: string | null ;
    AdditionalInsuredNames?: string | null ;
    AddOnInterest?: number | null ;
    AgencyControlOverNoticeOfCancellation?: string | null ;
    AgentID?: number | null ;
    AmountFinanced?: number | null ;
    BalanceDue?: number | null ;
    BalanceDueNoFees?: number | null ;
    BalanceDueNoWriteOffs?: number | null ;
    BalanceDueWithFees?: number | null ;
    BuyRate?: number | null ;
    CancelConfirmed?: string | null ;
    CancelFeesDue?: number | null ;
    CancellationDate?: string | null ;
    CancelReason?: string | null ;
    CurPaymentAmount?: number | null ;
    CurPaymentNumber?: number | null ;
    CurStatusCode?: string | null ;
    CurStatusCodeText?: string | null ;
    Database2: string;
    DayBeforeCancellationDate?: string | null ;
    DepartmentCode?: string | null ;
    DownPayment?: number | null ;
    DownPaymentBalance?: number | null ;
    DownPaymentDue?: number | null ;
    EffectiveCancellationDate?: string | null ;
    EffectiveDate?: string | null ;
    EffectiveInterestRate?: number | null ;
    FeesWrittenOff?: number | null ;
    FirstPaymentDueDate?: string | null ;
    Guaranteed?: string | null ;
    ID: number;
    InsuredID?: number | null ;
    InsuredPaymentType?: string | null ;
    InterestDeffered?: number | null ;
    InterestEarned?: number | null ;
    InterestPaid?: number | null ;
    InterestRate?: number | null ;
    InterestWrittenOff?: number | null ;
    LastPaymentDueDate?: string | null ;
    LastUpdate?: string | null ;
    LateChargesDue?: number | null ;
    MaturityDate?: string | null ;
    NextCancellationDate?: string | null ;
    NextMonthAccountPayoff?: number | null ;
    NextMonthAccountPayoffDate?: string | null ;
    NextPaymentDueDate?: string | null ;
    NextPaymentDueWithLate?: number | null ;
    NextPaymentDueWithLateDate?: string | null ;
    NextStatementDate?: string | null ;
    NSFFeesDue?: number | null ;
    NumPayments?: number | null ;
    OriginationState?: string | null ;
    OtherChargesDue?: number | null ;
    PaymentDue?: number | null ;
    PaymentType?: string | null ;
    PayoffValidDate?: string | null ;
    PolicyNumbers?: string | null ;
    PrincipalPaid?: number | null ;
    PrincipalWrittenOff?: number | null ;
    QuoteID?: number | null ;
    QuoteNumber?: string | null ;
    RateTableID?: number | null ;
    RefundPayableTo?: string | null ;
    RefundSendTo?: string | null ;
    RequireCertifiedFunds?: string | null ;
    SalesExecutiveName?: string | null ;
    SetupFeeDue?: number | null ;
    SetUpFeeWrittenOff?: number | null ;
    SignedAgreement?: string | null ;
    SiteID?: string | null ;
    SolicitorID?: number | null ;
    StatusChanged?: string | null ;
    SubStatusChanged?: string | null ;
    SubStatusString?: string | null ;
    SuspendDate?: string | null ;
    Suspended?: string | null ;
    Territory?: string | null ;
    TerritoryFullName: string;
    TotalAccountInterest?: number | null ;
    TotalAmountDue?: number | null ;
    TotalDownPayment?: number | null ;
}

export interface Account_100_Monthly {
    AccountNumber?: string | null ;
    AccountPayoff?: number | null ;
    AccountPayoffDate?: string | null ;
    AccountType?: string | null ;
    AccountTypeText?: string | null ;
    ActivatedByUserID?: number | null ;
    ActivationDate?: string | null ;
    ActivationDateMMMyyyy?: string | null ;
    AdditionalInsuredNames?: string | null ;
    AddOnInterest?: number | null ;
    AgencyControlOverNoticeOfCancellation?: string | null ;
    AgentID?: number | null ;
    AmountFinanced?: number | null ;
    BalanceDue?: number | null ;
    BalanceDueNoFees?: number | null ;
    BalanceDueNoWriteOffs?: number | null ;
    BalanceDueWithFees?: number | null ;
    BuyRate?: number | null ;
    CancelConfirmed?: string | null ;
    CancelFeesDue?: number | null ;
    CancellationDate?: string | null ;
    CancelReason?: string | null ;
    CurPaymentAmount?: number | null ;
    CurPaymentNumber?: number | null ;
    CurStatusCode?: string | null ;
    CurStatusCodeText?: string | null ;
    Database2: string;
    DayBeforeCancellationDate?: string | null ;
    DepartmentCode?: string | null ;
    DownPayment?: number | null ;
    DownPaymentBalance?: number | null ;
    DownPaymentDue?: number | null ;
    EffectiveCancellationDate?: string | null ;
    EffectiveDate?: string | null ;
    EffectiveInterestRate?: number | null ;
    FeesWrittenOff?: number | null ;
    FirstPaymentDueDate?: string | null ;
    Guaranteed?: string | null ;
    ID: number;
    InsuredID?: number | null ;
    InsuredPaymentType?: string | null ;
    InterestDeffered?: number | null ;
    InterestEarned?: number | null ;
    InterestPaid?: number | null ;
    InterestRate?: number | null ;
    InterestWrittenOff?: number | null ;
    LastPaymentDueDate?: string | null ;
    LastUpdate?: string | null ;
    LateChargesDue?: number | null ;
    MaturityDate?: string | null ;
    NextCancellationDate?: string | null ;
    NextMonthAccountPayoff?: number | null ;
    NextMonthAccountPayoffDate?: string | null ;
    NextPaymentDueDate?: string | null ;
    NextPaymentDueWithLate?: number | null ;
    NextPaymentDueWithLateDate?: string | null ;
    NextStatementDate?: string | null ;
    NSFFeesDue?: number | null ;
    NumPayments?: number | null ;
    OriginationState?: string | null ;
    OtherChargesDue?: number | null ;
    PaymentDue?: number | null ;
    PaymentType?: string | null ;
    PayoffValidDate?: string | null ;
    PolicyNumbers?: string | null ;
    PrincipalPaid?: number | null ;
    PrincipalWrittenOff?: number | null ;
    QuoteID?: number | null ;
    QuoteNumber?: string | null ;
    RateTableID?: number | null ;
    RefundPayableTo?: string | null ;
    RefundSendTo?: string | null ;
    RequireCertifiedFunds?: string | null ;
    SalesExecutiveName?: string | null ;
    SetupFeeDue?: number | null ;
    SetUpFeeWrittenOff?: number | null ;
    SignedAgreement?: string | null ;
    SiteID?: string | null ;
    SolicitorID?: number | null ;
    StatusChanged?: string | null ;
    SubStatusChanged?: string | null ;
    SubStatusString?: string | null ;
    SuspendDate?: string | null ;
    Suspended?: string | null ;
    Territory?: string | null ;
    TerritoryFullName: string;
    TotalAccountInterest?: number | null ;
    TotalAmountDue?: number | null ;
    TotalDownPayment?: number | null ;
}

export interface Account_Monthy {
    AccountNumber?: string | null ;
    AccountPayoff?: number | null ;
    AccountPayoffDate?: string | null ;
    AccountType?: string | null ;
    AccountTypeText?: string | null ;
    ActivatedByUserID?: number | null ;
    ActivationDate?: string | null ;
    AdditionalInsuredNames?: string | null ;
    AddOnInterest?: number | null ;
    AgencyControlOverNoticeOfCancellation?: string | null ;
    AgentID?: number | null ;
    AmountFinanced?: number | null ;
    BalanceDue?: number | null ;
    BalanceDueNoFees?: number | null ;
    BalanceDueNoWriteOffs?: number | null ;
    BalanceDueWithFees?: number | null ;
    BuyRate?: number | null ;
    CancelConfirmed?: string | null ;
    CancelFeesDue?: number | null ;
    CancellationDate?: string | null ;
    CancelReason?: string | null ;
    CurPaymentAmount?: number | null ;
    CurPaymentNumber?: number | null ;
    CurStatusCode?: string | null ;
    CurStatusCodeText?: string | null ;
    DayBeforeCancellationDate?: string | null ;
    DepartmentCode?: string | null ;
    DownPayment?: number | null ;
    DownPaymentBalance?: number | null ;
    DownPaymentDue?: number | null ;
    EffectiveCancellationDate?: string | null ;
    EffectiveDate?: string | null ;
    EffectiveInterestRate?: number | null ;
    FeesWrittenOff?: number | null ;
    FirstPaymentDueDate?: string | null ;
    ID: number;
    InsuredID?: number | null ;
    InsuredPaymentType?: string | null ;
    InterestEarned?: number | null ;
    InterestPaid?: number | null ;
    InterestRate?: number | null ;
    InterestWrittenOff?: number | null ;
    LastPaymentDueDate?: string | null ;
    LastUpdate?: string | null ;
    LateChargesDue?: number | null ;
    MaturityDate?: string | null ;
    NextCancellationDate?: string | null ;
    NextMonthAccountPayoff?: number | null ;
    NextMonthAccountPayoffDate?: string | null ;
    NextPaymentDueDate?: string | null ;
    NextPaymentDueWithLate?: number | null ;
    NextPaymentDueWithLateDate?: string | null ;
    NextStatementDate?: string | null ;
    NSFFeesDue?: number | null ;
    NumPayments?: number | null ;
    OriginationState?: string | null ;
    OtherChargesDue?: number | null ;
    PaymentDue?: number | null ;
    PaymentType?: string | null ;
    PayoffValidDate?: string | null ;
    PolicyNumbers?: string | null ;
    PrincipalPaid?: number | null ;
    PrincipalWrittenOff?: number | null ;
    QuoteID?: number | null ;
    QuoteNumber?: string | null ;
    RateTableID?: number | null ;
    RefundPayableTo?: string | null ;
    RefundSendTo?: string | null ;
    RequireCertifiedFunds?: string | null ;
    SalesExecutiveName?: string | null ;
    SetupFeeDue?: number | null ;
    SetUpFeeWrittenOff?: number | null ;
    SignedAgreement?: string | null ;
    SiteID?: string | null ;
    SolicitorID?: number | null ;
    StatusChanged?: string | null ;
    SubStatusChanged?: string | null ;
    SubStatusCode?: string | null ;
    SubStatusString?: string | null ;
    SuspendDate?: string | null ;
    Suspended?: string | null ;
    Territory?: string | null ;
    TotalAccountInterest?: number | null ;
    TotalAmountDue?: number | null ;
}

export interface AF_byAgent_2yr_RPT {
    AgentName?: string | null ;
    City?: string | null ;
    Percent_Change?: number | null ;
    Production_Previous_YTD?: number | null ;
    Production_YTD?: number | null ;
    State?: string | null ;
}

export interface AF_byAgent_3m_1y_RPT {
    Accounts_MTD: number;
    Accounts_MTD_2: number;
    Accounts_MTD_3: number;
    AgentName?: string | null ;
    AmountFinanced_MTD: number;
    AmountFinanced_MTD_2: number;
    AmountFinanced_MTD_3: number;
    AmountFinanced_YTD: number;
    City?: string | null ;
    State?: string | null ;
}

export interface AF_byAgent_MTD {
    Accounts?: number | null ;
    AgentName?: string | null ;
    AmountFinanced?: number | null ;
    City?: string | null ;
    ID?: number | null ;
    State?: string | null ;
}

export interface AF_byAgent_MTD_2 {
    Accounts?: number | null ;
    AgentName?: string | null ;
    AmountFinanced?: number | null ;
    City?: string | null ;
    ID?: number | null ;
    State?: string | null ;
}

export interface AF_byAgent_MTD_3 {
    Accounts?: number | null ;
    AgentName?: string | null ;
    AmountFinanced?: number | null ;
    City?: string | null ;
    ID?: number | null ;
    State?: string | null ;
}

export interface AF_byAgent_YTD {
    Accounts?: number | null ;
    AgentName?: string | null ;
    AmountFinanced?: number | null ;
    City?: string | null ;
    ID?: number | null ;
    State?: string | null ;
}

export interface AF_byAgent_YTDMTD_UNION {
    AgentName?: string | null ;
    City?: string | null ;
    ID?: number | null ;
    State?: string | null ;
}

export interface AF_byAgent_YTDYTD13_UNION {
    AgentName?: string | null ;
    City?: string | null ;
    ID?: number | null ;
    State?: string | null ;
}

export interface AF_byAgent_YTD_13 {
    Accounts?: number | null ;
    AgentName?: string | null ;
    AmountFinanced?: number | null ;
    City?: string | null ;
    ID?: number | null ;
    State?: string | null ;
}

export interface AF_Summary_byTerr_MTD {
    Accounts?: number | null ;
    AmountFinanced?: number | null ;
    Territory?: string | null ;
}

export interface AF_Summary_byTerr_YTD {
    Accounts?: number | null ;
    AmountFinanced?: number | null ;
    Territory?: string | null ;
}

export interface AF_SUM_MTD {
    AmountFinanced_MTD?: number | null ;
}

export interface AF_SUM_YTD {
    AmountFinanced_YTD?: number | null ;
}

export interface AF_Threshold {
    Class: string;
    ID: number;
    Type: string;
}

export interface AF_Tiered {
    Accounts?: number | null ;
    AmountFinanced?: number | null ;
    Average_Intrest_Rate?: number | null ;
    Tier?: string | null ;
    Tier_ID?: number | null ;
}

export interface AgencyIdMappingToAMC {
    AgencyCoID?: string | null ;
    AgencyId: string;
    tempName?: string | null ;
}

export interface AgencyYTDLeavittCommVolume {
    Agency?: string | null ;
    AgencyCoID?: string | null ;
    CommercialPremium?: number | null ;
    PFAmountFin?: number | null ;
}

export interface Agent {
    Address1?: string | null ;
    Address2?: string | null ;
    Address3?: string | null ;
    City?: string | null ;
    Country?: string | null ;
    Email?: string | null ;
    Fax?: string | null ;
    FlowThrough?: number | null ;
    ID: number;
    Name?: string | null ;
    Phone?: string | null ;
    SalesExecutiveID?: number | null ;
    SalesExecutiveName?: string | null ;
    SearchCode?: string | null ;
    State?: string | null ;
    TaxID?: string | null ;
    Territory?: string | null ;
    Zip?: string | null ;
}

export interface Agent_Monthy {
    Address1?: string | null ;
    Address2?: string | null ;
    Address3?: string | null ;
    City?: string | null ;
    Country?: string | null ;
    Email?: string | null ;
    Fax?: string | null ;
    FlowThrough?: number | null ;
    ID: number;
    Name?: string | null ;
    Phone?: string | null ;
    SalesExecutiveID?: number | null ;
    SalesExecutiveName?: string | null ;
    SearchCode?: string | null ;
    State?: string | null ;
    TaxID?: string | null ;
    Territory?: string | null ;
    Zip?: string | null ;
}

export interface AllAccounts_Tiered {
    Accounts?: number | null ;
    Tier?: string | null ;
    Tier_ID?: number | null ;
}

export interface All_Payment {
    AccountID?: number | null ;
    AccountNumber?: string | null ;
    ActivityDate?: string | null ;
    AutoID: number;
    CancelFee?: number | null ;
    CurStatusCodeText?: string | null ;
    DepartmentCode: string;
    Description?: string | null ;
    EnteredByUserName?: string | null ;
    LateCharge?: number | null ;
    NSFFee?: number | null ;
    Other?: number | null ;
    PaymentNumber?: number | null ;
    PrincipalAndInterest?: number | null ;
    ReceiptMethod?: string | null ;
    SetupFee?: number | null ;
    Territory?: string | null ;
    TotalAmount?: number | null ;
}

export interface All_Payments_Last_Payment {
    AccountNumber?: string | null ;
    Activity_Date?: string | null ;
}

export interface All_Payments_with_NSF {
    AccountID?: number | null ;
    AccountNumber?: string | null ;
    ActivityDate?: string | null ;
    AutoID: number;
    CancelFee?: number | null ;
    CurStatusCodeText?: string | null ;
    DepartmentCode: string;
    Description?: string | null ;
    EnteredByUserName?: string | null ;
    LateCharge?: number | null ;
    NSF_Count: number;
    NSFFee?: number | null ;
    Other?: number | null ;
    PaymentNumber?: number | null ;
    PrincipalAndInterest?: number | null ;
    ReceiptMethod?: string | null ;
    SetupFee?: number | null ;
    Territory?: string | null ;
    TotalAmount?: number | null ;
}

export interface AM_Best_Datum {
    AMBestGroupName?: string | null ;
    AMBestNumber?: string | null ;
    BondOutlook?: string | null ;
    BondRating?: string | null ;
    Domicile?: string | null ;
    Outlook?: string | null ;
    Rating?: string | null ;
}

export interface BalanceVer_Income_MTD {
    FeeIncome?: number | null ;
    Gross_Income?: number | null ;
    InterestIncome?: number | null ;
    TerritoryFullName: string;
    Writeoffs?: number | null ;
}

export interface BalanceVer_Income_YTD {
    FeeIncome?: number | null ;
    Gross_Income?: number | null ;
    InterestIncome?: number | null ;
    TerritoryFullName: string;
    Writeoffs?: number | null ;
}

export interface Bankruptcy {
    Class: string;
    ID: number;
    Type: string;
}

export interface Broker {
    Address1?: string | null ;
    Address2?: string | null ;
    Address3?: string | null ;
    City?: string | null ;
    Contact?: string | null ;
    Email?: string | null ;
    Fax?: string | null ;
    ID: number;
    Name?: string | null ;
    Phone?: string | null ;
    SearchCode?: string | null ;
    State?: string | null ;
    Zip?: string | null ;
}

export interface Broker_Monthy {
    Address1?: string | null ;
    Address2?: string | null ;
    Address3?: string | null ;
    City?: string | null ;
    Contact?: string | null ;
    Email?: string | null ;
    Fax?: string | null ;
    ID: number;
    Name?: string | null ;
    Phone?: string | null ;
    SearchCode?: string | null ;
    State?: string | null ;
    Zip?: string | null ;
}

export interface Cancellations_Tiered_MTD {
    Accounts?: number | null ;
    Tier?: string | null ;
    Tier_ID?: number | null ;
}

export interface Cancellation_Rate_Tier {
    Max?: number | null ;
    Min?: number | null ;
    Tier?: string | null ;
    Tier_ID?: number | null ;
}

export interface CancelledAccounts_Tired_RPT {
    All_Accounts: number;
    Cancellation_Ratio?: number | null ;
    Cancelled_Accounts: number;
    Tier?: string | null ;
}

export interface CompenIncomAgentIDUNION {
    AgentCity?: string | null ;
    AgentID?: number | null ;
    AgentName?: string | null ;
    AgentState?: string | null ;
}

export interface CompensationvsIncome_byAgency_RPT {
    AgentCity?: string | null ;
    AgentID?: number | null ;
    AgentName?: string | null ;
    AgentState?: string | null ;
    Compensation_MTD: number;
    Compensation_PrevYTD: number;
    Compensation_YTD: number;
    Expr1?: number | null ;
    GrossIncome_MTD: number;
    GrossIncome_PrevYTD: number;
    GrossIncome_YTD: number;
}

export interface Compensation_byAgency_MTD {
    AgentCity?: string | null ;
    AgentID?: number | null ;
    AgentName?: string | null ;
    AgentState?: string | null ;
    Compensation?: number | null ;
}

export interface Compensation_byAgency_PrevYTD {
    AgentCity?: string | null ;
    AgentID?: number | null ;
    AgentName?: string | null ;
    AgentState?: string | null ;
    Compensation?: number | null ;
}

export interface Compensation_byAgency_YTD {
    AgentCity?: string | null ;
    AgentID?: number | null ;
    AgentName?: string | null ;
    AgentState?: string | null ;
    Compensation?: number | null ;
}

export interface Contact {
    AccountID?: number | null ;
    Address1?: string | null ;
    Address2?: string | null ;
    AgentID?: number | null ;
    AutoID: number;
    City?: string | null ;
    Country?: string | null ;
    Email?: string | null ;
    Fax?: string | null ;
    Name?: string | null ;
    Phone?: string | null ;
    State?: string | null ;
    UserID?: string | null ;
    Zip?: string | null ;
}

export interface Contact_Monthly {
    AccountID?: number | null ;
    Address1?: string | null ;
    Address2?: string | null ;
    AgentID?: number | null ;
    AutoID: number;
    City?: string | null ;
    Country?: string | null ;
    Email?: string | null ;
    Fax?: string | null ;
    Name?: string | null ;
    Phone?: string | null ;
    State?: string | null ;
    UserID?: string | null ;
    Zip?: string | null ;
}

export interface DAR_ALLL {
    AccountNumber?: string | null ;
    AgentName?: string | null ;
    AmountFinanced?: number | null ;
    AuditlFactor?: number | null ;
    CancellationDate?: string | null ;
    Capital_Balance_Due?: number | null ;
    DaysPastDue?: number | null ;
    Grade?: string | null ;
    InsuredName?: string | null ;
    InterestEarnedAfterCancel?: number | null ;
    NormalFactor?: number | null ;
    OVERUNDER: string;
    Tier?: string | null ;
    TierOrder?: string | null ;
}

export interface DAR_ALLL_RPT {
    AccountNumber?: string | null ;
    AgencyCommitment?: number | null ;
    AgentName?: string | null ;
    AmountFinanced?: number | null ;
    AuditlFactor?: number | null ;
    Calculated_Required_Allocation?: number | null ;
    CancellationDate?: string | null ;
    Capital_Balance_Due?: number | null ;
    CarrierGACommitment?: number | null ;
    Commitment?: string | null ;
    CommitmentFrom?: string | null ;
    Date?: string | null ;
    DaysPastDue?: number | null ;
    Grade?: string | null ;
    InsuredName?: string | null ;
    InterestEarnedAfterCancel?: number | null ;
    Net_Amount_At_Risk?: number | null ;
    NormalFactor?: number | null ;
    OVERUNDER: string;
    Tier?: string | null ;
    TierOrder?: string | null ;
    UnderAudit?: string | null ;
}

export interface DAR_Base {
    AccountNumber?: string | null ;
    AgentName?: string | null ;
    AmountFinanced?: number | null ;
    AuditlFactor?: number | null ;
    Balance?: number | null ;
    CancellationDate?: string | null ;
    Collateral?: number | null ;
    DaysPastDue?: number | null ;
    GeneralAgentName?: string | null ;
    Grade?: string | null ;
    ID?: number | null ;
    InsuranceCompanyID?: number | null ;
    InsuranceCompanyName?: string | null ;
    InsuredName?: string | null ;
    InterestEarnedAfterCancel: number;
    NextPaymentDueDate?: string | null ;
    NormalFactor?: number | null ;
    OVERUNDER: string;
    PolicyInterest?: number | null ;
    PolicyNumber?: string | null ;
    SubStatusString?: string | null ;
    Tier?: string | null ;
    TierOrder?: string | null ;
    UnearnedPremium?: number | null ;
}

export interface DAR_byTier {
    BalanceDue?: number | null ;
    TerrTier?: string | null ;
}

export interface DB_Info {
    DateOfData?: string | null ;
}

export interface DB_Info_Monthy {
    DateOfData?: string | null ;
}

export interface DB_Log {
    datetime?: string | null ;
    ID: number;
    Message?: string | null ;
}

export interface DebugDate {
    LastBusinessDay?: string | null ;
    LastDayLastMonth?: string | null ;
    MTD_13_END?: string | null ;
    MTD_END?: string | null ;
    MTD_END_2?: string | null ;
    MTD_END_3?: string | null ;
    MTD_START?: string | null ;
    MTD_START_2?: string | null ;
    MTD_START_3?: string | null ;
    NextBusinessDay?: string | null ;
    YTD_13_END?: string | null ;
    YTD_13_START?: string | null ;
    YTD_END?: string | null ;
    YTD_START?: string | null ;
}

export interface Dollar_Tier {
    Max?: number | null ;
    Min?: number | null ;
    Tier?: string | null ;
    Tier_ID?: number | null ;
}

export interface FinanceCompany {
    Address1?: string | null ;
    AgreementFax?: string | null ;
    City?: string | null ;
    CompanyCode?: string | null ;
    Contact?: string | null ;
    ContactEmail?: string | null ;
    Email?: string | null ;
    Fax?: string | null ;
    ID: number;
    LicenseNumber?: string | null ;
    Name?: string | null ;
    Phone?: string | null ;
    State?: string | null ;
    Zip?: string | null ;
}

export interface FinanceCompany_Monthy {
    Address1?: string | null ;
    AgreementFax?: string | null ;
    City?: string | null ;
    CompanyCode?: string | null ;
    Contact?: string | null ;
    ContactEmail?: string | null ;
    Email?: string | null ;
    Fax?: string | null ;
    ID: number;
    LicenseNumber?: string | null ;
    Name?: string | null ;
    Phone?: string | null ;
    State?: string | null ;
    Zip?: string | null ;
}

export interface FirstPaymentDue {
    Class: string;
    ID?: number | null ;
    Type: string;
}

export interface GeneralAgent {
    Address1?: string | null ;
    Address2?: string | null ;
    Address3?: string | null ;
    City?: string | null ;
    Contact?: string | null ;
    Email?: string | null ;
    Fax?: string | null ;
    ID: number;
    Name?: string | null ;
    Phone?: string | null ;
    SearchCode?: string | null ;
    State?: string | null ;
    Zip?: string | null ;
}

export interface GeneralAgent_Monthy {
    Address1?: string | null ;
    Address2?: string | null ;
    Address3?: string | null ;
    City?: string | null ;
    Contact?: string | null ;
    Email?: string | null ;
    Fax?: string | null ;
    ID: number;
    Name?: string | null ;
    Phone?: string | null ;
    SearchCode?: string | null ;
    State?: string | null ;
    Zip?: string | null ;
}

export interface GLBaseLBDFISERVFormattedBaseBalanceCheck {
    _400?: number | null ;
    _500?: number | null ;
    GL_Account?: string | null ;
}

export interface GLBaseLBDFISERVFormattedBaseFinal {
    ActivityDate?: string | null ;
    Amount?: string | null ;
    Check_Number: string;
    Entry_Description?: string | null ;
    Filler: string;
    GL_Account?: string | null ;
    Max_Number_of_Times: string;
    Memo_Post_Flag: string;
    Recurring_Frequency: string;
    Reversal_Flag: string;
    Trace_Number: string;
    Tran_Code?: string | null ;
}

export interface GL_Agent_Compensation {
    AccountID?: number | null ;
    Activity?: string | null ;
    ActivityDate?: string | null ;
    Amount?: number | null ;
    Description?: string | null ;
    EntryType?: string | null ;
    GLAccountName?: string | null ;
    GLAccountNumber?: string | null ;
    GLAccountTypeID?: number | null ;
    GLEntryID: number;
    ObjectDetailTypeID?: number | null ;
    ObjectType?: string | null ;
    ObjectTypeID?: number | null ;
    PolicyID?: number | null ;
    UserID?: number | null ;
    UserName?: string | null ;
}

export interface GL_Agent_Compensation_Base {
    ActivityDate?: string | null ;
    AgentCity?: string | null ;
    AgentID?: number | null ;
    AgentName?: string | null ;
    AgentState?: string | null ;
    Compensation?: number | null ;
    GLEntryID: number;
    Territory?: string | null ;
}

export interface GL_Agent_Compensation_Base_Monthly {
    ActivityDate?: string | null ;
    AgentCity?: string | null ;
    AgentID?: number | null ;
    AgentName?: string | null ;
    AgentState?: string | null ;
    Compensation?: number | null ;
    GLEntryID: number;
    Territory?: string | null ;
}

export interface GL_Agent_Compensation_Monthly {
    AccountID?: number | null ;
    Activity?: string | null ;
    ActivityDate?: string | null ;
    Amount?: number | null ;
    Description?: string | null ;
    EntryType?: string | null ;
    GLAccountName?: string | null ;
    GLAccountNumber?: string | null ;
    GLAccountTypeID?: number | null ;
    GLEntryID: number;
    ObjectDetailTypeID?: number | null ;
    ObjectType?: string | null ;
    ObjectTypeID?: number | null ;
    PolicyID?: number | null ;
    UserID?: number | null ;
    UserName?: string | null ;
}

export interface GL_Base {
    AccountID?: number | null ;
    AccountNumber?: string | null ;
    AccountPayoff?: number | null ;
    AccountPayoffDate?: string | null ;
    AccountType?: string | null ;
    AccountTypeText?: string | null ;
    ActivatedByUserID?: number | null ;
    ActivationDate?: string | null ;
    ActivationDateMMMyyyy?: string | null ;
    Activity?: string | null ;
    ActivityDate?: string | null ;
    AdditionalInsuredNames?: string | null ;
    AddOnInterest?: number | null ;
    AgencyControlOverNoticeOfCancellation?: string | null ;
    AgentID?: number | null ;
    Amount?: number | null ;
    AmountFinanced?: number | null ;
    BalanceDue?: number | null ;
    BalanceDueNoFees?: number | null ;
    BalanceDueNoWriteOffs?: number | null ;
    BalanceDueWithFees?: number | null ;
    BuyRate?: number | null ;
    CancelConfirmed?: string | null ;
    CancelFeesDue?: number | null ;
    CancellationDate?: string | null ;
    CancelReason?: string | null ;
    City?: string | null ;
    CurPaymentAmount?: number | null ;
    CurPaymentNumber?: number | null ;
    CurStatusCode?: string | null ;
    CurStatusCodeText?: string | null ;
    Database2?: string | null ;
    DayBeforeCancellationDate?: string | null ;
    DepartmentCode?: string | null ;
    Description?: string | null ;
    DownPayment?: number | null ;
    DownPaymentBalance?: number | null ;
    DownPaymentDue?: number | null ;
    EffectiveCancellationDate?: string | null ;
    EffectiveDate?: string | null ;
    EffectiveInterestRate?: number | null ;
    EntryType?: string | null ;
    FeesWrittenOff?: number | null ;
    FirstPaymentDueDate?: string | null ;
    GLAccountName?: string | null ;
    GLAccountNumber?: string | null ;
    GLAccountTypeID?: number | null ;
    GLEntryID: number;
    Guaranteed?: string | null ;
    ID?: number | null ;
    InsuredFullStateName?: string | null ;
    InsuredID?: number | null ;
    InsuredPaymentType?: string | null ;
    InterestDeffered?: number | null ;
    InterestEarned?: number | null ;
    InterestPaid?: number | null ;
    InterestRate?: number | null ;
    InterestWrittenOff?: number | null ;
    LastPaymentDueDate?: string | null ;
    LastUpdate?: string | null ;
    LateChargesDue?: number | null ;
    MaturityDate?: string | null ;
    Name?: string | null ;
    NextCancellationDate?: string | null ;
    NextMonthAccountPayoff?: number | null ;
    NextMonthAccountPayoffDate?: string | null ;
    NextPaymentDueDate?: string | null ;
    NextPaymentDueWithLate?: number | null ;
    NextPaymentDueWithLateDate?: string | null ;
    NextStatementDate?: string | null ;
    NSFFeesDue?: number | null ;
    NumPayments?: number | null ;
    ObjectDetailTypeID?: number | null ;
    ObjectType?: string | null ;
    ObjectTypeID?: number | null ;
    OriginationState?: string | null ;
    OtherChargesDue?: number | null ;
    PaymentDue?: number | null ;
    PaymentType?: string | null ;
    PayoffValidDate?: string | null ;
    PolicyID?: number | null ;
    PolicyNumbers?: string | null ;
    PrincipalPaid?: number | null ;
    PrincipalWrittenOff?: number | null ;
    QuoteID?: number | null ;
    QuoteNumber?: string | null ;
    RateTableID?: number | null ;
    RefundPayableTo?: string | null ;
    RefundSendTo?: string | null ;
    RequireCertifiedFunds?: string | null ;
    SalesExecutiveName?: string | null ;
    Search_Code?: string | null ;
    SetupFeeDue?: number | null ;
    SetUpFeeWrittenOff?: number | null ;
    SignedAgreement?: string | null ;
    SiteID?: string | null ;
    SolicitorID?: number | null ;
    State?: string | null ;
    StatusChanged?: string | null ;
    SubStatusChanged?: string | null ;
    SubStatusString?: string | null ;
    SuspendDate?: string | null ;
    Suspended?: string | null ;
    Territory?: string | null ;
    TerritoryFullName?: string | null ;
    TotalAccountInterest?: number | null ;
    TotalAmountDue?: number | null ;
    TotalDownPayment?: number | null ;
    UserID?: number | null ;
    UserName?: string | null ;
}

export interface GL_Base_LBD {
    AccountID?: number | null ;
    AccountNumber?: string | null ;
    Activity?: string | null ;
    ActivityDate?: string | null ;
    Amount?: number | null ;
    Description: string;
    EntryType?: string | null ;
    GLAccountName?: string | null ;
    GLAccountNumber?: string | null ;
    GLAccountTypeID?: number | null ;
    GLEntryID: number;
    ObjectDetailTypeID?: number | null ;
    ObjectType?: string | null ;
    ObjectTypeID?: number | null ;
    PolicyID?: number | null ;
    UserID?: number | null ;
    UserName?: string | null ;
}

export interface GL_Base_LBD_FISERV_Formatted_Base {
    ActivityDate?: string | null ;
    Amount?: number | null ;
    Check_Number: string;
    Entry_Description?: string | null ;
    Filler: string;
    GL_Account?: string | null ;
    Max_Number_of_Times: string;
    Memo_Post_Flag: string;
    Recurring_Frequency: string;
    Reversal_Flag: string;
    Trace_Number: string;
    Tran_Code?: string | null ;
}

export interface GL_Base_Monthly {
    AccountID?: number | null ;
    AccountNumber?: string | null ;
    AccountPayoff?: number | null ;
    AccountPayoffDate?: string | null ;
    AccountType?: string | null ;
    AccountTypeText?: string | null ;
    ActivatedByUserID?: number | null ;
    ActivationDate?: string | null ;
    ActivationDateMMMyyyy?: string | null ;
    Activity?: string | null ;
    ActivityDate?: string | null ;
    AdditionalInsuredNames?: string | null ;
    AddOnInterest?: number | null ;
    AgencyControlOverNoticeOfCancellation?: string | null ;
    AgentID?: number | null ;
    Amount?: number | null ;
    AmountFinanced?: number | null ;
    BalanceDue?: number | null ;
    BalanceDueNoFees?: number | null ;
    BalanceDueNoWriteOffs?: number | null ;
    BalanceDueWithFees?: number | null ;
    BuyRate?: number | null ;
    CancelConfirmed?: string | null ;
    CancelFeesDue?: number | null ;
    CancellationDate?: string | null ;
    CancelReason?: string | null ;
    City?: string | null ;
    CurPaymentAmount?: number | null ;
    CurPaymentNumber?: number | null ;
    CurStatusCode?: string | null ;
    CurStatusCodeText?: string | null ;
    Database2?: string | null ;
    DayBeforeCancellationDate?: string | null ;
    DepartmentCode?: string | null ;
    Description?: string | null ;
    DownPayment?: number | null ;
    DownPaymentBalance?: number | null ;
    DownPaymentDue?: number | null ;
    EffectiveCancellationDate?: string | null ;
    EffectiveDate?: string | null ;
    EffectiveInterestRate?: number | null ;
    EntryType?: string | null ;
    FeesWrittenOff?: number | null ;
    FirstPaymentDueDate?: string | null ;
    GLAccountName?: string | null ;
    GLAccountNumber?: string | null ;
    GLAccountTypeID?: number | null ;
    GLEntryID: number;
    Guaranteed?: string | null ;
    ID?: number | null ;
    InsuredFullStateName?: string | null ;
    InsuredID?: number | null ;
    InsuredPaymentType?: string | null ;
    InterestDeffered?: number | null ;
    InterestEarned?: number | null ;
    InterestPaid?: number | null ;
    InterestRate?: number | null ;
    InterestWrittenOff?: number | null ;
    LastPaymentDueDate?: string | null ;
    LastUpdate?: string | null ;
    LateChargesDue?: number | null ;
    MaturityDate?: string | null ;
    Name?: string | null ;
    NextCancellationDate?: string | null ;
    NextMonthAccountPayoff?: number | null ;
    NextMonthAccountPayoffDate?: string | null ;
    NextPaymentDueDate?: string | null ;
    NextPaymentDueWithLate?: number | null ;
    NextPaymentDueWithLateDate?: string | null ;
    NextStatementDate?: string | null ;
    NSFFeesDue?: number | null ;
    NumPayments?: number | null ;
    ObjectDetailTypeID?: number | null ;
    ObjectType?: string | null ;
    ObjectTypeID?: number | null ;
    OriginationState?: string | null ;
    OtherChargesDue?: number | null ;
    PaymentDue?: number | null ;
    PaymentType?: string | null ;
    PayoffValidDate?: string | null ;
    PolicyID?: number | null ;
    PolicyNumbers?: string | null ;
    PrincipalPaid?: number | null ;
    PrincipalWrittenOff?: number | null ;
    QuoteID?: number | null ;
    QuoteNumber?: string | null ;
    RateTableID?: number | null ;
    RefundPayableTo?: string | null ;
    RefundSendTo?: string | null ;
    RequireCertifiedFunds?: string | null ;
    SalesExecutiveName?: string | null ;
    Search_Code?: string | null ;
    SetupFeeDue?: number | null ;
    SetUpFeeWrittenOff?: number | null ;
    SignedAgreement?: string | null ;
    SiteID?: string | null ;
    SolicitorID?: number | null ;
    State?: string | null ;
    StatusChanged?: string | null ;
    SubStatusChanged?: string | null ;
    SubStatusString?: string | null ;
    SuspendDate?: string | null ;
    Suspended?: string | null ;
    Territory?: string | null ;
    TerritoryFullName?: string | null ;
    TotalAccountInterest?: number | null ;
    TotalAmountDue?: number | null ;
    TotalDownPayment?: number | null ;
    UserID?: number | null ;
    UserName?: string | null ;
}

export interface GL_FeeIncome {
    AccountID?: number | null ;
    Activity?: string | null ;
    ActivityDate?: string | null ;
    Amount?: number | null ;
    EntryType?: string | null ;
    GLEntryID: number;
}

export interface GL_FeeIncome_Base {
    ActivityDate?: string | null ;
    FeeIncome?: number | null ;
    GLEntryID: number;
    ID?: number | null ;
    Territory?: string | null ;
    TerritoryFullName?: string | null ;
}

export interface GL_FeeIncome_Base_Monthly {
    ActivityDate?: string | null ;
    FeeIncome?: number | null ;
    GLEntryID: number;
    ID?: number | null ;
    Territory?: string | null ;
    TerritoryFullName?: string | null ;
}

export interface Gl_FeeIncome_GroupbyTerr_MTD {
    FeeIncome?: number | null ;
    TerritoryFullName?: string | null ;
}

export interface Gl_FeeIncome_GroupbyTerr_YTD {
    FeeIncome?: number | null ;
    TerritoryFullName?: string | null ;
}

export interface GL_FeeIncome_Monthly {
    AccountID?: number | null ;
    Activity?: string | null ;
    ActivityDate?: string | null ;
    Amount?: number | null ;
    EntryType?: string | null ;
    GLEntryID: number;
}

export interface GL_Funding_Base {
    AccountID?: number | null ;
    ActivityDate?: string | null ;
    Amount?: number | null ;
}

export interface GL_GrossIncome {
    AccountID?: number | null ;
    Activity?: string | null ;
    ActivityDate?: string | null ;
    Amount?: number | null ;
    EntryType?: string | null ;
    GLEntryID: number;
}

export interface GL_GrossIncome_Base {
    ActivityDate?: string | null ;
    AgentCity?: string | null ;
    AgentID?: number | null ;
    AgentName?: string | null ;
    AgentState?: string | null ;
    GLEntryID: number;
    GrossIncome?: number | null ;
    InsuredFullStateName?: string | null ;
    Territory?: string | null ;
    TerritoryFullName?: string | null ;
}

export interface GL_GrossIncome_Base_Monthly {
    ActivityDate?: string | null ;
    AgentCity?: string | null ;
    AgentID?: number | null ;
    AgentName?: string | null ;
    AgentState?: string | null ;
    GLEntryID: number;
    GrossIncome?: number | null ;
    InsuredFullStateName?: string | null ;
    Territory?: string | null ;
    TerritoryFullName?: string | null ;
}

export interface GL_GrossIncome_Monthly {
    AccountID?: number | null ;
    Activity?: string | null ;
    ActivityDate?: string | null ;
    Amount?: number | null ;
    EntryType?: string | null ;
    GLEntryID: number;
}

export interface GL_InterestEarned {
    AccountID?: number | null ;
    Activity?: string | null ;
    ActivityDate?: string | null ;
    Amount?: number | null ;
    Description?: string | null ;
    EntryType?: string | null ;
    GLAccountName?: string | null ;
    GLAccountNumber?: string | null ;
    GLAccountTypeID?: number | null ;
    GLEntryID: number;
    ObjectDetailTypeID?: number | null ;
    ObjectType?: string | null ;
    ObjectTypeID?: number | null ;
    PolicyID?: number | null ;
    UserID?: number | null ;
    UserName?: string | null ;
}

export interface GL_InterestEarned_Monthly {
    AccountID?: number | null ;
    Activity?: string | null ;
    ActivityDate?: string | null ;
    Amount?: number | null ;
    Description?: string | null ;
    EntryType?: string | null ;
    GLAccountName?: string | null ;
    GLAccountNumber?: string | null ;
    GLAccountTypeID?: number | null ;
    GLEntryID: number;
    ObjectDetailTypeID?: number | null ;
    ObjectType?: string | null ;
    ObjectTypeID?: number | null ;
    PolicyID?: number | null ;
    UserID?: number | null ;
    UserName?: string | null ;
}

export interface GL_InterestIncome {
    AccountID?: number | null ;
    Activity?: string | null ;
    ActivityDate?: string | null ;
    Amount?: number | null ;
    EntryType?: string | null ;
    GLEntryID: number;
}

export interface GL_InterestIncome_Base {
    ActivityDate?: string | null ;
    EffectiveDate?: string | null ;
    GLEntryID: number;
    ID?: number | null ;
    InsuredFullStateName?: string | null ;
    InterestIncome?: number | null ;
    Territory?: string | null ;
    TerritoryFullName?: string | null ;
}

export interface GL_InterestIncome_Base_Monthly {
    ActivityDate?: string | null ;
    EffectiveDate?: string | null ;
    GLEntryID: number;
    ID?: number | null ;
    InsuredFullStateName?: string | null ;
    InterestIncome?: number | null ;
    Territory?: string | null ;
    TerritoryFullName?: string | null ;
}

export interface GL_InterestIncome_Monthly {
    AccountID?: number | null ;
    Activity?: string | null ;
    ActivityDate?: string | null ;
    Amount?: number | null ;
    EntryType?: string | null ;
    GLEntryID: number;
}

export interface GL_Writeoff {
    AccountID?: number | null ;
    Activity?: string | null ;
    ActivityDate?: string | null ;
    Amount?: number | null ;
    EntryType?: string | null ;
    GLEntryID: number;
}

export interface GL_Writeoffs_Base {
    ActivityDate?: string | null ;
    GLEntryID: number;
    TerritoryFullName?: string | null ;
    Writeoffs?: number | null ;
}

export interface GL_Writeoffs_Base_Monthly {
    ActivityDate?: string | null ;
    GLEntryID: number;
    TerritoryFullName?: string | null ;
    Writeoffs?: number | null ;
}

export interface Gl_Writeoffs_groupbyTerr_MTD {
    TerritoryFullName?: string | null ;
    Writeoffs?: number | null ;
}

export interface Gl_Writeoffs_groupbyTerr_YTD {
    TerritoryFullName?: string | null ;
    Writeoffs?: number | null ;
}

export interface GL_Writeoffs_Monthly {
    AccountID?: number | null ;
    Activity?: string | null ;
    ActivityDate?: string | null ;
    Amount?: number | null ;
    EntryType?: string | null ;
    GLEntryID: number;
}

export interface GrossIncome_byAgency_MTD {
    AgentCity?: string | null ;
    AgentID?: number | null ;
    AgentName?: string | null ;
    AgentState?: string | null ;
    GrossIncome?: number | null ;
}

export interface GrossIncome_byAgency_PrevYTD {
    AgentCity?: string | null ;
    AgentID?: number | null ;
    AgentName?: string | null ;
    AgentState?: string | null ;
    GrossIncome?: number | null ;
}

export interface GrossIncome_byAgency_YTD {
    AgentCity?: string | null ;
    AgentID?: number | null ;
    AgentName?: string | null ;
    AgentState?: string | null ;
    GrossIncome?: number | null ;
}

export interface IC_Rating {
    Class: string;
    ID?: number | null ;
    Type: string;
}

export interface InsuranceCarrierGrouping {
    _15kLB?: number | null ;
    _30kLB?: number | null ;
    _50kLB?: number | null ;
    Balance?: number | null ;
    IC_Group?: string | null ;
    IC_Name?: string | null ;
    IC_Rating?: string | null ;
    ID?: number | null ;
}

export interface InsuranceCompany {
    Address1?: string | null ;
    Address2?: string | null ;
    Address3?: string | null ;
    City?: string | null ;
    Contact?: string | null ;
    Email?: string | null ;
    Fax?: string | null ;
    ID: number;
    Name?: string | null ;
    Phone?: string | null ;
    SearchCode?: string | null ;
    State?: string | null ;
    Zip?: string | null ;
}

export interface InsuranceCompanyManual {
    Address1?: string | null ;
    Address2?: string | null ;
    AggregateOutstandingsLimit?: string | null ;
    AMBest?: string | null ;
    AMBestGroupNumber?: string | null ;
    AMBestNumber?: string | null ;
    AMBestRatingDate?: string | null ;
    AvailableBalance?: number | null ;
    BadAddress?: string | null ;
    City?: string | null ;
    CompanyType?: string | null ;
    Contact?: string | null ;
    Country?: string | null ;
    DateCreated?: string | null ;
    Email?: string | null ;
    Fax?: string | null ;
    GAOwnerName?: string | null ;
    HomeOfficeName?: string | null ;
    InternalID: number;
    NAICNumber?: string | null ;
    Name?: string | null ;
    NextReviewDate?: string | null ;
    OutstandingBalance?: number | null ;
    Phone?: string | null ;
    RemittanceSchedule?: string | null ;
    SalesExecName?: string | null ;
    SearchCode?: string | null ;
    SiteID?: number | null ;
    State?: string | null ;
    StatusDetailName?: string | null ;
    StatusName?: string | null ;
    Suspended?: number | null ;
    TaxID?: string | null ;
    Zip?: string | null ;
}

export interface InsuranceCompanyManual_wICID {
    Address1?: string | null ;
    Address2?: string | null ;
    AggregateOutstandingsLimit?: string | null ;
    AMBest?: string | null ;
    AMBestGroupNumber?: string | null ;
    AMBestNumber?: string | null ;
    AMBestRatingDate?: string | null ;
    AvailableBalance?: number | null ;
    BadAddress?: string | null ;
    City?: string | null ;
    CompanyType?: string | null ;
    Contact?: string | null ;
    Country?: string | null ;
    DateCreated?: string | null ;
    Email?: string | null ;
    Fax?: string | null ;
    GAOwnerName?: string | null ;
    HomeOfficeName?: string | null ;
    InsuranceCompanyID?: number | null ;
    InternalID: number;
    NAICNumber?: string | null ;
    Name?: string | null ;
    NextReviewDate?: string | null ;
    OutstandingBalance?: number | null ;
    Phone?: string | null ;
    RemittanceSchedule?: string | null ;
    SalesExecName?: string | null ;
    SearchCode?: string | null ;
    SiteID?: number | null ;
    State?: string | null ;
    StatusDetailName?: string | null ;
    StatusName?: string | null ;
    Suspended?: number | null ;
    TaxID?: string | null ;
    Zip?: string | null ;
}

export interface InsuranceCompanyManual_wICID_Monthly {
    Address1?: string | null ;
    Address2?: string | null ;
    AggregateOutstandingsLimit?: string | null ;
    AMBest?: string | null ;
    AMBestGroupNumber?: string | null ;
    AMBestNumber?: string | null ;
    AMBestRatingDate?: string | null ;
    AvailableBalance?: number | null ;
    BadAddress?: string | null ;
    City?: string | null ;
    CompanyType?: string | null ;
    Contact?: string | null ;
    Country?: string | null ;
    DateCreated?: string | null ;
    Email?: string | null ;
    Fax?: string | null ;
    GAOwnerName?: string | null ;
    HomeOfficeName?: string | null ;
    InsuranceCompanyID?: number | null ;
    InternalID: number;
    NAICNumber?: string | null ;
    Name?: string | null ;
    NextReviewDate?: string | null ;
    OutstandingBalance?: number | null ;
    Phone?: string | null ;
    RemittanceSchedule?: string | null ;
    SalesExecName?: string | null ;
    SearchCode?: string | null ;
    SiteID?: number | null ;
    State?: string | null ;
    StatusDetailName?: string | null ;
    StatusName?: string | null ;
    Suspended?: number | null ;
    TaxID?: string | null ;
    Zip?: string | null ;
}

export interface InsuranceCompany_AMBEST {
    Address1?: string | null ;
    Address2?: string | null ;
    Address3?: string | null ;
    AggregateOutstandingsLimit?: string | null ;
    AMBest?: string | null ;
    AMBestGroupNumber?: string | null ;
    AMBestNumber?: string | null ;
    AMBestRatingDate?: string | null ;
    AMBestValid?: boolean | null ;
    AvailableBalance?: number | null ;
    BadAddress?: string | null ;
    City?: string | null ;
    CompanyType?: string | null ;
    Contact?: string | null ;
    Country?: string | null ;
    DateCreated?: string | null ;
    Email?: string | null ;
    Fax?: string | null ;
    GAOwnerName?: string | null ;
    HomeOfficeName?: string | null ;
    ID: number;
    NAICNumber?: string | null ;
    Name?: string | null ;
    NextReviewDate?: string | null ;
    OutstandingBalance?: number | null ;
    Phone?: string | null ;
    RemittanceSchedule?: string | null ;
    SalesExecName?: string | null ;
    SearchCode?: string | null ;
    State?: string | null ;
    StatusDetailName?: string | null ;
    StatusName?: string | null ;
    Suspended?: number | null ;
    TaxID?: string | null ;
    Zip?: string | null ;
}

export interface InsuranceCompany_AMBEST_Monthly {
    Address1?: string | null ;
    Address2?: string | null ;
    Address3?: string | null ;
    AggregateOutstandingsLimit?: string | null ;
    AMBest?: string | null ;
    AMBestGroupNumber?: string | null ;
    AMBestNumber?: string | null ;
    AMBestRatingDate?: string | null ;
    AMBestValid?: boolean | null ;
    AvailableBalance?: number | null ;
    BadAddress?: string | null ;
    City?: string | null ;
    CompanyType?: string | null ;
    Contact?: string | null ;
    Country?: string | null ;
    DateCreated?: string | null ;
    Email?: string | null ;
    Fax?: string | null ;
    GAOwnerName?: string | null ;
    HomeOfficeName?: string | null ;
    ID: number;
    NAICNumber?: string | null ;
    Name?: string | null ;
    NextReviewDate?: string | null ;
    OutstandingBalance?: number | null ;
    Phone?: string | null ;
    RemittanceSchedule?: string | null ;
    SalesExecName?: string | null ;
    SearchCode?: string | null ;
    State?: string | null ;
    StatusDetailName?: string | null ;
    StatusName?: string | null ;
    Suspended?: number | null ;
    TaxID?: string | null ;
    Zip?: string | null ;
}

export interface InsuranceCompany_Monthy {
    Address1?: string | null ;
    Address2?: string | null ;
    Address3?: string | null ;
    City?: string | null ;
    Contact?: string | null ;
    Email?: string | null ;
    Fax?: string | null ;
    ID: number;
    Name?: string | null ;
    Phone?: string | null ;
    SearchCode?: string | null ;
    State?: string | null ;
    Zip?: string | null ;
}

export interface Insured {
    Address1?: string | null ;
    Address2?: string | null ;
    Address3?: string | null ;
    AgentCustomerID?: string | null ;
    AgentID?: number | null ;
    City?: string | null ;
    CompanyName?: string | null ;
    ContactName?: string | null ;
    Country?: string | null ;
    DBAName?: string | null ;
    DUNS?: string | null ;
    Email?: string | null ;
    Fax?: string | null ;
    FEIN?: string | null ;
    GroupCode?: string | null ;
    ID: number;
    NAICSCode: number;
    Name?: string | null ;
    Phone?: string | null ;
    RiskAddress1?: string | null ;
    RiskAddress2?: string | null ;
    RiskAddress3?: string | null ;
    RiskCity?: string | null ;
    RiskCountry?: string | null ;
    RiskState?: string | null ;
    RiskZip?: string | null ;
    SearchCode?: string | null ;
    State?: string | null ;
    YearsInBusiness?: string | null ;
    Zip?: string | null ;
}

export interface Insured_100 {
    Address1?: string | null ;
    Address2?: string | null ;
    Address3?: string | null ;
    AgentCustomerID?: string | null ;
    AgentID?: number | null ;
    City?: string | null ;
    CompanyName?: string | null ;
    ContactName?: string | null ;
    Country?: string | null ;
    DBAName?: string | null ;
    DUNS?: string | null ;
    Email?: string | null ;
    Fax?: string | null ;
    FEIN?: string | null ;
    GroupCode?: string | null ;
    ID: number;
    NAICSCode?: number | null ;
    NAICSCode2Digit?: string | null ;
    Name?: string | null ;
    Phone?: string | null ;
    RiskAddress1?: string | null ;
    RiskAddress2?: string | null ;
    RiskAddress3?: string | null ;
    RiskCity?: string | null ;
    RiskCountry?: string | null ;
    RiskState?: string | null ;
    RiskZip?: string | null ;
    SearchCode?: string | null ;
    State?: string | null ;
    YearsInBusiness?: string | null ;
    Zip?: string | null ;
}

export interface Insured_100_Monthly {
    Address1?: string | null ;
    Address2?: string | null ;
    Address3?: string | null ;
    AgentCustomerID?: string | null ;
    AgentID?: number | null ;
    City?: string | null ;
    CompanyName?: string | null ;
    ContactName?: string | null ;
    Country?: string | null ;
    DBAName?: string | null ;
    DUNS?: string | null ;
    Email?: string | null ;
    Fax?: string | null ;
    FEIN?: string | null ;
    GroupCode?: string | null ;
    ID: number;
    NAICSCode?: number | null ;
    NAICSCode2Digit?: string | null ;
    Name?: string | null ;
    Phone?: string | null ;
    RiskAddress1?: string | null ;
    RiskAddress2?: string | null ;
    RiskAddress3?: string | null ;
    RiskCity?: string | null ;
    RiskCountry?: string | null ;
    RiskState?: string | null ;
    RiskZip?: string | null ;
    SearchCode?: string | null ;
    State?: string | null ;
    YearsInBusiness?: string | null ;
    Zip?: string | null ;
}

export interface Insured_Monthy {
    Address1?: string | null ;
    Address2?: string | null ;
    Address3?: string | null ;
    AgentCustomerID?: string | null ;
    AgentID?: number | null ;
    City?: string | null ;
    CompanyName?: string | null ;
    ContactName?: string | null ;
    Country?: string | null ;
    DBAName?: string | null ;
    DUNS?: string | null ;
    Email?: string | null ;
    Fax?: string | null ;
    FEIN?: string | null ;
    GroupCode?: string | null ;
    ID: number;
    NAICSCode?: number | null ;
    Name?: string | null ;
    Phone?: string | null ;
    RiskAddress1?: string | null ;
    RiskAddress2?: string | null ;
    RiskAddress3?: string | null ;
    RiskCity?: string | null ;
    RiskCountry?: string | null ;
    RiskState?: string | null ;
    RiskZip?: string | null ;
    SearchCode?: string | null ;
    State?: string | null ;
    YearsInBusiness?: string | null ;
    Zip?: string | null ;
}

export interface InterestEarnedAfterCancel {
    AccountID?: number | null ;
    InterestEarnedAfterCancel1?: number | null ;
}

export interface InterestIncome_groupbyTerr_MTD {
    InterestIncome?: number | null ;
    TerritoryFullName?: string | null ;
}

export interface InterestIncome_groupbyTerr_YTD {
    InterestIncome?: number | null ;
    TerritoryFullName?: string | null ;
}

export interface LB_byAgency_LA {
    Accounts?: number | null ;
    BalanceDue?: number | null ;
    City?: string | null ;
    Name?: string | null ;
    State?: string | null ;
}

export interface lb_byCoverageType {
    Balance?: number | null ;
    OVERUNDER: string;
    Policies?: number | null ;
    PolicyType?: string | null ;
}

export interface lb_byGeneralAgent {
    _12_Month_Average_Cancellation_Rate_?: number | null ;
    Amount_At_Risk?: number | null ;
    Balance?: number | null ;
    GA_GROUP: string;
    OVERUNDER: string;
    Polices?: number | null ;
    WIP_at_GA_Max_Months: number;
}

export interface lb_byInsuredEIN {
    Accounts?: number | null ;
    Balance?: number | null ;
    Client?: string | null ;
    TopBottom: string;
}

export interface lb_byNAIC {
    Accounts?: number | null ;
    Industry?: string | null ;
    Ledger_Balance?: number | null ;
    State?: string | null ;
}

export interface lb_byState {
    Accounts?: number | null ;
    Ledger_Balance?: number | null ;
    StateName?: string | null ;
}

export interface LB_Summary_byTerr_byAccount {
    Accounts?: number | null ;
    BalanceDue?: number | null ;
    Territory: string;
}

export interface LB_Summary_byTerr_byAccount_AFGT15k {
    Accounts?: number | null ;
    BalanceDue?: number | null ;
    Territory: string;
}

export interface LB_Summary_byTerr_byAccount_AFLT15k {
    Accounts?: number | null ;
    BalanceDue?: number | null ;
    Territory: string;
}

export interface LB_Summary_byTerr_byPolicy {
    Balance?: number | null ;
    Policies?: number | null ;
    Territory?: string | null ;
}

export interface LB_SUM_MTD {
    BalanceDue_MTD?: number | null ;
}

export interface LeavittProduction {
    Agency?: string | null ;
    agencyCoID?: string | null ;
    CommercialPremium?: number | null ;
}

export interface Ledger {
    AccountID?: number | null ;
    Activity?: string | null ;
    ActivityDate?: string | null ;
    Amount?: number | null ;
    Description: string;
    EntryType?: string | null ;
    GLAccountName?: string | null ;
    GLAccountNumber?: string | null ;
    GLAccountTypeID?: number | null ;
    GLEntryID: number;
    ObjectDetailTypeID?: number | null ;
    ObjectType?: string | null ;
    ObjectTypeID?: number | null ;
    PolicyID?: number | null ;
    UserID?: number | null ;
    UserName?: string | null ;
}

export interface Ledger_Monthy {
    AccountID?: number | null ;
    Activity?: string | null ;
    ActivityDate?: string | null ;
    Amount?: number | null ;
    Description?: string | null ;
    EntryType?: string | null ;
    GLAccountName?: string | null ;
    GLAccountNumber?: string | null ;
    GLAccountTypeID?: number | null ;
    GLEntryID: number;
    ObjectDetailTypeID?: number | null ;
    ObjectType?: string | null ;
    ObjectTypeID?: number | null ;
    PolicyID?: number | null ;
    UserID?: number | null ;
    UserName?: string | null ;
}

export interface MEP100 {
    Class: string;
    ID?: number | null ;
    Type: string;
}

export interface NAICS_Category {
    Category?: string | null ;
    Category_Short?: string | null ;
    NAICS_2_Digit?: number | null ;
}

export interface Past_Due_Tiers_for_CreditRiskChart {
    Max?: number | null ;
    Min?: number | null ;
    Tier?: string | null ;
    Tier_ID?: number | null ;
}

export interface Payment {
    AccountID?: number | null ;
    ActivityDate?: string | null ;
    AutoID: number;
    CancelFee?: number | null ;
    DepartmentCode?: string | null ;
    Description?: string | null ;
    EnteredByUserName?: string | null ;
    LateCharge?: number | null ;
    NSFFee?: number | null ;
    Other?: number | null ;
    PaymentNumber?: number | null ;
    PrincipalAndInterest?: number | null ;
    ReceiptMethod?: string | null ;
    SetupFee?: number | null ;
    Territory?: string | null ;
    TotalAmount?: number | null ;
}

export interface Payment_Monthy {
    AccountID?: number | null ;
    ActivityDate?: string | null ;
    AutoID: number;
    CancelFee?: number | null ;
    DepartmentCode?: string | null ;
    Description?: string | null ;
    EnteredByUserName?: string | null ;
    LateCharge?: number | null ;
    NSFFee?: number | null ;
    Other?: number | null ;
    PaymentNumber?: number | null ;
    PrincipalAndInterest?: number | null ;
    ReceiptMethod?: string | null ;
    SetupFee?: number | null ;
    Territory?: string | null ;
    TotalAmount?: number | null ;
}

export interface Policy {
    AccountAccountPayoff?: number | null ;
    AccountAmountFinanced?: number | null ;
    AccountBalanceDue?: number | null ;
    AccountID?: number | null ;
    AccountPolicyID?: number | null ;
    AgentReturnCommissionDue?: number | null ;
    AmountFinanced?: number | null ;
    Auditable?: string | null ;
    autoID: number;
    Balance?: number | null ;
    BrokerFee?: number | null ;
    BrokerID?: number | null ;
    CancellationDate?: string | null ;
    CancelTerms?: string | null ;
    CancelVerified?: string | null ;
    CarrierVerified?: string | null ;
    CoverageType?: string | null ;
    DateEntered?: string | null ;
    DepartmentCode?: string | null ;
    DownPayment?: number | null ;
    EffectiveCancelDate?: string | null ;
    EnteredByUserID?: number | null ;
    Expiration?: string | null ;
    FLDocStampFee?: number | null ;
    GeneralAgentID?: number | null ;
    GrossPremium?: number | null ;
    ID?: number | null ;
    Inception?: string | null ;
    InspectionFee?: number | null ;
    InsuranceCompanyID?: number | null ;
    InterestPaymentFactor?: number | null ;
    MinDownPayPercent?: number | null ;
    MinEarnedPercent?: number | null ;
    PolicyFee?: number | null ;
    PolicyNumber?: string | null ;
    PolicyStatus?: string | null ;
    PolicyType?: string | null ;
    PolicyVerified?: string | null ;
    PUCFilings?: string | null ;
    RemittanceDate?: string | null ;
    ShortRate?: string | null ;
    TaxStampFee?: number | null ;
    Term?: string | null ;
    Territory?: string | null ;
    UnearnedCommissionReceived?: number | null ;
    UnearnedFees?: number | null ;
    UnearnedPremium?: number | null ;
    UnearnedPremiumReceived?: number | null ;
}

export interface Policy_Monthy {
    AccountAccountPayoff?: number | null ;
    AccountAmountFinanced?: number | null ;
    AccountBalanceDue?: number | null ;
    AccountID?: number | null ;
    AccountPolicyID?: number | null ;
    AgentReturnCommissionDue?: number | null ;
    AmountFinanced?: number | null ;
    Auditable?: string | null ;
    autoID: number;
    Balance?: number | null ;
    BrokerFee?: number | null ;
    BrokerID?: number | null ;
    CancellationDate?: string | null ;
    CancelTerms?: string | null ;
    CancelVerified?: string | null ;
    CarrierVerified?: string | null ;
    CoverageType?: string | null ;
    DateEntered?: string | null ;
    DepartmentCode?: string | null ;
    DownPayment?: number | null ;
    EffectiveCancelDate?: string | null ;
    EnteredByUserID?: number | null ;
    Expiration?: string | null ;
    FLDocStampFee?: number | null ;
    GeneralAgentID?: number | null ;
    GrossPremium?: number | null ;
    ID?: number | null ;
    Inception?: string | null ;
    InspectionFee?: number | null ;
    InsuranceCompanyID?: number | null ;
    InterestPaymentFactor?: number | null ;
    MinDownPayPercent?: number | null ;
    MinEarnedPercent?: number | null ;
    PolicyFee?: number | null ;
    PolicyNumber?: string | null ;
    PolicyStatus?: string | null ;
    PolicyType?: string | null ;
    PolicyVerified?: string | null ;
    PUCFilings?: string | null ;
    RemittanceDate?: string | null ;
    ShortRate?: string | null ;
    TaxStampFee?: number | null ;
    Term?: string | null ;
    Territory?: string | null ;
    UnearnedCommissionReceived?: number | null ;
    UnearnedFees?: number | null ;
    UnearnedPremium?: number | null ;
    UnearnedPremiumReceived?: number | null ;
}

export interface State_Abbreviation {
    Abbreviation?: string | null ;
    StateName?: string | null ;
}

export interface TannerAuditMailMerge {
    AccountNumber?: string | null ;
    Amount_Outstanding?: number | null ;
    CurStatusCodeText?: string | null ;
    EffectiveInterestRate?: number | null ;
    Insured_Add1?: string | null ;
    Insured_Add2?: string | null ;
    Insured_City?: string | null ;
    Insured_Name?: string | null ;
    Insured_State?: string | null ;
    Insured_Zip?: string | null ;
    InterestPaid?: number | null ;
    LastPaymentDueDate?: string | null ;
    Loan_Commitment?: number | null ;
    MaturityDate?: string | null ;
    Origianal_Loan_Amount?: number | null ;
    TotalAccountInterest?: number | null ;
}

export interface TannerMailMergeAccList {
    AccountNum: string;
}

export interface Territory_List {
    Territory?: string | null ;
    TerritoryFullName: string;
}

export interface Test1 {
    AgentCity?: string | null ;
    AgentID?: number | null ;
    AgentName?: string | null ;
    AgentState?: string | null ;
    Compensation?: number | null ;
}

export interface UnionZionsExceptionsAccID {
    ID?: number | null ;
}

export interface WasingtonStateInvestigation {
    Account_Number?: string | null ;
    Account_Status?: string | null ;
    ActivationDate?: string | null ;
    Address1?: string | null ;
    Address2?: string | null ;
    Address3?: string | null ;
    Agency_Name?: string | null ;
    City?: string | null ;
    Country?: string | null ;
    Email?: string | null ;
    Fax?: string | null ;
    Insurance_Company_Name?: string | null ;
    Insured_Name?: string | null ;
    Ledger_Balance?: number | null ;
    Phone?: string | null ;
    Policy_Amount_Financed?: number | null ;
    Policy_Balance?: number | null ;
    Policy_Number?: number | null ;
    State?: string | null ;
    Zip?: string | null ;
}

export interface Workday {
    dteDay?: string | null ;
    dteID: number;
    dteWeekday?: string | null ;
}

export interface ZionsException {
    Exceptions?: string | null ;
    ID?: number | null ;
}

export interface ZionsLendingPolicyExceptionReport {
    AccountNumber?: string | null ;
    BalanceDue?: number | null ;
    Exception_s_?: string | null ;
    Status?: string | null ;
}

export interface AvgCancelationRate {
    avgCancelationRateID: number;
    created: string;
    createdByID: number;
    rate: number;
}

export interface BankHoliday {
    date: string;
    id: number;
    name?: string | null ;
}

export interface AbnormalPaymentReport {
    AccountNumber?: string | null ;
    AmountExpected?: number | null ;
    AmountExpectedWithLateFee?: number | null ;
    Difference?: number | null ;
    DifferenceWithLateFee?: number | null ;
    LastPaymentAmount?: number | null ;
    LastPaymentDate?: string | null ;
}

export interface AFSummaryByTerritoryCurrentMTD {
    Accounts?: number | null ;
    AmountFinanced?: number | null ;
    Territory?: string | null ;
}

export interface AFSummarybyTerrLBD {
    Accounts?: number | null ;
    AmountFinanced?: number | null ;
    Territory?: string | null ;
}

export interface AuditReport {
    AccountNumber?: string | null ;
    Address1?: string | null ;
    Address2?: string | null ;
    Address3?: string | null ;
    AmountFinanced?: number | null ;
    City?: string | null ;
    CurStatusCodeText?: string | null ;
    EffectiveInterestRate?: number | null ;
    InterestRate?: number | null ;
    LastPaymentDueDate?: string | null ;
    MaturityDate?: string | null ;
    Name?: string | null ;
    State?: string | null ;
    TotalAccountInterest?: number | null ;
    Zip?: string | null ;
}

export interface CancelReturnPremium {
    AccountNumber?: string | null ;
    ActivityDate?: string | null ;
    CancelFee?: number | null ;
    Description?: string | null ;
    EnteredByUserName?: string | null ;
    LateCharge?: number | null ;
    NSFFee?: number | null ;
    Other?: number | null ;
    PaymentNumber?: number | null ;
    PrincipalAndInterest?: number | null ;
    ReceiptMethod?: string | null ;
    SetupFee?: number | null ;
    TotalAmount?: number | null ;
}

export interface CreditRiskReport {
    AccountAmountFinanced?: number | null ;
    AccountNumber?: string | null ;
    AgentName?: string | null ;
    DateEntered?: string | null ;
    Flag?: string | null ;
    ICAMBestGroupNumber?: string | null ;
    InsuredAddr1?: string | null ;
    InsuredAddr2?: string | null ;
    InsuredAddr3?: string | null ;
    InsuredCompanyName?: string | null ;
    InsuredContactName?: string | null ;
    InsuredDBAName?: string | null ;
    InsuredDUNS?: string | null ;
    InsuredFEIN?: string | null ;
    InsuredName?: string | null ;
    InsuredPhone?: string | null ;
    PolicyAmountFinanced?: number | null ;
    PolicyID?: number | null ;
}

export interface CreditUnderwritingException {
    Account_ID: number;
    AccountNumber?: string | null ;
    Agent_Name?: string | null ;
    AmountFinanced?: number | null ;
    Auditable?: string | null ;
    DateEntered?: string | null ;
    DaysBetweenInceptionandFirstDue?: number | null ;
    DownPayment?: number | null ;
    MinDownPayPercent?: number | null ;
    MinEarnedPercent?: number | null ;
    Number_of_Payments?: number | null ;
    PaymentType?: string | null ;
    Policy_ID?: number | null ;
    PolicyNumber?: string | null ;
    PUCFilings?: string | null ;
}

export interface CreditUnderwritingExceptionsAllPolicies {
    AccountID: number;
    Balance?: number | null ;
    PolicyNumber?: string | null ;
}

export interface Credit_Underwritting_Exceptions_Account {
    Account_ID: number;
}

export interface InterestIncomeLMTD {
    ActivityDate?: string | null ;
    EffectiveDate?: string | null ;
    GLEntryID: number;
    ID?: number | null ;
    InterestIncome?: number | null ;
    Territory?: string | null ;
}

export interface LexisNexisLBDFEINAndUnknown {
    AccountNumber?: string | null ;
    Addr1?: string | null ;
    Addr2?: string | null ;
    AltCompanyName?: string | null ;
    CompanyName?: string | null ;
    Fein?: string | null ;
    NoSsnOrEin?: string | null ;
    PCityName?: string | null ;
    RepAddr1?: string | null ;
    RepPCityName?: string | null ;
    RepPhone?: string | null ;
    RepSt?: string | null ;
    RepZ5?: string | null ;
    St?: string | null ;
    Verified: string;
    Zip4?: string | null ;
}

export interface LexisNexisLBDSSN {
    AccountNumber?: string | null ;
    Addr1?: string | null ;
    Addr2?: string | null ;
    DBAName?: string | null ;
    FirstName?: string | null ;
    FullName?: string | null ;
    LastName?: string | null ;
    PCityName?: string | null ;
    RepAddr1?: string | null ;
    RepPCityName?: string | null ;
    RepPhone?: string | null ;
    RepSsn?: string | null ;
    RepSt?: string | null ;
    RepZ5?: string | null ;
    St?: string | null ;
    Verified: string;
    Zip4?: string | null ;
}

export interface LexisNexis_LBD_Base {
    account_number?: string | null ;
    addr1?: string | null ;
    addr2?: string | null ;
    alt_company_name?: string | null ;
    company_name?: string | null ;
    DBA_Name?: string | null ;
    fein?: string | null ;
    First_Name?: string | null ;
    Full_Name?: string | null ;
    Last_Name?: string | null ;
    no_ssn_or_ein?: string | null ;
    p_city_name?: string | null ;
    rep_addr1?: string | null ;
    rep_p_city_name?: string | null ;
    rep_phone?: string | null ;
    rep_ssn?: string | null ;
    rep_st?: string | null ;
    rep_z5?: string | null ;
    st?: string | null ;
    Verified: string;
    Zip4?: string | null ;
}

export interface LGADisbLBD {
    AccountNumber?: string | null ;
    Agency?: string | null ;
    CompanyName?: string | null ;
    DBAName?: string | null ;
    DisbursementAmount?: number | null ;
    EffectiveDate?: string | null ;
    InsuredName?: string | null ;
    PolicyNumbers?: string | null ;
}

export interface LGA_Disb_Base {
    AccountNumber?: string | null ;
    Activity?: string | null ;
    ActivityDate?: string | null ;
    Agency?: string | null ;
    Company_Name?: string | null ;
    DBAName?: string | null ;
    Disbursement_Amount?: number | null ;
    EffectiveDate?: string | null ;
    GLAccountName?: string | null ;
    InsuredName?: string | null ;
    PolicyNumbers?: string | null ;
    Territory?: string | null ;
}

export interface LoanOver100k {
    AccountAF?: number | null ;
    AccountNumber?: string | null ;
    AgentName?: string | null ;
    Auditable?: string | null ;
    BrokerFee?: number | null ;
    DownPaymentPercent?: number | null ;
    EffectiveDate?: string | null ;
    InspectionFee?: number | null ;
    InsuredAddr1?: string | null ;
    InsuredAddr2?: string | null ;
    InsuredAddr3?: string | null ;
    InsuredCity?: string | null ;
    InsuredDBAName?: string | null ;
    InsuredDUNS?: string | null ;
    InsuredName?: string | null ;
    InsuredPhone?: string | null ;
    InsuredState?: string | null ;
    InsuredZip?: string | null ;
    Last4EIN?: string | null ;
    NumPayments?: number | null ;
    PolicyFee?: number | null ;
    PolicyID?: number | null ;
    PolicyNumber?: string | null ;
    PUCFilings?: string | null ;
    RemittanceDate?: string | null ;
    TaxStampFee?: number | null ;
    Term?: string | null ;
    UnearnedFees?: number | null ;
}

export interface LowBalanceAccount {
    AccountNumber?: string | null ;
    ActivationDate?: string | null ;
    BalanceDue?: number | null ;
    CurPaymentAmount?: number | null ;
    InsuredName?: string | null ;
    LastPaymentDate?: string | null ;
}

export interface MissingAMBestNumbers {
    AMBestNumber?: string | null ;
    City?: string | null ;
    ID: number;
    Name?: string | null ;
    State?: string | null ;
    SumOfPolicyBalances?: number | null ;
}

export interface MissingNAICSReport {
    AccountNumber?: string | null ;
    Agent_Email?: string | null ;
    Agent_Name?: string | null ;
    Agent_Phone?: string | null ;
    CompanyName?: string | null ;
    DBAName?: string | null ;
    DUNS?: string | null ;
    Insured_ID: number;
    NAICSCode?: number | null ;
    Name?: string | null ;
    Phone?: string | null ;
}

export interface Mt_Hawley_Past_Due {
    Amount_Financed?: number | null ;
    Balance_Due?: number | null ;
    CancellationDate?: string | null ;
    CurPaymentNumber?: number | null ;
    Days_Past_Due?: number | null ;
    Insured_Name?: string | null ;
    Name?: string | null ;
    NextPaymentDueDate?: string | null ;
    NumPayments?: number | null ;
}

export interface NewAccountsLBD {
    AccountNumber?: string | null ;
    ActivationDate?: string | null ;
    DateEntered?: string | null ;
}

export interface NewAccountsLBDOFACFormatted {
    AccountNumber?: string | null ;
    DateEntered?: string | null ;
    Name?: string | null ;
}

export interface NoticeToInsured30Day {
    AccountNumber?: string | null ;
    Addr1?: string | null ;
    BalanceDue?: number | null ;
    City1?: string | null ;
    CurStatusCodeText?: string | null ;
    DBAName?: string | null ;
    InsuredName?: string | null ;
    Name?: string | null ;
    NoticeDate?: string | null ;
    PolicyNumbers?: string | null ;
}

export interface PaymentToNonCurrentAccounts {
    AccountNumber?: string | null ;
    ActivityDate?: string | null ;
    BalanceDue?: number | null ;
    CurStatusCodeText?: string | null ;
    PaymentAmount?: number | null ;
}

export interface PolicyVerificationReport {
    AccountAF?: number | null ;
    AccountNumber?: string | null ;
    ActivationDate?: string | null ;
    AgentName?: string | null ;
    Auditable?: string | null ;
    BalanceDue?: number | null ;
    DaysSinceActivation?: number | null ;
    DownPayment?: number | null ;
    GrossPremium?: number | null ;
    InsuranceCompany?: string | null ;
    MinEarnedPercent?: string | null ;
    PaymentsRemaining?: number | null ;
    PaymentType?: string | null ;
    PolicyAF?: number | null ;
    PolicyNumber?: string | null ;
    PolicyVerified?: string | null ;
    PUCFilings?: string | null ;
}

export interface QuarterlyCSRContestRandomSample {
    AccountNumber: string;
    AgentName: string;
    DefaultAgencyContact: string;
    InsuredName: string;
    Random?: number | null ;
}

export interface Return_Mail_Notice_Datum {
    AccountNumber?: string | null ;
    Agent_Address1?: string | null ;
    Agent_Address2?: string | null ;
    Agent_Address3?: string | null ;
    Agent_City?: string | null ;
    Agent_Email?: string | null ;
    Agent_Name?: string | null ;
    Agent_State?: string | null ;
    Agent_Zip?: string | null ;
    Insured_Address1?: string | null ;
    Insured_Address2?: string | null ;
    Insured_Address3?: string | null ;
    Insured_City?: string | null ;
    Insured_Name?: string | null ;
    Insured_State?: string | null ;
    Insured_Zip?: string | null ;
}

export interface RRGInsuranceCompaniesRPT {
    AMBestNumber: string;
    BalanceAvailable?: number | null ;
    BalanceDue?: number | null ;
    EntityGroupName: string;
    FlowThroughLimit?: number | null ;
    FlowThroughUsed?: number | null ;
    FlowThroughUsedPercent?: number | null ;
    LastReviewDate?: string | null ;
    Motivation: string;
    ReviewFrequencyMonths?: number | null ;
}

export interface UnknownFEIN {
    AccountNumber?: string | null ;
    CurStatusCodeText?: string | null ;
    DaysSinceActivation?: number | null ;
    FEIN?: string | null ;
    SignedAgreement?: string | null ;
}

export interface ZionsFundingReportLBD {
    AccountNumber?: string | null ;
    Agency?: string | null ;
    CompanyName?: string | null ;
    DBAName?: string | null ;
    DisbursementAmount?: number | null ;
    EffectiveDate?: string | null ;
    InsuredName?: string | null ;
    PolicyNumbers?: string | null ;
}

export interface ZionsTrialBalance {
    DateLastPaid?: string | null ;
    DaysPastDue?: number | null ;
    InterestDue?: number | null ;
    InterestRate?: number | null ;
    LoanNumber?: string | null ;
    NextPaymentDate?: string | null ;
    NSFs: string;
    ObligorName?: string | null ;
    OriginationAmount?: number | null ;
    OriginationDate?: string | null ;
    PaymentType: string;
    PrincipalBalanceDue?: number | null ;
    Status?: string | null ;
}

export interface _15_day_Notice_to_Agency {
    _5_Day_Hold_Cancel_Date?: string | null ;
    AccountNumber?: string | null ;
    CancellationDate?: string | null ;
    CompanyName?: string | null ;
    DBAName?: string | null ;
    Email?: string | null ;
    Name?: string | null ;
    Notice_Date?: string | null ;
}

export interface _30_day_Notice_to_Agency {
    AccountNumber?: string | null ;
    CurStatusCodeText?: string | null ;
    Email?: string | null ;
    Name?: string | null ;
    Notice_Date?: string | null ;
}

export interface ALLL_commitment_data {
    AccountNumber?: string | null ;
    AgencyCommitment?: number | null ;
    CarrierGACommitment?: number | null ;
    Commitment?: string | null ;
    CommitmentFrom?: string | null ;
    Date?: string | null ;
    ID: number;
    LastModified?: string | null ;
    LastModifiedBy?: string | null ;
    UnderAudit?: string | null ;
}

export interface Credit_Risk_Policy_Exceptions {
    AccountID?: string | null ;
    Class?: string | null ;
    ExceptionDate: string;
    Exceptions?: string | null ;
    LastModified: string;
    LastModifiedBy: string;
    MaxExposure?: number | null ;
    NotesCollectionActivity?: string | null ;
    ReportID: number;
}

export interface Returned_Mail_Tracking {
    AccountID: number;
    Date?: string | null ;
    LastModified?: string | null ;
    LastModifiedby?: string | null ;
    Memo?: string | null ;
}

export interface RRG_Insurance_Companies {
    AMBestNumber: string;
    Entity_Group_Name?: string | null ;
    Flow_Through_Limit?: number | null ;
    Last_Review_Date?: string | null ;
    LastModified?: string | null ;
    LastModifiedby?: string | null ;
    Motivation?: string | null ;
    Review_Frequency__Months_?: number | null ;
}