View: Check Header

RotoID: UP0048
Table: UPCHKH
Protocol: Header
DLL:UPCHKH

Compositions: 5

RotoID Tables Title DLL

UP0049 UPCHKD Check Details UPCHKD
UP0052 UPCHKC Check Comment Detail UPCHKC
UP0202 UPCHKE Check EFT Details UPCHKE
UP0133 UPCHHO Check Header Optional Field Values UPCHHO
UP0134 UPCHDO Check Details Optional Fields UPCHDO

Keys: 12

Title Fields

Employee EMPLOYEEPERENDENTRYSEQ
Check Date TRANSDATEEMPLOYEEENTRYSEQ
Post Status PRPOSTSTATPERENDEMPLOYEEENTRYSEQ
Posting Sequence POSTSEQEMPLOYEEPERENDENTRYSEQ
Bank Code by Check BANKTRANSNUMSERIAL
Pay Frequency PRPOSTSTATPAYFREQPERENDEMPLOYEEENTRYSEQ
Class 1 PRPOSTSTATCLASS1PERENDEMPLOYEEENTRYSEQ
Class 2 PRPOSTSTATCLASS2PERENDEMPLOYEEENTRYSEQ
Class 3 PRPOSTSTATCLASS3PERENDEMPLOYEEENTRYSEQ
Class 4 PRPOSTSTATCLASS4PERENDEMPLOYEEENTRYSEQ
Employee by Post Status PRPOSTSTATEMPLOYEEPERENDENTRYSEQ
G/L Drilldown Link GLDRDWNLNK

Fields: 47

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 
ENTRYTYPE 4 Integer Type of Check E A X  List:5 entries
1 = System Check
2 = Manual Check
3 = Adjustment
4 = History Entry
5 = Reversed Check
BANK 5 String*8 Bank ID E A X 
TRANSNUM 6 BCD*5.0 Transaction Number E A X 
TRANSDATE 7 Date Transaction Date E A X 
PERSTART 8 Date Period Start Date E A X 
TIMESLATE 9 Integer Times Late This Period/Timecard E A X 
CHECKSTAT 10 Integer Check Status E A X  List:8 entries
1 = Align
2 = Void
3 = Outstanding
4 = Reversed
5 = Cleared
6 = Cleared With Error
7 = Non-negotiable
8 = Continuation
PRPOSTSTAT 11 Integer PR Post Status E A X  List:2 entries
1 = Not Posted
2 = Posted
GLPOSTSTAT 12 Integer Sent to G/L E A X  List:3 entries
1 = Not sent
2 = Sent
3 = Not to be sent
PAYFREQ 13 Integer Pay Frequency E A X  List:9 entries
2 = Daily
3 = Weekly
4 = Biweekly
5 = Semimonthly
10 = Twenty-two per Year
9 = Thirteen per Year
6 = Monthly
8 = Ten per Year
7 = Quarterly
CLASS1 14 String*6 Class 1 E A X  Mask: %-6N
CLASS2 15 String*6 Class 2 E A X  Mask: %-6N
CLASS3 16 String*6 Class 3 E A X  Mask: %-6N
CLASS4 17 String*6 Class 4 E A X  Mask: %-6N
SERIAL 18 Long Bank Serial Number E A X 
CALCSEQ 19 Long Calculation Sequence E A X 
POSTSEQ 20 Long Posting Sequence E A X 
PRPERIOD 21 Integer Payroll Period E A X 
TRANSAMT 22 BCD*10.3 Transaction Amt E A X 
GLSEG1 23 String*15 G/L Segment One E A X 
GLSEG2 24 String*15 G/L Segment Two E A X 
GLSEG3 25 String*15 G/L Segment Three E A X 
BANKACCT 26 String*45 Bank General Ledger Account E A X 
WORKPROV 27 Integer RESERVED - Cdn Only X 
TAXPLAN 28 String*6 Employee EI ID E A X 
EXRATE 29 BCD*8.7 Exchange Rate E A X 
RATEOP 30 Integer Rate Operator E A X 
EFTSTAT 31 Integer EFT Status E A X  List:3 entries
0 = Not to be EFTed
1 = Not EFTed
2 = EFTed
EFTRUNSEQ 32 Long EFT Run Sequence E A X 
VALUES 33 Long Number of Optional Fields E A C X 
GLDRDWNLNK 34 BCD*10.0 G/L Drilldown Link E A X 
OTOVERRIDE 35 Boolean Overtime Override E A X 
OTCALCTYPE 36 Integer Overtime Calculation E A X  List:6 entries
0 = Hourly Rate
1 = Minimum Wage
2 = Shift Rate
3 = FLSA-Hourly
4 = FLSA-Salary Fixed Hours
5 = FLSA-Salary Fluctuating Hours
SWEXTERNTC 37 Integer Based on External Timecards E A X  List:2 entries
0 = No
1 = Yes
SWJOB 38 Boolean Job Related E A X 
EXRATEDATE 39 Date Exchange Rate Date E A 
ORGTYPE 40 Integer Original Type E A X  List:5 entries
1 = System Check
2 = Manual Check
3 = Adjustment
4 = History Entry
5 = Reversed Check
CSEFTSTAT 41 Integer Child Support EFT Status E A X  List:2 entries
0 = Not EFTed
1 = EFTed
GLSEG4 42 String*15 G/L Segment Four E A X 
GLSEG5 43 String*15 G/L Segment Five E A X 
GLSEG6 44 String*15 G/L Segment Six E A X 
PROCESSCMD 100 Integer Process Command Code E A C X  List:2 entries
0 = No Action
1 = Insert Optional Fields
LINENO 101 Integer Next Line Number E A C X 
USERSEC 102 Integer Security Flag E A