Table AD_System
Description:
System Identification and status (Singelton)
PRIMARY KEY
AD_System_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
UserName
NVARCHAR2 (60)
NOT NULL
Password
NVARCHAR2 (20)
ReleaseNo
CHAR (4)
Version
NVARCHAR2 (20)
SupportUnits
NUMBER (10, 0)
Info
NVARCHAR2 (255)
ReplicationType
CHAR (1)
default: 'L'
NOT NULL
IDRangeStart
NUMBER
IDRangeEnd
NUMBER
EncryptionKey
NVARCHAR2 (255)