Lawson Insight Technical Documentation |
|
ACSUMBAL
ACSUMBAL FILE
REFERENCED BY
ACTA.1
UPDATED BY
AC121 AC123 AC127 AC20.1 AC20.2 AC20.3
AC20.4 AC20.5 AC20.6 AC20.7 AC22.1 AC300
AC310 ACDR.1 SB515
FIELD NAME DESCRIPTION/VALID VALUES UPDATED BY
SMB-ACTIVITY-GRP Alpha 15 AC121 AC123
Element: Activity Grp The activity group is the overall AC127 AC20.1
project. AC20.2 AC20.3
AC20.4 AC20.5
AC20.6 AC20.7
AC22.1 ACDR.1
SB515
SMB-ACTIVITY Alpha 15 AC121 AC123
Element: Activity Activities are the processes or AC127 AC20.1
procedures that produce work. Cost AC20.2 AC20.3
objects (products, services, customers, AC20.4 AC20.5
and so on) are the reasons for AC20.6 AC20.7
performing the activity. AC22.1 ACDR.1
SB515
SMB-SUM-ACCT-CAT Alpha 5 AC121 AC123
Element: Sum Acct Cat The name of the summary account AC127 AC20.1
category. AC20.2 AC20.3
AC20.4 AC20.5
AC20.6 AC20.7
AC22.1 ACDR.1
SB515
SMB-FISCAL-YEAR Numeric 4 AC121 AC123
Element: Fiscal Year This is the current fiscal year. This AC127 AC20.1
field is updated by Period Closing AC20.2 AC20.3
(GL199). AC20.4 AC20.5
AC20.6 AC20.7
AC22.1 ACDR.1
SB515
SMB-BEGIN-BAL-AMT Signed 18.2 AC121 AC123
Element: Intl Amt AC127 AC20.1
AC20.2 AC20.3
AC20.4 AC20.5
AC20.6 AC20.7
AC22.1 AC300
ACDR.1 SB515
SMB-BEGIN-BAL-UNIT Signed 17.2 AC121 AC123
Element: Balance Unit AC127 AC20.1
AC20.2 AC20.3
AC20.4 AC20.5
AC20.6 AC20.7
AC22.1 AC300
ACDR.1 SB515
SMB-BALANCE-AMT Signed 18.2 AC121 AC123
Element: Intl Amt AC127 AC20.1
AC20.2 AC20.3
AC20.4 AC20.5
AC20.6 AC20.7
AC22.1 AC300
ACDR.1 SB515
SMB-BALANCE-UNIT Signed 17.2 AC121 AC123
Element: Balance Unit AC127 AC20.1
AC20.2 AC20.3
AC20.4 AC20.5
AC20.6 AC20.7
AC22.1 AC300
ACDR.1 SB515
SMB-PERIOD-AMT Signed 18.2 Occurs 13 Times AC121 AC123
Element: Intl Amt AC127 AC20.1
AC20.2 AC20.3
AC20.4 AC20.5
AC20.6 AC20.7
AC22.1 AC300
ACDR.1 SB515
SMB-PERIOD-UNIT Signed 15.2 Occurs 13 Times AC121 AC123
Element: Unit AC127 AC20.1
AC20.2 AC20.3
AC20.4 AC20.5
AC20.6 AC20.7
AC22.1 AC300
ACDR.1 SB515
SMB-BUDGET-NBR Numeric 3 AC121 AC123
Element: Budget Nbr The Budget Number field contains the AC127 AC20.1
budget number. AC20.2 AC20.3
AC20.4 AC20.5
AC20.6 AC20.7
AC22.1 ACDR.1
SB515
ACSUMBAL FILE INDEX
NAME KEY FIELDS DESCRIPTION / SUBSET CONDITION USED IN
SMBSET1 ACTIVITY-GRP AC121 AC123
ACTIVITY AC127 AC20.1
SUM-ACCT-CAT AC20.2 AC20.3
BUDGET-NBR AC20.4 AC20.5
FISCAL-YEAR AC20.6 AC20.7
AC22.1 AC300
AC310 ACDR.1
ACTA.1 SB515
SMBSET2 ACTIVITY-GRP AC121 AC123
ACTIVITY AC127 AC20.1
SUM-ACCT-CAT AC20.2 AC20.3
BUDGET-NBR AC20.4 AC20.5
FISCAL-YEAR* AC20.6 AC20.7
AC22.1 ACDR.1
ACTA.1 SB515
|