SLTRANSERR – PL Transaction Error

System: Strategic Ledger (SL)
Prefix: STE
Primary key: OBJ-ID
Fields: 46
Updated by: 18 programs
Referenced by: 4 programs

SLTRANSERR is the PL Transaction Error table in Lawson Strategic Ledger (prefix STE). It is indexed by OBJ-ID (STESET1); alternate indexes: STESET2 and STESET3. It is related 1:1 to GLTRANS and 1:M to ACTRANS, AMTRANS and PRDISTRIB. It is updated by AC45.1, GL110, GL146, GL190, GL191, GL197, GL310, GL40.1 and 10 more and referenced by GL240, SL00.2, SL01.1 and SL01.2. The table has 46 fields, 3 indexes and 4 documented relations.

About SLTRANSERR

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.

Fields (46)

Column = COBOL field name without the STE- prefix, hyphens → underscores. Derived fields are computed by the application and are not stored.

Field / column	Type	Description & values	Updated by
`STE-OBJ-ID` PK OBJ_ID	Numeric 12	This is the object identifier. It is used to relate commitments or posted 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.	AC45.1, GL146, GL190, GL191, GL197, GL40.1, GL40.2, GL40.3 +8 more
`STE-SEGMENT-GROUP` SEGMENT_GROUP	Alpha 15	This determines the user analysis values errors display for.	AC45.1, GL146, GL190, GL191, GL197, GL40.1, GL40.2, GL40.3 +7 more
`STE-COMPANY` COMPANY	Numeric 4	Identifies the AP company if the resource type = V. Identifies the HR company if the resource type = E. It is blank for type A, P or Q resources.	AC45.1, GL146, GL190, GL191, GL197, GL40.1, GL40.2, GL40.3 +7 more
`STE-FISCAL-YEAR` FISCAL_YEAR	Numeric 4	Contains the fiscal year for the data stored on this record.	AC45.1, GL146, GL190, GL191, GL197, GL40.1, GL40.2, GL40.3 +7 more
`STE-ACCT-PERIOD` ACCT_PERIOD	Numeric 2	This is the current accounting period. This field is updated by GL199 (Period Closing).	AC45.1, GL146, GL190, GL191, GL197, GL40.1, GL40.2, GL40.3 +7 more
`STE-SYSTEM` SYSTEM	Alpha 2	A two-character code representing an application used within the Lawson system. (i.e.: GL = General Ledger, AP = Accounts Payable, etc.)	AC45.1, GL146, GL190, GL191, GL197, GL40.1, GL40.2, GL40.3 +7 more
`STE-VAR-LEVELS` VAR_LEVELS	Alpha 30	A level that represents the location of an accounting unit in an organization's level structure.	AC45.1, GL146, GL190, GL191, GL197, GL40.1, GL40.2, GL40.3 +7 more
`STE-ACCT-UNIT` ACCT_UNIT	Alpha 15	The accounting unit is a shorthand notation representing the variable level 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.	AC45.1, GL146, GL190, GL191, GL197, GL40.1, GL40.2, GL40.3 +7 more
`STE-ACCOUNT` ACCOUNT	Numeric 6	This field along with the accounting unit and subaccount make up the location (account) where amounts and other account information is stored.	AC45.1, GL146, GL190, GL191, GL197, GL40.1, GL40.2, GL40.3 +7 more
`STE-SUB-ACCOUNT` SUB_ACCOUNT	Numeric 4	This field contains the subaccount from your general ledger chart of accounts that was charged with the amount carried on this record.	AC45.1, GL146, GL190, GL191, GL197, GL40.1, GL40.2, GL40.3 +7 more
`STE-SOURCE-CODE` SOURCE_CODE	Alpha 2	A two character code assigned to a transaction to identify where the transaction was created.	AC45.1, GL146, GL190, GL191, GL197, GL40.1, GL40.2, GL40.3 +7 more
`STE-DATE` DATE	Numeric 8 (yyyymmdd)	This field displays the system date when this was created.	AC45.1, GL146, GL190, GL191, GL197, GL40.1, GL40.2, GL40.3 +7 more
`STE-REFERENCE` REFERENCE	Alpha 10 (Lower Case)	The reference number associated with the transaction.	AC45.1, GL146, GL190, GL191, GL197, GL40.1, GL40.2, GL40.3 +7 more
`STE-DESCRIPTION` DESCRIPTION	Alpha 30 (Lower Case)	This field displays the description.	AC45.1, GL146, GL190, GL191, GL197, GL40.1, GL40.2, GL40.3 +7 more
`STE-BASE-AMOUNT` BASE_AMOUNT	Signed 18.2	—	AC45.1, GL146, GL190, GL191, GL197, GL40.1, GL40.2, GL40.3 +8 more
`STE-BASE-ND` BASE_ND	Numeric 1	The number of decimal positions defined for the company base currency.	AC45.1, GL146, GL190, GL191, GL197, GL40.1, GL40.2, GL40.3 +7 more
`STE-UNITS-AMOUNT` UNITS_AMOUNT	Signed 15.2	This is the units amount included in the file.	AC45.1, GL146, GL190, GL191, GL197, GL40.1, GL40.2, GL40.3 +8 more
`STE-TO-COMPANY` TO_COMPANY	Numeric 4	Identifies the AP company if the resource type = V. Identifies the HR company if the resource type = E. It is blank for type A, P or Q resources.	AC45.1, GL146, GL190, GL191, GL197, GL40.1, GL40.2, GL40.3 +7 more
`STE-POSTING-DATE` POSTING_DATE	Numeric 8 (yyyymmdd)	The date assigned to the journal entry for posting.	AC45.1, GL146, GL190, GL191, GL197, GL40.1, GL40.2, GL40.3 +7 more
`STE-ACTIVITY` ACTIVITY	Alpha 15	Activities are the processes or procedures that produce work. Cost objects (products, services, customers, and so on) are the reasons for performing the activity.	AC45.1, GL146, GL190, GL191, GL197, GL40.1, GL40.2, GL40.3 +7 more
`STE-ACCT-CATEGORY` ACCT_CATEGORY	Alpha 5	Account categories are groupings of costs, revenues, or a combination of both used for reporting and inquiries for activities in the Activity Management system.	AC45.1, GL146, GL190, GL191, GL197, GL40.1, GL40.2, GL40.3 +7 more
`STE-CURRENCY-CODE` CURRENCY_CODE	Alpha 5	This field contains the company base currency code established in Company (GL10.1 ).	AC45.1, GL146, GL190, GL191, GL197, GL40.1, GL40.2, GL40.3 +7 more
`STE-BASERATE` BASERATE	Signed 14.7	The currency rate.	AC45.1, GL146, GL190, GL191, GL197, GL40.1, GL40.2, GL40.3 +7 more
`STE-TRAN-AMOUNT` TRAN_AMOUNT	Signed 18.2	—	AC45.1, GL146, GL190, GL191, GL197, GL40.1, GL40.2, GL40.3 +8 more
`STE-TRAN-ND` TRAN_ND	Numeric 1	The number of decimals assigned to a particular account as determined by the account currency.	AC45.1, GL146, GL190, GL191, GL197, GL40.1, GL40.2, GL40.3 +7 more
`STE-ACCT-CURRENCY` ACCT_CURRENCY	Alpha 5	The account currency code associated with the transaction.	AC45.1, GL146, GL190, GL191, GL197, GL40.1, GL40.2, GL40.3 +7 more
`STE-ACCT-RATE` ACCT_RATE	Signed 14.7	The exchange rate defined for the currency relationship.	AC45.1, GL146, GL190, GL191, GL197, GL40.1, GL40.2, GL40.3 +7 more
`STE-ACCT-AMOUNT` ACCT_AMOUNT	Signed 18.2	—	AC45.1, GL146, GL190, GL191, GL197, GL40.1, GL40.2, GL40.3 +8 more
`STE-ACCT-ND` ACCT_ND	Numeric 1	The number of decimals assigned to a particular account as determined by the account currency.	AC45.1, GL146, GL190, GL191, GL197, GL40.1, GL40.2, GL40.3 +7 more
`STE-OPERATOR` OPERATOR	Alpha 10	This field is used to store the login id of the person who entered the record.	AC45.1, GL146, GL190, GL191, GL197, GL40.1, GL40.2, GL40.3 +7 more
`STE-TO-BASE-AMT` TO_BASE_AMT	Signed 18.2	The amount exchanged to the company base currency.	AC45.1, GL146, GL190, GL191, GL197, GL40.1, GL40.2, GL40.3 +8 more
`STE-TO-BASE-ND` TO_BASE_ND	Numeric 1	The number of decimals assigned to a particular account as determined by the account currency.	AC45.1, GL146, GL190, GL191, GL197, GL40.1, GL40.2, GL40.3 +7 more
`STE-TO-BASERATE` TO_BASERATE	Signed 14.7	The rate used to calculate the base amount from the nonbase currency transaction amount.	AC45.1, GL146, GL190, GL191, GL197, GL40.1, GL40.2, GL40.3 +7 more
`STE-TO-BASE-CURR` TO_BASE_CURR	Alpha 5	The amount exchanged to the company base currency.	AC45.1, GL146, GL190, GL191, GL197, GL40.1, GL40.2, GL40.3 +7 more
`STE-DOCUMENT-NBR` DOCUMENT_NBR	Alpha 27	The number assigned to the transaction (invoice, credit memo, etc.) for which the intrastat data was entered.	AC45.1, GL146, GL190, GL191, GL197, GL40.1, GL40.2, GL40.3 +7 more
`STE-HOLD-CODE` HOLD_CODE	Alpha 4	The hold code.	AC45.1, GL146, GL190, GL191, GL197, GL40.1, GL40.2, GL40.3 +7 more
`STE-REL-OPERATOR` REL_OPERATOR	Alpha 10	This field is used to store the login id of the person who entered the record.	AC45.1, GL146, GL190, GL191, GL197, GL40.1, GL40.2, GL40.3 +7 more
`STE-RPT-AMOUNT-1` RPT_AMOUNT_1	Signed 18.2	—	AC45.1, GL146, GL190, GL191, GL197, GL310, GL40.1, GL40.2 +9 more
`STE-RPT-ND-1` RPT_ND_1	Numeric 1	The number of decimals assigned to a particular account as determined by the account currency.	AC45.1, GL146, GL190, GL191, GL197, GL310, GL40.1, GL40.2 +8 more
`STE-RPT-RATE-1` RPT_RATE_1	Signed 14.7	The currency rate.	AC45.1, GL146, GL190, GL191, GL197, GL310, GL40.1, GL40.2 +8 more
`STE-RPT-AMOUNT-2` RPT_AMOUNT_2	Signed 18.2	—	AC45.1, GL146, GL190, GL191, GL197, GL310, GL40.1, GL40.2 +9 more
`STE-RPT-RATE-2` RPT_RATE_2	Signed 14.7	The currency rate.	AC45.1, GL146, GL190, GL191, GL197, GL310, GL40.1, GL40.2 +8 more
`STE-RPT-ND-2` RPT_ND_2	Numeric 1	The number of decimals assigned to a particular account as determined by the account currency.	AC45.1, GL146, GL190, GL191, GL197, GL310, GL40.1, GL40.2 +8 more
`STE-ERROR-MSG` ERROR_MSG	Alpha 60	The error message is a description of the error that has been found.	AC45.1, GL146, GL190, GL191, GL197, GL40.1, GL40.2, GL40.3 +7 more
`STE-GLT-OBJ-ID` GLT_OBJ_ID	Numeric 12	This is the object identifier. It is used to relate commitments or posted 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.	AC45.1, GL146, GL190, GL191, GL197, GL40.1, GL40.2, GL40.3 +7 more
`STE-SEGMENT-BLOCK` SEGMENT_BLOCK	Alpha 103	This field identifies the user analysis values included in the transaction. 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.	AC45.1, GL146, GL190, GL191, GL197, GL40.1, GL40.2, GL40.3 +7 more

