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. PK = primary key (present in every index); SETn = leading/alternate key of that index.

Field / columnTypeDescription & valuesUpdated by
#STE-OBJ-ID PK
OBJ_ID		Numeric 12This 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 SET2
SEGMENT_GROUP		Alpha 15This determines the user analysis values errors display for.AC45.1, GL146, GL190, GL191, GL197, GL40.1, GL40.2, GL40.3 +7 more
#STE-COMPANY SET2
COMPANY		Numeric 4Identifies 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 4Contains 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 2This 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 2A 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 30A 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 SET2
ACCT_UNIT		Alpha 15The 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 SET2
ACCOUNT		Numeric 6This 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 SET2
SUB_ACCOUNT		Numeric 4This 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 2A 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 1The 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.2This 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 4Identifies 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 15Activities 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 5Account 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 5This 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.7The 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 1The 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 5The 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.7The 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 1The 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 10This 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.2The 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 1The 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.7The 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 5The 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 27The 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 4The hold code.AC45.1, GL146, GL190, GL191, GL197, GL40.1, GL40.2, GL40.3 +7 more
#STE-REL-OPERATOR
REL_OPERATOR		Alpha 10This 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 1The 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.7The 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.7The currency rate.AC45.1, GL146, GL190, GL191, GL197, GL310, GL40.1, GL40.2 +8 more
#STE-RPT-ND-2
RPT_ND_2		Numeric 1The 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 60The 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 SET3
GLT_OBJ_ID		Numeric 12This 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 103This 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 are listed in index order; ↓ marks a descending key. Every documented Lawson index is unique unless flagged Duplicates; Subset indexes carry a Where condition.

IndexKeysFlagsConditionUsed in
STESET1
  1. OBJ-ID
PrimaryGL500, SL40.1
STESET2
  1. SEGMENT-GROUP
  2. COMPANY
  3. ACCT-UNIT
  4. ACCOUNT
  5. SUB-ACCOUNT
  6. OBJ-ID
KeyChangeGL110, SL00.2, SL01.1, SL01.2, SL40.1
STESET3
  1. GLT-OBJ-ID
  2. OBJ-ID
KeyChangeAC45.1, GL146, GL190, GL197, GL240, GL310, GL40.1, GL40.2 +6 more

Relations

Relationship map — 1:1 lookups/parents on the left, 1:M children on the right (up to 14 each)
GLTRANSACTRANSAMTRANSPRDISTRIBSLTRANSERR

One to one (1) — lookups and parents

RelationTableRulesConditionField map
GltransGLTRANSRequired
STE-GLT-OBJ-ID→GLT-OBJ-ID

One to many (3) — child tables

RelationTableRulesConditionField map
ActransACTRANS
STE-GLT-OBJ-ID→ATN-GLT-OBJ-ID
—→ATN-OBJ-ID
AmtransAMTRANS
STE-GLT-OBJ-ID→AMT-GLT-OBJ-ID
—→AMT-ASSET
—→AMT-SEQ-NUMBER
PrdistribPRDISTRIB
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)

Referenced by (4)