|
|
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 AC210 AC220 AC225
AC25.1 AC27.1 AC30.1 AC40.1 AC40.4 AC401
AC41.1 AC41.4 AC42.1 AC420 AC421 AC45.4
AC46.1 AC527 AC65.1 AC65.2 AC81.1 ACAC.1
ACDL.1 ACTA.1 ACVW.1 SE10.1 SE90.1 AP125
AP126 AP170 AP193 AP25.1 AP25.2 AP26.1
AP27.1 AP30.2 AP520 BR165 BR41.1 BR41.4
BR43.1 BR65.1 BR65.3 CB10.1 CB15.1 CB15.2
CB150 CB191 CB20.1 CB30.1 CB45.1 CB46.1
CB500 CB543 CB544 CB55.1 CB554 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 GL70.1 GL70.2 GL70.3
GL70.5 GL70.6 GL75.1 MA65.1 POIG.1 SB15.1
AC200 BR430
UPDATED BY
AC120 AC121 AC123 AC127 AC128 AC20.1
AC20.2 AC20.3 AC20.4 AC20.5 AC20.6 AC20.7
AC20.8 AC21.1 AC21.2 AC21.3 AC21.4 AC22.1
AC300 AC310 AC581 ACDR.1 SB515
FIELD NAME DESCRIPTION/VALID VALUES UPDATED BY
BDH-ACTIVITY-GRP Alpha 15 AC120 AC123
Element: Activity GroupRequired key. This is the activity AC127 AC20.6
group for the budget header information. AC20.7 SB515
BDH-ACTIVITY Alpha 15 AC123 AC127
Element: Activity Required key. This is the activity for AC20.6 AC20.7
the budget header information. SB515
BDH-BUDGET-NBR Numeric 3 AC123 AC127
Element: Budget Number Required key. This is the budget number AC20.6 AC20.7
uniquely defined in budget setup. SB515
BDH-BEGIN-DATE Numeric 8 (yyyymmdd) AC123 AC127
Element: Begin Date The beginning date of a date range for AC20.6 AC20.7
the budget. SB515
BDH-END-DATE Numeric 8 (yyyymmdd) AC123 AC127
Element: End Date The end date of a date range for the AC20.6 AC20.7
budget. SB515
BDH-TOTAL-BUDGET Signed 18.2 AC123 AC20.1
Element: Total Budget This is the total budget amount. AC20.2 AC20.3
AC20.4 AC20.5
AC20.6 AC20.7
BDH-TOT-UNITS-BUD Signed 15.2 AC20.1 AC20.2
Element: Tot Units Bud This is the total number of units for AC20.3 AC20.4
the budget. AC20.5 AC20.6
AC20.7
BDH-CURRENCY-CODE Alpha 5 AC123 AC127
Element: Currency Code This is the currency code for the AC20.6 AC20.7
budget. SB515
BDH-RATE-VALUE Signed 14.7 AC123 AC127
Element: Rate Value This is the budget exchange rate. AC20.7 SB515
BDH-MAINT-DATE Numeric 8 (yyyymmdd) AC123 AC127
Element: Maintenance DaThis is the date the budget was last AC20.6 AC20.7
changed. SB515
BDH-MAINT-TIME Numeric 6 (hhmmss) AC123 AC127
Element: Maintenance TiThis is the time the budget was last AC20.6 AC20.7
changed. SB515
BDH-CALC-DATE Numeric 8 (yyyymmdd) AC121 AC123
Element: Calculation DaThis is the date budget amounts were AC127 AC20.1
last calculated. AC20.2 AC20.3
AC20.4 AC20.5
AC20.6 AC20.7
AC22.1 ACDR.1
SB515
BDH-CALC-TIME Numeric 6 (hhmmss) AC121 AC123
Element: Calculation TiThis is the time budget amounts were AC127 AC20.1
last calculated. AC20.2 AC20.3
AC20.4 AC20.5
AC20.6 AC20.7
AC22.1 ACDR.1
SB515
BDH-DESCRIPTION Alpha 30 (Lower Case) AC00.1 AC123
Element: Budget DescripThis is the budget description. AC127 AC20.6
AC20.7 SB515
BDH-ROUND-TYPE Alpha 1 AC123 AC127
Element: Rounding Type This field indicates the type of AC20.6 AC20.7
rounding for the budget amount. The SB515
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
Element: Unt Round TypeThis field indicates the type of AC20.6 AC20.7
rounding for the units budget. The SB515
default is 2 (2 decimals, or no
rounding).
1 = 1 Decimal
2 = 2 Decimals
T = Thousands
H = Hundreds
W = Whole
BDH-LOCK Alpha 1 AC123 AC127
Element: Lock This flag indicates whether the budget AC128 AC20.6
is locked. AC20.7 AC20.8
N = No SB515
Y = Yes
BDH-NUM-DECIMALS Numeric 1 AC123 AC127
Element: Number of DeciThis is the number of decimal positions AC20.6 AC20.7
to calculate for the budget amount. SB515
BDH-UNT-NUM-DEC Numeric 1 AC123 AC127
Element: Unt Num Dec This is the number of decimal positions AC20.6 AC20.7
to calculate for the units budget. SB515
BDH-FACTOR Alpha 15
Element: Factor The element that affects the budget
change.
BDH-FACTOR-RATE Signed 14.7
Element: Factor 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
Element: Life Only This field indicates whether the budget AC20.6 AC20.7
is life-only. SB515
Y = Yes
N = No
BDH-RELEASED Alpha 1 AC123 AC127
Element: Released This field indicates whether a change AC21.1 AC21.2
order associated with the budget has AC21.3 AC21.4
been released. Use Yes for Released and AC22.1 SB515
No for Not Released.
Y = Released
N = Not Released
BDH-RPT-RATE-1 Signed 14.7 AC123 AC127
Element: Rpt Rate 1 The exchange rate to convert the AC20.6 AC20.7
transaction amount to Report Currency 1. AC581 SB515
The exchange rate is defined in CU10.1
(Exchange Rate).
BDH-RPT-RATE-2 Signed 14.7 AC123 AC127
Element: Rpt Rate 1 The exchange rate to convert the AC20.6 AC20.7
transaction amount to Report Currency 1. AC581 SB515
The exchange rate is defined in CU10.1
(Exchange Rate).
BDH-ACT-ACTIVE-BUD Derived
Element: Act Active BudThis is the active activity budget.
BDH-GRP-ACTIVE-BUD Derived
Element: Grp Active BudThis 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
AC128 AC165
AC20.1 AC20.2
AC20.3 AC20.4
AC20.5 AC20.6
AC20.7 AC20.8
AC21.1 AC21.2
AC21.3 AC21.4
AC210 AC22.1
AC220 AC225
AC25.1 AC27.1
AC30.1 AC300
AC310 AC40.1
...
BDHSET3 ACTIVITY-GRP AC00.1 AC20.4
BUDGET-NBR AC200 BR430
ACTIVITY
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
Accuamt ACCUAMT
BDH-ACTIVITY-GRP -> ACU-ACTIVITY-GRP
BDH-ACTIVITY -> ACU-ACTIVITY
BDH-CURRENCY-CODE -> ACU-CURRENCY-CODE
BDH-BUDGET-NBR -> ACU-BUDGET-NBR
ACU-ACCT-CATEGORY
ACU-FISCAL-YEAR
Accuamt Grp ACCUAMT
BDH-ACTIVITY-GRP -> ACU-ACTIVITY-GRP
Spaces -> ACU-ACTIVITY
BDH-CURRENCY-CODE -> ACU-CURRENCY-CODE
BDH-BUDGET-NBR -> ACU-BUDGET-NBR
ACU-ACCT-CATEGORY
ACU-FISCAL-YEAR
Accuamt Rpt1 ACCUAMT
BDH-ACTIVITY-GRP -> ACU-ACTIVITY-GRP
BDH-ACTIVITY -> ACU-ACTIVITY
AGP-CURR-CODE-1 -> ACU-CURRENCY-CODE
BDH-BUDGET-NBR -> ACU-BUDGET-NBR
ACU-ACCT-CATEGORY
ACU-FISCAL-YEAR
Accuamt Rpt2 ACCUAMT
BDH-ACTIVITY-GRP -> ACU-ACTIVITY-GRP
BDH-ACTIVITY -> ACU-ACTIVITY
AGP-CURR-CODE-2 -> ACU-CURRENCY-CODE
BDH-BUDGET-NBR -> ACU-BUDGET-NBR
ACU-ACCT-CATEGORY
ACU-FISCAL-YEAR
Acu Grp Rpt1 ACCUAMT
BDH-ACTIVITY-GRP -> ACU-ACTIVITY-GRP
Spaces -> ACU-ACTIVITY
AGP-CURR-CODE-1 -> ACU-CURRENCY-CODE
BDH-BUDGET-NBR -> ACU-BUDGET-NBR
ACU-ACCT-CATEGORY
ACU-FISCAL-YEAR
Acu Grp Rpt2 ACCUAMT
BDH-ACTIVITY-GRP -> ACU-ACTIVITY-GRP
Spaces -> ACU-ACTIVITY
AGP-CURR-CODE-2 -> ACU-CURRENCY-CODE
BDH-BUDGET-NBR -> ACU-BUDGET-NBR
ACU-ACCT-CATEGORY
ACU-FISCAL-YEAR
|
