ACFEECD – Activity Management Fee Code
- System
- AC Billing Revenue (BR)
- Prefix
FCD- Primary key
FEE-CD- Fields
- 5
- Updated by
- 1 program
- Referenced by
- 22 programs
ACFEECD is the Activity Management Fee Code table in Lawson AC Billing Revenue (prefix FCD). It is indexed by FEE-CD (FCDSET1). It is related 1:1 to ACCATGRP. It is updated by BR15.1 and referenced by BR120, BR121, BR122, BR123, BR130, BR140, BR151, BR152 and 14 more. The table has 5 fields, 1 index and 1 documented relation.
About ACFEECD
The ACFEECD (Fee Code) file maintains fee code names and descriptions, as well as, the account category group or account category range tha make up the valid account categories used to determine the driver for fee for each fee code. Fee codes are defined on BR15.1 (Fee Code Setup). On contracts awarded to the government for government contracting clients, fee is the profit or margin in addition to the costs that results from the contract. Fee is calculated on a cumulative basis by BR130 (Revenue Calculation) and BR120 (Invoice Calculation). The basis for fee is the cumulative cost amount available for billing or revenue.
Fields (5)
Column = COBOL field name without the FCD- prefix, hyphens → underscores. Derived fields are computed by the application and are not stored.
| Field / column | Type | Description & values | Updated by |
|---|---|---|---|
FCD-FEE-CD PKFEE_CD | Alpha 5 | The name of the code used to calculate fee. | BR15.1 |
FCD-DESCRIPTIONDESCRIPTION | Alpha 30 (Lower Case) | This field displays the description. | BR15.1 |
FCD-FR-ACCT-CATFR_ACCT_CAT | Alpha 5 | The "from" account category if an account category range is defined. | BR15.1 |
FCD-TO-ACCT-CATTO_ACCT_CAT | Alpha 5 | The "to" account category if an account category range is defined. | BR15.1 |
FCD-CAT-GROUPCAT_GROUP | Alpha 15 | The account category group. Account category groups are defined via AC05.2 (Account Category Group). An account category group is a list of account categories. | BR15.1 |
Indexes (1)
Keys marked * are descending. Every documented Lawson index is unique unless flagged Duplicates; Subset indexes carry a Where condition.
| Index | Keys | Flags | Condition | Used in |
|---|---|---|---|---|
FCDSET1 | FEE-CD | Primary | BR120, BR121, BR122, BR123, BR130, BR140, BR15.1, BR15.2 +16 more |
Relations
One to one (1) — lookups and parents
| Relation | Table | Rules | Condition | Field map |
|---|---|---|---|---|
| Accatgrp | ACCATGRP | Not Required | FCD-CAT-GROUP → CGP-CAT-GROUP |
Programs
Updated by (1)
- BR15.1 Fee Code Setup
Referenced by (22)
- BR120 Invoice Calculation
- BR121 Invoice Print and Interface
- BR122 Online batch invoice process
- BR123 Product Invoice Cancel
- BR130 Revenue Calculation
- BR140 Billing and Revenue Backout
- BR151 Product Invoicing
- BR152 Maintenance Invoicing
- BR156 Maintenance Quote
- BR20.1 Invoice Edit Contract
- BR20.2 Invoice Edit Line
- BR20.3 Invoice Edit Activity
- BR20.4 Invoice Edit Activity and Account Category
- BR20.5 Invoice Edit Transaction
- BR215 Fee Code Listing
- BR420 Billing Invoice Report
- BR450 Activity Aging
- BR515 Fee Code Recalculation
- BR516 Fee Code Rebuild
- BR521 Billing Import
- BR530 Revenue Import
- BRIP.1 Invoice Print Program