 |
Lawson Insight Technical Documentation |
|
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
AC720 ACDL.1 ACDR.1 AC130 AC30.2 AC30.3
AC32.1 AC490 ACAC.1 AC23.1 AC165 ACTA.1
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
Activity Group Required 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
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
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
Account Category Required 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
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
Parent Actv AC20.1 AC20.2
AC20.3 AC20.4
AC20.5
BDT-COMPUTE-NAME Alpha 12 AC121 AC123
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
Param Name AC127 AC20.1
AC20.2 AC20.3
AC20.4 AC20.5
BDT-MAINT-DATE Numeric 8 (yyyymmdd) AC121 AC123
Maintenance Date This 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
Maintenance Time This 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
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
Budget Balance This 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
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
Beginning Balance This 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
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
AC22.1 AC300
BDT-FACTOR Alpha 15 AC121 AC123
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
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
AC22.1 AC300
If you select units and amounts, the
rate is calculated.
BDT-BLANK Derived
Blank This derived field is always blank. It
is used in the Drill Around feature for
column headings.
BDT-AMT-VARIANCE Derived
Amt Variance This is the amount of the budget
variance.
BDT-UNIT-VARIANCE Derived
Unit Variance This is the number of units for the
budget variance.
BDT-VARIANCE Derived
Variance This is the percentage of variance from
the budget amount.
BDT-VARIANCE-UNITS Derived
Variance Units This is the percentage of variance from
the units budget.
BDT-OVER-UNDER Derived
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
Over Under Unt This 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
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 AC720
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
AC30.2 AC30.3
AC32.1 AC490
ACAC.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
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 AC30.2
AC30.3 AC32.1
AC490 AC65.1
AC65.2 ACAC.1
ACTA.1 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
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
|