ACBILL

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 AC147 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 AC247
AC261 AC265 AC290 AC295 AC297 AC298
AC310 AC311 AC32.1 AC346 AC37.1 AC40.1
AC40.4 AC400 AC401 AC41.1 AC41.4 AC410
AC412 AC42.1 AC420 AC421 AC440 AC45.1
AC45.4 AC46.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 AP125 AP126 AP131 AP170
AP193 AP20.1 AP20.2 AP20.3 AP20.4 AP20.5
AP20.7 AP21.1 AP211 AP23.1 AP25.1 AP25.2
AP26.1 AP27.1 AP30.2 AP30.4 AP510 AP520
API1.1 API2.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
BR43.1 BR430 BR44.1 BR450 BR52.2 BR52.4
BR52.5 BR54.2 BR54.3 BR54.4 BR96.1 CB10.1
CB15.1 CB15.2 CB150 CB191 CB20.1 CB30.1
CB45.1 CB46.1 CB500 CB543 CB544 CB55.1
CB554 CX100 CX20.1 CX20.2 CX20.4 CX20.5
CX220 CX30.1 CX300 CX506 CXCP.1 EE11.1
EE135 EE20.3 EE35.1 EE35.2 EE520 GL146
GL165 GL170 GL197 GL299 GL40.1 GL40.2
GL40.3 GL40.7 GL40.8 GL44.1 GL45.1 GL70.1
GL70.2 GL70.3 GL70.5 GL70.6 GL75.1 GL76.1
DR100 IC12.1 IC140 IC141 IC142 IC145
IC243 IC330 IC64.1 IC64.2 IC64.3 IC64.4
IC64.5 IC64.6 IC64.7 IC64.8 IC64.9 IC66.1
IC83.1 EX545 IFEB.1 MA180 MA278 MA41.1
MA41.2 MA41.4 MA41.7 MA42.2 MA43.2 MA43.7
MA44.1 MA44.2 MA53.1 MA530 MA531 MA60.2
MA60.3 MA60.5 MA61.1 MA65.1 MA66.2 MA67.2
MA67.3 MA68.2 MA68.3 MA68.5 MA70.1 MA75.1
MA80.1 MAI1.1 PD10.1 PD10.2 PD130 PD20.1
PD20.2 PD20.3 PD570 PO04.1 PO04.2 PO10.1
PO10.2 PO100 PO101 PO115 PO120 PO122
PO131 PO132 PO136 PO15.1 PO15.2 PO15.4
PO150 PO17.1 PO190 PO20.1 PO20.6 PO20.9
PO204 PO21.1 PO21.2 PO21.3 PO21.4 PO21.5
PO22.1 PO22.3 PO22.4 PO220 PO222 PO224
PO225 PO229 PO23.1 PO230 PO234 PO24.1
PO25.1 PO25.5 PO25.6 PO25.7 PO251 PO26.2
PO26.3 PO26.4 PO26.5 PO26.6 PO26.7 PO26.9
PO27.2 PO27.3 PO27.4 PO275 PO276 PO277
PO28.2 PO280 PO29.1 PO30.1 PO30.2 PO30.3
PO30.4 PO300 PO31.1 PO31.2 PO32.2 PO32.4
PO33.1 PO34.1 PO35.1 PO36.1 PO36.2 PO38.1
PO39.1 PO39.2 PO44.1 PO50.1 PO52.1 PO520
PO536 PO54.5 POCP.1 POI3.1 POID.1 POIG.1
POII.1 POIJ.1 POIK.1 RQ01.1 RQ10.1 RQ10.2
RQ10.3 RQ10.4 RQ10.5 RQ11.1 RQ12.1 RQ13.1
RQ13.2 RQ35.1 RQ44.1 RQ500 RQ810 RQIB.1
RQIF.1 RQII.1 RQIJ.1 WH130 WH132 WH190
WH20.2 WH20.7 WH222 WH30.1 WH30.2 WH30.3
WH30.4 WH31.1 WH31.2 WH31.3 WH31.4 WH32.1
WH32.2 WH32.3 WH32.4 WH32.5 WH33.1 WH33.2
WH33.3 WH33.4 WH33.5 WH33.6 WH33.8 WH33.9
WH34.1 WH34.2 WH34.3 WH34.4 WH40.1 WH40.2
WH520 WH830


