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


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

Foreign keys referencing this table

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