RE.STAT.REP.LINE

I have create a record in RE.STAT.REP.LINE table. I am trying to separate charges charged on accounts with specific categories, but it seems not to be working as all the charge amounts crediting the Charges category are all recording on one RE.STAT.REP.LINE record. Anyone with any ideas on how i can solve this, would greatly appreciated.

KINGDOM BANK (LIVE) RE.STAT.REP.LINE SEE

REP.NAME.LINE.NO.. KPL.4655

---

1 TYPE.............. DETAIL
2. 1. 1 GB DESC..... 4655
2. 2. 1 GB DESC..... WITHDRAWAL CHARGES
39. 1 PROFT.APPLIC.ID PLTR
40. 1 PLCATEGORY..... 52047 DRAFT CHARGES
41. 1 PLPRODUCT...... 1500
39. 2 PROFT.APPLIC.ID PLTR
40. 2 PLCATEGORY..... 52047 DRAFT CHARGES
41. 2 PLPRODUCT...... 1058
39. 3 PROFT.APPLIC.ID PLTR
40. 3 PLCATEGORY..... 52047 DRAFT CHARGES
41. 3 PLPRODUCT...... 1059
90 CURR.NO........... 1
91. 1 INPUTTER....... 1031_ESTHER02__OFS_BROWSERTC
92. 1 DATE.TIME...... 12 FEB 14 13:02
93 AUTHORISER........ 9567_ANDISEN
94 CO.CODE........... ZW-001-0001 KINGDOM BANK (LIVE)
95 DEPT.CODE......... 1 Head office

---

