Lawson Insight Technical Documentation

Generated by:
Documentation generated by Decision Analytics

ERDs Tables Conditions Elements Libraries APIs Forms

SOHDETAIL


                             SOHDETAIL FILE

The Stock On Hand Detail File contains the detail quantities for an item at a
location, if the item is controlled by bin or lot/sublot or multiple units of
measure. The sum of the stock-on-hand quantities in these records equals the
stock-on-hand quantity at the Item Location level.

REFERENCED BY

IC230     IC29.1    IC300     IC42.2    IC42.1    IC42.4
IC44.1    IC574     IC74.1    WHD2.1    IC15.2    IC41.1
IC51.1    IC598     IC138     IC223     IC237     IC238
IC01.3    IC43.1

UPDATED BY

AP125     AP126     AP131     AP20.1    AP20.2    AP20.3
AP20.4    AP20.5    AP20.7    AP23.1    AP25.1    AP25.2
AP26.1    AP27.1    AP30.4    API1.1    IC10.2    IC11.1
IC12.1    IC170     IC175     IC179     IC20.1    IC20.2
IC21.1    IC21.2    IC22.1    IC22.2    IC23.1    IC23.2
IC24.1    IC24.2    IC25.1    IC26.1    IC26.2    IC28.1
IC330     IC500     IC73.1    IC820     IC90.1    MA180
MA41.2    MA41.7    MA43.1    MA43.2    MA43.3    MA43.9
MA530     MA531     MA60.2    MA60.3    MA60.5    MA61.1
MA66.2    MA66.3    MA67.1    MA67.2    MA70.1    MA75.1
MA80.1    MAI1.1    PO100     PO101     PO122     PO131
PO20.1    PO21.1    PO21.2    PO21.3    PO21.4    PO21.5
PO22.1    PO23.1    PO25.1    PO25.5    PO25.6    PO25.7
PO27.2    PO29.1    PO30.1    PO30.2    PO30.3    PO300
PO31.1    PO31.2    PO32.2    PO33.1    PO34.1    PO35.1
PO36.1    PO36.2    PO38.1    PO39.1    PO39.2    PO44.1
PO50.1    PO52.1    PO520     PO536     POI3.1    POII.1
POIJ.1    RQ10.1    RQ10.2    RQ10.3    RQ35.1    RQIE.1
WH130     WH132     WH190     WH20.2    WH20.3    WH20.4
WH20.5    WH20.6    WH20.7    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     WHD3.1    WO120     WO132     WO140     WO20.1
WO30.1    WO32.1    WO32.2    WO32.3    WO32.4    WO32.5
WO40.1    WO40.2    WO40.3    WO40.4    WO40.5    WO41.1
WO41.2    WO41.3    WO41.4    WO42.1    WO42.2    WO42.3
WO42.4    WO42.5    WO45.1

FIELD NAME             DESCRIPTION/VALID VALUES                  UPDATED BY

SDT-COMPANY            Numeric 4                                 AP125   AP126
Element: Company       The company number represents an          AP131   AP20.1
                       established company and is entered on     AP20.2  AP20.3
                       all function codes.                       AP20.4  AP20.5
                                                                 AP20.7  AP23.1
                                                                 AP25.1  AP25.2
                                                                 AP26.1  AP27.1
                                                                 AP30.4  API1.1
                                                                 IC10.2  IC11.1
                                                                 IC12.1  IC175
                                                                 IC20.1  IC20.2
                                                                 IC21.1  IC21.2
                                                                 IC22.1  IC22.2
                                                                 IC23.1  IC23.2
                                                                 IC24.1  IC24.2
                                                                 IC25.1  IC26.1
                                                                 IC26.2  IC28.1
                                                                 IC330   IC500
                                                                 IC820   IC90.1
                                                                 MA180   MA41.2
                                                                 MA41.7  MA43.1
                                                                 MA43.2  MA43.3
                                                                 MA43.9  MA530
                                                                 MA531   MA60.2
                                                                 MA60.3  MA60.5
                                                                 MA61.1  MA66.2
                                                                 MA66.3  MA67.1
                                                                 MA67.2  MA70.1
                                                                 MA75.1  MA80.1
                                                                 MAI1.1  PO100
                                                                 ...

