Lawson Insight Technical Documentation

Generated by:
Documentation generated by Decision Analytics

ERDs Tables Conditions Elements Libraries APIs Forms

BLRIMAST


                             BLRIMAST FILE

                           Recurring Invoice

The Recurring Invoice file stores the parameters for a specific type of
service or combination of services. This sets the default for all customer
recurring invoices having the same recurring invoice number.

REFERENCED BY

BL230     BL231     BL232     BL33.1    BL331     BL34.1

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

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

BRM-RECUR-INVOICE      Alpha 10                                  BL130   BL30.1
Element: Recur Invoice The unique recurring invoice identifier.  BL30.2  BL30.3
                                                                 BL30.5  BL31.1
                                                                 BL31.2  BL31.3
                                                                 BL31.5  BL31.7
                                                                 BL32.1  BL32.2
                                                                 BL32.3  BL32.4

BRM-DESCRIPTION        Alpha 30  (Lower Case)                    BL130   BL30.1
Element: Description   This field displays the description.      BL30.2  BL30.3
                                                                 BL30.5  BL31.1
                                                                 BL31.2  BL31.3
                                                                 BL31.5  BL31.7
                                                                 BL32.1  BL32.2
                                                                 BL32.3  BL32.4

BRM-INVC-TYPE          Alpha 4                                   BL130   BL30.1
Element: Invoice Type  The invoice type for invoices created     BL30.2  BL30.3
                       for this recurring invoice.               BL30.5  BL31.1
                                                                 BL31.2  BL31.3
                                                                 BL31.5  BL31.7
                                                                 BL32.1  BL32.2
                                                                 BL32.3  BL32.4

BRM-LIST-NAME          Alpha 14                                  BL130   BL30.1
Element: List Name     The price list to use for all invoices    BL30.2  BL30.3
                       created for this recurring invoice. If    BL30.5  BL31.1
                       you do not enter this, the price list     BL31.2  BL31.3
                       for the customer will be used when        BL31.5  BL31.7
                       creating the invoices.                    BL32.1  BL32.2
                                                                 BL32.3  BL32.4

BRM-CURRENCY-CODE      Alpha 5                                   BL130   BL30.1
Element: Currency Code This field contains the company's base    BL30.2  BL30.3
                       currency code established in the General  BL30.5  BL31.1
                       Ledger system.                            BL31.2  BL31.3
                                                                 BL31.5  BL31.7
                                                                 BL32.1  BL32.2
                                                                 BL32.3  BL32.4

BRM-TERMS-CD           Alpha 5                                   BL130   BL30.1
Element: Terms Code    The terms code to use for invoices        BL30.2  BL30.3
                       created because of the recurring          BL30.5  BL31.1
                       invoice. If left blank, the customer's    BL31.2  BL31.3
                       terms code is used when the invoices are  BL31.5  BL31.7
                       created.                                  BL32.1  BL32.2
                                                                 BL32.3  BL32.4

BRM-REFERENCE          Alpha 10  (Lower Case)                    BL130   BL30.1
Element: Reference     The reference number associated with      BL30.2  BL30.3
                       the transaction.                          BL30.5  BL31.1
                                                                 BL31.2  BL31.3
                                                                 BL31.5  BL31.7
                                                                 BL32.1  BL32.2
                                                                 BL32.3  BL32.4

BRM-PROCESS-LEVEL      Alpha 5                                   BL130   BL30.1
Element: Process Level This field contains the process level,    BL30.2  BL30.3
                       which is the reporting hierarchy below    BL30.5  BL31.1
                       company.                                  BL31.2  BL31.3
                                                                 BL31.5  BL31.7
                                                                 BL32.1  BL32.2
                                                                 BL32.3  BL32.4

BRM-LOCATION           Alpha 5                                   BL130   BL30.1
Element: Location Code This field contains a valid stock         BL30.2  BL30.3
                       location within the company inventory.    BL30.5  BL31.1
                                                                 BL31.2  BL31.3
                                                                 BL31.5  BL31.7
                                                                 BL32.1  BL32.2
                                                                 BL32.3  BL32.4

BRM-TERRITORY          Alpha 4                                   BL130   BL30.1
Element: Sales TerritorSales territory. Invoices created for     BL30.2  BL30.3
                       this recurring invoice will have this     BL30.5  BL31.1
                       territory code. If left blank, the        BL31.2  BL31.3
                       invoice territory will default from the   BL31.5  BL31.7
                       customer at the time of creation.         BL32.1  BL32.2
                                                                 BL32.3  BL32.4

