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
AC210 ACAC.1 ACTA.1 ACVW.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 CB10.1 CB15.1 CB15.2 CB150
CB191 CB20.1 CB30.1 CB45.1 CB46.1 CB500
CB543 CB544 CB55.1 CB554 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 EX545 IFEB.1 MA41.1
MA41.2 MA41.4 MA41.7 MA43.1 MA43.2 MA43.3
MA43.4 MA43.6 MA43.7 MAI1.1 PO136 PO190
PO300 PO520 POCP.1 POI3.1 POIG.1 POII.1
POIJ.1 AC200


UPDATED BY
AC00.1 AC10.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.
BDH-ACTIVITY
Element: Activity
Alpha 15
Required key. This is the activity for the budget header information.
BDH-BUDGET-NBR
Element: Budget Number
Numeric 3
Required key. This is the budget number uniquely defined in budget setup.
BDH-BEGIN-DATE
Element: Begin Date
Numeric 8 (yyyymmdd)
The beginning date of a date range for the budget.
BDH-END-DATE
Element: End Date
Numeric 8 (yyyymmdd)
The end date of a date range for the budget.
BDH-TOTAL-BUDGET
Element: Total Budget
Signed 18.2
This is the total budget amount.
BDH-TOT-UNITS-BUD
Element: Tot Units Bud
Signed 15.2
This is the total number of units for the budget.
BDH-CURRENCY-CODE
Element: Currency Code
Alpha 5
This is the currency code for the budget.
BDH-RATE-VALUE
Element: Rate Value
Signed 14.7
This is the budget exchange rate.
BDH-MAINT-DATE
Element: Maintenance Date
Numeric 8 (yyyymmdd)
This is the date the budget was last changed.
BDH-MAINT-TIME
Element: Maintenance Time
Numeric 6 (hhmmss)
This is the time the budget was last changed.
BDH-CALC-DATE
Element: Calculation Date
Numeric 8 (yyyymmdd)
This is the date budget amounts were last calculated.
BDH-CALC-TIME
Element: Calculation Time
Numeric 6 (hhmmss)
This is the time budget amounts were last calculated.
BDH-DESCRIPTION
Element: Budget Description
Alpha 30 (Lower Case)
This is the budget description.
AC00.1
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
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
BDH-LOCK
Element: Lock
Alpha 1
This flag indicates whether the budget is locked.
N = No
Y = Yes
BDH-NUM-DECIMALS
Element: Number of Decimals
Numeric 1
This is the number of decimal positions to calculate for the budget amount.
BDH-UNT-NUM-DEC
Element: Unt Num Dec
Numeric 1
This is the number of decimal positions to calculate for the units budget.
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
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
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).
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).
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
AC210 ACAC.1
ACTA.1 ACVW.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
CB10.1 CB15.1
BDHSET3 ACTIVITY-GRP
BUDGET-NBR
ACTIVITY
AC00.1 AC200


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: Wed Jun 08 20:46:54 2016

Home
Contact Us



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