Vantive Dictionary Tables

TableName

Description

SW_ACTION Inbox Table
SW_ACTION_LOG Inbox Table
SW_ALARM Alarms to trigger
SW_ATTACHMENT Attachments
SW_AUDIT_TRAIL Audit of columns
SW_BASIC_FUNCTION VBA Functions
SW_BASIC_PCODE Complied code
SW_BASIC_SCRIPT VBA Scripts
SW_BINARY_DATA Table to hold ActiveX controls
SW_DERIVED Derived Expression information
SW_DISPATCH_RULE Dispatch Rules
SW_DISPTCH_VIEW View on SW_RULE to segment dispatch rules
SW_EVENT_ENUM List of Events based on availability in different objects (main info, inbox..)
SW_FIELD_EVENT Form Field events
SW_FIELD_PROPS Field properties (especially nested form, Acitve X etc..)
SW_FIND_FOR_KEY Find foreign key information
SW_FORM_FIELD Embedded forms Info in a main form (child forms)
SW_GROUP_EVENT Events at group level
SW_INBOX List of inboxes defined in tools
SW_INBOX_EVENT Inbox events
SW_INBOX_PRIV Privileges for users of inbox
SW_NOTIFICATION Notification Rules
SW_NOTIFY_VIEW View on SW_RULE to segment notification rules
SW_OBJ_PRIV Group access privileges for objects
SW_OBJ_PRIV_EVENT File New, File open object events
SW_OCX_RESOURCE Available ocx
SW_OCX_USAGE Usage of ocx on group level
SW_PAGE Page(tabs) Information
SW_PRIMARY_KEYS Primary key information which is manually inserted using SQL interface
SW_PROGRAM_TYPE_EN List of program types (CB, DB Proc, Server Scripts w/wo wait)
SW_REPORT Reports
SW_REPORT_PRIV Reports allowed in that group
SW_RULE Dispatch and Notification Rules
SW_SCREEN Form Information
SW_SCREEN_EVENT Form events
SW_SCREEN_FIELD Form field Information
SW_SCREEN_FUNCTION Form Level Utility functions
SW_SCREEN_POPUP Popup forms
SW_SCREEN_PROPS !Not used
SW_SCREEN_RIBBON Ribbon button functions
SW_SCREEN_SEARCH Search Objects Information
SW_SCREEN_TO_USE Forms assigned to groups
SW_SCREEN_TYPES Screen Types as identified in System
SW_SEARCH_GROUP Search Group Information
SW_SWB_COLUMN_ATTR Vantive Column definition (as done in VanTools)
SW_SWB_DEF_OBJECT Child tables
SW_SWB_DISP_CLASS Display Class Entries
SW_SWB_OBJ_UTILITY Object Utility Events
SW_SWB_OBJECT_TYPE Object
SW_SWB_RESOURCE  
SW_SWB_SCREEN_LOCK Screen lock information
SW_SWB_SCREEN_TYPE Types of screens
SW_SWB_TABLE Vantive Table definition
SW_SWB_USERS Developer accounts (at tools db)
SW_USER User list
SW_USER_EVENT Events at user level 
SW_USER_FUNCTION User defined function(retained for upgrade compatibility)
SW_VAL_ACT_PRI Valid Action Priority List
SW_VAL_PRIV_GRP Group Information
SW_VALID_ACTION Valid Action Codes
SW_VALID_CODE Code Sets
SW_WORK_LOG Notes

Back to vantive home