<?php

namespace App;

use Illuminate\Database\Eloquent\Model;
use Illuminate\Database\Eloquent\SoftDeletes;

class DaSystemData extends Model
{
    use SoftDeletes;
    protected $table = 'da_system_data';

    protected $fillable = [
        'company_id', 'partner_id', 'cust_id', 'loan_no', 'pool', 'member_name',
        'date_of_birth', 'age', 'mobile_number', 'nominee_name', 'nominee_dob',
        'nominee_age', 'nominee_relation', 'spouse_name', 'father_name', 'caste',
        'religion', 'disbursement_date', 'rural_urban', 'purpose_id', 'sub_purpose',
        'status', 'closure_remark', 'aadhaar_id', 'loan_created_on', 'address',
        'village_name', 'district', 'state', 'pincode', 'funder_id',
        'fund_allocation_date', 'lender_id', 'branch_name', 'branch_state', 'region',
        'lo_name', 'bank_account', 'bank_ifsc_code', 'disburse_by_fo', 'empcode',
        'principal_arrear', 'interest_arrear', 'total_arrear', 'prin_collected', 'int_collected',
        'first_due_amount', 'first_demand_date', 'is_qualify', 'last_maturity_date', 'remaining_maturity',
        'last_coll_date', 'last_coll_amount', 'od_days', 'od_bucket', 'product_category_id',
        'product_id', 'principal_total', 'int_rate', 'processing_fee', 'tenure',
        'total_interest', 'total_instal', 'instal_os', 'insurance_id', 'fo_id',
        'payment_ref_number', 'cycle', 'repayment_frequency', 'next_demand_date', 'loan_closure_date',
        'insurance_charges', 'prod_classification', 'repayment_mode', 'repayment_bank', 'insurance_maturity_date',
        'outstanding_principal', 'outstanding_interest', 'netoff_amount', 'document_charges', 'stampduty_charges',
        'legal_fee', 'application_fee', 'pre_emi_amt', 'fee_pay_mode', 'npa_date',
        'excess_amount', 'waiveoff_amount', 'od_interest_collected_till_date', 'loan_charges', 'write_off_amount',
        'city', 'customer_type', 'w_off_settlement', 'disbursement_amount', 'disb_bank_name',
        'advance_emi', 'mode_of_repayment', 'inst_amt_rs', 'over_due_inst', 'over_due_amount_rs',
        'foir_percent', 'credit_score', 'aadhar_number', 'pan_card_number', 'peak_dpd',
        'dpd_string', 'monthly_income', 'business_vintage', 'residence_vintage', 'business_premises',
        'co_borrower_name', 'co_borrower_contact_no', 'gender', 'uploaded_file', 'created_by'
    ];
}