|
CO_CODE
|
int(10)
|
|
|
|
|
SC_CODE
|
int(10)
|
|
|
|
|
LNAME
|
varchar(50)
|
utf8mb4_general_ci
|
|
|
|
BA
|
int(1)
|
|
|
|
|
NIM
|
int(1)
|
|
|
|
|
DP
|
int(1)
|
|
|
|
|
ISSUETYPE
|
varchar(35)
|
utf8mb4_general_ci
|
|
|
|
PUBLISS1
|
float
|
|
|
|
|
OPENDATE
|
varchar(45)
|
utf8mb4_general_ci
|
|
|
|
CLOSDATE
|
varchar(45)
|
utf8mb4_general_ci
|
|
|
|
BBOPENDATE
|
varchar(45)
|
utf8mb4_general_ci
|
|
|
|
BBCLOSDATE
|
varchar(45)
|
utf8mb4_general_ci
|
|
|
|
ISSUEPRICE
|
float
|
|
|
|
|
LISTPRICE
|
float
|
|
|
|
|
UP1000
|
float
|
|
|
|
|
AB1000
|
float
|
|
|
|
|
ADD1
|
varchar(30)
|
utf8mb4_general_ci
|
|
|
|
ADD2
|
varchar(30)
|
utf8mb4_general_ci
|
|
|
|
ADD3
|
varchar(30)
|
utf8mb4_general_ci
|
|
|
|
STATE
|
varchar(30)
|
utf8mb4_general_ci
|
|
|
|
PIN
|
varchar(8)
|
utf8mb4_general_ci
|
|
|
|
TEL1
|
varchar(35)
|
utf8mb4_general_ci
|
|
|
|
TEL2
|
varchar(35)
|
utf8mb4_general_ci
|
|
|
|
FAX1
|
varchar(35)
|
utf8mb4_general_ci
|
|
|
|
FAX2
|
varchar(35)
|
utf8mb4_general_ci
|
|
|
|
E_MAIL
|
varchar(50)
|
utf8mb4_general_ci
|
|
|
|
WEB
|
varchar(50)
|
utf8mb4_general_ci
|
|
|
|
OBJECTDET
|
varchar(10000)
|
utf8mb4_general_ci
|
|
|
|
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)
|
utf8mb4_general_ci
|
|
|
|
PRJCT
|
varchar(1000)
|
utf8mb4_general_ci
|
|
|
|
LMGR
|
varchar(2000)
|
utf8mb4_general_ci
|
|
|
|
PROMO
|
text
|
utf8mb4_general_ci
|
|
|
|
EXCHG
|
varchar(200)
|
utf8mb4_general_ci
|
|
|
|
REG_NAME
|
varchar(30)
|
utf8mb4_general_ci
|
|
|
|
REG_ADD1
|
varchar(20)
|
utf8mb4_general_ci
|
|
|
|
REG_ADD2
|
varchar(20)
|
utf8mb4_general_ci
|
|
|
|
REG_ADD3
|
varchar(20)
|
utf8mb4_general_ci
|
|
|
|
REG_ADD4
|
varchar(20)
|
utf8mb4_general_ci
|
|
|
|
REG_TEL1
|
varchar(45)
|
utf8mb4_general_ci
|
|
|
|
REG_TEL2
|
varchar(45)
|
utf8mb4_general_ci
|
|
|
|
REG_FAX1
|
varchar(45)
|
utf8mb4_general_ci
|
|
|
|
REG_FAX2
|
varchar(45)
|
utf8mb4_general_ci
|
|
|
|
LISTDATE
|
varchar(45)
|
utf8mb4_general_ci
|
|
|
|
Flag
|
varchar(1)
|
utf8mb4_general_ci
|
|
|
|
TSYM
|
varchar(50)
|
utf8mb4_general_ci
|
|
|
