# View: Timecard Earnings List

RotoID: UP0087
Table: UPCALO
Protocol: Flat
DLL: UPCALO

## Compositions: 0

## Keys: 1

Title | Fields
--- | ---
Earning Code | LEVEL, SORTCODE, EARDATE, START, TCPEREND, TIMECARD, TCLINENUM, EARNCODE, UNIQUE, LTYPE

## Fields: 65

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 | RESERVED - Cdn Only | 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 FLSA Overtime 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 |

This page was generated on 2009-Nov-19

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