IC130 - General Ledger

I know that the ICT prefix is for the ICTRANS table and ICC is for the ICCOMPANY table, but I am having problems finding the tables for the other fields.

This info can be found in the Technical Text document from Infor (official document name is something like DATA FILE TEXT FOR IC SYSTEM CODE).

Alternatively, you can look up the table names using MS Addins. I don't have a copy of MS Addins on this computer, but on one of the tabs of the MS Addins "query" application - you can enter the three digit code and will be provided the full table name.

Thank you, Mike!

I will give it a try and let you know how it goes.

The MS Addins is not working for me. Some of 3 digit prefix cannot be found for the fields; plus, there is a lot of tables and fields. If I could narrow down the tables and fields that IC130 uses, I might be able to find more data that is specific to the screen.

Here's the list of prefixes and corresponding table names that we have loaded here.

 

Unfortunately the field prefixes are not always table aliases, so the add-ins trick, which can be super helpful, does not always work. The IC Technical Text document will contain a list of tables updated and referenced by IC130, but does not go down to the level of individual fields. The IC Data File Text does list which programs update (not reference) each table column, but it covers IC tables only, and there is no cross reference between the program field name and the table column name. The only sure fire thing I can suggest is to get yourself a compile listing of IC130, search on the field names you want, and trace them back to where they came from, in the code.

Does this have to be a crystal report? If the users are just looking for a couple of additional fields, you can try the Smart Reports as the Gurus here suggest. You might also be able to make use of the actual .prt report file, or a .csv of the report file, using it as input to a custom report.

Thank you, Greg, for the listing of prefixes and corresponding table names! It will be helpful going foward.

Thank you, Pbelsky! The report does not have to be a crystal report. I just need to know where to get the data, and pull it into Excel or CVS (format) based on a date range (ICT.TRANS_DATE).

Pbelsky, you mentioned several things I can try, but I need more information:

1. Where can I get a compile listing of IC130?
2. Smart Reports - Are you referring to the MS Add-ins?
3. Actual .prt report file, or .csv - Are you referring to exporting from the IC130 screen?

Thank you

Hi Lisa, anyone with the proper auth can create a compile listing for a program. We are on windows, so we have 2 ways to get this. Have the right person run one of these commands from a prompt in LID and give you the output file:

qcompile -lC prodline systemcode programname
bldsh prodline systemcode programname

The qcompile will create a .lst file in the systemcode folder.
The bldsh will create a .cbl in the systemcode folder.

Example, if the command is being run in a productline called PROD:
qcompile -lC PROD IC IC130
bldsh PROD IC IC130

Smart Reports is a free tool from Infor that you can download from the support site. I believe the current full name for the product is Infor Smart Reports. You should be able to download it from "my products."

The .prt file is tied to the job (as opposed to the program), and it lives in the print directory of the person who created the job. You can see where it is located by bringing up an IC130 job and clicking on the Reports button. You'll get a little window that shows the file name and path. The .prt file can also be redirected to another folder by changing the path in this window.

If you prefer to work with a csv, and you don't want to have to manually export with the csv button, you can create it programmatically using the bldxffiles utility.

Bldxffiles -C username jobname stepnumber

Example:If I had a single step IC130 job called IC130PB, I would type the following from a LID command prompt:

bldxffiles -C pbelsky IC130PB 1

this will create an IC130.csv file in %lawdir%\print\pbelsky\IC130PB\1

Since we are on windows, we can put commands into .bat files and execute them either as Windows jobs, or through Lawson tokendef, and automate quite a bit of it this way.

I hope this helps.

This is very helpful information.

I will see how much access they will give me. Thank you!