eCosway » eCosway HK » RP_Purge

{{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));