Lawson Insight Technical Documentation


ERDs Tables Elements Libraries App Forms

                            WHSCMNTOUT 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

WIO-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

WIO-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

WIO-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

WIO-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

WIO-SEQ              Numeric 3                                   BL92.1  OE114
Sequence Number      This field contains the record sequence     WH130   WH132
                     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

WIO-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

WIO-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

WIO-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

WIO-COMMENT          Alpha 40  (Lower Case)                      BL92.1  OE114
Comment Line         This field contains the comment             WH130   WH132
                     narrative.                                  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

WIO-PRINT-CODE       Alpha 1                                     BL92.1  OE114
Print Code           This field contains the print code,         WH130   WH132
                     which defines where comments are            WH190   WH30.1
                     displayed or printed.                       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

WIO-PICK-FL          Alpha 1                                     BL92.1  OE114
Picking Option Flag  This field indicates whether comments       WH130   WH132
                     are printed on the pick list.               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

WIO-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

WIO-SHIP-LINE-NBR    Numeric 6
Ship Line Nbr

                         WHSCMNTOUT FILE INDEX

NAME      KEY FIELDS    DESCRIPTION / SUBSET CONDITION           USED IN

WIOSET1   COMPANY                                                WH330
          SYSTEM-CD
          DOC-NBR
          LINE-NBR
          SEQ
          CREATION-DATE
          CREATION-TIME

WIOSET2   COMPANY
          INTERFACE-STS
          SYSTEM-CD
          DOC-NBR
          LINE-NBR
          SEQ
          CREATION-DATE
          CREATION-TIME