Lawson Insight Technical Documentation

Generated by:
Documentation generated by Decision Analytics

ERDs Tables Conditions Elements Libraries APIs Forms

BLRICSGBLK


                            BLRICSGBLK FILE

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

UPDATED BY

BL130     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                                 BL130   BL31.1
Element: Company       Identifies the AP company if the          BL31.2  BL31.3
                       resource type = V.  Identifies the HR     BL31.5  BL31.7
                       company if the resource type = E.  It is  BL32.3  BL32.4
                       blank for type A, P or Q resources.       BL331

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

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

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

CGM-SEQ                Numeric 3                                 BL130   BL31.1
Element: Sequence NumbeThis field contains the record sequence   BL31.2  BL31.3
                       number.                                   BL31.5  BL31.7
                                                                 BL32.3  BL32.4
                                                                 BL331

CGM-SEGMENT-BLOCK      Alpha 103                                 BL130   BL31.1
Element: User Analysis This field identifies the user analysis   BL31.2  BL31.3
                       values included in the transaction.       BL31.5  BL31.7
                                                                 BL32.3  BL32.4
                       You can either type up to four values     BL331
                       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                                                BL130   BL31.1
          RECUR-INVOICE                                          BL31.2  BL31.3
          CUSTOMER                                               BL31.5  BL31.7
          LINE-NBR                                               BL32.3  BL32.4
          SEQ                                                    BL331

                         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