修改老单单据序时薄字段可见性

修改老单单据序时薄字段可见性原创

GOICE

7人赞赏了该文章 355次浏览编辑于2022年03月13日 19:16:44

发货通知单序时薄显示“订单单号”

SELECT FListTemplateID,* FROM dbo.ICTransactionType WHERE FNAME LIKE '%发货通知%'

SELECT FIsVisibleForList,* FROM dbo.ICTemplateEntry WHERE FID='s02' AND FHeadCaption='订单单号'

UPDATE dbo.ICTemplateEntry

SET FIsVisibleForList=1

WHERE FID='s02' AND FHeadCaption='订单单号'

SELECT * FROM dbo.ICListTemplate WHERE FID=34

SELECT FVisible,FVisForQuest,FVisForOrder,FViseForTDC,* FROM icchatbilltitle WHERE FTypeID=64 AND FColCaption LIKE '%订单单号%'

UPDATE dbo.ICChatBillTitle

SET FVisible=1

WHERE FTypeID=64 AND FInterID=50

图片.png

赞 7