# `GetMaterialsAuxiliaryQty` (function)


- **Type:** FUNCTION
- **Returns:** `decimal(18,6)`
- **Deterministic:** NO
- **SQL data access:** CONTAINS SQL

## Parameters

| # | Mode | Name | Type |
|---|---|---|---|
| 1 | IN | `iType` | `int` |
| 2 | IN | `p_sMaterialsId` | `varchar(100)` |
| 3 | IN | `p_sMaterialsStyle` | `varchar(100)` |
| 4 | IN | `p_sDefineNo` | `varchar(255)` |
| 5 | IN | `p_sDefineNo2` | `varchar(255)` |
| 6 | IN | `p_sWareHouseId` | `varchar(100)` |
| 7 | IN | `p_sLocationId` | `varchar(100)` |
| 8 | IN | `p_sWareHouseLocationId` | `varchar(100)` |
| 9 | IN | `p_sBrId` | `varchar(100)` |
| 10 | IN | `p_sSuId` | `varchar(100)` |

## Body

_Body is not pre-cached. To inspect: `mysql --defaults-file=~/.my.cnf -e 'SHOW CREATE FUNCTION `GetMaterialsAuxiliaryQty`'`._

## Narrative

_No human-written narrative yet._