Lawson Insight Technical Documentation |
|
SLTRANS
SLTRANS FILE
PL Transaction
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.
REFERENCED BY
SL00.2 SL01.1 SL01.2 GL240
UPDATED BY
GL110 GL120 GL146 GL190 GL191 GL197
GL199 GL310 GL40.1 GL40.2 GL40.3 GL40.6
GL40.7 GL40.8 GL44.1 GL45.1 IFGT.1 SL40.1
FIELD NAME DESCRIPTION/VALID VALUES UPDATED BY
SLT-OBJ-ID Numeric 12 GL146 GL190
Element: Object ID This is the object identifier. It is GL191 GL197
used to relate commitments or posted GL199 GL40.1
transactions back to the originating GL40.2 GL40.3
subsystems. Each subsystem record that GL40.6 GL40.7
is updated as a commitment or posted GL40.8 GL44.1
transaction is assigned an object GL45.1 IFGT.1
identifier. The object identifier is SL40.1
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.
SLT-SEGMENT-GROUP Alpha 15 GL146 GL190
Element: User Analysis A user analysis group is a combination GL191 GL197
of up to four user analysis for reports GL40.1 GL40.2
and analysis. GL40.3 GL40.6
GL40.7 GL40.8
GL44.1 GL45.1
IFGT.1 SL40.1
SLT-COMPANY Numeric 4 GL146 GL190
Element: 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 SL40.1
SLT-FISCAL-YEAR Numeric 4 GL146 GL190
Element: Fiscal Year This is the current fiscal year. This GL191 GL197
field is updated by Period Closing GL199 GL40.1
(GL199). GL40.2 GL40.3
GL40.6 GL40.7
GL40.8 GL44.1
GL45.1 IFGT.1
SL40.1
SLT-ACCT-PERIOD Numeric 2 GL146 GL190
Element: Accounting Period GL191 GL197
GL199 GL40.1
GL40.2 GL40.3
GL40.6 GL40.7
GL40.8 GL44.1
GL45.1 IFGT.1
SL40.1
SLT-SYSTEM Alpha 2 GL146 GL190
Element: System Code 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 SL40.1
SLT-VAR-LEVELS Alpha 30 GL120 GL146
Element: Level GL190 GL191
GL197 GL40.1
GL40.2 GL40.3
GL40.6 GL40.7
GL40.8 GL44.1
GL45.1 IFGT.1
SL40.1
SLT-ACCT-UNIT Alpha 15 GL146 GL190
Element: Accounting UniThe 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 SL40.1
SLT-ACCOUNT Numeric 6 GL146 GL190
Element: 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 SL40.1
SLT-SUB-ACCOUNT Numeric 4 GL146 GL190
Element: Subaccount GL191 GL197
GL40.1 GL40.2
GL40.3 GL40.6
GL40.7 GL40.8
GL44.1 GL45.1
IFGT.1 SL40.1
SLT-SOURCE-CODE Alpha 2 GL146 GL190
Element: Source Code A two character code assigned to a GL191 GL197
transaction to identify where the GL199 GL40.1
transaction was created. GL40.2 GL40.3
GL40.6 GL40.7
GL40.8 GL44.1
GL45.1 IFGT.1
SL40.1
SLT-DATE Numeric 8 (yyyymmdd) GL146 GL190
Element: Date This field displays the system date GL191 GL197
when this was created. GL199 GL40.1
GL40.2 GL40.3
GL40.6 GL40.7
GL40.8 GL44.1
GL45.1 IFGT.1
SL40.1
SLT-REFERENCE Alpha 10 (Lower Case) GL146 GL190
Element: Requester 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 SL40.1
SLT-DESCRIPTION Alpha 30 (Lower Case) GL146 GL190
Element: 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 SL40.1
SLT-BASE-AMOUNT Signed 15.2 GL146 GL190
Element: Adj Amt GL191 GL197
GL40.1 GL40.2
GL40.3 GL40.6
GL40.7 GL40.8
GL44.1 GL45.1
IFGT.1 SL40.1
SLT-BASE-ND Numeric 1 GL146 GL190
Account Currency GL191 GL197
Code GL40.1 GL40.2
GL40.3 GL40.6
GL40.7 GL40.8
GL44.1 GL45.1
IFGT.1 SL40.1
SLT-UNITS-AMOUNT Signed 15.2 GL146 GL190
Element: Adj Amt 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 SL40.1
SLT-TO-COMPANY Numeric 4 GL146 GL190
Element: Company GL191 GL197
GL40.1 GL40.2
GL40.3 GL40.6
GL40.7 GL40.8
GL44.1 GL45.1
IFGT.1 SL40.1
SLT-POSTING-DATE Numeric 8 (yyyymmdd) GL146 GL190
Element: Date GL191 GL197
GL199 GL40.1
GL40.2 GL40.3
GL40.6 GL40.7
GL40.8 GL44.1
GL45.1 IFGT.1
SL40.1
SLT-ACTIVITY Alpha 15 GL146 GL190
Element: 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 SL40.1
SLT-ACCT-CATEGORY Alpha 5 GL146 GL190
Element: Account CategoAccount 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. All transactions are GL44.1 GL45.1
posted to an account category within an IFGT.1 SL40.1
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.
SLT-CURRENCY-CODE Alpha 5 GL146 GL190
Element: 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 SL40.1
SLT-BASERATE Signed 12.6 GL146 GL190
Element: Account Rate GL191 GL197
GL40.1 GL40.2
GL40.3 GL40.6
GL40.7 GL40.8
GL44.1 GL45.1
IFGT.1 SL40.1
SLT-TRAN-AMOUNT Signed 15.2 GL146 GL190
Element: Adj Amt GL191 GL197
GL40.1 GL40.2
GL40.3 GL40.6
GL40.7 GL40.8
GL44.1 GL45.1
IFGT.1 SL40.1
SLT-TRAN-ND Numeric 1 GL146 GL190
Account Currency GL191 GL197
Code GL40.1 GL40.2
GL40.3 GL40.6
GL40.7 GL40.8
GL44.1 GL45.1
IFGT.1 SL40.1
SLT-ACCT-CURRENCY Alpha 5 GL146 GL190
Element: Account CurrenThe 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 SL40.1
SLT-ACCT-RATE Signed 12.6 GL146 GL190
Element: 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 SL40.1
SLT-ACCT-AMOUNT Signed 15.2 GL146 GL190
Element: Adj Amt GL191 GL197
GL40.1 GL40.2
GL40.3 GL40.6
GL40.7 GL40.8
GL44.1 GL45.1
IFGT.1 SL40.1
SLT-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 SL40.1
SLT-OPERATOR Alpha 10 GL146 GL190
Element: Operator Code This field is used to store the login GL191 GL197
id of the person who entered the record. GL199 GL40.1
GL40.2 GL40.3
GL40.6 GL40.7
GL40.8 GL44.1
GL45.1 IFGT.1
SL40.1
SLT-TO-BASE-AMT Signed 15.2 GL146 GL190
Element: Adj Amt The amount exchanged to the company GL191 GL197
base currency. GL40.1 GL40.2
GL40.3 GL40.6
GL40.7 GL40.8
GL44.1 GL45.1
IFGT.1 SL40.1
SLT-TO-BASE-ND Numeric 1 GL146 GL190
Account Currency GL191 GL197
Code GL40.1 GL40.2
GL40.3 GL40.6
GL40.7 GL40.8
GL44.1 GL45.1
IFGT.1 SL40.1
SLT-TO-BASERATE Signed 12.6 GL146 GL190
Element: Account 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 SL40.1
SLT-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 SL40.1
SLT-DOCUMENT-NBR Alpha 27 GL146 GL190
Element: Document NumbeThe document number associated with the GL191 GL197
transaction. GL40.1 GL40.2
GL40.3 GL40.6
GL40.7 GL40.8
GL44.1 GL45.1
IFGT.1 SL40.1
SLT-HOLD-CODE Alpha 4 GL146 GL190
Element: 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 SL40.1
SLT-REL-OPERATOR Alpha 10 GL146 GL190
Element: Operator Code The operator that created the GL191 GL197
transaction. GL199 GL40.1
GL40.2 GL40.3
GL40.6 GL40.7
GL40.8 GL44.1
GL45.1 IFGT.1
SL40.1
SLT-RPT-AMOUNT-1 Signed 15.2 GL146 GL190
Element: Adj Amt GL191 GL197
GL310 GL40.1
GL40.2 GL40.3
GL40.6 GL40.7
GL40.8 GL44.1
GL45.1 IFGT.1
SL40.1
SLT-RPT-RATE-1 Signed 12.6 GL146 GL190
Element: 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
SL40.1
SLT-RPT-ND-1 Numeric 1 GL146 GL190
Account Currency GL191 GL197
Code GL310 GL40.1
GL40.2 GL40.3
GL40.6 GL40.7
GL40.8 GL44.1
GL45.1 IFGT.1
SL40.1
SLT-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
SL40.1
SLT-RPT-RATE-2 Signed 12.6 GL146 GL190
Element: Rpt Rate 1 GL191 GL197
GL310 GL40.1
GL40.2 GL40.3
GL40.6 GL40.7
GL40.8 GL44.1
GL45.1 IFGT.1
SL40.1
SLT-RPT-ND-2 Numeric 1 GL146 GL190
Element: 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
SL40.1
SLT-GLT-OBJ-ID Numeric 12 GL146 GL190
Object GL191 GL197
Identification GL199 GL40.1
GL40.2 GL40.3
GL40.6 GL40.7
GL40.8 GL44.1
GL45.1 IFGT.1
SL40.1
SLT-SEGMENT-BLOCK Alpha 103 GL146 GL190
Element: 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 SL40.1
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.
SLTRANS FILE INDEX
NAME KEY FIELDS DESCRIPTION / SUBSET CONDITION USED IN
SLTSET1 OBJ-ID
SLTSET2 SEGMENT-GROUP KeyChange GL110 SL00.2
POSTING-DATE SL01.1 SL01.2
OBJ-ID
SLTSET3 GLT-OBJ-ID KeyChange GL146 GL190
OBJ-ID GL197 GL199
GL240 GL310
GL40.1 GL40.2
GL40.3 GL40.6
GL40.7 GL40.8
GL44.1 GL45.1
SLTSET4 SEGMENT-GROUP KeyChange GL120
COMPANY
ACCT-UNIT
ACCOUNT
SUB-ACCOUNT
POSTING-DATE
OBJ-ID
SLTRANS FILE RELATIONS
ONE TO ONE RELATIONS
RELATION RELATED
NAME FILE INTEGRITY RULES / FIELD MATCH
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
SLTRANS FILE RELATIONS
ONE TO MANY RELATIONS
RELATION RELATED
NAME FILE INTEGRITY RULES / FIELD MATCH
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
Prdistrib PRDISTRIB
SLT-TO-COMPANY -> PRD-DIST-COMPANY
SLT-ACCT-UNIT -> PRD-DST-ACCT-UNIT
SLT-ACCOUNT -> PRD-DST-ACCOUNT
SLT-SUB-ACCOUNT -> PRD-DST-SUB-ACCT
SLT-GLT-OBJ-ID -> PRD-GLT-OBJ-ID
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
|