Appendix A - WebTMA 7

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

Was this article helpful?
0 out of 0 found this helpful

Articles in this section

2024 Client Training Schedule
See the full list of web training events.