Lawson Insight Technical Documentation

Generated by:
Documentation generated by Decision Analytics

ERDs Tables Conditions Elements Libraries APIs Forms

SLTRANSERR


                            SLTRANSERR FILE

                          PL Transaction Error

The Strategic Transaction Error (SLTRANSERR) file stores transactions that
resulted in an error when processed in each Lawson Application that contained
user analyses. Use SL40.1 (Error Transaction Edit) to display  and correct
errors. When you release the transaction using SL40.1, the Strategic Ledger
Transaction (SLTRANS) file is updated.

When you release the transaction, the error file is removed.


REFERENCED BY

SL00.2    SL01.1    SL01.2    GL240

UPDATED BY

AC45.1    GL110     GL146     GL190     GL191     GL197
GL310     GL40.1    GL40.2    GL40.3    GL40.6    GL40.7
GL40.8    GL44.1    GL45.1    GL500     IFGT.1    SL40.1

FIELD NAME             DESCRIPTION/VALID VALUES                  UPDATED BY

STE-OBJ-ID             Numeric 12                                AC45.1  GL146
Element: Object ID     This is the object identifier. It is      GL190   GL191
                       used to relate commitments or posted      GL197   GL40.1
                       transactions back to the originating      GL40.2  GL40.3
                       subsystems. Each subsystem record that    GL40.6  GL40.7
                       is updated as a commitment or posted      GL40.8  GL44.1
                       transaction is assigned an object         GL45.1  GL500
                       identifier. The object identifier is      IFGT.1  SL40.1
                       maintained in the subsystem files and in
                       the Activity Commitments Detail and
                       Activity Transaction files. The object
                       identifier is a unique key used to drill
                       back from Activity Management to the
                       subsystems.

STE-SEGMENT-GROUP      Alpha 15                                  AC45.1  GL146
Element: User Analysis This determines the user analysis         GL190   GL191
                       values errors display for.                GL197   GL40.1
                                                                 GL40.2  GL40.3
                                                                 GL40.6  GL40.7
                                                                 GL40.8  GL44.1
                                                                 GL45.1  GL500
                                                                 IFGT.1  SL40.1

STE-COMPANY            Numeric 4                                 AC45.1  GL146
Element: Company       Identifies the AP company if the          GL190   GL191
                       resource type = V.  Identifies the HR     GL197   GL40.1
                       company if the resource type = E.  It is  GL40.2  GL40.3
                       blank for type A, P or Q resources.       GL40.6  GL40.7
                                                                 GL40.8  GL44.1
                                                                 GL45.1  GL500
                                                                 IFGT.1  SL40.1

STE-FISCAL-YEAR        Numeric 4                                 AC45.1  GL146
Element: Fiscal Year   This is the current fiscal year.  This    GL190   GL191
                       field is updated by Period Closing        GL197   GL40.1
                       (GL199).                                  GL40.2  GL40.3
                                                                 GL40.6  GL40.7
                                                                 GL40.8  GL44.1
                                                                 GL45.1  GL500
                                                                 IFGT.1  SL40.1

STE-ACCT-PERIOD        Numeric 2                                 AC45.1  GL146
Element: Accounting PerThis is the current accounting period.    GL190   GL191
                       This field is updated by GL199 (Period    GL197   GL40.1
                       Closing).                                 GL40.2  GL40.3
                                                                 GL40.6  GL40.7
                                                                 GL40.8  GL44.1
                                                                 GL45.1  GL500
                                                                 IFGT.1  SL40.1

STE-SYSTEM             Alpha 2                                   AC45.1  GL146
Element: System        A two-character code representing an      GL190   GL191
                       application used within the Lawson        GL197   GL40.1
                       system. (i.e.: GL = General Ledger, AP =  GL40.2  GL40.3
                       Accounts Payable, etc.)                   GL40.6  GL40.7
                                                                 GL40.8  GL44.1
                                                                 GL45.1  GL500
                                                                 IFGT.1  SL40.1

