Lawson Software

Lawson Insight Technical Documentation

Generated by:
Documentation generated by Decision Analytics

ERDs Tables Elements Libraries App Forms


                             BLRICCOMM FILE

                      Cust. Recurring Invc Comment

This file stores comments associated with customer recurring invoice and
invoice lines.

UPDATED BY

BLI2.1    BLI3.1

FIELD NAME           DESCRIPTION/VALID VALUES                    UPDATED BY

BUC-COMPANY          Numeric 4                                   BLI2.1
Company              The company number represents an
                     established company and is entered on
                     all function codes.


BUC-RECUR-INVOICE    Alpha 10                                    BLI2.1
Recur Invoice        This is the recurring invoice
                     identifier.

BUC-CUSTOMER         Alpha 9  (Right Justified)                  BLI2.1
Customer Number      This field contains the number that
                     represents a customer.

BUC-SHIP-TO          Numeric 4                                   BLI2.1
Ship-to Code         This field contains the number
                     representing the ship to customer.

BUC-LINE-NBR         Numeric 6                                   BLI2.1
Line Number          This field contains the line number.

BUC-SEQ              Numeric 3                                   BLI2.1
Sequence Number      This field contains the record sequence
                     number.


BUC-PRINT-CODE       Alpha 1                                     BLI2.1
Print Code           This field contains the print code,
                     which defines where comments are
                     displayed or printed.
                     B = Both print and display
                     D = Display only
                     P = Print only

BUC-START-DATE       Numeric 8  (yyyymmdd)                       BLI2.1
Start Date           This is the date on which this comment
                     will begin being used.

BUC-STOP-DATE        Numeric 8  (yyyymmdd)                       BLI2.1
Stop Date            This is the date this comment will stop
                     being used.

                         BLRICCOMM FILE INDEX

NAME      KEY FIELDS    DESCRIPTION / SUBSET CONDITION           USED IN

BUCSET1   COMPANY                                                BLI2.1  BLI3.1
          RECUR-INVOICE
          CUSTOMER
          LINE-NBR
          SEQ

                         BLRICCOMM FILE RELATIONS

ONE TO ONE RELATIONS


RELATION       RELATED
 NAME           FILE        INTEGRITY RULES / FIELD MATCH

Blricline      BLRICLINE    Required

                            BUC-COMPANY          -> BUL-COMPANY
                            BUC-RECUR-INVOICE    -> BUL-RECUR-INVOICE
                            BUC-CUSTOMER         -> BUL-CUSTOMER
                            BUC-LINE-NBR         -> BUL-LINE-NBR