ACBLMAST – Activity Billing Balances

System
AC Billing Revenue (BR)
Prefix
BMH
Primary key
BILL-ACTIVITY, BILL-WBS-CODE, ACTIVITY-GRP, ACTIVITY, ACCT-CATEGORY, MATRIX-CAT, RESOURCE-TYPE, RESOURCE-COMP, RESOURCE-CODE, MX-VALUE, FEE-TAX-CODE, LINE-TYPE
Fields
16
Updated by
3 programs
Referenced by
18 programs

ACBLMAST is the Activity Billing Balances table in Lawson AC Billing Revenue (prefix BMH). It is indexed by BILL-ACTIVITY, BILL-WBS-CODE, ACTIVITY-GRP, ACTIVITY, ACCT-CATEGORY, MATRIX-CAT, RESOURCE-TYPE, RESOURCE-COMP, RESOURCE-CODE, MX-VALUE, FEE-TAX-CODE, LINE-TYPE (BMHSET1); alternate indexes: BMHSET2. It is updated by AC300, BR140 and BRIP.1 and referenced by AC10.1, AC50.1, AC500, BR02.3, BR120, BR121, BR122, BR123 and 10 more. The table has 16 fields, 2 indexes and 0 documented relations.

About ACBLMAST

The Activity Billing Master file contains the life to date billing balances for the billing activities within an activity group. The Billing LTD Balances flag must = Yes on the Activity Group to create the records. This file is updated by BR20, BR120, BR121, BR21 and BRIP.

Fields (16)

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

Field / columnTypeDescription & valuesUpdated by
BMH-BILL-ACTIVITY PK
BILL_ACTIVITY		Alpha 15The activity associated with the billed activity transactions.BRIP.1
BMH-ACTIVITY-GRP PK
ACTIVITY_GRP		Alpha 15The activity group associated with the bill activity.BRIP.1
BMH-ACTIVITY PK
ACTIVITY		Alpha 15The posting activity associated with the billed transactionsBRIP.1
BMH-ACCT-CATEGORY PK
ACCT_CATEGORY		Alpha 5The life-to-date billed balances are maintained by account category for the posting activity.BRIP.1
BMH-MATRIX-CAT PK
MATRIX_CAT		Alpha 12The attribute name assigned to the activity transactions for this balance record.BRIP.1
BMH-MX-VALUE PK
MX_VALUE		Alpha 32The value assigned to the attribute.BRIP.1
BMH-AMOUNT
AMOUNT		Signed 18.2This is the life to date billed balance for the specified record.BRIP.1
BMH-UNIT
UNIT		Signed 15.2This is the life to date billed unit balance for the specified record.BRIP.1
BMH-LINE-TYPE PK
LINE_TYPE		Alpha 1The life to date balance is stored by type. The values are:
  • A Transaction
  • B Milestone
  • C Tax
  • F Fee
  • G Retention on Fee
  • H Overage on Fee
  • I Billed Retention on Fee
  • J Billed Overage on Fee
  • K Overage
  • L Billed Overage
  • M Retention
  • N Billed Retention
  • O Retainer
  • P Billed Retainer
  • A Transaction
  • B Milestone
  • C Tax
  • F Fee
  • G Retention on Fee
  • H Overage on Fee
  • I Billed Retention on Fee
  • J Billed Overage on Fee
  • K Overage
  • L Billed Overage
  • M Retention
  • N Billed Retention
  • O Retainer
  • P Billed Retainer
BRIP.1
BMH-RESOURCE-TYPE PK
RESOURCE_TYPE		Alpha 1The life to date balance record is stored by the type of resource. Valid values include: P - AC Person Q - Equipment E - Employee V - VendorBRIP.1
BMH-RESOURCE-COMP PK
RESOURCE_COMP		Numeric 4Identifies the AP company if the resource type = V. Identifies the HR company if the resource type = E. It is blank for type A, P or Q resources.BRIP.1
BMH-RESOURCE-CODE PK
RESOURCE_CODE		Alpha 10The code identifying the resource assigned to the activity or activity group associated with the balance record. The code is maintained on Resource (AC03).BRIP.1
BMH-CONTRACT
CONTRACT		Alpha 15The contract associated with the posting activity maintained in Contract Parameters (BR10).BRIP.1
BMH-BILL-WBS-CODE PK
BILL_WBS_CODE		Alpha 3The invoice group that is maintained on the activity (AC10).BRIP.1
BMH-RESOURCE-DESC
RESOURCE_DESC		Alpha 30 (Lower Case)The description of the resource code maintained on Resource (AC03).BRIP.1
BMH-FEE-TAX-CODE PK
FEE_TAX_CODE		Alpha 10This field has a double use. It will either be a tax code or a fee code.BRIP.1

Indexes (2)

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

IndexKeysFlagsConditionUsed in
BMHSET1BILL-ACTIVITY, BILL-WBS-CODE, ACTIVITY-GRP, ACTIVITY, ACCT-CATEGORY, MATRIX-CAT, RESOURCE-TYPE, RESOURCE-COMP, RESOURCE-CODE, MX-VALUE, FEE-TAX-CODE, LINE-TYPEPrimaryAC300, BRIP.1
BMHSET2CONTRACT, BILL-WBS-CODE, BILL-ACTIVITY, ACTIVITY-GRP, ACTIVITY, ACCT-CATEGORY, MATRIX-CAT, RESOURCE-TYPE, RESOURCE-COMP, RESOURCE-CODE, MX-VALUE, FEE-TAX-CODE, LINE-TYPEKeyChangeAC10.1, AC50.1, AC500, BR02.3, BR120, BR121, BR122, BR123 +11 more

Programs

Updated by (3)

Referenced by (18)