Done Please check & confrm.
Created attachment 1894 [details] SS_0882_IMIS_Against call id - 6411 -- Make script for Alter table "SCRATCH_CARD"& modification in procedure "PKG_SCRATCH_CARD.COUPON_UPDATE". Please find the attachment. 1. SS_0882_IMIS_Against call id - 6411
Created attachment 1893 [details] SALF4020_CSV_FILE Dear Mr. Sahu, Please find the attachment & verify the csv file. If any query please contact to us.
Working on...
Modification in Form - "SALF4020 -Generate Scratch Coupons". -------- Forwarded Message -------- Subject: Scratch card number allocation - Scheme 120 - ORANGE-TR Date: Tue, 4 May 2021 20:40:11 +0530 From: B.K. Sahu <bk.sahu@baba.in> Organization: Dharampal Premchand Ltd. To: 'Sweta Suman' <sweta.suman@baba.in> CC: 'Kamal Kapur' <kapurk@baba.in> Dear Ms.Sweta, We are in need of number allocation for scratch coupon scheme for the below mentioned scheme, the details of which is as follows :- Scheme name :- Scratch card for Master carton Scheme color scheme :- Orange -TR 1. Random number must be of 12character and it should be a combination of alphabet and numeral. 2. There should be at least 4 numerals in each random number. The prize allocation logic for scheme no 120 – ORANGE-TR :- Nauratan Panmasala Master carton Total coupon under this scheme :- 10000 The below mentioned prize needs to be allocated in random in a block of 1500 coupons each. the allocation breakup is as follows:- Rs.100/- :- 549 Rs.150/- :- 800 Rs.200/- :- 50 Rs.250/- :- 35 Rs.300/- :- 25 Rs.400/- :- 20 Rs.500/- :- 12 Rs.1000/- :- 05 Rs.2000/- :- 04 for this category the serial number series (alpha numeric) should start from 001 to 999 then the next series should start. We will prefer to have the serial number for this scheme to start with :- QEA001. It is requested to do the needful for creating the csv file at the earliest. Thanks Bksahu