SOHDETAIL – Stock-on-Hand Detail

System
Inventory Control (IC)
Prefix
SDT
Primary key
COMPANY, LOCATION, ITEM, UOM, LOT, SUBLOT, BIN
Fields
17
Updated by
248 programs
Referenced by
19 programs

SOHDETAIL is the Stock-on-Hand Detail table in Lawson Inventory Control (prefix SDT). It is indexed by COMPANY, LOCATION, ITEM, UOM, LOT, SUBLOT, BIN (SDTSET1); alternate indexes: SDTSET2, SDTSET3 and SDTSET4. It is related 1:1 to ICCOMPANY, ICBIN, ICLOT, ITEMMAST, ITEMLOC and ICLOCATION. It is updated by AP125, AP126, AP131, AP20.1, AP20.2, AP20.3, AP20.4, AP20.5 and 240 more and referenced by IC01.3, IC138, IC15.2, IC223, IC230, IC237, IC238, IC29.1 and 11 more. The table has 17 fields, 4 indexes and 6 documented relations.

About SOHDETAIL

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.

Fields (17)

Column = COBOL field name without the SDT- prefix, hyphens → underscores. Derived fields are computed by the application and are not stored.

Field / columnTypeDescription & valuesUpdated by
SDT-COMPANY PK
COMPANY		Numeric 4Identifies the AP company if the resource type = V. Identifies the HR company if the resource type = E. It is blank for type A, P or Q resources.AP125, AP126, AP131, AP20.1, AP20.2, AP20.3, AP20.4, AP20.5 +52 more (list truncated in source)
SDT-LOCATION PK
LOCATION		Alpha 5This field contains a valid stocking location within the company inventory.AP125, AP126, AP131, AP20.1, AP20.2, AP20.3, AP20.4, AP20.5 +52 more (list truncated in source)
SDT-ITEM PK
ITEM		Alpha 32This field contains the item identifier.AP125, AP126, AP131, AP20.1, AP20.2, AP20.3, AP20.4, AP20.5 +52 more (list truncated in source)
SDT-UOM PK
UOM		Alpha 4This field contains a valid tracking unit of measure for this item. This field indicates there is stock-on-hand quantity for this item at this detail level.AP125, AP126, AP131, AP20.1, AP20.2, AP20.3, AP20.4, AP20.5 +52 more (list truncated in source)
SDT-LOT PK
LOT		Alpha 10This field contains the identifier for a homogeneous quantity of material.AP125, AP126, AP131, AP20.1, AP20.2, AP20.3, AP20.4, AP20.5 +52 more (list truncated in source)
SDT-SUBLOT PK
SUBLOT		Alpha 6This field contains the identifier for a detail breakdown of a lot number.AP125, AP126, AP131, AP20.1, AP20.2, AP20.3, AP20.4, AP20.5 +52 more (list truncated in source)
SDT-BIN PK
BIN		Alpha 7This field contains a storage area for an item or any number of items.AP125, AP126, AP131, AP20.1, AP20.2, AP20.3, AP20.4, AP20.5 +52 more (list truncated in source)
SDT-SOH-QTY
SOH_QTY		Signed 13.4This field indicates the quantity currently on hand in inventory for this bin, unit of measure, and lot/sublot combination.AP125, AP126, AP131, AP20.1, AP20.2, AP20.3, AP20.4, AP20.5 +52 more (list truncated in source)
SDT-SECONDARY-QTY
SECONDARY_QTY		Signed 13.4This field contains the secondary quantity, which is tracked if the item is a catch weight item. This quantity is a memo quantity only. It is not used for valuation.AP125, AP126, AP131, AP20.1, AP20.2, AP20.3, AP20.4, AP20.5 +52 more (list truncated in source)
SDT-BIN-TYPE
BIN_TYPE		Alpha 1This field indicates how the bin is used. One example is inspection. It is used in this field for processing efficiencies.AP125, AP126, AP131, AP20.1, AP20.2, AP20.3, AP20.4, AP20.5 +52 more (list truncated in source)
SDT-ALLOC-QTY
ALLOC_QTY		Signed 13.4The field contains the allocated quantity for this detail record. This field is maintained by the Warehouse system.AP125, AP126, AP131, AP20.1, AP20.2, AP20.3, AP20.4, AP20.5 +52 more (list truncated in source)
SDT-HOLD-QTY
HOLD_QTY		Signed 13.4The field contains the quantity put on hold for inspection. This field is maintained by the Purchase Order system.AP125, AP126, AP131, AP20.1, AP20.2, AP20.3, AP20.4, AP20.5 +52 more (list truncated in source)
SDT-FREEZE-FL
FREEZE_FL		Alpha 1This field indicates this record has been selected to be counted in the physical inventory process.
  • N No
  • Y Yes
IC170, IC175, IC179, IC73.1, IC820
SDT-FREEZE-DT
FREEZE_DT		Numeric 8 (yyyymmdd)The field contains the date when this record was last selected for physical inventory counting.IC170, IC820
SDT-AVAIL-QTY
AVAIL_QTY		DerivedThe field contains the detail available quantity. This field is calculated by the system.—
SDT-CWT-AVAIL-QTY
CWT_AVAIL_QTY		DerivedThe field contains the available quantity if this item is a catch weight item. This field is calculated by the system.—
SDT-AVAILABLE-QTY
AVAILABLE_QTY		DerivedThis 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.—

Indexes (4)

Keys marked * are descending. Every documented Lawson index is unique unless flagged Duplicates; Subset indexes carry a Where condition.

IndexKeysFlagsConditionUsed in
SDTSET1COMPANY, LOCATION, ITEM, UOM, LOT, SUBLOT, BINPrimaryAP125, AP126, AP131, AP20.1, AP20.2, AP20.3, AP20.4, AP20.5 +22 more (list truncated in source)
SDTSET2COMPANY, LOCATION, BIN, ITEM, UOM, LOT, SUBLOTIC15.2, IC170, IC41.1, IC51.1, IC598
SDTSET3COMPANY, LOCATION, ITEM, BIN, UOM, LOT, SUBLOTAP125, AP126, AP131, AP20.1, AP20.2, AP20.3, AP20.4, AP20.5 +22 more (list truncated in source)
SDTSET4COMPANY, LOCATION, BIN-TYPE, ITEM, BIN, UOM, LOT, SUBLOTSubsetWhere BIN-TYPE != SpacesIC01.3, IC43.1

Relations

One to one (6) — lookups and parents

RelationTableRulesConditionField map
CompanyICCOMPANYRequiredSDT-COMPANY → ICC-COMPANY
IcbinICBINRequiredWhen SDT-BIN != SpacesSDT-COMPANY → ICB-COMPANY, SDT-LOCATION → ICB-LOCATION, SDT-BIN → ICB-BIN
IclotICLOTNot RequiredSDT-COMPANY → ILT-COMPANY, SDT-LOCATION → ILT-LOCATION, SDT-ITEM → ILT-ITEM, SDT-LOT → ILT-LOT
ItemITEMMASTRequiredICC-ITEM-GROUP → ITE-ITEM-GROUP, SDT-ITEM → ITE-ITEM
ItemlocITEMLOCRequiredSDT-COMPANY → ITL-COMPANY, SDT-LOCATION → ITL-LOCATION, SDT-ITEM → ITL-ITEM
LocationICLOCATIONRequiredSDT-COMPANY → ICL-COMPANY, SDT-LOCATION → ICL-LOCATION

Programs

Updated by (248)

Referenced by (19)