ACBILLX

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 AC147 AC160 AC165
AC169 AC190 AC191 AC197 AC198 AC200
AC203 AC206 AC207 AC210 AC213 AC218
AC220 AC225 AC240 AC246 AC247 AC261
AC265 AC290 AC295 AC297 AC298 AC310
AC311 AC346 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
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 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.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 BRIP.1

FIELD NAME DESCRIPTION/VALID VALUES UPDATED BY
AIX-ACTIVITY
Element: Activity		Alpha 15
Required key. This is the activity for the detailed billing information.
BR00.2
AIX-ACCT-CATEGORY
Element: Account Category		Alpha 5
Required key. This is the account category for the detailed billing information.
BR00.2
AIX-BILLING-METHOD
Element: Billing Method		Numeric 1
This 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
BR00.2
AIX-MARK-UP-PCT
Element: Markup Percent		Signed 5.2
This is the markup percentage to use in billing for the activity.
BR00.2
AIX-PERC-BILLABLE
Element: Percent Billable		Signed 7.4
Percent billable is the percentage of total costs that are billable.
BR00.2
AIX-TAX-CODE
Element: Tax Code		Alpha 10
The code representing specific tax information. This must be a valid Tax Code.
BR00.2
AIX-TAX-EXEMPT-CD
Element: Tax Exempt Cd		Alpha 1
Code indicating the taxing status. The values are: E = Exempt T = Taxable.
BR00.2
AIX-CEILING-AMT
Element: Intl Amt		Signed 18.2
The total amount that can be billed for the activity and account category.
BR00.2
AIX-TOTAL-BILLED
Element: Intl Amt		Signed 18.2
the total cumulative amount billed for the bill activity and account category. 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
AIX-TOT-UNT-BILLED
Element: Intl Amt		Signed 18.2
The total cumulative billed for the activity and account category. This unit amount is used to determine advance billing and unbilled account 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
AIX-TOT-REV-AMT
Element: Intl Amt		Signed 18.2
The cumulative revenue amount recognized for the activity and account category.
AC300 BR580
AIX-TOT-REV-UNIT
Element: Tot Rev Unit		Signed 15.2
the cumulative revenue units recognized for the activity and account category.
AC300 BR580
AIX-TOLERANCE-AMT
Element: Intl Amt		Signed 18.2
The billing activity and account category tolerance amount.
BR00.2
AIX-APPLY-TOL-AMT
Element: Intl Amt		Signed 18.2
The amount of tolerance applied for revenue for the billing activity and account category.
AC300 BR130
BR131 BR530
BR580
AIX-APPLY-TOL-UNIT
Element: Apply Tol Unit		Signed 15.2
Not used.
AC300 BR580
AIX-RATE-FLAG
Element: Rate Flag		Alpha 1
the billing rate determines if the rates are from a resource or a table. R = Resource T = Table
BR00.2
AIX-SERVICE-LOC
Element: Service Loc		Numeric 4
A user defined code identifying a customer's service location.
BR00.2
AIX-SUM-ACCT-CAT
Element: Sum Acct Cat		Alpha 5
The name of the summary account category.
BR00.2
AIX-CTR-CAT-GRP
Element: Ctr Cat Grp		Alpha 5
BR00.2


ACBILLX FILE INDEX

NAME KEY FIELDS DESCRIPTION / SUBSET CONDITION USED IN
AIXSET1 ACTIVITY
SUM-ACCT-CAT
CTR-CAT-GRP
ACCT-CATEGORY
...
AC10.1 AC10.5
AC110 AC112
AC113 AC12.1
AC120 AC121
AC123 AC128
AC135 AC145
AC147 AC160
AC165 AC169
AC190 AC191
AC197 AC198
AC200 AC203
AC206 AC207
AC210 AC213
AC218 AC220
AC225 AC240


ACBILLX FILE RELATIONS


ONE TO ONE RELATIONS

RELATION
NAME		 RELATED FILE INTEGRITY RULES / FIELD MATCH
Acacctcat ACACCTCAT Required
AIX-ACCT-CATEGORY->AAX-ACCT-CATEGORY


ACBILLX FILE RELATIONS


ONE TO MANY RELATIONS

RELATION
NAME		 RELATED 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

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

Home
Contact Us



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