LANGPREF – Language Definition
- System
- General Ledger Setup (IF)
- Prefix
DUG- Primary key
LANGUAGE-CODE- Fields
- 19
- Updated by
- 1 program
- Referenced by
- 3 programs
LANGPREF is the Language Definition table in Lawson General Ledger Setup (prefix DUG). It is indexed by LANGUAGE-CODE (DUGSET1). It is updated by GL19.1 and referenced by AP10.1, CB00.5 and GL219. The table has 19 fields, 1 index and 0 documented relations.
About LANGPREF
The language preference file maintains and validates language codes(locales) that are associated with a customer or vendor. In addition, it maintains translated report headings pertaining to dunning for each language. The file is updated by IFLC (Language Code Maintenance), AR19.2 (Language Code Maintenance) and AR19.3 (Translate Dunning Headings). A default language can be associated to customers in AR08.1 (Customer Defaults) and overridden for each customer in AR10.1 (Customer).
Fields (19)
Column = COBOL field name without the DUG- prefix, hyphens → underscores. Derived fields are computed by the application and are not stored.
| Field / column | Type | Description & values | Updated by |
|---|---|---|---|
DUG-LANGUAGE-CODE PKLANGUAGE_CODE | Alpha 10 | The language code. Must be full capped and defined in the environment program LANGDEF as well. | GL19.1 |
DUG-DESCRIPTIONDESCRIPTION | Alpha 30 (Lower Case) | The description of the language. | GL19.1 |
DUG-PAGE-LITPAGE_LIT | Alpha 18 (Lower Case) | The page column heading in the dunning letter. Use 19.3 (Translate Dunning Headings) to translate this heading. | — |
DUG-DATE-LITDATE_LIT | Alpha 18 (Lower Case) | The Date column heading in the dunning letter. Use 19.3 (Translate Dunning Headings) to translate this heading. | — |
DUG-CUSTOMER-LITCUSTOMER_LIT | Alpha 18 (Lower Case) | The Customer column heading in the dunning letter. Use 19.3 (Translate Dunning Headings) to translate this heading. | — |
DUG-INVOICE-LITINVOICE_LIT | Alpha 10 | — | — |
DUG-TRANS-DT-LIT1TRANS_DT_LIT1 | Alpha 8 (Lower Case) | The Trans part of the Trans Date column heading in the dunning letter. Use 19.3 (Translate Dunning Headings) to translate this heading. | — |
DUG-TRANS-DT-LIT2TRANS_DT_LIT2 | Alpha 8 (Lower Case) | The Date part of the Trans Date column heading in the dunning letter. Use 19.3 (Translate Dunning Headings) to translate this heading. | — |
DUG-DUE-DATE-LIT1DUE_DATE_LIT1 | Alpha 8 (Lower Case) | The Due part of the Due Date column heading in the dunning letter. Use 19.3 (Translate Dunning Headings) to translate this heading. | — |
DUG-DUE-DATE-LIT2DUE_DATE_LIT2 | Alpha 8 (Lower Case) | The Date part of the Due Date column heading in the dunning letter. Use 19.3 (Translate Dunning Headings) to translate this heading. | — |
DUG-DUE-DAYS-LIT1DUE_DAYS_LIT1 | Alpha 6 (Lower Case) | The Due part of the Due Days column heading in the dunning letter. Use 19.3 (Translate Dunning Headings) to translate this heading. | — |
DUG-DUE-DAYS-LIT2DUE_DAYS_LIT2 | Alpha 6 (Lower Case) | The Days part of the Due Days column heading in the dunning letter. Use 19.3 (Translate Dunning Headings) to translate this heading. | — |
DUG-ORIG-AMT-LITORIG_AMT_LIT | Alpha 11 (Lower Case) | The Orig Amount column heading in the dunning letter. Use 19.3 (Translate Dunning Headings) to translate this heading. | — |
DUG-OPEN-AMT-LITOPEN_AMT_LIT | Alpha 11 (Lower Case) | The Open Amount column heading in the dunning letter. Use 19.3 (Translate Dunning Headings) to translate this heading. | — |
DUG-CURR-LITCURR_LIT | Alpha 7 (Lower Case) | The Curr column heading in the dunning letter. Use 19.3 (Translate Dunning Headings) to translate this heading. | — |
DUG-DUNNED-LITDUNNED_LIT | Alpha 6 (Lower Case) | The Dunned column heading in the dunning letter. Use 19.3 (Translate Dunning Headings) to translate this heading. | — |
DUG-TOTAL-OPEN-LITTOTAL_OPEN_LIT | Alpha 22 (Lower Case) | The Total Open column heading in the dunning letter. Use 19.3 (Translate Dunning Headings) to translate this heading. | — |
DUG-TOTAL-DUNN-LITTOTAL_DUNN_LIT | Alpha 22 (Lower Case) | The Total Dunned column heading in the dunning letter. Use 19.3 (Translate Dunning Headings) to translate this heading. | — |
DUG-TOTAL-FEE-LITTOTAL_FEE_LIT | Alpha 22 (Lower Case) | The Total Fee column heading in the dunning letter. Use 19.3 (Translate Dunning Headings) to translate this heading. | — |
Indexes (1)
Keys marked * are descending. Every documented Lawson index is unique unless flagged Duplicates; Subset indexes carry a Where condition.
| Index | Keys | Flags | Condition | Used in |
|---|---|---|---|---|
DUGSET1 | LANGUAGE-CODE | Primary | AP10.1, CB00.5, GL19.1, GL219 |
Programs
Updated by (1)
- GL19.1 Language Code Maintenance