Description:
AD Column definition
|
| PRIMARY KEY |
|
AD_Column_ID
NUMBER (10, 0) NOT NULL |
| |
|
|
AD_Client_ID
NUMBER (10, 0) NOT NULL |
| AD_Client |
|
AD_Org_ID
NUMBER (10, 0) NOT NULL |
| AD_Org |
|
IsActive
CHAR (1) default: 'Y' CHECK ( IsActive in ( 'Y' , 'N' )) NOT NULL |
| |
|
Created
DATE default: SYSDATE NOT NULL |
| |
|
Updated
DATE default: SYSDATE NOT NULL |
| |
|
CreatedBy
NUMBER (10, 0) NOT NULL |
| |
|
UpdatedBy
NUMBER (10, 0) NOT NULL |
| |
|
Name
NVARCHAR2 (60) NOT NULL |
| |
|
Description
NVARCHAR2 (255) |
| |
|
Help
NVARCHAR2 (2000) |
| |
|
Version
NUMBER NOT NULL |
| |
|
EntityType
CHAR (1) default: 'D' NOT NULL |
| |
|
ColumnName
VARCHAR2 (40) NOT NULL |
| |
|
AD_Table_ID
NUMBER (10, 0) NOT NULL |
| AD_Table |
|
AD_Reference_ID
NUMBER (10, 0) NOT NULL |
| AD_Reference |
|
AD_Reference_Value_ID
NUMBER (10, 0) |
| AD_Reference |
|
AD_Val_Rule_ID
NUMBER (10, 0) |
| AD_Val_Rule |
|
FieldLength
NUMBER (10, 0) |
Only for VARCHAR and CHAR
| |
|
DefaultValue
NVARCHAR2 (2000) |
| |
|
IsKey
CHAR (1) default: 'N' CHECK ( IsKey in ( 'Y' , 'N' )) NOT NULL |
| |
|
IsParent
CHAR (1) default: 'N' CHECK ( IsParent in ( 'Y' , 'N' )) NOT NULL |
| |
|
IsMandatory
CHAR (1) default: 'N' CHECK ( IsMandatory in ( 'Y' , 'N' )) NOT NULL |
| |
|
IsUpdateable
CHAR (1) default: 'Y' CHECK ( IsUpdateable in ( 'Y' , 'N' )) NOT NULL |
| |
|
ReadOnlyLogic
NVARCHAR2 (2000) |
| |
|
IsIdentifier
CHAR (1) default: 'N' CHECK ( IsIdentifier in ( 'Y' , 'N' )) NOT NULL |
| |
|
SeqNo
NUMBER (10, 0) |
| |
|
IsTranslated
CHAR (1) default: 'N' CHECK ( IsTranslated in ( 'Y' , 'N' )) NOT NULL |
| |
|
IsEncrypted
CHAR (1) default: 'N' CHECK ( IsEncrypted in ( 'Y' , 'N' )) NOT NULL |
| |
|
Callout
NVARCHAR2 (255) |
| |
|
VFormat
NVARCHAR2 (60) |
| |
|
ValueMin
NVARCHAR2 (20) |
| |
|
ValueMax
NVARCHAR2 (20) |
| |
|
IsSelectionColumn
CHAR (1) default: 'N' CHECK ( IsSelectionColumn in ( 'Y' , 'N' )) NOT NULL |
| |
|
AD_Element_ID
NUMBER (10, 0) |
| AD_Element |
|
AD_Process_ID
NUMBER (10, 0) |
Process to start when pressing Button
| AD_Process |
|
IsSyncDatabase
CHAR (1) default: 'N' CHECK ( IsSyncDatabase in ( 'Y' , 'N' )) |
| |
FOREIGN KEY
AD_Element_AD_Column: AD_Element_ID => AD_Element
AD_Reference_ColumnDataType: AD_Reference_ID => AD_Reference
AD_Reference_ColumnValue: AD_Reference_Value_ID => AD_Reference
AD_Table_Column: AD_Table_ID => AD_Table
AD_ValRule_Column: AD_Val_Rule_ID => AD_Val_Rule
ADProcess_ADColumn: AD_Process_ID => AD_Process
ColumnClient: AD_Client_ID => AD_Client
ColumnOrg: AD_Org_ID => AD_Org
|
REFERENCED BY
AD_ChangeLog,
AD_Column_Access,
AD_Field,
AD_Find,
AD_ImpFormat_Row,
AD_PrintFormatItem,
AD_PrintLabelLine,
AD_Ref_Table,
AD_Ref_Table,
AD_ReportView_Col,
AD_Tab,
AD_Tab,
AD_Tab,
I_ElementValue |
|