STE-VAR-LEVELS         Alpha 30                                  AC45.1  GL146
Element: Variable LevelA level that represents the location of   GL190   GL191
                       an accounting unit in an organization's   GL197   GL40.1
                       level structure.                          GL40.2  GL40.3
                                                                 GL40.6  GL40.7
                                                                 GL40.8  GL44.1
                                                                 GL45.1  GL500
                                                                 IFGT.1  SL40.1

STE-ACCT-UNIT          Alpha 15                                  AC45.1  GL146
Element: Accounting UniThe accounting unit is a shorthand        GL190   GL191
                       notation representing the variable level  GL197   GL40.1
                       number. When used in the General Ledger   GL40.2  GL40.3
                       Account Master file, the accounting unit  GL40.6  GL40.7
                       must be defined in the General Ledger     GL40.8  GL44.1
                       Names file as a posting accounting unit.  GL45.1  GL500
                                                                 IFGT.1  SL40.1

STE-ACCOUNT            Numeric 6                                 AC45.1  GL146
Element: Account       This field along with the accounting      GL190   GL191
                       unit and subaccount make up the location  GL197   GL40.1
                       (account) where amounts and other         GL40.2  GL40.3
                       account information is stored.            GL40.6  GL40.7
                                                                 GL40.8  GL44.1
                                                                 GL45.1  GL500
                                                                 IFGT.1  SL40.1

STE-SUB-ACCOUNT        Numeric 4                                 AC45.1  GL146
Element: Subaccount    This field along with the accounting      GL190   GL191
                       unit and subaccount make up the location  GL197   GL40.1
                       (account) where amounts and other         GL40.2  GL40.3
                       account information is stored.            GL40.6  GL40.7
                                                                 GL40.8  GL44.1
                                                                 GL45.1  GL500
                                                                 IFGT.1  SL40.1

STE-SOURCE-CODE        Alpha 2                                   AC45.1  GL146
Element: Source Code   A two character code assigned to a        GL190   GL191
                       transaction to identify where the         GL197   GL40.1
                       transaction was created.                  GL40.2  GL40.3
                                                                 GL40.6  GL40.7
                                                                 GL40.8  GL44.1
                                                                 GL45.1  GL500
                                                                 IFGT.1  SL40.1

STE-DATE               Numeric 8  (yyyymmdd)                     AC45.1  GL146
Element: Date          This field displays the system date       GL190   GL191
                       when this was created.                    GL197   GL40.1
                                                                 GL40.2  GL40.3
                                                                 GL40.6  GL40.7
                                                                 GL40.8  GL44.1
                                                                 GL45.1  GL500
                                                                 IFGT.1  SL40.1

STE-REFERENCE          Alpha 10  (Lower Case)                    AC45.1  GL146
Element: Reference     The reference number associated with      GL190   GL191
                       the transaction.                          GL197   GL40.1
                                                                 GL40.2  GL40.3
                                                                 GL40.6  GL40.7
                                                                 GL40.8  GL44.1
                                                                 GL45.1  GL500
                                                                 IFGT.1  SL40.1

STE-DESCRIPTION        Alpha 30  (Lower Case)                    AC45.1  GL146
Element: Description   This field displays the description.      GL190   GL191
                                                                 GL197   GL40.1
                                                                 GL40.2  GL40.3
                                                                 GL40.6  GL40.7
                                                                 GL40.8  GL44.1
                                                                 GL45.1  GL500
                                                                 IFGT.1  SL40.1

STE-BASE-AMOUNT        Signed 18.2                               AC45.1  GL146
Element: Base Amount   The base amount to be posted to the       GL190   GL191
                       General Ledger Account Master file.       GL197   GL40.1
                                                                 GL40.2  GL40.3
                                                                 GL40.6  GL40.7
                                                                 GL40.8  GL44.1
                                                                 GL45.1  GL500
                                                                 IFGT.1  SL40.1

