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
AC200 AC210 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 CB10.1 CB15.1 CB15.2 CB150
CB191 CB20.1 CB30.1 CB45.1 CB46.1 CB500
CB543 CB544 CB55.1 CB554 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 EX545 IFEB.1
MA41.1 MA41.2 MA41.4 MA41.7 MA43.1 MA43.2
MA43.3 MA43.4 MA43.6 MA43.7 MAI1.1 PO136
PO190 PO300 PO520 POCP.1 POI3.1 POIG.1
POII.1 POIJ.1


UPDATED BY
AC10.1

FIELD NAME DESCRIPTION/VALID VALUES UPDATED BY
ACI-ACTIVITY
Element: Activity
Alpha 15
Required key. This is the activity for the billing information.
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.
ACI-PERC-BILLABLE
Element: Billable Percentage
Signed 7.4
Percent billable is the percentage of total costs that are billable.
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
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.
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.
ACI-TOT-REV-AMT
Element: Intl Amt
Signed 18.2
The cumulative revenue amount recognized for the activity.
ACI-TOT-REV-UNIT
Element: Tot Rev Unit
Signed 15.2
The cumulative revenue units recognized for the activity.
ACI-TOLERANCE-AMT
Element: Intl Amt
Signed 18.2
The billing activity tolerance amount.
ACI-APPLY-TOL-AMT
Element: Intl Amt
Signed 18.2
The amount of tolerance applied for revenue for the billing activity.
ACI-APPLY-TOL-UNIT
Element: Tot Rev Unit
Signed 15.2
Not used.
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
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.
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
ACI-SERVICE-LOC
Element: Service Loc
Numeric 4
A user defined code identifying a customer's service location.


ACBILL FILE INDEX

NAME KEY FIELDS DESCRIPTION / SUBSET CONDITION USED IN
ACISET1 ACTIVITY
...
AC10.1 AC10.5
AC200 AC210
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
CB10.1 CB15.1


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: Wed Jun 08 20:48:19 2016

Home
Contact Us



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