Lawson Insight Technical Documentation

Generated by:
Documentation generated by Decision Analytics

ERDs Tables Conditions Elements Libraries APIs Forms

POIAPRDDIM


                            POIAPRDDIM FILE

REFERENCED BY

POA1.1    POA10     POA3.1    POA5.3    SADM.1    SALD.1

UPDATED BY

POA2.3    POAP.1

FIELD NAME             DESCRIPTION/VALID VALUES                  UPDATED BY

PI2-PROD-DIMENSION     Alpha 50  (Lower Case)                    POA2.3
Element: Prod Dimension

PI2-MEMBER-PREFIX      Alpha 5  (Lower Case)                     POA2.3
Element: Member Prefix The Member Prefix field contains a
                       unique prefix to differentiate the
                       dimension name from other like-named
                       dimensions.  This user-defined name can
                       contain up to five characters of any
                       kind.

PI2-ITEM-ALIAS         Alpha 1                                   POA2.3
Element: Item Alias    I = Item Name
                       N = Item Number

PI2-ALL-ITEMS          Alpha 1                                   POA2.3
Element: All Items     Y = Yes
                       N = No

PI2-ITEM-GROUP         Alpha 5                                   POA2.3
Element: Item Group    This field contains the identifier for
                       a group of items that can be shared by
                       one or more companies.

PI2-CLASS-TYPE         Alpha 1                                   POA2.3
Element: Class Type    This field contains the class type,
                       which identifies the group of classes.
                       " " = No Class Type Specified
                       I = Inventory Class
                       P = Purchasing Class
                       S = Sales Class

PI2-MAJOR-CLASS        Alpha 4                                   POA2.3
Element: Major Class

PI2-MINOR-CLASS        Alpha 4                                   POA2.3
Element: Minor Class

PI2-END-MAJOR-CLS      Alpha 4                                   POA2.3  SALD.1
Element: End Major Cls

PI2-END-MINOR-CLS      Alpha 4                                   POA2.3  SALD.1
Element: End Minor Cls

PI2-MANUF-CODE         Alpha 4                                   POA2.3
Element: Manufacturer'sThis field contains a user defined code
                       that indicates the  manufacturer of an
                       item.

PI2-MANUF-DIVISION     Alpha 4                                   POA2.3
Manufacturer's         This is a user defined code that
Division               indicates which division of a
                       manufacturer is tied to an item.

PI2-END-MANUF-CODE     Alpha 4                                   POA2.3
Element: End Manuf Code

PI2-END-MANUF-DIV      Alpha 4                                   POA2.3
Element: End Manuf Div

PI2-INCL-SPECIAL       Alpha 1                                   POA2.3
Element: Incl Special  Y = Yes
                       N = No

PI2-INCL-INVOICE       Alpha 1                                   POA2.3
Element: Incl Invoice

PI2-NBR-OF-ITEMS       Numeric 7
Element: Nbr Of Items

PI2-ITEMS-LOADED       Numeric 7
Element: Items Loaded

PI2-MATRIX-VIEW        Alpha 12                                  POA2.3
Element: Attribute ViewThe Attribute View field contains the
                       accounting unit view being used for
                       alternate roll-ups. Any posting
                       accounting units listed in a view that
                       is used for alternate roll-ups must also
                       be included in one of the company,
                       accounting, or company groups.


PI2-OUTLINE-FILE       Alpha 100  (Lower Case)                   POAP.1
Element: Outline File

PI2-LAST-MAINT-DT      Numeric 8  (yyyymmdd)                     POA2.3
Last Maintenance       This is the last date the Member was
Date                   imported to the budget.

PI2-LAST-IAMNT-TM      Numeric 8                                 POA2.3
Element: Last Iamnt Tm

PI2-LAST-LOAD-DT       Numeric 8  (yyyymmdd)                     POAP.1
Element: Last Load Dt

PI2-LAST-IALOAD-TM     Numeric 8                                 POAP.1
Element: Last Iaload Tm

                         POIAPRDDIM FILE INDEX

NAME      KEY FIELDS    DESCRIPTION / SUBSET CONDITION           USED IN

PI2SET1   PROD-DIMENSION                                         POA1.1  POA10
                                                                 POA2.3  POA3.1
                                                                 POA5.3  POAP.1
                                                                 SADM.1  SALD.1