--解决 结账及年度结转 作业日期控制 无内容
--UPDATE SCLOSE SET DIV_CD = '1000',CLOSE_DT='20060101'
ALTER TABLE SDBCFG ADD 	MOD_CNT varchar(1024) COLLATE Chinese_PRC_CI_AS NULL
ALTER TABLE SDBCFG ADD 	MOD_CNT_ENC varchar(2048) COLLATE Chinese_PRC_CI_AS NULL
ALTER TABLE SDBCFG ADD 	KEY_LOCK_DT varchar(40) COLLATE Chinese_PRC_CI_AS NULL
ALTER TABLE SDBCFG ADD 	MOD_DT varchar(236) COLLATE Chinese_PRC_CI_AS NULL
ALTER TABLE SDBCFG ADD 	CVT_CHK int NOT NULL DEFAULT ((1))
GO
--修正 会计科目登记 项目选择状态 2选择
--UPDATE SACCT SET ACCT_FG = 3 WHERE ACCT_FG <> 0
UPDATE SACCT SET TR_FG  = 2  WHERE TR_FG = 0
UPDATE SACCT SET TRNM_FG  = 2  WHERE TRNM_FG = 0
UPDATE SACCT SET DEPTCD_FG  = 2  WHERE DEPTCD_FG = 0
UPDATE SACCT SET PJTCD_FG  = 2  WHERE PJTCD_FG = 0
UPDATE SACCT SET CTNB_FG  = 2  WHERE CTNB_FG = 0
UPDATE SACCT SET FRDT_FG  = 2  WHERE FRDT_FG = 0
UPDATE SACCT SET TODT_FG  = 2  WHERE TODT_FG = 0
UPDATE SACCT SET QT_FG  = 2  WHERE QT_FG = 0
UPDATE SACCT SET AM_FG  = 2  WHERE AM_FG = 0
UPDATE SACCT SET RT_FG  = 2  WHERE RT_FG = 0
UPDATE SACCT SET DEAL_FG  = 2  WHERE DEAL_FG = 0
UPDATE SACCT SET USER1_FG  = 2  WHERE USER1_FG = 0
UPDATE SACCT SET USER2_FG  = 2  WHERE USER2_FG = 0
GO
/*
UPDATE SACCT SET TRCD_ty  = ''  WHERE TR_FG = 0 AND CO_CD = '1000'
UPDATE SACCT SET TRNM_ty  = ''  WHERE TRNM_FG = 0 AND CO_CD = '1000'
UPDATE SACCT SET DEPTCD_ty  = ''  WHERE DEPTCD_FG = 0 AND CO_CD = '1000'
UPDATE SACCT SET PJTCD_ty  = ''  WHERE PJTCD_FG = 0 AND CO_CD = '1000'
UPDATE SACCT SET CTNB_ty  = ''  WHERE CTNB_FG = 0 AND CO_CD = '1000'
UPDATE SACCT SET FRDT_ty  = ''  WHERE FRDT_FG = 0 AND CO_CD = '1000'
UPDATE SACCT SET TODT_ty  = ''  WHERE TODT_FG = 0 AND CO_CD = '1000'
UPDATE SACCT SET QT_ty  = ''  WHERE QT_FG = 0 AND CO_CD = '1000'
UPDATE SACCT SET AM_ty  = ''  WHERE AM_FG = 0 AND CO_CD = '1000'
UPDATE SACCT SET RT_ty  = ''  WHERE RT_FG = 0 AND CO_CD = '1000'
UPDATE SACCT SET DEAL_ty  = ''  WHERE DEAL_FG = 0 AND CO_CD = '1000'
UPDATE SACCT SET USER1_ty  = ''  WHERE USER1_FG = 0 AND CO_CD = '1000'
UPDATE SACCT SET USER2_ty  = ''  WHERE USER2_FG = 0 AND CO_CD = '1000'
*/

