View: E/D/T List

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

Compositions: 0

Keys: 1

Title  Fields

Level by E/D/T  LEVEL, SORTCODE, EARDEDTYPE, EDT

Fields: 26

Field  Index  Type  Title  Attributes  Presentation

LEVEL  Integer  E/D/T Level  E A K R   
SORTCODE  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  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=
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  String*6  E/D/T ID  E A K R  Mask: %-6N
CATEGORY  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  BCD*10.3  Employee Amount  E A   
RAMOUNT  BCD*10.3  Employer Amount  E A   
NORMWAGES  BCD*10.3  Normal Wages  E A   
SUPPWAGES  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   

This page was generated on 2008-May-02

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