Transaction Template Fields Tables

Template Field catalog

When a Transaction Template is saved, STEPforward stores the list of fields used by the Template in the system catalog table named SF_SYSTXTemplateFields of the following structure:

Column Generalized data type Use
SF_TemplateName VARCHAR(8) Name of the base Template
SF_CloneName VARCHAR(8) Name of the Template clone
SF_Type CHAR(1) Template type (Base or Clone)
SF_IdNumber SMALLINT Id number of the field
SF_UserName VARCHAR(30) User name of the field
SF_Action TINYINT Run-time action of the field
SF_Mandatory LOGICAL Flag to track mandatory data input in the field
SF_DataPrecision TINYINT Number of decimal places for numeric field
SF_ValueList SMALLINT Id number of the Value List attached to the field
SF_ContextHelp BLOB RTF-based text of the context-sensitive help for the field
SF_TimeStamp SMALLINT Version of the row (incremented with each update)

See notes to SF_SYSMasterTemplateFields table for detailed description of the columns.

General Field catalog

Every data field used in the Transaction Templates is recorded in the system catalog table named SF_SYSTXInputFields of the following structure:

Column Generalized data type Use
SF_SystemName VARCHAR(30) System name of the field
SF_UserName VARCHAR(30) User name of the field
SF_DataType TINYINT Type of data the field stores
SF_Width SMALLINT Size of the field (max number of characters)
SF_IdNumber SMALLINT Id number of the field
SF_InvisibleInk LOGICAL Invisible ink flag
SF_Encrypted LOGICAL Encryption flag
SF_TimeStamp SMALLINT Version of the row (incremented with each update)

Notes:

The table contains one row for each Transaction data field used by STEPforward.

SF_InvisibleInk is the logical flag that prevents the field from displaying its contents when the flag is set to TRUE (the field shows asterisks instead of the original text).

SF_Encrypted is the logical flag that causes STEPforward to encrypt the contents of the field before saving it in the database table.

Refer to the notes to SF_SYSMasterInputFields table for info on the other columns in SF_SYSTXInputFields table.