Lawson Insight Technical Documentation

Generated by:
Documentation generated by Decision Analytics

ERDs Tables Conditions Elements Libraries APIs Forms

POIADIM


                              POIADIM FILE

REFERENCED BY

POA10     POA4.1    POAX.1

UPDATED BY

POA1.1    POA3.1

FIELD NAME             DESCRIPTION/VALID VALUES                  UPDATED BY

POI-DATA-MART-NAME     Alpha 20  (Lower Case)                    POA1.1
Element: Data Mart Name

POI-VEND-DIMENSION     Alpha 50  (Lower Case)                    POA1.1
Element: Vend Dimension

POI-PROD-DIMENSION     Alpha 50  (Lower Case)                    POA1.1
Element: Prod Dimension

POI-ORG-DIMENSION      Alpha 50  (Lower Case)                    POA1.1
Organization           The Organization Dimension Name field
Dimensioin Name        contains the user-defined name for the
                       Organization dimension. This name can
                       contain up to 30 characters of any kind.


POI-BUYR-DIMENSION     Alpha 50  (Lower Case)                    POA1.1
Element: Buyr Dimension

POI-TIME-DIMENSION     Alpha 50  (Lower Case)                    POA1.1
Element: Time Dimension

POI-MEAS-DIMENSION     Alpha 50  (Lower Case)                    POA1.1
Element: Meas Dimension

POI-YEAR-DIMENSION     Alpha 50  (Lower Case)                    POA1.1
Element: Year Dimension

POI-STATUS             Numeric 1                                 POA1.1
Element: Status        This field displays the status of the
                       transaction.

POI-DATA-LOAD-OPT      Alpha 1                                   POA1.1
Element: Data Load Opt The Data Values Load Option field
                       specifies how the data values are loaded
                       into the data mart.

                       Value values are:
                       N = No Load
                       I = Incremental
                       C = Complete; Default value.
                       P = Partial
                       " " = None Specified

POI-DATALD-BEG-PER     Numeric 2                                 POA1.1
Element: Datald Beg Per

POI-DATALD-BEG-YR      Numeric 4                                 POA1.1
Element: Datald Beg Yr

POI-DATALD-END-PER     Numeric 2                                 POA1.1
Element: Datald End Per

POI-DATALD-END-YR      Numeric 4                                 POA1.1
Element: Datald End Yr

POI-MAINT-DATE         Numeric 8  (yyyymmdd)
Element: Date

POI-MAINT-TIME         Numeric 6  (hhmmss)
Element: Sys Time

POI-PHASE-RECORDS      Signed 13.0 Occurs 9 Times                POA3.1
Element: Phase Records

POI-PHASE-MINUTES      Signed 11.0 Occurs 9 Times
Element: Phase Minutes

POI-PHASE-SECONDS      Signed 2.0 Occurs 9 Times                 POA3.1
Element: Phase Seconds

POI-TOTAL-RECORDS      Signed 11.0                               POA3.1
Element: Total Records

POI-TOTAL-MINUTES      Signed 11.0
Element: Total Minutes

POI-TOTAL-SECONDS      Signed 2.0                                POA3.1
Element: Total Seconds

                         POIADIM FILE INDEX

NAME      KEY FIELDS    DESCRIPTION / SUBSET CONDITION           USED IN

POISET1   DATA-MART-NAME                                         POA1.1  POA10
                                                                 POA3.1  POA4.1
                                                                 POAX.1