Lawson Insight Technical Documentation


ERDs Tables Elements Libraries App Forms

                              WOSGBLK FILE

This file stores user analysis values for work order header-, item-, and
burden-related records.

REFERENCED BY

WO120     WO20.1

UPDATED BY

WO140     WO30.1    WO35.1    WO40.1    WO45.1    WOEX.1

FIELD NAME           DESCRIPTION/VALID VALUES                    UPDATED BY

WSB-COMPANY          Numeric 4                                   WO140   WO30.1
Company              The company number represents an            WO35.1  WO40.1
                     established company and is entered on       WO45.1  WOEX.1
                     all function codes.

WSB-LOCATION         Alpha 5                                     WO140   WO30.1
Location             This field contains a valid stocking        WO35.1  WO40.1
                     location within the company inventory.      WO45.1  WOEX.1

WSB-WORK-ORDER       Numeric 8                                   WO140   WO30.1
Work Order           This identifies the work order and may      WO35.1  WO40.1
                     be automatically assigned or manually       WO45.1  WOEX.1
                     assigned, depending on the option
                     defined for each production (inventory)
                     location.

WSB-WORK-ORDER-SUF   Numeric 2                                   WO140   WO30.1
Work Order Suffix    This will normally be zero for a work       WO35.1  WO40.1
                     order.  If you chose to split a work        WO45.1  WOEX.1
                     order so the completed part of the
                     finished goods can be available for
                     allocation, the work order created for
                     the remaining quantity will have a
                     non-zero value in this field.

WSB-COMPONENT-SEQ    Numeric 3                                   WO140   WO30.1
Component Sequence   This field contains the component           WO35.1  WO40.1
                     sequence number.                            WO45.1  WOEX.1

WSB-SEQ              Numeric 3                                   WO140   WO30.1
Sequence             This field contains the record sequence     WO35.1  WO40.1
                     number.                                     WO45.1  WOEX.1

WSB-SEGMENT-BLOCK    Alpha 103                                   WO140   WO30.1
Segment Block        This field identifies the user analysis     WO35.1  WO40.1
                     values included in the transaction.         WO45.1  WOEX.1

                     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.

                         WOSGBLK FILE INDEX

NAME      KEY FIELDS    DESCRIPTION / SUBSET CONDITION           USED IN

WSBSET1   COMPANY                                                WO120   WO140
          LOCATION                                               WO20.1  WO30.1
          WORK-ORDER                                             WO35.1  WO40.1
          WORK-ORDER-SUF                                         WO45.1  WOEX.1
          COMPONENT-SEQ
          SEQ

                         WOSGBLK FILE RELATIONS

ONE TO ONE RELATIONS


RELATION       RELATED
 NAME           FILE        INTEGRITY RULES / FIELD MATCH

Wobrdn         WOBRDN       Not Required

                            WSB-COMPANY           -> WBN-COMPANY
                            WSB-LOCATION          -> WBN-LOCATION
                            WSB-WORK-ORDER        -> WBN-WORK-ORDER
                            WSB-WORK-ORDER-SUF    -> WBN-WORK-ORDER-SUF
                            WSB-SEQ               -> WBN-SEQ

Woitem         WOITEM       Not Required

                            WSB-COMPANY           -> WOI-COMPANY
                            WSB-LOCATION          -> WOI-LOCATION
                            WSB-WORK-ORDER        -> WOI-WORK-ORDER
                            WSB-WORK-ORDER-SUF    -> WOI-WORK-ORDER-SUF
                            WSB-COMPONENT-SEQ     -> WOI-COMPONENT-SEQ

Worder         WORDER       Not Required

                            WSB-COMPANY           -> WOR-COMPANY
                            WSB-LOCATION          -> WOR-LOCATION
                            WSB-WORK-ORDER        -> WOR-WORK-ORDER
                            WSB-WORK-ORDER-SUF    -> WOR-WORK-ORDER-SUF