C6INVEST – No description in the Lawson data dictionary
- System
- C6 (C6)
- Prefix
C6I- Primary key
COMPANY,PAYROLL-YEAR,INV-GROUP,INV-CODE- Fields
- 8
- Updated by
- 1 program
- Referenced by
- 10 programs
C6INVEST is a Lawson C6 table (prefix C6I); no description in the lawson data dictionary. It is indexed by COMPANY, PAYROLL-YEAR, INV-GROUP, INV-CODE (C6ISET1). It is updated by PR999 and referenced by BN66.1, PR139, PR140, PR141, PR189, PR195, PR80.1, PR80.4 and 2 more. The table has 8 fields, 1 index and 0 documented relations.
About C6INVEST
No description in the Lawson data dictionary.
Fields (8)
Column = COBOL field name without the C6I- 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 |
|---|---|---|---|
#C6I-COMPANY PKCOMPANY | Numeric 4 | — | — |
#C6I-PAYROLL-YEAR PKPAYROLL_YEAR | Numeric 4 | — | PR999 |
#C6I-PROP-CUTOFFPROP_CUTOFF | Numeric 8 (yyyymmdd) | — | PR999 |
#C6I-INV-GROUP PKINV_GROUP | Alpha 1 | — | — |
#C6I-INV-CODE PKINV_CODE | Alpha 10 | — | — |
#C6I-INV-DESCINV_DESC | Alpha 30 (Lower Case) | — | — |
#C6I-PROPOSED-FLAGPROPOSED_FLAG | Alpha 1 | — | — |
#C6I-END-DATEEND_DATE | Numeric 8 (yyyymmdd) | — | — |
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 |
|---|---|---|---|---|
C6ISET1 |
| Primary | BN66.1, PR139, PR140, PR141, PR189, PR195, PR80.1, PR80.4 +3 more |
Programs
Updated by (1)
- PR999 Payroll Year End Close