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 GL146 GL190 GL191 GL199 GL310
GL45.1 IFGT.1
FIELD NAME DESCRIPTION/VALID VALUES UPDATED BY
SLT-OBJ-ID Numeric 12 GL146 GL190
Object ID This is the object identifier. It is GL191 GL199
used to relate commitments or posted GL45.1 IFGT.1
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.
SLT-SEGMENT-GROUP Alpha 15 GL146 GL190
User Analysis Group A user analysis group is a combination GL191 GL199
of up to four user analysis for reports GL45.1 IFGT.1
and analysis.
SLT-COMPANY Numeric 4 GL146 GL190
Company The company number represents an GL191 GL199
established company and is entered on GL45.1 IFGT.1
all function codes.
SLT-FISCAL-YEAR Numeric 4 GL146 GL190
Fiscal Year This is the current fiscal year. This GL191 GL199
field is updated by Period Closing GL45.1 IFGT.1
(GL199).
SLT-ACCT-PERIOD Numeric 2 GL146 GL190
Accounting Period This is the current accounting period. GL191 GL199
This field is updated by GL199 (Period GL45.1 IFGT.1
Closing).
SLT-SYSTEM Alpha 2 GL146 GL190
System Code A two-character code representing an GL191 GL199
application used within the Lawson GL45.1 IFGT.1
system. (i.e.: GL = General Ledger, AP =
Accounts Payable, etc.)
SLT-VAR-LEVELS Alpha 30 GL146 GL190
Level A level that represents the location of GL191 GL199
an accounting unit in an organization's GL45.1 IFGT.1
level structure.
SLT-ACCT-UNIT Alpha 15 GL146 GL190
Accounting Unit The accounting unit is a shorthand GL191 GL199
notation representing the variable level GL45.1 IFGT.1
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.
SLT-ACCOUNT Numeric 6 GL146 GL190
Account This field along with the accounting GL191 GL199
unit and subaccount make up the location GL45.1 IFGT.1
(account) where amounts and other
account information is stored.
SLT-SUB-ACCOUNT Numeric 4 GL146 GL190
Subaccount This field along with the accounting GL191 GL199
unit and subaccount make up the location GL45.1 IFGT.1
(account) where amounts and other
account information is stored.
SLT-SOURCE-CODE Alpha 2 GL146 GL190
Source Code A two character code assigned to a GL191 GL199
transaction to identify where the GL45.1 IFGT.1
transaction was created.
SLT-DATE Numeric 8 (yyyymmdd) GL146 GL190
Date This field displays the system date GL191 GL199
when this was created. GL45.1 IFGT.1
SLT-REFERENCE Alpha 10 (Lower Case) GL146 GL190
Reference The reference number associated with GL191 GL199
the transaction. GL45.1 IFGT.1
SLT-DESCRIPTION Alpha 30 (Lower Case) GL146 GL190
Description This field displays the description. GL191 GL199
GL45.1 IFGT.1
SLT-BASE-AMOUNT Signed 15.2 GL146 GL190
Base Amount The base amount to be posted to the GL191 GL199
General Ledger Account Master file. GL45.1 IFGT.1
SLT-BASE-ND Numeric 1 GL146 GL190
Base Number Of The number of decimal positions defined GL191 GL199
Decimals for the company base currency. GL45.1 IFGT.1
SLT-UNITS-AMOUNT Signed 15.2 GL146 GL190
Units Amount This is the units amount included in GL191 GL199
the file. GL45.1 IFGT.1
SLT-TO-COMPANY Numeric 4 GL146 GL190
To Company This is the company number to which GL191 GL199
this line is to be posted. GL45.1 IFGT.1
SLT-POSTING-DATE Numeric 8 (yyyymmdd) GL146 GL190
Posting Date The date assigned to the journal entry GL191 GL199
for posting. GL45.1 IFGT.1
SLT-ACTIVITY Alpha 15 GL146 GL190
Activity Activities are the processes or GL191 GL199
procedures that produce work. Cost GL45.1 IFGT.1
objects (products, services, customers,
and so on) are the reasons for
performing the activity.
SLT-ACCT-CATEGORY Alpha 5 GL146 GL190
Account Category Account categories are groupings of GL191 GL199
costs, revenues, or a combination of GL45.1 IFGT.1
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.
SLT-CURRENCY-CODE Alpha 5 GL146 GL190
Currency Code This field contains the company base GL191 GL199
currency code established in Company GL45.1 IFGT.1
(GL10.1 ).
SLT-BASERATE Signed 12.6 GL146 GL190
Exchange Rate Enter the exchange rate at the time the GL191 GL199
journal entry was made. If left blank, GL45.1 IFGT.1
the current exchange rate will default.
SLT-TRAN-AMOUNT Signed 15.2 GL146 GL190
Invoice Amount This is the amount in transaction GL191 GL199
currency to be posted. This amount GL45.1 IFGT.1
creates a CUAMOUNT type 1 record.
SLT-TRAN-ND Numeric 1 GL146 GL190
Transaction Number The number of decimal positions defined GL191 GL199
of Decimals for the transaction currency. GL45.1 IFGT.1
SLT-ACCT-CURRENCY Alpha 5 GL146 GL190
Account Currency The account currency code associated GL191 GL199
with the transaction. GL45.1 IFGT.1
SLT-ACCT-RATE Signed 12.6 GL146 GL190
Account Rate The exchange rate defined for the GL191 GL199
currency relationship. GL45.1 IFGT.1
SLT-ACCT-AMOUNT Signed 15.2 GL146 GL190
Account Amount The transaction amount associated with GL191 GL199
the account currency. GL45.1 IFGT.1
SLT-ACCT-ND Numeric 1 GL146 GL190
Account Currency The number of decimals assigned to a GL191 GL199
Code particular account as determined by the GL45.1 IFGT.1
account currency.
SLT-OPERATOR Alpha 10 GL146 GL190
Operator Code This field is used to store the login GL191 GL199
id of the person who entered the record. GL45.1 IFGT.1
SLT-TO-BASE-AMT Signed 15.2 GL146 GL190
To Company Base The amount exchanged to the company GL191 GL199
Amount base currency. GL45.1 IFGT.1
SLT-TO-BASE-ND Numeric 1 GL146 GL190
To Base Number Of GL191 GL199
Decimals GL45.1 IFGT.1
SLT-TO-BASERATE Signed 12.6 GL146 GL190
Exchange Rate The rate used to calculate the base GL191 GL199
amount from the nonbase currency GL45.1 IFGT.1
transaction amount.
SLT-TO-BASE-CURR Alpha 5 GL146 GL190
To Company Base The amount exchanged to the company GL191 GL199
Currency base currency. GL45.1 IFGT.1
SLT-DOCUMENT-NBR Alpha 27 GL146 GL190
Document Number The document number associated with the GL191 GL199
transaction. GL45.1 IFGT.1
SLT-HOLD-CODE Alpha 4 GL146 GL190
Hold Code The hold code. GL191 GL199
GL45.1 IFGT.1
SLT-REL-OPERATOR Alpha 10 GL146 GL190
Release Operator The operator that created the GL191 GL199
transaction. GL45.1 IFGT.1
SLT-RPT-AMOUNT-1 Signed 15.2 GL146 GL190
Report Currency 1 The transaction amount for Report GL191 GL199
Amount Currency 1. GL310 GL45.1
IFGT.1
SLT-RPT-RATE-1 Signed 12.6 GL146 GL190
Rpt Rate 1 The exchange rate to convert the GL191 GL199
transaction amount to Report Currency 1. GL310 GL45.1
The exchange rate is defined in CU10.1 IFGT.1
(Exchange Rate).
SLT-RPT-ND-1 Numeric 1 GL146 GL190
Rpt Nd 1 The number of decimal positions for GL191 GL199
Report Currency 1. GL310 GL45.1
IFGT.1
SLT-RPT-AMOUNT-2 Signed 15.2 GL146 GL190
Report Currency 2 The transaction amount for Report GL191 GL199
Amount Currency 2. GL310 GL45.1
IFGT.1
SLT-RPT-RATE-2 Signed 12.6 GL146 GL190
Rpt Rate 2 The exchange rate to convert the GL191 GL199
transaction amount to Report Currency 2. GL310 GL45.1
The exchange rate is defined in CU10.1 IFGT.1
(Exchange Rate).
SLT-RPT-ND-2 Numeric 1 GL146 GL190
Rpt Nd 2 The number of decimal positions for GL191 GL199
Report Currency 2. GL310 GL45.1
IFGT.1
SLT-GLT-OBJ-ID Numeric 12 GL146 GL190
Subsystem GL This is a subsystem GL interface GL191 GL199
Interface ID identification number. It is used for GL45.1 IFGT.1
Drill Around purposes.
SLT-SEGMENT-BLOCK Alpha 103 GL146 GL190
User Analysis This field identifies the user analysis GL191 GL199
values included in the transaction. GL45.1 IFGT.1
You can either type up to four 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 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 GL146 GL199
OBJ-ID GL310 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
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
Slmxvalue SLMXVALUE
SLT-OBJ-ID -> SMV-OBJ-ID
SMV-MATRIX-CAT
|
