阿里云rds数据库mysql版cpu占用100%排查问题过程
背景某天去到公司，用户反馈说系统响应很慢，甚至有些功能基本用不了，严重影响工作效率。测试同事说阿里云RDS数据库的CPU占用了100%，我打开阿里云dms的监控页面，确实如此，接着开始排查问题。问题排查过程因为前段时间遇到过代码死循环查询数据库导致了CPU占用100%的问题，所以一开始就往这个方向排查。首先通过阿里云的dms控制台执行show processlist命令查询数据库正在执行的线程如下 发现大量状态为sending data的线程，通过查询资料，这个状态的意思是读取和过滤数据，如果一个表数据量很大且没有索引的话，就容易出现sending data状态，官方解释是，线程正在读取和处理 SELECT 的行记录，发送给客户端，由于在这个状态下的操作会执行大量的磁盘访问（读），因此它通常是查询生命周期最长的状态。但具体为什么会占用大量CPU，还有待学习了解。之前的死循环会出现在一些同步erp数据到业务系统的定时任务中，因为需要同步大量的数据而使用了循环。使用上面的sql语句（info字段）搜索代码，发现只有一个定时任务的方法使用了这个语句，因此接着登录服务器查询这个定时任务，但是没有找到相应的定时任务，后来了解到原来一直没有配置，但是同事在前一天手动执行过这个定时任务，通过如下监控信息 发现从前一天下午5点09分开始数据库的CPU就开始飙升到100%了。通过ps命令找不到相关的定时任务进程正在执行，但为什么那些语句一直存在呢？然后在运维同事的帮助下，使用lsof和ll /proc/pid命令以及上面show processlist结果的端口查询到发起那个语句请求的进程是php-fpm，工作目录是tp框架的public目录，印象中tp框架的php think命令运行的模式是cli，因此导致sending data状态有可能不是定时任务导致的。因为当时没有及时排查出原因，所以采取了同事的建议将服务器重启。 重启后数据库的CPU确实降下来了，但是过了一会又升上去了。确定了不是由于定时任务导致的，接着继续排查代码中调用这个定时任务方法的地方，后来确实发现还有一个接口调用了这个方法，通过查询nginx的access.log日志，发现当时一直有IP频繁地请求着这个接口，初步认定是由于这个接口调用了这个方法导致的问题。接着和同事一起去查看这个方法的代码，但是却没有发现这个方法的问题，逻辑上产生死循环的逻辑也没有被发现。在测试环境模拟复现这个问题，发现在死循环中获取一个数据量为三万的表的同一条数据时（查询条件有加索引并命中）并不会导致CPU飙升，但是没有索引或没有命中索引的情况下，CPU就会一直飙升。 从上面排查的过程中，没有发现死循环，考虑到有些单据数据行比较多，所以模拟了短时间内循环查询并修改大量不同单据的情景，在命中索引的情况下，CPU占用不高，但是没有命中索引的情况下，CPU占用升到百分之五十多。接着看了生产环境相关的表，数据量大概是十万行，而且用于查询的entry_id字段并没有设置索引，因此同步数据时，如果数据量较大，循环插入或者更新数据时会导致数据库CPU占用持续升高。通过下面的监控图 119.23.123.173 - - [21/Apr/2022:11:10:03 +0800] "OPTIONS /abc_admin/v2/sourceOrderPhoto/getODODetail?inquire_type=2&express_no=10111194500 HTTP/1.1" 200 5 "https://cadmin.hopo.com.cn/" "Mozilla/5.0 (Windows NT 10.0; WOW64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/77.0.3865.120 Safari/537.36 Core/1.77.103.400 QQBrowser/10.9.4624.400" 119.23.123.176 - - [21/Apr/2022:11:10:07 +0800] "GET /abc_admin/v2/sourceOrderPhoto/getODODetail?inquire_type=2&express_no=10111194249 HTTP/1.1" 499 0 "https://cadmin.hopo.com.cn/" "Mozilla/5.0 (Windows NT 10.0; WOW64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/77.0.3865.120 Safari/537.36 Core/1.77.103.400 QQBrowser/10.9.4624.400" 119.23.123.174 - - [21/Apr/2022:11:10:09 +0800] "OPTIONS /abc_admin/v2/sourceOrderPhoto/getODODetail?inquire_type=2&express_no=10111194045 HTTP/1.1" 200 5 "https://cadmin.hopo.com.cn/" "Mozilla/5.0 (Windows NT 10.0; WOW64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/77.0.3865.120 Safari/537.36 Core/1.77.103.400 QQBrowser/10.9.4624.400" 119.23.123.179 - - [21/Apr/2022:11:10:09 +0800] "GET /abc_admin/v2/sourceOrderPhoto/getODODetail?inquire_type=2&express_no=10111194045 HTTP/1.1" 201 1003 "https://cadmin.hopo.com.cn/" "Mozilla/5.0 (Windows NT 10.0; WOW64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/77.0.3865.120 Safari/537.36 Core/1.77.103.400 QQBrowser/10.9.4624.400" 119.23.123.174 - - [21/Apr/2022:11:10:14 +0800] "OPTIONS /abc_admin/v2/sourceOrderPhoto/getODODetail?inquire_type=2&express_no=10111194552 HTTP/1.1" 200 5 "https://cadmin.hopo.com.cn/" "Mozilla/5.0 (Windows NT 10.0; WOW64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/77.0.3865.120 Safari/537.36 Core/1.77.103.400 QQBrowser/10.9.4624.400" 119.23.123.167 - - [21/Apr/2022:11:10:14 +0800] "GET /abc_admin/v2/sourceOrderPhoto/getODODetail?inquire_type=2&express_no=10111194552 HTTP/1.1" 201 1892 "https://cadmin.hopo.com.cn/" "Mozilla/5.0 (Windows NT 10.0; WOW64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/77.0.3865.120 Safari/537.36 Core/1.77.103.400 QQBrowser/10.9.4624.400" 119.23.123.164 - - [21/Apr/2022:11:10:17 +0800] "OPTIONS /abc_admin/v2/sourceOrderPhoto/getODODetail?inquire_type=2&express_no=10111194613 HTTP/1.1" 200 5 "https://cadmin.hopo.com.cn/" "Mozilla/5.0 (Windows NT 10.0; WOW64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/77.0.3865.120 Safari/537.36 Core/1.77.103.400 QQBrowser/10.9.4624.400" 119.23.123.154 - - [21/Apr/2022:11:10:26 +0800] "OPTIONS /abc_admin/v2/sourceOrderPhoto/getODODetail?inquire_type=2&express_no=10111194548 HTTP/1.1" 200 5 "https://cadmin.hopo.com.cn/" "Mozilla/5.0 (Windows NT 10.0; WOW64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/77.0.3865.120 Safari/537.36 Core/1.77.103.400 QQBrowser/10.9.4624.400" 119.23.123.169 - - [21/Apr/2022:11:10:31 +0800] "OPTIONS /abc_admin/v2/sourceOrderPhoto/getODODetail?inquire_type=2&express_no=10111194229 HTTP/1.1" 200 5 "https://cadmin.hopo.com.cn/" "Mozilla/5.0 (Windows NT 10.0; WOW64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/77.0.3865.120 Safari/537.36 Core/1.77.103.400 QQBrowser/10.9.4624.400" 47.112.84.217 - - [21/Apr/2022:11:10:31 +0800] "GET /abc_admin/v2/sourceOrderPhoto/getODODetail?inquire_type=2&express_no=10111194249 HTTP/1.1" 499 0 "https://cadmin.hopo.com.cn/" "Mozilla/5.0 (Windows NT 10.0; WOW64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/77.0.3865.120 Safari/537.36 Core/1.77.103.400 QQBrowser/10.9.4624.400" 119.23.123.165 - - [21/Apr/2022:11:10:32 +0800] "GET /abc_admin/v2/sourceOrderPhoto/getODODetail?inquire_type=2&express_no=10111194264 HTTP/1.1" 499 0 "https://cadmin.hopo.com.cn/" "Mozilla/5.0 (Windows NT 10.0; WOW64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/77.0.3865.120 Safari/537.36 Core/1.77.103.400 QQBrowser/10.9.4624.400" 119.23.123.178 - - [21/Apr/2022:11:10:35 +0800] "OPTIONS /abc_admin/v2/sourceOrderPhoto/getODODetail?inquire_type=2&express_no=10111194592 HTTP/1.1" 200 5 "https://cadmin.hopo.com.cn/" "Mozilla/5.0 (Windows NT 10.0; WOW64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/77.0.3865.120 Safari/537.36 Core/1.77.103.400 QQBrowser/10.9.4624.400" 119.23.123.170 - - [21/Apr/2022:11:10:39 +0800] "GET /abc_admin/v2/sourceOrderPhoto/getODODetail?inquire_type=2&express_no=10111194500 HTTP/1.1" 499 0 "https://cadmin.hopo.com.cn/" "Mozilla/5.0 (Windows NT 10.0; WOW64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/77.0.3865.120 Safari/537.36 Core/1.77.103.400 QQBrowser/10.9.4624.400" 119.23.123.159 - - [21/Apr/2022:11:10:41 +0800] "OPTIONS /abc_admin/v2/sourceOrderPhoto/getODODetail?inquire_type=2&express_no=10111194580 HTTP/1.1" 200 5 "https://cadmin.hopo.com.cn/" "Mozilla/5.0 (Windows NT 10.0; WOW64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/77.0.3865.120 Safari/537.36 Core/1.77.103.400 QQBrowser/10.9.4624.400" 119.23.123.170 - - [21/Apr/2022:11:10:41 +0800] "GET /abc_admin/v2/sourceOrderPhoto/getODODetail?inquire_type=2&express_no=10111194580 HTTP/1.1" 201 1125 "https://cadmin.hopo.com.cn/" "Mozilla/5.0 (Windows NT 10.0; WOW64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/77.0.3865.120 Safari/537.36 Core/1.77.103.400 QQBrowser/10.9.4624.400" 119.23.123.154 - - [21/Apr/2022:11:10:46 +0800] "OPTIONS /abc_admin/v2/sourceOrderPhoto/getODODetail?inquire_type=2&express_no=10111194576 HTTP/1.1" 200 5 "https://cadmin.hopo.com.cn/" "Mozilla/5.0 (Windows NT 10.0; WOW64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/77.0.3865.120 Safari/537.36 Core/1.77.103.400 QQBrowser/10.9.4624.400" 119.23.123.170 - - [21/Apr/2022:11:10:46 +0800] "GET /abc_admin/v2/sourceOrderPhoto/getODODetail?inquire_type=2&express_no=10111194576 HTTP/1.1" 201 1296 "https://cadmin.hopo.com.cn/" "Mozilla/5.0 (Windows NT 10.0; WOW64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/77.0.3865.120 Safari/537.36 Core/1.77.103.400 QQBrowser/10.9.4624.400" 119.23.123.154 - - [21/Apr/2022:11:10:51 +0800] "OPTIONS /abc_admin/v2/sourceOrderPhoto/getODODetail?inquire_type=2&express_no=10111194536 HTTP/1.1" 200 5 "https://cadmin.hopo.com.cn/" "Mozilla/5.0 (Windows NT 10.0; WOW64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/77.0.3865.120 Safari/537.36 Core/1.77.103.400 QQBrowser/10.9.4624.400" 119.23.123.171 - - [21/Apr/2022:11:10:53 +0800] "GET /abc_admin/v2/sourceOrderPhoto/getODODetail?inquire_type=2&express_no=10111194613 HTTP/1.1" 499 0 "https://cadmin.hopo.com.cn/" "Mozilla/5.0 (Windows NT 10.0; WOW64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/77.0.3865.120 Safari/537.36 Core/1.77.103.400 QQBrowser/10.9.4624.400" 47.112.84.213 - - [21/Apr/2022:11:10:56 +0800] "GET /abc_admin/v2/sourceOrderPhoto/getODODetail?inquire_type=2&express_no=10111194264 HTTP/1.1" 499 0 "https://cadmin.hopo.com.cn/" "Mozilla/5.0 (Windows NT 10.0; WOW64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/77.0.3865.120 Safari/537.36 Core/1.77.103.400 QQBrowser/10.9.4624.400" 119.23.123.163 - - [21/Apr/2022:11:10:57 +0800] "OPTIONS /abc_admin/v2/sourceOrderPhoto/getODODetail?inquire_type=2&express_no=10111194524 HTTP/1.1" 200 5 "https://cadmin.hopo.com.cn/" "Mozilla/5.0 (Windows NT 10.0; WOW64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/77.0.3865.120 Safari/537.36 Core/1.77.103.400 QQBrowser/10.9.4624.400" 119.23.123.172 - - [21/Apr/2022:11:11:02 +0800] "GET /abc_admin/v2/sourceOrderPhoto/getODODetail?inquire_type=2&express_no=10111194548 HTTP/1.1" 499 0 "https://cadmin.hopo.com.cn/" "Mozilla/5.0 (Windows NT 10.0; WOW64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/77.0.3865.120 Safari/537.36 Core/1.77.103.400 QQBrowser/10.9.4624.400" 47.112.84.216 - - [21/Apr/2022:11:11:02 +0800] "GET /abc_admin/v2/sourceOrderPhoto/getODODetail?inquire_type=2&express_no=10111194500 HTTP/1.1" 499 0 "https://cadmin.hopo.com.cn/" "Mozilla/5.0 (Windows NT 10.0; WOW64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/77.0.3865.120 Safari/537.36 Core/1.77.103.400 QQBrowser/10.9.4624.400" 119.23.123.166 - - [21/Apr/2022:11:11:06 +0800] "OPTIONS /abc_admin/v2/sourceOrderPhoto/getODODetail?inquire_type=2&express_no=10111194508 HTTP/1.1" 200 5 "https://cadmin.hopo.com.cn/" "Mozilla/5.0 (Windows NT 10.0; WOW64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/77.0.3865.120 Safari/537.36 Core/1.77.103.400 QQBrowser/10.9.4624.400"结合同事在前一天手动执行了定时任务并且是全量获取数据以及nginx的access.log日志的情况，从前一天执行了定时任务开始一直到第二天11点08分的CPU都是占满的状态，然后重启了服务器，CPU降了下来，接着因为相关接口被频繁调用，所以又导致CPU重新占满。问题原因数据量大的表且用于查询的字段没有设置索引，导致查询效率低。执行定时任务时没有传入增量获取的参数，采用了全量获取数据的方式进行同步数据，数据量较大，一直占用着数据库资源。解决办法与预防措施需要给数据量较大的表频繁查询的字段添加索引同步大量数据时，采用增量的方式，如果是需要重新获取全量数据，则尽量在晚上执行，且要考虑同步的时长是否会影响白天系统的使用。优化同步数据的方法，尽量避免在循环中调用数据库，造成数据库资源占用过高，影响系统性能。
一、请求参数说明： 1.formid：业务对象表单Id，字符串类型（必录） 2.data：JSON格式数据（详情参考JSON格式数据）（必录） 2.1.NeedUpDateFields：需要更新的字段，数组类型，格式：[key1,key2,...] （非必录）注（更新单据体字段得加上单据体key） 2.2.NeedReturnFields：需返回结果的字段集合，数组类型，格式：[key,entitykey.key,...]（非必录） 注（返回单据体字段格式：entitykey.key） 2.3.IsDeleteEntry：是否删除已存在的分录，布尔类型，默认true（非必录） 2.4.SubSystemId：表单所在的子系统内码，字符串类型（非必录） 2.5.IsVerifyBaseDataField：是否验证所有的基础资料有效性，布尔类，默认false（非必录） 2.6.IsEntryBatchFill：是否批量填充分录，默认true（非必录） 2.7.ValidateFlag：是否验证标志，布尔类型，默认true（非必录） 2.8.NumberSearch：是否用编码搜索基础资料，布尔类型，默认true（非必录） 2.9.IsAutoAdjustField：是否自动调整JSON字段顺序，布尔类型，默认false（非必录） 2.10.InterationFlags：交互标志集合，字符串类型，分号分隔，格式："flag1;flag2;..."（非必录） 例如（允许负库存标识：STK_InvCheckResult） 2.11.Model：表单数据包，JSON类型（必录） 备注: 1.示例Model数据包中字段顺序不建议改变，否则可能会有相互影响，如果出现字段值被覆盖或丢失，则可以尝试把字段顺序向后调整一下。 2.示例Model数据包默认包含允许引入的字段，实际按需构建既可。 3.如需创建关联关系，可参考http://club.kingdee.com/forum.php?mod=viewthread&tid=1394265 。 二、返回结果： {"Result":{"ResponseStatus":{"ErrorCode":"","IsSuccess":"false","Errors":[{"FieldName":"","Message":"","DIndex":0}],"SuccessEntitys":[{"Id":"","Number":"","DIndex":0}],"SuccessMessages":[{"FieldName":"","Message":"","DIndex":0}],"MsgCode":""},"Id":"","Number":"","NeedReturnData":[{}]}} 三、代码示例： // 使用webapi引用组件Kingdee.BOS.WebApi.Client.dll K3CloudApiClient client = new K3CloudApiClient("https://hopo.ik3cloud.com/K3cloud/"); var loginResult = client.ValidateLogin("20170307142733","Administrator","888888",2052); var resultType = JObject.Parse(loginResult)["LoginResultType"].Value<int>(); //登录结果类型等于1，代表登录成功 if (resultType == 1) { client.Save("PUR_ReceiveBill","{"NeedUpDateFields":[],"NeedReturnFields":[],"IsDeleteEntry":"true","SubSystemId":"","IsVerifyBaseDataField":"false","IsEntryBatchFill":"true","ValidateFlag":"true","NumberSearch":"true","IsAutoAdjustField":"false","InterationFlags":"","Model":{"FID":0,"FBillTypeID":{"FNUMBER":""},"FBillNo":"","FDate":"1900-01-01","FStockOrgId":{"FNumber":""},"FReceiveDeptId":{"FNumber":""},"FStockGroupId":{"FNumber":""},"FReceiverId":{"FNumber":""},"FDemandOrgId":{"FNumber":""},"FCorrespondOrgId":{"FNumber":""},"FPurOrgId":{"FNumber":""},"FPurDeptId":{"FNumber":""},"FPurGroupId":{"FNumber":""},"FPurchaserId":{"FNumber":""},"FSupplierId":{"FNumber":""},"FNote":"","FSupplyId":{"FNumber":""},"FSupplyAddress":"","FSettleId":{"FNumber":""},"FChargeId":{"FNumber":""},"FOwnerTypeIdHead":"","FOwnerIdHead":{"FNumber":""},"FConfirmerId":{"FUserID":""},"FConfirmDate":"1900-01-01","FIsInsideBill":"false","FIsMobile":"false","FScanBox":"","FProviderContactId":{"FCONTACTNUMBER":""},"FIsChecked":"false","FIsChangeQty":"false","FIncoming":"false","FACCTYPE":"","F_WH_SH":"","F_WH_KZ":"false","F_WH_TLKZ":"false","F_WH_yfk":"false","F_WH_SFJE":0,"F_WH_HZSL":0,"F_wh_qrrq":"1900-01-01","F_wh_jyrq":"1900-01-01","F_WH_jyry1":"","F_WH_QRRY1":"","F_WH_LLRKD":"","F_wh_PDJK":"false","F_WH_YWLX":"","F_WH_SP":{"FNumber":""},"F_WH_XTBJ":"false","F_WH_XTDD":"false","FinanceEntity":{"FEntryId":0,"FSettleOrgId":{"FNumber":""},"FSettleModeId":{"FNumber":""},"FSettleCurrId":{"FNumber":""},"FPayConditionId":{"FNumber":""},"FIsIncludedTax":"false","FPricePoint":"","FPriceListId":{"FNumber":""},"FDiscountListId":{"FNumber":""},"FLocalCurrId":{"FNumber":""},"FExchangeTypeId":{"FNumber":""},"FExchangeRate":0,"FISPRICEEXCLUDETAX":"false"},"FDetailEntity":[{"FEntryID":0,"FMaterialId":{"FNumber":""},"FMaterialDesc":"","FAuxPropId":{"FAUXPROPID__FF100001":"","FAUXPROPID__FF100002":{"FNumber":""}},"FUnitId":{"FNumber":""},"FActReceiveQty":0,"FPreDeliveryDate":"1900-01-01","FSUPDELQTY":0,"FPriceUnitId":{"FNumber":""},"FStockID":{"FNumber":""},"FStockLocId":{"FSTOCKLOCID__FF100006":{"FNumber":""},"FSTOCKLOCID__FF100007":{"FNumber":""},"FSTOCKLOCID__FF100008":{"FNumber":""},"FSTOCKLOCID__FF100009":{"FNumber":""},"FSTOCKLOCID__FF100010":{"FNumber":""},"FSTOCKLOCID__FF100011":{"FNumber":""},"FSTOCKLOCID__FF100014":{"FNumber":""},"FSTOCKLOCID__FF100015":{"FNumber":""},"FSTOCKLOCID__FF100016":{"FNumber":""},"FSTOCKLOCID__FF100017":{"FNumber":""}},"FStockStatusId":{"FNumber":""},"FLot":{"FNumber":""},"FRejectReason":"","FProduceDate":"1900-01-01","FDemandDeptId":{"FNumber":""},"FDemanderId":{},"FGiveAway":"false","FChargeProjectID":{"FNumber":""},"FCtrlStockInPercent":"false","FMtoNo":"","FExtAuxUnitId":{"FNumber":""},"FExtAuxUnitQty":0,"FProjectNo":"","FCheckJoinBaseQty":0,"FReceiveBaseQty":0,"FRefuseBaseQty":0,"FSampleDamageBaseQty":0,"FCheckJoinQty":0,"FReceiveQty":0,"FRefuseQty":0,"FSampleDamageQty":0,"FCheckInComing":"false","FDeliverySite":"","FCardJoinQty":0,"FCardQty":0,"FCardBaseQty":0,"FCardJoinBaseQty":0,"FCheckBaseQty":0,"FCheckQty":0,"FTransferBaseQty":0,"FIsReceiveUpdateStock":"false","FTransferQty":0,"FBomId":{"FNumber":""},"FSupplierLot":"","FExpiryDate":"1900-01-01","FAuxUnitQty":0,"FDescription":"","FStockInMaxQty":0,"FStockInMinQty":0,"FEntryTaxRate":0,"FTaxCombination":{"FNumber":""},"FDiscountRate":0,"FPrice":0,"FTaxPrice":0,"FProcScrapBaseQty":0,"FProcScrapQty":0,"FMtrlScrapBaseQty":0,"FMtrlScrapQty":0,"FCsnReceiveBaseQty":0,"FCsnReceiveQty":0,"FRefuseJoinBaseQty":0,"FRefuseJoinQty":0,"FCsnReceiveJoinBaseQty":0,"FCsnReceiveJoinQty":0,"FPriceBaseQty":0,"FSetPriceUnitID":{"FNumber":""},"FStockUnitID":{"FNumber":""},"FStockQty":0,"FStockBaseQty":0,"FActlandQty":0,"FConfirmDeliQty":0,"FConfirmDeliDate":"1900-01-01","FConfirmInfo":"","FXTRecQty":0,"FTest":"","FExplain":"","F_UN_HH":"","F_UN_TH":0,"F_UN_DDDJ":0,"F_UN_DDJS":0,"F_UN_S":0,"F_UN_DDSL":0,"F_WH_RKS":0,"FPriceDiscount":0,"F_WH_QSH":"false","F_WH_BL":"false","FACCRATE":0,"F_CKSL":0,"F_WH_zs":0,"FRejectsDiscountAmount":0,"FJoinRejectsDiscountAmount":0,"F_WH_jhrq":"1900-01-01","F_CGDDDJLX":"","F_WH_PZYC":"","F_wh_blxx":{"FNumber":""},"F_WH_DJYQty":0,"F_wh_DQRQty":0,"F_wh_yjjhrq":"1900-01-01","F_wh_JHDZ":"","F_wh_shgs":0,"F_wh_cjsl":0,"F_wh_blQty":0,"F_WH_CLFA":{"FNumber":""},"F_wh_thlx":{"FNumber":""},"F_wh_dqr":"false","F_SQ_SP":"","F_WH_SLZT":"","FTaxDetailSubEntity":[{"FDetailID":0,"FTaxRate":0}],"FSerialSubEntity":[{"FDetailID":0,"FSerialNo":"","FSerialNote":""}]}],"FReceiveTrace":[{"FEntryID":0,"FLogComId":{"FCODE":""},"FCarryBillNo":"","FTraceDetail":[{"FDetailID":0}]}]}}"); } 四、JSON格式数据： { "NeedUpDateFields": [], "NeedReturnFields": [], "IsDeleteEntry": "true", "SubSystemId": "", "IsVerifyBaseDataField": "false", "IsEntryBatchFill": "true", "ValidateFlag": "true", "NumberSearch": "true", "IsAutoAdjustField": "false", "InterationFlags": "", "Model": { "FID": 0, "FBillTypeID": { "FNUMBER": "" }, "FBillNo": "", "FDate": "1900-01-01", "FStockOrgId": { "FNumber": "" }, "FReceiveDeptId": { "FNumber": "" }, "FStockGroupId": { "FNumber": "" }, "FReceiverId": { "FNumber": "" }, "FDemandOrgId": { "FNumber": "" }, "FCorrespondOrgId": { "FNumber": "" }, "FPurOrgId": { "FNumber": "" }, "FPurDeptId": { "FNumber": "" }, "FPurGroupId": { "FNumber": "" }, "FPurchaserId": { "FNumber": "" }, "FSupplierId": { "FNumber": "" }, "FNote": "", "FSupplyId": { "FNumber": "" }, "FSupplyAddress": "", "FSettleId": { "FNumber": "" }, "FChargeId": { "FNumber": "" }, "FOwnerTypeIdHead": "", "FOwnerIdHead": { "FNumber": "" }, "FConfirmerId": { "FUserID": "" }, "FConfirmDate": "1900-01-01", "FIsInsideBill": "false", "FIsMobile": "false", "FScanBox": "", "FProviderContactId": { "FCONTACTNUMBER": "" }, "FIsChecked": "false", "FIsChangeQty": "false", "FIncoming": "false", "FACCTYPE": "", "F_WH_SH": "", "F_WH_KZ": "false", "F_WH_TLKZ": "false", "F_WH_yfk": "false", "F_WH_SFJE": 0, "F_WH_HZSL": 0, "F_wh_qrrq": "1900-01-01", "F_wh_jyrq": "1900-01-01", "F_WH_jyry1": "", "F_WH_QRRY1": "", "F_WH_LLRKD": "", "F_wh_PDJK": "false", "F_WH_YWLX": "", "F_WH_SP": { "FNumber": "" }, "F_WH_XTBJ": "false", "F_WH_XTDD": "false", "FinanceEntity": { "FEntryId": 0, "FSettleOrgId": { "FNumber": "" }, "FSettleModeId": { "FNumber": "" }, "FSettleCurrId": { "FNumber": "" }, "FPayConditionId": { "FNumber": "" }, "FIsIncludedTax": "false", "FPricePoint": "", "FPriceListId": { "FNumber": "" }, "FDiscountListId": { "FNumber": "" }, "FLocalCurrId": { "FNumber": "" }, "FExchangeTypeId": { "FNumber": "" }, "FExchangeRate": 0, "FISPRICEEXCLUDETAX": "false" }, "FDetailEntity": [ { "FEntryID": 0, "FMaterialId": { "FNumber": "" }, "FMaterialDesc": "", "FAuxPropId": { "FAUXPROPID__FF100001": "", "FAUXPROPID__FF100002": { "FNumber": "" } }, "FUnitId": { "FNumber": "" }, "FActReceiveQty": 0, "FPreDeliveryDate": "1900-01-01", "FSUPDELQTY": 0, "FPriceUnitId": { "FNumber": "" }, "FStockID": { "FNumber": "" }, "FStockLocId": { "FSTOCKLOCID__FF100006": { "FNumber": "" }, "FSTOCKLOCID__FF100007": { "FNumber": "" }, "FSTOCKLOCID__FF100008": { "FNumber": "" }, "FSTOCKLOCID__FF100009": { "FNumber": "" }, "FSTOCKLOCID__FF100010": { "FNumber": "" }, "FSTOCKLOCID__FF100011": { "FNumber": "" }, "FSTOCKLOCID__FF100014": { "FNumber": "" }, "FSTOCKLOCID__FF100015": { "FNumber": "" }, "FSTOCKLOCID__FF100016": { "FNumber": "" }, "FSTOCKLOCID__FF100017": { "FNumber": "" } }, "FStockStatusId": { "FNumber": "" }, "FLot": { "FNumber": "" }, "FRejectReason": "", "FProduceDate": "1900-01-01", "FDemandDeptId": { "FNumber": "" }, "FDemanderId": {}, "FGiveAway": "false", "FChargeProjectID": { "FNumber": "" }, "FCtrlStockInPercent": "false", "FMtoNo": "", "FExtAuxUnitId": { "FNumber": "" }, "FExtAuxUnitQty": 0, "FProjectNo": "", "FCheckJoinBaseQty": 0, "FReceiveBaseQty": 0, "FRefuseBaseQty": 0, "FSampleDamageBaseQty": 0, "FCheckJoinQty": 0, "FReceiveQty": 0, "FRefuseQty": 0, "FSampleDamageQty": 0, "FCheckInComing": "false", "FDeliverySite": "", "FCardJoinQty": 0, "FCardQty": 0, "FCardBaseQty": 0, "FCardJoinBaseQty": 0, "FCheckBaseQty": 0, "FCheckQty": 0, "FTransferBaseQty": 0, "FIsReceiveUpdateStock": "false", "FTransferQty": 0, "FBomId": { "FNumber": "" }, "FSupplierLot": "", "FExpiryDate": "1900-01-01", "FAuxUnitQty": 0, "FDescription": "", "FStockInMaxQty": 0, "FStockInMinQty": 0, "FEntryTaxRate": 0, "FTaxCombination": { "FNumber": "" }, "FDiscountRate": 0, "FPrice": 0, "FTaxPrice": 0, "FProcScrapBaseQty": 0, "FProcScrapQty": 0, "FMtrlScrapBaseQty": 0, "FMtrlScrapQty": 0, "FCsnReceiveBaseQty": 0, "FCsnReceiveQty": 0, "FRefuseJoinBaseQty": 0, "FRefuseJoinQty": 0, "FCsnReceiveJoinBaseQty": 0, "FCsnReceiveJoinQty": 0, "FPriceBaseQty": 0, "FSetPriceUnitID": { "FNumber": "" }, "FStockUnitID": { "FNumber": "" }, "FStockQty": 0, "FStockBaseQty": 0, "FActlandQty": 0, "FConfirmDeliQty": 0, "FConfirmDeliDate": "1900-01-01", "FConfirmInfo": "", "FXTRecQty": 0, "FTest": "", "FExplain": "", "F_UN_HH": "", "F_UN_TH": 0, "F_UN_DDDJ": 0, "F_UN_DDJS": 0, "F_UN_S": 0, "F_UN_DDSL": 0, "F_WH_RKS": 0, "FPriceDiscount": 0, "F_WH_QSH": "false", "F_WH_BL": "false", "FACCRATE": 0, "F_CKSL": 0, "F_WH_zs": 0, "FRejectsDiscountAmount": 0, "FJoinRejectsDiscountAmount": 0, "F_WH_jhrq": "1900-01-01", "F_CGDDDJLX": "", "F_WH_PZYC": "", "F_wh_blxx": { "FNumber": "" }, "F_WH_DJYQty": 0, "F_wh_DQRQty": 0, "F_wh_yjjhrq": "1900-01-01", "F_wh_JHDZ": "", "F_wh_shgs": 0, "F_wh_cjsl": 0, "F_wh_blQty": 0, "F_WH_CLFA": { "FNumber": "" }, "F_wh_thlx": { "FNumber": "" }, "F_wh_dqr": "false", "F_SQ_SP": "", "F_WH_SLZT": "", "FTaxDetailSubEntity": [ { "FDetailID": 0, "FTaxRate": 0 } ], "FSerialSubEntity": [ { "FDetailID": 0, "FSerialNo": "", "FSerialNote": "" } ] } ], "FReceiveTrace": [ { "FEntryID": 0, "FLogComId": { "FCODE": "" }, "FCarryBillNo": "", "FTraceDetail": [ { "FDetailID": 0 } ] } ] } } 五、字段说明： 基本信息：FBillHead 实体主键：FID 单据编号：FBillNo 单据状态：FDocumentStatus 收料组织：FStockOrgId (必填项) 收料日期：FDate (必填项) 单据类型：FBillTypeID (必填项) 货主类型：FOwnerTypeIdHead (必填项) 货主：FOwnerIdHead (必填项) 供应商：FSupplierId (必填项) 送货单号：FSendBillNo 提货单号：FLadBillNo 承运商：FCarrierId 收料部门：FReceiveDeptId 库存组：FStockGroupId 收料员：FReceiverId 采购组织：FPurOrgId (必填项) 采购部门：FPurDeptId 采购组：FPurGroupId 采购员：FPurchaserId 备注：FNote 创建人：FCreatorId 创建日期：FCreateDate 最后修改人：FModifierId 最后修改日期：FModifyDate 审核日期：FApproveDate 审核人：FApproverId 作废人：FCancellerId 作废日期：FCancelDate 作废状态：FCancelStatus 供货方联系人(旧)：FSupplyContact 结算方：FSettleId 供货方：FSupplyId 收款方：FChargeId 整单关闭状态：FCloseStatus 业务类型：FBusinessType 需要检验：FNeedCheck 需求组织：FDemandOrgId 供货方地址：FSupplyAddress 对应组织：FCorrespondOrgId 确认状态：FConfirmStatus 确认人：FConfirmerId 确认日期(停用)：FConfirmDate 序列号上传：FScanBox 外部单据：FIsInsideBill 供货方联系人：FProviderContactId 来自移动：FIsMobile 变更数量操作：FIsChangeQty 验收方式：FACCTYPE 供应商编码：F_GYSBM 已检验：FIsChecked 已来料：FIncoming 事项：F_WH_SH 自动下推控制按钮：F_WH_KZ 退料控制：F_WH_TLKZ 预付款：F_WH_yfk 创建人部门：F_CJRBM 实付金额：F_WH_SFJE 收料数量汇总：F_WH_HZSL 确认日期：F_wh_qrrq 检验日期：F_wh_jyrq 检验人员：F_WH_jyry1 确认人员：F_WH_QRRY1 入库人员：F_WH_LLRKD 协同历史数据判断：F_wh_PDJK 是否同步协同：F_wh_xtpt 采购订单业务类型：F_WH_YWLX 产品首批选型：F_WH_SP 协同标记：F_WH_XTBJ HOPO协同单：F_WH_XTDD 财务信息：FinanceEntity 实体主键：FEntryId 付款组织：FPayOrgId 结算组织：FSettleOrgId (必填项) 结算方式：FSettleModeId 付款条件：FPayConditionId 税额：FBillTaxAmount 金额：FBillAmount 价税合计：FBillAllAmount 价目表：FPriceListId 折扣表：FDiscountListId 定价时点：FPricePoint (必填项) 结算币别：FSettleCurrId (必填项) 汇率类型：FExchangeTypeId 汇率：FExchangeRate 本位币：FLocalCurrId 税额(本位币)：FBillTaxAmount_LC 价税合计(本位币)：FBillAllAmount_LC 金额(本位币)：FBillAmount_LC 含税：FIsIncludedTax 价外税：FISPRICEEXCLUDETAX 明细信息：FDetailEntity 实体主键：FEntryID 物料编码：FMaterialId (必填项) 物料名称：FMaterialName 规格型号：FMateriaModel 辅助属性：FAuxPropId 长度：FF100001 颜色：FF100002 物料类别：FMateriaType 实到数量：FActlandQty 交货数量：FActReceiveQty 仓库：FStockID 库存状态：FStockStatusId BOM版本：FBomId 供应商批号：FSupplierLot 生产日期：FProduceDate 有效期至：FExpiryDate 库存辅单位数量：FAuxUnitQty 需求部门：FDemandDeptId 控制入库数量：FCtrlStockInPercent 入库上限：FStockInMaxQty 入库下限：FStockInMinQty 合格入库关联数量：FInStockJoinQty 入库数量：FInStockQty 免费：FIsFree 计价数量：FPriceUnitQty 折扣率%：FDiscountRate 净价：FTaxNetPrice 金额：FAmount 税率%：FEntryTaxRate 单价：FPrice 税额：FEntryTaxAmount 价税合计：FAllAmount 需求跟踪号：FReqTraceNo 订单单号：FOrderBillNo 含税单价：FTaxPrice 价格下限：FMinPrice 价格上限：FMaxPrice 备注：FDescription 金额(本位币)：FAmount_LC 税额(本位币)：FTaxAmount_LC 价税合计(本位币)：FAllAmount_LC 需求人：FDemanderId 价格系数：FPriceCoefficient 系统定价：FSysPrice 拒收数量：FRejectQty 拒收原因：FRejectReason 库存更新标志：FStockFlag 货主类型：FOwnerTypeId 货主：FOwnerId 保管者类型：FKeeperTypeId 保管者：FKeeperId 采购基本数量：FBaseUnitQty 退料关联数量(基本单位)：FReturnJoinBaseQty 退料数量(基本单位)：FReturnBaseQty 合格入库关联数量(基本单位)：FInStockJoinBaseQty 入库数量(基本单位)：FInStockBaseQty 退料数量：FReturnQty 退料关联数量：FReturnJoinQty 基本单位：FBaseUnitId 收料单位：FUnitId (必填项) 计价单位：FPriceUnitId (必填项) 库存辅单位：FAuxUnitId 合同单号：FContactNo 交货地址：FDeliveryAddress 基本单位关联数量(组)：FJoinBaseQty 仓位：FStockLocId 新成品仓位：FF100006 新配件仓位：FF100007 配件仓位：FF100008 不良配件仓位：FF100009 新包材仓位：FF100010 不良成品仓位：FF100011 滞留配件仓位：FF100014 滞留成品仓位：FF100015 返修仓位：FF100016 行政仓位：FF100017 源单内码：FSrcId 源单分录内码：FSrcEntryId 保质期：FExpPeriod 保质期单位：FExpUnit 分录关闭状态：FMRPCloseStatus 源单类型：FSrcFormId 源单单号：FSrcBillNo 在架寿命期：FShelfLife 批号：FLot 交货地点(2.0删除)：FDeliverySite 税组合：FTaxCombination 折扣额：FDiscount 物料说明：FMaterialDesc 关联应付数量(计价基本)：FBaseAPJoinQty 入库上限(基本单位数量)：FBaseStockInMaxQty 入库下限(基本单位数量)：FBaseStockInMinQty 业务流程：FBFLowId 实收数量：FMustQty 计划跟踪号：FMtoNo 项目编号：FProjectNo 是否赠品：FGiveAway 费用项目：FChargeProjectID 合格入库关联数量（辅单位）：FINSTOCKJOINSECQTY 退货关联数量（辅单位）：FRETURNJOINSECQTY 紧急放行：FEmergencyRelease 检验关联数量（基本单位）：FCheckJoinBaseQty 合格数量（基本单位）：FReceiveBaseQty 判退数量（基本单位）：FRefuseBaseQty 样本破坏数量（基本单位）：FSampleDamageBaseQty 检验关联数量：FCheckJoinQty 合格数量：FReceiveQty 判退数量：FRefuseQty 样本破坏数量：FSampleDamageQty 来料检验：FCheckInComing 卡片关联数量：FCardJoinQty 卡片数量：FCardQty 卡片数量(基本单位)：FCardBaseQty 卡片关联数量(基本单位)：FCardJoinBaseQty 检验数量（基本单位）：FCheckBaseQty 检验数量：FCheckQty 累计调拨数量(基本单位)：FTransferBaseQty 累计调拨数量：FTransferQty 收料更新库存(废弃)：FIsReceiveUpdateStock 辅单位：FExtAuxUnitId 实收数量(辅单位)：FExtAuxUnitQty 工废数量(基本单位)：FProcScrapBaseQty 工废数量：FProcScrapQty 料废数量(基本单位)：FMtrlScrapBaseQty 料废数量：FMtrlScrapQty 工废关联数量(基本单位)：FProcScrapJoinBaseQty 工废关联数量：FProcScrapJoinQty 料废关联数量(基本单位)：FMtrlScrapJoinBaseQty 料废关联数量：FMtrlScrapJoinQty 预计到货日期：FPreDeliveryDate 让步接收数量(基本单位)：FCsnReceiveBaseQty 让步接收数量：FCsnReceiveQty 不合格关联数量(基本单位)：FRefuseJoinBaseQty 不合格关联数量：FRefuseJoinQty 让步接收关联数量(基本单位)：FCsnReceiveJoinBaseQty 让步接收关联数量：FCsnReceiveJoinQty 计价基本数量：FPriceBaseQty 定价单位：FSetPriceUnitID 库存单位：FStockUnitID (必填项) 库存单位数量：FStockQty 库存基本数量：FStockBaseQty 采购基本分子：FPurBaseNum 库存基本分母：FStockBaseDen 携带的主业务单位：FSRCBIZUNITID 合格入库库存关联数量(基本单位)：FSTOCKJOINBASEQTY 退料库存关联数量(基本单位)：FRETURNSTKJNBASTQTY 关联应付数量(库存基本)：FStockBaseAPJoinQty 供应商交货数量：FSUPDELQTY 执行人：FEXECUTEID 执行日期：FEXECUTEDATE 行状态：FENTRYSTATUS 分录价目表：FPriceListEntry 采购订单分录内码：FPOORDERENTRYID 确认交货数量：FConfirmDeliQty 确认到货日期：FConfirmDeliDate 确认意见：FConfirmInfo 序列号单位：FSNUNITID 序列号单位数量：FSNQTY 是否同步第三方(GY)：FISSYNTOTHIRD 产品类型：FRowType 父项产品：FPARENTMATID 单价折扣：FPriceDiscount 价目表分录id：FPriLstEntryId 样本破坏入库关联数量（基本单位）：FSDJNBASEQTY 供应商承担样本破坏基本数量：FJYSUPSAMDANQTY 验收比例%：FACCRATE 订单数量：FPOQTY 不良品折让金额：FRejectsDiscountAmount 入库关联不良品折让金额：FJoinRejectsDiscountAmount 尾差处理标识：FTailDiffFlag 收料数量(校验)：FXTRecQty 质检说明(不启用)：FTest 质检说明：FExplain 采购订单行号：F_UN_HH 退货数：F_UN_TH 订单含税单价：F_UN_DDDJ 订单价税合计：F_UN_DDJS 订单税率：F_UN_S 订单数量：F_UN_DDSL 入库数：F_WH_RKS 少货：F_WH_QSH 是否合格：F_WH_BL 费用物料已出库数量：F_CKSL 物流部物料分类：F_WH_FL 支数：F_WH_zs 是否门窗系统物料：F_WH_MC 年度备货日期：F_WH_jhrq 采购订单单据类型：F_CGDDDJLX 品质异常描述：F_WH_PZYC 不良类型：F_wh_blxx 待检验数量：F_WH_DJYQty 待确认数量：F_wh_DQRQty 预计交货日期：F_wh_yjjhrq 交货地址：F_wh_JHDZ 损耗工时：F_wh_shgs 抽检数量：F_wh_cjsl 不合格数量：F_wh_blQty 处理方案：F_WH_CLFA 退货类型：F_wh_thlx VMI物料：F_WH_vmiwl 待确认：F_wh_dqr 产品首批选型：F_SQ_SP 收料状态：F_WH_SLZT 是否VMI毛坯：F_SQ_VMIMP 税务明细：FTaxDetailSubEntity 实体主键：FDetailID 税率名称：FTaxRateId 税率%：FTaxRate 税额：FTaxAmount 计入成本比例%：FCostPercent 计入成本金额：FCostAmount 增值税：FVAT 卖方代扣代缴：FSellerWithholding 买方代扣代缴：FBuyerWithholding 辅助属性|序列号：FSerialSubEntity 实体主键：FDetailID 序列号：FSerialNo 序列号：FSerialId 备注：FSerialNote 物料：FSRMATERIALID 数量(辅序)：FSRQTY 基本单位数量(辅序)：FSRBASEQTY 入库关联数量(辅序)：FSRJOINQTY 入库关联基本数量(辅序)：FSRJOINBASEQTY 检验结果：FSRINSPECTRESULT 退料关联基本数量(辅序)：FSRMRBJOINBASEQTY 退料关联数量(辅序)：FSRMRBJOINQTY 使用决策：FUSEPOLICY 辅助属性(辅序)：FSRAUXPROPID 长度：FF100001 颜色：FF100002 供应商批号(辅序)：FSRSUPPLYLOT 生产日期(辅序)：FSRPRODUCEDATE 有效期至(辅序)：FSREXPIRYDATE 批号(辅序)：FSRLOT 物流跟踪：FReceiveTrace 实体主键：FEntryID 物流公司：FLogComId 物流单号：FCarryBillNo 物流详情：FTraceDetail 实体主键：FDetailID 物流时间：FTdTime 物流详情：FTdContent 关联关系表：FDetailEntity_Link 实体主键：FLinkId 业务流程图：FDetailEntity_Link_FFlowId 推进路线：FDetailEntity_Link_FFlowLineId 转换规则：FDetailEntity_Link_FRuleId 源单表内码：FDetailEntity_Link_FSTableId 源单表：FDetailEntity_Link_FSTableName 源单内码：FDetailEntity_Link_FSBillId 源单分录内码：FDetailEntity_Link_FSId 原始携带量：FDetailEntity_Link_FBaseUnitQtyOld 修改携带量：FDetailEntity_Link_FBaseUnitQty 原始携带量：FDetailEntity_Link_FStockBaseQtyOld 修改携带量：FDetailEntity_Link_FStockBaseQty 迁移图：FDetailEntity_Link_FLnkTrackerId 上游状态：FDetailEntity_Link_FLnkSState 数量FLnk：FDetailEntity_Link_FLnkAmount
阿里云RDS数据库CPU占用100%问题分析与解决方法
背景用户反馈使用BOASS、CRM、SRM系统时很卡，通过排查发现数据库CPU占用100%。原因分析通过DMS控制台，执行SHOW PROCESSLIST;命令，查看正在查询的进程，发现协同项目两条记录一直处于sending data 状态，再根据这两条语句，定位到服务器有两个定时任务一直在执行，已经超过五六个小时或者更长。然后查询代码逻辑，发现其中一个定时任务获取数据量太大以及运算的次数也很多，一直在抓取数据库数据，另外一个定时任务出现了死循环也在不断的查询数据库数据，导致CPU负载过高。解决办法1.优化算法，数据获取与计算采用增量的方式。 2.避免编写产生死循环的代码。
一、请求参数说明： 1.formid：业务对象表单Id，字符串类型（必录） 2.data：JSON格式数据（详情参考JSON格式数据）（必录） 2.1.NeedUpDateFields：需要更新的字段，数组类型，格式：[key1,key2,...] （非必录）注（更新单据体字段得加上单据体key） 2.2.NeedReturnFields：需返回结果的字段集合，数组类型，格式：[key,entitykey.key,...]（非必录） 注（返回单据体字段格式：entitykey.key） 2.3.IsDeleteEntry：是否删除已存在的分录，布尔类型，默认true（非必录） 2.4.SubSystemId：表单所在的子系统内码，字符串类型（非必录） 2.5.IsVerifyBaseDataField：是否验证所有的基础资料有效性，布尔类，默认false（非必录） 2.6.IsEntryBatchFill：是否批量填充分录，默认true（非必录） 2.7.ValidateFlag：是否验证标志，布尔类型，默认true（非必录） 2.8.NumberSearch：是否用编码搜索基础资料，布尔类型，默认true（非必录） 2.9.IsAutoAdjustField：是否自动调整JSON字段顺序，布尔类型，默认false（非必录） 2.10.InterationFlags：交互标志集合，字符串类型，分号分隔，格式："flag1;flag2;..."（非必录） 例如（允许负库存标识：STK_InvCheckResult） 2.11.Model：表单数据包，JSON类型（必录） 备注: 1.示例Model数据包中字段顺序不建议改变，否则可能会有相互影响，如果出现字段值被覆盖或丢失，则可以尝试把字段顺序向后调整一下。 2.示例Model数据包默认包含允许引入的字段，实际按需构建既可。 3.如需创建关联关系，可参考http://club.kingdee.com/forum.php?mod=viewthread&tid=1394265 。 二、返回结果： {"Result":{"ResponseStatus":{"ErrorCode":"","IsSuccess":"false","Errors":[{"FieldName":"","Message":"","DIndex":0}],"SuccessEntitys":[{"Id":"","Number":"","DIndex":0}],"SuccessMessages":[{"FieldName":"","Message":"","DIndex":0}],"MsgCode":""},"Id":"","Number":"","NeedReturnData":[{}]}} 三、代码示例： // 使用webapi引用组件Kingdee.BOS.WebApi.Client.dll K3CloudApiClient client = new K3CloudApiClient("https://hopo.ik3cloud.com/K3cloud/"); var loginResult = client.ValidateLogin("20170307142733","Administrator","888888",2052); var resultType = JObject.Parse(loginResult)["LoginResultType"].Value<int>(); //登录结果类型等于1，代表登录成功 if (resultType == 1) { client.Save("SAL_OUTSTOCK","{"NeedUpDateFields":[],"NeedReturnFields":[],"IsDeleteEntry":"true","SubSystemId":"","IsVerifyBaseDataField":"false","IsEntryBatchFill":"true","ValidateFlag":"true","NumberSearch":"true","IsAutoAdjustField":"false","InterationFlags":"","Model":{"FID":0,"FBillTypeID":{"FNUMBER":""},"FBillNo":"","FDate":"1900-01-01","FSaleOrgId":{"FNumber":""},"FCustomerID":{"FNumber":""},"FSaleDeptID":{"FNumber":""},"FHeadLocationId":{"FNumber":""},"FCorrespondOrgId":{"FNumber":""},"FCarrierID":{"FNumber":""},"FCarriageNO":"","FSalesGroupID":{"FNumber":""},"FSalesManID":{"FNumber":""},"FStockOrgId":{"FNumber":""},"FDeliveryDeptID":{"FNumber":""},"FLinkMan":"","FLinkPhone":"","FStockerGroupID":{"FNumber":""},"FStockerID":{"FNumber":""},"FNote":"","FReceiverID":{"FNumber":""},"FReceiveAddress":"","FSettleID":{"FNumber":""},"FReceiverContactID":{"FNAME":""},"FPayerID":{"FNumber":""},"FOwnerTypeIdHead":"","FOwnerIdHead":{"FNumber":""},"FScanBox":"","FCDateOffsetUnit":"","FCDateOffsetValue":0,"FPlanRecAddress":"","FIsTotalServiceOrCost":"false","F_kd_Assistant":{"FNumber":""},"F_kd_Assistant1":{"FNumber":""},"F_kd_bl":{"FSTAFFNUMBER":""},"FCreatorId1":{"FUserID":""},"F_kd_je":0,"F_UN_PrintTimes":0,"FSHOPNUMBER":"","F_UN_WEHUGDZ":{"FNUMBER":""},"FGYDATE":"1900-01-01","FSALECHANNEL":"","F_UN_HORDERNO":"","FLogisticsNos":"","F_UN_WHG":0,"FiHkh":{"FNumber":""},"F_WH_CK":{"FNumber":""},"F_WH_YPLX":{"FNumber":""},"F_wh_PD":0,"F_WH_FGSQYKH":{"FNumber":""},"F_WH_GSPP":{"FNumber":""},"F_wh_drop_shipping":"","F_wh_sdz":"false","F_TDMBLX":{"FNumber":""},"F_XTKH":"false","F_BCYFL":"false","F_CHR_DSPTDH":"","F_CHR_DSSHR":"","F_WH_btoc":{"FNUMBER":""},"F_WH_FKJSGX":"false","F_UN_WEHUGKH":{"FNUMBER":""},"F_SQ_XMMC":"","SubHeadEntity":{"FEntryId":0,"FSettleCurrID":{"FNumber":""},"FThirdBillNo":"","FThirdBillId":"","FThirdSrcType":"","FSettleOrgID":{"FNumber":""},"FSettleTypeID":{"FNumber":""},"FReceiptConditionID":{"FNumber":""},"FPriceListId":{"FNumber":""},"FDiscountListId":{"FNumber":""},"FIsIncludedTax":"false","FLocalCurrID":{"FNumber":""},"FExchangeTypeID":{"FNumber":""},"FExchangeRate":0,"FIsPriceExcludeTax":"false","FBuyerNick":"","FReceiverAddress":"","FReceiverName":"","FReceiverMobile":"","FReceiverCountry":"","FReceiverState":"","FReceiverCity":"","FReceiverDistrict":"","FReceiverPhone":"","FVIPCODE":""},"FEntity":[{"FENTRYID":0,"FRowType":"","FCustMatID":{"FNumber":""},"FMaterialID":{"FNumber":""},"FAuxPropId":{"FAUXPROPID__FF100001":"","FAUXPROPID__FF100002":{"FNumber":""}},"FUnitID":{"FNumber":""},"F_kd_xh":"","F_kd_Decimal":0,"F_kd_Decimal1":0,"FInventoryQty":0,"FRealQty":0,"FParentMatId":{"FNUMBER":""},"FPrice":0,"FTaxPrice":0,"FIsFree":"false","FBomID":{"FNumber":""},"FProduceDate":"1900-01-01","FOwnerTypeID":"","FOwnerID":{"FNumber":""},"FLot":{"FNumber":""},"FExpiryDate":"1900-01-01","FTaxCombination":{"FNumber":""},"FEntryTaxRate":0,"FAuxUnitQty":0,"FExtAuxUnitId":{"FNumber":""},"FExtAuxUnitQty":0,"FStockID":{"FNumber":""},"FStockLocID":{"FSTOCKLOCID__FF100006":{"FNumber":""},"FSTOCKLOCID__FF100007":{"FNumber":""},"FSTOCKLOCID__FF100008":{"FNumber":""},"FSTOCKLOCID__FF100009":{"FNumber":""},"FSTOCKLOCID__FF100010":{"FNumber":""},"FSTOCKLOCID__FF100011":{"FNumber":""},"FSTOCKLOCID__FF100014":{"FNumber":""},"FSTOCKLOCID__FF100015":{"FNumber":""},"FSTOCKLOCID__FF100016":{"FNumber":""},"FSTOCKLOCID__FF100017":{"FNumber":""}},"FStockStatusID":{"FNumber":""},"FQualifyType":"","FMtoNo":"","FEntrynote":"","FDiscountRate":0,"FActQty":0,"FSalUnitID":{"FNumber":""},"FSALUNITQTY":0,"FSALBASEQTY":0,"FPRICEBASEQTY":0,"FPriceDiscount":0,"FProjectNo":"","FOUTCONTROL":"false","FRepairQty":0,"FIsCreateProDoc":"","FEOwnerSupplierId":{"FNUMBER":""},"FIsOverLegalOrg":"false","FESettleCustomerId":{"FNUMBER":""},"FPriceListEntry":{"FNUMBER":""},"FARNOTJOINQTY":0,"FQmEntryID":0,"FSOEntryId":0,"F_kd_yhhd":"","FConvertEntryID":0,"FDisPriceQty":0,"F_kd_js":0,"F_kd_hj":0,"FBeforeDisPriceQty":0,"F_kd_yhdj":0,"F_kd_Qty":0,"F_UN_WHPrice":0,"F_UN_WHAmount":0,"FSignQty":0,"F_UN_OPrice":0,"F_UN_ORDERNO":"","FCheckDelivery":"false","FThirdEntryId":"","FETHIRDBILLID":"","FETHIRDBILLNO":"","FSettleBySon":"false","F_UN_XSBH":"","FBOMEntryId":0,"F_WH_xiufu":"false","F_KD":"","F_GD":"","F_MJ":"","F_wh_JSKC":"false","F_WH_FW":"false","F_wh_xs":0,"F_WH_YS":0,"F_wh_fwczy":"","F_wh_ctbm":"","F_wh_ctnm":0,"FPOID":0,"F_SQ_ETD":"1900-01-01","FPOENTRYID":0,"F_SQ_KHCG":"","FTaxDetailSubEntity":[{"FDetailID":0,"FTaxRate":0}],"FSerialSubEntity":[{"FDetailID":0,"FSerialNo":"","FSerialNote":""}]}],"FOutStockTrace":[{"FEntryID":0,"FLogComId":{"FCODE":""},"FPhoneNumber":"","FDelTime":"1900-01-01","FCarryBillNo":"","FTraceStatus":"","FOutStockTraceDetail":[{"FDetailID":0,"FTraceTime":"","FTraceDetail":""}]}]}}"); } 四、JSON格式数据： { "NeedUpDateFields": [], "NeedReturnFields": [], "IsDeleteEntry": "true", "SubSystemId": "", "IsVerifyBaseDataField": "false", "IsEntryBatchFill": "true", "ValidateFlag": "true", "NumberSearch": "true", "IsAutoAdjustField": "false", "InterationFlags": "", "Model": { "FID": 0, "FBillTypeID": { "FNUMBER": "" }, "FBillNo": "", "FDate": "1900-01-01", "FSaleOrgId": { "FNumber": "" }, "FCustomerID": { "FNumber": "" }, "FSaleDeptID": { "FNumber": "" }, "FHeadLocationId": { "FNumber": "" }, "FCorrespondOrgId": { "FNumber": "" }, "FCarrierID": { "FNumber": "" }, "FCarriageNO": "", "FSalesGroupID": { "FNumber": "" }, "FSalesManID": { "FNumber": "" }, "FStockOrgId": { "FNumber": "" }, "FDeliveryDeptID": { "FNumber": "" }, "FLinkMan": "", "FLinkPhone": "", "FStockerGroupID": { "FNumber": "" }, "FStockerID": { "FNumber": "" }, "FNote": "", "FReceiverID": { "FNumber": "" }, "FReceiveAddress": "", "FSettleID": { "FNumber": "" }, "FReceiverContactID": { "FNAME": "" }, "FPayerID": { "FNumber": "" }, "FOwnerTypeIdHead": "", "FOwnerIdHead": { "FNumber": "" }, "FScanBox": "", "FCDateOffsetUnit": "", "FCDateOffsetValue": 0, "FPlanRecAddress": "", "FIsTotalServiceOrCost": "false", "F_kd_Assistant": { "FNumber": "" }, "F_kd_Assistant1": { "FNumber": "" }, "F_kd_bl": { "FSTAFFNUMBER": "" }, "FCreatorId1": { "FUserID": "" }, "F_kd_je": 0, "F_UN_PrintTimes": 0, "FSHOPNUMBER": "", "F_UN_WEHUGDZ": { "FNUMBER": "" }, "FGYDATE": "1900-01-01", "FSALECHANNEL": "", "F_UN_HORDERNO": "", "FLogisticsNos": "", "F_UN_WHG": 0, "FiHkh": { "FNumber": "" }, "F_WH_CK": { "FNumber": "" }, "F_WH_YPLX": { "FNumber": "" }, "F_wh_PD": 0, "F_WH_FGSQYKH": { "FNumber": "" }, "F_WH_GSPP": { "FNumber": "" }, "F_wh_drop_shipping": "", "F_wh_sdz": "false", "F_TDMBLX": { "FNumber": "" }, "F_XTKH": "false", "F_BCYFL": "false", "F_CHR_DSPTDH": "", "F_CHR_DSSHR": "", "F_WH_btoc": { "FNUMBER": "" }, "F_WH_FKJSGX": "false", "F_UN_WEHUGKH": { "FNUMBER": "" }, "F_SQ_XMMC": "", "SubHeadEntity": { "FEntryId": 0, "FSettleCurrID": { "FNumber": "" }, "FThirdBillNo": "", "FThirdBillId": "", "FThirdSrcType": "", "FSettleOrgID": { "FNumber": "" }, "FSettleTypeID": { "FNumber": "" }, "FReceiptConditionID": { "FNumber": "" }, "FPriceListId": { "FNumber": "" }, "FDiscountListId": { "FNumber": "" }, "FIsIncludedTax": "false", "FLocalCurrID": { "FNumber": "" }, "FExchangeTypeID": { "FNumber": "" }, "FExchangeRate": 0, "FIsPriceExcludeTax": "false", "FBuyerNick": "", "FReceiverAddress": "", "FReceiverName": "", "FReceiverMobile": "", "FReceiverCountry": "", "FReceiverState": "", "FReceiverCity": "", "FReceiverDistrict": "", "FReceiverPhone": "", "FVIPCODE": "" }, "FEntity": [ { "FENTRYID": 0, "FRowType": "", "FCustMatID": { "FNumber": "" }, "FMaterialID": { "FNumber": "" }, "FAuxPropId": { "FAUXPROPID__FF100001": "", "FAUXPROPID__FF100002": { "FNumber": "" } }, "FUnitID": { "FNumber": "" }, "F_kd_xh": "", "F_kd_Decimal": 0, "F_kd_Decimal1": 0, "FInventoryQty": 0, "FRealQty": 0, "FParentMatId": { "FNUMBER": "" }, "FPrice": 0, "FTaxPrice": 0, "FIsFree": "false", "FBomID": { "FNumber": "" }, "FProduceDate": "1900-01-01", "FOwnerTypeID": "", "FOwnerID": { "FNumber": "" }, "FLot": { "FNumber": "" }, "FExpiryDate": "1900-01-01", "FTaxCombination": { "FNumber": "" }, "FEntryTaxRate": 0, "FAuxUnitQty": 0, "FExtAuxUnitId": { "FNumber": "" }, "FExtAuxUnitQty": 0, "FStockID": { "FNumber": "" }, "FStockLocID": { "FSTOCKLOCID__FF100006": { "FNumber": "" }, "FSTOCKLOCID__FF100007": { "FNumber": "" }, "FSTOCKLOCID__FF100008": { "FNumber": "" }, "FSTOCKLOCID__FF100009": { "FNumber": "" }, "FSTOCKLOCID__FF100010": { "FNumber": "" }, "FSTOCKLOCID__FF100011": { "FNumber": "" }, "FSTOCKLOCID__FF100014": { "FNumber": "" }, "FSTOCKLOCID__FF100015": { "FNumber": "" }, "FSTOCKLOCID__FF100016": { "FNumber": "" }, "FSTOCKLOCID__FF100017": { "FNumber": "" } }, "FStockStatusID": { "FNumber": "" }, "FQualifyType": "", "FMtoNo": "", "FEntrynote": "", "FDiscountRate": 0, "FActQty": 0, "FSalUnitID": { "FNumber": "" }, "FSALUNITQTY": 0, "FSALBASEQTY": 0, "FPRICEBASEQTY": 0, "FPriceDiscount": 0, "FProjectNo": "", "FOUTCONTROL": "false", "FRepairQty": 0, "FIsCreateProDoc": "", "FEOwnerSupplierId": { "FNUMBER": "" }, "FIsOverLegalOrg": "false", "FESettleCustomerId": { "FNUMBER": "" }, "FPriceListEntry": { "FNUMBER": "" }, "FARNOTJOINQTY": 0, "FQmEntryID": 0, "FSOEntryId": 0, "F_kd_yhhd": "", "FConvertEntryID": 0, "FDisPriceQty": 0, "F_kd_js": 0, "F_kd_hj": 0, "FBeforeDisPriceQty": 0, "F_kd_yhdj": 0, "F_kd_Qty": 0, "F_UN_WHPrice": 0, "F_UN_WHAmount": 0, "FSignQty": 0, "F_UN_OPrice": 0, "F_UN_ORDERNO": "", "FCheckDelivery": "false", "FThirdEntryId": "", "FETHIRDBILLID": "", "FETHIRDBILLNO": "", "FSettleBySon": "false", "F_UN_XSBH": "", "FBOMEntryId": 0, "F_WH_xiufu": "false", "F_KD": "", "F_GD": "", "F_MJ": "", "F_wh_JSKC": "false", "F_WH_FW": "false", "F_wh_xs": 0, "F_WH_YS": 0, "F_wh_fwczy": "", "F_wh_ctbm": "", "F_wh_ctnm": 0, "FPOID": 0, "F_SQ_ETD": "1900-01-01", "FPOENTRYID": 0, "F_SQ_KHCG": "", "FTaxDetailSubEntity": [ { "FDetailID": 0, "FTaxRate": 0 } ], "FSerialSubEntity": [ { "FDetailID": 0, "FSerialNo": "", "FSerialNote": "" } ] } ], "FOutStockTrace": [ { "FEntryID": 0, "FLogComId": { "FCODE": "" }, "FPhoneNumber": "", "FDelTime": "1900-01-01", "FCarryBillNo": "", "FTraceStatus": "", "FOutStockTraceDetail": [ { "FDetailID": 0, "FTraceTime": "", "FTraceDetail": "" } ] } ] } } 五、字段说明： 基本信息：FBillHead 实体主键：FID 单据编号：FBillNo 单据状态：FDocumentStatus 销售组织：FSaleOrgId (必填项) 日期：FDate (必填项) 发货组织：FStockOrgId (必填项) 客户：FCustomerID (必填项) 发货部门：FDeliveryDeptID 销售部门：FSaleDeptID 库存组：FStockerGroupID 仓管员：FStockerID 销售组：FSalesGroupID 销售员：FSalesManID 承运商：FCarrierID 运输单号：FCarriageNO 收货方：FReceiverID 结算方：FSettleID 付款方：FPayerID 创建日期：FCreateDate 最后修改人：FModifierId 最后修改日期：FModifyDate 创建人：FCreatorId 审核人：FApproverID 审核日期：FApproveDate 作废状态：FCancelStatus 作废人：FCancellerID 作废日期：FCancelDate 单据类型：FBillTypeID (必填项) 货主类型：FOwnerTypeIdHead 货主：FOwnerIdHead 业务类型：FBussinessType 收货方地址：FReceiveAddress 交货地点：FHeadLocationId 信用检查结果：FCreditCheckResult 跨组织业务类型：FTransferBizType 对应组织：FCorrespondOrgId 收货方联系人：FReceiverContactID 组织间结算跨法人标识：FIsInterLegalPerson 零售单日结生成：FGenFromPOS_CMK 联系电话：FLinkPhone 收货人姓名：FLinkMan 销售门店：FBranchId 序列号上传：FScanBox 创建日期偏移单位：FCDateOffsetUnit 创建日期偏移量：FCDateOffsetValue 交货明细执行地址(后台用)：FPlanRecAddress 整单服务或费用：FIsTotalServiceOrCost 摘要：FNote 拆单新单标识：FDisassemblyFlag 网店编码：FSHOPNUMBER 管易发货日期：FGYDATE 销售渠道：FSALECHANNEL 物流单号：FLogisticsNos 物流：F_kd_Assistant 运费：F_kd_Assistant1 备料：F_kd_bl 客户分组：F_kd_BaseProperty 详细地址：F_kd_xxdz 创建人：FCreatorId1 客户代码：F_kd_BaseProperty1 联系人：F_kd_LXR 联系电话：F_kd_lxdh 移动电话1：F_UN_yddh1 打印次数：F_UN_PrintTimes 子公司地址：F_UN_WEHUGDZ 客户类别：F_UN_BaseProperty 订单编号：F_UN_HORDERNO 发票类型：F_UN_FPLX 销售内勤：FXSNQ 整单金额：F_kd_je 序号：F_UN_XH 子公司金额合计：F_UN_WHG 同一家客户代码：F_UN_KHDM3 iHandle客户：FiHkh 出口：F_WH_CK 样品类型：F_WH_YPLX 判断字段：F_wh_PD 分公司区域客户：F_WH_FGSQYKH 公司品牌：F_WH_GSPP 代发客户简称：F_wh_drop_shipping 双地址：F_wh_sdz 套打模板类型：F_TDMBLX 系统客户：F_XTKH 不参与返利：F_BCYFL 电商平台单号：F_CHR_DSPTDH 电商收货人：F_CHR_DSSHR btoc客户：F_WH_btoc 跟进人：F_WH_GJR 付款解锁勾选框：F_WH_FKJSGX 子公司客户：F_UN_WEHUGKH 主体客户：F_SQ_ZTKH1 子公司详细地址：F_SQ_ZGSDZ 联系电话：F_SQ_LXDH 子客户联系人：F_SQ_LXR 项目名称：F_SQ_XMMC 财务信息：SubHeadEntity 实体主键：FEntryId 结算组织：FSettleOrgID (必填项) 本位币：FLocalCurrID 汇率类型：FExchangeTypeID 汇率：FExchangeRate 结算币别：FSettleCurrID (必填项) 结算方式：FSettleTypeID 总成本(暂未使用)：FBillCostAmount 总成本(本位币)(暂未使用)：FBillCostAmount_LC 收款条件：FReceiptConditionID 金额（本位币）：FBillAmount_LC 价税合计（本位币）：FBillAllAmount_LC 税额（本位币）：FBillTaxAmount_LC 价目表：FPriceListId 税额：FBillTaxAmount 价税合计：FBillAllAmount 金额：FBillAmount 是否含税：FIsIncludedTax 跨组织结算生成：FISGENFORIOS 结算组织客户：FSETTLECustomerID 货主供应商：FOwnerSupplierID 折扣表：FDiscountListId 工作流信用超标天数：FCreChkDays 工作流信用检查状态：FCreChkStatus 工作流信用超标金额：FCreChkAmount 审批流信用压批月结检查：FCrePreBatAndMonStatus 信用压批超标：FCrePreBatchOver 信用月结超标：FCreMonControlOver 价外税：FIsPriceExcludeTax 第三方单据编号：FThirdBillNo 第三方单据平台单号：FThirdBillId 第三方系统来源：FThirdSrcType 工作流信用逾期超标额度：FCreChkOverAmount 会员名称：FBuyerNick 收货人：FReceiverName 收货人手机：FReceiverMobile 收货人国家：FReceiverCountry 收货人省份：FReceiverState 收货人城市：FReceiverCity 收货人地区：FReceiverDistrict 收货人地址：FReceiverAddress 收货人电话：FReceiverPhone 应收单业务日期：FReceivaDate 会员编码：FVIPCODE 明细信息：FEntity 实体主键：FENTRYID 客户物料编码：FCustMatID 客户物料名称：FCustMatName 物料编码：FMaterialID 物料名称：FMaterialName 规格型号：FMateriaModel 物料类别：FMateriaType 库存单位：FUnitID (必填项) 应发数量：FMustQty 实发数量：FRealQty 仓库：FStockID 库存状态：FStockStatusID 货主类型：FOwnerTypeID (必填项) 货主：FOwnerID (必填项) 保管者类型：FKeeperTypeID 保管者：FKeeperID 备注：FEntrynote BOM版本：FBomID 库存基本数量：FBaseUnitQty 库存辅单位：FAuxUnitID 库存辅单位数量：FAuxUnitQty 成本价（本位币）：FCostPrice 总成本：FEntryCostAmount 总成本(本位币)：FCostAmount_LC 关联退货数量：FReturnQty 累计退货通知数量：FSumRetNoticeQty 累计退货数量：FSumRetStockQty 累计开票数量(作废)：FInvoicedQty 累计应收数量（销售）：FSumInvoicedQty 累计开票金额(作废)：FSumInvoicedAMT 累计收款金额：FSumReceivedAMT 关联退货数量(基本单位)：FBaseReturnQty 关联开票数量(基本单位)(作废)：FBaseInvoicedQty 库存更新标识：FStockFlag 订单单号：FSoorDerno 辅助属性：FAuxPropId 长度：FF100001 颜色：FF100002 累计退货通知数量(销售基本)：FBaseSumRetNoticeQty 源单类型：FSrcType 累计退货数量(基本单位)：FBaseSumRetstockQty 仓位：FStockLocID 新成品仓位：FF100006 新配件仓位：FF100007 配件仓位：FF100008 不良配件仓位：FF100009 新包材仓位：FF100010 不良成品仓位：FF100011 滞留配件仓位：FF100014 滞留成品仓位：FF100015 返修仓位：FF100016 行政仓位：FF100017 生产日期：FProduceDate 有效期至：FExpiryDate 勾稽数量：FJoinedQty 未勾稽数量：FUNJOINQTY 勾稽金额：FJoinedAmount 未勾稽金额：FUnJoinAmount 完全勾稽：FFullyJoined 行勾稽状态：FJoinStatus 批号：FLot 保质期单位：FExpiryPeriodUnit 保质期：FExpiryPeriod 是否赠品：FIsFree 累计开票数量(计价基本)(作废)：FBaseSumInvoicedQty 基本单位应发数量：FBaseMustQty 基本单位：FBaseUnitID 到货确认：FArrivalStatus 到货确认人：FArrivalConfirmor 检验日期：FValidateDate 检验确认：FValidateStatus 检验确认人：FValidateConfirmor 计价单位：FPriceUnitId 计价数量：FPriceUnitQty 单价：FPrice 含税单价：FTaxPrice 税组合：FTaxCombination 税率%：FEntryTaxRate 价格系数：FPriceCoefficient 系统定价：FSysPrice 最低限价：FLimitDownPrice 折前金额：FBefDisAmt 折前价税合计：FBefDisAllAmt 折扣率%：FDiscountRate 折扣额：FDiscount 金额：FAmount 金额（本位币）：FAmount_LC 税额：FEntryTaxAmount 税额（本位币）：FTaxAmount_LC 价税合计：FAllAmount 价税合计（本位币）：FAllAmount_LC 净价：FTaxNetPrice 关联应收数量（计价基本）：FBaseARJoinQty 到货日期：FArrivalDate 业务流程：FBFLowId 累计应收数量（销售基本）：FBASEARQTY 关联应收金额：FARJOINAMOUNT 累计应收金额：FARAMOUNT 服务上下文：FServiceContext 销售成本价：FSalCostPrice 源单编号：FSrcBillNo 实收数量：FActQty 关联入库数量(基本单位)：FBaseJoinInStockQty 关联入库数量：FJoinInStockQty 序列号单位：FSNUnitID 序列号单位数量：FSNQty 计划跟踪号：FMtoNo 项目编号：FProjectNo 拒收数量：FRefuseQty 补货数量：FRepairQty 是否补货：FIsRepair 捡货部门：FPickDeptId 关联入库数量（辅单位）：FSECJOININSTOCKQTY 关联退货数量（辅单位）：FSECRETURNQTY 消耗汇总：FIsConsumeSum 关联应收数量：FARJoinQty 控制出库数量：FOUTCONTROL 辅单位：FExtAuxUnitId 实发数量(辅单位)：FExtAuxUnitQty 零售条形码：FBarcode 门店供货价：FProPrice 供货金额：FProAmount 是否零售促销：FRetailSaleProm 当前库存：FInventoryQty 销售单位：FSalUnitID 销售数量：FSALUNITQTY 销售基本数量：FSALBASEQTY 计价基本数量：FPRICEBASEQTY 质量类型：FQualifyType 销售基本分子：FSalBaseNum 库存基本分母：FStockBaseDen 关联退货数量（库存基本）：FStockBaseReturnQty 累计退货数量（库存基本）：FStockBaseSumRetStockQty 关联应收数量（库存基本）：FStockBaseARJoinQty 携带的主业务单位：FSRCBIZUNITID 是否生成产品档案：FIsCreateProDoc 明细货主供应商：FEOwnerSupplierId 组织间结算跨法人标识：FIsOverLegalOrg 明细结算组织客户：FESettleCustomerId 关联应收数量（销售基本）：FSalBaseARJoinQty 关联入库数量（采购基本）：FPURBASEJOININSTOCKQTY 行价目表：FPriceListEntry 未关联应收数量（计价单位）：FARNOTJOINQTY 库存请检单EntryID：FQmEntryID 库存状态转换单ENTRYID：FConvertEntryID B2C订单明细Id：FB2CORDERDETAILID 销售订单EntryId：FSOEntryId 预留锁库EntryId：FReserveEntryId 拆单数量（计价）：FDisPriceQty 拆单前原计价数量：FBeforeDisPriceQty 产品类型：FRowType 父项产品：FParentMatId 行标识：FRowId 父行标识：FParentRowId 签收数量：FSignQty 管易订单单号：FThirdEntryId 发货检验：FCheckDelivery 第三方单据ID：FETHIRDBILLID 第三方单据编号：FETHIRDBILLNO 管易是否到账：FGYFINSTATUS 管易到账时间：FGYFINDate 单价折扣：FPriceDiscount 尾差处理标识：FTailDiffFlag 冲销数量(计价基本)：FWRITEOFFPRICEBASEQTY 冲销数量(销售基本)：FWRITEOFFSALEBASEQTY 冲销数量(库存基本)：FWRITEOFFSTOCKBASEQTY 冲销金额：FWRITEOFFAMOUNT 按子项结算：FSettleBySon BOM分录内码：FBOMEntryId 优惠活动：F_kd_yhhd 包装箱内数量：F_kd_bzxnsl 包装盒内数量：F_kd_bzhnsl 毛重KG：F_kd_mz 箱号：F_kd_xh 合计（旧）：F_kd_hj 件数（旧）：F_kd_js 件数：F_kd_Decimal 合计：F_kd_Decimal1 优惠单价：F_kd_yhdj 库存数量：F_kd_Qty 子公司单价：F_UN_WHPrice 子公司金额：F_UN_WHAmount 原单价：F_UN_OPrice 订单编号：F_UN_ORDERNO 存货类别：F_UN_CHLB 产品分类：F_CPFL 物料属性：F_wlsx 销售订单编号：F_UN_XSBH 销售基本数量修复：F_WH_xiufu 好博编码（合生）：F_WH_JWLBM 宽度（mm）：F_KD 高度（mm）：F_GD 面积(㎡)：F_MJ 获取即时库存：F_wh_JSKC 统计探索家销售额：F_TJTSJXSE 防伪：F_WH_FW 箱数：F_wh_xs 余数：F_WH_YS 防伪操作员：F_wh_fwczy 产品归属：F_CPGS 成套编码：F_wh_ctbm 成套内码：F_wh_ctnm 交货日期：F_SQ_ETD 采购订单ID：FPOID 采购订单分录ID：FPOENTRYID 产品定位：F_WH_CPDW 客户采购单：F_SQ_KHCG 税务明细：FTaxDetailSubEntity 实体主键：FDetailID 税率名称：FTaxRateId 税率%：FTaxRate 税额：FTaxAmount 计入成本比例%：FCostPercent 计入成本金额：FCostAmount 增值税：FVAT 卖方代扣代缴：FSellerWithholding 买方代扣代缴：FBuyerWithholding 序列号子单据体：FSerialSubEntity 实体主键：FDetailID 序列号：FSerialNo 序列号：FSerialId 备注：FSerialNote SN：FSN IMEI1：FIMEI1 IMEI2：FIMEI2 MEID：FMEID 下推退货通知标识：FPushReturnNotice 物流跟踪明细：FOutStockTrace 实体主键：FEntryID 物流公司：FLogComId 物流单号：FCarryBillNo (必填项) 物流状态：FTraceStatus 发货时间：FDelTime 寄件人手机号码：FPhoneNumber 物流详细信息：FOutStockTraceDetail 实体主键：FDetailID 时间：FTraceTime 物流详情：FTraceDetail 关联关系表：FEntity_Link 实体主键：FLinkId 业务流程图：FEntity_Link_FFlowId 推进路线：FEntity_Link_FFlowLineId 转换规则：FEntity_Link_FRuleId 源单表内码：FEntity_Link_FSTableId 源单表：FEntity_Link_FSTableName 源单内码：FEntity_Link_FSBillId 源单分录内码：FEntity_Link_FSId 原始携带量：FEntity_Link_FBaseUnitQtyOld 修改携带量：FEntity_Link_FBaseUnitQty 原始携带量：FEntity_Link_FSALBASEQTYOld 修改携带量：FEntity_Link_FSALBASEQTY 原始携带量：FEntity_Link_FAuxUnitQtyOld 修改携带量：FEntity_Link_FAuxUnitQty 迁移图：FEntity_Link_FLnkTrackerId 上游状态：FEntity_Link_FLnkSState 数量FLnk：FEntity_Link_FLnkAmount 迁移图：FEntity_Link_FLnk1TrackerId 上游状态：FEntity_Link_FLnk1SState 数量FLnk1：FEntity_Link_FLnk1Amount
阿里云服务器centos系统低版本硬盘扩容不生效解决办法
阿里云服务器在线扩容不生效，系统版本是centos6.10，后面通过阿里云硬盘扩容文档解决。