Excel Add-In Query Wizard

Good afternoon,

I am looking for some assistance please. I am new to this tool and I see the tables and fields listed. Is there a cheat sheet on the HR table fields?

Thanks,

Suzan

Find more posts tagged with

Comments

Robert Canham

I don't have a cheat sheet, but if you are in Portal, put your cursor in a field that you want and press ctrl-shift-o. When you do that, you will get information in your browser status bar that tells you the database field that it is showing.

For example, if you use that on the First Name field on HR11, it will tell you EMP-FIRST-NAME. The first 3 characters (EMP) are the table name. You can put that in at the bottom of Query Wizard and it will tell you the table. Then you can find the First-Name field in that table.

The other place you can get info is if you have access to LID. There is a command called dbdoc that will output you information about tables, all the fields, allowed values if there is a list, relationships, etc.

edwin-valle

I have a Common Table Name doc for HR. It is not everything of course, but it may help you. I don't know that I can attach the doc here. But I pasted below.

The above comment is excellent, also note that you can relate more than one table by using your main table on the first screen and then clicking on Relations to related to other HR tables and fields.

sample Lawson HR table names:

File Name	Like Form	Description	Sample Fields
EMPLOYEE (HR)	HR11 tabs: Main, Assgt, Pay, Work	Lists basic employee information to be used with the other modules	EE#, Name, Primary Position info and rate of pay, Status, OT Code, Pay Plan, Address
PAEMPLOYEE (HR)	HR11, tabs: Personal, Supp Addr	Stores additional information not found in EMPLOYEE	EE#, Home Phone, Supp Address, DOB
EMDEPEND (HR)	HR13	Employee Dependent information	EE#, DOB, relationship
BENEFIT (BN)	BN32	Enrollments for: health, dental, vision, 403b, EE/Dep/Sup life, etc.	EE#, Plan Type, Plan Code, Enrollment Start/Stop dates, Coverage Option/Amount
DEPTCODE (HR)	HR02	Department Code Setup	PL and Dept with cost center
JOBCODE (HR)	HR06	Job Code Setup	Job Code, description, EEO
PRDISTRIB (PR)		This may be where you will get the GL data from
PRTIME (PR)	Drill Around	Employee historical pay and hours info	EE#, Check ID, Pay Summary Group, Job Code, Hours, Rate, Amount, Acctg Info
PRCHECK (PR)	PR50	Ties paymaster and paydeductn records; Displays status of payment
PAYMASTR (PR)	PR51	Wage file (historical) from PR140 or PR80.	EE#, Check ID, Gross and Net pay, Check Date
PAYDEDUCTN (PR)	Drill Around	Deductions that were taken (historical) from a particular check date (from PR140).	EE#, Check ID, Ded Code, Amt, Taxable Wages
TIMERECORD (PR)	PR35.2/36	Open time records waiting to be processed	EE#, Pay Code, TR Date, Expense Info

deday

On the Welcome Tab in Query Wizard you can choose "Application" or "Database Tables". If you select Application then it will list the Form IDs "HR11" etc so you can build your query based on the data on the specific form. If you select "Database Tables" it will just list all the tables "EMPLOYEE", etc. I have found it much easier to start with the Application option when using Query Wizard. You can also look to the Technical Text Documentation on Infor Extreme to help you identify the tables that are used in the forms.

Copyright © 2025 Infor. All rights reserved.