View: E/D/T List

RotoID: CP0084
Table: CPCALE
Protocol: Flat
DLL:CPCALE

Keys: 1

Title Fields

Level by E/D/T LEVELSORTCODEEARDEDTYPEEDT

Fields: 36

Field Index Type Title Attributes Presentation

LEVEL 1 Integer E/D/T Level E A K R 
SORTCODE 2 Integer Sort Code E A K R  List:10 entries
1 = Accrual
2 = Earning
3 = Advance
4 = Deduction
5 = Expense Reimbursement
6 = Benefit
7 = Federal Tax
8 = Provincial Tax
9 = Local Tax
10 = User Tax
EARDEDTYPE 3 Integer E/D/T Type E A K R  List:16 entries
1 = Salary & Wages
2 = Reported Tips
3 = Allocated Tips
7 = Vacation
8 = Sick
9 = Banked Time
10 = Disability
13 = Cash
14 = Noncash
18 = Insurance Tax
19 = Income Tax
20 = Employment Tax
21 = Pension Plan Tax
22 = Health Tax
23 = Other Tax
25 = n/a
EDT 4 String*6 E/D/T ID E A K R  Mask: %-6N
CATEGORY 5 Integer Category E A  List:10 entries
1 = Accrual
2 = Earning
3 = Advance
4 = Deduction
5 = Expense Reimbursement
6 = Benefit
7 = Federal Tax
8 = Provincial Tax
9 = Local Tax
10 = User Tax
EAMOUNT 6 BCD*10.3 Employee Amount E A 
RAMOUNT 7 BCD*10.3 Employer Amount E A 
NORMWAGES 8 BCD*10.3 Normal Wages E A 
SUPPWAGES 9 BCD*10.3 Supplemental Wages E A 
TAXNOWH 10 BCD*10.3 Taxable Wages, No Withholding E A 
HOURS 11 BCD*4.3 Hours E A 
GLSEG1 12 String*15 G/L Segment One E A  Mask: %-15N
GLSEG2 13 String*15 G/L Segment Two E A  Mask: %-15N
GLSEG3 14 String*15 G/L Segment Three E A  Mask: %-15N
TCENTRY 15 Integer No. of TC/MC Dtl Entries E A 
TAXTIPS 16 BCD*10.3 Taxable Tips E A 
PROCESSED 17 Boolean E/D/T Processed? E A 
TAXHASCOMM 18 Boolean Tax Has Commissions E A 
ECALCMETH 19 Integer Employee Calculation Method E A 
COSTCTRTOT 20 BCD*10.3 Cost Ctr Expense For Taxes E A 
POSTSTOGL 21 Boolean Posts to G/L? E A 
NONPERPYMT 22 Boolean Nonperiodic Pymt Flag E A 
TAXNONPER 23 BCD*10.3 Nonperiodic Pymt Amt E A 
TAXEARNBD 24 BCD*10.3 Subject to income tax before deductions E A 
POOLEDTIPS 25 BCD*10.3 Pooled Tips E A 
OTHOURS 26 BCD*4.3 Overtime Hours E A 
DISTCODE 27 String*6 Distribution Code E A  Mask: %-6N
DISTRNAME 28 String*15 Distribution Description E A 
GLSEG4 29 String*15 G/L Segment Four E A  Mask: %-15N
GLSEG5 30 String*15 G/L Segment Five E A  Mask: %-15N
GLSEG6 31 String*15 G/L Segment Six E A  Mask: %-15N
TAXNONDED 32 BCD*10.3 Non-periodic Deduction E A 
PAYDOWNDED 33 Boolean Repayment Deduction Flag E A 
RPETAX 34 BCD*10.3 Repayment Employee Tax E A 
TAXREPAY 35 BCD*10.3 Repayment Deduction Before Tax E A 
CEILWAGE 36 BCD*10.3 Ceiling Wage E A