Lawson Insight Technical Documentation

Generated by:
Documentation generated by Decision Analytics

ERDs Tables Conditions Elements Libraries APIs Forms

ACPROFORMA


                            ACPROFORMA FILE

                        Product Proforma Invoice

The ACPROFORMA file stores data related to pro forma invoices generated for a
product maintenance contract. This file is primarily updated by Maintenance
Quote (BR156).

REFERENCED BY

BR152     BR157     BR252

UPDATED BY

BR151     BR156     BR52.1    BRPI.1    BR54.2    BR54.3
BR54.4

FIELD NAME             DESCRIPTION/VALID VALUES                  UPDATED BY

ATI-INVOICE-TYPE       Alpha 1                                   BR151   BR156
Element: Invoice Type  1 = Product
                       2 = Maintenance

ATI-CONTRACT           Alpha 10                                  BR151   BR156
Element: Contract

ATI-DUE-DATE           Numeric 8  (yyyymmdd)                     BR151
Element: Date          The transaction due date.

ATI-MAINT-SCHEDULE     Alpha 15                                  BR156
Element: Maint Schedule

ATI-INVOICE-PREFIX     Alpha 2                                   BR151   BR156
Element: Invoice Prefix

ATI-INVOICE-NBR        Numeric 8                                 BR151   BR156
Element: Invoice Nbr

                         ACPROFORMA FILE INDEX

NAME      KEY FIELDS    DESCRIPTION / SUBSET CONDITION           USED IN

ATISET1   INVOICE-TYPE                                           BR151   BR152
          CONTRACT                                               BR156   BR157
          DUE-DATE                                               BR252   BR52.1
          MAINT-SCHEDULE                                         BR54.2  BR54.3
                                                                 BR54.4  BRPI.1

ATISET2   CONTRACT      KeyChange
          MAINT-SCHEDULE
          INVOICE-TYPE
          DUE-DATE

                         ACPROFORMA FILE RELATIONS

ONE TO ONE RELATIONS


RELATION       RELATED
 NAME           FILE        INTEGRITY RULES / FIELD MATCH

Accntract      ACCNTRACT    Required

                            ATI-CONTRACT          -> CNT-CONTRACT  (CNTSET1)

                         ACPROFORMA FILE RELATIONS

ONE TO MANY RELATIONS


RELATION       RELATED
 NAME           FILE        INTEGRITY RULES / FIELD MATCH

Acmntsch       ACMNTSCH

                            ATI-CONTRACT          -> MSC-CONTRACT
                            ATI-MAINT-SCHEDULE    -> MSC-MAINT-SCHEDULE
                                                     MSC-OBJ-ID