 |
Lawson Insight Technical Documentation |
|
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.
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 SL195
FIELD NAME DESCRIPTION/VALID VALUES UPDATED BY
SLT-OBJ-ID Numeric 12 GL146 GL190
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 SL195
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
User Analysis Group 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 SL195
SLT-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
SLT-FISCAL-YEAR Numeric 4 GL146 GL190
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
SL195
SLT-ACCT-PERIOD Numeric 2 GL146 GL190
Accounting Period This is the current accounting period. GL191 GL197
This field is updated by GL199 (Period GL199 GL40.1
Closing). GL40.2 GL40.3
GL40.6 GL40.7
GL40.8 GL44.1
GL45.1 IFGT.1
SL195
SLT-SYSTEM Alpha 2 GL146 GL190
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 SL195
SLT-VAR-LEVELS Alpha 30 GL120 GL146
Level A level that represents the location of GL190 GL191
an accounting unit in an organization's GL197 GL40.1
level structure. GL40.2 GL40.3
GL40.6 GL40.7
GL40.8 GL44.1
GL45.1 IFGT.1
SL195
SLT-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
SLT-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
SLT-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
SLT-SOURCE-CODE Alpha 2 GL146 GL190
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
SL195
SLT-DATE Numeric 8 (yyyymmdd) GL146 GL190
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
SL195
SLT-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
SLT-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
SLT-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
SLT-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
SLT-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
SLT-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
SLT-POSTING-DATE Numeric 8 (yyyymmdd) GL146 GL190
Posting Date The date assigned to the journal entry GL191 GL197
for posting. GL199 GL40.1
GL40.2 GL40.3
GL40.6 GL40.7
GL40.8 GL44.1
GL45.1 IFGT.1
SL195
SLT-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
SLT-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. All transactions are GL44.1 GL45.1
posted to an account category within an IFGT.1 SL195
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
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
SLT-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
SLT-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
SLT-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
SLT-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
SLT-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
SLT-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
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 SL195
SLT-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. GL199 GL40.1
GL40.2 GL40.3
GL40.6 GL40.7
GL40.8 GL44.1
GL45.1 IFGT.1
SL195
SLT-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
SLT-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
SLT-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
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 SL195
SLT-DOCUMENT-NBR Alpha 27 GL146 GL190
Document Number The 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 SL195
SLT-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
SLT-REL-OPERATOR Alpha 10 GL146 GL190
Release Operator 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
SL195
SLT-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
SLT-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
SLT-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
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
SL195
SLT-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
SLT-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
SLT-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 GL199 GL40.1
Drill Around purposes. GL40.2 GL40.3
GL40.6 GL40.7
GL40.8 GL44.1
GL45.1 IFGT.1
SL195
SLT-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.
SLTRANS FILE INDEX
NAME KEY FIELDS DESCRIPTION / SUBSET CONDITION USED IN
SLTSET1 OBJ-ID
SLTSET2 SEGMENT-GROUP GL110
POSTING-DATE
OBJ-ID
SLTSET3 GLT-OBJ-ID GL120 GL146
OBJ-ID GL190 GL197
GL199 GL310
GL40.1 GL40.2
GL40.3 GL40.6
GL40.7 GL40.8
GL44.1 GL45.1
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
|