Project

General

Profile

Download (1.5 KB)

FILE 8.txt

Truong Nguyen Vu, 09/23/2020 01:36 PM

 
1 

    		
  

  

    
      2
    
    
      
INSERT INTO [CM_GOODS] ([GD_ID],[GD_CODE],[GD_NAME],[GD_TYPE_ID],[USE_BRANCH],[AMORT_RATE],[DESCRIPTION],[SUP_ID],[PRICE],[UNIT_ID],[NOTES],[RECORD_STATUS],[MAKER_ID],[CREATE_DT],[AUTH_STATUS],[CHECKER_ID],[APPROVE_DT])VALUES(N'GOOI001063274',N'DG.I.N.OE.0016',N'Bộ dịch vụ phát triển khách hàng lưu động - Sinh viên',N'NS',N'',NULL,N'',N'',NULL,N'',N'',N'1',N'admin',GETDATE(),N'A',N'admin',GETDATE())


    		
  

  

    
      3
    
    
      
INSERT INTO [CM_GOODS] ([GD_ID],[GD_CODE],[GD_NAME],[GD_TYPE_ID],[USE_BRANCH],[AMORT_RATE],[DESCRIPTION],[SUP_ID],[PRICE],[UNIT_ID],[NOTES],[RECORD_STATUS],[MAKER_ID],[CREATE_DT],[AUTH_STATUS],[CHECKER_ID],[APPROVE_DT])VALUES(N'GOOI001063275',N'DG.O.N.OE.0016',N'Bộ dịch vụ phát triển khách hàng lưu động - Sinh viên',N'NS',N'',NULL,N'',N'',NULL,N'',N'',N'1',N'admin',GETDATE(),N'A',N'admin',GETDATE())


    		
  

  

    
      4
    
    
      

    		
  

  

    
      5
    
    
      

    		
  

  

    
      6
    
    
      
INSERT INTO [PL_TRADEDETAIL] ([TRADE_ID],[PLAN_ID],[GOODS_ID],[GOODS_CODE],[GOODS_NAME],[GOODS_TYPE],[UNIT_ID],[M1],[M2],[M3],[M4],[M5],[M6],[M7],[M8],[AMT_ETM],[AMT_EXE],[AMT_APP],[QUANTITY_ETM],[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],[M9],[M10],[M11],[M12],[AMT_TF],[AMT_RECEIVE_TF])VALUES(N'PLTI000070096',N'PLM000000016935',N'GOOI001063274',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0,NULL,500000000,NULL,1,NULL,500000000,NULL,NULL,NULL,NULL,N'',N'1',N'admin',GETDATE(),N'A',N'admin',GETDATE(),NULL,NULL,NULL,NULL,0.00,0.00)