Project

General

Profile

Download (103 KB)

FILE 4 - UPDATE PL-TRADE.txt

Truong Nguyen Vu, 10/20/2020 02:20 PM

 
1 
??/*
2 
Run this script on:
3
4 
TRUONGNV.gAMSPro_VietcapitalBank_LOCAL    -  This database will be modified
5
6 
to synchronize it with:
7
8 
118.69.72.241,5036.gAMSPro_VietcapitalBank_v2
9
10 
You are recommended to back up your database before running this script
11
12 
Script created by SQL Data Compare version 13.7.7.10021 from Red Gate Software Ltd at 20-Oct-20 2:19:53 PM
13
14 
*/
15
16 
SET NUMERIC_ROUNDABORT OFF
17 
GO
18 
SET ANSI_PADDING, ANSI_WARNINGS, CONCAT_NULL_YIELDS_NULL, ARITHABORT, QUOTED_IDENTIFIER, ANSI_NULLS, NOCOUNT ON
19 
GO
20 
SET DATEFORMAT YMD
21 
GO
22 
SET XACT_ABORT ON
23 
GO
24 
SET TRANSACTION ISOLATION LEVEL Serializable
25 
GO
26 
BEGIN TRANSACTION
27
28 
PRINT(N'Update row in [dbo].[PL_IMPORT]')
29 
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'
30
31 
PRINT(N'Add rows to [dbo].[PL_MASTER]')
32 
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)
33 
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')
34 
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')
35 
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')
36 
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')
37 
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')
38 
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')
39 
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')
40 
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')
41 
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)
42 
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')
43 
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')
44 
PRINT(N'Operation applied to 12 rows out of 12')
45
46 
PRINT(N'Add rows to [dbo].[PL_TRADE_REF]')
47 
SET IDENTITY_INSERT [dbo].[PL_TRADE_REF] ON
48 
INSERT INTO [dbo].[PL_TRADE_REF] ([REF_ID], [TRADE_ID], [REF_CODE], [REF_NAME]) VALUES (124727, 'PLT000001062908', '0750001', N'THANH HOA')
49 
INSERT INTO [dbo].[PL_TRADE_REF] ([REF_ID], [TRADE_ID], [REF_CODE], [REF_NAME]) VALUES (124728, 'PLT000001062909', '0750001', N'THANH HOA')
50 
INSERT INTO [dbo].[PL_TRADE_REF] ([REF_ID], [TRADE_ID], [REF_CODE], [REF_NAME]) VALUES (124729, 'PLT000001062910', '0750001', N'THANH HOA')
51 
INSERT INTO [dbo].[PL_TRADE_REF] ([REF_ID], [TRADE_ID], [REF_CODE], [REF_NAME]) VALUES (124730, 'PLT000001062911', '0750001', N'THANH HOA')
52 
INSERT INTO [dbo].[PL_TRADE_REF] ([REF_ID], [TRADE_ID], [REF_CODE], [REF_NAME]) VALUES (124731, 'PLT000001062912', '0750001', N'THANH HOA')
53 
INSERT INTO [dbo].[PL_TRADE_REF] ([REF_ID], [TRADE_ID], [REF_CODE], [REF_NAME]) VALUES (124732, 'PLT000001062913', '0750001', N'THANH HOA')
54 
INSERT INTO [dbo].[PL_TRADE_REF] ([REF_ID], [TRADE_ID], [REF_CODE], [REF_NAME]) VALUES (124733, 'PLT000001062914', '0750001', N'THANH HOA')
55 
INSERT INTO [dbo].[PL_TRADE_REF] ([REF_ID], [TRADE_ID], [REF_CODE], [REF_NAME]) VALUES (124734, 'PLT000001062915', '0750001', N'THANH HOA')
56 
INSERT INTO [dbo].[PL_TRADE_REF] ([REF_ID], [TRADE_ID], [REF_CODE], [REF_NAME]) VALUES (124735, 'PLT000001062916', '0750001', N'THANH HOA')
57 
INSERT INTO [dbo].[PL_TRADE_REF] ([REF_ID], [TRADE_ID], [REF_CODE], [REF_NAME]) VALUES (124736, 'PLT000001062917', '0750001', N'THANH HOA')
58 
INSERT INTO [dbo].[PL_TRADE_REF] ([REF_ID], [TRADE_ID], [REF_CODE], [REF_NAME]) VALUES (124737, 'PLT000001062918', '0750001', N'THANH HOA')
59 
INSERT INTO [dbo].[PL_TRADE_REF] ([REF_ID], [TRADE_ID], [REF_CODE], [REF_NAME]) VALUES (124738, 'PLT000001062919', '0750001', N'THANH HOA')
60 
INSERT INTO [dbo].[PL_TRADE_REF] ([REF_ID], [TRADE_ID], [REF_CODE], [REF_NAME]) VALUES (124739, 'PLT000001062920', '0750001', N'THANH HOA')
61 
INSERT INTO [dbo].[PL_TRADE_REF] ([REF_ID], [TRADE_ID], [REF_CODE], [REF_NAME]) VALUES (124740, 'PLT000001062921', '0750001', N'THANH HOA')
62 
INSERT INTO [dbo].[PL_TRADE_REF] ([REF_ID], [TRADE_ID], [REF_CODE], [REF_NAME]) VALUES (124741, 'PLT000001062922', '0750001', N'THANH HOA')
63 
INSERT INTO [dbo].[PL_TRADE_REF] ([REF_ID], [TRADE_ID], [REF_CODE], [REF_NAME]) VALUES (124742, 'PLT000001062923', '0750001', N'THANH HOA')
64 
INSERT INTO [dbo].[PL_TRADE_REF] ([REF_ID], [TRADE_ID], [REF_CODE], [REF_NAME]) VALUES (124743, 'PLT000001062924', '0750001', N'THANH HOA')
65 
INSERT INTO [dbo].[PL_TRADE_REF] ([REF_ID], [TRADE_ID], [REF_CODE], [REF_NAME]) VALUES (124744, 'PLT000001062925', '0750001', N'THANH HOA')
66 
INSERT INTO [dbo].[PL_TRADE_REF] ([REF_ID], [TRADE_ID], [REF_CODE], [REF_NAME]) VALUES (124745, 'PLT000001062926', '0750001', N'THANH HOA')
67 
INSERT INTO [dbo].[PL_TRADE_REF] ([REF_ID], [TRADE_ID], [REF_CODE], [REF_NAME]) VALUES (124746, 'PLT000001062927', '0750001', N'THANH HOA')
68 
INSERT INTO [dbo].[PL_TRADE_REF] ([REF_ID], [TRADE_ID], [REF_CODE], [REF_NAME]) VALUES (124747, 'PLT000001062928', '0750001', N'THANH HOA')
69 
INSERT INTO [dbo].[PL_TRADE_REF] ([REF_ID], [TRADE_ID], [REF_CODE], [REF_NAME]) VALUES (124748, 'PLT000001062929', '0750001', N'THANH HOA')
70 
INSERT INTO [dbo].[PL_TRADE_REF] ([REF_ID], [TRADE_ID], [REF_CODE], [REF_NAME]) VALUES (124749, 'PLT000001062930', '0750001', N'THANH HOA')
71 
INSERT INTO [dbo].[PL_TRADE_REF] ([REF_ID], [TRADE_ID], [REF_CODE], [REF_NAME]) VALUES (124750, 'PLT000001062931', '0750001', N'THANH HOA')
72 
INSERT INTO [dbo].[PL_TRADE_REF] ([REF_ID], [TRADE_ID], [REF_CODE], [REF_NAME]) VALUES (124751, 'PLT000001062932', '0750001', N'THANH HOA')
73 
INSERT INTO [dbo].[PL_TRADE_REF] ([REF_ID], [TRADE_ID], [REF_CODE], [REF_NAME]) VALUES (124752, 'PLT000001062933', '0750001', N'THANH HOA')
74 
INSERT INTO [dbo].[PL_TRADE_REF] ([REF_ID], [TRADE_ID], [REF_CODE], [REF_NAME]) VALUES (124753, 'PLT000001062934', '0750001', N'THANH HOA')
75 
INSERT INTO [dbo].[PL_TRADE_REF] ([REF_ID], [TRADE_ID], [REF_CODE], [REF_NAME]) VALUES (124754, 'PLT000001062935', '0750001', N'THANH HOA')
76 
INSERT INTO [dbo].[PL_TRADE_REF] ([REF_ID], [TRADE_ID], [REF_CODE], [REF_NAME]) VALUES (124755, 'PLT000001062936', '0750001', N'THANH HOA')
77 
INSERT INTO [dbo].[PL_TRADE_REF] ([REF_ID], [TRADE_ID], [REF_CODE], [REF_NAME]) VALUES (124756, 'PLT000001062937', '0750001', N'THANH HOA')
78 
INSERT INTO [dbo].[PL_TRADE_REF] ([REF_ID], [TRADE_ID], [REF_CODE], [REF_NAME]) VALUES (124757, 'PLT000001062938', '0750001', N'THANH HOA')
79 
INSERT INTO [dbo].[PL_TRADE_REF] ([REF_ID], [TRADE_ID], [REF_CODE], [REF_NAME]) VALUES (124758, 'PLT000001062939', '0750001', N'THANH HOA')
80 
INSERT INTO [dbo].[PL_TRADE_REF] ([REF_ID], [TRADE_ID], [REF_CODE], [REF_NAME]) VALUES (124759, 'PLT000001062940', '0750001', N'THANH HOA')
81 
INSERT INTO [dbo].[PL_TRADE_REF] ([REF_ID], [TRADE_ID], [REF_CODE], [REF_NAME]) VALUES (124760, 'PLT000001062941', '0750001', N'THANH HOA')
82 
INSERT INTO [dbo].[PL_TRADE_REF] ([REF_ID], [TRADE_ID], [REF_CODE], [REF_NAME]) VALUES (124761, 'PLT000001062942', '0750001', N'THANH HOA')
83 
INSERT INTO [dbo].[PL_TRADE_REF] ([REF_ID], [TRADE_ID], [REF_CODE], [REF_NAME]) VALUES (124762, 'PLT000001062943', '0750001', N'THANH HOA')
84 
INSERT INTO [dbo].[PL_TRADE_REF] ([REF_ID], [TRADE_ID], [REF_CODE], [REF_NAME]) VALUES (124763, 'PLT000001062944', '0750001', N'THANH HOA')
85 
INSERT INTO [dbo].[PL_TRADE_REF] ([REF_ID], [TRADE_ID], [REF_CODE], [REF_NAME]) VALUES (124764, 'PLT000001062945', '0750001', N'THANH HOA')
86 
INSERT INTO [dbo].[PL_TRADE_REF] ([REF_ID], [TRADE_ID], [REF_CODE], [REF_NAME]) VALUES (124765, 'PLT000001062946', '0750001', N'THANH HOA')
87 
INSERT INTO [dbo].[PL_TRADE_REF] ([REF_ID], [TRADE_ID], [REF_CODE], [REF_NAME]) VALUES (124766, 'PLT000001062947', '0750001', N'THANH HOA')
88 
INSERT INTO [dbo].[PL_TRADE_REF] ([REF_ID], [TRADE_ID], [REF_CODE], [REF_NAME]) VALUES (124767, 'PLT000001062948', '0750001', N'THANH HOA')
89 
INSERT INTO [dbo].[PL_TRADE_REF] ([REF_ID], [TRADE_ID], [REF_CODE], [REF_NAME]) VALUES (124768, 'PLT000001062949', '0750001', N'THANH HOA')
90 
INSERT INTO [dbo].[PL_TRADE_REF] ([REF_ID], [TRADE_ID], [REF_CODE], [REF_NAME]) VALUES (124769, 'PLT000001062950', '0750001', N'THANH HOA')
91 
INSERT INTO [dbo].[PL_TRADE_REF] ([REF_ID], [TRADE_ID], [REF_CODE], [REF_NAME]) VALUES (124770, 'PLT000001062951', '0750001', N'THANH HOA')
92 
INSERT INTO [dbo].[PL_TRADE_REF] ([REF_ID], [TRADE_ID], [REF_CODE], [REF_NAME]) VALUES (124771, 'PLT000001062952', '0750001', N'THANH HOA')
93 
INSERT INTO [dbo].[PL_TRADE_REF] ([REF_ID], [TRADE_ID], [REF_CODE], [REF_NAME]) VALUES (124772, 'PLT000001062953', '0750001', N'THANH HOA')
94 
INSERT INTO [dbo].[PL_TRADE_REF] ([REF_ID], [TRADE_ID], [REF_CODE], [REF_NAME]) VALUES (124773, 'PLT000001062954', '0750001', N'THANH HOA')
95 
SET IDENTITY_INSERT [dbo].[PL_TRADE_REF] OFF
96 
PRINT(N'Operation applied to 47 rows out of 47')
97
98 
PRINT(N'Add rows to [dbo].[PL_TRADEDETAIL]')
99 
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)
100 
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)
101 
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)
102 
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)
103 
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)
104 
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)
105 
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)
106 
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)
107 
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)
108 
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)
109 
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)
110 
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)
111 
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)
112 
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)
113 
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)
114 
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)
115 
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)
116 
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)
117 
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)
118 
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)
119 
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)
120 
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)
121 
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)
122 
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)
123 
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)
124 
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)
125 
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)
126 
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)
127 
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)
128 
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)
129 
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)
130 
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)
131 
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)
132 
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)
133 
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)
134 
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)
135 
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)
136 
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)
137 
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)
138 
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)
139 
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)
140 
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)
141 
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)
142 
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)
143 
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)
144 
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)
145 
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)
146 
PRINT(N'Operation applied to 47 rows out of 47')
147 
COMMIT TRANSACTION
148 
GO
149