Lawson Insight Technical Documentation

Generated by:
Documentation generated by Decision Analytics

ERDs Tables Conditions Elements Libraries APIs Forms

WOSGBLK


                              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    WO300     WO35.1    WO40.1    WO45.1
WOEX.1

FIELD NAME             DESCRIPTION/VALID VALUES                  UPDATED BY

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

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

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


WSB-WORK-ORDER-SUF     Numeric 2                                 WO140   WO30.1
Element: Work Order SufThis will normally be zero for a work     WO300   WO35.1
                       order.  If you chose to split a work      WO40.1  WO45.1
                       order so the completed part of the        WOEX.1
                       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
Element: Sequence Number                                         WO300   WO35.1
                                                                 WO40.1  WO45.1
                                                                 WOEX.1

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

WSB-SEGMENT-BLOCK      Alpha 103                                 WO140   WO30.1
Element: User Analysis This field identifies the user analysis   WO300   WO35.1
                       values included in the transaction.       WO40.1  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                                             WO300   WO35.1
          WORK-ORDER-SUF                                         WO40.1  WO45.1
          COMPONENT-SEQ                                          WOEX.1
          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