|
|
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 AC220 AC295
AC297 AC420 AC65.2 AC65.1 AC95.1 AC95.2
AC97.1 AC97.2 ACDL.1 AC130 AC30.2 AC30.3
AC32.1 ACAC.1 AC23.1 AC165 AC170 AC410
AC90.1 AC90.2
UPDATED BY
AC120 AC121 AC123 AC127 AC20.1 AC20.2
AC20.3 AC20.4 AC20.5 AC20.6 AC22.1 AC300
AC310 AC580 AC701 AC730 AC980
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 AC730
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
AC730
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
AC730
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
AC730
BDT-FISCAL-YEAR Numeric 4 AC123 AC127
Fiscal Year Required key. This is the budget year. AC20.1 AC20.2
AC20.3 AC20.4
AC730
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 AC730
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-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 AC22.1
AC701 AC730
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 AC22.1
AC701 AC730
BDT-SPREAD-CODE Alpha 3 AC123 AC127
Spread Code A spread code is a formula for AC20.1 AC20.2
budgeting spending activity that can be AC20.3 AC20.4
set up in AC23.1 (Spread Codes). You can AC730
use a spread code to schedule spending
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 AC22.1
AC730
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 AC22.1
AC730
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 AC22.1
AC701 AC730
BDT-BEGIN-BAL-UNIT Signed 15.2 AC121 AC123
Unit Beginning This is the units balance for the AC127 AC20.1
Balance budget for the indicated year. AC20.2 AC20.3
AC20.4 AC22.1
AC701 AC730
BDT-FACTOR Alpha 15 AC121 AC123
Factor The element that affects the budget AC127 AC20.1
change. AC20.2 AC20.3
AC20.4 AC22.1
AC701 AC730
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 AC22.1
AC701 AC730
If you select units and amounts, the
rate is calculated.
BDT-CMP-ACTIVITY Alpha 15
Compute Activity This is the activity for the compute
statement.
BDT-CMP-AC-MATRIX Alpha 12
Compute Activity This is the activity list for the
List compute statement
BDT-CMP-FR-CAT Alpha 5
Compute From Acct This is the from-account category for
Category the compute statement account category
range.
BDT-CMP-TH-CAT Alpha 5
Compute Through This is the through-account category
Acct Category for the compute statement account
category range.
BDT-CMP-CAT-GROUP Alpha 15
Compute Category This is the account category group for
Group the compute statement.
BDT-CMP-AC-TYPE Alpha 1
Compute Activity This is the activity type for the
Type compute statement.
BDT-CMP-AC-BUDGET Numeric 3
Compute Activity This is the activity budget for the
Budget compute statement.
BDT-CMP-COMPANY Numeric 4
Compute Company This is the company for the compute
statement.
BDT-CMP-ACCT-UNIT Alpha 15
Compute Accounting This is the accounting unit for the
Unit compute statement.
BDT-CMP-AU-MATRIX Alpha 12
Compute Accounting This is the accounting unit list for
Unit List the compute statement.
BDT-CMP-FR-ACCT Numeric 6
Compute From Account This is the from-account for the
compute statement account range.
BDT-CMP-TH-ACCT Numeric 6
Compute Through This is the through-account for the
Account compute statement account range.
BDT-CMP-ACCT-GRP Alpha 15
Compute Account This is the account group for the
Group compute statement.
BDT-CMP-FR-SUB-ACT Numeric 4
Compute From This is the from-subaccount for the
Subaccount compute statement subaccount range.
BDT-CMP-TH-SUB-ACT Numeric 4
Compute Through This is the through-subaccount for the
Subaccount compute statement subaccount range.
BDT-CMP-SUB-GRP Alpha 12
Compute Subaccount This is the subaccount group for the
Group compute statement.
BDT-CMP-GL-BUDGET Numeric 3
Compute GL Budget This is the general ledger budget for
the compute statement.
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.
BDT-LIFE-BUDGET Derived
Life Budget This is the life-to-date budget.
BDT-LIFE-UNITS Derived
Life Units This is the life-to-date number of
units for the budget.
BDT-LTD-AMOUNT Derived
Ltd Amount This is the sum of the Amount Balance
and the Amount Beginning Balance fields
for the fiscal year.
BDT-LTD-UNIT Derived
Ltd Unit This is the sum of the Unit Balance and
the Unit Beginning Balance fields for
the fiscal year.
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 AC21.1
AC21.2 AC21.3
AC22.1 AC220
AC295 AC297
AC300 AC310
AC420 AC580
AC65.2 AC701
AC730 AC95.1
AC97.1 AC980
ACDL.1
BDTSET2 ACTIVITY-GRP AC121 AC123
ACTIVITY AC127 AC130
BUDGET-NBR AC20.1 AC20.2
FISCAL-YEAR AC20.3 AC20.4
ACCT-CATEGORY AC20.5 AC20.6
AC21.3 AC22.1
AC220 AC30.2
AC30.3 AC32.1
ACAC.1
BDTSET3 ACTIVITY-GRP AC20.4
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 AC170
ACCT-CATEGORY AC20.1 AC20.2
FISCAL-YEAR* AC20.3 AC20.4
AC21.1 AC21.2
AC22.1 AC30.2
AC30.3 AC32.1
AC410 AC65.1
AC65.2 AC90.1
AC90.2 AC95.1
AC95.2 AC97.1
AC97.2 ACAC.1
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
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
BDT-BUDGET-NBR -> ACU-BUDGET-NBR
BDT-FISCAL-YEAR -> ACU-FISCAL-YEAR
BDT-ACCT-CATEGORY -> ACU-ACCT-CATEGORY
BDH-CURRENCY-CODE -> ACU-CURRENCY-CODE
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
|