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
AC112 AC113 AC121 AC123 AC128 AC130
AC135 AC145 AC147 AC160 AC165 AC169
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 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
AP520 API1.1 API2.1 BR02.1 BR02.3 BR10.1
BR121 BR123 BR142 BR145 BR151 BR152
BR153 BR154 BR155 BR156 BR157 BR165
BR19.1 BR190 BR200 BR202 BR204 BR205
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 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 IC140 IC66.1
IC83.1 EX545 IFEB.1 MA180 MA41.1 MA41.2
MA41.4 MA41.7 MA42.2 MA43.2 MA43.7 MA44.1
MA44.2 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
PO100 PO101 PO122 PO131 PO136 PO150
PO190 PO20.1 PO20.6 PO20.9 PO21.1 PO21.2
PO21.3 PO21.4 PO21.5 PO22.1 PO22.3 PO22.4
PO23.1 PO24.1 PO25.1 PO25.5 PO25.6 PO25.7
PO26.2 PO26.3 PO26.4 PO26.5 PO26.6 PO26.7
PO26.9 PO27.2 PO28.2 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 RQ10.1 RQ10.2
RQ10.4 RQ12.1 RQ13.1 RQ13.2 RQ35.1 RQ500
RQIF.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
ZW130 AC110 AC12.1 AC19.1 ACBA.1 BR01.1
BR01.2 BR03.1 BR03.2 BR03.3 BR04.1 BR05.1
BR05.2 BR05.3 BR05.4 BR05.5 BR206 BR54.2
BR54.3 BR54.4 BR96.1


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 11:10:46 2016

Home
Contact Us



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