ACBUDREL

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

FIELD NAME DESCRIPTION/VALID VALUES UPDATED BY
ACB-RUN-GROUP
Element: Run Group
Alpha 15
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.
AC27.1
ACB-SEQ-NUMBER
Element: Sequence Number
Numeric 6
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.
AC27.1
ACB-OLD-ACT-GRP
Element: Old Activity Group
Alpha 35
This is the old activity group.
AC27.1
ACB-OLD-ACTIVITY
Element: Old Activity
Alpha 35
This is the old activity.
AC27.1
ACB-BUDGET-NBR
Element: Budget Number
Numeric 3
This is the budget number as defined in the Activity Management system.
AC27.1
ACB-OLD-ACCT-CAT
Element: Old Acct Cat
Alpha 35
AC27.1
ACB-FISCAL-YEAR
Element: Year
Numeric 4
Contains the fiscal year for the data stored on this record.
AC27.1
ACB-CURRENCY-CODE
Element: Currency Code
Alpha 5
This field contains the company base currency code established in Company (GL10.1 ).
AC127 AC27.1
ACB-BEGIN-DATE
Element: Begin Date
Numeric 8 (yyyymmdd)
This is the begin date of the date range for the budget.
AC127 AC27.1
ACB-END-DATE
Element: End Date
Numeric 8 (yyyymmdd)
This is the end date of the date range for the budget.
AC127 AC27.1
ACB-NBR-PERIODS
Element: Nbr Periods
Numeric 2
This is the number of periods for the budget.
AC27.1
ACB-DESCRIPTION
Element: Budget Description
Alpha 30 (Lower Case)
This is the budget description.
AC27.1
ACB-RATE-VALUE
Element: Acct Rate
Signed 14.7
AC127 AC27.1
ACB-ROUND-TYPE
Element: Round Type
Alpha 1
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).
AC127 AC27.1
ACB-UNT-ROUND-TYPE
Element: Unt Round Type
Alpha 1
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).
AC127 AC27.1
ACB-NUM-DECIMALS
Element: Num Decimals
Numeric 1
This is the number of decimals for the amount budget.
AC27.1
ACB-UNT-NUM-DEC
Element: Unt Num Dec
Numeric 1
This is the number of decimals for the units budget.
AC27.1
ACB-VALUE-ENTERED
Element: Value Entered
Alpha 1
This field indicates whether the budget is life, annual, or period.
AC27.1
ACB-LIFE-ONLY
Element: Life Only
Alpha 1
This field indicates whether the budget is life-only.
AC127 AC27.1
ACB-AMOUNT
Element: Intl Amt
Signed 18.2 Occurs 13 Times
AC127 AC27.1
ACB-UNIT
Element: Unit
Signed 15.2 Occurs 13 Times
This is the number of units for the new budget.
AC127 AC27.1
ACB-FACTOR
Element: Factor
Alpha 15 Occurs 13 Times
The element that affects the budget change.
AC127 AC27.1
ACB-FACTOR-RATE
Element: Factor Rate
Signed 14.7 Occurs 13 Times
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.
AC127 AC27.1
ACB-RPT-RATE-1
Element: Rpt Rate 1
Signed 14.7
The exchange rate to convert the transaction amount to Report Currency 1. The exchange rate is defined in CU10.1 (Exchange Rate).
AC127 AC27.1
ACB-RPT-RATE-2
Element: Rpt Rate 1
Signed 14.7
The exchange rate to convert the transaction amount to Report Currency 1. The exchange rate is defined in CU10.1 (Exchange Rate).
AC127 AC27.1
ACB-ACTIVE-FLAG
Element: Active Flag
Alpha 1
The Active flag indicates if this record contains the active budget for the activity or group.
Y
N
AC27.1
ACB-LOCK
Element: Lock
Alpha 1
Choose the Lock button to open the Lock subform. Use the subform to lock the budget. When you lock a budget, it cannot be changed or deleted.
AC27.1


ACBUDREL FILE INDEX

NAME KEY FIELDS DESCRIPTION / SUBSET CONDITION USED IN
ACBSET1 RUN-GROUP
SEQ-NUMBER*
AC127 AC227
AC27.1
ACBSET2 RUN-GROUP
OLD-ACT-GRP
OLD-ACTIVITY
BUDGET-NBR
OLD-ACCT-CAT
FISCAL-YEAR
SEQ-NUMBER
KeyChange
ACBSET3 RUN-GROUP
SEQ-NUMBER
AC127 AC227
AC27.1
ACBSET4 OLD-ACT-GRP
OLD-ACTIVITY
BUDGET-NBR
OLD-ACCT-CAT
FISCAL-YEAR
RUN-GROUP
SEQ-NUMBER
KeyChange
AC27.1 AC300


File created: Thu Jun 09 11:03:55 2016

Home
Contact Us



All trademarks and registered trademarks are the property of their respective owners.