View: Timecard Earnings List

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

Keys: 1

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

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 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 
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 RESERVED - Cdn Only E A 
TAXREPAY 72 BCD*10.3 RESERVED - Cdn Only E A 

This page was generated on 2023-Aug-31

© 2023 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).