BRM-SALESMAN           Numeric 4                                 BL130   BL30.1
Element: Salesman NumbeThis field contains the code that         BL30.2  BL30.3
                       represents the primary sales              BL30.5  BL31.1
                       representative of this line. If left      BL31.2  BL31.3
                       blank, this defaults from the customer    BL31.5  BL31.7
                       file.                                     BL32.1  BL32.2
                                                                 BL32.3  BL32.4

BRM-SALESMAN-2         Numeric 4                                 BL130   BL30.1
Element: Salesman NumbeThis field contains the code              BL30.2  BL30.3
                       representing the second sales             BL30.5  BL31.1
                       representative. This defaults from the    BL31.2  BL31.3
                       customer file.                            BL31.5  BL31.7
                                                                 BL32.1  BL32.2
                                                                 BL32.3  BL32.4

BRM-COMM-RATE-1        Percent 7.5  (Percent)                    BL130   BL30.1
Element: Chrg Rate     This field contains the commission rate   BL30.2  BL30.3
                       of the primary sales representative.      BL30.5  BL31.1
                       This defaults from the customer file.     BL31.2  BL31.3
                                                                 BL31.5  BL31.7
                                                                 BL32.1  BL32.2
                                                                 BL32.3  BL32.4

BRM-COMM-RATE-2        Percent 7.5  (Percent)                    BL130   BL30.1
Element: Chrg Rate     This field contains the commission rate   BL30.2  BL30.3
                       for the second sales representative.      BL30.5  BL31.1
                       This defaults from the customer file.     BL31.2  BL31.3
                                                                 BL31.5  BL31.7
                                                                 BL32.1  BL32.2
                                                                 BL32.3  BL32.4

BRM-COMM-SPLIT         Percent 5.3  (Percent)                    BL130   BL30.1
Commission Split       This field contains the commission        BL30.2  BL30.3
Percentage             split. This defaults from the customer    BL30.5  BL31.1
                       file.                                     BL31.2  BL31.3
                                                                 BL31.5  BL31.7
                                                                 BL32.1  BL32.2
                                                                 BL32.3  BL32.4

BRM-FREQUENCY          Alpha 1                                   BL130   BL30.1
Element: Frequency     The billing frequency. This option        BL30.2  BL30.3
                       determines how often a customer getting   BL30.5  BL31.1
                       this service is billed.                   BL31.2  BL31.3
                       W = Weekly                                BL31.5  BL31.7
                       S = Semi-Monthly                          BL32.1  BL32.2
                       M = Monthly                               BL32.3  BL32.4
                       Q = Quarterly
                       Y = Yearly
                       U = User Defined

BRM-CYCLE-CODE         Alpha 3                                   BL130   BL30.1
Element: Authority CodeThe user-defined cycle code. Used to      BL30.2  BL30.3
                       group recurring invoices for creation at  BL30.5  BL31.1
                       a level lower than frequency.             BL31.2  BL31.3
                                                                 BL31.5  BL31.7
                                                                 BL32.1  BL32.2
                                                                 BL32.3  BL32.4

BRM-BILL-MONTH         Numeric 2                                 BL130   BL30.1
Element: Current PeriodIndicates which month the invoice is      BL30.2  BL30.3
                       due. This is valid only for quarterly     BL30.5  BL31.1
                       and yearly billing frequencies. For a     BL31.2  BL31.3
                       quarterly frequency, the valid values     BL31.5  BL31.7
                       are 1 through 3, and for a yearly         BL32.1  BL32.2
                       frequency, valid values are 1 through     BL32.3  BL32.4
                       12.
                       01 = January
                       02 = February
                       03 = March
                       04 = April
                       05 = May
                       06 = June
                       07 = July
                       08 = August
                       09 = September
                       10 = October
                       11 = November
                       12 = December

BRM-BILL-DAY           Numeric 2                                 BL130   BL30.1
Element: Posting Day   The day of the month an invoice is due.   BL30.2  BL30.3
                       This field is used for computing the      BL30.5  BL31.1
                       billing date; it is valid for             BL31.2  BL31.3
                       semi-monthly, monthly, quarterly, and     BL31.5  BL31.7
                       yearly billing frequencies. For a         BL32.1  BL32.2
                       semi-monthly invoice, values 1 through    BL32.3  BL32.4
                       15 are valid and for other frequencies,
                       values 1 through 31 are valid. If the
                       day entered is greater than the
                       available number of days in a billing
                       month, the last day of that month is
                       used to compute the billing date.

