Lawson Insight Technical Documentation


ERDs Tables Elements Libraries App Forms

                              COSGBLK FILE

This file stores user analysis values for order header-, line-, and add-on
charge- related records.

UPDATED BY

BL92.1    OE10.1    OE10.2    OE10.3    OE10.4    OE10.5
OE10.6    OE10.7    OE10.8    OE11.1    OE11.4    OE11.8
OE11.9    OE110     OE113     OE114     OE129     OE14.4
OE15.1    OE15.2    OE15.3    OE15.4    OE15.5    OE15.7
OE30.1    OE30.2    OE30.3    OE30.4    OE30.5    OE30.6
OE30.7    OE30.9    OE310     OE510     OE80.1    OE81.1
OE810     OE830     OE90.1    OE920     OE950     WH20.2
WH20.7

FIELD NAME           DESCRIPTION/VALID VALUES                    UPDATED BY

OSG-COMPANY          Numeric 4                                   BL92.1  OE10.1
Company              The company number represents an            OE10.2  OE10.3
                     established company and is entered on       OE10.4  OE10.5
                     all function codes.                         OE10.6  OE10.7
                                                                 OE10.8  OE11.1
                                                                 OE11.4  OE11.8
                                                                 OE11.9  OE110
                                                                 OE113   OE114
                                                                 OE129   OE14.4
                                                                 OE15.1  OE15.2
                                                                 OE15.3  OE15.4
                                                                 OE15.5  OE15.7
                                                                 OE30.1  OE30.2
                                                                 OE30.3  OE30.4
                                                                 OE30.5  OE30.6
                                                                 OE30.7  OE30.9
                                                                 OE310   OE510
                                                                 OE80.1  OE81.1
                                                                 OE810   OE830
                                                                 OE90.1  OE920
                                                                 OE950   WH20.2
                                                                 WH20.7

OSG-ORDER-NBR        Numeric 8                                   BL92.1  OE10.1
Order Number         This field contains the order number.       OE10.2  OE10.3
                                                                 OE10.4  OE10.5
                                                                 OE10.6  OE10.7
                                                                 OE10.8  OE11.1
                                                                 OE11.4  OE11.8
                                                                 OE11.9  OE110
                                                                 OE113   OE114
                                                                 OE129   OE14.4
                                                                 OE15.1  OE15.2
                                                                 OE15.3  OE15.4
                                                                 OE15.5  OE15.7
                                                                 OE30.1  OE30.2
                                                                 OE30.3  OE30.4
                                                                 OE30.5  OE30.6
                                                                 OE30.7  OE30.9
                                                                 OE310   OE510
                                                                 OE80.1  OE81.1
                                                                 OE810   OE830
                                                                 OE90.1  OE920
                                                                 OE950   WH20.2
                                                                 WH20.7

OSG-LINE-NBR         Numeric 6                                   BL92.1  OE10.1
Line Number          This field contains the line number.        OE10.2  OE10.3
                                                                 OE10.4  OE10.5
                                                                 OE10.6  OE10.7
                                                                 OE10.8  OE11.1
                                                                 OE11.4  OE11.8
                                                                 OE11.9  OE110
                                                                 OE113   OE114
                                                                 OE129   OE14.4
                                                                 OE15.1  OE15.2
                                                                 OE15.3  OE15.4
                                                                 OE15.5  OE15.7
                                                                 OE30.1  OE30.2
                                                                 OE30.3  OE30.4
                                                                 OE30.5  OE30.6
                                                                 OE30.7  OE30.9
                                                                 OE310   OE510
                                                                 OE80.1  OE81.1
                                                                 OE810   OE830
                                                                 OE90.1  OE920
                                                                 OE950   WH20.2
                                                                 WH20.7

OSG-SEQ              Numeric 3                                   BL92.1  OE10.1
Sequence Number      This field contains the record sequence     OE10.2  OE10.3
                     number.                                     OE10.4  OE10.5
                                                                 OE10.6  OE10.7
                                                                 OE10.8  OE11.1
                                                                 OE11.4  OE11.8
                                                                 OE11.9  OE110
                                                                 OE113   OE114
                                                                 OE129   OE14.4
                                                                 OE15.1  OE15.2
                                                                 OE15.3  OE15.4
                                                                 OE15.5  OE15.7
                                                                 OE30.1  OE30.2
                                                                 OE30.3  OE30.4
                                                                 OE30.5  OE30.6
                                                                 OE30.7  OE30.9
                                                                 OE310   OE510
                                                                 OE80.1  OE81.1
                                                                 OE810   OE830
                                                                 OE90.1  OE920
                                                                 OE950   WH20.2
                                                                 WH20.7

OSG-SEGMENT-BLOCK    Alpha 103                                   BL92.1  OE10.1
User Analysis        This field identifies the user analysis     OE10.2  OE10.3
                     values included in the transaction.         OE10.4  OE10.5
                                                                 OE10.6  OE10.7
                     You can either type up to four values       OE10.8  OE11.1
                     or use Define (F6) to open the User         OE11.4  OE11.8
                     Analysis Entry subform. Use this subform    OE11.9  OE110
                     to select the user analysis values you      OE113   OE114
                     want to include in the transaction. If      OE129   OE14.4
                     you choose to type values, use commas to    OE15.1  OE15.2
                     separate them. For example:                 OE15.3  OE15.4
                     value1,value2,value3,value4                 OE15.5  OE15.7
                                                                 OE30.1  OE30.2
                     There are three conditions that affect      OE30.3  OE30.4
                     how you can select user analysis values.    OE30.5  OE30.6
                     See the User Analysis Entry form help or    OE30.7  OE30.9
                     the Strategic Ledger procedures manual      OE310   OE510
                     for additional information.                 OE80.1  OE81.1
                                                                 OE810   OE830
                                                                 OE90.1  OE920
                                                                 OE950   WH20.2
                                                                 WH20.7

                         COSGBLK FILE INDEX

NAME      KEY FIELDS    DESCRIPTION / SUBSET CONDITION           USED IN

OSGSET1   COMPANY                                                BL92.1  OE10.1
          ORDER-NBR                                              OE10.2  OE10.3
          LINE-NBR                                               OE10.4  OE10.5
          SEQ                                                    OE10.6  OE10.7
                                                                 OE10.8  OE11.1
                                                                 OE11.4  OE11.8
                                                                 OE11.9  OE110
                                                                 OE113   OE114
                                                                 OE129   OE14.4
                                                                 OE15.1  OE15.2
                                                                 OE15.3  OE15.4
                                                                 OE15.5  OE15.7
                                                                 OE30.1  OE30.2
                                                                 OE30.3  OE30.4
                                                                 OE30.5  OE30.6
                                                                 ...

                         COSGBLK FILE RELATIONS

ONE TO ONE RELATIONS


RELATION       RELATED
 NAME           FILE        INTEGRITY RULES / FIELD MATCH

Coline         COLINE       Not Required

                            OSG-COMPANY      -> COL-COMPANY
                            OSG-ORDER-NBR    -> COL-ORDER-NBR
                            OSG-LINE-NBR     -> COL-LINE-NBR

Comisc         COMISC       Not Required

                            OSG-COMPANY      -> CMC-COMPANY
                            OSG-ORDER-NBR    -> CMC-ORDER-NBR
                            OSG-LINE-NBR     -> CMC-LINE-NBR
                            OSG-SEQ          -> CMC-SEQ

Custorder      CUSTORDER    Not Required

                            OSG-COMPANY      -> COR-COMPANY
                            OSG-ORDER-NBR    -> COR-ORDER-NBR