ACBUDHDR

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
AC165 AC200 AC210 AC30.1 AC310 AC40.1
AC40.4 AC401 AC41.1 AC41.4 AC42.1 AC420
AC45.4 AC46.1 AC527 AC97.2 AC97.4 AC97.6
ACAC.1 ACTA.1 SE90.1 AP125 AP126 AP131
AP170 AP193 AP20.1 AP20.2 AP20.3 AP20.4
AP20.5 AP20.7 AP21.1 AP23.1 AP25.1 AP25.2
AP26.1 AP27.1 AP30.2 AP30.4 AP520 API1.1
API2.1 BR165 BR41.1 BR41.4 BR43.1 CB10.1
CB15.1 CB15.2 CB150 CB191 CB20.1 CB30.1
CB45.1 CB46.1 CB500 CB543 CB544 CB55.1
CB554 CX100 CX20.1 CX20.2 CX20.4 CX20.5
CX220 CX30.1 CX300 CX506 CXCP.1 EE11.1
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 GL76.1 DR100
IC140 IC66.1 IC83.1 EX545 IFEB.1 MA180
MA41.1 MA41.2 MA41.4 MA41.7 MA42.2 MA43.2
MA43.7 MA44.1 MA44.2 MA530 MA531 MA60.2
MA60.3 MA60.5 MA61.1 MA65.1 MA66.2 MA67.2
MA67.3 MA68.2 MA68.3 MA68.5 MA70.1 MA75.1
MA80.1 MAI1.1 PD10.1 PD10.2 PD130 PD20.1
PD20.2 PD20.3 PO100 PO101 PO122 PO131
PO136 PO150 PO190 PO20.1 PO20.6 PO20.9
PO21.1 PO21.2 PO21.3 PO21.4 PO21.5 PO22.1
PO22.3 PO22.4 PO23.1 PO24.1 PO25.1 PO25.5
PO25.6 PO25.7 PO26.2 PO26.3 PO26.4 PO26.5
PO26.6 PO26.7 PO26.9 PO27.2 PO28.2 PO29.1
PO30.1 PO30.2 PO30.3 PO30.4 PO300 PO31.1
PO31.2 PO32.2 PO32.4 PO33.1 PO34.1 PO35.1
PO36.1 PO36.2 PO38.1 PO39.1 PO39.2 PO44.1
PO50.1 PO52.1 PO520 PO536 PO54.5 POCP.1
POI3.1 POID.1 POIG.1 POII.1 POIJ.1 POIK.1
RQ10.1 RQ10.2 RQ10.4 RQ12.1 RQ13.1 RQ13.2
RQ35.1 RQ500 RQIF.1 WH130 WH132 WH190
WH20.2 WH20.7 WH222 WH30.1 WH30.2 WH30.3
WH30.4 WH31.1 WH31.2 WH31.3 WH31.4 WH32.1
WH32.2 WH32.3 WH32.4 WH32.5 WH33.1 WH33.2
WH33.3 WH33.4 WH33.5 WH33.6 WH33.8 WH33.9
WH34.1 WH34.2 WH34.3 WH34.4 WH40.1 WH40.2
WH520 WH830 ZW130 AC00.1 AC25.1 AC27.1
AC65.1 AC65.2 AC81.1 AC82.2 AC82.3 ACDL.1
ACVW.1 SE10.1 BR65.1 BR65.3


UPDATED BY
AC10.1 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
AC21.5 AC22.1 AC220 AC225 AC300 AC311
AC421 AC581 ACDR.1 BR430

