Lawson Insight Technical Documentation

Generated by:
Documentation generated by Decision Analytics

ERDs Tables Conditions Elements Libraries APIs Forms

BLRIMLINE


                             BLRIMLINE FILE

                         Recurring Invoice Item

This file stores the line items for this recurring invoice.  These line items
will be created on any customer recurring invoice associated with 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

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

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

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

BML-ITEM               Alpha 32                                  BL30.3  BL30.5
Element: Item          This field contains the item              BL32.2
                       identifier.

BML-QUANTITY           Signed 13.4                               BL30.3  BL30.5
Element: Quantity      This field contains the quantity to be    BL32.2
                       billed each period. It is required if
                       the zero after use flag is set off.

BML-SELL-UOM           Alpha 4                                   BL30.3  BL30.5
Element: Uom           This field contains the stock unit of     BL32.2
                       measure for the item.

BML-UNIT-PRICE         Signed 18.5                               BL30.3  BL30.5
Element: Intl Cost                                               BL32.2

BML-SPR-UOM            Alpha 4                                   BL30.3  BL30.5
Element: Uom           The pricing unit of measure for this      BL32.2
                       line.

BML-ZERO-AFTER-USE     Alpha 1                                   BL30.3  BL30.5
Element: All Flag      Indicates whether the quantity field in   BL32.2
                       the customer contract service line is to
                       be cleared once the current invoice is
                       created. This option is useful for
                       charges that vary from invoice to
                       invoice, based on some metering.
                       Y = Yes
                       N = No

BML-START-DATE         Numeric 8  (yyyymmdd)                     BL30.3  BL30.5
Element: Start Date    Indicates when this line went into        BL32.2
                       effect. This line will be added to a
                       customer recurring invoice created after
                       this date, provided the creation date is
                       not greater than the stop date.

BML-STOP-DATE          Numeric 8  (yyyymmdd)                     BL30.3  BL30.5
Element: Stop Date     The stop date for this line. After this   BL32.2
                       date, this line will no longer be added
                       to the customer recurring invoice when
                       it is created.

BML-TERRITORY          Alpha 4                                   BL30.3  BL30.5
Element: Territory     Sales territory. If left blank, the       BL32.2
                       territory will default from the customer
                       when the actual invoices are created for
                       this recurring invoice line.

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

BML-SALESMAN-2         Numeric 4                                 BL30.3  BL30.5
Element: Salesman      This field contains the code              BL32.2
                       representing the second sales
                       representative. This defaults from the
                       customer file.

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

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

BML-COMM-SPLIT         Percent 5.3  (Percent)                    BL30.3  BL30.5
Element: Comm Split    This field contains the commission        BL32.2
                       split. This defaults from the customer
                       file.

BML-STD-COMM1          Alpha 4                                   BL30.3  BL30.5
Element: Std Comm      Standard comment code points to a group   BL32.2
                       of comments to be copied onto invoices
                       created for this recurring invoice line.

BML-STD-COMM2          Alpha 4                                   BL30.3  BL30.5
Element: Std Comm      Standard comment code points to a group   BL32.2
                       of comments to be copied onto invoices
                       created for this recurring invoice line.

BML-STD-COMM3          Alpha 4                                   BL30.3  BL30.5
Element: Std Comm      Standard comment code points to a group   BL32.2
                       of comments to be copied onto invoices
                       created for this recurring invoice line.

BML-LAST-MISC-SEQ      Numeric 3                                 BL30.3  BL30.5
Element: Seq           Last sequence number used for add-on      BL32.2
                       charges attached to this recurring
                       invoice line.

BML-LAST-COMM-SEQ      Numeric 3                                 BL30.3  BL30.5
Element: Seq           This is the sequence number of the last   BL32.2
                       comment line entered for this line.

BML-ITEM-16            Derived
Element: Item 16       This field contains the first 16
                       characters of the item's identifier.
                       This information is used by inquiries
                       and reports.

