Lawson Software

Lawson Insight Technical Documentation

Generated by:
Documentation generated by Decision Analytics

ERDs Tables Elements Libraries App Forms


                              OISGBLK FILE

This file stores interface user analysis data.

UPDATED BY

BL98.1    BL98.2

FIELD NAME           DESCRIPTION/VALID VALUES                    UPDATED BY

ISB-COMPANY          Numeric 4                                   BL98.1  BL98.2
Company              The company number represents an
                     established company and is entered on
                     all function codes.

ISB-INVC-PREFIX      Alpha 2                                     BL98.1  BL98.2
Invoice Prefix       This field contains the invoice prefix
                     that is assigned from either the company
                     or process level, depending on the
                     invoice-level option chosen.

ISB-INVC-NUMBER      Numeric 8                                   BL98.1  BL98.2
Invc Number          This field contains the invoice number
                     assigned by the system.  Invoice numbers
                     are assigned at the company or process
                     level, depending on an invoice-level
                     option on the company file.

ISB-LINE-NBR         Numeric 6                                   BL98.1  BL98.2
Line Number          This field contains the line number.

ISB-SEQ              Numeric 3                                   BL98.1  BL98.2
Sequence Number      This field contains the record sequence
                     number.

ISB-SEGMENT-BLOCK    Alpha 103                                   BL98.1  BL98.2
User Analysis        This field identifies the user analysis
                     values included in the transaction.

                     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.

                         OISGBLK FILE INDEX

NAME      KEY FIELDS    DESCRIPTION / SUBSET CONDITION           USED IN

ISBSET1   COMPANY                                                BL98.1  BL98.2
          INVC-PREFIX
          INVC-NUMBER
          LINE-NBR
          SEQ

                         OISGBLK FILE RELATIONS

ONE TO ONE RELATIONS


RELATION       RELATED
 NAME           FILE        INTEGRITY RULES / FIELD MATCH

Oeinvcline     OEINVCLINE   Not Required

                            ISB-COMPANY        -> OIL-COMPANY
                            ISB-INVC-PREFIX    -> OIL-INVC-PREFIX
                            ISB-INVC-NUMBER    -> OIL-INVC-NUMBER
                            ISB-LINE-NBR       -> OIL-LINE-NBR

Oeinvcmisc     OEINVCMISC   Not Required

                            ISB-COMPANY        -> OIM-COMPANY
                            ISB-INVC-PREFIX    -> OIM-INVC-PREFIX
                            ISB-INVC-NUMBER    -> OIM-INVC-NUMBER
                            ISB-LINE-NBR       -> OIM-LINE-NBR
                            ISB-SEQ            -> OIM-SEQ

Oeinvoice      OEINVOICE    Not Required

                            ISB-COMPANY        -> OEI-COMPANY
                            ISB-INVC-PREFIX    -> OEI-INVC-PREFIX
                            ISB-INVC-NUMBER    -> OEI-INVC-NUMBER

Oeinvsgblk     OEINVSGBLK   Not Required

                            ISB-COMPANY        -> OSB-COMPANY
                            ISB-INVC-PREFIX    -> OSB-INVC-PREFIX
                            ISB-INVC-NUMBER    -> OSB-INVC-NUMBER
                            ISB-LINE-NBR       -> OSB-LINE-NBR
                            ISB-SEQ            -> OSB-SEQ