View: Timecard Earnings List

RotoID: CP0087
Table: CPCALO
Protocol: Flat
DLL:CPCALO

Keys: 1

Title Fields

Earning Code LEVELSORTCODEEARDATESTARTTCPERENDTIMECARDTCLINENUMEARNCODEUNIQUELTYPE

Fields: 72

Field Index Type Title Attributes Presentation

LEVEL 1 Integer Earning Code Level E A K R 
SORTCODE 2 Integer Sort Code E A K R 
EARDATE 3 Date Earnings Date E A K R 
START 4 Integer Earnings Start Time E A K R 
TCPEREND 5 Date Timecard Period End Date E A K R 
TIMECARD 6 String*6 Timecard E A K R  Mask: %-6N
TCLINENUM 7 Integer Timecard Line Number E A K R 
EARNCODE 8 String*6 Earnings Code E A K R  Mask: %-6N
UNIQUE 9 Integer Uniquifier E A K R 
LTYPE 10 Integer Line Type E A K R 
EMPLOYEE 11 String*12 Employee E A  Mask: %-12N
PEREND 12 Date Period End Date E A 
ENTRYSEQ 13 Long Entry Sequence By Employee E A 
CATEGORY 14 Integer Category code E A 
EARNDED 15 String*6 Earnings/Deduction E A  Mask: %-6N
LINETYPE 16 Integer Presentation List Type Pay E A 
LINENO 17 Integer Line Number E A 
EARDEDTYPE 18 Integer Earnings/Deduction Type E A 
EARDEDDATE 19 Date Earnings/Deduction Date E A 
HOURS 20 BCD*4.3 Earnings/Deduction Hours E A 
ECNTBASE 21 BCD*10.3 Employee Amt, Cnt, Base or Sales E A 
ERATE 22 BCD*9.5 Employee Hourly Rate or Percent E A 
EEXTEND 23 BCD*10.3 Employee Dollar Amounts E A 
EREGRATE 24 BCD*9.5 Base Regular Rate for OT E A 
RCNTBASE 25 BCD*10.3 Employer Amt, Cnt, Base or Sales E A 
RRATE 26 BCD*9.5 Employer Hourly Rate or Percent E A 
REXTEND 27 BCD*10.3 Employer Dollar Amounts E A 
EXPACCT 28 String*45 Regular Pay Expense G/L Account E A 
ELIABACCT 29 String*45 Employee Liability G/L Account E A 
RLIABACCT 30 String*45 Employer Liability G/L Account E A 
WCC 31 String*6 Workers' Compensation Code E A 
GLSEG1 32 String*15 Cost Center Segment One E A 
GLSEG2 33 String*15 Cost Center Segment Two E A 
GLSEG3 34 String*15 Cost Center Segment Three E A 
PARTIAL 35 Boolean Detail Was Partially Taken or Not E A 
TAXWEEKS 36 BCD*4.3 Weeks Worked for the Taxing Authority E A 
TAXEARNS 37 BCD*10.3 Taxable Earnings E A 
TXEARNCEIL 38 BCD*10.3 Taxable Earnings Ceiling E A 
TAXTIPS 39 BCD*10.3 Taxable Tips Without a Ceiling E A 
TXTIPSCEIL 40 BCD*10.3 Taxable Tips With a Ceiling E A 
TAXONTIPS 41 BCD*10.3 Amount of Tax Calculated on Tips E A 
UNCOLLTAX 42 BCD*10.3 For Uncollected SS/Med E A 
PCATEGORY 43 Integer Print Category E A 
PLINETYPE 44 Integer Print Line Type E A 
PCONTENTS 45 Integer Print Line Contents E A 
TAXNONPER 46 BCD*10.3 Taxable Non-periodic Earnings E A 
TAXEARNBD 47 BCD*10.3 Subject to Income tax befor deductions E A 
POOLEDTIPS 48 BCD*10.3 Pooled Tips E A 
DETAILDATE 49 Date Detail Date E A 
STARTTIME 50 Integer Start Time E A 
STOPTIME 51 Integer Stop Time E A 
WCCGROUP 52 String*6 Workers Comp. Group E A  Mask: %-6N
VALUES 53 Long Number of Optional Fields E A 
HASTC 54 Boolean Timecard flag E A 
TCENTRY 55 Integer Timecard Entry E A 
SEPARATECK 56 Boolean Separate Check flag E A 
SWFLSA 57 Boolean Included in Regular Rate OT Calc E A 
STAMOUNT 58 BCD*10.3 Straight Time Earnings E A 
PREMIUMRT 59 BCD*5.5 Overtime Rate Multiplier E A 
WORKCODE 60 String*6 Work Classification Code E A  Mask: %-6N
BRACKET 61 Integer Overtime Schedule Bracket E A 
PRORATED 62 Boolean Prorated Timecard Detail E A 
PUNIQUE 63 Integer Prorated Timecard Parent E A 
OTSCHED 64 String*6 Overtime Schedule E A  Mask: %-6N
OTOVERRIDE 65 Boolean Overtime Override E A 
DISTCODE 66 String*6 Distribution Code E A  Mask: %-6N
DISTRNAME 67 String*15 Distribution Description E A 
GLSEG4 68 String*15 Cost Center Segment Four E A 
GLSEG5 69 String*15 Cost Center Segment Five E A 
GLSEG6 70 String*15 Cost Center Segment Six E A 
TAXNONDED 71 BCD*10.3 Non-periodic Deduction E A 
TAXREPAY 72 BCD*10.3 Repayment Deduction Before Tax E A