BML-TAX-CODE           Alpha 10                                  BL30.3  BL30.5
Element: Tax Code      This field contains a code representing   BL32.2
                       specific tax information.  This must be
                       valid Tax Code.


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

BML-ACTIVITY           Alpha 15                                  BL30.3  BL30.5
Element: Activity      Activities are the processes or           BL32.2
                       procedures that produce work. Cost
                       objects (products, services, customers,
                       and so on) are the reasons for
                       performing the activity.


BML-ACCT-CATEGORY      Alpha 5                                   BL30.3  BL30.5
Element: Acct Category Account categories are groupings of       BL32.2
                       costs, revenues, or a combination of
                       both used for reporting and inquiries
                       for activities in the Activity
                       Management system. All transactions are
                       posted to an account category within an
                       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.

                       Valid account category types are:
                       cost
                       revenue
                       accrual
                       pass thru

BML-ITEM-DESC          Alpha 30  (Lower Case)                    BL30.3  BL30.5
Element: Description   This field displays the description.      BL32.2

BML-LINE-TYPE          Alpha 1                                   BL30.3  BL30.5
Element: Line Type     This field contains the type of           BL32.2
                       inventory on this line.
                       I = Inventory
                       N = Non-Stock
                       X = Special

                         BLRIMLINE FILE INDEX

NAME      KEY FIELDS    DESCRIPTION / SUBSET CONDITION           USED IN

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

                         BLRIMLINE FILE RELATIONS

ONE TO ONE RELATIONS


RELATION       RELATED
 NAME           FILE        INTEGRITY RULES / FIELD MATCH

Blrimsgblk     BLRIMSGBLK   Not Required

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

Iccompany      ICCOMPANY    Required

                            BML-COMPANY          -> ICC-COMPANY

Itemmast       ITEMMAST     Required
                            When BML-LINE-TYPE = "N"
                            Or   BML-LINE-TYPE = "I"

                            ICC-ITEM-GROUP       -> ITE-ITEM-GROUP
                            BML-ITEM             -> ITE-ITEM

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

                            BML-COMPANY          -> OCH-COMPANY
                            BML-STD-COMM1        -> OCH-STD-COMM

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

                            BML-COMPANY          -> OCH-COMPANY
                            BML-STD-COMM2        -> OCH-STD-COMM

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

                            BML-COMPANY          -> OCH-COMPANY
                            BML-STD-COMM3        -> OCH-STD-COMM

Oecompany      OECOMPANY    Required

                            BML-COMPANY          -> OEC-COMPANY

Oemastsrvc     BLRIMAST     Required

                            BML-COMPANY          -> BRM-COMPANY
                            BML-RECUR-INVOICE    -> BRM-RECUR-INVOICE

Salesman       SALESREP     Required
                            When BML-SALESMAN != Zeroes

                            BML-COMPANY          -> SAW-COMPANY
                            BML-SALESMAN         -> SAW-SALESMAN

Salesman 2     SALESREP     Required
                            When BML-SALESMAN-2 != Zeroes

                            BML-COMPANY          -> SAW-COMPANY
                            BML-SALESMAN-2       -> SAW-SALESMAN

Territory      TERITORY     Required
                            When BML-TERRITORY != Spaces

                            BML-COMPANY          -> TRY-COMPANY
                            BML-TERRITORY        -> TRY-TERRITORY

                         BLRIMLINE FILE RELATIONS

ONE TO MANY RELATIONS


RELATION       RELATED
 NAME           FILE        INTEGRITY RULES / FIELD MATCH

Oecsline       BLRICLINE

                            BML-COMPANY          -> BUL-COMPANY
                            BML-RECUR-INVOICE    -> BUL-RECUR-INVOICE
                            BML-LINE-NBR         -> BUL-MAST-LINE-NBR
                                                    BUL-CUSTOMER

Oemscomm       BLRIMCOMM

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

Oemsmisc       BLRIMMISC

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