SLTRANS

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 GL500 IFGT.1
SL40.1 SL00.2 SL01.1 SL01.2 GL240

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


SLTRANS FILE INDEX

NAME KEY FIELDS DESCRIPTION / SUBSET CONDITION USED IN
SLTSET1 OBJ-ID
GL500
SLTSET2 SEGMENT-GROUP
POSTING-DATE
OBJ-ID
KeyChange
GL110 SL00.2
SL01.1 SL01.2
SLTSET3 GLT-OBJ-ID
OBJ-ID
KeyChange
GL146 GL190
GL197 GL199
GL240 GL310
GL40.1 GL40.2
GL40.3 GL40.6
GL40.7 GL40.8
GL44.1 GL45.1
SLTSET4 SEGMENT-GROUP
COMPANY
ACCT-UNIT
ACCOUNT
SUB-ACCOUNT
POSTING-DATE
OBJ-ID
KeyChange
GL120


SLTRANS FILE RELATIONS


ONE TO ONE RELATIONS

RELATION
NAME
RELATED 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
NAME
RELATED 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


File created: Wed Jun 08 20:51:37 2016

Home
Contact Us



All trademarks and registered trademarks are the property of their respective owners.