ACBUDHDR FILE
Activity Budget Header
This file contains activity budget header information from the AC20 (Activity
Budget) forms. It includes activity group, activity, budget number, type,
total, and description; lock, calculation, and maintenance information; and
setup definitions, such as begin and end dates, variable levels, currency
code, rate value, units flag, rounding type, and number of decimal positions
in the budget currency.
REFERENCED BY
AC00.1 AC10.1 AC165 AC190 AC210 AC220
AC225 AC25.1 AC27.1 AC30.1 AC401 AC410
AC415 AC420 AC421 AC65.1 AC65.2 AC702
AC90.1 AC90.2 AC95.1 AC95.2 AC97.1 AC97.2
ACAC.1 ACDL.1 AC200
UPDATED BY
AC120 AC121 AC123 AC127 AC20.1 AC20.2
AC20.3 AC20.4 AC20.5 AC20.6 AC20.7 AC21.1
AC21.2 AC21.3 AC22.1 AC300 AC310 AC580
AC701 AC730 AC980
FIELD NAME DESCRIPTION/VALID VALUES UPDATED BY
BDH-ACTIVITY-GRP Alpha 15 AC120 AC123
Activity Group Required key. This is the activity AC127 AC20.5
group for the budget header information. AC20.6 AC730
BDH-ACTIVITY Alpha 15 AC123 AC127
Activity Required key. This is the activity for AC20.5 AC20.6
the budget header information. AC730
BDH-BUDGET-NBR Numeric 3 AC123 AC127
Budget Number Required key. This is the budget number AC20.5 AC20.6
uniquely defined in budget setup. AC730
BDH-BEGIN-DATE Numeric 8 (yyyymmdd) AC123 AC127
Begin Date The beginning date of a date range for AC20.5 AC20.6
the budget. AC730
BDH-END-DATE Numeric 8 (yyyymmdd) AC123 AC127
End Date The end date of a date range for the AC20.5 AC20.6
budget. AC730
BDH-TOTAL-BUDGET Signed 15.2 AC121 AC123
Total Budget This is the total budget amount. AC127 AC20.1
AC20.2 AC20.3
AC20.4 AC20.6
AC22.1 AC300
AC701 AC730
BDH-TOT-UNITS-BUD Signed 15.2 AC121 AC123
Tot Units Bud This is the total number of units for AC127 AC20.1
the budget. AC20.2 AC20.3
AC20.4 AC22.1
AC300 AC701
AC730
BDH-CURRENCY-CODE Alpha 5 AC123 AC127
Currency Code This is the currency code for the AC20.5 AC20.6
budget. AC730
BDH-RATE-VALUE Signed 12.6 AC120 AC123
Rate Value This is the budget exchange rate. AC127 AC20.6
AC580 AC730
AC980
BDH-MULT-DIV Alpha 1 AC120 AC123
Multiply/Divide This field indicates whether you want AC127 AC20.6
Option to multiply or divide in calculating a AC580 AC980
base currency amount. You can perform
the calculation either by multiplying or
dividing a budget currency amount by the
exchange rate to calculate the base
currency amount. The default is
Multiply.
M = Multiply
D = Divide
BDH-MAINT-DATE Numeric 8 (yyyymmdd) AC120 AC121
Maintenance Date This is the date the budget was last AC123 AC127
changed. AC20.1 AC20.2
AC20.3 AC20.4
AC20.5 AC20.6
AC22.1 AC580
AC701 AC730
AC980
BDH-MAINT-TIME Numeric 6 (hhmmss) AC120 AC121
Maintenance Time This is the time the budget was last AC123 AC127
changed. AC20.1 AC20.2
AC20.3 AC20.4
AC20.5 AC20.6
AC22.1 AC580
AC701 AC730
AC980
BDH-CALC-DATE Numeric 8 (yyyymmdd) AC121 AC123
Calculation Date This is the date budget amounts were AC127 AC20.1
last calculated. AC20.2 AC20.3
AC20.4 AC22.1
AC701 AC730
BDH-CALC-TIME Numeric 6 (hhmmss) AC121 AC123
Calculation Time This is the time budget amounts were AC127 AC20.1
last calculated. AC20.2 AC20.3
AC20.4 AC22.1
AC701 AC730
BDH-DESCRIPTION Alpha 30 (Lower Case) AC00.1 AC123
Budget Description This is the budget description. AC127 AC20.5
AC20.6 AC730
BDH-UNITS-FL Alpha 1
Units Fl This flag indicates whether the budget
is in units. The default is No (Amount).
BDH-ROUND-TYPE Alpha 1 AC123 AC127
Rounding Type This field indicates the type of AC20.5 AC20.6
rounding for the budget amount. The AC730
default is 2 (2 decimals, or no
rounding).
1 = 1 Decimal
2 = 2 Decimals
W = Whole
H = Hundreds
T = Thousands
BDH-UNT-ROUND-TYPE Alpha 1 AC123 AC127
Unt Round Type This field indicates the type of AC20.5 AC20.6
rounding for the units budget. The AC730
default is 2 (2 decimals, or no
rounding).
1 = One Decimal
2 = 2 Decimals
T = Thousands
H = Hundreds
W = Whole
BDH-LOCK Alpha 1 AC123 AC127
Lock Button This flag indicates whether the budget AC20.5 AC20.6
is locked. AC20.7 AC300
N = No AC730
Y = Yes
BDH-NUM-DECIMALS Numeric 1 AC121 AC123
Number of Decimals This is the number of decimal positions AC127 AC20.5
to calculate for the budget amount. AC20.6 AC730
BDH-UNT-NUM-DEC Numeric 1 AC123 AC127
Unt Num Dec This is the number of decimal positions AC20.5 AC20.6
to calculate for the units budget. AC730
BDH-FACTOR Alpha 15 AC730
Factor The element that affects the budget
change.
BDH-FACTOR-RATE Signed 12.6 AC730
Rate You can type or select the rate that
affects the factor. For example, you
could type the inflation rate.
If you select units and amounts, the
rate is calculated.
BDH-LIFE-ONLY Alpha 1 AC123 AC127
Life Only This field indicates whether the budget AC20.5 AC20.6
is life-only. AC730
Y = Yes
N = No
BDH-RELEASED Alpha 1 AC120 AC123
Released This field indicates whether a change AC127 AC21.1
order associated with the budget has AC21.2 AC21.3
been released. Use Yes for Released and AC22.1 AC300
No for Not Released. AC580 AC701
Y = Released AC730
N = Not Released
BDH-CURR-TOT-BUD-M Derived
Curr Tot Bud M This is the base currency budget amount
if you multiply to calculate base
currency.
BDH-CURR-TOT-BUD-D Derived
Curr Tot Bud D This is the base currency budget amount
if you divide to calculate base
currency.
BDH-CURR-TOT-BUDGT Derived
Curr Tot Budgt This is the base currency budget
amount.
BDH-ACT-ACTIVE-BUD Derived
Act Active Bud This is the active activity budget.
BDH-GRP-ACTIVE-BUD Derived
Grp Active Bud This is the active activity group
budget.
ACBUDHDR FILE INDEX
NAME KEY FIELDS DESCRIPTION / SUBSET CONDITION USED IN
BDHSET1 ACTIVITY-GRP AC00.1 AC10.1
ACTIVITY AC120 AC121
BUDGET-NBR AC123 AC127
AC165 AC190
AC20.1 AC20.2
AC20.3 AC20.4
AC20.5 AC20.6
AC20.7 AC21.1
AC21.2 AC21.3
AC210 AC22.1
AC220 AC225
AC25.1 AC27.1
AC30.1 AC300
AC310 AC401
AC410 AC415
...
BDHSET3 ACTIVITY-GRP AC00.1 AC20.1
BUDGET-NBR AC20.2 AC20.3
ACTIVITY AC200 AC90.1
ACBUDHDR FILE RELATIONS
ONE TO ONE RELATIONS
RELATION RELATED
NAME FILE INTEGRITY RULES / FIELD MATCH
Acactgrp ACACTGRP Required
BDH-ACTIVITY-GRP -> AGP-ACTIVITY-GRP
Acactivity ACACTIVITY Required
BDH-ACTIVITY -> ACV-ACTIVITY
ACBUDHDR FILE RELATIONS
ONE TO MANY RELATIONS
RELATION RELATED
NAME FILE INTEGRITY RULES / FIELD MATCH
Acbuddtl ACBUDDTL
Valid When BDH-ACTIVITY != Spaces
BDH-ACTIVITY-GRP -> BDT-ACTIVITY-GRP
BDH-ACTIVITY -> BDT-ACTIVITY
BDH-BUDGET-NBR -> BDT-BUDGET-NBR
BDT-ACCT-CATEGORY
BDT-FISCAL-YEAR
Acbuddtl Grp ACBUDDTL
Valid When BDH-ACTIVITY = Spaces
BDH-ACTIVITY-GRP -> BDT-ACTIVITY-GRP
BDH-ACTIVITY -> BDT-ACTIVITY
BDH-BUDGET-NBR -> BDT-BUDGET-NBR
Spaces -> BDT-ACCT-CATEGORY
BDT-FISCAL-YEAR
Acchgorder ACCHGORDER
BDH-ACTIVITY-GRP -> CHO-ACTIVITY-GRP
BDH-ACTIVITY -> CHO-ACTIVITY
BDH-BUDGET-NBR -> CHO-BUDGET-NBR
CHO-CHG-ORDER-NBR
Accomments ACCOMMENTS
BDH-ACTIVITY-GRP -> CMN-ACTIVITY-GRP
BDH-ACTIVITY -> CMN-ACTIVITY
"B" -> CMN-COMMENT-TYP
CMN-SEQ-NBR
Accuamt ACCUAMT
BDH-ACTIVITY-GRP -> ACU-ACTIVITY-GRP
BDH-ACTIVITY -> ACU-ACTIVITY
BDH-BUDGET-NBR -> ACU-BUDGET-NBR
BDH-CURRENCY-CODE -> ACU-CURRENCY-CODE
ACU-ACCT-CATEGORY
ACU-FISCAL-YEAR
Accuamt Grp ACCUAMT
BDH-ACTIVITY-GRP -> ACU-ACTIVITY-GRP
Spaces -> ACU-ACTIVITY
BDH-BUDGET-NBR -> ACU-BUDGET-NBR
BDH-CURRENCY-CODE -> ACU-CURRENCY-CODE
ACU-ACCT-CATEGORY
ACU-FISCAL-YEAR
|