FIELD NAME DESCRIPTION/VALID VALUES UPDATED BY
BDH-ACTIVITY-GRP
Element: Activity Group		Alpha 15
Required key. This is the activity group for the budget header information.
AC120 AC123
AC127 AC20.6
AC20.7
BDH-ACTIVITY
Element: Activity		Alpha 15
Required key. This is the activity for the budget header information.
AC123 AC127
AC20.6 AC20.7
BDH-BUDGET-NBR
Element: Budget Number		Numeric 3
Required key. This is the budget number uniquely defined in budget setup.
AC123 AC127
AC20.6 AC20.7
BDH-BEGIN-DATE
Element: Begin Date		Numeric 8 (yyyymmdd)
The beginning date of a date range for the budget.
AC123 AC127
AC20.6 AC20.7
BDH-END-DATE
Element: End Date		Numeric 8 (yyyymmdd)
The end date of a date range for the budget.
AC123 AC127
AC20.6 AC20.7
BDH-TOTAL-BUDGET
Element: Total Budget		Signed 18.2
This is the total budget amount.
AC123 AC20.1
AC20.2 AC20.3
AC20.4 AC20.5
AC20.6 AC20.7
AC21.5
BDH-TOT-UNITS-BUD
Element: Tot Units Bud		Signed 15.2
This is the total number of units for the budget.
AC20.1 AC20.2
AC20.3 AC20.4
AC20.5 AC20.6
AC20.7 AC21.5
BDH-CURRENCY-CODE
Element: Currency Code		Alpha 5
This is the currency code for the budget.
AC123 AC127
AC20.6 AC20.7
BDH-RATE-VALUE
Element: Rate Value		Signed 14.7
This is the budget exchange rate.
AC123 AC127
AC20.7
BDH-MAINT-DATE
Element: Maintenance Date		Numeric 8 (yyyymmdd)
This is the date the budget was last changed.
AC123 AC127
AC20.6 AC20.7
BDH-MAINT-TIME
Element: Maintenance Time		Numeric 6 (hhmmss)
This is the time the budget was last changed.
AC123 AC127
AC20.6 AC20.7
BDH-CALC-DATE
Element: Calculation Date		Numeric 8 (yyyymmdd)
This is the date budget amounts were last calculated.
AC121 AC123
AC127 AC20.1
AC20.2 AC20.3
AC20.4 AC20.5
AC20.6 AC20.7
AC21.5 AC22.1
ACDR.1
BDH-CALC-TIME
Element: Calculation Time		Numeric 6 (hhmmss)
This is the time budget amounts were last calculated.
AC121 AC123
AC127 AC20.1
AC20.2 AC20.3
AC20.4 AC20.5
AC20.6 AC20.7
AC21.5 AC22.1
ACDR.1
BDH-DESCRIPTION
Element: Budget Description		Alpha 30 (Lower Case)
This is the budget description.
AC00.1 AC123
AC127 AC20.6
AC20.7
BDH-ROUND-TYPE
Element: Rounding Type		Alpha 1
This field indicates the type of rounding for the budget amount. The default is 2 (2 decimals, or no rounding).
1 = 1 Decimal
2 = 2 Decimals
W = Whole
H = Hundreds
T = Thousands
AC123 AC127
AC20.6 AC20.7
BDH-UNT-ROUND-TYPE
Element: Unt Round Type		Alpha 1
This field indicates the type of rounding for the units budget. The default is 2 (2 decimals, or no rounding).
1 = 1 Decimal
2 = 2 Decimals
T = Thousands
H = Hundreds
W = Whole
AC123 AC127
AC20.6 AC20.7
BDH-LOCK
Element: Lock		Alpha 1
This flag indicates whether the budget is locked.
N = No
Y = Yes
AC123 AC127
AC128 AC20.6
AC20.7 AC20.8
BDH-NUM-DECIMALS
Element: Number of Decimals		Numeric 1
This is the number of decimal positions to calculate for the budget amount.
AC123 AC127
AC20.6 AC20.7
BDH-UNT-NUM-DEC
Element: Unt Num Dec		Numeric 1
This is the number of decimal positions to calculate for the units budget.
AC123 AC127
AC20.6 AC20.7
BDH-FACTOR
Element: Factor		Alpha 15
The element that affects the budget change.
BDH-FACTOR-RATE
Element: Factor Rate		Signed 14.7
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
Element: Life Only		Alpha 1
This field indicates whether the budget is life-only.
Y = Yes
N = No
AC123 AC127
AC20.6 AC20.7
BDH-RELEASED
Element: Released		Alpha 1
This field indicates whether a change order associated with the budget has been released. Use Yes for Released and No for Not Released.
Y = Released
N = Not Released
AC123 AC127
AC21.1 AC21.2
AC21.3 AC21.4
AC21.5 AC22.1
BDH-RPT-RATE-1
Element: Rpt Rate 1		Signed 14.7
The exchange rate to convert the transaction amount to Report Currency 1. The exchange rate is defined in CU10.1 (Exchange Rate).
AC123 AC127
AC20.6 AC20.7
AC581
BDH-RPT-RATE-2
Element: Rpt Rate 1		Signed 14.7
The exchange rate to convert the transaction amount to Report Currency 1. The exchange rate is defined in CU10.1 (Exchange Rate).
AC123 AC127
AC20.6 AC20.7
AC581
BDH-ACT-ACTIVE-BUD
Element: Act Active Bud		Derived
This is the active activity budget.
BDH-GRP-ACTIVE-BUD
Element: Grp Active Bud		Derived
This is the active activity group budget.


ACBUDHDR FILE INDEX

NAME KEY FIELDS DESCRIPTION / SUBSET CONDITION USED IN
BDHSET1 ACTIVITY-GRP
ACTIVITY
BUDGET-NBR
...
AC00.1 AC10.1
AC120 AC121
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
AC21.5 AC210
AC22.1 AC220
AC225 AC25.1
AC27.1 AC30.1
AC300 AC310
BDHSET3 ACTIVITY-GRP
BUDGET-NBR
ACTIVITY
AC00.1 AC20.4
AC200 BR430


ACBUDHDR FILE RELATIONS


ONE TO ONE RELATIONS

RELATION
NAME		 RELATED 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
NAME		 RELATED 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

File created: Thu Jun 09 11:03:54 2016

Home
Contact Us



All trademarks and registered trademarks are the property of their respective owners.