STE-BASE-ND            Numeric 1                                 AC45.1  GL146
Base Number Of         The number of decimal positions defined   GL190   GL191
Decimals               for the company base currency.            GL197   GL40.1
                                                                 GL40.2  GL40.3
                                                                 GL40.6  GL40.7
                                                                 GL40.8  GL44.1
                                                                 GL45.1  GL500
                                                                 IFGT.1  SL40.1

STE-UNITS-AMOUNT       Signed 15.2                               AC45.1  GL146
Element: Units Amount  This is the units amount included in      GL190   GL191
                       the file.                                 GL197   GL40.1
                                                                 GL40.2  GL40.3
                                                                 GL40.6  GL40.7
                                                                 GL40.8  GL44.1
                                                                 GL45.1  GL500
                                                                 IFGT.1  SL40.1

STE-TO-COMPANY         Numeric 4                                 AC45.1  GL146
Element: Company       This is the company number to which       GL190   GL191
                       this line is to be posted.                GL197   GL40.1
                                                                 GL40.2  GL40.3
                                                                 GL40.6  GL40.7
                                                                 GL40.8  GL44.1
                                                                 GL45.1  GL500
                                                                 IFGT.1  SL40.1

STE-POSTING-DATE       Numeric 8  (yyyymmdd)                     AC45.1  GL146
Element: Posting Date  The date assigned to the journal entry    GL190   GL191
                       for posting.                              GL197   GL40.1
                                                                 GL40.2  GL40.3
                                                                 GL40.6  GL40.7
                                                                 GL40.8  GL44.1
                                                                 GL45.1  GL500
                                                                 IFGT.1  SL40.1

STE-ACTIVITY           Alpha 15                                  AC45.1  GL146
Element: Activity      Activities are the processes or           GL190   GL191
                       procedures that produce work. Cost        GL197   GL40.1
                       objects (products, services, customers,   GL40.2  GL40.3
                       and so on) are the reasons for            GL40.6  GL40.7
                       performing the activity.                  GL40.8  GL44.1
                                                                 GL45.1  GL500
                                                                 IFGT.1  SL40.1

STE-ACCT-CATEGORY      Alpha 5                                   AC45.1  GL146
Element: Account CategoAccount categories are groupings of       GL190   GL191
                       costs, revenues, or a combination of      GL197   GL40.1
                       both used for reporting and inquiries     GL40.2  GL40.3
                       for activities in the Activity            GL40.6  GL40.7
                       Management system.                        GL40.8  GL44.1
                                                                 GL45.1  GL500
                                                                 IFGT.1  SL40.1

STE-CURRENCY-CODE      Alpha 5                                   AC45.1  GL146
Element: Currency Code This field contains the company base      GL190   GL191
                       currency code established in Company      GL197   GL40.1
                       (GL10.1 ).                                GL40.2  GL40.3
                                                                 GL40.6  GL40.7
                                                                 GL40.8  GL44.1
                                                                 GL45.1  GL500
                                                                 IFGT.1  SL40.1

STE-BASERATE           Signed 14.7                               AC45.1  GL146
Element: Currency Rate Enter the exchange rate at the time the   GL190   GL191
                       journal entry was made.  If left blank,   GL197   GL40.1
                       the current exchange rate will default.   GL40.2  GL40.3
                                                                 GL40.6  GL40.7
                                                                 GL40.8  GL44.1
                                                                 GL45.1  GL500
                                                                 IFGT.1  SL40.1

STE-TRAN-AMOUNT        Signed 18.2                               AC45.1  GL146
Element: Intl Amt      This is the amount in transaction         GL190   GL191
                       currency to be posted. This amount        GL197   GL40.1
                       creates a CUAMOUNT type 1 record.         GL40.2  GL40.3
                                                                 GL40.6  GL40.7
                                                                 GL40.8  GL44.1
                                                                 GL45.1  GL500
                                                                 IFGT.1  SL40.1

