# View: Open Doc. Detail Optional Fields

RotoID: AP0515
Table: APOBLJO
Protocol: Flat
DLL: APOBLJO

## Compositions: 0

## Keys: 2

Title | Fields
--- | ---
Vend. No./Doc. No./Line No./Fiel | IDVEND, IDINVC, CNTLINE, OPTFIELD
Field/Vend. No./Doc. No./Line No | OPTFIELD, IDVEND, IDINVC, CNTLINE

## Fields: 20

Field | Index | Type | Title | Attributes | Presentation
--- | --- | --- | --- | --- | ---
IDVEND | 1 | String*12 | Vendor Number | E A K R | Mask: %-12C
IDINVC | 2 | String*22 | Document Number | E A K R | Mask: %-22C
CNTLINE | 3 | BCD*3.0 | Line Number | E A K R |
OPTFIELD | 4 | String*12 | Optional Field | E A K R | Mask: %-12N
VALUE | 5 | String*60 | Value | E A P | Mask: %-60c
TYPE | 6 | Integer | Type | E A | List: 7 entries
1 | = | Text
100 | = | Amount
6 | = | Number
8 | = | Integer
9 | = | Yes/No
3 | = | Date
4 | = | Time
LENGTH | 7 | Integer | Length | E A |
DECIMALS | 8 | Integer | Decimals | E A |
ALLOWNULL | 9 | Boolean | Allow Blank | E A | List: 2 entries
0 | = | No
1 | = | Yes
VALIDATE | 10 | Boolean | Validate | E A | List: 2 entries
0 | = | No
1 | = | Yes
VALINDEX | 20 | Long | Typed Value Field Index | E A C |
VALIFTEXT | 21 | String*60 | Text Value | E A C P | Mask: %-60c
VALIFMONEY | 22 | BCD*10.3 | Money Value | E A C |
VALIFNUM | 23 | BCD*10.0 | Number Value | E A C T |
VALIFLONG | 24 | Long | Integer Value | E A C |
VALIFBOOL | 25 | Boolean | Yes/No Value | E A C | List: 2 entries
0 | = | No
1 | = | Yes
VALIFDATE | 26 | Date | Date Value | E A C |
VALIFTIME | 27 | Time | 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.