DỰ ÁN PHẦN MỀM QUẢN LÝ TÀI SẢN NGÂN HÀNG BẢN VIỆT

BEGIN TRANSACTION

PRINT(N'Add rows to [dbo].[PL_MASTER]')

INSERT INTO [dbo].[PL_MASTER] ([PLAN_ID], [PLAN_CODE], [PLAN_NAME], [BRANCH_ID], [DEPT_ID], [EFFECT_DT], [PLAN_TYPE], [TOTAL_AMT], [APPROVE_VALUE], [VERSON], [YEAR], [STATUS], [NOTES], [RECORD_STATUS], [MAKER_ID], [CREATE_DT], [AUTH_STATUS], [CHECKER_ID], [APPROVE_DT], [PLAN_TYPE_ID], [COST_ID]) VALUES ('PLM000001056650', '069220520', N'KẾ HOẠCH NGÂN SÁCH 2020', 'DV0001', 'DEP000000000062', '2020-10-22 14:25:46.687', '', 286000000.00, 286000000.00, 1, '2020', '1', N'', '1', 'thuynt2', '2020-10-22 00:00:00.000', 'A', 'hoattm', '2020-10-22 00:00:00.000', 'PLTYPE000000037', 'DM0000000000077')

PRINT(N'Operation applied to 1 rows out of 2')

PRINT(N'Add row to [dbo].[PL_TRADE_REF]')

SET IDENTITY_INSERT [dbo].[PL_TRADE_REF] ON

INSERT INTO [dbo].[PL_TRADE_REF] ([REF_ID], [TRADE_ID], [REF_CODE], [REF_NAME]) VALUES (125727, 'PLT000001062955', '0692205', N'PHONG PHAT TRIEN KINH DOANH')

SET IDENTITY_INSERT [dbo].[PL_TRADE_REF] OFF

PRINT(N'Add row to [dbo].[PL_TRADEDETAIL]')

INSERT INTO [dbo].[PL_TRADEDETAIL] ([TRADE_ID], [PLAN_ID], [GOODS_ID], [GOODS_CODE], [GOODS_NAME], [GOODS_TYPE], [UNIT_ID], [M1], [M2], [M3], [M4], [M5], [M6], [M7], [M8], [M9], [M10], [M11], [M12], [QUANTITY], [QUANTITY_EXE], [PRICE], [START_DT_AMORT], [MONTH_AMORT], [END_DT_AMORT], [RATE_AMORT], [NOTES], [RECORD_STATUS], [MAKER_ID], [CREATE_DT], [AUTH_STATUS], [CHECKER_ID], [APPROVE_DT], [AMT_ETM], [AMT_EXE], [AMT_APP], [QUANTITY_ETM], [AMT_TF], [AMT_RECEIVE_TF]) VALUES ('PLT000001062955', 'PLM000001056650', 'GOO000001062455', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 0, NULL, 286000000, NULL, NULL, NULL, NULL, N'', '1', 'thuynt2', '2020-10-22 00:00:00.000', 'A', 'hoattm', '2020-10-22 00:00:00.000', NULL, NULL, 286000000.00, NULL, NULL, NULL)

COMMIT TRANSACTION