User Defined Fields List

Access this report with Administrative user rights using Reports>Lists>User Defined Fields.

Use this report to obtain a list of user defined fields that have been created. User defined fields were created by the Administrator using the Organization>Set Up User Defined Fields form. You can add data to these fields using the appropriate form in the MIP Accounting system.

Report Criteria

Use this tab to assign a report name and determine whether or not to include it on the actual report. The report name can be printed in the header or the footer of the report.

Use this tab to determine what data to include in the report and to define the report layout.

  • By selecting Available Items, the data is divided onto separate pages. The report starts a new page for each item, and the item is printed in the page header of the report.
  • By selecting Available Columns, the data that appears in the body of the report is determined.

Column

Description

Type

A record type of A/R Invoices, A/R Invoices Detail, Charge Codes, Customers, Employees, {Segment Codes}, Purchase Orders, Transaction Documents, Transaction Lines, or Vendors.

Field Name

The internal field name that is used in the system, such as grantmanager.

Display Name

The name for the user defined field as it appears on the form in the system, such as Grant Manager.

Required

A designation of (Y) Yes or N (No) depending on whether the field is required.

Field Type

A field type of Currency, Date, Editable Drop-Down List, Non-Editable Drop-Down List, Number, String, or Yes/No.

Length

A field length between 1 and 255 if the field type is String, Non-Editable Drop-down List, or Editable Drop-down List.

Number of Decimal Places

The number of decimal places for a Number field type.

Default Text

The default text for String or Editable Drop-Down List field types.

Default Yes/No

The default value for Yes/No field types.

Default Date

The default value for Date field types.

Default Currency

The default value for Currency field types. This value is formatted in the organization's functional currency. The functional currency was determined by the Administrator when the organization was created (File>New Organization>Functional Currency panel).

Default Number

The default value for Number field types.

Shared List Type

The shared list type—A/R Invoices, A/R Invoices Detail, Assets, Charge Codes, Customers, Employees, {Segment Codes}, Purchase Orders, Transaction Documents, Transaction Lines, and Vendors—if the UDF uses one.

Shared List Field Name

All non-editable drop down list field names for the Shared List Type. This field is used in conjunction with the Set Up UDF Default Sources form.

Non-editable Code

The codes available for Non-Editable Drop-Down List field types.

Non-editable Description

The description for the associated code.

Non-editable Default

The default value for the associated code: Yes or No.

Non-editable Status

The status for the associated code: A-Active, I-Inactive, or D-Discontinued.

Transaction Source

The transaction sources associated with a Transaction Document or Transaction Line type user defined field, such as APC, API, APM, APS, ARB, ARC, ARM, ARP, ARS, BD, CD, CDS, CR, CRS, ENC, ENL, or JV.

Field ID

The BO Item ID that is used for Import. It is determined by a combination of the following fields:

{type}:{an internal distinction}:{fieldname}

Date Last Modified

The date and time the field was last changed.

Modified By

The user who modified the field last.

Use this tab to narrow down and more explicitly define the data to include in the report by selecting from the Available Filters.

Use this tab to change the font and page setup for a report.

Use this tab to secure the active report so that other users cannot save their changes to it. The user that selects the check box, and then saves the report, is the only user that can change or save it later. This check box cannot be cleared by any user other than the user that locked the report.