| CO_CODE | int(10) |
|
|
|
| SC_CODE | int(10) |
|
|
|
| LNAME | varchar(50) |
|
|
|
| BA | int(1) |
|
|
|
| NIM | int(1) |
|
|
|
| DP | int(1) |
|
|
|
| ISSUETYPE | varchar(35) |
|
|
|
| PUBLISS1 | float |
|
|
|
| OPENDATE | varchar(45) |
|
|
|
| CLOSDATE | varchar(45) |
|
|
|
| BBOPENDATE | varchar(45) |
|
|
|
| BBCLOSDATE | varchar(45) |
|
|
|
| ISSUEPRICE | float |
|
|
|
| LISTPRICE | float |
|
|
|
| UP1000 | float |
|
|
|
| AB1000 | float |
|
|
|
| ADD1 | varchar(30) |
|
|
|
| ADD2 | varchar(30) |
|
|
|
| ADD3 | varchar(30) |
|
|
|
| STATE | varchar(30) |
|
|
|
| PIN | varchar(8) |
|
|
|
| TEL1 | varchar(35) |
|
|
|
| TEL2 | varchar(35) |
|
|
|
| FAX1 | varchar(35) |
|
|
|
| FAX2 | varchar(35) |
|
|
|
| E_MAIL | varchar(50) |
|
|
|
| WEB | varchar(50) |
|
|
|
| OBJECTDET | varchar(10000) |
|
|
|
| APPNMONEY1 | float |
|
|
|
| APPNMONEY2 | float |
|
|
|
| ALOTMONEY1 | float |
|
|
|
| ALOTMONEY2 | float |
|
|
|
| MIN_APPLN | int(11) |
|
|
|
| MULTIPLES | int(11) |
|
|
|
| PROJCOST | float |
|
|
|
| TOT_EQTY | float |
|
|
|
| ISSUEPRI2 | float |
|
|
|
| HIGHLIGHTS | varchar(200) |
|
|
|
| PRJCT | varchar(1000) |
|
|
|
| LMGR | varchar(2000) |
|
|
|
| PROMO | varchar(200) |
|
|
|
| EXCHG | varchar(200) |
|
|
|
| REG_NAME | varchar(30) |
|
|
|
| REG_ADD1 | varchar(20) |
|
|
|
| REG_ADD2 | varchar(20) |
|
|
|
| REG_ADD3 | varchar(20) |
|
|
|
| REG_ADD4 | varchar(20) |
|
|
|
| REG_TEL1 | varchar(45) |
|
|
|
| REG_TEL2 | varchar(45) |
|
|
|
| REG_FAX1 | varchar(45) |
|
|
|
| REG_FAX2 | varchar(45) |
|
|
|
| LISTDATE | varchar(45) |
|
|
|
| Flag | varchar(1) |
|
|
|
| TSYM | varchar(50) |
|
|
|