delete from TR_REQ_PAY_AUTO_CUSTOMER
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])
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')
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])
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')
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])
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')
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])
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')
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])
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')
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])
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')
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])
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')
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])
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')
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])
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')
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])
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')
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])
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')
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])
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')
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])
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')
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])
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')
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])
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')
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])
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')
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])
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')
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])
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')
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])
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')
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])
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')
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])
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')
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])
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')
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])
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')
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])
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')
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])
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')

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