Ever wonder how many characters fit in those fields in your database? You're not alone! Check out this article for more info.
GLID | 255 |
Aux ID | 200 |
Fund Name | 200 |
Spending Account | 250 |
Fund | 50 |
Program | 50 |
Project | 50 |
Dept. | 50 |
Investment Pool Name | 75 |
Cost | Two decimal places |
Market Value | Two decimal places |
Inception Date | 01/01/2000 format |
Authorized Date | 01/01/2000 format |
Reinvest Threshold | Two decimal places |
Units | Four decimal places |
Book Value | Two decimal places |
Expendable Assets | Two decimal places |
Net Asset Classification | 100 |
Description | 250 |
Campuses | 100 |
Department | 100 |
Purpose/Use | 250 |
Spending rule | 255 |
Secondary Category | 200 |
Purpose Description | No Limit |
Secondary Description | No Limit |
Business Office Notes | No Limit |
User Category 2 | No Limit |
| Notes | No Limit |