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.
| FIELD NAME |
DESCRIPTION/VALID VALUES |
UPDATED BY |
SDT-COMPANY
Element: Company | Numeric 4
Identifies 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.
|
|
SDT-LOCATION
Element: Location | Alpha 5
This field contains a valid stocking
location within the company inventory.
|
|
SDT-ITEM
Element: Item | Alpha 32
This field contains the item
identifier.
|
|
SDT-UOM
Element: Uom | Alpha 4
This 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.
|
|
SDT-LOT
Element: Lot | Alpha 10
This field contains the identifier for
a homogeneous quantity of material.
|
|
SDT-SUBLOT
Element: Sublot | Alpha 6
This field contains the identifier for
a detail breakdown of a lot number.
|
|
SDT-BIN
Element: Bin | Alpha 7
This field contains a storage area for
an item or any number of items.
|
|
SDT-SOH-QTY
Element: Quantity | Signed 13.4
This field indicates the quantity
currently on hand in inventory for this
bin, unit of measure, and lot/sublot
combination.
|
|
SDT-SECONDARY-QTY
Element: Secondary Qty | Signed 13.4
This 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.
|
|
SDT-BIN-TYPE
Element: Bin Type | Alpha 1
This field indicates how the bin is
used. One example is inspection. It is
used in this field for processing
efficiencies.
|
|
SDT-ALLOC-QTY
Element: Quantity | Signed 13.4
The field contains the allocated
quantity for this detail record. This
field is maintained by the Warehouse
system.
|
|
SDT-HOLD-QTY
Element: Quantity | Signed 13.4
The field contains the quantity put on
hold for inspection. This field is
maintained by the Purchase Order system.
|
|
SDT-FREEZE-FL
Element: All Flag | Alpha 1
This field indicates this record has
been selected to be counted in the
physical inventory process.
N = No
Y = Yes |
|
SDT-FREEZE-DT
Element: Freeze Dt | Numeric 8 (yyyymmdd)
The field contains the date when this
record was last selected for physical
inventory counting.
|
|
SDT-AVAIL-QTY
Element: Avail Qty | Derived
The field contains the detail available
quantity. This field is calculated by
the system.
|
|
SDT-CWT-AVAIL-QTY
Element: Cwt Avail Qty | Derived
The field contains the available
quantity if this item is a catch weight
item. This field is calculated by the
system.
|
|
SDT-AVAILABLE-QTY
Element: Available Qty | Derived
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.
|
|
