第九课：表增加字段

移库开票单汇总表MOVENOTESMT，增加，是否下传，同步时间，是否审批，审批人和审批日期等新字段

没有找到智友的表增加字段工具

解决办法：只有手工加了

1.先在FLDLIST中查下是否有需要的字段

SELECT * FROM FLDLIST WHERE FDNAME IN ('IsXc','IsPass','Approver1','ApproveDate1','Sync')

2.MOVENOTESMT增加字段

ALTER TABLE MOVENOTESMT ADD IsXc CHAR(1) NULL DEFAULT 'N'
ALTER TABLE MOVENOTESMT ADD Sync DATETIME NULL DEFAULT ''
ALTER TABLE MOVENOTESMT ADD IsPass CHAR(1) NULL DEFAULT ''
ALTER TABLE MOVENOTESMT ADD Approver1 CHAR(64) NULL DEFAULT ''
ALTER TABLE MOVENOTESMT ADD ApproveDate1 CHAR(10) NULL DEFAULT ''

3.查询TBSTRU，最大顺序号，然后增加新增的内容进去

INSERT INTO TBSTRU
            (TBNAME,FDNAME,SORTNUM,FDDESC,IS_NULL,DEFAULTVALUE,EXPLAINS,ISDEVFLD,DESIGNDATE,MODDATE,MODDESC,MODULEID)
SELECT 'MoveNotesMt','IsXc',23,'是否下传','Y','N','是否下传WMS;新增字段;WDJ;20190628','N','','','',''
UNION ALL
SELECT 'MoveNotesMt','Sync',24,'同步时间','Y','','下传WMS同步时间;新增字段;WDJ;20190628','N','','','',''
UNION ALL
SELECT 'MoveNotesMt','IsPass',25,'是否审批','Y','','审批状态;新增字段;WDJ;20190628','N','','','',''
UNION ALL
SELECT 'MoveNotesMt','Approver1',26,'审批人1','Y','','审批情况;新增字段;WDJ;20190628','N','','','',''
UNION ALL
SELECT 'MoveNotesMt','ApproveDate1',27,'审批日期1','Y','','审批情况;新增字段;WDJ;20190628','N','','','',''

4.开票存盘测试看看

OK，到时表新增字段工作完成。