| id |
int(11)
|
|
|
|
| pur_rq_code |
varchar(45)
|
latin1_swedish_ci
|
|
|
| pur_rq_name |
varchar(100)
|
latin1_swedish_ci
|
|
|
| rq_description |
text
|
latin1_swedish_ci
|
|
|
| requester |
int(11)
|
|
|
|
| department |
int(11)
|
|
|
|
| request_date |
datetime
|
|
|
|
| status |
int(11)
|
|
|
|
| status_goods |
int(11)
|
|
|
|
| hash |
varchar(32)
|
latin1_swedish_ci
|
|
|
| type |
text
|
latin1_swedish_ci
|
|
|
| project |
int(11)
|
|
|
|
| number |
int(11)
|
|
|
|
| from_items |
int(2)
|
|
|
|
| subtotal |
decimal(15,2)
|
|
|
|
| total_tax |
decimal(15,2)
|
|
|
|
| total |
decimal(15,2)
|
|
|
|
| sale_invoice |
int(11)
|
|
|
|
| compare_note |
text
|
latin1_swedish_ci
|
|
|
| send_to_vendors |
text
|
latin1_swedish_ci
|
|
|
| currency |
int(11)
|
|
|
|
| currency_rate |
decimal(15,6)
|
|
|
|
| from_currency |
varchar(20)
|
latin1_swedish_ci
|
|
|
| to_currency |
varchar(20)
|
latin1_swedish_ci
|
|
|
| sale_estimate |
int(11)
|
|
|
|
