 |
Lawson Insight Technical Documentation |
|
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 GL197 GL310 GL40.1
GL40.2 GL40.3 GL40.6 GL40.7 GL40.8 GL44.1
GL45.1 IFGT.1 SL195
FIELD NAME DESCRIPTION/VALID VALUES UPDATED BY
STE-OBJ-ID Numeric 12 GL146 GL190
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 SL195
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 GL197
values errors display for. GL40.1 GL40.2
GL40.3 GL40.6
GL40.7 GL40.8
GL44.1 GL45.1
IFGT.1 SL195
STE-COMPANY Numeric 4 GL146 GL190
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 SL195
STE-FISCAL-YEAR Numeric 4 GL146 GL190
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 SL195
STE-ACCT-PERIOD Numeric 2 GL146 GL190
Accounting Period This is the current accounting period. GL191 GL197
This field is updated by GL199 (Period GL40.1 GL40.2
Closing). GL40.3 GL40.6
GL40.7 GL40.8
GL44.1 GL45.1
IFGT.1 SL195
STE-SYSTEM Alpha 2 GL146 GL190
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 SL195
STE-VAR-LEVELS Alpha 30 GL146 GL190
Variable Levels A level that represents the location of GL191 GL197
an accounting unit in an organization's GL40.1 GL40.2
level structure. GL40.3 GL40.6
GL40.7 GL40.8
GL44.1 GL45.1
IFGT.1 SL195
STE-ACCT-UNIT Alpha 15 GL146 GL190
Accounting Unit The 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 SL195
STE-ACCOUNT Numeric 6 GL146 GL190
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 SL195
STE-SUB-ACCOUNT Numeric 4 GL146 GL190
Subaccount 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 SL195
STE-SOURCE-CODE Alpha 2 GL146 GL190
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 SL195
STE-DATE Numeric 8 (yyyymmdd) GL146 GL190
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 SL195
STE-REFERENCE Alpha 10 (Lower Case) GL146 GL190
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 SL195
STE-DESCRIPTION Alpha 30 (Lower Case) GL146 GL190
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 SL195
STE-BASE-AMOUNT Signed 15.2 GL146 GL190
Base Amount The base amount to be posted to the GL191 GL197
General Ledger Account Master file. GL40.1 GL40.2
GL40.3 GL40.6
GL40.7 GL40.8
GL44.1 GL45.1
IFGT.1 SL195
STE-BASE-ND Numeric 1 GL146 GL190
Base Number Of The number of decimal positions defined GL191 GL197
Decimals for the company base currency. GL40.1 GL40.2
GL40.3 GL40.6
GL40.7 GL40.8
GL44.1 GL45.1
IFGT.1 SL195
STE-UNITS-AMOUNT Signed 15.2 GL146 GL190
Units Amount 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 SL195
STE-TO-COMPANY Numeric 4 GL146 GL190
To Company This is the company number to which GL191 GL197
this line is to be posted. GL40.1 GL40.2
GL40.3 GL40.6
GL40.7 GL40.8
GL44.1 GL45.1
IFGT.1 SL195
STE-POSTING-DATE Numeric 8 (yyyymmdd) GL146 GL190
Posting Date The date assigned to the journal entry GL191 GL197
for posting. GL40.1 GL40.2
GL40.3 GL40.6
GL40.7 GL40.8
GL44.1 GL45.1
IFGT.1 SL195
STE-ACTIVITY Alpha 15 GL146 GL190
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 SL195
STE-ACCT-CATEGORY Alpha 5 GL146 GL190
Account Category Account 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 SL195
STE-CURRENCY-CODE Alpha 5 GL146 GL190
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 SL195
STE-BASERATE Signed 12.6 GL146 GL190
Exchange Rate Enter the exchange rate at the time the GL191 GL197
journal entry was made. If left blank, GL40.1 GL40.2
the current exchange rate will default. GL40.3 GL40.6
GL40.7 GL40.8
GL44.1 GL45.1
IFGT.1 SL195
STE-TRAN-AMOUNT Signed 15.2 GL146 GL190
Invoice Amount This is the amount in transaction GL191 GL197
currency to be posted. This amount GL40.1 GL40.2
creates a CUAMOUNT type 1 record. GL40.3 GL40.6
GL40.7 GL40.8
GL44.1 GL45.1
IFGT.1 SL195
STE-TRAN-ND Numeric 1 GL146 GL190
Transaction Number The number of decimal positions defined GL191 GL197
of Decimals for the transaction currency. GL40.1 GL40.2
GL40.3 GL40.6
GL40.7 GL40.8
GL44.1 GL45.1
IFGT.1 SL195
STE-ACCT-CURRENCY Alpha 5 GL146 GL190
Account Currency The 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 SL195
STE-ACCT-RATE Signed 12.6 GL146 GL190
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 SL195
STE-ACCT-AMOUNT Signed 15.2 GL146 GL190
Account Amount The transaction amount associated with GL191 GL197
the account currency. GL40.1 GL40.2
GL40.3 GL40.6
GL40.7 GL40.8
GL44.1 GL45.1
IFGT.1 SL195
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 SL195
STE-OPERATOR Alpha 10 GL146 GL190
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 SL195
STE-TO-BASE-AMT Signed 15.2 GL146 GL190
To Company Base The amount exchanged to the company GL191 GL197
Amount base currency. GL40.1 GL40.2
GL40.3 GL40.6
GL40.7 GL40.8
GL44.1 GL45.1
IFGT.1 SL195
STE-TO-BASE-ND Numeric 1 GL146 GL190
To Base Number Of GL191 GL197
Decimals GL40.1 GL40.2
GL40.3 GL40.6
GL40.7 GL40.8
GL44.1 GL45.1
IFGT.1 SL195
STE-TO-BASERATE Signed 12.6 GL146 GL190
Exchange 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 SL195
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 SL195
STE-DOCUMENT-NBR Alpha 27 GL146 GL190
Document Number The 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 SL195
STE-HOLD-CODE Alpha 4 GL146 GL190
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 SL195
STE-REL-OPERATOR Alpha 10 GL146 GL190
Release Operator GL191 GL197
GL40.1 GL40.2
GL40.3 GL40.6
GL40.7 GL40.8
GL44.1 GL45.1
IFGT.1 SL195
STE-RPT-AMOUNT-1 Signed 15.2 GL146 GL190
Report Currency 1 The transaction amount for Report GL191 GL197
Amount Currency 1. GL310 GL40.1
GL40.2 GL40.3
GL40.6 GL40.7
GL40.8 GL44.1
GL45.1 IFGT.1
SL195
STE-RPT-ND-1 Numeric 1 GL146 GL190
Rpt Nd 1 The number of decimal positions for GL191 GL197
Report Currency 1. GL310 GL40.1
GL40.2 GL40.3
GL40.6 GL40.7
GL40.8 GL44.1
GL45.1 IFGT.1
SL195
STE-RPT-RATE-1 Signed 12.6 GL146 GL190
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
SL195
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
SL195
STE-RPT-RATE-2 Signed 12.6 GL146 GL190
Rpt Rate 2 The exchange rate to convert the GL191 GL197
transaction amount to Report Currency 2. 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
SL195
STE-RPT-ND-2 Numeric 1 GL146 GL190
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
SL195
STE-ERROR-MSG Alpha 60 GL146 GL190
Error Msg The error message for the transaction. GL191 GL197
GL40.1 GL40.2
GL40.3 GL40.7
GL40.8 GL44.1
GL45.1 IFGT.1
SL195
STE-GLT-OBJ-ID Numeric 12 GL146 GL190
Subsystem GL This is a subsystem GL interface GL191 GL197
Interface ID identification number. It is used for GL40.1 GL40.2
Drill Around purposes. GL40.3 GL40.6
GL40.7 GL40.8
GL44.1 GL45.1
IFGT.1 SL195
STE-SEGMENT-BLOCK Alpha 103 GL146 GL190
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 SL195
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 GL190
OBJ-ID GL197 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
|