SDT-LOCATION           Alpha 5                                   AP125   AP126
Element: Location Code This field contains a valid stocking      AP131   AP20.1
                       location within the company inventory.    AP20.2  AP20.3
                                                                 AP20.4  AP20.5
                                                                 AP20.7  AP23.1
                                                                 AP25.1  AP25.2
                                                                 AP26.1  AP27.1
                                                                 AP30.4  API1.1
                                                                 IC10.2  IC11.1
                                                                 IC12.1  IC175
                                                                 IC20.1  IC20.2
                                                                 IC21.1  IC21.2
                                                                 IC22.1  IC22.2
                                                                 IC23.1  IC23.2
                                                                 IC24.1  IC24.2
                                                                 IC25.1  IC26.1
                                                                 IC26.2  IC28.1
                                                                 IC330   IC500
                                                                 IC820   IC90.1
                                                                 MA180   MA41.2
                                                                 MA41.7  MA43.1
                                                                 MA43.2  MA43.3
                                                                 MA43.9  MA530
                                                                 MA531   MA60.2
                                                                 MA60.3  MA60.5
                                                                 MA61.1  MA66.2
                                                                 MA66.3  MA67.1
                                                                 MA67.2  MA70.1
                                                                 MA75.1  MA80.1
                                                                 MAI1.1  PO100
                                                                 ...

SDT-ITEM               Alpha 32                                  AP125   AP126
Element: Item Number   This field contains the item              AP131   AP20.1
                       identifier.                               AP20.2  AP20.3
                                                                 AP20.4  AP20.5
                                                                 AP20.7  AP23.1
                                                                 AP25.1  AP25.2
                                                                 AP26.1  AP27.1
                                                                 AP30.4  API1.1
                                                                 IC10.2  IC11.1
                                                                 IC12.1  IC175
                                                                 IC20.1  IC20.2
                                                                 IC21.1  IC21.2
                                                                 IC22.1  IC22.2
                                                                 IC23.1  IC23.2
                                                                 IC24.1  IC24.2
                                                                 IC25.1  IC26.1
                                                                 IC26.2  IC28.1
                                                                 IC330   IC500
                                                                 IC820   IC90.1
                                                                 MA180   MA41.2
                                                                 MA41.7  MA43.1
                                                                 MA43.2  MA43.3
                                                                 MA43.9  MA530
                                                                 MA531   MA60.2
                                                                 MA60.3  MA60.5
                                                                 MA61.1  MA66.2
                                                                 MA66.3  MA67.1
                                                                 MA67.2  MA70.1
                                                                 MA75.1  MA80.1
                                                                 MAI1.1  PO100
                                                                 ...

SDT-UOM                Alpha 4                                   AP125   AP126
Element: Unit of MeasurThis field contains a valid tracking      AP131   AP20.1
                       unit of measure for this item. This       AP20.2  AP20.3
                       field indicates there is stock-on-hand    AP20.4  AP20.5
                       quantity for this item at this detail     AP20.7  AP23.1
                       level.                                    AP25.1  AP25.2
                                                                 AP26.1  AP27.1
                                                                 AP30.4  API1.1
                                                                 IC10.2  IC11.1
                                                                 IC12.1  IC175
                                                                 IC20.1  IC20.2
                                                                 IC21.1  IC21.2
                                                                 IC22.1  IC22.2
                                                                 IC23.1  IC23.2
                                                                 IC24.1  IC24.2
                                                                 IC25.1  IC26.1
                                                                 IC26.2  IC28.1
                                                                 IC330   IC500
                                                                 IC820   IC90.1
                                                                 MA180   MA41.2
                                                                 MA41.7  MA43.1
                                                                 MA43.2  MA43.3
                                                                 MA43.9  MA530
                                                                 MA531   MA60.2
                                                                 MA60.3  MA60.5
                                                                 MA61.1  MA66.2
                                                                 MA66.3  MA67.1
                                                                 MA67.2  MA70.1
                                                                 MA75.1  MA80.1
                                                                 MAI1.1  PO100
                                                                 ...

