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.