Lawson Insight Technical Documentation


ERDs Tables Elements Libraries App Forms

                            WHSCOMPOUT FILE

UPDATED BY

BL92.1    OE114     WH130     WH132     WH190     WH30.1
WH30.2    WH30.3    WH31.1    WH31.2    WH31.3    WH32.1
WH32.2    WH32.3    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    WH40.1    WH40.2    WH520
WH830

FIELD NAME           DESCRIPTION/VALID VALUES                    UPDATED BY

WCO-COMPANY          Numeric 4                                   BL92.1  OE114
Company              The company number represents an            WH130   WH132
                     established company and is entered on       WH190   WH30.1
                     all function codes.                         WH30.2  WH30.3
                                                                 WH31.1  WH31.2
                                                                 WH31.3  WH32.1
                                                                 WH32.2  WH32.3
                                                                 WH33.1  WH33.2
                                                                 WH33.3  WH33.4
                                                                 WH33.5  WH33.6
                                                                 WH33.8  WH33.9
                                                                 WH34.1  WH34.2
                                                                 WH34.3  WH34.4
                                                                 WH40.1  WH40.2
                                                                 WH520   WH830

WCO-LOCATION         Alpha 5                                     BL92.1  OE114
Location Code        This field contains a valid stocking        WH130   WH132
                     location within the company inventory.      WH190   WH30.1
                                                                 WH30.2  WH30.3
                                                                 WH31.1  WH31.2
                                                                 WH31.3  WH32.1
                                                                 WH32.2  WH32.3
                                                                 WH33.1  WH33.2
                                                                 WH33.3  WH33.4
                                                                 WH33.5  WH33.6
                                                                 WH33.8  WH33.9
                                                                 WH34.1  WH34.2
                                                                 WH34.3  WH34.4
                                                                 WH40.1  WH40.2
                                                                 WH520   WH830

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

WCO-LINE-NBR         Numeric 6                                   BL92.1  OE114
Line Number          This field contains the line number.        WH130   WH132
                                                                 WH190   WH30.1
                                                                 WH30.2  WH30.3
                                                                 WH31.1  WH31.2
                                                                 WH31.3  WH32.1
                                                                 WH32.2  WH32.3
                                                                 WH33.1  WH33.2
                                                                 WH33.3  WH33.4
                                                                 WH33.5  WH33.6
                                                                 WH33.8  WH33.9
                                                                 WH34.1  WH34.2
                                                                 WH34.3  WH34.4
                                                                 WH40.1  WH40.2
                                                                 WH520   WH830

WCO-COMPONENT-SEQ    Numeric 3                                   BL92.1  OE114
Component Sequence   This field contains the component           WH130   WH132
Number               sequence number.                            WH190   WH30.1
                                                                 WH30.2  WH30.3
                                                                 WH31.1  WH31.2
                                                                 WH31.3  WH32.1
                                                                 WH32.2  WH32.3
                                                                 WH33.1  WH33.2
                                                                 WH33.3  WH33.4
                                                                 WH33.5  WH33.6
                                                                 WH33.8  WH33.9
                                                                 WH34.1  WH34.2
                                                                 WH34.3  WH34.4
                                                                 WH40.1  WH40.2
                                                                 WH520   WH830

WCO-CREATION-DATE    Numeric 8  (yyyymmdd)                       BL92.1  OE114
Creation Date        This is the date that this line was         WH130   WH132
                     added to the requisition.                   WH190   WH30.1
                                                                 WH30.2  WH30.3
                                                                 WH31.1  WH31.2
                                                                 WH31.3  WH32.1
                                                                 WH32.2  WH32.3
                                                                 WH33.1  WH33.2
                                                                 WH33.3  WH33.4
                                                                 WH33.5  WH33.6
                                                                 WH33.8  WH33.9
                                                                 WH34.1  WH34.2
                                                                 WH34.3  WH34.4
                                                                 WH40.1  WH40.2
                                                                 WH520   WH830

WCO-CREATION-TIME    Numeric 6  (hhmmss)                         BL92.1  OE114
Creation Time        The creation time.                          WH130   WH132
                                                                 WH190   WH30.1
                                                                 WH30.2  WH30.3
                                                                 WH31.1  WH31.2
                                                                 WH31.3  WH32.1
                                                                 WH32.2  WH32.3
                                                                 WH33.1  WH33.2
                                                                 WH33.3  WH33.4
                                                                 WH33.5  WH33.6
                                                                 WH33.8  WH33.9
                                                                 WH34.1  WH34.2
                                                                 WH34.3  WH34.4
                                                                 WH40.1  WH40.2
                                                                 WH520   WH830

WCO-INTERFACE-STS    Numeric 1                                   BL92.1  OE114
Interface Sts                                                    WH130   WH132
                                                                 WH190   WH30.1
                                                                 WH30.2  WH30.3
                                                                 WH31.1  WH31.2
                                                                 WH31.3  WH32.1
                                                                 WH32.2  WH32.3
                                                                 WH33.1  WH33.2
                                                                 WH33.3  WH33.4
                                                                 WH33.5  WH33.6
                                                                 WH33.8  WH33.9
                                                                 WH34.1  WH34.2
                                                                 WH34.3  WH34.4
                                                                 WH40.1  WH40.2
                                                                 WH520   WH830