SDT-LOT                Alpha 10                                  AP125   AP126
Element: Lot Number    This field contains the identifier for    AP131   AP20.1
                       a homogeneous quantity of material.       AP20.2  AP20.3
                                                                 AP20.4  AP20.5
                                                                 AP20.7  AP23.1
                                                                 AP25.1  AP25.2
                                                                 AP26.1  AP27.1
                                                                 AP30.4  API1.1
                                                                 IC10.2  IC11.1
                                                                 IC12.1  IC175
                                                                 IC20.1  IC20.2
                                                                 IC21.1  IC21.2
                                                                 IC22.1  IC22.2
                                                                 IC23.1  IC23.2
                                                                 IC24.1  IC24.2
                                                                 IC25.1  IC26.1
                                                                 IC26.2  IC28.1
                                                                 IC330   IC500
                                                                 IC820   IC90.1
                                                                 MA180   MA41.2
                                                                 MA41.7  MA43.1
                                                                 MA43.2  MA43.3
                                                                 MA43.9  MA530
                                                                 MA531   MA60.2
                                                                 MA60.3  MA60.5
                                                                 MA61.1  MA66.2
                                                                 MA66.3  MA67.1
                                                                 MA67.2  MA70.1
                                                                 MA75.1  MA80.1
                                                                 MAI1.1  PO100
                                                                 ...

SDT-SUBLOT             Alpha 6                                   AP125   AP126
Element: Sublot Number This field contains the identifier for    AP131   AP20.1
                       a detail breakdown of a lot number.       AP20.2  AP20.3
                                                                 AP20.4  AP20.5
                                                                 AP20.7  AP23.1
                                                                 AP25.1  AP25.2
                                                                 AP26.1  AP27.1
                                                                 AP30.4  API1.1
                                                                 IC10.2  IC11.1
                                                                 IC12.1  IC175
                                                                 IC20.1  IC20.2
                                                                 IC21.1  IC21.2
                                                                 IC22.1  IC22.2
                                                                 IC23.1  IC23.2
                                                                 IC24.1  IC24.2
                                                                 IC25.1  IC26.1
                                                                 IC26.2  IC28.1
                                                                 IC330   IC500
                                                                 IC820   IC90.1
                                                                 MA180   MA41.2
                                                                 MA41.7  MA43.1
                                                                 MA43.2  MA43.3
                                                                 MA43.9  MA530
                                                                 MA531   MA60.2
                                                                 MA60.3  MA60.5
                                                                 MA61.1  MA66.2
                                                                 MA66.3  MA67.1
                                                                 MA67.2  MA70.1
                                                                 MA75.1  MA80.1
                                                                 MAI1.1  PO100
                                                                 ...

SDT-BIN                Alpha 7                                   AP125   AP126
Element: Bin           This field contains a storage area for    AP131   AP20.1
                       an item or any number of items.           AP20.2  AP20.3
                                                                 AP20.4  AP20.5
                                                                 AP20.7  AP23.1
                                                                 AP25.1  AP25.2
                                                                 AP26.1  AP27.1
                                                                 AP30.4  API1.1
                                                                 IC10.2  IC11.1
                                                                 IC12.1  IC175
                                                                 IC20.1  IC20.2
                                                                 IC21.1  IC21.2
                                                                 IC22.1  IC22.2
                                                                 IC23.1  IC23.2
                                                                 IC24.1  IC24.2
                                                                 IC25.1  IC26.1
                                                                 IC26.2  IC28.1
                                                                 IC330   IC500
                                                                 IC820   IC90.1
                                                                 MA180   MA41.2
                                                                 MA41.7  MA43.1
                                                                 MA43.2  MA43.3
                                                                 MA43.9  MA530
                                                                 MA531   MA60.2
                                                                 MA60.3  MA60.5
                                                                 MA61.1  MA66.2
                                                                 MA66.3  MA67.1
                                                                 MA67.2  MA70.1
                                                                 MA75.1  MA80.1
                                                                 MAI1.1  PO100
                                                                 ...

