TP主数据表20160831(8月最新版)

合集下载

校园网设备统计表

校园网设备统计表
基础网络配置
项目
型号
描述
数
量
实验楼
网管系统
LinkManager-50NM
-50N
LinkManager网络管理系统V1.0(50NM-50N)。网管专业版
平台，50节点。功能：支持网络拓扑发现、资源管理、设备管理、终端管理、性能管理、故障分析、异常流量监测、服务器管理、WEB监控等。
1
MRS-PWR-B1-AC-B
220V交流电源模块(600W)，适用于DCRS-7608E、6808E
1
MRS-7608E-MI
DCRS-7608E一代管理引擎模块
1
MRS-7600E-12GX12G
B
DCRS-7600E增强系列24口1000Base-X (SFP) + 12口10/100/1000Base-T(Combo)接口模块，基于ASIC的硬件线速IPv6
2
PoE交换
机
DCS-4500-26T-PoE
全千兆智能安全PoE交换机，26口
10/100/1000Base-T + 4口千兆SFP（Combo）接口
7
1
校园网汇聚交换
DCRS-5960-28T
全千兆三层交换机， 24口10/100/1000Base-T + 4口千兆SFP(Combo)接口+2个万兆插槽，基于ASIC的硬件线速IPv6, 220VAC
4
办公楼
千兆接入交换机
DCS-4500-26T
全千兆智能安全交换机，26口10/100/1000Base-T + 4口千
1
校园无线配置
项目
型号
描述

S4客户主数据批导2

S4客户主数据批导2批量创建S4 BP客户考虑使⽤CVI_EI_INBOUND_MAIN。

本⽂重点讨论的业务场景：使⽤⽤户上传的EXCLE⽂件批量创建客户，节省时间操作时间。

开发申请要求：给出前台（TCODE：BP）创建客户相关数据，批量创建客户。

前台操作，根据界⾯底部的消息提⽰⼀步⼀步输⼊BP客户的相关数据。

1. 相关BAPI2.1 CVI_EI_INBOUND_MAIN(创建客户主要数据)2.1.1功能描述根据客户主数据创建客户数据相关信息。

2.1.2相关参数说明接收数据的结构，改⽅法只有⼀个导⼊参数，所有的信息都在这个导⼊参数⾥⾯。

主要的数据填充在CUSTOMER这个组件内对于CUSTOMER这个组件，分别填充客户的相关数据到对应组件这⾥主要有三个组件CENTRAL_DATA(中⼼数据)、COMPANY_DATA(公司代码数据)、SALES_DATA(销售数据)，分别在根据所需数据的类别分别填⼊对应的组件⾥。

BAPI_BUPA_TAX_ADD(类别、税号数据)对于前台标识页签下的税号相关数据，需要采⽤BAPI_BUPA_TAX_ADD进⾏维护代码⽰例CALL FUNCTION'BAPI_BUPA_TAX_ADD'EXPORTINGBUSINESSPARTNER = <FS_DATA>-PARTNERTAXTYPE = <FS_DATA>-TAXTYPE "类别TAXNUMBER = <FS_DATA>-TAXNUMXL "税号TABLESRETURN = LT_RETURN_TAX.BAPI_BUTX_FRG0010_ADD (税分类国家/地区税收类型税收组数据)对于前台控制页签下的税分类相关数据，如下图，需要⽤BAPI_BUTX_FRG0010_ADD才能添加进去。

调⽤代码⽰例:CALL FUNCTION'BAPI_BUTX_FRG0010_ADD'EXPORTINGBUSINESSPARTNER = <FS_DATA>-PARTNERTAXCOUNTRY = <FS_DATA>-TAX_CTY "国家/地区TAXREGION = ''"地区TAXTYPE = <FS_DATA>-TAX_TYPE "税收类型DATA = <FS_DATA>-TAX_GROUP "税收组TABLESRETURN = LT_RETURN_FRG.2.4 IO_BUPA_FACTORY->GET_CREDIT_ACCOUNT(信⽤参数⽂件数据)对于信⽤参数⽂件页签下的计分相关数据，如下图，需要采⽤类IO_BUPA_FACTORY下的⽅法GET_CREDIT_ACCOUNT进⾏维护。

消息8152，级别16，状态4，第1行将截断字符串或二进制数据。语句已终止。

消息8152，级别16，状态4，第1⾏将截断字符串或⼆进制数
据。

语句已终⽌。

数据库操作时
消息 8152，级别 16，状态 4，第 1 ⾏
将截断字符串或⼆进制数据。

语句已终⽌。

这样的报错原因是你输⼊字符串的长度,超过了你数据库能录⼊的长度.
⽹上介绍最简单的⽅法, 把你数据库的值,都改为varchar(50) .
解决'将 expression 转换为数据类型 nvarchar 时出现算术溢出错误。

'
消息 8115，级别 16，状态 2，第 1 ⾏
将 expression 转换为数据类型 nvarchar 时出现算术溢出错误。

语句已终⽌。

在⽣产环境中遇到⼀个异常提⽰：“将 expression 转换为数据类型 nvarchar 时出现算术溢出错误。

”，⼀看这错误就知道是数据库的异常，赶紧检查存储过程。

发现存储过程中有将某个int值转换为nvarchar(2)的数据，⼼中⼀想，不会吧……这样也可以？万⼀int是⾃增的，过了100咋办？⼀查数据果然是此int类型值已达9800+，为确认是此处导致的问题，⾃⼰写个查询检查下：
declare @x int;
set @x = 9980;
select Convert(nvarchar(2),@x);
结果果然出现了“将 expression 转换为数据类型 nvarchar 时出现算术溢出错误。

”。

那么增加nvarchar类型的长度就⾏，改为nvarchar(8)，顺利运⾏通过。

374体育

