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 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-GROUP Alpha 15 AC45.1 GL146
Element: User Analysis A user analysis group is a combination GL190 GL191
of up to four user analysis for reports GL197 GL40.1
and 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 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-FISCAL-YEAR Numeric 4 AC45.1 GL146
Element: Fiscal Year This is the current fiscal year. This GL190 GL191
field is updated by Period Closing GL197 GL199
(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
This field is updated by GL199 (Period GL197 GL199
Closing). 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, AP = GL40.2 GL40.3
Accounts Payable, 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 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-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 base amount to be posted to the GL190 GL191
General Ledger Account Master file. 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
Base Number Of The number of decimal positions defined GL190 GL191
Decimals 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 This is the company number to which GL190 GL191
this line is to be posted. GL197 GL40.1
GL40.2 GL40.3
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: Exchange Rate 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 This is the amount in transaction GL190 GL191
currency to be posted. This amount GL197 GL40.1
creates a CUAMOUNT type 1 record. 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
Account Currency The number of decimal positions defined GL190 GL191
Code for the transaction currency. GL197 GL40.1
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: Currency 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 The transaction amount associated with GL190 GL191
the account currency. 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
Account Currency The number of decimals assigned to a GL190 GL191
Code 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 Code 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
Account Currency GL190 GL191
Code GL197 GL40.1
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: Currency 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 NumbeThe 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 Code 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 The transaction amount for Report GL190 GL191
Currency 1. 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: Currency Rate The exchange rate to convert the GL190 GL191
transaction amount to Report Currency 1. GL197 GL310
The exchange rate is defined in CU10.1 GL40.1 GL40.2
(Exchange Rate). 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
Account Currency The number of decimal positions for GL190 GL191
Code Report Currency 1. 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-AMOUNT-2 Signed 18.2 AC45.1 GL146
Element: Intl Amt The transaction amount for Report GL190 GL191
Currency 2. 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: Currency Rate The exchange rate to convert the GL190 GL191
transaction amount to Report Currency 2. GL197 GL310
The exchange rate is defined in CU10.1 GL40.1 GL40.2
(Exchange Rate). 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
Account Currency The number of decimal positions for GL190 GL191
Code Report Currency 2. GL197 GL310
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
Object This is a subsystem GL interface GL190 GL191
Identification identification number. It is used for GL197 GL199
Drill Around purposes. GL40.1 GL40.2
GL40.3 GL40.6
GL40.7 GL40.8
GL44.1 GL45.1
GL500 IFGT.1
SL40.1
SLT-SEGMENT-BLOCK Alpha 103 AC45.1 GL146
Element: User Analysis This field identifies the user analysis GL190 GL191
values included in the transaction. GL197 GL40.1
GL40.2 GL40.3
You can either type up to four values GL40.6 GL40.7
or use Define (F6) to open the User GL40.8 GL44.1
Analysis Entry subform. Use this subform GL45.1 GL500
to select the user analysis values you IFGT.1 SL40.1
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 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-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
|