--修正 凭证录入 输入区分
UPDATE SMSG SET ENG_NM=N'<@Enter for the classification .(3 Debi, 4 Credit)@>',KOR_NM=N'<@구분을 입력하세요.(3 차변, 4 대변)@>',CHS_NM=N'<@输入区分。(3 借方, 4 贷方)@>',JPN_NM=N'<@区分を入力してください。(3 借方, 4 貸方)@>' WHERE FILE_NM = 'ACAC010' AND ID_NO = '[1140]'
UPDATE SMSG SET ENG_NM=N'<@Enter for the classification .(3 Debi, 4 Credit)@>',KOR_NM=N'<@구분을 입력하세요.(3 차변, 4 대변)@>',CHS_NM=N'<@输入区分。(3 借方, 4 贷方)@>',JPN_NM=N'<@区分を入力してください。(3 借方, 4 貸方)@>' WHERE FILE_NM = 'ACAC010' AND ID_NO = '[1687]'
go

--修正 固定资产附加事项
UPDATE SMSG SET CHS_NM='<@0. 原值增加@>' WHERE FILE_NM='ACEC010' AND ID_NO='[1064]'
UPDATE SMSG SET CHS_NM='<@1. 原值减少@>' WHERE FILE_NM='ACEC010' AND ID_NO='[1065]'
UPDATE SMSG SET CHS_NM='<@2. 出    售@>' WHERE FILE_NM='ACEC010' AND ID_NO='[1066]'
UPDATE SMSG SET CHS_NM='<@原值增加@>' WHERE FILE_NM='ACEC010' AND ID_NO='[1067]'
UPDATE SMSG SET CHS_NM='<@原值减少@>' WHERE FILE_NM='ACEC010' AND ID_NO='[1068]'
UPDATE SMSG SET CHS_NM='<@出    售@>' WHERE FILE_NM='ACEC010' AND ID_NO='[1069]'
UPDATE SMSG SET CHS_NM='<@3. 停止折旧@>' WHERE FILE_NM='ACEC010' AND ID_NO='[1087]'
UPDATE SMSG SET CHS_NM='<@4. 开始折旧@>' WHERE FILE_NM='ACEC010' AND ID_NO='[1088]'
UPDATE SMSG SET CHS_NM='<@停止折旧@>' WHERE FILE_NM='ACEC010' AND ID_NO='[1089]'
UPDATE SMSG SET CHS_NM='<@开始折旧@>' WHERE FILE_NM='ACEC010' AND ID_NO='[1090]'
GO

--SCTRL
UPDATE SCTRL SET CTRL_NM='汇率' WHERE CTRL_CD='H5' AND MODULE_CD='S' 
UPDATE SCTRL SET CTRL_NM = '币种' WHERE CTRL_CD='K2' AND MODULE_CD='S' 
UPDATE SCTRL SET CTRL_NM = '调动原因' where ctrl_cd = 'HF'
--UPDATE SCTRL_D SET CTD_NM='记账' WHERE CTRL_CD = '21' AND CO_CD = '1000' AND CTD_CD = 5
GO