年级编号班号班级名称学籍号民族姓名性别出生日期身份证号3110P06374100281040276汉陈彩云女1995-05-17430281199505175827 3110P06374100281040313汉李梦妮女1994-11-18430281199411182049 3110P06374100281040282汉黄婷女1994-07-04430281199407044065 3110P06374100281040319汉张赛女1995-11-2943028119951129008x 3110P06374100281040315汉袁驰方男1995-01-29430281199501295311 3110P06374100281040298汉金磊男1994-04-06430281199404063316 3110P06374100281040292汉周夏女1994-05-20430281199405206040 3110P06374100281040289汉邓友园男1993-12-15430281199312154050 3110P06374100281040300汉谢璇婵女1995-12-24430281199512240025 3110P06374100281040287汉刘礼平女1995-05-03430281199505035824 3110P06374100281040304汉汤海军男1994-09-12430281199409127913 3110P06374100281040279汉李智男1996-02-08430281199602083617 3110P06374100281040302汉邓明慧女1995-10-13430281199510134667 3110P06374100281040295汉吴莉女1993-06-25430281199306259147 3110P06374100281040311汉曾涛男1994-05-143110P06374100281040274汉黎明男1995-05-12430281199505123613 3110P06374100281040314汉何远哲男1994-08-15430281199408151030 3110P06374100281040306汉张念女1996-02-12430281199602127720 3110P06374100281040305汉罗钰女1995-02-27430281199502272322 3110P06374100281040290汉陈铁龙男1994-11-11430281199411111339 3110P06374100281040294汉丁宇豪男1995-03-19430281199503199112 3110P06374100281040291汉江丹女1994-09-27430281199409274665 3110P06374100281040312汉朱琳女1995-07-09430281199507099223 3110P06374100281040317汉汤旺男1995-08-06430281199508064313 3110P06374100281040296汉刘璐女1994-12-31430281199412310022 3110P06374100281040275汉唐子雄男1995-01-09430281199501090017 3110P06374100281040004汉王志翔男1994-06-23430281199406231010 3110P06374100281040321汉罗一波男1994-10-03430281199410031011 3110P06374100281040309汉梁天添女1995-12-08430281199512081327 3110P06374100281040285汉苏子沙女1995-07-17430281199507174668 3110P06374100281040299汉李亮男1994-03-21430281199403217715 3110P06374100281040288汉胡雅怡女1995-06-133110P06374100281040307汉刘浩男1994-06-04430281199406041313 3110P06374100281040323汉黎自强男1994-10-02430281199410021016 3110P06374100281040284汉陈慧芳女1995-03-11430281199503116022 3110P06374100281040310汉田娅琪女1995-01-06430281199501061347 3110P06374100281040283汉叶鑫文女1995-01-313110P06374100281040272汉周为女1995-08-20430281199508204320 3110P06374100281040278汉朱仕豪男1995-04-16430281199504169118 3110P06374100281040308汉陈妙女1995-06-023110P06374100281040280汉林红梅女1995-03-20430281199503204065 3110P06374100281040301汉钟逸男1995-08-05430219199508051717 3110P06374100281040318汉江健男1994-11-13430281199411130011 3110P06374100281040297汉瞿优利女1994-11-183110P06374100281040281汉曾琴女1993-12-10430281199312105427 3110P06374100281040273汉彭易男1994-10-02430281199410024655 3110P06374100281040286汉吴永和男1994-10-02430281199410027370 3110P06374100281040322汉张子豪男1995-06-28430281199506281314 3110P06374100281040303汉周雨彤女1994-11-19430281199411199246 3110P06374100281040320汉吴永优男1994-08-034302811994080373503110P06374100281040316汉黄玲女1995-04-203110P06374100281040293汉邓本威男1994-06-27430281199406279110 3110P06374100281040277汉杨纬华女1995-04-17430281199504177468 3110P07375100281040335汉陆科强男1994-04-02430281199404023613 3110P07375100281040364汉瞿颖婷女1994-12-18430281199412181021 3110P07375100281040368汉潘斌男1995-09-11430281199509113017 3110P07375100281040367汉张芬玲女1995-09-13430281199509136825 3110P07375100281040328汉邹婷女1995-01-09430281199501091327 3110P07375100281040338汉陈云华女1994-10-03430281199410034669 3110P07375100281040346汉方文秀女1995-11-09430281199511095348 3110P07375100281040342汉刘驰男1995-04-25430281199504252317 3110P07375100281040361汉邓杨清芬女1995-04-05430281199504051320 3110P07375100281040333汉刘秀女1995-03-06430281199503060727 3110P07375100281040329汉匡沙女1994-03-06430281199403065627 3110P07375100281040349汉兰武平男1995-09-25430281199509257010 3110P07375100281040341汉潘婷女1994-12-18430219199412186166 3110P07375100281040357汉黄娟女1994-01-15430281199401153324 3110P07375100281040331汉陈兵男1995-08-25430281199508259153 3110P07375100281040324汉郑涛男1995-06-28430281199506289113 3110P07375100281040332汉陈丽女1994-07-07430281199407079268 3110P07375100281040351汉龙竹英女1994-11-23430281199411230725 3110P07375100281040373汉鲁旺林男1994-08-09430281199408091314 3110P07375100281040359汉陈晶瑶女1995-06-13430281199506133629 3110P07375100281040354汉吴智斌男1994-08-21430281199408219250 3110P07375100281040362汉李鹏辉男1994-11-30430281199411303613 3110P07375100281040353汉李雪男1994-12-04430281199412046014 3110P07375100281040325汉杨敏婷女1995-08-13430281199508135927 3110P07375100281040343汉兰聪林男1993-10-22430281199310226815 3110P07375100281040330汉兰静茹女1993-04-27430281199304276162 3110P07375100281040327汉巫刚沛男1995-01-13430219199501133939 3110P07375100281040365汉张思远男1995-07-2743028119950727161x 3110P07375100281040366汉丁晓倩女1996-05-29430281199605290048 3110P07375100281040360汉钟佳琳女1995-06-06430281199506069225 3110P07375100281040369汉蒋琪男1994-10-12430281199410121316 3110P07375100281040347汉吕昶怡女1995-10-07430281199510071029 3110P07375100281040356汉易桂平女1995-11-03430281199511030720 3110P07375100281040337汉段毅男1995-12-11430224199512115518 3110P07375100281040340汉宋蓓女1993-11-09430281199311095423 3110P07375100281040358汉易伟琪男1995-01-0143028119950101003x 3110P07375100281040334汉朱兴文男1995-05-11430281199505117352 3110P07375100281040363汉兰志勇男1995-01-16430281199501164653 3110P07375100281040348汉周宏男1993-04-043110P07375100281040376汉万锦弘男1994-09-23430281199409232334 3110P07375100281040326汉黄丽佳女1995-04-02430281199504022722 3110P07375100281040345汉易洪女1995-10-04362201199510043425 3110P07375100281040352汉张权男1995-08-10430281199508100011 3110P07375100281040339汉黄瑞芳女1994-11-20430281199411205829 3110P07375100281040355汉黄洁华女1995-07-26430281199507262326 3110P07375100281040350汉陈丹女1995-11-26430281199511263620 3110P07375100281040344汉吴富童男1994-10-2943028119941029361x 3110P07375100281040336汉宋雅玲女1994-11-134302811994111313213110P07375100281040375汉张维男1995-02-07430281199502073315 3110P07375100281040374汉谢浩男1995-06-23430281199506230031 3110P07375100281040371汉周宇阳男1994-08-01430281199408011310 3110P07375100281040370汉何恬恬女1995-06-03430281199506032326 3110P07375100281040372汉梁潇女1995-05-20430281199505201327 3110P08376100281040392汉林旖旎女1995-04-22430281199504227728 3110P08376100281040425汉刘三亚男1994-09-07430281199409079114 3110P08376100281040406汉王宇豪男1994-03-283110P08376100281040418汉文强男1994-07-08430281199407080015 3110P08376100281040399汉黎珂男1995-01-05430281199501056011 3110P08376100281040420汉张可男1995-03-303110P08376100281040387汉帅小满女1995-04-1243028119950412602X 3110P08376100281040378汉张才勇男1993-03-263110P08376100281040384汉王洁纯女1996-01-22430281199601220026 3110P08376100281040381汉刘子豪男1995-07-073110P08376100281040410汉潘裕婷女1995-04-29430281199504299123 3110P08376100281040395汉李志勇男1994-12-03430281199412030055 3110P08376100281040417汉谭由芝女1995-09-0243022419950902392x 3110P08376100281040383汉杨鹏男1996-02-12430281199602129216 3110P08376100281040404汉张敏超男1995-10-20430281199510200759 3110P08376100281040427汉邹佳威男1995-05-25430281199505252319 3110P08376100281040390汉吴禹其女1995-04-3043028119950430202X 3110P08376100281040403汉李铭武男1993-05-0543028119930505465X 3110P08376100281040397汉徐利娟女1995-05-11430281199505117467 3110P08376100281040408汉胡巧莉女1995-03-20430281199503201323 3110P08376100281040419汉邓洋男1995-01-113110P08376100281040393汉林婉女1995-01-13430281199501139183 3110P08376100281040944汉黄昊媛女1996-12-15430281199612151628 3110P08376100281040421汉邹淳男1995-09-17430281199509172316 3110P08376100281040424汉张琦男1993-11-19430281199311191335 3110P08376100281040396汉黄晚晴女1994-05-15430281199405153321 3110P08376100281040389汉李雁瓷女1995-08-07430281199508077923 3110P08376100281040398汉邹志豪男1995-06-26430281199506267555 3110P08376100281040407汉易娟女1994-03-293110P08376100281040422汉张志豪男1995-03-01430281199503013955 3110P08376100281040401汉陈婉婷女1995-10-25430281199510256023 3110P08376100281040416汉樊玉群女1994-05-21430281199405217364 3110P08376100281040413汉凌巧女1994-11-27430281199411277566 3110P08376100281040409汉杨磊男1994-11-02430281199411020031 3110P08376100281040405汉黄凌颖女1995-09-03430281199509031329 3110P08376100281040377汉廖紫薇女1995-01-25430281199501254667 3110P08376100281040382汉袁柳丹女1995-02-0343028119950203616X 3110P08376100281040423汉丁雨晴女1994-05-1243028119940512132X 3110P08376100281040394汉谢彪男1994-06-29430281199406297714 3110P08376100281040400汉肖婷女1994-07-05430281199407050027 3110P08376100281040428汉谢俊豪男1995-07-05430281199507051035 3110P08376100281040379汉蒋龙男1995-04-05430281199504057351 3110P08376100281040411汉易婷女1995-11-09430281199511095321 3110P08376100281040402汉唐斌女1995-05-05430281199505055729 3110P08376100281040415汉谭亚敏女1995-11-21430281199511211329 3110P08376100281040385汉汤细华男1995-10-114302811995101179123110P08376100281040388汉肖欢女1995-04-08430281199504087729 3110P08376100281040414汉文国庆男1995-10-01430281199510015617 3110P08376100281040380汉胡丰明女1994-11-05430281199411051022 3110P08376100281040386汉周金鑫女1996-10-07430281199610070322 3110P08376100281040426汉徐杨宇男1995-01-17430281199501171319 3110P08376100281040391汉兰阳男1994-06-24430281199406247012 3110P08376100281040412汉夏敏男1995-01-14430281199501147714 3110P09377100281040476汉熊浩男1996-01-253110P09377100281040462汉易璐男1995-08-203110P09377100281040459汉刘力男1994-08-123110P09377100281040441汉康芳女1995-03-153110P09377100281040467汉王茜女1996-01-233110P09377100281040468汉晏得亲女1995-02-243110P09377100281040455汉张柳女1995-01-253110P09377100281040456汉吴自维男1993-01-203110P09377100281040464汉李维进男1995-01-233110P09377100281040451汉江峰男1996-03-293110P09377100281040431汉付磊男1995-07-013110P09377100281040457汉王钰莹女1995-02-133110P09377100281040461汉杨紫依女1995-05-203110P09377100281040447汉汤倩怡女1995-02-213110P09377100281040445汉陈丽女1996-01-103110P09377100281040471汉晏赛女1995-08-013110P09377100281040458汉张丽珍女1905-06-173110P09377100281040463汉杨婷女1995-06-243110P09377100281040437汉王英女1994-04-10430281199404107462 3110P09377100281040473汉陈利恒女1994-12-023110P09377100281040446汉唐志武男1995-07-113110P09377100281040466汉贺钱锋男1995-06-143110P09377100281040440汉吴淼女1995-06-163110P09377100281040472汉周炜龙男1995-07-213110P09377100281040460汉张文女1994-10-123110P09377100281040477汉周慧女1994-10-073110P09377100281040439汉邓晓寒女1994-12-25430281199412250023 3110P09377100281040430汉李衡男1995-04-04430281199504047751 3110P09377100281040448汉陈端喜男1995-09-213110P09377100281040469汉张师与女1994-09-153110P09377100281040436汉陈小青女1994-02-26430281199402263621 3110P09377100281040481汉岳俊良男1994-10-083110P09377100281040432汉王怡武男1995-05-063110P09377100281040442汉潘鸿麒男1994-12-22430281199412224693 3110P09377100281040443汉李亚敏女1995-08-173110P09377100281040454汉张丽波女1994-08-093110P09377100281040475汉李思怡女1994-12-213110P09377100281040444汉汤金娇女1995-11-21430219199511217925 3110P09377100281040434汉江雨莎女1996-04-08430281199604085325 3110P09377100281040452汉刘涛男1995-07-043110P09377100281040480汉张灏男1994-10-13430281199410132314 3110P09377100281040453汉付益玲女1994-02-233110P09377100281040479汉张龙雨男1994-07-17430281199407171312 3110P09377100281040470汉黄顺男1996-08-064302811996080679173110P09377100281040465汉易志超男1996-03-223110P09377100281040429汉汤婷女1995-04-033110P09377100281040474汉邹嘉意女1995-03-2343028119950323132x 3110P09377100281040478汉江华钦男1994-11-123110P09377100281040438汉刘宇明男1993-05-17430281199305173333 3110P09377100281040433汉唐芳女1994-10-053110P09377100281040435汉丁银桥男1995-04-01430281199504014052 3110P09377100281040449汉李江女1992-06-103110P09377100281040450汉张婉婷女1995-09-063110P10378100281040533汉杨天一男1995-05-26430281199505262330 3110P10378100281040532汉彭源盛男1995-02-2343028119950223131x 3110P10378100281040514汉张雅女1996-07-3043028119960730794x 3110P10378100281040529汉肖慧惠女1994-10-09430281199410091364 3110P10378100281040527汉杨瀚波男1994-11-01430281199411011311 3110P10378100281040489汉赖周强男1994-10-30430281199410304059 3110P10378100281040518汉吴龙男1993-11-1243028119931112161x 3110P10378100281040502汉骆晋宇男1994-12-11430281199412112018 3110P10378100281040483汉罗丰武男1994-07-14430281199407147718 3110P10378100281040498汉荣雾女1994-11-21430281199411214063 3110P10378100281040511汉汤九五女1995-08-273110P10378100281040512汉易金成男1995-08-19430281199508190715 3110P10378100281040522汉周思宇女1996-01-24430281199601242022 3110P10378100281040517汉游迪生男1995-01-21430281199501213638 3110P10378100281040497汉唐雅女1996-06-27430281199606274664 3110P10378100281040484汉凌宏男1994-12-03430281199412034056 3110P10378100281040513汉瞿珊珊女1993-06-0243028119930602740x 3110P10378100281040494汉易思女1995-07-20430281199507207722 3110P10378100281040519汉王彪男1995-04-043110P10378100281040504汉丁滔男1994-10-20430281199410202714 3110P10378100281040488汉袁志沙女1995-10-14430281199510147927 3110P10378100281040482汉黄宇玲女1995-08-01430281199508012724 3110P10378100281040500汉朱琳芳女1995-12-05430281199512054660 3110P10378100281040486汉张佳女1995-05-03430281199505031583 3110P10378100281040520汉彭慧敏女1994-10-16430281199410160040 3110P10378100281040531汉黄明江男1994-05-04430281199405044651 3110P10378100281040516汉刘婷女1996-10-233110P10378100281040526汉邹琬婷女1995-08-1143028119950811232x 3110P10378100281040485汉荣宇豪男1995-08-04430281199508040039 3110P10378100281040487汉李练男1995-05-25430281199505253610 3110P10378100281040515汉张旺男1995-08-013110P10378100281040490汉兰雨芝女1995-11-22430281199511227400 3110P10378100281040528汉贺中麟男1994-09-16430281199409161337 3110P10378100281040503汉李维久男1994-07-24430281199407247735 3110P10378100281040507汉张白露女1994-08-03430281199408030028 3110P10378100281040501汉汤迁女1995-08-26430281199508269124 3110P10378100281040492汉易清女1994-11-27430281199411277742 3110P10378100281040530汉黄轩男1994-07-16430281199407160330 3110P10378100281040506汉蒋响玲女1992-07-11430281199207119229 3110P10378100281040524汉邓明女1994-09-23430281199409237960 3110P10378100281040495汉洪利辉女1995-03-19430281199503195824 3110P10378100281040491汉易芳女1994-10-023603121994100220213110P10378100281040525汉易益鹏男1995-01-02430281199501024810 3110P10378100281040508汉唐灏男1994-05-193110P10378100281040499汉周翔男1995-11-12430281199511120056 3110P10378100281040496汉李孟男1995-07-11430281199507117735 3110P10378100281040523汉文振宇男1995-04-12430281199504125617 3110P10378100281040509汉李自粮男1995-09-0243028119950902601x 3110P10378100281040534汉刘志成男1995-07-13430281199507132310 3110P10378100281040493汉张天乐女1995-12-26430281199512262021 3110P10378100281040521汉杨娟女1994-08-09430281199408097927 3110P10378100281040505汉李春燕女1995-02-23430281199502234326 3110P10378100281040510汉杨迷女1994-08-26430281199408265820 3110P11379100281040543汉张新旺男1995-12-09430281199512090012 3110P11379100281040541汉钟琰女1995-02-23430281199502234684 3110P11379100281040568汉张婷女1995-10-08430281199510085324 3110P11379100281040555汉黄昌启男1995-01-02430281199501022719 3110P11379100281040561汉汤婉女1995-12-05430281199512057925 3110P11379100281040573汉张湘都女1993-08-1143028119930811534x 3110P11379100281040583汉李家晰男1994-08-1843028119940818131x 3110P11379100281040565汉温柔女1995-08-13430219199508133309 3110P11379100281040580汉彭增伟男1995-02-02430281199502023318 3110P11379100281040577汉黄庆宇男1995-05-02430281199505020016 3110P11379100281040558汉刘彩霞女1994-11-29430281199411290728 3110P11379100281040556汉林君娴女1996-04-05430281199604053622 3110P11379100281040535汉朱志强男1994-07-17430281199407170010 3110P11379100281040581汉殷小东男1995-02-073110P11379100281040559汉张林根男1993-09-08430281199309083917 3110P11379100281040544汉荣东男1994-06-06430281199406064056 3110P11379100281040546汉刘亚女1994-12-1643028119941216466x 3110P11379100281040586汉叶凯男1994-07-2343028119940723423x 3110P11379100281040537汉阙巧红女1995-11-10430281199511107927 3110P11379100281040566汉邓友情女1995-07-29430281199507292728 3110P11379100281040539汉陈俐女1996-01-29430281199601290024 3110P11379100281040562汉李惠女1994-11-22430281199411224069 3110P11379100281040538汉李锤男1996-05-02430281199605029210 3110P11379100281040579汉杨妮女1994-10-29430281199410299149 3110P11379100281040585汉汤子豪男1995-02-12430281199502120011 3110P11379100281040584汉张敏女1995-02-04430281199502041321 3110P11379100281040569汉熊希女1995-06-23430281199506239247 3110P11379100281040578汉贺智文女1995-05-14430281199505140026 3110P11379100281040563汉邓奇男1994-06-07430281199406073331 3110P11379100281040557汉易琼伶女1995-01-1043028119950110102x 3110P11379100281040576汉周怡君女1995-02-07430281199502072021 3110P11379100281040551汉王娟女1995-09-02430281199509022326 3110P11379100281040560汉郭志维男1995-06-03430281199506033011 3110P11379100281040572汉谢露罗华女1995-08-1743028119950817132x 3110P11379100281040570汉罗威男1996-02-14430903199602140617 3110P11379100281040542汉张潇妮女1995-08-22430281199508226845 3110P11379100281040536汉汪丹女1994-01-03430281199401033322 3110P11379100281040587汉徐雅琴女1995-07-013110P11379100281040567汉彭建男1994-06-24430281199406249034 3110P11379100281040571汉卜亚根女1992-07-014302811992070177403110P11379100281040575汉肖岳斌男1995-08-20430281199508201314 3110P11379100281040548汉刘文琴女1995-09-16430281199509164324 3110P11379100281040553汉付添凤女1995-04-113110P11379100281040547汉李正金男1994-11-12430281199411123612 3110P11379100281040564汉李韬男1994-07-20430281199407202318 3110P11379100281040554汉杨君男1995-04-1143028119950411503x 3110P11379100281040550汉黄市庆男1995-05-05430281199505050012 3110P11379100281040540汉李奇男1994-02-10430281199402107012 3110P11379100281040582汉杨海宇女1995-05-1043028119950510202x 3110P11379100281040545汉蒋文慧女1994-07-27430281199407276165 3110P11379100281040574汉杨海波男1994-09-25430281199409259238 3110P11379100281040549汉孔秋香女1995-08-19430281199508193625 3110P11379100281040552汉陈琴女1994-11-22430281199411223648 3110P12380100281040624汉吴旭女1995-11-18430281199511187381 3110P12380100281040614汉林森男1995-07-06430281199507063618 3110P12380100281040622汉刘雅婷女1995-04-25430281199504251023 3110P12380100281040619汉周文男1994-10-02430281199410029034 3110P12380100281040616汉刘天宇男1995-07-18430281199507181016 3110P12380100281040594汉余广女1996-03-05430281199603056522 3110P12380100281040629汉丁宇骁男1995-06-03430281199506031315 3110P12380100281040609汉黎政文男1994-11-21430281199411214311 3110P12380100281040630汉宋艺女1994-09-29430281199409290024 3110P12380100281040635汉龚飞龙男1995-05-29430281199505291019 3110P12380100281040591汉文佳俊男1995-07-27430281199507273017 3110P12380100281040608汉熊厚芳女1996-02-24431002199602245027 3110P12380100281040607汉张翔女1995-09-10430281199509100021 3110P12380100281040620汉江英杰男1996-03-14430281199603146819 3110P12380100281040589汉甘海丽女1994-05-20430281199405207721 3110P12380100281040612汉田园女1995-06-2743028119950627072x 3110P12380100281040592汉廖婷女1995-07-11430281199507113320 3110P12380100281040615汉李响女1993-12-06430281199312067723 3110P12380100281040636汉曾思文男1994-05-25430281199405252039 3110P12380100281040640汉丁盛男1994-06-17430281199406171310 3110P12380100281040606汉谢那英女1994-09-12430281199409123680 3110P12380100281040638汉杨景女1995-02-08430281199502081323 3110P12380100281040628汉邱礼毅男1994-08-08430281199408082012 3110P12380100281040632汉刘诗瑶女1995-07-28430281199507284189 3110P12380100281040639汉黄源女1994-09-17430281199409171340 3110P12380100281040625汉丁旺男1995-03-12430281199503124655 3110P12380100281040618汉荣昊男1995-05-30430281199505302312 3110P12380100281040596汉李桔华女1994-08-28430281199408283623 3110P12380100281040595汉黄纯女1994-09-13430281199409134662 3110P12380100281040603汉刘瑶女1995-01-173110P12380100281040634汉刘雍男1995-04-29430281199504291316 3110P12380100281040641汉黎青花女1994-11-25500101199411257144 3110P12380100281040588汉罗天龙男1995-06-29430281199506296153 3110P12380100281040627汉宋荣华男1995-05-02430281199505029213 3110P12380100281040601汉钟国洪男1994-12-27430281199412279133 3110P12380100281040605汉王诚男1994-06-273110P12380100281040610汉刘顺女1996-08-20430281199608207924 3110P12380100281040593汉昌建伟男1995-03-234302811995032358143110P12380100281040637汉唐芳女1994-04-12430221199404125621 3110P12380100281040617汉吴雅文女1995-08-23430281199508237763 3110P12380100281040597汉黄家豪男1994-05-303110P12380100281040613汉刘三柳女1995-03-03430281199503032726 3110P12380100281040602汉陈水兵女1995-09-0643028119950906362x 3110P12380100281040633汉黄政男1995-03-09430281199503091339 3110P12380100281040626汉刘雅琪女1995-08-26430281199508266628 3110P12380100281040623汉凌洁女1995-05-08430281199505080043 3110P12380100281040590汉曹鑫女1994-12-24430281199412242023 3110P12380100281040621汉张雅文女1995-08-26430281199508263021 3110P12380100281040604汉钟蝉女1995-08-07430281199508074327 3110P12380100281040631汉赖敏男1994-11-18430281199411184650 3110P12380100281040598汉黄沁女1995-01-15430281199501153620 3110P12380100281040611汉欧阳威男1995-07-15430281199507159134 3110P12380100281040599汉匡鹏男1995-01-03430281199501031316 3110P12380100281040600汉陈云男1995-02-25430281199502256015 3110P13381100281040683汉黄仕豪男1993-09-05430281199309050031 3110P13381100281040671汉陈思颖男1996-01-06430281199601065919 3110P13381100281040649汉管群女1995-05-2043028119950520072x 3110P13381100281040661汉赵宇萌男1995-11-29430281199511291314 3110P13381100281040670汉刘苏其女1993-06-18430281199306184325 3110P13381100281040679汉朱玲英女1994-07-283110P13381100281040690汉吴昕女1995-07-25430281199507259143 3110P13381100281040645汉付都女1994-09-03430281199409036667 3110P13381100281040681汉黎莎女1996-06-26430281199606265821 3110P13381100281040665汉李钰婷女1995-10-24430281199510247725 3110P13381100281040692汉柳思琪女1994-08-31430281199408311321 3110P13381100281040651汉陈雨香女1995-03-0343028119950303772x 3110P13381100281040674汉兰柳女1994-01-2943028119940129002x 3110P13381100281040642汉黄晓男1994-01-12430281199401129017 3110P13381100281040658汉肖娅女1995-08-17430281199508170044 3110P13381100281040652汉刘子铭男1995-06-23430281199506230058 3110P13381100281040673汉易优女1993-06-19430281199306197388 3110P13381100281040685汉罗龙雪男1995-01-11430281199501111017 3110P13381100281040660汉林露女1995-09-12430281199509127742 3110P13381100281040656汉兰张洋男1995-09-08430281199509081035 3110P13381100281040657汉陈程女1994-09-3043028119940930756x 3110P13381100281040672汉郑鹏男1995-05-31430281199505311016 3110P13381100281040006汉唐汝珩男1993-09-2443028119930924133X 3110P13381100281040643汉谢薇女1995-05-20430281199505203023 3110P13381100281040655汉张茜女1995-08-13430281199508133921 3110P13381100281040650汉李汪洋男1994-10-05430281199410054512 3110P13381100281040648汉蔡安女1996-04-06430281199604063644 3110P13381100281040667汉杨许斌女1994-11-03430281199411037466 3110P13381100281040688汉肖晨男1995-11-15430281199511151012 3110P13381100281040668汉易兵男1992-10-14430281199210147378 3110P13381100281040659汉黄李林女1995-08-03430281199508030041 3110P13381100281040680汉李璐男1995-08-053110P13381100281040662汉张洋男1995-04-27430281199504274655 3110P13381100281040647汉苏道军男1994-12-15430281199412150313 3110P13381100281040666汉刘晋男1995-06-044302811995060478193110P13381100281040669汉李志红女1995-10-20430281199510207723 3110P13381100281040678汉何莉女1994-08-263110P13381100281040664汉刘煜荣女1994-09-20430281199409202047 3110P13381100281040646汉张礼成男1994-04-22430281199404224650 3110P13381100281040676汉肖仁清男1994-08-02430281199408021316 3110P13381100281040654汉丁强男1995-03-21430281199503213017 3110P13381100281040684汉漆莹洁女1996-08-20430281199608200327 3110P13381100281040943汉邓逸琪男1994-11-09430281199411097717 3110P13381100281040677汉罗莎女1994-12-233110P13381100281040002汉兰宗裕男1993-10-17430281199310170014 3110P13381100281040689汉邓兴国男1995-03-26430281199503261318 3110P13381100281040682汉李堂男1995-08-113110P13381100281040675汉刘旭男1994-08-17430281199408173037 3110P13381100281040687汉朱婷女1994-11-29430281199411297380 3110P13381100281040686汉罗顺女1996-01-19430281199601194526 3110P13381100281040653汉张欢女1996-02-02430281199602025329 3110P13381100281040644汉刘新婉女1996-06-07430281199606070020 3110P13381100281040691汉匡世杰男1995-04-1143028119950411001x 3110P13381100281040663汉李拼女1995-09-15430281199509157466 3110P14382100281040726汉吴思女1995-06-26430281199506267360 3110P14382100281040741汉曾乐女1994-09-29430624199409297327 3110P14382100281040746汉朱新理男1994-07-28430281199407281351 3110P14382100281040711汉易林英女1995-10-11430281199510117963 3110P14382100281040696汉戴玉宁女1995-08-06430281199508062721 3110P14382100281040719汉谭海洋男1994-10-17430281199410174813 3110P14382100281040733汉陈敏男1994-11-2143028119941121571x 3110P14382100281040724汉黄园女1994-01-12430281199401127724 3110P14382100281040734汉张翔男1995-06-053110P14382100281040707汉钟林香女1993-11-17430281199311179221 3110P14382100281040727汉唐婷女1995-07-09430281199507095425 3110P14382100281040712汉陈容女1995-08-19430281199508195647 3110P14382100281040725汉廖志强男1995-06-13430281199506137451 3110P14382100281040706汉冯柱男1996-01-24430281199601243017 3110P14382100281040716汉沈贤娟女1995-01-14430281199501142729 3110P14382100281040699汉丁莎莎女1995-06-08430281199506084062 3110P14382100281040729汉黄凤姣女1994-06-27430281199406276024 3110P14382100281040704汉易鑫男1995-08-19430281199508194652 3110P14382100281040728汉刘超男1995-03-19430281199503192316 3110P14382100281040731汉曾雪女1994-09-25430521199409252888 3110P14382100281040715汉李珊女1993-10-06430281199310067869 3110P14382100281040730汉骆益红女1994-08-2943028119940829236x 3110P14382100281040732汉易勇男1995-08-2643028119950826071x 3110P14382100281040709汉胡子琴女1995-08-16430281199508169123 3110P14382100281040745汉周维明男1994-10-11430281199410117376 3110P14382100281040700汉邓斌男1995-05-15430281199505152318 3110P14382100281040708汉彭柳女1995-11-22430281199511229123 3110P14382100281040701汉吴丽莹女1995-08-17430281199508173624 3110P14382100281040713汉王幸红男1995-06-04430281199506049216 3110P14382100281040698汉刘胜强男1994-08-22430281199408225714 3110P14382100281040705汉易悠悠女1995-09-29430281199509290726 3110P14382100281040744汉李志男1995-05-284302811995052833183110P14382100281040737汉贺兴男1994-08-30430281199408301318 3110P14382100281040722汉李宇峰男1995-08-13430281199508134676 3110P14382100281040695汉李南英女1995-06-04430281199506043623 3110P14382100281040742汉吴子岑女1994-08-30430219199408301029 3110P14382100281040694汉黎望男1995-07-1043028119950710431x 3110P14382100281040740汉周锋男1994-05-02430281199405027376 3110P14382100281040710汉谢栋男1994-12-23430281199412231316 3110P14382100281040718汉汤鹏男1995-03-19430281199503194311 3110P14382100281040702汉张玉女1994-10-12430281199410126045 3110P14382100281040721汉张琳女1994-06-10430281199406104521 3110P14382100281040736汉邓慧女1995-10-09430281199510091329 3110P14382100281040714汉刘勇男1994-04-27430281199404272716 3110P14382100281040720汉张立女1996-07-16430281199607163325 3110P14382100281040723汉彭涛男1996-01-23430281199601239114 3110P14382100281040697汉刘理平男1994-07-03430281199407037551 3110P14382100281040717汉易雨柔女1994-08-30430281199408300024 3110P14382100281040743汉黄敏女1995-07-31430281199507314528 3110P14382100281040735汉吴丹女1994-12-09430281199412091026 3110P14382100281040703汉刘滔女1993-03-163110P14382100281040739汉张佳琲男1994-08-22430281199408221019 3110P14382100281040738汉汤洋女1995-05-06430281199505061643 3110P15383100281040780汉易春男1995-05-2343028119950523361X 3110P15383100281040755汉温子良男1995-08-08430281199508086619 3110P15383100281040787汉邓婷女1994-08-1843028119940818916X 3110P15383100281040779汉吴谢婷女1995-02-05430281199502057366 3110P15383100281040781汉易红霞女1995-03-153110P15383100281040784汉欧阳晓晴女1994-11-18430281199411185928 3110P15383100281040751汉凌宇女1995-08-04430281199508045622 3110P15383100281040783汉张骁虬男1995-08-07430281199508070035 3110P15383100281040782汉潘益民男1995-09-033110P15383100281040762汉柳敏女1995-10-03430281199510037461 3110P15383100281040768汉许智涛男1994-06-06430281199406061314 3110P15383100281040759汉谢露女1995-08-14430281199508143644 3110P15383100281040770汉易双女1994-03-01430281199403013923 3110P15383100281040788汉曾繁煜男1994-08-04430281199408043312 3110P15383100281040773汉吴惠敏女1995-01-2243028119950122736X 3110P15383100281040790汉钟任兵男1994-11-07430281199411075112 3110P15383100281040786汉孙学琴女1994-02-12500228199402125065 3110P15383100281040758汉邬梦秋女1994-07-06362202199407064021 3110P15383100281040795汉刘顺男1995-01-06430281199501063019 3110P15383100281040003汉钟羽轩男1994-02-13430281199402131311 3110P15383100281040774汉甘妙男1995-05-0243028119950502771X 3110P15383100281040775汉钟梓钰女1996-02-01430281199602012325 3110P15383100281040750汉潘志雄男1995-11-10430281199511107038 3110P15383100281040769汉李孝许男1994-05-25430281199405253613 3110P15383100281040756汉喻娟女1995-01-14430281199501140029 3110P15383100281040765汉郭鹏飞女1995-10-2743028119951027466X 3110P15383100281040753汉张强男1995-03-1143028119950311465X 3110P15383100281040761汉李勇男1996-01-14430281199601142718 3110P15383100281040748汉张雅玉女1996-01-0943021919960109616X 3110P15383100281040789汉余敏女1995-05-154302811995051553243110P15383100281040796汉吴驰男1995-02-28430281199502287399 3110P15383100281040749汉陈登男1996-03-01430281199603017750 3110P15383100281040793汉刘鹏琳男1994-08-20360313199408200331 3110P15383100281040763汉张美林女1994-03-26430281199403264060 3110P15383100281040777汉李威明男1995-08-14430281199508142713 3110P15383100281040797汉殷志成男1995-01-25430281199501251319 3110P15383100281040757汉柳英女1996-01-22430281199601224668 3110P15383100281040791汉张羽健女1994-12-18430281199412181320 3110P15383100281040792汉刘飞宇男1994-06-1143028119940611771X 3110P15383100281040767汉刘检男1994-11-17430281199411177717 3110P15383100281040747汉吴锐女1996-02-25430281199602259168 3110P15383100281040752汉陈汝婷女1996-02-21430281199602213629 3110P15383100281040776汉李云珑女1995-02-11430281199502110323 3110P15383100281040760汉侯蓓女1994-11-22430281199411227024 3110P15383100281040754汉李志辉女1994-11-19430281199411194066 3110P15383100281040764汉周威男1994-01-07432503199401077471 3110P15383100281040778汉陈雅琪女1995-07-22430281199507224661 3110P15383100281040794汉丁维男1995-12-24430281199512244050 3110P15383100281040785汉漆子毅男1995-07-1443028119950714133X 3110P15383100281040772汉王玺芳女1995-09-083110P15383100281040766汉汤子峰男1996-04-07430281199604077915 3110P15383100281040771汉陈威男1995-06-02430281199506020018 3110P15383100281040798汉叶雨男1993-08-01430281199308017352 3110P16384100281040839汉黄溪坤男1995-05-26430281199505261610 3110P16384100281040822汉陈莎女1995-05-17430281199505174525 3110P16384100281040835汉曾慧女1995-06-28430281199506289121 3110P16384100281040851汉陈治湘男1994-08-1243028119940812231x 3110P16384100281040830汉文玉霜女1994-07-09430281199407095620 3110P16384100281040814汉钟领女1995-02-01430281199502019220 3110P16384100281040799汉钟磊男1995-03-25430281199503252710 3110P16384100281040832汉钟韶明女1994-08-14430281199408145845 3110P16384100281040834汉宋君男1994-09-03430281199409031014 3110P16384100281040810汉张萍女1994-11-22430281199411223621 3110P16384100281040829汉文鹏程男1994-10-163110P16384100281040820汉李宇成男1994-08-19430281199408191315 3110P16384100281040837汉朱婉琴女1995-11-25430281199511252323 3110P16384100281040800汉徐旭女1995-06-20430281199506207923 3110P16384100281040821汉黄鑫成男1995-03-05430281199503059216 3110P16384100281040808汉张剑男1994-07-09362204199407095111 3110P16384100281040850汉李俊辰男1994-07-21430281199407210035 3110P16384100281040805汉汤慧娟女1996-06-1043028119960610792x 3110P16384100281040818汉郭婷女1995-02-0443028119950204272x 3110P16384100281040843汉吴莎女1995-01-29430281199501297384 3110P16384100281040844汉吴兴新男1995-01-16430281199501163634 3110P16384100281040846汉唐玉蓉女1995-12-10430281199512101324 3110P16384100281040841汉张志豪男1995-09-27430281199509272018 3110P16384100281040852汉赖响男1994-09-24430281199409247915 3110P16384100281040806汉吴峥女1995-10-2843028119951028362x 3110P16384100281040809汉黎云男1996-12-03360313199612031037 3110P16384100281040847汉郭远鹏男1995-02-07430281199502072312 3110P16384100281040804汉吴密男1994-06-06。

