Lawson Insight Technical Documentation

Generated by:
Documentation generated by Decision Analytics

ERDs Tables Conditions Elements Libraries APIs Forms

WHDVAUDIT


                             WHDVAUDIT FILE

UPDATED BY

POD0.1    POD1.1    RQD0.1    RQD1.1    WH440     WHD0.1
WHD1.1    WHD2.1    WHD3.1    WOD0.1    WOD1.1

FIELD NAME             DESCRIPTION/VALID VALUES                  UPDATED BY

WHV-PROGRAM            Alpha 5                                   POD0.1  POD1.1
Element: Program       This field designates the program this    RQD0.1  RQD1.1
                       record was created by                     WH440   WHD0.1
                                                                 WHD1.1  WHD2.1
                                                                 WHD3.1  WOD0.1
                                                                 WOD1.1

WHV-REPORT-NAME        Alpha 10                                  POD0.1  POD1.1
Element: Job Name                                                RQD0.1  RQD1.1
                                                                 WH440   WHD0.1
                                                                 WHD1.1  WHD2.1
                                                                 WHD3.1  WOD0.1
                                                                 WOD1.1

WHV-RECORD-NUMBER      Numeric 7                                 POD0.1  POD1.1
Element: Record Number This is the ASCII file record number.     RQD0.1  RQD1.1
                                                                 WH440   WHD0.1
                                                                 WHD1.1  WHD2.1
                                                                 WHD3.1  WOD0.1
                                                                 WOD1.1

WHV-ACTION             Alpha 1                                   POD0.1  POD1.1
Element: Action                                                  RQD0.1  RQD1.1
                                                                 WH440   WHD0.1
                                                                 WHD1.1  WHD2.1
                                                                 WHD3.1  WOD0.1
                                                                 WOD1.1

WHV-TABLE              Alpha 10                                  POD0.1  POD1.1
Element: Table                                                   RQD0.1  RQD1.1
                                                                 WHD0.1  WHD1.1
                                                                 WHD2.1  WHD3.1
                                                                 WOD0.1  WOD1.1

WHV-UPDATE-DATE        Numeric 8  (yyyymmdd)                     POD0.1  POD1.1
Element: Upd Date                                                RQD0.1  RQD1.1
                                                                 WH440   WHD0.1
                                                                 WHD1.1  WHD2.1
                                                                 WHD3.1  WOD0.1
                                                                 WOD1.1

WHV-UPDATE-TIME        Numeric 6                                 POD0.1  POD1.1
Element: Update Time   This field contains the system time       RQD0.1  RQD1.1
                       when the record was updated.              WH440   WHD0.1
                                                                 WHD1.1  WHD2.1
                                                                 WHD3.1  WOD0.1
                                                                 WOD1.1

WHV-OPR-CODE           Alpha 10                                  POD0.1  POD1.1
Element: Operator Code                                           RQD0.1  RQD1.1
                                                                 WH440   WHD0.1
                                                                 WHD1.1  WHD2.1
                                                                 WHD3.1  WOD0.1
                                                                 WOD1.1

WHV-FIELD-NAME         Alpha 20  (Lower Case)                    POD0.1  POD1.1
Element: Field Name                                              RQD0.1  RQD1.1
                                                                 WHD0.1  WHD1.1
                                                                 WHD2.1  WHD3.1
                                                                 WOD1.1

WHV-BEFORE-IMAGE       Alpha 32                                  POD0.1  POD1.1
Element: Before Change This field contains the field image       RQD0.1  RQD1.1
                       before the change.                        WHD0.1  WHD2.1
                                                                 WHD3.1  WOD1.1

WHV-AFTER-IMAGE        Alpha 32                                  POD0.1  POD1.1
Element: Before Change Image                                     RQD0.1  RQD1.1
                                                                 WHD0.1  WHD1.1
                                                                 WHD2.1  WHD3.1
                                                                 WOD1.1

WHV-COMPANY            Numeric 4                                 POD0.1  POD1.1
Element: Company       The company number represents an          RQD0.1  RQD1.1
                       established company and is entered on     WH440   WHD0.1
                       all function codes.                       WHD1.1  WHD2.1
                                                                 WHD3.1  WOD0.1
                                                                 WOD1.1

WHV-LOCATION           Alpha 5                                   POD0.1  POD1.1
Element: Location Code This field contains a valid stocking      RQD0.1  RQD1.1
                       location within the company inventory.    WHD0.1  WHD1.1
                                                                 WHD2.1  WHD3.1
                                                                 WOD0.1  WOD1.1

WHV-ITEM               Alpha 32                                  POD0.1  POD1.1
Element: Item Number   This field contains the item              RQD0.1  RQD1.1
                       identifier.                               WHD0.1  WHD1.1
                                                                 WHD2.1  WHD3.1
                                                                 WOD0.1  WOD1.1