18 FEB 2014 17:29:39 USER (04 JAN) INPUTT [1935,29PAGE 2
ACTION
AWAITING PAGE INSTRUCTIONS

Below is an entry of the record that credited the PL Category 52047...

Graniteside USD Branch Category Entry SEE

CATEG.ENTRY.ID.... 168470874651595.000001

---

2 COMPANY.CODE...... ZW-001-0049 Graniteside USD Branch
3 AMOUNT.LCY........ 250.00
4 TRANSACTION.CODE.. 983 Cash Withdrawal Commission
7 PL.CATEGORY....... 52-047 DRAFT CHARGES
8 CUSTOMER.ID....... 25974 THE WATTLE COMPANY LIMITED
9 ACCOUNT.OFFICER... 8130 MIRIAM ZISENGWE
10 PRODUCT.CATEGORY.. 1-500 HIGH VALUE CORPORATES
11 VALUE.DATE........ 01 JAN 2014
12 CURRENCY.......... USD US Dollar
16 POSITION.TYPE..... TR TRADING POSITION
20 CURRENCY.MARKET... 1 Currency Market
22 DEPARTMENT.CODE... 49 Graniteside USD Branch
23 TRANS.REFERENCE... TT14001GG42V
24 SYSTEM.ID......... TT TELLER
25 BOOKING.DATE...... 01 JAN 2014
26. 1 STMT.NO........ 168470874651595.00
26. 2 STMT.NO........ 1-3
26. 3 STMT.NO........ 1
26. 4 STMT.NO........ ZW0010032
26. 5 STMT.NO........ 168470874651595.01
26. 6 STMT.NO........ 1-4
29 CURR.NO........... 1
30. 1 INPUTTER....... 1026_TAPFUMISWA__OFS_BROWSERTC
31. 1 DATE.TIME...... 14 FEB 14 14:19
32 AUTHORISER........ 1019_TAWONGA
56 CONSOL. PLTR.52047..22.8130.ZW........ZW0010049
63 .................. 01

---

18 FEB 2014 15:44:41 USER (03 JAN) ANDISEN [9578,34PAGE 2
ACTION
AWAITING PAGE INSTRUCTIONS

Checking on the CONSOL.KEY on field 56, it seems the PLProduct is not being included on the Key. Please assist how i can resolve this.

Check "CONSOLIDATE.COND" for "PROFIT&LOSS" record definition. The consol key will be formed based on the definition here (Global setup). You have to defined the "Product Category" as a part of the definition, so that it'll get formed in your "CONSOL.KEY"

1. 2 NAME........... PLPRODUCT
2. 2 FILE.NAME...... CATEG.ENTRY Details of P&L entries
3. 2 FIELD.NAME..... PRODUCT.CATEGORY

KINGDOM BANK (LIVE) Consolidate Cond SEE

CONSOLIDATE.KEY... PROFIT&LOSS

---

1. 1 NAME........... PLCATEGORY
2. 1 FILE.NAME...... CATEG.ENTRY Details of P&L entries
3. 1 FIELD.NAME..... PL.CATEGORY
1. 2 NAME........... PLPRODUCT
2. 2 FILE.NAME...... LOCAL
1. 3 NAME........... PLSECTOR
2. 3 FILE.NAME...... CUSTOMER Customer details
3. 3 FIELD.NAME..... SECTOR
1. 4 NAME........... PLDEPARTMENT
2. 4 FILE.NAME...... CATEG.ENTRY Details of P&L entries
3. 4 FIELD.NAME..... ACCOUNT.OFFICER
1. 5 NAME........... PLRESIDENCE
2. 5 FILE.NAME...... CUSTOMER Customer details
3. 5 FIELD.NAME..... RESIDENCE
1. 6 NAME........... PLTIME
2. 6 FILE.NAME...... LOCAL
1. 7 NAME........... PLBOOK
2. 7 FILE.NAME...... LOCAL
1. 8 NAME........... PLTYPE
2. 8 FILE.NAME...... LOCAL
11. 1 MULTI.VALUE.NO. 2
12. 1 APPLICATION.... ACCOUNTS
13. 1 LOCAL.FILE.NAME AL
14. 1 LOCAL.FIELD.NAM CATEGORY
11. 2 MULTI.VALUE.NO. 2
12. 2 APPLICATION.... GROUP.ACCRUAL
13. 2 LOCAL.FILE.NAME AL
14. 2 LOCAL.FIELD.NAM CATEGORY
11. 3 MULTI.VALUE.NO. 2
12. 3 APPLICATION.... LOAN.DEPOSIT
13. 3 LOCAL.FILE.NAME AL
14. 3 LOCAL.FIELD.NAM CATEGORY
11. 4 MULTI.VALUE.NO. 2
12. 4 APPLICATION.... PAYMENT.DUE
13. 4 LOCAL.FILE.NAME AL
14. 4 LOCAL.FIELD.NAM CATEGORY
11. 5 MULTI.VALUE.NO. 2
12. 5 APPLICATION.... LETTER.OF.CREDIT
13. 5 LOCAL.FILE.NAME AL
14. 5 LOCAL.FIELD.NAM CATEGORY
11. 6 MULTI.VALUE.NO. 2
12. 6 APPLICATION.... SECURITIES
13. 6 LOCAL.FILE.NAME AL
14. 6 LOCAL.FIELD.NAM CATEGORY
11. 7 MULTI.VALUE.NO. 2
12. 7 APPLICATION.... FOREX
13. 7 LOCAL.FILE.NAME AL
14. 7 LOCAL.FIELD.NAM CATEGORY
11. 8 MULTI.VALUE.NO. 2
12. 8 APPLICATION.... MONEY.MARKET
13. 8 LOCAL.FILE.NAME AL
14. 8 LOCAL.FIELD.NAM CATEGORY
11. 9 MULTI.VALUE.NO. 2
12. 9 APPLICATION.... FRA
13. 9 LOCAL.FILE.NAME AL
14. 9 LOCAL.FIELD.NAM CATEGORY
11.10 MULTI.VALUE.NO. 6
12.10 APPLICATION.... LOAN.DEPOSIT
13.10 LOCAL.FILE.NAME AL
14.10 LOCAL.FIELD.NAM TIME
11.11 MULTI.VALUE.NO. 6
12.11 APPLICATION.... MONEY.MARKET
13.11 LOCAL.FILE.NAME AL
14.11 LOCAL.FIELD.NAM TIME
11.12 MULTI.VALUE.NO. 7
12.12 APPLICATION.... SECURITIES
13.12 LOCAL.FILE.NAME AL
14.12 LOCAL.FIELD.NAM SCBOOK
11.13 MULTI.VALUE.NO. 8
12.13 APPLICATION.... LOAN.DEPOSIT
13.13 LOCAL.FILE.NAME AL
14.13 LOCAL.FIELD.NAM LD.SUB.ASSET
23. 1 KEY.APPLICATION PROFIT.LOSS
24. 1 KEY.GEN.FILE... CUSTOMER Customer details
25. 1 KEY.LOCAL.FILE. CATEG.ENTRY Details of P&L entries
26. 1 KEY.LOCAL.FIELD CUSTOMER.ID
23. 2 KEY.APPLICATION PROFIT.LOSS
24. 2 KEY.GEN.FILE... CATEG.ENTRY Details of P&L entries
25. 2 KEY.LOCAL.FILE. CATEG.ENTRY Details of P&L entries
26. 2 KEY.LOCAL.FIELD PRODUCT.CATEGORY
29 CONT.SELF.BAL..... N
30 FX.SELF.BAL....... N
31 LIMIT.TO.TAKE..... NONE
37 UPDT.CONSOL.PROFIT NONE
40. 1 OVERRIDE....... POSITIONS HAS NO ENTRY FOR No. 2
40. 2 OVERRIDE....... LIMITS HAS NO ENTRY FOR No. 2
40. 3 OVERRIDE....... NDF HAS NO ENTRY FOR No. 2
40. 4 OVERRIDE....... ACCOUNTS HAS NO ENTRY FOR No. 6
40. 5 OVERRIDE....... POSITIONS HAS NO ENTRY FOR No. 6
40. 6 OVERRIDE....... FRA HAS NO ENTRY FOR No. 6
40. 7 OVERRIDE....... FOREX HAS NO ENTRY FOR No. 6
40. 8 OVERRIDE....... GROUP.ACCRUAL HAS NO ENTRY FOR No. 6
40. 9 OVERRIDE....... LETTER.OF.CREDIT HAS NO ENTRY FOR No. 6
40.10 OVERRIDE....... LIMITS HAS NO ENTRY FOR No. 6
40.11 OVERRIDE....... NDF HAS NO ENTRY FOR No. 6
40.12 OVERRIDE....... PAYMENT.DUE HAS NO ENTRY FOR No. 6
40.13 OVERRIDE....... SECURITIES HAS NO ENTRY FOR No. 6
40.14 OVERRIDE....... ACCOUNTS HAS NO ENTRY FOR No. 7
40.15 OVERRIDE....... POSITIONS HAS NO ENTRY FOR No. 7
40.16 OVERRIDE....... FRA HAS NO ENTRY FOR No. 7
40.17 OVERRIDE....... FOREX HAS NO ENTRY FOR No. 7
40.18 OVERRIDE....... GROUP.ACCRUAL HAS NO ENTRY FOR No. 7
40.19 OVERRIDE....... LETTER.OF.CREDIT HAS NO ENTRY FOR No. 7
40.20 OVERRIDE....... LOAN.DEPOSIT HAS NO ENTRY FOR No. 7
40.21 OVERRIDE....... LIMITS HAS NO ENTRY FOR No. 7
40.22 OVERRIDE....... MONEY.MARKET HAS NO ENTRY FOR No. 7
40.23 OVERRIDE....... NDF HAS NO ENTRY FOR No. 7
40.24 OVERRIDE....... PAYMENT.DUE HAS NO ENTRY FOR No. 7
40.25 OVERRIDE....... ACCOUNTS HAS NO ENTRY FOR No. 8
40.26 OVERRIDE....... POSITIONS HAS NO ENTRY FOR No. 8
40.27 OVERRIDE....... FRA HAS NO ENTRY FOR No. 8
40.28 OVERRIDE....... FOREX HAS NO ENTRY FOR No. 8
40.29 OVERRIDE....... GROUP.ACCRUAL HAS NO ENTRY FOR No. 8
40.30 OVERRIDE....... LETTER.OF.CREDIT HAS NO ENTRY FOR No. 8
40.31 OVERRIDE....... LIMITS HAS NO ENTRY FOR No. 8
40.32 OVERRIDE....... MONEY.MARKET HAS NO ENTRY FOR No. 8
40.33 OVERRIDE....... NDF HAS NO ENTRY FOR No. 8
40.34 OVERRIDE....... PAYMENT.DUE HAS NO ENTRY FOR No. 8
40.35 OVERRIDE....... SECURITIES HAS NO ENTRY FOR No. 8
42 CURR.NO........... 4
43. 1 INPUTTER....... 4527_OFSSAL
44. 1 DATE.TIME...... 15 AUG 12 16:59
45 AUTHORISER........ 7400_FARAINESU1
46 CO.CODE........... ZW-001-0001 KINGDOM BANK (LIVE)
47 DEPT.CODE......... 2000 Information Technology

---

19 FEB 2014 14:47:00 USER (06 JAN) INPUTT [5409,22PAGE 8
ACTION
AWAITING PAGE INSTRUCTIONS

The field am using in PLPRODUCT defined as above as LOCAL. What does the value LOCAL refer to?

Though I have redefined my line using sector and it has worked.

Then how come if i had used the ACCOUNT CATEGORY it was not able to create the CONSOL.KEY with the variable i had defined?