EOFFICE - GD4

INSERT TR_CONTRACT(CONTRACT_ID, CONTRACT_CODE, CONTRACT_NAME, CONTRACT_TYPE, BID_ID, SUP_ID, TOTAL_AMT, DELIVERY_DT, FORM1, VOUCHER_ID1, BANK1, AMOUNT1, EXP_DT1, RATE1, FORM2, VOUCHER_ID2, BANK2, AMOUNT2, EXP_DT2, RATE2, REQ_DOC_ID, REQ_DOC_CONTENT, APPROVE_VALUE, SIGN_DT, CONSTRUCT_PROGRESS, START_DT, END_DT, NOTES, RECORD_STATUS, MAKER_ID, CREATE_DT, AUTH_STATUS, CHECKER_ID, APPROVE_DT, IS_PARENT, REQUEST_ID, CONTRACT_PARENT, CUST_ID, IS_CLOSED, BRANCH_ID, CONT_TYPE, EXP_CONTRACT, DEPOSIT_AMT, TYPE_PERIOD, DEPOSIT_NOTE, IS_SEND_APPR, SEND_APPR_DT, ADDRESS) VALUES (N'TEST07062025', N'TEST07062025', N'HỢP ĐỒNG NGUYÊN TẮC CUNG CẤP VPP, NHU YẾU PHẨM', '1', '', '', 22000, NULL, NULL, NULL, NULL, 0, NULL, NULL, NULL, NULL, NULL, 0, NULL, NULL, NULL, NULL, 0, '2020-06-01 00:00:00.000', 0, '2020-06-01 00:00:00.000', '2022-05-31 00:00:00.000', N'', '1', 'xuanpt', '2020-08-18 10:05:45.000', 'A', 'thuongvc', '2020-10-06 14:43:43.000', NULL, NULL, NULL, NULL, NULL, 'BRN000000000401', 'NT', NULL, NULL, 'M', NULL, NULL, NULL, NULL)

INSERT TR_CONTRACT_DT(CD_ID, CONTRACT_ID, GOODS_ID, HH_DT_ID, UNIT_ID, QUANTITY, PRICE, TOTAL_VAT, PRICE_VAT, VAT, NOTES, RECORD_STATUS, MAKER_ID, CREATE_DT, AUTH_STATUS, CHECKER_ID, APPROVE_DT, GD_NAME_REAL, QUANTITY_USE, RECURRING, UNIT_NAME_REAL, RENT_PRICE, BUILDING_ID, REQ_DOC_ID) VALUES (N'DTTEST07062025', 'TEST07062025', 'HH0000000112216', 'PB0000000000002', '', 2, 10000.00, 2000.00, 1000.00, 10.00, N'', 'U', 'xuanpt', '2020-08-18 10:05:45.000', 'A', NULL, NULL, N'Vật tư, vật liệu khác', NULL, '', N'', NULL, NULL, NULL)