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.1 AC21.2 AC21.3 AC220 AC295 AC297 AC30.2 AC30.3 AC32.1 AC401 AC410 AC420 AC90.1 AC90.2 AC95.1 AC95.2 AC97.1 AC97.2 ACDL.1 AC470 ACAC.1 UPDATED BY AC120 AC121 AC123 AC127 AC20.1 AC20.2 AC20.3 AC20.4 AC20.5 AC20.6 AC22.1 AC300 AC310 AC580 AC701 AC730 AC980 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.1 AC20.2 AC20.3 AC20.4 AC22.1 AC730 BDX-ACTIVITY Alpha 15 AC121 AC123 Activity Required key. This is the activity for AC127 AC20.1 the budget detail. AC20.2 AC20.3 AC20.4 AC22.1 AC730 BDX-BUDGET-NBR Numeric 3 AC121 AC123 Budget Number Required key. This is the budget number AC127 AC20.1 uniquely defined in budget setup. AC20.2 AC20.3 AC20.4 AC22.1 AC730 BDX-ACCT-CATEGORY Alpha 5 AC121 AC123 Account Category Required key. This is the account AC127 AC20.1 category for the budget detail. AC20.2 AC20.3 AC20.4 AC22.1 AC730 BDX-FISCAL-YEAR Numeric 4 AC121 AC123 Fiscal Year Required key. This is the budget year. AC127 AC20.1 AC20.2 AC20.3 AC20.4 AC22.1 AC730 BDX-PERIOD Numeric 2 AC121 AC123 Period Required key. This is the period for AC127 AC20.1 the budget. AC20.2 AC20.3 AC20.4 AC22.1 AC730 BDX-AMOUNT Currency 15.2 AC121 AC123 Amount This is the budget amount for the AC127 AC20.1 budget period. AC20.2 AC20.3 AC20.4 AC22.1 AC701 AC730 BDX-UNIT Signed 15.2 AC121 AC123 Unit This is the units budget for the budget AC127 AC20.1 period. AC20.2 AC20.3 AC20.4 AC22.1 AC701 AC730 BDX-FACTOR Alpha 15 AC121 AC123 Factor The element that affects the budget AC127 AC20.1 change. AC20.2 AC20.3 AC20.4 AC22.1 AC730 BDX-FACTOR-RATE Signed 12.6 AC121 AC123 Rate You can type or select the rate that AC127 AC20.1 affects the factor. For example, you AC20.2 AC20.3 could type the inflation rate. AC20.4 AC22.1 AC730 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 AC21.1 AC21.2 AC21.3 AC22.1 AC220 AC295 AC297 AC30.2 AC30.3 AC300 AC310 AC32.1 AC401 AC410 AC420 AC580 AC701 AC730 AC90.1 ... BDXSET2 ACTIVITY-GRP ACTIVITY BUDGET-NBR FISCAL-YEAR ACCT-CATEGORY PERIOD BDXSET3 ACTIVITY-GRP AC21.3 AC470 ACTIVITY ACAC.1 BUDGET-NBR FISCAL-YEAR PERIOD ACCT-CATEGORY BDXSET4 ACTIVITY-GRP 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 BDX-BUDGET-NBR -> ACX-BUDGET-NBR BDX-FISCAL-YEAR -> ACX-FISCAL-YEAR BDX-ACCT-CATEGORY -> ACX-ACCT-CATEGORY BDH-CURRENCY-CODE -> ACX-CURRENCY-CODE 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 |