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

This 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       The number representing an AR company.

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                                                AR150   AR301
          CUSTOMER
          CURRENCY-CD