Lawson Insight Technical Documentation


ERDs Tables Elements Libraries App Forms

                            SLTRANSERR FILE

                          SL 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

UPDATED BY

GL146     GL190     GL191     GL199     GL45.1    IFGT.1
SL40.1

FIELD NAME           DESCRIPTION/VALID VALUES                    UPDATED BY

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

STE-SEGMENT-VAL-1    Alpha 32                                    GL146   GL190
Value 1              The user analysis associated with the       GL191   GL199
                     user analysis group.                        GL45.1  IFGT.1
                                                                 SL40.1

STE-SEGMENT-VAL-2    Alpha 32                                    GL146   GL190
Value 2              The user analysis associated with the       GL191   GL199
                     user analysis group.                        GL45.1  IFGT.1
                                                                 SL40.1

STE-SEGMENT-VAL-3    Alpha 32                                    GL146   GL190
Value 3              The user analysis associated with the       GL191   GL199
                     user analysis group.                        GL45.1  IFGT.1
                                                                 SL40.1

STE-SEGMENT-VAL-4    Alpha 32                                    GL146   GL190
Value 4              The user analysis associated with the       GL191   GL199
                     user analysis group.                        GL45.1  IFGT.1
                                                                 SL40.1

STE-COMPANY          Numeric 4                                   GL146   GL190
Company              The company number represents an            GL191   GL199
                     established company and is entered on       GL45.1  IFGT.1
                     all function codes.                         SL40.1

STE-FISCAL-YEAR      Numeric 4                                   GL146   GL190
Fiscal Year          This is the current fiscal year.  This      GL191   GL199
                     field is updated by GL199 (Period           GL45.1  IFGT.1
                     Closing).                                   SL40.1

STE-ACCT-PERIOD      Numeric 2                                   GL146   GL190
Accounting Period    This is the current accounting period.      GL191   GL199
                     This field is updated by GL199 (Period      GL45.1  IFGT.1
                     Closing).                                   SL40.1


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

STE-VAR-LEVELS       Alpha 30                                    GL146   GL190
Levels               A level that represents the location of     GL191   GL199
                     an accounting unit in an organization's     GL45.1  IFGT.1
                     level structure.                            SL40.1


STE-ACCT-UNIT        Alpha 15                                    GL146   GL190
Accounting Unit      The accounting unit is a shorthand          GL191   GL199
                     notation representing the variable level    GL45.1  IFGT.1
                     number. When used in the General Ledger     SL40.1
                     Account Master file, the accounting unit
                     must be defined in the General Ledger
                     Names file as a posting accounting unit.


STE-ACCOUNT          Numeric 6                                   GL146   GL190
Account              This field along with the accounting        GL191   GL199
                     unit and subaccount make up the location    GL45.1  IFGT.1
                     (account) where amounts and other           SL40.1
                     account information is stored.

STE-SUB-ACCOUNT      Numeric 4                                   GL146   GL190
Subaccount           This field along with the accounting        GL191   GL199
                     unit and subaccount make up the location    GL45.1  IFGT.1
                     (account) where amounts and other           SL40.1
                     account information is stored.

STE-SOURCE-CODE      Alpha 2                                     GL146   GL190
Source Code          A two character code assigned to a          GL191   GL199
                     transaction to identify where the           GL45.1  IFGT.1
                     transaction was created.                    SL40.1


STE-DATE             Numeric 8  (yyyymmdd)                       GL146   GL190
Date                 This field contains the system date         GL191   GL199
                     when this was created.                      GL45.1  IFGT.1
                                                                 SL40.1

STE-REFERENCE        Alpha 10  (Lower Case)                      GL146   GL190
Reference            The reference number associated with        GL191   GL199
                     the transaction.                            GL45.1  IFGT.1
                                                                 SL40.1

STE-DESCRIPTION      Alpha 30  (Lower Case)                      GL146   GL190
Description          This field contains the description.        GL191   GL199
                                                                 GL45.1  IFGT.1
                                                                 SL40.1

