Add document for explaining the promotion precision and scale for decimal data type

**Is your feature request related to a problem or challenge? Please describe what you are trying to do.**

part of #122

**Describe the solution you'd like**
A clear and concise description of what you want to happen.

**Describe alternatives you've considered**
A clear and concise description of any alternative solutions or features you've considered.

**Additional context**
Add any other context or screenshots about the feature request here.

Start by reading the related issue #122 and the repository's existing documentation for decimal data types. Define the document's scope around promotion, precision, and scale, then confirm that it clearly explains the expected behavior and terminology.

Written by the indexing model from the issue text.