# Table: Print Checks Detail Extension

Table: UPPCKD
View: UP0080
Record length: 130
Flags: A R

## Keys: 2

Title | Flags | Fields
--- | --- | ---
Sort Code |  | SORTCODE, CATEGORY, EARNDED, LINETYPE, LINENO
Print Order |  | SORTCODE, PCATEGORY, PLINETYPE, EARNDED, LINETYPE, LINENO

## Fields: 20

Field | Type | Title | Presentation
--- | --- | --- | ---
SORTCODE | BCD*10.0 | Sort Code |
CATEGORY | Integer | Category | List: 11 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
11 | = | EFT Entry
EARNDED | String*6 | Earning/Deduction/Tax Code | Mask: %-6N
LINETYPE | Integer | Line Type | List: 9 entries
1 | = | Payment
2 | = | Accrual
3 | = | Regular
4 | = | Overtime
5 | = | Shift Differential
6 | = | n/a
7 | = | Normal Withholding
8 | = | Backup Withholding
9 | = | Supplemental Withholding
LINENO | Integer | Line Number |
AUDTDATE | Date |  |
AUDTTIME | Time |  |
AUDTUSER | String*8 |  |
AUDTORG | String*6 |  |
SHORTDESC | String*15 | Short Desc |
HOURS | BCD*4.3 | Number of Hours |
ECNTBASE | BCD*10.3 | Base Amount |
RATEFMT | Integer | Rate Format |
RATE | BCD*9.5 | Hourly Rate/Percent/Amount |
CURRAMT | BCD*10.3 | Current Amount |
YTDAMT | BCD*10.3 | YTD Amount |
BALANCE | BCD*10.3 | Accrual Balance |
PCATEGORY | Integer | Printing Category | List: 6 entries
1 | = | CHKD Earnings
2 | = | CHKD Deductions
3 | = | CHKD Taxes
4 | = | CHKD Other
5 | = | CHKD Benefits
6 | = | CHKE EFT Entries
PLINETYPE | Integer | Printing Line type | List: 45 entries
11 | = | CHKD Regular Line
11 | = | CHKD Overtime Line
11 | = | CHKD Shift Diff Line
14 | = | CHKD Disbursed Tips
15 | = | CHKD Vacation Payment
16 | = | CHKD Sick Payment
17 | = | CHKD Comp. Time Payment
21 | = | CHKD Deduction Entry
31 | = | CHKD Federal Income Entry
32 | = | CHKD Federal Insurance Entry
33 | = | CHKD Federal UI Entry
34 | = | CHKD Federal Pension Entry
35 | = | CHKD Federal Health Entry
36 | = | CHKD Federal Other Entry
41 | = | CHKD State Income Entry
42 | = | CHKD State Insurance Entry
43 | = | CHKD State UI Entry
44 | = | CHKD State Pension Entry
45 | = | CHKD State Health Entry
46 | = | CHKD State Other Entry
51 | = | CHKD Local Income Entry
52 | = | CHKD Local Insurance Entry
53 | = | CHKD Local UI Entry
54 | = | CHKD Local Pension Entry
55 | = | CHKD Local Health Entry
56 | = | CHKD Local Other Entry
61 | = | CHKD User Income Entry
62 | = | CHKD User Insurance Entry
63 | = | CHKD User UI Entry
64 | = | CHKD User Pension Entry
65 | = | CHKD User Health Entry
66 | = | CHKD User Other Entry
71 | = | CHKD Exp Reimbursement
72 | = | CHKD Cash Advance
73 | = | CHKD Reported Tips
74 | = | CHKD Allocated Tips
75 | = | CHKD Noncash Advance
76 | = | CHKD Vac Accrual
77 | = | CHKD Sick Accrual
78 | = | CHKD Comp Accrual
81 | = | CHKD Cash Benefit
82 | = | CHKD Noncash Benefit
91 | = | CHKE EFT Entry - Fixed Amount
92 | = | CHKE EFT Entry - % of Gross Earnings
93 | = | CHKE EFT Entry - % of Net Pay
POOLEDTIPS | BCD*10.3 | Pooled Tips |

This page was generated on 2008-May-02

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