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

WHD2.1    IC15.2    IC01.3

UPDATED BY

AP125     AP126     AP131     AP20.1    AP20.2    AP20.3
AP20.4    AP20.5    AP20.7    AP21.1    AP23.1    AP25.1
AP25.2    AP26.1    AP27.1    AP30.4    API1.1    BL120
BL122     BL130     BL20.1    BL20.3    BL21.2    BL21.5
BL29.1    BL29.2    BL520     BL820     BL92.1    IC11.1
IC12.1    IC330     MA180     MA41.1    MA41.2    MA41.4
MA41.7    MA43.1    MA43.2    MA43.3    MA43.7    MA530
MA531     MA60.2    MA60.3    MA60.5    MA61.1    MA66.2
MA66.3    MA67.2    MA67.3    MA68.2    MA68.3    MA68.5
MA70.1    MA75.1    MA80.1    MAI1.1    PD10.1    PD10.2
PD130     PD20.1    PD20.2    PD20.3    PO100     PO101
PO122     PO131     PO190     PO20.1    PO21.1    PO21.2
PO21.3    PO21.4    PO21.5    PO22.1    PO23.1    PO24.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    PO32.4    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    POID.1    POII.1
POIJ.1    RQ10.1    RQ10.2    RQ35.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


FIELD NAME             DESCRIPTION/VALID VALUES                  UPDATED BY

SDT-COMPANY            Numeric 4                                 AP125   AP126
Element: Company       Identifies the AP company if the          AP131   AP20.1
                       resource type = V.  Identifies the HR     AP20.2  AP20.3
                       company if the resource type = E.  It is  AP20.4  AP20.5
                       blank for type A, P or Q resources.       AP20.7  AP21.1
                                                                 AP23.1  AP25.1
                                                                 AP25.2  AP26.1
                                                                 AP27.1  AP30.4
                                                                 API1.1  BL120
                                                                 BL122   BL130
                                                                 BL20.1  BL20.3
                                                                 BL21.2  BL21.5
                                                                 BL29.1  BL29.2
                                                                 BL520   BL820
                                                                 BL92.1  IC11.1
                                                                 IC12.1  IC330
                                                                 MA180   MA41.1
                                                                 MA41.2  MA41.4
                                                                 MA41.7  MA43.1
                                                                 MA43.2  MA43.3
                                                                 MA43.7  MA530
                                                                 MA531   MA60.2
                                                                 MA60.3  MA60.5
                                                                 MA61.1  MA66.2
                                                                 MA66.3  MA67.2
                                                                 MA67.3  MA68.2
                                                                 MA68.3  MA68.5
                                                                 MA70.1  MA75.1
                                                                 MA80.1  MAI1.1
                                                                 PD10.1  PD10.2
                                                                 ...

SDT-LOCATION           Alpha 5                                   AP125   AP126
Element: Location      This field contains a valid stocking      AP131   AP20.1
                       location within the company inventory.    AP20.2  AP20.3
                                                                 AP20.4  AP20.5
                                                                 AP20.7  AP21.1
                                                                 AP23.1  AP25.1
                                                                 AP25.2  AP26.1
                                                                 AP27.1  AP30.4
                                                                 API1.1  BL120
                                                                 BL122   BL130
                                                                 BL20.1  BL20.3
                                                                 BL21.2  BL21.5
                                                                 BL29.1  BL29.2
                                                                 BL520   BL820
                                                                 BL92.1  IC11.1
                                                                 IC12.1  IC330
                                                                 MA180   MA41.1
                                                                 MA41.2  MA41.4
                                                                 MA41.7  MA43.1
                                                                 MA43.2  MA43.3
                                                                 MA43.7  MA530
                                                                 MA531   MA60.2
                                                                 MA60.3  MA60.5
                                                                 MA61.1  MA66.2
                                                                 MA66.3  MA67.2
                                                                 MA67.3  MA68.2
                                                                 MA68.3  MA68.5
                                                                 MA70.1  MA75.1
                                                                 MA80.1  MAI1.1
                                                                 PD10.1  PD10.2
                                                                 ...