STE-BASE-AMOUNT      Signed 15.2                                 GL146   GL190
Base Amount          The base amount to be posted to the         GL191   GL199
                     General Ledger Account Master file.         GL45.1  IFGT.1
                                                                 SL40.1

STE-BASE-ND          Numeric 1                                   GL146   GL190
Base Currency Code   The number of decimal positions defined     GL191   GL199
                     for the company base currency.              GL45.1  IFGT.1
                                                                 SL40.1

STE-UNITS-AMOUNT     Signed 15.2                                 GL146   GL190
Units Amount         This is the units amount included in        GL191   GL199
                     the file.                                   GL45.1  IFGT.1
                                                                 SL40.1

STE-TO-COMPANY       Numeric 4                                   GL146   GL190
Company              This is the company number to which         GL191   GL199
                     this line is to be posted.                  GL45.1  IFGT.1
                                                                 SL40.1

STE-POSTING-DATE     Numeric 8  (yyyymmdd)                       GL146   GL190
Posting Date         The date assigned to the journal entry      GL191   GL199
                     for posting.                                GL45.1  IFGT.1
                                                                 SL40.1

STE-ACTIVITY         Alpha 15                                    GL146   GL190
Activity             Activities are the processes or             GL191   GL199
                     procedures that produce work. Cost          GL45.1  IFGT.1
                     objects (products, services, customers,     SL40.1
                     and so on) are the reasons for
                     performing the activity.

STE-ACCT-CATEGORY    Alpha 5                                     GL146   GL190
Account Category     Account categories are groupings of         GL191   GL199
                     costs, revenues, or a combination of        GL45.1  IFGT.1
                     both used for reporting and inquiries       SL40.1
                     for activities in the Activity
                     Management system.

STE-CURRENCY-CODE    Alpha 5                                     GL146   GL190
Currency Code        This field contains the company base        GL191   GL199
                     currency code established in GL10.1         GL45.1  IFGT.1
                     (Company).                                  SL40.1

STE-BASERATE         Signed 12.6                                 GL146   GL190
Exchange Rate        Enter the exchange rate at the time the     GL191   GL199
                     journal entry was made.  If left blank,     GL45.1  IFGT.1
                     the current exchange rate will default.     SL40.1

STE-TRAN-AMOUNT      Signed 15.2                                 GL146   GL190
Transaction Amount   This is the amount in transaction           GL191   GL199
                     currency to be posted. This amount          GL45.1  IFGT.1
                     creates a CUAMOUNT type 1 record.           SL40.1


STE-TRAN-ND          Numeric 1                                   GL146   GL190
Transaction          The number of decimal positions defined     GL191   GL199
Currency Code        for the transaction currency.               GL45.1  IFGT.1
                                                                 SL40.1

STE-ACCT-CURRENCY    Alpha 5                                     GL146   GL190
Account Currency     The account currency code associated        GL191   GL199
                     with the transaction.                       GL45.1  IFGT.1
                                                                 SL40.1

STE-ACCT-RATE        Signed 12.6                                 GL146   GL190
Exchange Rate        The exchange rate defined for the           GL191   GL199
                     currency relationship.                      GL45.1  IFGT.1
                                                                 SL40.1

STE-ACCT-AMOUNT      Signed 15.2                                 GL146   GL190
Account Amount       The transaction amount associated with      GL191   GL199
                     the account currency.                       GL45.1  IFGT.1
                                                                 SL40.1

STE-ACCT-ND          Numeric 1                                   GL146   GL190
Account Currency     The number of decimals assigned to a        GL191   GL199
Code                 particular account as determined by the     GL45.1  IFGT.1
                     account currency.                           SL40.1


STE-OPERATOR         Alpha 10                                    GL146   GL190
Operator             This field is used to store the login       GL191   GL199
                     id of the person who entered the record.    GL45.1  IFGT.1
                                                                 SL40.1

STE-TO-BASE-AMT      Signed 15.2                                 GL146   GL190
Base Amount          The amount exchanged to the company         GL191   GL199
                     base currency.                              GL45.1  IFGT.1
                                                                 SL40.1

