Lawson Insight Technical Documentation

Generated by:
Documentation generated by Decision Analytics

ERDs Tables Conditions Elements Libraries APIs Forms

SIRDIDPREF


                            SIRDIDPREF FILE

FIELD NAME             DESCRIPTION/VALID VALUES                  UPDATED BY

SIP-ID                 Alpha 20  (Lower Case)
Element: Id

SIP-SYSTEM-NAME        Alpha 10
Element: System Name

SIP-FIELD-NAME         Alpha 20  (Lower Case)
Element: Field Name

SIP-FIELD-VALUE        Alpha 99  (Lower Case)
Element: Field Value

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

SIP-TIME               Numeric 6  (hhmmss)
Element: Time

                         SIRDIDPREF FILE INDEX

NAME      KEY FIELDS    DESCRIPTION / SUBSET CONDITION           USED IN

SIPSET1   ID
          SYSTEM-NAME
          FIELD-NAME

SIPSET2   SYSTEM-NAME
          FIELD-NAME
          ID

SIPSET3   SYSTEM-NAME   Subset
          FIELD-NAME    Where ID = Spaces