Table AD_PInstance_Para
PRIMARY KEY
AD_PInstance_ID
NUMBER (10, 0)
NOT NULL
AD_PInstance
SeqNo
NUMBER (10, 0)
NOT NULL
AD_Client_ID
NUMBER (10, 0)
AD_Org_ID
NUMBER (10, 0)
IsActive
CHAR (1)
default: 'Y'
CHECK ( IsActive in ( 'Y' , 'N' ))
Created
DATE
default: SYSDATE
CreatedBy
NUMBER (10, 0)
Updated
DATE
default: SYSDATE
UpdatedBy
NUMBER (10, 0)
ParameterName
NVARCHAR2 (60)
P_String
NVARCHAR2 (60)
P_String_To
NVARCHAR2 (60)
P_Number
NUMBER
default: 0
P_Number_To
NUMBER
default: 0
P_Date
DATE
P_Date_To
DATE
Info
NVARCHAR2 (60)
Info_To
NVARCHAR2 (60)
FOREIGN KEY
ADPInstance_ADPInstancePara: AD_PInstance_ID =>
AD_PInstance