Lawson Software

Lawson Insight Technical Documentation

Generated by:
Documentation generated by Decision Analytics

ERDs Tables Elements Libraries App Forms


                             PWAUTHOR FILE

                        HR Report Writer Author

Contains information about an author. HR60.1 (HR Writer Authors) is the
primary program that updates this file.

REFERENCED BY

HR70.1

UPDATED BY

HR60.1    HR64.1    HR65.1    HR67.1

FIELD NAME           DESCRIPTION/VALID VALUES                    UPDATED BY

PWA-AUTHOR-NAME      Alpha 10                                    HR60.1
Author               Contains the user-defined author name.

PWA-DESCRIPTION      Alpha 30  (Lower Case)                      HR60.1
Description          Contains the author description that
                     further defines the author.

PWA-LST-TITLE-NBR    Numeric 4                                   HR64.1  HR65.1
Last Title Number    Contains the sequence number used to
Used                 store the last title record for this
                     author.

PWA-LAST-COMP-NBR    Numeric 4                                   HR67.1
Last Compute         Contains the sequence number used to
Statement Number     store the last compute record for this
                     author.

                         PWAUTHOR FILE INDEX

NAME      KEY FIELDS    DESCRIPTION / SUBSET CONDITION           USED IN

PWASET1   AUTHOR-NAME                                            HR60.1  HR64.1
                                                                 HR65.1  HR65.2
                                                                 HR65.3  HR65.4
                                                                 HR65.5  HR65.6
                                                                 HR65.7  HR65.8
                                                                 HR67.1  HR70.1

                         PWAUTHOR FILE RELATIONS

ONE TO MANY RELATIONS


RELATION       RELATED
 NAME           FILE        INTEGRITY RULES / FIELD MATCH

Computes       PWCOMPUTE    Delete Restricted

                            PWA-AUTHOR-NAME    -> PWC-AUTHOR-NAME
                                                  PWC-COLUMN-NAME

Titles         PWTITLE      Delete Restricted

                            PWA-AUTHOR-NAME    -> PWT-AUTHOR-NAME
                                                  PWT-TITLE