/*
Run this script on:

TRUONGNV.gAMSPro_VietcapitalBank_LOCAL    -  This database will be modified

to synchronize it with:

118.69.72.241,5036.gAMSPro_VietcapitalBank_v2

You are recommended to back up your database before running this script

Script created by SQL Data Compare version 13.7.7.10021 from Red Gate Software Ltd at 20-Oct-20 2:19:53 PM

*/
		
SET NUMERIC_ROUNDABORT OFF
GO
SET ANSI_PADDING, ANSI_WARNINGS, CONCAT_NULL_YIELDS_NULL, ARITHABORT, QUOTED_IDENTIFIER, ANSI_NULLS, NOCOUNT ON
GO
SET DATEFORMAT YMD
GO
SET XACT_ABORT ON
GO
SET TRANSACTION ISOLATION LEVEL Serializable
GO
BEGIN TRANSACTION

PRINT(N'Update row in [dbo].[PL_IMPORT]')
UPDATE [dbo].[PL_IMPORT] SET [IMP_ATM]=-1432771629805.00, [EDIT_DT]='2020-10-20 00:00:00.000', [APPROVE_DT]='2020-10-20 00:00:00.000' WHERE [IMPORT_ID] = 'PLIMP0000019002'

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 ('PLM000001056637', NULL, N'KẾ HOẠCH NGÂN SÁCH 2020', NULL, NULL, '2020-10-20 14:18:33.423', '', 0.00, 0.00, 1, '2020', '1', N'', '1', 'thuynt2', '2020-10-20 00:00:00.000', 'A', 'hoattm', '2020-10-20 00:00:00.000', NULL, NULL)
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 ('PLM000001056638', '075000120', N'KẾ HOẠCH NGÂN SÁCH 2020', 'BRN000000001841', 'DEP000000251858', '2020-10-20 14:18:35.033', '', 1070053136.92, 1070053136.92, 1, '2020', '1', N'', '1', 'thuynt2', '2020-10-20 00:00:00.000', 'A', 'hoattm', '2020-10-20 00:00:00.000', 'PLTYPE000000048', 'DM0000000000001')
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 ('PLM000001056639', '075000120', N'KẾ HOẠCH NGÂN SÁCH 2020', 'BRN000000001841', 'DEP000000251858', '2020-10-20 14:18:35.877', '', 0.00, 0.00, 1, '2020', '1', N'', '1', 'thuynt2', '2020-10-20 00:00:00.000', 'A', 'hoattm', '2020-10-20 00:00:00.000', 'PLTYPE000000049', 'DM0000000000001')
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 ('PLM000001056640', '075000120', N'KẾ HOẠCH NGÂN SÁCH 2020', 'BRN000000001841', 'DEP000000251858', '2020-10-20 14:18:36.360', '', 276577934.97, 276577934.97, 1, '2020', '1', N'', '1', 'thuynt2', '2020-10-20 00:00:00.000', 'A', 'hoattm', '2020-10-20 00:00:00.000', 'PLTYPE000000049', 'DM0000000000003')
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 ('PLM000001056641', '075000120', N'KẾ HOẠCH NGÂN SÁCH 2020', 'BRN000000001841', 'DEP000000251858', '2020-10-20 14:18:36.923', '', 0.00, 0.00, 1, '2020', '1', N'', '1', 'thuynt2', '2020-10-20 00:00:00.000', 'A', 'hoattm', '2020-10-20 00:00:00.000', 'PLTYPE000000049', 'DM0000000000042')
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 ('PLM000001056642', '075000120', N'KẾ HOẠCH NGÂN SÁCH 2020', 'BRN000000001841', 'DEP000000251858', '2020-10-20 14:18:37.410', '', 47627117.97, 47627117.97, 1, '2020', '1', N'', '1', 'thuynt2', '2020-10-20 00:00:00.000', 'A', 'hoattm', '2020-10-20 00:00:00.000', 'PLTYPE000000049', 'DM0000000000048')
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 ('PLM000001056643', '075000120', N'KẾ HOẠCH NGÂN SÁCH 2020', 'BRN000000001841', 'DEP000000251858', '2020-10-20 14:18:37.957', '', 19145454.55, 19145454.55, 1, '2020', '1', N'', '1', 'thuynt2', '2020-10-20 00:00:00.000', 'A', 'hoattm', '2020-10-20 00:00:00.000', 'PLTYPE000000049', 'DM0000000000049')
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 ('PLM000001056644', '075000120', N'KẾ HOẠCH NGÂN SÁCH 2020', 'BRN000000001841', 'DEP000000251858', '2020-10-20 14:18:38.393', '', 7167210.61, 7167210.61, 1, '2020', '1', N'', '1', 'thuynt2', '2020-10-20 00:00:00.000', 'A', 'hoattm', '2020-10-20 00:00:00.000', 'PLTYPE000000049', 'DM0000000000070')
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 ('PLM000001056645', '075000120', N'KẾ HOẠCH NGÂN SÁCH 2020', 'BRN000000001841', 'DEP000000251858', '2020-10-20 14:18:38.817', '', 90209858.19, 90209858.19, 1, '2020', '1', N'', '1', 'thuynt2', '2020-10-20 00:00:00.000', 'A', 'hoattm', '2020-10-20 00:00:00.000', 'PLTYPE000000049', 'DVDM-CHUNG')
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 ('PLM000001056646', '075000120', N'KẾ HOẠCH NGÂN SÁCH 2020', 'BRN000000001841', 'DEP000000251858', '2020-10-20 14:18:39.237', '', 136952986.31, 136952986.31, 1, '2020', '1', N'', '1', 'thuynt2', '2020-10-20 00:00:00.000', 'A', 'hoattm', '2020-10-20 00:00:00.000', 'PLTYPE000000050', NULL)
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 ('PLM000001056647', '075000120', N'KẾ HOẠCH NGÂN SÁCH 2020', 'BRN000000001841', 'DEP000000251858', '2020-10-20 14:18:39.690', '', 540000000.00, 540000000.00, 1, '2020', '1', N'', '1', 'thuynt2', '2020-10-20 00:00:00.000', 'A', 'hoattm', '2020-10-20 00:00:00.000', 'PLTYPE000000050', 'DM0000000000003')
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 ('PLM000001056648', '075000120', N'KẾ HOẠCH NGÂN SÁCH 2020', 'BRN000000001841', 'DEP000000251858', '2020-10-20 14:18:40.113', '', 0.00, 0.00, 1, '2020', '1', N'', '1', 'thuynt2', '2020-10-20 00:00:00.000', 'A', 'hoattm', '2020-10-20 00:00:00.000', 'PLTYPE000000051', 'DM0000000000048')
PRINT(N'Operation applied to 12 rows out of 12')

