JasonAtIntuit
Employee
Employee

Here's how you can access the field definitions:

  1. Open your 18tax folder and find the 3-letter module folder for the tax type you're interested in, for example C:\Lacerte\18tax\IND:
    1. IND = Individual
    2. COR = Corporate
    3. PAR = Partnership
    4. etc
  2. Find the usdbdef.?18 file where ? represents the module (I = Ind, C = Corp, etc)
  3. Make a copy of the file somewhere and either just open it in a text editor, or what I like to do is rename it to .xls and open it in Excel
  4. The columns are as follows:
    1. Table number
    2. Field number
    3. Description
    4. Short Desc
    5. Field Type (Number, Date, Character)
    6. Field Length
      16. Toggle Type
  5. The first 2 columns put together form the field name in the database, where negative field numbers represent the "G" columns - here's some examples:
    • 1, -12 is C1_G12
    • 1, 0 is C1_0
    • 2, 3 is C2_3

There's some information in the GL Bridge SDK as well (starting on p26 for the toggle codes, and p31 for the field descriptions). For example if you look at the usdbdef.i18 file at line 488 it looks like:

1	87	Dependent Status	Dep. Status	N	1 ... 58

This is C1_87 and matches what you see on p32 of the GL Bridge SDK indicating a toggle of 58. P31 of the GL Bridge SDK shows the toggle 58 means this:

58  1=Not Applicable
    2=Taxpayer Could Be a Dependent
    3=Taxpayer Claimed as a Dependent

It's important to make a copy of the usdbdef file just in case you accidentally change something and overwrite it - the program uses this file internally.

View solution in original post