Lawson Insight Technical Documentation

                              HRIAMBR FILE

REFERENCED BY

HCMS.1    HCMS.2    HCOP.1    HCOP.2    HCTM.1    HCUF.1

UPDATED BY

HC01.1    HC01.2    HC02.1    HC02.2    HC02.3    HCEM.1

FIELD NAME           DESCRIPTION/VALID VALUES                    UPDATED BY

HIM-DATA-MART-NAME   Alpha 20  (Lower Case)                      HC01.1  HC01.2
Data Mart Name                                                   HC02.1  HC02.2
                                                                 HC02.3  HCEM.1

HIM-DIM-TYPE         Numeric 3                                   HC01.1  HC01.2
Dim Type                                                         HC02.1  HC02.2
                                                                 HC02.3  HCEM.1

HIM-MEMBER-TYPE      Numeric 3                                   HC01.1  HC01.2
Member Type                                                      HC02.1  HC02.2
                                                                 HC02.3  HCEM.1

HIM-SEQ-NBR          Numeric 4                                   HC01.2  HC02.2
Sequence Number      An automatically assigned sequence          HC02.3  HCEM.1
                     number.

HIM-MBR-USE          Alpha 1                                     HC01.1  HC01.2
Mbr Use                                                          HC02.1  HC02.2
                                                                 HC02.3  HCMS.1

HIM-MBR-NAME         Alpha 30  (Lower Case)                      HC01.1  HC01.2
Member Name          The Member Name field contains the          HC02.1  HC02.2
                     user-defined member name for the income
                     statement member. This name can contain
                     up to 30 characters of any kind.

HIM-MBR-ALIAS-NAME   Alpha 30  (Lower Case)                      HC01.1  HC01.2
Alias Name                                                       HC02.1

HIM-TYPE             Alpha 2                                     HC01.1  HC01.2
Type                 This identifies whether this record is      HC02.1  HC02.2
                     created because of a picking
                     transaction, or because of a return.
                     Valid values are:
                         "IS" = Picking transaction.
                         "RR" = Return.
                      ~$1 VENDOR
                     The vendor's identification code.


HIM-PAY-CLASS        Alpha 3                                     HC01.2
Payment Class

HIM-PAY-SUM-GRP      Alpha 3                                     HC01.2
Payment Summary
Group

HIM-DATE-1           Numeric 8  (yyyymmdd)                       HC01.1  HC01.2
Date 1

HIM-DATE-2           Numeric 8  (yyyymmdd)                       HC01.2
Date 2

HIM-FACTOR-1         Signed 7.2                                  HC01.2
Factor 1

HIM-SELECTION        Alpha 100                                   HC01.1  HC01.2
Selection                                                        HC02.1  HC02.2
                                                                 HC02.3  HCEM.1

HIM-DATE-STAMP       Numeric 8  (yyyymmdd)                       HC01.1  HC01.2
Date Stamp           This field contains the server date         HC02.1  HC02.2
                     (month, date, and year) of the last         HC02.3  HCEM.1
                     change to this record.

HIM-TIME-STAMP       Numeric 6  (hhmmss)                         HC01.1  HC01.2
Time Stamp           Contains the server time (hour, minute,     HC02.1  HC02.2
                     and second) when the record was last        HC02.3  HCEM.1
                     changed.

HIM-USER-ID          Alpha 10  (Lower Case)                      HC01.1  HC01.2
User ID Name         Contains the user ID of the person who      HC02.1  HC02.2
                     last changed this record.                   HC02.3

                         HRIAMBR FILE INDEX

NAME      KEY FIELDS    DESCRIPTION / SUBSET CONDITION           USED IN

HIMSET1   DATA-MART-NAME                                         HC01.1  HC01.2
          DIM-TYPE                                               HC02.1  HC02.2
          MEMBER-TYPE                                            HC02.3  HCEM.1
          SEQ-NBR                                                HCMS.1  HCMS.2
                                                                 HCOP.1  HCOP.2
                                                                 HCTM.1  HCUF.1

                         HRIAMBR FILE RELATIONS

ONE TO ONE RELATIONS


RELATION       RELATED
 NAME           FILE        INTEGRITY RULES / FIELD MATCH

Dimension      HRIADIM      Required

                            HIM-DATA-MART-NAME    -> HID-DATA-MART-NAME
                            HIM-DIM-TYPE          -> HID-DIM-TYPE

Olap Db        OLAPDBM      Required

                            HIM-DATA-MART-NAME    -> ODB-DATA-MART-NAME

Pay Class      PAYCLASS     Required
                            When HIM-PAY-CLASS != Spaces

                            HID-COMPANY           -> PCL-COMPANY
                            HIM-PAY-CLASS         -> PCL-PAY-CLASS

Pay Sum Grp    PAYSUMGRP    Required
                            When HIM-PAY-SUM-GRP != Spaces

                            HID-COMPANY           -> PSG-COMPANY
                            HIM-PAY-SUM-GRP       -> PSG-PAY-SUM-GRP

                         HRIAMBR FILE RELATIONS

ONE TO MANY RELATIONS


RELATION       RELATED
 NAME           FILE        INTEGRITY RULES / FIELD MATCH

Pay Classes    PSGRELATE
                            Valid When HIM-PAY-SUM-GRP != Spaces

                            HID-COMPANY           -> PSR-COMPANY
                            HIM-PAY-SUM-GRP       -> PSR-PAY-SUM-GRP
                                                     PSR-PAY-CLASS