BRM-BILL-DAY-OF-WK     Numeric 1                                 BL130   BL30.1
Element: Day Of Week   The day of the week the invoice is for.   BL30.2  BL30.3
                       This is valid only for weekly billing     BL30.5  BL31.1
                       frequency.                                BL31.2  BL31.3
                       1 = Sunday                                BL31.5  BL31.7
                       2 = Monday                                BL32.1  BL32.2
                       3 = Tuesday                               BL32.3  BL32.4
                       4 = Wednesday
                       5 = Thursday
                       6 = Friday
                       7 = Saturday

BRM-NBR-OF-INVCS       Numeric 3                                 BL130   BL30.1
Element: Nbr Of Invcs  The total number of invoices to be        BL30.2  BL30.3
                       created for this recurring invoice.       BL30.5  BL31.1
                                                                 BL31.2  BL31.3
                                                                 BL31.5  BL31.7
                                                                 BL32.1  BL32.2
                                                                 BL32.3  BL32.4

BRM-START-DATE         Numeric 8  (yyyymmdd)                     BL130   BL30.1
Element: Start Date    Indicates when the template went into     BL30.2  BL30.3
                       effect. This determines when a customer   BL30.5  BL31.1
                       recurring invoice can be created.         BL31.2  BL31.3
                                                                 BL31.5  BL31.7
                                                                 BL32.1  BL32.2
                                                                 BL32.3  BL32.4

BRM-STOP-DATE          Numeric 8  (yyyymmdd)                     BL130   BL30.1
Element: Stop Date     The stop date for this template. After    BL30.2  BL30.3
                       this date, a customer service contract    BL30.5  BL31.1
                       can no longer be created. An existing     BL31.2  BL31.3
                       customer recurring invoice can still be   BL31.5  BL31.7
                       effective after this date.                BL32.1  BL32.2
                                                                 BL32.3  BL32.4

BRM-CURR-BILL-DATE     Numeric 8  (yyyymmdd)                     BL130   BL30.1
Element: Date          This indicates the current billing date   BL30.2  BL30.3
                       for this recurring invoice. This is used  BL30.5  BL31.1
                       as the basis to calculate the next        BL31.2  BL31.3
                       billing date for all billing frequencies  BL31.5  BL31.7
                       except the user-defined frequency. If     BL32.1  BL32.2
                       this field has zero value, the current    BL32.3  BL32.4
                       date is used as the basis to calculate
                       the next billing date.

BRM-ACTIVITY           Alpha 15                                  BL130   BL30.1
Element: Activity      Activities are the processes or           BL30.2  BL30.3
                       procedures that produce work. Cost        BL30.5  BL31.1
                       objects (products, services, customers,   BL31.2  BL31.3
                       and so on) are the reasons for            BL31.5  BL31.7
                       performing the activity. Activities and   BL32.1  BL32.2
                       cost object activities are used           BL32.3  BL32.4
                       synonymously in the Activity Management
                       system. Direct costs are posted to
                       activities, and indirect costs are
                       allocated to activities based on
                       activity drivers.

                       Activities are grouped or organized by
                       activity levels. There are two types of
                       activities: "posting allowed" and
                       "summary only." Use posting level
                       activities to budget and maintain all
                       posted transactions. Summary activities
                       or macro activities combine information
                       and balances from lower level activities
                       for reporting and inquiries.

BRM-ACCT-CATEGORY      Alpha 5                                   BL130   BL30.1
Element: Account CategoAccount categories are groupings of       BL30.2  BL30.3
                       costs, revenues, or a combination of      BL30.5  BL31.1
                       both used for reporting and inquiries     BL31.2  BL31.3
                       for activities in the Activity            BL31.5  BL31.7
                       Management system. All transactions are   BL32.1  BL32.2
                       posted to an account category within an   BL32.3  BL32.4
                       activity. You can assign a specific
                       general ledger account or range of
                       accounts (company, accounting unit,
                       account, and subaccount) that make up
                       the transactions posted to an account
                       category using AC07.1 (Account
                       Assignment).

                       Period-to-date, year-to-date, and
                       life-to-date balances are maintained by
                       account category for activities. Account
                       categories must be assigned to
                       activities before you do any budgeting
                       or transaction processing.

