Table: Earnings/Deductions

Table: UPDTLM
View: UP0007
Record length: 1820
Flags: A R 

Keys: 2

Title  Flags  Fields

Earning/Deduction  EARNDED
Category  CATEGORY, EARDEDTYPE, EARNDED

Fields: 252

Field  Type  Title  Presentation 

EARNDED  String*6  Earning/Deduction  Mask: %-6N
AUDTDATE  Date     
AUDTTIME  Time     
AUDTUSER  String*8     
AUDTORG  String*6     
LONGDESC  String*60  Earning/Deduction Description   
SHORTDESC  String*15  Earning/Deduction Short Description   
INACTIVE  Boolean  Inactive   
ASOF  Date  Inactive As Of   
LASTMAINT  Date  Last Maintained   
CATEGORY  Integer  Category  List: 6 entries
1=Accrual
2=Earning
3=Advance
4=Deduction
5=Expense Reimbursement
6=Benefit
EARDEDTYPE  Integer  Type  List: 3 entries
1=Salary & Wages
2=Reported Tips
3=Allocated Tips
FREQUENCY  Integer  Frequency  List: 10 entries
1=Float
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
STARTS  Integer  Starts  List: 4 entries
1=Specific Month/Day
2=Date of Hire
3=Months after Hire
4=Days after Hire
STARTMONTH  Integer  Start Month   
STARTDAY  Integer  Start Day   
ENDS  Date  Ends   
PRNTONCHK  Boolean  Print On Check   
PRNTIF0  Boolean  RESERVED Print If Current Zero.   
PRNTYTDIF0  Boolean  RESERVED Print YTD If Current Zero   
ECALCMETH  Integer  Employee Calculation Method  List: 7 entries
2=Flat
3=Fixed
4=Hourly Rate
5=Amount per Hour
6=Piece Rate Table
7=Percentage of Base
8=Sales Commission Table
EW2BOX  Integer  Employee W-2 Box  List: 13 entries
1=Not Applicable
2=Other Information Box
3=Dependent Care
4=Employee 401(k)
5=Employee 403(b)
6=Employee 408(k)(6)
7=Employee 457
8=Employee 501(c)(18)(d)
9=SIMPLE Retirement Acct
10=Deferrals under section 409A
11=Roth contributions to Employee 401(k)
12=Roth contributions to Employee 403(b)
13=Health Savings Account
ERATE  BCD*9.5  Employee Rate   
EANNUALMAX  BCD*10.3  Employee Annual Maximum   
EDAILYMIN  BCD*10.3  Employee Daily Minimum   
EDAILYMAX  BCD*10.3  Employee Daily Maximum   
EWEEKLYMIN  BCD*10.3  Employee Weekly Minimum   
EWEEKLYMAX  BCD*10.3  Employee Weekly Maximum   
EBIWKLYMIN  BCD*10.3  Employee Biweekly Minimum   
EBIWKLYMAX  BCD*10.3  Employee Biweekly Maximum   
ESEMIMNMIN  BCD*10.3  Employee Semimonthly Minimum   
ESEMIMNMAX  BCD*10.3  Employee Semimonthly Maximum   
EMNTHLYMIN  BCD*10.3  Employee Monthly Minimum   
EMNTHLYMAX  BCD*10.3  Employee Monthly Maximum   
EQRTRLYMIN  BCD*10.3  Employee Quarterly Minimum   
EQRTRLYMAX  BCD*10.3  Employee Quarterly Maximum   
E10PPPYMIN  BCD*10.3  Employee Ten Period/Year Minimum   
E10PPPYMAX  BCD*10.3  Employee Ten Period/Year Maximum   
E13PPPYMIN  BCD*10.3  Employee Thirteen Period/Year Minimum   
E13PPPYMAX  BCD*10.3  Employee Thirteen Period/Year Maximum   
E22PPPYMIN  BCD*10.3  Employee Twentytwo Period/Year Minimum   
E22PPPYMAX  BCD*10.3  Employee Twentytwo Period/Year Maximum   
ELIMITBASE  Integer  Employee Base Limit  List: 1 entries
1=No Limit
WGBRACK1  BCD*10.3  Wage Bracket 1   
WGADDAMT1  BCD*10.3  Add Amount 1   
WGPCTOVR1  BCD*5.5  Percnt. of Excess 1   
WGBRACK2  BCD*10.3  Wage Bracket 2   
WGADDAMT2  BCD*10.3  Add Amount 2   
WGPCTOVR2  BCD*5.5  Percnt. of Excess 2   
WGBRACK3  BCD*10.3  Wage Bracket 3   
WGADDAMT3  BCD*10.3  Add Amount 3   
WGPCTOVR3  BCD*5.5  Percnt. of Excess 3   
WGBRACK4  BCD*10.3  Wage Bracket 4   
WGADDAMT4  BCD*10.3  Add Amount 4   
WGPCTOVR4  BCD*5.5  Percnt. of Excess 4   
WGBRACK5  BCD*10.3  Wage Bracket 5   
WGADDAMT5  BCD*10.3  Add Amount 5   
WGPCTOVR5  BCD*5.5  Percnt. of Excess 5   
WGBRACK6  BCD*10.3  Wage Bracket 6   
WGADDAMT6  BCD*10.3  Add Amount 6   
WGPCTOVR6  BCD*5.5  Percnt. of Excess 6   
WGBRACK7  BCD*10.3  Wage Bracket 7   
WGADDAMT7  BCD*10.3  Add Amount 7   
WGPCTOVR7  BCD*5.5  Percnt. of Excess 7   
WGBRACK8  BCD*10.3  Wage Bracket 8   
WGADDAMT8  BCD*10.3  Add Amount 8   
WGPCTOVR8  BCD*5.5  Percnt. of Excess 8   
WGBRACK9  BCD*10.3  Wage Bracket 9   
WGADDAMT9  BCD*10.3  Add Amount 9   
WGPCTOVR9  BCD*5.5  Percnt. of Excess 9   
WGBRACK10  BCD*10.3  Wage Bracket 10   
WGADDAMT10  BCD*10.3  Add Amount 10   
WGPCTOVR10  BCD*5.5  Percnt. of Excess 10   
WGBRACK11  BCD*10.3  Wage Bracket 11   
WGADDAMT11  BCD*10.3  Add Amount 11   
WGPCTOVR11  BCD*5.5  Percnt. of Excess 11   
WGBRACK12  BCD*10.3  Wage Bracket 12   
WGADDAMT12  BCD*10.3  Add Amount 12   
WGPCTOVR12  BCD*5.5  Percnt. of Excess 12   
WGBRACK13  BCD*10.3  Wage Bracket 13   
WGADDAMT13  BCD*10.3  Add Amount 13   
WGPCTOVR13  BCD*5.5  Percnt. of Excess 13   
WGBRACK14  BCD*10.3  Wage Bracket 14   
WGADDAMT14  BCD*10.3  Add Amount 14   
WGPCTOVR14  BCD*5.5  Percnt. of Excess 14   
WGBRACK15  BCD*10.3  Wage Bracket 15   
WGADDAMT15  BCD*10.3  Add Amount 15   
WGPCTOVR15  BCD*5.5  Percnt. of Excess 15   
WGBRACK16  BCD*10.3  Wage Bracket 16   
WGADDAMT16  BCD*10.3  Add Amount 16   
WGPCTOVR16  BCD*5.5  Percnt. of Excess 16   
WGBRACK17  BCD*10.3  Wage Bracket 17   
WGADDAMT17  BCD*10.3  Add Amount 17   
WGPCTOVR17  BCD*5.5  Percnt. of Excess 17   
WGBRACK18  BCD*10.3  Wage Bracket 18   
WGADDAMT18  BCD*10.3  Add Amount 18   
WGPCTOVR18  BCD*5.5  Percnt. of Excess 18   
WGBRACK19  BCD*10.3  Wage Bracket 19   
WGADDAMT19  BCD*10.3  Add Amount 19   
WGPCTOVR19  BCD*5.5  Percnt. of Excess 19   
WGBRACK20  BCD*10.3  Wage Bracket 20   
WGADDAMT20  BCD*10.3  Add Amount 20   
WGPCTOVR20  BCD*5.5  Percnt. of Excess 20   
RCALCMETH  Integer  Employer Calcuation Method  List: 6 entries
2=Flat
5=Amount per Hour
6=Piece Rate Table
7=Percentage of Base
8=Sales Commission Table
9=Wage Bracket Table
RW2BOX  Integer  Employer W-2 Box  List: 20 entries
1=Not Applicable
2=Other Information Box
3=Allocated Tips
4=Dependent Care
5=Fringe Benefit
6=Cost of Group Term over $50,000
7=Uncollected Soc Sec Tax on Cost of Group Term over $50,000
8=Uncollected Medicare Tax on Cost of Group Term over $50,000
9=Sick Pay Not Includible as Income (3rd Party Sick Pay)
10=Excess Golden
11=Allowed per Diem
12=Nonqualified Plan
13=Section 457
14=Excludable Moving Expense Reimbursements
15=Nontaxable combat pay
16=Medical Savings Acct
17=Adoption Benefit
18=Non-statutory Stock Options
19=Health Savings Account
20=Income under section 409A
RRATE  BCD*9.5  Employer Rate   
RANNUALMAX  BCD*10.3  Employer Annual Maximum   
RDAILYMIN  BCD*10.3  Employer Daily Minimum   
RDAILYMAX  BCD*10.3  Employer Daily Maximum   
RWEEKLYMIN  BCD*10.3  Employer Weekly Minimum   
RWEEKLYMAX  BCD*10.3  Employer Weekly Maximum   
RBIWKLYMIN  BCD*10.3  Employer Biweekly Minimum   
RBIWKLYMAX  BCD*10.3  Employer Biweekly Maximum   
RSEMIMNMIN  BCD*10.3  Employer Semimonthly Minimum   
RSEMIMNMAX  BCD*10.3  Employer Semimonthly Maximum   
RMNTHLYMIN  BCD*10.3  Employer Monthly Minimum   
RMNTHLYMAX  BCD*10.3  Employer Monthly Maximum   
RQRTRLYMIN  BCD*10.3  Employer Quarterly Minimum   
RQRTRLYMAX  BCD*10.3  Employer Quarterly Maximum   
R10PPPYMIN  BCD*10.3  Employer Ten Per/Year Minimum   
R10PPPYMAX  BCD*10.3  Employer Ten Per/Year Maximum   
R13PPPYMIN  BCD*10.3  Employer Thirteen Per/Year Minimum   
R13PPPYMAX  BCD*10.3  Employer Thirteen Per/Year Maximum   
R22PPPYMIN  BCD*10.3  Employer TwentyTwo Per/Year Minimum   
R22PPPYMAX  BCD*10.3  Employer TwentyTwo Per/Year Maximum   
RLIMITBASE  Integer  Employer Base Limit  List: 1 entries
1=No Limit
ALLOWWCC  Boolean  Subject to Workers' Compensation   
COMMAMT1  BCD*10.3  Commission Amt. 1   
COMMPCT1  BCD*5.5  Commission Pct. 1   
COMMAMT2  BCD*10.3  Commission Amt. 2   
COMMPCT2  BCD*5.5  Commission Pct. 2   
COMMAMT3  BCD*10.3  Commission Amt. 3   
COMMPCT3  BCD*5.5  Commission Pct. 3   
COMMAMT4  BCD*10.3  Commission Amt. 4   
COMMPCT4  BCD*5.5  Commission Pct. 4   
COMMAMT5  BCD*10.3  Commission Amt. 5   
COMMPCT5  BCD*5.5  Commission Pct. 5   
COMMPCTX  BCD*5.5  Commission Amt. excess   
PIECNUM1  BCD*10.3  Piece count 1   
PIECAMT1  BCD*9.5  Piece amount 1   
PIECNUM2  BCD*10.3  Piece count 2   
PIECAMT2  BCD*9.5  Piece amount 2   
PIECNUM3  BCD*10.3  Piece count 3   
PIECAMT3  BCD*9.5  Piece amount 3   
PIECNUM4  BCD*10.3  Piece count 4   
PIECAMT4  BCD*9.5  Piece amount 4   
PIECNUM5  BCD*10.3  Piece count 5   
PIECAMT5  BCD*9.5  Piece amount 5   
PIECAMTX  BCD*9.5  Max Piece Rate Amt.   
TIPDISB  Boolean  Tip Disbursement   
PAYDOWNDED  Boolean  Repayment Deduction   
REPAYID  String*6  Advance to Be Repaid   
CARRYOVER  Integer  Carry-over  List: 4 entries
1=Specific Month/Day
2=Date of Hire
3=Months after Hire
4=Days after Hire
COVERDAY  Integer  Carry-over Day   
COVERMONTH  Integer  Carry-over Month   
POSTLIAB  Boolean  Post Liab.   
SVCYEAR1  Integer  Service Year 1   
BEGHRS1  BCD*10.3  Beginning Hours 1   
INCRHRS1  BCD*9.5  Increment Hours 1   
MAXACCR1  BCD*10.3  Max. Annual Accrual 1   
MAXCARRY1  BCD*10.3  Max. Carry-over Hours 1   
SVCYEAR2  Integer  Service Year 2   
BEGHRS2  BCD*10.3  Beginning Hours 2   
INCRHRS2  BCD*9.5  Increment Hours 2   
MAXACCR2  BCD*10.3  Max. Annual Accrual 2   
MAXCARRY2  BCD*10.3  Max. Carry-over Hours 2   
SVCYEAR3  Integer  Service Year 3   
BEGHRS3  BCD*10.3  Beginning Hours 3   
INCRHRS3  BCD*9.5  Increment Hours 3   
MAXACCR3  BCD*10.3  Max. Annual Accrual 3   
MAXCARRY3  BCD*10.3  Max. Carry-over Hours 3   
SVCYEAR4  Integer  Service Year 4   
BEGHRS4  BCD*10.3  Beginning Hours 4   
INCRHRS4  BCD*9.5  Increment Hours 4   
MAXACCR4  BCD*10.3  Max. Annual Accrual 4   
MAXCARRY4  BCD*10.3  Max. Carry-over Hours 4   
LEVEL  Integer  Level   
LISTUSEBHI  Integer  Base Hours List Use   
REGULARBHI  Integer  Base Hours Regular   
OVRTIMEBHI  Integer  Base Hours Overtime   
LISTUSEBEI  Integer  Base Earnings List Use   
REGULARBEI  Integer  Base Earnings Regular   
OVRTIMEBEI  Integer  Base Earnings Overtime   
SHIFTBEI  Integer  Base Earnings Shift   
LISTUSEBDI  Integer  Base Deductions List Use   
LISTUSEBTI  Integer  Base Tax List Use   
LISTUSETTW  Integer  List Use of Type of Taxable Wages   
WHMETHTTW  Integer  Withholding Method for Type of Taxable Wages  List: 3 entries
1=Regular Rate
4=Taxable, No Withholding
6=Supplemental Withholding
LISTUSETDB  Integer  Take Deduction Before List Use   
ET4BOX  Integer  RESERVED - Cdn Only   
RT4BOX  Integer  RESERVED - Cdn Only   
ER1BOX  Integer  RESERVED - Cdn Only   
RR1BOX  Integer  RESERVED - Cdn Only   
EASSOCW2SW  Boolean  Associate W-2 printing   
EASSOCTAX  String*6  Associated Tax   
RASSOCW2SW  Boolean  Associate W-2 printing   
RASSOCTAX  String*6  Associated Tax   
POSTBENE  Boolean  Post Benefit   
PAYACCRUAL  Boolean  Pay Accrual   
NONPERPYMT  Boolean  RESERVED - Cdn Only   
LINKEARN  String*6  Linked Earning   
VALUES  Long  Number of Optional Fields   
SWFLSA  Boolean  Include in FLSA Overtime Calc   
COMMINCREM  Boolean  Progressive Calc - Commissions   
WGANNUALIZ  Boolean  Annualized Wage Brackets   
WGBRINCREM  Boolean  Progressive Calc - Wage Brackets   
PIECINCREM  Boolean  Progressive Calc - Piece Rate   
ELIFETMMAX  BCD*10.3  Employee Lifetime Maximum   
RLIFETMMAX  BCD*10.3  Employer Lifetime Maximum   
E2NDRATEIN  Integer  Employee Secondary Rate Effective  List: 2 entries
0=Never
1=After Annual Maximum Reached
R2NDRATEIN  Integer  Employer Secondary Rate Effective  List: 2 entries
0=Never
1=After Annual Maximum Reached
E2NDRATE  BCD*9.5  Employee Secondary Rate   
R2NDRATE  BCD*9.5  Employer Secondary Rate   
SVCYEAR5  Integer  Service Year 5   
BEGHRS5  BCD*10.3  Beginning Hours 5   
INCRHRS5  BCD*9.5  Increment Hours 5   
MAXACCR5  BCD*10.3  Max. Annual Accrual 5   
MAXCARRY5  BCD*10.3  Max. Carry-over Hours 5   
SVCYEAR6  Integer  Service Year 6   
BEGHRS6  BCD*10.3  Beginning Hours 6   
INCRHRS6  BCD*9.5  Increment Hours 6   
MAXACCR6  BCD*10.3  Max. Annual Accrual 6   
MAXCARRY6  BCD*10.3  Max. Carry-over Hours 6   
SVCYEAR7  Integer  Service Year 7   
BEGHRS7  BCD*10.3  Beginning Hours 7   
INCRHRS7  BCD*9.5  Increment Hours 7   
MAXACCR7  BCD*10.3  Max. Annual Accrual 7   
MAXCARRY7  BCD*10.3  Max. Carry-over Hours 7   
SVCYEAR8  Integer  Service Year 8   
BEGHRS8  BCD*10.3  Beginning Hours 8   
INCRHRS8  BCD*9.5  Increment Hours 8   
MAXACCR8  BCD*10.3  Max. Annual Accrual 8   
MAXCARRY8  BCD*10.3  Max. Carry-over Hours 8   
SVCYEAR9  Integer  Service Year 9   
BEGHRS9  BCD*10.3  Beginning Hours 9   
INCRHRS9  BCD*9.5  Increment Hours 9   
MAXACCR9  BCD*10.3  Max. Annual Accrual 9   
MAXCARRY9  BCD*10.3  Max. Carry-over Hours 9   
SVCYEAR10  Integer  Service Year 10   
BEGHRS10  BCD*10.3  Beginning Hours 10   
INCRHRS10  BCD*9.5  Increment Hours 10   
MAXACCR10  BCD*10.3  Max. Annual Accrual 10   
MAXCARRY10  BCD*10.3  Max. Carry-over Hours 10   
CCOVERRIDE  Boolean  Cost Center Override Based on Calc Base   
BILLINGS  Long  Billing Rates   
BILLPCT1  BCD*5.5  Billing Percentage 1   
BILLPCT2  BCD*5.5  Billing Percentage 2   
BILLPCT3  BCD*5.5  Billing Percentage 3   
BILLPCT4  BCD*5.5  Billing Percentage 4   
BILLPCT5  BCD*5.5  Billing Percentage 5   
BILLPCT6  BCD*5.5  Billing Percentage 6   
MAXONREM  Boolean  Calc. Max. Carry-over based on Remaining Balance   

This page was generated on 2009-Nov-19

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