Lawson Insight Technical Documentation

Generated by:
Documentation generated by Decision Analytics

ERDs Tables Conditions Elements Libraries APIs Forms

FRBALANCE


                             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
Element: Company       This field contains the company number
                       defined in the General Ledger, Accounts
                       Receivable, and Billing systems.

FRB-CUSTOMER           Alpha 9  (Right Justified)                AR150
Element: Customer      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
Element: Last StatementThis field contains the date of the last
                       statement created by FR150 (Statement
                       Report) for the customer.

FRB-LAST-STA-BAL       Signed 18.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       -> -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