View Name: | fc_acct_task_view |
View Number: | 4621 |
Group: | |
Description: | |
Flags: | VIEW_OPTIMIZED |
Baseline/Custom: | Custom |
View Field Name | Table Name | Field Name | Comment | Generic Field Id |
---|---|---|---|---|
objid | task | objid | Task internal record number | 3 (UNIQUE) |
id | task | task_id | Task ID | |
title | task | title | Title of the task | |
due_date | task | due_date | Due date of the task | |
start_date | task | start_date | Start date of the task | |
comp_date | task | comp_date | Actual completion date of the task | |
status | gbst_stat(gbst_elm) | title | Status of the task | |
priority | gbst_pri(gbst_elm) | title | Priority of the task | |
task_type | gbst_type(gbst_elm) | title | Type of the task | |
login_name | user | login_name | Login name of the user | |
user_objid | user | objid | User-owner internal record number | |
condition | condition | title | Condition/state of the task | |
active | task | active | If the task is active | |
org_id | bus_org | org_id | User-specified ID number of the organization | |
org_name | bus_org | name | Name of the organization | |
org_objid | bus_org | objid | Internal record number |
Join From | Join To |
---|---|
(task).task_state2condition | (condition).task_condition2task |
(task).task_owner2user | (user).owner2task |
(task).type_task2gbst_elm | gbst_type(gbst_elm).type_task2task |
(task).task_priority2gbst_elm | gbst_pri(gbst_elm).priority2task |
(task).task_for2bus_org | (bus_org).receiver_org2task |
(task).task_sts2gbst_elm | gbst_stat(gbst_elm).status2task |
fc_acct_task_view | |||