Lawson Software

Lawson Insight Technical Documentation

Generated by:
Documentation generated by Decision Analytics

ERDs Tables Elements Libraries App Forms


                             BILLOPER FILE

                              Billing User

The Billing User file restricts operator access to items and add-on charges
for recurring billing.

REFERENCED BY

BL215     BL31.1    BL31.2    BL31.3    BL31.5    BL31.7
BL32.3    BL32.4    BL33.1    BL34.1

UPDATED BY

BL15.1    BL16.1

FIELD NAME           DESCRIPTION/VALID VALUES                    UPDATED BY

BOP-COMPANY          Numeric 4                                   BL15.1  BL16.1
Company              The company number represents an
                     established company and is entered on
                     all function codes.

BOP-OPERATOR         Alpha 10                                    BL15.1  BL16.1
Operator Code        This field is used to store the login
                     ID of the person who entered the record.

BOP-ITEM             Alpha 32                                    BL15.1  BL16.1
Item Number          This field contains the item
                     identifier.

BOP-MISC             Alpha 16                                    BL15.1  BL16.1
Misc                 This field contains the add-on charge.

                         BILLOPER FILE INDEX

NAME      KEY FIELDS    DESCRIPTION / SUBSET CONDITION           USED IN

BOPSET1   COMPANY                                                BL215   BL31.1
          OPERATOR                                               BL31.2  BL31.3
          ITEM                                                   BL31.5  BL31.7
          MISC                                                   BL32.3  BL32.4
                                                                 BL33.1  BL34.1

BOPSET2   COMPANY       Subset                                   BL15.1
          OPERATOR      Where ITEM != Spaces
          ITEM

BOPSET3   COMPANY       Subset                                   BL16.1
          OPERATOR      Where MISC != Spaces
          MISC

                         BILLOPER FILE RELATIONS

ONE TO ONE RELATIONS


RELATION       RELATED
 NAME           FILE        INTEGRITY RULES / FIELD MATCH

Iccompany      ICCOMPANY    Required

                            BOP-COMPANY          -> ICC-COMPANY

Itemmast       ITEMMAST     Not Required
                            Valid When BOP-ITEM != Spaces

                            ICC-ITEM-GROUP       -> ITE-ITEM-GROUP
                            BOP-ITEM             -> ITE-ITEM

Oecompany      OECOMPANY    Required

                            BOP-COMPANY          -> OEC-COMPANY

Oemisc         OEMISC       Not Required
                            Valid When BOP-MISC != Spaces

                            BOP-COMPANY          -> OEM-COMPANY
                            BOP-MISC             -> OEM-MISC
                            OEC-CURRENCY-CODE    -> OEM-CURRENCY-CODE