Lawson Software

Lawson Insight Technical Documentation

Generated by:
Documentation generated by Decision Analytics

ERDs Tables Elements Libraries App Forms


                            WHSCMNTOUT FILE

UPDATED BY

WH130     WH132     WH190     WH30.1    WH30.2    WH30.3
WH30.4    WH31.1    WH31.2    WH31.3    WH31.4    WH32.1
WH32.2    WH32.3    WH32.4    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                                   WH130   WH132
Company              The company number represents an            WH190   WH30.1
                     established company and is entered on       WH30.2  WH30.3
                     all function codes.                         WH30.4  WH31.1
                                                                 WH31.2  WH31.3
                                                                 WH31.4  WH32.1
                                                                 WH32.2  WH32.3
                                                                 WH32.4  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                                     WH130   WH132
System Code          This field indicates on what system the     WH190   WH30.1
                     transaction originated.                     WH30.2  WH30.3
                                                                 WH30.4  WH31.1
                                                                 WH31.2  WH31.3
                                                                 WH31.4  WH32.1
                                                                 WH32.2  WH32.3
                                                                 WH32.4  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)                 WH130   WH132
Doc Nbr                                                          WH190   WH30.1
                                                                 WH30.2  WH30.3
                                                                 WH30.4  WH31.1
                                                                 WH31.2  WH31.3
                                                                 WH31.4  WH32.1
                                                                 WH32.2  WH32.3
                                                                 WH32.4  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                                   WH130   WH132
Line Number          This field contains the line number.        WH190   WH30.1
                                                                 WH30.2  WH30.3
                                                                 WH30.4  WH31.1
                                                                 WH31.2  WH31.3
                                                                 WH31.4  WH32.1
                                                                 WH32.2  WH32.3
                                                                 WH32.4  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                                   WH130   WH132
Sequence Number      This field contains the record sequence     WH190   WH30.1
                     number.                                     WH30.2  WH30.3
                                                                 WH30.4  WH31.1
                                                                 WH31.2  WH31.3
                                                                 WH31.4  WH32.1
                                                                 WH32.2  WH32.3
                                                                 WH32.4  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)                       WH130   WH132
Creation Date        This is the date that this line was         WH190   WH30.1
                     added to the requisition.                   WH30.2  WH30.3
                                                                 WH30.4  WH31.1
                                                                 WH31.2  WH31.3
                                                                 WH31.4  WH32.1
                                                                 WH32.2  WH32.3
                                                                 WH32.4  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)                         WH130   WH132
Creation Time        The creation time.                          WH190   WH30.1
                                                                 WH30.2  WH30.3
                                                                 WH30.4  WH31.1
                                                                 WH31.2  WH31.3
                                                                 WH31.4  WH32.1
                                                                 WH32.2  WH32.3
                                                                 WH32.4  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                                   WH130   WH132
Interface Sts                                                    WH190   WH30.1
                                                                 WH30.2  WH30.3
                                                                 WH30.4  WH31.1
                                                                 WH31.2  WH31.3
                                                                 WH31.4  WH32.1
                                                                 WH32.2  WH32.3
                                                                 WH32.4  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)                      WH130   WH132
Comment Line         This field contains the comment             WH190   WH30.1
                     narrative.                                  WH30.2  WH30.3
                                                                 WH30.4  WH31.1
                                                                 WH31.2  WH31.3
                                                                 WH31.4  WH32.1
                                                                 WH32.2  WH32.3
                                                                 WH32.4  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                                     WH130   WH132
Print Code           This field contains the print code,         WH190   WH30.1
                     which defines where comments are            WH30.2  WH30.3
                     displayed or printed.                       WH30.4  WH31.1
                                                                 WH31.2  WH31.3
                                                                 WH31.4  WH32.1
                                                                 WH32.2  WH32.3
                                                                 WH32.4  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                                     WH130   WH132
Picking Option Flag  This field indicates whether comments       WH190   WH30.1
                     are printed on the pick list.               WH30.2  WH30.3
                                                                 WH30.4  WH31.1
                                                                 WH31.2  WH31.3
                                                                 WH31.4  WH32.1
                                                                 WH32.2  WH32.3
                                                                 WH32.4  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                                  WH130   WH132
Shipment Number      This field contains the shipment            WH190   WH30.1
                     number.  One order can have several         WH30.2  WH30.3
                     shipment numbers if the items of the        WH30.4  WH31.1
                     order were not shipped at the same time.    WH31.2  WH31.3
                                                                 WH31.4  WH32.1
                                                                 WH32.2  WH32.3
                                                                 WH32.4  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