SLTRANS – PL Transaction

System: Strategic Ledger (SL)
Prefix: SLT
Primary key: OBJ-ID
Fields: 45
Updated by: 20 programs
Referenced by: 4 programs

SLTRANS is the PL Transaction table in Lawson Strategic Ledger (prefix SLT). It is indexed by OBJ-ID (SLTSET1); alternate indexes: SLTSET2, SLTSET3 and SLTSET4. It is related 1:1 to ACACTIVITY, GLSYSTEM, GLTRANS, SLGROUPHDR, SLTRANS and GLSRCCODE and 1:M to ACTRANS, AMTRANS, APDISTRIB, ARDISTRIB, MMDIST, OEDIST, PRDISTRIB, SLGROUPDTL and 2 more. It is updated by AC45.1, GL110, GL120, GL146, GL190, GL191, GL197, GL199 and 12 more and referenced by GL240, SL00.2, SL01.1 and SL01.2. The table has 45 fields, 4 indexes and 16 documented relations.

About SLTRANS

The Strategic Ledger Transaction (SLTRANS) file contains the Strategic Ledger transaction records. This file is updated when you process transactions in each Lawson Application that includes user analyses.

Fields (45)

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

Field / column	Type	Description & values	Updated by
`SLT-OBJ-ID` PK OBJ_ID	Numeric 12	This is the object identifier. It is used to relate transactions back to the originating system. Each subsystem record that is updated as a transaction is assigned an object identifier. The object identifier is a unique key used to drill back from General Ledger to Strategic Ledger.	AC45.1, GL146, GL190, GL191, GL197, GL199, GL40.1, GL40.2 +9 more
`SLT-SEGMENT-GROUP` SEGMENT_GROUP	Alpha 15	A user analysis group is a combination of user analysis for reports and analysis.	AC45.1, GL146, GL190, GL191, GL197, GL40.1, GL40.2, GL40.3 +7 more
`SLT-COMPANY` COMPANY	Numeric 4	The number that identifies the company associated with the Strategic Ledger Transaction.	AC45.1, GL146, GL190, GL191, GL197, GL40.1, GL40.2, GL40.3 +7 more
`SLT-FISCAL-YEAR` FISCAL_YEAR	Numeric 4	This is the current fiscal year. .	AC45.1, GL146, GL190, GL191, GL197, GL199, GL40.1, GL40.2 +8 more
`SLT-ACCT-PERIOD` ACCT_PERIOD	Numeric 2	This is the current accounting period.	AC45.1, GL146, GL190, GL191, GL197, GL199, GL40.1, GL40.2 +8 more
`SLT-SYSTEM` SYSTEM	Alpha 2	A two-character code representing an application used within the Lawson system. (i.e.: GL = General Ledger, SL = Strategic Ledger, etc.)	AC45.1, GL146, GL190, GL191, GL197, GL40.1, GL40.2, GL40.3 +7 more
`SLT-VAR-LEVELS` VAR_LEVELS	Alpha 30	A level that represents the location of an accounting unit in an organization's level structure.	AC45.1, GL120, GL146, GL190, GL191, GL197, GL40.1, GL40.2 +8 more
`SLT-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
`SLT-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
`SLT-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
`SLT-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, GL199, GL40.1, GL40.2 +8 more
`SLT-DATE` DATE	Numeric 8 (yyyymmdd)	This field displays the system date when this was created.	AC45.1, GL146, GL190, GL191, GL197, GL199, GL40.1, GL40.2 +8 more
`SLT-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
`SLT-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
`SLT-BASE-AMOUNT` BASE_AMOUNT	Signed 18.2	The company base amount.	AC45.1, GL146, GL190, GL191, GL197, GL40.1, GL40.2, GL40.3 +8 more
`SLT-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
`SLT-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
`SLT-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
`SLT-POSTING-DATE` POSTING_DATE	Numeric 8 (yyyymmdd)	The date assigned to the journal entry for posting.	AC45.1, GL146, GL190, GL191, GL197, GL199, GL40.1, GL40.2 +8 more
`SLT-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
`SLT-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. All transactions are posted to an account category within an activity. You can assign a specific General Ledger account or range of accounts (company, accounting unit, account, and subaccount) that make up the transactions posted to an account category using AC07.1 (Account Assignment). Period-to-date, year-to-date, and life-to-date balances are maintained by account category for activities. Account categories must be assigned to activities before you do any budgeting or transaction processing. Valid account category types are: cost revenue accrual pass thru	AC45.1, GL146, GL190, GL191, GL197, GL40.1, GL40.2, GL40.3 +7 more
`SLT-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
`SLT-BASERATE` BASERATE	Signed 14.7	Enter the exchange rate at the time the journal entry was made. If left blank, the current exchange rate will default.	AC45.1, GL146, GL190, GL191, GL197, GL40.1, GL40.2, GL40.3 +7 more
`SLT-TRAN-AMOUNT` TRAN_AMOUNT	Signed 18.2	—	AC45.1, GL146, GL190, GL191, GL197, GL40.1, GL40.2, GL40.3 +8 more
`SLT-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
`SLT-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
`SLT-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
`SLT-ACCT-AMOUNT` ACCT_AMOUNT	Signed 18.2	—	AC45.1, GL146, GL190, GL191, GL197, GL40.1, GL40.2, GL40.3 +8 more
`SLT-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
`SLT-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, GL199, GL40.1, GL40.2 +8 more
`SLT-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
`SLT-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
`SLT-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
`SLT-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
`SLT-DOCUMENT-NBR` DOCUMENT_NBR	Alpha 27	The document number associated with the transaction.	AC45.1, GL146, GL190, GL191, GL197, GL40.1, GL40.2, GL40.3 +7 more
`SLT-HOLD-CODE` HOLD_CODE	Alpha 4	The hold code.	AC45.1, GL146, GL190, GL191, GL197, GL40.1, GL40.2, GL40.3 +7 more
`SLT-REL-OPERATOR` REL_OPERATOR	Alpha 10	The operator that created the transaction.	AC45.1, GL146, GL190, GL191, GL197, GL199, GL40.1, GL40.2 +8 more
`SLT-RPT-AMOUNT-1` RPT_AMOUNT_1	Signed 18.2	—	AC45.1, GL146, GL190, GL191, GL197, GL310, GL40.1, GL40.2 +9 more
`SLT-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
`SLT-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
`SLT-RPT-AMOUNT-2` RPT_AMOUNT_2	Signed 18.2	—	AC45.1, GL146, GL190, GL191, GL197, GL310, GL40.1, GL40.2 +9 more
`SLT-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
`SLT-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
`SLT-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, GL199, GL40.1, GL40.2 +8 more
`SLT-SEGMENT-BLOCK` SEGMENT_BLOCK	Alpha 103	This field identifies the user analysis values included in the transaction. You can either type the 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 User Guide for additional information.	AC45.1, GL146, GL190, GL191, GL197, GL40.1, GL40.2, GL40.3 +7 more

