Table: Cheque Jobs Optional Fields Values

Table: CPCHJO
View: CP0144
Record Length: 143

Flags: A R 

Keys: 2

Title Flags Fields

Cheque Jobs Optional Field Value EMPLOYEEPERENDENTRYSEQCATEGORYEARNDEDLINETYPELINENOJOBLINEOPTFIELD
Optional Field/Cheque Jobs OPTFIELDEMPLOYEEPERENDENTRYSEQCATEGORYEARNDEDLINETYPELINENOJOBLINE

Fields: 20

Field Type Title Presentation

EMPLOYEE String*12 Employee Mask: %-12N
PEREND Date Period End Date
ENTRYSEQ Long Entry Sequence
CATEGORY Integer Category List:10 entries
1 = Accrual
2 = Earning
3 = Advance
4 = Deduction
5 = Expense Reimbursement
6 = Benefit
7 = Federal Tax
8 = Provincial Tax
9 = Local Tax
10 = User Tax
EARNDED String*6 Earning/Deduction Mask: %-6N
LINETYPE Integer Type 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 Integer Line Number
JOBLINE Integer Job Line Number
OPTFIELD String*12 Optional Field Mask: %-12N
AUDTDATE Date
AUDTTIME Time
AUDTUSER String*8
AUDTORG String*6
VALUE String*60 Value Mask: %-60c
TYPE Integer Type List:7 entries
1 = Text
100 = Amount
6 = Number
8 = Integer
9 = Yes/No
3 = Date
4 = Time
LENGTH Integer Length
DECIMALS Integer Decimals
ALLOWNULL Boolean Allow Blank List:2 entries
0 = No
1 = Yes
VALIDATE Boolean Validate List:2 entries
0 = No
1 = Yes
SWSET Integer Value Set List:3 entries
0 = No
1 = Yes
99 = Not Applicable