Application: US Payroll 7.3A

Views: 138

RotoID	Tables	Title	DLL	Compositions

UP0001		Payroll Activation	UPACTV
UP0006	UPCLAS	Class Codes	UPCLAS
UP0007	UPDTLM	Earnings/Deductions	UPDTLM	UP0015, UP0015, UP0015, UP0015, UP0015, UP0009, UP0123, UP0040
UP0008	UPEMPD	Employee Earnings/Deductions	UPEMPD	UP0014, UP0125, UP0041
UP0009	UPDIST	Distribution	UPDIST	UP0029, UP0007
UP0010	UPEMPT	Employee Taxes	UPEMPT	UP0014, UP0062, UP0126
UP0012	UPHSTH	Employee History Control	UPHSTH	UP0013
UP0013	UPHSHO	Employee History Optional Field Values	UPHSHO	UP0012
UP0014	UPEMPL	Employees	UPEMPL	UP0008, UP0010, UP0053, UP0201, UP0122, UP0118, UP0119
UP0015	UPINCL	Include List	UPINCL	UP0007, UP0029
UP0016		US Payroll Integrity Checker	UPDCHK
UP0017	UPSTAT	Status	UPSTAT
UP0018		Delete Inactive Records	UPMAIN
UP0019	UPMCHD	Manual Check Header	UPMCHD	UP0020, UP0129
UP0020	UPMCDT	Manual Check Detail	UPMCDT	UP0019, UP0130, UP0043
UP0021	UPHHAU	History Audit Headers	UPHHAU	UP0024, UP0135
UP0022	UPOTSC	Overtime Schedules	UPOTSC
UP0023	UPOPTS	Company Options	UPOPTS
UP0024	UPHDAU	History Audit Details	UPHDAU	UP0021, UP0136
UP0025	UPSHFT	Shift Differential Schedule	UPSHFT	UP0038
UP0026		Concurrency controller	UPCTRL
UP0027	UPWRKC	Work Classification Codes	UPWRKC
UP0029	UPTXMS	Company Payroll Taxes	UPTXMS	UP0015, UP0015, UP0015, UP0009, UP0124
UP0031	UPTCHD	Timecard Header	UPTCHD	UP0032, UP0127
UP0032	UPTCDT	Timecard Detail	UPTCDT	UP0031, UP0128, UP0042
UP0036	UPWCCH	Workers Compensation Master	UPWCCH	UP0037
UP0037	UPWCCD	Workers Compensation Codes	UPWCCD	UP0036
UP0038	UPSHFD	Shift Differential Detail	UPSHFD	UP0025, UP0039
UP0039	UPSHFB	Shift Differential Billing Detail	UPSHFB	UP0038
UP0040	UPDTLB	Earnings Billing Detail	UPDTLB	UP0007
UP0041	UPEMDB	Employee Billing Details	UPEMDB	UP0008
UP0042	UPTCJB	Timecard Job Details	UPTCJB	UP0032, UP0141
UP0043	UPMCJB	Manual Check Job Details	UPMCJB	UP0020, UP0142
UP0044	UPUTJB	Employee Timecard Job Details	UPUTJB	UP0103, UP0143
UP0045	UPESLH	Employee Selection Lists	UPESLH	UP0046
UP0046	UPESLD	Employee Selection List Members	UPESLD	UP0045
UP0047	UPYTDS	Employee YTD Summaries	UPYTDS
UP0048	UPCHKH	Check Header	UPCHKH	UP0049, UP0052, UP0202, UP0133, UP0134
UP0049	UPCHKD	Check Details	UPCHKD	UP0048, UP0134, UP0056
UP0050		Payroll Posting Superview	UPPOST
UP0051	UPGLBM	Globally Modify List	UPGLBM
UP0052	UPCHKC	Check Comment Detail	UPCHKC	UP0048
UP0053	UPEMPC	Employee Notes	UPEMPC	UP0014
UP0056	UPCHJB	Check Job Details	UPCHJB	UP0049, UP0144
UP0057	UPGLREF	G/L Reference Integration	UPGLREF
UP0058		Globally Modify Process	UPGMET	UP0008, UP0041, UP0010
UP0059		G/L Acct Desc Report Extraction	UPGLDX
UP0060	UPGLDD	G/L Acct Desc Report List	UPGLDD
UP0062	UPEMTF	Employee Tax Fields	UPEMTF	UP0010
UP0064	UPXCPT	Calc PR Exceptions	UPXCPT
UP0065		Process Manual Checks	UPPMAN	UP0138
UP0077	UPCHKS	Check History Summary	UPCHKS
UP0078		Print Checks Control	UPPCKS
UP0079	UPPCKH	Print Checks Header Extension	UPPCKH	UP0080
UP0080	UPPCKD	Print Checks Detail Extension	UPPCKD	UP0079
UP0081		Earnings Hours Report	UPERHR
UP0082		Check Reconciliation	UPCREC
UP0083		Calculate Payroll	UPCALC	UP0137
UP0084	UPCALE	E/D/T List	UPCALE
UP0085	UPCALT	Timecard List	UPCALT
UP0086	UPCALA	Cost Center Allocations	UPCALA
UP0087	UPCALO	Timecard Earnings List	UPCALO
UP0088	UPCHKR	Check Run Header	UPCHKR	UP0139
UP0089	UPPCKF	Print Checks Trans.	UPPCKF
UP0093	UPEHRP	Earnings Hourly Report	UPEHRP
UP0094		Payroll Register G/L Accounts	UPPREG
UP0097	PRRSTRT	Restart	PRRSTRT
UP0099	UPDTLX	Earnings/Deductions (virtual)	UPDTLX
UP0100	UPTXMC	Temporary Tax List	UPTXMC
UP0101		Empl Timecards Transfer Ctrl	UPUTTR
UP0102	UPUTCH	Employee Timecard Header	UPUTCH	UP0103, UP0131
UP0103	UPUTCD	Employee Timecard Detail	UPUTCD	UP0102, UP0132, UP0044
UP0104		Employee Activity	UPEMAC
UP0105		Find Duplicate SSN	UPESIN
UP0106	UPEDUP	Duplicate SSN	UPEDUP
UP0107		Create G/L Batch	UPGLTR
UP0108		Copy Timecard	UPTCCP
UP0109		Employee Sel Lists Superview	UPESLC	UP0045, UP0046
UP0110	UPINCX	Include List (virtual)	UPINCX
UP0111		G/L Drill Down	UPDLDN
UP0112		Check Selection Superview	UPCHKX
UP0113	UPCHKL	Check Selection List	UPCHKL
UP0115	UPACCO	Accrual Carry-over Log File	UPACCO
UP0116	UPLIMH	Deduction Groups	UPLIMH	UP0117
UP0117	UPLIMD	Deduction Group Details	UPLIMD	UP0116
UP0118	UPEMCS	Employee Garnishment	UPEMCS	UP0014
UP0119	UPECMM	Employee Comments	UPECMM	UP0014
UP0120	UPOFH	Optional Field Locations	UPOFH	UP0121
UP0121	UPOFD	Optional Field Values	UPOFD	UP0120
UP0122	UPEMPO	Employee Optional Field Values	UPEMPO	UP0014
UP0123	UPDTLO	Earnings/Deductions Opt Fields	UPDTLO	UP0007
UP0124	UPTXMO	Taxes Optional Field Values	UPTXMO	UP0029
UP0125	UPEMDO	Empl Earn/Ded Optional Fields	UPEMDO	UP0008
UP0126	UPEMTO	Empl Taxes Optional Fields	UPEMTO	UP0010
UP0127	UPTCHO	Timecard Optional Field Values	UPTCHO	UP0031
UP0128	UPTCDO	Timecard Details Optional Field Values	UPTCDO	UP0032
UP0129	UPMCHO	Manual Check Optional Field Values	UPMCHO	UP0019
UP0130	UPMCDO	MC Details Opt Field Values	UPMCDO	UP0020
UP0131	UPUTHO	Empl Timecard Optional Fields	UPUTHO	UP0102
UP0132	UPUTDO	Empl Timecard Details Opt Flds	UPUTDO	UP0103
UP0133	UPCHHO	Check Header Optional Field Values	UPCHHO	UP0048
UP0134	UPCHDO	Check Details Optional Fields	UPCHDO	UP0049
UP0135	UPHHOA	History Audit Header Opt Fields	UPHHOA	UP0021
UP0136	UPHDOA	History Audit Detail Opt Fields	UPHDOA	UP0024
UP0137	UPCLCO	Calculate Payroll Optional Fields	UPCLCO	UP0083
UP0138	UPPMCO	Process Manual Check Optional Fields	UPPMCO	UP0065
UP0139	UPCHKO	Check Run Optional Field Values	UPCHKO	UP0088
UP0140		PR Optional Field Callbacks	UPOFCMD
UP0141	UPTCJO	Timecard Jobs Optional Field Values	UPTCJO	UP0042
UP0142	UPMCJO	Manual Check Jobs Opt Fields	UPMCJO	UP0043
UP0143	UPUTJO	Employee TC Jobs Opt Field Values	UPUTJO	UP0044
UP0144	UPCHJO	Check Jobs Optional Fields Values	UPCHJO	UP0056
UP0200	UPCOBK	Company EFT Banks	UPCOBK
UP0201	UPEMBK	Employee EFT Banks	UPEMBK	UP0014
UP0202	UPCHKE	Check EFT Details	UPCHKE	UP0048
UP0203		EFT Run Superview	UPERUN	UP0212
UP0204	UPEREG	EFT Run History Header	UPEREG	UP0205
UP0205	UPETRN	EFT Run History Details	UPETRN	UP0204
UP0206	UPEMULH	EFT Combine File Header	UPEMULH	UP0207
UP0207	UPEMULD	EFT Combine File Detail	UPEMULD	UP0206
UP0208	UPELST	EFT Combine File List	UPELST
UP0209	UPEMRGH	EFT Files Combine Setup Header	UPEMRGH	UP0210
UP0210	UPEMRGD	EFT Files Combine Setup Detail	UPEMRGD	UP0209
UP0211		EFT Combine Superview	UPECOMB	UP0208
UP0212			UPDDFUN
UP0213	UPDDOPTS	Direct Deposit Options	UPDDOPTS
UP0220	UPAUDM	Delete Inactive Records Audit	UPAUDM	UP0221, UP0222
UP0221	UPAUDMI	Delete Audit Inactive Details	UPAUDMI	UP0220
UP0222	UPAUDMH	Delete Audit Transaction Details	UPAUDMH	UP0220
UP0223	UPAUDE	Update Earn/Ded Audit	UPAUDE	UP0224
UP0224	UPAUDED	Update Earn/Ded Audit Details	UPAUDED	UP0223
UP0225	UPAUDT	Update Taxes Audit	UPAUDT	UP0226
UP0226	UPAUDTD	Update Taxes Audit Details	UPAUDTD	UP0225
UP0227	UPAUDA	Assign Earn/Ded Audit	UPAUDA	UP0228
UP0228	UPAUDAD	Assign Earn/Ded Audit Details	UPAUDAD	UP0227, UP0229
UP0229	UPAUDAB	Assign Earn/Ded Audit Billing	UPAUDAB	UP0228
UP0230	UPAUDS	Assign Tax Audit	UPAUDS	UP0231
UP0231	UPAUDSD	Tax Audit Details	UPAUDSD	UP0230