STE-TRAN-ND            Numeric 1                                 AC45.1  GL146
Account Currency       The number of decimal positions defined   GL190   GL191
Code                   for the transaction currency.             GL197   GL40.1
                                                                 GL40.2  GL40.3
                                                                 GL40.6  GL40.7
                                                                 GL40.8  GL44.1
                                                                 GL45.1  GL500
                                                                 IFGT.1  SL40.1

STE-ACCT-CURRENCY      Alpha 5                                   AC45.1  GL146
Element: Currency Code The account currency code associated      GL190   GL191
                       with the transaction.                     GL197   GL40.1
                                                                 GL40.2  GL40.3
                                                                 GL40.6  GL40.7
                                                                 GL40.8  GL44.1
                                                                 GL45.1  GL500
                                                                 IFGT.1  SL40.1

STE-ACCT-RATE          Signed 14.7                               AC45.1  GL146
Element: Currency Rate The exchange rate defined for the         GL190   GL191
                       currency relationship.                    GL197   GL40.1
                                                                 GL40.2  GL40.3
                                                                 GL40.6  GL40.7
                                                                 GL40.8  GL44.1
                                                                 GL45.1  GL500
                                                                 IFGT.1  SL40.1

STE-ACCT-AMOUNT        Signed 18.2                               AC45.1  GL146
Element: Intl Amt      The transaction amount associated with    GL190   GL191
                       the account currency.                     GL197   GL40.1
                                                                 GL40.2  GL40.3
                                                                 GL40.6  GL40.7
                                                                 GL40.8  GL44.1
                                                                 GL45.1  GL500
                                                                 IFGT.1  SL40.1

STE-ACCT-ND            Numeric 1                                 AC45.1  GL146
Account Currency       The number of decimals assigned to a      GL190   GL191
Code                   particular account as determined by the   GL197   GL40.1
                       account currency.                         GL40.2  GL40.3
                                                                 GL40.6  GL40.7
                                                                 GL40.8  GL44.1
                                                                 GL45.1  GL500
                                                                 IFGT.1  SL40.1

STE-OPERATOR           Alpha 10                                  AC45.1  GL146
Element: Operator Code This field is used to store the login     GL190   GL191
                       id of the person who entered the record.  GL197   GL40.1
                                                                 GL40.2  GL40.3
                                                                 GL40.6  GL40.7
                                                                 GL40.8  GL44.1
                                                                 GL45.1  GL500
                                                                 IFGT.1  SL40.1

STE-TO-BASE-AMT        Signed 18.2                               AC45.1  GL146
Element: Intl Amt      The amount exchanged to the company       GL190   GL191
                       base currency.                            GL197   GL40.1
                                                                 GL40.2  GL40.3
                                                                 GL40.6  GL40.7
                                                                 GL40.8  GL44.1
                                                                 GL45.1  GL500
                                                                 IFGT.1  SL40.1

STE-TO-BASE-ND         Numeric 1                                 AC45.1  GL146
Account Currency                                                 GL190   GL191
Code                                                             GL197   GL40.1
                                                                 GL40.2  GL40.3
                                                                 GL40.6  GL40.7
                                                                 GL40.8  GL44.1
                                                                 GL45.1  GL500
                                                                 IFGT.1  SL40.1

STE-TO-BASERATE        Signed 14.7                               AC45.1  GL146
Element: Currency Rate The rate used to calculate the base       GL190   GL191
                       amount from the nonbase currency          GL197   GL40.1
                       transaction amount.                       GL40.2  GL40.3
                                                                 GL40.6  GL40.7
                                                                 GL40.8  GL44.1
                                                                 GL45.1  GL500
                                                                 IFGT.1  SL40.1

STE-TO-BASE-CURR       Alpha 5                                   AC45.1  GL146
Element: Currency Code The amount exchanged to the company       GL190   GL191
                       base currency.                            GL197   GL40.1
                                                                 GL40.2  GL40.3
                                                                 GL40.6  GL40.7
                                                                 GL40.8  GL44.1
                                                                 GL45.1  GL500
                                                                 IFGT.1  SL40.1

