| ordmid |
int(11)
|
|
|
|
| ordno |
varchar(30)
|
latin1_swedish_ci
|
|
|
| orderdate |
date
|
|
|
|
| garid |
int(11)
|
|
|
|
| buyid |
int(11)
|
|
|
|
| contactperson |
varchar(50)
|
latin1_swedish_ci
|
|
|
| contactno |
varchar(100)
|
latin1_swedish_ci
|
|
|
| mmid |
int(11)
|
|
|
|
| mmdate |
date
|
|
|
|
| srmmid |
int(11)
|
|
|
|
| srmmdate |
date
|
|
|
|
| gmid |
int(13)
|
|
|
|
| gmdate |
date
|
|
|
|
| remarks |
varchar(100)
|
latin1_swedish_ci
|
|
|
| stuid |
int(13)
|
|
|
|
| studate |
date
|
|
|
|
| otype |
varchar(5)
|
latin1_swedish_ci
|
|
|
| srtype |
int(13)
|
|
|
|
| achuid |
int(13)
|
|
|
|
| contact_email |
varchar(50)
|
latin1_swedish_ci
|
|
|
| prcnt |
int(11)
|
|
|
|
| ordertype |
varchar(75)
|
latin1_swedish_ci
|
|
|
| ownerid |
varchar(40)
|
latin1_swedish_ci
|
|
|
| greige_price |
decimal(13,2)
|
|
|
|
| payment_mood |
varchar(25)
|
latin1_swedish_ci
|
|
|
| buyer_fab_ref |
varchar(50)
|
latin1_swedish_ci
|
|
|
