ACBUDDTLX FILE
Activity Budget Detail
This file contains activity budget period information from the AC20 (Activity
Budget) forms. It includes activity group, activity, budget number, account
category, fiscal year, period, and budget amount.
REFERENCED BY
AC130 AC21.3 AC21.4 AC220 AC295 AC297
AC30.2 AC30.3 AC32.1 AC410 AC420 AC490
AC720 ACDL.1 ACDR.1 ACTA.1 ACAC.1
UPDATED BY
AC120 AC121 AC123 AC127 AC20.2 AC20.3
AC20.4 AC20.5 AC20.7 AC20.6 AC22.1 AC300
AC310
FIELD NAME DESCRIPTION/VALID VALUES UPDATED BY
BDX-ACTIVITY-GRP Alpha 15 AC120 AC121
Activity Group Required key. This is the activity AC123 AC127
group for the budget detail. AC20.2 AC20.3
AC20.4 AC20.5
AC22.1
BDX-ACTIVITY Alpha 15 AC121 AC123
Activity Required key. This is the activity for AC127 AC20.2
the budget detail. AC20.3 AC20.4
AC20.5 AC22.1
BDX-BUDGET-NBR Numeric 3 AC121 AC123
Budget Number Required key. This is the budget number AC127 AC20.2
uniquely defined in budget setup. AC20.3 AC20.4
AC20.5 AC22.1
BDX-ACCT-CATEGORY Alpha 5 AC121 AC123
Account Category Required key. This is the account AC127 AC20.2
category for the budget detail. AC20.3 AC20.4
AC20.5 AC22.1
BDX-FISCAL-YEAR Numeric 4 AC121 AC123
Fiscal Year Required key. This is the budget year. AC127 AC20.2
AC20.3 AC20.4
AC20.5 AC22.1
BDX-PERIOD Numeric 2 AC121 AC123
Period Required key. This is the period for AC127 AC20.2
the budget. AC20.3 AC20.4
AC20.5 AC22.1
BDX-PARENT-ACTV Alpha 15 AC121 AC123
Parent Actv AC127 AC20.2
AC20.3 AC20.4
AC20.5 AC22.1
BDX-AMOUNT Currency 15.2 AC121 AC123
Amount This is the budget amount for the AC127 AC20.2
budget period. AC20.3 AC20.4
AC20.5 AC22.1
BDX-UNIT Signed 15.2 AC121 AC123
Unit This is the units budget for the budget AC127 AC20.2
period. AC20.3 AC20.4
AC20.5 AC22.1
BDX-FACTOR Alpha 15 AC121 AC123
Factor The element that affects the budget AC127 AC20.2
change. AC20.3 AC20.4
AC20.5 AC22.1
BDX-FACTOR-RATE Signed 12.6 AC121 AC123
Rate You can type or select the rate that AC127 AC20.2
affects the factor. For example, you AC20.3 AC20.4
could type the inflation rate. AC20.5 AC22.1
If you select units and amounts, the
rate is calculated.
BDX-AMT-VARIANCE Derived
Amt Variance This is the amount of variance for the
budget period.
BDX-UNIT-VARIANCE Derived
Unit Variance This is the units variance for the
budget period.
BDX-VARIANCE Derived
Variance This is the percentage of variance from
the budget amount.
BDX-VARIANCE-UNITS Derived
Variance Units This is the percentage of variance from
the units budget.
BDX-OVER-UNDER Derived
Over Under This field indicates whether there is a
variance, either over or under, the
budgeted amount. If there is no
variance, the field is blank.
BDX-OVER-UNDER-UNT Derived
Over Under Unt This field indicates whether there is a
variance, either over or under, the
units budget. If there is no variance,
the field is blank.
BDX-BLANK Derived
Blank This derived field is always blank. It
is used in the Drill Around feature for
column headings.
BDX-ACCT-CAT-TYPE Derived
Acct Cat Type This is the account category type:
cost, revenue, or accrual.
ACBUDDTLX FILE INDEX
NAME KEY FIELDS DESCRIPTION / SUBSET CONDITION USED IN
BDXSET1 ACTIVITY-GRP AC120 AC121
ACTIVITY AC123 AC127
BUDGET-NBR AC130 AC20.1
ACCT-CATEGORY AC20.2 AC20.3
FISCAL-YEAR AC20.4 AC20.5
PERIOD AC20.6 AC20.7
AC21.3 AC21.4
AC22.1 AC220
AC295 AC297
AC30.2 AC30.3
AC300 AC310
AC32.1 AC410
AC420 AC490
AC720 ACDL.1
ACDR.1 ACTA.1
BDXSET2 ACTIVITY-GRP
ACTIVITY
BUDGET-NBR
FISCAL-YEAR
ACCT-CATEGORY
PERIOD
BDXSET3 ACTIVITY-GRP AC21.4 ACAC.1
ACTIVITY
BUDGET-NBR
FISCAL-YEAR
PERIOD
ACCT-CATEGORY
BDXSET4 ACTIVITY-GRP
BUDGET-NBR
ACCT-CATEGORY
FISCAL-YEAR
PERIOD
ACTIVITY
BDXSET5 ACTIVITY-GRP KeyChange
PARENT-ACTV
BUDGET-NBR
ACCT-CATEGORY
FISCAL-YEAR
PERIOD
ACTIVITY
ACBUDDTLX FILE RELATIONS
ONE TO ONE RELATIONS
RELATION RELATED
NAME FILE INTEGRITY RULES / FIELD MATCH
Acacctcat ACACCTCAT Not Required
BDX-ACCT-CATEGORY -> AAX-ACCT-CATEGORY (AAXSET1)
Acacctcatx ACACCTCATX Not Required
BDX-ACTIVITY-GRP -> AXX-ACTIVITY-GRP
BDX-ACTIVITY -> AXX-ACTIVITY
BDX-ACCT-CATEGORY -> AXX-ACCT-CATEGORY
Acactgrp ACACTGRP Required
BDX-ACTIVITY-GRP -> AGP-ACTIVITY-GRP
Acactivity ACACTIVITY Not Required
BDX-ACTIVITY -> ACV-ACTIVITY
Acbuddtl ACBUDDTL Required
BDX-ACTIVITY-GRP -> BDT-ACTIVITY-GRP
BDX-ACTIVITY -> BDT-ACTIVITY
BDX-BUDGET-NBR -> BDT-BUDGET-NBR
BDX-ACCT-CATEGORY -> BDT-ACCT-CATEGORY
BDX-FISCAL-YEAR -> BDT-FISCAL-YEAR
Acbudhdr ACBUDHDR Required
BDX-ACTIVITY-GRP -> BDH-ACTIVITY-GRP
BDX-ACTIVITY -> BDH-ACTIVITY
BDX-BUDGET-NBR -> BDH-BUDGET-NBR
Accuamtx ACCUAMTX Not Required
BDX-ACTIVITY-GRP -> ACX-ACTIVITY-GRP
BDX-ACTIVITY -> ACX-ACTIVITY
BDH-CURRENCY-CODE -> ACX-CURRENCY-CODE
BDX-BUDGET-NBR -> ACX-BUDGET-NBR
BDX-FISCAL-YEAR -> ACX-FISCAL-YEAR
BDX-ACCT-CATEGORY -> ACX-ACCT-CATEGORY
BDX-PERIOD -> ACX-PERIOD
Acmasterx ACMASTERX Not Required
BDX-ACTIVITY-GRP -> MSX-ACTIVITY-GRP
BDX-ACTIVITY -> MSX-ACTIVITY
BDX-ACCT-CATEGORY -> MSX-ACCT-CATEGORY
BDX-FISCAL-YEAR -> MSX-FISCAL-YEAR
BDX-PERIOD -> MSX-PERIOD
|