WCO-SYSTEM-CD        Alpha 2                                     BL92.1  OE114
System Code          This field indicates on what system the     WH130   WH132
                     transaction originated.                     WH190   WH30.1
                                                                 WH30.2  WH30.3
                                                                 WH31.1  WH31.2
                                                                 WH31.3  WH32.1
                                                                 WH32.2  WH32.3
                                                                 WH33.1  WH33.2
                                                                 WH33.3  WH33.4
                                                                 WH33.5  WH33.6
                                                                 WH33.8  WH33.9
                                                                 WH34.1  WH34.2
                                                                 WH34.3  WH34.4
                                                                 WH40.1  WH40.2
                                                                 WH520   WH830

WCO-DOC-NBR          Alpha 10  (Right Justified)                 BL92.1  OE114
Doc Nbr                                                          WH130   WH132
                                                                 WH190   WH30.1
                                                                 WH30.2  WH30.3
                                                                 WH31.1  WH31.2
                                                                 WH31.3  WH32.1
                                                                 WH32.2  WH32.3
                                                                 WH33.1  WH33.2
                                                                 WH33.3  WH33.4
                                                                 WH33.5  WH33.6
                                                                 WH33.8  WH33.9
                                                                 WH34.1  WH34.2
                                                                 WH34.3  WH34.4
                                                                 WH40.1  WH40.2
                                                                 WH520   WH830

WCO-ITEM             Alpha 32                                    BL92.1  OE114
Item Number          This field contains the item                WH130   WH132
                     identifier.                                 WH190   WH30.1
                                                                 WH30.2  WH30.3
                                                                 WH31.1  WH31.2
                                                                 WH31.3  WH32.1
                                                                 WH32.2  WH32.3
                                                                 WH33.1  WH33.2
                                                                 WH33.3  WH33.4
                                                                 WH33.5  WH33.6
                                                                 WH33.8  WH33.9
                                                                 WH34.1  WH34.2
                                                                 WH34.3  WH34.4
                                                                 WH40.1  WH40.2
                                                                 WH520   WH830

WCO-QUANTITY         Signed 13.4                                 BL92.1  OE114
Quantity             This field contains the requested           WH130   WH132
                     quantity.                                   WH190   WH30.1
                                                                 WH30.2  WH30.3
                                                                 WH31.1  WH31.2
                                                                 WH31.3  WH32.1
                                                                 WH32.2  WH32.3
                                                                 WH33.1  WH33.2
                                                                 WH33.3  WH33.4
                                                                 WH33.5  WH33.6
                                                                 WH33.8  WH33.9
                                                                 WH34.1  WH34.2
                                                                 WH34.3  WH34.4
                                                                 WH40.1  WH40.2
                                                                 WH520   WH830

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

WCO-DETAIL-REQ       Alpha 1                                     BL92.1  OE114
Detail Req                                                       WH130   WH132
                                                                 WH190   WH30.1
                                                                 WH30.2  WH30.3
                                                                 WH31.1  WH31.2
                                                                 WH31.3  WH32.1
                                                                 WH32.2  WH32.3
                                                                 WH33.1  WH33.2
                                                                 WH33.3  WH33.4
                                                                 WH33.5  WH33.6
                                                                 WH33.8  WH33.9
                                                                 WH34.1  WH34.2
                                                                 WH34.3  WH34.4
                                                                 WH40.1  WH40.2
                                                                 WH520   WH830

WCO-UNIT-COST        Signed 13.5                                 BL92.1  OE114
Unit Cost            This field contains the unit cost.          WH130   WH132
                                                                 WH190   WH30.1
                                                                 WH30.2  WH30.3
                                                                 WH31.1  WH31.2
                                                                 WH31.3  WH32.1
                                                                 WH32.2  WH32.3
                                                                 WH33.1  WH33.2
                                                                 WH33.3  WH33.4
                                                                 WH33.5  WH33.6
                                                                 WH33.8  WH33.9
                                                                 WH34.1  WH34.2
                                                                 WH34.3  WH34.4
                                                                 WH40.1  WH40.2
                                                                 WH520   WH830

                         WHSCOMPOUT FILE INDEX

NAME      KEY FIELDS    DESCRIPTION / SUBSET CONDITION           USED IN

WCOSET1   COMPANY                                                BL92.1  OE114
          LOCATION                                               WH130   WH132
          SHIPMENT-NBR                                           WH190   WH30.1
          LINE-NBR                                               WH30.2  WH30.3
          COMPONENT-SEQ                                          WH31.1  WH31.2
          CREATION-DATE                                          WH31.3  WH32.1
          CREATION-TIME                                          WH32.2  WH32.3
                                                                 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  WH40.1
                                                                 WH40.2  WH520
                                                                 ...

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