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
AC00.1 AC00.2 AC00.3 AC02.1 AC05.2 AC05.3
AC08.1 AC08.2 AC08.3 AC08.4 AC08.5 AC08.6
AC08.7 AC10.1 AC165 AC210 AC220 AC225
AC25.1 AC27.1 AC30.1 AC310 AC40.1 AC40.4
AC401 AC41.1 AC41.4 AC42.1 AC420 AC421
AC45.4 AC46.1 AC527 AC540 AC65.1 AC65.2
AC81.1 AC82.2 AC82.3 AC97.2 AC97.4 AC97.6
ACAC.1 ACBD.1 ACBD.2 ACDL.1 ACTA.1 ACVW.1
SE10.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 AP510 AP520 API1.1
API2.1 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 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 IC12.1 IC140 IC141 IC142
IC145 IC243 IC330 IC64.1 IC64.2 IC64.3
IC64.4 IC64.5 IC64.6 IC64.7 IC64.8 IC64.9
IC66.1 IC83.1 EX545 IFEB.1 MA180 MA278
MA41.1 MA41.2 MA41.4 MA41.7 MA42.2 MA43.2
MA43.7 MA44.1 MA44.2 MA53.1 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 PD570 PO04.1 PO04.2
PO10.1 PO10.2 PO100 PO101 PO115 PO120
PO122 PO131 PO132 PO136 PO15.1 PO15.2
PO15.4 PO150 PO17.1 PO190 PO20.1 PO20.6
PO20.9 PO204 PO21.1 PO21.2 PO21.3 PO21.4
PO21.5 PO22.1 PO22.3 PO22.4 PO220 PO222
PO224 PO225 PO229 PO23.1 PO230 PO234
PO24.1 PO25.1 PO25.5 PO25.6 PO25.7 PO251
PO26.2 PO26.3 PO26.4 PO26.5 PO26.6 PO26.7
PO26.9 PO27.2 PO27.3 PO27.4 PO275 PO276
PO277 PO28.2 PO280 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 RQ01.1 RQ10.1
RQ10.2 RQ10.3 RQ10.4 RQ10.5 RQ11.1 RQ12.1
RQ13.1 RQ13.2 RQ35.1 RQ44.1 RQ500 RQ810
RQIB.1 RQIF.1 RQII.1 RQIJ.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 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 AC21.5
AC22.1 AC300 AC311 AC581 ACDR.1

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 AC00.2
AC00.3 AC02.1
AC05.2 AC05.3
AC08.1 AC08.2
AC08.3 AC08.4
AC08.5 AC08.6
AC08.7 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
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
Acbudhdbod ACBUDHDBOD Not Required, Delete Cascades
BDH-ACTIVITY-GRP->YAE-ACTIVITY-GRP
BDH-ACTIVITY->YAE-ACTIVITY
BDH-BUDGET-NBR->YAE-BUDGET-NBR


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 02:02:51 2016

Home
Contact Us



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