Login
Register
Search
Home
Forums
Jobs
LawsonGuru
LawsonGuru Letter
LawsonGuru Blog
Worthwhile Reading
Infor Lawson News Feed
Store
Store FAQs
About
Forums
Financial Management
Lawson S3 Financials
L_HACV and L_DACV environment tables
Home
Forums
Jobs
LawsonGuru
LawsonGuru Letter
LawsonGuru Blog
Worthwhile Reading
Infor Lawson News Feed
Store
Store FAQs
About
Who's On?
Membership:
Latest:
Wayne Willis
Past 24 Hours:
0
Prev. 24 Hours:
1
Overall:
5190
People Online:
Visitors:
234
Members:
0
Total:
234
Online Now:
New Topics
Lawson Landmark
Executing IPA from PR160
5/3/2024 2:46 PM
We're facing a situation where we need to upda
IPA/ProcessFlow
Executing IPA from PR160
5/3/2024 2:46 PM
We're facing a situation where we need to upda
S3 Customization/Development
Cobol - Extract Current Time
4/24/2024 7:21 PM
How do you extract just the Current System Time in
Lawson Landmark
LPL INSTR Functions
4/5/2024 8:32 PM
I'm writing a simple report using the Create R
Infor SCM
Translating 856 to get the ~ REF^CN^ field
4/3/2024 8:24 PM
We are trying to get the tracking number which is
IPA/ProcessFlow
Sample XML file create Flow
4/3/2024 3:43 PM
Hello everyone, I am new to creating XML files
Lawson S3 HR/Payroll/Benefits
bn105 error message
3/26/2024 6:40 PM
I need to change some of the set ups in our Life I
IPA/ProcessFlow
IPA executing Job
3/13/2024 7:08 PM
New to the IPA world and was wondering, can an IPA
Lawson S3 HR/Payroll/Benefits
Life Age Reduction on benefits plans
3/12/2024 7:15 PM
For our optional life we have an age based coverag
Lawson S3 HR/Payroll/Benefits
BN53.1 Add-In
3/7/2024 3:31 PM
We are migrating to Solstice. They require a
Top Forum Posters
Name
Points
Greg Moeller
4184
David Williams
3349
JonA
3288
Kat V
2984
Woozy
1973
Jimmy Chiu
1883
Kwane McNeal
1437
Ragu Raghavan
1354
Roger French
1311
mark.cook
1244
Forums
Unanswered
Active Topics
Most Liked
Most Replies
Search Forums
Search
Advanced Search
Topics
Posts
Prev
Next
Forums
Lawson S3 Financials
L_HACV and L_DACV environment tables
Sort:
Oldest First
Most Recent First
You are not authorized to post a reply.
Author
Messages
Tom_gbmc
New Member
Posts: 3
2/26/2016 1:45 PM
We have a request from a user to modify one of our crystal reports, reporting on activities, to include the comments from AC10. Infor told me that this information is stored in L_HACV and L_DACV and that these are environment tables and not accessed in the same way as a 'typical' database table. Has anyone had any experience using these tables and is there a reasonable way to be able to access them as well as the other AC tables in one report?
Thanks
ALB
Veteran Member
Posts: 130
2/26/2016 2:23 PM
I have accessed the comments on APINVOICE. On ACACTIVITY, there is an index with the fields L_ATACV_SS_SW which is Y if there are comments and N if there are no comments. The next field is L_INDEX (4 characters) which is part of the key to L_HACV and L_DACV. The other part of the key is FILENAME which would be ACACTIVITY in your case. If you have multiple comments, there is a field called ATCHNBR (2 characters). R_SIZE is the length of the total comments in all tables. The actual comments are in a field called OBJECT (512 characters). The first 95 or so characters (whatever the value of HEADSIZE is) stores information about the comment. My experience has been that HEADSIZE has always been 95, so I will assume 95 characters the rest of this explanation. Adjust accordingly. From characters 96-512 are the actual comments. If someone puts in a comment longer than 512-96 characters, it overflows to L_DACV. L_HACV and L_DACV have similar indexes (FILENAME, L_INDEX, and ATCHNBR). OBJECT on L_DACV is purely comments and is 1024 characters. There is a SEQNBR field which is used so that is there are more than 1024 characters of comments to be stored, it goes into the next L_DACV record. All tables with comments have L_Hxxx and L_Dxxx tables where xxx is the 3 character prefix of the table. I look at FILEDEF in the GEN database when I run across a table or prefix I do not recognize. If you use COBOL, there are APIs to pull the data from the comments tables. I believe the data is sliced up by characters not at the end of a word. Let's say your comment is 2,000 characters long and HEADSIZE is 95. The first 417 characters of the comment are stored in characters 96-512 of OBJECT in L_HACV. Characters 418-1441 of the comment are stored in OBJECT the first SEQNBR of L_DACV while the rest will be in the 2nd SEQNBR.
Tom_gbmc
New Member
Posts: 3
2/26/2016 3:45 PM
Hi Angela, that was a very detailed summary of how to accomplish that task. Unfortunately our Lawson is hosted and I don't even have access to a command line much less the ability to write a cobol program. All of our 'homegrown' programs are in Crystal and at this point I can't easily see how to accomplish this with Crystal. I do appreciate your help though.
Thanks
Tom
Greg Moeller
Veteran Member
Posts: 1498
2/26/2016 4:22 PM
If all your programs are in Crystal, continue to use Crystal. You just need to know how to link the tables together.
As for the character counts, you can use combinations of the right and left functions in Crystal to extract the data that you need.
Tom_gbmc
New Member
Posts: 3
2/26/2016 5:10 PM
Thanks Greg. I guess I can try that but my immediate problem is that when I use Crystal or access, those tables are not available to me. I have sent a 'ticket' to the company that hosts our Lawson to see if I can get access to them. As a relatively new crystal reports user (I am a long time cobol programmer) I think I will stumble through getting the links working but I can give it a shot if I have access to those table.
Thanks again
Tom
Deron
Advanced Member
Posts: 25
2/26/2016 5:41 PM
Nice summary Angela. I would add that you could use a list aggregation function in your SQL statement to "summarize" the OBJECT values. If you're an Oracle user, this link should help. <
http://www.techonthenet.c...unctions/listagg.php
>
John Henley
Senior Member
Posts: 3349
2/29/2016 2:45 PM
https://www.lawsonguru.co...ts-in-Lawson-v8.aspx
You are not authorized to post a reply.