|
id
|
int(11)
|
|
|
|
|
emp_id
|
varchar(10)
|
latin1_swedish_ci
|
|
|
|
pay_month
|
varchar(10)
|
latin1_swedish_ci
|
|
|
|
financial_year
|
varchar(10)
|
latin1_swedish_ci
|
|
|
|
pay_date
|
date
|
|
|
|
|
installment
|
varchar(10)
|
latin1_swedish_ci
|
|
|
|
adv_gpf
|
varchar(20)
|
latin1_swedish_ci
|
|
|
|
adv_cpf
|
varchar(20)
|
latin1_swedish_ci
|
|
|
|
adv_festival
|
varchar(20)
|
latin1_swedish_ci
|
|
|
|
adv_hba
|
varchar(20)
|
latin1_swedish_ci
|
|
|
|
adv_mca
|
varchar(20)
|
latin1_swedish_ci
|
|
|
|
adv_comp
|
varchar(20)
|
latin1_swedish_ci
|
|
|
|
adv_cycln
|
varchar(20)
|
latin1_swedish_ci
|
|
|
|
adv_medical
|
varchar(10)
|
latin1_swedish_ci
|
|
|
|
adv_outstand
|
varchar(10)
|
latin1_swedish_ci
|
|
|
|
busfare
|
varchar(20)
|
latin1_swedish_ci
|
|
|
|
water_charge
|
varchar(20)
|
latin1_swedish_ci
|
|
|
|
eb_charge
|
varchar(20)
|
latin1_swedish_ci
|
|
|
|
licence_fee
|
varchar(10)
|
latin1_swedish_ci
|
|
|
|
licencefee_arrear
|
varchar(20)
|
latin1_swedish_ci
|
|
|
|
court
|
varchar(10)
|
latin1_swedish_ci
|
|
|
|
excess_paid
|
varchar(20)
|
latin1_swedish_ci
|
|
|
|
oth_rec
|
varchar(10)
|
latin1_swedish_ci
|
|
|
|
date_created
|
datetime
|
|
|
|
|
date_modified
|
datetime
|
|
|
|
