|
ACBILLX FILE
Activity Billing Detail
This file contains billing detail from BR00.2 (Activity Billing Detail). It
includes activity, account category, billing method, rate schedule, markup
percentage, ceiling amount, tolerance amount, billable percentage and tax
information. BILLX parameters are stored at any activity/account category or
activity/summary account category level.
REFERENCED BY
AC110 AC112 AC113 AC12.1 AC121 AC123
AC128 AC135 AC145 AC160 AC165 AC169
AC190 AC191 AC197 AC198 AC200 AC203
AC206 AC207 AC210 AC213 AC218 AC220
AC225 AC240 AC246 AC261 AC265 AC290
AC295 AC298 AC346 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 BR05.2
BR05.3 BR05.4 BR05.5 BR10.1 BR121 BR123
BR142 BR145 BR151 BR152 BR153 BR154
BR155 BR156 BR157 BR165 BR18.1 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.2 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
AIX-ACTIVITY Alpha 15 BR00.2
Element: Activity Required key. This is the activity for
the detailed billing information.
AIX-ACCT-CATEGORY Alpha 5 BR00.2
Element: Account CategoRequired key. This is the account
category for the detailed billing
information.
AIX-BILLING-METHOD Numeric 1 BR00.2
Element: Billing MethodThis is the billing method for the
activity.
The values are:
1 = Time and Materials
2 = Cost Plus
3 = Units of Produciton
4 = Milestone
5 = Pass Thru
AIX-MARK-UP-PCT Signed 5.2 BR00.2
Element: Markup PercentThis is the markup percentage to use in
billing for the activity.
AIX-PERC-BILLABLE Signed 7.4 BR00.2
Element: Percent BillabPercent billable is the percentage of
total costs that are billable.
AIX-TAX-CODE Alpha 10 BR00.2
Element: Tax Code The code representing specific tax
information. This must be a valid Tax
Code.
AIX-TAX-EXEMPT-CD Alpha 1 BR00.2
Element: Tax Exempt Cd Code indicating the taxing status. The
values are:
E = Exempt
T = Taxable.
AIX-CEILING-AMT Signed 18.2 BR00.2
Element: Intl Amt The total amount that can be billed for
the activity and account category.
AIX-TOTAL-BILLED Signed 18.2 AC300 BR122
Element: Intl Amt the total cumulative amount billed for BR140 BR20.1
the bill activity and account category. BR20.2 BR20.3
This amount is used to determine advance BR20.4 BR20.5
billing and unbilled accounts receivable BR46.1 BR46.2
entries for revenue recognition and BR46.4 BR580
billing.
AIX-TOT-UNT-BILLED Signed 18.2 AC300 BR122
Element: Intl Amt The total cumulative billed for the BR140 BR20.1
activity and account category. This BR20.2 BR20.3
unit amount is used to determine BR20.4 BR20.5
advance billing and unbilled account BR46.1 BR46.2
receivable entries for revenue BR46.4 BR580
recognition and billing.
AIX-TOT-REV-AMT Signed 18.2 AC300 BR580
Element: Intl Amt The cumulative revenue amount recognized
for the activity and account category.
AIX-TOT-REV-UNIT Signed 15.2 AC300 BR580
Element: Tot Rev Unit the cumulative revenue units recognized
for the activity and account category.
AIX-TOLERANCE-AMT Signed 18.2 BR00.2
Element: Intl Amt The billing activity and account
category tolerance amount.
AIX-APPLY-TOL-AMT Signed 18.2 AC300 BR130
Element: Intl Amt The amount of tolerance applied for BR131 BR530
revenue for the billing activity and BR580
account category.
AIX-APPLY-TOL-UNIT Signed 15.2 AC300 BR580
Element: Apply Tol UnitNot used.
AIX-RATE-FLAG Alpha 1 BR00.2
Element: Rate Flag the billing rate determines if the rates
are from a resource or a table.
R = Resource
T = Table
AIX-SERVICE-LOC Numeric 4 BR00.2
Element: Service Loc A user defined code identifying a
customer's service location.
AIX-SUM-ACCT-CAT Alpha 5 BR00.2
Element: Sum Acct Cat The name of the summary account
category.
AIX-CTR-CAT-GRP Alpha 5 BR00.2
Element: Ctr Cat Grp
ACBILLX FILE INDEX
NAME KEY FIELDS DESCRIPTION / SUBSET CONDITION USED IN
AIXSET1 ACTIVITY AC10.1 AC10.5
SUM-ACCT-CAT AC110 AC112
CTR-CAT-GRP AC113 AC12.1
ACCT-CATEGORY AC120 AC121
AC123 AC128
AC135 AC145
AC160 AC165
AC169 AC190
AC191 AC197
AC198 AC200
AC203 AC206
AC207 AC210
AC213 AC218
AC220 AC225
AC240 AC246
...
ACBILLX FILE RELATIONS
ONE TO ONE RELATIONS
RELATION RELATED
NAME FILE INTEGRITY RULES / FIELD MATCH
Acacctcat ACACCTCAT Required
AIX-ACCT-CATEGORY -> AAX-ACCT-CATEGORY
ACBILLX FILE RELATIONS
ONE TO MANY RELATIONS
RELATION RELATED
NAME FILE INTEGRITY RULES / FIELD MATCH
Acblrate ACBLRATE
AIX-ACTIVITY -> ALR-ACTIVITY
AIX-SUM-ACCT-CAT -> ALR-SUM-ACCT-CAT
AIX-CTR-CAT-GRP -> ALR-CTR-CAT-GRP
AIX-ACCT-CATEGORY -> ALR-ACCT-CATEGORY
ALR-SOURCE-CODE
ALR-MATRIX-CAT
ALR-EFFECTIVE-DT
Acmilestnx ACMILESTNX
AIX-ACTIVITY -> MLX-ACTIVITY
"B" -> MLX-MILESTONE-CAT
MLX-MILESTONE
|