数据库安全检查表

数据库安全检查表1. 数据库配置- [ ] 确保数据库的默认账户已禁用或已更改用户名和密码- [ ] 检查数据库的监听端口是否安全，避免使用常用端口号- [ ] 启用审计日志功能，记录重要的数据库操作- [ ] 确保数据库的远程访问权限仅限于必要的IP地址2. 数据库访问控制- [ ] 确保每个用户都具有合适的权限，并限制他们的访问范围- [ ] 设置密码策略，包括密码长度、复杂度和定期更改要求- [ ] 禁止共享账户，并追踪用户的登录活动- [ ] 定期检查并删除不再使用的账户3. 数据备份与恢复- [ ] 设置定期自动备份，并确保备份文件的安全存储- [ ] 定期测试数据库的备份和恢复过程- [ ] 检查备份文件的完整性和可用性4. 数据库补丁和更新- [ ] 定期检查数据库供应商的安全补丁和更新- [ ] 及时应用数据库的安全补丁和更新- [ ] 评估并测试补丁的兼容性和可靠性5. 弱点和漏洞管理- [ ] 扫描数据库以检测潜在的弱点和漏洞- [ ] 及时修复发现的弱点和漏洞- [ ] 监控数据库的安全事件和攻击行为6. 安全审计与监控- [ ] 设置安全审计跟踪，并记录关键事件- [ ] 监控数据库资源的使用情况和性能- [ ] 实施入侵检测系统，并监控异常行为7. 数据加密与防护- [ ] 对敏感数据进行加密，并确保加密算法的安全性- [ ] 禁止明文传输数据库连接的数据- [ ] 使用安全的传输协议（如SSL/TLS）保护数据库连接- [ ] 实施访问控制和身份验证机制以防止未经授权的数据访问8. 员工培训与意识- [ ] 提供数据库安全培训给相关员工- [ ] 强调密码安全和常见的安全威胁- [ ] 定期提醒员工注意安全意识和行为以上是数据库安全检查表，应定期执行以确保数据库的安全性。