SDT-ITEM               Alpha 32                                  AP125   AP126
Element: Item          This field contains the item              AP131   AP20.1
                       identifier.                               AP20.2  AP20.3
                                                                 AP20.4  AP20.5
                                                                 AP20.7  AP21.1
                                                                 AP23.1  AP25.1
                                                                 AP25.2  AP26.1
                                                                 AP27.1  AP30.4
                                                                 API1.1  BL120
                                                                 BL122   BL130
                                                                 BL20.1  BL20.3
                                                                 BL21.2  BL21.5
                                                                 BL29.1  BL29.2
                                                                 BL520   BL820
                                                                 BL92.1  IC11.1
                                                                 IC12.1  IC330
                                                                 MA180   MA41.1
                                                                 MA41.2  MA41.4
                                                                 MA41.7  MA43.1
                                                                 MA43.2  MA43.3
                                                                 MA43.7  MA530
                                                                 MA531   MA60.2
                                                                 MA60.3  MA60.5
                                                                 MA61.1  MA66.2
                                                                 MA66.3  MA67.2
                                                                 MA67.3  MA68.2
                                                                 MA68.3  MA68.5
                                                                 MA70.1  MA75.1
                                                                 MA80.1  MAI1.1
                                                                 PD10.1  PD10.2
                                                                 ...

SDT-UOM                Alpha 4                                   AP125   AP126
Element: Uom           This 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  AP21.1
                       level.                                    AP23.1  AP25.1
                                                                 AP25.2  AP26.1
                                                                 AP27.1  AP30.4
                                                                 API1.1  BL120
                                                                 BL122   BL130
                                                                 BL20.1  BL20.3
                                                                 BL21.2  BL21.5
                                                                 BL29.1  BL29.2
                                                                 BL520   BL820
                                                                 BL92.1  IC11.1
                                                                 IC12.1  IC330
                                                                 MA180   MA41.1
                                                                 MA41.2  MA41.4
                                                                 MA41.7  MA43.1
                                                                 MA43.2  MA43.3
                                                                 MA43.7  MA530
                                                                 MA531   MA60.2
                                                                 MA60.3  MA60.5
                                                                 MA61.1  MA66.2
                                                                 MA66.3  MA67.2
                                                                 MA67.3  MA68.2
                                                                 MA68.3  MA68.5
                                                                 MA70.1  MA75.1
                                                                 MA80.1  MAI1.1
                                                                 PD10.1  PD10.2
                                                                 ...

SDT-LOT                Alpha 10                                  AP125   AP126
Element: Lot           This field contains the identifier for    AP131   AP20.1
                       a homogeneous quantity of material.       AP20.2  AP20.3
                                                                 AP20.4  AP20.5
                                                                 AP20.7  AP21.1
                                                                 AP23.1  AP25.1
                                                                 AP25.2  AP26.1
                                                                 AP27.1  AP30.4
                                                                 API1.1  BL120
                                                                 BL122   BL130
                                                                 BL20.1  BL20.3
                                                                 BL21.2  BL21.5
                                                                 BL29.1  BL29.2
                                                                 BL520   BL820
                                                                 BL92.1  IC11.1
                                                                 IC12.1  IC330
                                                                 MA180   MA41.1
                                                                 MA41.2  MA41.4
                                                                 MA41.7  MA43.1
                                                                 MA43.2  MA43.3
                                                                 MA43.7  MA530
                                                                 MA531   MA60.2
                                                                 MA60.3  MA60.5
                                                                 MA61.1  MA66.2
                                                                 MA66.3  MA67.2
                                                                 MA67.3  MA68.2
                                                                 MA68.3  MA68.5
                                                                 MA70.1  MA75.1
                                                                 MA80.1  MAI1.1
                                                                 PD10.1  PD10.2
                                                                 ...

