|
|
ACBILL FILE
Activity Billing
This file contains billing information from BR00.1 (Activity Billing). It
includes billing information, such as the billing method, billing rates,
billing ceilings, billable percentage, billing tolerance, tax information, as
well as total billed amounts. ACBILL parameters can be stored at any level in
the activity structure. A record is required at the contract level.
REFERENCED BY
AC110 AC112 AC113 AC12.1 AC121 AC123
AC128 AC130 AC135 AC145 AC160 AC165
AC169 AC19.1 AC190 AC191 AC197 AC198
AC20.1 AC20.2 AC20.3 AC20.4 AC20.5 AC200
AC203 AC206 AC207 AC210 AC213 AC218
AC220 AC225 AC240 AC246 AC261 AC265
AC290 AC295 AC298 AC32.1 AC346 AC37.1
AC40.1 AC40.4 AC400 AC401 AC41.1 AC41.4
AC410 AC412 AC42.1 AC420 AC421 AC440
AC45.1 AC460 AC471 AC472 AC473 AC480
AC490 AC493 AC494 AC50.1 AC500 AC527
AC54.1 AC540 AC56.1 AC560 AC90.1 AC90.2
AC90.4 AC90.6 AC90.8 AC92.1 AC92.2 AC92.4
AC92.6 AC93.4 AC93.5 AC94.1 AC94.2 AC94.4
AC94.6 AC95.1 AC95.2 AC95.4 AC95.6 ACAC.1
ACBA.1 AP211 AR237 AR239 AR257 AR296
AR32.1 BR01.1 BR01.2 BR02.1 BR02.3 BR03.1
BR03.2 BR03.3 BR04.1 BR05.1 BR05.2 BR05.3
BR05.4 BR05.5 BR10.1 BR121 BR123 BR142
BR145 BR151 BR152 BR153 BR154 BR155
BR156 BR157 BR165 BR19.1 BR190 BR200
BR202 BR204 BR205 BR206 BR210 BR212
BR215 BR220 BR245 BR251 BR252 BR253
BR265 BR300 BR40.3 BR40.4 BR400 BR405
BR41.1 BR41.4 BR42.1 BR420 BR422 BR430
BR450 BR52.2 BR52.4 BR52.5 BR54.2 BR54.3
BR54.4 BR96.1 ET175 ET540 ET542 PW110
PW510
UPDATED BY
AC10.1 AC120 AC300 AC310 BR00.1 BR120
BR122 BR130 BR131 BR140 BR20.1 BR20.2
BR20.3 BR20.4 BR20.5 BR46.1 BR46.2 BR46.4
BR521 BR530 BR580
FIELD NAME DESCRIPTION/VALID VALUES UPDATED BY
ACI-ACTIVITY Alpha 15 BR00.1
Element: Activity Required key. This is the activity for
the billing information.
ACI-MAX-BILLING Signed 18.2 BR00.1
Element: Maximum BillinThis is the maximum billing for the
contract. Total billings should not
exceed the maximum billing entered.
ACI-PERC-BILLABLE Signed 7.4 BR00.1
Element: Billable PercePercent billable is the percentage of
total costs that are billable.
ACI-BILLING-METHOD Numeric 1 AC197 AC198
Element: Billing MethodThe method used to calculate billings. BR00.1
The values are:
1 = Time and Materials
2 = Cost Plus
3 = Units of Production
4 = Milestone
5 = Pass Thru
9 = User Defined
ACI-TOTAL-BILLED Signed 18.2 AC300 BR122
Element: Intl Amt The total cumulative amount billed for BR140 BR20.1
the bill activity. This amount is used BR20.2 BR20.3
to determine advance billing and BR20.4 BR20.5
unbilled accounts receivable entries BR46.1 BR46.2
for revenue recognition and billing. BR46.4 BR580
ACI-TOT-UNT-BILLED Signed 18.2 AC300 BR122
Element: Intl Amt The total cumulative units billed for BR140 BR20.1
the activity. This unit amount is used BR20.2 BR20.3
to determine advance billing and BR20.4 BR20.5
unbilled accounts receivable entries for BR46.1 BR46.2
revenue recognition and billing. BR46.4 BR580
ACI-TOT-REV-AMT Signed 18.2 AC300 BR580
Element: Intl Amt The cumulative revenue amount recognized
for the activity.
ACI-TOT-REV-UNIT Signed 15.2 AC300 BR580
Element: Tot Rev Unit The cumulative revenue units recognized
for the activity.
ACI-TOLERANCE-AMT Signed 18.2 BR00.1
Element: Intl Amt The billing activity tolerance amount.
ACI-APPLY-TOL-AMT Signed 18.2 AC300 BR130
Element: Intl Amt The amount of tolerance applied for BR131 BR530
revenue for the billing activity. BR580
ACI-APPLY-TOL-UNIT Signed 15.2 AC300 BR580
Element: Tot Rev Unit Not used.
ACI-RATE-FLAG Alpha 1 BR00.1
Element: Rate Flag The Billing Rate determines if the rates
are from a resource or a table.
The values are:
R = Resource
T = Table
ACI-TAX-CODE Alpha 10 BR00.1
Element: Tax Code A code representing specific tax
information for the activity. This must
be a valid tax code in the Tax system.
ACI-TAX-EXEMPT-CD Alpha 1 BR00.1
Element: Tax Exempt Cd The tax exempt code, indicating whether
the activity is taxable or tax exempt.
The values are:
E = Exempt T = Taxable
ACI-SERVICE-LOC Numeric 4 BR00.1
Element: Service Loc A user defined code identifying a
customer's service location.
ACBILL FILE INDEX
NAME KEY FIELDS DESCRIPTION / SUBSET CONDITION USED IN
ACISET1 ACTIVITY AC10.1 AC10.5
AC110 AC112
AC113 AC12.1
AC120 AC121
AC123 AC128
AC130 AC135
AC145 AC160
AC165 AC169
AC19.1 AC190
AC191 AC197
AC198 AC20.1
AC20.2 AC20.3
AC20.4 AC20.5
AC200 AC203
AC206 AC207
...
ACBILL FILE RELATIONS
ONE TO ONE RELATIONS
RELATION RELATED
NAME FILE INTEGRITY RULES / FIELD MATCH
Acactivity ACACTIVITY Required
ACI-ACTIVITY -> ACV-ACTIVITY
ACBILL FILE RELATIONS
ONE TO MANY RELATIONS
RELATION RELATED
NAME FILE INTEGRITY RULES / FIELD MATCH
Acbillx ACBILLX
ACI-ACTIVITY -> AIX-ACTIVITY
AIX-SUM-ACCT-CAT
AIX-CTR-CAT-GRP
AIX-ACCT-CATEGORY
Acblactv ACBLACTV
ACI-ACTIVITY -> BLA-BILL-ACTIVITY
BLA-ACTIVITY
BLA-ACCT-CATEGORY
BLA-SUM-ACCT-CAT
BLA-CTR-CAT-GRP
Acblrate ACBLRATE
ACI-ACTIVITY -> ALR-ACTIVITY
ALR-SUM-ACCT-CAT
ALR-CTR-CAT-GRP
ALR-ACCT-CATEGORY
ALR-SOURCE-CODE
ALR-MATRIX-CAT
ALR-EFFECTIVE-DT
Acblratex ACBLRATEX
ACI-ACTIVITY -> ALX-ACTIVITY
ALX-SUM-ACCT-CAT
ALX-CTR-CAT-GRP
ALX-ACCT-CATEGORY
ALX-SOURCE-CODE
ALX-MATRIX-CAT
ALX-EFFECTIVE-DT
ALX-MX-VALUE
Acceiling ACCEILING
ACI-ACTIVITY -> CEH-ACTIVITY
CEH-ACCT-CATEGORY
CEH-SUM-ACCT-CAT
CEH-CTR-CAT-GRP
CEH-MATRIX-CAT
Acceilingx ACCEILINGX
ACI-ACTIVITY -> CEX-ACTIVITY
CEX-ACCT-CATEGORY
CEX-SUM-ACCT-CAT
CEX-CTR-CAT-GRP
CEX-MATRIX-CAT
CEX-MX-VALUE
Acmilestn ACMILESTN
ACI-ACTIVITY -> MLS-ACTIVITY
MLS-MILESTONE-CAT
Acmilestnx ACMILESTNX
ACI-ACTIVITY -> MLX-ACTIVITY
"B" -> MLX-MILESTONE-CAT
MLX-MILESTONE
H Acblrate ACBLRATE
ACI-ACTIVITY -> ALR-ACTIVITY
ALR-SUM-ACCT-CAT
ALR-CTR-CAT-GRP
ALR-ACCT-CATEGORY
ALR-SOURCE-CODE
ALR-MATRIX-CAT
ALR-EFFECTIVE-DT
U Acblrate ACBLRATE
ACI-ACTIVITY -> ALR-ACTIVITY
ALR-SUM-ACCT-CAT
ALR-CTR-CAT-GRP
ALR-ACCT-CATEGORY
ALR-SOURCE-CODE
ALR-MATRIX-CAT
ALR-EFFECTIVE-DT
|
