Lawson Insight Technical Documentation

Generated by:
Documentation generated by Decision Analytics

ERDs Tables Conditions Elements Libraries APIs Forms

BLRIMMISC


                             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

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

BMM-COMPANY            Numeric 4                                 BL30.2  BL30.5
Element: Company       Identifies the AP company if the
                       resource type = V.  Identifies the HR
                       company if the resource type = E.  It is
                       blank for type A, P or Q resources.

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

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

BMM-SEQ                Numeric 3                                 BL30.2  BL30.5
Element: Seq           This field contains the record sequence
                       number.

BMM-MISC               Alpha 16                                  BL30.2  BL30.5
Element: 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
Element: All Flag      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
Element: 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
Element: 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.

BMM-TAX-EXEMPT-CD      Alpha 1                                   BL30.2  BL30.5
Element: Tax Exempt Cd Code indicating the taxing status. E -
                       Exempt, T - Taxable.

                         BLRIMMISC FILE INDEX

NAME      KEY FIELDS    DESCRIPTION / SUBSET CONDITION           USED IN

BMMSET1   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

                         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 BRM-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