SLTRANSREL FILE
FIELD NAME DESCRIPTION/VALID VALUES UPDATED BY
STR-RUN-GROUP Alpha 15
Run Group Run Group and Seq Number are the keys
to the file. They should be used to
group records together for interfacing.
STR-SEQ-NUMBER Numeric 6
Record Sequence A unique number assigned to each
Number transaction to be transferred into the
Lawson system.
STR-COMPANY Numeric 4
Company The company number represents an
established company and is entered on
all function codes.
STR-OLD-COMPANY Alpha 35
Old Company The old company structure associated
with the Lawson Company/Accounting Unit.
STR-OLD-CPY-SHORT Derived
Old Cpy Short The short description.
STR-STRING-COMPANY Derived
String Company
STR-OLD-ACCT-NBR Alpha 25
Old Account Number This is the old account structure to be
associated with the new
account/subaccount within the Lawson
system.
STR-OLD-ACCT-SHORT Derived
Old Acct Short The short description.
STR-SOURCE-CODE Alpha 2
Source Code A two character code assigned to a
transaction to identify where the
transaction was created.
STR-SYSTEM Alpha 2
System Code A two-character code representing an
application used within the Lawson
system. (i.e.: GL = General Ledger, AP =
Accounts Payable, etc.)
STR-DATE Numeric 8 (yyyymmdd)
Date This field displays the system date
when this was created.
STR-POSTING-DATE Numeric 8 (yyyymmdd)
Posting Date The date assigned to the journal entry
for posting.
STR-REFERENCE Alpha 10 (Lower Case)
Reference The reference number associated with
the transaction.
STR-DESCRIPTION Alpha 30 (Lower Case)
Description This field displays the description.
STR-CURRENCY-CODE Alpha 5
Currency Code This field contains the company base
currency code established in Company
(GL10.1 ).
STR-UNITS-AMOUNT Signed 15.2
Units Amount This is the units amount included in
the file.
STR-TRAN-AMOUNT Signed 15.2
Invoice Amount This is the amount in transaction
currency to be posted. This amount
creates a CUAMOUNT type 1 record.
STR-BASE-AMOUNT Signed 15.2
Base Amount The base amount to be posted to the
General Ledger Account Master file.
STR-BASERATE Signed 12.6
Exchange Rate Enter the exchange rate at the time the
journal entry was made. If left blank,
the current exchange rate will default.
STR-ACTIVITY Alpha 15
Activity Activities are the processes or
procedures that produce work. Cost
objects (products, services, customers,
and so on) are the reasons for
performing the activity.
STR-ACCT-CATEGORY Alpha 5
Account Category 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.
STR-DOCUMENT-NBR Alpha 27
Document Number The number assigned to the transaction
(invoice, credit memo, etc.) for which
the intrastat data was entered.
STR-TO-BASE-AMT Signed 15.2
To Company Base
Amount
STR-MX-VALUE Alpha 32 Occurs 3 Times
Attribute Value
STR-MX-VALUE1 Derived
Attribute Value
STR-MX-VALUE2 Derived
Attribute Value
STR-MX-VALUE3 Derived
Attribute Value
STR-SEGMENT-BLOCK Alpha 103
User Analysis This field identifies the user analysis
values included in the transaction.
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.
STR-RPT-AMOUNT-1 Signed 15.2
Report Currency 1 The transaction amount for Report
Amount Currency 1.
STR-RPT-RATE-1 Signed 12.6
Rpt Rate 1 The exchange rate to convert the
transaction amount to Report Currency 1.
The exchange rate is defined in CU10.1
(Exchange Rate).
STR-RPT-ND-1 Numeric 1
Rpt Nd 1 The number of decimal positions for
Report Currency 1.
STR-RPT-AMOUNT-2 Signed 15.2
Report Currency 2 The transaction amount for Report
Amount Currency 2.
STR-RPT-RATE-2 Signed 12.6
Rpt Rate 2 The exchange rate to convert the
transaction amount to Report Currency 2.
The exchange rate is defined in CU10.1
(Exchange Rate).
STR-RPT-ND-2 Numeric 1
Rpt Nd 2 The number of decimal positions for
Report Currency 2.
SLTRANSREL FILE INDEX
NAME KEY FIELDS DESCRIPTION / SUBSET CONDITION USED IN
STRSET1 RUN-GROUP
SEQ-NUMBER
STRSET2 COMPANY KeyChange
OLD-COMPANY
OLD-ACCT-NBR
RUN-GROUP
SEQ-NUMBER
STRSET3 RUN-GROUP KeyChange
COMPANY
OLD-COMPANY
OLD-ACCT-NBR
SEQ-NUMBER
SLTRANSREL FILE RELATIONS
ONE TO ONE RELATIONS
RELATION RELATED
NAME FILE INTEGRITY RULES / FIELD MATCH
Company GLSYSTEM Required
STR-COMPANY -> GLS-COMPANY (GLSSET1)
Currency Code CUCODES Not Required
STR-CURRENCY-CODE -> CUC-CURRENCY-CODE
Old Company GLCOMPREL Required
STR-OLD-COMPANY -> GCR-OLD-COMPANY
Source Code GLCODES Not Required
STR-SOURCE-CODE -> GCD-SOURCE-CODE
System Code GLCODES Not Required
STR-COMPANY -> GCD-COMPANY
STR-SYSTEM -> GCD-SYSTEM
|
