Lawson Software

Lawson Insight Technical Documentation

Generated by:
Documentation generated by Decision Analytics

ERDs Tables Elements Libraries App Forms


                             BALFWDTOT FILE

                     AR Balance Forward Cust Totals

The AR Balance Forward Cust Totals file contains the customer balance amount
by currency since the last run of AR150 (Statement Print) for customers that
are balance forward processing customers.

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