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
TemplateName VARCHAR(8) Name of the base Template
CloneName VARCHAR(8) Name of the Template clone
Type CHAR(1) Template type (Base or Clone)
IdNumber SMALLINT Id number of the field
UserName VARCHAR(30) User name of the field
Action TINYINT Run-time action of the field
Mandatory LOGICAL Flag to track mandatory data input in the field
DataPrecision TINYINT Number of decimal places for numeric field
ValueList SMALLINT Id number of the Value List attached to 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
SystemName VARCHAR(30) System name of the field
UserName VARCHAR(30) User name of the field
SF_DataType TINYINT Type of data the field stores
Width SMALLINT Size of the field (max number of characters)
IdNumber SMALLINT Id number of the field
InvisibleInk LOGICAL Invisible ink flag
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.

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).

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.