新增文章

文章标题分类内容

-------------------------------------------------------------------------------------------------------------------------------------------------------------------------
-- 单据转换流程

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'