Understanding Database Tables

This topic provides information about understanding how to interpret the database table information.

Understanding General Ledger Table Information

Each Table describes the fields that exist in each record in a table or file within the database.  The table below describes the information that is displayed in a General Ledger Table.

Note:  To see a list of Tables for the files in the software module, refer to the Invision General Ledger Database Overview.

Table Columns

Field Name Column

Lists the name of the field.  All tables are made up of one or more fields.

Notes:

  • The field name is required for the report or project that you build using iKnowSys or a third-party application, such as, Crystal Reports™.

  • Frequently, you can click the field name to see more information about the field and where it is used.

Datatype Column

Defines what type of data the field contains and sometimes describes the field format.  This information may be helpful when planning your project.

  • decimal(x,y):  Indicates a numeric field with digits to the left and right of the decimal place where x is the number of digits to the left of the decimal and y is the number of digits to the right of the decimal.
    Example    :  (4,2) means 4 digits to the left and 2 digits to the right of the decimal, a total of 6 digits.

  • int:  Indicates a four-byte integer value that supports numbers from -2147483648 to 2147483647.

  • varchar:  Indicates an alphanumeric field that contains a string of text.  A text string can contain any combination of characters including letters, words, numbers, and spaces.

  • time:  Indicates a time value.

  • date:  Indicates a date value.