| Field | Type | Definition | Comments | Retain on Stroke 2 Equivalent layout |
| > | Navigation | Open SKU Detail form | The detail dropdown | TBC |
| SKU | Numeric | Unique reference identifier for item | Yes | |
| Owner | Text | Owner company for item | Yes | |
| Type | Text | Blank
Garment", "Printed Garment", "Merchandise",
"Peripheral", "Returns", "Bundle", "-", "Consumable", "Stationery", "Embroidery thread", "Purchased Screen Ink", "Mixed Screen Ink", "ink", "Cleaning Supplies", "Maintenance Materials", "-", "Blank Screen", "Printed Screen", "Screen Frame", "-", "General Item", "Support Item", "-", "Digitisation/Subbed Art" |
Can this not be rationalised | TBC |
| Description | Text | Description | Taken from here | Yes |
| Colourway | Text | This is the DSI for | Is this needed if it is in Description | No |
| Locaton | Text | The location reference which holds a balance | Yes | |
| Qty in Location | Numeric | The location balance for the specified location | Yes | |
| Adjust | Button | Allows users to increment or decrement the location balance | Makes sense to have this and embellish with adj reason field to aid auditing - and store as a transaction | Yes |
| Set | Button | Allows users to overwrite(set) the location balance | Query use of this - available balances should really be a result of a transaction. It would be better audit wise if adjustment transaction was used | TBC |
| Expected | Numeric | @sum of Expected qty for SKU | Yes | |
| Available | Numeric | @sum of Available qty for SKU | Yes | |
| Allocated | Numeric | @sum of Allocated qty for SKU | ||
| Storage Charges | Money | ?? Is this the legacy storage charge vale ?? | Is this needed at this level ? | TBC/ No? |
| Total in all locations | Numeric | @sum of All Location balances for SKU | Note a SKU can be in multiple locations, each of which would have a record here | Yes |
| Warehouse Discrepancy | Numeric | =(@sum of SKU Available + @sum of SKU Allocated)-(@sum of SKU warehouse location balances) | At the @sum location balance level, not individual location | Yes |
| Other Location | Button | Invokes a pop up with the other locations that may hold the SKU; and allows for Set / Adjust & set check for other locations | Not bad - but doesn't it make sense to disable/hide when only 1 location ? | Yes |
| Change Location | Button | Invokespop up to allow (picker) or barcode scanner to select destination location and execute move transaction (whole location balance) | Yes | |
| Free Stock | Button | Invokes dialog to specify qty to book to free stock (DR Location; DR Available) | Yes | |
| Last Checked | Date | Populated with last date that SKU location was set as checked | Yes | |
| Select | Button | Allows for multiple records to be selected | Yes | |
| Stock Status | Icon | Denotes the status of the item in the location record | <0>Not Check [Red]</0><1>Part Checked[Amber]</1><2>Checked[Green]</2> | Yes |