Appendix A - WebTMA 7

Updated March 08, 2023 22:16

The following define the available selections for the UFI Template Setup. Except where indicated, these are available for both the Header Column Section and the Line Column Section.

You will also see your own segment names as selections.

Available UFI Template Setup Selections

Selection	Definition
[Account Segments]	The named account segments you defined on the Segment window.
Budget Code	Available for Line Item Section only. Complex field based on transaction type. The code is captured during the posting process. See Budget Codes topic below for an explanation of how the contents are derived.
Constant	Add values of your choosing that are seen in the Default column and exported at posting.
Debit/Credit	Indicates whether the amount is a Debit or a Credit. If the Debit / Credit flag is not included in the template, then any credit amounts are multiplied by -1. If the Debit / Credit flag is used and either a D or C is set as the flag, then Credit will be given a C and Debits will be given a D. If the Debit / Credit flag is used and + is given as the flag, then Credits will be given a – and debits will be given a +. If the Debit / Credit flag is used and – is given as the flag, then Credits will be given a – and debits will not be given a flag. If the Value column contains a vertical bar (\|) in the Debit / Credit row, then UFI interprets everything before the bar as the flag for Debits and everything after the bar as the flag for Credits.
Document Code	This is only available when Banner is the selected Financial Application. It pulls a new value from the UFI counter table.
Fiscal Year Posted	The Fiscal year for which the amount is posted.
Full Accounting Unit	This represents the entire WebTMA account code including separators.
Journal Date	This corresponds to the time stamp made when the post charges batch job is executed.
Journal ID	The Code from the UFI Template window.
Journal Line #	Available for Line Item Subtab only. This is a literal line count for every non-header line template export.
Ledger Group	Contents of the Ledger Group field from the UFI Template, i.e., up to 10 alphanumeric characters to name the group associated with this Template. Note: Banner calls this field the Rule Class Code.
Line Item Description	Complex field based on transaction type. See Line Items list below.
Line Item Ext Descript.	Complex field based on transaction type. See Line Items list below.
Line Item Main Transaction Description	Select this column to show the contents of the Request field from Work Order transactions. For other transaction types, the field displays the transaction number.
Line Item Type	Complex field based on transaction type. See the list in Line Items topic below.
Posted Date	The date the transactions were posted to the General Ledger.
Rule Class Code	Used only by Banner, this is identical to the Ledger Group column.
System Date	This includes both date and time. See UFI Template Setup for the hierarchy used to determine the time zone value.
Total Amount	This is the sum of Credit and Debit amounts. For example: WO# Credit = $100, Debit = $100, Total Amount = $200
Trans Amount	Header: The total amount of currency exchanged for a given line item. This is the sum of the absolute values (i.e., a negative 50 and a positive 50 equals 100.) Line Item: The amount of the individual transaction. Trans Amount supports an Absolute Value function. To enable the Absolute Value, the Value column of the Trans Amount row needs to contain a minus ( - ) character. When UFI exports data using this feature, any negative numbers return the Absolute Value and the Debit/Credit flag is switched. For example, a Debit of -1200.00 becomes a Credit of 1200.00.
Trans Date	Date of Transaction
Trans Description	Only used with Work Order transactions to give the action requested.
Trans Fiscal Year	Fiscal Year in which the transaction occurred.
Trans Number	ID # of the Transaction.
Trans Type	Transaction Code (WO, SO, VT, FLT, UMETER, FT, VR, CAP)

Budget Codes

The Budget Codes captured during the posting process are derived in the following ways:

Work Order

Debit – Work Order Type Budget Code
Credit –

Labor – Technician Budget Code
Part – Part Type Budget Code
Other – Other Charge Type Budget Code
Contractor – Task Type Budget Code

Sales Order

Debit – Sales Order Type Budget Code
Credit – Part Type Budget Code (if inventory)

or
Sales Line Type Budget Code (if one-time sale)

Fuel & Oil

Debit – Fuel & Oil record Budget Code
Credit – Fuel & Oil record Budget Code (same as debit)

Rental

Debit – Rental record Budget Code
Credit – Rental record Budget Code (same as Debit)

Expense Ticket

Debit – Expense Ticket record Budget Code
Credit – Expense Ticket record Budget Code (same as Debit)

Utility Ticket

Debit – Utility Meter record Budget Code
Credit – Utility Meter record Budget Code (same as Debit)

Part Transfer

Debit – Part Transfer header Budget Code
Credit – Part Type Budget Code

Project Requisition

Debit – Requisition Budget Code
Credit – Requisition Budget Code (same as Debit)

Journal Entry

Debit – Journal record Budget Code
Credit – Journal record Budget Code (same as Debit)

Line Items

The following table shows the possible values displayed for the Line Item Type, Line Item Description, and Line Item Ext Description.

Line Item Type	Line Item Description	Line Item Ext Description
Work Order Charge	Work Order Charge	Work Order Charge
Labor Credit	[Trade Description]	[Technician Name]
Part Credit	[Part Description]	[SKU]
Other Credit	[Item Description]	[Item Code]
Contractor Credit	[Contractor Name]	[Contract #]
Sales Order Charge	Sales Order Charge	Sales Order Charge
Sales Order Credit	[Sales Line Description]	[Sales Line Code]
Fuel Ticket Charge	Fuel Ticket Charge	Fuel Ticket Charge
Fuel Ticket Credit	[Vehicle Description]	[Vehicle Tag #]
Rental Charge	Rental Charge	Rental Charge
Rental Credit	[Item Description]	[Item Code]
Expense Ticket Charge	Expense Ticket Charge	Expense Ticket Charge
Expense Ticket Credit	[Expense Description]	[Expense Code]
Utility Ticket Charge	Utility Ticket Charge	Utility Ticket Charge
Utility Ticket Credit	[Meter Description]	[Meter Code]
Part Transfer Charge	Part Transfer Charge	Part Transfer Charge
Part Transfer Credit	[Part Description]	[Part Code]
Project Req Charge	Project Req Charge	Project Req Charge
Project Req Credit	[Req Line Description]	[Req Line Description]
Journal Entry Charge	Journal Entry Charge	Journal Entry Charge
Journal Entry Credit	Journal Entry Credit	Journal Entry Credit

Want to Know More?

Visit the WebTMA Help Page

Budget Codes

Line Items

Want to Know More?

Articles in this section