SDT-SOH-QTY            Signed 13.4                               AP125   AP126
Element: Quantity      This field indicates the quantity         AP131   AP20.1
                       currently on hand in inventory for this   AP20.2  AP20.3
                       bin, unit of measure, and lot/sublot      AP20.4  AP20.5
                       combination.                              AP20.7  AP23.1
                                                                 AP25.1  AP25.2
                                                                 AP26.1  AP27.1
                                                                 AP30.4  API1.1
                                                                 IC10.2  IC11.1
                                                                 IC12.1  IC175
                                                                 IC20.1  IC20.2
                                                                 IC21.1  IC21.2
                                                                 IC22.1  IC22.2
                                                                 IC23.1  IC23.2
                                                                 IC24.1  IC24.2
                                                                 IC25.1  IC26.1
                                                                 IC26.2  IC28.1
                                                                 IC330   IC42.1
                                                                 IC42.2  IC44.1
                                                                 IC500   IC820
                                                                 IC90.1  MA180
                                                                 MA41.2  MA41.7
                                                                 MA43.1  MA43.2
                                                                 MA43.3  MA43.9
                                                                 MA530   MA531
                                                                 MA60.2  MA60.3
                                                                 MA60.5  MA61.1
                                                                 MA66.2  MA66.3
                                                                 MA67.1  MA67.2
                                                                 MA70.1  MA75.1
                                                                 ...

SDT-SECONDARY-QTY      Signed 13.4                               AP125   AP126
Element: Quantity                                                AP131   AP20.1
                                                                 AP20.2  AP20.3
                                                                 AP20.4  AP20.5
                                                                 AP20.7  AP23.1
                                                                 AP25.1  AP25.2
                                                                 AP26.1  AP27.1
                                                                 AP30.4  API1.1
                                                                 IC10.2  IC12.1
                                                                 IC175   IC20.1
                                                                 IC20.2  IC21.1
                                                                 IC21.2  IC22.1
                                                                 IC22.2  IC23.1
                                                                 IC23.2  IC24.1
                                                                 IC24.2  IC25.1
                                                                 IC26.1  IC26.2
                                                                 IC28.1  IC330
                                                                 IC500   IC820
                                                                 IC90.1  MA180
                                                                 MA41.2  MA41.7
                                                                 MA43.1  MA43.2
                                                                 MA43.3  MA43.9
                                                                 MA530   MA531
                                                                 MA60.2  MA60.3
                                                                 MA60.5  MA61.1
                                                                 MA66.2  MA66.3
                                                                 MA67.1  MA67.2
                                                                 MA70.1  MA75.1
                                                                 MA80.1  MAI1.1
                                                                 PO100   PO101
                                                                 ...

