eCosway » eCosway HK » RP_Purge

Batch » History » Revision 5

Revision 4 (Soh Keong, 10/12/2023 10:42 AM) → Revision 5/13 (Soh Keong, 10/18/2023 08:46 AM)

{{toc}} 

 h1. Batches 

 h2. PurgeRP 

 Program Class : ECpurgeRP 
 Run Indicator :  
 > 0    - First Time run only, For earn and get from table MEMBER_ACCOUNT 

 > 1    - Subsequence to Calculate Earn and Utilize RP from table TRANSACTION 

 > 2    - Calculate Utilized RP and Deduct from ProcessDate Balance 

 > 3    - Purge expired RP 

 > -3 - Roll back (3) 

 > -2 - Roll back (2) 



 h2. Report 

 Program Class : GenHKRPDaily 
 Steps           : 
 # Call webservice (EcHkMemberController.getRPBalanceExpiryDateList) get HK & MC RP balance with expiry date. 
 # Write RP to file name : RPyymmdd.HK 


 h2. Table 

 CREATE TABLE RP_PURGE ( 
     PROCESS_DATE INTEGER NOT NULL, 
     MEMBER_ID VARCHAR(20) NOT NULL, 
     RP_EARN DECIMAL(15,2),  
	 RP_UTILIZE DECIMAL(15,2), 
	 RP_TOTAL_UTILIZED DECIMAL(15,2) DEFAULT 0, 
	 RP_UTILIZED_PROCESS_DATE VARCHAR(25), 
	 RP_PURGE DECIMAL(15,2), 
	 RP_TO_BE_EXPIRED DECIMAL(15,2), 
	 EXPIRY_DATE DATE, 
	 PROCESS_IND VARCHAR(1) DEFAULT 'N', 
     CREATE_DATETIME TIMESTAMP NOT NULL DEFAULT CURRENT TIMESTAMP, 
     MODIFY_DATETIME TIMESTAMP,  
     PRIMARY KEY (PROCESS_DATE,MEMBER_ID));