Lawson Insight Technical Documentation

Generated by:
Documentation generated by Decision Analytics

ERDs Tables Conditions Elements Libraries APIs Forms

COSGBLK


                              COSGBLK FILE

UPDATED BY

AP125     AP126     AP131     AP20.1    AP20.2    AP20.3
AP20.4    AP20.5    AP20.7    AP21.1    AP23.1    AP25.1
AP25.2    AP26.1    AP27.1    AP30.4    API1.1    AR21.6
BL120     BL122     BL130     BL20.1    BL20.3    BL21.2
BL21.5    BL29.1    BL29.2    BL520     BL820     BL92.1
MA180     MA41.1    MA41.2    MA41.4    MA41.7    MA43.1
MA43.2    MA43.3    MA43.7    MA530     MA531     MA60.2
MA60.3    MA60.5    MA61.1    MA66.2    MA66.3    MA67.2
MA67.3    MA68.2    MA68.3    MA68.5    MA70.1    MA75.1
MA80.1    MAI1.1    PD10.1    PD10.2    PD130     PD20.1
PD20.2    PD20.3    PO100     PO101     PO122     PO131
PO20.1    PO21.1    PO21.2    PO21.3    PO21.4    PO21.5
PO22.1    PO23.1    PO24.1    PO25.1    PO25.5    PO25.6
PO25.7    PO27.2    PO29.1    PO30.1    PO30.2    PO30.3
PO300     PO31.1    PO31.2    PO32.2    PO32.4    PO33.1
PO34.1    PO35.1    PO36.1    PO36.2    PO38.1    PO39.1
PO39.2    PO44.1    PO50.1    PO52.1    PO520     PO536
POI3.1    POID.1    POII.1    POIJ.1    RQ10.1    RQ10.2
WH20.2    WH20.7

FIELD NAME             DESCRIPTION/VALID VALUES                  UPDATED BY

OSG-COMPANY            Numeric 4                                 AP125   AP126
Element: Company       Identifies the AP company if the          AP131   AP20.1
                       resource type = V.  Identifies the HR     AP20.2  AP20.3
                       company if the resource type = E.  It is  AP20.4  AP20.5
                       blank for type A, P or Q resources.       AP20.7  AP21.1
                                                                 AP23.1  AP25.1
                                                                 AP25.2  AP26.1
                                                                 AP27.1  AP30.4
                                                                 API1.1  AR21.6
                                                                 BL120   BL122
                                                                 BL130   BL20.1
                                                                 BL20.3  BL21.2
                                                                 BL21.5  BL29.1
                                                                 BL29.2  BL520
                                                                 BL820   BL92.1
                                                                 MA180   MA41.1
                                                                 MA41.2  MA41.4
                                                                 MA41.7  MA43.1
                                                                 MA43.2  MA43.3
                                                                 MA43.7  MA530
                                                                 MA531   MA60.2
                                                                 MA60.3  MA60.5
                                                                 MA61.1  MA66.2
                                                                 MA66.3  MA67.2
                                                                 MA67.3  MA68.2
                                                                 MA68.3  MA68.5
                                                                 MA70.1  MA75.1
                                                                 MA80.1  MAI1.1
                                                                 PD10.1  PD10.2
                                                                 PD130   PD20.1
                                                                 ...

OSG-ORDER-NBR          Numeric 8                                 AP125   AP126
Element: Order Nbr     This field contains the order number.     AP131   AP20.1
                                                                 AP20.2  AP20.3
                                                                 AP20.4  AP20.5
                                                                 AP20.7  AP21.1
                                                                 AP23.1  AP25.1
                                                                 AP25.2  AP26.1
                                                                 AP27.1  AP30.4
                                                                 API1.1  AR21.6
                                                                 BL120   BL122
                                                                 BL130   BL20.1
                                                                 BL20.3  BL21.2
                                                                 BL21.5  BL29.1
                                                                 BL29.2  BL520
                                                                 BL820   BL92.1
                                                                 MA180   MA41.1
                                                                 MA41.2  MA41.4
                                                                 MA41.7  MA43.1
                                                                 MA43.2  MA43.3
                                                                 MA43.7  MA530
                                                                 MA531   MA60.2
                                                                 MA60.3  MA60.5
                                                                 MA61.1  MA66.2
                                                                 MA66.3  MA67.2
                                                                 MA67.3  MA68.2
                                                                 MA68.3  MA68.5
                                                                 MA70.1  MA75.1
                                                                 MA80.1  MAI1.1
                                                                 PD10.1  PD10.2
                                                                 PD130   PD20.1
                                                                 ...

