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 | ![]() | 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.