View: Timecard Earnings List

RotoID: CP0087
Table:
DLL: CPCALO

Compositions: 0

Keys: 1

Title	Fields

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

Fields: 61

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
EARNCODE	5	String*6	Earnings Code	E A K R	Mask: %-6N
UNIQUE	6	Integer	Uniquifier	E A K R
LTYPE	7	Integer	Line Type	E A K R
TCPEREND	8	Date	Timecard Period End Date	E A K R
TIMECARD	9	String*6	Timecard	E A K R	Mask: %-6N
EMPLOYEE	10	String*12	Employee	E A	Mask: %-12N
PEREND	11	Date	Period End Date	E A
ENTRYSEQ	12	Long	Entry Sequence By Employee	E A
CATEGORY	13	Integer	Category code	E A
EARNDED	14	String*6	Earnings/Deduction	E A	Mask: %-6N
LINETYPE	15	Integer	Presentation List Type Pay	E A
LINENO	16	Integer	Line Number	E A
EARDEDTYPE	17	Integer	Earnings/Deduction Type	E A
EARDEDDATE	18	Date	Earnings/Deduction Date	E A
HOURS	19	BCD*4.3	Earnings/Deduction Hours	E A
ECNTBASE	20	BCD*10.3	Employee Amt, Cnt, Base or Sales	E A
ERATE	21	BCD*9.5	Employee Hourly Rate or Percent	E A
EEXTEND	22	BCD*10.3	Employee Dollar Amounts	E A
EREGRATE	23	BCD*9.5	Base Regular Rate for OT	E A
RCNTBASE	24	BCD*10.3	Employer Amt, Cnt, Base or Sales	E A
RRATE	25	BCD*9.5	Employer Hourly Rate or Percent	E A
REXTEND	26	BCD*10.3	Employer Dollar Amounts	E A
EXPACCT	27	String*45	Regular Pay Expense G/L Account	E A
ELIABACCT	28	String*45	Employee Liability G/L Account	E A
RLIABACCT	29	String*45	Employer Liability G/L Account	E A
WCC	30	String*6	Workers' Compensation Code	E A
GLSEG1	31	String*15	Cost Center Segment One	E A
GLSEG2	32	String*15	Cost Center Segment Two	E A
GLSEG3	33	String*15	Cost Center Segment Three	E A
PARTIAL	34	Boolean	Detail Was Partially Taken or No	E A
TAXWEEKS	35	BCD*4.3	Weeks Worked for the Taxing Auth	E A
TAXEARNS	36	BCD*10.3	Taxable Earnings	E A
TXEARNCEIL	37	BCD*10.3	Taxable Earnings Ceiling	E A
TAXTIPS	38	BCD*10.3	Taxable Tips Without a Ceiling	E A
TXTIPSCEIL	39	BCD*10.3	Taxable Tips With a Ceiling	E A
TAXONTIPS	40	BCD*10.3	Amount of Tax Calculated on Tips	E A
UNCOLLTAX	41	BCD*10.3	For Uncollected SS/Med	E A
PCATEGORY	42	Integer	Print Category	E A
PLINETYPE	43	Integer	Print Line Type	E A
PCONTENTS	44	Integer	Print Line Contents	E A
TAXNONPER	45	BCD*10.3	Taxable Non-periodic Earnings	E A
TAXEARNBD	46	BCD*10.3	Subject to Income tax befor dedu	E A
POOLEDTIPS	47	BCD*10.3	Pooled Tips	E A
DETAILDATE	48	Date	Detail Date	E A
STARTTIME	49	Integer	Start Time	E A
STOPTIME	50	Integer	Stop Time	E A
WCCGROUP	51	String*6	Workers Comp. Group	E A	Mask: %-6N
VALUES	52	Long	Number of Optional Fields	E A
HASTC	53	Boolean	Timecard flag	E A
TCENTRY	54	Integer	Timecard Entry	E A
TCLINENUM	55	Integer	Timecard Line Number	E A
SEPARATECK	56	Boolean	Separate Check flag	E A
SWFLSA	57	Boolean	Included in Regular Rate OT 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

This page was generated on 2006-Sep-07