1What you can do here #
- Create Schema (F3): opens the designer in a dialog to define a brand-new table (name, columns, keys, lookups). Saving runs the live CREATE on the database.
- View Schema (F2): opens the selected table in the designer to inspect or Modify its definition. (Double-clicking a row does the same.)
- Data Entry (F6): opens the selected table's record form in a dialog, ready in Add mode so you can key the first record immediately.
- Delete: removes the selected table — see the warning below.
- Refresh: reloads the list.
2Step by step #
The browser answers 'what has been captured?' for any custom table.
- Pick the custom table to browse; its captured rows list out with the defined columns.
- Filter, correct or export as the page offers.
3The Designer (Create / View) #
- Header: Table Name (fixed after create), Display Name, Description, and optional Applicable To linkage to a Master / General Transaction.
- Fields: each column's data type, length, primary-key flag, nullability, identity (seed/increment), display order, prompt label, and an optional Lookup SQL that turns the field into a searchable dropdown on the data-entry form.
- Keys: in the designer — F3 Add, F4 Modify, F5 Save, Esc Cancel/Close; Enter/Tab move between fields and add field rows.
4The Data Entry screen #
A record-at-a-time form whose controls are chosen automatically (lookup combo, switch, date picker, number box, multiline, or text; identity/computed are read-only).
- Find (F2) load an existing row · Add (F3) new row · Modify (F4) edit · Save (F5) (then focus parks on Add) · Delete · Cancel/Close (Esc) .
- Opened from here it starts in Add so you can begin entering straight away.
- A table without a primary key can add rows but not edit/delete them in place.
5If something does not work #
A table you defined is not listed
- Why
- The browser lists active custom tables your login may read.
- What to do
- Check the table is active, and that you have the right on it.
A column shows nothing, or shows raw values
- Why
- The browser shows what is stored; a column added after the rows were written is empty on those rows.
- What to do
- Fill the new column, or ignore it on old rows.
This is the help InvoiceNET® ERP shows beside the Custom Table Browser screen. Whether you have the screen depends on the modules of your licence and the rights your administrator has given you.
See this screen for yourself
The demo is the real product, with a company of your own.