Activity Billing Balances
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 |
AC300 | BR140 | 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. |
|
||
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. |
|
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 |
|
|
All trademarks and registered trademarks are the property of their
respective owners.