| id |
int(11) |
|
|
|
|---|
|
| voucherreversal_id |
int(11) |
|
|
|
|---|
|
| major_code |
varchar(20) |
latin1_swedish_ci |
|
|
|---|
|
| minor_code |
varchar(20) |
latin1_swedish_ci |
|
|
|---|
|
| service_id |
int(11) |
|
|
|
|---|
|
| service_desc |
varchar(45) |
latin1_swedish_ci |
|
|
|---|
|
| reason |
varchar(45) |
latin1_swedish_ci |
|
|
|---|
|
| actual_quantity |
float(11,2) |
|
|
|
|---|
|
| quantity |
float(11,2) |
|
|
|
|---|
|
| rate |
double(8,2) |
|
|
|
|---|
|
| amount |
double(8,2) |
|
|
|
|---|
|
| reversal_amt |
double(8,2) |
|
|
|
|---|
|
| aythorized_by |
varchar(30) |
latin1_swedish_ci |
|
|
|---|
|
| packqty |
float(10,2) |
|
|
|
|---|
|
| packamt |
float(10,2) |
|
|
|
|---|
|
| adv_refund |
float(10,2) |
|
|
|
|---|
|
| lab_based_on |
varchar(2) |
latin1_swedish_ci |
|
|
|---|
|
| created_date |
timestamp |
|
|
|
|---|
|
| created_by |
varchar(20) |
latin1_swedish_ci |
|
|
|---|
|
| modified_date |
datetime |
|
|
|
|---|
|
| modified_by |
varchar(20) |
latin1_swedish_ci |
|
|
|---|
|
| finance_status |
int(1) |
|
|
|
|---|
|
| locationname |
varchar(20) |
latin1_swedish_ci |
|
|
|---|
|
| tax_amount |
double(10,2) |
|
|
|
|---|
|
| cgst |
double(10,2) |
|
|
|
|---|
|
| igst |
double(10,2) |
|
|
|
|---|
|
| utgst |
double(10,2) |
|
|
|
|---|
|
| sgst |
double(10,2) |
|
|
|
|---|
|
| store_code |
varchar(20) |
latin1_swedish_ci |
|
|
|---|
|
| item_code |
varchar(30) |
latin1_swedish_ci |
|
|
|---|
|
| batch_no |
varchar(20) |
latin1_swedish_ci |
|
|
|---|
|
| discount_amt |
double(16,4) |
|
|
|
|---|
|
| tax_perc |
double(16,4) |
|
|
|
|---|
|
| net_amt |
double(16,4) |
|
|
|
|---|
|
