AMASTCOMM FILE

                             Asset Comment

The Asset Comment file stores asset comments defined in AM50.1 (Comments).

REFERENCED BY

AM220     AM225     AM230     AM240     AM40.1

UPDATED BY

AM115     AM135     AM15.1    AM15.2    AM15.3    AM15.4
AM170     AM20.1    AM20.2    AM20.3    AM20.4    AM20.5
AM20.6    AM30.1    AM30.2    AM300     AM50.1    AM500
AM952     AM96.1    AM98.1

FIELD NAME           DESCRIPTION/VALID VALUES                    UPDATED BY

ASC-ASSET            Numeric 10                                  AM135   AM30.1
Asset                The asset number associated with the        AM30.2  AM50.1
                     comment record.                             AM952


ASC-SEQ-NUMBER       Numeric 6                                   AM50.1  AM952
Sequence Number      A unique number assigned to each asset
                     comment.


ASC-COMMENT-TYPES    Alpha 3                                     AM50.1  AM952
Comment Types        This field indicates the type of
                     comment defined for the asset. Valid
                     values are:

                     ADD = Addition.
                     ADJ = Adjustment.
                     DSP = Disposal.
                     TRF = Transfer.


ASC-COMMENT-DATE     Numeric 8  (yyyymmdd)                       AM50.1  AM952
Comment Date         The date assigned to the comment. This
                     date does not have to be the date the
                     comment was entered.


ASC-COMMENT-TXT      Alpha 65  (Lower Case)                      AM50.1  AM952
Comment Text         The comment narrative.

ASC-CREATION-DATE    Numeric 8  (yyyymmdd)                       AM50.1  AM952
Creation Date        The system date the comment was created.


ASC-CREATION-TIME    Numeric 6  (hhmmss)                         AM50.1  AM952
Creation Time        The system time the comment was created.


ASC-CREATOR-ID       Alpha 10                                    AM50.1  AM952
Creator ID           The login identification of the person
                     who created the comment record.


ASC-TAG              Derived
Tag                  The tag number associated with the
                     asset, if applicable.


                         AMASTCOMM FILE INDEX

NAME      KEY FIELDS    DESCRIPTION / SUBSET CONDITION           USED IN

ASCSET1   ASSET                                                  AM115   AM135
          COMMENT-TYPES                                          AM15.1  AM15.2
          SEQ-NUMBER                                             AM15.3  AM15.4
                                                                 AM170   AM20.1
                                                                 AM20.2  AM20.3
                                                                 AM20.4  AM20.5
                                                                 AM20.6  AM220
                                                                 AM225   AM230
                                                                 AM240   AM30.1
                                                                 AM30.2  AM300
                                                                 AM40.1  AM50.1
                                                                 AM500   AM96.1
                                                                 AM98.1

ASCSET2   ASSET         KeyChange                                AM50.1
          COMMENT-TYPES
          COMMENT-DATE
          SEQ-NUMBER

                         AMASTCOMM FILE RELATIONS

ONE TO ONE RELATIONS


RELATION       RELATED
 NAME           FILE        INTEGRITY RULES / FIELD MATCH

Amasset        AMASSET      Not Required

                            ASC-ASSET    -> AST-ASSET

Amassetadj     AMASSETADJ   Not Required

                            ASC-ASSET    -> ASA-ASSET

Amassetdsp     AMASSETDSP   Not Required

                            ASC-ASSET    -> ASD-ASSET

Amassettrf     AMASSETTRF   Not Required

                            ASC-ASSET    -> ATF-ASSET