--修改 人事信息登记 中阴/阳应该是男/女
/*
UPDATE SCTRL SET CTRL_NM = '性别(人事信息登记用)' WHERE CTRL_CD = 'S3'
UPDATE SCTRL SET CTRL_NM = '军种' WHERE CTRL_CD = 'H6'
UPDATE SCTRL_D SET CTD_NM = '合同工' WHERE CTRL_CD = 'G1' AND CTD_CD = '001'
UPDATE SCTRL_D SET CTD_NM = '男' WHERE CTRL_CD = 'S3' AND CTD_CD = '000'
UPDATE SCTRL_D SET CTD_NM = '女' WHERE CTRL_CD = 'S3' AND CTD_CD = '001'
UPDATE SMSG SET CHS_NM='<@@T男/女@D5@A(DT_RIGHT|DT_VCENTER|DT_SINGLELINE)@>' WHERE FILE_NM = 'HRB0010' AND ID_NO = '[1290]'
UPDATE SMSG SET CHS_NM='<@@T国       籍@D14@A(DT_RIGHT|DT_VCENTER|DT_SINGLELINE)@>' WHERE FILE_NM = 'HRB0010' AND ID_NO = '[1317]'
UPDATE SMSG SET CHS_NM='<@职责@>' WHERE FILE_NM = 'HRB0010' and ID_NO IN ('[1304]')
UPDATE SMSG SET CHS_NM='<@职务@>' WHERE FILE_NM = 'HRB0010' and ID_NO IN ('[1211]','[1244]')
UPDATE SMSG SET CHS_NM='<@@T职    责@D9@A(DT_RIGHT|DT_VCENTER|DT_SINGLELINE)@>' WHERE FILE_NM = 'HRB0010' and ID_NO in ('[1304]')
UPDATE SMSG SET CHS_NM='<@@T职    务@D9@A(DT_RIGHT|DT_VCENTER|DT_SINGLELINE)@>' WHERE FILE_NM = 'HRB0010' and ID_NO in ('[1309]')

*/
GO
update sctrl_d set EDIT_YN = '1'  where CTRL_CD BETWEEN 'G1'  AND 'G5' AND EDIT_YN='0'
UPDATE SCTRL_D SET EDIT_YN = '1' WHERE CTRL_CD IN ('PD','P3','P2')
UPDATE SCTRL_D SET CTD_NM='退休'  WHERE CTRL_CD='HE' AND CTD_CD='J04'
UPDATE SCTRL_D SET CTD_NM='离职'  WHERE CTRL_CD='HE' AND CTD_CD='J05'

GO
/*
UPDATE SCTRL SET EDIT_YN = '1',CTRL_FG='H' WHERE CTRL_CD = 'HH'
UPDATE SCTRL SET EDIT_YN = '1',CTRL_FG='H' WHERE CTRL_CD = 'HS'
UPDATE SCTRL_D SET EDIT_YN = '1' WHERE CTRL_CD = 'HH'
UPDATE SCTRL_D SET EDIT_YN = '1' WHERE CTRL_CD = 'HS'
*/
GO
/*
UPDATE SMSG SET CHS_NM=N'<@ 职     务@>' WHERE FILE_NM = 'HRB0010' AND ID_NO = '[1211]'
UPDATE SMSG SET CHS_NM=N'<@ 职     务@>' WHERE FILE_NM = 'HRB0010' AND ID_NO = '[1244]'
UPDATE SMSG SET CHS_NM=N'<@ 职     责@>' WHERE FILE_NM = 'HRB0010' AND ID_NO = '[1208]'
UPDATE SMSG SET CHS_NM=N'<@ 职     责@>' WHERE FILE_NM = 'HRB0010' AND ID_NO = '[1241]'
*/
UPDATE SMSG SET CHS_NM=N'<@@T职    务@D9@A(DT_RIGHT|DT_VCENTER|DT_SINGLELINE)@> 'WHERE FILE_NM = 'HRB0010' AND ID_NO = '[1309]'
UPDATE SMSG SET CHS_NM=N'<@@T职    责@D9@A(DT_RIGHT|DT_VCENTER|DT_SINGLELINE)@>' WHERE FILE_NM = 'HRB0010' AND ID_NO = '[1304]'
go
UPDATE SMSG SET CHS_NM='<@@T离职日期@D8@A(DT_RIGHT|DT_VCENTER|DT_SINGLELINE)@>' WHERE FILE_NM='HRB0010' AND ID_NO='[1300]'
UPDATE SMSG SET CHS_NM='<@@T国       籍@D14@A(DT_RIGHT|DT_VCENTER|DT_SINGLELINE)@>' WHERE FILE_NM='HRB0010' AND ID_NO='[1317]'

GO
--删除多余的所得税记录
DELETE FROM HPFTITC WHERE SQ = 1
--删除多余的菜单
DELETE FROM SMENU WHERE LEFT(EXE_NM,6) = 'ACE007' OR LEFT(EXE_NM,4) = 'ACE2'
DELETE SECURITY WHERE LEFT(MENU_CD,6) = 'ACE007' OR LEFT(MENU_CD,4) = 'ACE2'