|
|
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
AC135 AC145 AC160 AC165 AC190 AC191
AC197 AC198 AC200 AC203 AC206 AC207
AC210 AC213 AC218 AC220 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 AC54.1
AC540 ACAC.1 ACBA.1 AP211 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 BR142
BR145 BR165 BR18.1 BR19.1 BR190 BR200
BR202 BR204 BR205 BR206 BR210 BR212
BR215 BR220 BR245 BR265 BR300 BR40.3
BR40.4 BR400 BR405 BR41.1 BR41.4 BR420
BR430 BR450 BR96.1
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 valid Tax
Code.
AIX-TAX-EXEMPT-CD Alpha 1 BR00.2
Element: Tax Exempt CodCode 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 AC135
AC145 AC160
AC165 AC190
AC191 AC197
AC198 AC200
AC203 AC206
AC207 AC210
AC213 AC218
AC220 AC240
AC246 AC261
AC265 AC290
...
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
|
