Lawson Insight Technical Documentation

Generated by:
Documentation generated by Decision Analytics

ERDs Tables Conditions Elements Libraries APIs Forms

OISGBLK


                              OISGBLK FILE

This file stores interface user analysis data.

UPDATED BY

BL520     BL98.1    BL98.2

FIELD NAME             DESCRIPTION/VALID VALUES                  UPDATED BY

ISB-COMPANY            Numeric 4                                 BL520   BL98.1
Element: Company       Identifies the AP company if the          BL98.2
                       resource type = V.  Identifies the HR
                       company if the resource type = E.  It is
                       blank for type A, P or Q resources.

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

ISB-INVC-NUMBER        Numeric 8                                 BL520   BL98.1
Element: Invc Number   This field contains the invoice number    BL98.2
                       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                                 BL520   BL98.1
Element: Line Number   This field contains the line number.      BL98.2

ISB-SEQ                Numeric 3                                 BL520   BL98.1
Element: Sequence NumbeThis field contains the record sequence   BL98.2
                       number.

ISB-SEGMENT-BLOCK      Alpha 103                                 BL520   BL98.1
Element: User Analysis This field identifies the user analysis   BL98.2
                       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                                                BL520   BL98.1
          INVC-PREFIX                                            BL98.2
          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