SDT-SUBLOT             Alpha 6                                   AP125   AP126
Element: Sublot        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  AP21.1
                                                                 AP23.1  AP25.1
                                                                 AP25.2  AP26.1
                                                                 AP27.1  AP30.4
                                                                 API1.1  BL120
                                                                 BL122   BL130
                                                                 BL20.1  BL20.3
                                                                 BL21.2  BL21.5
                                                                 BL29.1  BL29.2
                                                                 BL520   BL820
                                                                 BL92.1  IC11.1
                                                                 IC12.1  IC330
                                                                 MA180   MA41.1
                                                                 MA41.2  MA41.4
                                                                 MA41.7  MA43.1
                                                                 MA43.2  MA43.3
                                                                 MA43.7  MA530
                                                                 MA531   MA60.2
                                                                 MA60.3  MA60.5
                                                                 MA61.1  MA66.2
                                                                 MA66.3  MA67.2
                                                                 MA67.3  MA68.2
                                                                 MA68.3  MA68.5
                                                                 MA70.1  MA75.1
                                                                 MA80.1  MAI1.1
                                                                 PD10.1  PD10.2
                                                                 ...

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  AP21.1
                                                                 AP23.1  AP25.1
                                                                 AP25.2  AP26.1
                                                                 AP27.1  AP30.4
                                                                 API1.1  BL120
                                                                 BL122   BL130
                                                                 BL20.1  BL20.3
                                                                 BL21.2  BL21.5
                                                                 BL29.1  BL29.2
                                                                 BL520   BL820
                                                                 BL92.1  IC11.1
                                                                 IC12.1  IC330
                                                                 MA180   MA41.1
                                                                 MA41.2  MA41.4
                                                                 MA41.7  MA43.1
                                                                 MA43.2  MA43.3
                                                                 MA43.7  MA530
                                                                 MA531   MA60.2
                                                                 MA60.3  MA60.5
                                                                 MA61.1  MA66.2
                                                                 MA66.3  MA67.2
                                                                 MA67.3  MA68.2
                                                                 MA68.3  MA68.5
                                                                 MA70.1  MA75.1
                                                                 MA80.1  MAI1.1
                                                                 PD10.1  PD10.2
                                                                 ...

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  AP21.1
                                                                 AP23.1  AP25.1
                                                                 AP25.2  AP26.1
                                                                 AP27.1  AP30.4
                                                                 API1.1  BL120
                                                                 BL122   BL130
                                                                 BL20.1  BL20.3
                                                                 BL21.2  BL21.5
                                                                 BL29.1  BL29.2
                                                                 BL520   BL820
                                                                 BL92.1  IC11.1
                                                                 IC12.1  IC330
                                                                 MA180   MA41.1
                                                                 MA41.2  MA41.4
                                                                 MA41.7  MA43.1
                                                                 MA43.2  MA43.3
                                                                 MA43.7  MA530
                                                                 MA531   MA60.2
                                                                 MA60.3  MA60.5
                                                                 MA61.1  MA66.2
                                                                 MA66.3  MA67.2
                                                                 MA67.3  MA68.2
                                                                 MA68.3  MA68.5
                                                                 MA70.1  MA75.1
                                                                 MA80.1  MAI1.1
                                                                 PD10.1  PD10.2
                                                                 ...

SDT-SECONDARY-QTY      Signed 13.4                               AP125   AP126
Element: Secondary Qty This field contains the secondary         AP131   AP20.1
                       quantity, which is tracked if the item    AP20.2  AP20.3
                       is a catch weight item.  This quantity    AP20.4  AP20.5
                       is a memo quantity only.  It is not used  AP20.7  AP21.1
                       for valuation.                            AP23.1  AP25.1
                                                                 AP25.2  AP26.1
                                                                 AP27.1  AP30.4
                                                                 API1.1  BL120
                                                                 BL122   BL130
                                                                 BL20.1  BL20.3
                                                                 BL21.2  BL21.5
                                                                 BL29.1  BL29.2
                                                                 BL520   BL820
                                                                 BL92.1  IC12.1
                                                                 IC330   MA180
                                                                 MA41.1  MA41.2
                                                                 MA41.4  MA41.7
                                                                 MA43.1  MA43.2
                                                                 MA43.3  MA43.7
                                                                 MA530   MA531
                                                                 MA60.2  MA60.3
                                                                 MA60.5  MA61.1
                                                                 MA66.2  MA66.3
                                                                 MA67.2  MA67.3
                                                                 MA68.2  MA68.3
                                                                 MA68.5  MA70.1
                                                                 MA75.1  MA80.1
                                                                 MAI1.1  PD10.1
                                                                 PD10.2  PD130
                                                                 ...

