This table contains information about payroll items and its associated details like account, entity, subsidiary etc.
Module:
id
| Name | Datatype | Length | Precision | Not Null | Comments | Referred Table | Referred Column |
|---|---|---|---|---|---|---|---|
| id | NUMBER | 38 | 0 | True | Internal ID | ||
| SOURCE_RECORD_ID | VARCHAR2 | 128 | This column is for Oracle Internal use only. This is source record id column. | ||||
| allowbulkentry | VARCHAR2 | 16 | Allow Entry from Create Payroll | ||||
| assetaccount | NUMBER | 38 | 0 | Asset Account | DW_NS_account_D | id | |
| basedonquantity | VARCHAR2 | 16 | Based on Quantity | ||||
| defaultrate | NUMBER | Default Rate | |||||
| derivedratemultiplier | NUMBER | Rate Multiplier | |||||
| deriveratefrompayrollitem | NUMBER | 38 | 0 | Derived From | DW_NS_payrollItem_D | id | |
| deriveratefrompayrollitemgroup | NUMBER | 38 | 0 | Derived From Payroll Item Group | DW_NS_PayrollItemGroup_D | id | |
| description | VARCHAR2 | 512 | Description | ||||
| employeepaid | VARCHAR2 | 16 | Employee Paid | ||||
| expenseaccount | NUMBER | 38 | 0 | Expense Account | DW_NS_account_D | id | |
| inactive | VARCHAR2 | 16 | Inactive | ||||
| itemtype | NUMBER | 38 | 0 | Item Type | DW_NS_payItemType_D | key | |
| liabilityaccount | NUMBER | 38 | 0 | Liability Account | DW_NS_account_D | id | |
| limit | NUMBER | Limit | |||||
| name | VARCHAR2 | 64 | Item Name | ||||
| reportingsection | NUMBER | 38 | 0 | Report Section | DW_NS_reportingSection_D | key | |
| showinemployeecenter | VARCHAR2 | 16 | View in Employee Center | ||||
| subsidiary | NUMBER | 38 | 0 | Subsidiary | DW_NS_subsidiary_D | id | |
| vendor | NUMBER | 38 | 0 | Agency | DW_NS_vendor_D | id |
Copyright © 2019, 2026, Oracle and/or its affiliates.