| id |
int(5) |
|
|
|
|---|
|
| site |
varchar(20) |
latin1_swedish_ci |
|
|
|---|
|
| issue_slipno |
varchar(50) |
latin1_swedish_ci |
|
|
|---|
|
| issuedate |
date |
|
|
|
|---|
|
| mst_storeid |
int(4) |
|
|
|
|---|
|
| store |
varchar(20) |
latin1_swedish_ci |
|
|
|---|
|
| issueto |
varchar(20) |
latin1_swedish_ci |
|
|
|---|
|
| received_by |
varchar(50) |
latin1_swedish_ci |
|
|
|---|
|
| department |
varchar(50) |
latin1_swedish_ci |
|
|
|---|
|
| work_order_no |
varchar(50) |
latin1_swedish_ci |
|
|
|---|
|
| remarks |
varchar(255) |
latin1_swedish_ci |
|
|
|---|
|
| totalqty |
double(10,2) |
|
|
|
|---|
|
| status |
varchar(15) |
latin1_swedish_ci |
|
|
|---|
|
| createdby |
varchar(30) |
latin1_swedish_ci |
|
|
|---|
|
| createddate |
date |
|
|
|
|---|
|
| check_status |
varchar(10) |
latin1_swedish_ci |
|
|
|---|
|
| issue_reg_no |
varchar(255) |
latin1_swedish_ci |
|
|
|---|
|
| cost_center |
varchar(255) |
latin1_swedish_ci |
|
|
|---|
|
| material_received_by |
varchar(255) |
latin1_swedish_ci |
|
|
|---|
|
| material_issue_by |
varchar(255) |
latin1_swedish_ci |
|
|
|---|
|
| companyID |
int(10) |
|
|
|
|---|
|
| finished_item |
int(25) |
|
|
|
|---|
|
| job_card_no |
int(25) |
|
|
|
|---|
|
| job_card_date |
date |
|
|
|
|---|
|
| finished_item_detail |
varchar(255) |
latin1_swedish_ci |
|
|
|---|
|
| issue_floor |
int(11) |
|
|
|
|---|
|
| modified_by |
int(10) |
|
|
|
|---|
|
| modified_date |
date |
|
|
|
|---|
|
| mrnid |
int(255) |
|
|
|
|---|
|
| issue_type |
varchar(100) |
latin1_swedish_ci |
|
|
|---|
|
| mrs_id |
int(11) |
|
|
|
|---|
|
| area |
int(11) |
|
|
|
|---|
|
| project |
int(11) |
|
|
|
|---|
|
| wo_id |
int(11) |
|
|
|
|---|
|
| cancel_issue |
int(1) |
|
|
|
|---|
|
| job_id |
int(10) |
|
|
|
|---|
|
| issue_reg_date |
date |
|
|
|
|---|
|
| indent_id |
int(11) |
|
|
|
|---|
|
| size_id |
int(11) |
|
|
|
|---|
|
| transaction_time |
datetime |
|
|
|
|---|
|
| type |
varchar(250) |
latin1_swedish_ci |
|
|
|---|
|
| to_store |
int(11) |
|
|
|
|---|
|
