# View: Optional Field Values

RotoID: CS0012
Tables: CSOPTFD
DLL: CSOPTFD

## Compositions: 1

RotoID | Title | Tables | DLL
--- | --- | --- | ---
CS0011 | Optional Fields | CSOPTFH | CSOPTFH

## Keys: 2

Title | Fields
--- | ---
Optional Field Value | OPTFIELD, VALUE
Optional Field Sorted Value | OPTFIELD, SORTEDVAL

## Fields: 18

Field | Index | Type | Title | Attributes | Presentation
--- | --- | --- | --- | --- | ---
OPTFIELD | 1 | String*12 | Optional Field | E A K R | Mask: %-12N
VALUE | 2 | String*60 | Value | E A K R |
SORTEDVAL | 3 | String*60 | Sorted Value | E A C |
VDESC | 4 | String*60 | Description | E A |
TYPE | 5 | Integer | Type | E A C | List: 7 entries
1 | = | Text
100 | = | Amount
6 | = | Number
8 | = | Integer
9 | = | Yes/No
3 | = | Date
4 | = | Time
LENGTH | 6 | Integer | Length | E A C |
DECIMALS | 7 | Integer | Decimals | E A C |
ALLOWNULL | 8 | Boolean | Allow Blank | E A C P | List: 2 entries
0 | = | N/A
1 | = | N/A
VALIDATE | 9 | Boolean | Validate | E A C | List: 2 entries
0 | = | No
1 | = | Yes
VALCONVERT | 20 | String*60 | Value String To Convert | E A C |
VALINDEX | 21 | Long | Typed Value Field Index | A C |
VALIFTEXT | 22 | String*60 | Text Value | E A C P X | Mask: %-60c
VALIFMONEY | 23 | BCD*10.3 | Amount Value | A C X |
VALIFNUM | 24 | BCD*10.0 | Number Value | A C T X |
VALIFLONG | 25 | Long | Integer Value | A C X |
VALIFBOOL | 26 | Boolean | Yes/No Value | A C X | List: 2 entries
0 | = | No
1 | = | Yes
VALIFDATE | 27 | Date | Date Value | A C X |
VALIFTIME | 28 | Time | Time Value | A C X |

This page was generated on 2004-Oct-28

Copyright © 2000–2004 ACCPAC International, Inc. All rights reserved.