Lawson Software

Lawson Insight Technical Documentation

Generated by:
Documentation generated by Decision Analytics

ERDs Tables Elements Libraries App Forms


                            BLRICSGBLK FILE

This file relates to user analysis values from the Billing system Customer
Recurring invoice file and its related files.

UPDATED BY

BL31.1    BL31.2    BL31.3    BL31.5    BL31.7    BL32.3
BL32.4    BL331

FIELD NAME           DESCRIPTION/VALID VALUES                    UPDATED BY

CGM-COMPANY          Numeric 4                                   BL31.1  BL31.2
Company              The company number represents an            BL31.3  BL31.5
                     established company and is entered on       BL31.7  BL32.3
                     all function codes.                         BL32.4  BL331

CGM-RECUR-INVOICE    Alpha 10                                    BL31.1  BL31.2
Recur Invoice        This is the recurring invoice               BL31.3  BL31.5
                     identifier.                                 BL31.7  BL32.3
                                                                 BL32.4  BL331

CGM-CUSTOMER         Alpha 9  (Right Justified)                  BL31.1  BL31.2
Customer Number      This field contains the number that         BL31.3  BL31.5
                     represents a customer.                      BL31.7  BL32.3
                                                                 BL32.4  BL331

CGM-LINE-NBR         Numeric 6                                   BL31.1  BL31.2
Line Number          This field contains the line number.        BL31.3  BL31.5
                                                                 BL31.7  BL32.3
                                                                 BL32.4  BL331

CGM-SEQ              Numeric 3                                   BL31.1  BL31.2
Sequence Number      This field contains the record sequence     BL31.3  BL31.5
                     number.                                     BL31.7  BL32.3
                                                                 BL32.4  BL331

CGM-SEGMENT-BLOCK    Alpha 103                                   BL31.1  BL31.2
User Analysis        This field identifies the user analysis     BL31.3  BL31.5
                     values included in the transaction.         BL31.7  BL32.3
                                                                 BL32.4  BL331
                     You can either type up to four values
                     or use Define (F6) to open the User
                     Analysis Entry subform. Use this subform
                     to select the user analysis values you
                     want to include in the transaction. If
                     you choose to type values, use commas to
                     separate them. For example:
                     value1,value2,value3,value4

                     There are three conditions that affect
                     how you can select user analysis values.
                     See the User Analysis Entry form help or
                     the Strategic Ledger procedures manual
                     for additional information.

                         BLRICSGBLK FILE INDEX

NAME      KEY FIELDS    DESCRIPTION / SUBSET CONDITION           USED IN

CGMSET1   COMPANY                                                BL31.1  BL31.2
          RECUR-INVOICE                                          BL31.3  BL31.5
          CUSTOMER                                               BL31.7  BL32.3
          LINE-NBR                                               BL32.4  BL331
          SEQ

                         BLRICSGBLK FILE RELATIONS

ONE TO ONE RELATIONS


RELATION       RELATED
 NAME           FILE        INTEGRITY RULES / FIELD MATCH

Blricline      BLRICLINE    Not Required

                            CGM-COMPANY          -> BUL-COMPANY
                            CGM-RECUR-INVOICE    -> BUL-RECUR-INVOICE
                            CGM-CUSTOMER         -> BUL-CUSTOMER
                            CGM-LINE-NBR         -> BUL-LINE-NBR

Blricmisc      BLRICMISC    Not Required

                            CGM-COMPANY          -> BUM-COMPANY
                            CGM-RECUR-INVOICE    -> BUM-RECUR-INVOICE
                            CGM-CUSTOMER         -> BUM-CUSTOMER
                            CGM-LINE-NBR         -> BUM-LINE-NBR
                            CGM-SEQ              -> BUM-SEQ

Blricust       BLRICUST     Not Required

                            CGM-COMPANY          -> BRC-COMPANY
                            CGM-RECUR-INVOICE    -> BRC-RECUR-INVOICE
                            CGM-CUSTOMER         -> BRC-CUSTOMER