|
|
ACBLACTV FILE
This file contains billing information for the posting activities associated
with a billing activity established in Activity Billing ( BR00.1) and Billing
Detail (BR00.2). It includes a record for each posting activity. If a detail
record is established, a record exists for each account category or summary
account category for the posting activity.
The primary purpose of this file is to determine the billing activity for a
posting level activity. This file is updated by BR00 and read by DI550
(Databasics Interface Time and Expense Entry Load).
UPDATED BY
AC10.1 AC120 AC300 AC310 AC500 BR00.1
BR00.2
FIELD NAME DESCRIPTION/VALID VALUES UPDATED BY
BLA-BILL-ACTIVITY Alpha 15 AC10.1 AC120
Element: Bill Activity The Billing activity maintained in AC500 BR00.1
Activity Billing (BR00.1). BR00.2
BLA-ACTIVITY Alpha 15 AC10.1 AC500
Element: Activity The posting activities associated with BR00.1 BR00.2
the activity maintained in Activity
Billing (BR00.1). If a detail billing
exists in Billing Detail (BR00.2), a
separate record is created for the
posting activity and account category or
summary acct category.
BLA-ACCT-CATEGORY Alpha 5 AC10.1 AC500
Element: Account CategoThe account category maintained in the BR00.1 BR00.2
Billing Detail (BR00.2) for the Billing
Activity. A separate record will exist
for each account category.
BLA-LEVEL-DEPTH Numeric 1 AC10.1 AC500
Element: Level Depth The variable level depth of the billing BR00.1 BR00.2
Activity. The variable level is
established in Activity (AC10).
BLA-BILLING-METHOD Numeric 1 AC10.1 AC120
Element: Billing MethodThe method used to calculate billing. AC500 BR00.1
The billing method is maintained in BR00.2
Activity Billing (BR00.1) or Billing
Detail (BR00.2).
The values are:
1 = Time and Materials
2 = Cost Plus
3 = Units of Production
4 = Milestone
5 = Pass Thru
9 = User Defined
BLA-SUM-ACCT-CAT Alpha 5 AC10.1 AC500
Element: Sum Acct Cat The summary account category maintained BR00.1 BR00.2
in the Billing Detail (BR00.2) for the
Billing Activity. A separate record
will exist for each summary account
category.
BLA-CTR-CAT-GRP Alpha 5 AC10.1 AC500
Element: Ctr Cat Grp BR00.1 BR00.2
ACBLACTV FILE INDEX
NAME KEY FIELDS DESCRIPTION / SUBSET CONDITION USED IN
BLASET1 BILL-ACTIVITY AC10.1 AC120
ACTIVITY BR00.1 BR00.2
ACCT-CATEGORY
SUM-ACCT-CAT
CTR-CAT-GRP
BLASET2 ACTIVITY AC10.1 AC120
ACCT-CATEGORY AC300 AC310
CTR-CAT-GRP BR00.1 BR00.2
SUM-ACCT-CAT
BILL-ACTIVITY
BLASET3 BILL-ACTIVITY BR00.1 BR00.2
SUM-ACCT-CAT
ACCT-CATEGORY
CTR-CAT-GRP
ACTIVITY
ACBLACTV FILE RELATIONS
ONE TO ONE RELATIONS
RELATION RELATED
NAME FILE INTEGRITY RULES / FIELD MATCH
Acactgrp ACACTGRP Required
ACV-ACTIVITY-GRP -> AGP-ACTIVITY-GRP
Acactivity ACACTIVITY Required
BLA-ACTIVITY -> ACV-ACTIVITY
Acbill ACBILL Required
BLA-BILL-ACTIVITY -> ACI-ACTIVITY
|
