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. PK = primary key (present in every index); SETn = leading/alternate key of that index.

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 are listed in index order; ↓ marks a descending key. Every documented Lawson index is unique unless flagged Duplicates; Subset indexes carry a Where condition.

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

Relations

Relationship map — 1:1 lookups/parents on the left, 1:M children on the right (up to 14 each)
ACACTIVITYACBILLXACBLRATEACBLRATEXACCEILINGACCEILINGXACMILESTNACMILESTNXACBILL

One to one (1) — lookups and parents

RelationTableRulesConditionField map
AcactivityACACTIVITYRequired
ACI-ACTIVITY→ACV-ACTIVITY

One to many (9) — child tables

RelationTableRulesConditionField map
AcbillxACBILLX
ACI-ACTIVITY→AIX-ACTIVITY
—→AIX-SUM-ACCT-CAT
—→AIX-CTR-CAT-GRP
—→AIX-ACCT-CATEGORY
AcblrateACBLRATE
ACI-ACTIVITY→ALR-ACTIVITY
—→ALR-SUM-ACCT-CAT
—→ALR-CTR-CAT-GRP
—→ALR-ACCT-CATEGORY
—→ALR-SOURCE-CODE
—→ALR-MATRIX-CAT
—→ALR-EFFECTIVE-DT
AcblratexACBLRATEX
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
AcceilingACCEILING
ACI-ACTIVITY→CEH-ACTIVITY
—→CEH-ACCT-CATEGORY
—→CEH-SUM-ACCT-CAT
—→CEH-CTR-CAT-GRP
—→CEH-MATRIX-CAT
AcceilingxACCEILINGX
ACI-ACTIVITY→CEX-ACTIVITY
—→CEX-ACCT-CATEGORY
—→CEX-SUM-ACCT-CAT
—→CEX-CTR-CAT-GRP
—→CEX-MATRIX-CAT
—→CEX-MX-VALUE
AcmilestnACMILESTN
ACI-ACTIVITY→MLS-ACTIVITY
—→MLS-MILESTONE-CAT
AcmilestnxACMILESTNX
ACI-ACTIVITY→MLX-ACTIVITY
"B"→MLX-MILESTONE-CAT
—→MLX-MILESTONE
H AcblrateACBLRATE
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 AcblrateACBLRATE
ACI-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)