View: Check Jobs Optional Fields Values

RotoID: UP0144
Table: UPCHJO
Protocol: Detail, Ordered revisions
DLL:UPCHJO

Compositions: 1

RotoID Tables Title DLL

UP0056 UPCHJB Check Job Details UPCHJB

Keys: 2

Title Fields

Check Jobs Optional Field Value EMPLOYEEPERENDENTRYSEQCATEGORYEARNDEDLINETYPELINENOJOBLINEOPTFIELD
Optional Field/Check Jobs OPTFIELDEMPLOYEEPERENDENTRYSEQCATEGORYEARNDEDLINETYPELINENOJOBLINE

Fields: 26

Field Index Type Title Attributes Presentation

EMPLOYEE 1 String*12 Employee E A K R  Mask: %-12N
PEREND 2 Date Period End Date E A K R 
ENTRYSEQ 3 Long Entry Sequence E A K R 
CATEGORY 4 Integer Category E A K R  List:10 entries
1 = Accrual
2 = Earning
3 = Advance
4 = Deduction
5 = Expense Reimbursement
6 = Benefit
7 = Federal Tax
8 = State Tax
9 = Local Tax
10 = User Tax
EARNDED 5 String*6 Earning/Deduction E A K R  Mask: %-6N
LINETYPE 6 Integer Type E A K R  List:9 entries
1 = Payment
2 = Accrual
3 = Regular
4 = Overtime
5 = Shift Differential
6 = n/a
7 = Normal Withholding
8 = Backup Withholding
9 = Supplemental Withholding
LINENO 7 Integer Line Number E A K R 
JOBLINE 8 Integer Job Line Number E A K R 
OPTFIELD 9 String*12 Optional Field E A K R  Mask: %-12N
VALUE 10 String*60 Value E A P  Mask: %-60c
TYPE 11 Integer Type E A C  List:7 entries
1 = Text
100 = Amount
6 = Number
8 = Integer
9 = Yes/No
3 = Date
4 = Time
LENGTH 12 Integer Length E A C 
DECIMALS 13 Integer Decimals E A C 
ALLOWNULL 14 Boolean Allow Blank E A C  List:2 entries
0 = No
1 = Yes
VALIDATE 15 Boolean Validate E A C  List:2 entries
0 = No
1 = Yes
SWSET 16 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  Mask: %-60c
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