WHV-DOC-NUMBER         Alpha 14  (Right Justified)               POD0.1  POD1.1
Element: Doc Number                                              RQD0.1  RQD1.1
                                                                 WHD0.1  WHD1.1
                                                                 WHD2.1  WHD3.1
                                                                 WOD0.1  WOD1.1

WHV-DOC-TYPE           Alpha 2                                   POD0.1  POD1.1
Element: Document Type This field contains the type of           RQD0.1  RQD1.1
                       transaction.                              WHD0.1  WHD2.1
                                                                 WHD3.1

WHV-LINE-NBR           Numeric 6                                 POD0.1  POD1.1
Element: Line Number   This field contains the line number.      RQD0.1  RQD1.1
                                                                 WHD0.1  WHD1.1
                                                                 WHD2.1  WHD3.1
                                                                 WOD0.1  WOD1.1

WHV-SEQ                Numeric 3                                 POD0.1  POD1.1
Element: Sequence NumbeThis field contains the record sequence   RQD0.1  RQD1.1
                       number.                                   WHD0.1  WHD2.1
                                                                 WHD3.1  WOD0.1
                                                                 WOD1.1

WHV-BIN                Alpha 7                                   POD0.1  RQD0.1
Element: Bin           This field contains a storage area for    RQD1.1  WHD0.1
                       an item or any number of items.           WHD2.1  WHD3.1
                                                                 WOD0.1  WOD1.1

WHV-LOT                Alpha 10                                  POD0.1  RQD0.1
Element: Lot Number    This field contains the identifier for    WHD0.1  WHD2.1
                       the homogeneous quantity of material.     WHD3.1  WOD0.1
                                                                 WOD1.1

WHV-SUBLOT             Alpha 6                                   POD0.1  RQD0.1
Element: Sublot Number This field contains the identifier for    WHD0.1  WHD2.1
                       a detail breakdown of a lot number.       WHD3.1  WOD0.1
                                                                 WOD1.1

WHV-SERIAL             Alpha 16                                  POD0.1  RQD0.1
Element: Serial Number                                           WHD0.1  WHD2.1
                                                                 WHD3.1  WOD0.1
                                                                 WOD1.1

WHV-UOM                Alpha 4                                   POD0.1  POD1.1
Element: Unit of MeasurThis field contains the valid stock       RQD0.1  RQD1.1
                       unit of measure for this item.            WHD0.1  WHD2.1
                                                                 WHD3.1  WOD0.1
                                                                 WOD1.1

WHV-QUANTITY           Signed 13.4                               POD0.1  POD1.1
Element: Quantity      This field contains the desired           RQD0.1  RQD1.1
                       quantity.                                 WHD0.1  WHD2.1
                                                                 WHD3.1  WOD0.1
                                                                 WOD1.1

WHV-AGREEMENT-REF      Alpha 30                                  POD0.1
Element: Agreement Ref

WHV-PROC-GROUP         Alpha 4  (Lower Case)                     POD0.1  RQD0.1
Element: Process Group Contains the processing group (head
                       process level).The processing group
                       identifies a group of process levels.

WHV-PO-NBR             Alpha 14                                  POD0.1  POD1.1
Element: PO Number     The purchase order number field is an
                       optional field for your reference. It is
                       assumed to contain the original purchase
                       order number on which this asset was
                       included.

WHV-PO-RELEASE         Numeric 4                                 POD0.1  POD1.1
Element: PO Release NumUsed to identify a purchase order
                       release (created from a Blanket or
                       Standing order).

WHV-PO-CODE            Alpha 4                                   POD0.1  POD1.1
Element: Po Code       This is the purchase order code.          RQD0.1

WHV-SHIPMENT-NBR       Numeric 10                                POD0.1  WHD0.1
Element: Shipment NumbeThis field contains the shipment          WHD2.1  WHD3.1
                       number.  One order can have several
                       shipment numbers if the items of the
                       order were not shipped at the same time.


WHV-RECORD-TYPE        Alpha 1                                   POD0.1  POD1.1
Element: Record Type   This field identifies the type of         RQD0.1  RQD1.1
                       record defined.                           WHD0.1  WHD1.1
                                                                 WHD2.1  WOD0.1
                       Valid values are:                         WOD1.1
                       S = Summary
                       D = Detail

                         WHDVAUDIT FILE INDEX

NAME      KEY FIELDS    DESCRIPTION / SUBSET CONDITION           USED IN

WHVSET1   COMPANY                                                WH440
          UPDATE-DATE
          UPDATE-TIME
          REPORT-NAME
          PROGRAM
          RECORD-NUMBER