ACCNTRCAT – Activity Contract Category
- System
- AC Billing Revenue (BR)
- Prefix
CNC- Primary key
CONTRACT,ACTIVITY,ACCT-CATEGORY- Fields
- 5
- Updated by
- 5 programs
- Referenced by
- 2 programs
ACCNTRCAT is the Activity Contract Category table in Lawson AC Billing Revenue (prefix CNC). It is indexed by CONTRACT, ACTIVITY, ACCT-CATEGORY (CNCSET1). It is related 1:1 to ACACCTCAT, ACACTIVITY, ACCNTRACT and ACCNTRACTX. It is updated by BR10.1, BR12.2, BR130, BR140 and BR530 and referenced by BR165 and BR65.3. The table has 5 fields, 1 index and 4 documented relations.
About ACCNTRCAT
No description in the Lawson data dictionary.
Fields (5)
Column = COBOL field name without the CNC- prefix, hyphens → underscores. Derived fields are computed by the application and are not stored.
| Field / column | Type | Description & values | Updated by |
|---|---|---|---|
CNC-CONTRACT PKCONTRACT | Alpha 15 | Activity Management contract. | BR12.2 |
CNC-ACTIVITY PKACTIVITY | Alpha 15 | Activities are the processes or procedures that produce work. Cost objects (products, services, customers, and so on) are the reasons for performing the activity. | BR12.2 |
CNC-ACCT-CATEGORY PKACCT_CATEGORY | Alpha 5 | Account categories are groupings of costs, revenues, or a combination of both used for reporting and inquiries for activities in the Activity Management system. All transactions are posted to an account category within an activity. You can assign a specific General Ledger account or range of accounts (company, accounting unit, account, and subaccount) that make up the transactions posted to an account category using AC07.1 (Account Assignment). Period-to-date, year-to-date, and life-to-date balances are maintained by account category for activities. Account categories must be assigned to activities before you do any budgeting or transaction processing. Valid account category types are: cost revenue accrual pass thru | BR12.2 |
CNC-CONTRACT-AMTCONTRACT_AMT | Signed 18.2 | — | BR12.2 |
CNC-TOTAL-REVENUETOTAL_REVENUE | Signed 18.2 | — | BR130, BR140, BR530 |
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 |
|---|---|---|---|---|
CNCSET1 | CONTRACT, ACTIVITY, ACCT-CATEGORY | Primary | BR10.1, BR10.2, BR12.2, BR130, BR140, BR165, BR530, BR65.3 |
Relations
One to one (4) — lookups and parents
| Relation | Table | Rules | Condition | Field map |
|---|---|---|---|---|
| Acacctcat | ACACCTCAT | Required | CNC-ACCT-CATEGORY → AAX-ACCT-CATEGORY | |
| Acactivity | ACACTIVITY | Required | CNC-ACTIVITY → ACV-ACTIVITY | |
| Accntract | ACCNTRACT | Required | CNC-CONTRACT → CNT-CONTRACT | |
| Accntractx | ACCNTRACTX | Required | CNC-CONTRACT → CNX-CONTRACT, CNC-ACTIVITY → CNX-ACTIVITY |
Programs
Updated by (5)
- BR10.1 Contract Parameters
- BR12.2 Contract Account Category Detail
- BR130 Revenue Calculation
- BR140 Billing and Revenue Backout
- BR530 Revenue Import