请按照检查表逐项进行检查并记录相应的改进措施和修复活动。

指标数据TP50、TP90、TP99、TP999

指标数据TP50、TP90、TP99、TP999
概念：TP指标: 指在一个时间段内，统计该方法每次调用所消耗的时间，并将这些时间按从小到大的顺序进行排序,并取出结果为：总次数 * 指标数 = 对应TP指标的值，在取出排序好的时间。

TP50：指在一个时间段内（如5分钟），统计该方法每次调用所消耗的时间，并将这些时间按从小到大的顺序进行排序，取第50%的那个值作为TP50 值；配置此监控指标对应的报警阀值后，需要保证在这个时间段内该方法所有调用的消耗时间至少有50%的值要小于此阀值，否则系统将会报警。

TP90，TP99，TP999与TP50值计算方式一致，它们分别代表着对方法的不同性能要求，TP50相对较低，TP90则比较高，TP99，TP999则对方法性能要求很高。

举个例子：有四次请求耗时分别为：
10ms，1000ms，100ms，2ms
那么我们可以这样计算TP99：4次请求中，99%的请求数为4*0.99，进位取整也就是4次，满足这全部4次请求的的最低耗时为1000ms，也就是TP99的答案是1000ms。

思迅商锐数据库表表名对照

思迅商锐数据库表表名对照menu_id menu_name menu_code menu_typeopen_type 1000档案MODU S1100往来单位MODU S1101供应商档案w_bd_SUPCUST_form EDIT S1102客户类别w_bd_cust_type EDIT S1103客户区域w_bd_area_class EDIT S1104客户档案w_bd_cust_form EDIT S1200商品信息MODU S1201商品品类w_bd_CLASS_FORM EDIT S1202商品档案w_bd_ITEM_FORM EDIT S1203组合商品w_bd_CSITEM_FORM EDIT S1205分店SKU管理w_bd_branchcls_sku EDIT S1206分店商品配置w_bd_branchitem_putup EDIT S1207新品申请w_bd_item_form_app EDIT S1208新品审核w_bd_item_form_app EDIT S1209新品试销分析报表w_rm_trialsale_analyse BROW S1210商品综合查询w_bd_query_item BROW S1211商品异常查询w_bd_unnormal_item BROW S1212条码黑名单w_bd_barcode_blacklist EDIT S1213商品属性检查w_bd_unnormal_test BROW S1214组合商品查询w_bd_comb_info_query BROW S1241商品设置w_sys_setup_input OTHR R1242批量修改商品属性w_bd_itempro_batch EDIT S1243基础代码w_bd_basecode EDIT S1244助记码更新w_bd_zjm_update BROW R1245编号修改w_bd_item_update BROW R1246导出商品w_bd_item_export_for_pd OTHR R1247普通价签w_pc_price_tag OTHR R1248条码价签w_rm_print_barcode_pricetab OTHR R1249调价历史查询w_bd_query_adjust_price BROW S1281商品条码w_sys_view_doc OTHR S1282改包销售w_sys_view_doc OTHR S1283礼篮w_sys_view_doc OTHR S1284加工品w_sys_view_doc OTHR S1285一码多品w_sys_view_doc OTHR S1300分店机构MODU S1301分店仓库w_bd_branch_form EDIT S1302货架货位w_bd_shelf_form EDIT S1303商品陈列与存量指标w_bd_shelf_item EDIT S1400生命周期MODU S1401商品生命周期w_bd_item_lifecycle EDIT S1402供应商生命周期w_bd_supcust_lifecycle EDIT S1500档案辅助MODU S1501商品设置w_sys_setup_input OTHR R1502商品转供应商w_sys_item_transfer EDIT S1503供应商转经营方式w_sys_sup_transfer EDIT S1504批量修改商品属性w_bd_itempro_batch EDIT S1505编号修改w_bd_item_update BROW R 1506基础代码w_bd_basecode EDIT S 1507助记码更新w_bd_zjm_update BROW R 1508导出盘点商品w_bd_item_export_for_pd OTHR R 1600档案说明MODU S 1601商品条码w_sys_view_doc OTHR S 1602改包销售w_sys_view_doc OTHR S 1603礼篮w_sys_view_doc OTHR S 1604加工品w_sys_view_doc OTHR S 1605一码多品w_sys_view_doc OTHR S 2000合同MODU S 2100采购合同MODU S 2101购销合同建立w_bd_contract_gx EDIT S 2102代销合同建立w_bd_contract_dx EDIT S 2103扣率代销合同建立w_bd_contract_kldx EDIT S 2104联营合同建立w_bd_contract_ly EDIT S 2105租赁合同建立w_bd_contract_zl EDIT S 2200合同维护MODU S 2202合同暂停w_bd_contract_pause EDIT S 2203合同解除w_bd_contract_free EDIT S 2204合同作废w_bd_contract_del EDIT S 2300合同说明MODU S 2301合同业务w_sys_view_doc OTHR S 2302合同流程w_sys_view_doc OTHR S 3000采购MODU S 3100补货管理MODU S 3102导购w_pm_wizard OTHR R 3103补货申请单w_pm_sheet_bh SHEE S 3104批量处理补货单w_pm_batch_dispose_bh OTHR R 3105补货分析表REPT S 3106永续订单w_pm_sheet_yx SHEE S 3107补货分析表(按分店和商品分组)REPT S 3141采购订单状态报表REPT S 3142采购订单到货率报表REPT S 3143采购订单到期报表REPT S 3144采购订单类别汇总报表REPT S 3145单据批量打印w_pub_bill_print BROW S 3200采购业务MODU S 3201采购订单w_pm_sheet_po SHEE S 3202采购订单状态跟踪w_pm_trace_order OTHR S 3203采购收货单w_pm_sheet_pi SHEE S 3204采购退货单w_pm_sheet_ro SHEE S 3205单据批量打印w_pub_bill_print BROW S 3206条码打印w_rm_print_barcode_id OTHR R 3207采购退货通知单w_pm_sheet_rt SHEE S 3241供应商档案w_bd_SUPCUST_form EDIT S 3242采购订单w_pm_sheet_po SHEE S3243采购设置w_sys_setup_purchase OTHR R 3244发票录入w_bd_input_fp BROW S 3246询价单w_pm_sheet_xj SHEE S 3281条码打印说明w_sys_view_doc OTHR S 3282保质期管理w_sys_view_doc OTHR S 3300采购辅助MODU S 3301采购设置w_sys_setup_purchase OTHR R 3302发票录入w_bd_input_fp BROW S 3303询价单w_pm_sheet_xj SHEE S 3304发票查询w_bd_fp_query BROW S 3305询价单明细查询REPT S 3400采购报表MODU S 3401采购商品汇总报表REPT S 3402采购大类汇总报表REPT S 3403采购类别汇总报表REPT S 3404采购订单状态报表REPT S 3405采购订单到货率报表REPT S 3406采购订单到期报表REPT S 3407采购订单类别汇总报表REPT S 3408采购类单据查询w_pm_query_with_tv BROW S 3409历史进价查询REPT S 3410采购订单供应商汇总报表REPT S 3411采购商品明细报表REPT S 3412采购中类汇总报表REPT S 3500供应商相关MODU S 3501供应商综合查询w_bd_supplier_query BROW S 3502采购供应商汇总报表REPT S 3503供应商销售汇总REPT S 3504供应商销售明细报表REPT S 3505供应商送货信用度报表REPT S 3506供应商机构销售汇总报表REPT S 3507供应商每天单品销售报表REPT S 3600采购说明MODU S 3601条码打印说明w_sys_view_doc OTHR S 3602保质期管理w_sys_view_doc OTHR S 4000价格MODU S 4100调基本价MODU S 4101调价单w_pc_SHEET_PX SHEE S 4102批发价调价单w_pc_sheet_lk SHEE S 4103批量调价w_bd_batch_change_price BROW R 4104调价生效提醒REPT S 4105调价历史查询w_bd_query_adjust_price BROW S 4200常用促销MODU S 4201促销进价单w_pc_sheet_pf SHEE S 4202促销特价单w_pc_sheet_ps SHEE S 4203超量特价单w_pc_sheet_pn SHEE S 4204类别品牌促销单w_pc_sheet_pu SHEE S4205超额奖励w_pc_sheet_ph SHEE S 4206时段特价单w_pc_sheet_pe SHEE S 4207促销补差单w_pc_sheet_bc SHEE S 4300特色促销MODU S 4301DM促销单w_pc_sheet_dm SHEE S 4302赠品促销w_rm_present_sales_promotion EDIT S 4303优惠券促销单w_pc_sheet_py SHEE S 4304条件组合促销单w_pc_sheet_pg SHEE S 4305买满直减w_pc_sales_promotion EDIT S 4306量贩价促销单w_pc_sheet_pm SHEE S 4307类别梯度折扣促销单w_pc_sheet_lf SHEE S 4308促销终止w_pc_specprice_cancel BROW S 4309偶数特价单w_pc_sheet_pk SHEE S 4310买满折扣w_pc_sheet_pr SHEE S 4400促销查询MODU S 4401当前促销查询w_pc_query_specprice BROW S 4402历史促销查询w_pc_promotion_history BROW S 4403促销业绩查询w_pc_promotion_sale BROW S 4404促销销售查询w_pc_query_spec_sale BROW S 4405优惠券销售查询w_rm_yhq_sale_detail BROW S 4406DM促销跟踪报表w_pc_promotion_sale_dm BROW S 4407促销档期销售查询w_pc_query_distance_dm BROW S 4408DM销售对比查询REPT S 4409DM销售日比REPT S 4500让利查询MODU S 4501销售让利汇总REPT S 4502销售让利明细REPT S 4503收银员让利REPT S 4504收银员让利明细REPT S 4505促销让利汇总REPT S 4506让利类别汇总REPT S 4507让利大类汇总REPT S 4541当前促销查询w_pc_query_specprice BROW S 4542历史促销查询w_pc_promotion_history BROW S 4543促销业绩查询w_pc_promotion_sale BROW S 4544促销销售查询w_pc_query_spec_sale BROW S 4545优惠券销售查询w_rm_yhq_sale_detail BROW S 4546DM促销跟踪报表w_pc_promotion_sale_dm BROW S 4600价格说明MODU S 4601促销扣率w_sys_view_doc OTHR S 4602进货搭赠w_sys_view_doc OTHR S 4603自然组合促销w_sys_view_doc OTHR S 4604捆绑促销w_sys_view_doc OTHR S 4605条件组合促销w_sys_view_doc OTHR S 5000卖场MODU S 5100营运设置MODU S 5101POS设置w_sys_setup_pos EDIT R5102POS功能预设w_sys_pos_function EDIT R 5103POS登记w_sys_pos_ip_spec OTHR R 5104缴款设置w_sys_setup_jk EDIT R 5105柜台营业员w_rm_saleman EDIT R 5200收银缴款MODU S 5201收银对账w_rm_cashier_query BROW S 5202缴款单w_rm_sheet_jk SHEE S 5203长短款报表w_rm_cdk_report_summary_new BROW S 5204长短款报表(班次)w_rm_cdk_report_summary_shift BROW S 5300营运相关MODU S 5301日结w_sys_data_daysum EDIT R 5302时段销售分析w_rm_sale_analyze_byhour BROW S 5303客单分析w_rm_sale_analyze BROW S 5304卖场监控w_rm_pos_monitor BROW S 5305店长日志w_rm_edit_mglog EDIT S 5306班次查询w_rm_shift_query BROW S 5307成本重结转w_sys_data_redaysum EDIT R 5400销售报表MODU S 5401流水查询w_rm_possale_queryBROW S 5402商品销售汇总报表REPT S 5403大类销售汇总报表ANAL S 5404类别销售汇总报表ANAL S 5405门店销售汇总报表ANAL S 5406供应商销售汇总报表ANAL S 5407品牌销售汇总报表ANAL S 5408库位销售汇总报表REPT S 5409商品销售分部汇总报表REPT S 5410类别销售分部汇总报表REPT S 5411日均销售报表REPT S 5412商品销售明细报表REPT S 5413中类销售汇总报表ANAL S 5414商品销售汇总报表(按商品和售价分组)REPT S 5415商品销售日报表REPT S 5416类别销售日报表REPT S 5417大类销售日报表REPT S 5418品牌销售日报表REPT S 5419门店销售日报表ANAL S 5420供应商销售日报表REPT S 5421营业员销售提成w_rm_saleman_query BROW S 5422柜台销售查询w_rm_counter_query BROW S 5423品牌销售分店汇总表REPT S 5424供应商付款方式汇总w_rm_supplier_payinfo BROW S 5425收银员业绩考核报表REPT S 5426门店销售坪效分析REPT S 5427商品库位销售汇总报表REPT S 5431机构供应商销售汇总报表REPT S 5500毛利报表MODU S5501商品毛利日报表REPT S 5502类别毛利日报表REPT S 5503大类毛利日报表REPT S 5504品牌毛利日报表REPT S 5505门店毛利日报表REPT S 5506供应商毛利日报表REPT S 5507商品毛利汇总报表REPT S 5508类别毛利汇总报表ANAL S 5509大类毛利汇总报表ANAL S 5510品牌毛利汇总报表ANAL S 5511门店毛利汇总报表ANAL S 5512供应商毛利汇总报表ANAL S 5513供应商类别毛利汇总报表ANAL S 5514商品毛利汇总报表(按仓库)REPT S 5515毛利分析(按税率)REPT S 5516中类毛利汇总REPT S 5517库位毛利汇总报表ANAL S 5518库位商品毛利汇总报表ANAL S 5519经营方式毛利汇总报表ANAL S 5600卖场说明MODU S 5601日结说明w_sys_view_doc OTHR S 5602班次管理w_sys_view_doc OTHR S 5603支付宝付款说明w_sys_view_doc OTHR S 6000生鲜MODU S 6100主要功能MODU S 6101电子称w_rm_balance OTHR R 6102永续订单w_pm_sheet_yx SHEE S 6103时段特价单w_pc_sheet_peSHEE S 6104部门调货单w_im_sheet_zh SHEE S 6105部门调货汇总表REPT S 6200相关功能MODU S 6201组合商品w_bd_CSITEM_FORM EDIT S 6202自动组拆汇总表w_im_query_cs BROW S 6203组合拆分单w_im_sheet_cs SHEE S 6204组合拆分汇总表REPT S 6300生鲜说明MODU S 6301电子称说明w_sys_view_doc OTHR S 6302肉类分割w_sys_view_doc OTHR S 6303熟食加工w_sys_view_doc OTHR S 6304面包房w_sys_view_doc OTHR S 6305水果分级w_sys_view_doc OTHR S 7000批发MODU S 7100客户信息MODU S 7101客户区域管理w_bd_area_class EDIT S 7102客户类别管理w_bd_cust_type EDIT S 7103客户商品关系w_bd_cust_price EDIT S 7104客户档案w_bd_cust_form EDIT S7105批发价调价单w_pc_sheet_lk SHEE S 7200批发业务MODU S 7201批发订单w_wm_sheet_ss SHEE S 7202销售订单状态跟踪w_wm_trace_order OTHR S 7203批发销售单w_wm_sheet_so SHEE S 7204批发退货单w_wm_sheet_ri SHEE S 7205业务员销售提成w_rm_orderman_query BROW S 7206批发发票录入w_bd_input_fp BROW S 7241客户费用单w_fm_SHEET_FC SHEE S 7242客户结算单w_fm_SHEET_RP SHEE S 7243客户到期帐款报表REPT S 7244应收帐款汇总报表REPT S 7245应收帐款明细报表REPT S 7246客户历史往来帐款报表REPT S 7247已收账款明细报表REPT S 7248客户信誉额度报表REPT S 7249客户历史往来帐款汇总报表REPT S 7300批发查询MODU S 7301批发类单据查询w_wm_query_with_tv BROW S 7302批发发票查询w_bd_fp_query BROW S 7303客户赠品报表REPT S 7304无业务客户报表REPT S 7305商品批发汇总报表REPT S 7306类别批发汇总报表ANAL S 7307大类批发汇总报表ANAL S 7308主供应商批发汇总报表ANAL S 7309区域批发汇总报表ANAL S 7310品牌批发汇总报表ANAL S 7400销售查询MODU S 7401客户销售汇总报表REPT S 7402客户销售商品汇总报表REPT S 7403客户销售让利汇总报表REPT S 7404批发销售明细报表REPT S 7405业务员客户销售报表REPT S 7406业务员客户销售明细报表REPT S 7407业务员批发销售明细报表REPT S 7500批发毛利MODU S 7501商品批发毛利汇总报表REPT S 7502批发单据毛利报表REPT S 7503商品批发日毛利汇总报表REPT S 7504类别批发毛利汇总报表ANAL S 7505大类批发毛利汇总报表ANAL S 7506客户毛利汇总报表ANAL S 7507业务员毛利汇总报表ANAL S 7508区域毛利汇总报表ANAL S 7509客户类别毛利汇总报表ANAL S 7600批发说明MODU S7601多批发价体系w_sys_view_doc OTHR S 8000库管MODU S 8100库管业务MODU S 8101领用单w_im_sheet_ko SHEE S 8102报损单w_im_sheet_jo SHEE S 8103转仓单w_dm_sheet_io SHEE S 8104库存调整单w_im_sheet_OO SHEE S 8105成本调价单w_pc_sheet_pc SHEE S 8106库存异常与告警w_im_stock_alter BROW S 8107库存设置w_sys_setup_inventroy EDIT R 8108组合拆分单w_im_sheet_cs SHEE S 8109扣补单(分店)w_im_sheet_kb SHEE S 8141仓库类单据查询w_im_query_with_tv BROW S 8142库存调整汇总表REPT S 8143成本价调整查询w_pc_query_adjust_price BROW S 8144领用汇总表REPT S 8145报损汇总表REPT S 8146转仓商品汇总REPT S 8147转仓类别汇总REPT S 8148转仓分部汇总REPT S 8149转仓明细查询REPT S 8150库存调整明细表REPT S 8151组合拆分汇总表REPT S 8152SX3700盘点机w_sys_view_doc OTHR S 8200盘点业务MODU S 8201盘点计划w_sys_view_doc OTHR S 8202预盘单w_im_sheet_pdrecord SHEE S 8203盘点号申请w_im_pd_init EDIT R 8204存货盘点单w_im_sheet_pd SHEE S 8205盘点差异处理单w_im_pd_process SHEE S 8206盘点报表w_im_pd_summary BROW S 8207预盘单明细w_im_query_pdrecord BROW S 8208点货w_sys_view_doc OTHR S 8209核对盘点差异w_sys_view_doc OTHR S 8210盘点机w_sys_view_doc OTHR S 8300库存查询MODU S 8301商品库存汇总REPT S 8302类别库存汇总REPT S 8303实时库存REPT S 8304出入库汇总REPT S 8305出入库明细REPT S 8306机构商品库存汇总REPT S 8307机构大类库存汇总REPT S 8308分店库存汇总REPT S 8309历史库存查询w_im_stock_summary_history BROW S 8310库存分析报表REPT S 8311在途库存报表REPT S8312大类库存汇总REPT S 8400业务汇总MODU S 8401仓库类单据查询w_im_query_with_tv BROW S 8402库存调整汇总表REPT S 8403成本价调整查询w_pc_query_adjust_price BROW S 8404领用汇总表REPT S 8405报损汇总表REPT S 8406转仓商品汇总REPT S 8407转仓类别汇总REPT S 8408转仓分部汇总REPT S 8409转仓明细查询REPT S 8410库存调整明细表REPT S 8411组合拆分汇总表REPT S 8412报损大类汇总报表REPT S 8500批次库存MODU S 8501批次结存REPT S 8502批次进销存REPT S 8503批次未冲销数据REPT S 8504批次出库REPT S 8505商品批次毛利日报表REPT S 8506类别批次毛利日报表REPT S 8507大类批次毛利日报表REPT S 8508商品批次毛利报表REPT S 8509类别批次毛利报表REPT S 8510大类批次毛利报表REPT S 8600进销存业务MODU S 8601商品进销存日报表REPT S 8602类别进销存类别日报表REPT S 8603大类进销存日报表REPT S 8604供应商进销存日报表REPT S 8605商品进销存报表REPT S 8606类别进销存报表REPT S 8607供应商进销存汇总报表REPT S 9000卡券MODU S 9100卡券业务MODU S 9101会员设置w_rm_setup_vip_card OTHR R 9102会员设置向导w_rm_setup_vip_card_new OTHR R 9103批量制卡w_rm_saving_make EDIT R 9104发卡w_rm_vip_new EDIT R 9105会员档案w_rm_vip_FORM EDIT S 9106卡管理w_rm_saving_admin EDIT R 9107换卡补卡w_vip_instead_and_renew EDIT R 9108会员档案审核w_vip_info_edit_approve BROW S 9109会员限量特价单w_pc_sheet_pv SHEE S 9110批量删除会员w_rm_vip_del EDIT S 9111会员结构分析w_vip_analyze BROW S 9112会员生日REPT S 9113批量修改会员信息w_vip_info_batch EDIT S 9114一卡通用户设置w_vip_oct_operator EDIT R 9141积分业务查询w_vip_query BROW S 9142会员消费查询w_vip_paid_query BROW S 9143储值卡查询w_rm_saving_query BROW S 9144储值卡消费查询w_vip_paid_query BROW S 9145积分清除w_rm_vip_clear_acc OTHR S 9146卡管理操作日志报表REPT S 9181会员优惠价w_sys_view_doc OTHR S 9182卡介质说明w_sys_view_doc OTHR S 9183积分升级w_sys_view_doc OTHR S 9200积分业务MODU S 9201积分业务查询w_vip_query BROW S 9202会员积分兑换w_vip_consume_dec EDIT R 9203会员礼品管理w_rm_vip_good EDIT S 9204会员消费查询w_vip_paid_query BROW S 9205积分清除w_rm_vip_clear_acc OTHR S 9206时段积分w_pc_sheet_jf SHEE S 9283积分升级w_sys_view_doc OTHR S 9284会员消费积分w_sys_view_doc OTHR S 9300储值业务MODU S 9301储值卡查询w_rm_saving_query BROW S 9302储值卡消费查询w_vip_paid_query BROW S 9303充值w_rm_saving_add EDIT R 9304批量充值w_rm_saving_batchadd EDIT R 9305积分转储值w_vip_consume_to_savamt EDIT R 9306批量积分转储值w_vip_consume_to_savamt_lot EDIT S 9307一卡通消费查询w_vip_paid_oct_query BROW S 9381储值消费w_sys_view_doc OTHR S 9382安全储值卡方案w_sys_view_doc OTHR S 9400卡流程MODU S 9401会员设置w_rm_setup_vip_card OTHR R 9402发卡w_rm_vip_new EDIT R 9403卡入库w_vip_sheet_vi SHEE S 9404卡领用w_vip_sheet_vo SHEE S 9405卡销售w_vip_sheet_vs SHEE S 9406卡销售统计w_vip_query_card_sale BROW S 9407卡领用统计w_vip_query_card_out BROW S 9408卡入库统计w_vip_query_card_in BROW S 9409卡制作统计w_vip_query_card_make BROW S 9441卡管理w_rm_saving_admin EDIT R 9481卡流程说明w_sys_view_doc OTHR S 9500购物券管理MODU S 9501券设置w_pc_setup_certificate OTHR R 9502制券w_rm_gift_certificate EDIT S 9503券入库w_qm_sheet_qi SHEE S 9504券领用w_qm_sheet_qo SHEE S9505券销售w_qm_sheet_qs SHEE S 9506券作废w_qm_sheet_qd SHEE S 9507券统计w_pc_query_certificate BROW S 9581券流程说明w_sys_view_doc OTHR S 9600卡券说明MODU S 9601卡流程说明w_sys_view_doc OTHR S 9602券流程说明w_sys_view_doc OTHR S 9603会员优惠价w_sys_view_doc OTHR S 9604积分升级w_sys_view_doc OTHR S 9605安全储值卡方案w_sys_view_doc OTHR S 9606卡介质说明w_sys_view_doc OTHR S 9607会员消费积分w_sys_view_doc OTHR S 9608储值消费w_sys_view_doc OTHR S A000结算MODU S A100应付管理MODU S A101购销返利计算w_fm_SHEET_CP SHEE S A102代销帐款w_fm_sheet_dx_v6SHEE S A103联营帐款w_fm_SHEET_ly SHEE S A104扣率代销帐款w_fm_sheet_kldx SHEE S A105租赁帐款w_fm_SHEET_zl SHEE S A107费用单w_fm_SHEET_FG SHEE S A108扣补单w_im_sheet_kb SHEE S A109供应商对帐单w_fm_SHEET_dP SHEE S A110供应商付款单w_fm_SHEET_FK SHEE S A111库存冲减单w_im_sheet_rd SHEE S A112供应商预结算单w_fm_sheet_fs SHEE S A113供应商预付款单w_fm_sheet_sa SHEE S A114账期管理w_fm_approve_account EDIT S A115供应商批量结算w_fm_batch_settle EDIT S A116供应商批量对账w_fm_batch_check EDIT S A117历史供应商对帐单查看w_fm_sheet_dp_forold SHEE S A118历史供应商付款单查看w_fm_sheet_fkfor_old SHEE S A119账期查询w_fm_query_account EDIT S A120扣补向导w_kb_wizard OTHR R A141采购商品汇总报表REPT S A142采购大类汇总报表REPT S A143采购类别汇总报表REPT S A144采购供应商汇总报表REPT S A145历史进价查询REPT S A146供应商到期帐款报表REPT S A147应付帐款汇总报表REPT S A148应付帐款明细报表REPT S A149供应商历史往来帐款报表REPT S A150实付账款明细报表REPT S A151供应商对账单明细报表w_fm_dp_master_report BROW S A152供应商对帐情况报表REPT S A200应付相关MODU SA201供应商到期帐款报表REPT S A202应付帐款汇总报表REPT S A203应付帐款明细报表REPT S A204供应商历史往来帐款报表REPT S A205实付账款明细报表REPT S A206代销查询w_im_batch_stock BROW S A207联营商品销售表w_rm_ly_salepos BROW S A208扣率代销查询w_rm_ly_salepos BROW S A209供应商费用明细报表REPT S A210供应商费用汇总报表REPT S A211供应商费用机构汇总报表REPT S A212扣补单查询报表REPT S A213扣补单明细查询REPT S A214供应商往来账REPT S A215供应商账款查询w_fm_settle_query BROW S A300应收管理MODU S A301客户费用单w_fm_SHEET_FC SHEE S A302客户结算单w_fm_SHEET_RP SHEE S A303内部费用单w_fm_sheet_ng SHEE S A304内部收款单w_fm_sheet_zp SHEE S A305客户预收款单w_fm_SHEET_SD SHEE S A306客户收款单w_fm_SHEET_GA SHEE S A400应收相关MODU S A401客户到期帐款报表REPT S A402应收帐款汇总报表REPT S A403应收帐款明细报表REPT S A404客户历史往来帐款报表REPT S A405已收账款明细报表REPT S A406客户信誉额度报表REPT S A407客户历史往来帐款汇总报表REPT S A408内部帐款查询w_fm_summary_zp BROW S A500结算相关MODU S A501结算设置w_sys_setup_balance EDIT R A502帐务代码w_bd_fmcode EDIT S A503费用代码w_bd_fm_charge EDIT S A600结算说明MODU S A601结算业务w_sys_view_doc OTHR S A602经营方式w_sys_view_doc OTHR S B000连锁MODU S B100传输管理MODU S B101分店业务设置w_cm_setup_barnch EDIT R B102店组信息w_bd_branch_group EDIT R B103数据传输w_client OTHR R B104传输日志w_cm_log BROW S B105传输断点调整w_cm_breakpoint_adjust OTHR R B106传输明细日志w_cm_log_err BROW S B107总部数据分发w_send_data_set OTHR RB108单据下载查询w_pc_down_query BROW S B200智能配送MODU S B201要货单w_dm_sheet_yh SHEE S B202门店补货向导w_bh_wizard OTHR R B203配货池w_dm_ph_pool BROW R B204囤货分析w_dm_th_analysis BROW S B205采购配货单w_dm_sheet_dh SHEE S B206配货池查询w_ph_pool_query BROW S B207补货跟踪报表w_dm_report_supply_follow BROW S B208门店要货单状态跟踪报表REPT S B209门店到货率分析报表REPT S B210门店缺货分析报表REPT S B211门店要货汇总报表REPT S B212门店要货商品汇总报表REPT S B300配送业务MODU S B301配送出库单w_dm_sheet_mo SHEE S B302配送入库单w_dm_sheet_mi SHEE S B303直调单w_dm_sheet_io SHEE S B304店间调拨入库单w_dm_sheet_di SHEE S B305店间调拨出库单w_dm_sheet_do SHEE S B400拣货管理MODU S B401摘果式拣货单w_dm_sheet_jh_zg SHEE S B402播种式拣货单w_dm_sheet_jh_bz SHEE S B500配送查询MODU S B501配送率分析报表REPT S B502调出单查询报表REPT S B503配送率分析-按单汇总报表REPT S B504配送商品汇总报表REPT S B505配送调拨类单据查询w_dm_query_with_tv BROW S B506配送类别汇总报表REPT S B507配送分部汇总报表REPT S B508加盟店单据毛利汇总报表REPT S B509调拨商品汇总报表REPT S B510调拨类别汇总报表REPT S B511调拨分部汇总报表REPT S B512直调查询w_dm_io_query BROW S B513调入单查询报表REPT S B514加盟店单据毛利明细报表REPT S B515配送商品明细报表NULL REPT S B516差异回调报表REPT S B517配送大类汇总报表REPT S B518调拨商品明细报表ANAL S B600连锁说明MODU S B601分店业务说明w_sys_view_doc OTHR S B602配货池说明w_sys_view_doc OTHR S C000预警MODU S C100预警管理MODU SC101预警设置w_sys_fore_alarm_setting OTHR R C102预警说明w_sys_view_doc OTHR S C200库存相关MODU S C201库存告警w_sys_start_tips brow S C202过期催销w_sys_start_tips brow S C203异常成本w_sys_start_tips brow S C204负库存商品w_sys_start_tips brow S C205未审核单据w_sys_start_tips brow SC206负毛利商品w_sys_start_tips brow S C207要货单预警w_sys_start_tips brow S C300价格相关MODU S C301特价到期w_sys_start_tips brow S C302特价生效w_sys_start_tips brow S C303价格异常w_sys_start_tips brow S C400采购相关MODU S C401到期订单w_sys_start_tips brow S C402商品属性异常w_sys_start_tips brow Sw_sys_start_tips brow S C403供应商营业执照有效期提C500其它MODU S C501系统异常日志w_sys_start_tips brow S C502会员生日提醒w_sys_start_tips brow S C503到期应收w_sys_start_tips brow S C504到期应付w_sys_start_tips brow S C505合同到期w_sys_start_tips brow S C506新品审核预警w_sys_start_tips brow S D000客服MODU S D100送货管理MODU S D101车辆管理w_sah_vehicle_base EDIT S D102送货单派工w_sah_deliver EDIT S D103送货单反馈w_sah_deliver EDIT S D104送货单月报表REPT S D200安装管理MODU S D201安装单派工w_sah_deliver EDIT S D202安装单反馈w_sah_deliver EDIT S D203安装单月报表REPT S D300售后管理MODU S D301售后服务单受理w_sah_shfw EDIT S D302售后服务单派工w_sah_shfw EDIT S D303售后服务单反馈w_sah_shfw EDIT S D304售后服务月报表REPT S D400投诉管理MODU S D401顾客投诉登记w_sah_ts EDIT S D402顾客投诉处理w_sah_ts EDIT S D403顾客投诉处理月报表REPT S E000审批MODU S E100审批管理MODU S E101审批说明w_sys_view_doc OTHR SE102审批流程设置w_au_audit_set EDIT S E103集中审批w_au_audit_sheet EDIT S E104审批查询w_au_audit_query BROW S F000预算MODU S F100销售计划MODU S F101类别销售计划w_rm_saleplan_itemcls EDIT S F102业务员销售计划w_rm_saleplan_orderman EDIT S F103营业员销售计划w_rm_saleplan_saleman EDIT S F200销售考核MODU S F201类别销售计划完成度w_rm_report_saleplan_itemcls BROW S F202业务员销售计划完成度w_rm_report_saleplan_orderman BROW S F203营业员销售计划完成度w_rm_report_saleplan_saleman BROW S G000决策MODU S G100月结月报MODU S G101月结w_sys_month_settle OTHR R G102进销存月商品汇总REPT S G103进销存月类别汇总REPT S G104进销存月大类汇总REPT S G105进销存月主供应商汇总REPT S G106进销存月中级类别汇总REPT S G107进销存月品牌汇总REPT S G112商品毛利月报表REPT S G113类别毛利月报表REPT S G114大类毛利月报表REPT S G115主供应商毛利月报表REPT S G116中级类别毛利月报表REPT S G117品牌毛利月报表REPT S G200供应商分析MODU S G201供应商销售排行w_rm_sup_sort BROW S G202供应商送货分析ANAL S G203供应商退货分析ANAL S G204供应商结款分析ANAL S G205供应商综合分析ANAL S G206供应商贡献度分析ANAL S G207供应商信誉度分析ANAL S G208供应商信誉度分析(商品)ANAL S G209供应商商品分析ANAL S G210供应商月效益分析ANAL S G211供应商品牌销售分析ANAL S G212供应商品牌销售明细ANAL S G213供应商信誉分析(订单)REPT S G214经营方式分析ANAL S G300周报分析MODU S G301商品销售周报REPT S G302类别销售周报REPT S G303大类销售周报REPT S G304品牌销售周报REPT SG305门店销售周报REPT S G306供应商销售周报REPT S G400商品分析MODU S G401商品销售排行w_rm_item_sort BROW S G402畅销商品w_rm_item_salable BROW S G403滞销商品w_rm_item_badsale BROW S G404价格走势分析w_bd_query_item_price BROW S G405商品价格分析REPT S G406ABC分析w_rm_sales_abc_analyse BROW S G407商品价格带分析ANAL S G408商品价格带销售分析ANAL S G409商品结构分析(大类)ANAL S G410商品结构分析(类别)ANAL S G411主推商品报表REPT S G412商品销售增长率分析REPT S G413商品库存金额分析ANAL S G414商品周转率分析ANAL S G415商品交叉比率分析ANAL S G500对比分析MODU S G501商品月销售对比w_da_ana_item_cross BROW S G502类别月销售对比w_da_ana_class_cross BROW S G503大类月销售对比w_da_ana_bigcls_cross BROW S G504品牌月销售对比w_da_ana_pp_cross BROW S G505供应商月销售对比w_da_ana_sup_cross BROW S G506供应商月采购对比w_da_ana_sup_cross_pi BROW S G507商品月同期对比REPT S G508类别月同期对比ANAL S G509大类月同期对比ANAL S G510供应商月同期对比ANAL S G511品牌月同期对比ANAL S G512门店月同期对比ANAL S G513综合对比分析w_da_ana_dbfx BROW S G600店组报表MODU S G601店组销售汇总REPT S G602店组商品汇总REPT S G603店组大类汇总REPT S G604店组分部汇总REPT S G605店组类别汇总REPT S G606店组-商品库存分析REPT S G607店组-类别库存分析REPT S G608店组-大类库存分析REPT S G609店组--供应商采购汇总报表REPT S G610店组--供应商销售汇总报表REPT S G700其他报表MODU S G701消费群体分析w_rm_salecust_analyze BROW S G702库存积压报表w_rm_item_overstock BROW S G703时段销售对比分析w_rm_sale_analyze_sametime BROW SG704环比销售分析REPT S G705营业额增长率分析ANAL S G706毛利增长分析ANAL S G707会员忠诚度分析ANAL S G708会员群体分析ANAL S G709商品月销售环比REPT S G710类别月销售环比REPT S G711门店月销售环比REPT S G712主供应商月销售环比REPT S G713门店类别日销售对比w_da_branch_bigcls_sale BROW S G716经营总况日报表REPT S H000系统MODU S H100权限管理MODU S H101操作员管理w_sys_operator_new EDIT S H102操作员权限sa_w_operator_grant EDIT S H103操作员数据权限sa_w_oper_datagrant EDIT S H104收银员w_sys_cashier EDIT S H105菜单自定义w_sys_menu EDIT S H200系统管理MODU S H201系统设置w_sys_setup_wizard OTHR R H202系统数据管理w_sys_data_admin OTHR R H203数据库管理w_sys_database_admin OTHR R H204历史数据删除w_sys_delete_data OTHR R H205授权管理w_admin_process_management OTHR R H300其他管理MODU S H301自定义报表rpt_w_manager_document SHEE S H302机构登录设置w_branch_connect_setup OTHR R H303操作日志w_sys_operator_log BROW S H304公告sa_w_affiche_manage OTHR S H305我的邮件sa_w_mailmanage OTHR S H306报表单据模板w_sys_template_setup OTHR R H307部门岗位w_sys_dept EDIT S H308员工档案w_sys_employee EDIT S H400分部管理MODU S H401分部收货单w_pm_sheet_pi SHEE S H402分部退货单w_pm_sheet_ro SHEE S H403盘点录入单(托管)w_im_sheet_pd SHEE S H404数据传输(托管)w_client OTHR R H405传输日志(托管)w_cm_log BROW S H406要货单(托管)w_dm_sheet_yh SHEE S H407库存设置(托管)w_sys_setup_inventroy EDIT R H408预盘单(托管)w_im_sheet_pdrecord SHEE S H500系统说明MODU S H501单据模板w_sys_view_doc OTHR S I000短信MODU S I100相关设置MODU S I101短信设置w_sys_mess_setup OTHR RI102短信组管理w_ms_group_form EDIT S I103短信成员管理w_ms_cust_input EDIT S I200短信发送MODU S I201短信单发w_ms_send_single OTHR R I202短信群发w_ms_send_multi OTHR R I203会员短信群发w_ms_query_vipinfo OTHR R I204短信查询w_ms_query_send BROW S I300短信说明MODU S I301短信业务说明w_sys_view_doc OTHR S J000百货MODU S J100相关资料MODU S J101供应商档案w_bd_SUPCUST_form EDIT S J102商品档案w_bd_ITEM_FORM EDIT S J103柜台营业员w_rm_saleman EDIT R J104费用代码w_bd_fm_charge EDIT S J200价格管理MODU S J201调价单w_pc_SHEET_PX SHEE S J202促销特价单w_pc_sheet_ps SHEE S J203DM促销单w_pc_sheet_dm SHEE S J204优惠券促销单w_pc_sheet_py SHEE S J205量贩价促销单w_pc_sheet_pm SHEE S J206促销终止w_pc_specprice_cancelBROW S J207当前促销查询w_pc_query_specprice BROW S J208促销业绩查询w_pc_promotion_sale BROW S J209优惠券销售查询w_rm_yhq_sale_detail BROW S J210DM促销跟踪报表w_pc_promotion_sale_dm BROW S J300卖场相关MODU S J301卖场监控w_rm_pos_monitor BROW S J302流水查询w_rm_possale_query BROW S J303柜台销售查询w_rm_counter_query BROW S J304商品销售汇总报表REPT S J305时段销售分析w_rm_sale_analyze_byhour BROW S J400合同管理MODU S J401租赁合同建立w_bd_contract_zl EDIT S J402联营合同建立w_bd_contract_ly EDIT S J403合同暂停w_bd_contract_pause EDIT S J404合同解除w_bd_contract_free EDIT S J405合同作废w_bd_contract_del EDIT S J500结算管理MODU S J501租赁帐款w_fm_SHEET_zl SHEE S J502联营帐款w_fm_SHEET_ly SHEE S J504费用单w_fm_SHEET_FG SHEE S J505供应商对帐单w_fm_SHEET_dP SHEE S J506供应商付款单w_fm_SHEET_FK SHEE S J511供应商到期帐款报表REPT S J512应付帐款汇总报表REPT S J513供应商往来账REPT SJ514供应商费用明细报表REPT S J515供应商费用汇总报表REPT S J516联营商品销售表w_rm_ly_salepos BROW S K000微店MODU S K100档案信息MODU S K101微商店档案w_wx_item_info_weixin EDIT S K102微商店分店w_wx_branch_info EDIT S K200订单管理MODU S K201批发订单w_wm_sheet_ss SHEE S K202批发销售单w_wm_sheet_so SHEE S K203微商店订单报表w_wx_order_query BROW S。

