View: Timecard Earnings List

RotoID: UP0087
Table: UPCALO
Protocol: Flat
DLL: UPCALO

Compositions: 0

Keys: 1

Title	Fields

Earning Code	LEVEL, SORTCODE, EARDATE, START, TCPEREND, TIMECARD, TCLINENUM, EARNCODE, UNIQUE, LTYPE

Fields: 65

Field	Index	Type	Title	Attributes	Presentation

LEVEL	1	Integer	Earning Code Level	E A K R
SORTCODE	2	Integer	Sort Code	E A K R
EARDATE	3	Date	Earnings Date	E A K R
START	4	Integer	Earnings Start Time	E A K R
TCPEREND	5	Date	Timecard Period End Date	E A K R
TIMECARD	6	String*6	Timecard	E A K R	Mask: %-6N
TCLINENUM	7	Integer	Timecard Line Number	E A K R
EARNCODE	8	String*6	Earnings Code	E A K R	Mask: %-6N
UNIQUE	9	Integer	Uniquifier	E A K R
LTYPE	10	Integer	Line Type	E A K R
EMPLOYEE	11	String*12	Employee	E A	Mask: %-12N
PEREND	12	Date	Period End Date	E A
ENTRYSEQ	13	Long	Entry Sequence By Employee	E A
CATEGORY	14	Integer	Category code	E A
EARNDED	15	String*6	Earnings/Deduction	E A	Mask: %-6N
LINETYPE	16	Integer	Presentation List Type Pay	E A
LINENO	17	Integer	Line Number	E A
EARDEDTYPE	18	Integer	Earnings/Deduction Type	E A
EARDEDDATE	19	Date	Earnings/Deduction Date	E A
HOURS	20	BCD*4.3	Earnings/Deduction Hours	E A
ECNTBASE	21	BCD*10.3	Employee Amt, Cnt, Base or Sales	E A
ERATE	22	BCD*9.5	Employee Hourly Rate or Percent	E A
EEXTEND	23	BCD*10.3	Employee Dollar Amounts	E A
EREGRATE	24	BCD*9.5	Base Regular Rate for OT	E A
RCNTBASE	25	BCD*10.3	Employer Amt, Cnt, Base or Sales	E A
RRATE	26	BCD*9.5	Employer Hourly Rate or Percent	E A
REXTEND	27	BCD*10.3	Employer Dollar Amounts	E A
EXPACCT	28	String*45	Regular Pay Expense G/L Account	E A
ELIABACCT	29	String*45	Employee Liability G/L Account	E A
RLIABACCT	30	String*45	Employer Liability G/L Account	E A
WCC	31	String*6	Workers' Compensation Code	E A
GLSEG1	32	String*15	Cost Center Segment One	E A
GLSEG2	33	String*15	Cost Center Segment Two	E A
GLSEG3	34	String*15	Cost Center Segment Three	E A
PARTIAL	35	Boolean	Detail Was Partially Taken or Not	E A
TAXWEEKS	36	BCD*4.3	Weeks Worked for the Taxing Authority	E A
TAXEARNS	37	BCD*10.3	Taxable Earnings	E A
TXEARNCEIL	38	BCD*10.3	Taxable Earnings Ceiling	E A
TAXTIPS	39	BCD*10.3	Taxable Tips Without a Ceiling	E A
TXTIPSCEIL	40	BCD*10.3	Taxable Tips With a Ceiling	E A
TAXONTIPS	41	BCD*10.3	Amount of Tax Calculated on Tips	E A
UNCOLLTAX	42	BCD*10.3	For Uncollected SS/Med	E A
PCATEGORY	43	Integer	Print Category	E A
PLINETYPE	44	Integer	Print Line Type	E A
PCONTENTS	45	Integer	Print Line Contents	E A
TAXNONPER	46	BCD*10.3	Taxable Non-periodic Earnings	E A
TAXEARNBD	47	BCD*10.3	Subject to Income tax befor deductions	E A
POOLEDTIPS	48	BCD*10.3	RESERVED - Cdn Only	E A
DETAILDATE	49	Date	Detail Date	E A
STARTTIME	50	Integer	Start Time	E A
STOPTIME	51	Integer	Stop Time	E A
WCCGROUP	52	String*6	Workers Comp. Group	E A	Mask: %-6N
VALUES	53	Long	Number of Optional Fields	E A
HASTC	54	Boolean	Timecard flag	E A
TCENTRY	55	Integer	Timecard Entry	E A
SEPARATECK	56	Boolean	Separate Check flag	E A
SWFLSA	57	Boolean	Included in FLSA Overtime Calc	E A
STAMOUNT	58	BCD*10.3	Straight Time Earnings	E A
PREMIUMRT	59	BCD*5.5	Overtime Rate Multiplier	E A
WORKCODE	60	String*6	Work Classification Code	E A	Mask: %-6N
BRACKET	61	Integer	Overtime Schedule Bracket	E A
PRORATED	62	Boolean	Prorated Timecard Detail	E A
PUNIQUE	63	Integer	Prorated Timecard Parent	E A
OTSCHED	64	String*6	Overtime Schedule	E A	Mask: %-6N
OTOVERRIDE	65	Boolean	Overtime Override	E A

This page was generated on 2009-Nov-19