id |
int(11) |
|
|
|
|
drugissue_id |
int(11) |
|
|
|
|
presc_no |
varchar(20) |
latin1_swedish_ci |
|
|
|
rate |
double(12,2) |
|
|
|
|
total_amt |
double(12,2) |
|
|
|
|
net_amount |
double(12,2) |
|
|
|
|
discount |
float(11,2) |
|
|
|
|
discount_indicator |
varchar(20) |
latin1_swedish_ci |
|
|
|
discount_payment |
double(12,2) |
|
|
|
|
total_pck_serv_amnt |
float(13,2) |
|
|
|
|
created_date |
datetime |
|
|
|
|
created_by |
varchar(20) |
latin1_swedish_ci |
|
|
|
modified_date |
datetime |
|
|
|
|
modified_by |
varchar(20) |
latin1_swedish_ci |
|
|
|
discount_last_type |
varchar(1) |
latin1_swedish_ci |
|
|
|
discount_last_val |
double(12,2) |
|
|
|
|
taxAmount_tot |
double(12,2) |
|
|
|
|
round_off |
varchar(2) |
latin1_swedish_ci |
|
|
|
round_off_amt |
double(12,2) |
|
|
|
|
locationname |
varchar(20) |
latin1_swedish_ci |
|
|
|
total_discount |
double(10,2) |
|
|
|
|
net_amount1 |
double(10,2) |
|
|
|
|