糖尿病统计表

女女女男女女男女男男女女男男男男男男男男男男女女男
雄英村一社喜洋村五社岔河村二社喜洋村五社田坝村五社黄狮村三社岔河村二社落普村二社木落村三社沙坝村二社沙坝村一社双山村三社沙坝村五社底塔村三社底塔村四社雄英村三社木落村三社田坝村五社黄狮村四社底塔村四社双山村二社沙坝村二社底塔村二社底塔村四社田坝村二社
பைடு நூலகம்
女男女男女女女女男女女男男男男女男男男男男男男男男
黄狮村四社岔河村五社水潦村三社雄英村一社田坝村五社木落村三社雄英村一社岔河村四社海崖村二社水潦村三社喜洋村三社岔河村四社岔河村三社雄英村一社喜洋村二社落普村二社岔河村三社喜洋村五社喜洋村三社雄英村三社水潦村三社水潦村一社雄英村一社海崖村六社落普村二社
3月份糖尿病统计表
姓名余进荣李定兰杨德勇魏康秀张绍良李国秀李正清李腾禄何宣贵陈中华樊安平周宏恩丁世富刘银芬邓仕兰余龙莲胡清飞郑绍友梅大超郑祖芬余加剑李安龙张安贤性别家庭住址女女男女男女男男男男男男男女女女女男男女男男男水潦村五社水潦村四社海崖村四社水潦村二社水潦居委会水潦居委会水潦居委会水潦居委会水潦居委会水潦村三社海崖村六社落普村二社海崖村六社水潦村二社落普村二社喜洋村五社岔河村四社水潦村四社海崖村六社落普村二社岔河村五社水潦村三社黄狮村四社 2次 1次 1次 2次 1次 1次 2次 2次 1次 1次 2次 1次 13 6.5 6.5 13 6.5 6.5 13 13 6.5 6.5 13 6.5 随访人次数 2次 2次 1次 2次 1次 2次 1次 1次 1次 1次单价6.5元签字 13 13 6.5 13 13 13 6.5 6.5 6.5 6.5

