ColumnName |
Domain |
Datatype |
NULL |
Definition |
EXP_TYPE_CD |
|
VARCHAR2(10) |
NO |
Name: EXP_TYPE_TASK Description: The expense type unique identifier. |
FUNCTIONAL_ROLE_CD |
|
VARCHAR2(10) |
NO |
Name: Functional Role Description: Unique identifier for this functional role. |
S_TASK_OBJECT_CD |
|
VARCHAR2(10) |
NO |
Name: S_TASK_OBJECT_CD Description: Indicates object that task is associated with. The valid values are: ER or EA. |
S_TASK_SUB_OBJECT_CD |
|
VARCHAR2(10) |
NO |
Name: Task Object Description: Indicates object that task is performed on. The valid values are: ATTACHMENT. |
S_TASK_TYPE_CD |
|
VARCHAR2(10) |
NO |
Name: Task Type Description: Indicates the type of task. The valid values are APPROVE or ATTACH. |
ATTACHMENT_TYPE_CD |
|
VARCHAR2(10) |
NO |
Name: Attachment Type Description: The attachment type related to task. |
TASK_THRESHOLD_AMT |
|
NUMBER(15, 5) |
NO |
Name: Threshold Amount Description: The threshold for task base on expense amount. |
START_DTT |
|
DATE |
NO |
Name: Inactive Date Time Description: Date time that task rule started for expense type. |
END_DTT |
|
DATE |
YES |
Name: Inactive Date Time Description: Date time that task rule ended for expense type. |
MODIFIED_BY |
|
VARCHAR2(20) |
NO |
|
ROWVERSION |
|
NUMBER(10, 0) |
NO |
|
TIME_STAMP |
|
DATE |
NO |
|