oplist contains 54 columns - click on heading to sort:

Table	Column	Type	Size	Nulls	Auto	Default	Comments
OPLIST_AREA	ACTIVE	int	10
OPLIST_GROUP	ACTIVE	int	10
OPLIST_PRODUCT	ACTIVE	int	10
OPLIST_STAT	ACTIVE	int	10
OPLIST_GROUP	CLIENT	int	10
OPLIST_GROUP	INTERNAL	int	10
OPLIST_AREA	OPARC	int	10
OPLIST_COMMENT	OPCPRIVATE	int	10			0
OPLIST	OPDEADLINE	date	10	√		null	Termin
OPLIST	OPDELETED	int	10			0
OPLIST_FILE	OPLFT	int	10
OPLIST_PRODUCT	OPPRC	int	10
OPLIST	OPPRIO	int	10			0
OPLIST_STAT	OPSRC	int	10
OPLIST_USERS	OPUACTIVE	int	10			0
OPLIST_DEBUG	ERST	timestamp	19			CURRENT_TIMESTAMP
OPLIST	OPAID	bigint	19			4
OPLIST_AREA	OPAID	bigint	19		√
OPLIST_COMMENT	OPCDATE	timestamp	19			CURRENT_TIMESTAMP
OPLIST_COMMENT	OPCID	bigint	19		√
OPLIST	OPDATECREATED	timestamp	19			CURRENT_TIMESTAMP
OPLIST	OPDATEUPDATED	timestamp	19			CURRENT_TIMESTAMP
OPLIST_FILE	OPFID	bigint	19		√
OPLIST_GROUP	OPGID	bigint	19		√
OPLIST_USERS	OPGID	bigint	19			3
OPLIST	OPID	bigint	19		√
OPLIST_COMMENT	OPID	bigint	19
OPLIST	OPPID	bigint	19			4
OPLIST_PRODUCT	OPPID	bigint	19		√
OPLIST	OPSID	bigint	19			0
OPLIST_STAT	OPSID	bigint	19		√
OPLIST_USERS	OPUDATE	timestamp	19			CURRENT_TIMESTAMP
OPLIST_COMMENT	OPUID	bigint	19
OPLIST_USERS	OPUID	bigint	19		√
OPLIST	OPUID_ASSIGNED	bigint	19			0
OPLIST	OPUID_CREATED	bigint	19			0
OPLIST	OPUID_UPDATED	bigint	19			0
OPLIST_VERSION	OPVID	bigint	19
OPLIST_VERSION	OPVVERSION	bigint	19
OPLIST_COMMENT	OPCFILENAME	varchar	20	√		null
OPLIST_GROUP	OPGTEXT	varchar	20
OPLIST_USERS	OPUPASSWORD	varchar	100			pwd
OPLIST_STAT	OPSTEXT	varchar	200
OPLIST_VERSION	OPVDESC	varchar	200
OPLIST_AREA	OPATEXT	varchar	255
OPLIST_PRODUCT	OPPTEXT	varchar	255
OPLIST_USERS	OPUEMAIL	varchar	255	√		null
OPLIST_USERS	OPUFNAME	varchar	255
OPLIST_USERS	OPULNAME	varchar	255
OPLIST_USERS	OPUUSERNAME	varchar	255
OPLIST_COMMENT	OPCTEXT	varchar	4000	√		null
OPLIST	OPDESC	varchar	4000	√		null
OPLIST	OPENTRY	varchar	4000
OPLIST_DEBUG	VALUE	varchar	4000	√		null