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 AC08.3 AC08.7 AC10.1 AC21.1 AC21.2
AC21.3 AC21.4 AC220 AC295 AC410 AC420
AC65.2 AC65.1 ACDL.1 ACTA.1 AC130 AC32.1
AC37.1 AC490 AC23.1 AC165 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.6 AC20.7 AC22.1
AC300 AC310 ACDR.1
FIELD NAME DESCRIPTION/VALID VALUES UPDATED BY
BDT-ACTIVITY-GRP Alpha 15 AC120 AC121
Element: Activity GroupRequired key. This is the activity AC123 AC127
group for the budget information. AC20.1 AC20.2
AC20.3 AC20.4
AC20.5 AC20.6
AC20.7 AC22.1
ACDR.1
BDT-ACTIVITY Alpha 15 AC121 AC123
Element: Activity Required key. This is the activity for AC127 AC20.1
the budget information. AC20.2 AC20.3
AC20.4 AC20.5
AC20.6 AC20.7
AC22.1 ACDR.1
BDT-BUDGET-NBR Numeric 3 AC121 AC123
Element: Budget Number Required key. This is the budget number AC127 AC20.1
uniquely defined in budget setup. AC20.2 AC20.3
AC20.4 AC20.5
AC20.6 AC20.7
AC22.1 ACDR.1
BDT-ACCT-CATEGORY Alpha 5 AC121 AC123
Element: Account CategoRequired key. This is the account AC127 AC20.1
category for the budget information. AC20.2 AC20.3
AC20.4 AC20.5
AC20.6 AC20.7
AC22.1 ACDR.1
BDT-FISCAL-YEAR Numeric 4 AC121 AC123
Element: Fiscal Year Required key. This is the budget year. AC127 AC20.1
AC20.2 AC20.3
AC20.4 AC20.5
AC20.6 AC20.7
AC22.1 ACDR.1
BDT-PARENT-ACTV Alpha 15 AC121 AC123
Element: Parent Actv The parent activity field contains the AC127 AC20.1
activity name of the member parent. AC20.2 AC20.3
AC20.4 AC20.5
AC20.6 AC20.7
AC22.1 ACDR.1
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 AC20.6 AC20.7
compute statement, consisting of data AC22.1 ACDR.1
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
AC20.6 AC20.7
AC22.1 ACDR.1
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
AC20.6 AC20.7
AC22.1 ACDR.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
AC20.6 AC20.7
AC22.1 ACDR.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 AC20.6 AC20.7
over the life of the activity or AC22.1 ACDR.1
activity group. Spread codes can be used
to represent characteristic spending
patterns.
BDT-BALANCE Signed 18.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
AC20.6 AC20.7
AC22.1 ACDR.1
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
AC20.6 AC20.7
AC22.1 ACDR.1
BDT-BEGIN-BAL Signed 18.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
AC20.6 AC20.7
AC22.1 ACDR.1
BDT-BEGIN-BAL-UNIT Signed 15.2 AC121 AC123
Beginning Unit This is the units balance for the AC127 AC20.1
Balance budget for the indicated year. AC20.2 AC20.3
AC20.4 AC20.5
AC20.6 AC20.7
AC22.1 ACDR.1
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
AC20.6 AC20.7
AC22.1 ACDR.1
BDT-FACTOR-RATE Signed 14.7 AC121 AC123
Element: Currency Rate You can type or select the rate that AC127 AC20.1
affects the factor. For example, you AC20.2 AC20.3
could type the inflation rate. AC20.4 AC20.5
AC20.6 AC20.7
If you select units and amounts, the AC22.1 ACDR.1
rate is calculated.
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.
BDT-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 ACDR.1
BDT-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 ACDR.1
BDT-PERIOD-FACTOR Alpha 15 Occurs 13 Times AC121 AC123
Element: Factor AC127 AC20.1
AC20.2 AC20.3
AC20.4 AC20.5
AC20.6 AC20.7
AC22.1 ACDR.1
BDT-PERIOD-RATE Signed 14.7 Occurs 13 Times AC121 AC123
Element: Rate AC127 AC20.1
AC20.2 AC20.3
AC20.4 AC20.5
AC20.6 AC20.7
AC22.1 ACDR.1
ACBUDDTL FILE INDEX
NAME KEY FIELDS DESCRIPTION / SUBSET CONDITION USED IN
BDTSET1 ACTIVITY-GRP AC00.1 AC08.3
ACTIVITY AC08.7 AC10.1
BUDGET-NBR AC120 AC121
ACCT-CATEGORY AC123 AC127
FISCAL-YEAR AC20.1 AC20.2
AC20.3 AC20.4
AC20.5 AC20.6
AC20.7 AC21.1
AC21.2 AC21.3
AC21.4 AC22.1
AC220 AC295
AC300 AC310
AC410 AC420
AC65.2 ACDL.1
ACDR.1 ACTA.1
BDTSET2 ACTIVITY-GRP AC121 AC123
ACTIVITY AC130 AC20.1
BUDGET-NBR AC20.2 AC20.3
FISCAL-YEAR AC20.4 AC20.5
ACCT-CATEGORY AC20.6 AC20.7
AC21.4 AC220
AC32.1 AC37.1
AC490
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
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
AC20.6 AC20.7
AC21.1 AC22.1
AC32.1 AC37.1
AC490 AC65.1
AC65.2 ACDR.1
ACTA.1 BR130
BR530 BR65.1
BR65.2 BRCC.1
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
|