ACIFATTR – No description in the Lawson data dictionary
- System
- Activity Management (AC)
- Prefix
AAT- Primary key
RUN-GROUP,OLD-ACTIVITY,MATRIX-CAT,EFFECTIVE-DATE- Fields
- 5
- Updated by
- 3 programs
- Referenced by
- 0 programs
ACIFATTR is a Lawson Activity Management table (prefix AAT); no description in the lawson data dictionary. It is indexed by RUN-GROUP, OLD-ACTIVITY, MATRIX-CAT, EFFECTIVE-DATE (AATSET1). It is updated by AC51.1, AC510 and AC560. The table has 5 fields, 1 index and 0 documented relations.
About ACIFATTR
No description in the Lawson data dictionary.
Fields (5)
Column = COBOL field name without the AAT- 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 |
|---|---|---|---|
#AAT-RUN-GROUP PKRUN_GROUP | Alpha 15 | Key field. This is the run group for the import information. | AC51.1 |
#AAT-OLD-ACTIVITY PKOLD_ACTIVITY | Alpha 35 | Key field. This is the old, or non-Lawson, activity. | AC51.1 |
#AAT-MATRIX-CAT PKMATRIX_CAT | Alpha 12 | Required. This is the attribute to be imported. | AC51.1 |
#AAT-MX-VALUEMX_VALUE | Alpha 32 | This is the value of the attribute to be imported. | AC51.1 |
#AAT-EFFECTIVE-DATE PKEFFECTIVE_DATE | Numeric 8 (yyyymmdd) | The date a vendor's prices will be in effect. | AC51.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 |
|---|---|---|---|---|
AATSET1 |
| Primary | AC51.1, AC510, AC560 |