C6INPF – No description in the Lawson data dictionary

System
C6 (C6)
Prefix
C6F
Primary key
PF-NBR
Fields
9
Updated by
0 programs
Referenced by
0 programs

C6INPF is a Lawson C6 table (prefix C6F); no description in the lawson data dictionary. It is indexed by PF-NBR (C6FSET1). It is related 1:M to C6TAXGRP. The table has 9 fields, 1 index and 1 documented relation.

About C6INPF

No description in the Lawson data dictionary.

Fields (9)

Column = COBOL field name without the C6F- 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 / columnTypeDescription & valuesUpdated by
#C6F-PF-NBR PK
PF_NBR		Alpha 20——
#C6F-PF-GRP-CODE
PF_GRP_CODE		Alpha 3——
#C6F-PF-TRUST-IND
PF_TRUST_IND		Alpha 1—
  • N No
  • Y Yes
—
#C6F-CREATE-USER
CREATE_USER		Alpha 10 (Lower Case)——
#C6F-CREATE-DATE
CREATE_DATE		Numeric 8 (yyyymmdd)——
#C6F-CREATE-TIME
CREATE_TIME		Numeric 6 (hhmmss)——
#C6F-USER-ID
USER_ID		Alpha 10 (Lower Case)——
#C6F-DATE-STAMP
DATE_STAMP		Numeric 8 (yyyymmdd)——
#C6F-TIME-STAMP
TIME_STAMP		Numeric 6 (hhmmss)——

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.

IndexKeysFlagsConditionUsed in
C6FSET1
  1. PF-NBR
PrimaryBN66.1, PR140, PR189, PR195, PR80.1, PR80.4, PR89.1, PRAT.1

Relations

Relationship map — 1:1 lookups/parents on the left, 1:M children on the right (up to 14 each)
C6TAXGRPC6INPF

One to many (1) — child tables

RelationTableRulesConditionField map
C6taxgrpC6TAXGRP
C6F-PF-NBR→C6G-PF-NBR
—→C6G-COMPANY
—→C6G-PROCESS-LEVEL
—→C6G-BUS-NBR-GRP

Programs

No Lawson programs are documented as updating or referencing this table.