个人博客 用于记载日常收集的一些技术文章 ...

K3 BOS : K3 老单 K3 BOS : K3 老单 ---------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
-- 注册：中间层组件：BOS 老单 / 插件：aGsf_KIS.B01_Save / 工程名 aGsf_KIS / 类名 B01_Save / 主键：FTypeID ,FTypeDetailID ,FIndex
/*

DELETE FROM t_ThirdPartyComponent WHERE FComponentSrv in ( 'aGsf_KIS.SvrList21' )

INSERT INTO t_ThirdPartyComponent( FTypeID ,FTypeDetailID ,FIndex , FComponentSrv , FDescription ,FComponentName )
SELECT 2 ,300003 ,MAX(FIndex)+1 ,'aGsf_KIS.B01_Save' ,'销售出库单 保存后' ,'' FROM t_ThirdPartyComponent
GO
*/

SELECT * FROM t_ThirdPartyComponent WHERE FTypeID = 2
SELECT * FROM t_ThirdPartyComponent WHERE FComponentSrv = 'aGsf_KIS.SvrList21' 郭少锋 编辑 2023-09-05 14:14:10 创建 2023-09-05 11:43:24 K3 BOS K3 BOS : 22 K3 BOS : 22 11 郭少锋 创建 2023-09-05 14:06:35 K3 BOS K3 BOS : K3 老单 K3 BOS : K3 老单 -------------------------------------------------------------------------------------------------------------------------------------------------------------------------
-- 单据转换流程：对应关系

SELECT ISNULL(a2.FTabIndex,'') FDstNo,a1.FDstCtlField FDstField,ISNULL(a2.FCaption,'') FDstName
,ISNULL(a3.FTabIndex,'') FSrcNo,a1.FName FSrcField,ISNULL(a3.FCaption,'') FSrcName
,a1.FAction
,a1.*

FROM ICSelBills a1
LEFT JOIN (
SELECT 'v1' FTableAlias ,FFieldName,FTabIndex,FCaption FROM ICTemplate WHERE FID = 'B01'
UNION All
SELECT 'u1' FTableAlias ,FFieldName,FCtlOrder,FHeadCaption FROM ICTemplateEntry WHERE FID = 'B01'
) a2
ON a1.FDstCtlField = a2.FFieldName AND a1.FTableAlias = a2.FTableAlias

LEFT JOIN (
SELECT 'v1' FTableAlias ,FFieldName,FTabIndex,FCaption FROM ICTemplate WHERE FID = 'S01'
UNION All
SELECT 'u1' FTableAlias ,FFieldName,FCtlOrder,FHeadCaption FROM ICTemplateEntry WHERE FID = 'S01'
) a3
ON a1.FName = a3.FFieldName AND a1.FTableAlias = a3.FTableAlias

Where a1.FID = 'B01'
AND a1.FFieldName = 'FOrderInterID'

AND a1.FDstCtlField = 'FUniDiscount'


SELECT FID,FCtlOrder,FOptionExt,FFieldName,FHeadCaption,FWidth,FEnable,FVisForBillType,FRelationID,FAction,FFilter FROM ICTemplateEntry WHERE FID = 'B01' ORDER BY FCtlOrder -- 表体
SELECT FID,FCtlOrder,FOptionExt,FFieldName,FHeadCaption,FWidth,FEnable,FVisForBillType,FRelationID,FAction,FFilter FROM ICTemplateEntry WHERE FID = 'S01' ORDER BY FCtlOrder -- 表体 郭少锋 创建 2023-09-05 11:42:51 K3 BOS K3 BOS : K3 老单 K3 BOS : K3 老单 -------------------------------------------------------------------------------------------------------------------------------------------------------------------------
-- 单据转换流程：下推方向

SELECT FFieldName,FSourClassTypeID,FDestClassTypeID,FSourTranTypeID,FDestTranTypeID,FCondition,FRemark,FLookUpConditionUp
,FROB,FDefault,FUnControl,FIsUsed,FISUserDefine,FMustSelected,FAllowCopy,FAllowCheck,FUsePage,FDefaultPage
,FSelectListID,FSystemReserved,FUseSpec,FSrcDestPage,FSrcPage
,FSourBillFID,FSourBillFEntryID,FSourBillFBillNo,FSRCIDKey,FSRCEntryIDKey,FSRCBillNoKey,FSRCClassIDKey
FROM ICClassLink
WHERE FSourClassTypeID = -81 -- 销售订单
AND FDestClassTypeID = -21 -- 销售出库

