# View: Canadian Payroll Superview

RotoID: PM0450
Table: PMCP
Protocol: Header
DLL: PMCP

## Compositions: 1

RotoID | Tables | Title | DLL
--- | --- | --- | ---
PM0452 | PMCPO | C/P Optional Field | PMCPO

## Keys: 1

Title | Fields
--- | ---
| SEQUENCENO

## Fields: 53

Field | Index | Type | Title | Attributes | Presentation
--- | --- | --- | --- | --- | ---
SEQUENCENO | 1 | Long |  | E A K R |
CNTBTCH | 2 | BCD*5.0 | Batch | E A |
LINENO | 3 | Integer | Line Number | E A |
CHECKNUM | 4 | BCD*5.0 | Check Number | E A |
FISCALYEAR | 5 | String*4 | Fiscal Year | E A | Mask: %04D
FISCALPER | 6 | Integer | Fiscal Period | E A | List: 13 entries
1 | = | 1
2 | = | 2
3 | = | 3
4 | = | 4
5 | = | 5
6 | = | 6
7 | = | 7
8 | = | 8
9 | = | 9
10 | = | 10
11 | = | 11
12 | = | 12
13 | = | 13
JOURNLDATE | 7 | Date | G/L Journal Date | E A |
TRANSDATE | 8 | Date | Transaction Date | E A |
CURRENCY | 9 | String*3 | Currency | E A | Mask: %-3N
EXCHRATE | 10 | BCD*8.7 | Exchange Rate | E A |
RATETYPE | 11 | String*2 | Rate Type | E A | Mask: %-2N
RATEDATE | 12 | Date | Rate Date | E A |
RATEOP | 13 | Integer | Rate Operator | E A | List: 2 entries
1 | = | Multiply
2 | = | Divide
CONTRACT | 14 | String*16 | ^1 | E A | Mask: %-16C
PROJECT | 15 | String*16 | ^2 | E A | Mask: %-16N
CATEGORY | 16 | String*16 | ^3 | E A | Mask: %-16N
EMPLOYEE | 17 | String*24 | Employee | E A |
DOCTYPE | 18 | Integer | Document Type | E A | List: 2 entries
1 | = | System Check
2 | = | Manual Check
TRANSTYPE | 19 | Integer | Transaction Type | E A | List: 2 entries
1 | = | Posted
2 | = | Check Reversal
TRANSNUM | 20 | Long | PJC Transaction Number | A C |
EARNINGS | 21 | String*6 | Earnings or Deduction Code | E A |
QUANTITY | 22 | BCD*10.5 | Quantity | E A |
HOURS | 23 | BCD*4.3 | Hours | E A |
BASE | 24 | BCD*10.3 | Base | E A |
UNITRATE | 25 | BCD*9.5 | Unit Rate | E A |
PERCENT | 26 | BCD*9.5 | Percent | E A |
EXTAMTHM | 27 | BCD*10.3 | Extended Amount (HM) | E A |
EXTAMTSR | 28 | BCD*10.3 | Extended Amount (SR) | E A |
BILLRATE | 29 | BCD*10.6 | Billing Rate | E A |
BILLTYPE | 30 | Integer | Billing Type | E A | List: 4 entries
0 | = | None
2 | = | Billable
3 | = | No Charge
1 | = | Non-billable
WIPACCT | 31 | String*45 | WIP Account | E A | Mask: %-45C
TRANACCT | 32 | String*45 | Transaction Account | E A | Mask: %-45C
OHACCT | 33 | String*45 | Overhead Account | E A C | Mask: %-45C
OHAMTSR | 34 | BCD*10.3 | Overhead Amount | E A C |
OHAMTHM | 35 | BCD*10.3 | Overhead Amount | E A C |
LABACCT | 36 | String*45 | Labor Account | E A C | Mask: %-45C
LABORSR | 37 | BCD*10.3 | Labor Amount | E A C |
LABORHM | 38 | BCD*10.3 | Labor Amount | E A C |
ARITEM | 39 | String*16 | A/R Item Number | E A | Mask: %-16C
ARUOM | 40 | String*10 | A/R Unit of Measure | E A | Mask: %-10C
OVERHD | 41 | Integer | Overhead Type | E A C | List: 3 entries
1 | = | None
2 | = | Flat Rate Per Unit
5 | = | Percentage of Cost
OHEADRATE | 42 | BCD*10.6 | Overhead Rate | E A C |
HEADPER | 43 | BCD*5.5 | Overhead Percentage | E A C |
LABOR | 44 | Integer | Labor Type | E A C | List: 3 entries
1 | = | None
2 | = | Flat Rate Per Labor Hour/Unit
3 | = | Percentage of Labor Cost
LABORRATE | 45 | BCD*10.6 | Labor Rate | E A C |
LABORPER | 46 | BCD*5.5 | Labor Percentage | E A C |
DRILLSRCTY | 47 | Integer | Drill Down Type | E A |
DRILLDWNLK | 48 | BCD*10.0 | Drill Down Link | E A |
DRILLAPP | 49 | String*2 | Drill Down Application | E A |
PROJSTAT | 50 | Integer | ^2 Status | E A | List: 7 entries
10 | = | Estimate
20 | = | Approved
30 | = | Open
40 | = | On Hold
70 | = | Inactive
60 | = | Completed
50 | = | Closed
DIFF | 51 | Integer | Differential Record? | E A |
EXPENSEREI | 52 | Integer | Exp. Reimbursement? | E A |
RESOURCE | 53 | String*24 | Resource | E A |

This page was generated on 2008-May-01

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