Table: Print Cheques Header Extension

Table: CPPCKH
View: CP0079
Record Length: 1259

Flags: A R 

Keys: 2

Title Flags Fields

Sort Code SORTCODE
Employee D M  EMPLOYEE

Fields: 65

Field Type Title Presentation

SORTCODE BCD*10.0 Sort Code
AUDTDATE Date
AUDTTIME Time
AUDTUSER String*8
AUDTORG String*6
LASTNAME String*20 Employee Last Name
FIRSTNAME String*15 Employee First Name
MIDDLENAME String*15 Employee Middle Name
ADDRESS1 String*60 Employee Address 1
ADDRESS2 String*60 Employee Address 2
ADDRESS3 String*60 Employee Address 3
ADDRESS4 String*60 Employee Address 4
CITY String*30 City
STATE String*30 State
ZIP String*20 Zip/Postal Code
COUNTRY String*30 Country
SSN String*11 SSN/SIN
GLSEG1 String*15 G/L Segment One
GLSEG2 String*15 G/L Segment Two
GLSEG3 String*15 G/L Segment Three
GPAYCUR BCD*10.3 Current Gross Pay
GPAYYTD BCD*10.3 YTD Gross Pay
TOTEARNCUR BCD*10.3 Current Total Earnings
TOTEARNYTD BCD*10.3 YTD Total Earnings
TOTTAXCUR BCD*10.3 Current Total Taxes
TOTTAXYTD BCD*10.3 YTD Total Taxes
TOTDEDCUR BCD*10.3 Current Total Deductions
TOTDEDYTD BCD*10.3 YTD Total Deductions
TOTCBCUR BCD*10.3 Current Total Cash Benefits
TOTCBYTD BCD*10.3 YTD Total Cash Benefits
TOTNCCUR BCD*10.3 Current Total Non-cash Benefits
TOTNCYTD BCD*10.3 YTD Total Non-cash Benefits
TOTTBCUR BCD*10.3 Total Taxable Benefits
TOTNTCUR BCD*10.3 Total Non-taxable Benefits
FITYTD BCD*10.3 YTD Wages Subject to FIT
NETPAYCUR BCD*10.3 Current Net Pay
NETPAYYTD BCD*10.3 YTD Net Pay
VACUSEDC BCD*10.3 Current Vacation Used
VACUSEDY BCD*10.3 YTD Vacation Used
VACLEFT BCD*10.3 Vacation Left
SICKUSEDC BCD*10.3 Current Sick Used
SICKUSEDY BCD*10.3 YTD Sick Used
SICKLEFT BCD*10.3 Sick Left
COMPUSEDC BCD*10.3 Current Banked Used
COMPUSEDY BCD*10.3 YTD Banked Used
COMPLEFT BCD*10.3 Banked Left
TOTHOURS BCD*10.3 Total Hours
TOTREGHRS BCD*10.3 Total Regular Hours
TOTOTHRS BCD*10.3 Total Overtime Hours
COMPANYNAM String*60 Company Name
CADDRESS1 String*60 Company Address 1
CADDRESS2 String*60 Company Address 2
CADDRESS3 String*60 Company Address 3
CADDRESS4 String*60 Company Address 4
CCITY String*30 Company City
CSTATE String*30 Company State
CPOSTALC String*20 Company Zip/Postal Code
CCOUNTRY String*30 Company Country
PERSTART Date Period Start Date
PEREND Date Period End Date
PRPERIOD Integer Period
EMPLOYEE String*12 Employee
GLSEG4 String*15 G/L Segment Four
GLSEG5 String*15 G/L Segment Five
GLSEG6 String*15 G/L Segment Six