Example – finding the field names for the supplier details.
Navigate to the Accounts Payable module.
Add the following text to the end of the URL
&helpmode=prompt
Select 'Toggle Help' from the User Drop Down Menu
Run the Supplier Enquiry
The field name in () should point you to the correct table in the database enquiry.
Each table has a three letter Table ID displayed on the right hand column of the Database Enquiry, e.g. avm, this is also the prefix of the field names within to the table.
The next step is to find the table from the Database Enquiry Screen
Navigate to Database Enquiry.
Using the filters at the top of the screen, search for the tables three characters (e.g. avm) in the ID field
Follow the link to view the available fields within that table.
Example:
In order to produce a Accounts Payable Supplier Listing Report you may need to know the field names for:
Account Number
Name
Address
Postcode
Telephone Number
Contact
Note: Supplier address has four lines and this is indicated in the database enquiry by an array number enclosed in square brackets at the end of the supplier address field. So to include only lines 1 and 2 of a supplier address the fields selected within a report would be avm_add__1 and avm_add__2.
The first two characters of the table name reference the module, for example, ap indicates Accounts Payable/Accounts Payable.