Lawson Insight Technical Documentation

                             BLRICCOMM FILE

                      Cust. Recurring Invc Comment

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

REFERENCED BY

BL231

UPDATED BY

BL31.1    BL31.2    BL31.3    BL31.5    BL31.7    BL32.3
BL32.4    BL331     BLI2.1    BLI3.1

FIELD NAME           DESCRIPTION/VALID VALUES                    UPDATED BY

BUC-COMPANY          Numeric 4                                   BL31.1  BL31.2
Company              The company number represents an            BL31.3  BL31.5
                     established company and is entered on       BL31.7  BL32.3
                     all function codes.                         BL32.4  BLI2.1

BUC-RECUR-INVOICE    Alpha 10                                    BL31.1  BL31.2
Recur Invoice        This is the recurring invoice               BL31.3  BL31.5
                     identifier.                                 BL31.7  BL32.3
                                                                 BL32.4  BLI2.1

BUC-CUSTOMER         Alpha 9  (Right Justified)                  BL31.1  BL31.2
Customer Number      This field contains the number that         BL31.3  BL31.5
                     represents a customer.                      BL31.7  BL32.3
                                                                 BL32.4  BLI2.1

BUC-SHIP-TO          Numeric 4                                   BL31.1  BL31.2
Ship-to Code         This field contains the number              BL31.3  BL31.5
                     representing the ship to customer.          BL31.7  BL32.3
                                                                 BL32.4  BLI2.1

BUC-LINE-NBR         Numeric 6                                   BL31.1  BL31.2
Line Number          This field contains the line number.        BL31.3  BL31.5
                                                                 BL31.7  BL32.3
                                                                 BL32.4  BLI2.1

BUC-SEQ              Numeric 3                                   BL31.1  BL31.2
Sequence Number      This field contains the record sequence     BL31.3  BL31.5
                     number.                                     BL31.7  BL32.3
                                                                 BL32.4  BLI2.1

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

BUC-START-DATE       Numeric 8  (yyyymmdd)                       BL31.1  BL31.2
Start Date           This is the date on which this comment      BL31.3  BL31.5
                     will begin being used.                      BL31.7  BL32.3
                                                                 BL32.4  BLI2.1

BUC-STOP-DATE        Numeric 8  (yyyymmdd)                       BL31.1  BL31.2
Stop Date            This is the date this comment will stop     BL31.3  BL31.5
                     being used.                                 BL31.7  BL32.3
                                                                 BL32.4  BLI2.1

                         BLRICCOMM FILE INDEX

NAME      KEY FIELDS    DESCRIPTION / SUBSET CONDITION           USED IN

BUCSET1   COMPANY                                                BL231   BL31.1
          RECUR-INVOICE                                          BL31.2  BL31.3
          CUSTOMER                                               BL31.5  BL31.7
          LINE-NBR                                               BL32.3  BL32.4
          SEQ                                                    BL331   BLI2.1
                                                                 BLI3.1

                         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