TP6_数据的基本操作(二)

Handsபைடு நூலகம்On实训教程系列
选择表中的若干记录确定集合 1、格式列表达式 [not] in(列值1，列值2，……) 2、例：查询科目代码为‘004’，‘006’，’009‘的科目记录 select * from subjectInfo where subjectID in('004','006','009')
选择表中的若干记录
常用的查询条件
查询条件运算符 >,>=,<,<=,=,!=(<>),!>,! 比较 <；not+上述运算符 between 值1 and 值2 确定范围 not between 值1 and 值 2 确定集合 in ,not in 意义比较大小判断值是否在范围内判断是否是列表中的值
选择表中的若干记录
多重条件查询 1、格式
逻辑表达式 AND| OR [NOT] 逻辑表达式 2、例：查询学生表中宿舍号为‘504’，年龄在40以上的同学的学号和姓名 select stuID,stuName from studentInfo where stuDorm=‘504’ and stuAge>=40
Hands-On实训教程系列
选择表中的若干列三、为结果集内的列指定别名 1、格式 select 表达式 as 别名 from 表名 2、例：将查询的英文字段名用中文显示 select stuName as 姓名,stuTel as 电话 from studentInfo
Hands-On实训教程系列
选择表中的若干记录一、消除重复行查询 1、格式 select distinct 列名 from 表名 2、例：查询选修了课程的学生的学号 select distinct stuID from selectInfo 练习1：查询被选修的课程的课程号练习2：查询所有入住学生的宿舍号

