| id |
int(11) |
|
|
|
|---|
|
| issue_id |
int(11) |
|
|
|
|---|
|
| mst_itemid |
int(11) |
|
|
|
|---|
|
| issue_qty |
varchar(11) |
latin1_swedish_ci |
|
|
|---|
|
| itemprice |
double(10,2) |
|
|
|
|---|
|
| itemcode |
varchar(11) |
latin1_swedish_ci |
|
|
|---|
|
| description |
varchar(255) |
latin1_swedish_ci |
|
|
|---|
|
| Make |
varchar(20) |
latin1_swedish_ci |
|
|
|---|
|
| Color |
varchar(20) |
latin1_swedish_ci |
|
|
|---|
|
| Gread |
varchar(20) |
latin1_swedish_ci |
|
|
|---|
|
| size |
varchar(20) |
latin1_swedish_ci |
|
|
|---|
|
| gsm |
varchar(20) |
latin1_swedish_ci |
|
|
|---|
|
| UOM |
varchar(20) |
latin1_swedish_ci |
|
|
|---|
|
| Qcrequd |
varchar(20) |
latin1_swedish_ci |
|
|
|---|
|
| currency |
int(11) |
|
|
|
|---|
|
| POQty |
double(10,2) |
|
|
|
|---|
|
| qty_as_per_bill |
double(10,2) |
|
|
|
|---|
|
| short_accessid |
double(10,2) |
|
|
|
|---|
|
| rejectqty |
double(10,2) |
|
|
|
|---|
|
| reciveqty |
double(10,2) |
|
|
|
|---|
|
| secondaryqty |
double(10,2) |
|
|
|
|---|
|
| order_no |
int(11) |
|
|
|
|---|
|
| taxname |
varchar(255) |
latin1_swedish_ci |
|
|
|---|
|
| tax_rate |
double(10,2) |
|
|
|
|---|
|
| taxamount_rate |
decimal(10,2) |
|
|
|
|---|
|
| item_total_rate |
double(10,2) |
|
|
|
|---|
|
| disc_type |
varchar(20) |
latin1_swedish_ci |
|
|
|---|
|
| discount |
double(10,2) |
|
|
|
|---|
|
| discount_amount |
double(10,2) |
|
|
|
|---|
|
| val_after_disc |
double(10,2) |
|
|
|
|---|
|
| specialdis_type |
varchar(250) |
latin1_swedish_ci |
|
|
|---|
|
| sp_disc_perc |
double(10,2) |
|
|
|
|---|
|
| sp_disc_amt |
double(10,2) |
|
|
|
|---|
|
| basic |
double(10,2) |
|
|
|
|---|
|
| billing_type |
varchar(25) |
latin1_swedish_ci |
|
|
|---|
|
| excise_duty |
int(5) |
|
|
|
|---|
|
| excise_perc |
double(10,2) |
|
|
|
|---|
|
| excise_val |
double(10,2) |
|
|
|
|---|
|
| e_cess_perc |
double(10,2) |
|
|
|
|---|
|
| e_cess_val |
double(10,2) |
|
|
|
|---|
|
| sah_perc |
double(10,2) |
|
|
|
|---|
|
| sah_val |
double(10,2) |
|
|
|
|---|
|
| total_amt_with_tax |
double(10,2) |
|
|
|
|---|
|
| remarks |
varchar(255) |
latin1_swedish_ci |
|
|
|---|
|
| status |
enum('Y', 'N') |
latin1_swedish_ci |
|
|
|---|
|
| parent_id |
int(11) |
|
|
|
|---|
|
| mat_value |
int(20) |
|
|
|
|---|
|
| delete_status |
int(3) |
|
|
|
|---|
|
| Can_status |
varchar(10) |
latin1_swedish_ci |
|
|
|---|
|
| MRVS |
int(10) |
|
|
|
|---|
|
| grn_type |
varchar(255) |
latin1_swedish_ci |
|
|
|---|
|
| Cess_ID |
int(10) |
|
|
|
|---|
|
| SHECess_ID |
int(10) |
|
|
|
|---|
|
| cuntomDuty_Flag |
int(10) |
|
|
|
|---|
|
| Custon_Duty |
int(10) |
|
|
|
|---|
|
| CustomDutyAmt |
double(16,2) |
|
|
|
|---|
|
| conversion_curr |
int(10) |
|
|
|
|---|
|
| conversion_rate |
double(10,2) |
|
|
|
|---|
|
| CVD |
int(10) |
|
|
|
|---|
|
| CVD_amt |
double(10,2) |
|
|
|
|---|
|
| custom_ecess |
int(10) |
|
|
|
|---|
|
| custom_ecess_value |
double(10,2) |
|
|
|
|---|
|
| custom_shecess |
int(10) |
|
|
|
|---|
|
| custom_shcess_value |
double(10,2) |
|
|
|
|---|
|
| add_duty_per |
int(10) |
|
|
|
|---|
|
| adduty_amt |
double(10,2) |
|
|
|
|---|
|
| batch_no |
varchar(255) |
latin1_swedish_ci |
|
|
|---|
|
| Excise_type |
varchar(255) |
latin1_swedish_ci |
|
|
|---|
|
| qcdet_status |
int(1) |
|
|
|
|---|
|
| totalPrice |
double(10,2) |
|
|
|
|---|
|
| minSign |
varchar(2) |
latin1_swedish_ci |
|
|
|---|
|
| stock_qty2 |
double(16,2) |
|
|
|
|---|
|
| mst_unitid |
int(11) |
|
|
|
|---|
|
| mst_sec_unitid |
int(11) |
|
|
|
|---|
|
| qty_type |
varchar(10) |
latin1_swedish_ci |
|
|
|---|
|
| mfg |
date |
|
|
|
|---|
|
| expiry |
date |
|
|
|
|---|
|
| conv_fac |
double(16,4) |
|
|
|
|---|
|
| mrprate |
double(10,2) |
|
|
|
|---|
|
| site_transfer_issue_status |
int(11) |
|
|
|
|---|
|
| rate |
double(10,2) |
|
|
|
|---|
|
| amount |
double(10,2) |
|
|
|
|---|
|
| purchase_rate |
double(10,2) |
|
|
|
|---|
|
| free_qty |
double(10,2) |
|
|
|
|---|
|
