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
AC45.1 GL110 GL120 GL146 GL190 GL191
GL197 GL199 GL310 GL40.1 GL40.2 GL40.3
GL40.6 GL40.7 GL40.8 GL44.1 GL45.1 GL500
IFGT.1 SL40.1
FIELD NAME DESCRIPTION/VALID VALUES UPDATED BY
SLT-OBJ-ID Numeric 12 AC45.1 GL146
Element: Object ID This is the object identifier. It is GL190 GL191
used to relate transactions back to GL197 GL199
the originating system. Each subsystem GL40.1 GL40.2
record that is updated as a transaction GL40.3 GL40.6
is assigned an object identifier. The GL40.7 GL40.8
object identifier is a unique key used GL44.1 GL45.1
to drill back from General Ledger to GL500 IFGT.1
Strategic Ledger. SL40.1
SLT-SEGMENT-GROUP Alpha 15 AC45.1 GL146
Element: User Analysis A user analysis group is a combination GL190 GL191
of user analysis for reports and GL197 GL40.1
analysis. GL40.2 GL40.3
GL40.6 GL40.7
GL40.8 GL44.1
GL45.1 GL500
IFGT.1 SL40.1
SLT-COMPANY Numeric 4 AC45.1 GL146
Element: Company The number that identifies the company GL190 GL191
associated with the Strategic Ledger GL197 GL40.1
Transaction. GL40.2 GL40.3
GL40.6 GL40.7
GL40.8 GL44.1
GL45.1 GL500
IFGT.1 SL40.1
SLT-FISCAL-YEAR Numeric 4 AC45.1 GL146
Element: Fiscal Year This is the current fiscal year. . GL190 GL191
GL197 GL199
GL40.1 GL40.2
GL40.3 GL40.6
GL40.7 GL40.8
GL44.1 GL45.1
GL500 IFGT.1
SL40.1
SLT-ACCT-PERIOD Numeric 2 AC45.1 GL146
Element: Accounting PerThis is the current accounting period. GL190 GL191
GL197 GL199
GL40.1 GL40.2
GL40.3 GL40.6
GL40.7 GL40.8
GL44.1 GL45.1
GL500 IFGT.1
SL40.1
SLT-SYSTEM Alpha 2 AC45.1 GL146
Element: System Code A two-character code representing an GL190 GL191
application used within the Lawson GL197 GL40.1
system. (i.e.: GL = General Ledger, SL = GL40.2 GL40.3
Strategic Ledger, etc.) GL40.6 GL40.7
GL40.8 GL44.1
GL45.1 GL500
IFGT.1 SL40.1
SLT-VAR-LEVELS Alpha 30 AC45.1 GL120
Element: Level A level that represents the location of GL146 GL190
an accounting unit in an organization's GL191 GL197
level structure. GL40.1 GL40.2
GL40.3 GL40.6
GL40.7 GL40.8
GL44.1 GL45.1
GL500 IFGT.1
SL40.1
SLT-ACCT-UNIT Alpha 15 AC45.1 GL146
Element: Accounting UniThe accounting unit is a shorthand GL190 GL191
notation representing the variable level GL197 GL40.1
number. When used in the General Ledger GL40.2 GL40.3
Account Master file, the accounting unit GL40.6 GL40.7
must be defined in the General Ledger GL40.8 GL44.1
Names file as a posting accounting unit. GL45.1 GL500
IFGT.1 SL40.1
SLT-ACCOUNT Numeric 6 AC45.1 GL146
Element: Account This field along with the accounting GL190 GL191
unit and subaccount make up the location GL197 GL40.1
(account) where amounts and other GL40.2 GL40.3
account information is stored. GL40.6 GL40.7
GL40.8 GL44.1
GL45.1 GL500
IFGT.1 SL40.1
SLT-SUB-ACCOUNT Numeric 4 AC45.1 GL146
Element: Subaccount This field contains the subaccount from GL190 GL191
your general ledger chart of accounts GL197 GL40.1
that was charged with the amount carried GL40.2 GL40.3
on this record. GL40.6 GL40.7
GL40.8 GL44.1
GL45.1 GL500
IFGT.1 SL40.1
SLT-SOURCE-CODE Alpha 2 AC45.1 GL146
Element: Source Code A two character code assigned to a GL190 GL191
transaction to identify where the GL197 GL199
transaction was created. GL40.1 GL40.2
GL40.3 GL40.6
GL40.7 GL40.8
GL44.1 GL45.1
GL500 IFGT.1
SL40.1
SLT-DATE Numeric 8 (yyyymmdd) AC45.1 GL146
Element: Date This field displays the system date GL190 GL191
when this was created. GL197 GL199
GL40.1 GL40.2
GL40.3 GL40.6
GL40.7 GL40.8
GL44.1 GL45.1
GL500 IFGT.1
SL40.1
SLT-REFERENCE Alpha 10 (Lower Case) AC45.1 GL146
Element: Reference The reference number associated with GL190 GL191
the transaction. GL197 GL40.1
GL40.2 GL40.3
GL40.6 GL40.7
GL40.8 GL44.1
GL45.1 GL500
IFGT.1 SL40.1
SLT-DESCRIPTION Alpha 30 (Lower Case) AC45.1 GL146
Element: Description This field displays the description. GL190 GL191
GL197 GL40.1
GL40.2 GL40.3
GL40.6 GL40.7
GL40.8 GL44.1
GL45.1 GL500
IFGT.1 SL40.1
SLT-BASE-AMOUNT Signed 18.2 AC45.1 GL146
Element: Intl Amt The company base amount. GL190 GL191
GL197 GL40.1
GL40.2 GL40.3
GL40.6 GL40.7
GL40.8 GL44.1
GL45.1 GL500
IFGT.1 SL40.1
SLT-BASE-ND Numeric 1 AC45.1 GL146
Element: Base Nd The number of decimal positions defined GL190 GL191
for the company base currency. GL197 GL40.1
GL40.2 GL40.3
GL40.6 GL40.7
GL40.8 GL44.1
GL45.1 GL500
IFGT.1 SL40.1
SLT-UNITS-AMOUNT Signed 15.2 AC45.1 GL146
Element: Units Amount This is the units amount included in GL190 GL191
the file. GL197 GL40.1
GL40.2 GL40.3
GL40.6 GL40.7
GL40.8 GL44.1
GL45.1 GL500
IFGT.1 SL40.1
SLT-TO-COMPANY Numeric 4 AC45.1 GL146
Element: Company Identifies the AP company if the GL190 GL191
resource type = V. Identifies the HR GL197 GL40.1
company if the resource type = E. It is GL40.2 GL40.3
blank for type A, P or Q resources. GL40.6 GL40.7
GL40.8 GL44.1
GL45.1 GL500
IFGT.1 SL40.1
SLT-POSTING-DATE Numeric 8 (yyyymmdd) AC45.1 GL146
Element: Posting Date The date assigned to the journal entry GL190 GL191
for posting. GL197 GL199
GL40.1 GL40.2
GL40.3 GL40.6
GL40.7 GL40.8
GL44.1 GL45.1
GL500 IFGT.1
SL40.1
SLT-ACTIVITY Alpha 15 AC45.1 GL146
Element: Activity Activities are the processes or GL190 GL191
procedures that produce work. Cost GL197 GL40.1
objects (products, services, customers, GL40.2 GL40.3
and so on) are the reasons for GL40.6 GL40.7
performing the activity. GL40.8 GL44.1
GL45.1 GL500
IFGT.1 SL40.1
SLT-ACCT-CATEGORY Alpha 5 AC45.1 GL146
Element: Account CategoAccount categories are groupings of GL190 GL191
costs, revenues, or a combination of GL197 GL40.1
both used for reporting and inquiries GL40.2 GL40.3
for activities in the Activity GL40.6 GL40.7
Management system. All transactions are GL40.8 GL44.1
posted to an account category within an GL45.1 GL500
activity. You can assign a specific IFGT.1 SL40.1
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
SLT-CURRENCY-CODE Alpha 5 AC45.1 GL146
Element: Currency Code This field contains the company base GL190 GL191
currency code established in Company GL197 GL40.1
(GL10.1 ). GL40.2 GL40.3
GL40.6 GL40.7
GL40.8 GL44.1
GL45.1 GL500
IFGT.1 SL40.1
SLT-BASERATE Signed 14.7 AC45.1 GL146
Element: Baserate Enter the exchange rate at the time the GL190 GL191
journal entry was made. If left blank, GL197 GL40.1
the current exchange rate will default. GL40.2 GL40.3
GL40.6 GL40.7
GL40.8 GL44.1
GL45.1 GL500
IFGT.1 SL40.1
SLT-TRAN-AMOUNT Signed 18.2 AC45.1 GL146
Element: Intl Amt GL190 GL191
GL197 GL40.1
GL40.2 GL40.3
GL40.6 GL40.7
GL40.8 GL44.1
GL45.1 GL500
IFGT.1 SL40.1
SLT-TRAN-ND Numeric 1 AC45.1 GL146
Element: Acct Nd The number of decimals assigned to a GL190 GL191
particular account as determined by the GL197 GL40.1
account currency. GL40.2 GL40.3
GL40.6 GL40.7
GL40.8 GL44.1
GL45.1 GL500
IFGT.1 SL40.1
SLT-ACCT-CURRENCY Alpha 5 AC45.1 GL146
Element: Currency Code The account currency code associated GL190 GL191
with the transaction. GL197 GL40.1
GL40.2 GL40.3
GL40.6 GL40.7
GL40.8 GL44.1
GL45.1 GL500
IFGT.1 SL40.1
SLT-ACCT-RATE Signed 14.7 AC45.1 GL146
Element: Curr Rate The exchange rate defined for the GL190 GL191
currency relationship. GL197 GL40.1
GL40.2 GL40.3
GL40.6 GL40.7
GL40.8 GL44.1
GL45.1 GL500
IFGT.1 SL40.1
SLT-ACCT-AMOUNT Signed 18.2 AC45.1 GL146
Element: Intl Amt GL190 GL191
GL197 GL40.1
GL40.2 GL40.3
GL40.6 GL40.7
GL40.8 GL44.1
GL45.1 GL500
IFGT.1 SL40.1
SLT-ACCT-ND Numeric 1 AC45.1 GL146
Element: Acct Nd The number of decimals assigned to a GL190 GL191
particular account as determined by the GL197 GL40.1
account currency. GL40.2 GL40.3
GL40.6 GL40.7
GL40.8 GL44.1
GL45.1 GL500
IFGT.1 SL40.1
SLT-OPERATOR Alpha 10 AC45.1 GL146
Element: Operator This field is used to store the login GL190 GL191
id of the person who entered the record. GL197 GL199
GL40.1 GL40.2
GL40.3 GL40.6
GL40.7 GL40.8
GL44.1 GL45.1
GL500 IFGT.1
SL40.1
SLT-TO-BASE-AMT Signed 18.2 AC45.1 GL146
Element: Intl Amt The amount exchanged to the company GL190 GL191
base currency. GL197 GL40.1
GL40.2 GL40.3
GL40.6 GL40.7
GL40.8 GL44.1
GL45.1 GL500
IFGT.1 SL40.1
SLT-TO-BASE-ND Numeric 1 AC45.1 GL146
Element: Acct Nd The number of decimals assigned to a GL190 GL191
particular account as determined by the GL197 GL40.1
account currency. GL40.2 GL40.3
GL40.6 GL40.7
GL40.8 GL44.1
GL45.1 GL500
IFGT.1 SL40.1
SLT-TO-BASERATE Signed 14.7 AC45.1 GL146
Element: Curr Rate The rate used to calculate the base GL190 GL191
amount from the nonbase currency GL197 GL40.1
transaction amount. GL40.2 GL40.3
GL40.6 GL40.7
GL40.8 GL44.1
GL45.1 GL500
IFGT.1 SL40.1
SLT-TO-BASE-CURR Alpha 5 AC45.1 GL146
Element: Currency Code The amount exchanged to the company GL190 GL191
base currency. GL197 GL40.1
GL40.2 GL40.3
GL40.6 GL40.7
GL40.8 GL44.1
GL45.1 GL500
IFGT.1 SL40.1
SLT-DOCUMENT-NBR Alpha 27 AC45.1 GL146
Element: Document Nbr The document number associated with the GL190 GL191
transaction. GL197 GL40.1
GL40.2 GL40.3
GL40.6 GL40.7
GL40.8 GL44.1
GL45.1 GL500
IFGT.1 SL40.1
SLT-HOLD-CODE Alpha 4 AC45.1 GL146
Element: Hold Code The hold code. GL190 GL191
GL197 GL40.1
GL40.2 GL40.3
GL40.6 GL40.7
GL40.8 GL44.1
GL45.1 GL500
IFGT.1 SL40.1
SLT-REL-OPERATOR Alpha 10 AC45.1 GL146
Element: Operator The operator that created the GL190 GL191
transaction. GL197 GL199
GL40.1 GL40.2
GL40.3 GL40.6
GL40.7 GL40.8
GL44.1 GL45.1
GL500 IFGT.1
SL40.1
SLT-RPT-AMOUNT-1 Signed 18.2 AC45.1 GL146
Element: Intl Amt GL190 GL191
GL197 GL310
GL40.1 GL40.2
GL40.3 GL40.6
GL40.7 GL40.8
GL44.1 GL45.1
GL500 IFGT.1
SL40.1
SLT-RPT-RATE-1 Signed 14.7 AC45.1 GL146
Element: Curr Rate The currency rate. GL190 GL191
GL197 GL310
GL40.1 GL40.2
GL40.3 GL40.6
GL40.7 GL40.8
GL44.1 GL45.1
GL500 IFGT.1
SL40.1
SLT-RPT-ND-1 Numeric 1 AC45.1 GL146
Element: Acct Nd The number of decimals assigned to a GL190 GL191
particular account as determined by the GL197 GL310
account currency. GL40.1 GL40.2
GL40.3 GL40.6
GL40.7 GL40.8
GL44.1 GL45.1
GL500 IFGT.1
SL40.1
SLT-RPT-AMOUNT-2 Signed 18.2 AC45.1 GL146
Element: Intl Amt GL190 GL191
GL197 GL310
GL40.1 GL40.2
GL40.3 GL40.6
GL40.7 GL40.8
GL44.1 GL45.1
GL500 IFGT.1
SL40.1
SLT-RPT-RATE-2 Signed 14.7 AC45.1 GL146
Element: Curr Rate The currency rate. GL190 GL191
GL197 GL310
GL40.1 GL40.2
GL40.3 GL40.6
GL40.7 GL40.8
GL44.1 GL45.1
GL500 IFGT.1
SL40.1
SLT-RPT-ND-2 Numeric 1 AC45.1 GL146
Element: Acct Nd The number of decimals assigned to a GL190 GL191
particular account as determined by the GL197 GL310
account currency. GL40.1 GL40.2
GL40.3 GL40.6
GL40.7 GL40.8
GL44.1 GL45.1
GL500 IFGT.1
SL40.1
SLT-GLT-OBJ-ID Numeric 12 AC45.1 GL146
Element: Obj Id This is the object identifier. It is GL190 GL191
used to relate commitments or posted GL197 GL199
transactions back to the originating GL40.1 GL40.2
subsystems. Each subsystem record that GL40.3 GL40.6
is updated as a commitment or posted GL40.7 GL40.8
transaction is assigned an object GL44.1 GL45.1
identifier. The object identifier is GL500 IFGT.1
maintained in the subsystem files and in SL40.1
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-BLOCK Alpha 103 AC45.1 GL146
Element: Segment Block This field identifies the user analysis GL190 GL191
values included in the transaction. GL197 GL40.1
GL40.2 GL40.3
You can either type the values or use GL40.6 GL40.7
Define (F6) to open the User Analysis GL40.8 GL44.1
Entry subform. Use this subform to GL45.1 GL500
select the user analysis values you want IFGT.1 SL40.1
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.
SLTRANS FILE INDEX
NAME KEY FIELDS DESCRIPTION / SUBSET CONDITION USED IN
SLTSET1 OBJ-ID GL500
SLTSET2 SEGMENT-GROUP KeyChange GL110 SL00.2
POSTING-DATE SL01.1 SL01.2
OBJ-ID
SLTSET3 GLT-OBJ-ID KeyChange AC45.1 GL146
OBJ-ID GL190 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
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
|