Project

General

Profile

Download (12.9 KB)

import_data_TR_REQ_PAY_AUTO_CUSTOMER.txt

Luc Tran Van, 02/25/2023 10:50 AM

 
1 
delete from TR_REQ_PAY_AUTO_CUSTOMER
2 
INSERT INTO [dbo].[TR_REQ_PAY_AUTO_CUSTOMER]([REQ_PAY_AUTO_CUSTOMER_ID],[BILLCODE],[BILLALIAS],[SEVCODE],[SEVNAME],[PRVCODE],[PRVNAME],[ROUTETO],[TRANSACCOUNT],[TRANSACCOUNT_NAME],[TRANS_GLCODE],[TRANS_GLNAME],[RECEIVE_GLCODE],[RECEIVE_GLNAME],[CUSTOMER_CODE],[CUSTOMER_NAME],[MAKER_ID],[CREATE_DT],[RECORD_STATUS])
3 
VALUES('TRPAC0000000001','PK01000083765','NGUYEN HONG VAN','SEV007',N'Hóa đơn điện','PRV013',N'Điện lực toàn quốc','AMS','','','','','','','00025464',N'Trần Quyên','admin',GETDATE(),'1')
4 
INSERT INTO [dbo].[TR_REQ_PAY_AUTO_CUSTOMER]([REQ_PAY_AUTO_CUSTOMER_ID],[BILLCODE],[BILLALIAS],[SEVCODE],[SEVNAME],[PRVCODE],[PRVNAME],[ROUTETO],[TRANSACCOUNT],[TRANSACCOUNT_NAME],[TRANS_GLCODE],[TRANS_GLNAME],[RECEIVE_GLCODE],[RECEIVE_GLNAME],[CUSTOMER_CODE],[CUSTOMER_NAME],[MAKER_ID],[CREATE_DT],[RECORD_STATUS])
5 
VALUES('TRPAC0000000002','PK01000048450','NGUYEN PHUONG MAI','SEV007',N'Hóa đơn điện','PRV013',N'Điện lực toàn quốc','AMS','','','','','','','00025464',N'Trần Quyên','admin',GETDATE(),'1')
6 
INSERT INTO [dbo].[TR_REQ_PAY_AUTO_CUSTOMER]([REQ_PAY_AUTO_CUSTOMER_ID],[BILLCODE],[BILLALIAS],[SEVCODE],[SEVNAME],[PRVCODE],[PRVNAME],[ROUTETO],[TRANSACCOUNT],[TRANSACCOUNT_NAME],[TRANS_GLCODE],[TRANS_GLNAME],[RECEIVE_GLCODE],[RECEIVE_GLNAME],[CUSTOMER_CODE],[CUSTOMER_NAME],[MAKER_ID],[CREATE_DT],[RECORD_STATUS])
7 
VALUES('TRPAC0000000003','PK01000048449','TRAN LIEN HUONG','SEV007',N'Hóa đơn điện','PRV013',N'Điện lực toàn quốc','AMS','','','','','','','00025464',N'Trần Quyên','admin',GETDATE(),'1')
8 
INSERT INTO [dbo].[TR_REQ_PAY_AUTO_CUSTOMER]([REQ_PAY_AUTO_CUSTOMER_ID],[BILLCODE],[BILLALIAS],[SEVCODE],[SEVNAME],[PRVCODE],[PRVNAME],[ROUTETO],[TRANSACCOUNT],[TRANSACCOUNT_NAME],[TRANS_GLCODE],[TRANS_GLNAME],[RECEIVE_GLCODE],[RECEIVE_GLNAME],[CUSTOMER_CODE],[CUSTOMER_NAME],[MAKER_ID],[CREATE_DT],[RECORD_STATUS])
9 
VALUES('TRPAC0000000004','PK01000048448','TA THI TRUONG GIANG','SEV007',N'Hóa đơn điện','PRV013',N'Điện lực toàn quốc','AMS','','','','','','','00025464',N'Trần Quyên','admin',GETDATE(),'1')
10 
INSERT INTO [dbo].[TR_REQ_PAY_AUTO_CUSTOMER]([REQ_PAY_AUTO_CUSTOMER_ID],[BILLCODE],[BILLALIAS],[SEVCODE],[SEVNAME],[PRVCODE],[PRVNAME],[ROUTETO],[TRANSACCOUNT],[TRANSACCOUNT_NAME],[TRANS_GLCODE],[TRANS_GLNAME],[RECEIVE_GLCODE],[RECEIVE_GLNAME],[CUSTOMER_CODE],[CUSTOMER_NAME],[MAKER_ID],[CREATE_DT],[RECORD_STATUS])
11 
VALUES('TRPAC0000000005','PK01000048447','NGUYEN THI MINH TAM','SEV007',N'Hóa đơn điện','PRV013',N'Điện lực toàn quốc','AMS','','','','','','','00025464',N'Trần Quyên','admin',GETDATE(),'1')
12 
INSERT INTO [dbo].[TR_REQ_PAY_AUTO_CUSTOMER]([REQ_PAY_AUTO_CUSTOMER_ID],[BILLCODE],[BILLALIAS],[SEVCODE],[SEVNAME],[PRVCODE],[PRVNAME],[ROUTETO],[TRANSACCOUNT],[TRANSACCOUNT_NAME],[TRANS_GLCODE],[TRANS_GLNAME],[RECEIVE_GLCODE],[RECEIVE_GLNAME],[CUSTOMER_CODE],[CUSTOMER_NAME],[MAKER_ID],[CREATE_DT],[RECORD_STATUS])
13 
VALUES('TRPAC0000000006','PK10000071949','LUU VAN QUY','SEV007',N'Hóa đơn điện','PRV013',N'Điện lực toàn quốc','AMS','','','','','','','00025464',N'Trần Quyên','admin',GETDATE(),'1')
14 
INSERT INTO [dbo].[TR_REQ_PAY_AUTO_CUSTOMER]([REQ_PAY_AUTO_CUSTOMER_ID],[BILLCODE],[BILLALIAS],[SEVCODE],[SEVNAME],[PRVCODE],[PRVNAME],[ROUTETO],[TRANSACCOUNT],[TRANSACCOUNT_NAME],[TRANS_GLCODE],[TRANS_GLNAME],[RECEIVE_GLCODE],[RECEIVE_GLNAME],[CUSTOMER_CODE],[CUSTOMER_NAME],[MAKER_ID],[CREATE_DT],[RECORD_STATUS])
15 
VALUES('TRPAC0000000007','PK11000060742','NGUYEN KIM DUNG','SEV007',N'Hóa đơn điện','PRV013',N'Điện lực toàn quốc','AMS','','','','','','','00025464',N'Trần Quyên','admin',GETDATE(),'1')
16 
INSERT INTO [dbo].[TR_REQ_PAY_AUTO_CUSTOMER]([REQ_PAY_AUTO_CUSTOMER_ID],[BILLCODE],[BILLALIAS],[SEVCODE],[SEVNAME],[PRVCODE],[PRVNAME],[ROUTETO],[TRANSACCOUNT],[TRANSACCOUNT_NAME],[TRANS_GLCODE],[TRANS_GLNAME],[RECEIVE_GLCODE],[RECEIVE_GLNAME],[CUSTOMER_CODE],[CUSTOMER_NAME],[MAKER_ID],[CREATE_DT],[RECORD_STATUS])
17 
VALUES('TRPAC0000000008','PK07000140624','NGUYEN VAN KHOET','SEV007',N'Hóa đơn điện','PRV013',N'Điện lực toàn quốc','AMS','','','','','','','00025464',N'Trần Quyên','admin',GETDATE(),'1')
18 
INSERT INTO [dbo].[TR_REQ_PAY_AUTO_CUSTOMER]([REQ_PAY_AUTO_CUSTOMER_ID],[BILLCODE],[BILLALIAS],[SEVCODE],[SEVNAME],[PRVCODE],[PRVNAME],[ROUTETO],[TRANSACCOUNT],[TRANSACCOUNT_NAME],[TRANS_GLCODE],[TRANS_GLNAME],[RECEIVE_GLCODE],[RECEIVE_GLNAME],[CUSTOMER_CODE],[CUSTOMER_NAME],[MAKER_ID],[CREATE_DT],[RECORD_STATUS])
19 
VALUES('TRPAC0000000009','PK07000094099','CHU THI TRANG','SEV007',N'Hóa đơn điện','PRV013',N'Điện lực toàn quốc','AMS','','','','','','','00025464',N'Trần Quyên','admin',GETDATE(),'1')
20 
INSERT INTO [dbo].[TR_REQ_PAY_AUTO_CUSTOMER]([REQ_PAY_AUTO_CUSTOMER_ID],[BILLCODE],[BILLALIAS],[SEVCODE],[SEVNAME],[PRVCODE],[PRVNAME],[ROUTETO],[TRANSACCOUNT],[TRANSACCOUNT_NAME],[TRANS_GLCODE],[TRANS_GLNAME],[RECEIVE_GLCODE],[RECEIVE_GLNAME],[CUSTOMER_CODE],[CUSTOMER_NAME],[MAKER_ID],[CREATE_DT],[RECORD_STATUS])
21 
VALUES('TRPAC0000000010','PK07000111399','NGUYEN VAN TUONG','SEV007',N'Hóa đơn điện','PRV013',N'Điện lực toàn quốc','AMS','','','','','','','00025464',N'Trần Quyên','admin',GETDATE(),'1')
22 
INSERT INTO [dbo].[TR_REQ_PAY_AUTO_CUSTOMER]([REQ_PAY_AUTO_CUSTOMER_ID],[BILLCODE],[BILLALIAS],[SEVCODE],[SEVNAME],[PRVCODE],[PRVNAME],[ROUTETO],[TRANSACCOUNT],[TRANSACCOUNT_NAME],[TRANS_GLCODE],[TRANS_GLNAME],[RECEIVE_GLCODE],[RECEIVE_GLNAME],[CUSTOMER_CODE],[CUSTOMER_NAME],[MAKER_ID],[CREATE_DT],[RECORD_STATUS])
23 
VALUES('TRPAC0000000011','PK07000141098','BUI THI PHUONG LAN','SEV007',N'Hóa đơn điện','PRV013',N'Điện lực toàn quốc','AMS','','','','','','','00025464',N'Trần Quyên','admin',GETDATE(),'1')
24 
INSERT INTO [dbo].[TR_REQ_PAY_AUTO_CUSTOMER]([REQ_PAY_AUTO_CUSTOMER_ID],[BILLCODE],[BILLALIAS],[SEVCODE],[SEVNAME],[PRVCODE],[PRVNAME],[ROUTETO],[TRANSACCOUNT],[TRANSACCOUNT_NAME],[TRANS_GLCODE],[TRANS_GLNAME],[RECEIVE_GLCODE],[RECEIVE_GLNAME],[CUSTOMER_CODE],[CUSTOMER_NAME],[MAKER_ID],[CREATE_DT],[RECORD_STATUS])
25 
VALUES('TRPAC0000000012','PK07000056477','NGUYEN QUANG HUY','SEV007',N'Hóa đơn điện','PRV013',N'Điện lực toàn quốc','AMS','','','','','','','00025464',N'Trần Quyên','admin',GETDATE(),'1')
26 
INSERT INTO [dbo].[TR_REQ_PAY_AUTO_CUSTOMER]([REQ_PAY_AUTO_CUSTOMER_ID],[BILLCODE],[BILLALIAS],[SEVCODE],[SEVNAME],[PRVCODE],[PRVNAME],[ROUTETO],[TRANSACCOUNT],[TRANSACCOUNT_NAME],[TRANS_GLCODE],[TRANS_GLNAME],[RECEIVE_GLCODE],[RECEIVE_GLNAME],[CUSTOMER_CODE],[CUSTOMER_NAME],[MAKER_ID],[CREATE_DT],[RECORD_STATUS])
27 
VALUES('TRPAC0000000013','PK07000119064','VY THI THAO','SEV007',N'Hóa đơn điện','PRV013',N'Điện lực toàn quốc','AMS','','','','','','','00025464',N'Trần Quyên','admin',GETDATE(),'1')
28 
INSERT INTO [dbo].[TR_REQ_PAY_AUTO_CUSTOMER]([REQ_PAY_AUTO_CUSTOMER_ID],[BILLCODE],[BILLALIAS],[SEVCODE],[SEVNAME],[PRVCODE],[PRVNAME],[ROUTETO],[TRANSACCOUNT],[TRANSACCOUNT_NAME],[TRANS_GLCODE],[TRANS_GLNAME],[RECEIVE_GLCODE],[RECEIVE_GLNAME],[CUSTOMER_CODE],[CUSTOMER_NAME],[MAKER_ID],[CREATE_DT],[RECORD_STATUS])
29 
VALUES('TRPAC0000000014','PK02000144227','NGUYEN THE ANH','SEV007',N'Hóa đơn điện','PRV013',N'Điện lực toàn quốc','AMS','','','','','','','00025464',N'Trần Quyên','admin',GETDATE(),'1')
30 
INSERT INTO [dbo].[TR_REQ_PAY_AUTO_CUSTOMER]([REQ_PAY_AUTO_CUSTOMER_ID],[BILLCODE],[BILLALIAS],[SEVCODE],[SEVNAME],[PRVCODE],[PRVNAME],[ROUTETO],[TRANSACCOUNT],[TRANSACCOUNT_NAME],[TRANS_GLCODE],[TRANS_GLNAME],[RECEIVE_GLCODE],[RECEIVE_GLNAME],[CUSTOMER_CODE],[CUSTOMER_NAME],[MAKER_ID],[CREATE_DT],[RECORD_STATUS])
31 
VALUES('TRPAC0000000015','PK02000118586','NGUYEN QUOC MINH','SEV007',N'Hóa đơn điện','PRV013',N'Điện lực toàn quốc','AMS','','','','','','','00025464',N'Trần Quyên','admin',GETDATE(),'1')
32 
INSERT INTO [dbo].[TR_REQ_PAY_AUTO_CUSTOMER]([REQ_PAY_AUTO_CUSTOMER_ID],[BILLCODE],[BILLALIAS],[SEVCODE],[SEVNAME],[PRVCODE],[PRVNAME],[ROUTETO],[TRANSACCOUNT],[TRANSACCOUNT_NAME],[TRANS_GLCODE],[TRANS_GLNAME],[RECEIVE_GLCODE],[RECEIVE_GLNAME],[CUSTOMER_CODE],[CUSTOMER_NAME],[MAKER_ID],[CREATE_DT],[RECORD_STATUS])
33 
VALUES('TRPAC0000000016','PK02000146279','NGUYEN THI CHINH','SEV007',N'Hóa đơn điện','PRV013',N'Điện lực toàn quốc','AMS','','','','','','','00025464',N'Trần Quyên','admin',GETDATE(),'1')
34 
INSERT INTO [dbo].[TR_REQ_PAY_AUTO_CUSTOMER]([REQ_PAY_AUTO_CUSTOMER_ID],[BILLCODE],[BILLALIAS],[SEVCODE],[SEVNAME],[PRVCODE],[PRVNAME],[ROUTETO],[TRANSACCOUNT],[TRANSACCOUNT_NAME],[TRANS_GLCODE],[TRANS_GLNAME],[RECEIVE_GLCODE],[RECEIVE_GLNAME],[CUSTOMER_CODE],[CUSTOMER_NAME],[MAKER_ID],[CREATE_DT],[RECORD_STATUS])
35 
VALUES('TRPAC0000000017','PK02000120668','BUI THUY NGUYEN','SEV007',N'Hóa đơn điện','PRV013',N'Điện lực toàn quốc','AMS','','','','','','','00025464',N'Trần Quyên','admin',GETDATE(),'1')
36 
INSERT INTO [dbo].[TR_REQ_PAY_AUTO_CUSTOMER]([REQ_PAY_AUTO_CUSTOMER_ID],[BILLCODE],[BILLALIAS],[SEVCODE],[SEVNAME],[PRVCODE],[PRVNAME],[ROUTETO],[TRANSACCOUNT],[TRANSACCOUNT_NAME],[TRANS_GLCODE],[TRANS_GLNAME],[RECEIVE_GLCODE],[RECEIVE_GLNAME],[CUSTOMER_CODE],[CUSTOMER_NAME],[MAKER_ID],[CREATE_DT],[RECORD_STATUS])
37 
VALUES('TRPAC0000000018','PK02000117987','NGUYEN THUY LINH','SEV007',N'Hóa đơn điện','PRV013',N'Điện lực toàn quốc','AMS','','','','','','','00025464',N'Trần Quyên','admin',GETDATE(),'1')
38 
INSERT INTO [dbo].[TR_REQ_PAY_AUTO_CUSTOMER]([REQ_PAY_AUTO_CUSTOMER_ID],[BILLCODE],[BILLALIAS],[SEVCODE],[SEVNAME],[PRVCODE],[PRVNAME],[ROUTETO],[TRANSACCOUNT],[TRANSACCOUNT_NAME],[TRANS_GLCODE],[TRANS_GLNAME],[RECEIVE_GLCODE],[RECEIVE_GLNAME],[CUSTOMER_CODE],[CUSTOMER_NAME],[MAKER_ID],[CREATE_DT],[RECORD_STATUS])
39 
VALUES('TRPAC0000000019','PK04000043631','PHAM THAI HA','SEV007',N'Hóa đơn điện','PRV013',N'Điện lực toàn quốc','AMS','','','','','','','00025464',N'Trần Quyên','admin',GETDATE(),'1')
40 
INSERT INTO [dbo].[TR_REQ_PAY_AUTO_CUSTOMER]([REQ_PAY_AUTO_CUSTOMER_ID],[BILLCODE],[BILLALIAS],[SEVCODE],[SEVNAME],[PRVCODE],[PRVNAME],[ROUTETO],[TRANSACCOUNT],[TRANSACCOUNT_NAME],[TRANS_GLCODE],[TRANS_GLNAME],[RECEIVE_GLCODE],[RECEIVE_GLNAME],[CUSTOMER_CODE],[CUSTOMER_NAME],[MAKER_ID],[CREATE_DT],[RECORD_STATUS])
41 
VALUES('TRPAC0000000020','PB15050011086','BUI THI LUYEN','SEV007',N'Hóa đơn điện','PRV013',N'Điện lực toàn quốc','AMS','','','','','','','00025464',N'Trần Quyên','admin',GETDATE(),'1')
42 
INSERT INTO [dbo].[TR_REQ_PAY_AUTO_CUSTOMER]([REQ_PAY_AUTO_CUSTOMER_ID],[BILLCODE],[BILLALIAS],[SEVCODE],[SEVNAME],[PRVCODE],[PRVNAME],[ROUTETO],[TRANSACCOUNT],[TRANSACCOUNT_NAME],[TRANS_GLCODE],[TRANS_GLNAME],[RECEIVE_GLCODE],[RECEIVE_GLNAME],[CUSTOMER_CODE],[CUSTOMER_NAME],[MAKER_ID],[CREATE_DT],[RECORD_STATUS])
43 
VALUES('TRPAC0000000021','PB15050011098','NGUYEN VIET CHIEN','SEV007',N'Hóa đơn điện','PRV013',N'Điện lực toàn quốc','AMS','','','','','','','00025464',N'Trần Quyên','admin',GETDATE(),'1')
44 
INSERT INTO [dbo].[TR_REQ_PAY_AUTO_CUSTOMER]([REQ_PAY_AUTO_CUSTOMER_ID],[BILLCODE],[BILLALIAS],[SEVCODE],[SEVNAME],[PRVCODE],[PRVNAME],[ROUTETO],[TRANSACCOUNT],[TRANSACCOUNT_NAME],[TRANS_GLCODE],[TRANS_GLNAME],[RECEIVE_GLCODE],[RECEIVE_GLNAME],[CUSTOMER_CODE],[CUSTOMER_NAME],[MAKER_ID],[CREATE_DT],[RECORD_STATUS])
45 
VALUES('TRPAC0000000022','PB15051120381','DO DUY DOA','SEV007',N'Hóa đơn điện','PRV013',N'Điện lực toàn quốc','AMS','','','','','','','00025464',N'Trần Quyên','admin',GETDATE(),'1')
46 
INSERT INTO [dbo].[TR_REQ_PAY_AUTO_CUSTOMER]([REQ_PAY_AUTO_CUSTOMER_ID],[BILLCODE],[BILLALIAS],[SEVCODE],[SEVNAME],[PRVCODE],[PRVNAME],[ROUTETO],[TRANSACCOUNT],[TRANSACCOUNT_NAME],[TRANS_GLCODE],[TRANS_GLNAME],[RECEIVE_GLCODE],[RECEIVE_GLNAME],[CUSTOMER_CODE],[CUSTOMER_NAME],[MAKER_ID],[CREATE_DT],[RECORD_STATUS])
47 
VALUES('TRPAC0000000023','PB15010014601','NGUYEN HONG NGOC','SEV007',N'Hóa đơn điện','PRV013',N'Điện lực toàn quốc','AMS','','','','','','','00025464',N'Trần Quyên','admin',GETDATE(),'1')
48 
INSERT INTO [dbo].[TR_REQ_PAY_AUTO_CUSTOMER]([REQ_PAY_AUTO_CUSTOMER_ID],[BILLCODE],[BILLALIAS],[SEVCODE],[SEVNAME],[PRVCODE],[PRVNAME],[ROUTETO],[TRANSACCOUNT],[TRANSACCOUNT_NAME],[TRANS_GLCODE],[TRANS_GLNAME],[RECEIVE_GLCODE],[RECEIVE_GLNAME],[CUSTOMER_CODE],[CUSTOMER_NAME],[MAKER_ID],[CREATE_DT],[RECORD_STATUS])
49 
VALUES('TRPAC0000000024','PB15010010676','NGUYEN HAI YEN','SEV007',N'Hóa đơn điện','PRV013',N'Điện lực toàn quốc','AMS','','','','','','','00025464',N'Trần Quyên','admin',GETDATE(),'1')
50 
INSERT INTO [dbo].[TR_REQ_PAY_AUTO_CUSTOMER]([REQ_PAY_AUTO_CUSTOMER_ID],[BILLCODE],[BILLALIAS],[SEVCODE],[SEVNAME],[PRVCODE],[PRVNAME],[ROUTETO],[TRANSACCOUNT],[TRANSACCOUNT_NAME],[TRANS_GLCODE],[TRANS_GLNAME],[RECEIVE_GLCODE],[RECEIVE_GLNAME],[CUSTOMER_CODE],[CUSTOMER_NAME],[MAKER_ID],[CREATE_DT],[RECORD_STATUS])
51 
VALUES('TRPAC0000000025','PK01000038721','TRAN XUAN THANG','SEV007',N'Hóa đơn điện','PRV013',N'Điện lực toàn quốc','AMS','','','','','','','00025464',N'Trần Quyên','admin',GETDATE(),'1')
52 

    		
  

  

    
      53
    
    
      
update TR_REQ_PAY_AUTO_CUSTOMER set TRANSACCOUNT = '068704100285', RECEIVE_GLCODE = '359200001'