Sage 50 UK FUND Columns
| Name | Type | Length | Precision | Notes | Example |
|---|---|---|---|---|---|
| FUND_ID | INTEGER | 4 | 10 | Fund ID | |
| FUND_TYPE_ID | INTEGER | 4 | 10 | Fund Type ID | |
| DESCRIPTION | VARCHAR | 63 | 63 | Fund Description | |
| CONTACT_NAME | VARCHAR | 30 | 30 | Contact | |
| HELD_BY | VARCHAR | 62 | 62 | Held By | |
| ACCOUNT_REF | VARCHAR | 8 | 8 | Nominal Code | |
| BALANCE | DOUBLE | 8 | 15 | Balance | |
| OPENING_BALANCE | DOUBLE | 8 | 15 | Opening Balance | |
| RECORD_CREATE_DATE | 16 | 0 | Date and time when the record was created. | ||
| RECORD_MODIFY_DATE | 16 | 0 | Date and time when the record was modified. | ||
| RECORD_DELETED | SMALLINT | 2 | 5 | Flag denoting if the record has been deleted or not. |