Lawson Software

Lawson Insight Technical Documentation

Generated by:
Documentation generated by Decision Analytics

ERDs Tables Elements Libraries App Forms


                             BLRIMMISC FILE

                         Recurring Invoice AOC

This file stores the add-on charges attached to a recurring invoice or its
line items.  These will be copied to any customer recurring invoice created
from this recurring invoice.

REFERENCED BY

BL230

UPDATED BY

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

BMM-COMPANY          Numeric 4                                   BL30.2  BL30.5
Company              The company number represents an
                     established company and is entered on
                     all function codes.

BMM-RECUR-INVOICE    Alpha 10                                    BL30.2  BL30.5
Recur Invoice        This is the recurring invoice
                     identifier.

BMM-LINE-NBR         Numeric 6                                   BL30.2  BL30.5
Line Number          This field contains the line number.

BMM-SEQ              Numeric 3                                   BL30.2  BL30.5
Sequence Number      This field contains the record sequence
                     number.

BMM-MISC             Alpha 16                                    BL30.2  BL30.5
Misc                 The add-on charge code. Must exist in
                     the add-on charge master file.

BMM-ZERO-AFTER-USE   Alpha 1                                     BL30.2  BL30.5
Zero After Use       Indicates whether the charge amount
                     associated with the customer service
                     contract line is to be cleared once the
                     invoice is created. This is valid only
                     for flat amount type of charges.
                     Y = Yes
                     N = No

BMM-START-DATE       Numeric 8  (yyyymmdd)                       BL30.2  BL30.5
Start Date           The date on which this specific charge
                     went into effect. This field, along with
                     stop date, determines whether this
                     charge is added to the customer
                     recurring invoice when it is created.

BMM-STOP-DATE        Numeric 8  (yyyymmdd)                       BL30.2  BL30.5
Stop Date            The date on which this specific charge
                     is no longer in effect. This will
                     determine whether this add-on charge is
                     created for any customer recurring
                     invoices created from this recurring
                     invoice.

                         BLRIMMISC FILE INDEX

NAME      KEY FIELDS    DESCRIPTION / SUBSET CONDITION           USED IN

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

                         BLRIMMISC FILE RELATIONS

ONE TO ONE RELATIONS


RELATION       RELATED
 NAME           FILE        INTEGRITY RULES / FIELD MATCH

Blrimsgblk     BLRIMSGBLK   Not Required

                            BMM-COMPANY          -> MSG-COMPANY
                            BMM-RECUR-INVOICE    -> MSG-RECUR-INVOICE
                            BMM-LINE-NBR         -> MSG-LINE-NBR
                            BMM-SEQ              -> MSG-SEQ

Oecompany      OECOMPANY    Required

                            BMM-COMPANY          -> OEC-COMPANY

Oemastsrvc     BLRIMAST     Required

                            BMM-COMPANY          -> BRM-COMPANY
                            BMM-RECUR-INVOICE    -> BRM-RECUR-INVOICE

Oemisc         OEMISC       Required
                            When BMM-CURRENCY-CODE != Spaces

                            BMM-COMPANY          -> OEM-COMPANY
                            BMM-MISC             -> OEM-MISC
                            BRM-CURRENCY-CODE    -> OEM-CURRENCY-CODE

Oemsline       BLRIMLINE    Required
                            When BMM-LINE-NBR != Zeroes

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

                         BLRIMMISC FILE RELATIONS

ONE TO MANY RELATIONS


RELATION       RELATED
 NAME           FILE        INTEGRITY RULES / FIELD MATCH

Oecsmisc       BLRICMISC

                            BMM-COMPANY          -> BUM-COMPANY
                            BMM-RECUR-INVOICE    -> BUM-RECUR-INVOICE
                            BMM-LINE-NBR         -> BUM-MAST-LINE-NBR
                            BMM-SEQ              -> BUM-MAST-SEQ
                                                    BUM-CUSTOMER