Project

General

Profile

Download (3.76 KB)

IMPORT PHAN BO CHI PHI.txt

Luc Tran Van, 05/09/2023 11:19 AM

 
1 

    		
  

  

    
      2
    
    
      
INSERT INTO ASS_COST_ALLOCATION (COS_ID, ASSET_ID, NOTE, TRN_DATE, RECORD_STATUS, AUTH_STATUS, MAKER_ID, CREATE_DT, EDITOR_ID, EDITOR_DT, CHECKER_ID, APPROVE_DT, BRANCH_CREATE, XML_TEMP, SECURE_01, SERCURE_01) VALUES


    		
  

  

    
      3
    
    
      
('ACACI000001008', 'ASS000000309645', NULL, CONVERT(DATETIME, '2023-05-09 10:02:12.000', 121), '1', 'A', 'vinhnt', CONVERT(DATETIME, '2023-05-09 10:02:12.000', 121), NULL, NULL, 'vinhnt',CONVERT(DATETIME, '2023-05-09 10:02:12.000', 121), 'DV0001', NULL, NULL, NULL)


    		
  

  

    
      4
    
    
      

    		
  

  

    
      5
    
    
      

    		
  

  

    
      6
    
    
      
INSERT INTO ASS_COST_ALLOC_DT (COSTDT_ID, COS_ID, BRANCH_ID, DEPT_ID, COST_AMOUNT, COST_RATE, COST_MONTH, COST_START_DATE, COST_END_DATE, COSTED_MONTH, COSTED_AMT, EXP_ACCTNO, NOTE, RECORD_STATUS, AUTH_STATUS, MAKER_ID, CREATE_DT, EDITOR_ID, EDITOR_DT, CHECKER_ID, APPROVE_DT) VALUES


    		
  

  

    
      7
    
    
      
('ALODT0000001075', 'ACACI000001008', 'BRN000000000033', '', 145000000, 23.95, 476.00, NULL, NULL, 0.00, 0, '', N'', '', 'A', 'bichnn0500', CONVERT(DATETIME, '2023-05-09 10:02:12.000', 121), NULL, NULL, NULL, NULL),


    		
  

  

    
      8
    
    
      
('ALODT0000001076', 'ACACI000001008', 'DV0001', 'DEP000000000068', 7626074, 1.26, 476.00, NULL, NULL, 0.00, 0, '', N'', '', 'A', 'bichnn0500', CONVERT(DATETIME, '2023-05-09 10:02:12.000', 121), NULL, NULL, NULL, NULL),


    		
  

  

    
      9
    
    
      
('ALODT0000001077', 'ACACI000001008', 'DV0001', 'DEP000000000027', 5017156, 0.83, 476.00, NULL, NULL, 0.00, 0, '', N'', '', 'A', 'bichnn0500', CONVERT(DATETIME, '2023-05-09 10:02:12.000', 121), NULL, NULL, NULL, NULL),


    		
  

  

    
      10
    
    
      
('ALODT0000001078', 'ACACI000001008', 'DV0001', 'DEP000000000071', 5017156, 0.83, 476.00, NULL, NULL, 0.00, 0, '', N'', '', 'A', 'bichnn0500', CONVERT(DATETIME, '2023-05-09 10:02:12.000', 121), NULL, NULL, NULL, NULL),


    		
  

  

    
      11
    
    
      
('ALODT0000001079', 'ACACI000001008', 'DV0001', 'DEP000000000089', 1505147, 0.25, 476.00, NULL, NULL, 0.00, 0, '', N'', '', 'A', 'bichnn0500', CONVERT(DATETIME, '2023-05-09 10:02:12.000', 121), NULL, NULL, NULL, NULL),


    		
  

  

    
      12
    
    
      
('ALODT0000001080', 'ACACI000001008', 'DV0001', 'DEP000000000086', 802745, 0.13, 476.00, NULL, NULL, 0.00, 0, '', N'', '', 'A', 'bichnn0500', CONVERT(DATETIME, '2023-05-09 10:02:12.000', 121), NULL, NULL, NULL, NULL),


    		
  

  

    
      13
    
    
      
('ALODT0000001081', 'ACACI000001008', 'DV0001', 'DEP000000000077', 5819900, 0.96, 476.00, NULL, NULL, 0.00, 0, '', N'', '', 'A', 'bichnn0500', CONVERT(DATETIME, '2023-05-09 10:02:12.000', 121), NULL, NULL, NULL, NULL),


    		
  

  

    
      14
    
    
      
('ALODT0000001082', 'ACACI000001008', 'DV0001', 'DEP000000000080', 1505147, 0.25, 476.00, NULL, NULL, 0.00, 0, '', N'', '', 'A', 'bichnn0500', CONVERT(DATETIME, '2023-05-09 10:02:12.000', 121), NULL, NULL, NULL, NULL),


    		
  

  

    
      15
    
    
      
('ALODT0000001083', 'ACACI000001008', 'DV0001', 'DEP000000000015', 2006862, 0.33, 476.00, NULL, NULL, 0.00, 0, '', N'', '', 'A', 'bichnn0500', CONVERT(DATETIME, '2023-05-09 10:02:12.000', 121), NULL, NULL, NULL, NULL),


    		
  

  

    
      16
    
    
      
('ALODT0000001084', 'ACACI000001008', 'DV0001', 'DEP000000000086', 3010293, 0.5, 476.00, NULL, NULL, 0.00, 0, '', N'', '', 'A', 'bichnn0500', CONVERT(DATETIME, '2023-05-09 10:02:12.000', 121), NULL, NULL, NULL, NULL),


    		
  

  

    
      17
    
    
      
('ALODT0000001085', 'ACACI000001008', 'DV0001', 'DEP000000000004', 5017156, 0.83, 476.00, NULL, NULL, 0.00, 0, '', N'', '', 'A', 'bichnn0500', CONVERT(DATETIME, '2023-05-09 10:02:12.000', 121), NULL, NULL, NULL, NULL),


    		
  

  

    
      18
    
    
      
('ALODT0000001086', 'ACACI000001008', 'DV0001', 'DEP000000000054', 17760731, 2.93, 476.00, NULL, NULL, 0.00, 0, '', N'', '', 'A', 'bichnn0500', CONVERT(DATETIME, '2023-05-09 10:02:12.000', 121), NULL, NULL, NULL, NULL),


    		
  

  

    
      19
    
    
      
('ALODT0000001087', 'ACACI000001008', 'DV0001', 'DEP000000000089', 35421118, 5.85, 476.00, NULL, NULL, 0.00, 0, '', N'', '', 'A', 'bichnn0500', CONVERT(DATETIME, '2023-05-09 10:02:12.000', 121), NULL, NULL, NULL, NULL),


    		
  

  

    
      20
    
    
      
('ALODT0000001088', 'ACACI000001008', 'BRN000000000053', '', 354211180, 58.5, 476.00, NULL, NULL, 0.00, 0, '', N'', '', 'A', 'bichnn0500', CONVERT(DATETIME, '2023-05-09 10:02:12.000', 121), NULL, NULL, NULL, NULL)


    		
  

  

    
      21