Lawson Insight Technical Documentation

Generated by:
Documentation generated by Decision Analytics

ERDs Tables Conditions Elements Libraries APIs Forms

OEINVSGBLK


                            OEINVSGBLK FILE

This file relates to user analysis values from the Billing system Invoice
file and its related files. User analysis data is added to this file as
invoice options, line options, or add-on charge additional information in the
Billing system.

UPDATED BY

AR21.6    BL120     BL122     BL123     BL130     BL20.1
BL20.3    BL21.2    BL21.5    BL217     BL29.1    BL29.2
BL320     BL520     BL80.1    BL81.1    BL820     BL92.1
OE114     OE129     OE30.1    OE30.2    OE30.3    OE30.4
OE30.5    OE30.6    OE30.7    OE30.9    OE310     OE330
OE530     OE830

FIELD NAME             DESCRIPTION/VALID VALUES                  UPDATED BY

OSB-COMPANY            Numeric 4                                 AR21.6  BL120
Element: Company       Identifies the AP company if the          BL122   BL123
                       resource type = V.  Identifies the HR     BL130   BL20.1
                       company if the resource type = E.  It is  BL20.3  BL21.2
                       blank for type A, P or Q resources.       BL21.5  BL217
                                                                 BL29.1  BL29.2
                                                                 BL320   BL520
                                                                 BL80.1  BL81.1
                                                                 BL820   BL92.1
                                                                 OE114   OE129
                                                                 OE30.1  OE30.2
                                                                 OE30.3  OE30.4
                                                                 OE30.5  OE30.6
                                                                 OE30.7  OE30.9
                                                                 OE310   OE330
                                                                 OE530   OE830

OSB-INVC-PREFIX        Alpha 2                                   AR21.6  BL120
Element: Invoice PrefixThis field contains the invoice prefix    BL122   BL123
                       that is assigned from either the company  BL130   BL20.1
                       or process level, depending on the        BL20.3  BL21.2
                       invoice-level option chosen.              BL21.5  BL217
                                                                 BL29.1  BL29.2
                                                                 BL320   BL520
                                                                 BL80.1  BL81.1
                                                                 BL820   BL92.1
                                                                 OE114   OE129
                                                                 OE30.1  OE30.2
                                                                 OE30.3  OE30.4
                                                                 OE30.5  OE30.6
                                                                 OE30.7  OE30.9
                                                                 OE310   OE330
                                                                 OE530   OE830

OSB-INVC-NUMBER        Numeric 8                                 AR21.6  BL120
Element: Invc Number   This field contains the invoice number    BL122   BL123
                       assigned by the system.  Invoice numbers  BL130   BL20.1
                       are assigned at the company or process    BL20.3  BL21.2
                       level, depending on an invoice-level      BL21.5  BL217
                       option on the company file.               BL29.1  BL29.2
                                                                 BL320   BL520
                                                                 BL80.1  BL81.1
                                                                 BL820   BL92.1
                                                                 OE114   OE129
                                                                 OE30.1  OE30.2
                                                                 OE30.3  OE30.4
                                                                 OE30.5  OE30.6
                                                                 OE30.7  OE30.9
                                                                 OE310   OE330
                                                                 OE530   OE830

OSB-LINE-NBR           Numeric 6                                 AR21.6  BL120
Element: Line Number   This field contains the line number.      BL122   BL123
                                                                 BL130   BL20.1
                                                                 BL20.3  BL21.2
                                                                 BL21.5  BL217
                                                                 BL29.1  BL29.2
                                                                 BL320   BL520
                                                                 BL80.1  BL81.1
                                                                 BL820   BL92.1
                                                                 OE114   OE129
                                                                 OE30.1  OE30.2
                                                                 OE30.3  OE30.4
                                                                 OE30.5  OE30.6
                                                                 OE30.7  OE30.9
                                                                 OE310   OE330
                                                                 OE530   OE830

OSB-SEQ                Numeric 3                                 AR21.6  BL120
Element: Sequence NumbeThis field contains the record sequence   BL122   BL123
                       number.                                   BL130   BL20.1
                                                                 BL20.3  BL21.2
                                                                 BL21.5  BL217
                                                                 BL29.1  BL29.2
                                                                 BL320   BL520
                                                                 BL80.1  BL81.1
                                                                 BL820   BL92.1
                                                                 OE114   OE129
                                                                 OE30.1  OE30.2
                                                                 OE30.3  OE30.4
                                                                 OE30.5  OE30.6
                                                                 OE30.7  OE30.9
                                                                 OE310   OE330
                                                                 OE530   OE830

OSB-SEGMENT-BLOCK      Alpha 103                                 AR21.6  BL120
Element: User Analysis This field identifies the user analysis   BL122   BL123
                       values included in the transaction.       BL130   BL20.1
                                                                 BL20.3  BL21.2
                       You can either type up to four values     BL21.5  BL217
                       or use Define (F6) to open the User       BL29.1  BL29.2
                       Analysis Entry subform. Use this subform  BL320   BL520
                       to select the user analysis values you    BL80.1  BL81.1
                       want to include in the transaction. If    BL820   BL92.1
                       you choose to type values, use commas to  OE114   OE129
                       separate them. For example:               OE30.1  OE30.2
                       value1,value2,value3,value4               OE30.3  OE30.4
                                                                 OE30.5  OE30.6
                       There are three conditions that affect    OE30.7  OE30.9
                       how you can select user analysis values.  OE310   OE330
                       See the User Analysis Entry form help or  OE530   OE830
                       the Strategic Ledger procedures manual
                       for additional information.

                         OEINVSGBLK FILE INDEX

NAME      KEY FIELDS    DESCRIPTION / SUBSET CONDITION           USED IN

OSBSET1   COMPANY       This index is used to access             AR21.6  BL120
          INVC-PREFIX   invoice-line user analysis records for a BL122   BL123
          INVC-NUMBER   specific company, invoice prefix,        BL130   BL20.1
          LINE-NBR      invoice number, line number, sequence,   BL20.3  BL21.2
          SEQ           and segment block.                       BL21.5  BL217
                                                                 BL29.1  BL29.2
                                                                 BL320   BL520
                                                                 BL80.1  BL81.1
                                                                 BL820   BL92.1
                                                                 OE114   OE129
                                                                 OE30.1  OE30.2
                                                                 OE30.3  OE30.4
                                                                 OE30.5  OE30.6
                                                                 OE30.7  OE30.9
                                                                 OE310   OE330
                                                                 ...

                         OEINVSGBLK FILE RELATIONS

ONE TO ONE RELATIONS


RELATION       RELATED
 NAME           FILE        INTEGRITY RULES / FIELD MATCH

Oeinvcline     OEINVCLINE   Not Required

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

Oeinvcmisc     OEINVCMISC   Not Required

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

Oeinvoice      OEINVOICE    Not Required

                            OSB-COMPANY        -> OEI-COMPANY
                            OSB-INVC-PREFIX    -> OEI-INVC-PREFIX
                            OSB-INVC-NUMBER    -> OEI-INVC-NUMBER