Lawson Insight Technical Documentation

Generated by:
Documentation generated by Decision Analytics

ERDs Tables Conditions Elements Libraries APIs Forms

WHDEMNDDTL


                            WHDEMNDDTL FILE

                             Demand Detail

The Demand Detail file contains details (bin, lot, serial number, and
multiple unit of measure) assigned to the document line.

REFERENCED BY

WH210

UPDATED BY

WH20.3    WH20.4    WH20.5    WH20.6    WO140     BL92.1
OE114     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
WH34.1    WH34.2    WH34.3    WH34.4    WH40.1    WH40.2
WH520     WH830

FIELD NAME             DESCRIPTION/VALID VALUES                  UPDATED BY

WDD-COMPANY            Numeric 4                                 WH20.3  WH20.4
Element: Company       This field contains the company number.   WH20.5  WH20.6
                                                                 WO140

WDD-SYSTEM-CD          Alpha 2                                   WH20.3  WH20.4
Element: System Code   This field indicates on which Lawson      WH20.5  WH20.6
                       system the document originated.           WO140
                       OE = Customer Order
                       RQ = Requisitions
                       CX = Case Cart

WDD-DOC-NBR            Alpha 10  (Right Justified)               WH20.3  WH20.4
Element: Doc Nbr       This field contains the document number   WH20.5  WH20.6
                       for the document line requiring details.  WO140

WDD-DOC-NBR-NUM        Numeric 10                                WO140
Element: Doc Nbr Num   This field contains the numeric value
                       of the document number.

WDD-LINE-NBR           Numeric 6                                 WH20.3  WH20.4
Element: Line Number   This field contains the document line     WH20.5  WH20.6
                       number.                                   WO140

WDD-COMPONENT-SEQ      Numeric 3                                 WH20.3  WH20.4
Element: Sequence NumbeThis field contains the component         WH20.5  WH20.6
                       sequence number for kit component items   WO140
                       on the document line.

WDD-BIN                Alpha 7                                   WH20.3  WH20.4
Element: Bin           This field contains the bin assigned to   WH20.5  WH20.6
                       the document line.                        WO140

WDD-LOT                Alpha 10                                  WH20.3  WH20.4
Element: Lot Number    This field contains the lot assigned to   WH20.5  WH20.6
                       the document line.                        WO140

WDD-SUBLOT             Alpha 6                                   WH20.3  WH20.4
Element: Sublot Number This field contains the sublot assigned   WH20.5  WH20.6
                       to the document line.                     WO140

WDD-SERIAL             Alpha 16                                  WH20.3  WH20.4
Element: Serial Number This field contains the serial number     WH20.5  WO140
                       assigned to the document line.

WDD-UOM                Alpha 4                                   WH20.3  WH20.4
Element: Unit of MeasurThis field contains the unit of measure   WH20.5  WH20.6
                       assigned to the document line.            WO140

WDD-LOCATION           Alpha 5                                   WH20.3  WH20.4
Element: Location Code This field contains a valid stocking      WH20.5  WH20.6
                       location within the company inventory.

WDD-UOM-MULT           Signed 13.7                               WH20.3  WH20.4
Unit of Measure        This field contains the multiplier for    WH20.5  WH20.6
Multiplier             converting this unit of measure to the    WO140
                       stock unit of measure.

WDD-QUANTITY           Signed 13.4                               WH20.3  WH20.4
Element: Quantity      This field contains the requested         WH20.5  WH20.6
                       document line quantity.                   WO140

WDD-CATCH-WT-QTY       Signed 13.4                               WO140
Element: Quantity      This field contains the catch weight
                       quantity in secondary unit of measure.

WDD-UPDATE-DATE        Numeric 8  (yyyymmdd)                     WO140
Element: Update Date   This field contains the date the record
                       was updated.

WDD-UPDATE-TIME        Numeric 6                                 WO140
Element: Update Time   This field contains the system time
                       when the record was updated.

                         WHDEMNDDTL FILE INDEX

NAME      KEY FIELDS    DESCRIPTION / SUBSET CONDITION           USED IN

WDDSET1   COMPANY       Primary index used for accessing and     BL92.1  OE114
          LOCATION      updating the table.                      WH130   WH132
          SYSTEM-CD                                              WH190   WH20.3
          DOC-NBR                                                WH20.4  WH20.5
          LINE-NBR                                               WH20.6  WH210
          COMPONENT-SEQ                                          WH30.1  WH30.2
          BIN                                                    WH30.3  WH30.4
          LOT                                                    WH31.1  WH31.2
          SUBLOT                                                 WH31.3  WH31.4
          SERIAL                                                 WH32.1  WH32.2
          UOM                                                    WH32.3  WH32.4
                                                                 WH33.1  WH33.2
                                                                 WH33.3  WH33.4
                                                                 WH33.5  WH33.6
                                                                 WH33.8  WH33.9
                                                                 ...

                         WHDEMNDDTL FILE RELATIONS

ONE TO ONE RELATIONS


RELATION       RELATED
 NAME           FILE        INTEGRITY RULES / FIELD MATCH

Iccompany      ICCOMPANY    Required

                            WDD-COMPANY          -> ICC-COMPANY

Iclocation     ICLOCATION   Required

                            WDD-COMPANY          -> ICL-COMPANY
                            WDD-LOCATION         -> ICL-LOCATION

Itemloc        ITEMLOC      Required

                            WDD-COMPANY          -> ITL-COMPANY
                            WDD-LOCATION         -> ITL-LOCATION
                            WDM-ITEM             -> ITL-ITEM

Sohdetail      SOHDETAIL    Required

                            WDD-COMPANY          -> SDT-COMPANY
                            WDD-LOCATION         -> SDT-LOCATION
                            WDM-ITEM             -> SDT-ITEM
                            WDD-UOM              -> SDT-UOM
                            WDD-LOT              -> SDT-LOT
                            WDD-SUBLOT           -> SDT-SUBLOT
                            WDD-BIN              -> SDT-BIN

Whdemand       WHDEMAND     Required

                            WDD-COMPANY          -> WDM-COMPANY
                            WDD-SYSTEM-CD        -> WDM-SYSTEM-CD
                            WDD-DOC-NBR          -> WDM-DOC-NBR
                            WDD-LINE-NBR         -> WDM-LINE-NBR
                            WDD-COMPONENT-SEQ    -> WDM-COMPONENT-SEQ
                            WDD-LOCATION         -> WDM-LOCATION