Table C_Greeting

Diagram AD Diagram I

PRIMARY KEY
C_Greeting_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
Greeting NVARCHAR2 (60)
IsFirstNameOnly CHAR (1) default: 'N' CHECK ( IsFirstNameOnly in ( 'Y' , 'N' )) NOT NULL
IsDefault CHAR (1) default: 'N' CHECK ( IsDefault in ( 'Y' , 'N' )) NOT NULL
REFERENCED BY AD_User, C_BPartner, C_Greeting_Trl, I_BPartner