Lawson Insight Technical Documentation

Generated by:
Documentation generated by Decision Analytics

ERDs Tables Conditions Elements Libraries APIs Forms

SIRDXRFTYP


                            SIRDXRFTYP FILE

REFERENCED BY

RD41.1    RD41.2    RD41.3    RD41.4    RD941

UPDATED BY

RD61.1    RD990

FIELD NAME             DESCRIPTION/VALID VALUES                  UPDATED BY

XRT-XREF-TYPE          Alpha 15  (Lower Case)                    RD61.1  RD990
Element: Xref Type

XRT-PARENT-TYPE        Alpha 15  (Lower Case)                    RD61.1
Element: Parent Type

XRT-DESCRIPTION        Alpha 50  (Lower Case)                    RD61.1  RD990
Element: Description   This field contains the description.

XRT-KEY-FIELDS         Numeric 2
Element: Key Fields

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

XRT-TIME               Numeric 6  (hhmmss)                       RD990
Element: Time

XRT-CHILD-EXITS        Derived
Element: Child Exits

                         SIRDXRFTYP FILE INDEX

NAME      KEY FIELDS    DESCRIPTION / SUBSET CONDITION           USED IN

XRTSET1   XREF-TYPE                                              RD41.1  RD41.2
                                                                 RD41.3  RD41.4
                                                                 RD61.1  RD941
                                                                 RD990

XRTSET2   PARENT-TYPE   KeyChange                                RD61.1
          XREF-TYPE

                         SIRDXRFTYP FILE RELATIONS

ONE TO MANY RELATIONS


RELATION       RELATED
 NAME           FILE        INTEGRITY RULES / FIELD MATCH

Child Exists   SIRDXRFTYP   Delete Restricted

                            XRT-XREF-TYPE    -> XRT-PARENT-TYPE
                                                XRT-XREF-TYPE

Sirdidxref     SIRDIDXREF   Delete Restricted

                            XRT-XREF-TYPE    -> XRF-XREF-TYPE
                                                XRF-EXTERNAL-ID

Sirdxtydef     SIRDXTYDEF   Delete Restricted

                            XRT-XREF-TYPE    -> XTY-XREF-TYPE
                                                XTY-ATTRIBUTE