Lawson Software

Lawson Insight Technical Documentation

Generated by:
Documentation generated by Decision Analytics

ERDs Tables Elements Libraries App Forms


                            WHSCOMPOUT FILE

UPDATED BY

WH130     WH33.1    WH33.2    WH33.3    WH33.4    WH33.5
WH33.6    WH33.8    WH33.9    WH330     WH34.1    WH34.2
WH34.3    WH34.4

FIELD NAME           DESCRIPTION/VALID VALUES                    UPDATED BY

WCO-COMPANY          Numeric 4                                   WH130   WH33.1
Company              The company number represents an            WH33.2  WH33.3
                     established company and is entered on       WH33.4  WH33.5
                     all function codes.                         WH33.6  WH33.8
                                                                 WH33.9  WH34.1
                                                                 WH34.2  WH34.3
                                                                 WH34.4

WCO-LOCATION         Alpha 5                                     WH130   WH33.1
Location Code        This field contains a valid stocking        WH33.2  WH33.3
                     location within the company inventory.      WH33.4  WH33.5
                                                                 WH33.6  WH33.8
                                                                 WH33.9  WH34.1
                                                                 WH34.2  WH34.3
                                                                 WH34.4

WCO-SHIPMENT-NBR     Numeric 10                                  WH130   WH33.1
Shipment Number      This field contains the shipment            WH33.2  WH33.3
                     number.  One order can have several         WH33.4  WH33.5
                     shipment numbers if the items of the        WH33.6  WH33.8
                     order were not shipped at the same time.    WH33.9  WH34.1
                                                                 WH34.2  WH34.3
                                                                 WH34.4

WCO-LINE-NBR         Numeric 6                                   WH130   WH33.1
Line Number          This field contains the line number.        WH33.2  WH33.3
                                                                 WH33.4  WH33.5
                                                                 WH33.6  WH33.8
                                                                 WH33.9  WH34.1
                                                                 WH34.2  WH34.3
                                                                 WH34.4

WCO-COMPONENT-SEQ    Numeric 3                                   WH130   WH33.1
Component Sequence   This field contains the component           WH33.2  WH33.3
Number               sequence number.                            WH33.4  WH33.5
                                                                 WH33.6  WH33.8
                                                                 WH33.9  WH34.1
                                                                 WH34.2  WH34.3
                                                                 WH34.4

WCO-CREATION-DATE    Numeric 8  (yyyymmdd)                       WH130   WH33.1
Creation Date        This is the date that this line was         WH33.2  WH33.3
                     added to the requisition.                   WH33.4  WH33.5
                                                                 WH33.6  WH33.8
                                                                 WH33.9  WH34.1
                                                                 WH34.2  WH34.3
                                                                 WH34.4

WCO-CREATION-TIME    Numeric 6  (hhmmss)                         WH130   WH33.1
Creation Time        The creation time.                          WH33.2  WH33.3
                                                                 WH33.4  WH33.5
                                                                 WH33.6  WH33.8
                                                                 WH33.9  WH34.1
                                                                 WH34.2  WH34.3
                                                                 WH34.4

WCO-INTERFACE-STS    Numeric 1                                   WH130   WH33.1
Interface Sts                                                    WH33.2  WH33.3
                                                                 WH33.4  WH33.5
                                                                 WH33.6  WH33.8
                                                                 WH33.9  WH34.1
                                                                 WH34.2  WH34.3
                                                                 WH34.4

WCO-SYSTEM-CD        Alpha 2                                     WH130   WH33.1
System Code          This field indicates on what system the     WH33.2  WH33.3
                     transaction originated.                     WH33.4  WH33.5
                                                                 WH33.6  WH33.8
                                                                 WH33.9  WH34.1
                                                                 WH34.2  WH34.3
                                                                 WH34.4

WCO-DOC-NBR          Alpha 10  (Right Justified)                 WH130   WH33.1
Doc Nbr                                                          WH33.2  WH33.3
                                                                 WH33.4  WH33.5
                                                                 WH33.6  WH33.8
                                                                 WH33.9  WH34.1
                                                                 WH34.2  WH34.3
                                                                 WH34.4

WCO-ITEM             Alpha 32                                    WH130   WH33.1
Item Number          This field contains the item                WH33.2  WH33.3
                     identifier.                                 WH33.4  WH33.5
                                                                 WH33.6  WH33.8
                                                                 WH33.9  WH34.1
                                                                 WH34.2  WH34.3
                                                                 WH34.4

WCO-QUANTITY         Signed 13.4                                 WH130   WH33.1
Quantity             This field contains the desired             WH33.2  WH33.3
                     quantity.                                   WH33.4  WH33.5
                                                                 WH33.6  WH33.8
                                                                 WH33.9  WH34.1
                                                                 WH34.2  WH34.3
                                                                 WH34.4

WCO-DETAIL-QTY       Signed 13.4                                 WH130   WH33.1
Detail Qty           This field shows the total quantity of      WH33.2  WH33.3
                     details defined for a detail tracked        WH33.4  WH33.5
                     item. It is matched against the line        WH33.6  WH33.8
                     quantity field to determine if details      WH33.9  WH34.1
                     are in balance.                             WH34.2  WH34.3
                     In the item detail screen, it is the        WH34.4
                     quantity for a particular lot or bin.

WCO-DETAIL-REQ       Alpha 1                                     WH130   WH33.1
Detail Req                                                       WH33.2  WH33.3
                                                                 WH33.4  WH33.5
                                                                 WH33.6  WH33.8
                                                                 WH33.9  WH34.1
                                                                 WH34.2  WH34.3
                                                                 WH34.4

WCO-UNIT-COST        Signed 13.5                                 WH130   WH33.1
Unit Cost            This field contains the unit cost.          WH33.2  WH33.3
                                                                 WH33.4  WH33.5
                                                                 WH33.6  WH33.8
                                                                 WH33.9  WH34.1
                                                                 WH34.2  WH34.3
                                                                 WH34.4

                         WHSCOMPOUT FILE INDEX

NAME      KEY FIELDS    DESCRIPTION / SUBSET CONDITION           USED IN

WCOSET1   COMPANY                                                WH130   WH33.1
          LOCATION                                               WH33.2  WH33.3
          SHIPMENT-NBR                                           WH33.4  WH33.5
          LINE-NBR                                               WH33.6  WH33.8
          COMPONENT-SEQ                                          WH33.9  WH330
          CREATION-DATE                                          WH34.1  WH34.2
          CREATION-TIME                                          WH34.3  WH34.4

WCOSET2   COMPANY
          LOCATION
          INTERFACE-STS
          SHIPMENT-NBR
          LINE-NBR
          COMPONENT-SEQ
          CREATION-DATE
          CREATION-TIME