View: Posting Journal Entry Optional Fields

RotoID: AP0514
Table: APPJHO
Protocol: Flat
DLL:APPJHO

Keys: 2

Title Fields

Type/Post. Seq./Batch/Entry/Fiel TYPEBTCHPOSTSEQNCECNTBTCHCNTITEMOPTFIELD
Field/Type/Post. Seq./Batch/Entr OPTFIELDTYPEBTCHPOSTSEQNCECNTBTCHCNTITEM

Fields: 21

Field Index Type Title Attributes Presentation

TYPEBTCH 1 String*2 Batch Type E A K R  Mask: %-2N
POSTSEQNCE 2 BCD*5.0 Posting Sequence No. E A K R 
CNTBTCH 3 BCD*5.0 Batch No. E A K R 
CNTITEM 4 BCD*4.0 Entry No. E A K R 
OPTFIELD 5 String*12 Optional Field E A K R  Mask: %-12N
VALUE 6 String*60 Value E A P 
TYPE 7 Integer Type E A  List:7 entries
1 = Text
100 = Amount
6 = Number
8 = Integer
9 = Yes/No
3 = Date
4 = Time
LENGTH 8 Integer Length E A 
DECIMALS 9 Integer Decimals E A 
ALLOWNULL 10 Boolean Allow Blank E A  List:2 entries
0 = No
1 = Yes
VALIDATE 11 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 
VALIFMONEY 22 BCD*10.3 Amount 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