Login
Register
Search
Home
Forums
Jobs
LawsonGuru
LawsonGuru Letter
LawsonGuru Blog
Worthwhile Reading
Infor Lawson News Feed
Store
Store FAQs
About
Forums
Performance Management
Lawson Business Intelligence/Reporting/Crystal
GEN Database Programs and Screens
Home
Forums
Jobs
LawsonGuru
LawsonGuru Letter
LawsonGuru Blog
Worthwhile Reading
Infor Lawson News Feed
Store
Store FAQs
About
Who's On?
Membership:
Latest:
Raju
Past 24 Hours:
1
Prev. 24 Hours:
1
Overall:
5205
People Online:
Visitors:
296
Members:
0
Total:
296
Online Now:
New Topics
Lawson S3 HR/Payroll/Benefits
Post Tax Benefit Plan Table
11/14/2024 9:16 PM
Hi, totally new to Laswon. I have a repor
Lawson S3 Procurement
ED501 Error: Map 850 not supported by /law/c15vda/lawson/test10/edi/bin/laws_out_91
11/12/2024 3:47 PM
Tried runnning ED501 and getting the atathced erro
Lawson Smart Office
Error
11/6/2024 9:54 PM
When I try to enroll a retiree in 72.1 health plan
Infor CloudSuite
Syteline: New Data Maintenance Wizard (Error) Need help
11/1/2024 4:39 PM
Hi, I need help with an error on syteline while us
Infor ERP (Syteline)
Syteline: New Data Maintenance Wizard (Error) Need help
11/1/2024 4:24 PM
Hi, I need help with an error on syteline while us
Dealing with Lawson / Infor
Implementing Lawson v10 with Cerner Surginet, Case Cart Picking, and Quick Adds for the OR
10/29/2024 4:20 PM
Hi Everyone, I am wondering if there is any org
Lawson S3 HR/Payroll/Benefits
Canada Tax Calculation (Federal and Provincial) Issue
10/23/2024 5:00 AM
Initially, we had problem with CPP2 calculation is
Lawson S3 HR/Payroll/Benefits
CA Section 125 401k Plan
10/22/2024 10:13 PM
Does anyone have any recommendations on how to fac
S3 Systems Administration
Running AC120 deleted records from ACMASTER table
10/22/2024 3:40 PM
We recently ran the AC120 as normal and somehow it
Lawson S3 Procurement
RQ13 Approval Info
10/17/2024 2:12 PM
When a Requisition is approved on RQ13, what table
Top Forum Posters
Name
Points
Greg Moeller
4184
David Williams
3349
JonA
3291
Kat V
2984
Woozy
1973
Jimmy Chiu
1883
Kwane McNeal
1437
Ragu Raghavan
1369
Roger French
1315
mark.cook
1244
Forums
Filtered Topics
Unanswered
Unresolved
Announcements
Active Topics
Most Liked
Most Replies
Search Forums
Search
Advanced Search
Topics
Posts
Prev
Next
Forums
Performance Management
Lawson Business Intelligence/Reporting/Crystal
GEN Database Programs and Screens
Please
login
to post a reply.
2 Replies
0
Subscribed to this topic
22 Subscribed to this forum
Sort:
Oldest First
Most Recent First
Author
Messages
Layne
Basic Member
Posts: 24
1/31/2012 11:55 AM
I am running the following query on GEN. I wanted to see what fields are being used by a certain Program and Screen.
SELECT *
FROM dbo.PGMFLD
WHERE PROGRAMCODE = 'HR11'
AND SCRNBR = 1
AND PRODUCTLINE = 'LAWPROD'
What is the prefix field used for. Is there a list of the defintions of these fields? Let's say I was in the Lawson Portal on Screen HR11.1. I want to know what tables and fields that this form uses, so I can write a report. I am not worried about how to connect back to other tables to get the actual tables used in this form and screen. I know how to do that. What prefix would I use. Do I further constrain on prefix = 'EMP'. If this is correct, then why are the other prefixes evern listed here. Doing a distinct on prefix using the same query gives me the following:
AAX
AJH
APL
BEN
BNB
BNG
BNH
BTE
CCH
CCT
CTC
CUC
DDC
DIP
DPT
EDM
EFD
EMP
EMS
EPC
ETM
GCD
GDT
GIC
GLS
HER
HEU
HRH
HRU
HSL
HSU
INT
ITV
JBC
LTR
MIL
OTD
PA2
PAA
PAB
PAC
PAD
PAH
PAP
PAS
PAT
PBG
PCD
PCO
PCT
PDD
PDH
PEA
PEM
PEP
PEU
PGE
PGS
PJR
PLM
PLN
PMD
PMN
POS
PPC
PPP
PPR
PPV
PQC
PRA
PRC
PRF
PRG
PRH
PRO
PRQ
PRR
PRS
PRX
PSA
PTF
PTS
PW4
PWU
PXL
PYD
PYM
QTD
QTW
REG
RGP
RQC
SGD
SGH
STM
TAP
TAR
TBL
TEM
TEN
TES
TGE
TGR
TLM
TPR
TRD
TSC
TST
TTR
TXG
WSC
WUP
David Williams
Veteran Member
Posts: 1127
1/31/2012 12:14 PM
Lawson's Technical Text documentation should give you what you need.
Greg Moeller
Veteran Member
Posts: 1498
1/31/2012 1:44 PM
Or you could do it another way.
Select prefix, filename, productline
from gen.filedef
Please
login
to post a reply.