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

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