|
|
ACBUDREL FILE
Activity Budget Relation
This file is used in conversion of non-Lawson activity budget information to
the LAWSON INSIGHT Activity Management system. The file contains activity
budget relations information from AC27.1 (Budget Relationship). It relates
activity budgets to the Run Group and Sequence Number fields, which organize
transaction records for conversion and importing. In addition to run group and
sequence number, this file includes old activity group, old activity, budget
number and description, account category, budget begin and end dates, as well
as other budget information.
REFERENCED BY
AC227
UPDATED BY
AC127 AC27.1 AC300 AC310
FIELD NAME DESCRIPTION/VALID VALUES UPDATED BY
ACB-RUN-GROUP Alpha 12 AC27.1
Run Group Required key. This is the run group.
The Run Group and Sequence Number fields
are the keys to the file. They should be
used to group records together for
importing.
ACB-SEQ-NUMBER Numeric 6 AC27.1
Sequence Number Required key. Sequence number is a
unique number assigned to each
transaction. The Sequence Number and
Run Group fields are the keys to the
file. They should be used to group
records together for importing.
ACB-OLD-ACT-GRP Alpha 35 AC27.1
Old Activity Group This is the old activity group.
ACB-OLD-ACTIVITY Alpha 35 AC27.1
Old Activity This is the old activity.
ACB-BUDGET-NBR Numeric 3 AC27.1
Budget Number This is the budget number as defined in
the Activity Management system.
ACB-ACCT-CATEGORY Alpha 5 AC27.1
Account Category This is the account category for the
budget relationship information.
ACB-FISCAL-YEAR Numeric 4 AC27.1
Fiscal Year This is the current fiscal year. This
field is updated by GL199 (Period
Closing).
ACB-CURRENCY-CODE Alpha 5 AC127 AC27.1
Currency Code This field contains the company base
currency code established in GL10.1
(Company).
ACB-BEGIN-DATE Numeric 8 (yyyymmdd) AC127 AC27.1
Begin Date This is the begin date of the date
range for the budget.
ACB-END-DATE Numeric 8 (yyyymmdd) AC127 AC27.1
End Date This is the end date of the date range
for the budget.
ACB-NBR-PERIODS Numeric 2 AC27.1
Number of Periods This is the number of periods for the
budget.
ACB-DESCRIPTION Alpha 30 (Lower Case) AC27.1
Budget Description This is the budget description.
ACB-RATE-VALUE Signed 12.6 AC127 AC27.1
Value The amount used to recalculate the
budget.
ACB-MULT-DIV Alpha 1 AC127 AC27.1
Multiply/Divide Indicate whether you want to multiply
Option or divide in calculating a base currency
amount. You can perform the calculation
either by multiplying or dividing a
budget currency amount by the exchange
rate to calculate the base currency
amount. The default is Multiply.
ACB-ROUND-TYPE Alpha 1 AC127 AC27.1
Round Type Select a round type to use in rounding
budget amounts. You can choose one of
the following values:
1 = 1 Decimal
2 = 2 Decimals
W = Whole Numbers
H = Hundreds
T = Thousands
The default is 2 (2 Decimals).
ACB-UNT-ROUND-TYPE Alpha 1 AC127 AC27.1
Unt Round Type Select a round type to use in rounding
units budget values. You can choose one
of the following values:
1 = 1 Decimal
2 = 2 Decimals
W = Whole Numbers
H = Hundreds
T = Thousands
The default is 2 (2 Decimals).
ACB-NUM-DECIMALS Numeric 1 AC27.1
Num Decimals This is the number of decimals for the
amount budget.
ACB-UNT-NUM-DEC Numeric 1 AC27.1
Unt Num Dec This is the number of decimals for the
units budget.
ACB-VALUE-ENTERED Alpha 1 AC27.1
Value Entered This field indicates whether the budget
is life, annual, or period.
L = Life
A = Annual
P = Period
ACB-LIFE-ONLY Alpha 1 AC127 AC27.1
Life Only This field indicates whether the budget
is life-only.
ACB-AMOUNT Currency 15.2 Occurs 53 Times AC127 AC27.1
Amount This is the amounts by period for the
specified record.
ACB-UNIT Signed 15.2 Occurs 53 Times AC127 AC27.1
Unit This is the number of units for the new
budget.
ACB-FACTOR Alpha 15 Occurs 53 Times AC127 AC27.1
Factor The element that affects the budget
change.
ACB-FACTOR-RATE Signed 12.6 Occurs 53 Times AC127 AC27.1
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.
ACBUDREL FILE INDEX
NAME KEY FIELDS DESCRIPTION / SUBSET CONDITION USED IN
ACBSET1 RUN-GROUP AC127 AC27.1
SEQ-NUMBER*
ACBSET2 RUN-GROUP KeyChange AC310
OLD-ACT-GRP
OLD-ACTIVITY
BUDGET-NBR
ACCT-CATEGORY
FISCAL-YEAR
SEQ-NUMBER
ACBSET3 RUN-GROUP AC127 AC227
SEQ-NUMBER AC27.1
ACBSET4 OLD-ACT-GRP KeyChange AC27.1 AC300
OLD-ACTIVITY
BUDGET-NBR
ACCT-CATEGORY
FISCAL-YEAR
RUN-GROUP
SEQ-NUMBER
|