# 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 | EMPLOYEE, PEREND, ENTRYSEQ, CATEGORY, EARNDED, LINETYPE, LINENO, JOBLINE, OPTFIELD
Optional Field/Check Jobs | OPTFIELD, EMPLOYEE, PEREND, ENTRYSEQ, CATEGORY, EARNDED, LINETYPE, LINENO, JOBLINE

## 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 |

This page was generated on 2008-May-02

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