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.