Project

General

Profile

Download (2.37 KB)

DATA_5.txt

Luc Tran Van, 04/21/2022 03:37 PM

 
1 
INSERT INTO [TR_REQUEST_DOC] ([REQ_ID],[REQ_CODE],[REQ_NAME],[REQ_DT],[REQ_TYPE],[REQ_CONTENT],[PROCESS_ID],[PL_REQ_ID],[TOTAL_AMT],[NOTES],[RECORD_STATUS],[MAKER_ID],[CREATE_DT],[AUTH_STATUS],[CHECKER_ID],[APPROVE_DT],[BRANCH_DO],[REQ_REASON],[BRANCH_CREATE],[USER_REQUEST],[BRANCH_DVMS],[USER_DVMS],[DMMS_ID],[DEP_CREATE],[REQ_PARENT_ID],[SIGN_USER],[IS_KT])VALUES(N'TRRD00000005268',N'PUR/2022/000686',NULL,N'Apr 21 2022 12:00AM',NULL,NULL,N'',N'PLRD00000203630',4679000000,NULL,N'1',N'baotq',N'Apr 21 2022  3:26PM',N'E',NULL,NULL,NULL,N'Chi thưởng Bancassurance dành cho lãnh đạo và trưởng phòng tại ĐVKD hàng tháng',N'DV0001',N'baotq',N'DV0001',NULL,NULL,N'DEP000000000028',NULL,NULL,NULL)
2 

    		
  

  

    
      3
    
    
      

    		
  

  

    
      4
    
    
      
INSERT INTO [TR_REQUEST_DOC_DT] ([REQDT_ID],[REQ_DOC_ID],[PL_REQDT_ID],[GD_ID],[SUP_ID],[DESCRIPTION],[TRAN_TYPE_ID],[QUANTITY],[PRICE],[TOTAL_AMT],[AMOUNT_PAID],[INVOICENO],[NOTES],[HANGHOA_ID],[NOTE_DVMS],[RECORD_STATUS],[MAKER_ID],[CREATE_DT],[AUTH_STATUS],[CHECKER_ID],[APPROVE_DT],[PRICE_ETM],[TOTAL_AMT_ETM],[REQ_DT],[AMORT_MONTH],[CURRENCY],[EXCHANGE_RATE],[TAXES],[DVDM_ID],[BID_ID],[OFFERING_VALUE],[PO_ID],[PO_AMT],[REQPL_DT_ID],[UNIT_NAME])VALUES(N'TRRDD0000006071',N'TRRD00000005268',N'PLRDD0000236525',N'',N'',N'theo tờ trình đính kèm',NULL,1,4679000000.00,4679000000.00,NULL,NULL,N'',N'HH0000000112299',NULL,N'1',N'baotq',N'Apr 21 2022  3:26PM',N'U',NULL,NULL,4679000000.00,4679000000.00,N'Apr 22 2022 12:00AM',NULL,N'VND',1.00,0.00,N'',NULL,NULL,NULL,NULL,N'TRPLD0000106260',N'chương trình')


    		
  

  

    
      5
    
    
      

    		
  

  

    
      6
    
    
      
INSERT INTO [TR_REQUEST_DOC_PL_DT] ([REQPL_DT_ID],[REQ_DOC_ID],[PL_REQDT_ID],[GD_ID],[SUP_ID],[HH_ID],[TRAN_TYPE_ID],[MAKER_ID],[CREATE_DT],[AUTH_STATUS],[CHECKER_ID],[APPROVE_DT],[DES_GOOD],[QUANTITY_PL],[PRICE_PL],[CURRENCY],[EXCHANGE_RATE],[TAXES],[TOTAL_AMT_ETM],[REASON_CDT],[REQ_DT],[NOTES],[RECORD_STATUS])VALUES(N'TRPLD0000106260',N'TRRD00000005268',N'PLRDD0000236525',N'GOO000000254542',N'',N'HH0000000112299',N'',N'baotq',N'Apr 21 2022  3:26PM',N'U',NULL,NULL,N'theo tờ trình đính kèm',1,4679000000.00,N'VND',1.00,0.00,4679000000.00,N'',NULL,N'',N'1')


    		
  

  

    
      7
    
    
      

    		
  

  

    
      8
    
    
      
INSERT INTO [PL_REQUEST_PROCESS] ([ID],[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(1246,N'TRRD00000005268',N'NEW',N'C',N'',N'',N'',NULL,N'',N'N',N'',N'',N'Chờ gửi phê duyệt',NULL,NULL)