EMPLOYEE |
String*12 |
Employee |
Mask: %-12N |
PEREND |
Date |
Period End Date |
|
ENTRYSEQ |
Long |
Entry Sequence |
|
AUDTDATE |
Date |
|
|
AUDTTIME |
Time |
|
|
AUDTUSER |
String*8 |
|
|
AUDTORG |
String*6 |
|
|
ENTRYTYPE |
Integer |
Type of Cheque |
List:5 entries
1 |
= |
System Cheque |
2 |
= |
Manual Cheque |
3 |
= |
Adjustment |
4 |
= |
History Entry |
5 |
= |
Reversed Cheque |
|
BANK |
String*8 |
Bank ID |
|
TRANSNUM |
BCD*5.0 |
Transaction Number |
|
TRANSDATE |
Date |
Transaction Date |
|
PERSTART |
Date |
Period Start Date |
|
TIMESLATE |
Integer |
Times Late This Period/Timecard |
|
CHECKSTAT |
Integer |
Cheque Status |
List:8 entries
1 |
= |
Align |
2 |
= |
Void |
3 |
= |
Outstanding |
4 |
= |
Reversed |
5 |
= |
Cleared |
6 |
= |
Cleared With Error |
7 |
= |
Non-negotiable |
8 |
= |
Continuation |
|
PRPOSTSTAT |
Integer |
PR Post Status |
List:2 entries
1 |
= |
Not Posted |
2 |
= |
Posted |
|
GLPOSTSTAT |
Integer |
Sent to G/L |
List:3 entries
1 |
= |
Not sent |
2 |
= |
Sent |
3 |
= |
Not to be sent |
|
PAYFREQ |
Integer |
Pay Frequency |
List:9 entries
2 |
= |
Daily |
3 |
= |
Weekly |
4 |
= |
Biweekly |
5 |
= |
Semimonthly |
10 |
= |
Twenty-two per Year |
9 |
= |
Thirteen per Year |
6 |
= |
Monthly |
8 |
= |
Ten per Year |
7 |
= |
Quarterly |
|
CLASS1 |
String*6 |
Class 1 |
Mask: %-6N |
CLASS2 |
String*6 |
Class 2 |
Mask: %-6N |
CLASS3 |
String*6 |
Class 3 |
Mask: %-6N |
CLASS4 |
String*6 |
Class 4 |
Mask: %-6N |
SERIAL |
Long |
Bank Serial Number |
|
CALCSEQ |
Long |
Calculation Sequence |
|
POSTSEQ |
Long |
Posting Sequence |
|
PRPERIOD |
Integer |
Payroll Period |
|
TRANSAMT |
BCD*10.3 |
Transaction Amt |
|
GLSEG1 |
String*15 |
G/L Segment One |
|
GLSEG2 |
String*15 |
G/L Segment Two |
|
GLSEG3 |
String*15 |
G/L Segment Three |
|
BANKACCT |
String*45 |
Bank General Ledger Account |
|
WORKPROV |
Integer |
Province of Employment |
List:14 entries
1 |
= |
Alberta |
2 |
= |
British Columbia |
3 |
= |
Manitoba |
4 |
= |
New Brunswick |
5 |
= |
Newfoundland & Labrador |
6 |
= |
Northwest Territories |
7 |
= |
Nova Scotia |
8 |
= |
Ontario |
9 |
= |
Outside Canada |
10 |
= |
Prince Edward Island |
11 |
= |
Quebec |
12 |
= |
Saskatchewan |
13 |
= |
Yukon Territory |
14 |
= |
Nunavut |
|
TAXPLAN |
String*6 |
Employee EI ID |
|
EXRATE |
BCD*8.7 |
Exchange Rate |
|
RATEOP |
Integer |
Rate Operator |
|
EFTSTAT |
Integer |
EFT Status |
List:3 entries
0 |
= |
Not to be EFTed |
1 |
= |
Not EFTed |
2 |
= |
EFTed |
|
EFTRUNSEQ |
Long |
EFT Run Sequence |
|
VALUES |
Long |
Number of Optional Fields |
|
GLDRDWNLNK |
BCD*10.0 |
G/L Drilldown Link |
|
OTOVERRIDE |
Boolean |
Overtime Override |
|
OTCALCTYPE |
Integer |
Overtime Calculation |
List:6 entries
0 |
= |
Hourly Rate |
1 |
= |
Minimum Wage |
2 |
= |
Shift Rate |
3 |
= |
Regular Rate-Hourly |
4 |
= |
Regular Rate-Salary Fixed Hours |
5 |
= |
Regular Rate-Salary Fluctuating Hours |
|
SWEXTERNTC |
Integer |
Based on External Timecards |
List:2 entries
|
SWJOB |
Boolean |
Job Related |
|
EXRATEDATE |
Date |
Exchange Rate Date |
|
ORGTYPE |
Integer |
Original Type |
List:5 entries
1 |
= |
System Cheque |
2 |
= |
Manual Cheque |
3 |
= |
Adjustment |
4 |
= |
History Entry |
5 |
= |
Reversed Cheque |
|
CSEFTSTAT |
Integer |
Child Support EFT Status |
List:2 entries
|
GLSEG4 |
String*15 |
G/L Segment Four |
|
GLSEG5 |
String*15 |
G/L Segment Five |
|
GLSEG6 |
String*15 |
G/L Segment Six |
|
|