Tables: 105

Table	RotoID	Title

UPACCO	UP0115	Accrual Carry-over Log File
UPAUDA	UP0227	Assign Earn/Ded Audit
UPAUDAB	UP0229	Assign Earn/Ded Audit Billing
UPAUDAD	UP0228	Assign Earn/Ded Audit Details
UPAUDE	UP0223	Update Earn/Ded Audit
UPAUDED	UP0224	Update Earn/Ded Audit Details
UPAUDM	UP0220	Delete Inactive Records Audit
UPAUDMH	UP0222	Delete Audit Transaction Details
UPAUDMI	UP0221	Delete Audit Inactive Details
UPAUDS	UP0230	Assign Tax Audit
UPAUDSD	UP0231	Tax Audit Details
UPAUDT	UP0225	Update Taxes Audit
UPAUDTD	UP0226	Update Taxes Audit Details
UPCALA	UP0086	Cost Center Allocations
UPCHDO	UP0134	Check Details Optional Fields
UPCHHO	UP0133	Check Header Optional Field Values
UPCHJB	UP0056	Check Job Details
UPCHJO	UP0144	Check Jobs Optional Fields Values
UPCHKC	UP0052	Check Comment Detail
UPCHKD	UP0049	Check Details
UPCHKE	UP0202	Check EFT Details
UPCHKH	UP0048	Check Header
UPCHKL	UP0113	Check Selection List
UPCHKO	UP0139	Check Run Optional Field Values
UPCHKR	UP0088	Check Run Header
UPCHKS	UP0077	Check History Summary
UPCLAS	UP0006	Class Codes
UPCLCO	UP0137	Calculate Payroll Optional Fields
UPCOBK	UP0200	Company EFT Banks
UPDDOPTS	UP0213	Direct Deposit Options
UPDIST	UP0009	Distribution
UPDTLB	UP0040	Earnings Billing Detail
UPDTLM	UP0007	Earnings/Deductions
UPDTLO	UP0123	Earnings/Deductions Opt Fields
UPECMM	UP0119	Employee Comments
UPEDUP	UP0106	Duplicate SSN
UPEHRP	UP0093	Earnings Hourly Report
UPELST	UP0208	EFT Combine File List
UPEMBK	UP0201	Employee EFT Banks
UPEMCS	UP0118	Employee Garnishment
UPEMDB	UP0041	Employee Billing Details
UPEMDO	UP0125	Empl Earn/Ded Optional Fields
UPEMPC	UP0053	Employee Notes
UPEMPD	UP0008	Employee Earnings/Deductions
UPEMPL	UP0014	Employees
UPEMPO	UP0122	Employee Optional Field Values
UPEMPT	UP0010	Employee Taxes
UPEMRGD	UP0210	EFT Files Combine Setup Detail
UPEMRGH	UP0209	EFT Files Combine Setup Header
UPEMTF	UP0062	Employee Tax Fields
UPEMTO	UP0126	Empl Taxes Optional Fields
UPEMULD	UP0207	EFT Combine File Detail
UPEMULH	UP0206	EFT Combine File Header
UPEREG	UP0204	EFT Run History Header
UPESLD	UP0046	Employee Selection List Members
UPESLH	UP0045	Employee Selection Lists
UPETRN	UP0205	EFT Run History Details
UPGLBM	UP0051	Globally Modify List
UPGLDD	UP0060	G/L Acct Desc Report List
UPGLREF	UP0057	G/L Reference Integration
UPHDAU	UP0024	History Audit Details
UPHDOA	UP0136	History Audit Detail Opt Fields
UPHHAU	UP0021	History Audit Headers
UPHHOA	UP0135	History Audit Header Opt Fields
UPINCL	UP0015	Include List
UPLIMD	UP0117	Deduction Group Details
UPLIMH	UP0116	Deduction Groups
UPMCDO	UP0130	MC Details Opt Field Values
UPMCDT	UP0020	Manual Check Detail
UPMCHD	UP0019	Manual Check Header
UPMCHO	UP0129	Manual Check Optional Field Values
UPMCJB	UP0043	Manual Check Job Details
UPMCJO	UP0142	Manual Check Jobs Opt Fields
UPOFD	UP0121	Optional Field Values
UPOFH	UP0120	Optional Field Locations
UPOPTS	UP0023	Company Options
UPOTSC	UP0022	Overtime Schedules
UPPCKD	UP0080	Print Checks Detail Extension
UPPCKH	UP0079	Print Checks Header Extension
UPPMCO	UP0138	Process Manual Check Optional Fields
UPSHFB	UP0039	Shift Differential Billing Detail
UPSHFD	UP0038	Shift Differential Detail
UPSHFT	UP0025	Shift Differential Schedule
UPSTAT	UP0017	Status
UPTCDO	UP0128	Timecard Details Optional Field Values
UPTCDT	UP0032	Timecard Detail
UPTCHD	UP0031	Timecard Header
UPTCHO	UP0127	Timecard Optional Field Values
UPTCJB	UP0042	Timecard Job Details
UPTCJO	UP0141	Timecard Jobs Optional Field Values
UPTXMO	UP0124	Taxes Optional Field Values
UPTXMS	UP0029	Company Payroll Taxes
UPUSLD
UPUSLH
UPUTCD	UP0103	Employee Timecard Detail
UPUTCH	UP0102	Employee Timecard Header
UPUTDO	UP0132	Empl Timecard Details Opt Flds
UPUTHO	UP0131	Empl Timecard Optional Fields
UPUTJB	UP0044	Employee Timecard Job Details
UPUTJO	UP0143	Employee TC Jobs Opt Field Values
UPWCCD	UP0037	Workers Compensation Codes
UPWCCH	UP0036	Workers Compensation Master
UPWRKC	UP0027	Work Classification Codes
UPXCPT	UP0064	Calc PR Exceptions
UPYTDS	UP0047	Employee YTD Summaries

