新增文章

文章标题分类内容

-------------------------------------------------------------------------------------------------------------------------------------------------------------------------
-- 添加字段：涉及数据表

SELECT * FROM ICTemplateEntry  WHERE FID         = 'S01' And FFieldName   = 'FEntrySelfS0173'
   SELECT * FROM ICSelBills       WHERE FID         = 'S01' And FDstCtlField = 'FEntrySelfS0173'

SELECT * FROM GLNoteType 
   SELECT * FROM GLNoteCitation   WHERE FTemplateID = 'S01' And FCode        = 'FEntrySelfS0173'
   
   SELECT * FROM ICChatBilltitle  WHERE FTypeID     = 61 And FColName   = 'FEntrySelfS0173'
   SELECT * FROM ICTableRelation  WHERE FTypeID     = 61 And FFieldName = 'FEntrySelfS0173'

SELECT * FROM ICListTemplate   WHERE FTemplateID = 61
   SELECT * FROM ICChatBillTitle  WHERE FTypeID     = 61  ORDER BY FInterID  -- 序时簿
   SELECT * FROM ICTableRelation  WHERE FTypeID     = 61  ORDER BY FInterID  -- 序时簿 关联字段

SELECT * FROM t_TableDescription  WHERE FTableName = 'SEOrderEntry'
   
   SELECT * FROM ICVoucherTpl       WHERE FName LIKE '%销售出库%'
   SELECT * FROM ICVouchertplEntry  WHERE FInterID = 11
   SELECT * FROM ICVoucherTField    WHERE FInterID = 11 And FUserDefineField = 'FEntrySelfS0173'