Lawson Software

Lawson Insight Technical Documentation

Generated by:
Documentation generated by Decision Analytics

ERDs Tables Elements Libraries App Forms


                            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.


UPDATED BY

GL146     GL190     GL191     GL199     GL310     GL45.1
IFGT.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
                     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


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.

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

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).

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 =
                     Accounts Payable, etc.)

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


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

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

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

STE-DESCRIPTION      Alpha 30  (Lower Case)                      GL146   GL190
Description          This field displays the description.        GL191   GL199
                                                                 GL45.1  IFGT.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

STE-BASE-ND          Numeric 1                                   GL146   GL190
Base Number Of       The number of decimal positions defined     GL191   GL199
Decimals             for the company base currency.              GL45.1  IFGT.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

STE-TO-COMPANY       Numeric 4                                   GL146   GL190
To Company           This is the company number to which         GL191   GL199
                     this line is to be posted.                  GL45.1  IFGT.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

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,
                     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
                     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 Company        GL45.1  IFGT.1
                     (GL10.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.

STE-TRAN-AMOUNT      Signed 15.2                                 GL146   GL190
Invoice 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.

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

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


STE-ACCT-RATE        Signed 12.6                                 GL146   GL190
Account Rate         The exchange rate defined for the           GL191   GL199
                     currency relationship.                      GL45.1  IFGT.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

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.


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


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


STE-TO-BASE-ND       Numeric 1                                   GL146   GL190
To Base Number Of                                                GL191   GL199
Decimals                                                         GL45.1  IFGT.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.


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


STE-DOCUMENT-NBR     Alpha 27                                    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.

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

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

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

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

STE-RPT-RATE-1       Signed 12.6                                 GL146   GL190
Rpt Rate 1           The exchange rate to convert the            GL191   GL199
                     transaction amount to Report Currency 1.    GL310   GL45.1
                     The exchange rate is defined in CU10.1      IFGT.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.                                 GL310   GL45.1
                                                                 IFGT.1

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

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

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

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

STE-SEGMENT-BLOCK    Alpha 103                                   GL146   GL190
User Analysis        This field identifies the user analysis     GL191   GL199
                     values included in the transaction.         GL45.1  IFGT.1

                     You can either type up to four values
                     or use Define (F6) to open the User
                     Analysis Entry subform. Use this subform
                     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

STESET2   SEGMENT-GROUP
          COMPANY
          ACCT-UNIT
          ACCOUNT
          SUB-ACCOUNT
          OBJ-ID

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