 |
Lawson Insight Technical Documentation |
|
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 AC190 AC210 AC220
AC225 AC25.1 AC27.1 AC30.1 AC401 AC420
AC421 AC45.1 AC65.1 AC65.2 AC720 AC81.1
AC97.2 AC97.4 AC97.6 ACAC.1 ACDL.1 ACDR.1
ACVW.1 SE10.1 SE90.1 BR65.1 BR65.2 BRCC.1
AC200 BR430
UPDATED BY
AC120 AC121 AC123 AC127 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
FIELD NAME DESCRIPTION/VALID VALUES UPDATED BY
BDH-ACTIVITY-GRP Alpha 15 AC120 AC123
Activity Group Required key. This is the activity AC127 AC20.6
group for the budget header information. AC20.7
BDH-ACTIVITY Alpha 15 AC123 AC127
Activity Required key. This is the activity for AC20.6 AC20.7
the budget header information.
BDH-BUDGET-NBR Numeric 3 AC123 AC127
Budget Number Required key. This is the budget number AC20.6 AC20.7
uniquely defined in budget setup.
BDH-BEGIN-DATE Numeric 8 (yyyymmdd) AC123 AC127
Begin Date The beginning date of a date range for AC20.6 AC20.7
the budget.
BDH-END-DATE Numeric 8 (yyyymmdd) AC123 AC127
End Date The end date of a date range for the AC20.6 AC20.7
budget.
BDH-TOTAL-BUDGET Signed 15.2 AC121 AC123
Total Budget This is the total budget amount. AC127 AC20.1
AC20.2 AC20.3
AC20.4 AC20.5
AC20.7 AC22.1
BDH-TOT-UNITS-BUD Signed 15.2 AC121 AC123
Tot Units Bud This is the total number of units for AC127 AC20.1
the budget. AC20.2 AC20.3
AC20.4 AC20.5
AC22.1
BDH-CURRENCY-CODE Alpha 5 AC123 AC127
Currency Code This is the currency code for the AC20.6 AC20.7
budget.
BDH-RATE-VALUE Signed 12.6 AC123 AC127
Rate Value This is the budget exchange rate. AC20.7
BDH-MAINT-DATE Numeric 8 (yyyymmdd) AC121 AC123
Maintenance Date This is the date the budget was last AC127 AC20.1
changed. AC20.2 AC20.3
AC20.4 AC20.5
AC20.6 AC20.7
AC22.1
BDH-MAINT-TIME Numeric 6 (hhmmss) AC121 AC123
Maintenance Time This is the time the budget was last AC127 AC20.1
changed. AC20.2 AC20.3
AC20.4 AC20.5
AC20.6 AC20.7
AC22.1
BDH-CALC-DATE Numeric 8 (yyyymmdd) AC121 AC123
Calculation Date This is the date budget amounts were AC127 AC20.1
last calculated. AC20.2 AC20.3
AC20.4 AC20.5
AC22.1
BDH-CALC-TIME Numeric 6 (hhmmss) AC121 AC123
Calculation Time This is the time budget amounts were AC127 AC20.1
last calculated. AC20.2 AC20.3
AC20.4 AC20.5
AC22.1
BDH-DESCRIPTION Alpha 30 (Lower Case) AC00.1 AC123
Budget Description This is the budget description. AC127 AC20.6
AC20.7
BDH-ROUND-TYPE Alpha 1 AC123 AC127
Rounding Type This field indicates the type of AC20.6 AC20.7
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 Alpha 1 AC123 AC127
Unt Round Type This field indicates the type of AC20.6 AC20.7
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 Alpha 1 AC123 AC127
Lock Button This flag indicates whether the budget AC20.6 AC20.7
is locked. AC20.8 AC300
N = No
Y = Yes
BDH-NUM-DECIMALS Numeric 1 AC123 AC127
Number of Decimals This is the number of decimal positions AC20.6 AC20.7
to calculate for the budget amount.
BDH-UNT-NUM-DEC Numeric 1 AC123 AC127
Unt Num Dec This is the number of decimal positions AC20.6 AC20.7
to calculate for the units budget.
BDH-FACTOR Alpha 15
Factor The element that affects the budget
change.
BDH-FACTOR-RATE Signed 12.6
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
Life Only This field indicates whether the budget AC20.6 AC20.7
is life-only.
Y = Yes
N = No
BDH-RELEASED Alpha 1 AC123 AC127
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 AC300
No for Not Released.
Y = Released
N = Not Released
BDH-RPT-RATE-1 Signed 12.6 AC123 AC127
Rpt Rate 1 The exchange rate to convert the AC20.6 AC20.7
transaction amount to Report Currency 1. AC581
The exchange rate is defined in CU10.1
(Exchange Rate).
BDH-RPT-RATE-2 Signed 12.6 AC123 AC127
Rpt Rate 2 The exchange rate to convert the AC20.6 AC20.7
transaction amount to Report Currency 2. AC581
The exchange rate is defined in CU10.1
(Exchange Rate).
BDH-ACT-ACTIVE-BUD Derived
Act Active Bud This is the active activity budget.
BDH-GRP-ACTIVE-BUD Derived
Grp Active Bud This 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
AC165 AC190
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 AC401
...
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
|