SDT-BIN-TYPE           Alpha 1                                   AP125   AP126
Element: Bin Usage TypeThis field indicates how the bin is       AP131   AP20.1
                       used. One example is inspection. It is    AP20.2  AP20.3
                       used in this field for processing         AP20.4  AP20.5
                       efficiencies.                             AP20.7  AP23.1
                                                                 AP25.1  AP25.2
                                                                 AP26.1  AP27.1
                                                                 AP30.4  API1.1
                                                                 IC10.2  IC12.1
                                                                 IC175   IC20.1
                                                                 IC20.2  IC21.1
                                                                 IC21.2  IC22.1
                                                                 IC22.2  IC23.1
                                                                 IC23.2  IC24.1
                                                                 IC24.2  IC25.1
                                                                 IC26.1  IC26.2
                                                                 IC28.1  IC330
                                                                 IC500   IC820
                                                                 IC90.1  MA180
                                                                 MA41.2  MA41.7
                                                                 MA43.1  MA43.2
                                                                 MA43.3  MA43.9
                                                                 MA530   MA531
                                                                 MA60.2  MA60.3
                                                                 MA60.5  MA61.1
                                                                 MA66.2  MA66.3
                                                                 MA67.1  MA67.2
                                                                 MA70.1  MA75.1
                                                                 MA80.1  MAI1.1
                                                                 PO100   PO101
                                                                 ...

SDT-ALLOC-QTY          Signed 13.4                               AP125   AP126
Element: Quantity      The field contains the allocated          AP131   AP20.1
                       quantity for this detail record. This     AP20.2  AP20.3
                       field is maintained by the Warehouse      AP20.4  AP20.5
                       system.                                   AP20.7  AP23.1
                                                                 AP25.1  AP25.2
                                                                 AP26.1  AP27.1
                                                                 AP30.4  API1.1
                                                                 IC10.2  IC11.1
                                                                 IC12.1  IC175
                                                                 IC20.1  IC20.2
                                                                 IC21.1  IC21.2
                                                                 IC22.1  IC22.2
                                                                 IC23.1  IC23.2
                                                                 IC24.1  IC24.2
                                                                 IC25.1  IC26.1
                                                                 IC26.2  IC28.1
                                                                 IC330   IC42.1
                                                                 IC42.2  IC44.1
                                                                 IC500   IC90.1
                                                                 MA180   MA41.2
                                                                 MA41.7  MA43.1
                                                                 MA43.2  MA43.3
                                                                 MA43.9  MA530
                                                                 MA531   MA60.2
                                                                 MA60.3  MA60.5
                                                                 MA61.1  MA66.2
                                                                 MA66.3  MA67.1
                                                                 MA67.2  MA70.1
                                                                 MA75.1  MA80.1
                                                                 ...

SDT-HOLD-QTY           Signed 13.4                               AP125   AP126
Element: Quantity      The field contains the quantity put on    AP131   AP20.1
                       hold for inspection. This field is        AP20.2  AP20.3
                       maintained by the Purchase Order system.  AP20.4  AP20.5
                                                                 AP20.7  AP23.1
                                                                 AP25.1  AP25.2
                                                                 AP26.1  AP27.1
                                                                 AP30.4  API1.1
                                                                 IC10.2  IC11.1
                                                                 IC12.1  IC175
                                                                 IC20.1  IC20.2
                                                                 IC21.1  IC21.2
                                                                 IC22.1  IC22.2
                                                                 IC23.1  IC23.2
                                                                 IC24.1  IC24.2
                                                                 IC25.1  IC26.1
                                                                 IC26.2  IC28.1
                                                                 IC330   IC42.1
                                                                 IC42.2  IC44.1
                                                                 IC500   IC90.1
                                                                 MA180   MA41.2
                                                                 MA41.7  MA43.1
                                                                 MA43.2  MA43.3
                                                                 MA43.9  MA530
                                                                 MA531   MA60.2
                                                                 MA60.3  MA60.5
                                                                 MA61.1  MA66.2
                                                                 MA66.3  MA67.1
                                                                 MA67.2  MA70.1
                                                                 MA75.1  MA80.1
                                                                 ...

SDT-FREEZE-FL          Alpha 1                                   IC170   IC175
Element: All Flag      This field indicates this record has      IC179   IC73.1
                       been selected to be counted in the        IC820
                       physical inventory process.
                       N = No
                       Y = Yes

SDT-FREEZE-DT          Numeric 8  (yyyymmdd)                     IC170   IC820
Element: Date          The field contains the date when this
                       record was last selected for physical
                       inventory counting.

