Default Table Structure

Access this form with Administrative user rights using Organization>Default Table Structure.

Use this form to view all fields in the system. You may want to look in the system to determine all acceptable values for each field.

 

Filters: The filter is for display purposes only; it simply allows you to limit which items are displayed in the Available Items table.

• Available Filter, Selected Filter: Select an item in the Available Filter column, and click the Mover ( > ) to move it to the Selected Filter column. Once an item is in the Selected Filter column, set up its filtering criteria. Then, the table is limited to the data that falls within the designated filter criteria. Your choices for filtering items are: Table Name, Field Name, and Module.
• Compares To: Select an operator from the drop-down list. The operator compares the value in the Selected Filter column with the values in Criteria 1 and Criteria 2 to determine which items are displayed in the Available Items table.
• Criteria 1: Enter a value to compare with the item in the Selected Filter column. When using Like or Not Like, you can use "%" to represent any number of characters.
• Criteria 2: Enter a value for the end of a range if the Compares To column contains the Between or Not Between operators.

Available Items Table: Records are initially sorted on the first data column in ascending order. However, records can be sorted based on any column by clicking on the column heading.

• Records per Page: Select how many items per page to display using the Records per Page drop-down list. You can view items in the table in increments of 10, 25, 50, 100, 250, 500, or 1000. The default setting for the Records per Page drop-down list was selected using the Options>Customize Workstation Settings>Preferences tab.
• Table Name: The table where the field information is stored.
• Field Name: The field name identified by the system. Most of these field names correspond to a field name on a form. All field names begin with common letters that identify a field's function.

Field Identified	Field Type	Example
dtm	date	dtmDocDate
s	string	Description
d	double	dDocID
cur	currency	curAmount
guid	number	guidUserIDf
n	integer	nOrderID
ysn	yes/no	ysnSuta

• Field Description: A description of the designated field. Often the description also contains acceptable values for the field.
• Field Size: This is the default size assigned by the system. Some fields are user defined; therefore, this field size may have changed.
• Module: The system displays the module associated with the designated field. The available modules are as follows (depending on which ones are installed):
  
  

AB	Accounts Receivable Billing
AM	Allocations Management
AP	Accounts Payable
AR	Accounts Receivable Reporting
AS	Advanced Security
BG	Budget
BK	Bank Reconciliation
DD	Direct Deposit
EN	Encumbrances
EP	Electronic Funds Transfer for A/P
FA	Fixed Assets
FD	Forms Designer
GA	Grant Administration
GL	General Ledger
MC	Multicurrency
OE	Order Entry
PO	Purchase Orders
PR	Payroll
RQ	Electronic Requisitions
SY	Administration