Hi All,
i want to create a set of all ACCOUNT's of a particular ENTITY.
For example,
When am uploading transaction data as below,
ACCOUNT,ENTITY,DATASRC,INTCO,RPTCURRENCY,TIME,CATEGORY,AMOUNT
570927,32000,INPUT,NON_INTERCO,LC,2008.JAN,ACTUAL,1000
570930,32000,INPUT,NON_INTERCO,LC,2008.JAN,ACTUAL,2000
570999,32000,INPUT,NON_INTERCO,LC,2008.JAN,ACTUAL,3000
600100,42000,INPUT,NON_INTERCO,LC,2008.JAN,ACTUAL,5000
600200,42000,INPUT,NON_INTERCO,LC,2008.JAN,ACTUAL,6000
i want all the ACCOUNT(570927,570930,570999) numbers of ONE ENTITY=32000 in a variable
to use in Script Logic.
Can any one of you please explain how can i achieve this.
Thanks in advance.
Regards,
Sai