C6TAXGRP – No description in the Lawson data dictionary

System
C6 (C6)
Prefix
C6G
Primary key
COMPANY, PROCESS-LEVEL, BUS-NBR-GRP
Fields
12
Updated by
0 programs
Referenced by
0 programs

C6TAXGRP is a Lawson C6 table (prefix C6G); no description in the lawson data dictionary. It is indexed by COMPANY, PROCESS-LEVEL, BUS-NBR-GRP (C6GSET1); alternate indexes: C6GSET2, C6GSET3, C6GSET4, C6GSET5 and C6GSET6. It is related 1:1 to C6INPF. The table has 12 fields, 6 indexes and 1 documented relation.

About C6TAXGRP

No description in the Lawson data dictionary.

Fields (12)

Column = COBOL field name without the C6G- 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
#C6G-COMPANY PK
COMPANY		Numeric 4——
#C6G-PROCESS-LEVEL PK
PROCESS_LEVEL		Alpha 5——
#C6G-BUS-NBR-GRP PK
BUS_NBR_GRP		Alpha 4——
#C6G-TAN-NBR SET3 SET6
TAN_NBR		Alpha 10——
#C6G-PF-NBR SET4
PF_NBR		Alpha 20——
#C6G-ESIC-NBR SET5
ESIC_NBR		Alpha 20——
#C6G-CREATE-USER-ID
CREATE_USER_ID		Alpha 10 (Lower Case)——
#C6G-CREATE-DATE
CREATE_DATE		Numeric 8 (yyyymmdd)——
#C6G-CREATE-TIME
CREATE_TIME		Numeric 6 (hhmmss)——
#C6G-USER-ID
USER_ID		Alpha 10 (Lower Case)——
#C6G-DATE-STAMP
DATE_STAMP		Numeric 8 (yyyymmdd)——
#C6G-TIME-STAMP
TIME_STAMP		Numeric 6 (hhmmss)——

Indexes (6)

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
C6GSET1
  1. COMPANY
  2. PROCESS-LEVEL
  3. BUS-NBR-GRP
PrimaryBN305, BN66.1, HR00.1, HR01.1, HR11.1, HR11.2, HR11.4, HR200 +22 more (list truncated in source)
C6GSET2
  1. COMPANY
  2. BUS-NBR-GRP
  3. PROCESS-LEVEL
PR560
C6GSET3
  1. TAN-NBR
  2. COMPANY
  3. PROCESS-LEVEL
  4. BUS-NBR-GRP
—
C6GSET4
  1. PF-NBR
  2. COMPANY
  3. PROCESS-LEVEL
  4. BUS-NBR-GRP
BN305, HR11.1, HR11.2, HR11.4, HR28.1, HR511, LT101, LT111 +22 more (list truncated in source)
C6GSET5
  1. ESIC-NBR
  2. COMPANY
  3. PROCESS-LEVEL
  4. BUS-NBR-GRP
BN305, HR11.1, HR11.2, HR11.4, HR28.1, HR511, LT101, LT111 +22 more (list truncated in source)
C6GSET6
  1. COMPANY
  2. TAN-NBR
  3. PROCESS-LEVEL
  4. BUS-NBR-GRP
—

Relations

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

One to one (1) — lookups and parents

RelationTableRulesConditionField map
C6inpfC6INPFRequired
C6G-PF-NBR→C6F-PF-NBR (C6FSET1)

Programs

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