Objects: 40

Object	Protocol	Views

GPGLPE	FLAT	GP0930
UPCALCULAT	ORDERED	UP0083, UP0137
UPCHECKS	ORD5	UP0048, UP0049, UP0052, UP0202, UP0133, UP0134
UPCHKCOMNT	SET	UP0052
UPCLASSIDS	SET	UP0006
UPCONTROL	SUPER	UP0026
UPCPYTCARD	SUPER	CP0108
UPDCHK	SUPER	UP0016
UPDELINREC	SUPER	UP0018
UPDISTCODE	SET	UP0009
UPEARNDED	ORD4	UP0007, UP0015, UP0009, UP0123, UP0040
UPEFTCOBK	SET	UP0200
UPEFTMERGE	ORDERED	UP0211, UP0208
UPEFTMERGESTP	ORDERED	UP0209, UP0210
UPEFTTRANS	ORDERED	UP0204, UP0205
UPEMASTER	ORD9	UP0014, UP0008, UP0010, UP0053, UP0201, UP0062, UP0122, UP0125, UP0126, UP0041
UPERNGHRS	SUPER	UP0081
UPESELECT	ORDERED	UP0045, UP0046
UPGENEFT	SUPER	UP0203
UPGMET	SUPER	UP0058
UPHSTAUDH	ORD3	UP0021, UP0024, UP0135, UP0136
UPMANCHK	ORD5	UP0019, UP0020, UP0129, UP0130, UP0043, UP0142
UPMANCKDTL	ORD3	UP0020, UP0130, UP0043, UP0142
UPOPTFLDS	ORDERED	UP0120, UP0121
UPOPTIONS	FLAT	UP0023
UPOTSCHED	FLAT	UP0022
UPPRCHECKS	SUPER	UP0078
UPPRMANCHK	ORDERED	UP0065, UP0138
UPREGISTER	SUPER	UP0094
UPSECURITY	ORDERED	UP0066, UP0067
UPSHFTSCH	ORD2	UP0025, UP0038, UP0039
UPTAXMASTR	ORD3	UP0029, UP0009, UP0015, UP0124
UPTIMECARD	ORD5	UP0031, UP0032, UP0127, UP0128, UP0042, UP0141
UPTMCRDDTL	ORD3	UP0032, UP0128, UP0042, UP0141
UPUPEMPTAX	SUPER	UP0058
UPUPETINFO	FLAT	UP0051
UPUTCARD	ORD5	UP0102, UP0103, UP0131, UP0132, UP0044, UP0143
UPUTCTRF	SUPER	UP0101
UPWORKCODE	FLAT	UP0027
UPWORKCOMP	ORDERED	UP0036, UP0037

© 2021 Sage Software, Inc. All rights reserved. Reproduction of part or all of the contents in any form is prohibited unless for personal use. None of the content of this article may be copied or otherwise incorporated into any other document, publication or other work in any form (whether written, electronic or other format).

Sage Software, Inc. makes no warranties, representations or undertakings about any of the content of articles (including, without limitation, any as to the quality, accuracy, completeness or fitness for any particular purpose of such content).