Lawson Insight Technical Documentation

                            ACPROFORMA FILE

REFERENCED BY

BR02.3    BR120     BR121     BR122     BR123     BR140
BR151     BR152     BR156     BR157     BR20.1    BR20.2
BR20.3    BR20.4    BR20.5    BR252     BR420     BR521


UPDATED BY

BR52.1    BRIP.1    BR54.2    BR54.3    BR54.4

FIELD NAME             DESCRIPTION/VALID VALUES                  UPDATED BY

ATI-INVOICE-TYPE       Alpha 1                                   BRIP.1
Element: Invoice Type  THis field will be filled in from the
                       Invoice based on PO number.  This is a
                       carrier for the field.  The PORECEIVE
                       file will have to be updated with this
                       field.
                       1 = Product
                       2 = Maintenance

ATI-CONTRACT           Alpha 15                                  BRIP.1
Element: Contract      Activity Management contract.

ATI-DUE-DATE           Numeric 8  (yyyymmdd)                     BRIP.1
Element: Date          This field displays the system date
                       when this was created.

ATI-MAINT-SCHEDULE     Alpha 15                                  BRIP.1
Element: Maint Schedule

ATI-INVOICE-PREFIX     Alpha 2                                   BRIP.1
Element: Invoice Prefix

ATI-INVOICE-NBR        Numeric 8                                 BRIP.1
Element: Invoice Nbr

ATI-HIH-OBJ-ID         Numeric 12                                BRIP.1
Element: Obj Id        This is the object identifier. It is
                       used to relate commitments or posted
                       transactions back to the originating
                       subsystems. Each subsystem record that
                       is updated as a commitment or posted
                       transaction is assigned an object
                       identifier. The object identifier is
                       maintained in the subsystem files and in
                       the Activity Commitments Detail and
                       Activity Transaction files. The object
                       identifier is a unique key used to drill
                       back from Activity Management to the
                       subsystems.

                         ACPROFORMA FILE INDEX

NAME      KEY FIELDS    DESCRIPTION / SUBSET CONDITION           USED IN

ATISET1   INVOICE-TYPE                                           BR02.3  BR120
          CONTRACT                                               BR121   BR122
          DUE-DATE                                               BR123   BR140
          MAINT-SCHEDULE                                         BR151   BR152
                                                                 BR156   BR157
                                                                 BR20.1  BR20.2
                                                                 BR20.3  BR20.4
                                                                 BR20.5  BR252
                                                                 BR420   BR52.1
                                                                 BR521   BR54.2
                                                                 BR54.3  BR54.4
                                                                 BRIP.1