|
1
|
INSERT INTO CM_DVDM (DVDM_ID, DVDM_CODE,DVDM_NAME,NOTES,RECORD_STATUS,AUTH_STATUS,MAKER_ID,CREATE_DT,EDITER_ID,EDIT_DT,CHECKER_ID,APPROVE_DT, IS_DVDM, IS_KHOI, IS_DVCM)
|
|
2
|
VALUES ('DM0000000000078','89900001','PHONG PHAT TRIEN KINH DOANH NGAN HANG SO','PHONG PHAT TRIEN KINH DOANH NGAN HANG SO',
|
|
3
|
'1','A','admin',GETDATE(),'admin',GETDATE(),1,0,1,0,0)
|
|
4
|
INSERT INTO PL_COSTCENTER (COST_ID,COST_CODE,COST_NAME,RECORD_STATUS,AUTH_STATUS,MAKER_ID,CREATE_DT,DVDM_ID)
|
|
5
|
VALUES ('PLCC00000001003','89900001','PHONG PHAT TRIEN KINH DOANH NGAN HANG SO','1','A','admin',GETDATE(),'DM0000000000078')
|
|
6
|
INSERT INTO PL_COSTCENTER_DT(COSTDT_ID,COST_ID,BRANCH_ID,DEP_ID,RECORD_STATUS,MAKER_ID,CREATE_DT)
|
|
7
|
VALUES ('PCDT00000001014','PLCC00000001003','DV0001','DEP000000252203','1','admin',GETDATE())
|
|
8
|
UPDATE CM_DVDM SET DVDM_CODE ='8990000', DVDM_NAME ='TRUNG TAM NGAN HANG SO' WHERE DVDM_ID ='DM0000000000034'
|