搜索到
104
篇与
basil
的结果
-
阿里云RDS数据库CPU占用100%问题分析与解决方法 背景用户反馈使用BOASS、CRM、SRM系统时很卡，通过排查发现数据库CPU占用100%。原因分析通过DMS控制台，执行SHOW PROCESSLIST;命令，查看正在查询的进程，发现协同项目两条记录一直处于sending data 状态，再根据这两条语句，定位到服务器有两个定时任务一直在执行，已经超过五六个小时或者更长。然后查询代码逻辑，发现其中一个定时任务获取数据量太大以及运算的次数也很多，一直在抓取数据库数据，另外一个定时任务出现了死循环也在不断的查询数据库数据，导致CPU负载过高。解决办法1.优化算法，数据获取与计算采用增量的方式。 2.避免编写产生死循环的代码。 -
ERP销售出库单 一、请求参数说明： 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
-
-
-
PHP的CRUL模块报错：PHP Problem with the SSL CA cert (path? access rights?) 背景 阿里云ECS服务器硬盘空间不够，进行了在线扩容，重启服务器也没有生效，后来向阿里云提了工单，解决办法是根据扩容文档进行操作，因为服务器内核比较低，所以使用了低内核版本文档，根据文档安装dracut-modules-growroot工具，但是发现操作系统版本是centos6.8，yum的源官方已经不维护了，安装不了，再继续切换到阿里云自己维护的源，然后执行了yum update命令后安装了dracut-modules-growroot工具。第二天早上发现系统部分业务使用PHP的CRUL模块调ERP的接口调不通，排查的时候发现，使用PHP的Cli模式运行（thinkphp框架的命令行think）可以调通，但是使用NGINX+PHP-FPM运行的模式的接口报：PHP Problem with the SSL CA cert (path? access rights?) 原因分析 查找关于PHP Problem with the SSL CA cert (path? access rights?) 报错的问题，发现可能是ca-certificates扩展导致的问题。查看yum的log日志发现Dec 28 19:42:24 Updated: ca-certificates-2020.2.41-65.1.el6_10.noarch前一晚执行的yum update命令将ca-certificates这个扩展进行了更新。那为什么cli模式可以正常运行而PHP-FPM不能正常运行呢？因为PHP-FPM是常驻内存的,所以需要重启PHP-FPM才能重新加载新版本的ca-certificates。解决办法 重新安装ca-certificates扩展，重启PHP-FPM
-
-
PHP高精度计算问题例子 代码 //直接运算 echo "\n"; var_dump(intval(0.58 * 100)); var_dump(0.7 * 100 == 7); var_dump(floor(0.58 * 100)); var_dump((8945.63 * 100) % 1000000); echo "\n"; // 使用bcmath高精度函数计算 var_dump(intval(bcmul(0.58, 100))); var_dump(bccomp(bcmul(0.7, 100), 7)); var_dump(floor(bcmul(0.58, 100))); var_dump(bcmod(bcmul(8945.63, 100), 1000000));输出结果 int(57) bool(false) float(57) int(894562) int(58) int(1) float(58) string(6) "894563"
-
