Table naming convention

The name of an LN table that is stored in SQL Server has this format:

t<Package><Module><Table number><Company number>

This list shows the components of the table name:

• Package

  Package is a two-letter identifier that refers to the LN package where the table is defined. For example, a table that is defined in the LN Tools package has the package code tt.

• Module

  Module is a three-letter identifier for the subset of the package that defines the table. For example, a table that the LN Distribution Sales module creates has the module code sls.

• Table Number

  The table number is a three-digit number uniquely identifying the table within the module that it was defined. The number often indicates the order in which the table was defined in the module.

• Company Number

  Within LN, three digit company numbers are used to isolate data sets used for different purposes (for example; demo data, training data, production data). There must be a company with the number 000. Company 000 contains master data common to all companies. This data includes currencies and languages used. In addition to Company 000, there must be several other company numbers.

  For example, the table 999 in module adv with company number 000 is created in SQL Server as tttadv999000.

  Note: 

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

    s<Package><Module><Table number><Company number>

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

    v<Package><Module><Table number><Company number>