Lawson Insight Technical Documentation |
|
ACBUDHDR
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 AC40.1 AC40.4
AC401 AC41.1 AC41.4 AC42.1 AC420 AC421
AC45.1 AC65.1 AC65.2 AC81.1 AC97.2 AC97.4
AC97.6 ACAC.1 ACDL.1 ACDR.1 ACVW.1 SE10.1
SE90.1 AP125 AP126 AP25.1 AP25.2 AP26.1
AP27.1 AP520 BR165 BR41.1 BR41.4 BR43.1
BR65.1 BRCC.1 CB10.1 CB191 CB20.1 CB30.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 GL75.1 MA65.1
POIG.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
Element: Activity GroupRequired key. This is the activity AC127 AC20.6
group for the budget header information. AC20.7
BDH-ACTIVITY Alpha 15 AC123 AC127
Element: Activity Required key. This is the activity for AC20.6 AC20.7
the budget header information.
BDH-BUDGET-NBR Numeric 3 AC123 AC127
Element: 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
Element: Begin Date The beginning date of a date range for AC20.6 AC20.7
the budget.
BDH-END-DATE Numeric 8 (yyyymmdd) AC123 AC127
Element: End Date The end date of a date range for the AC20.6 AC20.7
budget.
BDH-TOTAL-BUDGET Signed 15.2 AC121 AC123
Element: Total Budget This is the total budget amount. AC127 AC20.1
AC20.2 AC20.3
AC20.4 AC20.5
AC20.7 AC22.1
AC300
BDH-TOT-UNITS-BUD Signed 15.2 AC121 AC123
Element: Detail Total This is the total number of units for AC127 AC20.1
the budget. AC20.2 AC20.3
AC20.4 AC20.5
AC22.1 AC300
BDH-CURRENCY-CODE Alpha 5 AC123 AC127
Element: Currency Code This is the currency code for the AC20.6 AC20.7
budget.
BDH-RATE-VALUE Signed 12.6 AC123 AC127
Element: Rate Value This is the budget exchange rate. AC20.7
BDH-MAINT-DATE Numeric 8 (yyyymmdd) AC121 AC123
Element: Maintenance DaThis 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
Element: Maintenance TiThis 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
Element: Calculation DaThis 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
Element: Calculation TiThis 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
Element: Budget DescripThis is the budget description. AC127 AC20.6
AC20.7
BDH-ROUND-TYPE Alpha 1 AC123 AC127
Element: 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
Element: 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
Element: All Flag 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
Element: Number of DeciThis is the number of decimal positions AC20.6 AC20.7
to calculate for the budget amount.
BDH-UNT-NUM-DEC Numeric 1 AC123 AC127
Element: Num Decimals This is the number of decimal positions AC20.6 AC20.7
to calculate for the units budget.
BDH-FACTOR Alpha 15 AC300
Element: Factor The element that affects the budget
change.
BDH-FACTOR-RATE Signed 12.6 AC300
Element: Account Rate
BDH-LIFE-ONLY Alpha 1 AC123 AC127
Element: All Flag This field indicates whether the budget AC20.6 AC20.7
is life-only.
Y = Yes
N = No
BDH-RELEASED Alpha 1 AC123 AC127
Element: 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
Element: 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
Element: Rpt Rate 1 AC20.6 AC20.7
AC581
BDH-ACT-ACTIVE-BUD Derived
Element: Act Active BudThis is the active activity budget.
BDH-GRP-ACTIVE-BUD Derived
Element: Grp Active BudThis 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 AC40.1
...
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
|