• Table of contents
• Batches
  • PurgeRP
  • Report
  • Table

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

-3 - Roll back (3)

-2 - Roll back (2)

Report¶

Program Class : GenHKRPDaily
Steps :

1. Call webservice (EcHkMemberController.getRPBalanceExpiryDateList) get HK & MC RP balance with expiry date.
2. 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));