SDT-BIN-TYPE           Alpha 1                                   AP125   AP126
Element: Bin Type      This 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  AP21.1
                                                                 AP23.1  AP25.1
                                                                 AP25.2  AP26.1
                                                                 AP27.1  AP30.4
                                                                 API1.1  BL120
                                                                 BL122   BL130
                                                                 BL20.1  BL20.3
                                                                 BL21.2  BL21.5
                                                                 BL29.1  BL29.2
                                                                 BL520   BL820
                                                                 BL92.1  IC12.1
                                                                 IC330   MA180
                                                                 MA41.1  MA41.2
                                                                 MA41.4  MA41.7
                                                                 MA43.1  MA43.2
                                                                 MA43.3  MA43.7
                                                                 MA530   MA531
                                                                 MA60.2  MA60.3
                                                                 MA60.5  MA61.1
                                                                 MA66.2  MA66.3
                                                                 MA67.2  MA67.3
                                                                 MA68.2  MA68.3
                                                                 MA68.5  MA70.1
                                                                 MA75.1  MA80.1
                                                                 MAI1.1  PD10.1
                                                                 PD10.2  PD130
                                                                 ...

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  AP21.1
                                                                 AP23.1  AP25.1
                                                                 AP25.2  AP26.1
                                                                 AP27.1  AP30.4
                                                                 API1.1  BL120
                                                                 BL122   BL130
                                                                 BL20.1  BL20.3
                                                                 BL21.2  BL21.5
                                                                 BL29.1  BL29.2
                                                                 BL520   BL820
                                                                 BL92.1  IC11.1
                                                                 IC12.1  IC330
                                                                 MA180   MA41.1
                                                                 MA41.2  MA41.4
                                                                 MA41.7  MA43.1
                                                                 MA43.2  MA43.3
                                                                 MA43.7  MA530
                                                                 MA531   MA60.2
                                                                 MA60.3  MA60.5
                                                                 MA61.1  MA66.2
                                                                 MA66.3  MA67.2
                                                                 MA67.3  MA68.2
                                                                 MA68.3  MA68.5
                                                                 MA70.1  MA75.1
                                                                 MA80.1  MAI1.1
                                                                 PD10.1  PD10.2
                                                                 ...

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  AP21.1
                                                                 AP23.1  AP25.1
                                                                 AP25.2  AP26.1
                                                                 AP27.1  AP30.4
                                                                 API1.1  BL120
                                                                 BL122   BL130
                                                                 BL20.1  BL20.3
                                                                 BL21.2  BL21.5
                                                                 BL29.1  BL29.2
                                                                 BL520   BL820
                                                                 BL92.1  IC11.1
                                                                 IC12.1  IC330
                                                                 MA180   MA41.1
                                                                 MA41.2  MA41.4
                                                                 MA41.7  MA43.1
                                                                 MA43.2  MA43.3
                                                                 MA43.7  MA530
                                                                 MA531   MA60.2
                                                                 MA60.3  MA60.5
                                                                 MA61.1  MA66.2
                                                                 MA66.3  MA67.2
                                                                 MA67.3  MA68.2
                                                                 MA68.3  MA68.5
                                                                 MA70.1  MA75.1
                                                                 MA80.1  MAI1.1
                                                                 PD10.1  PD10.2
                                                                 ...

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

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

SDT-AVAIL-QTY          Derived
Element: Avail Qty     The 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 Qty This 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  AP21.1
          SUBLOT                                                 AP23.1  AP25.1
          BIN                                                    AP25.2  AP26.1
                                                                 AP27.1  AP30.4
                                                                 API1.1  BL120
                                                                 BL122   BL130
                                                                 BL20.1  BL20.3
                                                                 BL21.2  BL21.5
                                                                 BL29.1  BL29.2
                                                                 BL520   BL820
                                                                 BL92.1  IC11.1
                                                                 ...

SDTSET2   COMPANY                                                IC15.2
          LOCATION
          BIN
          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  AP21.1
          LOT                                                    AP23.1  AP25.1
          SUBLOT                                                 AP25.2  AP26.1
                                                                 AP27.1  AP30.4
                                                                 API1.1  BL120
                                                                 BL122   BL130
                                                                 BL20.1  BL20.3
                                                                 BL21.2  BL21.5
                                                                 BL29.1  BL29.2
                                                                 BL520   BL820
                                                                 BL92.1  MA180
                                                                 ...

SDTSET4   COMPANY       Subset                                   IC01.3
          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