ACBILL – Activity Billing

System
AC Billing Revenue (BR)
Prefix
ACI
Primary key
ACTIVITY
Fields
15
Updated by
21 programs
Referenced by
434 programs

ACBILL is the Activity Billing table in Lawson AC Billing Revenue (prefix ACI). It is indexed by ACTIVITY (ACISET1). It is related 1:1 to ACACTIVITY and 1:M to ACBILLX, ACBLRATE, ACBLRATEX, ACCEILING, ACCEILINGX, ACMILESTN and ACMILESTNX. It is updated by AC10.1, AC120, AC300, BR00.1, BR120, BR122, BR130, BR131 and 13 more and referenced by AC110, AC112, AC113, AC12.1, AC121, AC123, AC128, AC130 and 426 more. The table has 15 fields, 1 index and 10 documented relations.

About ACBILL

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.

Fields (15)

Column = COBOL field name without the ACI- prefix, hyphens → underscores. Derived fields are computed by the application and are not stored.

Field / columnTypeDescription & valuesUpdated by
ACI-ACTIVITY PK
ACTIVITY		Alpha 15Required key. This is the activity for the billing information.BR00.1
ACI-MAX-BILLING
MAX_BILLING		Signed 18.2This is the maximum billing for the contract. Total billings should not exceed the maximum billing entered.BR00.1
ACI-PERC-BILLABLE
PERC_BILLABLE		Signed 7.4Percent billable is the percentage of total costs that are billable.BR00.1
ACI-BILLING-METHOD
BILLING_METHOD		Numeric 1The 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
TOTAL_BILLED		Signed 18.2The 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 +5 more
ACI-TOT-UNT-BILLED
TOT_UNT_BILLED		Signed 18.2The 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 +5 more
ACI-TOT-REV-AMT
TOT_REV_AMT		Signed 18.2The cumulative revenue amount recognized for the activity.AC300, BR580
ACI-TOT-REV-UNIT
TOT_REV_UNIT		Signed 15.2The cumulative revenue units recognized for the activity.AC300, BR580
ACI-TOLERANCE-AMT
TOLERANCE_AMT		Signed 18.2The billing activity tolerance amount.BR00.1
ACI-APPLY-TOL-AMT
APPLY_TOL_AMT		Signed 18.2The amount of tolerance applied for revenue for the billing activity.AC300, BR130, BR131, BR530, BR580
ACI-APPLY-TOL-UNIT
APPLY_TOL_UNIT		Signed 15.2Not used.AC300, BR580
ACI-RATE-FLAG
RATE_FLAG		Alpha 1The 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
TAX_CODE		Alpha 10A 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
TAX_EXEMPT_CD		Alpha 1The tax exempt code, indicating whether the activity is taxable or tax exempt. The values are:
  • E Exempt T = Taxable
BR00.1
ACI-SERVICE-LOC
SERVICE_LOC		Numeric 4A user defined code identifying a customer's service location.BR00.1

Indexes (1)

Keys marked * are descending. Every documented Lawson index is unique unless flagged Duplicates; Subset indexes carry a Where condition.

IndexKeysFlagsConditionUsed in
ACISET1ACTIVITYPrimaryAC10.1, AC10.5, AC110, AC112, AC113, AC12.1, AC120, AC121 +22 more (list truncated in source)

Relations

One to one (1) — lookups and parents

RelationTableRulesConditionField map
AcactivityACACTIVITYRequiredACI-ACTIVITY → ACV-ACTIVITY

One to many (9) — child tables

RelationTableRulesConditionField map
AcbillxACBILLXACI-ACTIVITY → AIX-ACTIVITY, → AIX-SUM-ACCT-CAT, → AIX-CTR-CAT-GRP, → AIX-ACCT-CATEGORY
AcblrateACBLRATEACI-ACTIVITY → ALR-ACTIVITY, → ALR-SUM-ACCT-CAT, → ALR-CTR-CAT-GRP, → ALR-ACCT-CATEGORY, → ALR-SOURCE-CODE, → ALR-MATRIX-CAT, → ALR-EFFECTIVE-DT
AcblratexACBLRATEXACI-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
AcceilingACCEILINGACI-ACTIVITY → CEH-ACTIVITY, → CEH-ACCT-CATEGORY, → CEH-SUM-ACCT-CAT, → CEH-CTR-CAT-GRP, → CEH-MATRIX-CAT
AcceilingxACCEILINGXACI-ACTIVITY → CEX-ACTIVITY, → CEX-ACCT-CATEGORY, → CEX-SUM-ACCT-CAT, → CEX-CTR-CAT-GRP, → CEX-MATRIX-CAT, → CEX-MX-VALUE
AcmilestnACMILESTNACI-ACTIVITY → MLS-ACTIVITY, → MLS-MILESTONE-CAT
AcmilestnxACMILESTNXACI-ACTIVITY → MLX-ACTIVITY, "B" → MLX-MILESTONE-CAT, → MLX-MILESTONE
H AcblrateACBLRATEACI-ACTIVITY → ALR-ACTIVITY, → ALR-SUM-ACCT-CAT, → ALR-CTR-CAT-GRP, → ALR-ACCT-CATEGORY, → ALR-SOURCE-CODE, → ALR-MATRIX-CAT, → ALR-EFFECTIVE-DT
U AcblrateACBLRATEACI-ACTIVITY → ALR-ACTIVITY, → ALR-SUM-ACCT-CAT, → ALR-CTR-CAT-GRP, → ALR-ACCT-CATEGORY, → ALR-SOURCE-CODE, → ALR-MATRIX-CAT, → ALR-EFFECTIVE-DT

Programs

Updated by (21)

Referenced by (434)