BBSMax数据库

IsRead
bit
否
[IsReceive]为true的时候这个字段才有意义。表示消息是否已读，否则且值始终保持1
FromMessageID
int
否
[IsReceive]为true的时候这个字段才有意义。表示接收到的这条消息来自于哪条消息
[Content]
nvarchar(3000)
否
消息内容
KeywordVersion
BeginDate
datetime
否
公告开始日期
EndDate
datetime
否
公告结束日期
SortOrder
int
否
公告排列顺序
7、bx_AttachmentExchanges：附件购买记录表
列名
数据类型
允许空
备注
AttachmentID
int
否
主键、外键(bx_Attachments)附件ID
UserID
列名
数据类型
允许空
备注
LogID
int
否
主键
OperationType
tinyint
否
操作类型0未在任何版块被屏蔽1整站屏蔽2在指定版块屏蔽
OperationTime
datetime
否
操作发生时间
OperatorName
nvarchar(50)
否
操作人名
Cause
nvarchar(1000)
否
屏蔽原因
Thumb
nvarchar(200)
否
日志缩略图
Subject
nvarchar(200)
否
标题
[Content]

ITC数据分析2016版

1.打开 Origin 软件（MicroCal，LLC ITC200），点击“Read data”，在相应文件夹中找到 iTC 实验结果文件，导入软件，如下图所示；2.点击“Remove Bad Data”，光标变为方框，将光标移动至需要删除的点处，单击选中该点，再按“Enter”键即可消除b ad data，结果如下图所示；3.如希望利用点对点扣除背景，请转至步骤7；如希望用最后几个点进行背景扣除，请按照以下步骤操作；4.在工具栏“Window”中选择“Data1”，如上图所示。

