View: Manual Check Header

RotoID: UP0019
Table: UPMCHD
Protocol: Header
DLL:UPMCHD

Compositions: 2

RotoID Tables Title DLL
UP0020 UPMCDT Manual Check Detail UPMCDT
UP0129 UPMCHO Manual Check Optional Field Values UPMCHO

Keys: 3

Title Fields
Check Date EMPLOYEE, BANK, CHECKNUM, PEREND, CHECKDATE
Check Number EMPLOYEE, BANK, CHECKNUM
Period End Date EMPLOYEE, PEREND, CHECKNUM

Fields: 64

Field Index Type Title Attributes Presentation
EMPLOYEE 1 String*12 Employee E A K R  Mask: %-12N
BANK 2 String*8 Bank Code E A K R X  Mask: %-8N
CHECKNUM 3 BCD*5.0 Check Number E A K R X 
PEREND 4 Date Period End Date E A K R 
CHECKDATE 5 Date Check Date E A K R 
CHECKDESC 6 String*15 Description E A 
PERSTART 7 Date Period Start Date E A 
TIMESLATE 8 Integer Times Late E A 
ACTIVE 9 Boolean Check Active E A 
PRINT 10 Boolean Print Check E A 
BANKFORM 11 String*6 Check Stock Code E A  Mask: %-6N
PROCESSED 13 Integer Processed E A C 
GROSSPAY 14 BCD*10.3 Gross Pay E A C 
CONTRIBS 15 BCD*10.3 Benefits E A C 
DEDUCTIONS 16 BCD*10.3 Deductions E A C 
TAXES 17 BCD*10.3 Taxes E A C 
NETPAY 18 BCD*10.3 Net Pay E A C 
LASTNAME 19 String*20 Last Name A C 
FIRSTNAME 20 String*15 First Name A C 
MIDDLENAME 21 String*15 Middle Name A C 
CREGHRS 22 BCD*4.3 Regular Hours E A C 
CSHIFTHRS 23 BCD*4.3 Shift Hours E A C 
COTHRS 24 BCD*4.3 Overtime Hours E A C 
CVACHRSP 25 BCD*4.3 Vacation Hours Paid A C 
CVACHRSA 26 BCD*4.3 Vacation Hours Accrued A C 
CSICKHRSP 27 BCD*4.3 Sick Hours Paid A C 
CSICKHRSA 28 BCD*4.3 Sick Hours Accrued A C 
CCOMPHRSP 29 BCD*4.3 Compensatory Time Hours Paid A C 
CCOMPHRSA 30 BCD*4.3 Comp. Time Hours Accrued A C 
CVACAMTP 31 BCD*10.3 Vacation Dollars Paid A C 
CVACAMTA 32 BCD*10.3 Vacation Dollars Accrued A C 
CSICKAMTP 33 BCD*10.3 Sick Time Dollars Paid A C 
CSICKAMTA 34 BCD*10.3 Sick Time Dollars Accrued A C 
CCOMPAMTP 35 BCD*10.3 Comp. Time Dollars Paid A C 
CCOMPAMTA 36 BCD*10.3 Comp. Time Dollars Accrued A C 
ESSWAGES 37 BCD*10.3 Employee Social Security Wages A C 
ESSWH 38 BCD*10.3 Employee Soc. Sec. Withholding A C 
EMEDWAGES 39 BCD*10.3 Employee Medicare Wages A C 
EMEDWH 40 BCD*10.3 Employee Medicare Withholding A C 
KEYACTION 41 Integer INTERNAL USE - Key Action E A C 
CDISIHRSP 42 BCD*4.3 RESERVED - Cdn Only A C 
CDISIHRSA 43 BCD*4.3 RESERVED - Cdn Only A C 
CDISIAMTP 44 BCD*10.3 RESERVED - Cdn Only A C 
CDISIAMTA 45 BCD*10.3 RESERVED - Cdn Only A C 
HIREDATE 46 Date Hire Date E A 
FIREDATE 47 Date Termination Date E A 
PARTTIME 48 Boolean Part-Time E A 
PAYFREQ 49 Integer Pay Frequency E A 
OTSCHED 50 String*6 Overtime Schedule E A 
SHIFTSCHED 51 String*6 Shift Differential Schedule E A 
SHIFTNUM 52 Integer Shift Number E A 
GLSEG1 53 String*15 Segment Code 1 E A 
GLSEG2 54 String*15 Segment Code 2 E A 
GLSEG3 55 String*15 Segment Code 3 E A 
WORKPROV 56 Integer RESERVED - Cdn Only E A 
STATUS 57 Integer Employment Status E A 
INACTDATE 58 Date Inactive Date E A 
PROCESSCMD 59 Integer Process Command Code E A C  List:2 entries
0 = Key Action
1 = Insert Optional Fields
WORKCODE 60 String*6 Work Classification A C 
TOTALJOBS 61 Long Total Jobs E A C 
USERSEC 62 Integer Security Flag E A 
VALUES 75 Long Number of Optional Fields E A C 
MCDLINES 76 Integer Manual Check Lines E A C 
SWJOB 77 Boolean Job Related E A 

This page was generated on 2022-Aug-18

© 2021 Sage Software, Inc. All rights reserved. Reproduction of part or all of the contents in any form is prohibited unless for personal use. None of the content of this article may be copied or otherwise incorporated into any other document, publication or other work in any form (whether written, electronic or other format).

Sage Software, Inc. makes no warranties, representations or undertakings about any of the content of articles (including, without limitation, any as to the quality, accuracy, completeness or fitness for any particular purpose of such content).