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 AC300 AC50.1 AC500 BR02.3 BR120
BR121 BR122 BR123 BR140 BR151 BR152
BR156 BR20.1 BR20.2 BR20.3 BR20.4 BR20.5
BR420 BR521 BRIP.1

FIELD NAME DESCRIPTION/VALID VALUES UPDATED BY
BMH-BILL-ACTIVITY
Element: Bill Activity
Alpha 15
The activity associated with the billed activity transactions.
BRIP.1
BMH-ACTIVITY-GRP
Element: Activity Grp
Alpha 15
The activity group associated with the bill activity.
BRIP.1
BMH-ACTIVITY
Element: Activity
Alpha 15
The posting activity associated with the billed transactions
BRIP.1
BMH-ACCT-CATEGORY
Element: Acct Category
Alpha 5
The life-to-date billed balances are maintained by account category for the posting activity.
BRIP.1
BMH-MATRIX-CAT
Element: Matrix Cat
Alpha 12
The attribute name assigned to the activity transactions for this balance record.
BRIP.1
BMH-MX-VALUE
Element: Mx Value
Alpha 32
The value assigned to the attribute.
BRIP.1
BMH-AMOUNT
Element: Intl Amt
Signed 18.2
This is the life to date billed balance for the specified record.
BRIP.1
BMH-UNIT
Element: Unit
Signed 15.2
This is the life to date billed unit balance for the specified record.
BRIP.1
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
BRIP.1
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
BRIP.1
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.
BRIP.1
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).
BRIP.1
BMH-CONTRACT
Element: Contract
Alpha 15
The contract associated with the posting activity maintained in Contract Parameters (BR10).
BRIP.1
BMH-BILL-WBS-CODE
Element: Bill Wbs Code
Alpha 3
The invoice group that is maintained on the activity (AC10).
BRIP.1
BMH-RESOURCE-DESC
Element: Description
Alpha 30 (Lower Case)
The description of the resource code maintained on Resource (AC03).
BRIP.1
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.
BRIP.1


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
AC300 BRIP.1
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 AC50.1
AC500 BR02.3
BR120 BR121
BR122 BR123
BR140 BR151
BR152 BR156
BR20.1 BR20.2
BR20.3 BR20.4
BR20.5 BR420
BR521


File created: Thu Jun 09 11:10:47 2016

Home
Contact Us



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