BRM-STD-COMM1          Alpha 4                                   BL130   BL30.1
Element: Standard CommeThe standard comment code. This comment   BL30.2  BL30.3
                       code will be attached to all customer     BL30.5  BL31.1
                       recurring invoices created.               BL31.2  BL31.3
                                                                 BL31.5  BL31.7
                                                                 BL32.1  BL32.2
                                                                 BL32.3  BL32.4

BRM-STD-COMM2          Alpha 4                                   BL130   BL30.1
Element: Standard CommeThe standard comment code. This comment   BL30.2  BL30.3
                       code will be attached to all customer     BL30.5  BL31.1
                       recurring invoices created.               BL31.2  BL31.3
                                                                 BL31.5  BL31.7
                                                                 BL32.1  BL32.2
                                                                 BL32.3  BL32.4

BRM-STD-COMM3          Alpha 4                                   BL130   BL30.1
Element: Standard CommeThe standard comment code. This comment   BL30.2  BL30.3
                       code will be attached to all customer     BL30.5  BL31.1
                       recurring invoices created.               BL31.2  BL31.3
                                                                 BL31.5  BL31.7
                                                                 BL32.1  BL32.2
                                                                 BL32.3  BL32.4

BRM-TRANS-USER1        Alpha 10                                  BL130   BL30.1
Element: Trans User1   User field 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

BRM-TRANS-USER2        Alpha 15                                  BL130   BL30.1
Element: Agent         User field 2.                             BL30.2  BL30.3
                                                                 BL30.5  BL31.1
                                                                 BL31.2  BL31.3
                                                                 BL31.5  BL31.7
                                                                 BL32.1  BL32.2
                                                                 BL32.3  BL32.4

BRM-TRANS-USER3        Numeric 8  (yyyymmdd)                     BL130   BL30.1
Element: Trans User3   User field 3.                             BL30.2  BL30.3
                                                                 BL30.5  BL31.1
                                                                 BL31.2  BL31.3
                                                                 BL31.5  BL31.7
                                                                 BL32.1  BL32.2
                                                                 BL32.3  BL32.4

BRM-TRANS-USER4        Numeric 9                                 BL130   BL30.1
Element: Trans User4   User field 4.                             BL30.2  BL30.3
                                                                 BL30.5  BL31.1
                                                                 BL31.2  BL31.3
                                                                 BL31.5  BL31.7
                                                                 BL32.1  BL32.2
                                                                 BL32.3  BL32.4

BRM-TRANS-USER5        Signed 18.2                               BL130   BL30.1
Element: Intl Amt      User field 5.                             BL30.2  BL30.3
                                                                 BL30.5  BL31.1
                                                                 BL31.2  BL31.3
                                                                 BL31.5  BL31.7
                                                                 BL32.1  BL32.2
                                                                 BL32.3  BL32.4

BRM-LAST-LINE-NBR      Numeric 6                                 BL130   BL30.1
Element: Line Number   This is the number of the last line       BL30.2  BL30.3
                       item added. It is used to determine the   BL30.5  BL31.1
                       number when the next line is added.       BL31.2  BL31.3
                                                                 BL31.5  BL31.7
                                                                 BL32.1  BL32.2
                                                                 BL32.3  BL32.4

BRM-LAST-MISC-SEQ      Numeric 3                                 BL130   BL30.1
Element: Sequence NumbeLast sequence number used for add-on      BL30.2  BL30.3
                       charges for this recurring invoice.       BL30.5  BL31.1
                                                                 BL31.2  BL31.3
                                                                 BL31.5  BL31.7
                                                                 BL32.1  BL32.2
                                                                 BL32.3  BL32.4

BRM-LAST-COMM-SEQ      Numeric 3                                 BL130   BL30.1
Element: Sequence NumbeThis is the sequence number of the last   BL30.2  BL30.3
                       comment line entered for this line.       BL30.5  BL31.1
                                                                 BL31.2  BL31.3
                                                                 BL31.5  BL31.7
                                                                 BL32.1  BL32.2
                                                                 BL32.3  BL32.4

BRM-USED-FL            Alpha 1                                   BL130   BL30.1
Element: Used          Flag to indicate whether this recurring   BL30.2  BL30.3
                       invoice has or did have any customer      BL30.5  BL31.1
                       recurring invoices created for it.        BL31.2  BL31.3
                       Y = Yes                                   BL31.5  BL31.7
                       N = No                                    BL32.1  BL32.2
                                                                 BL32.3  BL32.4

                         BLRIMAST FILE INDEX

NAME      KEY FIELDS    DESCRIPTION / SUBSET CONDITION           USED IN

