Lawson Insight Technical Documentation |
|
ACBUDDTLX
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
AC32.1 AC37.1 AC410 AC420 AC490 ACDL.1
ACDR.1 ACTA.1 AC40.1 AC40.4 AC41.1 AC41.4
AC42.1 ACAC.1 AP125 AP126 AP25.1 AP25.2
AP26.1 AP27.1 AP520 BR41.1 BR41.4 BR43.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
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
Element: Activity GroupRequired 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
Element: 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
Element: 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
Element: Account CategoRequired 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
Element: 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
Element: 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
Element: Parent Actv AC127 AC20.2
AC20.3 AC20.4
AC20.5 AC22.1
BDX-AMOUNT Currency 15.2 AC121 AC123
Element: 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
Element: 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
Element: 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
Element: Account Rate AC127 AC20.2
AC20.3 AC20.4
AC20.5 AC22.1
BDX-AMT-VARIANCE Derived
Element: Amt Variance This is the amount of variance for the
budget period.
BDX-UNIT-VARIANCE Derived
Element: Unit Variance This is the units variance for the
budget period.
BDX-VARIANCE Derived
Element: Variance This is the percentage of variance from
the budget amount.
BDX-VARIANCE-UNITS Derived
Element: Variance UnitsThis is the percentage of variance from
the units budget.
BDX-OVER-UNDER Derived
Element: 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
Element: Over Under UntThis 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
Element: Blank This derived field is always blank. It
is used in the Drill Around feature for
column headings.
BDX-ACCT-CAT-TYPE Derived
Element: 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
AC300 AC310
AC32.1 AC37.1
AC410 AC420
AC490 ACDL.1
ACDR.1 ACTA.1
BDXSET2 ACTIVITY-GRP
ACTIVITY
BUDGET-NBR
FISCAL-YEAR
ACCT-CATEGORY
PERIOD
BDXSET3 ACTIVITY-GRP AC21.4 AC40.1
ACTIVITY AC40.4 AC41.1
BUDGET-NBR AC41.4 AC42.1
FISCAL-YEAR ACAC.1 AP125
PERIOD AP126 AP25.1
ACCT-CATEGORY AP25.2 AP26.1
AP27.1 AP520
BR41.1 BR41.4
BR43.1 CB10.1
CB191 CB20.1
CB30.1 EE135
EE20.3 EE35.1
EE35.2 EE520
GL146 GL165
GL170 GL197
...
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
|