Lawson Insight Technical Documentation

Generated by:
Documentation generated by Decision Analytics

ERDs Tables Conditions Elements Libraries APIs Forms

BILLOPER


                             BILLOPER FILE

                              Billing User

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

REFERENCED BY

BL130     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
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.

BOP-OPERATOR           Alpha 10                                  BL15.1  BL16.1
Element: 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
Element: Item Number   This field contains the item
                       identifier.

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

                         BILLOPER FILE INDEX

NAME      KEY FIELDS    DESCRIPTION / SUBSET CONDITION           USED IN

BOPSET1   COMPANY                                                BL130   BL215
          OPERATOR                                               BL31.1  BL31.2
          ITEM                                                   BL31.3  BL31.5
          MISC                                                   BL31.7  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