Lawson Insight Technical Documentation

Generated by:
Documentation generated by Decision Analytics

ERDs Tables Conditions Elements Libraries APIs Forms

PRWKPATDTL


                            PRWKPATDTL FILE

REFERENCED BY

UK34.1    TM260     TM265

UPDATED BY

UK87.1

FIELD NAME             DESCRIPTION/VALID VALUES                  UPDATED BY

WKD-PATTERN-CODE       Alpha 3                                   UK87.1
Element: Pattern Code

WKD-WEEK-NBR           Numeric 2                                 UK87.1
Element: Week Nbr

WKD-SUN-DETL           Signed 4.2                                UK87.1
Element: Sun Detl

WKD-MON-DETL           Signed 4.2                                UK87.1
Element: Mon Detl

WKD-TUE-DETL           Signed 4.2                                UK87.1
Element: Tue Detl

WKD-WED-DETL           Signed 4.2                                UK87.1
Element: Wed Detl

WKD-THU-DETL           Signed 4.2                                UK87.1
Element: Thu Detl

WKD-FRI-DETL           Signed 4.2                                UK87.1
Element: Fri Detl

WKD-SAT-DETL           Signed 4.2                                UK87.1
Element: Sat Detl

                         PRWKPATDTL FILE INDEX

NAME      KEY FIELDS    DESCRIPTION / SUBSET CONDITION           USED IN

WKDSET1   PATTERN-CODE                                           UK34.1  UK87.1
          WEEK-NBR                                               TM260   TM265

                         PRWKPATDTL FILE RELATIONS

ONE TO ONE RELATIONS


RELATION       RELATED
 NAME           FILE        INTEGRITY RULES / FIELD MATCH

Prwkpat        PRWKPAT      Required

                            WKD-PATTERN-CODE    -> WKP-PATTERN-CODE