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

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

FIELD NAME             DESCRIPTION/VALID VALUES                  UPDATED BY

STE-OBJ-ID             Numeric 12                                GL146   GL190
Element: Object ID     This is the object identifier. It is      GL191   GL197
                       used to relate commitments or posted      GL40.1  GL40.2
                       transactions back to the originating      GL40.3  GL40.6
                       subsystems. Each subsystem record that    GL40.7  GL40.8
                       is updated as a commitment or posted      GL44.1  GL45.1
                       transaction is assigned an object         IFGT.1  SL40.1
                       identifier. The object identifier is
                       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                                  GL146   GL190
Element: User Analysis This determines the user analysis         GL191   GL197
                       values errors display for.                GL40.1  GL40.2
                                                                 GL40.3  GL40.6
                                                                 GL40.7  GL40.8
                                                                 GL44.1  GL45.1
                                                                 IFGT.1  SL40.1

STE-COMPANY            Numeric 4                                 GL146   GL190
Element: Company       The company number represents an          GL191   GL197
                       established company and is entered on     GL40.1  GL40.2
                       all function codes.                       GL40.3  GL40.6
                                                                 GL40.7  GL40.8
                                                                 GL44.1  GL45.1
                                                                 IFGT.1  SL40.1

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

STE-ACCT-PERIOD        Numeric 2                                 GL146   GL190
Element: Accounting Period                                       GL191   GL197
                                                                 GL40.1  GL40.2
                                                                 GL40.3  GL40.6
                                                                 GL40.7  GL40.8
                                                                 GL44.1  GL45.1
                                                                 IFGT.1  SL40.1

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

STE-VAR-LEVELS         Alpha 30                                  GL146   GL190
Element: Variable Levels                                         GL191   GL197
                                                                 GL40.1  GL40.2
                                                                 GL40.3  GL40.6
                                                                 GL40.7  GL40.8
                                                                 GL44.1  GL45.1
                                                                 IFGT.1  SL40.1

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


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

STE-SUB-ACCOUNT        Numeric 4                                 GL146   GL190
Element: Subaccount                                              GL191   GL197
                                                                 GL40.1  GL40.2
                                                                 GL40.3  GL40.6
                                                                 GL40.7  GL40.8
                                                                 GL44.1  GL45.1
                                                                 IFGT.1  SL40.1

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

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

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

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

STE-BASE-AMOUNT        Signed 15.2                               GL146   GL190
Element: Base Amount                                             GL191   GL197
                                                                 GL40.1  GL40.2
                                                                 GL40.3  GL40.6
                                                                 GL40.7  GL40.8
                                                                 GL44.1  GL45.1
                                                                 IFGT.1  SL40.1

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

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

STE-TO-COMPANY         Numeric 4                                 GL146   GL190
Element: Company                                                 GL191   GL197
                                                                 GL40.1  GL40.2
                                                                 GL40.3  GL40.6
                                                                 GL40.7  GL40.8
                                                                 GL44.1  GL45.1
                                                                 IFGT.1  SL40.1

STE-POSTING-DATE       Numeric 8  (yyyymmdd)                     GL146   GL190
Element: Date                                                    GL191   GL197
                                                                 GL40.1  GL40.2
                                                                 GL40.3  GL40.6
                                                                 GL40.7  GL40.8
                                                                 GL44.1  GL45.1
                                                                 IFGT.1  SL40.1

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

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

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

STE-BASERATE           Signed 12.6                               GL146   GL190
Element: Account Rate                                            GL191   GL197
                                                                 GL40.1  GL40.2
                                                                 GL40.3  GL40.6
                                                                 GL40.7  GL40.8
                                                                 GL44.1  GL45.1
                                                                 IFGT.1  SL40.1

STE-TRAN-AMOUNT        Signed 15.2                               GL146   GL190
Element: Adj Amt                                                 GL191   GL197
                                                                 GL40.1  GL40.2
                                                                 GL40.3  GL40.6
                                                                 GL40.7  GL40.8
                                                                 GL44.1  GL45.1
                                                                 IFGT.1  SL40.1

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

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

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

STE-ACCT-AMOUNT        Signed 15.2                               GL146   GL190
Element: Adj Amt                                                 GL191   GL197
                                                                 GL40.1  GL40.2
                                                                 GL40.3  GL40.6
                                                                 GL40.7  GL40.8
                                                                 GL44.1  GL45.1
                                                                 IFGT.1  SL40.1

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

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

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

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

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

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

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

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

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

STE-RPT-AMOUNT-1       Signed 15.2                               GL146   GL190
Element: Adj Amt                                                 GL191   GL197
                                                                 GL310   GL40.1
                                                                 GL40.2  GL40.3
                                                                 GL40.6  GL40.7
                                                                 GL40.8  GL44.1
                                                                 GL45.1  IFGT.1
                                                                 SL40.1

STE-RPT-ND-1           Numeric 1                                 GL146   GL190
Account Currency                                                 GL191   GL197
Code                                                             GL310   GL40.1
                                                                 GL40.2  GL40.3
                                                                 GL40.6  GL40.7
                                                                 GL40.8  GL44.1
                                                                 GL45.1  IFGT.1
                                                                 SL40.1

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

STE-RPT-AMOUNT-2       Signed 15.2                               GL146   GL190
Report Currency 2      The transaction amount for Report         GL191   GL197
Amount                 Currency 2.                               GL310   GL40.1
                                                                 GL40.2  GL40.3
                                                                 GL40.6  GL40.7
                                                                 GL40.8  GL44.1
                                                                 GL45.1  IFGT.1
                                                                 SL40.1

STE-RPT-RATE-2         Signed 12.6                               GL146   GL190
Element: Rpt Rate 1                                              GL191   GL197
                                                                 GL310   GL40.1
                                                                 GL40.2  GL40.3
                                                                 GL40.6  GL40.7
                                                                 GL40.8  GL44.1
                                                                 GL45.1  IFGT.1
                                                                 SL40.1

STE-RPT-ND-2           Numeric 1                                 GL146   GL190
Element: Rpt Nd 2      The number of decimal positions for       GL191   GL197
                       Report Currency 2.                        GL310   GL40.1
                                                                 GL40.2  GL40.3
                                                                 GL40.6  GL40.7
                                                                 GL40.8  GL44.1
                                                                 GL45.1  IFGT.1
                                                                 SL40.1

STE-ERROR-MSG          Alpha 60                                  GL146   GL190
Element: Err Message                                             GL191   GL197
                                                                 GL40.1  GL40.2
                                                                 GL40.3  GL40.7
                                                                 GL40.8  GL44.1
                                                                 GL45.1  IFGT.1
                                                                 SL40.1

STE-GLT-OBJ-ID         Numeric 12                                GL146   GL190
Object                                                           GL191   GL197
Identification                                                   GL40.1  GL40.2
                                                                 GL40.3  GL40.6
                                                                 GL40.7  GL40.8
                                                                 GL44.1  GL45.1
                                                                 IFGT.1  SL40.1

STE-SEGMENT-BLOCK      Alpha 103                                 GL146   GL190
Element: User Analysis This field identifies the user analysis   GL191   GL197
                       values included in the transaction.       GL40.1  GL40.2
                                                                 GL40.3  GL40.6
                       You can either type up to four values     GL40.7  GL40.8
                       or use Define (F6) to open the User       GL44.1  GL45.1
                       Analysis Entry subform. Use this subform  IFGT.1  SL40.1
                       to select the user analysis values you
                       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                                                 SL40.1

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

STESET3   GLT-OBJ-ID    KeyChange                                GL146   GL190
          OBJ-ID                                                 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