|
1
|
INSERT INTO [CM_GOODS] ([GD_ID],[GD_CODE],[GD_NAME],[GD_TYPE_ID],[USE_BRANCH],[AMORT_RATE],[DESCRIPTION],[SUP_ID],[PRICE],[UNIT_ID],[NOTES],[RECORD_STATUS],[MAKER_ID],[CREATE_DT],[AUTH_STATUS],[CHECKER_ID],[APPROVE_DT])VALUES(N'GOOII0001094344',N'RB.I.N.OE.0080',N'Ngân sách JCB tài trợ cho BVB',N'NS',N'',NULL,N'',N'',NULL,N'',N'',N'1',N'admin',N'Sep 11 2020 4:08PM',N'A',N'admin',N'Sep 11 2020 4:08PM')
|
|
2
|
INSERT INTO [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(N'PLM000001057966',N'069210320',N'KẾ HOẠCH NGÂN SÁCH 2020',N'DV0001',N'DEP000000000051',N'Sep 14 2020 9:26AM',N'',1854250000.00,1854250000.00,1,N'2020',N'1',N'',N'1',N'admin',N'Sep 14 2020 9:26AM',N'A',N'admin',N'Sep 14 2020 9:26AM',N'PLTYPE000000011',N'DM0000000000008')
|
|
3
|
INSERT INTO [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],[QUANTITY_ETM],[AMT_APP],[AMT_EXE],[AMT_ETM],[AMT_TF],[AMT_RECEIVE_TF])VALUES(N'PLT000001073024',N'PLM000001057966',N'GOOII0001094344',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,1,NULL,NULL,NULL,NULL,NULL,NULL,N'',N'1',N'admin',N'Sep 14 2020 9:26AM',N'A',N'admin',N'Sep 14 2020 9:26AM',NULL,1854250000.00,NULL,NULL,NULL,NULL)
|
|
4
|
INSERT INTO [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],[QUANTITY_ETM],[AMT_APP],[AMT_EXE],[AMT_ETM],[AMT_TF],[AMT_RECEIVE_TF])VALUES(N'PLT000001073025',N'PLM000000017955',N'GOO000001061943',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,1,NULL,NULL,NULL,NULL,NULL,NULL,N'',N'1',N'admin',N'Sep 14 2020 9:28AM',N'A',N'admin',N'Sep 14 2020 9:28AM',NULL,1854250000.00,NULL,NULL,NULL,NULL)
|