新增文章
文章标题
分类
C#
云星空
K3 BOS
K3 功能
用友
Oracle
python
SQL
MySql
PHP
HTML
script
windows
Access
影视后期
财务
服务
生活
内容
------------------------------------------------------------------------------------------------------------------------------------------------------------------------- -- 单据序时簿:常用字段 SELECT FTypeID,FInterID,FColName,FColCaption ,FVisible,FColWidth,FAlign,FMustSelected ,FTableName,FTableAlias,FName,FItemClassID ,FVisForQuest -- 条件 ,FVisForOrder -- 排序 ,FAction FROM ICChatBillTitle WHERE FInterID >= 0 AND FTypeID = 61 -- 销售订单 ORDER BY FInterID ------------------------------------------------------------------------------------------------------------------------------------------------------------------------- -- 单据序时簿:所有字段 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 ICTemplate WHERE FID = 'S01' ORDER BY FCtlIndex SELECT * FROM ICTemplateEntry WHERE FID = 'S01' ORDER BY FCtlIndex
返回
保存