Lawson Insight Technical Documentation

Generated by:
Documentation generated by Decision Analytics

ERDs Tables Conditions Elements Libraries APIs Forms

SIRDREGION


                            SIRDREGION FILE

                                 Region

This file defines regions and assigns them to their applicable country.

REFERENCED BY

RD30.1    RD30.2    RD50.1    RD50.2    RD70.1    RD70.2

UPDATED BY

RD18.1

FIELD NAME             DESCRIPTION/VALID VALUES                  UPDATED BY

WRG-COUNTRY-CODE       Alpha 2                                   RD18.1
Element: Country Code

WRG-REGION-CODE        Alpha 2                                   RD18.1
Element: Region Code

WRG-DESCRIPTION        Alpha 50  (Lower Case)                    RD18.1
Element: Description   This field contains the description.

WRG-DATE               Numeric 8  (yyyymmdd)                     RD18.1
Element: Date          This field contains the system date
                       when this was created.

WRG-TIME               Numeric 6  (hhmmss)                       RD18.1
Element: Time

                         SIRDREGION FILE INDEX

NAME      KEY FIELDS    DESCRIPTION / SUBSET CONDITION           USED IN

WRGSET1   COUNTRY-CODE                                           RD18.1  RD30.1
          REGION-CODE                                            RD30.2  RD50.1
                                                                 RD50.2  RD70.1
                                                                 RD70.2

                         SIRDREGION FILE RELATIONS

ONE TO ONE RELATIONS


RELATION       RELATED
 NAME           FILE        INTEGRITY RULES / FIELD MATCH

Rdctry         SIRDCTRY     Required

                            WRG-COUNTRY-CODE    -> WCT-COUNTRY-CODE