| id |
int(11) |
|
|
|
|---|
|
| create_vendor_quotation_id |
int(11) |
|
|
|
|---|
|
| item_code |
varchar(25) |
latin1_swedish_ci |
|
|
|---|
|
| item_uom |
varchar(25) |
latin1_swedish_ci |
|
|
|---|
|
| req_quantity |
int(10) |
|
|
|
|---|
|
| quoted_rate |
float(10,2) |
|
|
|
|---|
|
| currency |
varchar(20) |
latin1_swedish_ci |
|
|
|---|
|
| total_rate |
float(10,2) |
|
|
|
|---|
|
| discount_type |
varchar(20) |
latin1_swedish_ci |
|
|
|---|
|
| discount_amount |
float(10,2) |
|
|
|
|---|
|
| discounted_amount |
float(10,2) |
|
|
|
|---|
|
| sub_total |
float(10,2) |
|
|
|
|---|
|
| basic_amount |
float(10,2) |
|
|
|
|---|
|
| excise_type |
varchar(25) |
latin1_swedish_ci |
|
|
|---|
|
| excise_duty |
varchar(25) |
latin1_swedish_ci |
|
|
|---|
|
| excise_amount |
float(10,2) |
|
|
|
|---|
|
| e_cess_type |
varchar(50) |
latin1_swedish_ci |
|
|
|---|
|
| e_cess_amount |
float(10,2) |
|
|
|
|---|
|
| sah_e_cess_type |
varchar(50) |
latin1_swedish_ci |
|
|
|---|
|
| sah_e_cess_value |
float(10,2) |
|
|
|
|---|
|
| tax_amount |
float(10,2) |
|
|
|
|---|
|
| total_amount |
float(10,2) |
|
|
|
|---|
|
| locationname |
varchar(20) |
latin1_swedish_ci |
|
|
|---|
|
