| PRIMARY KEY |
|
AD_Process_Para_ID
NUMBER (10, 0) NOT NULL |
| |
|
|
AD_Client_ID
NUMBER (10, 0) NOT NULL |
| |
|
AD_Org_ID
NUMBER (10, 0) NOT NULL |
| |
|
IsActive
CHAR (1) default: 'Y' CHECK ( IsActive in ( 'Y' , 'N' )) NOT NULL |
| |
|
Created
DATE default: SYSDATE NOT NULL |
| |
|
CreatedBy
NUMBER (10, 0) NOT NULL |
| |
|
Updated
DATE default: SYSDATE NOT NULL |
| |
|
UpdatedBy
NUMBER (10, 0) NOT NULL |
| |
|
Name
NVARCHAR2 (60) NOT NULL |
| |
|
Description
NVARCHAR2 (255) |
| |
|
Help
NVARCHAR2 (2000) |
| |
|
AD_Process_ID
NUMBER (10, 0) NOT NULL |
| AD_Process |
|
SeqNo
NUMBER (10, 0) NOT NULL |
| |
|
AD_Reference_ID
NUMBER (10, 0) NOT NULL |
| AD_Reference |
|
AD_Reference_Value_ID
NUMBER (10, 0) |
| AD_Reference |
|
AD_Val_Rule_ID
NUMBER (10, 0) |
| AD_Val_Rule |
|
ColumnName
VARCHAR2 (40) NOT NULL |
| |
|
AD_Element_ID
NUMBER (10, 0) |
| AD_Element |
|
IsCentrallyMaintained
CHAR (1) default: 'Y' CHECK ( IsCentrallyMaintained in ( 'Y' , 'N' )) NOT NULL |
| |
|
EntityType
CHAR (1) default: 'D' NOT NULL |
| |
|
FieldLength
NUMBER (10, 0) NOT NULL |
| |
|
IsMandatory
CHAR (1) default: 'N' CHECK ( IsMandatory in ( 'Y' , 'N' )) NOT NULL |
| |
|
IsRange
CHAR (1) default: 'N' CHECK ( IsRange in ( 'Y' , 'N' )) NOT NULL |
| |
|
DefaultValue
NVARCHAR2 (60) |
| |
|
DefaultValue2
NVARCHAR2 (60) |
| |
|
VFormat
NVARCHAR2 (20) |
| |
|
ValueMin
NVARCHAR2 (20) |
| |
|
ValueMax
NVARCHAR2 (20) |
| |
FOREIGN KEY
ADElement_ADProcessPara: AD_Element_ID => AD_Element
ADProcess_ADProcessPara: AD_Process_ID => AD_Process
ADReference_ADProcessPara: AD_Reference_ID => AD_Reference
ADReferenceValue_ADProcPara: AD_Reference_Value_ID => AD_Reference
ADValRule_AD_ProcessPara: AD_Val_Rule_ID => AD_Val_Rule
|
REFERENCED BY
AD_Process_Para_Trl,
AD_Scheduler_Para,
AD_WF_Node_Para |
|