Indexes (4)

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

Index	Keys	Flags	Used in
`SLTSET1`	`OBJ-ID`	Primary	GL500
`SLTSET2`	`SEGMENT-GROUP`, `POSTING-DATE`, `OBJ-ID`	KeyChange	GL110, SL00.2, SL01.1, SL01.2
`SLTSET3`	`GLT-OBJ-ID`, `OBJ-ID`	KeyChange	AC45.1, GL146, GL190, GL197, GL199, GL240, GL310, GL40.1 +7 more
`SLTSET4`	`SEGMENT-GROUP`, `COMPANY`, `ACCT-UNIT`, `ACCOUNT`, `SUB-ACCOUNT`, `POSTING-DATE`, `OBJ-ID`	KeyChange	GL120

Relations

One to one (6) — lookups and parents

Relation	Table	Rules	Field map
Activity	ACACTIVITY	Not Required	`SLT-ACTIVITY` → `ACV-ACTIVITY`
Glsystem	GLSYSTEM	Required	`SLT-COMPANY` → `GLS-COMPANY`
Gltrans	GLTRANS	Required	`SLT-GLT-OBJ-ID` → `GLT-OBJ-ID`
Slgrouphdr	SLGROUPHDR	Required	`SLT-SEGMENT-GROUP` → `SLH-SEGMENT-GROUP`
Sltrans	SLTRANS	Required	`SLT-OBJ-ID` → `SLT-OBJ-ID`
Source Code	GLSRCCODE	Required	`SLT-SOURCE-CODE` → `GSR-SOURCE-CODE`

