# View: Timecard Detail

RotoID: UP0032
Tables: UPTCDT
DLL: UPTCDT

## Compositions: 2

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

## Keys: 2

Title | Fields
--- | ---
Timecard Employee Values | EMPLOYEE, PEREND, TIMECARD, CATEGORY, EARNDED, UNIQUE
Values | EARNDED, EMPLOYEE, PEREND, TIMECARD, CATEGORY, UNIQUE

## Fields: 59

Field | Index | Type | Title | Attributes | Presentation
--- | --- | --- | --- | --- | ---
EMPLOYEE | 1 | String*12 | Employee Values | E A K R | Mask: %-12N
PEREND | 2 | Date | Period end date Values | E A K R |
TIMECARD | 3 | String*6 | Timecard Values | E A K R | Mask: %-6N
CATEGORY | 4 | Integer | Category Values | E A K 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 | 5 | String*6 | Earnings/Deduction Values | E A K R | Mask: %-6N
UNIQUE | 6 | Integer | Unique Key Field Values | E A K R |
EARDEDTYPE | 7 | Integer | Type Values | 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 Values | E A X |
STARTTIME | 9 | Integer | Start Time Values | E A X |
STOPTIME | 10 | Integer | Stop Time Values | E A X |
GLSEG1 | 11 | String*15 | G/L Segment One Values | E A X | Mask: %-15N
GLSEG2 | 12 | String*15 | G/L Segment Two Values | E A X | Mask: %-15N
GLSEG3 | 13 | String*15 | G/L Segment Three Values | E A X | Mask: %-15N
HOURS | 14 | BCD*4.3 | Hours Values | E A X |
CALCMETH | 15 | Integer | Calculation Method Values | 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 Values | E A C |
CNTBASE | 17 | BCD*10.3 | Pieces/Base Values | X |
RATE | 18 | BCD*9.5 | E/D/Tax Rate/Amt/Percent Values | E A X |
PAYORACCR | 19 | Integer | Pay/Accrue Hours Values | E A X | List: 3 entries
1 | = | Payment
2 | = | Accrual
6 | = | n/a
EXPACCT | 20 | String*45 | Regular Pay Expense G/L Account Values | E A X D |
LIABACCT | 21 | String*45 | Liability G/L Account Values | X |
OTACCT | 22 | String*45 | Overtime Expense G/L Account Values | X |
SHIFTACCT | 23 | String*45 | Shift Differential G/L Account Values | X |
ASSETACCT | 24 | String*45 | Asset Account Values | X |
OTSCHED | 25 | String*6 | Overtime Schedule Values | X |
SHIFTSCHED | 26 | String*6 | Shift Differential Schedule Values | X |
SHIFTNUM | 27 | Integer | Shift Number Values | X |
WCC | 28 | String*6 | Workers Compensation Code Values | X |
TAXWEEKS | 29 | BCD*4.3 | Weeks Worked Values | E A X |
TAXANNLIZ | 30 | BCD*5.5 | Tax Annualization Factor Values | E A X |
WEEKLYNTRY | 31 | Boolean | INTERNAL USE Values | X |
ENTRYTYPE | 32 | Integer | Entry Type Values | E A C |
POOLEDTIPS | 33 | BCD*10.3 | RESERVED - Cdn Only Values | X |
DESC | 34 | String*60 | E/D/Tax Description Values | E A C |
GLSEGID1 | 35 | String*6 | G/L Segment Name One Values | E A C |
GLSEGDESC1 | 36 | String*60 | G/L Segment Description One Values | E A C |
GLSEGID2 | 37 | String*6 | G/L Segment Name Two Values | E A C |
GLSEGDESC2 | 38 | String*60 | G/L Segment Description Two Values | E A C |
GLSEGID3 | 39 | String*6 | G/L Segment Name Three Values | E A C |
GLSEGDESC3 | 40 | String*60 | G/L Segment Description Three Values | E A C |
KEYACTION | 41 | Integer | INTERNAL USE - Key Action Values | E A C |
WORKPROV | 42 | Integer | Values | E A C |
PROCESSCMD | 43 | Integer | Process Command Code Values | E A C | List: 3 entries
0 | = | Process Cost Centers
1 | = | Insert Optional Fields
2 | = | Transfer Optional Fields
NKEMPLOYEE | 44 | String*12 | INTERNAL USE - New Key Employee Values | E A C | Mask: %-12N
NKPEREND | 45 | Date | INTERNAL USE - New Key Period EnValues | E A C |
NKTIMECARD | 46 | String*6 | INTERNAL USE - New Key Timecard Values | E A C | Mask: %-6N
NKCATEGORY | 47 | Integer | INTERNAL USE - New Key Category Values | E A C |
NKEARNDED | 48 | String*6 | INTERNAL USE - New Key EarnDed Values | E A C | Mask: %-6N
NKUNIQUE | 49 | Integer | INTERNAL USE - New Key UniquifieValues | E A C |
DAYS | 100 | Integer | Days Values | E A X |
REGHOURS | 101 | BCD*4.3 | Regular Hours Values | E A X |
OTHOURS1 | 102 | BCD*4.3 | Overtime Hours 1 Values | E A X |
OTHOURS2 | 103 | BCD*4.3 | Overtime Hours 2 Values | E A X |
OTHOURS3 | 104 | BCD*4.3 | Overtime Hours 3 Values | E A X |
OTHOURS4 | 105 | BCD*4.3 | Overtime Hours 4 Values | E A X |
OTHOURS5 | 106 | BCD*4.3 | Overtime Hours 5 Values | E A X |
OTHOURS6 | 107 | BCD*4.3 | Overtime Hours 6 Values | E A X |
WCCGROUP | 108 | String*6 | Workers Comp. Group Values | X |
VALUES | 109 | Long | Number of Optional Fields Values | E A C |

This page was generated on 2004-Oct-28

Copyright © 2000–2004 ACCPAC International, Inc. All rights reserved.