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

BL130     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                                 BL130   BL31.1
Element: Company       Identifies the AP company if the          BL31.2  BL31.3
                       resource type = V.  Identifies the HR     BL31.5  BL31.7
                       company if the resource type = E.  It is  BL32.3  BL32.4
                       blank for type A, P or Q resources.       BLI2.1

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

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

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

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

BUC-SEQ                Numeric 3                                 BL130   BL31.1
Element: Seq           This field contains the record sequence   BL31.2  BL31.3
                       number.                                   BL31.5  BL31.7
                                                                 BL32.3  BL32.4
                                                                 BLI2.1

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

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

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

                         BLRICCOMM FILE INDEX

NAME      KEY FIELDS    DESCRIPTION / SUBSET CONDITION           USED IN

BUCSET1   COMPANY                                                BL130   BL231
          RECUR-INVOICE                                          BL31.1  BL31.2
          CUSTOMER                                               BL31.3  BL31.5
          LINE-NBR                                               BL31.7  BL32.3
          SEQ                                                    BL32.4  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