ACIFCNTCMT – No description in the Lawson data dictionary
- System
- AC Billing Revenue (BR)
- Prefix
AFC- Primary key
CONTRACT,COMMENT-TYPE,SEQ-NBR- Fields
- 5
- Updated by
- 3 programs
- Referenced by
- 0 programs
ACIFCNTCMT is a Lawson AC Billing Revenue table (prefix AFC); no description in the lawson data dictionary. It is indexed by CONTRACT, COMMENT-TYPE, SEQ-NBR (AFCSET1). It is updated by BR570, BR70.1 and BR71.1. The table has 5 fields, 1 index and 0 documented relations.
About ACIFCNTCMT
No description in the Lawson data dictionary.
Fields (5)
Column = COBOL field name without the AFC- 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 / column | Type | Description & values | Updated by |
|---|---|---|---|
#AFC-CONTRACT PKCONTRACT | Alpha 15 | Activity Management contract. | BR71.1 |
#AFC-COMMENT-TYPE PKCOMMENT_TYPE | Alpha 2 | — | BR71.1 |
#AFC-SEQ-NBR PKSEQ_NBR | Numeric 4 | A unique number assigned to each transaction to be interfaced into the Lawson system. | BR71.1 |
#AFC-CMT-TEXTCMT_TEXT | Alpha 60 (Lower Case) | The text associated with the sequence number. | BR71.1 |
#AFC-DATEDATE | Numeric 8 (yyyymmdd) | This field displays the system date when this was created. | BR71.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.
| Index | Keys | Flags | Condition | Used in |
|---|---|---|---|---|
AFCSET1 |
| Primary | BR570, BR70.1, BR71.1 |