# View: Account Trans. Optional Fields

RotoID: GL0408
Table: GLWAMTO
Protocol: Detail, Ordered revisions
DLL: GLWAMTO

## Compositions: 1

RotoID | Tables | Title | DLL
--- | --- | --- | ---
GL0046 | GLWAMF | Preview Accounts | GLWAMF

## Keys: 2

Title | Fields
--- | ---
Account/Optional Field | ACCTID, OPTFIELD
Optional Field/Account | OPTFIELD, ACCTID

## Fields: 21

Field | Index | Type | Title | Attributes | Presentation
--- | --- | --- | --- | --- | ---
ACCTID | 1 | String*45 | Unformatted Account | E A K R | Mask: %-45C
OPTFIELD | 2 | String*12 | Optional Field | E A K R | Mask: %-12N
DEFVAL | 3 | String*60 | Default Value | E A P | Mask: %-60c
TYPE | 4 | Integer | Type | E A C | List: 7 entries
1 | = | Text
100 | = | Amount
6 | = | Number
8 | = | Integer
9 | = | Yes/No
3 | = | Date
4 | = | Time
LENGTH | 5 | Integer | Length | E A C |
DECIMALS | 6 | Integer | Decimals | E A C |
ALLOWNULL | 7 | Boolean | Allow Blank | E A C | List: 2 entries
0 | = | No
1 | = | Yes
VALIDATE | 8 | Boolean | Validate | E A C | List: 2 entries
0 | = | No
1 | = | Yes
INITFLAG | 9 | Integer | Auto Insert | E A | List: 2 entries
0 | = | No
1 | = | Yes
SWREQUIRED | 10 | Integer | Required | E A | List: 2 entries
0 | = | No
1 | = | Yes
SWSET | 11 | Integer | Value Set | E A | List: 2 entries
0 | = | No
1 | = | Yes
DVINDEX | 20 | Long | Typed Default Value Field Index | E A C |
DVIFTEXT | 21 | String*60 | Default Text Value | E A C P | Mask: %-60c
DVIFMONEY | 22 | BCD*10.3 | Default Amount Value | E A C |
DVIFNUM | 23 | BCD*10.0 | Default Number Value | E A C T |
DVIFLONG | 24 | Long | Default Integer Value | E A C |
DVIFBOOL | 25 | Boolean | Default Yes/No Value | E A C | List: 2 entries
0 | = | No
1 | = | Yes
DVIFDATE | 26 | Date | Default Date Value | E A C |
DVIFTIME | 27 | Time | Default Time Value | E A C |
FDESC | 28 | String*60 | Optional Field Description | E A C |
VDESC | 29 | String*60 | Value Description | E A C |

This page was generated on 2008-May-01

Copyright © 2001–2008 Sage Software, Inc. All rights reserved.