Lawson Insight Technical Documentation

Generated by:
Documentation generated by Decision Analytics

ERDs Tables Conditions Elements Libraries APIs Forms

SAIAMEADIM


                            SAIAMEADIM FILE

REFERENCED BY

SALD.1

UPDATED BY

SADM.3    SAMM.1

FIELD NAME             DESCRIPTION/VALID VALUES                  UPDATED BY

SA2-MEASURE-DIM        Alpha 50  (Lower Case)                    SADM.3
Element: Measure Dim

SA2-MEMBER-PREFIX      Alpha 5  (Lower Case)                     SADM.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.

SA2-NET-SALES-MBR      Alpha 50  (Lower Case)                    SADM.3
Element: Net Sales Mbr

SA2-GROSS-SALE-MBR     Alpha 50  (Lower Case)                    SADM.3
Element: Gross Sale Mbr

SA2-DISCOUNT-MBR       Alpha 50  (Lower Case)                    SADM.3
Element: Discount Mbr

SA2-MARG-MBR           Alpha 50  (Lower Case)                    SADM.3
Element: Marg Mbr

SA2-MARG-NET-MBR       Alpha 50  (Lower Case)                    SADM.3
Element: Marg Net Mbr

SA2-MARG-COGS-MBR      Alpha 50  (Lower Case)                    SADM.3
Element: Marg Cogs Mbr

SA2-QUANTITY-MBR       Alpha 50  (Lower Case)                    SADM.3
Element: Quantity Mbr

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

SA2-LAST-MAINT-TM      Numeric 6  (hhmmss)                       SADM.3
Element: Sys Time      This is the last time the member was
                       imported to the budget.

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

SA2-LAST-LOAD-TM       Numeric 6  (hhmmss)                       SAMM.1
Element: Last Load Tm

                         SAIAMEADIM FILE INDEX

NAME      KEY FIELDS    DESCRIPTION / SUBSET CONDITION           USED IN

SA2SET1   MEASURE-DIM                                            SADM.1  SADM.3
                                                                 SALD.1  SAMM.1