SOHDETAIL FILE
Stock On Hand Detail 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 IC300 IC42.2 IC42.1 IC42.4 IC574
IC74.1 PO32.2 PO39.1 IC15.2 IC41.1 IC51.1
IC138 IC237 IC238 IC01.3 IC43.1
UPDATED BY
BL92.1 CX100 CX20.1 CX20.2 CX20.4 CX20.5
CX220 CX30.1 CX300 CX506 CXCP.1 DR100
IC10.2 IC11.1 IC116 IC12.1 IC141 IC142
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 IC83.1 IC90.1 OE10.1 OE10.2 OE10.3
OE10.4 OE10.5 OE10.6 OE10.7 OE10.8 OE11.1
OE11.4 OE11.8 OE11.9 OE110 OE113 OE114
OE129 OE14.4 OE15.1 OE15.2 OE15.3 OE15.4
OE15.5 OE15.7 OE30.1 OE30.2 OE30.3 OE30.4
OE30.5 OE30.6 OE30.7 OE30.9 OE510 OE810
OE830 OE90.1 OE920 OE950 PO30.1 PO31.1
PO33.1 PO34.1 PO35.1 PO530 RQ10.1 RQ10.3
RQ11.1 RQ12.1 RQ13.1 RQ20.1 RQ35.1 RQ500
RQ961 WH130 WH132 WH190 WH20.1 WH20.2
WH20.3 WH20.4 WH20.5 WH20.6 WH20.7 WH222
WH30.1 WH30.2 WH30.3 WH31.1 WH31.2 WH31.3
WH32.1 WH32.2 WH32.3 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 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 WOEX.1 WOSP.1
FIELD NAME DESCRIPTION/VALID VALUES UPDATED BY
SDT-COMPANY Numeric 4 BL92.1 CX100
Company The company number represents an CX20.1 CX20.2
established company and is entered on CX20.4 CX20.5
all function codes. CX220 CX30.1
CX300 CX506
CXCP.1 DR100
IC10.2 IC11.1
IC116 IC12.1
IC141 IC142
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
IC500 IC820
IC83.1 IC90.1
OE10.1 OE10.2
OE10.3 OE10.4
OE10.5 OE10.6
OE10.7 OE10.8
OE11.1 OE11.4
OE11.8 OE11.9
OE110 OE113
OE114 OE129
OE14.4 OE15.1
OE15.2 OE15.3
OE15.4 OE15.5
OE15.7 OE30.1
...
SDT-LOCATION Alpha 5 BL92.1 CX100
Location Code This field contains a valid stock CX20.1 CX20.2
location with the company inventory. CX20.4 CX20.5
CX220 CX30.1
CX300 CX506
CXCP.1 DR100
IC10.2 IC11.1
IC116 IC12.1
IC141 IC142
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
IC500 IC820
IC83.1 IC90.1
OE10.1 OE10.2
OE10.3 OE10.4
OE10.5 OE10.6
OE10.7 OE10.8
OE11.1 OE11.4
OE11.8 OE11.9
OE110 OE113
OE114 OE129
OE14.4 OE15.1
OE15.2 OE15.3
OE15.4 OE15.5
OE15.7 OE30.1
...
SDT-ITEM Alpha 32 BL92.1 CX100
Item Number This field contains the item CX20.1 CX20.2
identifier. CX20.4 CX20.5
CX220 CX30.1
CX300 CX506
CXCP.1 DR100
IC10.2 IC11.1
IC116 IC12.1
IC141 IC142
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
IC500 IC820
IC83.1 IC90.1
OE10.1 OE10.2
OE10.3 OE10.4
OE10.5 OE10.6
OE10.7 OE10.8
OE11.1 OE11.4
OE11.8 OE11.9
OE110 OE113
OE114 OE129
OE14.4 OE15.1
OE15.2 OE15.3
OE15.4 OE15.5
OE15.7 OE30.1
...
SDT-UOM Alpha 4 BL92.1 CX100
Unit of Measure This field contains a valid tracking CX20.1 CX20.2
unit of measure for this item. This CX20.4 CX20.5
field indicates there is stock-on-hand CX220 CX30.1
quantity for this item at this detail CX300 CX506
level. CXCP.1 DR100
IC10.2 IC11.1
IC116 IC12.1
IC141 IC142
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
IC500 IC820
IC83.1 IC90.1
OE10.1 OE10.2
OE10.3 OE10.4
OE10.5 OE10.6
OE10.7 OE10.8
OE11.1 OE11.4
OE11.8 OE11.9
OE110 OE113
OE114 OE129
OE14.4 OE15.1
OE15.2 OE15.3
OE15.4 OE15.5
OE15.7 OE30.1
...
SDT-LOT Alpha 10 BL92.1 CX100
Lot Number This field contains the identifier for CX20.1 CX20.2
a homogeneous quantity of material. CX20.4 CX20.5
CX220 CX30.1
CX300 CX506
CXCP.1 DR100
IC10.2 IC11.1
IC116 IC12.1
IC141 IC142
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
IC500 IC820
IC83.1 IC90.1
OE10.1 OE10.2
OE10.3 OE10.4
OE10.5 OE10.6
OE10.7 OE10.8
OE11.1 OE11.4
OE11.8 OE11.9
OE110 OE113
OE114 OE129
OE14.4 OE15.1
OE15.2 OE15.3
OE15.4 OE15.5
OE15.7 OE30.1
...
SDT-SUBLOT Alpha 6 BL92.1 CX100
Sublot Number This field contains the identifier for CX20.1 CX20.2
a detail breakdown of a lot number. CX20.4 CX20.5
CX220 CX30.1
CX300 CX506
CXCP.1 DR100
IC10.2 IC11.1
IC116 IC12.1
IC141 IC142
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
IC500 IC820
IC83.1 IC90.1
OE10.1 OE10.2
OE10.3 OE10.4
OE10.5 OE10.6
OE10.7 OE10.8
OE11.1 OE11.4
OE11.8 OE11.9
OE110 OE113
OE114 OE129
OE14.4 OE15.1
OE15.2 OE15.3
OE15.4 OE15.5
OE15.7 OE30.1
...
SDT-BIN Alpha 7 BL92.1 CX100
Bin This field contains a storage area for CX20.1 CX20.2
an item or any number of items. CX20.4 CX20.5
CX220 CX30.1
CX300 CX506
CXCP.1 DR100
IC10.2 IC11.1
IC116 IC12.1
IC141 IC142
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
IC500 IC820
IC83.1 IC90.1
OE10.1 OE10.2
OE10.3 OE10.4
OE10.5 OE10.6
OE10.7 OE10.8
OE11.1 OE11.4
OE11.8 OE11.9
OE110 OE113
OE114 OE129
OE14.4 OE15.1
OE15.2 OE15.3
OE15.4 OE15.5
OE15.7 OE30.1
...
SDT-SOH-QTY Signed 13.4 BL92.1 CX100
Stock On Hand This field indicates the quantity CX20.1 CX20.2
Quantity currently on hand in inventory for this CX20.4 CX20.5
bin, unit of measure, and lot/sublot CX220 CX30.1
combination. CX300 CX506
CXCP.1 DR100
IC10.2 IC11.1
IC116 IC12.1
IC141 IC142
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
IC42.1 IC42.2
IC500 IC820
IC83.1 IC90.1
OE10.1 OE10.2
OE10.3 OE10.4
OE10.5 OE10.6
OE10.7 OE10.8
OE11.1 OE11.4
OE11.8 OE11.9
OE110 OE113
OE114 OE129
OE14.4 OE15.1
OE15.2 OE15.3
OE15.4 OE15.5
...
SDT-SECONDARY-QTY Signed 13.4 BL92.1 CX100
Secondary Quantity This field contains the secondary CX20.1 CX20.2
quantity, which is tracked if the item CX20.4 CX20.5
is a catch weight item. This quantity is CX220 CX30.1
a memo quantity only. It is not used for CX300 CX506
valuation. CXCP.1 DR100
IC10.2 IC116
IC12.1 IC141
IC142 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 IC500
IC820 IC83.1
IC90.1 OE10.1
OE10.2 OE10.3
OE10.4 OE10.5
OE10.6 OE10.7
OE10.8 OE11.1
OE11.4 OE11.8
OE11.9 OE110
OE113 OE114
OE129 OE14.4
OE15.1 OE15.2
OE15.3 OE15.4
OE15.5 OE15.7
OE30.1 OE30.2
...
SDT-BIN-TYPE Alpha 1 BL92.1 CX100
Bin Usage Type This field indicates how the bin is CX20.1 CX20.2
used. One example is inspection. It is CX20.4 CX20.5
used in this field for processing CX220 CX30.1
efficiencies. CX300 CX506
CXCP.1 DR100
IC10.2 IC116
IC12.1 IC141
IC142 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 IC500
IC820 IC83.1
IC90.1 OE10.1
OE10.2 OE10.3
OE10.4 OE10.5
OE10.6 OE10.7
OE10.8 OE11.1
OE11.4 OE11.8
OE11.9 OE110
OE113 OE114
OE129 OE14.4
OE15.1 OE15.2
OE15.3 OE15.4
OE15.5 OE15.7
OE30.1 OE30.2
...
SDT-ALLOC-QTY Signed 13.4 BL92.1 CX100
Allocated Quantity The field contains the allocated CX20.1 CX20.2
quantity for this detail record. This CX20.4 CX20.5
field is maintained by the Warehouse CX220 CX30.1
system. CX300 CX506
CXCP.1 DR100
IC10.2 IC11.1
IC116 IC12.1
IC141 IC142
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
IC42.1 IC42.2
IC500 IC83.1
IC90.1 OE10.1
OE10.2 OE10.3
OE10.4 OE10.5
OE10.6 OE10.7
OE10.8 OE11.1
OE11.4 OE11.8
OE11.9 OE110
OE113 OE114
OE129 OE14.4
OE15.1 OE15.2
OE15.3 OE15.4
OE15.5 OE15.7
...
SDT-HOLD-QTY Signed 13.4 BL92.1 CX100
Hold Quantity The field contains the quantity put on CX20.1 CX20.2
hold for inspection. This field is CX20.4 CX20.5
maintained by the Purchase Order system. CX220 CX30.1
CX300 CX506
CXCP.1 DR100
IC10.2 IC11.1
IC116 IC12.1
IC141 IC142
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
IC42.1 IC42.2
IC500 IC83.1
IC90.1 OE10.1
OE10.2 OE10.3
OE10.4 OE10.5
OE10.6 OE10.7
OE10.8 OE11.1
OE11.4 OE11.8
OE11.9 OE110
OE113 OE114
OE129 OE14.4
OE15.1 OE15.2
OE15.3 OE15.4
OE15.5 OE15.7
...
SDT-POTENCY Signed 7.3
Potency Factor This field is not used by the Inventory
Control system.
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 BL92.1 CX100
LOCATION CX20.1 CX20.2
ITEM CX20.4 CX20.5
UOM CX220 CX30.1
LOT CX300 CX506
SUBLOT CXCP.1 DR100
BIN IC10.2 IC11.1
IC116 IC12.1
IC141 IC142
IC170 IC175
IC20.1 IC20.2
IC21.1 IC21.2
IC22.1 IC22.2
IC23.1 IC23.2
IC230 IC24.1
...
SDTSET2 COMPANY IC15.2 IC170
LOCATION IC41.1 IC51.1
BIN
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
OE114 PO31.1
PO32.2 WH130
WH20.3 WH20.4
...
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
|