Table C_RevenueRecognition
Diagram M
PRIMARY KEY
C_RevenueRecognition_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)
IsTimeBased
CHAR (1)
NOT NULL
RecognitionFrequency
CHAR (1)
NoMonths
NUMBER (10, 0)
REFERENCED BY
C_RevenueRecognition_Plan
,
M_Product