STE-DOCUMENT-NBR       Alpha 27                                  AC45.1  GL146
Element: Document NumbeThe number assigned to the transaction    GL190   GL191
                       (invoice, credit memo, etc.) for which    GL197   GL40.1
                       the intrastat data was entered.           GL40.2  GL40.3
                                                                 GL40.6  GL40.7
                                                                 GL40.8  GL44.1
                                                                 GL45.1  GL500
                                                                 IFGT.1  SL40.1

STE-HOLD-CODE          Alpha 4                                   AC45.1  GL146
Element: Hold Code     The hold code.                            GL190   GL191
                                                                 GL197   GL40.1
                                                                 GL40.2  GL40.3
                                                                 GL40.6  GL40.7
                                                                 GL40.8  GL44.1
                                                                 GL45.1  GL500
                                                                 IFGT.1  SL40.1

STE-REL-OPERATOR       Alpha 10                                  AC45.1  GL146
Element: Operator Code                                           GL190   GL191
                                                                 GL197   GL40.1
                                                                 GL40.2  GL40.3
                                                                 GL40.6  GL40.7
                                                                 GL40.8  GL44.1
                                                                 GL45.1  GL500
                                                                 IFGT.1  SL40.1

STE-RPT-AMOUNT-1       Signed 18.2                               AC45.1  GL146
Element: Intl Amt      The transaction amount for Report         GL190   GL191
                       Currency 1.                               GL197   GL310
                                                                 GL40.1  GL40.2
                                                                 GL40.3  GL40.6
                                                                 GL40.7  GL40.8
                                                                 GL44.1  GL45.1
                                                                 GL500   IFGT.1
                                                                 SL40.1

STE-RPT-ND-1           Numeric 1                                 AC45.1  GL146
Account Currency       The number of decimal positions for       GL190   GL191
Code                   Report Currency 1.                        GL197   GL310
                                                                 GL40.1  GL40.2
                                                                 GL40.3  GL40.6
                                                                 GL40.7  GL40.8
                                                                 GL44.1  GL45.1
                                                                 GL500   IFGT.1
                                                                 SL40.1

STE-RPT-RATE-1         Signed 14.7                               AC45.1  GL146
Element: Currency Rate The exchange rate to convert the          GL190   GL191
                       transaction amount to Report Currency 1.  GL197   GL310
                       The exchange rate is defined in CU10.1    GL40.1  GL40.2
                       (Exchange Rate).                          GL40.3  GL40.6
                                                                 GL40.7  GL40.8
                                                                 GL44.1  GL45.1
                                                                 GL500   IFGT.1
                                                                 SL40.1

STE-RPT-AMOUNT-2       Signed 18.2                               AC45.1  GL146
Element: Intl Amt      The transaction amount for Report         GL190   GL191
                       Currency 2.                               GL197   GL310
                                                                 GL40.1  GL40.2
                                                                 GL40.3  GL40.6
                                                                 GL40.7  GL40.8
                                                                 GL44.1  GL45.1
                                                                 GL500   IFGT.1
                                                                 SL40.1

STE-RPT-RATE-2         Signed 14.7                               AC45.1  GL146
Element: Currency Rate The exchange rate to convert the          GL190   GL191
                       transaction amount to Report Currency 2.  GL197   GL310
                       The exchange rate is defined in CU10.1    GL40.1  GL40.2
                       (Exchange Rate).                          GL40.3  GL40.6
                                                                 GL40.7  GL40.8
                                                                 GL44.1  GL45.1
                                                                 GL500   IFGT.1
                                                                 SL40.1

STE-RPT-ND-2           Numeric 1                                 AC45.1  GL146
Account Currency       The number of decimal positions for       GL190   GL191
Code                   Report Currency 2.                        GL197   GL310
                                                                 GL40.1  GL40.2
                                                                 GL40.3  GL40.6
                                                                 GL40.7  GL40.8
                                                                 GL44.1  GL45.1
                                                                 GL500   IFGT.1
                                                                 SL40.1

