id |
int(11) |
|
|
|
|
branch |
varchar(10) |
latin1_swedish_ci |
|
|
|
sheet_no |
varchar(12) |
latin1_swedish_ci |
|
|
|
sheet_date |
date |
|
|
|
|
against |
varchar(10) |
latin1_swedish_ci |
|
|
|
client |
int(11) |
|
|
|
|
lead_ref |
int(11) |
|
|
|
|
lead_ref_date |
date |
|
|
|
|
type |
int(11) |
|
|
|
|
sub_group |
int(11) |
|
|
|
|
primary_qty |
double(10,2) |
|
|
|
|
secondary_qty |
double(10,2) |
|
|
|
|
grossamt |
double(10,2) |
|
|
|
|
remark |
varchar(255) |
latin1_swedish_ci |
|
|
|
totalAmount |
double(10,2) |
|
|
|
|
prepared_by |
varchar(40) |
latin1_swedish_ci |
|
|
|
checked_by |
varchar(40) |
latin1_swedish_ci |
|
|
|
authorized_by |
varchar(40) |
latin1_swedish_ci |
|
|
|
CompanyId |
int(11) |
|
|
|
|
created_date |
date |
|
|
|
|
created_by |
int(10) |
|
|
|
|
modified_date |
date |
|
|
|
|
modified_by |
int(10) |
|
|
|
|
est_status |
varchar(10) |
latin1_swedish_ci |
|
|
|