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
| 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. |
|
||||||||||||||
| 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. |
|
||||||||||||||
| 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. |
|
| NAME | KEY FIELDS | DESCRIPTION / SUBSET CONDITION | USED IN | ||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| BDHSET1 |
ACTIVITY-GRP ACTIVITY BUDGET-NBR |
|
|||||||||||
| BDHSET3 |
ACTIVITY-GRP BUDGET-NBR ACTIVITY |
|
| ||||||||||
| RELATION NAME |
RELATED FILE | INTEGRITY RULES / FIELD MATCH | |||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|
| Acactgrp | ACACTGRP |
Required
| |||||||||
| Acactivity | ACACTIVITY |
Required
| |||||||||
| Acbudhdbod | ACBUDHDBOD |
Not Required, Delete Cascades
|
| RELATION NAME |
RELATED FILE | INTEGRITY RULES / FIELD MATCH | |||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| Acbuddtl | ACBUDDTL |
| |||||||||||||||||||||
| Acbuddtl Grp | ACBUDDTL |
| |||||||||||||||||||||
| Acchgorder | ACCHGORDER |
| |||||||||||||||||||||
| Accuamt | ACCUAMT |
| |||||||||||||||||||||
| Accuamt Grp | ACCUAMT |
| |||||||||||||||||||||
| Accuamt Rpt1 | ACCUAMT |
| |||||||||||||||||||||
| Accuamt Rpt2 | ACCUAMT |
| |||||||||||||||||||||
| Acu Grp Rpt1 | ACCUAMT |
| |||||||||||||||||||||
| Acu Grp Rpt2 | ACCUAMT |
|
All trademarks and registered trademarks are the property of their
respective owners.