FRBALANCE FILE

                         FR Statement Balances

This file keeps a rolling, ten-period statement balance for use in receivable
reporting.

UPDATED BY

AR150

FIELD NAME           DESCRIPTION/VALID VALUES                    UPDATED BY

FRB-COMPANY          Numeric 4                                   AR150
Company              This field contains the company number
                     defined in the General Ledger, Accounts
                     Receivable, and Billing systems.

FRB-CUSTOMER         Alpha 9  (Right Justified)                  AR150
Customer Number      This field contains the customer
                     number, which is defined in the Accounts
                     Receivable system.

FRB-LAST-STA-DATE    Numeric 8  (yyyymmdd) Occurs 11 Times       AR150
Last Statement Date  This field contains the date of the
                     last statement created by FR150
                     (Statement Report) for the customer.

FRB-LAST-STA-BAL     Signed 15.2 Occurs 11 Times                 AR150
Last Statement       This field contains the balance of the
Balance              last statement created by FR150
                     (Statement Report) for the customer.

                         FRBALANCE FILE INDEX

NAME      KEY FIELDS    DESCRIPTION / SUBSET CONDITION           USED IN

FRBSET1   COMPANY                                                AR150
          CUSTOMER

                         FRBALANCE FILE RELATIONS

ONE TO ONE RELATIONS


RELATION       RELATED
 NAME           FILE        INTEGRITY RULES / FIELD MATCH

Arcomp         ARCOMP       Required

                            FRB-COMPANY       -> ACO-COMPANY

Arcustomer     ARCUSTOMER   Required

                            FRB-COMPANY       -> ACM-COMPANY
                            FRB-CUSTOMER      -> ACM-CUSTOMER

Custdesc       CUSTDESC     Required

                            ACO-CUST-GROUP    -> CUD-CUST-GROUP
                            FRB-CUSTOMER      -> CUD-CUSTOMER

Salesrep       SALESREP     Required

                            FRB-COMPANY       -> SAW-COMPANY
                            ACM-SALESMAN      -> SAW-SALESMAN