BRMSET1   COMPANY                                                BL130   BL230
          RECUR-INVOICE                                          BL231   BL232
                                                                 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  BL33.1
                                                                 BL330   BL331
                                                                 BL34.1

BRMSET2   COMPANY       KeyChange                                BL130
          FREQUENCY
          RECUR-INVOICE

                         BLRIMAST FILE RELATIONS

ONE TO ONE RELATIONS


RELATION       RELATED
 NAME           FILE        INTEGRITY RULES / FIELD MATCH

Blrimsgblk     BLRIMSGBLK   Not Required

                            BRM-COMPANY          -> MSG-COMPANY
                            BRM-RECUR-INVOICE    -> MSG-RECUR-INVOICE
                            Zeroes               -> MSG-LINE-NBR
                            Zeroes               -> MSG-SEQ

Cucodes        CUCODES      Required

                            BRM-CURRENCY-CODE    -> CUC-CURRENCY-CODE

Iclocation     ICLOCATION   Required
                            When BRM-LOCATION != Spaces

                            BRM-COMPANY          -> ICL-COMPANY
                            BRM-LOCATION         -> ICL-LOCATION

Oecommhdr1     OECOMMHDR    Not Required
                            Valid When BRM-STD-COMM1 != Spaces

                            BRM-COMPANY          -> OCH-COMPANY
                            BRM-STD-COMM1        -> OCH-STD-COMM

Oecommhdr2     OECOMMHDR    Not Required
                            Valid When BRM-STD-COMM2 != Spaces

                            BRM-COMPANY          -> OCH-COMPANY
                            BRM-STD-COMM2        -> OCH-STD-COMM

Oecommhdr3     OECOMMHDR    Not Required
                            Valid When BRM-STD-COMM3 != Spaces

                            BRM-COMPANY          -> OCH-COMPANY
                            BRM-STD-COMM3        -> OCH-STD-COMM

Oecompany      OECOMPANY    Required

                            BRM-COMPANY          -> OEC-COMPANY

Oeinvctype     OEINVCTYPE   Required

                            BRM-COMPANY          -> OIN-COMPANY
                            BRM-INVC-TYPE        -> OIN-INVC-TYPE

Oeprclist      OEPRCLIST    Not Required
                            Valid When BRM-LIST-NAME != Spaces

                            BRM-COMPANY          -> OPL-COMPANY
                            Spaces               -> OPL-CUSTOMER
                            BRM-LIST-NAME        -> OPL-LIST-NAME
                            Spaces               -> OPL-PROMOTION

Oeproclev      OEPROCLEV    Required

                            BRM-COMPANY          -> OEP-COMPANY
                            BRM-PROCESS-LEVEL    -> OEP-PROCESS-LEVEL

Salesman       SALESREP     Required
                            When BRM-SALESMAN != Zeroes

                            BRM-COMPANY          -> SAW-COMPANY
                            BRM-SALESMAN         -> SAW-SALESMAN

Salesman2      SALESREP     Required
                            When BRM-SALESMAN-2 != Zeroes

                            BRM-COMPANY          -> SAW-COMPANY
                            BRM-SALESMAN-2       -> SAW-SALESMAN

Terms          TERMS        Required
                            When BRM-TERMS-CD != Spaces

                            BRM-TERMS-CD         -> TMS-TERMS-CD

Territory      TERITORY     Required
                            When BRM-TERRITORY != Spaces

                            BRM-COMPANY          -> TRY-COMPANY
                            BRM-TERRITORY        -> TRY-TERRITORY

                         BLRIMAST FILE RELATIONS

ONE TO MANY RELATIONS


RELATION       RELATED
 NAME           FILE        INTEGRITY RULES / FIELD MATCH

Oecustsrvc     BLRICUST

                            BRM-COMPANY          -> BRC-COMPANY
                            BRM-RECUR-INVOICE    -> BRC-RECUR-INVOICE
                                                    BRC-CUSTOMER

Oemscomm       BLRIMCOMM

                            BRM-COMPANY          -> BMC-COMPANY
                            BRM-RECUR-INVOICE    -> BMC-RECUR-INVOICE
                            Zeroes               -> BMC-LINE-NBR
                                                    BMC-SEQ

Oemsline       BLRIMLINE

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

Oemsmisc       BLRIMMISC

                            BRM-COMPANY          -> BMM-COMPANY
                            BRM-RECUR-INVOICE    -> BMM-RECUR-INVOICE
                            Zeroes               -> BMM-LINE-NBR
                                                    BMM-SEQ