STE-ERROR-MSG          Alpha 60                                  AC45.1  GL146
Element: Err Message   The error message for the transaction.    GL190   GL191
                                                                 GL197   GL40.1
                                                                 GL40.2  GL40.3
                                                                 GL40.7  GL40.8
                                                                 GL44.1  GL45.1
                                                                 GL500   IFGT.1
                                                                 SL40.1

STE-GLT-OBJ-ID         Numeric 12                                AC45.1  GL146
Object                 This is a subsystem GL interface          GL190   GL191
Identification         identification number. It is used for     GL197   GL40.1
                       Drill Around purposes.                    GL40.2  GL40.3
                                                                 GL40.6  GL40.7
                                                                 GL40.8  GL44.1
                                                                 GL45.1  GL500
                                                                 IFGT.1  SL40.1

STE-SEGMENT-BLOCK      Alpha 103                                 AC45.1  GL146
Element: User Analysis This field identifies the user analysis   GL190   GL191
                       values included in the transaction.       GL197   GL40.1
                                                                 GL40.2  GL40.3
                       You can either type up to four values     GL40.6  GL40.7
                       or use Define (F6) to open the User       GL40.8  GL44.1
                       Analysis Entry subform. Use this subform  GL45.1  GL500
                       to select the user analysis values you    IFGT.1  SL40.1
                       want to include in the transaction. If
                       you choose to type values, use commas to
                       separate them. For example:
                       value1,value2,value3,value4

                       There are three conditions that affect
                       how you can select user analysis values.
                       See the User Analysis Entry form help or
                       the Strategic Ledger procedures manual
                       for additional information.

                         SLTRANSERR FILE INDEX

NAME      KEY FIELDS    DESCRIPTION / SUBSET CONDITION           USED IN

STESET1   OBJ-ID                                                 GL500   SL40.1

STESET2   SEGMENT-GROUP KeyChange                                GL110   SL00.2
          COMPANY                                                SL01.1  SL01.2
          ACCT-UNIT                                              SL40.1
          ACCOUNT
          SUB-ACCOUNT
          OBJ-ID

STESET3   GLT-OBJ-ID    KeyChange                                AC45.1  GL146
          OBJ-ID                                                 GL190   GL197
                                                                 GL240   GL310
                                                                 GL40.1  GL40.2
                                                                 GL40.3  GL40.6
                                                                 GL40.7  GL40.8
                                                                 GL44.1  GL45.1

                         SLTRANSERR FILE RELATIONS

ONE TO ONE RELATIONS


RELATION       RELATED
 NAME           FILE        INTEGRITY RULES / FIELD MATCH

Gltrans        GLTRANS      Required

                            STE-GLT-OBJ-ID     -> GLT-OBJ-ID

                         SLTRANSERR FILE RELATIONS

ONE TO MANY RELATIONS


RELATION       RELATED
 NAME           FILE        INTEGRITY RULES / FIELD MATCH

Actrans        ACTRANS

                            STE-GLT-OBJ-ID     -> ATN-GLT-OBJ-ID
                                                  ATN-OBJ-ID

Amtrans        AMTRANS

                            STE-GLT-OBJ-ID     -> AMT-GLT-OBJ-ID
                                                  AMT-ASSET
                                                  AMT-SEQ-NUMBER

Prdistrib      PRDISTRIB

                            STE-TO-COMPANY     -> PRD-DIST-COMPANY
                            STE-ACCT-UNIT      -> PRD-DST-ACCT-UNIT
                            STE-ACCOUNT        -> PRD-DST-ACCOUNT
                            STE-SUB-ACCOUNT    -> PRD-DST-SUB-ACCT
                            STE-GLT-OBJ-ID     -> PRD-GLT-OBJ-ID
                                                  PRD-OBJ-ID