|
|
ACBLMAST FILE
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.
REFERENCED BY
AC10.1 AC50.1 AC500 BR02.3 BR120 BR121
BR122 BR123 BR151 BR152 BR156 BR20.1
BR20.2 BR20.3 BR20.4 BR20.5 BR420 BR521
PW110 PW510
UPDATED BY
AC300 AC310 BR140 BRIP.1
FIELD NAME DESCRIPTION/VALID VALUES UPDATED BY
BMH-BILL-ACTIVITY Alpha 15 BRIP.1
Element: Bill Activity The activity associated with the billed
activity transactions.
BMH-ACTIVITY-GRP Alpha 15 BRIP.1
Element: Activity Grp The activity group associated with the
bill activity.
BMH-ACTIVITY Alpha 15 BRIP.1
Element: Activity The posting activity associated with the
billed transactions
BMH-ACCT-CATEGORY Alpha 5 BRIP.1
Element: Acct Category The life-to-date billed balances are
maintained by account category for the
posting activity.
BMH-MATRIX-CAT Alpha 12 BRIP.1
Element: Matrix Cat The attribute name assigned to the
activity transactions for this balance
record.
BMH-MX-VALUE Alpha 32 BRIP.1
Element: Mx Value The value assigned to the attribute.
BMH-AMOUNT Signed 18.2 BRIP.1
Element: Intl Amt This is the life to date billed balance
for the specified record.
BMH-UNIT Signed 15.2 BRIP.1
Element: Unit This is the life to date billed unit
balance for the specified record.
BMH-LINE-TYPE Alpha 1 BRIP.1
Element: Line Type 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 Alpha 1 BRIP.1
Element: Resource Type 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 Numeric 4 BRIP.1
Element: Company 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 Alpha 10 BRIP.1
Element: Resource Code 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 Alpha 15 BRIP.1
Element: Contract The contract associated with the posting
activity maintained in Contract
Parameters (BR10).
BMH-BILL-WBS-CODE Alpha 3 BRIP.1
Element: Bill Wbs Code The invoice group that is maintained on
the activity (AC10).
BMH-RESOURCE-DESC Alpha 30 (Lower Case) BRIP.1
Element: Description The description of the resource code
maintained on Resource (AC03).
BMH-FEE-TAX-CODE Alpha 10 BRIP.1
Element: Fee Tax Code 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 AC300 AC310
BILL-WBS-CODE BRIP.1
ACTIVITY-GRP
ACTIVITY
ACCT-CATEGORY
MATRIX-CAT
RESOURCE-TYPE
RESOURCE-COMP
RESOURCE-CODE
MX-VALUE
FEE-TAX-CODE
LINE-TYPE
BMHSET2 CONTRACT KeyChange AC10.1 AC50.1
BILL-WBS-CODE AC500 BR02.3
BILL-ACTIVITY BR120 BR121
ACTIVITY-GRP BR122 BR123
ACTIVITY BR140 BR151
ACCT-CATEGORY BR152 BR156
MATRIX-CAT BR20.1 BR20.2
RESOURCE-TYPE BR20.3 BR20.4
RESOURCE-COMP BR20.5 BR420
RESOURCE-CODE BR521 PW110
MX-VALUE PW510
FEE-TAX-CODE
LINE-TYPE
|
