Atonei的博客

–老单模板相关表ICTransactionType、ICTemplate、ICTemplateEntry–新单相关模板表ICClassType、ICClassTableInfo–目标单为老单的单据转换流程相关模板表：–icclasslink(单据转换流程整体信息)、ICSelBills(单据转换流程字段明细对应关系信息) ICTableRelation(单据转换流程表之间的连接关系信息)–ICWriteBackTemplate(勾稽关系的控制字段、扣减字段、关闭字段等信息)–目标单为BOS新单的单

Update t_subsys set Fused = -1 , FPeriodSynch = 0 , FCheckout = 0 where Fsubsysid = 6 and Fyear= 2020 and Fperiod = 2; //修改应付模块期间状态 ，应收模块 Fsubsysid = 5Update t_RP_SystemProfile Set FValue = ‘2’ Where FCategory = ‘ARP’ And FKey = ‘FAPCurPeriod’;Update

--------查询销售出库单-------------select * from ICStockBill where FTranType=21--------普通发票视图创建-----------alter view ptfpasselect a.finterid,a.FItemID,sum(a.FQty) as sl,sum(a.FAmountincludetax) as bhsje...

/*从发货通知单复制批号字段到销售订单（注意：字段名保持FBatchNo不变）Insert Into ICTemplateEntry(FID,FCtlOrder,FCtlIndex,FCtlType,FLookUpCls,FNeedSave,FValueType,FSaveValue,FFieldName,FEnable,FPrint,FHeadCaption,FWidth,FNeedCoun...