Actions
Batch » History » Revision 7
« Previous |
Revision 7/13
(diff)
| Next »
Soh Keong, 10/18/2023 09:08 AM
Batches¶
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
4 - Add missing RP by period
-4 - Roll back (4)
-3 - Roll back (3)
-2 - Roll back (2)
Report¶
Program Class : GenHKRPDailySteps :
- Call webservice (EcHkMemberController.getRPBalanceExpiryDateList) get HK & MC RP balance with expiry date.
- Write RP to file name : RPyymmdd.HK
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));
Updated by Soh Keong about 1 year ago · 7 revisions