# View: Timecard Detail

RotoID: UP0032
Table: UPTCDT
Protocol: Detail, Sequenced revisions, Key auto generate
DLL: UPTCDT

## Compositions: 3

RotoID | Tables | Title | DLL
--- | --- | --- | ---
UP0031 | UPTCHD | Timecard Header | UPTCHD
UP0128 | UPTCDO | Timecard Details Optional Field Values | UPTCDO
UP0042 | UPTCJB | Timecard Job Details | UPTCJB

## Keys: 3

Title | Fields
--- | ---
Timecard | EMPLOYEE, PEREND, TIMECARD, LINENUM
Timecard Employee | EMPLOYEE, PEREND, TIMECARD, CATEGORY, EARNDED, LINENUM
Timecard Earn/Ded | EARNDED, EMPLOYEE, PEREND, TIMECARD, CATEGORY, LINENUM

## Fields: 61

Field | Index | Type | Title | Attributes | Presentation
--- | --- | --- | --- | --- | ---
EMPLOYEE | 1 | String*12 | Employee | E A K R | Mask: %-12N
PEREND | 2 | Date | Period End Date | E A K R |
TIMECARD | 3 | String*6 | Timecard | E A K R | Mask: %-6N
LINENUM | 4 | Integer | Line Number | E A K R |
CATEGORY | 5 | Integer | Category | E A R | List: 10 entries
1 | = | Accrual
2 | = | Earning
3 | = | Advance
4 | = | Deduction
5 | = | Expense Reimbursement
6 | = | Benefit
7 | = | Federal Tax
8 | = | State Tax
9 | = | Local Tax
10 | = | User Tax
EARNDED | 6 | String*6 | Earnings/Deduction | E A R | Mask: %-6N
EARDEDTYPE | 7 | Integer | Type | E A C | List: 15 entries
1 | = | Salary & Wages
2 | = | Reported Tips
3 | = | Allocated Tips
7 | = | Vacation
8 | = | Sick
9 | = | Compensatory Time
13 | = | Cash
14 | = | Noncash
18 | = | Insurance Tax
19 | = | Income Tax
20 | = | Unemployment Tax
21 | = | Pension Plan Tax
22 | = | Health Tax
23 | = | Other Tax
25 | = | n/a
EARDEDDATE | 8 | Date | Date | E A X |
STARTTIME | 9 | Integer | Start Time | E A X |
STOPTIME | 10 | Integer | Stop Time | E A X |
GLSEG1 | 11 | String*15 | G/L Segment One | X |
GLSEG2 | 12 | String*15 | G/L Segment Two | X |
GLSEG3 | 13 | String*15 | G/L Segment Three | X |
HOURS | 14 | BCD*4.3 | Hours | E A X |
CALCMETH | 15 | Integer | Calculation Method | E A C | List: 13 entries
1 | = | None
2 | = | Flat
3 | = | Fixed
4 | = | Hourly Rate
5 | = | Amount per Hour
6 | = | Piece Rate Table
7 | = | Percentage of Base
8 | = | Sales Commission Table
9 | = | Wage Bracket Table
10 | = | Hours per Hour Worked
12 | = | Hours per Frequency
13 | = | Tax Bracket Table
14 | = | Percentage of Another Tax
LIMITBASE | 16 | Integer | Base Limit | E A C |
CNTBASE | 17 | BCD*10.3 | Pieces/Sales/Base | X |
RATE | 18 | BCD*9.5 | E/D/Tax Rate/Amt/Percent | X |
PAYORACCR | 19 | Integer | Pay/Accrue Hours | E A X | List: 3 entries
1 | = | Payment
2 | = | Accrual
6 | = | n/a
EXPACCT | 20 | String*45 | Regular Pay Expense G/L Account | E A X D |
LIABACCT | 21 | String*45 | Liability G/L Account | X |
OTACCT | 22 | String*45 | Overtime Expense G/L Account | X |
SHIFTACCT | 23 | String*45 | Shift Differential G/L Account | X |
ASSETACCT | 24 | String*45 | Asset Account | X |
OTSCHED | 25 | String*6 | Overtime Schedule | P X |
SHIFTSCHED | 26 | String*6 | Shift Differential Schedule | P X |
SHIFTNUM | 27 | Integer | Shift Number | X |
WCC | 28 | String*6 | Workers Compensation Code | P X |
TAXWEEKS | 29 | BCD*4.3 | Weeks Worked | E A X |
TAXANNLIZ | 30 | BCD*5.5 | Tax Annualization Factor | E A X |
WEEKLYNTRY | 31 | Boolean | INTERNAL USE | X |
ENTRYTYPE | 32 | Integer | Entry Type | E A C |
POOLEDTIPS | 33 | BCD*10.3 | RESERVED - Cdn Only | X |
DESC | 34 | String*60 | E/D/Tax Description | E A C |
GLSEGID1 | 35 | String*6 | G/L Segment Name One | E A C |
GLSEGDESC1 | 36 | String*60 | G/L Segment Description One | E A C |
GLSEGID2 | 37 | String*6 | G/L Segment Name Two | E A C |
GLSEGDESC2 | 38 | String*60 | G/L Segment Description Two | E A C |
GLSEGID3 | 39 | String*6 | G/L Segment Name Three | E A C |
GLSEGDESC3 | 40 | String*60 | G/L Segment Description Three | E A C |
KEYACTION | 41 | Integer | INTERNAL USE - Key Action | E A C |
WORKPROV | 42 | Integer | RESERVED - Cdn Only | E A C |
PROCESSCMD | 43 | Integer | Process Command Code | E A C | List: 5 entries
0 | = | Process Cost Centers
1 | = | Insert Optional Fields
2 | = | Update Info to Match Jobs
3 | = | Clear OT Override Fields
4 | = | Clear Jobs
NKEMPLOYEE | 44 | String*12 | INTERNAL USE - New Key Employee | E A C | Mask: %-12N
NKPEREND | 45 | Date | INTERNAL USE - New Key Period End | E A C |
NKTIMECARD | 46 | String*6 | INTERNAL USE - New Key Timecard | E A C | Mask: %-6N
NKLINENUM | 47 | Integer | INTERNAL USE - New Key Line Number | E A C |
DAYS | 100 | Integer | Days Worked | E A X |
WCCGROUP | 108 | String*6 | Workers Comp. Group | P X |
VALUES | 109 | Long | Number of Optional Fields | E A C |
OTHOURS | 110 | BCD*4.3 | Overtime Hours Override | X |
OTRATE | 111 | BCD*9.5 | Overtime Rate Override | X |
SWFLSA | 112 | Boolean | Include in FLSA Overtime Calc | X |
DISTCODE | 113 | String*6 | Distribution Code | E A X | Mask: %-6N
REXPACCT | 114 | String*45 | Employer Expense G/L Account | X |
RLIABACCT | 115 | String*45 | Employer Liability G/L Account | X |
SWALLOCJOB | 116 | Boolean | Jobs Alloc Based on Calc Base | X |
JOBS | 117 | Long | Jobs | C X |
WORKCODE | 118 | String*6 | Work Classification Code | E A | Mask: %-6N
JOBHOURS | 119 | BCD*4.3 | Total Job Hours | E A C X |
JOBBASE | 120 | BCD*10.3 | Total Job Pieces/Sales/Amt | C X |

This page was generated on 2009-Nov-19

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