SLTRANS FILE SL 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 GL110 GL146 GL190 GL191 GL199 GL45.1 IFGT.1 SL40.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 SL40.1 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-TRL-OBJ-ID-1 Numeric 12 GL146 GL190 Object ID 1 This is the object identifier. GL191 GL199 GL45.1 IFGT.1 SL40.1 SLT-TRL-OBJ-ID-2 Numeric 12 GL146 GL190 Object ID 2 This is the object identifier. GL191 GL199 GL45.1 IFGT.1 SL40.1 SLT-TRL-OBJ-ID-3 Numeric 12 GL146 GL190 Object ID 3 This is the object identifier. GL191 GL199 GL45.1 IFGT.1 SL40.1 SLT-TRL-OBJ-ID-4 Numeric 12 GL146 GL190 Object ID 4 This is the object identifier. GL191 GL199 GL45.1 IFGT.1 SL40.1 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. SL40.1 SLT-SEGMENT-VALUE Alpha 32 Occurs 4 Times GL146 GL190 User Analysis Value The value for the user analysis. GL191 GL199 GL45.1 IFGT.1 SL40.1 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. SL40.1 SLT-FISCAL-YEAR Numeric 4 GL146 GL190 Fiscal Year This is the current fiscal year. This GL191 GL199 field is updated by GL199 (Period GL45.1 IFGT.1 Closing). SL40.1 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). SL40.1 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 = SL40.1 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. SL40.1 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 SL40.1 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 SL40.1 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 SL40.1 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. SL40.1 SLT-DATE Numeric 8 (yyyymmdd) GL146 GL190 Date This field contains the system date GL191 GL199 when this was created. GL45.1 IFGT.1 SL40.1 SLT-REFERENCE Alpha 10 (Lower Case) GL146 GL190 Reference The reference number associated with GL191 GL199 the transaction. GL45.1 IFGT.1 SL40.1 SLT-DESCRIPTION Alpha 30 (Lower Case) GL146 GL190 Description This field contains the description. GL191 GL199 GL45.1 IFGT.1 SL40.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 SL40.1 SLT-BASE-ND Numeric 1 GL146 GL190 Currency Code The number of decimal positions defined GL191 GL199 for the company base currency. GL45.1 IFGT.1 SL40.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 SL40.1 SLT-TO-COMPANY Numeric 4 GL146 GL190 Company This is the company number to which GL191 GL199 this line is to be posted. GL45.1 IFGT.1 SL40.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 SL40.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, SL40.1 and so on) are the reasons for performing the activity. Activities and cost object activities are used synonymously in the Activity Management system. Direct costs are posted to activities, and indirect costs are allocated to activities based on activity drivers. Activities are grouped or organized by activity levels. There are two kinds of activities: "posting allowed" and "summary only." Use posting level activities to budget and maintain all posted transactions. Summary activities or macro activities combine information and balances from lower level activities for reporting and inquiries. 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 SL40.1 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 GL10.1 GL45.1 IFGT.1 (Company). SL40.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. SL40.1 SLT-TRAN-AMOUNT Signed 15.2 GL146 GL190 Transaction 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. SL40.1 SLT-TRAN-ND Numeric 1 GL146 GL190 Transaction The number of decimal positions defined GL191 GL199 Currency Code for the transaction currency. GL45.1 IFGT.1 SL40.1 SLT-ACCT-CURRENCY Alpha 5 GL146 GL190 Account Currency The account currency code associated GL191 GL199 with the transaction. GL45.1 IFGT.1 SL40.1 SLT-ACCT-RATE Signed 12.6 GL146 GL190 Exchange Rate The exchange rate defined for the GL191 GL199 currency relationship. GL45.1 IFGT.1 SL40.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 SL40.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. SL40.1 SLT-OPERATOR Alpha 10 GL146 GL190 Operator This field is used to store the login GL191 GL199 id of the person who entered the record. GL45.1 IFGT.1 SL40.1 SLT-TO-BASE-AMT Signed 15.2 GL146 GL190 Base Amount The amount exchanged to the company GL191 GL199 base currency. GL45.1 IFGT.1 SL40.1 SLT-TO-BASE-ND Numeric 1 GL146 GL190 Base Currency Code GL191 GL199 GL45.1 IFGT.1 SL40.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. SL40.1 SLT-TO-BASE-CURR Alpha 5 GL146 GL190 Currency Code The amount exchanged to the company GL191 GL199 base currency. GL45.1 IFGT.1 SL40.1 SLT-DOCUMENT-NBR Alpha 24 GL146 GL190 Document Number The document number associated with the GL191 GL199 transaction. GL45.1 IFGT.1 SL40.1 SLT-HOLD-CODE Alpha 4 GL146 GL190 Hold Code The hold code. GL191 GL199 GL45.1 IFGT.1 SL40.1 SLT-REL-OPERATOR Alpha 10 GL146 GL190 Operator The operator that created the GL191 GL199 transaction. GL45.1 IFGT.1 SL40.1 SLT-RPT-AMOUNT-1 Signed 15.2 GL146 GL190 Report Currency 1 The transaction amount for Report GL191 GL199 Amount Currency 1. GL45.1 IFGT.1 SL40.1 SLT-RPT-RATE-1 Signed 12.6 GL146 GL190 Exchange Rate The exchange rate to convert the GL191 GL199 transaction amount to Report Currency 1. GL45.1 IFGT.1 The exchange rate is defined in CU10.1 SL40.1 (Exchange Rate). SLT-RPT-ND-1 Numeric 1 GL146 GL190 Report Currency 1 The number of decimal positions for GL191 GL199 Code Report Currency 1. GL45.1 IFGT.1 SL40.1 SLT-RPT-AMOUNT-2 Signed 15.2 GL146 GL190 Report Currency 2 The transaction amount for Report GL191 GL199 Amount Currency 2. GL45.1 IFGT.1 SL40.1 SLT-RPT-RATE-2 Signed 12.6 GL146 GL190 Exchange Rate The exchange rate to convert the GL191 GL199 transaction amount to Report Currency 2. GL45.1 IFGT.1 The exchange rate is defined in CU10.1 SL40.1 (Exchange Rate). SLT-RPT-ND-2 Numeric 1 GL146 GL190 Report Currency 2 The number of decimal positions for GL191 GL199 Code Report Currency 2. GL45.1 IFGT.1 SL40.1 SLT-GLT-OBJ-ID Numeric 12 GL146 GL190 Object ID This is a subsystem GL interface GL191 GL199 identification number. It is used for GL45.1 IFGT.1 Drill Around purposes. SL40.1 SLT-SEGMENT-VALUE1 Derived Value 1 The user analysis values included in a transaction. SLT-SEGMENT-VALUE2 Derived Value 2 The user analysis values included in the transaction. SLT-SEGMENT-VALUE3 Derived Value 3 The user analysis values included in the transaction. SLT-SEGMENT-VALUE4 Derived Value 4 The user analysis values included in the transaction. SLTRANS FILE INDEX NAME KEY FIELDS DESCRIPTION / SUBSET CONDITION USED IN SLTSET1 OBJ-ID SLTSET2 SEGMENT-GROUP GL110 SL00.2 TRL-OBJ-ID-1 SL01.1 SL01.2 TRL-OBJ-ID-2 TRL-OBJ-ID-3 TRL-OBJ-ID-4 POSTING-DATE OBJ-ID SLTSET3 GLT-OBJ-ID GL146 GL199 OBJ-ID GL240 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 System Code SYSTEMCODE Required SLT-SYSTEM -> SYS-SYSTEM 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-COMPANY -> APD-DIST-COMPANY SLT-ACCT-UNIT -> APD-DIS-ACCT-UNIT SLT-ACCOUNT -> APD-DIS-ACCOUNT SLT-SUB-ACCOUNT -> APD-DIS-SUB-ACCT SLT-POSTING-DATE -> APD-DISTRIB-DATE 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 Eedistrib EEDISTRIB SLT-TO-COMPANY -> EED-DIST-COMPANY SLT-ACCT-UNIT -> EED-EXP-ACCT-UNIT SLT-ACCOUNT -> EED-EXP-ACCOUNT SLT-SUB-ACCOUNT -> EED-EXP-SUB-ACCT SLT-POSTING-DATE -> EED-DISTRIB-DATE SLT-GLT-OBJ-ID -> EED-GLT-OBJ-ID EED-COMPANY EED-VENDOR EED-EXPENSE-NBR EED-SEQ-NBR Icmmdist MMDIST Valid When SLT-SYSTEM = "IC" SLT-GLT-OBJ-ID -> MMD-GLT-OBJ-ID MMD-COMPANY MMD-SYSTEM-CD MMD-LOCATION MMD-DOC-TYPE MMD-DOC-NBR 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 Pommdist MMDIST Valid When SLT-SYSTEM = "PO" SLT-GLT-OBJ-ID -> MMD-GLT-OBJ-ID MMD-COMPANY MMD-SYSTEM-CD MMD-LOCATION MMD-DOC-TYPE MMD-DOC-NBR MMD-DOC-NBR-NUM MMD-LINE-NBR MMD-COMPONENT-SEQ MMD-LINE-SEQ 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 Rqmmdist MMDIST Valid When SLT-SYSTEM = "RQ" SLT-GLT-OBJ-ID -> MMD-GLT-OBJ-ID MMD-COMPANY MMD-SYSTEM-CD MMD-LOCATION MMD-DOC-TYPE MMD-DOC-NBR MMD-DOC-NBR-NUM MMD-LINE-NBR MMD-COMPONENT-SEQ MMD-LINE-SEQ Slmxvalue SLMXVALUE SLT-OBJ-ID -> SMV-OBJ-ID SMV-MATRIX-CAT |