You are here: Field Rules Reference > Field Rules Summary

Field Rules Summary

The following pages list and explain the various field rules you can use. The rules are discussed in alphabetical order on the pages following this table.

You can also see information about the field rules while using Studio when you select the rule on the field’s Properties window:

Field options

The following table lists the rules discussed in this section.

To…	Use this rule	AFGJOB	Section	Files	INI	Overflow	XML
Add a placeholder which causes no operation to occur (used in testing)	NoOpFunc	no	no	no	no	na	no
Add a variable from more than one occurrence of a particular record type	AccumulateVariableTotal	no	no	no	no	na	no
Add two or more fields and insert the result into a new field	MoveSum	no	no	yes	yes	na	yes
Call a DAL function	If	no	no	yes	yes	no	no
Concatenate strings and place the result in the field you specify	ConCat	no	no	no	no	yes	no
Copy alphanumeric data from a table using the source record field as a key	TblLkUp	no	no	yes	yes	yes	no
Copy and format numeric data in an extract record	MoveNum	no	no	no	no	yes	yes
Copy data from an external record into the output buffer	Move_It	no	no	no	no	yes	yes
Copy data from an SAP Raw Data Interface (RDI) extract file	SAPMove_It	no	no	yes	no	yes	yes
Copy data from the table list of records into the output buffer	MovTbl	no	no	no	yes	na	no
Copy data if a source record exists	MoveExt	no	no	yes	no	yes	no
Count the total number of overflow records that could be processed per transaction	OvPrint	no	yes	no	no	yes	no
Create lists of data for populating section lists or columns	BldGrpList	yes	no	no	no	na	no
Display the difference between two dates	DateDiff	no	no	no	no	na	no
Draw an underline beneath a variable field	UnderlineField	no	yes	no	no	yes	no
Emulate TerSub entry functionality	TerSubstitute	no	no	no	no	yes	no
Execute the MoveNum rule if an external record is found	MNumExt	no	no	yes	no	yes	no
Force a transaction to manual batch (WIP)	KickToWip	no	no	no	yes	na	yes
Force a transaction to manual batch (WIP)	PowType	no	no	no	yes	na	no
Format a date	* DateFmt	no	no	yes	no	yes	no
Format a date (for international localities)	FmtDate	no	no	no	no	yes	yes
Format a number	FmtNum	no	no	no	no	yes	yes
Format a time (for international localities)	FmtTime	no	no	no	no	yes	yes
Format the system date	SysDate	no	no	no	no	yes	no
Get a text table item based on a key from the source field name concatenated with data retrieved from the source record	TblText	yes	no	yes	yes	yes	yes
Get data from an extract record, look up the data in a table, and copy the table data to the destination field	LookUp	yes	no	yes	yes	na	no
Get information from an extract file based on conditions you specify	DAL	no	no	yes	yes	yes	yes
Get information from an extract file based on conditions you specify	If	no	no	yes	yes	no	no
Get the current system date	FfSysDte	no	no	no	no	yes	no
Get the run date from the TRNFILE.DAT file and format it using the mask you specify	RunDate	no	no	yes	no	na	no
Have the system format the data when it maps it to a field	AnyToAny	no	no	no	no	na	no
Insert a specific value	Mk_Hard	no	no	no	no	na	no
Insert a value in a field only if a record is found in the extract data using the search criteria you specify	HardExst	no	no	no	no	yes	no
Justify a field (right, left, or center)	JustFld	no	no	no	yes	yes	yes
Map fields in the XDB database	* XDB	no	no	yes	no	na	no
Map fields in the XDD database	XDD	no	no	yes	yes	na	yes
Print information in a field if the data matches the numeric value you specify	PrtIfNum	no	no	yes	no	na	no
Print information in a field if the data matches the string you specify	PrintIf	no	no	yes	no	yes	no
Process multipage sections	* EjectPage	no	no	no	no	na	no
Replace the NoOpFunc rule	MapFromImportData	no	no	no	yes	na	no
Report the actual number of overflow records that could be processed per transaction	OvActPrint	no	no	no	no	yes	no
Retrieve a message from an extract file	MessageFromExtr	no	no	yes	yes	yes	no
Retrieve and format a string	LookUp	no	no	yes	no	yes	no
Select the largest value of multiple packed decimal fields located on the same record to populate a variable field	CompBin	no	no	no	no	na	no
Speed the processing of fields used repeatedly throughout a form set	GlobalFld	no	no	yes	no	na	no
Store and retrieve subsequent lines of a multiple line address	SetAddr	no	no	no	no	yes	no
Store and retrieve subsequent lines of a multiple line address and also format the city, state, and 10-digit postal code	SetAddr2	no	no	no	no	yes	no
Store and retrieve subsequent lines of a multiple line address and combine address lines two and three	SetAddr3	no	no	no	no	yes	no
Tell the system the field has been mapped to the master DDT file	Master	no	no	yes	no	na	no
Translate a numeric ISO state code into the actual state name	SetState	no	no	yes	no	yes	no
* - Indicates this is a legacy rule that may be found in older implementations. AFGJOB - Indicates if there are AFGJOB.JDT file implications to this rule. Section - Indicates if this rule depends on a section rule. Files - Indicates if external supporting files (other than extract records) can be used with this rule. INI - Indicates if there are INI options associated with this rule.Overflow - Indicates if this rule supports overflow. XML - Indicates if this rule accepts XML input.

Open table of contents