View: Recurring Payable Optional Fields

RotoID: AP0405
Table: APRPHO
Protocol: Detail, Ordered revisions
DLL:APRPHO

Compositions: 1

RotoID Tables Title DLL

AP0064 APRPH Recurring Payables APRPH

Keys: 2

Title Fields

Recurring Payable Optional Field IDVENDIDRECURROPTFIELD
Optional Field/Recurring Payable OPTFIELDIDVENDIDRECURR

Fields: 20

Field Index Type Title Attributes Presentation

IDVEND 1 String*12 Vendor Number E A K R  Mask: %-12C
IDRECURR 2 String*16 Recurring Payable Code E A K R  Mask: %-16C
OPTFIELD 3 String*12 Optional Field E A K R  Mask: %-12N
VALUE 4 String*60 Optional Field Value E A P 
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  List:2 entries
0 = No
1 = Yes
VALIDATE 9 Boolean Validate E A C  List:2 entries
0 = No
1 = Yes
SWSET 10 Integer Value Set E A  List:3 entries
0 = No
1 = Yes
99 = Not Applicable
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