EOFFICE - GD4

STAR00000000002

UPDATE STA_REGISTER_MASTER SET END_DT = END_DT - 1 WHERE REG_ID = ''

SELECT * FROM SYS_PREFIX WHERE ID IN ('STA_REGISTER_MASTER'
,'STA_REGISTER_CONTRACT_DT'
,'STA_REGISTER_GOODS_DT'
,'STA_REGISTER_BRANCH_DT'
,'STA_REQUEST_REGISTER_MASTER'
,'STA_REQUEST_REGISTER_DT'
,'STA_SYNTHETIC_DISTRIBUTE_MASTER'
,'STA_SYNTHETIC_DISTRIBUTE_DT'
,'STA_NORM_DT'
,'STA_GOODS_GROUP'
,'STA_GOODS_TYPE'
,'STA_GOODS_DT'
,'STA_REGISTER_GOODS_TYPE_DT'
,'CM_PRICE_BANK')

STASD0000000001

UPDATE STA_REQUEST_REGISTER_MASTER SET END_DT = END_DT - 1 WHERE REQ_REG_ID = ''

DELETE FROM ASS_GENERAL_REQ

SELECT RL.DisplayName FROM TL_USER TL
INNER JOIN AbpUserRoles UR ON TL.ID = UR.UserId
INNER JOIN AbpRoles RL ON UR.RoleId = RL.Id
WHERE TL.TLNANME =@p_USER_LOGIN

SELECT * FROM TR_CONTRACT tc WHERE tc.CONTRACT_ID = ''

SELECT * FROM TR_CONTRACT_DT tcd WHERE tcd.CONTRACT_ID = ''

SELECT aa.AMORT_TERM, aa.EXECUTE_DT FROM ASS_AMORT aa ORDER BY aa.EXECUTE_DT

SELECT * FROM SYS_PREFIX WHERE ID IN (
'SHO_LEGAL_DOC'
,'SHO_SERVICE'
,'SHO_SERVICE_DT'
,'SHO_REQ_SERVICE'
,'SHO_REQ_SERVICE_DVCM'
,'SHO_REQ_SERVICE_DT'
,'SHO_REQ_SERVICE_DT_CONTENT'
,'SHO_REQ_SERVICE_DT_LEGAL'
,'SHO_REPORT_COST'
,'SHO_REPORT_COST_REQ'
,'SHO_REPORT_COST_SERVICE')

SLD
SRC
SRCR
SRCS
SRS
SRSDT
SRSDTC
SRSDTL
SRSD
SS
SSDT

UPDATE SHO_SERVICE SET SERVICE_ID = 'SS' + RIGHT) - 3)),13),
SERVICE_CODE = 'DV/' + RIGHT) - 3)), 3)

UPDATE SHO_SERVICE_DT SET SERVICE_ID = 'SS' + RIGHT) - 3)),13)

https://eoffice.bvbank.net.vn/app/admin/plan-transfer-view;id=PLRD00000214353;type=TTMS

ALTER TABLE [dbo].[CM_REQUEST_TEMPLATE]
ALTER COLUMN [CONTENT] [nvarchar](max) COLLATE SQL_Latin1_General_CP1_CI_AS NULL;