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
 |