ACBLRATE – Activity Billing Rates Header

System: AC Billing Revenue (BR)
Prefix: ALR
Primary key: ACTIVITY, SUM-ACCT-CAT, CTR-CAT-GRP, ACCT-CATEGORY, SOURCE-CODE, MATRIX-CAT, EFFECTIVE-DT
Fields: 9
Updated by: 6 programs
Referenced by: 17 programs

ACBLRATE is the Activity Billing Rates Header table in Lawson AC Billing Revenue (prefix ALR). It is indexed by ACTIVITY, SUM-ACCT-CAT, CTR-CAT-GRP, ACCT-CATEGORY, SOURCE-CODE, MATRIX-CAT, EFFECTIVE-DT (ALRSET1). It is related 1:1 to ACBILL and MXCATDEF and 1:M to ACBLRATEX. It is updated by AC300, BR00.1, BR00.2, BR03.1, BR03.2 and BR03.3 and referenced by AC190, AC40.1, AC40.4, AC41.1, AC41.4, AC42.1, AC54.1, AC540 and 9 more. The table has 9 fields, 1 index and 3 documented relations.

About ACBLRATE

This file contains billing rate information from the Billing Category Rates (BR03.1) or the Units of Production Rates (BR03.2). Rates are stored by attributes or units of prodction. The file maintains the rate schedule name and description, the billing rate attribute, unit type, and currency code for an activity. You can print a billing rate listing by running BR203 (Billing Rate Listing).

Fields (9)

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

Field / column	Type	Description & values	Updated by
`ALR-ACTIVITY` PK ACTIVITY	Alpha 15	The activity established in Billing Category Rates (BR03.1) or Units of Production Rates (BR03.2).	BR03.1, BR03.2, BR03.3
`ALR-ACCT-CATEGORY` PK ACCT_CATEGORY	Alpha 5	The account category associated with the activity and maintained in Billing Category Rates (BR03.1) or the Units of Production Rates(BR03.2) . A blank value in the account category or summary account category indicates that the rates are valid for all account categories associated with the activity.	BR03.1, BR03.2, BR03.3
`ALR-SOURCE-CODE` PK SOURCE_CODE	Alpha 2	The Source Code is established in the Source Code (GL05) and maintained in Billing Category Rates (BR03.1) or Units of Production Rates (BR03.2). A blank value in this field indicates that the rates are valid for all source codes related to Activity Management.	BR03.1, BR03.2, BR03.3
`ALR-MATRIX-CAT` PK MATRIX_CAT	Alpha 12	A billing rate attribute must be defined as part of the key for Activity Management billing transactions. The attribute is established in MX00.1. The attribute must have an object type of ACTRN established. The attribute must be assigned to the object type ACTRANS in GL05.1 (Source Code).	BR03.1, BR03.2, BR03.3
`ALR-EFFECTIVE-DT` PK EFFECTIVE_DT	Numeric 8 (yyyymmdd)	The effective date is the date the record is first valid. The date is maintained on the Billing Category Rates (BR03.1) or Units of Production (BR03.2).	BR03.1, BR03.2, BR03.3
`ALR-UNIT-TYPE` UNIT_TYPE	Alpha 1	This field indicates whether the rate schedule is for hours (time and materials) or units (units of production). If the rates are set up in Billing Category Rates (BR00.1), the up in Units of Production Rates (BR03.2) `value` H(ours). If the rates are set `the value` U(nits). `U` Units `H` Hours	BR03.1, BR03.2, BR03.3
`ALR-CURRENCY-CODE` CURRENCY_CODE	Alpha 5	This code represents the currency defined for the activity which is established in Activity (AC10.1).	BR03.1, BR03.2, BR03.3
`ALR-SUM-ACCT-CAT` PK SUM_ACCT_CAT	Alpha 5	The summary account category associated with the activity and maintained in Billing Category Rates (BR03.1) or Units of Production (BR03.2). A blank value in the summary account category or the account category indicates that the rates are valid for all account categories associated with the activity.	BR03.1, BR03.2, BR03.3
`ALR-CTR-CAT-GRP` PK CTR_CAT_GRP	Alpha 5	—	BR03.1, BR03.2, BR03.3

Indexes (1)

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

Index	Keys	Flags	Condition	Used in
`ALRSET1`	`ACTIVITY`, `SUM-ACCT-CAT`, `CTR-CAT-GRP`, `ACCT-CATEGORY`, `SOURCE-CODE`, `MATRIX-CAT`, `EFFECTIVE-DT*`	Primary		AC190, AC300, AC40.1, AC40.4, AC41.1, AC41.4, AC42.1, AC54.1 +15 more

Relations

One to one (2) — lookups and parents

Relation	Table	Rules	Condition	Field map
Acbill	ACBILL	Required		`ALR-ACTIVITY` → `ACI-ACTIVITY`
Mxcatdef	MXCATDEF	Required		`ALR-MATRIX-CAT` → `MXC-MATRIX-CAT`

One to many (1) — child tables

Relation	Table	Rules	Condition	Field map
Acblratex	ACBLRATEX			`ALR-ACTIVITY` → `ALX-ACTIVITY`, `ALR-SUM-ACCT-CAT` → `ALX-SUM-ACCT-CAT`, `ALR-CTR-CAT-GRP` → `ALX-CTR-CAT-GRP`, `ALR-ACCT-CATEGORY` → `ALX-ACCT-CATEGORY`, `ALR-SOURCE-CODE` → `ALX-SOURCE-CODE`, `ALR-MATRIX-CAT` → `ALX-MATRIX-CAT`, `ALR-EFFECTIVE-DT` → `ALX-EFFECTIVE-DT`, → `ALX-MX-VALUE`

Programs

Updated by (6)

AC300 Activity Group Purge
BR00.1 Activity Billing
BR00.2 Billing Detail
BR03.1 Billing Category Rates
BR03.2 Units of Production Rates
BR03.3 Cost Plus Billing Labor Category Assignment

Referenced by (17)

AC190 Activity Posting
AC40.1 Journal Entry (AC only)
AC40.4 Journal Entry (AC and GL)
AC41.1 Resource Time Entry (AC only)
AC41.4 Resource Time Entry (AC and GL)
AC42.1 Subcontractor Time and Material Entry
AC54.1 Transaction Interface Adjustment
AC540 Transaction Interface
ACAC.1 Activity Management Activity Edit
BR190 Billing and Revenue Recalculation
BR20.6 Invoice Edit Detail
BR203 Billing Rate Listing
BR40.3 Transfer
BR44.1 Mass Transaction Transfer
BR46.1 Bill in Advance
BR46.2 Transfer Invoice Transaction
BR46.4 Split Transfer