Table C_AcctProcessor
PRIMARY KEY
C_AcctProcessor_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)
FrequencyType
CHAR (1)
NOT NULL
Frequency
NUMBER (10, 0)
NOT NULL
DateLastRun
DATE
DateNextRun
DATE
Supervisor_ID
NUMBER (10, 0)
NOT NULL
AD_User
KeepLogDays
NUMBER (10, 0)
NOT NULL
Processing
CHAR (1)
FOREIGN KEY
ADUser_CAcctProcessor: Supervisor_ID =>
AD_User
REFERENCED BY
C_AcctProcessorLog