Lawson Insight Technical Documentation |
|
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
|