SLAMOUNTS FILE
Profitability Ledger Amounts
The Strategic Ledger Amounts (SLAMOUNTS) file stores the summarized balance
detail created by posting the Strategic Ledger Transaction (SLTRANS) records.
Use SL190 (Strategic Ledger Posting) to post balances.
FIELD NAME DESCRIPTION/VALID VALUES UPDATED BY
SAM-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).
SAM-SLAMOUNTS-ID Numeric 12
Amounts ID The identifier for the amounts record.
SAM-LEDGER-ACCOUNT Numeric 12
Ledger Account The General Ledger account number
associated with the strategic ledger.
SAM-FISCAL-YEAR Numeric 4
Fiscal Year This is the current fiscal year. This
field is updated by Period Closing
(GL199).
SAM-CAL-PERIOD Numeric 3
Accounting Period The strategic ledger period amounts are
posted to.
SAM-MAINT-DATE Numeric 8 (yyyymmdd)
Maintenance Date The date last changed.
SAM-MAINT-TIME Numeric 6 (hhmmss)
Maintenance Time The time last changed.
SAM-AMOUNT Currency 15.2
Amounts This is the amounts by period for the
specified record.
SAM-UNITS Signed 15.2
Units This is the units by period for the
specified record.
SLAMOUNTS FILE INDEX
NAME KEY FIELDS DESCRIPTION / SUBSET CONDITION USED IN
SAMSET1 LEDGER
SLAMOUNTS-ID
SAMSET2 LEDGER
LEDGER-ACCOUNT
FISCAL-YEAR
CAL-PERIOD
SAMSET3 LEDGER KeyChange
MAINT-DATE
MAINT-TIME
SLAMOUNTS-ID
SAMSET4 LEDGER
FISCAL-YEAR
LEDGER-ACCOUNT
CAL-PERIOD
SLAMOUNTS FILE RELATIONS
ONE TO ONE RELATIONS
RELATION RELATED
NAME FILE INTEGRITY RULES / FIELD MATCH
Slaccount SLACCOUNT Required
SAM-LEDGER -> SLA-LEDGER (SLASET1)
SAM-LEDGER-ACCOUNT -> SLA-LEDGER-ACCOUNT
Slledger SLLEDGER Required
SAM-LEDGER -> SLL-LEDGER
SLAMOUNTS FILE RELATIONS
ONE TO MANY RELATIONS
RELATION RELATED
NAME FILE INTEGRITY RULES / FIELD MATCH
Sltdrill SLDRILL Delete Cascades
SAM-LEDGER -> SLX-LEDGER
SAM-SLAMOUNTS-ID -> SLX-SLAMOUNTS-ID
SLX-SLTRANS-ID
|
