# `Fun_MoneyToCh` (function)


- **Type:** FUNCTION
- **Returns:** `varchar(150)`
- **Deterministic:** NO
- **SQL data access:** CONTAINS SQL

## Parameters

| # | Mode | Name | Type |
|---|---|---|---|
| 1 | IN | `MONEY` | `decimal(14,6)` |

## Body

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

## Narrative

**Business context:** Converts a numeric currency amount into its formal Chinese capitalized form (大写金额, e.g. `123.45` → `壹佰贰拾叁元肆角伍分`) — the format required on Chinese invoices, receipts, and finance bills.

**What it does:** Splits the amount into integer and two decimal places, then walks up to twelve integer positions plus jiao/fen, mapping digits to `零壹贰叁肆伍陆柒捌玖` and place markers to `元/拾/佰/仟/万/亿/角/分`. Suppresses redundant zeros and emits `整` when there is no fractional part.

**Invocation:** Status: appears orphaned. No form-master, gdsmodule, other-routine, or Java caller references this name (the matching `xly-src/script/标版/30000101/Fun_MoneyToCh.sql` is the definition itself). Candidate for maintainer audit — likely a leftover from an older finance-print template.