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.

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
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.
AC45.1 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.
AC45.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-COMPANY
Element: Company		Numeric 4
The number that identifies the company associated with the Strategic Ledger Transaction.
AC45.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-FISCAL-YEAR
Element: Fiscal Year		Numeric 4
This is the current fiscal year. .
AC45.1 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.
AC45.1 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.)
AC45.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-VAR-LEVELS
Element: Level		Alpha 30
A level that represents the location of an accounting unit in an organization's level structure.
AC45.1 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.
AC45.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-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.
AC45.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-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.
AC45.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-SOURCE-CODE
Element: Source Code		Alpha 2
A two character code assigned to a transaction to identify where the transaction was created.
AC45.1 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.
AC45.1 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.
AC45.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-DESCRIPTION
Element: Description		Alpha 30 (Lower Case)
This field displays the description.
AC45.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-BASE-AMOUNT
Element: Intl Amt		Signed 18.2
The company base amount.
AC45.1 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.
AC45.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-UNITS-AMOUNT
Element: Units Amount		Signed 15.2
This is the units amount included in the file.
AC45.1 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.
AC45.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-POSTING-DATE
Element: Posting Date		Numeric 8 (yyyymmdd)
The date assigned to the journal entry for posting.
AC45.1 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.
AC45.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-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
AC45.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-CURRENCY-CODE
Element: Currency Code		Alpha 5
This field contains the company base currency code established in Company (GL10.1 ).
AC45.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.
AC45.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-TRAN-AMOUNT
Element: Intl Amt		Signed 18.2
AC45.1 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.
AC45.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-ACCT-CURRENCY
Element: Currency Code		Alpha 5
The account currency code associated with the transaction.
AC45.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-ACCT-RATE
Element: Curr Rate		Signed 14.7
The exchange rate defined for the currency relationship.
AC45.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-ACCT-AMOUNT
Element: Intl Amt		Signed 18.2
AC45.1 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.
AC45.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-OPERATOR
Element: Operator		Alpha 10
This field is used to store the login id of the person who entered the record.
AC45.1 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.
AC45.1 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.
AC45.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-TO-BASERATE
Element: Curr Rate		Signed 14.7
The rate used to calculate the base amount from the nonbase currency transaction amount.
AC45.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-TO-BASE-CURR
Element: Currency Code		Alpha 5
The amount exchanged to the company base currency.
AC45.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-DOCUMENT-NBR
Element: Document Nbr		Alpha 27
The document number associated with the transaction.
AC45.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-HOLD-CODE
Element: Hold Code		Alpha 4
The hold code.
AC45.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-REL-OPERATOR
Element: Operator		Alpha 10
The operator that created the transaction.
AC45.1 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
AC45.1 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.
AC45.1 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.
AC45.1 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
AC45.1 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.
AC45.1 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.
AC45.1 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.
AC45.1 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.
AC45.1 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
AC45.1 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: Thu Jun 09 02:32:37 2016

Home
Contact Us



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