SLLEDGER FILE
PL Ledger
The Strategic Ledger Ledger (SLLEDGER) file stores strategic ledger
information defined in SL50.1 (Strategic Ledger). Ledger information is used
to post and summarize strategic ledger data using SL190 (Strategic Ledger
Posting) and for reporting in the OLAP environment using SL87 (Strategic
Ledger Data Mart Setup).
FIELD NAME DESCRIPTION/VALID VALUES UPDATED BY
SLL-LEDGER Alpha 15
Profitability Ledger The name that identifies the strategic
ledger.
The Ledger information is used to post
Strategic ledger data using SL190
(Strategic Ledger Posting) or used for
reporting in the OLAP environment using
SL87 (Strategic Ledger Data Mart Setup).
SLL-DESCRIPTION Alpha 30 (Lower Case)
Ledger Description The description of the ledger.
SLL-CALENDAR Alpha 15
Calendar Identifies the Strategic ledger
calendar.
SLL-CURRENCY-CODE Alpha 5
Currency Code This field contains the company base
currency code established in Company
(GL10.1 ).
SLL-CURRENCY-TYPE Alpha 1
Currency Type This field identifies the type of
currency included. You can select Base
currency or Transaction currency.
SLL-SEGMENT Alpha 15 Occurs 10 Times
User Analysis The name that identifies the user
analysis.
A user analysis is a flexible,
user-defined element, much like an
accounting unit, account, or attribute,
that stores transaction information you
can use for reports and analysis.
You can use a user analysis to track
multiple elements of business data.
SLL-SEGMENT-TYPE Alpha 1 Occurs 10 Times
Segment Type This identifies whether the information
included in the ledger defined in SL50.1
(Strategic Ledger) General Ledger only
information, a user analysis field, or
an attribute.
1 = GL Segment
2 = User Analysis
3 = Attribute
SLL-SEG-VAL-COUNT Numeric 12 Occurs 10 Times
Seg Val Count
SLL-SEG-KEY-SIZE Numeric 2 Occurs 10 Times
Seg Key Size This identifies the segment size.
SLL-LAST-SLT-ID Numeric 12
Last Slt Id
SLL-LAST-SLA-ID Numeric 12
Last Sla Id
SLL-LAST-SAM-ID Numeric 12
Last Sam Id
SLL-LAST-SEQ-NBR Numeric 6
Last Seq Nbr
SLL-LAST-RUN-DATE Numeric 8 (yyyymmdd)
Last Run Date The date the ledger was last run.
SLL-LAST-RUN-TIME Numeric 6 (hhmmss)
Last Run Time The time the ledger was last ran.
SLL-COMPANY Numeric 4
Company The company number represents an
established company and is entered on
all function codes.
SLL-COMPANY-GROUP Alpha 12
Company Group You can type or select a company group.
A company group represents one or more
companies.
If you select a company group, leave
the Company field blank.
SLL-CHART-NAME Alpha 12
Chart of Accounts This is the name you assigned to the
chart of accounts when you defined your
company structure in the General Ledger
system.
SLL-CHART-SECTION Alpha 1
Chart Section The chart section.
" " = All
1 = Balance Sheet
2 = Income Statement
SLL-SEGMENT2 Alpha 15 Occurs 10 Times
Segment2
SLL-ORG-DIMENSION Alpha 50 (Lower Case)
Organization The Organization Dimension Name field
Dimensioin Name contains the user-defined name for the
Organization dimension. This name can
contain up to 30 characters of any kind.
SLL-ACT-DIMENSION Alpha 50 (Lower Case)
Act Dimension The Accounts Dimension Name field
contains the user-defined name for the
Accounts dimension. This name can
contain up to 30 characters of any kind.
SLLEDGER FILE INDEX
NAME KEY FIELDS DESCRIPTION / SUBSET CONDITION USED IN
SLLSET1 LEDGER
SLLEDGER FILE RELATIONS
ONE TO MANY RELATIONS
RELATION RELATED
NAME FILE INTEGRITY RULES / FIELD MATCH
Slaccount SLACCOUNT Delete Cascades
SLL-LEDGER -> SLA-LEDGER (SLASET1)
SLA-LEDGER-ACCOUNT
Slamounts SLAMOUNTS Delete Cascades
SLL-LEDGER -> SAM-LEDGER
SAM-SLAMOUNTS-ID
Slslsel SLSLSEL Delete Cascades
SLL-LEDGER -> SLS-LEDGER
SLS-OR-GROUP
SLS-SEGMENT
SLS-SEQ-NUMBER
Slslvalue SLSLVALUE Delete Cascades
SLL-LEDGER -> SLV-LEDGER
SLV-SEGMENT
SLV-SEGMENT-VALUE
|
