ACBUDREL – Activity Budget Relation

System: Activity Management (AC)
Prefix: ACB
Primary key: RUN-GROUP, SEQ-NUMBER
Fields: 27
Updated by: 3 programs
Referenced by: 1 program

ACBUDREL is the Activity Budget Relation table in Lawson Activity Management (prefix ACB). It is indexed by RUN-GROUP, SEQ-NUMBER (ACBSET1); alternate indexes: ACBSET2, ACBSET3 and ACBSET4. It is updated by AC127, AC27.1 and AC300 and referenced by AC227. The table has 27 fields, 4 indexes and 0 documented relations.

About ACBUDREL

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.

Fields (27)

Column = COBOL field name without the ACB- prefix, hyphens → underscores. Derived fields are computed by the application and are not stored.

Field / column	Type	Description & values	Updated by
`ACB-RUN-GROUP` PK 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` PK SEQ_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` OLD_ACT_GRP	Alpha 35	This is the old activity group.	AC27.1
`ACB-OLD-ACTIVITY` OLD_ACTIVITY	Alpha 35	This is the old activity.	AC27.1
`ACB-BUDGET-NBR` BUDGET_NBR	Numeric 3	This is the budget number as defined in the Activity Management system.	AC27.1
`ACB-OLD-ACCT-CAT` OLD_ACCT_CAT	Alpha 35	—	AC27.1
`ACB-FISCAL-YEAR` FISCAL_YEAR	Numeric 4	Contains the fiscal year for the data stored on this record.	AC27.1
`ACB-CURRENCY-CODE` CURRENCY_CODE	Alpha 5	This field contains the company base currency code established in Company (GL10.1 ).	AC127, AC27.1
`ACB-BEGIN-DATE` BEGIN_DATE	Numeric 8 (yyyymmdd)	This is the begin date of the date range for the budget.	AC127, AC27.1
`ACB-END-DATE` END_DATE	Numeric 8 (yyyymmdd)	This is the end date of the date range for the budget.	AC127, AC27.1
`ACB-NBR-PERIODS` NBR_PERIODS	Numeric 2	This is the number of periods for the budget.	AC27.1
`ACB-DESCRIPTION` DESCRIPTION	Alpha 30 (Lower Case)	This is the budget description.	AC27.1
`ACB-RATE-VALUE` RATE_VALUE	Signed 14.7	—	AC127, AC27.1
`ACB-ROUND-TYPE` ROUND_TYPE	Alpha 1	Select a round type to use in rounding budget amounts. You can choose one of the following values: The default is 2 (2 Decimals). `1` 1 Decimal `2` 2 Decimals `W` Whole Numbers `H` Hundreds `T` Thousands	AC127, AC27.1
`ACB-UNT-ROUND-TYPE` UNT_ROUND_TYPE	Alpha 1	Select a round type to use in rounding units budget values. You can choose one of the following values: The default is 2 (2 Decimals). `1` 1 Decimal `2` 2 Decimals `W` Whole Numbers `H` Hundreds `T` Thousands	AC127, AC27.1
`ACB-NUM-DECIMALS` NUM_DECIMALS	Numeric 1	This is the number of decimals for the amount budget.	AC27.1
`ACB-UNT-NUM-DEC` UNT_NUM_DEC	Numeric 1	This is the number of decimals for the units budget.	AC27.1
`ACB-VALUE-ENTERED` VALUE_ENTERED	Alpha 1	This field indicates whether the budget is life, annual, or period.	AC27.1
`ACB-LIFE-ONLY` LIFE_ONLY	Alpha 1	This field indicates whether the budget is life-only.	AC127, AC27.1
`ACB-AMOUNT` AMOUNT	Signed 18.2 Occurs 13 Times ×13	—	AC127, AC27.1
`ACB-UNIT` UNIT	Signed 15.2 Occurs 13 Times ×13	This is the number of units for the new budget.	AC127, AC27.1
`ACB-FACTOR` FACTOR	Alpha 15 Occurs 13 Times ×13	The element that affects the budget change.	AC127, AC27.1
`ACB-FACTOR-RATE` FACTOR_RATE	Signed 14.7 Occurs 13 Times ×13	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` 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` RPT_RATE_2	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` 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` 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

Indexes (4)

Keys marked * are descending. Every documented Lawson index is unique unless flagged Duplicates; Subset indexes carry a Where condition.

Index	Keys	Flags	Used in
`ACBSET1`	`RUN-GROUP`, `SEQ-NUMBER*`	Primary	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

ACBUDREL – Activity Budget Relation

About ACBUDREL

Fields (27)

Indexes (4)

Programs

Updated by (3)

Referenced by (1)