Indexes (3)

Keys marked * are descending. Every documented Lawson index is unique unless flagged Duplicates; Subset indexes carry a Where condition.

Index	Keys	Flags	Used in
`STESET1`	`OBJ-ID`	Primary	GL500, SL40.1
`STESET2`	`SEGMENT-GROUP`, `COMPANY`, `ACCT-UNIT`, `ACCOUNT`, `SUB-ACCOUNT`, `OBJ-ID`	KeyChange	GL110, SL00.2, SL01.1, SL01.2, SL40.1
`STESET3`	`GLT-OBJ-ID`, `OBJ-ID`	KeyChange	AC45.1, GL146, GL190, GL197, GL240, GL310, GL40.1, GL40.2 +6 more

Relations

One to one (1) — lookups and parents

Relation	Table	Rules	Condition	Field map
Gltrans	GLTRANS	Required		`STE-GLT-OBJ-ID` → `GLT-OBJ-ID`

One to many (3) — child tables

Relation	Table	Field map
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-COMPANY` → `PRD-DIST-COMPANY`, `STE-GLT-OBJ-ID` → `PRD-GLT-OBJ-ID`, `STE-ACCT-UNIT` → `PRD-DST-ACCT-UNIT`, `STE-ACCOUNT` → `PRD-DST-ACCOUNT`, `STE-SUB-ACCOUNT` → `PRD-DST-SUB-ACCT`, → `PRD-OBJ-ID`

Programs

Updated by (18)

AC45.1 Transaction Edit
GL110 Company Copy Delete
GL146 Batch Journal Control
GL190 Journal Posting
GL191 Currency Revaluation
GL197 Period, Year End GL Commitments Processing
GL310 Report Currency Purge
GL40.1 Journal Entry
GL40.2 Define Journal
GL40.3 Speed Entry
GL40.6 Journal Copy
GL40.7 Totals
GL40.8 Journal Entry
GL44.1 Report Currency Entry
GL45.1 Journal Control
GL500 Fiscal Year Change
IFGT.1 GLTRANS Interface
SL40.1 Error Transaction Edit

Referenced by (4)

GL240 Journal Edit Listing
SL00.2 Define User Analysis
SL01.1 User Analysis Group
SL01.2 Define User Analysis Group