SDT-AVAIL-QTY          Derived
Element: Available QuanThe field contains the detail available
                       quantity. This field is calculated by
                       the system.

SDT-CWT-AVAIL-QTY      Derived
Element: Cwt Avail Qty The field contains the available
                       quantity if this item is a catch weight
                       item. This field is calculated by the
                       system.

SDT-AVAILABLE-QTY      Derived
Element: Available QuanThis is a conditionally calculated
                       field. The field contains the available
                       quantity that is displayed on inquiries.
                       If the item is a catch weight item, it
                       is the catch weight available quantity.

                         SOHDETAIL FILE INDEX

NAME      KEY FIELDS    DESCRIPTION / SUBSET CONDITION           USED IN

SDTSET1   COMPANY                                                AP125   AP126
          LOCATION                                               AP131   AP20.1
          ITEM                                                   AP20.2  AP20.3
          UOM                                                    AP20.4  AP20.5
          LOT                                                    AP20.7  AP23.1
          SUBLOT                                                 AP25.1  AP25.2
          BIN                                                    AP26.1  AP27.1
                                                                 AP30.4  API1.1
                                                                 IC10.2  IC11.1
                                                                 IC12.1  IC170
                                                                 IC175   IC20.1
                                                                 IC20.2  IC21.1
                                                                 IC21.2  IC22.1
                                                                 IC22.2  IC23.1
                                                                 IC23.2  IC230
                                                                 ...

SDTSET2   COMPANY                                                IC15.2  IC170
          LOCATION                                               IC41.1  IC51.1
          BIN                                                    IC598
          ITEM
          UOM
          LOT
          SUBLOT

SDTSET3   COMPANY                                                AP125   AP126
          LOCATION                                               AP131   AP20.1
          ITEM                                                   AP20.2  AP20.3
          BIN                                                    AP20.4  AP20.5
          UOM                                                    AP20.7  AP23.1
          LOT                                                    AP25.1  AP25.2
          SUBLOT                                                 AP26.1  AP27.1
                                                                 AP30.4  API1.1
                                                                 IC138   IC170
                                                                 IC175   IC179
                                                                 IC20.1  IC20.2
                                                                 IC21.1  IC21.2
                                                                 IC22.1  IC22.2
                                                                 IC223   IC23.1
                                                                 IC23.2  IC237
                                                                 ...

SDTSET4   COMPANY       Subset                                   IC01.3  IC43.1
          LOCATION      Where BIN-TYPE != Spaces
          BIN-TYPE
          ITEM
          BIN
          UOM
          LOT
          SUBLOT

                         SOHDETAIL FILE RELATIONS

ONE TO ONE RELATIONS


RELATION       RELATED
 NAME           FILE        INTEGRITY RULES / FIELD MATCH

Company        ICCOMPANY    Required

                            SDT-COMPANY       -> ICC-COMPANY

Icbin          ICBIN        Required
                            When SDT-BIN != Spaces

                            SDT-COMPANY       -> ICB-COMPANY
                            SDT-LOCATION      -> ICB-LOCATION
                            SDT-BIN           -> ICB-BIN

Iclot          ICLOT        Not Required

                            SDT-COMPANY       -> ILT-COMPANY
                            SDT-LOCATION      -> ILT-LOCATION
                            SDT-ITEM          -> ILT-ITEM
                            SDT-LOT           -> ILT-LOT

Item           ITEMMAST     Required

                            ICC-ITEM-GROUP    -> ITE-ITEM-GROUP
                            SDT-ITEM          -> ITE-ITEM

Itemloc        ITEMLOC      Required

                            SDT-COMPANY       -> ITL-COMPANY
                            SDT-LOCATION      -> ITL-LOCATION
                            SDT-ITEM          -> ITL-ITEM

Location       ICLOCATION   Required

                            SDT-COMPANY       -> ICL-COMPANY
                            SDT-LOCATION      -> ICL-LOCATION