Lawson Software

Lawson Insight Technical Documentation

Generated by:
Documentation generated by Decision Analytics

ERDs Tables Elements Libraries App Forms


                            POIAPRDDIM FILE

REFERENCED BY

POA1.1    POA10     POA3.1    POA5.3

UPDATED BY

POA2.3    POAP.1

FIELD NAME           DESCRIPTION/VALID VALUES                    UPDATED BY

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

PI2-MEMBER-PREFIX    Alpha 5  (Lower Case)                       POA2.3
Member Prefix

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

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

PI2-ITEM-GROUP       Alpha 5                                     POA2.3
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
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
Major Class

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

PI2-END-MAJOR-CLS    Alpha 4                                     POA2.3
End Major Cls

PI2-END-MINOR-CLS    Alpha 4                                     POA2.3
End Minor Cls

PI2-MANUF-CODE       Alpha 4                                     POA2.3
Manufacturer's Code  This 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
End Manuf Code

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

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

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

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

PI2-ITEMS-LOADED     Numeric 7
Items Loaded

PI2-OUTLINE-FILE     Alpha 100  (Lower Case)                     POAP.1
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
Last Iamnt Tm

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

PI2-LAST-IALOAD-TM   Numeric 8                                   POAP.1
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