ORDER BY FIsUsed desc,FDestClassTypeID 郭少锋 创建 2023-09-05 11:42:20 K3 BOS K3 BOS : K3 老单 K3 BOS : K3 老单 -------------------------------------------------------------------------------------------------------------------------------------------------------------------------
-- 单据转换流程

SELECT * FROM ICClassWorkFlow WHERE FID = 270 -- 名称
SELECT * FROM ICClassWorkFlowBill WHERE FID = 270 -- 布局：关联单据
SELECT * FROM ICClassWorkFlowJoin WHERE FID = 270 -- 关系：关联单据

SELECT * FROM ICClassLink WHERE FSourClassTypeID = -81 AND FDestClassTypeID = -21 -- FFieldName 销售订单 下推 销售出库
SELECT * FROM ICClassLinkEntry WHERE FSourClassTypeID = -81 AND FDestClassTypeID = -21
SELECT * FROM ICClassLinkCommit WHERE FSrcClsTypID = -81 AND FDstClsTypID = -21

SELECT * FROM ICSelBills Where FID = 'B01' AND FFieldName = '81'
SELECT * FROM ICTableRelation Where FBillID = 'B01' AND FFieldID = '81'


SELECT * FROM ICSelBills Where FID = 'B01' AND FFieldName = 'FOrderInterID'
SELECT * FROM ICTableRelation Where FBillID = 'B01' AND FFieldID = 'FOrderInterID' 郭少锋 创建 2023-09-05 11:40:59 K3 BOS K3 BOS : K3 老单 K3 BOS : K3 老单 -------------------------------------------------------------------------------------------------------------------------------------------------------------------------
-- 单据布局

-- S01 销售订单 / B01 销售出库 / I04 销售发票(专用) / I05 销售发票(普通)
-- P02 采购订单 / A01 外购入库 / I02 购货发票(专用) / I03 购货发票(普通)

SELECT * FROM ICTransactionType WHERE FTemplateID = 'S01' -- 整体

SELECT * FROM ICTemplate WHERE FID = 'S01' ORDER BY FCtlIndex -- 表头
SELECT * FROM ICTemplateEntry WHERE FID = 'S01' ORDER BY FCtlIndex -- 表体


SELECT * FROM ICTemplate WHERE FID = 'S01' ORDER BY FTabIndex
SELECT * FROM ICTemplateEntry WHERE FID = 'S01' ORDER BY FCtlOrder

SELECT * FROM ICTemplate WHERE FID = 'S01' AND FCaption LIKE '%日期%' ORDER BY FTabIndex
SELECT * FROM ICTemplateEntry WHERE FID = 'S01' AND FHeadCaption LIKE '%日期%' ORDER BY FCtlOrder


SELECT FID,FTabIndex,FOptionExt,FFieldName,FCaption,FWidth,FEnable,FVisForBillType,FRelationID,FAction,FFilter FROM ICTemplate WHERE FID = 'B01' ORDER BY FTabIndex -- 表头
SELECT FID,FTabIndex,FOptionExt,FFieldName,FCaption,FWidth,FEnable,FVisForBillType,FRelationID,FAction,FFilter FROM ICTemplate WHERE FID = 'S01' ORDER BY FTabIndex -- 表头


SELECT FID,FCtlOrder,FOptionExt,FFieldName,FHeadCaption,FWidth,FEnable,FVisForBillType,FRelationID,FAction,FFilter FROM ICTemplateEntry WHERE FID = 'B01' ORDER BY FCtlOrder -- 表体
SELECT FID,FCtlOrder,FOptionExt,FFieldName,FHeadCaption,FWidth,FEnable,FVisForBillType,FRelationID,FAction,FFilter FROM ICTemplateEntry WHERE FID = 'S01' ORDER BY FCtlOrder -- 表体

