 |
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 IC598
IC138 IC237 IC238 IC01.3 IC43.1
UPDATED BY
AP125 AP126 AP131 AP25.1 AP25.2 AP26.1
AP27.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 IC500 IC73.1 IC820
IC90.1 MA180 MA43.9 MA530 MA531 MA60.2
MA60.3 MA60.5 MA61.1 MA66.3 MA67.1 MA67.2
MA70.1 MAI1.1 PO100 PO101 PO122 PO131
PO20.1 PO21.2 PO21.3 PO21.4 PO21.5 PO22.1
PO23.1 PO29.1 PO30.1 PO30.2 PO30.3 PO300
PO31.1 PO31.2 PO32.2 PO33.1 PO34.1 PO35.1
PO38.1 PO39.1 PO39.2 PO44.1 PO50.1 PO52.1
PO520 POI3.1 POIE.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
FIELD NAME DESCRIPTION/VALID VALUES UPDATED BY
SDT-COMPANY Numeric 4 AP125 AP126
Company The company number represents an AP131 AP25.1
established company and is entered on AP25.2 AP26.1
all function codes. AP27.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 IC500
IC820 IC90.1
MA180 MA43.9
MA530 MA531
MA60.2 MA60.3
MA60.5 MA61.1
MA66.3 MA67.1
MA67.2 MA70.1
MAI1.1 PO100
PO101 PO122
PO131 PO20.1
PO21.2 PO21.3
PO21.4 PO21.5
PO22.1 PO23.1
PO29.1 PO30.1
PO30.2 PO30.3
PO300 PO31.1
PO31.2 PO32.2
...
SDT-LOCATION Alpha 5 AP125 AP126
Location Code This field contains a valid stocking AP131 AP25.1
location within the company inventory. AP25.2 AP26.1
AP27.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 IC500
IC820 IC90.1
MA180 MA43.9
MA530 MA531
MA60.2 MA60.3
MA60.5 MA61.1
MA66.3 MA67.1
MA67.2 MA70.1
MAI1.1 PO100
PO101 PO122
PO131 PO20.1
PO21.2 PO21.3
PO21.4 PO21.5
PO22.1 PO23.1
PO29.1 PO30.1
PO30.2 PO30.3
PO300 PO31.1
PO31.2 PO32.2
...
SDT-ITEM Alpha 32 AP125 AP126
Item Number This field contains the item AP131 AP25.1
identifier. AP25.2 AP26.1
AP27.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 IC500
IC820 IC90.1
MA180 MA43.9
MA530 MA531
MA60.2 MA60.3
MA60.5 MA61.1
MA66.3 MA67.1
MA67.2 MA70.1
MAI1.1 PO100
PO101 PO122
PO131 PO20.1
PO21.2 PO21.3
PO21.4 PO21.5
PO22.1 PO23.1
PO29.1 PO30.1
PO30.2 PO30.3
PO300 PO31.1
PO31.2 PO32.2
...
SDT-UOM Alpha 4 AP125 AP126
Unit of Measure This field contains a valid tracking AP131 AP25.1
unit of measure for this item. This AP25.2 AP26.1
field indicates there is stock-on-hand AP27.1 IC10.2
quantity for this item at this detail IC11.1 IC12.1
level. 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 IC500
IC820 IC90.1
MA180 MA43.9
MA530 MA531
MA60.2 MA60.3
MA60.5 MA61.1
MA66.3 MA67.1
MA67.2 MA70.1
MAI1.1 PO100
PO101 PO122
PO131 PO20.1
PO21.2 PO21.3
PO21.4 PO21.5
PO22.1 PO23.1
PO29.1 PO30.1
PO30.2 PO30.3
PO300 PO31.1
PO31.2 PO32.2
...
SDT-LOT Alpha 10 AP125 AP126
Lot Number This field contains the identifier for AP131 AP25.1
a homogeneous quantity of material. AP25.2 AP26.1
AP27.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 IC500
IC820 IC90.1
MA180 MA43.9
MA530 MA531
MA60.2 MA60.3
MA60.5 MA61.1
MA66.3 MA67.1
MA67.2 MA70.1
MAI1.1 PO100
PO101 PO122
PO131 PO20.1
PO21.2 PO21.3
PO21.4 PO21.5
PO22.1 PO23.1
PO29.1 PO30.1
PO30.2 PO30.3
PO300 PO31.1
PO31.2 PO32.2
...
SDT-SUBLOT Alpha 6 AP125 AP126
Sublot Number This field contains the identifier for AP131 AP25.1
a detail breakdown of a lot number. AP25.2 AP26.1
AP27.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 IC500
IC820 IC90.1
MA180 MA43.9
MA530 MA531
MA60.2 MA60.3
MA60.5 MA61.1
MA66.3 MA67.1
MA67.2 MA70.1
MAI1.1 PO100
PO101 PO122
PO131 PO20.1
PO21.2 PO21.3
PO21.4 PO21.5
PO22.1 PO23.1
PO29.1 PO30.1
PO30.2 PO30.3
PO300 PO31.1
PO31.2 PO32.2
...
SDT-BIN Alpha 7 AP125 AP126
Bin This field contains a storage area for AP131 AP25.1
an item or any number of items. AP25.2 AP26.1
AP27.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 IC500
IC820 IC90.1
MA180 MA43.9
MA530 MA531
MA60.2 MA60.3
MA60.5 MA61.1
MA66.3 MA67.1
MA67.2 MA70.1
MAI1.1 PO100
PO101 PO122
PO131 PO20.1
PO21.2 PO21.3
PO21.4 PO21.5
PO22.1 PO23.1
PO29.1 PO30.1
PO30.2 PO30.3
PO300 PO31.1
PO31.2 PO32.2
...
SDT-SOH-QTY Signed 13.4 AP125 AP126
Stock On Hand This field indicates the quantity AP131 AP25.1
Quantity currently on hand in inventory for this AP25.2 AP26.1
bin, unit of measure, and lot/sublot AP27.1 IC10.2
combination. 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 IC42.1
IC42.2 IC500
IC820 IC90.1
MA180 MA43.9
MA530 MA531
MA60.2 MA60.3
MA60.5 MA61.1
MA66.3 MA67.1
MA67.2 MA70.1
MAI1.1 PO100
PO101 PO122
PO131 PO20.1
PO21.2 PO21.3
PO21.4 PO21.5
PO22.1 PO23.1
PO29.1 PO30.1
PO30.2 PO30.3
PO300 PO31.1
...
SDT-SECONDARY-QTY Signed 13.4 AP125 AP126
Secondary Quantity This field contains the secondary AP131 AP25.1
quantity, which is tracked if the item AP25.2 AP26.1
is a catch weight item. This quantity AP27.1 IC10.2
is a memo quantity only. It is not used IC12.1 IC175
for valuation. 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
IC500 IC820
IC90.1 MA180
MA43.9 MA530
MA531 MA60.2
MA60.3 MA60.5
MA61.1 MA66.3
MA67.1 MA67.2
MA70.1 MAI1.1
PO100 PO101
PO122 PO131
PO20.1 PO21.2
PO21.3 PO21.4
PO21.5 PO22.1
PO23.1 PO29.1
PO30.1 PO30.2
PO30.3 PO300
PO31.1 PO31.2
PO32.2 PO33.1
...
SDT-BIN-TYPE Alpha 1 AP125 AP126
Bin Usage Type This field indicates how the bin is AP131 AP25.1
used. One example is inspection. It is AP25.2 AP26.1
used in this field for processing AP27.1 IC10.2
efficiencies. 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
IC500 IC820
IC90.1 MA180
MA43.9 MA530
MA531 MA60.2
MA60.3 MA60.5
MA61.1 MA66.3
MA67.1 MA67.2
MA70.1 MAI1.1
PO100 PO101
PO122 PO131
PO20.1 PO21.2
PO21.3 PO21.4
PO21.5 PO22.1
PO23.1 PO29.1
PO30.1 PO30.2
PO30.3 PO300
PO31.1 PO31.2
PO32.2 PO33.1
...
SDT-ALLOC-QTY Signed 13.4 AP125 AP126
Allocated Quantity The field contains the allocated AP131 AP25.1
quantity for this detail record. This AP25.2 AP26.1
field is maintained by the Warehouse AP27.1 IC10.2
system. 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 IC42.1
IC42.2 IC500
IC90.1 MA180
MA43.9 MA530
MA531 MA60.2
MA60.3 MA60.5
MA61.1 MA66.3
MA67.1 MA67.2
MA70.1 MAI1.1
PO100 PO101
PO122 PO131
PO20.1 PO21.2
PO21.3 PO21.4
PO21.5 PO22.1
PO23.1 PO29.1
PO30.1 PO30.2
PO30.3 PO300
PO31.1 PO31.2
...
SDT-HOLD-QTY Signed 13.4 AP125 AP126
Hold Quantity The field contains the quantity put on AP131 AP25.1
hold for inspection. This field is AP25.2 AP26.1
maintained by the Purchase Order system. AP27.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 IC42.1
IC42.2 IC500
IC90.1 MA180
MA43.9 MA530
MA531 MA60.2
MA60.3 MA60.5
MA61.1 MA66.3
MA67.1 MA67.2
MA70.1 MAI1.1
PO100 PO101
PO122 PO131
PO20.1 PO21.2
PO21.3 PO21.4
PO21.5 PO22.1
PO23.1 PO29.1
PO30.1 PO30.2
PO30.3 PO300
PO31.1 PO31.2
...
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 AP125 AP126
LOCATION AP131 AP25.1
ITEM AP25.2 AP26.1
UOM AP27.1 IC10.2
LOT IC11.1 IC12.1
SUBLOT IC170 IC175
BIN IC20.1 IC20.2
IC21.1 IC21.2
IC22.1 IC22.2
IC23.1 IC23.2
IC230 IC24.1
IC24.2 IC25.1
IC26.1 IC26.2
IC28.1 IC29.1
IC300 IC42.2
...
SDTSET2 COMPANY IC15.2 IC170
LOCATION IC41.1 IC500
BIN IC51.1 IC598
ITEM
UOM
LOT
SUBLOT
SDTSET3 COMPANY AP125 AP126
LOCATION AP131 AP25.1
ITEM AP25.2 AP26.1
BIN AP27.1 IC138
UOM IC170 IC175
LOT IC179 IC20.1
SUBLOT IC20.2 IC21.1
IC21.2 IC22.1
IC22.2 IC23.1
IC23.2 IC237
IC238 IC24.1
IC24.2 IC25.1
IC28.1 IC42.1
IC42.4 IC500
IC574 IC73.1
...
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
|