One to many (10) — child tables

Relation	Table	Field map
Actrans	ACTRANS	`SLT-GLT-OBJ-ID` → `ATN-GLT-OBJ-ID`, → `ATN-OBJ-ID`
Amtrans	AMTRANS	`SLT-GLT-OBJ-ID` → `AMT-GLT-OBJ-ID`, → `AMT-ASSET`, → `AMT-SEQ-NUMBER`
Apdistrib	APDISTRIB	`SLT-GLT-OBJ-ID` → `APD-GLT-OBJ-ID`, → `APD-API-OBJ-ID`, → `APD-DIST-SEQ-NBR`
Ardistrib	ARDISTRIB	`SLT-COMPANY` → `AMD-GL-COMPANY`, `SLT-ACCT-UNIT` → `AMD-ACCT-UNIT`, `SLT-ACCOUNT` → `AMD-ACCOUNT`, `SLT-SUB-ACCOUNT` → `AMD-SUB-ACCT`, `SLT-POSTING-DATE` → `AMD-GL-DATE`, `SLT-GLT-OBJ-ID` → `AMD-GLT-OBJ-ID`, → `AMD-CREATE-DATE`, → `AMD-CREATE-TIME`, → `AMD-PROG-SEQ-NBR`
Mmdist	MMDIST	`SLT-GLT-OBJ-ID` → `MMD-GLT-OBJ-ID`, → `MMD-COMPANY`, → `MMD-SYSTEM-CD`, → `MMD-LOCATION`, → `MMD-DOC-TYPE`, → `MMD-DOC-NUMBER`, → `MMD-DOC-NBR-NUM`, → `MMD-LINE-NBR`, → `MMD-COMPONENT-SEQ`, → `MMD-LINE-SEQ`
Oedist	OEDIST	`SLT-GLT-OBJ-ID` → `ODI-GLT-OBJ-ID`, → `ODI-INVC-PREFIX`, → `ODI-INVC-NUMBER`, → `ODI-AUTH-NO`, → `ODI-LINE-NBR`, → `ODI-SEQ`, → `ODI-POSTING-TYPE`
Prdistrib	PRDISTRIB	`SLT-COMPANY` → `PRD-DIST-COMPANY`, `SLT-GLT-OBJ-ID` → `PRD-GLT-OBJ-ID`, `SLT-ACCT-UNIT` → `PRD-DST-ACCT-UNIT`, `SLT-ACCOUNT` → `PRD-DST-ACCOUNT`, `SLT-SUB-ACCOUNT` → `PRD-DST-SUB-ACCT`, → `PRD-OBJ-ID`
Slgroupdtl	SLGROUPDTL	`SLT-SEGMENT-GROUP` → `GRD-SEGMENT-GROUP`, → `GRD-SEGMENT-ORDER`, → `GRD-SEGMENT`
Slmxvalue	SLMXVALUE	`SLT-OBJ-ID` → `SMV-OBJ-ID`, → `SMV-MATRIX-CAT`
Sltrandtl	SLTRANDTL	`SLT-OBJ-ID` → `STD-SLT-OBJ-ID`, → `STD-SEGMENT-ORDER`

Programs

Updated by (20)

AC45.1 Transaction Edit
GL110 Company Copy Delete
GL120 Level Reorganization
GL146 Batch Journal Control
GL190 Journal Posting
GL191 Currency Revaluation
GL197 Period, Year End GL Commitments Processing
GL199 Period Closing
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