SELECT FID,FTabIndex,FFieldName,FCaption,FTop,FHeight,FLeft,FWidth FROM ICTemplate WHERE FID = 'B01' ORDER BY FTabIndex -- 表头
SELECT FID,FTabIndex,FFieldName,FCaption,FTop,FHeight,FLeft,FWidth FROM ICTemplate WHERE FID = 'B01' ORDER BY FHeight,FTabIndex -- 表头 高度

-------------------------------------------------------------------------------------------------------------------------------------------------------------------------
-- 单据布局 更新设置

UPDATE ICClassType SET FID = FID 郭少锋 编辑 2023-09-05 11:39:39 创建 2023-09-05 09:58:43 K3 BOS K3 BOS : K3 老单 数据表 K3 BOS : K3 老单 数据表 -------------------------------------------------------------------------------------------------------------------------------------------------------------------------
-- 销售订单

SELECT * FROM SEOrder
SELECT * FROM SEOrderEntry

SELECT * FROM ICStockBill
SELECT * FROM ICStockBillEntry

-------------------------------------------------------------------------------------------------------------------------------------------------------------------------
-- 部门

SELECT FNumber,FName,* FROM t_Department

-------------------------------------------------------------------------------------------------------------------------------------------------------------------------
-- 客户

SELECT F_102,FRegionID,FDepartment,FEmployee,FNumber,FName,* FROM t_Organization

-------------------------------------------------------------------------------------------------------------------------------------------------------------------------
-- 辅助资料

SELECT * FROM t_SubMesType -- 辅助资料：类别

SELECT * FROM t_SubMessage WHERE FTypeID = 10006 -- 辅助资料：票据种类 郭少锋 编辑 2023-09-05 11:37:00 创建 2023-09-05 10:26:58 K3 BOS K3 BOS : K3 老单 K3 BOS : K3 老单 -------------------------------------------------------------------------------------------------------------------------------------------------------------------------
-- 核算项目

SELECT * FROM t_ItemClass -- 核算项目：FSQLTableName t_Item_3002 颜色

SELECT * FROM t_Item_3002 -- 物料辅助属性：颜色
SELECT * FROM t_Item_3004 -- 物料辅助属性：型号
SELECT * FROM t_Item_3005 -- 物料辅助属性：型号+颜色


SELECT * FROM t_ICItem -- 物料
SELECT * FROM t_AuxItem -- 物料辅助属性
SELECT * FROM ICItemAuxProp -- 物料辅助属性 关联 物料 DELETE FROM ICItemAuxProp 郭少锋 创建 2023-09-05 11:32:57 K3 BOS K3 BOS : K3 老单 K3 BOS : K3 老单 -------------------------------------------------------------------------------------------------------------------------------------------------------------------------
-- 系统参数

SELECT * FROM t_Systemprofile WHERE FCategory = 'Base' AND FKey = 'ServicePack'
SELECT * FROM t_Systemprofile WHERE FCategory = 'Base' AND FKey = 'Type' 郭少锋 创建 2023-09-05 11:31:58 K3 BOS K3 BOS : K3 老单 K3 BOS : K3 老单 -------------------------------------------------------------------------------------------------------------------------------------------------------------------------
-- 单据：凭证模板

SELECT * FROM ICVoucherTBill WHERE FBillType = 21 ORDER BY FItemClassID -- 模板表体：核算项目：可选


SELECT * FROM ICVoucherTNote -- 未知 ？


SELECT * FROM ICVoucherTplType WHERE FInterID = 211 -- 事务类型
SELECT * FROM ICVoucherTpl WHERE FTplType = 211 -- 模板表头

SELECT * FROM ICVoucherTpl WHERE FInterID = 1042 -- 模板表头
SELECT * FROM ICVoucherTplEntry WHERE FInterID = 1042 -- 模板表体
SELECT * FROM ICVoucherTAudit WHERE FInterID = 1042 -- 模板表体：核算项目

SELECT * FROM ICVoucherTAcct WHERE FTplType = 211 ORDER BY FTplType,FInterID -- 模板表体：科目来源
SELECT * FROM ICVoucherTField WHERE FTplType = 211 ORDER BY FTplType,FCountPrice DESC,FInterID -- 模板表体：金额来源 郭少锋 创建 2023-09-05 11:29:40 K3 BOS