# Table: Check Header

Table: UPCHKH
View: UP0048
Record length: 271
Flags: A R

## Keys: 12

Title | Flags | Fields
--- | --- | ---
Employee |  | EMPLOYEE, PEREND, ENTRYSEQ
Check Date |  | TRANSDATE, EMPLOYEE, ENTRYSEQ
Post Status | M | PRPOSTSTAT, PEREND, EMPLOYEE, ENTRYSEQ
Posting Sequence | M | POSTSEQ, EMPLOYEE, PEREND, ENTRYSEQ
Bank Code by Check | D M | BANK, TRANSNUM, SERIAL
Pay Frequency | M | PRPOSTSTAT, PAYFREQ, EMPLOYEE, PEREND, ENTRYSEQ
Class 1 | M | PRPOSTSTAT, CLASS1, EMPLOYEE, PEREND, ENTRYSEQ
Class 2 | M | PRPOSTSTAT, CLASS2, EMPLOYEE, PEREND, ENTRYSEQ
Class 3 | M | PRPOSTSTAT, CLASS3, EMPLOYEE, PEREND, ENTRYSEQ
Class 4 | M | PRPOSTSTAT, CLASS4, EMPLOYEE, PEREND, ENTRYSEQ
Employee by Post Status | M | PRPOSTSTAT, EMPLOYEE, PEREND, ENTRYSEQ
G/L Drilldown Link | D M | GLDRDWNLNK

## Fields: 44

Field | Type | Title | Presentation
--- | --- | --- | ---
EMPLOYEE | String*12 | Employee | Mask: %-12N
PEREND | Date | Period End Date |
ENTRYSEQ | Long | Entry Sequence |
AUDTDATE | Date |  |
AUDTTIME | Time |  |
AUDTUSER | String*8 |  |
AUDTORG | String*6 |  |
ENTRYTYPE | Integer | Type of Check | List: 5 entries
1 | = | System Check
2 | = | Manual Check
3 | = | Adjustment
4 | = | History Entry
5 | = | Reversed Check
BANK | String*8 | Bank ID |
TRANSNUM | BCD*5.0 | Transaction Number |
TRANSDATE | Date | Transaction Date |
PERSTART | Date | Period Start Date |
TIMESLATE | Integer | Times Late This Period/Timecard |
CHECKSTAT | Integer | Check Status | List: 8 entries
1 | = | Align
2 | = | Void
3 | = | Outstanding
4 | = | Reversed
5 | = | Cleared
6 | = | Cleared With Error
7 | = | Non-negotiable
8 | = | Continuation
PRPOSTSTAT | Integer | PR Post Status | List: 2 entries
1 | = | Not Posted
2 | = | Posted
GLPOSTSTAT | Integer | Sent to G/L | List: 3 entries
1 | = | Not sent
2 | = | Sent
3 | = | Not to be sent
PAYFREQ | Integer | Pay Frequency | 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 | String*6 | Class 1 | Mask: %-6N
CLASS2 | String*6 | Class 2 | Mask: %-6N
CLASS3 | String*6 | Class 3 | Mask: %-6N
CLASS4 | String*6 | Class 4 | Mask: %-6N
SERIAL | Long | Bank Serial Number |
CALCSEQ | Long | Calculation Sequence |
POSTSEQ | Long | Posting Sequence |
PRPERIOD | Integer | Payroll Period |
TRANSAMT | BCD*10.3 | Transaction Amt |
GLSEG1 | String*15 | G/L Segment One |
GLSEG2 | String*15 | G/L Segment Two |
GLSEG3 | String*15 | G/L Segment Three |
BANKACCT | String*45 | Bank General Ledger Account |
WORKPROV | Integer | RESERVED - Cdn Only |
TAXPLAN | String*6 | Employee EI ID |
EXRATE | BCD*8.7 | Exchange Rate |
RATEOP | Integer | Rate Operator |
EFTSTAT | Integer | EFT Status | List: 3 entries
0 | = | Not to be EFTed
1 | = | Not EFTed
2 | = | EFTed
EFTRUNSEQ | Long | EFT Run Sequence |
VALUES | Long | Number of Optional Fields |
GLDRDWNLNK | BCD*10.0 | G/L Drilldown Link |
OTOVERRIDE | Boolean | Overtime Override |
OTCALCTYPE | Integer | Overtime Calculation | 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 | Integer | Based on External Timecards | List: 2 entries
0 | = | No
1 | = | Yes
SWJOB | Boolean | Job Related |
EXRATEDATE | Date | Exchange Rate Date |
ORGTYPE | Integer | Original Type | List: 5 entries
1 | = | System Check
2 | = | Manual Check
3 | = | Adjustment
4 | = | History Entry
5 | = | Reversed Check

This page was generated on 2009-Nov-19

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