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.
UPDATED BY
| 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. |
|
| NAME | KEY FIELDS | DESCRIPTION / SUBSET CONDITION | USED IN | |||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| SDTSET1 |
COMPANY LOCATION ITEM UOM LOT SUBLOT BIN |
|
||||||||||||||
| SDTSET2 |
COMPANY LOCATION BIN ITEM UOM LOT SUBLOT |
|
||||||||||||||
| SDTSET3 |
COMPANY LOCATION ITEM BIN UOM LOT SUBLOT |
|
||||||||||||||
| SDTSET4 |
COMPANY LOCATION BIN-TYPE ITEM BIN UOM LOT SUBLOT |
|
||||||||||||||
| RELATION NAME |
RELATED FILE | INTEGRITY RULES / FIELD MATCH | |||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| Company | ICCOMPANY |
Required
| |||||||||||||||
| Icbin | ICBIN |
Required
| |||||||||||||||
| Iclot | ICLOT |
Not Required
| |||||||||||||||
| Item | ITEMMAST |
Required
| |||||||||||||||
| Itemloc | ITEMLOC |
Required
| |||||||||||||||
| Location | ICLOCATION |
Required
|
All trademarks and registered trademarks are the property of their
respective owners.