Lawson Insight Technical Documentation

Generated by:
Documentation generated by Decision Analytics

ERDs Tables Conditions Elements Libraries APIs Forms

BALFWDTOT


                             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
Element: Company       Company number.

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

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

BFT-BALANCEF           Signed 18.2                               AR150
Element: Balance AmountBalance amount as of the last statement
                       run.

BFT-DATE               Numeric 8  (yyyymmdd)                     AR150
Element: 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