Lawson Insight Technical Documentation


ERDs Tables Elements Libraries App Forms

                             BALFWDTOT FILE

                     AR Balance Forward Cust Totals

AR Balance Forward Cust Totals

UPDATED BY

AR150     AR301

FIELD NAME           DESCRIPTION/VALID VALUES                    UPDATED BY

BFT-COMPANY          Numeric 4                                   AR150
Company              Company number.

BFT-CUSTOMER         Alpha 9  (Right Justified)                  AR150
Customer             Customer number.

BFT-CURRENCY-CD      Alpha 5                                     AR150
Currency Code        Currency code identifying the balance
                     amount.

BFT-BALANCEF         Signed 15.2                                 AR150
Balance Amount       Balance amount as of the last statement
                     run.

BFT-DATE             Numeric 8  (yyyymmdd)                       AR150
Date                 "As of" date of the last statement run
                     for this customer.

                         BALFWDTOT FILE INDEX

NAME      KEY FIELDS    DESCRIPTION / SUBSET CONDITION           USED IN

BFTSET1   COMPANY       This path is used for record uniqueness  AR150   AR301
          CUSTOMER      and selection.
          CURRENCY-CD