Lawson Software

Lawson Insight Technical Documentation

Generated by:
Documentation generated by Decision Analytics

ERDs Tables Elements Libraries App Forms


                            WHSCMNTOUT 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

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

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

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

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

WIO-SEQ              Numeric 3                                   WH130   WH33.1
Sequence Number      This field contains the record sequence     WH33.2  WH33.3
                     number.                                     WH33.4  WH33.5
                                                                 WH33.6  WH33.8
                                                                 WH33.9  WH34.1
                                                                 WH34.2  WH34.3
                                                                 WH34.4

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

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

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

WIO-COMMENT          Alpha 40  (Lower Case)                      WH130   WH33.1
Comment Line         This field contains the comment             WH33.2  WH33.3
                     narrative.                                  WH33.4  WH33.5
                                                                 WH33.6  WH33.8
                                                                 WH33.9  WH34.1
                                                                 WH34.2  WH34.3
                                                                 WH34.4

WIO-PRINT-CODE       Alpha 1                                     WH130   WH33.1
Print Code           This field contains the print code,         WH33.2  WH33.3
                     which defines where comments are            WH33.4  WH33.5
                     displayed or printed.                       WH33.6  WH33.8
                                                                 WH33.9  WH34.1
                                                                 WH34.2  WH34.3
                                                                 WH34.4

WIO-PICK-FL          Alpha 1                                     WH130   WH33.1
Picking Option Flag  This field indicates whether comments       WH33.2  WH33.3
                     are printed on the pick list.               WH33.4  WH33.5
                                                                 WH33.6  WH33.8
                                                                 WH33.9  WH34.1
                                                                 WH34.2  WH34.3
                                                                 WH34.4

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

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