 |
Lawson Insight Technical Documentation |
|
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
IC574 IC74.1 IC15.2 IC41.1 IC51.1 IC138
IC237 IC238 IC01.3 IC43.1
UPDATED BY
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 IC500 IC73.1 IC820 IC90.1 ICI2.1
POIJ.1 WH130 WH33.1 WH33.2 WH33.3 WH33.4
WH33.5 WH33.6 WH33.8 WH33.9 WH34.1 WH34.2
WH34.3 WH34.4
FIELD NAME DESCRIPTION/VALID VALUES UPDATED BY
SDT-COMPANY Numeric 4 IC10.2 IC11.1
Company The company number represents an IC12.1 IC175
established company and is entered on IC20.1 IC20.2
all function codes. IC21.1 IC21.2
IC22.1 IC22.2
IC23.1 IC23.2
IC24.1 IC24.2
IC25.1 IC26.1
IC26.2 IC500
IC820 IC90.1
ICI2.1 POIJ.1
WH130 WH33.1
WH33.2 WH33.3
WH33.4 WH33.5
WH33.6 WH33.8
WH33.9 WH34.1
WH34.2 WH34.3
WH34.4
SDT-LOCATION Alpha 5 IC10.2 IC11.1
Location Code This field contains a valid stocking IC12.1 IC175
location within the company inventory. 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 IC500
IC820 IC90.1
ICI2.1 POIJ.1
WH130 WH33.1
WH33.2 WH33.3
WH33.4 WH33.5
WH33.6 WH33.8
WH33.9 WH34.1
WH34.2 WH34.3
WH34.4
SDT-ITEM Alpha 32 IC10.2 IC11.1
Item Number This field contains the item IC12.1 IC175
identifier. 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 IC500
IC820 IC90.1
ICI2.1 POIJ.1
WH130 WH33.1
WH33.2 WH33.3
WH33.4 WH33.5
WH33.6 WH33.8
WH33.9 WH34.1
WH34.2 WH34.3
WH34.4
SDT-UOM Alpha 4 IC10.2 IC11.1
Unit of Measure This field contains a valid tracking IC12.1 IC175
unit of measure for this item. This IC20.1 IC20.2
field indicates there is stock-on-hand IC21.1 IC21.2
quantity for this item at this detail IC22.1 IC22.2
level. IC23.1 IC23.2
IC24.1 IC24.2
IC25.1 IC26.1
IC26.2 IC500
IC820 IC90.1
ICI2.1 POIJ.1
WH130 WH33.1
WH33.2 WH33.3
WH33.4 WH33.5
WH33.6 WH33.8
WH33.9 WH34.1
WH34.2 WH34.3
WH34.4
SDT-LOT Alpha 10 IC10.2 IC11.1
Lot Number This field contains the identifier for IC12.1 IC175
a homogeneous quantity of material. 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 IC500
IC820 IC90.1
ICI2.1 POIJ.1
WH130 WH33.1
WH33.2 WH33.3
WH33.4 WH33.5
WH33.6 WH33.8
WH33.9 WH34.1
WH34.2 WH34.3
WH34.4
SDT-SUBLOT Alpha 6 IC10.2 IC11.1
Sublot Number This field contains the identifier for IC12.1 IC175
a detail breakdown of a lot number. 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 IC500
IC820 IC90.1
ICI2.1 POIJ.1
WH130 WH33.1
WH33.2 WH33.3
WH33.4 WH33.5
WH33.6 WH33.8
WH33.9 WH34.1
WH34.2 WH34.3
WH34.4
SDT-BIN Alpha 7 IC10.2 IC11.1
Bin This field contains a storage area for IC12.1 IC175
an item or any number of items. 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 IC500
IC820 IC90.1
ICI2.1 POIJ.1
WH130 WH33.1
WH33.2 WH33.3
WH33.4 WH33.5
WH33.6 WH33.8
WH33.9 WH34.1
WH34.2 WH34.3
WH34.4
SDT-SOH-QTY Signed 13.4 IC10.2 IC11.1
Stock On Hand This field indicates the quantity IC12.1 IC175
Quantity currently on hand in inventory for this IC20.1 IC20.2
bin, unit of measure, and lot/sublot IC21.1 IC21.2
combination. IC22.1 IC22.2
IC23.1 IC23.2
IC24.1 IC24.2
IC25.1 IC26.1
IC26.2 IC42.1
IC42.2 IC500
IC820 IC90.1
ICI2.1 POIJ.1
WH130 WH33.1
WH33.2 WH33.3
WH33.4 WH33.5
WH33.6 WH33.8
WH33.9 WH34.1
WH34.2 WH34.3
WH34.4
SDT-SECONDARY-QTY Signed 13.4 IC10.2 IC12.1
Secondary Quantity This field contains the secondary IC175 IC20.1
quantity, which is tracked if the item IC20.2 IC21.1
is a catch weight item. This quantity IC21.2 IC22.1
is a memo quantity only. It is not used IC22.2 IC23.1
for valuation. IC23.2 IC24.1
IC24.2 IC25.1
IC26.1 IC26.2
IC500 IC820
IC90.1 ICI2.1
POIJ.1 WH130
WH33.1 WH33.2
WH33.3 WH33.4
WH33.5 WH33.6
WH33.8 WH33.9
WH34.1 WH34.2
WH34.3 WH34.4
SDT-BIN-TYPE Alpha 1 IC10.2 IC12.1
Bin Usage Type This field indicates how the bin is IC175 IC20.1
used. One example is inspection. It is IC20.2 IC21.1
used in this field for processing IC21.2 IC22.1
efficiencies. IC22.2 IC23.1
IC23.2 IC24.1
IC24.2 IC25.1
IC26.1 IC26.2
IC500 IC820
IC90.1 ICI2.1
POIJ.1 WH130
WH33.1 WH33.2
WH33.3 WH33.4
WH33.5 WH33.6
WH33.8 WH33.9
WH34.1 WH34.2
WH34.3 WH34.4
SDT-ALLOC-QTY Signed 13.4 IC10.2 IC11.1
Allocated Quantity The field contains the allocated IC12.1 IC175
quantity for this detail record. This IC20.1 IC20.2
field is maintained by the Warehouse IC21.1 IC21.2
system. IC22.1 IC22.2
IC23.1 IC23.2
IC24.1 IC24.2
IC25.1 IC26.1
IC26.2 IC42.1
IC42.2 IC500
IC90.1 ICI2.1
POIJ.1 WH130
WH33.1 WH33.2
WH33.3 WH33.4
WH33.5 WH33.6
WH33.8 WH33.9
WH34.1 WH34.2
WH34.3 WH34.4
SDT-HOLD-QTY Signed 13.4 IC10.2 IC11.1
Hold Quantity The field contains the quantity put on IC12.1 IC175
hold for inspection. This field is IC20.1 IC20.2
maintained by the Purchase Order system. IC21.1 IC21.2
IC22.1 IC22.2
IC23.1 IC23.2
IC24.1 IC24.2
IC25.1 IC26.1
IC26.2 IC42.1
IC42.2 IC500
IC90.1 ICI2.1
POIJ.1 WH130
WH33.1 WH33.2
WH33.3 WH33.4
WH33.5 WH33.6
WH33.8 WH33.9
WH34.1 WH34.2
WH34.3 WH34.4
SDT-FREEZE-FL Alpha 1 IC170 IC175
Freeze 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
Freeze Date The field contains the date when this
record was last selected for physical
inventory counting.
SDT-AVAIL-QTY Derived
Available Quantity The field contains the detail available
quantity. This field is calculated by
the system.
SDT-CWT-AVAIL-QTY Derived
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
Available Quantity 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 IC10.2 IC11.1
LOCATION IC12.1 IC170
ITEM IC175 IC20.1
UOM IC20.2 IC21.1
LOT IC21.2 IC22.1
SUBLOT IC22.2 IC23.1
BIN IC23.2 IC230
IC24.1 IC24.2
IC25.1 IC26.1
IC26.2 IC29.1
IC300 IC42.2
IC500 IC574
IC74.1 IC820
IC90.1 ICI2.1
POIJ.1 WH130
...
SDTSET2 COMPANY IC15.2 IC170
LOCATION IC41.1 IC500
BIN IC51.1
ITEM
UOM
LOT
SUBLOT
SDTSET3 COMPANY IC138 IC170
LOCATION IC175 IC179
ITEM IC20.1 IC20.2
BIN IC21.1 IC21.2
UOM IC22.1 IC22.2
LOT IC23.1 IC23.2
SUBLOT IC237 IC238
IC24.1 IC24.2
IC25.1 IC42.1
IC42.4 IC500
IC574 IC73.1
IC74.1 IC90.1
WH130 WH33.1
WH33.2 WH33.4
WH34.1 WH34.2
...
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
|