|
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
|
|
|
|
|
da_arrear
|
varchar(20)
|
latin1_swedish_ci
|
|
|
|
ta_arrear
|
varchar(20)
|
latin1_swedish_ci
|
|
|
|
hra_arrear
|
varchar(10)
|
latin1_swedish_ci
|
|
|
|
pay_arrear
|
varchar(20)
|
latin1_swedish_ci
|
|
|
|
bonus
|
varchar(20)
|
latin1_swedish_ci
|
|
|
|
honorarium
|
varchar(20)
|
latin1_swedish_ci
|
|
|
|
remuneration
|
varchar(20)
|
latin1_swedish_ci
|
|
|
|
consultancy_fee
|
varchar(10)
|
latin1_swedish_ci
|
|
|
|
ota
|
varchar(20)
|
latin1_swedish_ci
|
|
|
|
el_encashment
|
varchar(20)
|
latin1_swedish_ci
|
|
|
|
spl_encash
|
varchar(20)
|
latin1_swedish_ci
|
|
|
|
tuition_reimburse
|
varchar(20)
|
latin1_swedish_ci
|
|
|
|
medical_reimburse
|
varchar(20)
|
latin1_swedish_ci
|
|
|
|
fixed_med_allow
|
varchar(5)
|
latin1_swedish_ci
|
|
|
|
tds_refund
|
varchar(20)
|
latin1_swedish_ci
|
|
|
|
hpl
|
varchar(20)
|
latin1_swedish_ci
|
|
|
|
convey_allow
|
varchar(10)
|
latin1_swedish_ci
|
|
|
|
oth_refund
|
varchar(20)
|
latin1_swedish_ci
|
|
|
|
ded_refund
|
varchar(20)
|
latin1_swedish_ci
|
|
|
|
contrib_nps_uni
|
varchar(10)
|
latin1_swedish_ci
|
|
|
|
date_created
|
datetime
|
|
|
|
|
date_modified
|
datetime
|
|
|
|