UPDATED BY
AC10.1 AC120 AC300 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 BRIP.1

FIELD NAME DESCRIPTION/VALID VALUES UPDATED BY
ACI-ACTIVITY
Element: Activity
Alpha 15
Required key. This is the activity for the billing information.
BR00.1
ACI-MAX-BILLING
Element: Maximum Billing
Signed 18.2
This is the maximum billing for the contract. Total billings should not exceed the maximum billing entered.
BR00.1
ACI-PERC-BILLABLE
Element: Billable Percentage
Signed 7.4
Percent billable is the percentage of total costs that are billable.
BR00.1
ACI-BILLING-METHOD
Element: Billing Method
Numeric 1
The method used to calculate billings. The values are: 1 = Time and Materials 2 = Cost Plus 3 = Units of Production 4 = Milestone 5 = Pass Thru 9 = User Defined
AC197 AC198
BR00.1
ACI-TOTAL-BILLED
Element: Intl Amt
Signed 18.2
The total cumulative amount billed for the bill activity. This amount is used to determine advance billing and unbilled accounts receivable entries for revenue recognition and billing.
AC300 BR122
BR140 BR20.1
BR20.2 BR20.3
BR20.4 BR20.5
BR46.1 BR46.2
BR46.4 BR580
BRIP.1
ACI-TOT-UNT-BILLED
Element: Intl Amt
Signed 18.2
The total cumulative units billed for the activity. This unit amount is used to determine advance billing and unbilled accounts receivable entries for revenue recognition and billing.
AC300 BR122
BR140 BR20.1
BR20.2 BR20.3
BR20.4 BR20.5
BR46.1 BR46.2
BR46.4 BR580
BRIP.1
ACI-TOT-REV-AMT
Element: Intl Amt
Signed 18.2
The cumulative revenue amount recognized for the activity.
AC300 BR580
ACI-TOT-REV-UNIT
Element: Tot Rev Unit
Signed 15.2
The cumulative revenue units recognized for the activity.
AC300 BR580
ACI-TOLERANCE-AMT
Element: Intl Amt
Signed 18.2
The billing activity tolerance amount.
BR00.1
ACI-APPLY-TOL-AMT
Element: Intl Amt
Signed 18.2
The amount of tolerance applied for revenue for the billing activity.
AC300 BR130
BR131 BR530
BR580
ACI-APPLY-TOL-UNIT
Element: Tot Rev Unit
Signed 15.2
Not used.
AC300 BR580
ACI-RATE-FLAG
Element: Rate Flag
Alpha 1
The Billing Rate determines if the rates are from a resource or a table. The values are: R = Resource T = Table
BR00.1
ACI-TAX-CODE
Element: Tax Code
Alpha 10
A code representing specific tax information for the activity. This must be a valid tax code in the Tax system.
BR00.1
ACI-TAX-EXEMPT-CD
Element: Tax Exempt Cd
Alpha 1
The tax exempt code, indicating whether the activity is taxable or tax exempt. The values are: E = Exempt T = Taxable
BR00.1
ACI-SERVICE-LOC
Element: Service Loc
Numeric 4
A user defined code identifying a customer's service location.
BR00.1


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 AC147
AC160 AC165
AC169 AC19.1
AC190 AC191
AC197 AC198
AC20.1 AC20.2
AC20.3 AC20.4
AC20.5 AC200
AC203 AC206


ACBILL FILE RELATIONS


ONE TO ONE RELATIONS

RELATION
NAME
RELATED FILE INTEGRITY RULES / FIELD MATCH
Acactivity ACACTIVITY Required
ACI-ACTIVITY->ACV-ACTIVITY


ACBILL FILE RELATIONS


ONE TO MANY RELATIONS

RELATION
NAME
RELATED FILE INTEGRITY RULES / FIELD MATCH
Acbillx ACBILLX
ACI-ACTIVITY->AIX-ACTIVITY
  AIX-SUM-ACCT-CAT
  AIX-CTR-CAT-GRP
  AIX-ACCT-CATEGORY
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


File created: Thu Jun 09 02:10:57 2016

Home
Contact Us



All trademarks and registered trademarks are the property of their respective owners.