Table AD_TaskInstance
PRIMARY KEY
AD_TaskInstance_ID
NUMBER (10, 0) NOT NULL

AD_Client_ID
NUMBER (10, 0) NOT NULL
AD_Client
AD_Org_ID
NUMBER (10, 0) NOT NULL
AD_Org
IsActive
CHAR (1) default: 'Y' CHECK ( IsActive in ( 'Y' , 'N' )) NOT NULL
Created
DATE default: SYSDATE NOT NULL
CreatedBy
NUMBER (10, 0)
Updated
DATE default: SYSDATE NOT NULL
UpdatedBy
NUMBER (10, 0)
AD_Task_ID
NUMBER (10, 0) NOT NULL
AD_Task


FOREIGN KEY
AD_Task_TaskInstance: AD_Task_ID => AD_Task
TaskInstanceClient: AD_Client_ID => AD_Client
TaskInstanceOrg: AD_Org_ID => AD_Org