ACBUDRATE – Activity Budget Rate

System
Activity Management (AC)
Prefix
BUR
Primary key
ACTIVITY-GRP, CURR-CODE-1, CURR-CODE-2, ACTIVITY, BUDGET-NBR
Fields
7
Updated by
4 programs
Referenced by
1 program

ACBUDRATE is the Activity Budget Rate table in Lawson Activity Management (prefix BUR). It is indexed by ACTIVITY-GRP, CURR-CODE-1, CURR-CODE-2, ACTIVITY, BUDGET-NBR (BURSET1). It is updated by AC300, AC311, AC581 and AC81.1 and referenced by AC310. The table has 7 fields, 1 index and 0 documented relations.

About ACBUDRATE

No description in the Lawson data dictionary.

Fields (7)

Column = COBOL field name without the BUR- prefix, hyphens → underscores. Derived fields are computed by the application and are not stored. PK = primary key (present in every index); SETn = leading/alternate key of that index.

Field / columnTypeDescription & valuesUpdated by
#BUR-ACTIVITY-GRP PK
ACTIVITY_GRP
Alpha 15The activity group is the overall project.AC81.1
#BUR-CURR-CODE-1 PK
CURR_CODE_1
Alpha 5This field contains the company base currency code established in Company (GL10.1 ).AC81.1
#BUR-CURR-CODE-2 PK
CURR_CODE_2
Alpha 5Type the currency code you want to associate with the report currency name. The currency code must exist in CU01.1 (Currency Codes).AC81.1
#BUR-ACTIVITY PK
ACTIVITY
Alpha 15Activities are the processes or procedures that produce work. Cost objects (products, services, customers, and so on) are the reasons for performing the activity.AC81.1
#BUR-BUDGET-NBR PK
BUDGET_NBR
Numeric 3The Budget Number field contains the budget number.AC81.1
#BUR-RPT-RATE-1
RPT_RATE_1
Signed 14.7The exchange rate to convert the transaction amount to Report Currency 1. The exchange rate is defined in CU10.1 (Exchange Rate).AC81.1
#BUR-RPT-RATE-2
RPT_RATE_2
Signed 14.7The exchange rate to convert the transaction amount to Report Currency 1. The exchange rate is defined in CU10.1 (Exchange Rate).AC81.1

Indexes (1)

Keys are listed in index order; marks a descending key. Every documented Lawson index is unique unless flagged Duplicates; Subset indexes carry a Where condition.

IndexKeysFlagsConditionUsed in
BURSET1
  1. ACTIVITY-GRP
  2. CURR-CODE-1
  3. CURR-CODE-2
  4. ACTIVITY
  5. BUDGET-NBR
PrimaryAC300, AC310, AC311, AC581, AC81.1

Programs

Updated by (4)

Referenced by (1)