Table naming convention

The table name of an LN table stored in Oracle has this format.

t<DD Table name><Company number>

The explanation of the table name:

• DD Table Name

  The name of the table used in the data dictionary, which consists of a package designation, a module designation, and a table number, as follows:

  <DD Table name> = <package><module><table number>

  • Package: A two-letter code that refers to the LN package that created the table. For example, a table created by the LN Tools package has the package code tt.
  • Module: A three-letter code that refers to the LN module in a package that created the table. For example, a table that the LN Distribution Sales module creates has the module code sls.
  • Table number: A three-digit code that refers to a table that belongs to an LN module.
• Company Number:

  Used in LN to differentiate areas of functionality. A company must exist with the number 000. Additionally, several other company numbers can exist.

  For example, the data dictionary table ttadv999 with company number 000 is created in Oracle as tttadv999000.

  Note: 

  • For tables with the Multi language Application Data feature enabled, a secondary table exists, named as:

    s<DD Table name><Company number>

  • For tables with the Document Authorization (DBCM) feature enabled, another secondary table exists, named as:

    v<DD Table name><Company number>