Previous Topic: CI_WF_TEMPLATES TableNext Topic: Contact_Method Table


Column_Name Table

Column Name list used by Web Screen Painter.

Field

Data Type

Reference

Remarks

cn_desc

STRING 240

 

description of column

cn_dflt

STRING 30

 

default external name

cn_name

STRING 30

 

user name for column

cn_sys

STRING 30

S_KEY

 

system name

cn_table

STRING 30

S_KEY

 

system table name

del

INTEGER

NOT_NULL

 

Deleted flag

0—Active

1—Inactive/marked as deleted

id

INTEGER

UNIQUE

NOT_NULL KEY

 

Unique (to the table) Numeric ID