• Search Forums
    Advanced Search Topics Posts
Prev
Next
Forums Human Capital Management Lawson S3 HR/Payroll/Benefits

Where's the PLAN table in crystal rpts?

 3 Replies
 0 Subscribed to this topic
 68 Subscribed to this forum
Sort:
Author
Messages
Sarah
Advanced Member Send Private Message
Posts: 33
Advanced Member
2/15/2012 7:56 PM
The table that warehouses all the BN15 information, what table is this in if I want to run a crystal rpt? when I hold down my ctrl, shift and O key it shows PLN and the field name but I can't find the PLAN table for me to write a report out of crystal rpts on it. I spoke to our IT group and they can't find it either; they wondered if it's been renamed in the 9.01 version?
If so, anyone know what name it's called now because Lawson still calls it the PLAN table.

I hope this makes sense.

TIA,

Sarah
Bob Canham
Veteran Member Send Private Message
Posts: 217
Veteran Member
2/15/2012 8:32 PM
If you're using an Oracle database, it is in the R_PLAN table. I'm not sure if it is a different name on other database types.
Woozy
Veteran Member Send Private Message
Posts: 709
Veteran Member
2/15/2012 10:18 PM
The table is R_PLAN in DB2 as well.
Kelly Meade
J. R. Simplot Company
Boise, ID
Sarah
Advanced Member Send Private Message
Posts: 33
Advanced Member
2/23/2012 3:58 PM
Thank you! I was able to use the R_PLAN table for my reports.