Lawson Insight Technical Documentation |
|
ACBUDDTL
ACBUDDTL FILE
Activity Budget
This file contains activity budget information from the AC20 (Activity
Budget) forms. It includes activity group, activity, budget number, beginning
balance, account category, fiscal year, spread code, compute name, as well as
maintenance time and date.
REFERENCED BY
AC00.1 AC21.1 AC21.2 AC21.3 AC21.4 AC220
AC295 AC297 AC410 AC420 AC65.2 AC65.1
ACDL.1 ACDR.1 AC130 AC32.1 AC37.1 AC40.1
AC40.4 AC41.1 AC41.4 AC42.1 AC490 ACAC.1
AP125 AP126 AP25.1 AP25.2 AP26.1 AP27.1
AP520 BR41.1 BR41.4 BR43.1 CB10.1 CB191
CB20.1 CB30.1 EE135 EE20.3 EE35.1 EE35.2
EE520 GL146 GL165 GL170 GL197 GL40.1
GL40.2 GL40.3 GL40.7 GL40.8 GL44.1 GL45.1
GL75.1 MA65.1 POIG.1 AC23.1 AC06.1 AC165
ACTA.1 BR130 BR530 BR65.1 BR65.2 BRCC.1
UPDATED BY
AC120 AC121 AC123 AC127 AC20.1 AC20.2
AC20.3 AC20.4 AC20.5 AC20.7 AC20.6 AC22.1
AC300 AC310
FIELD NAME DESCRIPTION/VALID VALUES UPDATED BY
BDT-ACTIVITY-GRP Alpha 15 AC120 AC123
Element: Activity GroupRequired key. This is the activity AC127 AC20.1
group for the budget information. AC20.2 AC20.3
AC20.4 AC20.5
BDT-ACTIVITY Alpha 15 AC123 AC127
Element: Activity Required key. This is the activity for AC20.1 AC20.2
the budget information. AC20.3 AC20.4
AC20.5
BDT-BUDGET-NBR Numeric 3 AC123 AC127
Element: Budget Number Required key. This is the budget number AC20.1 AC20.2
uniquely defined in budget setup. AC20.3 AC20.4
AC20.5
BDT-ACCT-CATEGORY Alpha 5 AC123 AC127
Element: Account CategoRequired key. This is the account AC20.1 AC20.2
category for the budget information. AC20.3 AC20.4
AC20.5
BDT-FISCAL-YEAR Numeric 4 AC123 AC127
Element: Fiscal Year Required key. This is the budget year. AC20.1 AC20.2
AC20.3 AC20.4
AC20.5
BDT-PARENT-ACTV Alpha 15 AC123 AC127
Element: Parent Actv AC20.1 AC20.2
AC20.3 AC20.4
AC20.5
BDT-COMPUTE-NAME Alpha 12 AC121 AC123
Element: Compute Name This is the name for a compute AC127 AC20.1
statement. You can use a compute AC20.2 AC20.3
statement to calculate the budget. Use AC20.4 AC20.5
the Compute action code and define a
compute statement, consisting of data
dictionary items and operation symbols.
You can define compute statements in
RW50.1 (Compute Statements).
BDT-PARAM-NAME Alpha 12 AC121 AC123
Element: Param Name AC127 AC20.1
AC20.2 AC20.3
AC20.4 AC20.5
BDT-MAINT-DATE Numeric 8 (yyyymmdd) AC121 AC123
Element: Maintenance DaThis is the date the budget was AC127 AC20.1
changed. AC20.2 AC20.3
AC20.4 AC20.5
AC22.1
BDT-MAINT-TIME Numeric 6 (hhmmss) AC121 AC123
Element: Maintenance TiThis is the time the budget was AC127 AC20.1
changed. AC20.2 AC20.3
AC20.4 AC20.5
AC22.1
BDT-SPREAD-CODE Alpha 3 AC121 AC123
Element: Spread Code A spread code is a formula for AC127 AC20.1
budgeting spending activity that can be AC20.2 AC20.3
set up in AC23.1 (Spread Codes). You can AC20.4 AC20.5
use a spread code to schedule spending AC300
over the life of the activity or
activity group. Spread codes can be used
to represent characteristic spending
patterns.
BDT-BALANCE Signed 17.2 AC121 AC123
Element: Budget BalanceThis is the annual balance of the AC127 AC20.1
budget for the indicated year. AC20.2 AC20.3
AC20.4 AC20.5
AC22.1 AC300
BDT-BALANCE-UNIT Signed 17.2 AC121 AC123
Element: Balance Unit This is the units balance for the AC127 AC20.1
budget for the indicated year. AC20.2 AC20.3
AC20.4 AC20.5
AC22.1 AC300
BDT-BEGIN-BAL Signed 15.2 AC121 AC123
Element: Beginning BalaThis is the beginning balance for the AC127 AC20.1
budget for the indicated year. AC20.2 AC20.3
AC20.4 AC20.5
AC22.1 AC300
BDT-BEGIN-BAL-UNIT Signed 15.2 AC121 AC123
Element: Current BalancThis is the units balance for the AC127 AC20.1
budget for the indicated year. AC20.2 AC20.3
AC20.4 AC20.5
AC22.1 AC300
BDT-FACTOR Alpha 15 AC121 AC123
Element: Factor The element that affects the budget AC127 AC20.1
change. AC20.2 AC20.3
AC20.4 AC20.5
AC22.1 AC300
BDT-FACTOR-RATE Signed 12.6 AC121 AC123
Element: Account Rate AC127 AC20.1
AC20.2 AC20.3
AC20.4 AC20.5
AC22.1 AC300
BDT-BLANK Derived
Element: Blank This derived field is always blank. It
is used in the Drill Around feature for
column headings.
BDT-AMT-VARIANCE Derived
Element: Amt Variance This is the amount of the budget
variance.
BDT-UNIT-VARIANCE Derived
Element: Unit Variance This is the number of units for the
budget variance.
BDT-VARIANCE Derived
Element: Variance This is the percentage of variance from
the budget amount.
BDT-VARIANCE-UNITS Derived
Element: Variance UnitsThis is the percentage of variance from
the units budget.
BDT-OVER-UNDER Derived
Element: Over Under This field indicates whether there is a
variance, either over or under, the
budgeted amount. If there is no
variance, the field is blank.
BDT-OVER-UNDER-UNT Derived
Element: Over Under UntThis field indicates whether there is a
variance, either over or under, the
budgeted number of units. If there is no
variance, the field is blank.
BDT-ACCT-CAT-TYPE Derived
Element: Acct Cat Type This is the account category type:
cost, revenue, or accrual.
ACBUDDTL FILE INDEX
NAME KEY FIELDS DESCRIPTION / SUBSET CONDITION USED IN
BDTSET1 ACTIVITY-GRP AC00.1 AC120
ACTIVITY AC121 AC123
BUDGET-NBR AC127 AC20.1
ACCT-CATEGORY AC20.2 AC20.3
FISCAL-YEAR AC20.4 AC20.5
AC20.6 AC20.7
AC21.1 AC21.2
AC21.3 AC21.4
AC22.1 AC220
AC295 AC297
AC300 AC310
AC410 AC420
AC65.2 ACDL.1
ACDR.1
BDTSET2 ACTIVITY-GRP AC121 AC123
ACTIVITY AC130 AC20.1
BUDGET-NBR AC20.2 AC20.3
FISCAL-YEAR AC20.4 AC20.5
ACCT-CATEGORY AC21.4 AC220
AC32.1 AC37.1
AC40.1 AC40.4
AC41.1 AC41.4
AC42.1 AC490
ACAC.1 AP125
AP126 AP25.1
AP25.2 AP26.1
AP27.1 AP520
BR41.1 BR41.4
BR43.1 CB10.1
...
BDTSET3 ACTIVITY-GRP AC20.5
BUDGET-NBR
ACCT-CATEGORY
FISCAL-YEAR
ACTIVITY
BDTSET4 SPREAD-CODE KeyChange AC23.1
ACTIVITY-GRP
ACTIVITY
BUDGET-NBR
ACCT-CATEGORY
FISCAL-YEAR
BDTSET5 ACCT-CATEGORY AC06.1
ACTIVITY
ACTIVITY-GRP
BUDGET-NBR
FISCAL-YEAR
BDTSET6 ACTIVITY-GRP AC121 AC123
ACTIVITY AC127 AC130
BUDGET-NBR AC165 AC20.1
ACCT-CATEGORY AC20.2 AC20.3
FISCAL-YEAR* AC20.4 AC20.5
AC21.1 AC32.1
AC37.1 AC40.1
AC40.4 AC41.1
AC41.4 AC42.1
AC490 AC65.1
AC65.2 ACAC.1
ACTA.1 AP125
AP126 AP25.1
AP25.2 AP26.1
AP27.1 AP520
...
BDTSET7 ACTIVITY-GRP KeyChange
PARENT-ACTV
BUDGET-NBR
ACCT-CATEGORY
FISCAL-YEAR
ACTIVITY
ACBUDDTL FILE RELATIONS
ONE TO ONE RELATIONS
RELATION RELATED
NAME FILE INTEGRITY RULES / FIELD MATCH
Acacctcat ACACCTCAT Not Required
BDT-ACCT-CATEGORY -> AAX-ACCT-CATEGORY (AAXSET1)
Acactgrp ACACTGRP Required
BDT-ACTIVITY-GRP -> AGP-ACTIVITY-GRP
Acactivity ACACTIVITY Required
BDT-ACTIVITY-GRP -> ACV-ACTIVITY-GRP
BDT-ACTIVITY -> ACV-ACTIVITY
Acbudhdr ACBUDHDR Required
BDT-ACTIVITY-GRP -> BDH-ACTIVITY-GRP
BDT-ACTIVITY -> BDH-ACTIVITY
BDT-BUDGET-NBR -> BDH-BUDGET-NBR
Accuamt ACCUAMT Not Required
BDT-ACTIVITY-GRP -> ACU-ACTIVITY-GRP
BDT-ACTIVITY -> ACU-ACTIVITY
BDH-CURRENCY-CODE -> ACU-CURRENCY-CODE
BDT-BUDGET-NBR -> ACU-BUDGET-NBR
BDT-FISCAL-YEAR -> ACU-FISCAL-YEAR
BDT-ACCT-CATEGORY -> ACU-ACCT-CATEGORY
Acmaster ACMASTER Not Required
BDT-ACTIVITY-GRP -> MST-ACTIVITY-GRP
BDT-ACTIVITY -> MST-ACTIVITY
BDT-ACCT-CATEGORY -> MST-ACCT-CATEGORY
BDT-FISCAL-YEAR -> MST-FISCAL-YEAR
Acspread ACSPREAD Not Required
BDT-SPREAD-CODE -> SPR-SPREAD-CODE
ACBUDDTL FILE RELATIONS
ONE TO MANY RELATIONS
RELATION RELATED
NAME FILE INTEGRITY RULES / FIELD MATCH
Acbuddtlx ACBUDDTLX
BDT-ACTIVITY-GRP -> BDX-ACTIVITY-GRP
BDT-ACTIVITY -> BDX-ACTIVITY
BDT-BUDGET-NBR -> BDX-BUDGET-NBR
BDT-ACCT-CATEGORY -> BDX-ACCT-CATEGORY
BDT-FISCAL-YEAR -> BDX-FISCAL-YEAR
BDX-PERIOD
|