ACBLMAST

Activity Billing Master

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.
UPDATED BY
AC10.1

FIELD NAME DESCRIPTION/VALID VALUES UPDATED BY
BMH-BILL-ACTIVITY
Element: Bill Activity
Alpha 15
The activity associated with the billed activity transactions.
BMH-ACTIVITY-GRP
Element: Activity Grp
Alpha 15
The activity group associated with the bill activity.
BMH-ACTIVITY
Element: Activity
Alpha 15
The posting activity associated with the billed transactions
BMH-ACCT-CATEGORY
Element: Acct Category
Alpha 5
The life-to-date billed balances are maintained by account category for the posting activity.
BMH-MATRIX-CAT
Element: Matrix Cat
Alpha 12
The attribute name assigned to the activity transactions for this balance record.
BMH-MX-VALUE
Element: Mx Value
Alpha 32
The value assigned to the attribute.
BMH-AMOUNT
Element: Intl Amt
Signed 18.2
This is the life to date billed balance for the specified record.
BMH-UNIT
Element: Unit
Signed 15.2
This is the life to date billed unit balance for the specified record.
BMH-LINE-TYPE
Element: Line Type
Alpha 1
The 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
BMH-RESOURCE-TYPE
Element: Resource Type
Alpha 1
The life to date balance record is stored by the type of resource. Valid values include: P - AC Person Q - Equipment E - Employee V - Vendor
BMH-RESOURCE-COMP
Element: Company
Numeric 4
Identifies 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.
BMH-RESOURCE-CODE
Element: Resource Code
Alpha 10
The code identifying the resource assigned to the activity or activity group associated with the balance record. The code is maintained on Resource (AC03).
BMH-CONTRACT
Element: Contract
Alpha 15
The contract associated with the posting activity maintained in Contract Parameters (BR10).
BMH-BILL-WBS-CODE
Element: Bill Wbs Code
Alpha 3
The invoice group that is maintained on the activity (AC10).
BMH-RESOURCE-DESC
Element: Description
Alpha 30 (Lower Case)
The description of the resource code maintained on Resource (AC03).
BMH-FEE-TAX-CODE
Element: Fee Tax Code
Alpha 10
This field has a double use. It will either be a tax code or a fee code.


ACBLMAST FILE INDEX

NAME KEY FIELDS DESCRIPTION / SUBSET CONDITION USED IN
BMHSET1 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
BMHSET2 CONTRACT
BILL-WBS-CODE
BILL-ACTIVITY
ACTIVITY-GRP
ACTIVITY
ACCT-CATEGORY
MATRIX-CAT
RESOURCE-TYPE
RESOURCE-COMP
RESOURCE-CODE
MX-VALUE
FEE-TAX-CODE
LINE-TYPE
KeyChange
AC10.1


File created: Wed Jun 08 20:48:19 2016

Home
Contact Us



All trademarks and registered trademarks are the property of their respective owners.