|
1
|
INSERT INTO [PL_REQUEST_DOC] ([REQ_ID],[REQ_CODE],[REQ_NAME],[REQ_DT],[REQ_TYPE],[REQ_CONTENT],[REQ_REASON],[BRANCH_ID],[TOTAL_AMT],[NOTES],[RECORD_STATUS],[MAKER_ID],[CREATE_DT],[AUTH_STATUS],[CHECKER_ID],[APPROVE_DT],[PROCESS_ID],[DVDM_APP_ID],[REQ_PARENT_ID],[BRANCH_FEE],[EFFEC_DT],[IS_BACKDAY],[DEP_ID],[DEP_FEE],[BRANCH_CREATE],[DEP_CREATE],[REQ_LINE],[TC_NOTES],[SIGN_USER],[KT_NOTES],[IS_CHECKALL],[BASED_CONTENT],[IS_SETTLMENT],[PL_BASED_ID])VALUES(N'PLRDI0001056505',N'08A/2018/TTr-VP.HĐQT',N'Phục vụ cho việc tăng vốn điều lệ thông qua việc phát hành cổ phiếu và niêm yết cổ phiếu trên sàn Upcom',N'Aug 22 2018 12:00AM',NULL,N'Phục vụ cho việc tăng vốn điều lệ thông qua việc phát hành cổ phiếu và niêm yết cổ phiếu trên sàn Upcom',N'Phục vụ cho việc tăng vốn điều lệ thông qua việc phát hành cổ phiếu và niêm yết cổ phiếu trên sàn Upcom',N'DV0001',440000000,NULL,N'1',N'trangldp',N'Aug 22 2018 12:00AM',N'A',NULL,N'Aug 27 2018 12:00AM',N'APPROVE',NULL,NULL,N'DV0001',N'Aug 27 2018 12:00AM',NULL,NULL,NULL,N'DV0001',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL)
|
|
2
|
INSERT INTO [PL_REQUEST_DOC_DT] ([REQDT_ID],[REQ_ID],[PLAN_ID],[TRADE_ID],[GOODS_ID],[NAME],[DESCRIPTION],[REQDT_TYPE],[UNIT_ID],[QUANTITY],[PRICE],[TOTAL_AMT],[RECORD_STATUS],[MAKER_ID],[CREATE_DT],[AUTH_STATUS],[CHECKER_ID],[APPROVE_DT],[DVDM_ID],[HANGHOA_ID],[CURRENCY],[EXCHANGE_RATE],[TAXES],[SUP_ID],[TRADE_TYPE],[KHOI_ID],[UNIT_NAME])VALUES(N'PLRDDI001058253',N'PLRDI0001056505',NULL,NULL,N'GOO000001064649',NULL,NULL,N'I',N'CMU000000000051',1,440000000.00,440000000.00,N'1',NULL,NULL,N'A',NULL,NULL,N'DM0000000000005',N'HH0000000112257',N'VND',1.00,0.00,NULL,N'VCCB',NULL,N'gói')
|
|
3
|
INSERT INTO [TR_REQUEST_DOC] ([REQ_ID],[REQ_CODE],[REQ_NAME],[REQ_DT],[REQ_TYPE],[REQ_REASON],[REQ_CONTENT],[PL_REQ_ID],[TOTAL_AMT],[NOTES],[RECORD_STATUS],[MAKER_ID],[CREATE_DT],[AUTH_STATUS],[CHECKER_ID],[APPROVE_DT],[BRANCH_DO],[PROCESS_ID],[BRANCH_CREATE],[USER_REQUEST],[BRANCH_DVMS],[USER_DVMS],[DMMS_ID],[DEP_CREATE],[REQ_PARENT_ID],[SIGN_USER])VALUES(N'TRRDI0001056607',N'PUR/2018/00007070',NULL,N'Aug 22 2018 12:00AM',NULL,N'Phục vụ cho việc tăng vốn điều lệ thông qua việc phát hành cổ phiếu và niêm yết cổ phiếu trên sàn Upcom',N'',N'PLRDI0001056505',440000000,N'',N'1',N'trangldp',N'Aug 22 2018 12:00AM',N'A',N'hungnm2',N'Aug 27 2018 12:00AM',N'',N'APPROVE',N'',N'trangldp',N'',N'phuongvn',N'DMMS00000000001',N'',N'',N'')
|
|
4
|
INSERT INTO [TR_REQUEST_DOC_DT] ([REQDT_ID],[REQ_DOC_ID],[PL_REQDT_ID],[GD_ID],[SUP_ID],[TRAN_TYPE_ID],[DESCRIPTION],[QUANTITY],[PRICE],[PRICE_ETM],[TOTAL_AMT],[TOTAL_AMT_ETM],[AMOUNT_PAID],[INVOICENO],[REQ_DT],[AMORT_MONTH],[NOTES],[RECORD_STATUS],[MAKER_ID],[CREATE_DT],[AUTH_STATUS],[CHECKER_ID],[APPROVE_DT],[HANGHOA_ID],[CURRENCY],[EXCHANGE_RATE],[TAXES],[DVDM_ID],[BID_ID],[OFFERING_VALUE],[NOTE_DVMS],[PO_ID],[PO_AMT])VALUES(N'TRRDD0001057560',N'TRRDI0001056607',N'PLRDDI001058253',N'GOO000001064649',NULL,N'CD',NULL,1,440000000.00,NULL,440000000.00,NULL,NULL,N'',N'Aug 22 2018 12:00AM',NULL,N'',N'1',N'trangldp',N'Aug 22 2018 12:00AM',N'A',N'hungnm2',N'Aug 27 2018 12:00AM',N'HH0000000112257',N'VND',1.00,0.00,N'DM0000000000005',N'',NULL,NULL,NULL,NULL)
|
|
5
|
INSERT INTO [PL_REQUEST_PROCESS] ([REQ_ID],[PROCESS_ID],[STATUS],[ROLE_USER],[BRANCH_ID],[CHECKER_ID],[APPROVE_DT],[PARENT_PROCESS_ID],[IS_LEAF],[COST_ID],[DVDM_ID],[NOTES],[IS_HAS_CHILD],[DEP_ID])VALUES(N'TRRDI0001056607',N'DMMS',N'P',N'GDDV',N'',N'phuongtln1',N'Aug 27 2018 12:00AM',N'',N'',N'',N'',N'',1,N'')
|
|
6
|
INSERT INTO [PL_REQUEST_PROCESS] ([REQ_ID],[PROCESS_ID],[STATUS],[ROLE_USER],[BRANCH_ID],[CHECKER_ID],[APPROVE_DT],[PARENT_PROCESS_ID],[IS_LEAF],[COST_ID],[DVDM_ID],[NOTES],[IS_HAS_CHILD],[DEP_ID])VALUES(N'TRRDI0001056607',N'APPROVE',N'C',N'',N'',N'',N'Aug 31 2020 10:18AM',N'DMMS',N'',N'',N'',N'',NULL,N'')
|
|
7
|
INSERT INTO [PL_REQUEST_PROCESS_CHILD] ([REQ_ID],[PROCESS_ID],[TLNAME],[TYPE_JOB],[LEVEL_JOB],[STATUS_JOB],[RECORD_STATUS],[MAKER_ID],[TRANFER_DT])VALUES(N'TRRDI0001056607',N'6',N'phuongtln1',N'TP',1,N'P',N'1',N'',N'Aug 31 2020 10:18AM')
|
|
8
|
INSERT INTO [PL_REQUEST_PROCESS_CHILD] ([REQ_ID],[PROCESS_ID],[TLNAME],[TYPE_JOB],[LEVEL_JOB],[STATUS_JOB],[RECORD_STATUS],[MAKER_ID],[TRANFER_DT])VALUES(N'TRRDI0001056607',N'6',N'phuongvn',N'XL',2,N'P',N'1',N'',N'Aug 31 2020 10:18AM')
|