Path: Accounting > Universal Financial > Segment
In WebTMA, you can add as many as nine account number segments plus a tenth Full Accounting Unit (FAU) statement. Even though your financial package uses segments with a specific length, you can choose not to use the entire length in UFI. While UFI must be configured to accept from three to nine segments, you have the flexibility to populate only one segment if the Variable Count check box is marked. If variable segments are allowed, the first segment is not necessarily required; the only requirement is that at least one segment is populated.
The Length field in WebTMA Table definitions is the length of data that must be entered in the related fields (in the WebTMA application) and is probably different from the maximum length specified by your financial application provider.
When data is entered in WebTMA, the system looks for the number of segments (Segment Count) and the number of characters (Max Length) specified in the UFI Segment Entry window. WebTMA supports both Variable Length segments and a Variable Number of segments. If you use the Banner accounting package, WebTMA also supports an account index.
The Validation SQL is an SQL statement that you provide. It comes from the outside financial application. Each segment has its own statement.
The order of the segments themselves is very important and does not vary.
The SQL statement should contain aliases called TMA_CHART_SEG and TMA_CHART_SEG_NAME, which represent the segment value and segment name to be validated. If the statement executes and returns a row, the statement is considered valid.
The popup entry window includes a Test SQL button to test the statement. Note: This only tests whether the SQL is valid and executes. It does not indicate whether the results, if any, are correct.
How to Define UFI Segments
Path: Accounting > Universal Financial > Segment
The following instructions are repeated for each Segment line on the window. WebTMA can accommodate as many as nine Segments.
- Click the Edit on the WebTMA toolbar.
- Type the Segment Count. This represents the number of segments you plan to use, and the grid reflects the number of lines plus a total.
- Type a Segment Separator in the next field. This is the character used to separate each segment such as a hyphen ( - ) or a semicolon ( ; ).
- Click the Edit (pencil) icon on the first line to open the popup UFI Segment Entry.
- Replace the Segment Name with a description of the segment (maximum of 25 characters).
- (Optional) Enter the Max Length of the identified segment including spaces.
- Type the Validation Statement used to validate account data for your outside financial application accounts.
- (Optional) Click the Test button on the popup to test the statement validity.
- Click the Save button on the window to save the changes.
- Click Save on the WebTMA toolbar.
Note: By default, there is one more line than the number in the Segment Count field. Once the record is saved, the last line item defaults to Full Accounting Unit. The Validation Segment field on this line should be completed to validate the combination of all segments. This is used to be sure the combination of all segments also passes. The FAU statement checks that either the data can be assembled or that the whole account is still valid.