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 15 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 Period Closing
(GL199).
ACB-CURRENCY-CODE Alpha 5 AC127 AC27.1
Currency Code This field contains the company base
currency code established in Company
(GL10.1 ).
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-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.
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.
ACB-RPT-RATE-1 Signed 12.6 AC127 AC27.1
Rpt Rate 1 The exchange rate to convert the
transaction amount to Report Currency 1.
The exchange rate is defined in CU10.1
(Exchange Rate).
ACB-RPT-RATE-2 Signed 12.6 AC127 AC27.1
Rpt Rate 2 The exchange rate to convert the
transaction amount to Report Currency 2.
The exchange rate is defined in CU10.1
(Exchange Rate).
ACB-ACTIVE-FLAG Alpha 1 AC27.1
Status The Active flag indicates if this record
contains the active budget for the
activity or group.
Y
N
ACBUDREL FILE INDEX
NAME KEY FIELDS DESCRIPTION / SUBSET CONDITION USED IN
ACBSET1 RUN-GROUP AC127 AC227
SEQ-NUMBER* AC27.1
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
|
