CWDISTRIB – No description in the Lawson data dictionary

System
CW (CW)
Prefix
CWD
Primary key
COMPANY, EMPLOYEE, CONTRACT-YEAR, POSITION, CONT-SEQ-NBR, PAY-CODE, GL-EFFECT-DATE, GL-SEQ-NBR
Fields
23
Updated by
0 programs
Referenced by
0 programs

CWDISTRIB is a Lawson CW table (prefix CWD); no description in the lawson data dictionary. It is indexed by COMPANY, EMPLOYEE, CONTRACT-YEAR, POSITION, CONT-SEQ-NBR, PAY-CODE, GL-EFFECT-DATE, GL-SEQ-NBR (CWDSET1); alternate indexes: CWDSET2 and CWDSET3. It is related 1:1 to ACACCTCAT, ACACTIVITY, PRSYSTEM, GLMASTER, EMPLOYEE and PAEMPLOYEE and 1:M to CWASSIGN, CWCONTRACT, PAEMPPOS and PRPAYCODE. The table has 23 fields, 3 indexes and 10 documented relations.

About CWDISTRIB

No description in the Lawson data dictionary.

Fields (23)

Column = COBOL field name without the CWD- prefix, hyphens → underscores. Derived fields are computed by the application and are not stored.

Field / columnTypeDescription & valuesUpdated by
CWD-COMPANY PK
COMPANY		Numeric 4——
CWD-EMPLOYEE PK
EMPLOYEE		Numeric 9——
CWD-CONTRACT-YEAR PK
CONTRACT_YEAR		Numeric 4——
CWD-POSITION PK
POSITION		Alpha 12——
CWD-CONT-SEQ-NBR PK
CONT_SEQ_NBR		Numeric 12——
CWD-PAY-CODE PK
PAY_CODE		Alpha 4——
CWD-GL-EFFECT-DATE PK
GL_EFFECT_DATE		Numeric 8 (yyyymmdd)——
CWD-GL-SEQ-NBR PK
GL_SEQ_NBR		Numeric 4——
CWD-PCD-SEQ-NBR
PCD_SEQ_NBR		Numeric 8——
CWD-DIST-COMPANY
DIST_COMPANY		Numeric 4——
CWD-DST-ACCT-UNIT
DST_ACCT_UNIT		Alpha 15——
CWD-DST-ACCOUNT
DST_ACCOUNT		Numeric 6——
CWD-DST-SUB-ACCT
DST_SUB_ACCT		Numeric 4——
CWD-ACTIVITY
ACTIVITY		Alpha 15——
CWD-ACCT-CATEGORY
ACCT_CATEGORY		Alpha 5——
CWD-PERCENT
PERCENT		Signed 7.3——
CWD-DATE-STAMP
DATE_STAMP		Numeric 8 (yyyymmdd)——
CWD-TIME-STAMP
TIME_STAMP		Numeric 6 (hhmmss)——
CWD-USER-ID
USER_ID		Alpha 10 (Lower Case)——
CWD-CREATE-DATE
CREATE_DATE		Numeric 8 (yyyymmdd)——
CWD-CREATE-TIME
CREATE_TIME		Numeric 6 (hhmmss)——
CWD-CREATE-USER-ID
CREATE_USER_ID		Alpha 10 (Lower Case)——
CWD-FTE
FTE		Signed 11.6——

Indexes (3)

Keys marked * are descending. Every documented Lawson index is unique unless flagged Duplicates; Subset indexes carry a Where condition.

IndexKeysFlagsConditionUsed in
CWDSET1COMPANY, EMPLOYEE, CONTRACT-YEAR*, POSITION, CONT-SEQ-NBR*, PAY-CODE, GL-EFFECT-DATE*, GL-SEQ-NBR*PrimaryBN305, HR11.1, HR11.2, HR11.4, HR28.1, HR511, LT101, LT111 +22 more (list truncated in source)
CWDSET2COMPANY, EMPLOYEE, CONTRACT-YEAR, POSITION, CONT-SEQ-NBR, PAY-CODE, GL-EFFECT-DATE, GL-SEQ-NBR—
CWDSET3COMPANY, CONTRACT-YEAR*, EMPLOYEE, POSITION, CONT-SEQ-NBR*, PAY-CODE, GL-EFFECT-DATE*, GL-SEQ-NBR*—

Relations

One to one (6) — lookups and parents

RelationTableRulesConditionField map
Acct CategoryACACCTCATRequiredWhen (CWD-ACCT-CATEGORY != Spaces)CWD-ACCT-CATEGORY → AAX-ACCT-CATEGORY
ActivityACACTIVITYRequiredWhen (CWD-ACTIVITY != Spaces)CWD-ACTIVITY → ACV-ACTIVITY
CompanyPRSYSTEMRequiredCWD-COMPANY → PRS-COMPANY, Spaces → PRS-PROCESS-LEVEL
Dist AccountGLMASTERRequiredCWD-COMPANY → GLM-COMPANY, CWD-DST-ACCT-UNIT → GLM-ACCT-UNIT, CWD-DST-ACCOUNT → GLM-ACCOUNT, CWD-DST-SUB-ACCT → GLM-SUB-ACCOUNT
EmployeeEMPLOYEERequiredCWD-COMPANY → EMP-COMPANY, CWD-EMPLOYEE → EMP-EMPLOYEE
PaemployeePAEMPLOYEERequiredCWD-COMPANY → PEM-COMPANY, CWD-EMPLOYEE → PEM-EMPLOYEE

One to many (4) — child tables

RelationTableRulesConditionField map
AssignmentCWASSIGNCWD-COMPANY → CWA-COMPANY, CWD-CONTRACT-YEAR → CWA-CONTRACT-YEAR, CWD-EMPLOYEE → CWA-EMPLOYEE, CWD-POSITION → CWA-POSITION, → CWA-ASG-EFFECT-DTE, → CWA-PCD-SEQ-NBR
Emp ContractCWCONTRACTCWD-COMPANY → CCT-COMPANY, CWD-EMPLOYEE → CCT-EMPLOYEE, CWD-CONTRACT-YEAR → CCT-CONTRACT-YEAR, CWD-POSITION → CCT-POSITION, → CCT-CONT-SEQ-NBR
Emp PositionPAEMPPOSCWD-COMPANY → PEP-COMPANY, CWD-EMPLOYEE → PEP-EMPLOYEE, CWD-POSITION → PEP-POSITION, → PEP-EFFECT-DATE, → PEP-POS-LEVEL
Pay CodePRPAYCODECWD-COMPANY → PCD-COMPANY, CWD-PAY-CODE → PCD-PAY-CODE, → PCD-PROCESS-LEVEL, → PCD-JOB-CODE

Programs

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