The Transaction Column Fields custom field is available for the Employee Time table.
Name | Type | Length | Precision | Scale | References | In | Description |
---|---|---|---|---|---|---|---|
approved | VARCHAR2 | 3 | Approved | ||||
billable | VARCHAR2 | 3 | Billable | ||||
billed | VARCHAR2 | 3 | Billed | ||||
billing_class_id | NUMBER | 39 | 0 |
billing_class_id |
Billing_classes |
Billing class ID | |
billing_subsidiary_id | NUMBER | 39 | 0 |
subsidiary_id |
Subsidiaries |
Billing subsidiary ID | |
break_duration | NUMBER | 12 | 5 | Break duration | |||
charge_billing_run_id | NUMBER | 39 | 0 | Charge billing run ID | |||
class_id | NUMBER | 39 | 0 |
class_id |
Classes |
Class ID | |
closed | TIMESTAMP | Closed | |||||
comments | VARCHAR2 | 4000 | Comments | ||||
customer_id | NUMBER | 39 | 0 |
customer_id |
Customers |
Customer ID | |
date_last_modified | TIMESTAMP | Date last modified | |||||
day_0 | TIMESTAMP | Day | |||||
department_id | NUMBER | 39 | 0 |
department_id |
Departments |
Department ID | |
duration | NUMBER | 12 | 5 | Duration | |||
employee_id | NUMBER | 39 | 0 |
employee_id |
Employees |
Employee | |
employee_time_id | NUMBER | 39 | 0 | Employee time ID | |||
ending | TIMESTAMP | Ending | |||||
event_id | NUMBER | 39 | 0 | Event ID | |||
is_outside_project_plan | VARCHAR2 | 3 | Is outside of the project plan | ||||
is_posted | VARCHAR2 | 3 | Whether the time is posted | ||||
is_productive | VARCHAR2 | 1 | Productive | ||||
is_utilized | VARCHAR2 | 1 | Utilized | ||||
item_id | NUMBER | 39 | 0 |
item_id |
Service_items |
Item ID | |
location_id | NUMBER | 39 | 0 |
location_id |
Locations |
Location ID | |
next_approver_id | NUMBER | 39 | 0 | Next approver ID | |||
payroll_item_id | NUMBER | 39 | 0 |
payroll_item_id |
Payroll_items |
Payroll item ID | |
payroll_workplace_id | NUMBER | 39 | 0 | Payroll workplace ID | |||
price_type_id | NUMBER | 39 | 0 |
price_type_id |
Price_types |
Price type ID | |
rejection_note | VARCHAR2 | 4000 | Rejection note | ||||
remaining_time_to_charge | NUMBER | 39 | 0 | Remaining time to charge | |||
resource_allocation_id | NUMBER | 39 | 0 | Resource allocation ID | |||
starting | TIMESTAMP | Starting | |||||
status_code | VARCHAR2 | 200 | Status code | ||||
subsidiary_id | NUMBER | 39 | 0 |
subsidiary_id |
Subsidiaries |
Subsidiary ID | |
time_type | VARCHAR2 | 9 | Type of time (Actual, Allocated, Planned) | ||||
timesheet_id | NUMBER | 39 | 0 | Timesheet ID | |||
transaction_id | NUMBER | 39 | 0 |
transaction_id transaction_id |
Transaction_lines Transactions |
Transaction ID | |
transaction_line_id | NUMBER | 39 | 0 |
transaction_line_id |
Transaction_lines |
Transaction Line ID | |
unit_cost | NUMBER | 20 | 2 | Unit cost | |||
unit_price | NUMBER | 30 | 15 | Unit price |
PK Column Name |
---|
employee_time_id |
FK Name | FK Column Name | PK Table Name | PK Column Name | Key Seq |
---|---|---|---|---|
employee_time_billing_classes_fk | billing_class_id | Billing_classes | billing_class_id | 1 |
employee_time_classes_fk | class_id | Classes | class_id | 1 |
employee_time_customers_fk | customer_id | Customers | customer_id | 1 |
employee_time_departments_fk | department_id | Departments | department_id | 1 |
employee_time_employees_fk | employee_id | Employees | employee_id | 1 |
employee_time_locations_fk | location_id | Locations | location_id | 1 |
employee_time_payroll_items_fk | payroll_item_id | Payroll_items | payroll_item_id | 1 |
employee_time_price_types_fk | price_type_id | Price_types | price_type_id | 1 |
employee_time_service_items_fk | item_id | Service_items | item_id | 1 |
employee_time_subsidiaries_fk | subsidiary_id | Subsidiaries | subsidiary_id | 1 |
employee_time_subsidiaries_fk_2 | billing_subsidiary_id | Subsidiaries | subsidiary_id | 1 |
employee_time_transaction_lines_fk | transaction_id | Transaction_lines | transaction_id | 1 |
employee_time_transaction_lines_fk | transaction_line_id | Transaction_lines | transaction_line_id | 2 |
employee_time_transactions_fk | transaction_id | Transactions | transaction_id | 1 |