ACBLRATEX – Activity Billing Rates Detail

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

ACBLRATEX is the Activity Billing Rates Detail table in Lawson AC Billing Revenue (prefix ALX). It is indexed by ACTIVITY, SUM-ACCT-CAT, CTR-CAT-GRP, ACCT-CATEGORY, SOURCE-CODE, MATRIX-CAT, EFFECTIVE-DT, MX-VALUE (ALXSET1); alternate indexes: ALXSET2 and ALXSET3. It is related 1:1 to ACACTGRP, ACACTIVITY, ACBILL, ACBLRATE and MXCATDEF and 1:M to GLSCCAT. 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 10 fields, 3 indexes and 6 documented relations.

About ACBLRATEX

This file contains detailed billing rate information from the BR03 forms. It includes rate schedule, attribute and attribute value, effective date, and billing rate. You can run a listing of billing rates by runnning BR203 (Billing Rate Listing).

Fields (10)

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

Field / columnTypeDescription & valuesUpdated by
ALX-ACTIVITY PK
ACTIVITY		Alpha 15The activity established in the Billing Category Rates (BR03.1) or Units of Production Rates (BR03.2).BR03.1, BR03.2, BR03.3
ALX-ACCT-CATEGORY PK
ACCT_CATEGORY		Alpha 5The account category associated with the activity 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. combination of both used for reporting and inquiries for activities in the Activity Management system. All transactions are posted to an account category within an activity. You can assign a specific General Ledger account or range of accounts (company, accounting unit, account, and subaccount) that make up the transactions posted to an account category using AC07.1 (Account Assignment). Period-to-date, year-to-date, and life-to-date balances are maintained by account category for activities. Account categories must be assigned to activities before you do any budgeting or transaction processing.BR03.1, BR03.2, BR03.3
ALX-SOURCE-CODE PK
SOURCE_CODE		Alpha 2The Source Code is established in 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
ALX-MATRIX-CAT PK
MATRIX_CAT		Alpha 12A billing rate attribute can 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.BR03.1, BR03.2, BR03.3
ALX-DESCRIPTION
DESCRIPTION		Alpha 30 (Lower Case)The billing category description which is associated with the category selected.BR03.1, BR03.3
ALX-MX-VALUE PK
MX_VALUE		Alpha 32Key field. This field is required if an attribute is defined. The value for this field is UOM if the Unit Type field in the Activity Billing Rate Header file is Units of Production.BR03.1, BR03.2, BR03.3
ALX-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 (B03.2).BR03.1, BR03.2, BR03.3
ALX-BILL-RATE
BILL_RATE		Signed 13.4The hourly rate at which to bill this value for the attribute.BR03.1, BR03.2, BR03.3
ALX-SUM-ACCT-CAT PK
SUM_ACCT_CAT		Alpha 5The 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
ALX-CTR-CAT-GRP PK
CTR_CAT_GRP		Alpha 5—BR03.1, BR03.2, BR03.3

Indexes (3)

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

IndexKeysFlagsConditionUsed in
ALXSET1ACTIVITY, SUM-ACCT-CAT, CTR-CAT-GRP, ACCT-CATEGORY, SOURCE-CODE, MATRIX-CAT, EFFECTIVE-DT*, MX-VALUEPrimaryAC190, AC300, AC40.1, AC40.4, AC41.1, AC41.4, AC42.1, AC54.1 +16 more
ALXSET2ACTIVITY, SUM-ACCT-CAT, CTR-CAT-GRP, ACCT-CATEGORY, SOURCE-CODE, MATRIX-CAT, MX-VALUE, EFFECTIVE-DT*AC190, AC40.1, AC40.4, AC41.1, AC41.4, AC42.1, AC54.1, AC540 +8 more
ALXSET3MATRIX-CAT, ACTIVITY, SUM-ACCT-CAT, CTR-CAT-GRP, ACCT-CATEGORY, SOURCE-CODE, EFFECTIVE-DT*, MX-VALUE—

Relations

One to one (5) — lookups and parents

RelationTableRulesConditionField map
AcactgrpACACTGRPRequiredACV-ACTIVITY-GRP → AGP-ACTIVITY-GRP (AGPSET1)
AcactivityACACTIVITYRequiredALX-ACTIVITY → ACV-ACTIVITY
AcbillACBILLRequiredALX-ACTIVITY → ACI-ACTIVITY
AcblrateACBLRATERequiredALX-ACTIVITY → ALR-ACTIVITY, ALX-SUM-ACCT-CAT → ALR-SUM-ACCT-CAT, ALX-CTR-CAT-GRP → ALR-CTR-CAT-GRP, ALX-ACCT-CATEGORY → ALR-ACCT-CATEGORY, ALX-SOURCE-CODE → ALR-SOURCE-CODE, ALX-MATRIX-CAT → ALR-MATRIX-CAT, ALX-EFFECTIVE-DT → ALR-EFFECTIVE-DT
MxcatdefMXCATDEFRequiredALX-MATRIX-CAT → MXC-MATRIX-CAT

One to many (1) — child tables

RelationTableRulesConditionField map
Glsccat AdGLSCCATALX-MATRIX-CAT → GSC-MATRIX-CAT, "AD" → GSC-SOURCE-CODE, → GSC-SEQ-NBR

Programs

Updated by (6)

Referenced by (17)