OSG-LINE-NBR           Numeric 6                                 AP125   AP126
Element: Line Nbr      This field contains the line number.      AP131   AP20.1
                                                                 AP20.2  AP20.3
                                                                 AP20.4  AP20.5
                                                                 AP20.7  AP21.1
                                                                 AP23.1  AP25.1
                                                                 AP25.2  AP26.1
                                                                 AP27.1  AP30.4
                                                                 API1.1  AR21.6
                                                                 BL120   BL122
                                                                 BL130   BL20.1
                                                                 BL20.3  BL21.2
                                                                 BL21.5  BL29.1
                                                                 BL29.2  BL520
                                                                 BL820   BL92.1
                                                                 MA180   MA41.1
                                                                 MA41.2  MA41.4
                                                                 MA41.7  MA43.1
                                                                 MA43.2  MA43.3
                                                                 MA43.7  MA530
                                                                 MA531   MA60.2
                                                                 MA60.3  MA60.5
                                                                 MA61.1  MA66.2
                                                                 MA66.3  MA67.2
                                                                 MA67.3  MA68.2
                                                                 MA68.3  MA68.5
                                                                 MA70.1  MA75.1
                                                                 MA80.1  MAI1.1
                                                                 PD10.1  PD10.2
                                                                 PD130   PD20.1
                                                                 ...

OSG-SEQ                Numeric 3                                 AP125   AP126
Element: Seq           This field contains the record sequence   AP131   AP20.1
                       number.                                   AP20.2  AP20.3
                                                                 AP20.4  AP20.5
                                                                 AP20.7  AP21.1
                                                                 AP23.1  AP25.1
                                                                 AP25.2  AP26.1
                                                                 AP27.1  AP30.4
                                                                 API1.1  AR21.6
                                                                 BL120   BL122
                                                                 BL130   BL20.1
                                                                 BL20.3  BL21.2
                                                                 BL21.5  BL29.1
                                                                 BL29.2  BL520
                                                                 BL820   BL92.1
                                                                 MA180   MA41.1
                                                                 MA41.2  MA41.4
                                                                 MA41.7  MA43.1
                                                                 MA43.2  MA43.3
                                                                 MA43.7  MA530
                                                                 MA531   MA60.2
                                                                 MA60.3  MA60.5
                                                                 MA61.1  MA66.2
                                                                 MA66.3  MA67.2
                                                                 MA67.3  MA68.2
                                                                 MA68.3  MA68.5
                                                                 MA70.1  MA75.1
                                                                 MA80.1  MAI1.1
                                                                 PD10.1  PD10.2
                                                                 PD130   PD20.1
                                                                 ...

OSG-SEGMENT-BLOCK      Alpha 103                                 AP125   AP126
Element: Segment Block This field identifies the user analysis   AP131   AP20.1
                       values included in the transaction.       AP20.2  AP20.3
                                                                 AP20.4  AP20.5
                       You can either type up to four values     AP20.7  AP21.1
                       or use Define (F6) to open the User       AP23.1  AP25.1
                       Analysis Entry subform. Use this subform  AP25.2  AP26.1
                       to select the user analysis values you    AP27.1  AP30.4
                       want to include in the transaction. If    API1.1  AR21.6
                       you choose to type values, use commas to  BL120   BL122
                       separate them. For example:               BL130   BL20.1
                       value1,value2,value3,value4               BL20.3  BL21.2
                                                                 BL21.5  BL29.1
                       There are three conditions that affect    BL29.2  BL520
                       how you can select user analysis values.  BL820   BL92.1
                       See the User Analysis Entry form help or  MA180   MA41.1
                       the Strategic Ledger procedures manual    MA41.2  MA41.4
                       for additional information.               MA41.7  MA43.1
                                                                 MA43.2  MA43.3
                                                                 MA43.7  MA530
                                                                 MA531   MA60.2
                                                                 MA60.3  MA60.5
                                                                 MA61.1  MA66.2
                                                                 MA66.3  MA67.2
                                                                 MA67.3  MA68.2
                                                                 MA68.3  MA68.5
                                                                 MA70.1  MA75.1
                                                                 MA80.1  MAI1.1
                                                                 PD10.1  PD10.2
                                                                 PD130   PD20.1
                                                                 ...

                         COSGBLK FILE INDEX

NAME      KEY FIELDS    DESCRIPTION / SUBSET CONDITION           USED IN

OSGSET1   COMPANY                                                AP125   AP126
          ORDER-NBR                                              AP131   AP20.1
          LINE-NBR                                               AP20.2  AP20.3
          SEQ                                                    AP20.4  AP20.5
                                                                 AP20.7  AP21.1
                                                                 AP23.1  AP25.1
                                                                 AP25.2  AP26.1
                                                                 AP27.1  AP30.4
                                                                 API1.1  AR21.6
                                                                 BL120   BL122
                                                                 BL130   BL20.1
                                                                 BL20.3  BL21.2
                                                                 BL21.5  BL29.1
                                                                 BL29.2  BL520
                                                                 BL820   BL92.1
                                                                 ...

                         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