Lawson Insight Technical Documentation


ERDs Tables Elements Libraries App Forms

                             BLRIMCOMM FILE

                       Recurring Invoice Comment

This file stores comments attached to a recurring invoice or its line items.
These comments will be copied to any customer recurring invoice created for
this recurring invoice.

REFERENCED BY

BL230

UPDATED BY

BL130     BL30.1    BL30.2    BL30.3    BL30.5    BL31.1
BL31.2    BL31.3    BL31.5    BL31.7    BL32.1    BL32.2
BL32.3    BL32.4    BL330

FIELD NAME           DESCRIPTION/VALID VALUES                    UPDATED BY

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

BMC-RECUR-INVOICE    Alpha 10                                    BL32.1  BL32.2
Recurring Invoice    This is the recurring invoice
                     identifier.

BMC-LINE-NBR         Numeric 6                                   BL32.1  BL32.2
Line Number          This field contains the line number.

BMC-SEQ              Numeric 3                                   BL32.1  BL32.2
Sequence Number      This field contains the record sequence
                     number.

BMC-COMMENT          Alpha 40  (Lower Case)                      BL32.1  BL32.2
Comment Line         This field contains the comment
                     narrative.

BMC-PRINT-CODE       Alpha 1                                     BL32.1  BL32.2
Print Code           This field contains the print code,
                     which defines where comments are
                     displayed or printed.

BMC-START-DATE       Numeric 8  (yyyymmdd)                       BL32.1  BL32.2
Start Date           This comment is only active after this
                     date.

BMC-STOP-DATE        Numeric 8  (yyyymmdd)                       BL32.1  BL32.2
Stop Date            This comment is no longer effective
                     after this date.

                         BLRIMCOMM FILE INDEX

NAME      KEY FIELDS    DESCRIPTION / SUBSET CONDITION           USED IN

BMCSET1   COMPANY                                                BL130   BL230
          RECUR-INVOICE                                          BL30.1  BL30.2
          LINE-NBR                                               BL30.3  BL30.5
          SEQ                                                    BL31.1  BL31.2
                                                                 BL31.3  BL31.5
                                                                 BL31.7  BL32.1
                                                                 BL32.2  BL32.3
                                                                 BL32.4  BL330

                         BLRIMCOMM FILE RELATIONS

ONE TO ONE RELATIONS


RELATION       RELATED
 NAME           FILE        INTEGRITY RULES / FIELD MATCH

Blrimline      BLRIMLINE    Required

                            BMC-COMPANY          -> BML-COMPANY
                            BMC-RECUR-INVOICE    -> BML-RECUR-INVOICE
                            BMC-LINE-NBR         -> BML-LINE-NBR