STE-TO-BASE-ND       Numeric 1                                   GL146   GL190
Base Currency Code                                               GL191   GL199
                                                                 GL45.1  IFGT.1
                                                                 SL40.1

STE-TO-BASERATE      Signed 12.6                                 GL146   GL190
Exchange Rate        The rate used to calculate the base         GL191   GL199
                     amount from the nonbase currency            GL45.1  IFGT.1
                     transaction amount.                         SL40.1

STE-TO-BASE-CURR     Alpha 5                                     GL146   GL190
Currency Code        The amount exchanged to the company         GL191   GL199
                     base currency.                              GL45.1  IFGT.1
                                                                 SL40.1

STE-DOCUMENT-NBR     Alpha 24                                    GL146   GL190
Document Number      The number assigned to the transaction      GL191   GL199
                     (invoice, credit memo, etc.) for which      GL45.1  IFGT.1
                     the intrastat data was entered.             SL40.1

STE-HOLD-CODE        Alpha 4                                     GL146   GL190
Hold Code            The hold code.                              GL191   GL199
                                                                 GL45.1  IFGT.1
                                                                 SL40.1

STE-REL-OPERATOR     Alpha 10                                    GL146   GL190
Operator                                                         GL191   GL199
                                                                 GL45.1  IFGT.1
                                                                 SL40.1

STE-RPT-AMOUNT-1     Signed 15.2                                 GL146   GL190
Report Curency 1     The transaction amount for Report           GL191   GL199
Amount               Currency 1.                                 GL45.1  IFGT.1
                                                                 SL40.1

STE-RPT-ND-1         Numeric 1                                   GL146   GL190
Report Currency 1    The number of decimal positions for         GL191   GL199
Code                 Report Currency 1.                          GL45.1  IFGT.1
                                                                 SL40.1

STE-RPT-RATE-1       Signed 12.6                                 GL146   GL190
Exchange Rate        The exchange rate to convert the            GL191   GL199
                     transaction amount to Report Currency 1.    GL45.1  IFGT.1
                     The exchange rate is defined in CU10.1      SL40.1
                     (Exchange Rate).


STE-RPT-AMOUNT-2     Signed 15.2                                 GL146   GL190
Report Currency 2    The transaction amount for Report           GL191   GL199
Amount               Currency 2.                                 GL45.1  IFGT.1
                                                                 SL40.1

STE-RPT-RATE-2       Signed 12.6                                 GL146   GL190
Exchange Rate        The exchange rate to convert the            GL191   GL199
                     transaction amount to Report Currency 2.    GL45.1  IFGT.1
                     The exchange rate is defined in CU10.1      SL40.1
                     (Exchange Rate).


STE-RPT-ND-2         Numeric 1                                   GL146   GL190
Report Currency 2    The number of decimal positions for         GL191   GL199
Code                 Report Currency 2.                          GL45.1  IFGT.1
                                                                 SL40.1

STE-ERROR-MSG        Alpha 60                                    GL146   GL190
Error Message        The error message for the transaction.      GL191   GL199
                                                                 GL45.1  IFGT.1
                                                                 SL40.1

STE-GLT-OBJ-ID       Numeric 12                                  GL146   GL190
Object ID            This is a subsystem GL interface            GL191   GL199
                     identification number. It is used for       GL45.1  IFGT.1
                     Drill Around purposes.                      SL40.1


                         SLTRANSERR FILE INDEX

NAME      KEY FIELDS    DESCRIPTION / SUBSET CONDITION           USED IN

STESET1   OBJ-ID                                                 SL40.1

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

STESET3   GLT-OBJ-ID    KeyChange                                GL146   GL45.1
          OBJ-ID

                         SLTRANSERR FILE RELATIONS

ONE TO ONE RELATIONS


RELATION       RELATED
 NAME           FILE        INTEGRITY RULES / FIELD MATCH

Activity       ACACTIVITY   Not Required

                            STE-ACTIVITY         -> ACV-ACTIVITY

