Payroll_items

The Other > Payroll Item custom field is available for the Payroll Items table.

Columns

Name	Type	Length	Precision	Scale	References	In	Description
date_last_modified	TIMESTAMP						Date last modified
derived_from_payroll_item_id	NUMBER		39	0			The ID of a payroll item from which this payroll item is derived
derived_rate_multiplier	NUMBER		15	8			The rate multiplier for a derived payroll item
expense_account	NUMBER		39	0			Expense account
isinactive	VARCHAR2	3					Inactive
liability_account	NUMBER		39	0			Liability account
limit_0	NUMBER		12	2			Limit
locality	VARCHAR2	15					Locality
name	VARCHAR2	50					Name
payroll_item_id	NUMBER		39	0			Payroll item ID
payroll_item_type_id	NUMBER		39	0			Payroll item type ID
rate	VARCHAR2	42					Rate
state	VARCHAR2	2					State
tax_number	VARCHAR2	20					Agency ID
vendor_id	NUMBER		39	0			Vendor ID
w2_code	VARCHAR2	10					W-2 box

Primary key

PK Column Name
payroll_item_id

Foreign keys referencing this table

FK Name	PK Column Name	FK Table Name	FK Column Name	Key Seq
Employee_time_payroll_items_fk	payroll_item_id	Employee_time	payroll_item_id	1
Opportunity_lines_payroll_items_fk	payroll_item_id	Opportunity_lines	payroll_item_id	1