观察N DH 的最后4-5 滴的结果，如果与之前对照实验的结果类似，且数值稳定，可以将这几滴对应的数值选中（如图中所示）；5.点击工具栏“Statistics”→“Descriptive statistics” →“Statistics on columns”，在弹出的页面中选择“Mean（Y）”对应的数值，copy 该数值；6. 在工具栏“Window”中选择“DeltaH”；在工具栏“Math”中选择“Simple math”，在弹出的对话框中“operator”填“-”号，“Y2”中 p aste 上述数值（Mean （Y ）），点击 O K 即完成背景扣除。

下转步骤12；7. 如希望利用点对点扣除背景，如使用旧版软件，请按照以下操作步骤进行；如使用新版软件，请转至步骤108.在工具栏“Window”中选择 “mRawITC”，点击“Read data”，在相应文件夹中找到对照实验的结果文件，导入软件，此时软件中只会显示第二次导入的数据；9.双击左上角数字1 的灰色方框，出现窗口“Layer1”；选中“data1_NDH”再点击符号“=>”将data1 的数据导入右侧区域（此时方框内共有data2_NDH 和data1_NDH 两组值），点击“OK”，此时“Data1_NDH”、“Data2_NDH”都会显示在窗口中；接步骤11.10.新版软件中，点击 “Read Data”，在相应的文件夹中分别选中两组数据，然后点击 “Add File(s)”；或者同时选中后，再点“Add File(s)”。