PRINT(N'Add rows 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 (124727, 'PLT000001062908', '0750001', N'THANH HOA')
INSERT INTO [dbo].[PL_TRADE_REF] ([REF_ID], [TRADE_ID], [REF_CODE], [REF_NAME]) VALUES (124728, 'PLT000001062909', '0750001', N'THANH HOA')
INSERT INTO [dbo].[PL_TRADE_REF] ([REF_ID], [TRADE_ID], [REF_CODE], [REF_NAME]) VALUES (124729, 'PLT000001062910', '0750001', N'THANH HOA')
INSERT INTO [dbo].[PL_TRADE_REF] ([REF_ID], [TRADE_ID], [REF_CODE], [REF_NAME]) VALUES (124730, 'PLT000001062911', '0750001', N'THANH HOA')
INSERT INTO [dbo].[PL_TRADE_REF] ([REF_ID], [TRADE_ID], [REF_CODE], [REF_NAME]) VALUES (124731, 'PLT000001062912', '0750001', N'THANH HOA')
INSERT INTO [dbo].[PL_TRADE_REF] ([REF_ID], [TRADE_ID], [REF_CODE], [REF_NAME]) VALUES (124732, 'PLT000001062913', '0750001', N'THANH HOA')
INSERT INTO [dbo].[PL_TRADE_REF] ([REF_ID], [TRADE_ID], [REF_CODE], [REF_NAME]) VALUES (124733, 'PLT000001062914', '0750001', N'THANH HOA')
INSERT INTO [dbo].[PL_TRADE_REF] ([REF_ID], [TRADE_ID], [REF_CODE], [REF_NAME]) VALUES (124734, 'PLT000001062915', '0750001', N'THANH HOA')
INSERT INTO [dbo].[PL_TRADE_REF] ([REF_ID], [TRADE_ID], [REF_CODE], [REF_NAME]) VALUES (124735, 'PLT000001062916', '0750001', N'THANH HOA')
INSERT INTO [dbo].[PL_TRADE_REF] ([REF_ID], [TRADE_ID], [REF_CODE], [REF_NAME]) VALUES (124736, 'PLT000001062917', '0750001', N'THANH HOA')
INSERT INTO [dbo].[PL_TRADE_REF] ([REF_ID], [TRADE_ID], [REF_CODE], [REF_NAME]) VALUES (124737, 'PLT000001062918', '0750001', N'THANH HOA')
INSERT INTO [dbo].[PL_TRADE_REF] ([REF_ID], [TRADE_ID], [REF_CODE], [REF_NAME]) VALUES (124738, 'PLT000001062919', '0750001', N'THANH HOA')
INSERT INTO [dbo].[PL_TRADE_REF] ([REF_ID], [TRADE_ID], [REF_CODE], [REF_NAME]) VALUES (124739, 'PLT000001062920', '0750001', N'THANH HOA')
INSERT INTO [dbo].[PL_TRADE_REF] ([REF_ID], [TRADE_ID], [REF_CODE], [REF_NAME]) VALUES (124740, 'PLT000001062921', '0750001', N'THANH HOA')
INSERT INTO [dbo].[PL_TRADE_REF] ([REF_ID], [TRADE_ID], [REF_CODE], [REF_NAME]) VALUES (124741, 'PLT000001062922', '0750001', N'THANH HOA')
INSERT INTO [dbo].[PL_TRADE_REF] ([REF_ID], [TRADE_ID], [REF_CODE], [REF_NAME]) VALUES (124742, 'PLT000001062923', '0750001', N'THANH HOA')
INSERT INTO [dbo].[PL_TRADE_REF] ([REF_ID], [TRADE_ID], [REF_CODE], [REF_NAME]) VALUES (124743, 'PLT000001062924', '0750001', N'THANH HOA')
INSERT INTO [dbo].[PL_TRADE_REF] ([REF_ID], [TRADE_ID], [REF_CODE], [REF_NAME]) VALUES (124744, 'PLT000001062925', '0750001', N'THANH HOA')
INSERT INTO [dbo].[PL_TRADE_REF] ([REF_ID], [TRADE_ID], [REF_CODE], [REF_NAME]) VALUES (124745, 'PLT000001062926', '0750001', N'THANH HOA')
INSERT INTO [dbo].[PL_TRADE_REF] ([REF_ID], [TRADE_ID], [REF_CODE], [REF_NAME]) VALUES (124746, 'PLT000001062927', '0750001', N'THANH HOA')
INSERT INTO [dbo].[PL_TRADE_REF] ([REF_ID], [TRADE_ID], [REF_CODE], [REF_NAME]) VALUES (124747, 'PLT000001062928', '0750001', N'THANH HOA')
INSERT INTO [dbo].[PL_TRADE_REF] ([REF_ID], [TRADE_ID], [REF_CODE], [REF_NAME]) VALUES (124748, 'PLT000001062929', '0750001', N'THANH HOA')
INSERT INTO [dbo].[PL_TRADE_REF] ([REF_ID], [TRADE_ID], [REF_CODE], [REF_NAME]) VALUES (124749, 'PLT000001062930', '0750001', N'THANH HOA')
INSERT INTO [dbo].[PL_TRADE_REF] ([REF_ID], [TRADE_ID], [REF_CODE], [REF_NAME]) VALUES (124750, 'PLT000001062931', '0750001', N'THANH HOA')
INSERT INTO [dbo].[PL_TRADE_REF] ([REF_ID], [TRADE_ID], [REF_CODE], [REF_NAME]) VALUES (124751, 'PLT000001062932', '0750001', N'THANH HOA')
INSERT INTO [dbo].[PL_TRADE_REF] ([REF_ID], [TRADE_ID], [REF_CODE], [REF_NAME]) VALUES (124752, 'PLT000001062933', '0750001', N'THANH HOA')
INSERT INTO [dbo].[PL_TRADE_REF] ([REF_ID], [TRADE_ID], [REF_CODE], [REF_NAME]) VALUES (124753, 'PLT000001062934', '0750001', N'THANH HOA')
INSERT INTO [dbo].[PL_TRADE_REF] ([REF_ID], [TRADE_ID], [REF_CODE], [REF_NAME]) VALUES (124754, 'PLT000001062935', '0750001', N'THANH HOA')
INSERT INTO [dbo].[PL_TRADE_REF] ([REF_ID], [TRADE_ID], [REF_CODE], [REF_NAME]) VALUES (124755, 'PLT000001062936', '0750001', N'THANH HOA')
INSERT INTO [dbo].[PL_TRADE_REF] ([REF_ID], [TRADE_ID], [REF_CODE], [REF_NAME]) VALUES (124756, 'PLT000001062937', '0750001', N'THANH HOA')
INSERT INTO [dbo].[PL_TRADE_REF] ([REF_ID], [TRADE_ID], [REF_CODE], [REF_NAME]) VALUES (124757, 'PLT000001062938', '0750001', N'THANH HOA')
INSERT INTO [dbo].[PL_TRADE_REF] ([REF_ID], [TRADE_ID], [REF_CODE], [REF_NAME]) VALUES (124758, 'PLT000001062939', '0750001', N'THANH HOA')
INSERT INTO [dbo].[PL_TRADE_REF] ([REF_ID], [TRADE_ID], [REF_CODE], [REF_NAME]) VALUES (124759, 'PLT000001062940', '0750001', N'THANH HOA')
INSERT INTO [dbo].[PL_TRADE_REF] ([REF_ID], [TRADE_ID], [REF_CODE], [REF_NAME]) VALUES (124760, 'PLT000001062941', '0750001', N'THANH HOA')
INSERT INTO [dbo].[PL_TRADE_REF] ([REF_ID], [TRADE_ID], [REF_CODE], [REF_NAME]) VALUES (124761, 'PLT000001062942', '0750001', N'THANH HOA')
INSERT INTO [dbo].[PL_TRADE_REF] ([REF_ID], [TRADE_ID], [REF_CODE], [REF_NAME]) VALUES (124762, 'PLT000001062943', '0750001', N'THANH HOA')
INSERT INTO [dbo].[PL_TRADE_REF] ([REF_ID], [TRADE_ID], [REF_CODE], [REF_NAME]) VALUES (124763, 'PLT000001062944', '0750001', N'THANH HOA')
INSERT INTO [dbo].[PL_TRADE_REF] ([REF_ID], [TRADE_ID], [REF_CODE], [REF_NAME]) VALUES (124764, 'PLT000001062945', '0750001', N'THANH HOA')
INSERT INTO [dbo].[PL_TRADE_REF] ([REF_ID], [TRADE_ID], [REF_CODE], [REF_NAME]) VALUES (124765, 'PLT000001062946', '0750001', N'THANH HOA')
INSERT INTO [dbo].[PL_TRADE_REF] ([REF_ID], [TRADE_ID], [REF_CODE], [REF_NAME]) VALUES (124766, 'PLT000001062947', '0750001', N'THANH HOA')
INSERT INTO [dbo].[PL_TRADE_REF] ([REF_ID], [TRADE_ID], [REF_CODE], [REF_NAME]) VALUES (124767, 'PLT000001062948', '0750001', N'THANH HOA')
INSERT INTO [dbo].[PL_TRADE_REF] ([REF_ID], [TRADE_ID], [REF_CODE], [REF_NAME]) VALUES (124768, 'PLT000001062949', '0750001', N'THANH HOA')
INSERT INTO [dbo].[PL_TRADE_REF] ([REF_ID], [TRADE_ID], [REF_CODE], [REF_NAME]) VALUES (124769, 'PLT000001062950', '0750001', N'THANH HOA')
INSERT INTO [dbo].[PL_TRADE_REF] ([REF_ID], [TRADE_ID], [REF_CODE], [REF_NAME]) VALUES (124770, 'PLT000001062951', '0750001', N'THANH HOA')
INSERT INTO [dbo].[PL_TRADE_REF] ([REF_ID], [TRADE_ID], [REF_CODE], [REF_NAME]) VALUES (124771, 'PLT000001062952', '0750001', N'THANH HOA')
INSERT INTO [dbo].[PL_TRADE_REF] ([REF_ID], [TRADE_ID], [REF_CODE], [REF_NAME]) VALUES (124772, 'PLT000001062953', '0750001', N'THANH HOA')
INSERT INTO [dbo].[PL_TRADE_REF] ([REF_ID], [TRADE_ID], [REF_CODE], [REF_NAME]) VALUES (124773, 'PLT000001062954', '0750001', N'THANH HOA')
SET IDENTITY_INSERT [dbo].[PL_TRADE_REF] OFF
PRINT(N'Operation applied to 47 rows out of 47')

PRINT(N'Add rows 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 ('PLT000001062908', 'PLM000001056638', 'GOO000001061861', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 0, NULL, 964532876, NULL, NULL, NULL, NULL, N'', '1', 'thuynt2', '2020-10-20 00:00:00.000', 'A', 'hoattm', '2020-10-20 00:00:00.000', NULL, NULL, 964532875.67, NULL, NULL, NULL)
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 ('PLT000001062909', 'PLM000001056638', 'GOO000001061863', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 0, NULL, 13500000, NULL, NULL, NULL, NULL, N'', '1', 'thuynt2', '2020-10-20 00:00:00.000', 'A', 'hoattm', '2020-10-20 00:00:00.000', NULL, NULL, 13500000.00, NULL, NULL, NULL)
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 ('PLT000001062910', 'PLM000001056638', 'GOO000001061865', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 0, NULL, 23000000, NULL, NULL, NULL, NULL, N'', '1', 'thuynt2', '2020-10-20 00:00:00.000', 'A', 'hoattm', '2020-10-20 00:00:00.000', NULL, NULL, 23000000.00, NULL, NULL, NULL)
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 ('PLT000001062911', 'PLM000001056638', 'GOO000001061867', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 0, NULL, 33900000, NULL, NULL, NULL, NULL, N'', '1', 'thuynt2', '2020-10-20 00:00:00.000', 'A', 'hoattm', '2020-10-20 00:00:00.000', NULL, NULL, 33900000.00, NULL, NULL, NULL)
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 ('PLT000001062912', 'PLM000001056638', 'GOO000001061869', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 0, NULL, 0, NULL, NULL, NULL, NULL, N'', '1', 'thuynt2', '2020-10-20 00:00:00.000', 'A', 'hoattm', '2020-10-20 00:00:00.000', NULL, NULL, 0.00, NULL, NULL, NULL)
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 ('PLT000001062913', 'PLM000001056638', 'GOO000001061871', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 0, NULL, 35120261, NULL, NULL, NULL, NULL, N'', '1', 'thuynt2', '2020-10-20 00:00:00.000', 'A', 'hoattm', '2020-10-20 00:00:00.000', NULL, NULL, 35120261.25, NULL, NULL, NULL)
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 ('PLT000001062914', 'PLM000001056639', 'GOO000001061891', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 0, NULL, 0, NULL, NULL, NULL, NULL, N'', '1', 'thuynt2', '2020-10-20 00:00:00.000', 'A', 'hoattm', '2020-10-20 00:00:00.000', NULL, NULL, 0.00, NULL, NULL, NULL)
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 ('PLT000001062915', 'PLM000001056640', 'GOO000001061873', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 0, NULL, 903506, NULL, NULL, NULL, NULL, N'', '1', 'thuynt2', '2020-10-20 00:00:00.000', 'A', 'hoattm', '2020-10-20 00:00:00.000', NULL, NULL, 903506.09, NULL, NULL, NULL)
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 ('PLT000001062916', 'PLM000001056640', 'GOO000001061875', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 0, NULL, 7864976, NULL, NULL, NULL, NULL, N'', '1', 'thuynt2', '2020-10-20 00:00:00.000', 'A', 'hoattm', '2020-10-20 00:00:00.000', NULL, NULL, 7864976.24, NULL, NULL, NULL)
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 ('PLT000001062917', 'PLM000001056640', 'GOO000001061877', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 0, NULL, 0, NULL, NULL, NULL, NULL, N'', '1', 'thuynt2', '2020-10-20 00:00:00.000', 'A', 'hoattm', '2020-10-20 00:00:00.000', NULL, NULL, 0.00, NULL, NULL, NULL)
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 ('PLT000001062918', 'PLM000001056640', 'GOO000001061879', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 0, NULL, 3360000, NULL, NULL, NULL, NULL, N'', '1', 'thuynt2', '2020-10-20 00:00:00.000', 'A', 'hoattm', '2020-10-20 00:00:00.000', NULL, NULL, 3360000.00, NULL, NULL, NULL)
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 ('PLT000001062919', 'PLM000001056640', 'GOO000001061881', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 0, NULL, 4101796, NULL, NULL, NULL, NULL, N'', '1', 'thuynt2', '2020-10-20 00:00:00.000', 'A', 'hoattm', '2020-10-20 00:00:00.000', NULL, NULL, 4101796.27, NULL, NULL, NULL)
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 ('PLT000001062920', 'PLM000001056640', 'GOO000001061893', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 0, NULL, 0, NULL, NULL, NULL, NULL, N'', '1', 'thuynt2', '2020-10-20 00:00:00.000', 'A', 'hoattm', '2020-10-20 00:00:00.000', NULL, NULL, 0.00, NULL, NULL, NULL)
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 ('PLT000001062921', 'PLM000001056640', 'GOO000001061895', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 0, NULL, 4888291, NULL, NULL, NULL, NULL, N'', '1', 'thuynt2', '2020-10-20 00:00:00.000', 'A', 'hoattm', '2020-10-20 00:00:00.000', NULL, NULL, 4888291.00, NULL, NULL, NULL)
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 ('PLT000001062922', 'PLM000001056640', 'GOO000001061919', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 0, NULL, 8785738, NULL, NULL, NULL, NULL, N'', '1', 'thuynt2', '2020-10-20 00:00:00.000', 'A', 'hoattm', '2020-10-20 00:00:00.000', NULL, NULL, 8785737.56, NULL, NULL, NULL)
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 ('PLT000001062923', 'PLM000001056640', 'GOO000001061921', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 0, NULL, 904567, NULL, NULL, NULL, NULL, N'', '1', 'thuynt2', '2020-10-20 00:00:00.000', 'A', 'hoattm', '2020-10-20 00:00:00.000', NULL, NULL, 904567.24, NULL, NULL, NULL)
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 ('PLT000001062924', 'PLM000001056640', 'GOO000001061923', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 0, NULL, 18000000, NULL, NULL, NULL, NULL, N'', '1', 'thuynt2', '2020-10-20 00:00:00.000', 'A', 'hoattm', '2020-10-20 00:00:00.000', NULL, NULL, 18000000.00, NULL, NULL, NULL)
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 ('PLT000001062925', 'PLM000001056640', 'GOO000001061925', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 0, NULL, 134399927, NULL, NULL, NULL, NULL, N'', '1', 'thuynt2', '2020-10-20 00:00:00.000', 'A', 'hoattm', '2020-10-20 00:00:00.000', NULL, NULL, 134399927.24, NULL, NULL, NULL)
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 ('PLT000001062926', 'PLM000001056640', 'GOO000001061927', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 0, NULL, 5000000, NULL, NULL, NULL, NULL, N'', '1', 'thuynt2', '2020-10-20 00:00:00.000', 'A', 'hoattm', '2020-10-20 00:00:00.000', NULL, NULL, 5000000.00, NULL, NULL, NULL)
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 ('PLT000001062927', 'PLM000001056640', 'GOO000001061935', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 0, NULL, 7369133, NULL, NULL, NULL, NULL, N'', '1', 'thuynt2', '2020-10-20 00:00:00.000', 'A', 'hoattm', '2020-10-20 00:00:00.000', NULL, NULL, 7369133.33, NULL, NULL, NULL)
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 ('PLT000001062928', 'PLM000001056640', 'GOO000001061939', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 0, NULL, 81000000, NULL, NULL, NULL, NULL, N'', '1', 'thuynt2', '2020-10-20 00:00:00.000', 'A', 'hoattm', '2020-10-20 00:00:00.000', NULL, NULL, 81000000.00, NULL, NULL, NULL)
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 ('PLT000001062929', 'PLM000001056641', 'GOO000001061941', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 0, NULL, 0, NULL, NULL, NULL, NULL, N'', '1', 'thuynt2', '2020-10-20 00:00:00.000', 'A', 'hoattm', '2020-10-20 00:00:00.000', NULL, NULL, 0.00, NULL, NULL, NULL)
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 ('PLT000001062930', 'PLM000001056642', 'GOO000001061883', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 0, NULL, 3632000, NULL, NULL, NULL, NULL, N'', '1', 'thuynt2', '2020-10-20 00:00:00.000', 'A', 'hoattm', '2020-10-20 00:00:00.000', NULL, NULL, 3632000.00, NULL, NULL, NULL)
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 ('PLT000001062931', 'PLM000001056642', 'GOO000001061885', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 0, NULL, 1617739, NULL, NULL, NULL, NULL, N'', '1', 'thuynt2', '2020-10-20 00:00:00.000', 'A', 'hoattm', '2020-10-20 00:00:00.000', NULL, NULL, 1617738.53, NULL, NULL, NULL)
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 ('PLT000001062932', 'PLM000001056642', 'GOO000001061887', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 0, NULL, 0, NULL, NULL, NULL, NULL, N'', '1', 'thuynt2', '2020-10-20 00:00:00.000', 'A', 'hoattm', '2020-10-20 00:00:00.000', NULL, NULL, 0.00, NULL, NULL, NULL)
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 ('PLT000001062933', 'PLM000001056642', 'GOO000001061889', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 0, NULL, 3070943, NULL, NULL, NULL, NULL, N'', '1', 'thuynt2', '2020-10-20 00:00:00.000', 'A', 'hoattm', '2020-10-20 00:00:00.000', NULL, NULL, 3070943.01, NULL, NULL, NULL)
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 ('PLT000001062934', 'PLM000001056642', 'GOO000001061915', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 0, NULL, 0, NULL, NULL, NULL, NULL, N'', '1', 'thuynt2', '2020-10-20 00:00:00.000', 'A', 'hoattm', '2020-10-20 00:00:00.000', NULL, NULL, 0.00, NULL, NULL, NULL)
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 ('PLT000001062935', 'PLM000001056642', 'GOO000001061917', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 0, NULL, 0, NULL, NULL, NULL, NULL, N'', '1', 'thuynt2', '2020-10-20 00:00:00.000', 'A', 'hoattm', '2020-10-20 00:00:00.000', NULL, NULL, 0.00, NULL, NULL, NULL)
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 ('PLT000001062936', 'PLM000001056642', 'GOO000001061929', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 0, NULL, 12500000, NULL, NULL, NULL, NULL, N'', '1', 'thuynt2', '2020-10-20 00:00:00.000', 'A', 'hoattm', '2020-10-20 00:00:00.000', NULL, NULL, 12500000.00, NULL, NULL, NULL)
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 ('PLT000001062937', 'PLM000001056642', 'GOO000001061933', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 0, NULL, 2223320, NULL, NULL, NULL, NULL, N'', '1', 'thuynt2', '2020-10-20 00:00:00.000', 'A', 'hoattm', '2020-10-20 00:00:00.000', NULL, NULL, 2223320.16, NULL, NULL, NULL)
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 ('PLT000001062938', 'PLM000001056642', 'GOO000001061937', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 0, NULL, 24083116, NULL, NULL, NULL, NULL, N'', '1', 'thuynt2', '2020-10-20 00:00:00.000', 'A', 'hoattm', '2020-10-20 00:00:00.000', NULL, NULL, 24083116.27, NULL, NULL, NULL)
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 ('PLT000001062939', 'PLM000001056642', 'GOO000001061943', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 0, NULL, 0, NULL, NULL, NULL, NULL, N'', '1', 'thuynt2', '2020-10-20 00:00:00.000', 'A', 'hoattm', '2020-10-20 00:00:00.000', NULL, NULL, 0.00, NULL, NULL, NULL)
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 ('PLT000001062940', 'PLM000001056642', 'GOO000001061945', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 0, NULL, 500000, NULL, NULL, NULL, NULL, N'', '1', 'thuynt2', '2020-10-20 00:00:00.000', 'A', 'hoattm', '2020-10-20 00:00:00.000', NULL, NULL, 500000.00, NULL, NULL, NULL)
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 ('PLT000001062941', 'PLM000001056642', 'GOO000001061947', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 0, NULL, 0, NULL, NULL, NULL, NULL, N'', '1', 'thuynt2', '2020-10-20 00:00:00.000', 'A', 'hoattm', '2020-10-20 00:00:00.000', NULL, NULL, 0.00, NULL, NULL, NULL)
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 ('PLT000001062942', 'PLM000001056642', 'GOO000001061949', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 0, NULL, 0, NULL, NULL, NULL, NULL, N'', '1', 'thuynt2', '2020-10-20 00:00:00.000', 'A', 'hoattm', '2020-10-20 00:00:00.000', NULL, NULL, 0.00, NULL, NULL, NULL)
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 ('PLT000001062943', 'PLM000001056643', 'GOO000001061897', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 0, NULL, 19145455, NULL, NULL, NULL, NULL, N'', '1', 'thuynt2', '2020-10-20 00:00:00.000', 'A', 'hoattm', '2020-10-20 00:00:00.000', NULL, NULL, 19145454.55, NULL, NULL, NULL)
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 ('PLT000001062944', 'PLM000001056644', 'GOO000001061931', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 0, NULL, 7167211, NULL, NULL, NULL, NULL, N'', '1', 'thuynt2', '2020-10-20 00:00:00.000', 'A', 'hoattm', '2020-10-20 00:00:00.000', NULL, NULL, 7167210.61, NULL, NULL, NULL)
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 ('PLT000001062945', 'PLM000001056645', 'GOO000001061899', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 0, NULL, 90209858, NULL, NULL, NULL, NULL, N'', '1', 'thuynt2', '2020-10-20 00:00:00.000', 'A', 'hoattm', '2020-10-20 00:00:00.000', NULL, NULL, 90209858.19, NULL, NULL, NULL)
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 ('PLT000001062946', 'PLM000001056646', 'GOO000001061951', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 0, NULL, 38174774, NULL, NULL, NULL, NULL, N'', '1', 'thuynt2', '2020-10-20 00:00:00.000', 'A', 'hoattm', '2020-10-20 00:00:00.000', NULL, NULL, 38174774.19, NULL, NULL, NULL)
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 ('PLT000001062947', 'PLM000001056646', 'GOO000001061967', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 0, NULL, 41944444, NULL, NULL, NULL, NULL, N'', '1', 'thuynt2', '2020-10-20 00:00:00.000', 'A', 'hoattm', '2020-10-20 00:00:00.000', NULL, NULL, 41944444.44, NULL, NULL, NULL)
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 ('PLT000001062948', 'PLM000001056646', 'GOO000001061959', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 0, NULL, 11579500, NULL, NULL, NULL, NULL, N'', '1', 'thuynt2', '2020-10-20 00:00:00.000', 'A', 'hoattm', '2020-10-20 00:00:00.000', NULL, NULL, 11579500.00, NULL, NULL, NULL)
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 ('PLT000001062949', 'PLM000001056646', 'GOO000001061975', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 0, NULL, 45254268, NULL, NULL, NULL, NULL, N'', '1', 'thuynt2', '2020-10-20 00:00:00.000', 'A', 'hoattm', '2020-10-20 00:00:00.000', NULL, NULL, 45254267.68, NULL, NULL, NULL)
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 ('PLT000001062950', 'PLM000001056647', 'GOO000001061983', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 0, NULL, 0, NULL, NULL, NULL, NULL, N'', '1', 'thuynt2', '2020-10-20 00:00:00.000', 'A', 'hoattm', '2020-10-20 00:00:00.000', NULL, NULL, 0.00, NULL, NULL, NULL)
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 ('PLT000001062951', 'PLM000001056647', 'GOO000001061985', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 0, NULL, 0, NULL, NULL, NULL, NULL, N'', '1', 'thuynt2', '2020-10-20 00:00:00.000', 'A', 'hoattm', '2020-10-20 00:00:00.000', NULL, NULL, 0.00, NULL, NULL, NULL)
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 ('PLT000001062952', 'PLM000001056647', 'GOO000001061987', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 0, NULL, 540000000, NULL, NULL, NULL, NULL, N'', '1', 'thuynt2', '2020-10-20 00:00:00.000', 'A', 'hoattm', '2020-10-20 00:00:00.000', NULL, NULL, 540000000.00, NULL, NULL, NULL)
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 ('PLT000001062953', 'PLM000001056647', 'GOO000001061989', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 0, NULL, 0, NULL, NULL, NULL, NULL, N'', '1', 'thuynt2', '2020-10-20 00:00:00.000', 'A', 'hoattm', '2020-10-20 00:00:00.000', NULL, NULL, 0.00, NULL, NULL, NULL)
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 ('PLT000001062954', 'PLM000001056648', 'GOO000001061991', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 0, NULL, 0, NULL, NULL, NULL, NULL, N'', '1', 'thuynt2', '2020-10-20 00:00:00.000', 'A', 'hoattm', '2020-10-20 00:00:00.000', NULL, NULL, 0.00, NULL, NULL, NULL)
PRINT(N'Operation applied to 47 rows out of 47')
COMMIT TRANSACTION
GO