[Feature] Enable suppression of `numeric` precision/scale warning for model contracts

### Is this a new bug in dbt-core?

- [x] I believe this is a new bug in dbt-core
- [x] I have searched the existing issues, and I could not find an existing issue for this bug

### Current Behavior

This warning is not suppressible.

`Compilation Error in model reference__codes__country_code ()
Detected columns with numeric type and unspecified precision/scale, this can lead to unintended rounding`

### Expected Behavior

The warning would be defined in types.py and suppressible.

### Steps To Reproduce

1. Create contract and specify numeric column.
2. Set project to error on warn
3. Have to revert #⁠2 b/c you cannot suppress the warning.

### Relevant log output

```
Compilation Error in model reference__codes__country_code ()
Detected columns with numeric type and unspecified precision/scale, this can lead to unintended rounding
```

### Environment

```markdown
Dbt cloud
```

### Which database adapter are you using with dbt?

snowflake

### Additional Context

_No response_