Glsystem       GLSYSTEM     Required

                            STE-COMPANY          -> GLS-COMPANY

Gltrans        GLTRANS      Required

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

Slgrouphdr     SLGROUPHDR   Required

                            STE-SEGMENT-GROUP    -> SLH-SEGMENT-GROUP

Source Code    GLSRCCODE    Required

                            STE-SOURCE-CODE      -> GSR-SOURCE-CODE

System Code    SYSTEMCODE   Required

                            STE-SYSTEM           -> SYS-SYSTEM

                         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

Apdistrib      APDISTRIB

                            STE-COMPANY          -> APD-DIST-COMPANY
                            STE-ACCT-UNIT        -> APD-DIS-ACCT-UNIT
                            STE-ACCOUNT          -> APD-DIS-ACCOUNT
                            STE-SUB-ACCOUNT      -> APD-DIS-SUB-ACCT
                            STE-POSTING-DATE     -> APD-DISTRIB-DATE
                            STE-GLT-OBJ-ID       -> APD-GLT-OBJ-ID
                                                    APD-API-OBJ-ID
                                                    APD-DIST-SEQ-NBR

Ardistrib      ARDISTRIB

                            STE-COMPANY          -> AMD-GL-COMPANY
                            STE-ACCT-UNIT        -> AMD-ACCT-UNIT
                            STE-ACCOUNT          -> AMD-ACCOUNT
                            STE-SUB-ACCOUNT      -> AMD-SUB-ACCT
                            STE-POSTING-DATE     -> AMD-GL-DATE
                            STE-GLT-OBJ-ID       -> AMD-GLT-OBJ-ID
                                                    AMD-CREATE-DATE
                                                    AMD-CREATE-TIME
                                                    AMD-PROG-SEQ-NBR

Eedistrib      EEDISTRIB

                            STE-COMPANY          -> EED-DIST-COMPANY
                            STE-ACCT-UNIT        -> EED-EXP-ACCT-UNIT
                            STE-ACCOUNT          -> EED-EXP-ACCOUNT
                            STE-SUB-ACCOUNT      -> EED-EXP-SUB-ACCT
                            STE-POSTING-DATE     -> EED-DISTRIB-DATE
                            STE-GLT-OBJ-ID       -> EED-GLT-OBJ-ID
                                                    EED-COMPANY
                                                    EED-VENDOR
                                                    EED-EXPENSE-NBR
                                                    EED-SEQ-NBR

Icmmdist       MMDIST

                            STE-GLT-OBJ-ID       -> MMD-GLT-OBJ-ID
                                                    MMD-COMPANY
                                                    MMD-SYSTEM-CD
                                                    MMD-LOCATION
                                                    MMD-DOC-TYPE
                                                    MMD-DOC-NBR
                                                    MMD-DOC-NBR-NUM
                                                    MMD-LINE-NBR
                                                    MMD-COMPONENT-SEQ
                                                    MMD-LINE-SEQ

Oedist         OEDIST

                            STE-GLT-OBJ-ID       -> ODI-GLT-OBJ-ID
                                                    ODI-INVC-PREFIX
                                                    ODI-INVC-NUMBER
                                                    ODI-AUTH-NO
                                                    ODI-LINE-NBR
                                                    ODI-SEQ
                                                    ODI-POSTING-TYPE

Pommdist       MMDIST

                            STE-GLT-OBJ-ID       -> MMD-GLT-OBJ-ID
                                                    MMD-COMPANY
                                                    MMD-SYSTEM-CD
                                                    MMD-LOCATION
                                                    MMD-DOC-TYPE
                                                    MMD-DOC-NBR
                                                    MMD-DOC-NBR-NUM
                                                    MMD-LINE-NBR
                                                    MMD-COMPONENT-SEQ
                                                    MMD-LINE-SEQ

Prdistrib      PRDISTRIB

                            STE-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

Slmxvalue      SLMXVALUE

                            STE-OBJ-ID           -> SMV-OBJ-ID
                                                    SMV-MATRIX-CAT