New-DbaDbMaskingConfig.ps1 does not support numeric data type

[JosiahSiegel]

Verified issue does not already exist?

I have searched and found no existing issue

What error did you receive?

Columns with datetype "numeric" are not supported by New-DbaDbMaskingConfig.ps1, but "numeric" is a synonym for "decimal"

Source Code

Steps to Reproduce

$piiscan = Invoke-DbaDbPiiScan -SqlInstance $server -Database TESTDB -Table TESTTABLE -Column <<numeric column>>
New-DbaDbMaskingConfig -SqlInstance $server -Table TESTTABLE -Column <<numeric column>> -Path D:\dbatoolsMask -InputObject $piiscan

Please confirm that you are running the most recent version of dbatools

2.1.24

Other details or mentions

No response

What PowerShell host was used when producing this error

VS Code (terminal)

PowerShell Host Version

Name Value

---

PSVersion 5.1.22621.4111
PSEdition Desktop
PSCompatibleVersions {1.0, 2.0, 3.0, 4.0...}
BuildVersion 10.0.22621.4111
CLRVersion 4.0.30319.42000
WSManStackVersion 3.0
PSRemotingProtocolVersion 2.3
SerializationVersion 1.1.0.1

SQL Server Edition and Build number

Microsoft SQL Azure (RTM) - 12.0.2000.8

.NET Framework Version

.NET Framework 4.8.9261.0